Supplier Mfqueue
In ScopeTechnical: SUPPLIER_MFQUEUE | ID: OR-SUP-SUPPLIER_MFQUEUE-SUPPLIER_MFQUEUE
Staging table for suppliers. It supports controlled ingestion, validation, and downstream batch processing.
See how this object fits into Supplier 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
- SUPPLIER_MFQUEUE
Field Definitions(5)
Rules & Considerations(14)
Sample Load Data(4)
| _scenario | SEQ_NORPK | FAMILY | MESSAGE | GROUP_ID | SUPPLIER | ADDR_TYPE | THREAD_NO | PUB_STATUS | ADDR_SEQ_NO | ORG_UNIT_ID | MESSAGE_TYPE | RET_ALLOW_IND | TRANSACTION_NUMBER | TRANSACTION_TIME_STAMP |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | 1 | SAMPLE | Sample text | 1 | 1 | SA | 1 | S | 1 | 1 | SAMPLE | SA | 1 | 2026-01-01 |
| Closed supplier record due to compliance issues | 2 | Merchandise | — | 2 | 2 | BL | 1 | N | 5 | 2 | BDD | N | 2 | 2025-05-30 |
| New record with minimal optional data | 3 | — | — | 2 | — | — | — | — | — | 3 | — | — | 3 | — |
Example values from field definitions
- SEQ_NORPK
- 1
- FAMILY
- SAMPLE
- MESSAGE
- Sample text
- GROUP_ID
- 1
- SUPPLIER
- 1
- ADDR_TYPE
- SA
- THREAD_NO
- 1
- PUB_STATUS
- S
- ADDR_SEQ_NO
- 1
- ORG_UNIT_ID
- 1
- MESSAGE_TYPE
- SAMPLE
- RET_ALLOW_IND
- SA
- TRANSACTION_NUMBER
- 1
- TRANSACTION_TIME_STAMP
- 2026-01-01
Closed supplier record due to compliance issues
- SEQ_NORPK
- 2
- FAMILY
- Merchandise
- MESSAGE
- —
- GROUP_ID
- 2
- SUPPLIER
- 2
- ADDR_TYPE
- BL
- THREAD_NO
- 1
- PUB_STATUS
- N
- ADDR_SEQ_NO
- 5
- ORG_UNIT_ID
- 2
- MESSAGE_TYPE
- BDD
- RET_ALLOW_IND
- N
- TRANSACTION_NUMBER
- 2
- TRANSACTION_TIME_STAMP
- 2025-05-30
New record with minimal optional data
- SEQ_NORPK
- 3
- FAMILY
- —
- MESSAGE
- —
- GROUP_ID
- 2
- SUPPLIER
- —
- ADDR_TYPE
- —
- THREAD_NO
- —
- PUB_STATUS
- —
- ADDR_SEQ_NO
- —
- ORG_UNIT_ID
- 3
- MESSAGE_TYPE
- —
- RET_ALLOW_IND
- —
- TRANSACTION_NUMBER
- 3
- TRANSACTION_TIME_STAMP
- —
Rule Validation Summary
- Source Rule Count
- 26
- Governed Rule Count
- 14