Page Comparison

<HD>1

CustomerCode

Y

A

8

Customer will supply the alphanumeric customer code which will then have to be looked up for the FKID of the customer.

Mandatory

<HD>2

CustomerPONumber

Y

A

20

Insert your PO Number which should be a unique number for the purchase order and something which your supplier/shipper/haulier can use to quote for booking purposes.

Mandatory

<HD>3

CustomerPODate

Y

D

Format dd/mm/yyyy or dd/mm/yy

Mandatory

<HO>1

SiteCode

Y

A

2

Mandatory -  this field is MANDATORY for all files

<HO>2

DeliveryType

Y

A

6

Standard Codes which can be sent with a Pre-Advice

CodeDescriptionNotesFOR USE IN PRE-ADVICE EDI FILESPURPurchased Goods

Use this as default.

XTRExternal TransferStock moving from an external source into the customers stock, where ownership has not changedRWCReWarehouse CustomerGoods Re-warehoused at the request of the customerRFCCollection from CustomerBring goods back into the warehouseINTERNAL USE ONLY - USED BY THE WAREHOUSE - DO NOT SEND ON PRE-ADVICEUNSUnsure / Unknown
TRATransferInternal warehouse transfer of stock to your accountWKOWorks Order
XTRExternal TransferStock moving from an external source into the customers stock, where ownership has not changedCTOCustomer Take On
STK

Stock Management

RETReturn from a Delivery

Mandatory -  this field is MANDATORY for all files

<HO>3

SupplierCode

A

8

If you know the supplier code which is stored on the warehouse keeper system then this can be filled in, instead of having to complete the full supplier details below.

The supplier codes are customer specific and you can only select your own supplier, if supplied it must be correct

Optional - Do not fill this in if you do not know the correct code as the system will fail the entire incoming pre-advice if an invalid code is sent.

DO NOT USE THIS IF YOU ARE USING A 3PL WAREHOUSE TO STORE YOUR STOCK

<HO>4

ShipperCode

A

8

If you know the shipper code which is stored on the warehouse keeper system then this can be filled in, instead of having to complete the full shipper details below.

The shipper codes are shared among all customers as the same companies are generally used by everyone.
If supplied this must be correct

Optional - Do not filll this in if you do not know the correct code the system will reject the entire pre-advice if this is an invalid code.

DO NOT USE THIS IF YOU ARE USING A 3PL WAREHOUSE TO STORE YOUR STOCK

<HO>5

ExpectedDeliveryDate

Y

D

Format dd/mm/yyyy or dd/mm/yy

Mandatory

<HO>6

Container

B

Either Y or N

Optional – Default is NO

<HO>7

ContainerNumber

A

20

Conditional – Should be supplied if this is arriving in container, but can be left blank

<HO>8

SlipSheetsInUse

B

Either Y or N

Optional – Default is NO

<HO>9

OnPallets

B

Either Y or N

Optional – Default is NO

<HO>10

SupplierName

Y

A

50

Conditional – If HO<3> is supplied then this is not required, otherwise MANDATORY

If this is being used for Delivery Type = COLL (e.g. You are asking the warehouse to pick the goods up and return to the warehouse) then supply the collection name and address in the fields HO10-HO26

<HO>11

SupplierContactName

Y

A

50

Conditional – If HO<3> is supplied then this is not required, otherwise MANDATORY

<HO>12

SupplierAccountCode

A

20

Conditional – If HO<3> is supplied then this is not required, otherwise Optional

<HO>13

SupplierAddressLine1

Y

A

50

Conditional – If HO<3> is supplied then this is not required, otherwise MANDATORY

<HO>14

SupplierAddressLine2

Y

A

50

Conditional – If HO<3> is supplied then this is not required, otherwise Optional

<HO>15

SupplierAddressLine3

Y

A

50

Conditional – If HO<3> is supplied then this is not required, otherwise Optional

<HO>16

SupplierTown

Y

A

50

Conditional – If HO<3> is supplied then this is not required, otherwise MANDATORY

<HO>17

SupplierPostcode

Y

A

15

Conditional – If HO<3> is supplied then this is not required, otherwise Conditional if FKSupplier country = GB

<HO>18

SupplierCountry

Y

A

2

ISO-3166 – 2 digit country codes

Conditional – If HO<3> is supplied then this is not required, otherwise MANDATORY

If UK then GB needs to be entered !! 

<HO>19

SupplierTelephone

A

20

Optional –If HO<3> is supplied then this is not required.

<HO>20

SupplierFax

A

20

Optional –If HO<3> is supplied then this is not required.

<HO>21

SupplierEmail

A

50

Optional –If HO<3> is supplied then this is not required.

<HO>22

ShipperName

Y

A

50

Conditional – If HO<3> is supplied then this is not required, otherwise it is MANDATORY field

<HO>23

ShipperContactName

A

50

Conditional – If HO<3> is supplied then this is not required, otherwise it is Optional field

<HO>24

ShipperContactTelephone

A

20

Conditional – If HO<3> is supplied then this is not required, otherwise it is Optional field

<HO>25

ShipperContactFax

A

20

Conditional – If HO<3> is supplied then this is not required, otherwise it is Optional field

<HO>26

ShipperContactEmail

A

50

Conditional – If HO<3> is supplied then this is not required, otherwise it is Optional field

<HO>27

ExpectedNoOfLines

Y

I

Total number of product lines due

Mandatory

<HO>28

ExpectedNoOfCases

Y

I

Total number of cases due

Mandatory

<HO>29

ArrangeCollection

Y

B

1

Y or N

Optional - Will default to N if not set. If you select Y then section PH/PD sections are then active.