Table: dbo.Apply_Customer_Payment_Option
This table holds user options, per client per staff, for apply customer payments.
Columns
NameTypeConstraintsDescription
apply_customer_payment_option_KEYint (4)NOT NULLPrimary key, not null. The primary key for this table.
staff_KEYint (4)NOT NULLThe key of the staff member the options are for.
client_KEYint (4)NOT NULLThe key of the client the options are for.
allow_multiple_applicationsbit (1)NOT NULLTrue if multiple applications are allowed in Manage AP Payments.
journal_KEYint (4)NOT NULLThe journal key to be used when creating a payment application.
reference_number_suffixnvarchar (32)NOT NULLThe reference number suffix to be associated with the payment application.
use_payment_date_as_application_datebit (1)NOT NULL1 means the payment date is used as the application date; 0 means that we use AR date as the application date.
Primary key
NameColumnsDescription
PK_Apply_Customer_Payment_Optionapply_customer_payment_option_KEY
Unique constraints
NameColumnsDescription
UK_Apply_Customer_Payment_Option$client_KEY$staff_KEYclient_KEY, staff_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Apply_Customer_Payment_Option__Client__client_KEYclient_KEYClient (client_KEY)
FK_Apply_Customer_Payment_Option__Journal__journal_KEYjournal_KEYJournal (journal_KEY)
FK_Apply_Customer_Payment_Option__Staff__staff_KEYstaff_KEYStaff (staff_KEY)

Schema diagram