ZX_TRX_TAX_DISTRIBUTIONS
This table contains the tax distributions information for the external or simulator tax transaction.
Details
-
Schema: FUSION
-
Object owner: ZX
-
Object type: TABLE
-
Tablespace: TRANSACTION_TABLES
Primary Key
Name | Columns |
---|---|
ZX_TRX_TAX_DISTRIBUTIONS_PK |
TAX_DIST_ID |
Columns
Name | Datatype | Length | Precision | Not-null | Comments | Status |
---|---|---|---|---|---|---|
TAX_DIST_ID | NUMBER | 18 | Yes | Unique identifier for a tax distribution. | Active | |
ACCOUNT_CCID | NUMBER | 18 | Unique combination of segment values that records accounting transactions. | Active | ||
ACCOUNT_CLASS | VARCHAR2 | 30 | Account class from the customer transaction line GL distribution. | Active | ||
ACCOUNT_SET_FLAG | VARCHAR2 | 1 | Yes or No indicates whether the account set for a distribution is stored. | Active | ||
ACCOUNT_SOURCE_TAX_RATE_ID | NUMBER | 18 | Account source tax rate identifier. | Active | ||
ACCOUNT_STRING | VARCHAR2 | 1000 | Account string associated with the item distribution line. | Active | ||
ACCOUNTING_EVENT_ID | NUMBER | 18 | Identifier for an accounting event record in a table. | Active | ||
APPLICATION_ID | NUMBER | 18 | Yes | Application identifier for a tax distribution. | Active | |
COLLECTED_TAX_CCID | NUMBER | 18 | Identifier for the account associated with collected tax. | Active | ||
COLLECTED_TAX_CONCAT_SEG | VARCHAR2 | 1000 | Code combination used to account for collected tax associated with external transactions. | Active | ||
CONTENT_OWNER_ID | NUMBER | 18 | Party tax profile identifier for a configuration owner of a distribution. | Active | ||
CURRENCY_CONVERSION_DATE | DATE | Date as of which a conversion rate is used to convert an amount into another currency. | Active | |||
CURRENCY_CONVERSION_RATE | NUMBER | Conversion rate at which the principal unit of one currency can be converted into another currency. | Active | |||
CURRENCY_CONVERSION_TYPE | VARCHAR2 | 30 | Source of a currency conversion rate, such as user defined, spot, or corporate. | Active | ||
DEF_SETTLEMENT_OPTION_CODE | VARCHAR2 | 30 | Default settlement option code. | Active | ||
ENTITY_CODE | VARCHAR2 | 30 | Yes | Entity code of the transaction, which indicates the type of transaction being created. | Active | |
EVENT_CLASS_CODE | VARCHAR2 | 30 | Yes | Application event class of the transaction. | Active | |
EVENT_TYPE_CODE | VARCHAR2 | 30 | Yes | Event type code for the application event class. | Active | |
FREEZE_FLAG | VARCHAR2 | 1 | Yes or No indicates whether this tax distribution is frozen. | Active | ||
GL_DATE | DATE | Default accounting date for transactions. | Active | |||
GL_POSTED_DATE | DATE | Date when this distribution was posted in the general ledger. | Active | |||
HISTORICAL_FLAG | VARCHAR2 | 1 | Yes or No indicates whether this tax line is created during migration from prior releases. | Active | ||
INCLUSIVE_FLAG | VARCHAR2 | 1 | Yes or No indicates whether this tax line is inclusive. | Active | ||
INTERNAL_ORGANIZATION_ID | NUMBER | 18 | Internal organization identifier of the tax distribution. | Active | ||
LAST_MANUAL_ENTRY | VARCHAR2 | 30 | Identifier for the column that was last overridden by the user. Possible values are TAX_STATUS, TAX_RATE, TAX_RATE_CODE and TAX_AMOUNT. | Active | ||
LEDGER_ID | NUMBER | 18 | Ledger identifier for the self-contained accounting information set for single or multiple legal or management entities. | Active | ||
LEGAL_ENTITY_ID | NUMBER | 18 | 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. | Active | ||
LEGAL_REPORTING_STATUS | VARCHAR2 | 15 | Legal reporting status of the document. | Active | ||
MINIMUM_ACCOUNTABLE_UNIT | NUMBER | Smallest meaningful denomination of a currency. | Active | |||
ORIG_RATE | NUMBER | Original tax rate of the distribution. | Active | |||
ORIG_RATE_CODE | VARCHAR2 | 150 | Original tax rate code of the distribution. | Active | ||
ORIG_TAX_AMT | NUMBER | Tax amount in entered currency before user override. | Active | |||
ORIG_TAX_AMT_TAX_CURR | NUMBER | Tax amount in tax currency before user override. | Active | |||
OVERRIDDEN_FLAG | VARCHAR2 | 1 | Yes or No indicates whether user has overridden this tax line. | Active | ||
POSTED_TO_SLA_FLAG | VARCHAR2 | 1 | Yes or No indicates whether an item distribution has been posted to SLA. | Active | ||
PRECISION | NUMBER | One-digit whole number to indicate the decimal place for tax rounding. | Active | |||
RECORD_TYPE_CODE | VARCHAR2 | 30 | Lookup code to indicate whether the record is migrated, seeded or defined by the user. | Active | ||
REPORTABLE_FLAG | VARCHAR2 | 1 | Yes or No indicates whether this tax distribution is reportable. | Active | ||
REVENUE_ADJUSTMENT_ID | NUMBER | 18 | Revenue adjustment identifier of a tax distribution. | Active | ||
REVERSE_FLAG | VARCHAR2 | 1 | Yes or No indicates whether the tax distribution is reversed by another tax distribution. | Active | ||
REVERSED_TAX_DIST_ID | NUMBER | 18 | Reversed Tax Distribution Identifier | Active | ||
ROUNDING_RULE_CODE | VARCHAR2 | 30 | Rule that defines how the rounding should be performed on a value involved in a taxable transaction. | Active | ||
TAX | VARCHAR2 | 30 | Yes | Tax code for the classification of a charge imposed by a government through a fiscal or tax authority. | Active | |
TAX_AMT | NUMBER | Tax amount associated with the tax distribution. | Active | |||
TAX_APPORTIONMENT_LINE_NUMBER | NUMBER | Yes or No indicates whether there are multiple tax lines created for the tax of this line during migration from prior releases. | Active | |||
TAX_CURRENCY_CODE | VARCHAR2 | 15 | Unique identification of a currency in which the tax transactions are to be reported. | Active | ||
TAX_CURRENCY_CONVERSION_DATE | DATE | Date of the conversion rate for entered currency to tax currency conversion. | Active | |||
TAX_CURRENCY_CONVERSION_RATE | NUMBER | Conversion rate for entered currency to tax currency conversion. | Active | |||
TAX_CURRENCY_CONVERSION_TYPE | VARCHAR2 | 30 | Conversion rate type for entered currency to tax currency conversion. | Active | ||
TAX_DIST_AMT | NUMBER | Monetary value of a tax distribution. | Active | |||
TAX_DIST_AMT_FUNCL_CURR | NUMBER | Tax distribution amount in ledger currency. | Active | |||
TAX_DIST_AMT_TAX_CURR | NUMBER | Tax distribution amount in tax currency. | Active | |||
TAX_DIST_NUMBER | NUMBER | Numeric identifier for a tax distribution. | Active | |||
TAX_EVENT_CLASS_CODE | VARCHAR2 | 30 | Application event class of the transaction. | Active | ||
TAX_EVENT_TYPE_CODE | VARCHAR2 | 30 | Tax event type code of the transaction. | Active | ||
TAX_ID | NUMBER | 18 | Tax identifier for the classification of a charge imposed by a government through a fiscal or tax authority. | Active | ||
TAX_JURISDICTION_CODE | VARCHAR2 | 30 | Tax jurisdiction code for a geographic area where a tax is levied by a specific tax authority. | Active | ||
TAX_JURISDICTION_ID | NUMBER | 18 | Tax jurisdiction identifier for a geographic area where a tax is levied by a specific tax authority. | Active | ||
TAX_LINE_ID | NUMBER | 18 | Yes | Identifier for a particular tax line in a table. | Active | |
TAX_LINE_NUMBER | NUMBER | Line number generated for this tax line. | Active | |||
TAX_ONLY_LINE_FLAG | VARCHAR2 | 1 | Yes or No indicates whether this tax distribution is for a tax only line. | Active | ||
TAX_POINT_BASIS | VARCHAR2 | 30 | Event on which the tax is levied, accounted in the books and reported to the tax authorities. | Active | ||
TAX_POINT_DATE | DATE | Date on which the taxpayer becomes liable for paying the tax to the tax authority. | Active | |||
TAX_RATE | NUMBER | Rate specified for a tax status for an effective time period. A tax rate can be expressed as a percentage or a value per unit quantity. | Active | |||
TAX_RATE_CODE | VARCHAR2 | 150 | Yes | Tax rate code specified for a tax status for an effective time period, expressed as a percentage or a value per unit quantity. | Active | |
TAX_RATE_ID | NUMBER | 18 | Identifier for the rate specified for a tax status for an effective time period. | Active | ||
TAX_REGIME_CODE | VARCHAR2 | 30 | Yes | Tax regime code for the set of tax rules that determines the treatment of one or more taxes administered by a tax authority. | Active | |
TAX_REGIME_ID | NUMBER | 18 | Tax regime identifier for the set of tax rules that determines the treatment of one or more taxes administered by a tax authority. | Active | ||
TAX_STATUS_CODE | VARCHAR2 | 30 | Yes | Tax status code for the taxable nature of a product in the context of a transaction for a tax. | Active | |
TAX_STATUS_ID | NUMBER | 18 | Tax status identifier for the taxable nature of a product in the context of a transaction for a tax. | Active | ||
TRX_CURRENCY_CODE | VARCHAR2 | 15 | Three-letter ISO (International Organization for Standardization) code for the entered currency. | Active | ||
TRX_ID | NUMBER | 18 | Yes | System-generated identification number of a transaction. | Active | |
TRX_LEVEL_TYPE | VARCHAR2 | 30 | Yes | Level at which the transaction line identifier is stored. Possible values are LINE, SHIPMENT and FREIGHT. | Active | |
TRX_LINE_DIST_AMT | NUMBER | Amount of the current item distribution line. | Active | |||
TRX_LINE_DIST_ID | NUMBER | 18 | Yes | Identifier for the current item distribution line. | Active | |
TRX_LINE_DIST_TAX_AMT | NUMBER | Tax amount pertaining to the current item distribution. | Active | |||
TRX_LINE_ID | NUMBER | 18 | Yes | Identifier for a particular transaction line in a table. | Active | |
TRX_LINE_NUMBER | NUMBER | Number of a particular transaction line in a table. | Active | |||
TRX_NUMBER | VARCHAR2 | 30 | Transaction number, typically the number that enables a user to identify a transaction. | Active | ||
LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | Active | ||
LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | Active | ||
LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | Active | |
CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | Active | ||
CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | Active | |
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. | Active | |
TRANSFERRED_TO_GL_FLAG | VARCHAR2 | 1 | Column to store posted to GL flag. | Active | ||
ACCOUNTING_REQUEST_ID | NUMBER | 18 | Column to store request identifier of the accounting program. | Active | ||
CREDIT_ACCOUNT_CCID | NUMBER | 18 | Credit account identifier for the transaction line. | |||
DEBIT_ACCOUNT_CCID | NUMBER | 18 | Debit account identifier for the transaction line. | |||
REPORTING_BATCH_ID | NUMBER | 18 | To store the selection process batch identifier. | |||
TRX_LINE_DIST_AMT_FUNCL_CURR | NUMBER | Item distribution amount in ledger currency. |
Indexes
Index | Uniqueness | Tablespace | Columns | Status |
---|---|---|---|---|
ZX_TRX_TAX_DISTRIBUTIONS_U1 | Unique | FUSION_TS_TX_IDX | TAX_DIST_ID | Active |
ZX_TRX_TAX_DISTRIBUTIONS_U2 | Unique | FUSION_TS_TX_IDX | APPLICATION_ID, ENTITY_CODE, EVENT_CLASS_CODE, TRX_ID, TRX_LINE_ID, TRX_LEVEL_TYPE, TAX_LINE_ID | Active |