Dc Sups
In ScopeTechnical: DC_SUPS | ID: OR-SUP-DC_SUPS-DC_SUPS
This table is a staging table for data conversion and will hold the supplier information.
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
- DC_SUPS
Field Definitions(5)
Rules & Considerations(52)
Sample Load Data(4)
| _scenario | LANG | TERMS | QC_IND | QC_PCT | VC_IND | VC_PCT | DSD_IND | EDI_ASN | QC_FREQ | VC_FREQ | DUNS_LOC | SUPPLIER | SUP_NAME | EDI_PO_CHG | EDI_PO_IND | VAT_REGION | CONTACT_FAX | DUNS_NUMBER | RET_COURIER | SHIP_METHOD | COMMENT_DESC | CONTACT_NAME | HANDLING_PCT | INV_MGMT_LVL | PRE_MARK_IND | RET_AUTH_REQ | BACKORDER_IND | CONTACT_EMAIL | CONTACT_PAGER | CONTACT_PHONE | CONTACT_TELEX | CURRENCY_CODE | FREIGHT_TERMS | RET_ALLOW_IND | SUP_QTY_LEVEL | EDI_CHANNEL_ID | EDI_PO_CONFIRM | PAYMENT_METHOD | DELIVERY_POLICY | RET_MIN_DOL_AMT | SETTLEMENT_CODE | SUPPLIER_PARENT | EDI_CONTRACT_IND | VMI_ORDER_STATUS | AUTO_APPR_INVC_IND | EDI_SALES_RPT_FREQ | FREIGHT_CHARGE_IND | SUP_NAME_SECONDARY | REPLEN_APPROVAL_IND | SERVICE_PERF_REQ_IND | DEFAULT_ITEM_LEAD_TIME | EDI_SUPP_AVAILABLE_IND |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | 1 | SAMPLE | S | 1.0000 | S | 1.0000 | S | S | 1 | 1 | SAMP | 1 | SAMPLE | S | S | 1 | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | 1.0000 | SAMPLE | S | S | S | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAM | SAMPLE | S | SAMPLE | 1 | S | SAMPLE | SAMPLE | 1.0000 | S | 1 | S | SAMPLE | S | S | S | SAMPLE | S | S | 1 | S |
| default | 3 | Dc Sups-002-ALT | D | 12.5000 | D | 12.5000 | D | D | 3 | 3 | Dc S | 3 | Dc Sups Secondary | D | D | 203 | Dc Sups-002-ALT | Dc Sups-0 | Dc Sups-002-ALT | Dc Sup | Dc Sups-002-ALT | Dc Sups Secondary | 12.5000 | Dc Sup | D | D | D | Dc Sups-002-ALT | Dc Sups-002-ALT | Dc Sups-002-ALT | Dc Sups-002-ALT | ALT | Dc Sups-002-ALT | D | Dc Sup | 100003 | D | Dc Sup | Dc Sup | 12.5000 | A | 3 | D | PENDIN | D | D | D | Dc Sups-002-ALT | D | D | 3 | D |
| default | 5 | Dc Sups-003-EDG | D | 14.0000 | D | 14.0000 | D | D | 5 | 5 | Dc S | 5 | Dc Sups Core | D | D | 205 | Dc Sups-003-EDGE | Dc Sups-0 | Dc Sups-003-EDGE | Dc Sup | Dc Sups-003-EDGE | Dc Sups Core | 14.0000 | Dc Sup | D | D | D | Dc Sups-003-EDGE | Dc Sups-003-EDGE | Dc Sups-003-EDGE | Dc Sups-003-EDGE | EDG | Dc Sups-003-EDGE | D | Dc Sup | 100005 | D | Dc Sup | Dc Sup | 14.0000 | E | 5 | D | ACTIVE | D | D | D | Dc Sups-003-EDGE | D | D | 5 | D |
Example values from field definitions
- LANG
- 1
- TERMS
- SAMPLE
- QC_IND
- S
- QC_PCT
- 1.0000
- VC_IND
- S
- VC_PCT
- 1.0000
- DSD_IND
- S
- EDI_ASN
- S
- QC_FREQ
- 1
- VC_FREQ
- 1
- DUNS_LOC
- SAMP
- SUPPLIER
- 1
- SUP_NAME
- SAMPLE
- EDI_PO_CHG
- S
- EDI_PO_IND
- S
- VAT_REGION
- 1
- CONTACT_FAX
- SAMPLE
- DUNS_NUMBER
- SAMPLE
- RET_COURIER
- SAMPLE
- SHIP_METHOD
- SAMPLE
- COMMENT_DESC
- SAMPLE
- CONTACT_NAME
- SAMPLE
- HANDLING_PCT
- 1.0000
- 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
- FREIGHT_TERMS
- SAMPLE
- RET_ALLOW_IND
- S
- SUP_QTY_LEVEL
- SAMPLE
- EDI_CHANNEL_ID
- 1
- EDI_PO_CONFIRM
- S
- PAYMENT_METHOD
- SAMPLE
- DELIVERY_POLICY
- SAMPLE
- RET_MIN_DOL_AMT
- 1.0000
- SETTLEMENT_CODE
- S
- SUPPLIER_PARENT
- 1
- EDI_CONTRACT_IND
- S
- VMI_ORDER_STATUS
- SAMPLE
- AUTO_APPR_INVC_IND
- S
- EDI_SALES_RPT_FREQ
- S
- FREIGHT_CHARGE_IND
- S
- SUP_NAME_SECONDARY
- SAMPLE
- REPLEN_APPROVAL_IND
- S
- SERVICE_PERF_REQ_IND
- S
- DEFAULT_ITEM_LEAD_TIME
- 1
- EDI_SUPP_AVAILABLE_IND
- S
default
- LANG
- 3
- TERMS
- Dc Sups-002-ALT
- QC_IND
- D
- QC_PCT
- 12.5000
- VC_IND
- D
- VC_PCT
- 12.5000
- DSD_IND
- D
- EDI_ASN
- D
- QC_FREQ
- 3
- VC_FREQ
- 3
- DUNS_LOC
- Dc S
- SUPPLIER
- 3
- SUP_NAME
- Dc Sups Secondary
- EDI_PO_CHG
- D
- EDI_PO_IND
- D
- VAT_REGION
- 203
- CONTACT_FAX
- Dc Sups-002-ALT
- DUNS_NUMBER
- Dc Sups-0
- RET_COURIER
- Dc Sups-002-ALT
- SHIP_METHOD
- Dc Sup
- COMMENT_DESC
- Dc Sups-002-ALT
- CONTACT_NAME
- Dc Sups Secondary
- HANDLING_PCT
- 12.5000
- INV_MGMT_LVL
- Dc Sup
- PRE_MARK_IND
- D
- RET_AUTH_REQ
- D
- BACKORDER_IND
- D
- CONTACT_EMAIL
- Dc Sups-002-ALT
- CONTACT_PAGER
- Dc Sups-002-ALT
- CONTACT_PHONE
- Dc Sups-002-ALT
- CONTACT_TELEX
- Dc Sups-002-ALT
- CURRENCY_CODE
- ALT
- FREIGHT_TERMS
- Dc Sups-002-ALT
- RET_ALLOW_IND
- D
- SUP_QTY_LEVEL
- Dc Sup
- EDI_CHANNEL_ID
- 100003
- EDI_PO_CONFIRM
- D
- PAYMENT_METHOD
- Dc Sup
- DELIVERY_POLICY
- Dc Sup
- RET_MIN_DOL_AMT
- 12.5000
- SETTLEMENT_CODE
- A
- SUPPLIER_PARENT
- 3
- EDI_CONTRACT_IND
- D
- VMI_ORDER_STATUS
- PENDIN
- AUTO_APPR_INVC_IND
- D
- EDI_SALES_RPT_FREQ
- D
- FREIGHT_CHARGE_IND
- D
- SUP_NAME_SECONDARY
- Dc Sups-002-ALT
- REPLEN_APPROVAL_IND
- D
- SERVICE_PERF_REQ_IND
- D
- DEFAULT_ITEM_LEAD_TIME
- 3
- EDI_SUPP_AVAILABLE_IND
- D
default
- LANG
- 5
- TERMS
- Dc Sups-003-EDG
- QC_IND
- D
- QC_PCT
- 14.0000
- VC_IND
- D
- VC_PCT
- 14.0000
- DSD_IND
- D
- EDI_ASN
- D
- QC_FREQ
- 5
- VC_FREQ
- 5
- DUNS_LOC
- Dc S
- SUPPLIER
- 5
- SUP_NAME
- Dc Sups Core
- EDI_PO_CHG
- D
- EDI_PO_IND
- D
- VAT_REGION
- 205
- CONTACT_FAX
- Dc Sups-003-EDGE
- DUNS_NUMBER
- Dc Sups-0
- RET_COURIER
- Dc Sups-003-EDGE
- SHIP_METHOD
- Dc Sup
- COMMENT_DESC
- Dc Sups-003-EDGE
- CONTACT_NAME
- Dc Sups Core
- HANDLING_PCT
- 14.0000
- INV_MGMT_LVL
- Dc Sup
- PRE_MARK_IND
- D
- RET_AUTH_REQ
- D
- BACKORDER_IND
- D
- CONTACT_EMAIL
- Dc Sups-003-EDGE
- CONTACT_PAGER
- Dc Sups-003-EDGE
- CONTACT_PHONE
- Dc Sups-003-EDGE
- CONTACT_TELEX
- Dc Sups-003-EDGE
- CURRENCY_CODE
- EDG
- FREIGHT_TERMS
- Dc Sups-003-EDGE
- RET_ALLOW_IND
- D
- SUP_QTY_LEVEL
- Dc Sup
- EDI_CHANNEL_ID
- 100005
- EDI_PO_CONFIRM
- D
- PAYMENT_METHOD
- Dc Sup
- DELIVERY_POLICY
- Dc Sup
- RET_MIN_DOL_AMT
- 14.0000
- SETTLEMENT_CODE
- E
- SUPPLIER_PARENT
- 5
- EDI_CONTRACT_IND
- D
- VMI_ORDER_STATUS
- ACTIVE
- AUTO_APPR_INVC_IND
- D
- EDI_SALES_RPT_FREQ
- D
- FREIGHT_CHARGE_IND
- D
- SUP_NAME_SECONDARY
- Dc Sups-003-EDGE
- REPLEN_APPROVAL_IND
- D
- SERVICE_PERF_REQ_IND
- D
- DEFAULT_ITEM_LEAD_TIME
- 5
- EDI_SUPP_AVAILABLE_IND
- D
Rule Validation Summary
- Source Rule Count
- 58
- Governed Rule Count
- 52
