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 |
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 |