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

ID
API Ref

ReportName

ShortName

Availability

PDF

CSV

XML
File

XML
API

Last Updated

2101

Stock Snapshot By Product

StkPrdt

Standard

Y

Y

Y

Y

 

2102

Stock Snapshot By Rotation

StkRotn

Standard

Y

Y

Y

Y

 

2103

Stock Snapshot By Product Enhanced

StkPrdtE

Enhanced

Y

Y

Y

Y

 

2104

Stock Snapshot By Rotation Enhanced

StkRotnE

Enhanced

Y

Y

Y

Y

14/11/2022

2105

Multi Site Product Stock

 

Enhanced

 

 

 

 

 

2110

Stock Frozen Audit

FrznAud

Enhanced

 

 

Y

Y

 

2120

Stock Loss

StkLoss

Standard

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

Standard

Y

Y

Y

Y

24/02/22

2202

Goods Received Enhanced

GdsRcvdE

Enhanced

Y

Y

Y

Y

24/02/22

2310

Order Status

 

API Module

 

 

 

Y

 

2311

Order Status by Doc Ref

 

API Module

 

 

 

Y

 

2320

Orders Received

NewOrds

Standard

 

 

Y

Y

 

2321

Held Orders

HldOrds

Standard

Y

Y

 

 

 

2322

New Orders Entered and Held Orders

NewOrds

Standard

Y

Y

Y

Y

 

2340

Order Picking Confirmation

OrdPckd

Standard

Y

Y

Y

Y

 

2350

Transaction Audit

TrsnAud

Enhanced

 

 

Y

Y

 

2355

Intrastat

Intrast

Standard

Y

Y

Y

Y

 

2360 

POC Export

 

Standard

 

 

Y

 

2410

Delivery Status

 

API Module

 

 

Y

Y

 

2411

Delivery Status by Doc Ref

 

API Module

 

 

Y

 

2480

POD Extract

PODExtr

Standard

 

Y

 

 

 

2490

EPOD

ePOD

Standard with VD
Can not be scheduled

Y

 

 

 

 

2600

Documents

 

API Module

 

 

 

Y

 

2610

Products

 

API Module

 

 

 

Y

 

2620

Excise And VAT Summary

ExcsVAT

Standard with VB
Can not be scheduled

Y

Y

 

 

13/07/2022

7001

Intra Vision PO

InVisPO

Additional Module

 

 

Y

Y

 

8001

Order Transaction Audit

StkTrsn

Standard

 

Y

 

 

 

8002

Warehouse Despatch Advice

WhsDspt

Enhanced

 

Y

 

 

 

8003

Notification Issue List

NtfnIss

Enhanced

 

 Y

 

 

 

9001

Management Warehousing

MgmtWhs

Standard

Y

 

 

 

 

9002

Management Transport

MgmtTpt

Standard

Y

 

 

 

 

9003

Stock Inwards Non Conformance

 

Enhanced

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.