Table: dbo.AR_Customer_Payment_List_View_Column_Option
Saves user-specified ordering of how the columns will appear in the AR Customer Payments view.
Columns
NameTypeConstraintsDescription
ar_customer_payment_list_view_column_option_KEYint (4)NOT NULLPrimary key.
ar_customer_payment_list_view_column_KEYint (4)NOT NULLThe column whose ordering is specified by this entry.
ar_customer_payment_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_Customer_Payment_List_View_Column_Optionar_customer_payment_list_view_column_option_KEY
Unique constraints
NameColumnsDescription
UK_AR_Customer_Payment_List_View_Column_Option$ar_customer_payment_option_KEY$ar_customer_payment_list_view_column_KEYar_customer_payment_option_KEY, ar_customer_payment_list_view_column_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_AR_Customer_Payment_List_View_Column_Option__AR_Customer_Payment_List_View_Column__ar_customer_payment_list_view_column_KEYar_customer_payment_list_view_column_KEYAR_Customer_Payment_List_View_Column (ar_customer_payment_list_view_column_KEY)
FK_AR_Customer_Payment_List_View_Column_Option__AR_Customer_Payment_Option__ar_customer_payment_option_KEYar_customer_payment_option_KEYAR_Customer_Payment_Option (ar_customer_payment_option_KEY)

Schema diagram