CST_ITEM_COST_PROFILE_TXNS_GT
The table is used by Quantity PreProcessor to identify the that need new item cost profile created.
Details
-
Schema: FUSION
-
Object owner: CST
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| CST_INV_TRANSACTION_ID | NUMBER | 18 | Yes | Costing inventory transaction identifier | |
| COST_ORG_ID | NUMBER | 18 | Yes | Cost organization identifier | |
| COST_BOOK_ID | NUMBER | 18 | Yes | Cost book identifier | |
| MASTER_ORGANIZATION_ID | NUMBER | 18 | Yes | Item master organization identifier | |
| INVENTORY_ITEM_ID | NUMBER | 18 | Yes | Inevntory item identifier | |
| COST_PROFILE_TYPE_FLAG | VARCHAR2 | 1 | Yes | Denotes the kind of item cost profile needed by the transaction. Possible values are (A)sset, (E)xpense or (C)onsigned | |
| BASE_TXN_SOURCE_TYPE_ID | NUMBER | 18 | Yes | Inventory transaction source type identifier. For origin as INV the value comes from INV_TXN_SOURCE_TYPES_TL table, and for CST it comes from Lookup_type CST_BASE_TXN_SOURCE_TYPES | |
| BASE_TXN_ACTION_ID | NUMBER | 18 | Yes | 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. |
Indexes
| Index | Uniqueness | Columns |
|---|---|---|
| CST_ITEM_COST_PROFILE_TXN_N1 | Non Unique | INVENTORY_ITEM_ID |
| CST_ITEM_COST_PROFILE_TXN_U1 | Unique | CST_INV_TRANSACTION_ID, COST_ORG_ID, COST_BOOK_ID |