Sites

In Scope

Technical: InventSite | ID: D365FO-INV-INVENTSITE-SITES

See how this object fits into Inventory Warehouse

Review the broader sequencing and dependencies for this domain

Migration Details

Complexity: Low
Sequencing: Stage 1 - Master Data
Typical Sources: ERPLegacy

Classification

Object Type: dictionary

Target Structure

Load Approach: Table
Target Objects: InventSite

Field Definitions(5)

Rules & Considerations(26)

Sample Load Data(3)

_scenario	NameR	SiteIdRPK	DataAreaIdRPK	IsActive	SiteType	Timezone	AddressCity	AddressState	InventSiteId	AddressStreet	IsServiceSite	AddressValidTo	AddressZipCode	AddressCountyId	AddressTimeZone	AddressValidFrom	SiteBlockedReason	AddressDescription	DefaultWarehouseId	AddressStreetNumber	AddressCountryRegionId	AddressBuildingCompliment
Example values from field definitions	Minnesota Plant	USMN	USMF	Yes	Production	GMTMinus0500EasternTimeUSCanada	Redmond	WA	USMN	123 Main St	Yes	2099-12-31	98052	KING	GMTMinus0500EasternTimeUSCanada	2023-01-01	Sales	Main Factory Address	USMN-MAIN	123B	US	Suite 500
Variation 1 - type-safe variation anchored to example values	MINNESOTAPLANT02	VSMN	VSMF	ZES	QRODUCTION	GMTMINUS0500EASTERNTIMEUSCANA02	SEDMOND	XA	VSMN	123MAINST02	ZES	21000206	98051	LING	GMTMINUS0500EASTERNTIMEUSCANA02	20230207	TALES	MAINFACTORYADDRESS02	USMNMAIN02	1231	VS	SUITE50002
Variation 2 - additional in-range variation with row-level constraint alignment	MINNESOTAPLANT03	UUMN	UUMF	YGS	PTODUCTION	GMTMINUS0500EASTERNTIMEUSCANA03	RGDMOND	WC	UUMN	123MAINST03	YGS	21000315	98052	KKNG	GMTMINUS0500EASTERNTIMEUSCANA03	20230316	SCLES	MAINFACTORYADDRESS03	USMNMAIN03	1232	UU	SUITE50003

Example values from field definitions

NameR: Minnesota Plant
SiteIdRPK: USMN
DataAreaIdRPK: USMF
IsActive: Yes
SiteType: Production
Timezone: GMTMinus0500EasternTimeUSCanada
AddressCity: Redmond
AddressState: WA
InventSiteId: USMN
AddressStreet: 123 Main St
IsServiceSite: Yes
AddressValidTo: 2099-12-31
AddressZipCode: 98052
AddressCountyId: KING
AddressTimeZone: GMTMinus0500EasternTimeUSCanada
AddressValidFrom: 2023-01-01
SiteBlockedReason: Sales
AddressDescription: Main Factory Address
DefaultWarehouseId: USMN-MAIN
AddressStreetNumber: 123B
AddressCountryRegionId: US
AddressBuildingCompliment: Suite 500

Variation 1 - type-safe variation anchored to example values

NameR: MINNESOTAPLANT02
SiteIdRPK: VSMN
DataAreaIdRPK: VSMF
IsActive: ZES
SiteType: QRODUCTION
Timezone: GMTMINUS0500EASTERNTIMEUSCANA02
AddressCity: SEDMOND
AddressState: XA
InventSiteId: VSMN
AddressStreet: 123MAINST02
IsServiceSite: ZES
AddressValidTo: 21000206
AddressZipCode: 98051
AddressCountyId: LING
AddressTimeZone: GMTMINUS0500EASTERNTIMEUSCANA02
AddressValidFrom: 20230207
SiteBlockedReason: TALES
AddressDescription: MAINFACTORYADDRESS02
DefaultWarehouseId: USMNMAIN02
AddressStreetNumber: 1231
AddressCountryRegionId: VS
AddressBuildingCompliment: SUITE50002

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

NameR: MINNESOTAPLANT03
SiteIdRPK: UUMN
DataAreaIdRPK: UUMF
IsActive: YGS
SiteType: PTODUCTION
Timezone: GMTMINUS0500EASTERNTIMEUSCANA03
AddressCity: RGDMOND
AddressState: WC
InventSiteId: UUMN
AddressStreet: 123MAINST03
IsServiceSite: YGS
AddressValidTo: 21000315
AddressZipCode: 98052
AddressCountyId: KKNG
AddressTimeZone: GMTMINUS0500EASTERNTIMEUSCANA03
AddressValidFrom: 20230316
SiteBlockedReason: SCLES
AddressDescription: MAINFACTORYADDRESS03
DefaultWarehouseId: USMNMAIN03
AddressStreetNumber: 1232
AddressCountryRegionId: UU
AddressBuildingCompliment: SUITE50003

Rule Validation Summary

Source Rule Count: 26
Governed Rule Count: 26