DBA Data[Home] [Help] [Dependency Information]

TABLE: ZX.ZX_REC_NREC_DIST

Object Details
Object Name: ZX_REC_NREC_DIST
Object Type: TABLE
Owner: ZX
FND Design Data: TableZX.ZX_REC_NREC_DIST
Subobject Name:
Status: VALID

Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
ZX_REC_NREC_DIST_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnREC_NREC_TAX_DIST_ID
ZX_REC_NREC_DIST_U2 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnTAX_LINE_ID
ColumnTRX_LINE_DIST_ID
ColumnREC_NREC_TAX_DIST_NUMBER
ZX_REC_NREC_DIST_U3 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnAPPLICATION_ID
ColumnENTITY_CODE
ColumnEVENT_CLASS_CODE
ColumnTRX_ID
ColumnTAX_LINE_NUMBER
ColumnTRX_LINE_DIST_ID
ColumnREC_NREC_TAX_DIST_NUMBER
ZX_REC_NREC_DIST_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnTRX_LINE_ID
ColumnREVERSE_FLAG
ZX_REC_NREC_DIST_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnREVERSED_TAX_DIST_ID
ColumnREVERSE_FLAG
Columns
Name Datatype Length Mandatory Comments
REC_NREC_TAX_DIST_ID NUMBER (15) Yes Unique identifier
APPLICATION_ID NUMBER
Yes Application identifier for this tax distribution
ENTITY_CODE VARCHAR2 (30) Yes Entity code for this tax distribution
EVENT_CLASS_CODE VARCHAR2 (30) Yes Event class code for this tax distribution
EVENT_TYPE_CODE VARCHAR2 (30) Yes Event type code for this tax distribution
TAX_EVENT_CLASS_CODE VARCHAR2 (30)
Tax event class code of this tax distribution
TAX_EVENT_TYPE_CODE VARCHAR2 (30)
Tax event type code of this tax distribution
TRX_ID NUMBER
Yes Transaction identifier for this tax distribution
TRX_LINE_ID NUMBER
Yes Transaction line identifier for this tax distribution
TRX_LINE_NUMBER NUMBER

Transaction line number for this tax distribution
TAX_LINE_ID NUMBER (15) Yes Tax line identifier for this tax distribution
TAX_LINE_NUMBER NUMBER
Yes Tax line number for this tax distribution
TRX_LINE_DIST_ID NUMBER
Yes Item distribution identifier for this tax distribution
ITEM_DIST_NUMBER NUMBER

Item distribution number for this tax distribution
CONTENT_OWNER_ID NUMBER (15)
Party tax profile identifier for the first party organization of the transaction
REC_NREC_TAX_DIST_NUMBER NUMBER
Yes Line number generated for this tax distribution
TAX_REGIME_ID NUMBER (15)
Tax regime identifier
TAX_REGIME_CODE VARCHAR2 (30)
Tax regime code
TAX_ID NUMBER (15)
Tax identifier
TAX VARCHAR2 (30)
Tax
TAX_STATUS_ID NUMBER (15)
Tax status identifier
TAX_STATUS_CODE VARCHAR2 (30)
Tax status code
TAX_RATE_ID NUMBER (15)
Tax rate identifier
TAX_RATE_CODE VARCHAR2 (150)
Tax rate code
TAX_RATE NUMBER

