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(36)
Rules & Considerations(38)
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | 1 | S | S | 1 | SAMPLE | SAMPLE | S | 1 | S | SAMPLE | 1 | 1 | SAMPLE | S | S | SAMPLE | SAMP | S | 1.0000 | SAMPLE | SAMPLE | 1 | 1 | SAM | S | S | SAMPLE | S | S | SAMPLE | 2026-01-01 | S | 1.0000 | 1 | S | 2026-01-01 |
Example values from field definitions
- SEQ_NORPK
- 1
- EXT_UIN_INDR
- S
- MULT_RUNS_PER_DAY_INDR
- S
- 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
- 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
- PRIMARY_REPL_SUPPLIER
- 1
- REJECT_STORE_ORDER_IND
- S
- TRANSACTION_TIME_STAMP
- 2026-01-01
Rule Validation Summary
- Source Rule Count
- 50
- Governed Rule Count
- 38