EDI / API Output

Owned by Alan Gilchrist
Last updated: Oct 08, 2024
4 min read

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

ID
API Ref

ReportName

ShortName

Availability

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

Y

Y

Y

Y

24/02/22

2202

Goods Received Enhanced

GdsRcvdE

Schedule & API

Y

Y

Y

Y

24/02/22

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

 

2330

Order Status 2024

 

API Module

 

 

 

Y

New Q4,2024

2331

Order Status 2024 by Doc Ref

 

API Module

 

 

 

Y

New Q4,2024

2340

Order Picking Confirmation

OrdPckd

Schedule & API

Y

Y

Y

Y

 

2341

Reserve Customer Order Pick Confirm..

ROrdPckd

Schedule

 

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

 

 

Y 

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

New Q4,2024

2421

Delivery Status 2024 by Doc Ref

 

API Module

 

 

 

Y

New Q4,2024

2480

POD Extract

PODExtr

System Generates

 

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

Y

Y

 

 

13/07/2022

7001

Intra Vision PO

InVisPO

Schedule & API

 

 

Y

Y

 

8001

Order Transaction Audit

StkTrsn

Schedule

 

Y

 

 

 

8002

Warehouse Despatch Advice

WhsDspt

Schedule

 

Y

 

 

 

8003

Notification Issue List

NtfnIss

Schedule

 

 Y

 

 

 

9001

Management Warehousing

MgmtWhs

Schedule

Y

 

 

 

 

9002

Management Transport

MgmtTpt

Schedule

Y

 

 

 

 

9003

Stock Inwards Non Conformance

 

Schedule

Y

 

 

 

 

Links to all the EDI Documents are shown below

 

 

8xxx Reports

These are very old reports which are likely to be discontinued at some point in the future but have been left on the system for backward compatibility purposes, they will only produce information in CSV format and are not and will never be available on the API.

 

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