Tax rate
INCLUSIVE_FLAG VARCHAR2 (1)
Y on N indicates if this tax distribution amount is included in transaction line amount.
RECOVERY_TYPE_ID NUMBER (15)
Recovery type Identifier
RECOVERY_TYPE_CODE VARCHAR2 (30)
Recovery type code
RECOVERY_RATE_ID NUMBER (15)
Recovery rate identifier
RECOVERY_RATE_CODE VARCHAR2 (150)
Recovery rate code
REC_NREC_RATE NUMBER
Yes Tax distribution rate used for determining the distribution amount
REC_TYPE_RULE_FLAG VARCHAR2 (1)
Y or N indicates whether rules are used for recovery type determination
NEW_REC_RATE_CODE_FLAG VARCHAR2 (1)
Y or N indicates if the recovery rate code is new
RECOVERABLE_FLAG VARCHAR2 (1) Yes Y or N indicates whether this tax distribution is recoverable or non-recoverable
REVERSE_FLAG VARCHAR2 (1)
Y or N indicates that this tax distribution either reverses another tax distribution or is reversed by another tax distribution
HISTORICAL_FLAG VARCHAR2 (1)
Y or N indicates whether this tax distribution is migrated from prior releases
REVERSED_TAX_DIST_ID NUMBER

Identifier of tax distribution that is reversed by this tax distribution
REC_NREC_TAX_AMT NUMBER
Yes Tax distribution amount in transaction currency
REC_NREC_TAX_AMT_TAX_CURR NUMBER

Tax distribution amount in tax currency
REC_NREC_TAX_AMT_FUNCL_CURR NUMBER

Tax distribution amount in functional currency
INTENDED_USE VARCHAR2 (30)
Fiscal classification code that indicates the purpose for which the product of this tax distribution is used
PROJECT_ID NUMBER

Identifier for project used to build Accounting Flexfield for project-related item distribution line
TASK_ID NUMBER

Identifier for project task used to build Accounting Flexfield for project-related item distribution line
AWARD_ID NUMBER

Reserved for use by Oracle Grants Management
EXPENDITURE_TYPE VARCHAR2 (30)
Project expenditure type used to build Accounting Flexfield for project-related item distribution line
EXPENDITURE_ORGANIZATION_ID NUMBER

Identifier for project organization used to build Accounting Flexfield for project-related item distribution line
EXPENDITURE_ITEM_DATE DATE

Date for project expenditure item used to build Accounting Flexfield for project-related item distribution line
REC_RATE_DET_RULE_FLAG VARCHAR2 (1)
Y or N indicates if rules are used for recovery rate determination
LEDGER_ID NUMBER (15)
Ledger defining column
SUMMARY_TAX_LINE_ID NUMBER (15)
Summary tax line identifier corresponding to this tax distribution
RECORD_TYPE_CODE VARCHAR2 (30)
Lookup code to indicate whether the record is migrated, seeded or defined by the user
CURRENCY_CONVERSION_DATE DATE

Date of the exchange rate for transaction currency to functional currency conversion
CURRENCY_CONVERSION_TYPE VARCHAR2 (30)
Exchange rate type for transaction currency to functional currency conversion
CURRENCY_CONVERSION_RATE NUMBER

Exchange rate for transaction currency to functional currency conversion
TAX_CURRENCY_CONVERSION_DATE DATE

Date of the exchange rate for transaction currency to tax currency conversion
TAX_CURRENCY_CONVERSION_TYPE VARCHAR2 (30)
Exchange rate type for transaction currency to tax currency conversion
TAX_CURRENCY_CONVERSION_RATE NUMBER

Exchange rate for transaction currency to tax currency conversion
TRX_CURRENCY_CODE VARCHAR2 (15)
Transaction currency code
TAX_CURRENCY_CODE VARCHAR2 (15)
Tax currency code
TRX_LINE_DIST_AMT NUMBER

Item distribution line amount
TRX_LINE_DIST_TAX_AMT NUMBER

Tax amount pertaining to the current item distribution in transaction currency
ORIG_REC_NREC_RATE NUMBER

Tax distribution rate prior to user override
ORIG_REC_RATE_CODE VARCHAR2 (150)
Tax distribution rate code prior to user override
ORIG_REC_NREC_TAX_AMT NUMBER

Tax distribution amount prior to user override
ORIG_REC_NREC_TAX_AMT_TAX_CURR NUMBER

Tax distribution amount in tax currency prior to user override
UNROUNDED_REC_NREC_TAX_AMT NUMBER

