Sups

In Scope

Technical: SUPS | ID: OR-MFCS-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

Target Structure

Load Approach: Table
Target Objects: SUPS

Field Definitions(79)

Rules & Considerations(240)

Sample Load Data(4)

_scenario	LANGPK	TERMSRPK	QC_INDR	VC_INDR	DSD_INDR	EDI_ASNR	SUPPLIERRPK	SUP_NAMER	CREATE_IDR	EDI_PO_CHGR	EDI_PO_INDR	SUP_STATUSR	VAT_REGIONPK	CONTACT_NAMER	EDI_INVC_INDR	PRE_MARK_INDR	RET_AUTH_REQR	BACKORDER_INDR	CONTACT_PHONER	CURRENCY_CODERPK	FREIGHT_TERMSPK	RET_ALLOW_INDR	SUP_QTY_LEVELR	EDI_CHANNEL_IDPK	EDI_PO_CONFIRMR	FINAL_DEST_INDR	LAST_UPDATE_IDR	CREATE_DATETIMER	DELIVERY_POLICYR	PREPAY_INVC_INDR	SETTLEMENT_CODER	SUPPLIER_PARENTPK	EDI_CONTRACT_INDR	PAYMENT_SITE_INDR	SCALE_AIP_ORDERSR	AUTO_APPR_INVC_INDR	FREIGHT_CHARGE_INDR	BRACKET_COSTING_INDR	REPLEN_APPROVAL_INDR	LAST_UPDATE_DATETIMER	PROCUREMENT_SITE_INDR	SERVICE_PERF_REQ_INDR	AUTO_APPR_DBT_MEMO_INDR	EDI_SUPP_AVAILABLE_INDR	QC_PCT	TAX_ID	VC_PCT	QC_FREQ	VC_FREQ	DUNS_LOC	CONTACT_FAX	DUNS_NUMBER	RET_COURIER	SHIP_METHOD	COMMENT_DESC	HANDLING_PCT	INVC_PAY_LOC	INV_MGMT_LVL	CONTACT_EMAIL	CONTACT_PAGER	CONTACT_TELEX	DBT_MEMO_CODE	PAYMENT_METHOD	EXTERNAL_REF_ID	RET_MIN_DOL_AMT	COST_CHG_AMT_VAR	COST_CHG_PCT_VAR	INVC_RECEIVE_LOC	VMI_ORDER_STATUS	ADDINVC_GROSS_NET	GEN_CONSIGN_ORDER	STATUS_UPD_BY_RMS	DEAL_UPLOAD_STATUS	EDI_SALES_RPT_FREQ	SUP_NAME_SECONDARY	DEFAULT_PAY_SITE_ID	GEN_CONSIGN_INVOICE	DEFAULT_ITEM_LEAD_TIME	DEFAULT_PRICING_CONTROL
default	000001	Sups-001	Sups-001	Sups-001	Y	Y	1	Sups Primary	USERENV	Y	Y	A	0201	Sups Primary	Y	Y	Y	Sups-001	Sups-001	STD-SUPS-001	Sups-001	Y	EA	100001	Y	N	RETAIL_CTX	2026-01-01	Sups-001	Y	E	1	Sups-001	Y	N	Y	Y	Y	Y	2026-01-01	Y	non	Y	Sups-001	11.0000	STD-SUPS-001	11.0000	01	01	Sups-001	Sups-001	Sups-001	Sups-001	Non	Sups-001	11.0000	Sups-001	Sups-001	Sups-001	Sups-001	Sups-001	Y	Sups-001	STD-SUPS-001	11.0000	11.0000	11.0000	Sups-001	ACTIVE	Sups-001	Y	ACTIVE	W	D	Sups-001	1000000001	Y	0001	NULL

default

LANGPK: 000001
TERMSRPK: Sups-001
QC_INDR: Sups-001
VC_INDR: Sups-001
DSD_INDR: Y
EDI_ASNR: Y
SUPPLIERRPK: 1
SUP_NAMER: Sups Primary
CREATE_IDR: USERENV
EDI_PO_CHGR: Y
EDI_PO_INDR: Y
SUP_STATUSR: A
VAT_REGIONPK: 0201
CONTACT_NAMER: Sups Primary
EDI_INVC_INDR: Y
PRE_MARK_INDR: Y
RET_AUTH_REQR: Y
BACKORDER_INDR: Sups-001
CONTACT_PHONER: Sups-001
CURRENCY_CODERPK: STD-SUPS-001
FREIGHT_TERMSPK: Sups-001
RET_ALLOW_INDR: Y
SUP_QTY_LEVELR: EA
EDI_CHANNEL_IDPK: 100001
EDI_PO_CONFIRMR: Y
FINAL_DEST_INDR: N
LAST_UPDATE_IDR: RETAIL_CTX
CREATE_DATETIMER: 2026-01-01
DELIVERY_POLICYR: Sups-001
PREPAY_INVC_INDR: Y
SETTLEMENT_CODER: E
SUPPLIER_PARENTPK: 1
EDI_CONTRACT_INDR: Sups-001
PAYMENT_SITE_INDR: Y
SCALE_AIP_ORDERSR: N
AUTO_APPR_INVC_INDR: Y
FREIGHT_CHARGE_INDR: Y
BRACKET_COSTING_INDR: Y
REPLEN_APPROVAL_INDR: Y
LAST_UPDATE_DATETIMER: 2026-01-01
PROCUREMENT_SITE_INDR: Y
SERVICE_PERF_REQ_INDR: non
AUTO_APPR_DBT_MEMO_INDR: Y
EDI_SUPP_AVAILABLE_INDR: Sups-001
QC_PCT: 11.0000
TAX_ID: STD-SUPS-001
VC_PCT: 11.0000
QC_FREQ: 01
VC_FREQ: 01
DUNS_LOC: Sups-001
CONTACT_FAX: Sups-001
DUNS_NUMBER: Sups-001
RET_COURIER: Sups-001
SHIP_METHOD: Non
COMMENT_DESC: Sups-001
HANDLING_PCT: 11.0000
INVC_PAY_LOC: Sups-001
INV_MGMT_LVL: Sups-001
CONTACT_EMAIL: Sups-001
CONTACT_PAGER: Sups-001
CONTACT_TELEX: Sups-001
DBT_MEMO_CODE: Y
PAYMENT_METHOD: Sups-001
EXTERNAL_REF_ID: STD-SUPS-001
RET_MIN_DOL_AMT: 11.0000
COST_CHG_AMT_VAR: 11.0000
COST_CHG_PCT_VAR: 11.0000
INVC_RECEIVE_LOC: Sups-001
VMI_ORDER_STATUS: ACTIVE
ADDINVC_GROSS_NET: Sups-001
GEN_CONSIGN_ORDER: Y
STATUS_UPD_BY_RMS: ACTIVE
DEAL_UPLOAD_STATUS: W
EDI_SALES_RPT_FREQ: D
SUP_NAME_SECONDARY: Sups-001
DEFAULT_PAY_SITE_ID: 1000000001
GEN_CONSIGN_INVOICE: Y
DEFAULT_ITEM_LEAD_TIME: 0001
DEFAULT_PRICING_CONTROL: NULL

All objects