Dc Sups

In Scope

Technical: 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

Dc Sups | undefined | Oracle Retail