Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Overview

Confirmation of new orders received

...

Scheduling

Standard (daily, weekly, monthly or On demand)

Filename Convention

SiteCode_CustomerCode_NewOrds_datetime.xml

e.g. RF_JONES_NewOrds_201705111338.xml

Limitations

Only one orders report can be run, if run it will mark the record as exported. The report will only bring back records for the past 30 days that are not marked as exported.

Last Updates

We will only show entries highlighting changes which are less than 2 years old

XML Segments, Elements and Notes

Date

Change

 

 

 

 

Example Output

PDF

Not available

CSV

Not available

XML

View file
name24.xml

XML Specifications

Segment

Segment

L1

Segment

L2


Notes

<NewOrds>

<HD>

<HD> can repeat many times within the <NewOrds>

<LD>

Can repeat many times within the <HD>

</LD>

<LM>

Will be in the LD section once

</LM>

</HD>

</NewOrds>



Segment

L1 Sub Segment

L2 Sub Segment

Element

Field Name

Type

Size

Notes

<HD>

<Cust>

Customer Code

AN

8

<Site>

Site Code

AN

6

<UID>

System UID

INT

Unique System Reference for this Order

<DocRef>

Document Reference

AN

20

Customers Order Reference number

<DPRef>

DP Ref / Order Ref

AN

20

Delivery Point Ref or Order Ref - usually the DP customer code.

<CustPORef>

Customer Reference

AN

20

Customer PO Ref

<OrdDate>

Order Date

ddmmyy

Date order was received

<DPName>

Delivery Point Name

AN

...

40

<DPTown>

Delivery Point Town

AN

...

50

<DPPostcode>

Delivery Point Postcode

AN

15

<DPCo>

Delivery Point Country

AN

2

ISO 2 digit country

...

DeliveryPostcode

...

10

...

OrderDate

...

10

...

Cases

...

10

...

Singles

...

10

...

DefermentCustomer

...

code

<HMRCType>

Movement Type

AN

6

Movement Type Code

<LD>

<PCode>

Product Code

AN

30

Requested product code

<PDesc>

Description

AN

50

<PBrand>

Brand

AN

50

<Rtn>

Rotation Number

AN

10

requested rotation number

<RtnLn>

Rotation Line No

INT

4

requested rotation line number

<Batch>

Batch Number

AN

20

requested batch number

<Cases>

Cases

INT

requested cases

<Singles>

Singles

INT

requested singles

<Tsingles>

Tsingles

INT

requested tsingles

<CLineNo>

Line number

AN

6

Your line number sent to the warehouse in your sales order file.

<LM>

<MD_PCode>

Destination Product Code

AN

30

Manufacturing only segment - Destination Product Code

<MD_Case>

Destination Cases

INT

Destination Cases

<MD_Single>

Destination Singles

INT

Destination Singles

<MD_SPC>

Destination SPC

INT

Destination SPC