D18A

Message D18A/STLRPT

Settlement transaction reporting message

A Settlement transaction reporting message is exchanged between participants in the Billing and Settlement Plan (BSP) to report transaction data for processing and account settlement purposes. BSP participants include airlines, agents, Computer Reservations Systems (CRS) and the BSP Centre.

Message description

UNH

M(1) : Message header

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

BGM

M(1) : Beginning of message

A segment to indicate the type and function of the message.

DTM

M(2) : Date/time/period

A segment to indicate processing dates and times.

NAD

M(1) : Name and address

A segment identifying either the reporting agent or the BSP.

SG1 C(999) : CUX-EQN-MOA

A group of segments occurring in the BSP-to-airline functional message to specify transaction totals of all agents by specified currency.

CUX

M(1) : Currencies

A segment to specify the currency for the total amount.

EQN

M(1) : Number of units

A segment to specify the number of agents reporting transactions for the specified currency.

MOA

M(6) : Monetary amount

A segment to indicate the transaction totals for the specified currency.

SG2 M(9) : DTM-GEI-SG3-SG4

A group of segments to specify either the transactions for the reporting period in the CRS-to-BSPC functional message, or the billing analysis transactions and totals in the BSPC-to-airline functional message.

DTM

M(1) : Date/time/period

A segment to indicate BSP reporting dates.

GEI

C(1) : Processing information

A segment to specify indicators relating to the BSP processing of the transactions.

SG3 C(999) : CUX-EQN-MOA-QVR

A group of segments occurring in the BSP-to-airline functional message to specify the transactions totals for all agents by specified currency for a billing analysis period.

CUX

M(1) : Currencies

A segment to specify the currency for the total amount.

EQN

M(1) : Number of units

A segment to specify the number of agents reporting transactions for the specified currency.

MOA

M(6) : Monetary amount

A segment to indicate the transaction totals for the specified currency.

QVR

C(1) : Quantity variances

A segment to indicate monetary variances relating to BSP processing.

SG4 M(999999) : RFF-LOC-DTM-FTX-SG5-SG6-CNT

A group of segments to specify the transaction data for an agent.

RFF

M(1) : Reference

A segment identifying the reporting agent.

LOC

C(1) : Place/location identification

A segment to identify the locale of the agent.

DTM

C(1) : Date/time/period

A segment to indicate the BSP remittance period ending date.

FTX

C(9) : Free text

A segment to specify free text information relating to the agent transactions.

SG5 C(999) : CUX-MOA-QVR

A group of segments occurring in the BSP-to-airline functional message to specify transaction totals for the agent.

CUX

M(1) : Currencies

A segment to specify the currency for the total amounts.

MOA

M(9) : Monetary amount

A segment to indicate the transaction totals for the specified currency.

QVR

C(1) : Quantity variances

A segment to indicate monetary variances relating to BSP processing for the agent.

SG6 M(99) : BUS-SG7-SG8

A group of segments to specify transaction type data.

BUS

M(1) : Business function

A segment to specify the transaction type.

SG7 C(999) : CUX-MOA-QVR

A group of segments occurring in the BSP-to-airline functional message to specify transaction type totals of an agent by specified currency.

CUX

M(1) : Currencies

A segment to specify the currency for the total amounts.

MOA

M(9) : Monetary amount

A segment to indicate the transaction type totals for the specified currency.

QVR

C(1) : Quantity variances

A segment to indicate transaction type monetary variances relating to BSP processing for the agent.

SG8 M(99999) : LIN-DTM-RFF-NAD-LOC-CUX-GEI-IMD-MOA-ALC-

FTX-TAX-SG9-SG10-SG11 A group of segments to specify the transaction details.

LIN

M(1) : Line item

A segment to specify the transaction.

DTM

C(1) : Date/time/period

A segment to indicate the date of issue of the transaction.

RFF

C(9) : Reference

A segment identifying the reference numbers relating to a transaction.

NAD

