Table: dbo.Manage_AP_Payment_Grid_User_Option
This table holds preferences, per user, per client, on which columns are shown in the Manage AP Payment grid.
Columns
NameTypeConstraintsDescription
manage_ap_payment_grid_user_option_KEYint (4)NOT NULLPrimary Key. Not null.
client_KEYint (4)NOT NULLThe key of the client the preferences are for.
user_preference_KEYint (4)NOT NULLThe user preference key for the user that the preferences are for.
manage_ap_payment_grid_column_KEYint (4)NOT NULLThe grid column this preference is for.
hide_columnbit (1)NOT NULLTrue if the column is to be hidden.
sequence_numberint (4)NOT NULLThe order in which this option appears.
Primary key
NameColumnsDescription
PK_Manage_AP_Payment_Grid_User_Optionmanage_ap_payment_grid_user_option_KEY
Unique constraints
NameColumnsDescription
UK_Manage_AP_Payment_Grid_User_Option$client_KEY$user_preference_KEY$manage_ap_payment_grid_column_KEYclient_KEY, user_preference_KEY, manage_ap_payment_grid_column_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Manage_AP_Payment_Grid_User_Option__Client__client_KEYclient_KEYClient (client_KEY)
FK_Manage_AP_Payment_Grid_User_Option__Manage_AP_Payment_Grid_Column__manage_ap_payment_grid_column_KEYmanage_ap_payment_grid_column_KEYManage_AP_Payment_Grid_Column (manage_ap_payment_grid_column_KEY)
FK_Manage_AP_Payment_Grid_User_Option__User_Preference__user_preference_KEYuser_preference_KEYUser_Preference (user_preference_KEY)

Schema diagram