EDI / API Output

EDI / API Output

Formats

Outbound files can be supplied in a number of formats:

CSV

older files, not always available, usually will open in excel
(will only support latin characters)

XML

widely used, will open in excel,
usually readable by computer, supports all characters

PDF

limited in use
only output where the information can be held within a page.

Sending Intervals

Generation of outbound information can be obtained as follows:

API

This is on demand service, you can not combine this with any of the other sending intervals.

Hourly

Each hour from 0400 to 2000

Daily

Between 0100 and 0500 each day

Weekly

Usually a sunday morning between 0100 and 0500

Monthly

Usually 1st day of the month between 0100 and 0500

How it works

There are two method in use

API - where you can call the report name throughout the day (this is subject to rate control to stop you calling it repeatedly)

eMail - where you schedule the report to run at a specific time and within the WMS you select which email addresses will receive the file when it is generated.

Timing for outbound report is determined by the warehouse. you can not specify a specific time.

Transactional Reports

When these are generated the transactions are marked as supplied, therefore you can not run API and eMAIL for this type of output. Transactional reports are highlighted RED on the ID

Any data shown within the output examples is from our test system which does contain real customer names with a mix up of addresses, the data shown bears no resemblance to actual values held by our customers.

EDI Output List

You will find the Code Lists page useful when using the outputs below as many of the statuses and codes will be contained within the code lists.

 

ID
API Ref

ReportName

ShortName

Availability

Type

PDF

CSV

XML
File

XML
API

Last Updated

ID
API Ref

ReportName

ShortName

Availability

Type

PDF

CSV

XML
File

XML
API

Last Updated

2101

Stock Snapshot By Product

StkPrdt

Schedule & API

 

Y

Y

Y

Y

 

2102

Stock Snapshot By Rotation

StkRotn

Schedule & API

 

Y

Y

Y

Y

 

2103

Stock Snapshot By Product Enhanced

StkPrdtE

Schedule & API

 

Y

Y

Y

Y

 

2104

Stock Snapshot By Rotation Enhanced

StkRotnE

Schedule & APIe

 

Y

Y

Y

Y

14/11/2022

2105

Multi Site Product Stock

 

Schedule

 

 

 

 

 

 

2106

Reserve Customer Stock Snap by Prod

RStkPrd

Schedule

 

 

Y

Y

 

10/10/2024

2107

Reserve Customer Stock Snap by Rotn

RStkRtn

Schedule

 

 

Y

Y

 

10/10/2024

2110

Stock Frozen Audit

FrznAud

Schedule & API

 

 

 

Y

Y

 

2120

Stock Loss

StkLoss

Schedule

 

Y

Y

 

 

 

2130

Rotation Stock Information

 

API Module

 

 

 

 

Y

 

2131

Rotation Stock in Warehouse

 

API Module

 

 

 

 

Y

 

2132

Product Stock in Warehouse

 

API Module

 

 

 

 

Y

 

2201

Goods Received

GdsRcvd

Schedule & API

Transactional

Y

Y

Y

Y

24/02/22

2202

Goods Received Enhanced

GdsRcvdE

Schedule & API

Transactional

Y

Y

Y

Y

29/05/2025

2203

Reserve Customer Goods Received

RGdsRcd

Schedule

 

 

Y

Y

 

10/10/2024

2310

Order Status

 

API Module

 

 

 

 

Y

Superceded by 2330

2311

Order Status by Doc Ref

 

API Module

 

 

 

 

Y

Superceded by 2331

2320

Orders Received

NewOrds

Schedule & API

 

 

 

Y

Y

 

2321

Held Orders

HldOrds

Schedule

 

Y

Y

 

 

 

2322

New Orders Entered and Held Orders

NewOrds

Schedule & API

 

Y

Y

Y

Y

29/05/2025

2330

Order Status 2024

 

API Module

 

 

 

 

Y

Coming Soon

2331

Order Status 2024 by Doc Ref

 

API Module

 

 

 

 

Y

Coming Soon

2340

Order Picking Confirmation

OrdPckd

Schedule & API

Transactional

Y

Y

Y

Y

 

2341

Reserve Customer Order Pick Confirm..

ROrdPckd

Schedule

Transactional

 

Y

Y

 

10/10/2024

2350

Transaction Audit

TrsnAud

Schedule & API

 

 

 

Y

Y

 

2355

Intrastat

Intrast

Schedule & API

 

Y

Y

Y

Y

 

2360 

POC Export

 

Schedule & API

Transactional

 

 

Y

 

2370

Despatched Orders

DesOrd

API Module

 

 

 

 

Y

Coming Soon

2410

Delivery Status

 

API Module

 

 

 

 

Y

Superceded by 2420

2411

Delivery Status by Doc Ref

 

API Module

 

 

 

 

Y

Superceded by 2421

2420

Delivery Status 2024

 

API Module

 

 

 

 

Y

Coming Soon

2421

Delivery Status 2024 by Doc Ref

 

API Module

 

 

 

 

Y

Coming Soon

2480

POD Extract

PODExtr

System Generates

Transactional

 

Y

 

 

 

2490

EPOD

ePOD

Schedule

 

Y

 

 

 

 

2500

Shipment Overview

ShipOvrvw

Schedule

 

 

Y

 

 

 

2600

Documents

 

API Module

 

 

 

 

Y

 

2610

Products

 

API Module

 

 

 

 

Y

 

2620

Excise And VAT Summary

ExcsVAT

System Generates

Transactional

Y

Y

 

 

29/05/2025

2700

Warehouse Despatches

 

 

 

 

 

 

Y

29/05/2025

7001

Intra Vision PO

InVisPO

Transactional

Transactional

 

 

Y

Y

 

8001

Order Transaction Audit

StkTrsn

Schedule

 

 

Y

 

 

 

8002

Warehouse Despatch Advice

WhsDspt

Schedule

Transactional

 

Y

 

 

Consider using 2700

8003

Notification Issue List

NtfnIss

Schedule

Transactional

 

 Y

 

 

 

Copyright Ontech Solutions 2017-2024. All rights reserved, no part may be replicated or distributed without the express permission of the owner.