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