Tax distribution amount in transaction currency before rounding
APPLICABILITY_RESULT_ID NUMBER (15)
Column to record identifier of the process result obtained from tax recovery type applicability process for this tax distribution
REC_RATE_RESULT_ID NUMBER (15)
Column to record identifier of the process result obtained from tax recovery rate determination process for this tax distribution
BACKWARD_COMPATIBILITY_FLAG VARCHAR2 (1)
Y or N indicates if the recovery rate is derived from the default recovery rate defined for tax rate code
OVERRIDDEN_FLAG VARCHAR2 (1)
Y or N indicates whether user has overridden this tax distribution
SELF_ASSESSED_FLAG VARCHAR2 (1)
Y or N indicates whether this is distribution is for a self-assessed tax
FREEZE_FLAG VARCHAR2 (1)
Y or N indicates if this tax distribution is frozen
POSTING_FLAG VARCHAR2 (1)
Y or N indicates if this tax distribution is posted to General Ledger
ATTRIBUTE_CATEGORY VARCHAR2 (150)
Descriptive flexfield structure defining column
ATTRIBUTE1 VARCHAR2 (150)
Descriptive flexfield segment column
ATTRIBUTE2 VARCHAR2 (150)
Descriptive flexfield segment column
ATTRIBUTE3 VARCHAR2 (150)
Descriptive flexfield segment column
ATTRIBUTE4 VARCHAR2 (150)
Descriptive flexfield segment column
ATTRIBUTE5 VARCHAR2 (150)
Descriptive flexfield segment column
ATTRIBUTE6 VARCHAR2 (150)
Descriptive flexfield segment column
ATTRIBUTE7 VARCHAR2 (150)
Descriptive flexfield segment column
ATTRIBUTE8 VARCHAR2 (150)
Descriptive flexfield segment column
ATTRIBUTE9 VARCHAR2 (150)
Descriptive flexfield segment column
ATTRIBUTE10 VARCHAR2 (150)
Descriptive flexfield segment column
ATTRIBUTE11 VARCHAR2 (150)
Descriptive flexfield segment column
ATTRIBUTE12 VARCHAR2 (150)
Descriptive flexfield segment column
ATTRIBUTE13 VARCHAR2 (150)
Descriptive flexfield segment column
ATTRIBUTE14 VARCHAR2 (150)
Descriptive flexfield segment column
ATTRIBUTE15 VARCHAR2 (150)
Descriptive flexfield segment column
GLOBAL_ATTRIBUTE_CATEGORY VARCHAR2 (150)
Reserved for country specific localizations
GLOBAL_ATTRIBUTE1 VARCHAR2 (150)
Reserved for country specific localizations
GLOBAL_ATTRIBUTE2 VARCHAR2 (150)
Reserved for country specific localizations
GLOBAL_ATTRIBUTE3 VARCHAR2 (150)
Reserved for country specific localizations
GLOBAL_ATTRIBUTE4 VARCHAR2 (150)
Reserved for country specific localizations
GLOBAL_ATTRIBUTE5 VARCHAR2 (150)
Reserved for country specific localizations
GLOBAL_ATTRIBUTE6 VARCHAR2 (150)
Reserved for country specific localizations
GLOBAL_ATTRIBUTE7 VARCHAR2 (150)
Reserved for country specific localizations
GLOBAL_ATTRIBUTE8 VARCHAR2 (150)
Reserved for country specific localizations
GLOBAL_ATTRIBUTE9 VARCHAR2 (150)
Reserved for country specific localizations
GLOBAL_ATTRIBUTE10 VARCHAR2 (150)
Reserved for country specific localizations
GLOBAL_ATTRIBUTE11 VARCHAR2 (150)
Reserved for country specific localizations
GLOBAL_ATTRIBUTE12 VARCHAR2 (150)
Reserved for country specific localizations
GLOBAL_ATTRIBUTE13 VARCHAR2 (150)
Reserved for country specific localizations
GLOBAL_ATTRIBUTE14 VARCHAR2 (150)
Reserved for country specific localizations
GLOBAL_ATTRIBUTE15 VARCHAR2 (150)
Reserved for country specific localizations
GL_DATE DATE

