...
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 | |
...
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.
...
. | ||
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 |
|---|---|
|
...
Links to the output formats are below
...
| |
|
|
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> |
|
|
|
|
| <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. |
| <ADT> | ddmmyy | 23 | Auto Date Time |
| <CBN> | varchar | 20 | Customer Batch No |
| <AUF> | varchar | 4 | Auto Unfrozen Yes / No / NA |
</A> |
|
|
|
|