Project
>
Touchworks
>
User databases
>
Works
>
Tables
> dbo.Note_Correspondence_Letter
Touchworks 25.2
[dbo].[Note_Correspondence_Letter]
MS_Description
Maps the Original Document to the Referral Document and its respective NoteLetterID (1,2,3)
Columns
Key
Name
Data Type
Max Length (Bytes)
Nullability
Identity
Description
ID
[dbo].[dict_id]
5
NOT NULL
1 - 1
Key to the Note_Correspondence_Letter table
(2)
OriginalDocumentID
[dbo].[uniqueid]
9
NOT NULL
Link to Document.DocumentID
ReferralDocumentID
[dbo].[uniqueid]
9
NOT NULL
Link to Document.DocumentID and CSS_CC_Distribution.WorkObjectID (the generated referral)
NoteLetterID
int
4
NOT NULL
Ordinal values (1, 2, or 3) within a set of OriginalDocumentID's (see CSS_CC_Distribution.NoteLetterID)