Skip to main content
Avalara Help Center

TTE location assignment

Physical location to tax authority

TTE data schema

TTE_data_schema_physical_loc.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 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

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 PhysicalLocationID X   N String 50 Unique identifier for the physical location (warehouse, store, kiosk, and so on)
4 PhysicalLocationName   X N String 60 Name of the physical location associated with the PhysicalLocationID
5 TaxRegionID   X N String 50 Unique identifier for the tax region
6 LastAssignTaxRegionID   X Y String 50 Previous TaxRegionID assigned to this PhysicalLocationID, if different
7 EffectiveDateTime   X N DateTime 23 Date and time the physical location to region mapping goes into effect
8 EndDateTime   X N DateTime 23 Date and time the physical location to region mapping expires
9 RecordCreatedTimestamp   X N DateTime 23 Date and time this record is created

Tax region tax authority table

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

Tax authority table

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

Postal location to tax authority

TTE data schema

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

Tax region tax authority table

TTE_tax_region_tax_authority            
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 TaxRegionID X   N String 50 Unique identifier for the tax region
4 TaxRegionName   X N String 254 Name of the Tax Region associated to the TaxRegionID (combined country, state or province, county or parish, city or township, and district)
5 TaxRegionCountry   X N String 50 Name of the country associated with the TaxRegionID
6 TaxRegionStateProvince   X N String 50 Name of the state or province associated with the TaxRegionID
7 TaxAuthorityID X   N String 50 Unique identifier for the tax authority
8 EffectiveDateTime   X N DateTime 23 Date and time the tax region to tax authority mapping goes into effect
9 EndDateTime   X N DateTime 23 Date and time the tax region to tax authority mapping expires
10 RecordCreatedTimestamp   X N DateTime 23 Date and time this record is created

Tax authority table

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