Table: dbo.Payable_Transaction_Type
The table enumerates the different types of payable transactions.
Columns
NameTypeConstraintsDescription
payable_transaction_type_KEYint (4)NOT NULLPrimary key.
descriptionnvarchar (80)NOT NULLDescription of a payable transaction type.
Primary key
NameColumnsDescription
PK_Payable_Transaction_Typepayable_transaction_type_KEY
Unique constraints
NameColumnsDescription
UK_Payable_Transaction_Type$descriptiondescription
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_AP_Enter_Transaction_List_View_Column_Option__Payable_Transaction_Type__default__payable_transaction_type_KEYdefault__payable_transaction_type_KEYAP_Enter_Transaction_List_View_Column_Option
FK_Payable_Transaction_Template__Payable_Transaction_Type__payable_transaction_type_KEYpayable_transaction_type_KEYPayable_Transaction_Template
FK_Manage_AP_Payment_Processable_Transaction__Payable_Transaction_Type__payable_transaction_type_KEYpayable_transaction_type_KEYManage_AP_Payment_Processable_Transaction
FK_Payable_Transaction__Payable_Transaction_Type__payable_transaction_type_KEYpayable_transaction_type_KEYPayable_Transaction

Schema diagram