TTE discount assignment

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

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

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

TTE data schema