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(52)
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 |
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
Rule Validation Summary
- Source Rule Count
- 58
- Governed Rule Count
- 52