Partner

In Scope

Technical: PARTNER | ID: OR-MFCS-PARTNER

This table is used to store partner detail information. Partners can include any outside entity (Banks, Agents, etc.) that the company deals with except suppliers, whose detail information is stored…

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

Field Definitions(38)

Rules & Considerations(108)

Sample Load Data(4)

_scenario	LANGPK	TERMSR	STATUSR	CREATE_IDR	PARTNER_IDR	VAT_REGIONPK	ORG_UNIT_IDPK	CONTACT_NAMER	PARTNER_DESCR	PARTNER_TYPERPK	CONTACT_PHONER	CURRENCY_CODERPK	TSF_ENTITY_IDPK	LAST_UPDATE_IDR	PRIMARY_IA_INDR	CREATE_DATETIMER	AUTO_RCV_STOCK_INDR	LAST_UPDATE_DATETIMER	PRINCIPLE_COUNTRY_IDPK	SERVICE_PERF_REQ_INDR	MFG_ID	TAX_ID	YTD_CREDIT	CONTACT_FAX	OPEN_CREDIT	PARENT_NAME	COMMENT_DESC	INVC_PAY_LOC	CONTACT_EMAIL	CONTACT_TELEX	PARENT_REF_ID	YTD_DRAWDOWNS	LINE_OF_CREDIT	EXTERNAL_REF_ID	OUTSTAND_CREDIT	INVC_RECEIVE_LOC	IMPORT_COUNTRY_ID	PARTNER_NAME_SECONDARY
default	000001	Partner-001	A	RETAIL_CTX	STD-PARTNER-001	0201	1000000001	Partner Primary	Partner-001	Partner-001	Partner-001	STD-PARTNER-001	Y	RETAIL_CTX	Partner-001	2026-01-01	N	2026-01-01	STD-PARTNER-001	non	STD-PARTNER-001	STD-PARTNER-001	11.0000	Partner-001	11.0000	Partner Primary	Partner-001	populated	Partner-001	Partner-001	STD-PARTNER-001	11.0000	11.0000	STD-PARTNER-001	11.0000	Partner-001	STD-PARTNER-001	Partner-001

default

LANGPK: 000001
TERMSR: Partner-001
STATUSR: A
CREATE_IDR: RETAIL_CTX
PARTNER_IDR: STD-PARTNER-001
VAT_REGIONPK: 0201
ORG_UNIT_IDPK: 1000000001
CONTACT_NAMER: Partner Primary
PARTNER_DESCR: Partner-001
PARTNER_TYPERPK: Partner-001
CONTACT_PHONER: Partner-001
CURRENCY_CODERPK: STD-PARTNER-001
TSF_ENTITY_IDPK: Y
LAST_UPDATE_IDR: RETAIL_CTX
PRIMARY_IA_INDR: Partner-001
CREATE_DATETIMER: 2026-01-01
AUTO_RCV_STOCK_INDR: N
LAST_UPDATE_DATETIMER: 2026-01-01
PRINCIPLE_COUNTRY_IDPK: STD-PARTNER-001
SERVICE_PERF_REQ_INDR: non
MFG_ID: STD-PARTNER-001
TAX_ID: STD-PARTNER-001
YTD_CREDIT: 11.0000
CONTACT_FAX: Partner-001
OPEN_CREDIT: 11.0000
PARENT_NAME: Partner Primary
COMMENT_DESC: Partner-001
INVC_PAY_LOC: populated
CONTACT_EMAIL: Partner-001
CONTACT_TELEX: Partner-001
PARENT_REF_ID: STD-PARTNER-001
YTD_DRAWDOWNS: 11.0000
LINE_OF_CREDIT: 11.0000
EXTERNAL_REF_ID: STD-PARTNER-001
OUTSTAND_CREDIT: 11.0000
INVC_RECEIVE_LOC: Partner-001
IMPORT_COUNTRY_ID: STD-PARTNER-001
PARTNER_NAME_SECONDARY: Partner-001

All objects