Partner Detail Information

In Scope

Technical: PARTNER | ID: OR-SUP-PARTNER-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

Classification

Object Type: dictionary

Target Structure

Load Approach: Table
Target Objects: PARTNER

Field Definitions(5)

Sample Load Data(4)

_scenario	PARTNER_IDRPK	PARTNER_DESCR	PARTNER_TYPERPK	CURRENCY_CODER	ID	LANG	NAME	TYPE	TERMS	MFG_ID	STATUS	TAX_ID	CREATE_ID	LOCALE_ID	VAT_REGION	YTD_CREDIT	CONTACT_FAX	OPEN_CREDIT	ORG_UNIT_ID	PARENT_NAME	COMMENT_DESC	CONTACT_NAME	INVC_PAY_LOC	CONTACT_EMAIL	CONTACT_PHONE	CONTACT_TELEX	PARENT_REF_ID	PAYMENT_TERMS	TSF_ENTITY_ID	YTD_DRAWDOWNS	IMPORT_PRIMARY	LAST_UPDATE_ID	LINE_OF_CREDIT	PRIMARY_IA_IND	CREATE_DATETIME	EXTERNAL_REF_ID	MANUFACTURER_ID	OUTSTAND_CREDIT	INVC_RECEIVE_LOC	IMPORT_COUNTRY_ID	AUTO_RCV_STOCK_IND	TRANSFER_ENTITY_ID	LAST_UPDATE_DATETIME	ORGANIZATION_UNIT_ID	PRINCIPAL_COUNTRY_ID	PRINCIPLE_COUNTRY_ID	SERVICE_PERF_REQ_IND	PARTNER_NAME_SECONDARY	VALUE_ADDED_TAX_REGION
Example values from field definitions	SAMPLE	SAMPLE	SAMPLE	SAM	1	1	SAMPLE	SAMPLE	SAMPLE	SAMPLE	S	SAMPLE	SAMPLE	1	1	1.0000	SAMPLE	1.0000	1	SAMPLE	SAMPLE	SAMPLE	SAMPLE	SAMPLE	SAMPLE	SAMPLE	SAMPLE	SAMPLE	1	1.0000	S	SAMPLE	1.0000	S	2026-01-01	SAMPLE	SAMPLE	1.0000	SAMPLE	SAM	S	SAMPLE	2026-01-01	SAMPLE	SAM	SAM	S	SAMPLE	SAMPLE
default	ALT-PARTNE	Partner-002-ALT	Partne	ALT	—	3	—	—	Partner-002-ALT	ALT-PARTNER-002	A	ALT-PARTNER-002	APP_USER_ID	—	203	12.5000	Partner-002-ALT	12.5000	1000000003	Partner Secondary	Partner-002-ALT	Partner Secondary	popula	Partner-002-ALT	Partner-002-ALT	Partner-002-ALT	ALT-PARTNER-002	—	N	12.5000	—	APP_USER_ID	12.5000	P	2026-01-03	ALT-PARTNER-002	—	12.5000	Partne	ALT	N	—	2026-01-03	—	—	ALT	n	Partner-002-ALT	—
default	EDGE-PARTN	Partner-003-EDGE	Partne	EDG	—	5	—	—	Partner-003-EDG	EDGE-PARTNER-003	A	EDGE-PARTNER-003	USERENV	—	205	14.0000	Partner-003-EDGE	14.0000	1000000005	Partner Core	Partner-003-EDGE	Partner Core	popula	Partner-003-EDGE	Partner-003-EDGE	Partner-003-EDGE	EDGE-PARTNER-003	—	Y	14.0000	—	USERENV	14.0000	P	2026-01-05	EDGE-PARTNER-003	—	14.0000	Partne	EDG	N	—	2026-01-05	—	—	EDG	n	Partner-003-EDGE	—

Example values from field definitions

PARTNER_IDRPK: SAMPLE
PARTNER_DESCR: SAMPLE
PARTNER_TYPERPK: SAMPLE
CURRENCY_CODER: SAM
ID: 1
LANG: 1
NAME: SAMPLE
TYPE: SAMPLE
TERMS: SAMPLE
MFG_ID: SAMPLE
STATUS: S
TAX_ID: SAMPLE
CREATE_ID: SAMPLE
LOCALE_ID: 1
VAT_REGION: 1
YTD_CREDIT: 1.0000
CONTACT_FAX: SAMPLE
OPEN_CREDIT: 1.0000
ORG_UNIT_ID: 1
PARENT_NAME: SAMPLE
COMMENT_DESC: SAMPLE
CONTACT_NAME: SAMPLE
INVC_PAY_LOC: SAMPLE
CONTACT_EMAIL: SAMPLE
CONTACT_PHONE: SAMPLE
CONTACT_TELEX: SAMPLE
PARENT_REF_ID: SAMPLE
PAYMENT_TERMS: SAMPLE
TSF_ENTITY_ID: 1
YTD_DRAWDOWNS: 1.0000
IMPORT_PRIMARY: S
LAST_UPDATE_ID: SAMPLE
LINE_OF_CREDIT: 1.0000
PRIMARY_IA_IND: S
CREATE_DATETIME: 2026-01-01
EXTERNAL_REF_ID: SAMPLE
MANUFACTURER_ID: SAMPLE
OUTSTAND_CREDIT: 1.0000
INVC_RECEIVE_LOC: SAMPLE
IMPORT_COUNTRY_ID: SAM
AUTO_RCV_STOCK_IND: S
TRANSFER_ENTITY_ID: SAMPLE
LAST_UPDATE_DATETIME: 2026-01-01
ORGANIZATION_UNIT_ID: SAMPLE
PRINCIPAL_COUNTRY_ID: SAM
PRINCIPLE_COUNTRY_ID: SAM
SERVICE_PERF_REQ_IND: S
PARTNER_NAME_SECONDARY: SAMPLE
VALUE_ADDED_TAX_REGION: SAMPLE

