Vendor Addresses

See how this object fits into Vendors Procurement

Review the broader sequencing and dependencies for this domain

Field Definitions(5)

Rules & Considerations(47)

validation

constraint

Sample Load Data(4)

_scenario	COUNTRYREGIONIDR	VENDORACCOUNTNUMBERRPK	CITY	STATE	COUNTY	STREET	POSTBOX	VALIDTO	ZIPCODE	LATITUDE	TIMEZONE	ISPRIMARY	ISPRIVATE	LONGITUDE	VALIDFROM	ISROLEHOME	LOCATIONID	ADDRESSCITY	ADDRESSTYPE	ATTENTIONTO	DESCRIPTION	ADDRESSLINE1	ADDRESSLINE2	ADDRESSLINE3	STREETNUMBER	ADDRESSSTREET	ISROLEINVOICE	ADDRESSPOSTBOX	ADDRESSSTATEID	ADDRESSVALIDTO	ADDRESSZIPCODE	ISROLEBUSINESS	ISROLEDELIVERY	ADDRESSCOUNTYID	ADDRESSLATITUDE	ADDRESSTIMEZONE	ISLOCATIONOWNER	ISPOSTALADDRESS	ADDRESSLONGITUDE	ADDRESSVALIDFROM	FORMATTEDADDRESS	ADDRESSLOCATIONID	ADDRESSDESCRIPTION	BUILDINGCOMPLIMENT	ADDRESSDISTRICTNAME	ADDRESSSTREETNUMBER	BUILDINGCOMPARTMENT	VENDORLEGALENTITYID	ADDRESSLOCATIONROLES	ADDRESSCOUNTRYREGIONID	ATTENTIONTOADDRESSLINE	ISPRIVATEPOSTALADDRESS	ADDRESSCOUNTRYREGIONISOCODE
Example values from field definitions	US	VEND0001	New York	CA	Los Angeles	123 Main Street	P.O. Box 789	2154-12-31T23:59:59Z	10001	34.0522	America/New_York	Yes	No	-118.243683	2023-01-01T08:00:00Z	0	LOC001-VEND0001	London	Business	Accounts Payable Department	Headquarters	Unit 2, The Business Centre	Suite 400	Warehouse East	45B	456 Oak Avenue	1	PO Box 9876	WA	2154-12-31T23:59:59	98052-6399	1	1	King	51.507351	21	0	1	-0.127800	2023-01-01T00:00:00	1000 SW 34th St, Redmond, WA 98052-6399, USA	LOCID-V0001-DL	Warehouse 3 (North)	Suite 200	Financial District	789	Building A, Floor 5	USMF	Business,Delivery,Invoice	GB	ATTN: Receiving Dept - Dock 5	0	US
Variation 1 - type-safe variation anchored to example values	VS	VEND0001	NEWYORK02	DA	LOSANGEL02	123MAINSTREET02	POBOX78902	21541231T235959Z02	10001	3405202	AMERICANEWYORK02	ZES	OO	11824368302	20230101T080000Z02	2	LOC001VEND000102	MONDON	CUSINESS	ACCOUNTSPAYABLEDEPARTMENT02	IEADQUARTERS	UNIT2THEBUSINESSCENTRE02	SUITE40002	WAREHOUSEEAST02	451	456OAKAVENUE02	2	POBOX987602	XA	21541231T23595902	9805263902	2	2	LING	515073502	02	2	2	012780002	20230101T00000002	1000SW34THSTREDMONDWA980526399USA02	LOCIDV0001DL02	WAREHOUSE3NORTH02	SUITE20002	FINANCIALDISTRICT02	781	BUILDINGAFLOOR502	VSMF	BUSINESSDELIVERYINVOICE02	HB	ATTNRECEIVINGDEPTDOCK502	2	VS
Variation 2 - additional in-range variation with row-level constraint alignment	UU	VEND0002	NEWYORK03	CC	LOSANGEL03	123MAINSTREET03	POBOX78903	21541231T235959Z03	10002	3405203	AMERICANEWYORK03	YGS	NQ	11824368303	20230101T080000Z03	3	LOC001VEND000103	LQNDON	BWSINESS	ACCOUNTSPAYABLEDEPARTMENT03	HGADQUARTERS	UNIT2THEBUSINESSCENTRE03	SUITE40003	WAREHOUSEEAST03	452	456OAKAVENUE03	3	POBOX987603	WC	21541231T23595903	9805263903	3	3	KKNG	515073503	03	3	3	012780003	20230101T00000003	1000SW34THSTREDMONDWA980526399USA03	LOCIDV0001DL03	WAREHOUSE3NORTH03	SUITE20003	FINANCIALDISTRICT03	782	BUILDINGAFLOOR503	UUMF	BUSINESSDELIVERYINVOICE03	GD	ATTNRECEIVINGDEPTDOCK503	3	UU

