One Row For Each Supplier
In ScopeTechnical: SUPS | ID: OR-SUP-SUPS-SUPS
Stores one row for each supplier within the company. When ever a supplier name etc.
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
- SUPS
Field Definitions(79)
Rules & Considerations(129)
constraint
validation
Sample Load Data(4)
| _scenario | LANGRPK | TERMSRPK | QC_INDR | VC_INDR | DSD_INDR | EDI_ASNR | SUPPLIERRPK | SUP_NAMER | CREATE_IDR | EDI_PO_CHGR | EDI_PO_INDR | SUP_STATUSR | VAT_REGIONRPK | CONTACT_NAMER | EDI_INVC_INDR | PRE_MARK_INDR | RET_AUTH_REQR | BACKORDER_INDR | CONTACT_PHONER | CURRENCY_CODERPK | FREIGHT_TERMSRPK | RET_ALLOW_INDR | SUP_QTY_LEVELR | EDI_CHANNEL_IDRPK | EDI_PO_CONFIRMR | FINAL_DEST_INDR | LAST_UPDATE_IDR | CREATE_DATETIMER | DELIVERY_POLICYR | PREPAY_INVC_INDR | SETTLEMENT_CODER | SUPPLIER_PARENTRPK | EDI_CONTRACT_INDR | PAYMENT_SITE_INDR | SCALE_AIP_ORDERSR | AUTO_APPR_INVC_INDR | FREIGHT_CHARGE_INDR | BRACKET_COSTING_INDR | REPLEN_APPROVAL_INDR | LAST_UPDATE_DATETIMER | PROCUREMENT_SITE_INDR | SERVICE_PERF_REQ_INDR | AUTO_APPR_DBT_MEMO_INDR | EDI_SUPP_AVAILABLE_INDR | QC_PCT | TAX_ID | VC_PCT | QC_FREQ | VC_FREQ | DUNS_LOC | CONTACT_FAX | DUNS_NUMBER | RET_COURIER | SHIP_METHOD | COMMENT_DESC | HANDLING_PCT | INVC_PAY_LOC | INV_MGMT_LVL | CONTACT_EMAIL | CONTACT_PAGER | CONTACT_TELEX | DBT_MEMO_CODE | PAYMENT_METHOD | EXTERNAL_REF_ID | RET_MIN_DOL_AMT | COST_CHG_AMT_VAR | COST_CHG_PCT_VAR | INVC_RECEIVE_LOC | VMI_ORDER_STATUS | ADDINVC_GROSS_NET | GEN_CONSIGN_ORDER | STATUS_UPD_BY_RMS | DEAL_UPLOAD_STATUS | EDI_SALES_RPT_FREQ | SUP_NAME_SECONDARY | DEFAULT_PAY_SITE_ID | GEN_CONSIGN_INVOICE | DEFAULT_ITEM_LEAD_TIME | DEFAULT_PRICING_CONTROL |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | 1 | SAMPLE | S | S | S | S | 1 | SAMPLE | SAMPLE | S | S | S | 1 | SAMPLE | S | S | S | S | SAMPLE | SAM | SAMPLE | S | SAMPLE | 1 | S | S | SAMPLE | 2026-01-01 | SAMPLE | S | S | 1 | S | S | S | S | S | S | S | 2026-01-01 | S | S | S | S | 1.0000 | SAMPLE | 1.0000 | 1 | 1 | SAMP | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | 1.0000 | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | S | SAMPLE | SAMPLE | 1.0000 | 1.0000 | 1.0000 | SAMPLE | SAMPLE | SAMPLE | S | S | SAMPLE | S | SAMPLE | 1 | S | 1 | S |
Example values from field definitions
- LANGRPK
- 1
- TERMSRPK
- SAMPLE
- QC_INDR
- S
- VC_INDR
- S
- DSD_INDR
- S
- EDI_ASNR
- S
- SUPPLIERRPK
- 1
- SUP_NAMER
- SAMPLE
- CREATE_IDR
- SAMPLE
- EDI_PO_CHGR
- S
- EDI_PO_INDR
- S
- SUP_STATUSR
- S
- VAT_REGIONRPK
- 1
- CONTACT_NAMER
- SAMPLE
- EDI_INVC_INDR
- S
- PRE_MARK_INDR
- S
- RET_AUTH_REQR
- S
- BACKORDER_INDR
- S
- CONTACT_PHONER
- SAMPLE
- CURRENCY_CODERPK
- SAM
- FREIGHT_TERMSRPK
- SAMPLE
- RET_ALLOW_INDR
- S
- SUP_QTY_LEVELR
- SAMPLE
- EDI_CHANNEL_IDRPK
- 1
- EDI_PO_CONFIRMR
- S
- FINAL_DEST_INDR
- S
- LAST_UPDATE_IDR
- SAMPLE
- CREATE_DATETIMER
- 2026-01-01
- DELIVERY_POLICYR
- SAMPLE
- PREPAY_INVC_INDR
- S
- SETTLEMENT_CODER
- S
- SUPPLIER_PARENTRPK
- 1
- EDI_CONTRACT_INDR
- S
- PAYMENT_SITE_INDR
- S
- SCALE_AIP_ORDERSR
- S
- AUTO_APPR_INVC_INDR
- S
- FREIGHT_CHARGE_INDR
- S
- BRACKET_COSTING_INDR
- S
- REPLEN_APPROVAL_INDR
- S
- LAST_UPDATE_DATETIMER
- 2026-01-01
- PROCUREMENT_SITE_INDR
- S
- SERVICE_PERF_REQ_INDR
- S
- AUTO_APPR_DBT_MEMO_INDR
- S
- EDI_SUPP_AVAILABLE_INDR
- S
- QC_PCT
- 1.0000
- TAX_ID
- SAMPLE
- VC_PCT
- 1.0000
- QC_FREQ
- 1
- VC_FREQ
- 1
- DUNS_LOC
- SAMP
- CONTACT_FAX
- SAMPLE
- DUNS_NUMBER
- SAMPLE
- RET_COURIER
- SAMPLE
- SHIP_METHOD
- SAMPLE
- COMMENT_DESC
- SAMPLE
- HANDLING_PCT
- 1.0000
- INVC_PAY_LOC
- SAMPLE
- INV_MGMT_LVL
- SAMPLE
- CONTACT_EMAIL
- SAMPLE
- CONTACT_PAGER
- SAMPLE
- CONTACT_TELEX
- SAMPLE
- DBT_MEMO_CODE
- S
- PAYMENT_METHOD
- SAMPLE
- EXTERNAL_REF_ID
- SAMPLE
- RET_MIN_DOL_AMT
- 1.0000
- COST_CHG_AMT_VAR
- 1.0000
- COST_CHG_PCT_VAR
- 1.0000
- INVC_RECEIVE_LOC
- SAMPLE
- VMI_ORDER_STATUS
- SAMPLE
- ADDINVC_GROSS_NET
- SAMPLE
- GEN_CONSIGN_ORDER
- S
- STATUS_UPD_BY_RMS
- S
- DEAL_UPLOAD_STATUS
- SAMPLE
- EDI_SALES_RPT_FREQ
- S
- SUP_NAME_SECONDARY
- SAMPLE
- DEFAULT_PAY_SITE_ID
- 1
- GEN_CONSIGN_INVOICE
- S
- DEFAULT_ITEM_LEAD_TIME
- 1
- DEFAULT_PRICING_CONTROL
- S
Rule Validation Summary
- Source Rule Count
- 181
- Governed Rule Count
- 129