CST_ITEM_COST_SERVICE_VU_GT
Global temporary table used in the bulk processing of item cost service requests. This holds valuation unit and maximum cost date for each layer for ACTUAL cost method.
Details
-
Schema: FUSION
-
Object owner: CST
-
Object type: TABLE
-
Tablespace: Default
Columns
Name | Datatype | Length | Precision | Comments |
---|---|---|---|---|
COST_ORG_ID | NUMBER | 18 | Indicates the cost organization identifier. | |
COST_BOOK_ID | NUMBER | 18 | Indicates the cost book identifier. | |
INVENTORY_ITEM_ID | NUMBER | 18 | Indicates the inventory item identifier. | |
VAL_UNIT_ID | NUMBER | 18 | Indicates the valuation unit identifier. | |
REFERENCE_DATE | TIMESTAMP | Indicates the reference date. It specifies the effective date time for which to retrieve the cost. If null then the system date time is used. | ||
COST_DATE | TIMESTAMP | Cost date used for processing transaction. | ||
UNIT_COST | NUMBER | Current transaction cost for one quantity. | ||
UOM_CODE | VARCHAR2 | 3 | Indicates the target UOM code. This column is optional and can be null. | |
CURRENCY_CODE | VARCHAR2 | 15 | Indicates the target currency code. |
Indexes
Index | Uniqueness | Columns |
---|---|---|
CST_ITEM_COST_SERVICE_VU_GT_U1 | Unique | COST_ORG_ID, COST_BOOK_ID, INVENTORY_ITEM_ID, VAL_UNIT_ID |