CST_TXNS_NO_STANDARD_COST_GT
The table holds the transactions that do not have standard costs available for them. If This information is used to generate standard costs from reference standard cost records.
Details
-
Schema: FUSION
-
Object owner: CST
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Columns
| Name | Datatype | Precision | Not-null | Comments |
|---|---|---|---|---|
| COST_ORG_ID | NUMBER | 18 | Yes | Identifies the cost organization |
| COST_BOOK_ID | NUMBER | 18 | Yes | Identifies the cost book |
| INVENTORY_ORG_ID | NUMBER | 18 | Yes | Surrogate ID identifying the inventory_organization. |
| INVENTORY_ITEM_ID | NUMBER | 18 | Yes | Identifies the inventory item |
| VAL_UNIT_ID | NUMBER | 18 | Yes | Identifies the valuation unit |
| COST_DATE | DATE | Yes | The cost date of the transaction as stamped on the transaction layers. | |
| VAL_STRUCTURE_ID | NUMBER | 18 | Yes | Identifies the valuation structure |
| COST_PROFILE_ID | NUMBER | 18 | Yes | Identifies the cost profile |