D96A

Message D96A/SLSRPT

Sales data report message

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.

Message description

UNH M(1) : Message header

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

BGM M(1) : Beginning of message

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

DTM M(5) : 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.

SG1 M(5) : NAD-SG2

A group of segments identifying the parties with associated information.

NAD M(1) : 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.

SG2 C(5) : CTA-COM

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

CTA M(1) : Contact information

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

COM C(5) : Communication contact

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

SG3 C(5) : RFF-DTM

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

RFF M(1) : Reference

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

DTM C(5) : Date/time/period

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

SG4 C(5) : 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.

CUX M(1) : 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.

DTM C(5) : Date/time/period

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

SG5 M(200000) : 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.

LOC M(1) : 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.

DTM C(5) : 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.

SG6 C(99) : RFF-DTM

A group of segments giving references at an intermediate level relating to several lines items, e.g. an invoice, shipment, notification, etc.

RFF M(1) : Reference

To specify a reference.

DTM C(5) : Date/time/period

To specify date, and/or time, or period.

SG7 C(200000) : LIN-PIA-IMD-PAC-RFF-DOC-ALI-MOA-PRI-GIN-SG8

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.

LIN M(1) : 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.

PIA C(5) : 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.

IMD C(5) : Item description

A segment for describing the product in the line item.

PAC C(5) : Package

A segment specifying the number and type of packages.

RFF C(5) : Reference

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

DOC C(5) : Document/message details

A segment identifying and providing information relating to documents.

ALI C(5) : 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.

MOA C(5) : 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.

PRI C(5) : 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.

GIN C(9999) : Goods identity number

A segment to specify identity numbers related to units of the product identified in the LIN segment, e.g. serial number.

SG8 C(999) : QTY-MKS-NAD

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

QTY M(1) : Quantity

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

MKS C(1) : Market/sales channel information

To identify market and sales channel details for products and services information.

NAD C(1) : Name and address

To specify the name/address and their related function, either by CO82 only and/or unstructured by CO58 or structured by CO80 thru 3207.

UNT M(1) : 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.

Message structure

UNH, Message header                           M        1
BGM, Beginning of message                     M        1
DTM, Date/time/period                         M        5

--- Segment Group 1 ------------------------- M        5 -------+
NAD, Name and address                         M        1        |
                                                                |
--- Segment Group 2 ------------------------- C        5 ------+|
CTA, Contact information                      M        1       ||
COM, Communication contact                    C        5       ||
---- ----------------------------------------------------------++

--- Segment Group 3 ------------------------- C        5 -------+
RFF, Reference                                M        1        |
DTM, Date/time/period                         C        5        |
---- -----------------------------------------------------------+

--- Segment Group 4 ------------------------- C        5 -------+
CUX, Currencies                               M        1        |
DTM, Date/time/period                         C        5        |
---- -----------------------------------------------------------+

--- Segment Group 5 ------------------------- M   200000 -------+
LOC, Place/location identification            M        1        |
DTM, Date/time/period                         C        5        |
                                                                |
--- Segment Group 6 ------------------------- C       99 ------+|
RFF, Reference                                M        1       ||
DTM, Date/time/period                         C        5       ||
---- ----------------------------------------------------------+|
                                                                |
--- Segment Group 7 ------------------------- C   200000 ------+|
LIN, Line item                                M        1       ||
PIA, Additional product id                    C        5       ||
IMD, Item description                         C        5       ||
PAC, Package                                  C        5       ||
RFF, Reference                                C        5       ||
DOC, Document/message details                 C        5       ||
ALI, Additional information                   C        5       ||
MOA, Monetary amount                          C        5       ||
PRI, Price details                            C        5       ||
GIN, Goods identity number                    C     9999       ||
                                                               ||
--- Segment Group 8 ------------------------- C      999 -----+||
QTY, Quantity                                 M        1      |||
MKS, Market/sales channel information         C        1      |||
NAD, Name and address                         C        1      |||
---- ---------------------------------------------------------+++
UNT, Message trailer                          M        1