Overview |
|---|
...
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
...
<SiteCode>_<CustomeCode>_StkLoss_ |
...
<datetime>. |
...
Limitations | Each time the report is sent, you will only | |
|---|---|---|
...
receive losses which |
...
you have not |
...
been |
...
previously notified of |
...
. |
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
...
...
Last Updates
We will only show entries highlighting changes which are less than 2 years old
Date | Change |
|---|---|
|
|
|
|
Example Output
| View file | ||
|---|---|---|
|
CSV
| View file | ||
|---|---|---|
|
XML
Not available
XML Specifications
Segment | Element | Field Name | Length | Comments |
<LD> | ||||
<CustCode> | CustomerCode | 8 | ||
<CustName> | CustomerName | 30 | ||
<PCode> | ProductCode | 50 | ||
<PDescription> | ProductDescription | 50 | ||
<Rotation> | RotationNumber | 15 | ||
<UID> | Ref | 10 | Internal Warehouse Reference No | |
<LossDate> | DateLostInStore |
...
...
10 |
...
<LC> | CasesLost |
...
...
<LC>
10 |
...
<LS> | SinglesLost |
...
...
10 |
...
<LOL> | LitresOfLiquid |
...
...
18 |
...
<LOA> | LitresOfAlcohol |
...
...
18 |
...
<TAX> | TaxCode |
...
...
3 |
...
<CCODE> | Commodity Code |
...
...
12 |
...
<REASON> | Reason |
...
...
150 | Text Reason |
...
</LD> |
...
...
...
...