Query report (TJQ)

Introduction

This service provides Travel Agents the ability to get the Query Report from Host. It returns a list of all documents that were issued, voided, refunded on during specified date range. The report includes the total fare, taxes, fees and commission.

ReportQueryRQ Webservice

To get the report NDC agent should pass its credentials which contain Agent name, password, OiD, report query parameters. The system validates the parameters and replies with a report. If the query is not valid Agent receives an error.

This web service is called with the following inputs:

Office Id "<OID number>" - Get the report on all the transactions made in the selected OiD.
Date range - Get the report on all the transactions issued on a specific date or date range
Currency "USD" - Get the report on all the transactions issued the specified currency. Means that in the report will be displayed transactions issued in the specified currency.
Currency "Not selected" - Get the report on all the transactions issued in the default OID currency.

The output data this service returns in HEX format and include:

1) a Header containing the requesting details:

OFFICE - Amadeus office identification
AGY NO - agency IATA number
AGENT - agents sign
CURRENCY - report currency
QUERY REPORT - date range
SELECTION - Selected option
airline code
sales report number
sales report date

2) the list of transactions containing each one, the following information:

SSEQ NO - sequence number
A/L - three-digit airline code
DOC NUMBER - ten-digit document number.
TOTAL DOC - the total value for the item including tax.
TAX- the value of the tax total for the item.
FEE - the value of the airline ticketing fees, if applicable
COMM - the value of the commission amount for the item
FP- a form of payment
PAX NAME - passenger name only displayed on a 79-character display.
AS - the sign of the issuing agent
RLOC - pnr record locator.
TRNC - transaction code. for a list of transaction codes

ReportQueryRQ

Envelope xmlns="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://www.iata.org/IATA/EDIST/2017.1 OrderRetrieveRQ.xsd">
    <Body>
        <ReportQueryRQ Version="17.1" PrimaryLangID="EN" xmlns="http://www.iata.org/IATA/EDIST/2017.1">
            <Document>
                <Name>PS</Name>
            </Document>
            <Party>
                <Sender>
                    <TravelAgencySender>
                        <Name>Agent</Name>
                        <PseudoCity>IEVPS28ND</PseudoCity>
                        <AgencyID>PB123</AgencyID>
                    </TravelAgencySender>
                </Sender>
            </Party>
            <Query>
                <Filters>
                    <DateFrom>2020-08-07</DateFrom>
                    <DateTo>2020-08-07</DateTo>
                    <CurrencyCode>UAH</CurrencyCode>
                </Filters>
            </Query>
        </ReportQueryRQ>
    </Body>
</Envelope>

ReportQuery Error/Validation Checks

Click here to expand...

PADIS Error Code	PADIS Error Text	Cases
System errors
911	Unable to process - system error / Invalid query	Invalid query
486	Unknown	The equivalent of -1 error
304	System Temporarily unavailable	The system is not available/HOST problem
916	EDIFACT version not supported	Not supported NDC service version.
Agent authorization errors
368	Not authorized	Wrong agent authentication key. Agent is inactive
79A	Invalid office identification	OID is missing or incorrect
Query errors
6466	No data found	No records on the requested dates