Table: dbo.AR_Item_Tax_Status
This table stores the different item tax statuses.
Columns
NameTypeConstraintsDescription
ar_item_tax_status_KEYint (4)NOT NULLPrimary key for this table.
descriptionnvarchar (20)NOT NULLdescription of the tax status.
Primary key
NameColumnsDescription
PK_AR_Item_Tax_Statusar_item_tax_status_KEY
Unique constraints
NameColumnsDescription
UK_AR_Item_Tax_Status$descriptiondescription
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_AR_Item__AR_Item_Tax_Status__ar_item_tax_status_KEYar_item_tax_status_KEYAR_Item
FK_AR_Transaction_Item__AR_Item_Tax_Status__ar_item_tax_status_KEYar_item_tax_status_KEYAR_Transaction_Item

Schema diagram