Table: dbo.Processing_Note_Sort_Order
Determines how processing notes should be sorted in the Client Processing Notes and Process Payroll Tax Forms Notes dialogs.
Columns
NameTypeConstraintsDescription
processing_note_sort_order_KEYint (4)NOT NULLThe primary key, assigned by ACS.
descriptionnvarchar (50)NOT NULLThe description of the sort method, As Arranged, Newest to Oldest and Oldest to Newest
Primary key
NameColumnsDescription
PK_Processing_Note_Sort_Orderprocessing_note_sort_order_KEY
Unique constraints
NameColumnsDescription
UK_Processing_Note_Sort_Order$descriptiondescription
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_User_Preference__Processing_Note_Sort_Order__processing_note_sort_order_KEYprocessing_note_sort_order_KEYUser_Preference

Schema diagram