Message handbook for EDIEL
Implementation guide for the Sales data report message 19
Message handbook
for
EDIEL
Implementation guide for
Sales data report message
EDIFACT-message: Extended SLSRPT
EDIFACT-version: D
EDIFACT-release: 96A
EDIFACT-status: 1
IG-status: Under development -
not for implementation
IG-version: 0.991
IG-date: 03. April 1998
C O N T E N T
1. Introduction 3
1.1. Overview of messages in the power industry 4
2. General description of the «Sales data report message» 5
2.1. Sales data report message 5
2.2. Functional Definition 5
2.3. Principles 6
3. References 7
3.1. Precedence 7
4. Quality assurance 8
4.1. Version number 8
4.2. Corrections from earlier versions 8
5. Overview of the message 10
5.1. Data model for Sales data report message 10
5.2. Cue list 11
5.3. Message diagram 13
5.4. Segment table 14
5.5. Description of segments used 16
6. Detailed description of the message 19
Appendix - Example of an EDIFACT Message 41
Introduction
This document is an Implementation Guide (IG) for the Sales data report message, to be used in the power industry. The IG describes the «expanded» EDIFACT-message SLSRPT in detail. The message is used for information about prises in the power industry.
Note: This SLSRPT (Sales data report message) is expanded in proportion to the standard EDIFACT message SLSRPT with several new segments to achieve the needs for the power industry.
This IG is a part of the "Message handbook for EDIEL", which contains a set of IG’s for different messages used in the power industry and a functional description, which contains common descriptions for the different IG’s. In the future several new IG’s are planned.
The document is written by Posten SDS, Norway, on behalf of EDIEL Nordic Forum, which is an organisation with members from the following organisations:
· Nord Pool ASA, Nordic Power Exchange
· Svenska Kraftnät, Sweden
· Sydkraft, Sweden
· Statnett SF, Norway
· Viken Energinett AS, Norway
· ELTRA, Denmark
· ELKRAFT, Denmark
· Imatran Voima Oy, Finland
· PVO-Group, Finland
· Fingrid, Finland
The EDIEL organisation will work for standardisation of EDI-messages, communication, security etc. in the power industry, basically in the Nordic countries.
EDIEL is responsible for the documentation and further maintenance. This covers the following:
· Produce documentation of good quality
· Have knowledge about the parties using the documentation.
· Provide necessary support and help to the users of the documentation, so the documentation can be used in a correct way.
· Maintain the documentation as EDIFACT develops and in response to user-requests.
The documentation is primarily written for people who are going to implement EDIFACT in applications and EDI-software.
Overview of messages in the power industry
For the time being the Message handbook for EDIEL consists of
DELFOR Delivery schedule message
MSCONS Metered Service Consumption Report
QUOTES Quote message
SLSRPT Sales data report message
APERAK Application Acknowledgement
At a later stage other messages will also be developed for use between parties in the power industry.
In addition a Functional description is available, which contains common descriptions for the different Implementation Guides. This includes relations between the different message types, use of codes and code lists, special conditions between the countries (such as use of time zones), terms and notation, use of header and trailer segments (UNB and UNZ), use of the CONTRL message etc.
General description of the «Sales data report message»
Sales data report message
The message type used for the Sales data report message is based upon the EDIFACT message SLSRPT. The EDIFACT standard message is expanded to achieve the needs for the power industry:
· MKS, SG. 0 New segment
· SG. 4 Extended from 5 to 99 repetitions
· FTX, SG. 5 New segment
· PRI, SG. 7 Removed
· SG. 8 New segment group
· PRI, SG. 8 New segment
· CUX, SG. 8 New segment
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.
In the power industry the Sales data report message is used for price information from the Power Exchange and the System Operators.
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 System Operator or from the Power Exchange to participants in the power industry. 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 parties identification.
The information is transferred as:
· General information including dates, periods and currencies.
· Description of price area, contracts etc.
· Time period, quantity and price for each market.
· Information about the turnover, totally and for each party.
References
This Implementation guide is based on the following documents.
[1] Norsk veiledning i bruk av EDIFACT, version 2.0, November 1991 with addition of January 1994.
[2] UN/EDIFACT Draft directory, D.96A
[3] Message handbook for EDIEL, Functional description, version 2.1
[4] ISO 9735, version 2, 1990.11.01
Precedence
If there should be any conflict regarding this Implementation guide or between this Implementation guide and other documents, the following precedence shall be used:
1 UN/EDIFACT Draft directory, D.96A [2]
2 The Functional description [3]
3 This Implementation guide.
In this Implementation guide the EDIFACT message type is described in different ways. If there should be any conflict regarding the different descriptions, the detailed description in the last chapter should be used.
Quality assurance
This document is written by Posten SDS on behalf of EDIEL. Members of the EDIEL-organisation have taken part in the development through the work.
There will be a test period with a following revision before a final Implementation guide will be made available.
The present document has the following status:
· Under development – not for implementation
Version number
The Implementation Guide will have 3 levels of version numbering. This will be Version, Release and Correction:
· The Correction (last number) will be updated when there have been «cosmetic» changes, like correction of examples, adding some text etc.
· The Release number will be updated when there have been minor changes to the IG, like adding several new codes etc.
· The Version number (first number) will be updated when there have been major changes, like new segments, data elements etc.
Corrections from earlier versions
Version 0.96 of the SLSRPT was totally renewed, based on a new concept and a new data model.
Corrections from version 0.96:
· The MOA segment in segment group 7 is removed.
· The CUX segment is corrected (2. Repetition of data element 5402 is removed).
· Code Z03 is added to the PRI segment in segment group 8.
· Code Z05 is added to the QTY segment in segment group 9.
· The DTM segment in segment group 4 is changed to Dependent (D).
Corrections from version 0.97:
· The code “XEU” for “European Monetary Coop. Fund, (Euro)” is added to the CUX segments.
· The segment groups 8 and 9 are classified as “Required”.
Corrections from version 0.98:
· The codes in data element 1001, BGM is changed.
· The LOC segment is removed from SG 9. Bidding areas is moved to LOC, SG 5.
· The RFF segment in SG 9 is moved to SG 7.
Corrections from version 0.99:
· Segment group 9 is corrected from 99 to 1 repetition.
Overview of the message
Data model for Sales data report message
Below is shown a data model for the Sales data report message:
Figure 1 Data model for the Sales data report message
The attributes in parentheses are conditional attributes and are not necessarily transferred.
Cue list
Below is a table describing the EDIFACT message and the relation to the attributes in the data model.
General information about the messageUNH / M / 1 / Message reference
Message type
BGM / M / 1 / Message name
Message Id.
Message function
Request for acknowledgement
DTM / M / 5 / Message date
Reporting period
Time zone
(Correction time)
MKS / R / 1 / Sales channel (Market type)
Parties
SG 1 / M / 4
NAD / M / 1 / Message from
Document recipient
(In care of party 1)
(In care of party 2)
Contact person
SG 2 / O / 1
CTA / M / 1 / (Contact person)
References
SG 3 / O / 2
RFF / M / 1 / (Reference to earlier sent message)
(Agreement Id.)
Currencies
SG 4 / D / 99
CUX / M / 1 / Currencies
Rate of exchange
DTM / D / 1 / Date/time related to the rate of exchange.
Serial Id., Area and Time
SG 5 / M / 200000
LOC / M / 1 / Area or Serial Id.
(Company 1)
(Area 1)
(Company 2)
(Area 2)
DTM / R / 3 / Time period (hour or part of hour)
Total report period (day or week summary)
Number of hours for the Area
FTX / D / 1 / Description of Area
Amount and Area
SG 7 / R / 1
LIN / M / 1 / Line no. (sequence)
Product
RFF / O / 1 / (Reference to Quotation)
Prices and Currencies
SG 8 / D / 99
PRI / M / 1 / Prices
CUX / D / 1 / Currencies
Quantity
SG 9 / D / 1
QTY / M / 1 / Quantity
Measure unit
Message trailer
UNT / M / 1 / Message trailer
At least the segment groups (with corresponding segments) marked with R or M have to be used in every message.
Message diagram
The Message diagram below shows the subset of the EDIFACT message that is used in this IG. All segments and segment groups are shown according to the classification in this subset. For a complete overview over the EDIFACT message, please see the next chapter (segment table).
Note: The message type used for the Sales data report message is based upon the EDIFACT message SLSRPT. The EDIFACT standard message is expanded to achieve the needs for the power industry:
· MKS, SG. 0 New segment
· SG. 4 Extended from 5 to 99 repetitions
· FTX, SG. 5 New segment
· PRI, SG. 7 Removed
· SG. 8 New segment group
· PRI, SG. 8 New segment
· CUX, SG. 8 New segment
Figure 2 Message diagram for the Sales data report message
Segment table
In this chapter the segment table for the Sales data report message (SLSRPT) is shown by the way it is described in version D, release 96A of the EDIFACT directory with exemption of the expansion mentioned below. The segments and segment groups that are used in this IG are shown with bold letters.
Note: The message type used for the Sales data report message is based upon the EDIFACT message SLSRPT. The EDIFACT standard message is expanded to achieve the needs for the power industry:
· MKS, SG. 0 New segment
· SG. 4 Extended from 5 to 99 repetitions
· FTX, SG. 5 New segment
· PRI, SG. 7 Removed
· SG. 8 New segment group
· PRI, SG. 8 New segment
· CUX, SG. 8 New segment
HEADER SECTION
UNH Message header M 1
BGM Beginning of message M 1
DTM Date/time/period M 5
MKS Market/sales channel information C 1
------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 99 ------+
CUX Currencies M 1 ¦
DTM Date/time/period C 5 ------+
DETAIL SECTION
------Segment group 5 ------M 200000------+
LOC Place/location identification M 1 ¦
DTM Date/time/period C 5 ¦
FTX Free text 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 ----+¦¦
PRI Price details M 1 ¦¦¦
CUX Currencies C 1 ----+¦¦
¦¦
------Segment group 9 ------C 999 ----+¦¦
QTY Quantity M 1 ¦¦¦
MKS Market/sales channel information C 1 ¦¦¦
NAD Name and address C 1 ------+
SUMMARY SECTION
UNT Message trailer M 1
Description of segments used
Below the segments and segment groups used in this IG are described. The description is copied from version D, release 96A of the UN/EDIFACT directory with exemption of the expansion mentioned below. The way EDIEL uses the segments is described in the next chapter.
Note: The message type used for the Sales data report message is based upon the EDIFACT message SLSRPT. The EDIFACT standard message is expanded to achieve the needs for the power industry:
· MKS, SG. 0 New segment
· SG. 4 Extended from 5 to 99 repetitions
· FTX, SG. 5 New segment
· PRI, SG. 7 Removed
· SG. 8 New segment group
· PRI, SG. 8 New segment
· CUX, SG. 8 New segment