Table: dbo.AP_Payment_Type
This table defines all of our payment types used in manage ap payments processing.
Columns
NameTypeConstraintsDescription
ap_payment_type_KEYint (4)NOT NULLPrimary Key for this table.
descriptionnvarchar (60)NOT NULLthe description of the ap payment type.
Primary key
NameColumnsDescription
PK_AP_Payment_Typeap_payment_type_KEY
Unique constraints
NameColumnsDescription
UK_AP_Payment_Type$descriptiondescription
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Pending_AP_Payment__AP_Payment_Type__ap_payment_type_KEYap_payment_type_KEYPending_AP_Payment
FK_Manage_AP_Payment_Processable_Transaction__AP_Payment_Type__pending__ap_payment_type_KEYpending__ap_payment_type_KEYManage_AP_Payment_Processable_Transaction

Schema diagram