Skip to main content
Avalara Help Center

TTE tax group assignment

 

A warning icon

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

TTE data schema

 

taxgroup.png

TTE table flow

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

Tax group table

TTE_taxgroup            
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 Avalara unique identifier for the company
3 CompanyCode X   N String 50 Customer unique identifier for the company
4 TaxGroupID X   N String 50 Unique identifier for the tax group (Item classification)
5 TaxCodeID X   N String 50 Unique identifier for the tax code
6 TaxCodeName   X N String 50 Avalara name for the Tax Code associated to the Avalara TaxCodeID
7 TaxCodeCreatedDate   X N DateTime 23

Avalara date for when the Tax Code was created

8 TaxGroupName   X Y String 254 Customer name for the tax group associated to the TaxGroupID
9 EffectiveDateTime   X N DateTime 23 Date and time the tax group goes into effect
10 EndDateTime   X N DateTime 23 Date and time the tax group expires
11 RecordCreatedTimestamp   X N DateTime 23 Date and time this record is created

 

  • Was this article helpful?