Table: dbo.Manage_AP_Payment_User_Preference
This table holds preferences per user per client for Manage AP Payments.
Columns
NameTypeConstraintsDescription
manage_ap_payment_user_preference_KEYint (4)NOT NULLPrimary Key. Not null.
client_KEYint (4)NOT NULLThe key of the client the preferences are for.
user_preference_KEYint (4)NOT NULLThe user preference key for the user that the preferences are for.
allow_multiple_applicationsbit (1)NOT NULLTrue if multiple applications are allowed in Manage AP Payments.
allow_multiple_paymentsbit (1)NOT NULLTrue if multiple payments are allowed in Manage AP Payments.
default__journal_KEYint (4)NOT NULLThe default journal key to be used when creating a payment application.
reference_numbernvarchar (32)NOT NULLThe reference number to be associated with the payment application.
Primary key
NameColumnsDescription
PK_Manage_AP_Payment_User_Preferencemanage_ap_payment_user_preference_KEY
Unique constraints
NameColumnsDescription
UK_Manage_AP_Payment_User_Preference$client_KEY$user_preference_KEYclient_KEY, user_preference_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Manage_AP_Payment_User_Preference__Client__client_KEYclient_KEYClient (client_KEY)
FK_Manage_AP_Payment_User_Preference__Journal__default__journal_KEYdefault__journal_KEYJournal (journal_KEY)
FK_Manage_AP_Payment_User_Preference__User_Preference__user_preference_KEYuser_preference_KEYUser_Preference (user_preference_KEY)

Schema diagram