CST_ATTR_ONHAND_SUMMARY_S_GT
Global temporary table used by the reports processor to summarize valuation data.
Details
-
Schema: FUSION
-
Object owner: CST
-
Object type: TABLE
-
Tablespace: Default
Columns
| Name | Datatype | Length | Precision | Comments |
|---|---|---|---|---|
| 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. | |
| VAL_UNIT_ID | NUMBER | 18 | Identifier for the valuation unit. | |
| INVENTORY_ORG_ID | NUMBER | 18 | Indicates the inventory organization to which the item belongs. | |
| SUBINVENTORY_CODE | VARCHAR2 | 10 | Indicates the subinventory code where the item is stored. | |
| VAL_STRUCTURE_TYPE_CODE | VARCHAR2 | 30 | Indicates the valuation structure type. | |
| PERIOD_NAME | VARCHAR2 | 15 | Indicates the period in which the valuation exists. | |
| PERIOD_START_DATE | DATE | Indicates the start date of the period. | ||
| PERIOD_END_DATE | DATE | Indicates the end date of the period. | ||
| PRIOR_PERIOD_NAME | VARCHAR2 | 15 | Indicates the prior period in which the valuation exists. | |
| PRIOR_PERIOD_START_DATE | DATE | Indicates the start date of the prior period. | ||
| PRIOR_PERIOD_END_DATE | DATE | Indicates the end date of the prior period. | ||
| INVENTORY_VALUE | NUMBER | Indicates the inventory valuation for the period. | ||
| PRIOR_INVENTORY_VALUE | NUMBER | Indicates the inventory valuation for the prior period. | ||
| COSTED_AMOUNT | NUMBER | Indicates the costed amount of the item. | ||
| COSTED_WRITEOFF_AMOUNT | NUMBER | Indicates the costed amount in write-off instead of inventory. | ||
| PRIOR_COSTED_AMOUNT | NUMBER | Indicates the costed amount of the item for the prior period. | ||
| PRIOR_COSTED_WRITEOFF_AMOUNT | NUMBER | Indicates the costed amount in write-off instead of inventory for the prior period. | ||
| ACCTD_AMOUNT | NUMBER | Indicates the amount that is final accounted. | ||
| ACCTD_WRITEOFF_AMOUNT | NUMBER | Indicates the amount in write-off that should be in inventory and is final accounted. | ||
| PRIOR_ACCTD_AMOUNT | NUMBER | Indicates the amount that is final accounted for the prior period. | ||
| PRIOR_ACCTD_WRITEOFF_AMOUNT | NUMBER | Indicates the amount in write-off that should be in inventory and is final accounted for the prior period. |
Indexes
| Index | Uniqueness | Columns |
|---|---|---|
| CST_ATTR_ONHAND_SUM_S_GT_N1 | Non Unique | PERIOD_NAME, COST_BOOK_ID, COST_ORG_ID, INVENTORY_ORG_ID, SUBINVENTORY_CODE, VAL_UNIT_ID |