Project
>
Touchworks
>
User databases
>
Works
>
Tables
> dbo.ePA_Transaction_Attachments
Touchworks 25.2
[dbo].[ePA_Transaction_Attachments]
MS_Description
We can attach a document as additional information for the questions asked by ESI, table is used for saving that information.
Columns
Key
Name
Data Type
Max Length (Bytes)
Nullability
Identity
Description
ID
[dbo].[uniqueid]
9
NOT NULL
1 - 1
Key to the ePA_Transaction_Attachments table.
(2)
HeaderID
[dbo].[uniqueid]
9
NOT NULL
Question. Key to the ePA_Transaction_Questions_Header table.
ItemID
[dbo].[uniqueid]
9
NOT NULL
Link to the Item level table
ItemChildID
[dbo].[uniqueid]
9
NOT NULL
Link to the specific version of the order
OriginatingDocumentID
[dbo].[uniqueid]
9
NOT NULL
Link to the first version of the attached document
DocumentID
[dbo].[uniqueid]
9
NOT NULL
Link to the current version of the attached document
IsRemovedFlag
[dbo].[BOOL]
1
NOT NULL
Was this removed?
RecordedDTTM
datetime
8
NULL allowed
Original Recorded time
LastUpdatedDTTM
datetime
8
NULL allowed
Last Updated time