Example values from field definitions

COUNTRYREGIONIDR: US
VENDORACCOUNTNUMBERRPK: VEND0001
CITY: New York
STATE: CA
COUNTY: Los Angeles
STREET: 123 Main Street
POSTBOX: P.O. Box 789
VALIDTO: 2154-12-31T23:59:59Z
ZIPCODE: 10001
LATITUDE: 34.0522
TIMEZONE: America/New_York
ISPRIMARY: Yes
ISPRIVATE: No
LONGITUDE: -118.243683
VALIDFROM: 2023-01-01T08:00:00Z
ISROLEHOME: 0
LOCATIONID: LOC001-VEND0001
ADDRESSCITY: London
ADDRESSTYPE: Business
ATTENTIONTO: Accounts Payable Department
DESCRIPTION: Headquarters
ADDRESSLINE1: Unit 2, The Business Centre
ADDRESSLINE2: Suite 400
ADDRESSLINE3: Warehouse East
STREETNUMBER: 45B
ADDRESSSTREET: 456 Oak Avenue
ISROLEINVOICE: 1
ADDRESSPOSTBOX: PO Box 9876
ADDRESSSTATEID: WA
ADDRESSVALIDTO: 2154-12-31T23:59:59
ADDRESSZIPCODE: 98052-6399
ISROLEBUSINESS: 1
ISROLEDELIVERY: 1
ADDRESSCOUNTYID: King
ADDRESSLATITUDE: 51.507351
ADDRESSTIMEZONE: 21
ISLOCATIONOWNER: 0
ISPOSTALADDRESS: 1
ADDRESSLONGITUDE: -0.127800
ADDRESSVALIDFROM: 2023-01-01T00:00:00
FORMATTEDADDRESS: 1000 SW 34th St, Redmond, WA 98052-6399, USA
ADDRESSLOCATIONID: LOCID-V0001-DL
ADDRESSDESCRIPTION: Warehouse 3 (North)
BUILDINGCOMPLIMENT: Suite 200
ADDRESSDISTRICTNAME: Financial District
ADDRESSSTREETNUMBER: 789
BUILDINGCOMPARTMENT: Building A, Floor 5
VENDORLEGALENTITYID: USMF
ADDRESSLOCATIONROLES: Business,Delivery,Invoice
ADDRESSCOUNTRYREGIONID: GB
ATTENTIONTOADDRESSLINE: ATTN: Receiving Dept - Dock 5
ISPRIVATEPOSTALADDRESS: 0
ADDRESSCOUNTRYREGIONISOCODE: US

Variation 1 - type-safe variation anchored to example values

