location
The location table.
Columns
Name | Type | References | Description |
id [KEY] | Integer | Internal ID | |
defaultallocationpriority | Double | Default Allocation Priority | |
externalid | String | External ID | |
fullname | String | Full Name | |
includeincontroltower | Boolean | Include In Control Tower | |
includeinsupplyplanning | Boolean | Include in Supply Planning | |
isinactive | Boolean | Location is Inactive | |
lastmodifieddate | Datetime | Last Modified Date | |
latitude | Double | Latitude | |
locationtype | Integer | Location Type | |
longitude | Double | Longitude | |
mainaddress | String | Address | |
makeinventoryavailable | Boolean | Make Inventory Available | |
makeinventoryavailablestore | Boolean | Make Inventory Available in Web Store | |
name | String | Name | |
parent | Integer | Parent Location | |
returnaddress | String | Return Address | |
sopredconfidence | Double | Sales Order Predicted Risk Confidence | |
sopredicteddays | Integer | Sales Order Predicted Days Late/Early | |
subsidiary | String | Subsidiary | |
topredconfidence | Double | Transfer Order Predicted Risk Confidence | |
topredicteddays | Integer | Transfer Order Predicted Days Late/Early | |
tranprefix | String | Document Number Prefix | |
usebins | Boolean | Use Bins |