ZX_TRX_LINE_APP_REGIMES
This table stores Transaction Line aplicable Regimes
Details
-
Schema: FUSION
-
Object owner: ZX
-
Object type: TABLE
-
Tablespace: TRANSACTION_TABLES
Primary Key
Name | Columns |
---|---|
ZX_TRX_LINE_APP_REGIMES_PK |
EVENT_CLASS_CODE, APPLICATION_ID, ENTITY_CODE, TRX_ID, TRX_LINE_ID, TRX_LEVEL_TYPE, TAX_REGIME_CODE |
Columns
Name | Datatype | Length | Precision | Not-null | Comments |
---|---|---|---|---|---|
EVENT_CLASS_CODE | VARCHAR2 | 30 | Yes | Event class code of the transaction | |
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. | |
APPLICATION_ID | NUMBER | Yes | Application Identifier of the transaction | ||
ENTITY_CODE | VARCHAR2 | 30 | Yes | Entity code of the transaction | |
TRX_ID | NUMBER | 18 | Yes | Primary transaction identifier | |
TRX_LINE_ID | NUMBER | 18 | Yes | Transaction line identifier | |
TRX_LEVEL_TYPE | VARCHAR2 | 30 | Yes | Column to record the level at which the transaction line identifier is stored. Possible values are LINE, SHIPMENT and FREIGHT. | |
TAX_REGIME_ID | NUMBER | Yes | Tax regime identifier applicable for the transaction line | ||
TAX_REGIME_CODE | VARCHAR2 | 30 | Yes | Tax regime code applicable for the transaction line | |
TAX_PROVIDER_ID | NUMBER | 18 | Party tax profile identifier of the third party tax service provider that calculates tax for this regime and transaction line | ||
ALLOW_TAX_CALCULATION_FLAG | VARCHAR2 | 1 | Y or N indicates to the tax service provider to always synchronize the transaction and tax information instead of calculating the tax information | ||
CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | ||
UPDATE_FLAG | VARCHAR2 | 1 | Y or N indicates if the transaction line is updated in the current API call | ||
PSEUDO_TAX_ONLY_LINE_FLAG | VARCHAR2 | 1 | Y or N indicates whether the transaction line identifier represents a pseudo line corresponding to a tax only line |
Foreign Keys
Table | Foreign Table | Foreign Key Column |
---|---|---|
ZX_TRX_LINE_APP_REGIMES | zx_regimes_b | TAX_REGIME_CODE |
ZX_TRX_LINE_APP_REGIMES | zx_party_tax_profile | TAX_PROVIDER_ID |
Indexes
Index | Uniqueness | Tablespace | Columns |
---|---|---|---|
ZX_TRX_LINE_APP_REGIMES_U1 | Unique | Default | EVENT_CLASS_CODE, APPLICATION_ID, ENTITY_CODE, TRX_ID, TRX_LINE_ID, TRX_LEVEL_TYPE, TAX_REGIME_CODE |