COUNTRYREGIONIDR: VS
VENDORACCOUNTNUMBERRPK: VEND0001
CITY: NEWYORK02
STATE: DA
COUNTY: LOSANGEL02
STREET: 123MAINSTREET02
POSTBOX: POBOX78902
VALIDTO: 21541231T235959Z02
ZIPCODE: 10001
LATITUDE: 3405202
TIMEZONE: AMERICANEWYORK02
ISPRIMARY: ZES
ISPRIVATE: OO
LONGITUDE: 11824368302
VALIDFROM: 20230101T080000Z02
ISROLEHOME: 2
LOCATIONID: LOC001VEND000102
ADDRESSCITY: MONDON
ADDRESSTYPE: CUSINESS
ATTENTIONTO: ACCOUNTSPAYABLEDEPARTMENT02
DESCRIPTION: IEADQUARTERS
ADDRESSLINE1: UNIT2THEBUSINESSCENTRE02
ADDRESSLINE2: SUITE40002
ADDRESSLINE3: WAREHOUSEEAST02
STREETNUMBER: 451
ADDRESSSTREET: 456OAKAVENUE02
ISROLEINVOICE: 2
ADDRESSPOSTBOX: POBOX987602
ADDRESSSTATEID: XA
ADDRESSVALIDTO: 21541231T23595902
ADDRESSZIPCODE: 9805263902
ISROLEBUSINESS: 2
ISROLEDELIVERY: 2
ADDRESSCOUNTYID: LING
ADDRESSLATITUDE: 515073502
ADDRESSTIMEZONE: 02
ISLOCATIONOWNER: 2
ISPOSTALADDRESS: 2
ADDRESSLONGITUDE: 012780002
ADDRESSVALIDFROM: 20230101T00000002
FORMATTEDADDRESS: 1000SW34THSTREDMONDWA980526399USA02
ADDRESSLOCATIONID: LOCIDV0001DL02
ADDRESSDESCRIPTION: WAREHOUSE3NORTH02
BUILDINGCOMPLIMENT: SUITE20002
ADDRESSDISTRICTNAME: FINANCIALDISTRICT02
ADDRESSSTREETNUMBER: 781
BUILDINGCOMPARTMENT: BUILDINGAFLOOR502
VENDORLEGALENTITYID: VSMF
ADDRESSLOCATIONROLES: BUSINESSDELIVERYINVOICE02
ADDRESSCOUNTRYREGIONID: HB
ATTENTIONTOADDRESSLINE: ATTNRECEIVINGDEPTDOCK502
ISPRIVATEPOSTALADDRESS: 2
ADDRESSCOUNTRYREGIONISOCODE: VS

Variation 2 - additional in-range variation with row-level constraint alignment

COUNTRYREGIONIDR: UU
VENDORACCOUNTNUMBERRPK: VEND0002
CITY: NEWYORK03
STATE: CC
COUNTY: LOSANGEL03
STREET: 123MAINSTREET03
POSTBOX: POBOX78903
VALIDTO: 21541231T235959Z03
ZIPCODE: 10002
LATITUDE: 3405203
TIMEZONE: AMERICANEWYORK03
ISPRIMARY: YGS
ISPRIVATE: NQ
LONGITUDE: 11824368303
VALIDFROM: 20230101T080000Z03
ISROLEHOME: 3
LOCATIONID: LOC001VEND000103
ADDRESSCITY: LQNDON
ADDRESSTYPE: BWSINESS
ATTENTIONTO: ACCOUNTSPAYABLEDEPARTMENT03
DESCRIPTION: HGADQUARTERS
ADDRESSLINE1: UNIT2THEBUSINESSCENTRE03
ADDRESSLINE2: SUITE40003
ADDRESSLINE3: WAREHOUSEEAST03
STREETNUMBER: 452
ADDRESSSTREET: 456OAKAVENUE03
ISROLEINVOICE: 3
ADDRESSPOSTBOX: POBOX987603
ADDRESSSTATEID: WC
ADDRESSVALIDTO: 21541231T23595903
ADDRESSZIPCODE: 9805263903
ISROLEBUSINESS: 3
ISROLEDELIVERY: 3
ADDRESSCOUNTYID: KKNG
ADDRESSLATITUDE: 515073503
ADDRESSTIMEZONE: 03
ISLOCATIONOWNER: 3
ISPOSTALADDRESS: 3
ADDRESSLONGITUDE: 012780003
ADDRESSVALIDFROM: 20230101T00000003
FORMATTEDADDRESS: 1000SW34THSTREDMONDWA980526399USA03
ADDRESSLOCATIONID: LOCIDV0001DL03
ADDRESSDESCRIPTION: WAREHOUSE3NORTH03
BUILDINGCOMPLIMENT: SUITE20003
ADDRESSDISTRICTNAME: FINANCIALDISTRICT03
ADDRESSSTREETNUMBER: 782
BUILDINGCOMPARTMENT: BUILDINGAFLOOR503
VENDORLEGALENTITYID: UUMF
ADDRESSLOCATIONROLES: BUSINESSDELIVERYINVOICE03
ADDRESSCOUNTRYREGIONID: GD
ATTENTIONTOADDRESSLINE: ATTNRECEIVINGDEPTDOCK503
ISPRIVATEPOSTALADDRESS: 3
ADDRESSCOUNTRYREGIONISOCODE: UU

Rule Validation Summary

Source Rule Count: 47
Governed Rule Count: 47

Migration Details

Classification

Target Structure