Locations
Locations table for AvalaraAvatax data provider.
Insert
To create a location at least the following fields should be specified.
INSERT INTO Locations (CompanyId, Line1, LocationCode, AddressTypeId, AddressCategoryId, PostalCode, Country) VALUES (247015, '2000 Main Street', 'L001', 'Location', 'MainOffice', 92614, 'US')
Update
To update a location, you need to specify Id and CompanyId in WHERE clause.
UPDATE Locations SET City = 'Irvine' WHERE Id = 56789 AND CompanyId = 247015
Delete
To delete a location, you need to specify Id and AccountId in WHERE clause.
DELETE FROM Locations WHERE Id = 56789 AND CompanyId = 247015
Columns
| Name | Type | ReadOnly | Description |
| Id [KEY] | Int | False |
The unique ID number of this location. |
| CompanyId [KEY] | Int | False |
The unique ID number of the company that operates at this location. |
| RegisteredDate | Datetime | False |
The date when this location was registered with a tax authority. Not required. |
| DbaName | String | False |
If this location has a different business name from its legal entity name, specify the 'Doing Business As' name for this location. |
| EffectiveDate | Date | False |
The date when this location was opened for business, or null if not known. |
| CreatedUserId | Int | False |
The User ID of the user who created this record. |
| AddressCategoryId | String | False |
Indicates the type of place of business represented by this location. |
| Region | String | False |
Name or ISO 3166 code identifying the region within the country of the physical address of this location. |
| LastTransactionDate | Datetime | False |
The most recent date when a transaction was processed for this location. Set by AvaTax. |
| ModifiedDate | Datetime | False |
The date/time when this record was last modified. |
| OutletName | String | False |
A friendly name for this location. |
| IsRegistered | Bool | False |
Set this flag to true to indicate that this location has been registered with a tax authority. |
| Line3 | String | False |
The third line of the physical address of this location. |
| LocationCode | String | False |
A code that identifies this location. Must be unique within your company. |
| PostalCode | String | False |
The postal code or zip code of the physical address of this location. |
| Line2 | String | False |
The second line of the physical address of this location. |
| Line1 | String | False |
The first line of the physical address of this location. |
| AddressTypeId | String | False |
Indicates whether this location is a physical place of business or a temporary salesperson location. |
| ModifiedUserId | Int | False |
The user ID of the user who last modified this record. |
| Country | String | False |
Name or ISO 3166 code identifying the country of the physical address of this location. |
| City | String | False |
The city of the physical address of this location. |
| Description | String | False |
A friendly name for this location. |
| County | String | False |
The county name of the physical address of this location. Not required. |
| IsDefault | Bool | False |
Set this flag to true to indicate that this is the default location for this company. |
| EndDate | Date | False |
If this place of business has closed, the date when this location closed business. |
| LinkedSettings | String | False |
Extra information required by certain jurisdictions for filing. |
| CreatedDate | Datetime | False |
The date when this record was created. |
| PageKey | String | False |