D18A
Message D18A/SLSFCT
Sales forecast message
A message to enable the transmission of forecast 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 headerA service segment starting and uniquely identifying a message. The message type code for the Sales forecast message is SLSFCT. Note: Sales forecast messages conforming to this document must contain the following data in segment UNH, composite S009: Data element 0065 SLSFCT 0052 D 0054 18A 0051 UN
BGM
M(1) : Beginning of messageA segment by which the sender must uniquely identify the sales forecast by means of its type and number.
DTM
M(5) : Date/time/periodA segment specifying general dates and, when relevant, times related to the whole message. The sales forecast report preparation date and the forecast 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 addressA segment identifying names and addresses of the parties, in coded or clear form, and their functions relevant to the Sales Forecast Message. Identification of the sender of the report and the recipient is mandatory for the Sales Forecast 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 sales forecast 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 informationA segment to identify a person or department, and their function, to whom communications should be directed.
COM
C(5) : Communication contactA 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) : ReferenceA segment identifying the reference by its number and, where appropriate, a line number within the document.
DTM
C(5) : Date/time/periodA 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 forecast message. Segment Group 4 may be omitted in national applications but will be required for international exchanges.
CUX
M(1) : CurrenciesA segment identifying the currencies specified in the sales forecast message, e.g. the currency in which the forecast amounts or product prices are expressed. A rate of exchange may be given to convert a reference currency into a target currency.
DTM
C(5) : Date/time/periodA segment specifying the date/time/period related to the rate of exchange.
SG5 M(200000) : LOC-DTM-SG6
A group of segments providing details of the location for which forecasted sales are being reported and the period or sub-period during which the sales will take place. There must be at least one occurrence of Segment group 5 within a sales forecast message.
LOC
M(1) : Place/location identificationA segment indicating in coded form the location to which the forecast data being reported apply, e.g. a retail outlet, a geographic area.
DTM
C(5) : Date/time/periodA segment identifying the sub-period during which the forecast sales being reported will occur if different from the period specified in the heading section. e.g. within a biweekly sales forecast message as specified in the heading section, sales forecasts are reported in sub-periods of one week.
SG6 C(200000) : LIN-PIA-IMD-PAC-RFF-DOC-ALI-MOA-PRI-SG7
A group of segments providing details per location and period of the individual products to be sold in terms of product family or group, planned promotional flags, total forecast sale monetary amount and planned sale price.
LIN
M(1) : Line itemA segment identifying the line item by the line number and configuration level, and additionally identifying the product or service to be sold.
PIA
C(5) : Additional product idA segment providing either additional identification to the product specified in the LIN segment or providing any substitute product identification. In the Sales Forecast Message 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 descriptionA segment for describing the product in the line item.
PAC
C(5) : PackageA segment specifying the number and type of packages.
RFF
C(5) : ReferenceA segment for referencing documents or other numbers pertinent to the line item.
DOC
C(5) : Document/message detailsA segment identifying and providing information relating to documents.
ALI
C(5) : Additional informationA segment indicating that the line item is subject to special conditions owing to origin, customs preference, embargo regulations or commercial factors. In the Sales Forecast Message the ALI segment can be used to specify planned promotions, e.g. to indicate what type of promotion if any will be in effect when the product specified in LIN is to be sold.
MOA
C(5) : Monetary amountA segment specifying any monetary amounts relating to the product. For the sales forecast message the MOA segment can be used to express the forecast total monetary amount of the product to be sold, held, distributed, produced in one location for one period.
PRI
C(5) : Price detailsA segment to specify the price type and amount. The price used in the calculation of the forecast total sales monetary amount will normally be the average forecast selling price.
SG7 C(999) : QTY-MKS-NAD
A group of segments identifying the quantity to be sold and if relevant through which market sector, sales distribution channel, end-use type, etc.
QTY
M(1) : QuantityA segment identifying the product quantity, i.e. forecast quantity sold, held, produced, distributed.
MKS
C(1) : Market/sales channel informationA segment to specify to which market sector and/or through which distribution channel and/or for which end-use the forecast sales of product/service are to be made.
NAD
C(1) : Name and addressA segment identifying the name and address of a party being the recipient of a proportion of the forecast quantity.
UNT
M(1) : Message trailerA 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.
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 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 || || --- Segment Group 7 ------------------------- C 999 -----+|| QTY, Quantity M 1 ||| MKS, Market/sales channel information C 1 ||| NAD, Name and address C 1 ||| ---- ---------------------------------------------------------+++ UNT, Message trailer M 1