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(5)
Rules & Considerations(136)
constraint
validation
Sample Load Data(4)
| _scenario | SUPPLIERRPK | SUP_NAMER | CONTACT_NAMER | LANG | TERMS | QC_IND | QC_PCT | TAX_ID | VC_IND | VC_PCT | DSD_IND | EDI_ASN | QC_FREQ | VC_FREQ | DUNS_LOC | CREATE_ID | EDI_PO_CHG | EDI_PO_IND | SUP_STATUS | VAT_REGION | CONTACT_FAX | DUNS_NUMBER | RET_COURIER | SHIP_METHOD | COMMENT_DESC | EDI_INVC_IND | HANDLING_PCT | INVC_PAY_LOC | INV_MGMT_LVL | PRE_MARK_IND | RET_AUTH_REQ | BACKORDER_IND | CONTACT_EMAIL | CONTACT_PAGER | CONTACT_PHONE | CONTACT_TELEX | CURRENCY_CODE | DBT_MEMO_CODE | FREIGHT_TERMS | RET_ALLOW_IND | SUP_QTY_LEVEL | EDI_CHANNEL_ID | EDI_PO_CONFIRM | FINAL_DEST_IND | LAST_UPDATE_ID | PAYMENT_METHOD | CREATE_DATETIME | DELIVERY_POLICY | EXTERNAL_REF_ID | PREPAY_INVC_IND | RET_MIN_DOL_AMT | SETTLEMENT_CODE | SUPPLIER_PARENT | COST_CHG_AMT_VAR | COST_CHG_PCT_VAR | EDI_CONTRACT_IND | INVC_RECEIVE_LOC | PAYMENT_SITE_IND | SCALE_AIP_ORDERS | VMI_ORDER_STATUS | ADDINVC_GROSS_NET | GEN_CONSIGN_ORDER | STATUS_UPD_BY_RMS | AUTO_APPR_INVC_IND | DEAL_UPLOAD_STATUS | EDI_SALES_RPT_FREQ | FREIGHT_CHARGE_IND | SUP_NAME_SECONDARY | BRACKET_COSTING_IND | DEFAULT_PAY_SITE_ID | GEN_CONSIGN_INVOICE | REPLEN_APPROVAL_IND | LAST_UPDATE_DATETIME | PROCUREMENT_SITE_IND | SERVICE_PERF_REQ_IND | AUTO_APPR_DBT_MEMO_IND | DEFAULT_ITEM_LEAD_TIME | EDI_SUPP_AVAILABLE_IND | DEFAULT_PRICING_CONTROL |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | 1 | SAMPLE | SAMPLE | 1 | SAMPLE | S | 1.0000 | SAMPLE | S | 1.0000 | S | S | 1 | 1 | SAMP | SAMPLE | S | S | S | 1 | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | S | 1.0000 | SAMPLE | SAMPLE | S | S | S | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAM | S | SAMPLE | S | SAMPLE | 1 | S | S | SAMPLE | SAMPLE | 2026-01-01 | SAMPLE | SAMPLE | S | 1.0000 | S | 1 | 1.0000 | 1.0000 | S | SAMPLE | S | S | SAMPLE | SAMPLE | S | S | S | SAMPLE | S | S | SAMPLE | S | 1 | S | S | 2026-01-01 | S | S | S | 1 | S | S |
| default | 3 | Sups Secondary | Sups Secondary | 3 | Sups-002-ALT | S | 12.5000 | ALT-SUPS-002 | S | 12.5000 | N | N | 3 | 3 | Sups | C LIENT_INFO | N | N | A | 203 | Sups-002-ALT | Sups-002- | Sups-002-ALT | Water | Sups-002-ALT | N | 12.5000 | Sups-0 | Sups-0 | N | N | S | Sups-002-ALT | Sups-002-ALT | Sups-002-ALT | Sups-002-ALT | ALT | N | Sups-002-ALT | N | CA | 100003 | N | N | APP_USER_ID | Sups-0 | 2026-01-03 | Sups-0 | ALT-SUPS-002 | N | 12.5000 | N | 3 | 12.5000 | 12.5000 | S | Sups-0 | Y | N | PENDIN | Sups-0 | N | P | N | S | D | N | Sups-002-ALT | N | 1000000003 | N | N | 2026-01-03 | Y | n | N | 3 | S | N |
| default | 5 | Sups Core | Sups Core | 5 | Sups-003-EDGE | S | 14.0000 | EDGE-SUPS-003 | S | 14.0000 | Y | Y | 5 | 5 | Sups | USE RENV | Y | Y | A | 205 | Sups-003-EDGE | Sups-003- | Sups-003-EDGE | Non | Sups-003-EDGE | Y | 14.0000 | Sups-0 | Sups-0 | Y | Y | S | Sups-003-EDGE | Sups-003-EDGE | Sups-003-EDGE | Sups-003-EDGE | EDG | Y | Sups-003-EDGE | Y | EA | 100005 | Y | N | USERENV | Sups-0 | 2026-01-05 | Sups-0 | EDGE-SUPS-003 | Y | 14.0000 | E | 5 | 14.0000 | 14.0000 | S | Sups-0 | Y | N | ACTIVE | Sups-0 | Y | A | Y | A | D | Y | Sups-003-EDGE | Y | 1000000005 | Y | Y | 2026-01-05 | Y | n | Y | 5 | S | N |
Example values from field definitions
- SUPPLIERRPK
- 1
- SUP_NAMER
- SAMPLE
- CONTACT_NAMER
- SAMPLE
- LANG
- 1
- TERMS
- SAMPLE
- QC_IND
- S
- QC_PCT
- 1.0000
- TAX_ID
- SAMPLE
- VC_IND
- S
- VC_PCT
- 1.0000
- DSD_IND
- S
- EDI_ASN
- S
- QC_FREQ
- 1
- VC_FREQ
- 1
- DUNS_LOC
- SAMP
- CREATE_ID
- SAMPLE
- EDI_PO_CHG
- S
- EDI_PO_IND
- S
- SUP_STATUS
- S
- VAT_REGION
- 1
- CONTACT_FAX
- SAMPLE
- DUNS_NUMBER
- SAMPLE
- RET_COURIER
- SAMPLE
- SHIP_METHOD
- SAMPLE
- COMMENT_DESC
- SAMPLE
- EDI_INVC_IND
- S
- HANDLING_PCT
- 1.0000
- INVC_PAY_LOC
- SAMPLE
- INV_MGMT_LVL
- SAMPLE
- PRE_MARK_IND
- S
- RET_AUTH_REQ
- S
- BACKORDER_IND
- S
- CONTACT_EMAIL
- SAMPLE
- CONTACT_PAGER
- SAMPLE
- CONTACT_PHONE
- SAMPLE
- CONTACT_TELEX
- SAMPLE
- CURRENCY_CODE
- SAM
- DBT_MEMO_CODE
- S
- FREIGHT_TERMS
- SAMPLE
- RET_ALLOW_IND
- S
- SUP_QTY_LEVEL
- SAMPLE
- EDI_CHANNEL_ID
- 1
- EDI_PO_CONFIRM
- S
- FINAL_DEST_IND
- S
- LAST_UPDATE_ID
- SAMPLE
- PAYMENT_METHOD
- SAMPLE
- CREATE_DATETIME
- 2026-01-01
- DELIVERY_POLICY
- SAMPLE
- EXTERNAL_REF_ID
- SAMPLE
- PREPAY_INVC_IND
- S
- RET_MIN_DOL_AMT
- 1.0000
- SETTLEMENT_CODE
- S
- SUPPLIER_PARENT
- 1
- COST_CHG_AMT_VAR
- 1.0000
- COST_CHG_PCT_VAR
- 1.0000
- EDI_CONTRACT_IND
- S
- INVC_RECEIVE_LOC
- SAMPLE
- PAYMENT_SITE_IND
- S
- SCALE_AIP_ORDERS
- S
- VMI_ORDER_STATUS
- SAMPLE
- ADDINVC_GROSS_NET
- SAMPLE
- GEN_CONSIGN_ORDER
- S
- STATUS_UPD_BY_RMS
- S
- AUTO_APPR_INVC_IND
- S
- DEAL_UPLOAD_STATUS
- SAMPLE
- EDI_SALES_RPT_FREQ
- S
- FREIGHT_CHARGE_IND
- S
- SUP_NAME_SECONDARY
- SAMPLE
- BRACKET_COSTING_IND
- S
- DEFAULT_PAY_SITE_ID
- 1
- GEN_CONSIGN_INVOICE
- S
- REPLEN_APPROVAL_IND
- S
- LAST_UPDATE_DATETIME
- 2026-01-01
- PROCUREMENT_SITE_IND
- S
- SERVICE_PERF_REQ_IND
- S
- AUTO_APPR_DBT_MEMO_IND
- S
- DEFAULT_ITEM_LEAD_TIME
- 1
- EDI_SUPP_AVAILABLE_IND
- S
- DEFAULT_PRICING_CONTROL
- S
default
- SUPPLIERRPK
- 3
- SUP_NAMER
- Sups Secondary
- CONTACT_NAMER
- Sups Secondary
- LANG
- 3
- TERMS
- Sups-002-ALT
- QC_IND
- S
- QC_PCT
- 12.5000
- TAX_ID
- ALT-SUPS-002
- VC_IND
- S
- VC_PCT
- 12.5000
- DSD_IND
- N
- EDI_ASN
- N
- QC_FREQ
- 3
- VC_FREQ
- 3
- DUNS_LOC
- Sups
- CREATE_ID
- C LIENT_INFO
- EDI_PO_CHG
- N
- EDI_PO_IND
- N
- SUP_STATUS
- A
- VAT_REGION
- 203
- CONTACT_FAX
- Sups-002-ALT
- DUNS_NUMBER
- Sups-002-
- RET_COURIER
- Sups-002-ALT
- SHIP_METHOD
- Water
- COMMENT_DESC
- Sups-002-ALT
- EDI_INVC_IND
- N
- HANDLING_PCT
- 12.5000
- INVC_PAY_LOC
- Sups-0
- INV_MGMT_LVL
- Sups-0
- PRE_MARK_IND
- N
- RET_AUTH_REQ
- N
- BACKORDER_IND
- S
- CONTACT_EMAIL
- Sups-002-ALT
- CONTACT_PAGER
- Sups-002-ALT
- CONTACT_PHONE
- Sups-002-ALT
- CONTACT_TELEX
- Sups-002-ALT
- CURRENCY_CODE
- ALT
- DBT_MEMO_CODE
- N
- FREIGHT_TERMS
- Sups-002-ALT
- RET_ALLOW_IND
- N
- SUP_QTY_LEVEL
- CA
- EDI_CHANNEL_ID
- 100003
- EDI_PO_CONFIRM
- N
- FINAL_DEST_IND
- N
- LAST_UPDATE_ID
- APP_USER_ID
- PAYMENT_METHOD
- Sups-0
- CREATE_DATETIME
- 2026-01-03
- DELIVERY_POLICY
- Sups-0
- EXTERNAL_REF_ID
- ALT-SUPS-002
- PREPAY_INVC_IND
- N
- RET_MIN_DOL_AMT
- 12.5000
- SETTLEMENT_CODE
- N
- SUPPLIER_PARENT
- 3
- COST_CHG_AMT_VAR
- 12.5000
- COST_CHG_PCT_VAR
- 12.5000
- EDI_CONTRACT_IND
- S
- INVC_RECEIVE_LOC
- Sups-0
- PAYMENT_SITE_IND
- Y
- SCALE_AIP_ORDERS
- N
- VMI_ORDER_STATUS
- PENDIN
- ADDINVC_GROSS_NET
- Sups-0
- GEN_CONSIGN_ORDER
- N
- STATUS_UPD_BY_RMS
- P
- AUTO_APPR_INVC_IND
- N
- DEAL_UPLOAD_STATUS
- S
- EDI_SALES_RPT_FREQ
- D
- FREIGHT_CHARGE_IND
- N
- SUP_NAME_SECONDARY
- Sups-002-ALT
- BRACKET_COSTING_IND
- N
- DEFAULT_PAY_SITE_ID
- 1000000003
- GEN_CONSIGN_INVOICE
- N
- REPLEN_APPROVAL_IND
- N
- LAST_UPDATE_DATETIME
- 2026-01-03
- PROCUREMENT_SITE_IND
- Y
- SERVICE_PERF_REQ_IND
- n
- AUTO_APPR_DBT_MEMO_IND
- N
- DEFAULT_ITEM_LEAD_TIME
- 3
- EDI_SUPP_AVAILABLE_IND
- S
- DEFAULT_PRICING_CONTROL
- N
default
- SUPPLIERRPK
- 5
- SUP_NAMER
- Sups Core
- CONTACT_NAMER
- Sups Core
- LANG
- 5
- TERMS
- Sups-003-EDGE
- QC_IND
- S
- QC_PCT
- 14.0000
- TAX_ID
- EDGE-SUPS-003
- VC_IND
- S
- VC_PCT
- 14.0000
- DSD_IND
- Y
- EDI_ASN
- Y
- QC_FREQ
- 5
- VC_FREQ
- 5
- DUNS_LOC
- Sups
- CREATE_ID
- USE RENV
- EDI_PO_CHG
- Y
- EDI_PO_IND
- Y
- SUP_STATUS
- A
- VAT_REGION
- 205
- CONTACT_FAX
- Sups-003-EDGE
- DUNS_NUMBER
- Sups-003-
- RET_COURIER
- Sups-003-EDGE
- SHIP_METHOD
- Non
- COMMENT_DESC
- Sups-003-EDGE
- EDI_INVC_IND
- Y
- HANDLING_PCT
- 14.0000
- INVC_PAY_LOC
- Sups-0
- INV_MGMT_LVL
- Sups-0
- PRE_MARK_IND
- Y
- RET_AUTH_REQ
- Y
- BACKORDER_IND
- S
- CONTACT_EMAIL
- Sups-003-EDGE
- CONTACT_PAGER
- Sups-003-EDGE
- CONTACT_PHONE
- Sups-003-EDGE
- CONTACT_TELEX
- Sups-003-EDGE
- CURRENCY_CODE
- EDG
- DBT_MEMO_CODE
- Y
- FREIGHT_TERMS
- Sups-003-EDGE
- RET_ALLOW_IND
- Y
- SUP_QTY_LEVEL
- EA
- EDI_CHANNEL_ID
- 100005
- EDI_PO_CONFIRM
- Y
- FINAL_DEST_IND
- N
- LAST_UPDATE_ID
- USERENV
- PAYMENT_METHOD
- Sups-0
- CREATE_DATETIME
- 2026-01-05
- DELIVERY_POLICY
- Sups-0
- EXTERNAL_REF_ID
- EDGE-SUPS-003
- PREPAY_INVC_IND
- Y
- RET_MIN_DOL_AMT
- 14.0000
- SETTLEMENT_CODE
- E
- SUPPLIER_PARENT
- 5
- COST_CHG_AMT_VAR
- 14.0000
- COST_CHG_PCT_VAR
- 14.0000
- EDI_CONTRACT_IND
- S
- INVC_RECEIVE_LOC
- Sups-0
- PAYMENT_SITE_IND
- Y
- SCALE_AIP_ORDERS
- N
- VMI_ORDER_STATUS
- ACTIVE
- ADDINVC_GROSS_NET
- Sups-0
- GEN_CONSIGN_ORDER
- Y
- STATUS_UPD_BY_RMS
- A
- AUTO_APPR_INVC_IND
- Y
- DEAL_UPLOAD_STATUS
- A
- EDI_SALES_RPT_FREQ
- D
- FREIGHT_CHARGE_IND
- Y
- SUP_NAME_SECONDARY
- Sups-003-EDGE
- BRACKET_COSTING_IND
- Y
- DEFAULT_PAY_SITE_ID
- 1000000005
- GEN_CONSIGN_INVOICE
- Y
- REPLEN_APPROVAL_IND
- Y
- LAST_UPDATE_DATETIME
- 2026-01-05
- PROCUREMENT_SITE_IND
- Y
- SERVICE_PERF_REQ_IND
- n
- AUTO_APPR_DBT_MEMO_IND
- Y
- DEFAULT_ITEM_LEAD_TIME
- 5
- EDI_SUPP_AVAILABLE_IND
- S
- DEFAULT_PRICING_CONTROL
- N
Rule Validation Summary
- Source Rule Count
- 188
- Governed Rule Count
- 136