Vendors

In Scope

Technical: VendTable | ID: D365FO-PRC-VENDTABLE-VENDORS

See how this object fits into Vendors Procurement

Review the broader sequencing and dependencies for this domain

Migration Details

Complexity: Medium
Sequencing: Stage 2 - Dependent Master Data
Typical Sources: ERPLegacy

Classification

Object Type: dictionary

Target Structure

Load Approach: Table
Target Objects: VendTable

Field Definitions(5)

Rules & Considerations(163)

validation

constraint

Sample Load Data(4)

_scenario	NAMER	VENDGROUPR	ACCOUNTNUMRPK	PARTY	BLOCKED	CURRENCY	PAYMMODE	TAXGROUP	DIMENSION	PARTYTYPE	LANGUAGEID	PAYMTERMID	SEARCHNAME	DIMENSION2_	DIMENSION3_	VENDPAYMMODE	ONETIMEVENDER	ONETIMEVENDOR	INVOICEACCOUNT	ORGANIZATIONNAME	TAXWITHHOLDGROUPVE	DEFAULTDELIVERYLOCATIONID	ADDRESSCITY	ADDRESSBOOKS	ADDRESSSTATEID	ADDRESSZIPCODE	VENDORACCOUNTNUMBER	ADDRESSCOUNTRYREGIONID
Example values from field definitions	Contoso, Ltd.	DOMESTIC	VEN-001	00000213	Invoice	USD	EFT	US_SALES_TAX	SALES	Organization	en-us	NET30	Contoso Sol.	IT	PROJ-DEV	WIRE_CH	Yes	Yes	VEN-PARENT	Contoso Global Solutions, Inc.	WHT_INDIA	000000001	—	—	—	—	—	—
Closed historical record - UK-based vendor acquired in 2019, now blocked for all transactions	BritPack Solutions Ltd	EOMESTIC	VEN-GB-2019-CL	00000987	All	GBP	FFT	UK_VAT_STD	TALES	Organization	en-gb	NET31	BritPack Ltd	JT			No	No		BritPack Solutions Limited			Manchester		ENG	M1 1AA		GB
Minimal domestic micro-vendor - single-person LLC set up for occasional consulting, only mandatory fields populated	Rivera Consulting LLC	DQMESTIC	VEN-US-24-CONSULT	—	—	—	—	US_1099_NE	—	—	en-us	NET15	Rivera Consulting	—	—	—	—	—	—	CONTOSOGLOBALSOLUTIONSINC03	—	000000002	—	—	ADDRESSS03	ADDRESSZ03	VENDORACCOUNTNUMBE03	ADDRESSC03

Example values from field definitions

NAMER: Contoso, Ltd.
VENDGROUPR: DOMESTIC
ACCOUNTNUMRPK: VEN-001
PARTY: 00000213
BLOCKED: Invoice
CURRENCY: USD
PAYMMODE: EFT
TAXGROUP: US_SALES_TAX
DIMENSION: SALES
PARTYTYPE: Organization
LANGUAGEID: en-us
PAYMTERMID: NET30
SEARCHNAME: Contoso Sol.
DIMENSION2_: IT
DIMENSION3_: PROJ-DEV
VENDPAYMMODE: WIRE_CH
ONETIMEVENDER: Yes
ONETIMEVENDOR: Yes
INVOICEACCOUNT: VEN-PARENT
ORGANIZATIONNAME: Contoso Global Solutions, Inc.
TAXWITHHOLDGROUPVE: WHT_INDIA
DEFAULTDELIVERYLOCATIONID: 000000001
ADDRESSCITY: —
ADDRESSBOOKS: —
ADDRESSSTATEID: —
ADDRESSZIPCODE: —
VENDORACCOUNTNUMBER: —
ADDRESSCOUNTRYREGIONID: —

Closed historical record - UK-based vendor acquired in 2019, now blocked for all transactions

NAMER: BritPack Solutions Ltd
VENDGROUPR: EOMESTIC
ACCOUNTNUMRPK: VEN-GB-2019-CL
PARTY: 00000987
BLOCKED: All
CURRENCY: GBP
PAYMMODE: FFT
TAXGROUP: UK_VAT_STD
DIMENSION: TALES
PARTYTYPE: Organization
LANGUAGEID: en-gb
PAYMTERMID: NET31
SEARCHNAME: BritPack Ltd
DIMENSION2_: JT
DIMENSION3_
VENDPAYMMODE
ONETIMEVENDER: No
ONETIMEVENDOR: No
INVOICEACCOUNT
ORGANIZATIONNAME: BritPack Solutions Limited
TAXWITHHOLDGROUPVE
DEFAULTDELIVERYLOCATIONID
ADDRESSCITY: Manchester
ADDRESSBOOKS
ADDRESSSTATEID: ENG
ADDRESSZIPCODE: M1 1AA
VENDORACCOUNTNUMBER
ADDRESSCOUNTRYREGIONID: GB

Minimal domestic micro-vendor - single-person LLC set up for occasional consulting, only mandatory fields populated

NAMER: Rivera Consulting LLC
VENDGROUPR: DQMESTIC
ACCOUNTNUMRPK: VEN-US-24-CONSULT
PARTY: —
BLOCKED: —
CURRENCY: —
PAYMMODE: —
TAXGROUP: US_1099_NE
DIMENSION: —
PARTYTYPE: —
LANGUAGEID: en-us
PAYMTERMID: NET15
SEARCHNAME: Rivera Consulting
DIMENSION2_: —
DIMENSION3_: —
VENDPAYMMODE: —
ONETIMEVENDER: —
ONETIMEVENDOR: —
INVOICEACCOUNT: —
ORGANIZATIONNAME: CONTOSOGLOBALSOLUTIONSINC03
TAXWITHHOLDGROUPVE: —
DEFAULTDELIVERYLOCATIONID: 000000002
ADDRESSCITY: —
ADDRESSBOOKS: —
ADDRESSSTATEID: ADDRESSS03
ADDRESSZIPCODE: ADDRESSZ03
VENDORACCOUNTNUMBER: VENDORACCOUNTNUMBE03
ADDRESSCOUNTRYREGIONID: ADDRESSC03

Rule Validation Summary

Source Rule Count: 163
Governed Rule Count: 163