Accounting Date
CREATED_BY NUMBER (15) Yes Standard Who column
CREATION_DATE DATE
Yes Standard Who column
LAST_UPDATED_BY NUMBER (15) Yes Standard Who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column
LAST_UPDATE_DATE DATE
Yes Standard Who column
REF_DOC_APPLICATION_ID NUMBER

Reference document application identifier
REF_DOC_ENTITY_CODE VARCHAR2 (30)
Reference document entity code
REF_DOC_EVENT_CLASS_CODE VARCHAR2 (30)
Reference document event class code
REF_DOC_TRX_ID NUMBER

Reference document transaction identifier
REF_DOC_LINE_ID NUMBER

Reference document transaction line identifier
REF_DOC_DIST_ID NUMBER

Reference document item distribution identifier
MINIMUM_ACCOUNTABLE_UNIT NUMBER

Minimum accountable unit
PRECISION NUMBER

Precision
ROUNDING_RULE_CODE VARCHAR2 (30)
Rounding Rule for the tax of this distribution
TAXABLE_AMT NUMBER

Taxable amount on this tax distribution
TAXABLE_AMT_TAX_CURR NUMBER

Taxable amount on this tax distribution in tax currency
TAXABLE_AMT_FUNCL_CURR NUMBER

Taxable amount on this tax distribution in funcitonal currency
TAX_ONLY_LINE_FLAG VARCHAR2 (1)
Y or N indicates whether this tax distribution is for a tax only line
UNROUNDED_TAXABLE_AMT NUMBER

Unrounded taxable amount on this tax distribution
LEGAL_ENTITY_ID NUMBER

Legal entity identifier for the transaction
ACCOUNT_CCID NUMBER

Account identifier associated with the item distribution line
ACCOUNT_STRING VARCHAR2 (2000)
Account string associated with the item distribution line
PRD_TAX_AMT NUMBER

Prorated tax amount
PRD_TAX_AMT_TAX_CURR NUMBER

Prorated tax amount in tax currency
PRD_TAX_AMT_FUNCL_CURR NUMBER

Prorated tax amount in functional currency
PRD_TOTAL_TAX_AMT NUMBER

Prorated total tax amount
PRD_TOTAL_TAX_AMT_TAX_CURR NUMBER

Prorated total tax amount in tax currency
PRD_TOTAL_TAX_AMT_FUNCL_CURR NUMBER

Prorated total tax amount in functional currency
APPLIED_FROM_TAX_DIST_ID NUMBER

Applied from document tax distribution identifier
ADJUSTED_DOC_TAX_DIST_ID NUMBER

Adjusted document tax distribution identifier
FUNC_CURR_ROUNDING_ADJUSTMENT NUMBER

Functional currency rounding adjustment
GLOBAL_ATTRIBUTE16 VARCHAR2 (150)
Reserved for country specific localizations
GLOBAL_ATTRIBUTE17 VARCHAR2 (150)
Reserved for country specific localizations
GLOBAL_ATTRIBUTE18 VARCHAR2 (150)
Reserved for country specific localizations
GLOBAL_ATTRIBUTE19 VARCHAR2 (150)
Reserved for country specific localizations
GLOBAL_ATTRIBUTE20 VARCHAR2 (150)
Reserved for country specific localizations
LAST_MANUAL_ENTRY VARCHAR2 (30)
Column to indicate which column is last overridden by the user
TAX_APPORTIONMENT_LINE_NUMBER NUMBER

Apportionment line number for the tax line of this tax distribution when multiple tax lines are created for the same tax during migration from prior releases
REF_DOC_TAX_DIST_ID NUMBER

