Table: dbo.Processing_Note_Type
The type of processing note. This determines which notes should be shown in different areas of the program.
Columns
NameTypeConstraintsDescription
processing_note_type_KEYint (4)NOT NULLThe primary key, assigned by ACS.
descriptionnvarchar (50)NOT NULLThe description of the note type, Engagement Item Note, Client Processing Note and Tax Processing Note
Primary key
NameColumnsDescription
PK_Processing_Note_Typeprocessing_note_type_KEY
Unique constraints
NameColumnsDescription
UK_Processing_Note_Type$descriptiondescription
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Processing_Note_Category__Processing_Note_Type__processing_note_type_KEYprocessing_note_type_KEYProcessing_Note_Category
FK_Processing_Note__Processing_Note_Type__processing_note_type_KEYprocessing_note_type_KEYProcessing_Note

Schema diagram