Table: dbo.Transaction_Template_Automatic_Type
Transaction Template Automatic Types - enumerates the supported subtypes for automatic transaction templates
Columns
NameTypeConstraintsDescription
transaction_template_automatic_type_KEYint (4)NOT NULLPrimary key
descriptionnvarchar (60)NOT NULLValues: None, Percentage, Inventory, Income tax
Primary key
NameColumnsDescription
PK_Transaction_Template_Automatic_Typetransaction_template_automatic_type_KEY
Unique constraints
NameColumnsDescription
UK_Transaction_Template_Automatic_Type$descriptiondescription
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Transaction_Template__Transaction_Template_Automatic_Type__transaction_template_automatic_type_KEYtransaction_template_automatic_type_KEYTransaction_Template

Schema diagram