C(9) : Name and address

A segment identifying the agent and passenger involved in the transaction.

LOC

C(1) : Place/location identification

A segment to identify the location where the transaction took place.

CUX

C(1) : Currencies

A segment to indicate the currency relating to the transaction.

GEI

C(2) : Processing information

A segment to specify indicators relating to the processing of the transaction.

IMD

C(9) : Item description

A segment to specify the type of transaction, in coded form.

MOA

C(9) : Monetary amount

A segment to indicate transaction monetary amounts.

ALC

C(9) : Allowance or charge

A segment to indicate the charge.

FTX

C(99) : Free text

A segment to specify free text information relating to the transaction.

TAX

C(999) : Duty/tax/fee details

A segment to specify tax and commission amounts.

SG9 C(99) : DOC-DTM-FTX-PIA-SEQ

A group of segments to specify the ticket details.

DOC

M(1) : Document/message details

A segment to specify the ticket number.

DTM

M(1) : Date/time/period

A segment to indicate the date of issue of a refunded ticket.

FTX

C(1) : Free text

A segment to specify free text information relating to the ticket.

PIA

C(1) : Additional product id

A segment to specify the substituted ticket number.

SEQ

C(1) : Sequence details

A segment to specify the product delivery sequence number.

SG10 C(9999) : PYT-MOA-RFF-DTM-AGR-GEI-NAD-FTX-IMD

A group of segments to specify the terms of payment details.

PYT

M(1) : Payment terms

A segment to specify the terms of payment.

MOA

C(9) : Monetary amount

A segment to indicate the monetary amounts associated with the terms of payment.

RFF

C(9) : Reference

A segment identifying references relating to the terms of payment.

DTM

C(2) : Date/time/period

A segment to indicate the dates associated with the terms of payment.

AGR

C(1) : Agreement identification

A segment to specify the agreement details.

GEI

C(2) : Processing information

A segment to indicate payment processing codes.

NAD

C(1) : Name and address

A segment identifying the client.

FTX

C(9) : Free text

A segment to specify optional free text information.

IMD

C(2) : Item description

A segment to specify the form of payment, in coded form.

SG11 C(999) : GIR-IMD-GIN-SG12

A group of segments to specify related document details.

GIR

M(1) : Related identification numbers

A segment to specify the related document number.

IMD

C(2) : Item description

A segment to specify the type of related document.

GIN

C(2) : Goods identity number

A segment to specify stock control numbers.

SG12 C(99) : SEQ-FTX-ALC-GIN-RFF-IMD-NAD-TDT-

DTM-LOC A group of segments to specify coupon information.

SEQ

M(1) : Sequence details

A segment to specify the coupon delivery sequence.

FTX

C(99) : Free text

A segment to specify print and service provider information in free text format.

ALC

C(1) : Allowance or charge

A segment to indicate the coupon charge.

GIN

C(1) : Goods identity number

A segment to specify coupon stock control numbers.

RFF

C(2) : Reference

A segment to specify a frequent flyer number.

IMD

C(9) : Item description

A segment to specify services and products relating to the coupon or flight details.

NAD

C(1) : Name and address

A segment identifying the party to be billed.

TDT

C(1) : Transport information

A segment identifying the carrier and flight number.

DTM

C(9) : Date/time/period

A segment to indicate flight departure dates and times, and, coupon validity dates.

LOC

C(9) : Place/location identification

A segment to specify airports of departure and arrival and to indicate transit stops.

CNT

M(1) : Control total

A segment to specify the total number of transactions per agent.

UNT

M(1) : Message trailer

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.

Message structure

UNH, Message header                           M        1
BGM, Beginning of message                     M        1
DTM, Date/time/period                         M        2
NAD, Name and address                         M        1

--- Segment Group 1 ------------------------- C      999 -------+
CUX, Currencies                               M        1        |
EQN, Number of units                          M        1        |
MOA, Monetary amount                          M        6        |
---- -----------------------------------------------------------+

