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 |