TRADACOMS ›
Availability Report › AVLDET
AVLDET: Availability Report Details
The AVLDET message is part of the TRADACOMS Availability Report file: product availability reports.
The Availability Report file contains: AVLHDR → AVLDET → AVLTLR.
Message structure
| Segment | Name | Usage |
|---|---|---|
MHD | Message Header | One message for each Availability Report |
ARF | Availability Report Reference | |
DNA | Data Narrative | Repeat if necessary at reference level |
AVD | Availability Line Details | Repeat for each product and for actual and historical values |
DNB | Data Narrative | Repeat for each line detail |
ATR | Availability Trailer | |
PAT | Planned Availability Trailer | |
MTR | Message Trailer |
Segments and data elements
| Element | Name | M/C | F/V | Format | Notes |
|---|---|---|---|---|---|
MSRF | Message Reference | M | V | 9(12) | Consecutive count of messages within the transmission |
TYPE | Type of Message composite | M | 'AVLDET' '4' for this version | ||
| Type | M | F | X(6) | ||
| Version Number | M | F | 9(1) |
| Element | Name | M/C | F/V | Format | Notes |
|---|---|---|---|---|---|
AREF | Availability References/Series No. | M | V | X(17) | Unique reference for this availability report |
RPSD | Report Period Start Date | M | F | 9(6) | Format: YYMMDD |
RPED | Report Period End Date | M | F | 9(6) | Format: YYMMDD |
| Element | Name | M/C | F/V | Format | Notes |
|---|---|---|---|---|---|
SEQA | First Level Sequence Number | M | V | 9(10) | Starts at 1 and incremented by 1 for each repeat of this segment |
DNAC | Data Narrative Code composite | C | Standard data narrative previously defined and agreed by sender and receiver Number of relevant code list Code Value from code list · code list 22 | ||
| Code Table Number | C | V | 9(4) | ||
| Code Value | C | V | X(3) | ||
RTEX | Registered Text composite | C | Essential text, where not provided for by specific fields may be communicated using this element. Application codes to define the function of the text must be registered with the ANA prior to use. The same application code may be repeated up to four times, or up to four different codes may be used · code list 24 | ||
| First Registered Application Code | C | V | X(3) | ||
| Application Text | C | V | X(40) | ||
| Second Registered Application Code | C | V | X(3) | ||
| Application Text | C | V | X(40) | ||
| Third Registered Application Code | C | V | X(3) | ||
| Application Text | C | V | X(40) | ||
| Fourth Registered Application Code | C | V | X(3) | ||
| Application Text | C | V | X(40) | ||
GNAR | General Narrative composite | C | |||
| General Narrative Line 1 | C | V | X(40) | ||
| General Narrative Line 2 | C | V | X(40) | ||
| General Narrative Line 3 | C | V | X(40) | ||
| General Narrative Line 4 | C | V | X(40) |
| Element | Name | M/C | F/V | Format | Notes |
|---|---|---|---|---|---|
SEQA | First Level Sequence Number | M | V | 9(10) | Starts at 1 and is incremented by 1 for each repeat of this segment |
APIN | Actual/Proposed Status Indicator | M | F | X(1) | 0 = Actual Stock Details Follow 1 = Proposed Stock Details Follow |
SPRO | Supplier's Product Number composite | M | Either the EAN traded unit code or the supplier's code must be quoted EAN Article number allocated to the unit of trade Supplier's internal reference (non-EAN) identifying the traded unit Code for the traded unit allocated under the alternative (DUN-14) EAN system | ||
| EAN-13 Article Number for the Unit of Trade | C | F | 9(13) | ||
| Supplier's Code for the Traded Unit | C | V | X(30) | ||
| DUN-14 Code for the Traded Unit | C | F | 9(14) | ||
SACU | Supplier's EAN Article Number for Designated Consumer Unit | C | F | 9(13) | EAN number allocated to the retail (POS) unit. (Insert five leading zeros before eight digit codes) |
CPRO | Customer's Product Number composite | C | Can be used for 'own label' items allocated a customer's internal number Customer's internal reference for the item - non-EAN format | ||
| Customer's Own Brand EAN Number | C | F | 9(15) | ||
| Customer's Item Code | C | C | X(30) | ||
UNOR | Unit of Ordering composite | M | Quote at least 1 of the 3 sub-elements. Measure Indicator must be quoted if Ordering Measure is used Number of consumer units making up the supplier's traded unit Required when ordering variable measure items Abbreviation for the ordering measure. Code Values List 4. Mandatory if Ordering Measure used | ||
| Consumer Units in Traded Unit | C | V | 9(15) | ||
| Ordering Measure | C | V | 9(10)V9(3) | ||
| Measure Indicator | C | V | X(6) | ||
CLSK | Closing Stock for the Period composite | C | Actual Closing Stock if APIN=0 Planned Closing Stock if APIN=1 Number of traded units of closing stock Total weight, volume, etc. of closing stock. Only required for variable measure items Values List 4. Mandatory if Total Measure of Closing Stock used | ||
| Number of Closing Stock Order Units | C | V | 9(15) | ||
| Total Measure of Closing Stock | C | V | 9(10)V9(3) | ||
| Measure Indicator | C | V | X(6) | ||
QPRO | Quantity Produced composite | C | Quantity produced for the period Actual if APIN = 0 Planned if APIN = 1 Number of supplier's ordering units produced for the period Total weight, volume, etc. produced for the period Only required if reporting on items of variable measure Abbreviation for the production measure. Code Values List 4 | ||
| Number of Order Units Produced | C | V | 9(15) | ||
| Total Measure Produced this Period | C | V | 9(10)V9(3) | ||
| Measure Indicator | C | V | X(6) | ||
DELQ | Delivery Quantity composite | C | At least one of the 3 sub-elements must be used. Measure Indicator must be shown if Total Measure of Delivery used Number of supplier's traded units in delivery Total weight, volume, etc. of delivery Only required when delivering variable measure items Abbreviation of the order measure. Mandatory if Total Measure of Delivery used. Code Values List 4 | ||
| Number of Traded Units in Delivery | C | V | 9(15) | ||
| Total Measure of Delivery | C | V | 9(10)V9(3) | ||
| Measure Indicator | C | V | X(6) |
| Element | Name | M/C | F/V | Format | Notes |
|---|---|---|---|---|---|
SEQA | First Level Sequence Number | M | V | 9(10) | Takes the value of SEQA in the preceding segment with which this segment is nested |
SEQB | Second Level Sequence Number | M | V | 9(10) | Starts at 1 and incremented by 1 for each repeat of this segment |
DNAC | Data Narrative Code composite | C | Standard data narrative previously defined and agreed by sender and receiver Number of relevant code list Code Value from code list · code list 22 | ||
| Code Table Number | C | V | 9(4) | ||
| Code Value | C | V | X(3) | ||
RTEX | Registered Text composite | C | Essential text, where not provided for by specific fields may be communicated using this element. Application codes to define the function of the text must be registered with the ANA prior to use. The same application code may be repeated up to four times, or up to four different codes may be used · code list 24 | ||
| First Registered Application Code | C | V | X(3) | ||
| Application Text | C | V | X(40) | ||
| Second Registered Application Code | C | V | X(3) | ||
| Application Text | C | V | X(40) | ||
| Third Registered Application Code | C | V | X(3) | ||
| Application Text | C | V | X(40) | ||
| Fourth Registered Application Code | C | V | X(3) | ||
| Application Text | C | V | X(40) | ||
GNAR | General Narrative composite | C | |||
| General Narrative Line 1 | C | V | X(40) | ||
| General Narrative Line 2 | C | V | X(40) | ||
| General Narrative Line 3 | C | V | X(40) | ||
| General Narrative Line 4 | C | V | X(40) |
| Element | Name | M/C | F/V | Format | Notes |
|---|---|---|---|---|---|
NOPA | Number of Availability REPORTS | M | V | 9(10) | Number of AVD segments in this message for APIN = 0 |
| Element | Name | M/C | F/V | Format | Notes |
|---|---|---|---|---|---|
NOPA | Number of Availability REPORTs | M | V | 9(10) | Number of AVD segments in this message for APIN = 1 |
| Element | Name | M/C | F/V | Format | Notes |
|---|---|---|---|---|---|
NOSG | Number of Segments in Message | M | V | 9(10) | Control count of the number of segments comprising message. Includes the MHD and MTR segments |
Need to exchange TRADACOMS messages with a UK retailer?
SupplyLens connects your ERP, e-commerce or accounting system to any TRADACOMS or EDIFACT trading partner: orders in, invoices out, fully managed.
Book a demo Learn about retail EDI →