CML_TROP_CHARGE_ACTUALS
This table stores the actual landed cost charges in a trade operation at charge level.
Details
-
Schema: FUSION
-
Object owner: CML
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
CML_TROP_CHARGE_ACTUALS_PK |
TROP_CHARGE_ACTUAL_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| TROP_CHARGE_ACTUAL_ID | NUMBER | 18 | Yes | Surrogate key that identifies the trade operation charge actual. | |
| TRADE_OPERATION_CHARGE_ID | NUMBER | 18 | Yes | Foreign Key that identifies a trade operation charge line. | |
| ENTERED_DATE | TIMESTAMP | Yes | The system date on which the actual is established/updated. The entered Date is to keep track of updates to the charge actuals. Instead of overwriting the history, changes to actuals are tracked by creating new records every time the charge actual amount is changed. | ||
| TROP_DOC_CURRENCY_CODE | VARCHAR2 | 15 | Yes | The currency in which estimate is calculated. | |
| AMOUNT_IN_TROP_DOC_CURR | NUMBER | The total charge amount for the trade operation charge line. | |||
| NR_TAX_IN_TROP_DOC_CURR | NUMBER | The non recoverable tax amount for the trade operation charge line. | |||
| ACTIVE_FLAG | VARCHAR2 | 1 | Indicates whether there is more recent information for this charge actual. Only the most recent record will have this flag set to Y. | ||
| 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. | |
| 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. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| CML_TROP_CHARGE_ACTUALS_N1 | Non Unique | Default | ACTIVE_FLAG, TRADE_OPERATION_CHARGE_ID |
| CML_TROP_CHARGE_ACTUALS_U1 | Unique | Default | TROP_CHARGE_ACTUAL_ID |
| CML_TROP_CHARGE_ACTUALS_U2 | Unique | Default | TRADE_OPERATION_CHARGE_ID, ENTERED_DATE |