| Notes | |
|---|---|
| Overview |
...
| Confirmation of stock losses |
...
Formats |
|---|
Format
...
| CSV XML | |
| PDF Available | Yes |
|---|---|
| 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.
Delivery is defined through customer contacts in Vision warehousing. Only those selected will receive the scheduled report. The file will |
...
be |
...
emailled directly to the contact(s) |
| File Name Convention |
|---|
The filename will be
...
| <SiteCode>_<CustomeCode>_StkLoss_ |
...
| <datetime>. (xml or 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> |
|
|
|
Links to the output formats are below