Table: dbo.AR_Enter_Invoice_Option
Saves user configuration of their settings for use in the AR Enter Invoices view.
Columns
NameTypeConstraintsDescription
ar_enter_invoice_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 NULLWhether this configuration refers to the detail or the rapid tab.
rapid_tab_list_view_filter_KEYint (4)NOT NULLThe filter type to use for the rapid tab.
default__ar_transaction_type_KEYint (4)Specifies the default value for AR transaction types as set by the user in the options.
default__gl_account_KEYint (4)Specifies the default value for the GL account as set by the user in the options.
default__journal_KEYint (4)Specifies the default value for Journals as set by the user in the options.
default__payment_term_KEYint (4)Specifies the default value for payment terms as set by the user in the options.
default__messagenvarchar (480)Specifies the default message as set by the user in the options.
create_transactions_as_printedbit (1)NOT NULLOption for users to set which will default the transaction status to printed when transactions are created.
Primary key
NameColumnsDescription
PK_AR_Enter_Invoice_Optionar_enter_invoice_option_KEY
Unique constraints
NameColumnsDescription
UK_AR_Enter_Invoice_Option$staff_KEY$client_KEYstaff_KEY, client_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_AR_Enter_Invoice_Option__AR_Transaction_Type__default__ar_transaction_type_KEYdefault__ar_transaction_type_KEYAR_Transaction_Type (ar_transaction_type_KEY)
FK_AR_Enter_Invoice_Option__Client__client_KEYclient_KEYClient (client_KEY)
FK_AR_Enter_Invoice_Option__Data_Entry_Method__data_entry_method_KEYdata_entry_method_KEYData_Entry_Method (data_entry_method_KEY)
FK_AR_Enter_Invoice_Option__GL_Account__default__gl_account_KEYdefault__gl_account_KEYGL_Account (gl_account_KEY)
FK_AR_Enter_Invoice_Option__Journal__default__journal_KEYdefault__journal_KEYJournal (journal_KEY)
FK_AR_Enter_Invoice_Option__Payment_Term__default__payment_term_KEYdefault__payment_term_KEYPayment_Term (payment_term_KEY)
FK_AR_Enter_Invoice_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_Enter_Invoice_Option__Staff__staff_KEYstaff_KEYStaff (staff_KEY)
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_AR_Enter_Invoice_List_View_Column_Option__AR_Enter_Invoice_Option__ar_enter_invoice_option_KEYar_enter_invoice_option_KEYAR_Enter_Invoice_List_View_Column_Option

Schema diagram