CMR_RETRO_PRICE_TAX_EVENTS_GT
Temporary table to hold all the retro active price update transactions
Details
-
Schema: FUSION
-
Object owner: CMR
-
Object type: TABLE
-
Tablespace: Default
Columns
| Name | Datatype | Length | Precision | Comments |
|---|---|---|---|---|
| PO_LINE_LOCATION_ID | NUMBER | 18 | Purchase order Line Location Identifier. | |
| RETROACTIVE_DATE | TIMESTAMP | Retro Active Date - indicates the po price change date | ||
| QUANTITY | NUMBER | Purchase order quantity at po schedule level. | ||
| PRIOR_QUANTITY | NUMBER | Prior PO quantity - Purchase order quantity at po schedule level. | ||
| TRANSACTION_TAX_ID | NUMBER | 18 | Stores transaction tax identifier | |
| TRANSACTION_ID | NUMBER | 18 | Transaction Identifier - maps to CMR_TRANSACTIONS.TRANSACTION_ID. | |
| TAX_REGIME_CODE | VARCHAR2 | 30 | Tax Regime Code - used in TAX API call attribute. | |
| TAX | VARCHAR2 | 30 | Tax name - used in TAX API call attribute. | |
| TAX_RATE_CODE | VARCHAR2 | 150 | Tax rate Code -- used in TAX API call attribute. | |
| RECOVERY_TYPE_CODE | VARCHAR2 | 30 | Recovery Type Code -- used in TAX API call attribute. | |
| RECOVERABLE_FLAG | VARCHAR2 | 1 | Tax Recoverable Flag -- used in TAX API call attribute. | |
| SELF_ASSESSED_FLAG | VARCHAR2 | 1 | Self assed Flag - used in TAX API call attribute. | |
| TAX_JURISDICTION_ID | NUMBER | 18 | Tax Jurisdiction Identifier populated for price change events | |
| RECOVERY_RATE_CODE | VARCHAR2 | 150 | Recovery Rate Code | |
| ACCOUNT_CCID | NUMBER | 18 | Tax Account Identifier | |
| INCLUSIVE_FLAG | VARCHAR2 | 1 | Inclusive Flag | |
| TAX_POINT_BASIS | VARCHAR2 | 30 | tax Point basis - Invoiced or Deliver based taxes | |
| TAX_STATUS_CODE | VARCHAR2 | 30 | Tax Status Code | |
| TAX_UNIT_AMT | NUMBER | Tax Unit Amount - Return value by TAX API call for purchase order receipts. | ||
| PRIOR_TAX_UNIT_AMT | NUMBER | Prior processed tax amount - Return value by TAX API call for purchase order receipts. |