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
NameTypeConstraintsDescription
ap_enter_transaction_list_view_column_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.
ap_enter_transaction_list_view_column_KEYint (4)NOT NULLSpecifies which AP Enter Transaction list view column these options belong to. Not null.
default__payable_transaction_type_KEYint (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_KEYint (4)Indicates the users Journal preference. Not null ONLY when the ap_enter_transaction_list_view_column_KEY is (Journal).
default__payment_term_KEYint (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_KEYint (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_KEYint (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_visiblebit (1)NOT NULLFlag to determine whether to show this column in Enter AP Transactions or not. Not null.
sequence_numberint (4)NOT NULLUsed to track the user-defined order that the columns appear in the display. Not null.
is_skip_rapidbit (1)NOT NULLFlag to determine whether to skip this field in the tab order in the Rapid tab. Not null.
is_skip_detailbit (1)NOT NULLFlag to determine whether to skip this field in the tab order in the Detail tab. Not null.
Primary key
NameColumnsDescription
PK_AP_Enter_Transaction_List_View_Column_Optionap_enter_transaction_list_view_column_option_KEY
Unique constraints
NameColumnsDescription
UK_AP_Enter_Transaction_List_View_Column_Option$user_preference_KEY$client_KEY$ap_enter_transaction_list_view_column_KEYuser_preference_KEY, client_KEY, ap_enter_transaction_list_view_column_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_AP_Enter_Transaction_List_View_Column_Option__AP_Enter_Transaction_Description_Type__default__ap_enter_transaction_descriptiodefault__ap_enter_transaction_description_type_KEYAP_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_KEap_enter_transaction_list_view_column_KEYAP_Enter_Transaction_List_View_Column (ap_enter_transaction_list_view_column_KEY)
FK_AP_Enter_Transaction_List_View_Column_Option__Client__client_KEYclient_KEYClient (client_KEY)
FK_AP_Enter_Transaction_List_View_Column_Option__GL_Account__default__gl_account_KEYdefault__gl_account_KEYGL_Account (gl_account_KEY)
FK_AP_Enter_Transaction_List_View_Column_Option__Journal__default__journal_KEYdefault__journal_KEYJournal (journal_KEY)
FK_AP_Enter_Transaction_List_View_Column_Option__Payable_Transaction_Type__default__payable_transaction_type_KEYdefault__payable_transaction_type_KEYPayable_Transaction_Type (payable_transaction_type_KEY)
FK_AP_Enter_Transaction_List_View_Column_Option__Payment_Term__default__payment_term_KEYdefault__payment_term_KEYPayment_Term (payment_term_KEY)
FK_AP_Enter_Transaction_List_View_Column_Option__User_Preference__user_preference_KEYuser_preference_KEYUser_Preference (user_preference_KEY)

Schema diagram