Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.



Notes

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 (including file extension)XML
PDFNo
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 conventionsSiteCode_CustomerCode_FrznAud_Datetime.    <format>
LimitationsIf extracted this will not be output again, each time the extract is run any items not already output will be output.

 

Field Names & Content for XML File


Segment

Segment

L1

Segment

L2

Notes
<FrznAud>



<A>
Repeats multiple times within the <FrznAud>

</A>

<FrznAud>


 

XML Segment

XML

Element


Length

 

<A>

 


 

 

 

<Site>

AN

2

Site code where the customer account stores

 

<Cust>

AN

8

Customer account code


<PCode>AN30Product Code

<PDesc>AN50Description

<PBrand>AN50Brand

 

<Rotn>

AN

15

Rotation Nuber


<RotLn>INT4Rotation line number (if not blank)

<FRCode>AN8Frozen Reason Code (when applicable)

<FRText>AN50First 50 characters of the reason for freezing

<FUserID>INT4User ID for this transaction

<FUserName>AN30User 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>int10Singles Frozen in this transaction

<SU>int10Singles Unfrozen in this transaction
 <SS>decimal8.5Single size, litres
 <SPC>int6The number of singles in each case for this rotation number.
 <CPP>int6The number of cases on the pallet for this rotation number.

</A>

 


 

 

...