[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | ZX_REC_NREC_DIST |
|---|---|
| Object Type: | TABLE |
| Owner: | ZX |
| FND Design Data: |  ZX.ZX_REC_NREC_DIST
|
| Subobject Name: | |
| Status: | VALID |
| Tablespace: |  APPS_TS_TX_DATA |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| ZX_REC_NREC_DIST_U1 | NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
 REC_NREC_TAX_DIST_ID
|
| ZX_REC_NREC_DIST_U2 | NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
TAX_LINE_ID
TRX_LINE_DIST_ID
REC_NREC_TAX_DIST_NUMBER
|
| ZX_REC_NREC_DIST_U3 | NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
APPLICATION_ID
ENTITY_CODE
EVENT_CLASS_CODE
TRX_ID
TAX_LINE_NUMBER
TRX_LINE_DIST_ID
REC_NREC_TAX_DIST_NUMBER
|
| ZX_REC_NREC_DIST_N1 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
TRX_LINE_ID
REVERSE_FLAG
|
| ZX_REC_NREC_DIST_N2 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
REVERSED_TAX_DIST_ID
REVERSE_FLAG
|
| 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 |
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;
ZX.ZX_REC_NREC_DIST does not reference any database object
ZX.ZX_REC_NREC_DIST is referenced by following:
APPS
ZX_REC_NREC_DIST
|
|
|
|