Table: dbo.AR_Customer_Payment_Option
Saves user configuration of their settings for use in the AR Customer Payment view.
Columns
NameTypeConstraintsDescription
ar_customer_payment_option_KEYint (4)NOT NULLPrimary key.
staff_KEYint (4)NOT NULLUsed to reference a set of user preferences.
client_KEYint (4)NOT NULLThe client associated with the saved configuration.
data_entry_method_KEYint (4)NOT NULLDescribes whether to default to the detail or rapid tab when the user enters Customer Payments.
rapid_tab_list_view_filter_KEYint (4)NOT NULLThe filter type to use for the rapid tab.
enable_default_applicationsbit (1)NOT NULLDescribes whether or not Customer Payments should use an automatic payment method.
automatic_payment_application_method_KEYint (4)NOT NULLDescribes the automatic payment method to use if default applications are enabled.
default__checkbook_KEYint (4)Specifies the default bank account to use for payments. If null, then there is no set default bank account that will be filled in for a payment.
default__journal_KEYint (4)Specifies the default journal to use for payments. If null, there is not set default journal that will be filled in for a payment.
default__default_date_option_KEYint (4)Specifies the default date option to use for payments. If null, there is no default date option that will be filled in for a payment.
default__reference_numbernvarchar (32)NOT NULLSpecifies the default reference number to use for payments.
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_AR_Customer_Payment_Optionar_customer_payment_option_KEY
Unique constraints
NameColumnsDescription
UK_AR_Customer_Payment_Option$staff_KEY$client_KEYstaff_KEY, client_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_AR_Customer_Payment_Option__Automatic_Payment_Application_Method__automatic_payment_application_method_KEYautomatic_payment_application_method_KEYAutomatic_Payment_Application_Method (automatic_payment_application_method_KEY)
FK_AR_Customer_Payment_Option__Checkbook__default__checkbook_KEYdefault__checkbook_KEYCheckbook (checkbook_KEY)
FK_AR_Customer_Payment_Option__Client__client_KEYclient_KEYClient (client_KEY)
FK_AR_Customer_Payment_Option__Data_Entry_Method__data_entry_method_KEYdata_entry_method_KEYData_Entry_Method (data_entry_method_KEY)
FK_AR_Customer_Payment_Option__Default_Date_Option__default__default_date_option_KEYdefault__default_date_option_KEYDefault_Date_Option (default_date_option_KEY)
FK_AR_Customer_Payment_Option__Journal__default__journal_KEYdefault__journal_KEYJournal (journal_KEY)
FK_AR_Customer_Payment_Option__Rapid_Tab_List_View_Filter__rapid_tab_list_view_filter_KEYrapid_tab_list_view_filter_KEYRapid_Tab_List_View_Filter (rapid_tab_list_view_filter_KEY)
FK_AR_Customer_Payment_Option__Staff__staff_KEYstaff_KEYStaff (staff_KEY)
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_AR_Customer_Payment_List_View_Column_Option__AR_Customer_Payment_Option__ar_customer_payment_option_KEYar_customer_payment_option_KEYAR_Customer_Payment_List_View_Column_Option

Schema diagram