Location
Holds location-specific data, including addresses, contact information, and configuration settings, to support multi-location operations.
Columns
| Name | Type | ReadOnly | Description |
| Locationid [KEY] | String | False |
The unique identifier for the location. |
| Recordno | Int64 | False |
The record number associated with the location. |
| Name | String | False |
The name of the location. |
| Parentid | String | False |
The identifier of the parent location, if applicable. |
| Supervisorname | String | False |
The name of the supervisor for the location. |
| Supervisorid | String | False |
The identifier of the supervisor for the location. |
| Contactinfo_contactname | String | False |
The contact name for the location. |
| Contactinfo_printas | String | False |
The name to be printed for the location contact. |
| Contactinfo_phone1 | String | False |
The primary phone number for the location. |
| Contactinfo_phone2 | String | False |
The secondary phone number for the location. |
| Contactinfo_email1 | String | False |
The primary email address for the location. |
| Contactinfo_email2 | String | False |
The secondary email address for the location. |
| Contactinfo_fax | String | False |
The fax number for the location. |
| Contactinfo_mailaddress_address1 | String | False |
The first line of the mailing address for the location. |
| Contactinfo_mailaddress_address2 | String | False |
The second line of the mailing address for the location. |
| Contactinfo_mailaddress_city | String | False |
The city of the location's mailing address. |
| Contactinfo_mailaddress_state | String | False |
The state of the location's mailing address. |
| Contactinfo_mailaddress_zip | String | False |
The zip code of the location's mailing address. |
| Contactinfo_mailaddress_country | String | False |
The country of the location's mailing address. |
| Contactinfo_mailaddress_countrycode | String | False |
The country code of the location's mailing address. |
| Startdate | Datetime | False |
The start date for the location's operations. |
| Enddate | Datetime | False |
The end date for the location's operations. |
| Shipto_contactname | String | False |
The contact name for shipping purposes at the location. |
| Shipto_phone1 | String | False |
The primary phone number for shipping purposes at the location. |
| Shipto_phone2 | String | False |
The secondary phone number for shipping purposes at the location. |
| Shipto_mailaddress_address1 | String | False |
The first line of the shipping address for the location. |
| Shipto_mailaddress_address2 | String | False |
The second line of the shipping address for the location. |
| Shipto_mailaddress_city | String | False |
The city of the shipping address for the location. |
| Shipto_mailaddress_state | String | False |
The state of the shipping address for the location. |
| Shipto_mailaddress_zip | String | False |
The zip code of the shipping address for the location. |
| Shipto_mailaddress_country | String | False |
The country of the shipping address for the location. |
| Shipto_mailaddress_countrycode | String | False |
The country code of the shipping address for the location. |
| Status | String | False |
The current status of the location. |
| Whencreated | Datetime | False |
The date and time when the location record was created. |
| Whenmodified | Datetime | False |
The date and time when the location record was last modified. |
| Federalid | String | False |
The federal identification number for the location. |
| Firstmonth | String | False |
The first month of operation for the location. |
| Weekstart | String | False |
The starting day of the week for the location's schedule. |
| Iepayable_account | String | False |
The accounts payable account for the location. |
| Iepayable_number | String | False |
The accounts payable number for the location. |
| Iereceivable_account | String | False |
The accounts receivable account for the location. |
| Iereceivable_number | String | False |
The accounts receivable number for the location. |
| Message_text | String | False |
The message text associated with the location. |
| Marketing_text | String | False |
The marketing text associated with the location. |
| Footnotetext | String | False |
The footer text associated with the location. |
| Reportprintas | String | False |
The format in which the location report is printed. |
| Isroot | String | False |
Indicates if the location is a root location in the hierarchy. |
| Reserveamt | String | False |
The reserve amount for the location. |
| Vendorname | String | False |
The name of the vendor associated with the location. |
| Vendorid | String | False |
The identifier of the vendor associated with the location. |
| Customerid | String | False |
The identifier of the customer associated with the location. |
| Customername | String | False |
The name of the customer associated with the location. |
| Currency | String | False |
The currency used at the location. |
| Has_ie_relation | Boolean | False |
Indicates whether the location has an internal/external relation. |
| Custtitle | String | False |
The customer title associated with the location. |
| Businessdays | String | False |
The business days for the location. |
| Weekends | String | False |
The weekends observed at the location. |
| Firstmonthtax | String | False |
The tax for the first month of operation at the location. |
| Contactkey | Int64 | False |
The key for the contact associated with the location. |
| Supervisorkey | Int64 | False |
The key for the supervisor associated with the location. |
| Parentkey | Int64 | False |
The key for the parent location, if applicable. |
| Shiptokey | Int64 | False |
The key for the shipping address associated with the location. |
| Vendentity | String | False |
The vendor entity associated with the location. |
| Custentity | String | False |
The customer entity associated with the location. |
| Taxid | String | False |
The tax ID for the location. |
| Createdby | Int64 | False |
The user who created the location record. |
| Modifiedby | Int64 | False |
The user who last modified the location record. |
| Record_url | String | False |
The URL to access the location record. |