| 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 | ||