Project
>
Touchworks
>
User databases
>
Works
>
Tables
> dbo.Order_Document_Mapper
Touchworks 25.2
[dbo].[Order_Document_Mapper]
MS_Description
Table for linking documents to orders.
Columns
Key
Name
Data Type
Max Length (Bytes)
Nullability
Default
Description
OrderActivityHeaderID
[dbo].[uniqueid]
9
NOT NULL
Key to the Order_Activity_Header table
OriginatingDocumentID
[dbo].[uniqueid]
9
NOT NULL
Key to the Document table. This points to the first version of the document.
PlanItemID
[dbo].[uniqueid]
9
NOT NULL
Order level instace id.Link to Plan_Item.ID
DocumentID
[dbo].[uniqueid]
9
NOT NULL
Attached version of DocumentID. Link to Document.DocumentID
IsDocumentLinkedtoResult
[dbo].[BOOL]
1
NOT NULL
('N')
Holds value Y or N. Y indicates attached document is considered as Result.
N indicates attached documents are considered as Additional documentation.
IsDocumentRemovedFLAG
[dbo].[BOOL]
1
NOT NULL
('N')
Holds value Y or N.
Y indicates attached document is removed.