Overview | This file extracts stock records with frozen stocks and their frozen quantities. A record is only extracted when there has been a change to the frozen stock quantity against a rotation, therefore it is not repeated every time this file is generated. | |
Format
The report is in xml format.
Delivery & Scheduling
The report can be scheduled to run automatically on an hourly, 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_CustomerCode_FrznAud_Datetime. (xml)
Limitations
There are no known limitation to the production of this file, but customers should read the delivery and scheduling section and understand what they ask for especially with real time information as this can become over whelming if used, we would suggest hourly updates as the most regular style of update.
Field Names & Content for XML File
File Identifier - <FrznAud>
Example
<FrznAud>
<A>
...fields...
</A>
...
File name conventions | SiteCode_CustomerCode_FrznAud_Datetime. <format> | |
Limitations | If extracted this will not be output again, each time the extract is run any items not already output will be output. | |
Last Updates
We will only show entries highlighting changes which are less than 2 years old
Date | Change |
|---|---|
|
|
|
|
Example Output
Not available
CSV
Not available
XML
| View file | ||
|---|---|---|
|
XML Specification
Segment | Segment L1 | Segment L2 | Notes |
|---|---|---|---|
<FrznAud> |
|
|
|
| <A> |
| Repeats multiple times within the <FrznAud> |
| </A> |
|
|
<FrznAud> |
|
|
|
XML Segment | XML | Length | ||
<A> |
|
...
<A>
|
|
| ||
| <Site> | AN | 2 | Site code where the customer account stores |
| <Cust> | AN | 8 | Customer account code |
| <PCode> | AN | 30 | Product Code |
| <PDesc> | AN | 50 | Description |
| <PBrand> | AN | 50 | Brand |
| <Rotn> | AN | 15 | Rotation |
...
Number | ||||
| <RotLn> | INT | 4 | Rotation line number (if not blank) |
| <FRCode> | AN | 8 | Frozen Reason Code (when applicable) |
| <FRText> | AN | 50 | First 50 characters of the reason for freezing |
| <FUserID> | INT | 4 | User ID for this transaction |
| <FUserName> | AN | 30 | User Name |
| <DP> | Bit |
| Duty Paid Status 0 = No and 1 = Yes (of the stock at the time of the transaction) |
| <DT> | ddmmyy | 23 | The date and time of the frozen quantity check / extract. |
| <TSF> | int | 10 | The total singles frozen against the rotation at the time reported in the <DT> field. |
| <SF> | int | 10 | Singles Frozen in this transaction |
| <SU> | int | 10 | Singles Unfrozen in this transaction |
| <SS> | decimal | 8.5 | Single size, litres |
| <SPC> | int | 6 | The number of singles in each case for this rotation number. |
| <CPP> | int | 6 | The number of cases on the pallet for this rotation number. |
...
</A>
...
...
| <ADT> | ddmmyy | 23 | Auto Date Time |
| <CBN> | varchar | 20 | Customer Batch No |
| <AUF> | varchar | 4 | Auto Unfrozen Yes / No / NA |
</A> |
|
|
|
|