--- Segment Group 2 ------------------------- M        9 -------+
DTM, Date/time/period                         M        1        |
GEI, Processing information                   C        1        |
                                                                |
--- Segment Group 3 ------------------------- C      999 ------+|
CUX, Currencies                               M        1       ||
EQN, Number of units                          M        1       ||
MOA, Monetary amount                          M        6       ||
QVR, Quantity variances                       C        1       ||
---- ----------------------------------------------------------+|
                                                                |
--- Segment Group 4 ------------------------- M   999999 ------+|
RFF, Reference                                M        1       ||
LOC, Place/location identification            C        1       ||
DTM, Date/time/period                         C        1       ||
FTX, Free text                                C        9       ||
                                                               ||
--- Segment Group 5 ------------------------- C      999 -----+||
CUX, Currencies                               M        1      |||
MOA, Monetary amount                          M        9      |||
QVR, Quantity variances                       C        1      |||
---- ---------------------------------------------------------+||
                                                               ||
--- Segment Group 6 ------------------------- M       99 -----+||
BUS, Business function                        M        1      |||
                                                              |||
--- Segment Group 7 ------------------------- C      999 ----+|||
CUX, Currencies                               M        1     ||||
MOA, Monetary amount                          M        9     ||||
QVR, Quantity variances                       C        1     ||||
---- --------------------------------------------------------+|||
                                                              |||
--- Segment Group 8 ------------------------- M    99999 ----+|||
LIN, Line item                                M        1     ||||
DTM, Date/time/period                         C        1     ||||
RFF, Reference                                C        9     ||||
NAD, Name and address                         C        9     ||||
LOC, Place/location identification            C        1     ||||
CUX, Currencies                               C        1     ||||
GEI, Processing information                   C        2     ||||
IMD, Item description                         C        9     ||||
MOA, Monetary amount                          C        9     ||||
ALC, Allowance or charge                      C        9     ||||
FTX, Free text                                C       99     ||||
TAX, Duty/tax/fee details                     C      999     ||||
                                                             ||||
--- Segment Group 9 ------------------------- C       99 ---+||||
DOC, Document/message details                 M        1    |||||
DTM, Date/time/period                         M        1    |||||
FTX, Free text                                C        1    |||||
PIA, Additional product id                    C        1    |||||
SEQ, Sequence details                         C        1    |||||
---- -------------------------------------------------------+||||
                                                             ||||
--- Segment Group 10 ------------------------ C     9999 ---+||||
PYT, Payment terms                            M        1    |||||
MOA, Monetary amount                          C        9    |||||
RFF, Reference                                C        9    |||||
DTM, Date/time/period                         C        2    |||||
AGR, Agreement identification                 C        1    |||||
GEI, Processing information                   C        2    |||||
NAD, Name and address                         C        1    |||||
FTX, Free text                                C        9    |||||
IMD, Item description                         C        2    |||||
---- -------------------------------------------------------+||||
                                                             ||||
--- Segment Group 11 ------------------------ C      999 ---+||||
GIR, Related identification numbers           M        1    |||||
IMD, Item description                         C        2    |||||
GIN, Goods identity number                    C        2    |||||
                                                            |||||
--- Segment Group 12 ------------------------ C       99 --+|||||
SEQ, Sequence details                         M        1   ||||||
FTX, Free text                                C       99   ||||||
ALC, Allowance or charge                      C        1   ||||||
GIN, Goods identity number                    C        1   ||||||
RFF, Reference                                C        2   ||||||
IMD, Item description                         C        9   ||||||
NAD, Name and address                         C        1   ||||||
TDT, Transport information                    C        1   ||||||
DTM, Date/time/period                         C        9   ||||||
LOC, Place/location identification            C        9   ||||||
---- ------------------------------------------------------++++||
CNT, Control total                            M        1       ||
---- ----------------------------------------------------------++
UNT, Message trailer                          M        1