Reference document tax distribution identifier
MRC_TAX_DIST_FLAG VARCHAR2 (1)
Y or N indicates if this tax distribution is for one of the multiple reporting currencies (MRC)
MRC_LINK_TO_TAX_DIST_ID NUMBER

Identifier of the source tax disttribution in transaction currency corresponding to which this tax distribution is created if this tax distribution is in one of the multiple reporting currencies
TAX_APPORTIONMENT_FLAG VARCHAR2 (1)
Y or N indicates whether there are multiple tax lines created for the tax of this tax distribution during migration from prior releases
RATE_TAX_FACTOR NUMBER

1 for percentage based taxes; 0 for all others
REF_DOC_PER_UNIT_NREC_TAX_AMT NUMBER

Per-unit non recoverable tax amount for the reference document
PER_UNIT_NREC_TAX_AMT NUMBER

Per-unit non recoverable tax amount for the current transaction
TRX_LINE_DIST_QTY NUMBER

Transaction line distribution quantity
REF_DOC_TRX_LINE_DIST_QTY NUMBER

Reference document transaction line distribution quantity
PRICE_DIFF NUMBER

Price difference. This column is applicable only for price correction invoices.
QTY_DIFF NUMBER

Quantity difference
PER_TRX_CURR_UNIT_NR_AMT NUMBER

Amount derived by dividing non-recoverable tax amount by quantity and price of the current document
REF_PER_TRX_CURR_UNIT_NR_AMT NUMBER

Amount derived by dividing non-recoverable tax amount by quantity and price of the reference document
REF_DOC_CURR_CONV_RATE NUMBER

Exchange rate for transaction to functional currecy conversion in reference document
UNIT_PRICE NUMBER

Unit price of the current transaction line
REF_DOC_UNIT_PRICE NUMBER

Unit price of the reference document line
APPLIED_TO_DOC_CURR_CONV_RATE NUMBER

Applied to document exchange rate
TRX_NUMBER VARCHAR2 (150)
Transaction number for this tax distribution
TRX_LEVEL_TYPE VARCHAR2 (30)
Column to record the level at which the transaction line identifier is stored for this tax distribution. Possible values are LINE, SHIPMENT and FREIGHT.
REF_DOC_TRX_LEVEL_TYPE VARCHAR2 (30)
Column to record the level at which the reference document line identifier is stored. Possible values are LINE, SHIPMENT and FREIGHT.
OBJECT_VERSION_NUMBER NUMBER
Yes Object version number
ORIG_AP_CHRG_DIST_NUM NUMBER

Column to store INVOICE_DISTRIBUTION_ID of AP_INVOICE_DISTRIBUTIONS_ALL for the taxable line correponding to this tax distribuion if it is migrated from prior releases
ORIG_AP_CHRG_DIST_ID NUMBER

Column to store DISTRIBUTION_LINE_NUMBER of AP_INVOICE_DISTRIBUTIONS_ALL for the taxable line correponding to this tax distribuion if it is migrated from prior releases
ORIG_AP_TAX_DIST_NUM NUMBER

Column to store INVOICE_DISTRIBUTION_ID of AP_INVOICE_DISTRIBUTIONS_ALL for the tax line correponding to this tax distribuion if it is migrated from prior releases
ORIG_AP_TAX_DIST_ID NUMBER

Column to store DISTRIBUTION_LINE_NUMBER of AP_INVOICE_DISTRIBUTIONS_ALL for the tax line correponding to this tax distribuion if it is migrated from prior releases
INTERNAL_ORGANIZATION_ID NUMBER

