Table: dbo.AR_Item_Type
This table stores the AR item types.
Columns
NameTypeConstraintsDescription
ar_item_type_KEYint (4)NOT NULLPrimary key for this table.
descriptionnvarchar (30)NOT NULLdescription of the AR item type.
Primary key
NameColumnsDescription
PK_AR_Item_Typear_item_type_KEY
Unique constraints
NameColumnsDescription
UK_AR_Item_Type$descriptiondescription
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_AR_Item__AR_Item_Type__ar_item_type_KEYar_item_type_KEYAR_Item
FK_Spreadsheet_Import_AR_Item__AR_Item_Type__ar_item_type_KEYar_item_type_KEYSpreadsheet_Import_AR_Item
FK_AR_Transaction_Item__AR_Item_Type__ar_item_type_KEYar_item_type_KEYAR_Transaction_Item

Schema diagram