Table: dbo.Apply_Customer_Payment_Option
This table holds user options, per client per staff, for apply customer payments.
Columns
Name | Type | Constraints | Description
apply_customer_payment_option_KEY | int (4) | NOT NULL | Primary key, not null. The primary key for this table.
staff_KEY | int (4) | NOT NULL | The key of the staff member the options are for.
client_KEY | int (4) | NOT NULL | The key of the client the options are for.
allow_multiple_applications | bit (1) | NOT NULL | True if multiple applications are allowed in Manage AP Payments.
journal_KEY | int (4) | NOT NULL | The journal key to be used when creating a payment application.
reference_number_suffix | nvarchar (32) | NOT NULL | The reference number suffix to be associated with the payment application.
use_payment_date_as_application_date | bit (1) | NOT NULL | 1 means the payment date is used as the application date; 0 means that we use AR date as the application date.

Primary key
Name | Columns | Description
PK_Apply_Customer_Payment_Option | apply_customer_payment_option_KEY |
Unique constraints
Name | Columns | Description
UK_Apply_Customer_Payment_Option$client_KEY$staff_KEY | client_KEY, staff_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_Apply_Customer_Payment_Option__Client__client_KEY | client_KEY | Client (client_KEY) |
FK_Apply_Customer_Payment_Option__Journal__journal_KEY | journal_KEY | Journal (journal_KEY) |
FK_Apply_Customer_Payment_Option__Staff__staff_KEY | staff_KEY | Staff (staff_KEY) |