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
Name | Type | Constraints | Description
ap_enter_transaction_option_KEY | int (4) | NOT NULL | Primary Key. Not null.
user_preference_KEY | int (4) | NOT NULL | The user to which this user preference belongs. Not null.
client_KEY | int (4) | NOT NULL | The Client to which this user preference belongs. Not null.
data_entry_method_KEY | int (4) | NOT NULL | Indicates 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_KEY | int (4) | NOT NULL | Indicates the users preference on the default filter to use in the Rapid tab in the Enter AP Transaction screen. Not null.

Primary key
Name | Columns | Description
PK_AP_Enter_Transaction_Option | ap_enter_transaction_option_KEY |
Unique constraints
Name | Columns | Description
UK_AP_Enter_Transaction_Option$user_preference_KEY$client_KEY | user_preference_KEY, client_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_AP_Enter_Transaction_Option__Client__client_KEY | client_KEY | Client (client_KEY) |
FK_AP_Enter_Transaction_Option__Data_Entry_Method__data_entry_method_KEY | data_entry_method_KEY | Data_Entry_Method (data_entry_method_KEY) |
FK_AP_Enter_Transaction_Option__Rapid_Tab_List_View_Filter__rapid_tab_list_view_filter_KEY | rapid_tab_list_view_filter_KEY | Rapid_Tab_List_View_Filter (rapid_tab_list_view_filter_KEY) |
FK_AP_Enter_Transaction_Option__User_Preference__user_preference_KEY | user_preference_KEY | User_Preference (user_preference_KEY) |