...
CSV Field Name (Reference Only) | In the CSV | CSV Position | XML Segment | XML Element | XML Element (Future Change) | Length | Notes |
| <HD> |
|
|
| |||
Customer Code | Yes | 1 |
| <CustomerCode> | <Cust> | 8 | Your customer code with the warehouse |
| <Site> | <Site> | 6 | Stock holding customer site code. | ||||
Product Code | Yes | 3 |
| <ProductCode> | <Code> | 50 |
|
Product Description | Yes | 4 |
| <Description> | <Desc> | 50 |
|
| </HD> |
|
|
| |||
| <LD> |
|
|
| |||
Rotation Number | Yes | 2 |
| <Rotation> | <Rotn> | 10 or 15 | Rotation Number in the format YY/Dnnnnnn and where rotation line number are in use then YY/Dnnnnnn/nnnn. The 15 digit format is only used when necessary, normally only shows 10 digits unless a line number exists. |
Date Received | Yes | 6 |
| <DateReceived> | <Recd> | 10 |
|
Singles Per Case | Yes | 7 |
| <SPC> | <SPC> | 5 |
|
Present Cases | Yes | 8 |
| <PC> | <PC> | 6 | Whole numbers only, no decimal places, this will be calculated using the rotation level record singles per case |
Present Singles | Yes | 9 |
| <PS> | <PS> | 6 | The remainder of stock which is in addition to the number of cases in stock, this will be calculated using the rotation level record singles per case |
Total Present Singles | Yes | 10 |
| <TotalS> | <TS> | 6 | A total amount in single items. The present stocks figures are the total available stock holdings at the time of the extract and do NOT include items which are frozen. To find your total stock in bond you need to add the Present and Frozen case figures together. |
Frozen Cases | Yes | 11 |
| <FzC> | <FzC> | 6 | Whole numbers only, no decimal places |
Frozen Bottles | Yes | 12 |
| <FzS> | <FzS> | 6 | The remainder of stock which is in addition to the number of cases in stock |
Total Frozen Bottles | Yes | 13 |
| <TotalFzS> | <TFzS> | 6 | A total amount in single items. |
Duty Paid | Yes | 14 |
| <ExciseDP> | <DP> | 3 | Yes or No indicator whether the items have duty paid. |
Reserve Customer Code | Yes | 15 |
| <Reserve> | <Rsrv> | 8 | Only completed is the stock has a reserve customer code allocated |
BBD | Yes | 16 |
| <BBD> | <BBD> | 10 | Best Before Date |
Year | Yes | 17 |
| <Year> | <YR> | 4 | Alternatively ‘vintage’ |
Batch | Yes | 18 |
| <Batch> | <Bth> | 30 | Your batch number (if known) |
Free Circulation | Yes | 19 |
| <CustomsDP> | <FC> | 3 | Free Circulation - Yes / No - is customs duty paid |
OWC | Yes | 20 |
| <OWC> | <OWC> | 3 | Original Wooden Case – Yes / No |
DS | Yes | 21 |
| <DStamp> | <DS> | 3 | Duty Stamped - Yes / No |
|
| <PackageType> | <Pck> | 6 | Package Type Code – as per ISO listings [not in CSV export] | ||
| Single Size | Enhanced | 22 | <SS> | <SS> | 8.5 | ||
| Cases per Pallet | Enhanced | 23 | <CPP> | <CPP> | 6 | ||
| Packaging Code | Enhanced | 24 | <PPackCd> | <PkCd> | 8 | ||
| Packaging Description | Enhanced | 25 | <PPAckDesc> | <PkDe> | 50 | Will be made up from database fields
<Singles per case> X <Single Size>
e.g. 6 x 0.75 2007 Per Pallet : 112 | |
| Total Singles Presently in stock which are underbond | Enhanced | 26 | <TotalSUB> | <TSUB> | 8 | ||
| Total singles currently in stock which are duty paid. | Enhanced | 27 | <TotalSDP> | <TSDP> | 8 | ||
| Brand | Enhanced | 29 | <PBrand> | <Brd> | 50 | ||
| Reserve customer Name | Enhanced | 28 | |||||
| Purchase Order Number | <PONo> | <PO> | 15 | ||||
| Rotation Notes | <RotnNotes> | <RNote> | 50 | ||||
| Product Value per Case | <PValue> | <Value> | 8.5 | Product Value in currency entered | |||
| Product Value Currency | <PValueCurr> | <VCurr> | 3 | ISO Code | |||
| Goods In UID | <GoodsInUID> | <GIUID> | 15 | the pre-advice header number for this receipt. | |||
| </LD> |
|
|
|
...