EBIFour.com Training Clarify Tips PostgreSQL : Retrieve Message Status Code for Outbound EDI Transactions
PostgreSQL : Retrieve Message Status Code for Outbound EDI Transactions
14th August 2017
When I was researching the status of outbound EDI documents in the PostgreSQL table:
LOG_OF_MESSAGE. I discovered each document had its own STATUS code.
There were some cases where the outbound EDI messages have MESSAGE_ID = <null>, in some instances, and MESSAGE_ID != <null>. I was also finding that the status codes are different when “MESSAGE_ID” is populated versus not populated.
Examples of status codes:
Below are some examples of status codes. The complete list can be obtained from Cleo Clarify Support Team
STATUS: Completed
STATUS: Generated
For users unsure of accessing the internal PostgreSQL tables, we discussed access to the internal PostgreSQL database tables.
By: Sean Hoppe on