CST_PAC_PREPROCESS_GT
This global temporary table will be used in PAC Preprocessor for data processing.
Details
-
Schema: FUSION
-
Object owner: CST
-
Object type: TABLE
-
Tablespace: Default
Columns
Name | Datatype | Length | Precision | Comments |
---|---|---|---|---|
TRANSACTION_ID | NUMBER | 18 | Unique identifier for the transaction in costing. | |
COST_ORG_ID | NUMBER | 18 | Identifies the cost organization associated with the inventory organization. | |
COST_BOOK_ID | NUMBER | 18 | Identifies the cost book assigned to the cost organization. | |
INVENTORY_ITEM_ID | NUMBER | 18 | Identifier for the inventory item. | |
VAL_UNIT_ID | NUMBER | 18 | Identifier for the valuation unit. | |
PERIOD_NAME | VARCHAR2 | 15 | Indicates the costing period in which the transaction is processed. | |
QUANTITY | NUMBER | Value that identifies the transaction quantity. | ||
COST_OWNED_FLAG | VARCHAR2 | 1 | Identifies the transaction is cost owned or cost derived. Possible values are: Y- Cost owned transaction. N- Cost derived transaction. | |
BASE_TXN_TYPE_ID | NUMBER | 18 | Inventory transaction type identifier. For origin as INV the value comes from INV_TRANSACTION_TYPES_TL table. | |
BASE_TXN_SOURCE_TYPE_ID | NUMBER | 18 | Inventory transaction source type identifier. For origin as INV the value comes from INV_TXN_SOURCE_TYPES_TL table, but a custom source type is treated as INVENTORY (value>100 is brought in as 13), and for CST it comes from Lookup_type CST_BASE_TXN_SOURCE_TYPES. | |
BASE_TXN_ACTION_ID | NUMBER | 18 | Inventory transaction action identifier. For Origin as INV, the value comes from lookup INV_TRANSACTION_ACTIONS and for Origin as CST the value is from lookup_type CST_BASE_TXN_ACTIONS. | |
WO_COST_ALLOCATION_BASIS | VARCHAR2 | 30 | The basis for cost allocation for output items in a process manufacturing work order. It can be either percentage or fixed value. Valid values exist in lookup ORA_WIS_COST_ALLOC_BASIS. | |
PROVISIONAL_COMPLETION_TYPE | VARCHAR2 | 30 | Work order valuation option for valuing work order partial completions into inventory. Following options will be available: - Value at standard cost (available for all cost methods) - Value at last actual cost (available for actual and perpetual average cost method) - Value at perpetual average cost (available for perpetual average cost method) - Value at prior periodic average cost (available only for periodic average cost method) |