Table: dbo.Payment_Term_Basis
Type table that will have payment bases that will determine the payment discount date or due date.
Columns
NameTypeConstraintsDescription
payment_term_basis_KEYint (4)NOT NULLPrimary key for this table.
descriptionnvarchar (18)NOT NULLThe description of the payment term basis.
Primary key
NameColumnsDescription
PK_Payment_Term_Basispayment_term_basis_KEY
Unique constraints
NameColumnsDescription
UK_Payment_Term_Basis$descriptiondescription
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Payment_Term__Payment_Term_Basis__discount_date__payment_term_basis_KEYdiscount_date__payment_term_basis_KEYPayment_Term
FK_Payment_Term__Payment_Term_Basis__due_date__payment_term_basis_KEYdue_date__payment_term_basis_KEYPayment_Term

Schema diagram