Overview
A confirmation of stock losses.
Format
The report is in csv format, which means it can be read into your system or can be opened in excel. It is also available in PDF format.
Delivery & Scheduling
The report can be scheduled to run automatically on a daily, weekly or monthly basis or it can be requested via the web site on an ad-hoc real time basis.
It is up to the customers whether this is scheduled.
The file will normally be emailed to your email address as an attachment to an existing message.
File Name Convention
The filename will be
FullCustomerName_StockLoss_datetime.csv
Limitations
Each time the report is sent, only stock losses which you’ve not already been informed of will be included.
CSV Field Names & Content
Field Name | Length | Comments |
CustomerCode | 8 |
|
CustomerName | 30 |
|
ProductCode | 50 |
|
ProductDescription | 50 |
|
RotationNumber | 13 |
|
Package | 12 |
|
Ref | 10 |
|
DateLostInStore | 10 |
|
CasesLost | 10 |
|
SinglesLost | 10 |
|
LitresOfLiquid | 18 |
|
LitresOfAlcohol | 18 |
|
TaxCode | 3 |
|
Reason | 150 |
|
XML Field Names & Content
File Identifier - <StkLoss>
Field Name | XML Segment | XML Element | Length | Comments |
| <LD> |
|
|
|
CustomerCode |
| <CustCode> | 8 |
|
CustomerName |
| <CustName> | 30 |
|
ProductCode |
| <PCode> | 50 |
|
ProductDescription |
| <PDescription> | 50 |
|
RotationNumber |
| <Rotation> | 15 |
|
Ref |
| <UID> | 10 | Internal Warehouse Reference No |
DateLostInStore |
| <LossDate> | 10 |
|
CasesLost |
| <LC> | 10 |
|
SinglesLost |
| <LS> | 10 |
|
LitresOfLiquid |
| <LOL> | 18 |
|
LitresOfAlcohol |
| <LOA> | 18 |
|
TaxCode |
| <TAX> | 3 |
|
Commodity Code |
| <CCODE> | 12 |
|
Reason |
| <REASON> | 150 | Text Reason |
| </LD> |
|
|
|