2203 Reserve Customer Goods Received

Overview

This file extracts all goods received into the warehouse for specific days and can be used to replace the automated goods received report.

Format (and filename suffix)

CSV or XML

Filename Convention

SiteCode_CustomerCode_RGdsRcvd_Datetime.        

Limitations

This is designed for confirmation to the reserve customer.

You need to schedule this report and the flag in reserve customers marked as REPORT will be used to generate the report for the user, whichever Reserve reports you schedule the customer will receive all of them.

If you ask for a daily report then you will be sent the previous days information

If you ask for a weekly report then you will receive information for the previous week

If you ask for a monthly report then you will receive information for the past month.

Field Name

Length

Notes

<HD>

CustomerCode

8

PurchaseOrderNo

30

Your purchase order number, each po number is usually dealt with on a single receipt.

Details

90

General Notes on the receipt.

SupplierName

30

This information is held, and can be the supplier or yourself, it is used in declarations to HMRC for payment of duties should that be required.

DateReceived

10

The date in which the goods arrived on site, and the rental start date.

DeliveryType

6

See code list B - this is used to signify the type of receipt and potentially the agreed warehouse charges for the receipt.

HMRCType

6

HMRC Movement Type Code

Site

6

Stock Holding Customer Site

SAC

8

Supplier Account Code

SAS

6

Supplier Account Customer Site (only when delivery type is TRA) (Incoming Transfers)

SDocRef

20

This is auto filled into the Other details field on the receipt. (only when delivery type is TRA)(Incoming Transfers)

SDPRef

20

Prefixed with DPREF: this is autofilled in the Purchase Order details for a transfer(only when delivery type is TRA)(Incoming Transfers)

</HD>

<LD>

RotationNumber

10 or 15

ProductCode

20

ProductDescription

50

PackageDescription

50

SinglesPerCase

6

Cases

6

Singles

6

TotalInSingles

6

DutyPaid

3

Is the stock arriving Duty Paid status.

ProductCostperCase

10.2

ProductCostCurrency

3

Uses ISO currency code.

FreightCostperCase

10.2

FreightCostCurrency

3

InsuranceCostperCase

10.2

InsuranceCostCurrency

3

FreeCirculation

3

Is the stock in Free Circulation within the EC, this means is “Customs Duty “ paid

ReserveCustomer

8

If the stock goes into a reserve customer code account then the code is shown here.

ReserveName

BestBeforeDate

8

If the stock has a best before date then this is shown in the field here, the format is normally  dd/mm/yy

OriginalWoodenCase

3

A Yes or No field, and is used when the case containing the stock is the original wooden case

NoOfPallets

6

If the stock is received in pallets then the number of pallets is shown in this field, normally used when pallet space charging is in use, a part pallet will show as one more pallet received.

CasesPerPallet

6

The number of cases on the pallet for this rotation number.

RotationNotes

30

Any general notes made by the warehouse on the receipt of the goods for this rotation, can include damage or notification of issues with the goods received.

EMCSInfo

30

This will be introduced in 2010 and is a EU system to control the movement of goods in the EU and the UK.  The EMCS reference is the sending warehouse unique identifier for these goods, and can show you that the receipt of the goods has discharged the sender of their HMRC obligation for receipt.

PALineNo

The line number provided in the Pre Advice file from the customers system. If the warehouse have manually added any item lines then this number will be blank to signify that it was not sent from your system in the first place and that you need to manually review this line.

StockDate

Date the stock was available in the warehouse

RentDate

Date the stock rent period starts from (even if there is then a free period this will be at the start of the period)

ABV

8.2

The strength of the product.

</LD>