SLSRPT Sales data report
TBG1 Supply Chain
A message to enable the conveyance of product activity related to the sale of products or services, such as the activity location, date, time or period, quantity, pricing, monetary amount, market sector, involved parties and other data enabling various sales analysis processes. Such activity information allows the recipient to perform statistical and quantitative analysis in support of production, planning, marketing, replenishment, and other processes.
Header
- 00010Message headerMandatoryMax 1
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 18A 0051 UN
1. Data element S009/0057 is retained for upward compatibility. The use ofS016 and/or S017 is encouraged in preference.2. The combination of the values carried in data elements 0062 and S009 shallbe used to identify uniquely the message within its group (if used) or ifnot used, within its interchange, for the purpose of acknowledgement. - 00020Beginning of messageMandatoryMax 1
A segment by which the sender must uniquely identify the sales data report by means of its type and number.
- 00030Date/time/periodMandatoryMax 5
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.
- 00040Market/sales channel informationConditionalMax 1
To identify market and sales channel details for products and services information.
- Segment group 1Repeat 9
- 00060ReferenceMandatoryMax 1
A segment identifying the reference by its number and where appropriate a line number within the document.
- 00070Date/time/periodConditionalMax 9
A segment specifying the date/time related to the reference.
- 00060ReferenceMandatoryMax 1
- Segment group 2Repeat 5
- 00090Name and addressMandatoryMax 1
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.
- Segment group 3Repeat 5
- 00110Contact informationMandatoryMax 1
A segment to identify a person or department, and their function, to whom communications should be directed.
- 00120Communication contactConditionalMax 5
A segment to identify a communications type and number for the contact specified in the CTA segment.
- 00110Contact informationMandatoryMax 1
- Segment group 4Repeat 9
- 00140ReferenceMandatoryMax 1
A segment identifying the reference by its number and where appropriate a line number within the document.
- 00150Date/time/periodConditionalMax 9
A segment specifying the date/time related to the reference.
- 00140ReferenceMandatoryMax 1
- 00090Name and addressMandatoryMax 1
- Segment group 5Repeat 5
- 00170CurrenciesMandatoryMax 1
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.
- 00180Date/time/periodConditionalMax 5
A segment specifying the date/time/period related to the rate of exchange.
- 00190StatusConditionalMax 5
A segment giving a status for the range of exchange, e.g. if the exchange rate is preliminary or accurate.
- 00170CurrenciesMandatoryMax 1
Detail
- Segment group 6Repeat 200000
- 00210Place/location identificationMandatoryMax 1
A segment to identify the activity, e.g. sales, the quantity of the activity, and other data related to the specific activity such as buying party, selling price, date sold, etc.
- 00220Date/time/periodConditionalMax 5
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.
- 00230Free textConditionalMax 5
A segment with free text information, in coded or clear form, used when additional information is needed but cannot be accommodated within other segments. In computer to computer exchanges such text will normally require the receiver to process this segment manually.
- Segment group 7Repeat 99
- 00250ReferenceMandatoryMax 1
To specify a reference.
- 00260Date/time/periodConditionalMax 5
To specify date, and/or time, or period.
- 00250ReferenceMandatoryMax 1
- Segment group 8Repeat 200000
- 00280Line itemMandatoryMax 1
A segment identifying the line item by the line number and configuration level. In addition it may identify the product or service to which the activity, e.g sales is applicable.
- 00290Additional product idConditionalMax 5
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.
- 00300Item descriptionConditionalMax 5
A segment for describing the product in the line item.
- 00310Date/time/periodConditionalMax 9
A segment specifying the date/time related to the sale of the product specified in the LIN segment.
- 00320PackageConditionalMax 5
A segment specifying the number and type of packages.
- 00330ReferenceConditionalMax 5
A segment for referencing documents or other numbers pertinent to the line item.
- 00340Document/message detailsConditionalMax 5
A segment identifying and providing information relating to documents.
- 00350Additional informationConditionalMax 5
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.
- 00360Monetary amountConditionalMax 5
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.
- 00370Goods identity numberConditionalMax 9999
A segment to specify identity numbers related to units of the product identified in the LIN segment, e.g. serial number.
- Segment group 9Repeat 999
- 00390Price detailsMandatoryMax 1
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.
- 00400CurrenciesConditionalMax 1
A segment identifying the currencies and rate of exchange for each line item.
- 00390Price detailsMandatoryMax 1
- 00410Payment instructionsConditionalMax 9
A segment to report the means of payment for the current product (e.g. cash payment).
- Segment group 10Repeat 999
- 00430QuantityMandatoryMax 1
A segment identifying the quantity and activity, e.g. quantity sold.
- 00440Market/sales channel informationConditionalMax 1
To identify market and sales channel details for products and services information.
- 00450Name and addressConditionalMax 1
To specify the name and address of a party related to the specific activity quantity identified in the previous QTY segment, e.g. the party the product(s) were sold to.
- 00460Price detailsConditionalMax 9
A segment specifying the price type and amount associated with the activity quantity.
- 00470Date/time/periodConditionalMax 9
A segment identifying the date/time or period during which the activity quantity occurred if different than the date/time or period specified in either the header section or segment group 5.
- 00480ReferenceConditionalMax 9
A segment to specify reference numbers associated with the activity quantity.
- 00490StatusConditionalMax 9
A segment giving a status for the quantity, e.g. metered, estimated or corrected.
- 00430QuantityMandatoryMax 1
- 00280Line itemMandatoryMax 1
- 00210Place/location identificationMandatoryMax 1
- Segment group 11Repeat 1
- 00510Processing informationMandatoryMax 1
This segment is used to initiate reporting by line item.
- Segment group 12Repeat 999999
- 00530Line itemMandatoryMax 1
A segment identifying the line item by the line number and configuration level, and additionally identifying the product or service for which activity data is being reported.
- 00540Additional product idConditionalMax 99
A segment providing additional or alternate product identification, e.g. product group, identified in the LIN segment.
- 00550Item descriptionConditionalMax 9
A segment used to provide the item description for the item identified in the LIN or PIA segments.
- 00560PackageConditionalMax 9
A segment specifying the number and type of packages.
- 00570Monetary amountConditionalMax 9
A segment used to specify monetary amounts applicable to the line item, e.g. total sales.
- Segment group 13Repeat 9999
- 00590Place/location identificationMandatoryMax 1
A segment indicating in coded form the location to which the sales data being reported apply, e.g. a retail outlet, a geographic area.
- 00600ReferenceConditionalMax 9
A segment to specify reference numbers associated with the location.
- 00610Date/time/periodConditionalMax 9
A segment identifying the date, time or period during which all the activity quantities occurred for the location if different than the date, time or period specified in the header section.
- 00620Monetary amountConditionalMax 9
A segment used to specify monetary amounts applicable to the location, e.g. total sales.
- Segment group 14Repeat 99
- 00640QuantityMandatoryMax 1
A segment identifying the quantity and activity, e.g. quantity sold.
- 00650Price detailsConditionalMax 9
A segment specifying the price type and amount associated with the quantity.
- 00660Date/time/periodConditionalMax 9
A segment identifying the date, time or period during which the activity quantity occurred if different than the date, time or period specified in either the header section or segment group 5.
- 00670ReferenceConditionalMax 9
A segment to specify reference numbers associated with the activity quantity.
- 00680StatusConditionalMax 9
A segment giving a status for the quantity, e.g. metered, estimated or corrected.
- 00640QuantityMandatoryMax 1
- 00590Place/location identificationMandatoryMax 1
- 00530Line itemMandatoryMax 1
- 00510Processing informationMandatoryMax 1
- 00690Section controlMandatoryMax 1
A service segment placed at the start of the summary section to avoid segment collision.
- 00700Monetary amountConditionalMax 9
A segment to specify monetary amounts relevant to the whole message, such as the goods and services tax amounts.
- 00710Message trailerMandatoryMax 1
A service segment ending a message, giving the total number of segments in the message (including the UNH & UNT) and the control reference number of the message.
1. 0062, the value shall be identical to the value in 0062 in thecorresponding UNH segment.