Table: dbo.AP_Enter_Transaction_List_View_Column_Option
This table contains the user preferences per client for settings and fields defaults for Enter AP Transactions screen.
Columns
Name | Type | Constraints | Description
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.

Primary key
Name | Columns | Description
PK_AP_Enter_Transaction_List_View_Column_Option | ap_enter_transaction_list_view_column_option_KEY |
Unique constraints
Name | Columns | Description
UK_AP_Enter_Transaction_List_View_Column_Option$user_preference_KEY$client_KEY$ap_enter_transaction_list_view_column_KEY | user_preference_KEY, client_KEY, ap_enter_transaction_list_view_column_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_AP_Enter_Transaction_List_View_Column_Option__AP_Enter_Transaction_Description_Type__default__ap_enter_transaction_descriptio | default__ap_enter_transaction_description_type_KEY | AP_Enter_Transaction_Description_Type (ap_enter_transaction_description_type_KEY) |
FK_AP_Enter_Transaction_List_View_Column_Option__AP_Enter_Transaction_List_View_Column__ap_enter_transaction_list_view_column_KE | ap_enter_transaction_list_view_column_KEY | AP_Enter_Transaction_List_View_Column (ap_enter_transaction_list_view_column_KEY) |
FK_AP_Enter_Transaction_List_View_Column_Option__Client__client_KEY | client_KEY | Client (client_KEY) |
FK_AP_Enter_Transaction_List_View_Column_Option__GL_Account__default__gl_account_KEY | default__gl_account_KEY | GL_Account (gl_account_KEY) |
FK_AP_Enter_Transaction_List_View_Column_Option__Journal__default__journal_KEY | default__journal_KEY | Journal (journal_KEY) |
FK_AP_Enter_Transaction_List_View_Column_Option__Payable_Transaction_Type__default__payable_transaction_type_KEY | default__payable_transaction_type_KEY | Payable_Transaction_Type (payable_transaction_type_KEY) |
FK_AP_Enter_Transaction_List_View_Column_Option__Payment_Term__default__payment_term_KEY | default__payment_term_KEY | Payment_Term (payment_term_KEY) |
FK_AP_Enter_Transaction_List_View_Column_Option__User_Preference__user_preference_KEY | user_preference_KEY | User_Preference (user_preference_KEY) |