Internal organization identifier of the transaction
TAX_JURISDICTION_ID NUMBER (15)
Internal identifier of Tax Jurisdiction
DEF_REC_SETTLEMENT_OPTION_CODE VARCHAR2 (30)
Lookup code to indicate whether an input tax can be recovered when an invoice is recorded or only when the invoice is paid and whether an output tax is due for settlement when the invoice is issued or only when the payment is received against it
ACCOUNT_SOURCE_TAX_RATE_ID NUMBER (15)
Tax Rate from which the GL account should be derived. If the tax derives its GL account from another tax, this column store the tax rate id of that tax, i.e., the source tax for accounts
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT REC_NREC_TAX_DIST_ID
,      APPLICATION_ID
,      ENTITY_CODE
,      EVENT_CLASS_CODE
,      EVENT_TYPE_CODE
,      TAX_EVENT_CLASS_CODE
,      TAX_EVENT_TYPE_CODE
,      TRX_ID
,      TRX_LINE_ID
,      TRX_LINE_NUMBER
,      TAX_LINE_ID
,      TAX_LINE_NUMBER
,      TRX_LINE_DIST_ID
,      ITEM_DIST_NUMBER
,      CONTENT_OWNER_ID
,      REC_NREC_TAX_DIST_NUMBER
,      TAX_REGIME_ID
,      TAX_REGIME_CODE
,      TAX_ID
,      TAX
,      TAX_STATUS_ID
,      TAX_STATUS_CODE
,      TAX_RATE_ID
,      TAX_RATE_CODE
,      TAX_RATE
,      INCLUSIVE_FLAG
,      RECOVERY_TYPE_ID
,      RECOVERY_TYPE_CODE
,      RECOVERY_RATE_ID
,      RECOVERY_RATE_CODE
,      REC_NREC_RATE
,      REC_TYPE_RULE_FLAG
,      NEW_REC_RATE_CODE_FLAG
,      RECOVERABLE_FLAG
,      REVERSE_FLAG
,      HISTORICAL_FLAG
,      REVERSED_TAX_DIST_ID
,      REC_NREC_TAX_AMT
,      REC_NREC_TAX_AMT_TAX_CURR
,      REC_NREC_TAX_AMT_FUNCL_CURR
,      INTENDED_USE
,      PROJECT_ID
,      TASK_ID
,      AWARD_ID
,      EXPENDITURE_TYPE
,      EXPENDITURE_ORGANIZATION_ID
,      EXPENDITURE_ITEM_DATE
,      REC_RATE_DET_RULE_FLAG
,      LEDGER_ID
,      SUMMARY_TAX_LINE_ID
,      RECORD_TYPE_CODE
,      CURRENCY_CONVERSION_DATE
,      CURRENCY_CONVERSION_TYPE
,      CURRENCY_CONVERSION_RATE
,      TAX_CURRENCY_CONVERSION_DATE
,      TAX_CURRENCY_CONVERSION_TYPE
,      TAX_CURRENCY_CONVERSION_RATE
,      TRX_CURRENCY_CODE
,      TAX_CURRENCY_CODE
,      TRX_LINE_DIST_AMT
,      TRX_LINE_DIST_TAX_AMT
,      ORIG_REC_NREC_RATE
,      ORIG_REC_RATE_CODE
,      ORIG_REC_NREC_TAX_AMT
,      ORIG_REC_NREC_TAX_AMT_TAX_CURR
,      UNROUNDED_REC_NREC_TAX_AMT
,      APPLICABILITY_RESULT_ID
,      REC_RATE_RESULT_ID
,      BACKWARD_COMPATIBILITY_FLAG
,      OVERRIDDEN_FLAG
,      SELF_ASSESSED_FLAG
,      FREEZE_FLAG
,      POSTING_FLAG
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      GLOBAL_ATTRIBUTE_CATEGORY
,      GLOBAL_ATTRIBUTE1
,      GLOBAL_ATTRIBUTE2
,      GLOBAL_ATTRIBUTE3
,      GLOBAL_ATTRIBUTE4
,      GLOBAL_ATTRIBUTE5
,      GLOBAL_ATTRIBUTE6
,      GLOBAL_ATTRIBUTE7
,      GLOBAL_ATTRIBUTE8
,      GLOBAL_ATTRIBUTE9
,      GLOBAL_ATTRIBUTE10
,      GLOBAL_ATTRIBUTE11
,      GLOBAL_ATTRIBUTE12
,      GLOBAL_ATTRIBUTE13
,      GLOBAL_ATTRIBUTE14
,      GLOBAL_ATTRIBUTE15
,      GL_DATE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      LAST_UPDATE_DATE
,      REF_DOC_APPLICATION_ID
,      REF_DOC_ENTITY_CODE
,      REF_DOC_EVENT_CLASS_CODE
,      REF_DOC_TRX_ID
,      REF_DOC_LINE_ID
,      REF_DOC_DIST_ID
,      MINIMUM_ACCOUNTABLE_UNIT
,      PRECISION
,      ROUNDING_RULE_CODE
,      TAXABLE_AMT
,      TAXABLE_AMT_TAX_CURR
,      TAXABLE_AMT_FUNCL_CURR
,      TAX_ONLY_LINE_FLAG
,      UNROUNDED_TAXABLE_AMT
,      LEGAL_ENTITY_ID
,      ACCOUNT_CCID
,      ACCOUNT_STRING
,      PRD_TAX_AMT
,      PRD_TAX_AMT_TAX_CURR
,      PRD_TAX_AMT_FUNCL_CURR
,      PRD_TOTAL_TAX_AMT
,      PRD_TOTAL_TAX_AMT_TAX_CURR
,      PRD_TOTAL_TAX_AMT_FUNCL_CURR
,      APPLIED_FROM_TAX_DIST_ID
,      ADJUSTED_DOC_TAX_DIST_ID
,      FUNC_CURR_ROUNDING_ADJUSTMENT
,      GLOBAL_ATTRIBUTE16
,      GLOBAL_ATTRIBUTE17
,      GLOBAL_ATTRIBUTE18
,      GLOBAL_ATTRIBUTE19
,      GLOBAL_ATTRIBUTE20
,      LAST_MANUAL_ENTRY
,      TAX_APPORTIONMENT_LINE_NUMBER
,      REF_DOC_TAX_DIST_ID
,      MRC_TAX_DIST_FLAG
,      MRC_LINK_TO_TAX_DIST_ID
,      TAX_APPORTIONMENT_FLAG
,      RATE_TAX_FACTOR
,      REF_DOC_PER_UNIT_NREC_TAX_AMT
,      PER_UNIT_NREC_TAX_AMT
,      TRX_LINE_DIST_QTY
,      REF_DOC_TRX_LINE_DIST_QTY
,      PRICE_DIFF
,      QTY_DIFF
,      PER_TRX_CURR_UNIT_NR_AMT
,      REF_PER_TRX_CURR_UNIT_NR_AMT
,      REF_DOC_CURR_CONV_RATE
,      UNIT_PRICE
,      REF_DOC_UNIT_PRICE
,      APPLIED_TO_DOC_CURR_CONV_RATE
,      TRX_NUMBER
,      TRX_LEVEL_TYPE
,      REF_DOC_TRX_LEVEL_TYPE
,      OBJECT_VERSION_NUMBER
,      ORIG_AP_CHRG_DIST_NUM
,      ORIG_AP_CHRG_DIST_ID
,      ORIG_AP_TAX_DIST_NUM
,      ORIG_AP_TAX_DIST_ID
,      INTERNAL_ORGANIZATION_ID
,      TAX_JURISDICTION_ID
,      DEF_REC_SETTLEMENT_OPTION_CODE
,      ACCOUNT_SOURCE_TAX_RATE_ID
FROM ZX.ZX_REC_NREC_DIST;

Dependencies

[top of page]

ZX.ZX_REC_NREC_DIST does not reference any database object

ZX.ZX_REC_NREC_DIST is referenced by following:

SchemaAPPS
SynonymZX_REC_NREC_DIST