CST_PAC_WO_INPUT_COSTS_GT
This transaction global temporary table will be used by PAC Processor to store the cost information of work orders input transactions that are processed in the current period.
Details
-
Schema: FUSION
-
Object owner: CST
-
Object type: TABLE
-
Tablespace: Default
Columns
Name | Datatype | Length | Precision | Not-null | Comments |
---|---|---|---|---|---|
MAX_TRANSACTION_ID | NUMBER | 18 | Yes | Maximum transaction identifier for the set of work order input transactions grouped by cost organization, cost book, inventory item, valuation unit, period name, inventory organization, costing work order identifier, costing work order operation identifier, cost transaction type, transaction source type, transaction action and transaction type. | |
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 | Period in which the transaction is processed. This value is populated for the transactions in periodic average cost method. | ||
CST_WORK_ORDER_ID | NUMBER | 18 | Surrogate identifying a work order uniquely in costing. | ||
CST_WORK_ORDER_OPERATION_ID | NUMBER | 18 | Surrogate identifying a work order operation associated with the transaction in costing. | ||
QUANTITY | NUMBER | Sum of quantity for the set of work order input transactions grouped by cost organization, cost book, inventory item, valuation unit, period name, inventory organization, costing work order identifier, costing work order operation identifier, cost transaction type, transaction source type, transaction action and transaction type. | |||
COST_ELEMENT_ID | NUMBER | 18 | Unique identifier for the cost element. | ||
EXPENSE_POOL_ID | NUMBER | 18 | Unique identifier for the expense pool. | ||
UNIT_COST | NUMBER | Indicates the unit cost of the cost element. |