Table: dbo.Payment_Term_Discount_Method
Type table which will have discount types that determine how payments will be discounted.
Columns
NameTypeConstraintsDescription
payment_term_discount_method_KEYtinyint (1)NOT NULLPrimary key for this table.
descriptionnvarchar (20)NOT NULLThe description of the payment term method.
Primary key
NameColumnsDescription
PK_Payment_Term_Discount_Methodpayment_term_discount_method_KEY
Unique constraints
NameColumnsDescription
UK_Payment_Term_Discount_Method$descriptiondescription
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Payment_Term__Payment_Term_Method__payment_term_discount_method_KEYpayment_term_discount_method_KEYPayment_Term
FK_AR_Item__Payment_Term_Discount_Method__additional_charge__payment_term_discount_method_KEYadditional_charge__payment_term_discount_method_KEYAR_Item

Schema diagram