Versions Compared

Key

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

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.

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

PDF

 Not available

CSV

 Not available

XML

View file
name22.xml

XML Specification

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>

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>