Table: dbo.Billing_Item_1099_Type
This table is used to hold the differnt types of 1099 forms.
Columns
NameTypeConstraintsDescription
billing_item_1099_type_KEYint (4)NOT NULLPrimary Key
descriptionnvarchar (32)NOT NULLThe 1099 form name.
Primary key
NameColumnsDescription
PK_Billing_Item_1099_Typebilling_item_1099_type_KEY
Unique constraints
NameColumnsDescription
UK_Billing_Item_1099_Type$descriptiondescription
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Form_Processing_Run_Form_Count__Billing_Item_1099_Type__billing_item_1099_type_KEYbilling_item_1099_type_KEYForm_Processing_Run_Form_Count
FK_Billing_Item_Form_Rate__Billing_Item_1099_Type__billing_item_1099_type_KEYbilling_item_1099_type_KEYBilling_Item_Form_Rate

Schema diagram