Table: dbo.AP_Enter_Transaction_List_View_Column
This table contains the list of columns used in Enter AP Transactions screen and whether they can be hidden or not.
Columns
NameTypeConstraintsDescription
ap_enter_transaction_list_view_column_KEYint (4)NOT NULLPrimary Key. Not null.
descriptionnvarchar (44)NOT NULLRepresents the list of all columns used in Enter AP Transactions. A (*) at the end of a column indicates it is required and cannot be hidden. Not null.
is_requiredint (4)NOT NULLIf set to true, then the column must be shown in the AP Enter Transaction screen; it can't be hidden by the user.
Primary key
NameColumnsDescription
PK_AP_Enter_Transaction_List_View_Columnap_enter_transaction_list_view_column_KEY
Unique constraints
NameColumnsDescription
UK_AP_Enter_Transaction_List_View_Column$descriptiondescription
Incoming foreign keys
NameColumnsReferencing tableDescription
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_Option

Schema diagram