This table contains the user preferences per client for settings and fields defaults for Enter AP Transactions screen. |
ap_enter_transaction_list_view_column_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. |
ap_enter_transaction_list_view_column_KEY | int (4) | NOT NULL | Specifies which AP Enter Transaction list view column these options belong to. Not null. |
default__payable_transaction_type_KEY | int (4) | | Indicates the users payable transaction type preference (Payable or Credit Memo) for the given client. Not null ONLY when the ap_enter_transaction_list_view_column_KEY is (Type). |
default__journal_KEY | int (4) | | Indicates the users Journal preference. Not null ONLY when the ap_enter_transaction_list_view_column_KEY is (Journal). |
default__payment_term_KEY | int (4) | | Indicates the users payment term preference. Must be null when the ap_enter_transaction_list_view_column_KEY is NOT (Payment Terms). |
default__gl_account_KEY | int (4) | | Indicates the users gl account preference. Must be null when the ap_enter_transaction_list_view_column_KEY is NOT (AP Account). |
default__ap_enter_transaction_description_type_KEY | int (4) | | Indicates the users ap enter transaction description type preference(Vendor Name, Journal or GL Account Description). Not null ONLY when the ap_enter_transaction_list_view_column_KEY is (Description). |
is_visible | bit (1) | NOT NULL | Flag to determine whether to show this column in Enter AP Transactions or not. Not null. |
sequence_number | int (4) | NOT NULL | Used to track the user-defined order that the columns appear in the display. Not null. |
is_skip_rapid | bit (1) | NOT NULL | Flag to determine whether to skip this field in the tab order in the Rapid tab. Not null. |
is_skip_detail | bit (1) | NOT NULL | Flag to determine whether to skip this field in the tab order in the Detail tab. Not null. |