CST_COMPARE_COSTS_GT
Compare Costs - Global Temporary Table
Details
-
Schema: FUSION
-
Object owner: CST
-
Object type: TABLE
-
Tablespace: Default
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| COMPARE_SET_CODE | VARCHAR2 | 30 | Yes | COMPARE_SET_CODE | |
| COST_PROFILE_CODE | VARCHAR2 | 30 | COST_PROFILE | ||
| RECEIPT_NUM | VARCHAR2 | 30 | RECEIPT_NUM | ||
| CURRENCY_CODE | VARCHAR2 | 30 | CURRENCY_CODE | ||
| UOM_CODE | VARCHAR2 | 30 | UOM_CODE | ||
| ITEM_NUMBER | VARCHAR2 | 300 | ITEM_NUMBER | ||
| COST_ORG_NAME | VARCHAR2 | 240 | COST_ORG_NAME | ||
| COST_BOOK_CODE | VARCHAR2 | 30 | COST_BOOK_CODE | ||
| VAL_UNIT_CODE | VARCHAR2 | 1000 | VAL_UNIT_CODE | ||
| COST_ORG_ID | NUMBER | 18 | Yes | Single column FK: Identifies the Cost Organization associated with the inventory organization. | |
| COST_BOOK_ID | NUMBER | 18 | Yes | Single column FK: Identifies the Cost Book assigned to the Cost Organization. | |
| INVENTORY_ITEM_ID | NUMBER | 18 | Yes | Inventory Item Identifier | |
| COST_METHOD_CODE | VARCHAR2 | 30 | Yes | The cost method code like PERPETUAL AVERAGE, FIFO etc. Value comes from lookup_type CST_COST_METHODS | |
| VAL_UNIT_ID | NUMBER | 18 | Yes | Valuation unit identifier | |
| COST_DATE | TIMESTAMP | Yes | Transaciton Cost Date | ||
| TRANSACTION_ID | NUMBER | 18 | Yes | Single column FK: Identifies the costing transaction. | |
| TOTAL_COST | NUMBER | TOTAL_COST |
Indexes
| Index | Uniqueness | Columns | Status |
|---|---|---|---|
| CST_COMPARE_COSTS_GT_U1 | Unique | COST_ORG_ID, COST_BOOK_ID, INVENTORY_ITEM_ID, COST_METHOD_CODE, VAL_UNIT_ID, TRANSACTION_ID, COST_DATE | Obsolete |