CST_INV_QTY_LAST_RECORD_GT
Used to stage data for inventory valuation delta calculation
Details
-
Schema: FUSION
-
Object owner: CST
-
Object type: TABLE
-
Tablespace: Default
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| COST_ORG_ID | NUMBER | 18 | Yes | COST_ORG_ID | |
| COST_BOOK_ID | NUMBER | 18 | Yes | COST_BOOK_ID | |
| VAL_UNIT_ID | NUMBER | 18 | VAL_UNIT_ID | ||
| INVENTORY_ITEM_ID | NUMBER | 18 | Yes | INVENTORY_ITEM_ID | |
| SNAPSHOT_DATE | DATE | Yes | SNAPSHOT_DATE | ||
| BUSINESS_UNIT_ID | NUMBER | 18 | BUSINESS_UNIT_ID | ||
| INVENTORY_ORG_ID | NUMBER | 18 | Yes | INVENTORY_ORG_ID | |
| SUBINVENTORY_CODE | VARCHAR2 | 10 | SUBINVENTORY_CODE | ||
| LOCATOR_ID | NUMBER | 18 | LOCATOR_ID | ||
| QUANTITY | NUMBER | QUANTITY | |||
| UOM_CODE | VARCHAR2 | 3 | UOM_CODE | ||
| EFF_TO_DATE | DATE | EFF_TO_DATE | |||
| TRANSFER_COST_ORG_ID | NUMBER | 18 | TRANSFER_COST_ORG_ID | ||
| TRANSFER_BOOK_ID | NUMBER | 18 | TRANSFER_BOOK_ID | ||
| TRANSFER_INVENTORY_ORG_ID | NUMBER | 18 | TRANSFER_INVENTORY_ORG_ID | ||
| TRANSFER_SUBINVENTORY_CODE | VARCHAR2 | 10 | TRANSFER_SUBINVENTORY_CODE | ||
| TRANSFER_LOCATOR_ID | NUMBER | 18 | TRANSFER_LOCATOR_ID | ||
| AMOUNT | NUMBER | AMOUNT | |||
| FOB_POINT | NUMBER | 1 | FOB_POINT |
Indexes
| Index | Uniqueness | Columns |
|---|---|---|
| CST_INV_QTY_LAST_RECORD_GT_N1 | Non Unique | COST_ORG_ID, COST_BOOK_ID, INVENTORY_ITEM_ID, VAL_UNIT_ID, INVENTORY_ORG_ID, SUBINVENTORY_CODE, SNAPSHOT_DATE |