Skip to main content
Avalara Help Center

TTE discount assignment

TTE data schema

TTE_data_schema_entity_to_discount.png

TTE table flow

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

Discount table

TTE_discount            
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 DiscountID X   N String 50 Unique identifier for the discount
4 DiscountName   X N String 60 Name of the discount associated with the DiscountID (retail, vendor, and so on)
5 DiscountAllIndicator   X Y Boolean 1 Indicates whether the discount applies to all tax authorities
6 GrossInd   X Y Boolean 1 Indicates that the discount is taxable at the full item price
7 TaxAuthorityID   X N String 50 Unique identifier for the tax authority; identify authority applying to the discount if DiscountAllIndicator is false
8 EffectiveDateTime   X N DateTime 23 Date and time the discount goes into effect
9 EndDateTime   X N DateTime 23 Date and time the discount 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
  • Was this article helpful?