Frames | No Frames

Return to Stylus Studio EDIFACT home page.
Return to Stylus Studio EDIFACT D93A Messages page.


This message is available for formal trial in the present version for a period of at least twelve months from the date of approval by the UN/ECE/TRADE/WP.4.

Organisations are invited to trial this message and are requested to notify their Rapporteur Team Secretariat of their intention. Comments on the results from the trial should also be forwarded to the Secretariat as soon as they are available. Based on the results of the trials, a UNSM will be issued.

It should be noted that this material is contained in a Trial Directory; however, it may differ from that in the UN Directories (UNTDID) having the same identfying tags. Any differences will be reconciled prior to the message becoming a UNSM.

Message Type:SLSRPT
Contr. Agency:UN
SOURCE:Submitted by WEEB-MD1 on behalf of PAEB

  1. Introduction
  2. Scope
    1. Functional Definition
    2. Field of Application
    3. Principles
  3. References
  4. Message Definition
  5. Message Definition
    1. Data Segment Clarification
    2. Message structure
      1. Branching Diagram
      2. Segment Table
    3. Data Segment Index (Alphabetic Sequence)

For general information on UN standard message types see UN Trade Data Interchange Directory, UNTDID, Part 4, Section 2.5, UN/ECE UNSM General Introduction.

This message also occurs in the following versions of this standard:
D93A, D94A, D94B, D95A, D95B, D96A, D96B, D97A, D97B, D98A, D98B, D99A, D99B, D00A, D00B, D01A, D01B, D01C, D02A, D02B, D03A, D03B, D04A, D04B

0. Introduction

This specification provides a proposal for the definition of the United Nations Standard Sales Data Report Message to be used in Electronic Data Interchange (EDI) between trading partners, involved in administration, commerce and transport.

1. Scope

1.1. Functional Definition

A message to enable the transmission of sales data related to products or services, such as corresponding location, period, product identification, pricing, monetary amount, quantity, market sector information, sales parties. It enables the recipient to process the information automatically and use it for production, planning, marketing, statistical purposes, etc.

1.2. Field of Application

The Sales Data Report Message may be applied for both national and international trade. It is based on universal commercial practice and is not dependent on the type of business or industry.

1.3. Principles

The message intent is to provide sales information for one or more locations for a series of products within a specified time period. The message is transmitted either from a seller to its supplier or from a headquarters, coordination or distribution centre to a manufacturer, supplier or a third party, such as a marketing institute for statistical analysis. It allows the recipient to know for a specific product the:

  • Location of the sale
  • Period in which it was sold
  • Product identification
  • Product selling price, quantity and value of the sales
  • Additional Identification of the products such as promotional flags, product group or family identification and internal identification numbers
  • Periodical Turnover of a specified location
  • Global specified product sales, i.e. total sales of a product in all locations
  • Sales channel, market segment end use
  • Sales parties identification. Though the message is location driven, it is conceivable that the recipient process the data to derive information based on other variables such as a specific product and all its related sales locations and/or addresses or periodic turnover and the related locations.

2. References

See UNTDID, Part 4 Section 2.5 UN/ECE UNSM - General Introduction, Section 1.

3. Terms and Definitions

See UNTDID, Part 4, Section 2.5 UN/ECE UNSM - General Introduction, Section 2.

4. Message Definition

4.1. Data Segment Clarification

This section should be read in conjunction with the Branching Diagram and the Segment Table which indicate mandatory, conditional and repeating requirements.

0010 UNH, Message header

A service segment starting and uniquely identifying the message. The message type code for the UN Sales Data Report Message is SLSRPT. Note: Sales data report message conforming to this document must contain the following data in segment UNH, composite S009: Data element 0065 SLSRPT 0052 D 0054 93A 0051 UN

0020 BGM, Beginning of message

A segment by which the sender must uniquely identify the sales data report by means of its type and number.

0030 DTM, Date/time/period

A segment specifying general dates and, when relevant, times related to the whole message. The sales report preparation date and the sales period covered by the report must be specified using this segment.

0040 Segment Group 1: NAD-SG2

A group of segments identifying the parties with associated information.

0050 NAD, Name and address

A segment identifying names and addresses of the parties, in coded or clear form, and their functions relevant to the sales data report. Identification of the sender of the report and the recipient is mandatory for the sales data report message. It is recommended that where possible only the coded form of the party ID should be specified e.g. the sender and receiver of the report are known to each other, thus only the coded ID is required, but when a new address might have to be clearly specified, this should be done preferably in structured format.

0060 Segment Group 2: CTA-COM

A group of segments giving contact details of the specific person or department within the party identified in the NAD segment.

0070 CTA, Contact information

A segment to identify a person or department, and their function, to whom communications should be directed.

0080 COM, Communication contact

A segment to identify a communications type and number for the contact specified in the CTA segment.

0090 Segment Group 3: RFF-DTM

A group of segments for giving references and where necessary, their dates, relating to the whole message e.g. contract number.

0100 RFF, Reference

A segment identifying the reference by its number and where appropriate a line number within the document.

0110 DTM, Date/time/period

A segment specifying the date/time related to the reference.

0120 Segment Group 4: CUX-DTM

A group of segments specifying the currencies and related dates/periods valid for the whole sales data report. The Segment Group 4 may be omitted in national applications but will be required for international exchanges.

0130 CUX, Currencies

