Skip to main content
Avalara Help Center

TTE location assignment

 

A warning icon

The information on this page is subject to change based on the latest upcoming updates for future releases.

 

Physical location to tax jurisdiction

TTE data schema

 

physical_location.png

TTE table flow

TTE_table_flow_physical_loc.png

Entity table

 

TTE_entity            
Field # Field name PK FK Null Type Width Description
1 AccountID X   N String 50 Unique identifier for the Avalara account
2 CompanyID X   N String 50 Unique identifier for the company
3 CompanyCode X   N String 50 Customer unique identifier for the company
4 CompanyName   X N String 60 Name of the company associated with the CompanyID
5 EffectiveDateTime   X N DateTime 23 Date and time the company goes into effect
6 EndDateTime   X N DateTime 23 Date and time the company expires
7 RecordCreatedTimestamp   X N DateTime 23 Date and time this record is created

Physical location region table

 

TTE_physical_location_region            
Field # Field name PK FK Null Type Width Description
1 AccountID X   N String 50 Unique identifier for the Avalara account
2 CompanyID X   N String 50 Unique identifier for the company
3 CompanyCode X   N String 50 Customer unique identifier for the company
4 PhysicalLocationID X   N String 50 Unique identifier for the physical location (warehouse, store, kiosk, and so on)
5 PhysicalLocationName   X N String 60 Name of the physical location associated with the PhysicalLocationID
6 TaxRegionID   X N String 50 Unique identifier for the tax region
7 LastAssignTaxRegionID   X Y String 50 Previous TaxRegionID assigned to this PhysicalLocationID, if different
8 EffectiveDateTime   X N DateTime 23 Date and time the physical location to region mapping goes into effect
9 EndDateTime   X N DateTime 23 Date and time the physical location to region mapping expires
10 RecordCreatedTimestamp   X N DateTime 23 Date and time this record is created

 

Tax region jurisdiction table

 

TTE_tax_region_jurisdiction            
Field # Field name PK FK Null Type Width Description
1 AccountID X   N String 50 Unique identifier for the Avalara account
2 CompanyID X   N String 50 Unique identifier for the company
3 CompanyCode X   N String 50

Customer unique identifier for the company

4 TaxRegionID X   N String 50 Unique identifier for the tax region
5 TaxRegionName   X N String 254 Name of the tax region associated to the TaxRegionID (combined country, state/province, county/parish, city/township, and district)
6 TaxRegionCountry   X N String 50 Name of the country associated with the TaxRegionID
7 TaxRegionStateProvince   X N String 50 Name of the state or province associated with the TaxRegionID
8 TaxJurisdictionID X   N String 50 Unique identifier for the tax jurisdiction
9 EffectiveDateTime   X N DateTime 23 Date and time the tax region to tax authority mapping goes into effect
10 EndDateTime   X N DateTime 23 Date and time the tax region to tax authority mapping expires
11 RecordCreatedTimestamp   X N DateTime 23 Date and time this record is created

Tax jurisdiction table

 

TTE_tax_jurisdiction            
Field # Field name PK FK Null Type Width Description
1 AccountID X   N String 50 Unique identifier for the Avalara account
2 CompanyID X   N String 50 Unique identifier for the company
3 CompanyCode X   N String 50

Customer unique identifier for the company

4 TaxJurisdictionID X   N String 50 Unique identifier for the tax jurisdiction
5 TaxJurisdictionName   X N String 254 Name of the tax jurisdiction associated with the TaxJurisdictionID (country, state or province, county or parish, city or township, or district)
6 TaxJurisdictionLevel   X N String 50 Valid tax jurisdiction levels include: country, state or province, county or parish, city or township, and district
7 RoundingMethod   X N String 50 A method indicating how the rate should be rounded during calculation
8 RoundingDigits   X N Integer 1 The number of digits to which rounding is calculated
9 EffectiveDateTime   X N DateTime 23 Date and time the tax jurisdiction goes into effect
10 EndDateTime   X N DateTime 23 Date and time the tax jurisdiction expires
11 RecordCreatedTimestamp   X N DateTime 23 Date and time this record is created

