CST_AND_INV_ONHAND_GT
This table gets the inventory and costing onhand data ready for mismatch 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 | 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. | |
| EXTERNAL_SYSTEM_REFERENCE | VARCHAR2 | 60 | Yes | Identifies the external source syste | |
| INVENTORY_ORG_ID | NUMBER | 18 | Yes | Indicates The Inventory Org To Which The Item Belongs | |
| INVENTORY_ITEM_ID | NUMBER | 18 | Yes | Inventory Item Identifier | |
| SUBINVENTORY_CODE | VARCHAR2 | 30 | The subinventory code where the item is stored | ||
| LOCATOR_ID | NUMBER | 18 | Inventory locator identifier | ||
| LOT_NUMBER | VARCHAR2 | 80 | The lot number of the item | ||
| SERIAL_NUMBER | VARCHAR2 | 80 | The serial number of the item | ||
| GRADE_CODE | VARCHAR2 | 150 | Grade of the Lot for a grade controlled Item | ||
| EXPENSE_ONHAND_FLAG | VARCHAR2 | 1 | Yes | Indicates whether or not this onhand is for a expense item or from a expense SubInventory | |
| VAL_UNIT_ID | NUMBER | 18 | Valuation unit identifier | ||
| INV_CALC_ONHAND_QTY | NUMBER | The current onhand quantity of the item at Inventory in primary unit of measure | |||
| INV_UNSENT_TXN_QTY | NUMBER | The sum of quantity from transactions not sent to costing in primary unit of measure | |||
| INV_UOM_CODE | VARCHAR2 | 3 | The primary unit of measure for Inv quantities | ||
| CST_UNPROCESSED_QTY | NUMBER | Unprocessed transaction quantity | |||
| CST_UNPROCESSED_SEC_QTY | NUMBER | Unprocessed quantity in secondary UOM | |||
| CST_CT_ERROR_QTY | NUMBER | Sum of transaction quantity for transactions in error status | |||
| CST_CT_ERROR_SEC_QTY | NUMBER | Sum of transaction quantity for transactions in error status in secondary unit of measure | |||
| CST_INTERFACE_ERROR_QTY | NUMBER | Sum of primary quantity for interfaced transactions in error status | |||
| CST_INTERFACE_ERROR_SEC_QTY | NUMBER | Sum of quantity in secondary unit of measure for interfaced transactions in error status | |||
| CST_INTERFACE_UNPROCESSED_QTY | NUMBER | Sum of primary quantity for interfaced transactions | |||
| CST_INTF_UNPROC_SEC_QTY | NUMBER | Sum of secondary quantity for interfaced transactions | |||
| CST_CT_UNCOSTED_QTY | NUMBER | The quantity in successfully preprocessed transaction in CST_TRANSACTIONS that is pending costing. | |||
| UNPROCESSED_ERROR_QTY_UOM_CODE | VARCHAR2 | 3 | Unit of measure for the total quantity of unprocessed transactions for the item. | ||
| SEC_UOM_CODE | VARCHAR2 | 3 | Secondary UOM code | ||
| CST_UOM_CODE | VARCHAR2 | 3 | The unit of measure for costing quantities | ||
| UOM_CONVERSION_FACTOR | NUMBER | UOM Conversion factor between inventory UOM and costing UOM | |||
| INV_CALC_SEC_ONHAND_QTY | NUMBER | The current onhand quantity of the item at Inventory in secondary unit of measure | |||
| INV_UNSENT_TXN_SEC_QTY | NUMBER | The sum of quantity from transactions not sent to costing in secondary unit of measure | |||
| INV_SEC_UOM_CODE | VARCHAR2 | 3 | The primary unit of measure for Inv quantities |