CST_INV_QTY_MIN_DATE_GT
在庫評価デルタ計算のデータのステージングに使用
詳細
-
スキーマ: FUSION
-
オブジェクト所有者: CST
-
オブジェクト・タイプ: TABLE
-
表領域: Default
列
| 名前 | データ型 | 長さ | 精度 | 非null | コメント |
|---|---|---|---|---|---|
| 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 | |
| MIN_DATE | DATE | Yes | MIN_DATE | ||
| INVENTORY_ORG_ID | NUMBER | 18 | Yes | INVENTORY_ORG_ID | |
| SUBINVENTORY_CODE | VARCHAR2 | 10 | SUBINVENTORY_CODE | ||
| LOCATOR_ID | NUMBER | 18 | LOCATOR_ID | ||
| 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 | ||
| FOB_POINT | NUMBER | 1 | FOB_POINT |
索引
| 索引 | 一意性 | 列 |
|---|---|---|
| CST_INV_QTY_MIN_DATE_GT_N1 | 一意でない | COST_ORG_ID, COST_BOOK_ID, INVENTORY_ITEM_ID, VAL_UNIT_ID, INVENTORY_ORG_ID, SUBINVENTORY_CODE |