A segment identifying the currencies specified in the sales data report e.g. the currency in which the sales amounts or product prices are expressed in. A rate of exchange may be given to convert a reference currency into a target currency.

0140 DTM, Date/time/period

A segment specifying the date/time/period related to the rate of exchange.

0150 Segment Group 5: LOC-DTM-SG6-SG7

A group of segments providing details of the location for which sales are being reported and the period or sub-period during which the sales took place. There must be at least one occurrence of Segment group 5 within a sales data report.

0160 LOC, Place/location identification

A segment indicating in coded form the location to which the sales data being reported apply e.g. a retail outlet, a geographic area.

0170 DTM, Date/time/period

A segment identifying the sub-period during which the sales being reported occurred if different than the period specified in the heading section e.g. within a biweekly sales data report as specified in the heading section, sales are reported in sub-periods of one week.


A group of segments providing details per location and period of the individual products sold in terms of product family or group, promotional flags, total sale monetary amount and sale price.

0190 LIN, Line item

A segment identifying the line item by the line number and configuration level, and additionally identifying the product or service that has been sold.

0200 PIA, Additional product id

A segment providing either additional identification to the product specified in the LIN segment or providing any substitute product identification. In the Sales Data Report the PIA segment can be used when a product specified in LIN has to be associated with a group or family of products whose identity could be specified in PIA.

0210 IMD, Item description

A segment for describing the product in the line item.

0220 PAC, Package

A segment specifying the number and type of packages.

0230 RFF, Reference

A segment for referencing documents or other numbers pertinent to the line item.

0240 DOC, Document/message details

A segment identifying and providing information relating to documents.

0250 ALI, Additional information

A segment indicating that the line item is subject to special conditions owing to origin, customs preference, embargo regulations or commercial factors. In the Sales Data Report the ALI segment can be used to specify promotional flags, e.g. to indicate what type of promotion if any was in effect when the product specified in LIN was sold.

0260 MOA, Monetary amount

A segment specifying any monetary amounts relating to the product. For the sales data report the MOA segment can be used to express the total monetary amount of the product sold in one location for one period.

0270 PRI, Price details

A segment to specify the price type and amount. The price used in the calculation of the total sales monetary amount will normally be the selling price.

0280 QTY, Quantity

A segment identifying the product quantity, i.e. quantity sold.

0290 Segment Group 7: NAD-QTY

A group of segments providing split delivery sales parties and relevant quantities information.

0300 NAD, Name and address

A segment identifying the name and address of a party being the recipient of a proportion of the quantity sold.

0310 QTY, Quantity

A segment identifying the product quantity, i.e. quantity sold.

0320 UNT, Message trailer

A service segment ending a message giving the total number of segments in the message and the control reference number of the message.

4.2. Message Structure

4.2.1. Branching Diagram

4.2.2. Segment Table

├─UNH Message header ×1 (M)
├─BGM Beginning of message ×1 (M)
├─DTM Date/time/period ×5 (M)
├─Segment Group 1 ×5 (M)
├─NAD Name and address ×1 (M)
└─Segment Group 2 ×5 (C)
──├─CTA Contact information ×1 (M)
──└─COM Communication contact ×5 (C)
├─Segment Group 3 ×5 (C)
├─RFF Reference ×1 (M)
└─DTM Date/time/period ×5 (C)
├─Segment Group 4 ×5 (C)
├─CUX Currencies ×1 (M)
└─DTM Date/time/period ×5 (C)
├─Segment Group 5 ×200000 (M)
├─LOC Place/location identification ×1 (M)
├─DTM Date/time/period ×5 (C)
└─Segment Group 6 ×200000 (C)
──├─LIN Line item ×1 (M)
──├─PIA Additional product id ×5 (C)
──├─IMD Item description ×5 (C)
──├─PAC Package ×5 (C)
──├─RFF Reference ×5 (C)
──├─DOC Document/message details ×5 (C)
──├─ALI Additional information ×5 (C)
──├─MOA Monetary amount ×5 (C)
──├─PRI Price details ×5 (C)
──├─QTY Quantity ×5 (C)
──└─Segment Group 7 ×100 (C)
────├─NAD Name and address ×1 (M)
────└─QTY Quantity ×5 (C)
└─UNT Message trailer ×1 (M)

4.3. Data Segment Index (Alphabetic Sequence)

ALI Additional information
BGM Beginning of message
COM Communication contact
CTA Contact information
CUX Currencies
DOC Document/message details
DTM Date/time/period
IMD Item description
LIN Line item
LOC Place/location identification
MOA Monetary amount
NAD Name and address
PAC Package
PIA Additional product id
PRI Price details
QTY Quantity
RFF Reference
UNH Message header
UNT Message trailer

Return to Stylus Studio EDIFACT D93A Messages page.
EDI to XML Mapping for EDIFACT/X12 Convert EDIFACT/X12 Schemas to XML Schema Legacy Data Conversion Tools Access Relational Data as XML Visual XSLT and XQuery Mapping Tools EDIFACT to XML
Return to Stylus Studio EDIFACT home page.

Return to Stylus Studio home page.
Site Map | Privacy Policy | Terms of Use | Trademarks
Stylus Scoop XML Newsletter:
W3C Member
Stylus Studio® and DataDirect XQuery ™are from DataDirect Technologies, is a registered trademark of Progress Software Corporation, in the U.S. and other countries. © 2004-2016 All Rights Reserved.