Table: dbo.AR_Enter_Invoice_Option
Saves user configuration of their settings for use in the AR Enter Invoices view.
Columns
Name | Type | Constraints | Description
ar_enter_invoice_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 | Whether this configuration refers to the detail or the rapid tab.
rapid_tab_list_view_filter_KEY | int (4) | NOT NULL | The filter type to use for the rapid tab.
default__ar_transaction_type_KEY | int (4) |  | Specifies the default value for AR transaction types as set by the user in the options.
default__gl_account_KEY | int (4) |  | Specifies the default value for the GL account as set by the user in the options.
default__journal_KEY | int (4) |  | Specifies the default value for Journals as set by the user in the options.
default__payment_term_KEY | int (4) |  | Specifies the default value for payment terms as set by the user in the options.
default__message | nvarchar (480) |  | Specifies the default message as set by the user in the options.
create_transactions_as_printed | bit (1) | NOT NULL | Option for users to set which will default the transaction status to printed when transactions are created.

Primary key
Name | Columns | Description
PK_AR_Enter_Invoice_Option | ar_enter_invoice_option_KEY |
Unique constraints
Name | Columns | Description
UK_AR_Enter_Invoice_Option$staff_KEY$client_KEY | staff_KEY, client_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_AR_Enter_Invoice_Option__AR_Transaction_Type__default__ar_transaction_type_KEY | default__ar_transaction_type_KEY | AR_Transaction_Type (ar_transaction_type_KEY) |
FK_AR_Enter_Invoice_Option__Client__client_KEY | client_KEY | Client (client_KEY) |
FK_AR_Enter_Invoice_Option__Data_Entry_Method__data_entry_method_KEY | data_entry_method_KEY | Data_Entry_Method (data_entry_method_KEY) |
FK_AR_Enter_Invoice_Option__GL_Account__default__gl_account_KEY | default__gl_account_KEY | GL_Account (gl_account_KEY) |
FK_AR_Enter_Invoice_Option__Journal__default__journal_KEY | default__journal_KEY | Journal (journal_KEY) |
FK_AR_Enter_Invoice_Option__Payment_Term__default__payment_term_KEY | default__payment_term_KEY | Payment_Term (payment_term_KEY) |
FK_AR_Enter_Invoice_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_Enter_Invoice_Option__Staff__staff_KEY | staff_KEY | Staff (staff_KEY) |

Incoming foreign keys
Name | Columns | Referencing table | Description
FK_AR_Enter_Invoice_List_View_Column_Option__AR_Enter_Invoice_Option__ar_enter_invoice_option_KEY | ar_enter_invoice_option_KEY | AR_Enter_Invoice_List_View_Column_Option |