Table: dbo.AR_Enter_Invoice_List_View_Column_Option
Saves user-specified ordering of how the columns will appear in the AR Enter Invoices view.
Columns
NameTypeConstraintsDescription
ar_enter_invoice_list_view_column_option_KEYint (4)NOT NULLPrimary key.
ar_enter_invoice_list_view_column_KEYint (4)NOT NULLThe column whose ordering is specified by this entry.
ar_enter_invoice_option_KEYint (4)NOT NULLThe set of saved options this entry belongs to.
is_visiblebit (1)NOT NULLWhether or not the column will be visible to the user during data entry.
sequence_numberint (4)NOT NULLThe sequence number which specifies where in the order the column will appear in.
is_skip_rapidbit (1)NOT NULLSpecifies whether to skip this column during entry on the rapid tab.
is_skip_detailbit (1)NOT NULLSpecifies whether to skip this column during entry on the detail tab.
Primary key
NameColumnsDescription
PK_AR_Enter_Invoice_List_View_Column_Optionar_enter_invoice_list_view_column_option_KEY
Unique constraints
NameColumnsDescription
UK_AR_Enter_Invoice_List_View_Column_Option$ar_enter_invoice_option_KEY$ar_enter_invoice_list_view_column_KEYar_enter_invoice_option_KEY, ar_enter_invoice_list_view_column_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_AR_Enter_Invoice_List_View_Column_Option__AR_Enter_Invoice_List_View_Column__ar_enter_invoice_list_view_column_KEYar_enter_invoice_list_view_column_KEYAR_Enter_Invoice_List_View_Column (ar_enter_invoice_list_view_column_KEY)
FK_AR_Enter_Invoice_List_View_Column_Option__AR_Enter_Invoice_Option__ar_enter_invoice_option_KEYar_enter_invoice_option_KEYAR_Enter_Invoice_Option (ar_enter_invoice_option_KEY)

Schema diagram