Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 12 Next »


Notes

Overview

Confirmation of new orders received

Format

XML

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.

XML Segments, Elements and Notes

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 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


  • No labels