Work Stkupld Item Loc Gtt
Out of ScopeTechnical: WORK_STKUPLD_ITEM_LOC_GTT | ID: OR-MFCS-WORK_STKUPLD_ITEM_LOC_GTT
This table is an helper table used in the stock upload process. Information required in the stock upload process from multiple RMS tables are retrieved and stored in this table.
See how this object fits into Item Management
Review the broader sequencing and dependencies for this domain
Migration Details
- Complexity
- Medium
- Sequencing
- Stage 2
- Typical Sources
- ERPLegacy
Target Structure
- Load Approach
- Table
- Target Objects
- WORK_STKUPLD_ITEM_LOC_GTT
Field Definitions(37)
Rules & Considerations(30)
Sample Load Data(4)
| _scenario | SSL_PHYSICAL_COUNT_QUANTITPK | DEPT | ITEM | CLASS | STATUS | CHUNK_ID | LOCATION | PACK_IND | SUBCLASS | ERROR_MSG | ITEM_TYPE | PACK_ITEM | ITEM_LEVEL | PROCESS_ID | TRAN_LEVEL | CYCLE_COUNT | ITEM_STATUS | SELLABLE_IND | INVENTORY_IND | LOCATION_TYPE | ORDERABLE_IND | ITEM_XFORM_IND | STAKE_QUANTITY | STOCKTAKE_TYPE | NEW_ITEMLOC_IND | SIMPLE_PACK_IND | STOCKCOUNT_ITEM | XFORM_ITEM_TYPE | ILS_STOCK_ON_HAND | PHYSICAL_LOCATION | PRODUCT_LEVEL_IND | SSL_PROCESSED_IND | STOCKCOUNT_QUANTITY | LOCATION_DESCRIPTION | PWH_SUM_SNAPSHOT_QTY | SSL_PACK_COMP_QUANTITY | SSL_SNAPSHOT_ON_HAND_QUANTITY |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| default | 11.0000 | 1001 | Work Stkupld Item Loc Gtt-001 | 1101 | ACTIVE | 1000000001 | 1 | Y | 1111 | Work Stkupld Item Loc Gtt-001 | ITM | Work Stkupld Item Loc Gtt-001 | 1 | 1000000001 | 1 | 1 | W | Y | Y | S | Y | Y | 11.0000 | B | Work Stkupld Item Loc Gtt-001 | Y | Work Stkupld Item Loc Gtt-001 | S | 11.0000 | 1 | Work Stkupld Item Loc Gtt-001 | Work Stkupld Item Loc Gtt-001 | 11.0000 | Work Stkupld Item Loc Gtt: Baseline migration row | 11.0000 | 11.0000 | 11.0000 |
default
- SSL_PHYSICAL_COUNT_QUANTITPK
- 11.0000
- DEPT
- 1001
- ITEM
- Work Stkupld Item Loc Gtt-001
- CLASS
- 1101
- STATUS
- ACTIVE
- CHUNK_ID
- 1000000001
- LOCATION
- 1
- PACK_IND
- Y
- SUBCLASS
- 1111
- ERROR_MSG
- Work Stkupld Item Loc Gtt-001
- ITEM_TYPE
- ITM
- PACK_ITEM
- Work Stkupld Item Loc Gtt-001
- ITEM_LEVEL
- 1
- PROCESS_ID
- 1000000001
- TRAN_LEVEL
- 1
- CYCLE_COUNT
- 1
- ITEM_STATUS
- W
- SELLABLE_IND
- Y
- INVENTORY_IND
- Y
- LOCATION_TYPE
- S
- ORDERABLE_IND
- Y
- ITEM_XFORM_IND
- Y
- STAKE_QUANTITY
- 11.0000
- STOCKTAKE_TYPE
- B
- NEW_ITEMLOC_IND
- Work Stkupld Item Loc Gtt-001
- SIMPLE_PACK_IND
- Y
- STOCKCOUNT_ITEM
- Work Stkupld Item Loc Gtt-001
- XFORM_ITEM_TYPE
- S
- ILS_STOCK_ON_HAND
- 11.0000
- PHYSICAL_LOCATION
- 1
- PRODUCT_LEVEL_IND
- Work Stkupld Item Loc Gtt-001
- SSL_PROCESSED_IND
- Work Stkupld Item Loc Gtt-001
- STOCKCOUNT_QUANTITY
- 11.0000
- LOCATION_DESCRIPTION
- Work Stkupld Item Loc Gtt: Baseline migration row
- PWH_SUM_SNAPSHOT_QTY
- 11.0000
- SSL_PACK_COMP_QUANTITY
- 11.0000
- SSL_SNAPSHOT_ON_HAND_QUANTITY
- 11.0000