CST_PAC_OVERHEADS_GT
This global temporary table will be used in PAC Preprocessor for overheads processing.
Details
-
Schema: FUSION
-
Object owner: CST
-
Object type: TABLE
-
Tablespace: cst_pac_overheads_gt
Columns
| Name | Datatype | Length | Precision | Comments |
|---|---|---|---|---|
| RULE_ID | NUMBER | 18 | Rule Identifier. Foreign key reference from CST_OVERHEAD_RULES table. | |
| RULE_DETAIL_ID | NUMBER | 18 | Rule Detail Identifier. Foreign key reference from CST_OVERHEAD_RULE_DETAILS table. | |
| COST_ORG_ID | NUMBER | 18 | Single column FK: Identifies the Cost Organization associated with the inventory organization. | |
| COST_BOOK_ID | NUMBER | 18 | Single column FK: Identifies the Cost Book assigned to the Cost Organization. | |
| INVENTORY_ITEM_ID | NUMBER | 18 | Value that identifies the inventory item associated with the transaction. | |
| PERIOD_NAME | VARCHAR2 | 15 | Period for which cost processor is run. This value is populated for the transactions in periodic average cost method. | |
| ABSORPTION_TYPE | VARCHAR2 | 3 | This column indicates how the overhead gets absorbed. Valid values come from lookup type CST_ABSORPTION_TYPE. |