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 headerA 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 messageA segment to indicate the type and function of the message.
DTM
M(2) : Date/time/periodA segment to indicate processing dates and times.
NAD
M(1) : Name and addressA 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) : CurrenciesA segment to specify the currency for the total amount.
EQN
M(1) : Number of unitsA segment to specify the number of agents reporting transactions for the specified currency.
MOA
M(6) : Monetary amountA 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/periodA segment to indicate BSP reporting dates.
GEI
C(1) : Processing informationA 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) : CurrenciesA segment to specify the currency for the total amount.
EQN
M(1) : Number of unitsA segment to specify the number of agents reporting transactions for the specified currency.
MOA
M(6) : Monetary amountA segment to indicate the transaction totals for the specified currency.
QVR
C(1) : Quantity variancesA 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) : ReferenceA segment identifying the reporting agent.
LOC
C(1) : Place/location identificationA segment to identify the locale of the agent.
DTM
C(1) : Date/time/periodA segment to indicate the BSP remittance period ending date.
FTX
C(9) : Free textA 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) : CurrenciesA segment to specify the currency for the total amounts.
MOA
M(9) : Monetary amountA segment to indicate the transaction totals for the specified currency.
QVR
C(1) : Quantity variancesA 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 functionA 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) : CurrenciesA segment to specify the currency for the total amounts.
MOA
M(9) : Monetary amountA segment to indicate the transaction type totals for the specified currency.
QVR
C(1) : Quantity variancesA 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 itemA segment to specify the transaction.
DTM
C(1) : Date/time/periodA segment to indicate the date of issue of the transaction.
RFF
C(9) : ReferenceA segment identifying the reference numbers relating to a transaction.
NAD
C(9) : Name and addressA segment identifying the agent and passenger involved in the transaction.
LOC
C(1) : Place/location identificationA segment to identify the location where the transaction took place.
CUX
C(1) : CurrenciesA segment to indicate the currency relating to the transaction.
GEI
C(2) : Processing informationA segment to specify indicators relating to the processing of the transaction.
IMD
C(9) : Item descriptionA segment to specify the type of transaction, in coded form.
MOA
C(9) : Monetary amountA segment to indicate transaction monetary amounts.
ALC
C(9) : Allowance or chargeA segment to indicate the charge.
FTX
C(99) : Free textA segment to specify free text information relating to the transaction.
TAX
C(999) : Duty/tax/fee detailsA 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 detailsA segment to specify the ticket number.
DTM
M(1) : Date/time/periodA segment to indicate the date of issue of a refunded ticket.
FTX
C(1) : Free textA segment to specify free text information relating to the ticket.
PIA
C(1) : Additional product idA segment to specify the substituted ticket number.
SEQ
C(1) : Sequence detailsA 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 termsA segment to specify the terms of payment.
MOA
C(9) : Monetary amountA segment to indicate the monetary amounts associated with the terms of payment.
RFF
C(9) : ReferenceA segment identifying references relating to the terms of payment.
DTM
C(2) : Date/time/periodA segment to indicate the dates associated with the terms of payment.
AGR
C(1) : Agreement identificationA segment to specify the agreement details.
GEI
C(2) : Processing informationA segment to indicate payment processing codes.
NAD
C(1) : Name and addressA segment identifying the client.
FTX
C(9) : Free textA segment to specify optional free text information.
IMD
C(2) : Item descriptionA 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 numbersA segment to specify the related document number.
IMD
C(2) : Item descriptionA segment to specify the type of related document.
GIN
C(2) : Goods identity numberA 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 detailsA segment to specify the coupon delivery sequence.
FTX
C(99) : Free textA segment to specify print and service provider information in free text format.
ALC
C(1) : Allowance or chargeA segment to indicate the coupon charge.
GIN
C(1) : Goods identity numberA segment to specify coupon stock control numbers.
RFF
C(2) : ReferenceA segment to specify a frequent flyer number.
IMD
C(9) : Item descriptionA segment to specify services and products relating to the coupon or flight details.
NAD
C(1) : Name and addressA segment identifying the party to be billed.
TDT
C(1) : Transport informationA segment identifying the carrier and flight number.
DTM
C(9) : Date/time/periodA segment to indicate flight departure dates and times, and, coupon validity dates.
LOC
C(9) : Place/location identificationA segment to specify airports of departure and arrival and to indicate transit stops.
CNT
M(1) : Control totalA segment to specify the total number of transactions per agent.
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 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