Table: dbo.Manage_AP_Payment_User_Preference
This table holds preferences per user per client for Manage AP Payments.
Columns
Name | Type | Constraints | Description
manage_ap_payment_user_preference_KEY | int (4) | NOT NULL | Primary Key. Not null.
client_KEY | int (4) | NOT NULL | The key of the client the preferences are for.
user_preference_KEY | int (4) | NOT NULL | The user preference key for the user that the preferences are for.
allow_multiple_applications | bit (1) | NOT NULL | True if multiple applications are allowed in Manage AP Payments.
allow_multiple_payments | bit (1) | NOT NULL | True if multiple payments are allowed in Manage AP Payments.
default__journal_KEY | int (4) | NOT NULL | The default journal key to be used when creating a payment application.
reference_number | nvarchar (32) | NOT NULL | The reference number to be associated with the payment application.

Primary key
Name | Columns | Description
PK_Manage_AP_Payment_User_Preference | manage_ap_payment_user_preference_KEY |
Unique constraints
Name | Columns | Description
UK_Manage_AP_Payment_User_Preference$client_KEY$user_preference_KEY | client_KEY, user_preference_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_Manage_AP_Payment_User_Preference__Client__client_KEY | client_KEY | Client (client_KEY) |
FK_Manage_AP_Payment_User_Preference__Journal__default__journal_KEY | default__journal_KEY | Journal (journal_KEY) |
FK_Manage_AP_Payment_User_Preference__User_Preference__user_preference_KEY | user_preference_KEY | User_Preference (user_preference_KEY) |