Locations – ReferenceExport files

Export files

Reference for the columns, in file order, of the Location master data Excel file downloaded from Settings.

The Location master data file contains one row for each Location. Column headings are shown exactly as they appear in the file.

To download it, click the gear icon at the top of the Locations page (or open Settings with the gear icon at the bottom of the left-hand navigation bar), then go to Master Data Settings > Location and use Download Location Master Data. See Master Data Settings. To download only some Locations, tick their rows in the list and select Download in the selection bar; see Browse and manage Locations.

Location master data

ColumnDescription
Location IdentifierYour identifier
Location NameName
Location GroupGroup name
GLNGlobal Location Number
DUNSDUNS number
License NumberLicense number
Contact NameContact person
Contact PhoneContact phone
Contact EmailContact email
Address line 1First address line
Address line 2Second address line
CityCity
StateState or province
Postal codePostal code
CountryCountry
LongitudeLongitude (listed before Latitude)
LatitudeLatitude
Trade Partner IdentifierIdentifier of the Trade Partner
Trade PartnerTrade Partner name
OwnerOwning account
Owner Location IdentifierThe owner's Location Number or ID in the owner's own Wholechain account
ArchivedWhether the record is archived

The file has no Location type column.