TTE exemption 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_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

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

TTE data schema