TAXID (Table)

Primary Key	Field Type
ID	uniqueidentifier

Field	Field Type	Notes	Description
TAXINGAUTHORITY	nvarchar(100)	Default = ''	User Defined unique description of this tax
DESCRIPTION	nvarchar(255)	Default = ''	Long description of this tax
TAXIDNUMBER	nvarchar(20)	Default = ''	User Defined unique description of this tax
ENTITYTYPECODE	tinyint	Default = 1	Taxing entity
STATUSCODE	tinyint	Default = 1	Tax ID status
STATUS	nvarchar(8) (Computed)	CASE [STATUSCODE] WHEN 0 THEN N'Inactive' WHEN 1 THEN N'Active' END	Provides a translation for the 'STATUSCODE' field.
DATEADDED	datetime	Default = getdate()	Indicates the date this record was added.
DATECHANGED	datetime	Default = getdate()	Indicates the date this record was last changed.
TS	timestamp		Timestamp.
TSLONG	bigint (Computed)	CONVERT(bigint, TS)	Numeric representation of the timestamp.
ENTITYTYPE	nvarchar(7) (Computed)	CASE [ENTITYTYPECODE] WHEN 0 THEN N'Federal' WHEN 1 THEN N'State' WHEN 2 THEN N'Local' END	Provides a translation for the 'ENTITYTYPECODE' field.

Foreign Key	Field Type	Notes	Description
STATEID	uniqueidentifier	STATE.LOCALID	FK to STATE
ADDEDBYID	uniqueidentifier	CHANGEAGENT.ID	FK to CHANGEAGENT.
CHANGEDBYID	uniqueidentifier	CHANGEAGENT.ID	FK to CHANGEAGENT.