Table: dbo.AP_Enter_Transaction_Option
This table contains user preferences per client for Data Entry Method and List View Filter in Enter AP Transactions.
Columns
NameTypeConstraintsDescription
ap_enter_transaction_option_KEYint (4)NOT NULLPrimary Key. Not null.
user_preference_KEYint (4)NOT NULLThe user to which this user preference belongs. Not null.
client_KEYint (4)NOT NULLThe Client to which this user preference belongs. Not null.
data_entry_method_KEYint (4)NOT NULLIndicates the users data entry preference regarding how screen AP Enter Trnasaction start up (starts in Detail tab or Rapid tab) for the given client. Not null.
rapid_tab_list_view_filter_KEYint (4)NOT NULLIndicates the users preference on the default filter to use in the Rapid tab in the Enter AP Transaction screen. Not null.
Primary key
NameColumnsDescription
PK_AP_Enter_Transaction_Optionap_enter_transaction_option_KEY
Unique constraints
NameColumnsDescription
UK_AP_Enter_Transaction_Option$user_preference_KEY$client_KEYuser_preference_KEY, client_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_AP_Enter_Transaction_Option__Client__client_KEYclient_KEYClient (client_KEY)
FK_AP_Enter_Transaction_Option__Data_Entry_Method__data_entry_method_KEYdata_entry_method_KEYData_Entry_Method (data_entry_method_KEY)
FK_AP_Enter_Transaction_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_AP_Enter_Transaction_Option__User_Preference__user_preference_KEYuser_preference_KEYUser_Preference (user_preference_KEY)

Schema diagram