CST_DEPSWO_GT
Depletions at a cost ex. RTV and other issues at a cost
Details
-
Schema: FUSION
-
Object owner: CST
-
Object type: TABLE
-
Tablespace: Default
Columns
Name | Datatype | Length | Precision | Not-null | Comments |
---|---|---|---|---|---|
TRANSACTION_ID | NUMBER | 18 | Yes | Single column FK: Identifies the costing transaction. | |
REC_TRXN_ID | NUMBER | 18 | Yes | Receipt Transaction Identifyer | |
DEP_TRXN_ID | NUMBER | 18 | Yes | Deplete Transaction Identifyer | |
COST_ELEMENT_ID | NUMBER | 18 | Yes | Cost element corresponding to the cost of the transaction. | |
EXPENSE_POOL_ID | NUMBER | 18 | Expense pool corresponding to the cost of the transaction. | ||
EFF_DATE | TIMESTAMP | Yes | The effective date of the cost record. It is the date when the cost became in effect for the transaction. For new costs, this value is the date of the transaction. For adjustments, this value is the user entered effective date, which may or may not be the UI adjustment transaction date, or the date of the incoming adjustment from upstream sources. | ||
COST_DATE | TIMESTAMP | This column holds the cost date for the adjustment costs. | |||
CURRENCY_CODE | VARCHAR2 | 15 | Identifies the currency of the transaction / cost. | ||
UNIT_COST_AVG | NUMBER | Current Average Cost | |||
UNIT_COST_ACT | NUMBER | Actual RTV cost | |||
UNIT_COST_WO | NUMBER | Wrietoff cost difference |