Tables [dbo].[ePA_Transaction_Attachments]
We can attach a document as additional information for the questions asked by ESI, table is used for saving that information.
KeyNameData TypeMax Length (Bytes)NullabilityIdentityDescription
Cluster Primary Key PK_ePA_Transaction_Attachments_ID: IDID[dbo].[uniqueid]9NOT NULL1 - 1Key to the ePA_Transaction_Attachments table.
Indexes NIX_ePA_Transaction_Attachments_[HeaderID], NIX_ePA_Transaction_Attachments_HeaderID(2)Foreign Keys FK_ePA_Txn_Att_HeaderID: [dbo].[ePA_Transaction_Questions_Header].HeaderIDHeaderID[dbo].[uniqueid]9NOT NULLQuestion. Key to the ePA_Transaction_Questions_Header table.
ItemID[dbo].[uniqueid]9NOT NULLLink to the Item level table
ItemChildID[dbo].[uniqueid]9NOT NULLLink to the specific version of the order
OriginatingDocumentID[dbo].[uniqueid]9NOT NULLLink to the first version of the attached document
DocumentID[dbo].[uniqueid]9NOT NULLLink to the current version of the attached document
IsRemovedFlag[dbo].[BOOL]1NOT NULLWas this removed?
RecordedDTTMdatetime8NULL allowedOriginal Recorded time
LastUpdatedDTTMdatetime8NULL allowedLast Updated time