Integrations

Modified on Wed, 6 Sep, 2023 at 11:18 AM

 PECOS provides 3 output interfaces that allow Financial transaction data to be extracted from PECOS.
These are
1. Purchase Orders (including Change Orders)
2. Receipts and Returns
3. Invoices

Each interface uses the same mechanism which is a basic HTTP(S) GET request to a PECOS web page, with a one line URL
Elcom has an API document for each interface
An XML document is returned in response to the request, which contains a comprehensive data item (up to 200 items per interface) description of POs, Receipts, Invoices, in PECOS format

The nature of the interfaces is that data stays in PECOS, until the HTTP GET request occurs, so for example, if the request happens daily you get data for all of the POs produced in the last 24 hours.
If the HTTP GET request occurs weekly, you get 7 days worth of PO activity.

Integrations
Typically ETL (Extract, Transform, Load) (known as Integrations) is performed on the PECOS documents to extract and convert only the required data items that get then be loaded into a Finance System.
Within the SG P2P Programme, a service is provided by Leidos, to provide 'Integrations' and currently provide this service for approx 30 customers.
(Simply, it GETs the data from PECOS, Transforms the data and creates output files in an SFTP folder, from the which the customer picks up the files and loads the data into their Finance System)
Alternatively, some customers choose to create their own Integration.

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article