Dc Sups
In ScopeTechnical: DC_SUPS | ID: OR-MFCS-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
Target Structure
- Load Approach
- Table
- Target Objects
- DC_SUPS
Field Definitions(52)
Rules & Considerations(107)
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| default | 000001 | Dc Sups-001 | Dc Sups-001 | 11.0000 | Dc Sups-001 | 11.0000 | Dc Sups-001 | Dc Sups-001 | 01 | 01 | Dc Sups-001 | 1 | Dc Sups Primary | Dc Sups-001 | Dc Sups-001 | 0201 | Dc Sups-001 | Dc Sups-001 | Dc Sups-001 | Dc Sups-001 | Dc Sups-001 | Dc Sups Primary | 11.0000 | Dc Sups-001 | Dc Sups-001 | Dc Sups-001 | Dc Sups-001 | Dc Sups-001 | Dc Sups-001 | Dc Sups-001 | Dc Sups-001 | STD-DC_SUPS-001 | Dc Sups-001 | Dc Sups-001 | Dc Sups-001 | 100001 | Dc Sups-001 | Dc Sups-001 | Dc Sups-001 | 11.0000 | STD-DC_SUPS-001 | 1 | Dc Sups-001 | ACTIVE | Dc Sups-001 | Dc Sups-001 | Dc Sups-001 | Dc Sups-001 | Dc Sups-001 | Dc Sups-001 | 0001 | Dc Sups-001 |
default
- LANG
- 000001
- TERMS
- Dc Sups-001
- QC_IND
- Dc Sups-001
- QC_PCT
- 11.0000
- VC_IND
- Dc Sups-001
- VC_PCT
- 11.0000
- DSD_IND
- Dc Sups-001
- EDI_ASN
- Dc Sups-001
- QC_FREQ
- 01
- VC_FREQ
- 01
- DUNS_LOC
- Dc Sups-001
- SUPPLIER
- 1
- SUP_NAME
- Dc Sups Primary
- EDI_PO_CHG
- Dc Sups-001
- EDI_PO_IND
- Dc Sups-001
- VAT_REGION
- 0201
- CONTACT_FAX
- Dc Sups-001
- DUNS_NUMBER
- Dc Sups-001
- RET_COURIER
- Dc Sups-001
- SHIP_METHOD
- Dc Sups-001
- COMMENT_DESC
- Dc Sups-001
- CONTACT_NAME
- Dc Sups Primary
- HANDLING_PCT
- 11.0000
- INV_MGMT_LVL
- Dc Sups-001
- PRE_MARK_IND
- Dc Sups-001
- RET_AUTH_REQ
- Dc Sups-001
- BACKORDER_IND
- Dc Sups-001
- CONTACT_EMAIL
- Dc Sups-001
- CONTACT_PAGER
- Dc Sups-001
- CONTACT_PHONE
- Dc Sups-001
- CONTACT_TELEX
- Dc Sups-001
- CURRENCY_CODE
- STD-DC_SUPS-001
- FREIGHT_TERMS
- Dc Sups-001
- RET_ALLOW_IND
- Dc Sups-001
- SUP_QTY_LEVEL
- Dc Sups-001
- EDI_CHANNEL_ID
- 100001
- EDI_PO_CONFIRM
- Dc Sups-001
- PAYMENT_METHOD
- Dc Sups-001
- DELIVERY_POLICY
- Dc Sups-001
- RET_MIN_DOL_AMT
- 11.0000
- SETTLEMENT_CODE
- STD-DC_SUPS-001
- SUPPLIER_PARENT
- 1
- EDI_CONTRACT_IND
- Dc Sups-001
- VMI_ORDER_STATUS
- ACTIVE
- AUTO_APPR_INVC_IND
- Dc Sups-001
- EDI_SALES_RPT_FREQ
- Dc Sups-001
- FREIGHT_CHARGE_IND
- Dc Sups-001
- SUP_NAME_SECONDARY
- Dc Sups-001
- REPLEN_APPROVAL_IND
- Dc Sups-001
- SERVICE_PERF_REQ_IND
- Dc Sups-001
- DEFAULT_ITEM_LEAD_TIME
- 0001
- EDI_SUPP_AVAILABLE_IND
- Dc Sups-001