CML_TROP_CHARGE_ESTIMATES
This table stores the estimated landed cost charges in a trade operation for allocating to PO schedules and receipts
Details
-
Schema: FUSION
-
Object owner: CML
-
Object type: TABLE
-
Tablespace: Default
Primary Key
Name | Columns |
---|---|
CML_TROP_CHARGE_ESTIMATES_PK |
TROP_CHARGE_ESTIMATE_ID |
Columns
Name | Datatype | Length | Precision | Not-null | Comments |
---|---|---|---|---|---|
TROP_CHARGE_ESTIMATE_ID | NUMBER | 18 | Yes | Surrogate key that identifies the trade operation charge estimate. | |
TRADE_OPERATION_CHARGE_ID | NUMBER | 18 | Yes | Foreign Key from CML_TRADE_OPERATION_CHARGES | |
ENTERED_DATE | TIMESTAMP | Yes | The sys date on which the estimate is established/updated. The entered Date is to keep track of updates to the charge estimates. Instead of overwriting the history, changes to estimates are tracked by creating new records every time the charge estimate amount is updated. | ||
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. | |
CURRENCY_CODE | VARCHAR2 | 15 | Yes | The Currency in which estimate is calculated. | |
ENTERED_AMOUNT | NUMBER | The charge amount in User entered currency | |||
NONRECOVERABLE_TAX | NUMBER | The non recoverable tax amount for the charge. | |||
ACTIVE_FLAG | VARCHAR2 | 1 | Indicates whether there is more recent information for this charge estimate. Only the most recent record will have this flag set to Y. | ||
TAX_ASSESSABLE_VALUE | NUMBER | Assessable value is the deemed price at which a product is valued, by a tax authority for a given tax, for tax calculation purposes | |||
CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
LAST_UPDATE_DATE | TIMESTAMP | Yes | 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. |
Foreign Keys
Table | Foreign Table | Foreign Key Column |
---|---|---|
CML_TROP_CHARGE_ESTIMATES | cml_trade_operation_charges | TRADE_OPERATION_CHARGE_ID |
Indexes
Index | Uniqueness | Tablespace | Columns |
---|---|---|---|
CML_TROP_CHARGE_ESTIMATES_N1 | Non Unique | Default | ACTIVE_FLAG, TRADE_OPERATION_CHARGE_ID |
CML_TROP_CHARGE_ESTIMATES_PK | Unique | Default | TROP_CHARGE_ESTIMATE_ID |
CML_TROP_CHARGE_ESTIMATES_U1 | Unique | Default | TRADE_OPERATION_CHARGE_ID, ENTERED_DATE |