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 |