Table: dbo.Rapid_Tab_List_View_Filter
This table contains the four possible filters for the Rapid tab in the Enter AP Transactions screen.
Columns
NameTypeConstraintsDescription
rapid_tab_list_view_filter_KEYint (4)NOT NULLPrimary Key. Also a Foreign Key to the AP_Enter_Transaction_Option table. Not null.
descriptionnvarchar (88)NOT NULLRepresents the filter used in the Rapid tab in Enter AP Transactions. Not null.
Primary key
NameColumnsDescription
PK_Rapid_Tab_List_View_Filterrapid_tab_list_view_filter_KEY
Unique constraints
NameColumnsDescription
UK_Rapid_Tab_List_View_Filter$descriptiondescription
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_AP_Enter_Transaction_Option__Rapid_Tab_List_View_Filter__rapid_tab_list_view_filter_KEYrapid_tab_list_view_filter_KEYAP_Enter_Transaction_Option
FK_AR_Enter_Invoice_Option__Rapid_Tab_List_View_Filter__rapid_tab_list_view_filter_KEYrapid_tab_list_view_filter_KEYAR_Enter_Invoice_Option
FK_AR_Customer_Payment_Option__Rapid_Tab_List_View_Filter__rapid_tab_list_view_filter_KEYrapid_tab_list_view_filter_KEYAR_Customer_Payment_Option

Schema diagram