none
EDI status report querying on Datebase

    Question

  • Hi

    I have enable EDI status reports on Agreement,i would like to query directly on Sql database to know the some results on EDI status report.

    I know how to query on BizTalk administration console,But i want to directly query on Sql Database to prepare custom reports to share with Business.

    Please let me know table details where EDI status report saved in database.

    Thanks,

    Amar.

    Monday, March 20, 2017 1:20 AM

All replies

  • Hi Ammu

    You can query from these BAM Views-

    (You can correlate the records using InterchangeControlNo attribute - this will be the same for an inbound EDI document that you receive and a 997 that you send out; and vice-versa)

    bam_InterchangeStatusActivity_CompletedInstances

    bam_TransactionSetActivity_CompletedInstances

    bam_InterchangeAckActivity_CompletedInstances

    bam_FunctionalAckActivity_CompletedInstances


    Thanks Arindam

    Monday, March 20, 2017 10:53 AM