Location

location

Fields

Label ID Type UI Workbook SuiteScript / SuiteTalk REST Web Services Connect
Address mainaddress summary Yes Yes Yes
Allow Store Pickup allowstorepickup checkbox Yes Yes Yes
Automatic Location Assignment autoassignmentregionsetting select Yes Yes Yes
Buffer Stock bufferstock integer Yes Yes Yes
Business Hours businesshours sublist Yes Yes Yes
Daily Shipping Capacity dailyshippingcapacity integer Yes Yes Yes
Derive From Postal Code geolocationmethod select Yes Yes Yes
Document Number Prefix tranprefix text Yes Yes Yes
Email for Store Pickup Alerts pickupalertemail emails Yes Yes Yes
Excluded Regions excludelocationregions sublist Yes Yes Yes
External ID externalid text Yes Yes Yes
Full Name fullname text Yes Yes Yes
General inventory turn-over velocity invtturnovervelocity integer Yes Yes Yes
Include Children includechildren checkbox Yes Yes Yes
Included Regions includelocationregions sublist Yes Yes Yes
Include In Control Tower includeincontroltower checkbox Yes Yes Yes
Include in Supply Planning includeinsupplyplanning checkbox Yes Yes Yes
Internal ID id integer Yes Yes Yes
Latitude latitude float Yes Yes Yes
Location is Inactive isinactive checkbox Yes Yes Yes
Location Type locationtype select Yes Yes Yes
Longitude longitude float Yes Yes Yes
Make Inventory Available makeinventoryavailable checkbox Yes Yes Yes
Make Inventory Available in Web Store makeinventoryavailablestore checkbox Yes Yes Yes
Memo storefulfillmentmemo textarea Yes Yes Yes
Name name text Yes Yes Yes
Next Pickup Cut-Off Time nextpickupcutofftime datetime Yes Yes Yes
Return Address returnaddress summary Yes Yes Yes
Sales Order Predicted Days Late/Early sopredicteddays integer Yes Yes Yes
Sales Order Predicted Risk Confidence sopredconfidence percent Yes Yes Yes
Store Pickup Buffer Stock storepickupbufferstock float Yes Yes Yes
Sublocation of parent select Yes Yes Yes
Subsidiaries subsidiary multiselect Yes Yes Yes
Total Shipping Capacity totalshippingcapacity integer Yes Yes Yes
Transaction Number Prefix traninternalprefix text Yes Yes Yes
Transfer Order Predicted Days Late/Early topredicteddays integer Yes Yes Yes
Transfer Order Predicted Risk Confidence topredconfidence percent Yes Yes Yes
Translation classtranslation sublist Yes Yes Yes
Use Bins usebins checkbox Yes Yes Yes
Use Warehouse Management usewarehousemanagement checkbox Yes Yes Yes

Joins

Join Target Record UI Workbook SuiteScript / SuiteTalk REST Web Services Connect
Business Hours to Location (location.id) business hours (locationbusinesshour, locationbusinesshour.location) No Yes Yes
Excluded Regions to Location (location.id) excluded regions (excludelocationregionitem, excludelocationregionitem.location) No Yes Yes
Location to Address (locationMainAddress.nkey) location (location, location.mainaddress) No Yes Yes
Location to Location (location.id) location (location, location.parent) No Yes Yes
Location to Address (locationReturnAddress.nkey) location (location, location.returnaddress) No Yes Yes