Itemloc Mfqueue
In ScopeTechnical: ITEMLOC_MFQUEUE | ID: OR-ITM-ITEMLOC_MFQUEUE-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
Classification
- Object Type
- dictionary
Target Structure
- Load Approach
- Table
- Target Objects
- ITEMLOC_MFQUEUE
Field Definitions(5)
Rules & Considerations(38)
constraint
validation
Sample Load Data(4)
| _scenario | SEQ_NORPK | LOC | ITEM | FAMILY | STATUS | GROUP_ID | LOC_TYPE | UIN_TYPE | SOURCE_WH | THREAD_NO | UIN_LABEL | PUB_STATUS | RANGED_IND | EXT_UIN_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 | MULT_RUNS_PER_DAY_IND | PRIMARY_REPL_SUPPLIER | REJECT_STORE_ORDER_IND | TRANSACTION_TIME_STAMP |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | 1 | 1 | SAMPLE | SAMPLE | S | 1 | S | SAMPLE | 1 | 1 | SAMPLE | S | S | S | SAMPLE | SAMP | S | 1.0000 | SAMPLE | SAMPLE | 1 | 1 | SAM | S | S | SAMPLE | S | S | SAMPLE | 2026-01-01 | S | 1.0000 | S | 1 | S | 2026-01-01 |
| default | 4 | 3 | Itemloc Mfqueue-002-ALT | Itemloc Mfqueue-002-ALT | P | 1000000003 | I | Itemlo | 9003 | 4 | Itemlo | P | I | N | Itemlo | Item | I | 12.5000 | Itemlo | Itemloc Mfqueue | 3 | 3 | Ite | I | I | Itemloc Mfqueue-002-ALT | I | N | Itemloc Mfqueue-002-ALT | 2026-01-03 | I | 12.5000 | N | 3 | I | 2026-02-09 |
| default | 6 | 5 | Itemloc Mfqueue-003-EDGE | Itemloc Mfqueue-003-EDGE | A | 1000000005 | I | Itemlo | 9005 | 6 | Itemlo | A | I | N | Itemlo | Item | I | 14.0000 | Itemlo | Itemloc Mfqueue | 5 | 5 | Ite | I | I | Itemloc Mfqueue-003-EDGE | I | N | Itemloc Mfqueue-003-EDGE | 2026-01-05 | I | 14.0000 | N | 5 | I | 2026-03-12 |
Example values from field definitions
- SEQ_NORPK
- 1
- LOC
- 1
- ITEM
- SAMPLE
- FAMILY
- SAMPLE
- STATUS
- S
- GROUP_ID
- 1
- LOC_TYPE
- S
- UIN_TYPE
- SAMPLE
- SOURCE_WH
- 1
- THREAD_NO
- 1
- UIN_LABEL
- SAMPLE
- PUB_STATUS
- S
- RANGED_IND
- S
- EXT_UIN_IND
- S
- REPL_METHOD
- SAMPLE
- SELLING_UOM
- SAMP
- TAXABLE_IND
- S
- UNIT_RETAIL
- 1.0000
- CAPTURE_TIME
- SAMPLE
- MESSAGE_TYPE
- SAMPLE
- PHYSICAL_LOC
- 1
- PRIMARY_SUPP
- 1
- PRIMARY_CNTRY
- SAM
- SOURCE_METHOD
- S
- RETURNABLE_IND
- S
- LOCAL_ITEM_DESC
- SAMPLE
- RECEIVE_AS_TYPE
- S
- STORE_PRICE_IND
- S
- LOCAL_SHORT_DESC
- SAMPLE
- NEXT_DELIVERY_DATE
- 2026-01-01
- CUSTOM_MESSAGE_TYPE
- S
- SELLING_UNIT_RETAIL
- 1.0000
- MULT_RUNS_PER_DAY_IND
- S
- PRIMARY_REPL_SUPPLIER
- 1
- REJECT_STORE_ORDER_IND
- S
- TRANSACTION_TIME_STAMP
- 2026-01-01
default
- SEQ_NORPK
- 4
- LOC
- 3
- ITEM
- Itemloc Mfqueue-002-ALT
- FAMILY
- Itemloc Mfqueue-002-ALT
- STATUS
- P
- GROUP_ID
- 1000000003
- LOC_TYPE
- I
- UIN_TYPE
- Itemlo
- SOURCE_WH
- 9003
- THREAD_NO
- 4
- UIN_LABEL
- Itemlo
- PUB_STATUS
- P
- RANGED_IND
- I
- EXT_UIN_IND
- N
- REPL_METHOD
- Itemlo
- SELLING_UOM
- Item
- TAXABLE_IND
- I
- UNIT_RETAIL
- 12.5000
- CAPTURE_TIME
- Itemlo
- MESSAGE_TYPE
- Itemloc Mfqueue
- PHYSICAL_LOC
- 3
- PRIMARY_SUPP
- 3
- PRIMARY_CNTRY
- Ite
- SOURCE_METHOD
- I
- RETURNABLE_IND
- I
- LOCAL_ITEM_DESC
- Itemloc Mfqueue-002-ALT
- RECEIVE_AS_TYPE
- I
- STORE_PRICE_IND
- N
- LOCAL_SHORT_DESC
- Itemloc Mfqueue-002-ALT
- NEXT_DELIVERY_DATE
- 2026-01-03
- CUSTOM_MESSAGE_TYPE
- I
- SELLING_UNIT_RETAIL
- 12.5000
- MULT_RUNS_PER_DAY_IND
- N
- PRIMARY_REPL_SUPPLIER
- 3
- REJECT_STORE_ORDER_IND
- I
- TRANSACTION_TIME_STAMP
- 2026-02-09
default
- SEQ_NORPK
- 6
- LOC
- 5
- ITEM
- Itemloc Mfqueue-003-EDGE
- FAMILY
- Itemloc Mfqueue-003-EDGE
- STATUS
- A
- GROUP_ID
- 1000000005
- LOC_TYPE
- I
- UIN_TYPE
- Itemlo
- SOURCE_WH
- 9005
- THREAD_NO
- 6
- UIN_LABEL
- Itemlo
- PUB_STATUS
- A
- RANGED_IND
- I
- EXT_UIN_IND
- N
- REPL_METHOD
- Itemlo
- SELLING_UOM
- Item
- TAXABLE_IND
- I
- UNIT_RETAIL
- 14.0000
- CAPTURE_TIME
- Itemlo
- MESSAGE_TYPE
- Itemloc Mfqueue
- PHYSICAL_LOC
- 5
- PRIMARY_SUPP
- 5
- PRIMARY_CNTRY
- Ite
- SOURCE_METHOD
- I
- RETURNABLE_IND
- I
- LOCAL_ITEM_DESC
- Itemloc Mfqueue-003-EDGE
- RECEIVE_AS_TYPE
- I
- STORE_PRICE_IND
- N
- LOCAL_SHORT_DESC
- Itemloc Mfqueue-003-EDGE
- NEXT_DELIVERY_DATE
- 2026-01-05
- CUSTOM_MESSAGE_TYPE
- I
- SELLING_UNIT_RETAIL
- 14.0000
- MULT_RUNS_PER_DAY_IND
- N
- PRIMARY_REPL_SUPPLIER
- 5
- REJECT_STORE_ORDER_IND
- I
- TRANSACTION_TIME_STAMP
- 2026-03-12
Rule Validation Summary
- Source Rule Count
- 50
- Governed Rule Count
- 38