Postal location to tax jurisdiction

TTE data schema

 

postal_location-TTEE.png

 

TTE table flow

TTE_table_flow_postal_loc.png

Entity table

 

TTE_entity            
Field # Field name PK FK Null Type Width Description
1 AccountID X   N String 50 Unique identifier for the Avalara account
2 CompanyID X   N String 50 Unique identifier for the company
3 CompanyName   X N String 60 Name of the company associated with the CompanyID
4 EffectiveDateTime   X N DateTime 23 Date and time the company goes into effect
5 EndDateTime   X N DateTime 23 Date and time the company expires
6 RecordCreatedTimestamp   X N DateTime 23 Date and time this record is created

Postal location region table

 

TTE_postal_location_region            
Field # Field name PK FK Null Type Width Description
1 AccountID X   N String 50 Unique identifier for the Avalara account
2 CompanyID X   N String 50 Unique identifier for the company
3 CompanyCode X   N String 50

Customer unique identifier for the company

4 PostalLocationID X   N String 50 Unique identifier for the postal location (5-digit postal code (US), 6-digit postal code (CAN), and so on)
5 TaxRegionID   X N String 50 Unique identifier for the tax region
6 EffectiveDateTime   X N DateTime 23 Date and time the postal location to region mapping goes into effect
7 EndDateTime   X N DateTime 23 Date and time the postal location to region mapping expires
8 LastAssignTaxRegionID   X Y String 50 Previous TaxRegionID assigned to this PostalLocationID, if different
9 RecordCreatedTimestamp   X N DateTime 23 Date and time this record is created

Tax region tax jurisdiction table

 

TTE_tax_region_jurisdiction            
Field # Field name PK FK Null Type Width Description
1 AccountID X   N String 50 Unique identifier for the Avalara account
2 CompanyID X   N String 50 Unique identifier for the company
3 CompanyCode X   N String 50

Customer unique identifier for the company

4 TaxRegionID X   N String 50 Unique identifier for the tax region
5 TaxRegionName   X N String 254 Name of the tax region associated to the TaxRegionID (combined country, state/province, county/parish, city/township, and district)
6 TaxRegionCountry   X N String 50 Name of the country associated with the TaxRegionID
7 TaxRegionStateProvince   X N String 50 Name of the state or province associated with the TaxRegionID
8 TaxJurisdictionID X   N String 50 Unique identifier for the tax jurisdiction
9 EffectiveDateTime   X N DateTime 23 Date and time the tax region to tax authority mapping goes into effect
10 EndDateTime   X N DateTime 23 Date and time the tax region to tax authority mapping expires
11 RecordCreatedTimestamp   X N DateTime 23 Date and time this record is created

Tax jurisdiction table

 

TTE_tax_jurisdiction            
Field # Field name PK FK Null Type Width Description
1 AccountID X   N String 50 Unique identifier for the Avalara account
2 CompanyID X   N String 50 Unique identifier for the company
3 CompanyCode X   N String 50

Customer unique identifier for the company

4 TaxJurisdictionID X   N String 50 Unique identifier for the tax jurisdiction
5 TaxJurisdictionName   X N String 254 Name of the tax jurisdiction associated with the TaxJurisdictionID (country, state or province, county or parish, city or township, or district)
6 TaxJurisdictionLevel   X N String 50 Valid tax jurisdiction levels include: country, state or province, county or parish, city or township, and district
7 RoundingMethod   X N String 50 A method indicating how the rate should be rounded during calculation
8 RoundingDigits   X N Integer 1 The number of digits to which rounding is calculated
9 EffectiveDateTime   X N DateTime 23 Date and time the tax jurisdiction goes into effect
10 EndDateTime   X N DateTime 23 Date and time the tax jurisdiction expires
11 RecordCreatedTimestamp   X N DateTime 23 Date and time this record is created
  • Was this article helpful?