Itemloc Mfqueue
In ScopeTechnical: ITEMLOC_MFQUEUE | ID: OR-MFCS-ITEMLOC_MFQUEUE
This is a staging table for Item Location messages. It contains snapshots of columns on the item_loc and repl_item_loc tables.
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
- ITEMLOC_MFQUEUE
Field Definitions(36)
Rules & Considerations(20)
Sample Load Data(4)
| _scenario | SEQ_NORPK | EXT_UIN_INDR | MULT_RUNS_PER_DAY_INDR | LOC | ITEM | FAMILY | STATUS | GROUP_ID | LOC_TYPE | UIN_TYPE | SOURCE_WH | THREAD_NO | UIN_LABEL | PUB_STATUS | RANGED_IND | REPL_METHOD | SELLING_UOM | TAXABLE_IND | UNIT_RETAIL | CAPTURE_TIME | MESSAGE_TYPE | PHYSICAL_LOC | PRIMARY_SUPP | PRIMARY_CNTRY | SOURCE_METHOD | RETURNABLE_IND | LOCAL_ITEM_DESC | RECEIVE_AS_TYPE | STORE_PRICE_IND | LOCAL_SHORT_DESC | NEXT_DELIVERY_DATE | CUSTOM_MESSAGE_TYPE | SELLING_UNIT_RETAIL | PRIMARY_REPL_SUPPLIER | REJECT_STORE_ORDER_IND | TRANSACTION_TIME_STAMP |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| default | 2 | N | N | 1 | Itemloc Mfqueue-001 | Itemloc Mfqueue-001 | ACTIVE | 1000000001 | Itemloc Mfqueue-001 | Itemloc Mfqueue-001 | 9001 | 0002 | Itemloc Mfqueue-001 | ACTIVE | Itemloc Mfqueue-001 | Itemloc Mfqueue-001 | Itemloc Mfqueue-001 | Itemloc Mfqueue-001 | 11.0000 | Itemloc Mfqueue-001 | Itemloc Mfqueue-001 | 1 | 1 | Itemloc Mfqueue-001 | Itemloc Mfqueue-001 | Itemloc Mfqueue-001 | Itemloc Mfqueue-001 | Itemloc Mfqueue-001 | N | Itemloc Mfqueue-001 | 2026-01-01 | Itemloc Mfqueue-001 | 11.0000 | 1 | Itemloc Mfqueue-001 | 2026-01-06 |
default
- SEQ_NORPK
- 2
- EXT_UIN_INDR
- N
- MULT_RUNS_PER_DAY_INDR
- N
- LOC
- 1
- ITEM
- Itemloc Mfqueue-001
- FAMILY
- Itemloc Mfqueue-001
- STATUS
- ACTIVE
- GROUP_ID
- 1000000001
- LOC_TYPE
- Itemloc Mfqueue-001
- UIN_TYPE
- Itemloc Mfqueue-001
- SOURCE_WH
- 9001
- THREAD_NO
- 0002
- UIN_LABEL
- Itemloc Mfqueue-001
- PUB_STATUS
- ACTIVE
- RANGED_IND
- Itemloc Mfqueue-001
- REPL_METHOD
- Itemloc Mfqueue-001
- SELLING_UOM
- Itemloc Mfqueue-001
- TAXABLE_IND
- Itemloc Mfqueue-001
- UNIT_RETAIL
- 11.0000
- CAPTURE_TIME
- Itemloc Mfqueue-001
- MESSAGE_TYPE
- Itemloc Mfqueue-001
- PHYSICAL_LOC
- 1
- PRIMARY_SUPP
- 1
- PRIMARY_CNTRY
- Itemloc Mfqueue-001
- SOURCE_METHOD
- Itemloc Mfqueue-001
- RETURNABLE_IND
- Itemloc Mfqueue-001
- LOCAL_ITEM_DESC
- Itemloc Mfqueue-001
- RECEIVE_AS_TYPE
- Itemloc Mfqueue-001
- STORE_PRICE_IND
- N
- LOCAL_SHORT_DESC
- Itemloc Mfqueue-001
- NEXT_DELIVERY_DATE
- 2026-01-01
- CUSTOM_MESSAGE_TYPE
- Itemloc Mfqueue-001
- SELLING_UNIT_RETAIL
- 11.0000
- PRIMARY_REPL_SUPPLIER
- 1
- REJECT_STORE_ORDER_IND
- Itemloc Mfqueue-001
- TRANSACTION_TIME_STAMP
- 2026-01-06