default

PARTNER_IDRPK: ALT-PARTNE
PARTNER_DESCR: Partner-002-ALT
PARTNER_TYPERPK: Partne
CURRENCY_CODER: ALT
ID: —
LANG: 3
NAME: —
TYPE: —
TERMS: Partner-002-ALT
MFG_ID: ALT-PARTNER-002
STATUS: A
TAX_ID: ALT-PARTNER-002
CREATE_ID: APP_USER_ID
LOCALE_ID: —
VAT_REGION: 203
YTD_CREDIT: 12.5000
CONTACT_FAX: Partner-002-ALT
OPEN_CREDIT: 12.5000
ORG_UNIT_ID: 1000000003
PARENT_NAME: Partner Secondary
COMMENT_DESC: Partner-002-ALT
CONTACT_NAME: Partner Secondary
INVC_PAY_LOC: popula
CONTACT_EMAIL: Partner-002-ALT
CONTACT_PHONE: Partner-002-ALT
CONTACT_TELEX: Partner-002-ALT
PARENT_REF_ID: ALT-PARTNER-002
PAYMENT_TERMS: —
TSF_ENTITY_ID: N
YTD_DRAWDOWNS: 12.5000
IMPORT_PRIMARY: —
LAST_UPDATE_ID: APP_USER_ID
LINE_OF_CREDIT: 12.5000
PRIMARY_IA_IND: P
CREATE_DATETIME: 2026-01-03
EXTERNAL_REF_ID: ALT-PARTNER-002
MANUFACTURER_ID: —
OUTSTAND_CREDIT: 12.5000
INVC_RECEIVE_LOC: Partne
IMPORT_COUNTRY_ID: ALT
AUTO_RCV_STOCK_IND: N
TRANSFER_ENTITY_ID: —
LAST_UPDATE_DATETIME: 2026-01-03
ORGANIZATION_UNIT_ID: —
PRINCIPAL_COUNTRY_ID: —
PRINCIPLE_COUNTRY_ID: ALT
SERVICE_PERF_REQ_IND: n
PARTNER_NAME_SECONDARY: Partner-002-ALT
VALUE_ADDED_TAX_REGION: —

default

PARTNER_IDRPK: EDGE-PARTN
PARTNER_DESCR: Partner-003-EDGE
PARTNER_TYPERPK: Partne
CURRENCY_CODER: EDG
ID: —
LANG: 5
NAME: —
TYPE: —
TERMS: Partner-003-EDG
MFG_ID: EDGE-PARTNER-003
STATUS: A
TAX_ID: EDGE-PARTNER-003
CREATE_ID: USERENV
LOCALE_ID: —
VAT_REGION: 205
YTD_CREDIT: 14.0000
CONTACT_FAX: Partner-003-EDGE
OPEN_CREDIT: 14.0000
ORG_UNIT_ID: 1000000005
PARENT_NAME: Partner Core
COMMENT_DESC: Partner-003-EDGE
CONTACT_NAME: Partner Core
INVC_PAY_LOC: popula
CONTACT_EMAIL: Partner-003-EDGE
CONTACT_PHONE: Partner-003-EDGE
CONTACT_TELEX: Partner-003-EDGE
PARENT_REF_ID: EDGE-PARTNER-003
PAYMENT_TERMS: —
TSF_ENTITY_ID: Y
YTD_DRAWDOWNS: 14.0000
IMPORT_PRIMARY: —
LAST_UPDATE_ID: USERENV
LINE_OF_CREDIT: 14.0000
PRIMARY_IA_IND: P
CREATE_DATETIME: 2026-01-05
EXTERNAL_REF_ID: EDGE-PARTNER-003
MANUFACTURER_ID: —
OUTSTAND_CREDIT: 14.0000
INVC_RECEIVE_LOC: Partne
IMPORT_COUNTRY_ID: EDG
AUTO_RCV_STOCK_IND: N
TRANSFER_ENTITY_ID: —
LAST_UPDATE_DATETIME: 2026-01-05
ORGANIZATION_UNIT_ID: —
PRINCIPAL_COUNTRY_ID: —
PRINCIPLE_COUNTRY_ID: EDG
SERVICE_PERF_REQ_IND: n
PARTNER_NAME_SECONDARY: Partner-003-EDGE
VALUE_ADDED_TAX_REGION: —

Rule Validation Summary

Source Rule Count: 72
Governed Rule Count: 72

All objects