AS2 Auditing Schema

The EFT Server installer updates the ARM database with AS2 tables; however, if you are using a SQL database, you will have to update your table schema manually. The AS2 auditing schema includes the tables listed below.

AS2Transactions - Contains details of AS2 Transactions:

• TransactionID

• MIC

• StartTime

• CompleteTime

• Direction

• MDN

• MDNSignatureType

• MDNType

• LocalHost

• RemoteHost

• TransactionStatus

• SiteName

• FromAS2ID

• ToAS2ID

• ErrorCode

• PayloadSignatureType

• PayloadEncryptionType

• PayloadHeaders

• MDNAS2MessageID

• PayloadAS2MessageID

• MDNHTTPResponse

AS2Files - Contains information about files transferred via AS2:

• FIleID

• TransactionID

• FileName

• ContentType

• LocalPath

• RemotePath

AS2Actions - Contains information about separate actions for each AS2 transaction:

• ActionID

• TransactionID

• ActionStatus

• ActionType

• ErrorCode

• TimeStamp

• FileID