Table: dbo.AR_Payment_Type
Table to identify the different payment classifications for an AR payment
Columns
NameTypeConstraintsDescription
ar_payment_type_KEYint (4)NOT NULLPrimary key
descriptionnvarchar (22)NOT NULLClassification of the payment
Primary key
NameColumnsDescription
PK_AR_Payment_Typear_payment_type_KEY
Unique constraints
NameColumnsDescription
UK_AR_Payment_Type$descriptiondescription
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_AR_Payment__AR_Payment_Type__ar_payment_type_KEYar_payment_type_KEYAR_Payment

Schema diagram