CST_MAX_COST_DATE_GT
Global temporary table that stores max cost date value for a cost-org, cost-book, item, VU combination.
Details
-
Schema: FUSION
-
Object owner: CST
-
Object type: TABLE
-
Tablespace: Default
Columns
Name | Datatype | Length | Precision | Not-null | Comments |
---|---|---|---|---|---|
COST_ORG_ID | NUMBER | 18 | Yes | Identifies the Cost Organization associated with the inventory organization. | |
COST_BOOK_ID | NUMBER | 18 | Yes | Identifies the Cost Book assigned to the Cost Organization. | |
INVENTORY_ITEM_ID | NUMBER | 18 | Yes | The system generated number that uniquely identifies the item for which the max cost date has to be determined. | |
VAL_UNIT_ID | NUMBER | 18 | The system generated number that uniquely identifies the valuation unit. The valuation unit identifier is a part of a unique combination of keys, for which the max cost date has to be determined. | ||
COST_DATE | TIMESTAMP | Date to be used for transaction sequencing. This value, at any given instance will be the greatest of the cost date values from CTL,CLC,CPC,CWC | |||
COST_AVAILABLE_FLAG | VARCHAR2 | 1 | Identifies if the cost is available for the valuation unit. Possible values - Y, N, NULL. |