Table: dbo.AR_Customer_Payment_Option
Saves user configuration of their settings for use in the AR Customer Payment view.
Columns
Name | Type | Constraints | Description
ar_customer_payment_option_KEY | int (4) | NOT NULL | Primary key.
staff_KEY | int (4) | NOT NULL | Used to reference a set of user preferences.
client_KEY | int (4) | NOT NULL | The client associated with the saved configuration.
data_entry_method_KEY | int (4) | NOT NULL | Describes whether to default to the detail or rapid tab when the user enters Customer Payments.
rapid_tab_list_view_filter_KEY | int (4) | NOT NULL | The filter type to use for the rapid tab.
enable_default_applications | bit (1) | NOT NULL | Describes whether or not Customer Payments should use an automatic payment method.
automatic_payment_application_method_KEY | int (4) | NOT NULL | Describes the automatic payment method to use if default applications are enabled.
default__checkbook_KEY | int (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_KEY | int (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_KEY | int (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_number | nvarchar (32) | NOT NULL | Specifies the default reference number to use for payments.
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_AR_Customer_Payment_Option | ar_customer_payment_option_KEY |
Unique constraints
Name | Columns | Description
UK_AR_Customer_Payment_Option$staff_KEY$client_KEY | staff_KEY, client_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_AR_Customer_Payment_Option__Automatic_Payment_Application_Method__automatic_payment_application_method_KEY | automatic_payment_application_method_KEY | Automatic_Payment_Application_Method (automatic_payment_application_method_KEY) |
FK_AR_Customer_Payment_Option__Checkbook__default__checkbook_KEY | default__checkbook_KEY | Checkbook (checkbook_KEY) |
FK_AR_Customer_Payment_Option__Client__client_KEY | client_KEY | Client (client_KEY) |
FK_AR_Customer_Payment_Option__Data_Entry_Method__data_entry_method_KEY | data_entry_method_KEY | Data_Entry_Method (data_entry_method_KEY) |
FK_AR_Customer_Payment_Option__Default_Date_Option__default__default_date_option_KEY | default__default_date_option_KEY | Default_Date_Option (default_date_option_KEY) |
FK_AR_Customer_Payment_Option__Journal__default__journal_KEY | default__journal_KEY | Journal (journal_KEY) |
FK_AR_Customer_Payment_Option__Rapid_Tab_List_View_Filter__rapid_tab_list_view_filter_KEY | rapid_tab_list_view_filter_KEY | Rapid_Tab_List_View_Filter (rapid_tab_list_view_filter_KEY) |
FK_AR_Customer_Payment_Option__Staff__staff_KEY | staff_KEY | Staff (staff_KEY) |

Incoming foreign keys
Name | Columns | Referencing table | Description
FK_AR_Customer_Payment_List_View_Column_Option__AR_Customer_Payment_Option__ar_customer_payment_option_KEY | ar_customer_payment_option_KEY | AR_Customer_Payment_List_View_Column_Option |