ZX_TAX_DISTS_INTERFACE
This table stores external transaction tax distributions to be imported into tax repository directly.
Details
-
Schema: FUSION
-
Object owner: ZX
-
Object type: TABLE
-
Tablespace: INTERFACE
Primary Key
| Name | Columns |
|---|---|
|
ZX_TAX_DISTS_INTERFACE_PK |
REC_NREC_TAX_DIST_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| REC_NREC_TAX_DIST_ID | NUMBER | 18 | Yes | Unique identifier | |
| DEBIT_ACCT_STRING | VARCHAR2 | 1000 | Concatenated accounting flexfield segment values associated with the debit account. | ||
| CREDIT_ACCT_STRING | VARCHAR2 | 1000 | Concatenated accounting flexfield segment values associated with the credit account. | ||
| DEBIT_ACCOUNT_CCID | NUMBER | 18 | Debit account identifier for the tax distribution. | ||
| CREDIT_ACCOUNT_CCID | NUMBER | 18 | Credit account identifier for the tax distribution. | ||
| APPLICATION_ID | NUMBER | 18 | Yes | Application identifier for this tax distribution | |
| TRX_LINE_DIST_TAX_AMT | NUMBER | Tax amount pertaining to the current item distribution in transaction currency | |||
| TRX_LINE_DIST_AMT | NUMBER | Item distribution line amount | |||
| TAX_CURRENCY_CODE | VARCHAR2 | 15 | Tax currency code | ||
| TRX_CURRENCY_CODE | VARCHAR2 | 15 | Transaction currency code. | ||
| TAX_CURRENCY_CONVERSION_RATE | NUMBER | 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_DATE | DATE | Date of the exchange rate for transaction currency to tax currency conversion | |||
| CURRENCY_CONVERSION_RATE | NUMBER | 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_DATE | DATE | Date of the exchange rate for transaction currency to functional currency conversion | |||
| LEDGER_ID | NUMBER | 18 | Ledger defining column | ||
| EXPENDITURE_ITEM_DATE | DATE | Date for project expenditure item used to build Accounting Flexfield for project-related item distribution line | |||
| EXPENDITURE_ORGANIZATION_ID | NUMBER | 18 | Identifier for project organization used to build Accounting Flexfield for project-related item distribution line | ||
| EXPENDITURE_TYPE | VARCHAR2 | 30 | Project expenditure type used to build Accounting Flexfield for project-related item distribution line | ||
| TASK_ID | NUMBER | 18 | Identifier for project task used to build Accounting Flexfield for project-related item distribution line | ||
| PROJECT_ID | NUMBER | 18 | Identifier for project used to build Accounting Flexfield for project-related item distribution line | ||
| HISTORICAL_FLAG | VARCHAR2 | 1 | Y or N indicates whether this tax distribution is migrated from prior releases | ||
| UNROUNDED_REC_NREC_TAX_AMT | NUMBER | Tax distribution amount in transaction currency before rounding | |||
| INTENDED_USE | VARCHAR2 | 30 | Fiscal classification code that indicates the purpose for which the product of this tax distribution is used | ||
| RECORD_TYPE_CODE | VARCHAR2 | 30 | Lookup code to indicate whether the record is migrated | ||
| REC_NREC_TAX_AMT_FUNCL_CURR | NUMBER | Tax distribution amount in functional currency | |||
| REC_NREC_TAX_AMT_TAX_CURR | NUMBER | Tax distribution amount in tax currency | |||
| REC_NREC_TAX_AMT | NUMBER | Yes | Tax distribution amount in transaction currency | ||
| REVERSED_TAX_DIST_ID | NUMBER | 18 | Identifier of tax distribution that is reversed by this tax distribution | ||
| REVERSE_FLAG | VARCHAR2 | 1 | Y or N indicates that this tax distribution either reverses another tax distribution or is reversed by another tax distribution | ||
| RECOVERABLE_FLAG | VARCHAR2 | 1 | Yes | Y or N indicates whether this tax distribution is recoverable or non-recoverable | |
| REC_NREC_RATE | NUMBER | Yes | Tax distribution rate used for determining the distribution amount | ||
| RECOVERY_RATE_CODE | VARCHAR2 | 150 | Recovery rate code | ||
| RECOVERY_RATE_ID | NUMBER | 18 | Recovery rate identifier | ||
| RECOVERY_TYPE_CODE | VARCHAR2 | 30 | Recovery type code | ||
| REC_NREC_TAX_DIST_NUMBER | NUMBER | Yes | Line number generated for this tax distribution | ||
| INCLUSIVE_FLAG | VARCHAR2 | 1 | Y on N indicates if this tax distribution amount is included in transaction line amount. | ||
| TAX_RATE | NUMBER | Tax rate | |||
| TAX_RATE_CODE | VARCHAR2 | 150 | Tax rate code | ||
| TAX_RATE_ID | NUMBER | 18 | Tax rate identifier | ||
| TAX_STATUS_CODE | VARCHAR2 | 30 | Tax status code | ||
| TAX | VARCHAR2 | 30 | Tax | ||
| TAX_REGIME_CODE | VARCHAR2 | 30 | Tax regime code | ||
| TRX_LINE_DIST_ID | NUMBER | 18 | Yes | Item distribution identifier for this tax distribution | |
| TAX_LINE_NUMBER | NUMBER | Yes | Tax line number for this tax distribution | ||
| TRX_LINE_NUMBER | NUMBER | Transaction line number for this tax distribution | |||
| TRX_LINE_ID | NUMBER | 18 | Yes | Transaction line identifier for this tax distribution | |
| TRX_ID | NUMBER | 18 | Yes | Transaction identifier for this tax distribution | |
| TAX_EVENT_TYPE_CODE | VARCHAR2 | 30 | Tax event type code of this tax distribution | ||
| TAX_EVENT_CLASS_CODE | VARCHAR2 | 30 | Tax event class code of this tax distribution | ||
| EVENT_TYPE_CODE | VARCHAR2 | 30 | Yes | Event type code for this tax distribution | |
| EVENT_CLASS_CODE | VARCHAR2 | 30 | Yes | Event class code for this tax distribution | |
| ENTITY_CODE | VARCHAR2 | 30 | Yes | Entity code for this tax distribution | |
| ITEM_DIST_NUMBER | NUMBER | Item distribution number for this tax distribution | |||
| ACCOUNT_SOURCE_TAX_RATE_ID | NUMBER | 18 | Tax rate from which the GL account should be derived. If the tax derives its GL account from another tax, this column stores the tax rate identifier of that tax, i.e., the source tax for accounts. | ||
| 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 | ||
| OBJECT_VERSION_NUMBER | NUMBER | 9 | Yes | Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. | |
| 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 | ||
| 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 | ||
| APPLIED_TO_DOC_CURR_CONV_RATE | NUMBER | Applied to document exchange rate | |||
| REF_DOC_UNIT_PRICE | NUMBER | Unit price of the reference document line | |||
| UNIT_PRICE | NUMBER | Unit price of the current transaction line | |||
| REF_DOC_CURR_CONV_RATE | NUMBER | Exchange rate for transaction to functional currecy conversion in reference 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 | |||
| PER_TRX_CURR_UNIT_NR_AMT | NUMBER | Amount derived by dividing non-recoverable tax amount by quantity and price of the current document | |||
| QTY_DIFF | NUMBER | Quantity difference | |||
| PRICE_DIFF | NUMBER | Price difference. This column is applicable only for price correction invoices. | |||
| REF_DOC_TRX_LINE_DIST_QTY | NUMBER | Reference document transaction line distribution quantity | |||
| TRX_LINE_DIST_QTY | NUMBER | Transaction line distribution quantity | |||
| PER_UNIT_NREC_TAX_AMT | NUMBER | Per-unit non recoverable tax amount for the current transaction | |||
| REF_DOC_PER_UNIT_NREC_TAX_AMT | NUMBER | Per-unit non recoverable tax amount for the reference document | |||
| 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 | ||
| REF_DOC_TAX_DIST_ID | NUMBER | 18 | Reference document tax distribution identifier | ||
| 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 | |||
| LAST_MANUAL_ENTRY | VARCHAR2 | 30 | Column to indicate which column is last overridden by the user | ||
| GLOBAL_ATTRIBUTE20 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE19 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE18 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE17 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE16 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| ADJUSTED_DOC_TAX_DIST_ID | NUMBER | 18 | Adjusted document tax distribution identifier | ||
| APPLIED_FROM_TAX_DIST_ID | NUMBER | 18 | Applied from document tax distribution identifier | ||
| ACCOUNT_STRING | VARCHAR2 | 1000 | Account string associated with the item distribution line | ||
| ACCOUNT_CCID | NUMBER | 18 | Account identifier associated with the item distribution line | ||
| LEGAL_ENTITY_ID | NUMBER | 18 | Legal entity identifier for the transaction | ||
| UNROUNDED_TAXABLE_AMT | NUMBER | Unrounded taxable amount on this tax distribution | |||
| TAX_ONLY_LINE_FLAG | VARCHAR2 | 1 | Y or N indicates whether this tax distribution is for a tax only line | ||
| TAXABLE_AMT_FUNCL_CURR | NUMBER | Taxable amount on this tax distribution in funcitonal currency | |||
| TAXABLE_AMT_TAX_CURR | NUMBER | Taxable amount on this tax distribution in tax currency | |||
| TAXABLE_AMT | NUMBER | Taxable amount on this tax distribution | |||
| ROUNDING_RULE_CODE | VARCHAR2 | 30 | Rounding Rule for the tax of this distribution | ||
| PRECISION | NUMBER | Precision | |||
| MINIMUM_ACCOUNTABLE_UNIT | NUMBER | Minimum accountable unit | |||
| REF_DOC_DIST_ID | NUMBER | 18 | Reference document item distribution identifier | ||
| REF_DOC_LINE_ID | NUMBER | 18 | Reference document transaction line identifier | ||
| REF_DOC_TRX_ID | NUMBER | 18 | Reference document transaction identifier | ||
| REF_DOC_EVENT_CLASS_CODE | VARCHAR2 | 30 | Reference document event class code | ||
| REF_DOC_ENTITY_CODE | VARCHAR2 | 30 | Reference document entity code | ||
| REF_DOC_APPLICATION_ID | NUMBER | 18 | Reference document application identifier | ||
| GL_DATE | DATE | Accounting Date | |||
| GLOBAL_ATTRIBUTE15 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE14 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE13 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE12 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE11 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE10 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE9 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE8 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE7 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE6 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE5 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE4 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE3 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE2 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE1 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE_CATEGORY | VARCHAR2 | 150 | Global Descriptive Flexfield: structure definition of the global descriptive flexfield. | ||
| ATTRIBUTE15 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE14 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE13 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE12 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE11 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE10 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE9 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE8 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE7 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE6 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE5 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE4 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE3 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE2 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE1 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CATEGORY | VARCHAR2 | 150 | Descriptive Flexfield: structure definition of the user descriptive flexfield. | ||
| POSTING_FLAG | VARCHAR2 | 1 | Y or N indicates if this tax distribution is posted to General Ledger | ||
| FREEZE_FLAG | VARCHAR2 | 1 | Y or N indicates if this tax distribution is frozen | ||
| SELF_ASSESSED_FLAG | VARCHAR2 | 1 | Y or N indicates whether this is distribution is for a self-assessed tax | ||
| ATTRIBUTE_DATE5 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE4 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE3 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE2 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE1 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER5 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER4 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER3 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER2 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER1 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| LAST_UPDATE_DATE | TIMESTAMP | Who column: indicates the date and time of the last update of the row. | |||
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | ||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Who column: indicates the user who last updated the row. | ||
| CREATION_DATE | TIMESTAMP | Who column: indicates the date and time of the creation of the row. | |||
| CREATED_BY | VARCHAR2 | 64 | Who column: indicates the user who created the row. | ||
| TAX_DIST_AMT | NUMBER | Monetary value of a tax distribution. | |||
| COLLECTED_TAX_CCID | NUMBER | 18 | Identifier for the account associated with collected tax. | ||
| COLLECTED_TAX_CONCAT_SEG | VARCHAR2 | 2000 | Segment associated with collected tax. | ||
| REVENUE_ADJUSTMENT_ID | NUMBER | 18 | Revenue adjustment identifier of a tax distribution. | ||
| DEF_SETTLEMENT_OPTION_CODE | VARCHAR2 | 30 | Default settlement option code. | ||
| TAX_POINT_BASIS | VARCHAR2 | 30 | Event on which the tax is levied, accounted in the books and reported to the tax authorities. | ||
| TAX_POINT_DATE | DATE | Date on which the taxpayer becomes liable for paying the tax to the tax authority. | |||
| GLOBAL_ATTRIBUTE_NUMBER1 | NUMBER | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAL_ATTRIBUTE_NUMBER2 | VARCHAR2 | 20 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE_NUMBER3 | VARCHAR2 | 20 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE_NUMBER4 | VARCHAR2 | 20 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE_NUMBER5 | VARCHAR2 | 20 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAGLOBAL_ATTRIBUTE_DATE1 | DATE | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAGLOBAL_ATTRIBUTE_DATE2 | DATE | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAGLOBAL_ATTRIBUTE_DATE3 | DATE | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAGLOBAL_ATTRIBUTE_DATE4 | DATE | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| GLOBAGLOBAL_ATTRIBUTE_DATE5 | DATE | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
| TAX_DIST_AMT_TAX_CURR | NUMBER | Tax distribution amount in tax currency. | |||
| TAX_DIST_AMT_FUNCL_CURR | NUMBER | Tax distribution amount in ledger currency. | |||
| LOAD_REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the interface load job that created the row. | ||
| LOAD_STATUS | VARCHAR2 | 30 | Enterprise Service Scheduler: indicates the request status of the interface load job that created the row. | ||
| LEDGER_NAME | VARCHAR2 | 30 | Ledger name for the self-contained accounting information set for single or multiple legal or management entities. | ||
| ITEM_DISTRIBUTION_NUMBER | NUMBER | Item distribution number for the particular tax distribution. | |||
| LINE_NUMBER | NUMBER | Numeric identifier of a line on a transaction. | |||
| TRX_NUMBER | VARCHAR2 | 150 | Alphanumeric identifier on a transaction. | ||
| ACCT_SRC_TAX_RATE_CODE | VARCHAR2 | 50 | Tax rate from which the GL account should be derived. If the tax derives its GL account from another tax, this column stores the tax rate identifier of the source tax. | ||
| LEGAL_ENTITY_IDENTIFIER | VARCHAR2 | 30 | Legal entity identifier that is either manually set by user or composed of the country of registration and the registration number of the identifying jurisdiction if automatically generated. | ||
| TAX_DISTRB_APPL_SHORT_NAME | VARCHAR2 | 1000 | Application short name of the tax distribution. | ||
| BATCH_NAME | VARCHAR2 | 80 | To identify the name of the batch containing external taxable transactions. | ||
| ASSET_FLAG | VARCHAR2 | 1 | Indicates if distribution is tracked in Assets. Possible values are Y or N. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| ZX_TAX_DISTS_INTERFACE_U1 | Unique | Default | REC_NREC_TAX_DIST_ID |
| ZX_TAX_DISTS_INTERFACE_U2 | Unique | Default | APPLICATION_ID, ENTITY_CODE, EVENT_CLASS_CODE, REC_NREC_TAX_DIST_NUMBER, TAX_LINE_NUMBER, TRX_ID, TRX_LINE_DIST_ID |