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
Name | Type | Constraints | Description
manage_ap_payment_grid_user_option_KEY | int (4) | NOT NULL | Primary Key. Not null.
client_KEY | int (4) | NOT NULL | The key of the client the preferences are for.
user_preference_KEY | int (4) | NOT NULL | The user preference key for the user that the preferences are for.
manage_ap_payment_grid_column_KEY | int (4) | NOT NULL | The grid column this preference is for.
hide_column | bit (1) | NOT NULL | True if the column is to be hidden.
sequence_number | int (4) | NOT NULL | The order in which this option appears.

Primary key
Name | Columns | Description
PK_Manage_AP_Payment_Grid_User_Option | manage_ap_payment_grid_user_option_KEY |
Unique constraints
Name | Columns | Description
UK_Manage_AP_Payment_Grid_User_Option$client_KEY$user_preference_KEY$manage_ap_payment_grid_column_KEY | client_KEY, user_preference_KEY, manage_ap_payment_grid_column_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_Manage_AP_Payment_Grid_User_Option__Client__client_KEY | client_KEY | Client (client_KEY) |
FK_Manage_AP_Payment_Grid_User_Option__Manage_AP_Payment_Grid_Column__manage_ap_payment_grid_column_KEY | manage_ap_payment_grid_column_KEY | Manage_AP_Payment_Grid_Column (manage_ap_payment_grid_column_KEY) |
FK_Manage_AP_Payment_Grid_User_Option__User_Preference__user_preference_KEY | user_preference_KEY | User_Preference (user_preference_KEY) |