Skip to main content
Avalara Help Center

TTE exemption assignment

TTE data schema

TTE_data_schema_entity_to_exemption.png

TTE table flow

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

Exemption certificate table

TTE_exemption_certificate            
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 ExemptType X   N String 50 Unique identifier for the exemption type
4 CertificateNumber X   N String 50 The certificate number assigned by the tax authority
5 CertificateHolderName   X Y String 50 The name of the organization or individual identified on the certificate
6 CertificateCountry   X Y String 50 Issuing country
7 CertificateStateProvince   X Y String 50 Issuing state or province
8 CertificateExpirationDate   X N DateTime 23 Date and time the certificate expires
9 RecordCreatedTimestamp   X N DateTime 23 Date and time this record is created

Exemption type table

TTE_exemption_type            
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 ExemptType X   N String 50 Unique identifier for the exemption type
4 ExemptTypeName   X N String 50 Name of the exemption type associated with the ExemptTypeID (resale, not-for-profit, government, and so on)
5 ExemptAllAuthorityIndicator   X Y Boolean 1 Indicates whether the exemption applies to all tax authorities
6 ExemptAllTaxCodeIndicator   X Y Boolean 1 Indicates whether the exemption applies to all tax codes
7 TaxAuthorityID   X Y String 50 Unique identifier for the tax authority
8 TaxAuthorityName   X Y String 254 Name of the tax authority associated with the TaxAuthorityID (country, state or province, county or parish, city or township, or district)
9 TaxAuthorityLevel   X Y String 50 Valid tax authority levels include: country, state or province, county or parish, city or township, and district
10 ReducedBy   X Y Double 8,6 Tax percentage by which the rate should be reduced
11 TaxCodeID   X Y String 50 Unique identifier for the tax code
12 TaxCodeName   X Y String 254 Name of the tax code associated with the TaxCodeID
13 EffectiveDateTime   X N DateTime 23 Date and time the exemption type assignment goes into effect
14 EndDateTime   X N DateTime 23 Date and time the exemption type assignment expires
15 RecordCreatedTimestamp   X N DateTime 23 Date and time this record is created
  • Was this article helpful?