2110 Stock Frozen Audit

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.

<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>