Booking Agent Contracts by okb64521

VIEWS: 45 PAGES: 18

More Info
									Version 5.03                                          TravelMan Data Dictionary



     Field #           Field Name        Database Table    Alias    Field Type   Length                          Description
                                                                                          CALC $ is used within the TravelMan product to
     CAL1                CALC $              NONE          NONE       money               calculate dollar amount .i.e., amount saved.
                                                                                          CALC NUMBER is used within the TravelMan product
     CAL2            CALC NUMBER             NONE          NONE      Numeric       10     to calculate numbers, i.e., hotel days.
                                                                                          CALC DATE is used within the TravelMan product to
     CAL3              CALC DATE             NONE          NONE      Date Time            format a date field which is currently in an alpha format
                                                                                          CALC TEXT is used within the TravelMan product to
     CAL4              CALC TEXT             NONE          NONE       varchar      50     create text fields i.e., city pairs
                                                                                          CALC INTEGER is field is used within the TravelMan
     CAL5            CALC INTEGER            NONE          NONE       Integer      10     product to calculate whole number counts
                                                                                          CALC TIMESTAMP is used within the TravelMan
     CAL6           CALC TIMESTAMP           NONE          NONE      Date Time            product to calculate a date and time stamp in a field
                                                                                          currently entered as alpha letters.
     CALCARCOST         CarCost              NONE          NONE        money
     CALCARDAYS         CarDays              NONE          NONE       Numeric      5
     CALHTLCOST        HotelCost             NONE          NONE        money
     CALHTLNIGHTS    HotelRoomNights         NONE          NONE      Numeric       5


     CALMON         MonthNameTicket          NONE          NONE                    3
                                                                      varchar
     CALNOX         NOXSegmentValue          NONE          NONE       money


                                                                                          Car table Record key is a unique code assigned by the
                                                                                          system when the data is being imported. It is used to
                                                                                          link together various tables such as invoice header, to
     CAR001            RecordKey              Car          CAR        varchar      50     invoice detail, transseg, and hotel.
                                                                                          IATA number is the main IATA number for client which
     CAR002              IataNum              Car          CAR        varchar      8      is filled in at time of import into TravelMan
                                                                                          This sequence number links together the invoice detail
     CAR003              SeqNum               Car          CAR        SmallInt            records
                                                                                          Car sequence number is the field that represents the
                                                                                          car order in the itinerary. ie, the first car has a
                                                                                          carseqnum of 1, the second car in the itinerary would
                                                                                          have a carseqnum of 2.
     CAR004            CarSeqNum              Car          CAR        smallint
                                                                                          Client Code is the DK number or DK number plus
     CAR005             ClientCode            Car          CAR        varchar      15     Branch number depending on customer
                                                                                          Invoice date is the date the record was invoiced into the
     CAR006            InvoiceDate            Car          CAR       Date Time            back office.
                                                                                          Issue date is the date the record was issued (should be
     CAR007             IssueDate             Car          CAR       Date Time            equal to or prior to Invoice date)
                                                                                          Void Indicator is a 1 letter field marked with "Y" or "N".
     CAR008              VoidInd              Car          CAR        varchar       1     A void record will contain a "Y" code.
     CAR009          VoidReasonType           Car          CAR        varchar       3     Reason for voiding
     CAR010             Salutation            Car          CAR        varchar      10     MR,MRS,MS,MISS,MSTR,SR,FR etc
     CAR011             FirstName             Car          CAR        varchar      25     Passenger First Name
     CAR012             Lastname              Car          CAR        varchar      35     Passenger Last Name
     CAR013            MiddleInitial          Car          CAR        varchar       1     Passenger Middle Initial
     CAR014              CarType              Car          CAR        varchar       6     Car Type is the 4 letter car type ID ,i.e.,ICAR, FCAR
                                                                                          Car chain code is the 2 letter code that identifies the
     CAR015           CarChainCode            Car          CAR        varchar      6      rental car company, i.e., ZL, ZE
                                                                                          Car chain name is the standardized name of the rental
     CAR016           CarChainName            Car          CAR        varchar      20     car company, ie., National Car Rental.
                                                                                          Car city code is a 3 letter GDS code that identifies the
     CAR017            CarCityCode            Car          CAR        varchar      3      car pick up location
                                                                                          Car city name is the city name in full which corresponds
     CAR018           CarCityName             Car          CAR        varchar      25     to the GDS car city code.
                                                                                          Domestic/International indicator is a single letter of
     CAR019           InternationalInd        Car          CAR        varchar      1      either "D" or "I" which identifies the location of rental as
                                                                                          either Domestic theInternational. car is booked to be
                                                                                          Pick up date is or date the rental
     CAR020             PickupDate            Car          CAR       Date Time            picked up.
                                                                                          Drop off Date is the date the rental car is booked to be
     CAR021            DropoffDate            Car          CAR       Date Time            returned/dropped off
                                                                                          Car city code is a 3 letter GDS code that identifies the
     CAR022         CarDropoffCityCode        Car          CAR        varchar      3      car drop off location
                                                                                          Drop Off city derived from the drop off city code if blank
     CAR023          DropOffCityName          Car          CAR        varchar      50
                                                                                          Number of days are the number of days the car is
     CAR024             NumDays               Car          CAR             Int            rented for.
                                                                                          Number of cars rented should a single PNR reflect
     CAR025              NumCars              Car          CAR             Int            multiple rentals in one locations.




                                                                 1 of 18
Version 5.03                                    TravelMan Data Dictionary



     Field #      Field Name       Database Table    Alias    Field Type   Length                          Description
                                                                                    Car rate quoted is the dollar amount returned from the
                                                                                    vendor and found in the car segment (i.e. daily,
     CAR026     CarQuotedRate           Car          CAR        Money               weekly, monthly.)
                                                                                    Car quoted currency code is a 3 letter standard
     CAR027     QuotedCurrCode          Car          CAR        varchar      3      currency code. i.e. USD, CAD, DEM
                                                                                    Car daily rate is the rate calculated by TMAN product.
                                                                                    Quoted Rate/Number of car rental days if the rate
     CAR028      CarDailyRate           Car          CAR        Money               category is not Daily
                                                                                    Total car cost is the total amount of car booking.
     CAR029       TtlCarCost            Car          CAR         float              Number of cars x number of days x car daily rate
                                                                                    Car rate category which identifies the type of car rate
     CAR030       CarRateCat            Car          CAR        varchar      10     i.e. daily, weekly, weekend .
                                                                                    Car compare rate is the car rate stored by customer in
     CAR031    CarCompareRate1          Car          CAR         float              UDID field
                                                                                    Car reason Code is a specific reason code stored at
     CAR032    CarReasonCode1           Car          CAR        varchar      6      customers request.
                                                                                    Car compare rate 2 is the car rate stored by customer
     CAR033    CarCompareRate2          Car          CAR         float              in UDID field
                                                                                    Car reason Code 2 is a specific reason code stored at
     CAR034    CarReasonCode2           Car          CAR        varchar      6      customers request.
     CAR035     CarCommAmt              Car          CAR          float             Car commission from the back-office system
                                                                                    Car currency code is a 3 letter standard currency
                                                                                    code. i.e. USD, CAD, DEM that is converted from
     CAR036       CurrCode              Car          CAR        varchar      3      QuotedCurrCode
     CAR037       PrefCarInd            Car          CAR        varchar      1      Can be used for corporate contracts
                                                                                    Car confirmation number is the confirmation number is
                                                                                    returned from the car vendor in the car segment of the
     CAR038       CarConfNum            Car          CAR        varchar      30     PNR.
     CAR039    FreqRenterProgram        Car          CAR        varchar      13     Membership number i.e.. Avis Wizard
     CAR040        CarStatus            Car          CAR        varchar       2     HK, BK, HL, etc
                                                                                    Remark1 contains the Statement Information/Name
                                                                                    Field Remarks in the back-office. This field will contain
     CAR041        Remarks1             Car          CAR        varchar     100     SSN/MOC/RC.
                                                                                    Remark2 contains the Statement Information/Name
                                                                                    Field Remarks in the back-office. This field will contain
     CAR042        Remarks2             Car          CAR        varchar     100     SSN/MOC/RC.
                                                                                    Remark3 contains the Statement Information/Name
                                                                                    Field Remarks in the back-office. This field will contain
     CAR043        Remarks3             Car          CAR        varchar     100     SSN/MOC/RC.
                                                                                    Remark4 contains the Statement Information/Name
                                                                                    Field Remarks in the back-office. This field will contain
     CAR044        Remarks4             Car          CAR        varchar     100     SSN/MOC/RC.
                                                                                    Remark5 contains the Statement Information/Name
                                                                                    Field Remarks in the back-office. This field will contain
     CAR045        Remarks5             Car          CAR        varchar     100     SSN/MOC/RC.
     CAR046     CommTrackInd            Car          CAR        varchar      5      To be used with commission tracking programs
     CAR047    CarCommPostDate          Car          CAR       Date Time            Date commission posted
     CAR048       MatchedInd            Car          CAR        varchar      1      Used with credit card reconciliation
                                                                                    Additional field for use with credit card reconciliation.
     CAR049      MatchedFields          Car          CAR       varchar      255
     CAR050    GDSRecordLocator         Car          CAR       varchar      10      PNR unique identifier assigned by GDS
     CAR051     BookingAgentId          Car          CAR       varchar      10      Booking Agent number
     CITY001        CityCode            City         CITY      varchar       3      3 letter IATA defined city code
     CITY002       TypeCode             City         CITY      varchar       1      A for airport, R for rail, B for Bus
     CITY003        CityName            City         CITY      varchar      30      Defination of City Code
     CITY004      AirportName           City         CITY      varchar      30      Name of Airpport
     CITY005      RegionCode            City         CITY      varchar       3      3 letter IATA defined city code
     CITY006      RegionName            City         CITY      varchar      30      Used for grouping mulltiple codes in 1 city
     CITY007   StateProvinceCode        City         CITY      varchar       5      state or province code
     CITY008      CountryCode           City         CITY      varchar       5      2 letter ISO code
     CITY009         Latitude           City         CITY      Numeric       0      degree of latitude
     CITY010        Longitude           City         CITY      Numeric       0      degree of longitude
     CITY011      TimeZoneDiff          City         CITY      Numeric       0      time difference from GMT
                                                                                    Client Code is the DK number or DK number plus
     CL001        ClientCode           Client         CL        varchar      15     Branch number depending on customer
                                                                                    IATA number is the main IATA number for client which
     CL002         IataNum             Client         CL        varchar       8     is filled in at time of extract from back office
     CL003        CustName             Client         CL        varchar      40     Customer Name as it is listed in Back Office
     CL004        CustAddr1            Client         CL        varchar      40     Customer Address1 in Back office
     CL005        CustAddr2            Client         CL        varchar      40     Customer Address2 in Back office
     CL006        CustAddr3            Client         CL        varchar      40     Customer Address3 in Back office
     CL007            City             Client         CL        varchar      25     City for the Customer Address in Back office
     CL008           State             Client         CL        varchar      20     State for the Customer Address in Back office




                                                           2 of 18
Version 5.03                                    TravelMan Data Dictionary



     Field #     Field Name        Database Table    Alias    Field Type   Length                         Description
     CL009            Zip              Client         CL        varchar      10     ZIP code for the Customer Address in Back office
                                                                                    Customer phone for the Customer Address in Back
     CL010        CustPhone            Client         CL        varchar      20     office
                                                                                    Country code for the Customer Address in Back office
     CL011       CountryCode           Client         CL        varchar      2
                                                                                    Attention line for the Customer Address in Back Office
     CL012         AttnLine            Client         CL        varchar      40
     CL013          Email              Client         CL        varchar      80     Email address of contact
     CL014     ConsolidationCode       Client         CL        varchar      10     Code used to consolidate accounts

     CL015      ClientRemark1          Client         CL        varchar     255     User Defined. Additional client information.
     CL016      ClientRemark2          Client         CL        varchar     255     User Defined. Additional client information.
     CL017      ClientRemark3          Client         CL        varchar     255     User Defined. Additional client information.
     CL018      ClientRemark4          Client         CL        varchar     255     User Defined. Additional client information.
     CL019      ClientRemark5          Client         CL        varchar     255     User Defined. Additional client information.
     CL020      ClientRemark6          Client         CL        varchar     255     User Defined. Additional client information.
     CL021      ClientRemark7          Client         CL        varchar     255     User Defined. Additional client information.
     CL022      ClientRemark8          Client         CL        varchar     255     User Defined. Additional client information.
     CL023      ClientRemark9          Client         CL        varchar     255     User Defined. Additional client information.
     CL024      ClientRemark10         Client         CL        varchar     255     User Defined. Additional client information.
     CR001         RecordKey         ComRmks          CR                    50      Record key is a unique code assigned by the system
                                                                                    when the data is being imported. It is used to link
                                                                                    together various tables such as tickets to airseg,
                                                                varchar             tickets and hotel.
     CR002         IataNum           ComRmks          CR        varchar      8      IATA number is the main IATA number for agency.
     CR003         SeqNum            ComRmks          CR                            This sequence number links together the invoice
                                                                smallint            header with detail records
     CR004        ClientCode         ComRmks          CR                     15     Client Code is the DK number or DK number plus
                                                                varchar             Branch number depending on customer
     CR005                           ComRmks          CR                            Invoice date is the date the record was invoiced into the
                  InvoiceDate                                  Date Time            back office.
     CR006                           ComRmks          CR                            Issue date is the date the record was issued (should be
                  IssueDate                                    Date Time            equal to or prior to Invoice date)
     CR007          Text1            ComRmks          CR        varchar     150     User Defined. Additional information.
     CR008          Text2            ComRmks          CR        varchar     150     User Defined. Additional information.
     CR009          Text3            ComRmks          CR        varchar     150     User Defined. Additional information.
     CR010          Text4            ComRmks          CR        varchar     150     User Defined. Additional information.
     CR011          Text5            ComRmks          CR        varchar     150     User Defined. Additional information.
     CR012          Text6            ComRmks          CR        varchar     150     User Defined. Additional information.
     CR013          Text7            ComRmks          CR        varchar     150     User Defined. Additional information.
     CR014          Text8            ComRmks          CR        varchar     150     User Defined. Additional information.
     CR015          Text9            ComRmks          CR        varchar     150     User Defined. Additional information.
     CR016          Text10           ComRmks          CR        varchar     150     User Defined. Additional information.
     CR017          Text11           ComRmks          CR        varchar     150     User Defined. Additional information.
     CR018          Text12           ComRmks          CR        varchar     150     User Defined. Additional information.
     CR019          Text13           ComRmks          CR        varchar     150     User Defined. Additional information.
     CR020          Text14           ComRmks          CR        varchar     150     User Defined. Additional information.
     CR021          Text15           ComRmks          CR        varchar     150     User Defined. Additional information.
     CR022          Text16           ComRmks          CR        varchar     150     User Defined. Additional information.
     CR023          Text17           ComRmks          CR        varchar     150     User Defined. Additional information.
     CR024          Text18           ComRmks          CR        varchar     150     User Defined. Additional information.
     CR025          Text19           ComRmks          CR        varchar     150     User Defined. Additional information.
     CR026          Text20           ComRmks          CR        varchar     150     User Defined. Additional information.
     CR027          Text21           ComRmks          CR        varchar     150     User Defined. Additional information.
     CR028          Text22           ComRmks          CR        varchar     150     User Defined. Additional information.
     CR029          Text23           ComRmks          CR        varchar     150     User Defined. Additional information.
     CR030          Text24           ComRmks          CR        varchar     150     User Defined. Additional information.
     CR031          Text25           ComRmks          CR        varchar     150     User Defined. Additional information.
     CR032          Text26           ComRmks          CR        varchar     150     User Defined. Additional information.
     CR033          Text27           ComRmks          CR        varchar     150     User Defined. Additional information.
     CR034          Text28           ComRmks          CR        varchar     150     User Defined. Additional information.
     CR035          Text29           ComRmks          CR        varchar     150     User Defined. Additional information.
     CR036          Text30           ComRmks          CR        varchar     150     User Defined. Additional information.
     CR037          Text31           ComRmks          CR        varchar     150     User Defined. Additional information.
     CR038          Text32           ComRmks          CR        varchar     150     User Defined. Additional information.
     CR039          Text33           ComRmks          CR        varchar     150     User Defined. Additional information.
     CR040          Text34           ComRmks          CR        varchar     150     User Defined. Additional information.
     CR041          Text35           ComRmks          CR        varchar     150     User Defined. Additional information.
     CR042          Text36           ComRmks          CR        varchar     150     User Defined. Additional information.
     CR043          Text37           ComRmks          CR        varchar     150     User Defined. Additional information.
     CR044          Text38           ComRmks          CR        varchar     150     User Defined. Additional information.
     CR045          Text39           ComRmks          CR        varchar     150     User Defined. Additional information.




                                                           3 of 18
Version 5.03                                 TravelMan Data Dictionary



     Field #     Field Name    Database Table     Alias   Field Type   Length                        Description
     CR046          Text40       ComRmks           CR       varchar      150    User Defined. Additional information.
     CR047          Text41       ComRmks           CR       varchar      150    User Defined. Additional information.
     CR048          Text42       ComRmks           CR       varchar      150    User Defined. Additional information.
     CR049          Text43       ComRmks           CR       varchar      150    User Defined. Additional information.
     CR050          Text44       ComRmks           CR       varchar      150    User Defined. Additional information.
     CR051          Text45       ComRmks           CR       varchar      150    User Defined. Additional information.
     CR052          Text46       ComRmks           CR       varchar      150    User Defined. Additional information.
     CR053          Text47       ComRmks           CR       varchar      150    User Defined. Additional information.
     CR054          Text48       ComRmks           CR       varchar      150    User Defined. Additional information.
     CR055          Text49       ComRmks           CR       varchar      150    User Defined. Additional information.
     CR056          Text50       ComRmks           CR       varchar      150    User Defined. Additional information.
     CR057          Num1         ComRmks           CR      Numeric        0     User Defined. Additional information.
     CR058          Num2         ComRmks           CR      Numeric        0     User Defined. Additional information.
     CR059          Num3         ComRmks           CR      Numeric        0     User Defined. Additional information.
     CR060          Num4         ComRmks           CR      Numeric        0     User Defined. Additional information.
     CR061          Num5         ComRmks           CR      Numeric        0     User Defined. Additional information.
     CR062          Num6         ComRmks           CR      Numeric        0     User Defined. Additional information.
     CR063          Num7         ComRmks           CR      Numeric        0     User Defined. Additional information.
     CR064          Num8         ComRmks           CR      Numeric        0     User Defined. Additional information.
     CR065          Num9         ComRmks           CR      Numeric        0     User Defined. Additional information.
     CR066          Num10        ComRmks           CR      Numeric        0     User Defined. Additional information.
     CR067          Num11        ComRmks           CR      Numeric        0     User Defined. Additional information.
     CR068          Num12        ComRmks           CR      Numeric        0     User Defined. Additional information.
     CR069          Num13        ComRmks           CR      Numeric        0     User Defined. Additional information.
     CR070          Num14        ComRmks           CR      Numeric        0     User Defined. Additional information.
     CR071          Num15        ComRmks           CR      Numeric        0     User Defined. Additional information.
     CR072          Num16        ComRmks           CR      Numeric        0     User Defined. Additional information.
     CR073          Num17        ComRmks           CR      Numeric        0     User Defined. Additional information.
     CR074          Num18        ComRmks           CR      Numeric        0     User Defined. Additional information.
     CR075          Num19        ComRmks           CR      Numeric        0     User Defined. Additional information.
     CR076          Num20        ComRmks           CR      Numeric        0     User Defined. Additional information.
     CR077          Num21        ComRmks           CR      Numeric        0     User Defined. Additional information.
     CR078          Num22        ComRmks           CR      Numeric        0     User Defined. Additional information.
     CR079          Num23        ComRmks           CR      Numeric        0     User Defined. Additional information.
     CR080          Num24        ComRmks           CR      Numeric        0     User Defined. Additional information.
     CR081          Num25        ComRmks           CR      Numeric        0     User Defined. Additional information.
     CR082          Num26        ComRmks           CR      Numeric        0     User Defined. Additional information.
     CR083          Num27        ComRmks           CR      Numeric        0     User Defined. Additional information.
     CR084          Num28        ComRmks           CR      Numeric        0     User Defined. Additional information.
     CR085          Num29        ComRmks           CR      Numeric        0     User Defined. Additional information.
     CR086          Num30        ComRmks           CR      Numeric        0     User Defined. Additional information.
     CR087           Int 1       ComRmks           CR       Integer       0     User Defined. Additional information.
     CR088           Int 2       ComRmks           CR       Integer       0     User Defined. Additional information.
     CR089           Int 3       ComRmks           CR       Integer       0     User Defined. Additional information.
     CR090           Int 4       ComRmks           CR       Integer       0     User Defined. Additional information.
     CR091           Int 5       ComRmks           CR       Integer       0     User Defined. Additional information.
     CR092           Int 6       ComRmks           CR       Integer       0     User Defined. Additional information.
     CR093           Int 7       ComRmks           CR       Integer       0     User Defined. Additional information.
     CR094           Int 8       ComRmks           CR       Integer       0     User Defined. Additional information.
     CR095           Int 9       ComRmks           CR       Integer       0     User Defined. Additional information.
     CR096          Int 10       ComRmks           CR       Integer       0     User Defined. Additional information.
     CR097          Int 11       ComRmks           CR       Integer       0     User Defined. Additional information.
     CR098          Int 12       ComRmks           CR       Integer       0     User Defined. Additional information.
     CR099          Int 13       ComRmks           CR       Integer       0     User Defined. Additional information.
     CR100          Int 14       ComRmks           CR       Integer       0     User Defined. Additional information.
     CR101          Int 15       ComRmks           CR       Integer       0     User Defined. Additional information.
     CR102          Int 16       ComRmks           CR       Integer       0     User Defined. Additional information.
     CR103          Int 17       ComRmks           CR       Integer       0     User Defined. Additional information.
     CR104          Int 18       ComRmks           CR       Integer       0     User Defined. Additional information.
     CR105          Int 19       ComRmks           CR       Integer       0     User Defined. Additional information.
     CR106          Int 20       ComRmks           CR       Integer       0     User Defined. Additional information.
     CTRY001      CtryCode         Country        CTRY      varchar       5     2 letter ISO code
     CTRY002      CtryName         Country        CTRY      varchar      25     Definiton of country
     CTRY003    IntlDomCode        Country        CTRY      varchar       1     D for domestic, I for international
     CTRY004   ContinentCode       Country        CTRY      varchar       2     Continent
     CTRY005      PhnCode          Country        CTRY      varchar       4     Internationl code
     CTRY006   CurrencyCode        Country        CTRY      varchar       3     3 letter currency code
                                                                                Base currency code is a 3 letter Home Country
     CURR001   BaseCurrCode       Currency        CURR     varchar       3      currency code. i.e., USD
                                                                                Currency Code is a 3 letter code which identifies
     CURR002     CurrCode         Currency        CURR     varchar       3      foreign currency , i.e., GBP, JPY
                                                                                Currency begin date is the beginning date/time stamp
     CURR003   CurrBeginDate      Currency        CURR    Date Time             for validity of rate being reported




                                                      4 of 18
Version 5.03                                     TravelMan Data Dictionary



     Field #     Field Name        Database Table     Alias    Field Type   Length                          Description
                                                                                     Currency end date is the end date/time stamp of rate
     CURR004     CurrEndDate          Currency        CURR      Date Time            being reported
                                                                                     Base Units per currency is the number of base
     CURR005   BaseUnitsPerCurr       Currency        CURR      Numeric       12     currency per foreign currency
                                                                                     Currency units per base is the number of foreign
     CURR006   CurrUnitsPerBase       Currency        CURR      Numeric       12     currency units per base currency unit.
                                                                                     Hotel table Record key is a unique code assigned by
                                                                                     the system when the data is being imported. It is used
                                                                                     to link together various tables such as tickets to airseg,
     HTL001      RecordKey             Hotel          HTL        varchar      50     car and hotel.
                                                                                     IATA number is the main IATA number for client which
     HTL002        IataNum             Hotel          HTL        varchar      8      is filled in at time of extract from back office
                                                                                     This sequence number links together the invoice detail
     HTL003        SeqNum              Hotel          HTL        SmallInt            records
                                                                                     Hotel segment number is the field that represents the
                                                                                     hotel order in the itinerary. Ie, the first hotel has a
                                                                                     htlsegnum of 1, the second hotel in the itinerary would
     HTL004      HtlSegNum             Hotel          HTL        smallint            have a htlsegnum of 2.
                                                                                     Client Code is the DK number or DK number plus
     HTL005       ClientCode           Hotel          HTL        varchar      15     Branch number depending on customer
                                                                                     Invoice date is the date the record was invoiced into the
     HTL006      InvoiceDate           Hotel          HTL       Date Time            back office.
                                                                                     Issue date is the date the record was issued (should be
     HTL007       IssueDate            Hotel          HTL       Date Time            equal to or prior to Invoice date)
                                                                                     Void Indicator is a 1 letter field marked with "Y" or "N".
     HTL008        VoidInd             Hotel          HTL        varchar       1     A void record will contain a "Y" code.
     HTL009    VoidReasonType          Hotel          HTL        varchar       3     Reason for voiding
     HTL010       Salutation           Hotel          HTL        varchar      10     MR,MRS,MS,MISS,MSTR,SR,FR etc
     HTL011       FirstName            Hotel          HTL        varchar      25     Passenger First Name
     HTL012       Lastname             Hotel          HTL        varchar      35     Passenger Last Name
     HTL013      MiddleInitial         Hotel          HTL        varchar      1      Passenger Middle Initial
                                                                                     Hotel chain code is the 2 letter code that identify the
     HTL014     HtlChainCode           Hotel          HTL        varchar      6      hotel chain, ie, HH for Hilton or SI for Sheraton.
                                                                                     Hotel chain name is the standardized hotel chain name,
                                                                                     ie, COURTYARD BY MARRIOTT, COMFORT INNS
     HTL015     HtlChainName           Hotel          HTL        varchar      40
                                                                                     Hotel property number is a series of characters used it
                                                                                     identify hotel properties within the GDS or Back -
                                                                                     Office.
     HTL016     GDSPropNum             Hotel          HTL        varchar      15
                                                                                     Hotel property name is the name of the Hotel as seen
                                                                                     in the hotel segment. Ie, WYNDHAM GARDEN
     HTL017    HtlPropertyName         Hotel          HTL        varchar      40     PERIMETER NORTH
                                                                                     Hotel property address1 is the second line of the hotel
     HTL018        HtlAddr1            Hotel          HTL        varchar      40     property address
                                                                                     Hotel property address2 is the first line of the hotel
     HTL019        HtlAddr2            Hotel          HTL        varchar      40     property address
                                                                                     Hotel property address3 is the third line of the hotel
     HTL020        HtlAddr3            Hotel          HTL        varchar      40     property address
                                                                                     Hotel city code is a 3 letter hotel city code , ie,
     HTL021      HtlCityCode           Hotel          HTL        varchar      3      DFW,BOS. This often matches the airport code.
                                                                                     Hotel city name is the name of the city where the hotel
     HTL022      HtlCityName           Hotel          HTL        varchar      25     is located.
     HTL023         HtlState           Hotel          HTL        varchar      20     State or province of hotel
     HTL024     HtlPostalCode          Hotel          HTL        varchar      15     Postal or zip code of the hotel
     HTL025     HtlCountryCode         Hotel          HTL        varchar       2     2 letter ISO code
                                                                                     Hotel phone number is the phone number as it
     HTL026        HtlPhone            Hotel          HTL        varchar      20     interfaces into the Back Office from the PNR.
                                                                                     Domestic/International indicator is a single letter of
                                                                                     either "D" or "I" which identifies the location of rental as
     HTL027     InternationalInd       Hotel          HTL        varchar      1      either Domestic or International.
                                                                                     Hotel Check in date is the date for the first night of the
     HTL028      CheckinDate           Hotel          HTL       Date Time            hotel reservation.
                                                                                     Hotel Check out date. The last night of the hotel
     HTL029     CheckoutDate           Hotel          HTL       Date Time            reservation.
                                                                                     Number of nights for which the hotel room was
     HTL030      NumNights             Hotel          HTL             int            reserved.
     HTL031      NumRooms              Hotel          HTL             int            Number of rooms reserved by the traveler.
                                                                                     Hotel quoted rate. This is the rate confirmed from the
                                                                                     vendor and found in the hotel segment of the PNR.
     HTL032     HtlQuotedRate          Hotel          HTL         float
                                                                                     Hotel quoted currency code is a 3 letter standard
     HTL033    QuotedCurrCode          Hotel          HTL        varchar      3      currency code returned from the vendor and found in
                                                                                     the hotel segment. Ie, USD, CAD, DEM




                                                            5 of 18
Version 5.03                                       TravelMan Data Dictionary



     Field #      Field Name      Database Table        Alias    Field Type   Length                          Description
                                                                                       Hotel daily rate is calculated by TMAN product and is
                                                                                       based on Quoted Rate/Number of hotel nights and
     HTL034       HtlDailyRate        Hotel             HTL         float              number of rooms
                                                                                       Total hotel cost is the total amount of hotel booking and
                                                                                       is based on the number of nights x number of rooms x
     HTL035        TtlHtlCost         Hotel             HTL         float              hotel daily rate
                                                                                       Room Type is a 3 letter code that identifies a room
                                                                                       type, ie, A1Q , ROHCOR
     HTL036       RoomType            Hotel             HTL        varchar      6
                                                                                       Hotel rate category is an identifier any special
                                                                                       designators associated with the hotel rate , ie EDS, BTI
     HTL037       HtlRateCat          Hotel             HTL        varchar      10
                                                                                       Hotel compare rate is an optional field, input by the
     HTL038    HtlCompareRate1        Hotel             HTL         float              agent at the customers request and stored in UDID
                                                                                       field
                                                                                       Hotel reason code is a specific reason code stored by
     HTL039     HtlReasonCode1        Hotel             HTL        varchar      6      the booking agent at the customers request.
                                                                                       Hotel compare rate2 is an additional optional field, input
                                                                                       by the agent at the customers request and stored in
     HTL040    HtlCompareRate2        Hotel             HTL         float              UDID field
                                                                                       Hotel reason code2 is an additional reason code
                                                                                       stored by the booking agent at the customers request.
     HTL041     HtlReasonCode2        Hotel             HTL        varchar      6
     HTL042      HtlCommAmt           Hotel             HTL          float             Hotel commission from the back-office system
                                                                                       Hotel currency code is a 3 letter currency code
                                                                                       converted from the quoted currency code to a standard
     HTL043        CurrCode           Hotel             HTL        varchar      3      rate. Ie, USD, CAD, DEM
     HTL044        PrefHtlInd         Hotel             HTL        varchar       1     Can be used for corporate contracts
     HTL045       HtlConfNum          Hotel             HTL        varchar      30     Hotel confirmation number. The confirmation number
                                                                                       Membership number i.e.. Hyatt GoldPassport, Hilton
     HTL046    FreqGuestProgram       Hotel             HTL        varchar      13     Honors
     HTL047        HtlStatus          Hotel             HTL        varchar       2     HK, BK, HL, etc
                                                                                       Remark1 contains the Statement Information/Name
                                                                                       Field Remarks in the back-office. This field will contain
     HTL048       Remarks1            Hotel             HTL        varchar     100     SSN/MOC/RC.
                                                                                       Remark2 contains the Statement Information/Name
                                                                                       Field Remarks in the back-office. This field will contain
     HTL049       Remarks2            Hotel             HTL        varchar     100     SSN/MOC/RC.
                                                                                       Remark3 contains the Statement Information/Name
                                                                                       Field Remarks in the back-office. This field will contain
     HTL050       Remarks3            Hotel             HTL        varchar     100     SSN/MOC/RC.
                                                                                       Remark4 contains the Statement Information/Name
                                                                                       Field Remarks in the back-office. This field will contain
     HTL051       Remarks4            Hotel             HTL        varchar     100     SSN/MOC/RC.
                                                                                       Remark5 contains the Statement Information/Name
                                                                                       Field Remarks in the back-office. This field will contain
     HTL052        Remarks5           Hotel             HTL        varchar     100     SSN/MOC/RC.
     HTL053     CommTrackInd          Hotel             HTL        varchar      5      To be used with commission tracking programs
     HTL054    HtlCommPostDate        Hotel             HTL       Date Time            Date commission posted
     HTL055      HtlMatchedInd        Hotel             HTL        varchar      1      Used with credit card reconciliation
                                                                                       Additional field for use with credit card reconciliation.
     HTL056     MatchedFields         Hotel             HTL        varchar     255
     HTL057    GDSRecordLocator       Hotel             HTL        varchar     10      PNR unique identifier assigned by GDS
     HTL058     BookingAgentId        Hotel             HTL        varchar     10      Booking Agent number
                                                                                       Record key is a unique code assigned by the system
                                                                                       when the data is being imported. It is used to link
                                                                                       together various tables such as invoices to transeg, car
     ID001        RecordKey        InvoiceDetail         ID        varchar      50     and hotel.
                                                                                       IATA number is the main IATA number for client which
     ID002         IataNum         InvoiceDetail         ID        varchar      8      is filled in at time of extract from back office
                                                                                       This sequence number links together the invoice
     ID003         SeqNum          InvoiceDetail         ID        SmallInt            header with detail records
                                                                                       Client Code is the DK number or DK number plus
     ID004        ClientCode       InvoiceDetail         ID        varchar      15     Branch number depending on customer
                                                                                       Invoice date is the date the record was invoiced into the
     ID005        InvoiceDate      InvoiceDetail         ID       Date Time            back office.
                                                                                       Issue date is the date the record was issued (should be
     ID006         IssueDate       InvoiceDetail         ID       Date Time            equal to or prior to Invoice date)
                                                                                       Void Indicator is a 1 letter field marked with "Y" or "N".
     ID007          VoidInd        InvoiceDetail         ID        varchar       1     A void record will contain a "Y" code.
     ID008      VoidReasonType     InvoiceDetail         ID        varchar       3     Reason for voiding
     ID009         Salutation      InvoiceDetail         ID        varchar      10     MR,MRS,MS,MISS,MSTR,SR,FR etc
     ID010         FirstName       InvoiceDetail         ID        varchar      25     Passenger First Name
     ID011         Lastname        InvoiceDetail         ID        varchar      35     Passenger Last Name
     ID012        MiddleInitial    InvoiceDetail         ID        varchar       1     Passenger Middle Initial




                                                              6 of 18
Version 5.03                                             TravelMan Data Dictionary



     Field #         Field Name         Database Table        Alias    Field Type   Length                          Description
     ID013           InvoiceType         InvoiceDetail         ID        varchar      10     Used for miscellaneous NonAir type transactions
     ID014     InvoiceTypeDescription    InvoiceDetail         ID        varchar      255    Description of miscellaneous NonAir transactions
                                                                                             Ticket Number without validating carrier or a Voucher
     ID015       DocumentNumber          InvoiceDetail         ID        varchar      15     number
     ID016         EndDocNum             InvoiceDetail         ID        varchar       3     The last 3 digits of conjunctive ticket number.
                                                                                             Vendor Number is an identification number which for
                                                                                             Airlines is the airline number and for NONAIR is the
     ID017        VendorNumber           InvoiceDetail         ID        varchar      15     back office vendor number
                                                                                             BSP,NONBSP = Air, NONAIR= Non Air, FEES=
     ID018          VendorType           InvoiceDetail         ID        varchar      10     Service Fees
                                                                                             Validating carrier number is the standard IATA
     ID019        ValCarrierNum          InvoiceDetail         ID        smallint            Airline/Carrier 3 digit number
                                                                                             Validating carrier code is the IATA Airline/Carrier 2
     ID020        ValCarrierCode         InvoiceDetail         ID        varchar       6     letter code
     ID021         VendorName            InvoiceDetail         ID        varchar      40     Validating Carrier Name or other Vendor Name
     ID022         BookingDate           InvoiceDetail         ID       Date Time            Booking date is the date the invoice was booked.
     ID023          ServiceDate          InvoiceDetail         ID       Date Time            Service date is the first date of Itinerary
                                                                                             Service category is the predominate class of service
     ID024        ServiceCategory        InvoiceDetail         ID       Date Time            from transportation segments
                                                                                             Domestic/International indicator is a single letter of
                                                                                             either "D" or "I" which identifies the location of service
     ID025        InternationalInd       InvoiceDetail         ID        varchar      1      as either Domestic or International.
     ID026          ServiceFee           InvoiceDetail         ID        Money               Amount of service fee received
     ID027          InvoiceAmt           InvoiceDetail         ID        Money               Base fare is the total fare without tax/surcharges
     ID028            TaxAmt             InvoiceDetail         ID        Money               Total Tax broken down in Tax Table
     ID029            TotalAmt           InvoiceDetail         ID        Money               Total Invoice Amount is the amount paid for ticket.
                                                                                             Ticket commission amount is the amount of
     ID030        CommissionAmt          InvoiceDetail         ID        Money               commission on ticket
     ID031       CancelPenaltyAmt        InvoiceDetail         ID        Money               Penalty Amount collected
                                                                                             Currency code is a 3 digit currency code for invoice
     ID032           CurrCode            InvoiceDetail         ID        varchar      3
                                                                                             Full fare is a comparison field stored by customer, field
     ID033        FareCompare1           InvoiceDetail         ID        Money               is populated by back office
                                                                                             Reason code 1 is a reason code populated by client
     ID034         ReasonCode1           InvoiceDetail         ID       VarChar       6
                                                                                             Low fare is a comparison field stored by customer, field
     ID035        FareCompare2           InvoiceDetail         ID        Money               is populated by back office
                                                                                             Reason code 1 is a reason code populated by client
     ID036         ReasonCode2           InvoiceDetail         ID       VarChar       6
                                                                                             Low fare is a comparison field stored by customer, field
     ID037        FareCompare3           InvoiceDetail         ID        Money               is populated by back office
                                                                                             Reason code 1 is a reason code populated by client
     ID038         ReasonCode3           InvoiceDetail         ID       VarChar       6
                                                                                             Low fare is a comparison field stored by customer, field
     ID039        FareCompare4           InvoiceDetail         ID        Money               is populated by back office
                                                                                             Reason code 1 is a reason code populated by client
     ID040         ReasonCode4           InvoiceDetail         ID       VarChar       6
     ID041           Mileage             InvoiceDetail                   float               Total mileage from segments
                                                                                             Routing is the linerary routing built from the flights found
     ID042            Routing            InvoiceDetail         ID        varchar      40     in the back office.
                                                                                             Days advance purchase is a calculated field which is
     ID043        DaysAdvPurch           InvoiceDetail         ID        Smallint            the amount of days between date booked and date
                                                                                             ticketed purchase group is a Grouping by number of
                                                                                             Advance
                                                                                             days in advance ticket was purchased. I.e. 1-3days, 4-
     ID044        AdvPurchGroup          InvoiceDetail         ID        varchar      10     6 days etc
                                                                                             True ticket count is is used to provide a truer
                                                                                             transaction count, useful for generating accurate
                                                                                             average ticket price. Tickets are a 1, Exchanges &
     ID045         TrueTktCount          InvoiceDetail         ID             Int            Partial Refunds are a 0, and Full Refunds are -1
                                                                                             Trip length is a calculation of the number of days start
     ID046          TripLength           InvoiceDetail         ID         Float              to finish of the trip. Calculate how….??????
                                                                                             Exchange indicator identifies tickets that have be
                                                                                             exchanged. A refunded ticket is marked "Y" or Yes.
     ID047         ExchangeInd           InvoiceDetail         ID        varchar      1
     ID048       OrigExchTktNum          InvoiceDetail         ID        varchar     15      Original ticket number being exchanged
     ID049          Department           InvoiceDetail         ID        varchar     40      User Defined.
     ID050            ETktInd            InvoiceDetail         ID        varchar      1      Y=Electronic Ticket, N=No ElectronicTicket
     ID051         ProductType           InvoiceDetail         ID        varchar     20      User Defined.
     ID052           TourCode            InvoiceDetail         ID        varchar     15      IT Number used for contracts
     ID053     EndorsementRemarks        InvoiceDetail         ID        varchar     60      Endorsements on ticket
     ID054         FareCalcLine          InvoiceDetail         ID        varchar     255     Linear fare calculation string
     ID055          GroupMult            InvoiceDetail         ID        Smallint            Used for consolidator tickets
     ID056          OneWayInd            InvoiceDetail         ID        varchar      1      Y=One Way Trip, N=Not One Way




                                                                    7 of 18
Version 5.03                                               TravelMan Data Dictionary



     Field #         Field Name           Database Table        Alias    Field Type   Length                          Description
     ID057            PrefTktInd           InvoiceDetail         ID        varchar      1      User Defined.
                                                                                               Number of nights for which the hotel room was
     ID058           HotelNights           InvoiceDetail         ID         Float              reserved.
                                                                                               Number of days are the number of days the car is
     ID059             CarDays             InvoiceDetail         ID         Float              rented for.
     ID060       OnlineBookingSystem       InvoiceDetail         ID        varchar     20      User Defined
     ID061       AccommodationType         InvoiceDetail         ID        varchar     10      User Defined
     ID062     AccommodationDescription    InvoiceDetail         ID        varchar     255     User Defined
     ID063            ServiceType          InvoiceDetail         ID        Vachar      10      User Defined
     ID064        ServiceDescription       InvoiceDetail         ID        varchar     255     User Defined
     ID065         ShipHotelName           InvoiceDetail         ID        varchar     255     User Defined
                                                                                               Remark1 contains the Statement Information/Name
                                                                                               Field Remarks in the back-office. This field will contain
     ID066            Remarks1             InvoiceDetail         ID        varchar     100     SSN/MOC/RC.
                                                                                               Remark2 contains the Statement Information/Name
                                                                                               Field Remarks in the back-office. This field will contain
     ID067            Remarks2             InvoiceDetail         ID        varchar     100     SSN/MOC/RC.
                                                                                               Remark3 contains the Statement Information/Name
                                                                                               Field Remarks in the back-office. This field will contain
     ID068            Remarks3             InvoiceDetail         ID        varchar     100     SSN/MOC/RC.
                                                                                               Remark4 contains the Statement Information/Name
                                                                                               Field Remarks in the back-office. This field will contain
     ID069            Remarks4             InvoiceDetail         ID        varchar     100     SSN/MOC/RC.
                                                                                               Remark5 contains the Statement Information/Name
                                                                                               Field Remarks in the back-office. This field will contain
     ID070              Remarks5           InvoiceDetail         ID        varchar     100     SSN/MOC/RC.
     ID071             IntlSalesInd        InvoiceDetail         ID        varchar      4      SITI, SITO, SOTO, SOTI
     ID072               MatchInd          InvoiceDetail         ID        varchar      1      Used with Credit Card Reconciliation
     ID073           MatchedFields         InvoiceDetail         ID        varchar     255     Used with Credit Card Reconciliation
     ID074              RefundInd          InvoiceDetail         ID        varchar      1      Y=Yes, N=Not Refunded, P=Partial
     ID075         OriginalInvoiceNum      InvoiceDetail         ID        varchar     15      Used to reference original information on refunds
     ID076      TicketingOfficeIATANum     InvoiceDetail         ID        varchar      8      IATA of Ticketing office
     ID077         GDSRecordLocator        InvoiceDetail         ID        varchar     10      PNR unique identifier assigned by GDS
     ID078          BookingAgentId         InvoiceDetail         ID        varchar     10      Booking Agent number
     ID079          TicketingAgentId       InvoiceDetail         ID        varchar     10      Ticketing Agent number
     ID080             OriginCode          InvoiceDetail         ID        varchar      3      Origin city code is a 3 digit origin city code.
                                                                                               Destination city code is a 3 digit destination city code.
     ID081         DestinationCode         InvoiceDetail         ID        varchar      3
                                                                                               Record key is a unique code assigned by the system
                                                                                               when the data is being imported. It is used to link
                                                                                               together various tables such as tickets to airseg, car
     IH001            RecordKey           InvoiceHeader          IH        varchar      50     and hotel.
                                                                                               IATA number is the main IATA number for client which
     IH002             IataNum            InvoiceHeader          IH        varchar      8      is filled in at time of extract from back office
                                                                                               Client Code is the DK number or DK number plus
     IH003            ClientCode          InvoiceHeader          IH        varchar      15     Branch number depending on customer
                                                                                               Invoice date is the date the record was invoiced into the
     IH004           InvoiceDate          InvoiceHeader          IH       Date Time            back office.
                                                                                               Number assigned to the record at the time of invoicing
     IH005           InvoiceNum           InvoiceHeader          IH        varchar      15     into the back office
     IH006         TicketingBranch        InvoiceHeader          IH        varchar      10     Ticketing Branch IATA Number
     IH007         BookingBranch          InvoiceHeader          IH        varchar      10     Booking Branch IATA Number
     IH008          TtlInvoiceAmt         InvoiceHeader          IH        Money               Total of all invoice records associated to this header
                                                                                               (InvoiceDetail) records associated to this header
                                                                                               Total of all tax
     IH009            TtlTaxAmt           InvoiceHeader          IH        Money               (TaxDetail)
                                                                                               Total of all commission records associated to this
     IH010        TtlCommissionAmt        InvoiceHeader          IH        Money               header (InvoiceDetail)
     IH011             CurrCode           InvoiceHeader          IH        varchar       3     3 letter ISO code for local currency
     IH012            OrigCountry         InvoiceHeader          IH        varchar       2     2 letter ISO country code for sale origination
     IH013           SalesAgentId         InvoiceHeader          IH        varchar      10     Sales Agent number
                                                                                               AR=Accounts Receivable, CC=Credit Card, CA=Cash,
     IH014              FOP               InvoiceHeader          IH        varchar       2     CK=Check
     IH015             CCCode             InvoiceHeader          IH        varchar       6     AX=American Express, DC=Diners Club, etc
     IH016             CCNum              InvoiceHeader          IH        varchar      40     Card number no spaces
                                                                                               Month and year of expiration i.e.. 0301 for March 2001
     IH017             CCExp              InvoiceHeader          IH        varchar      10
                                                                                               Approval code assigned by the credit card company
     IH018         CCApprovalCode         InvoiceHeader          IH        varchar      10
                                                                                               1A=Amadeus, 1P=Worldspan, 1G=Galileo, 1V=Apollo,
     IH019            GDSCode             InvoiceHeader          IH        varchar      10     1W=SABRE, 1B=Abacus
     IH020           BackOfficeId         InvoiceHeader          IH        varchar      20     Assigned at time of import.




                                                                      8 of 18
Version 5.03                                      TravelMan Data Dictionary



     Field #        Field Name       Database Table    Alias    Field Type   Length                          Description
                                                                                      Version of specification

     IH021          VersionNote      InvoiceHeader      IH        varchar      5
                                                                                      Minute Rule - no connection- destination city code to be
                                                                                      used with true origin and destination flights when the
                                                                                      4hour domestic/ 6 hour international layover rule
     MDEST001        CityCode             City        MDEST       varchar      3      applies.
                                                                                      Minute Rule - no connection destination type code
                                                                                      identifies the method of travel either Air or Rail travel.
                                                                                      "A" = Air , "R" = Rail to be used with true origin and
                                                                                      destination flights when the 4hour domestic/ 6 hour
                                                                                      international layover rule applies.
     MDEST002       TypeCode              City        MDEST       varchar      1
                                                                                      Minute Rule - no connection-destination city name is
                                                                                      the full city name and is to be used with true origin and
                                                                                      destination flights when the 4hour domestic/ 6 hour
                                                                                      international layover rule applies.
     MDEST003        CityName             City        MDEST       varchar      30
                                                                                      Minute Rule - no connection- destination airport name
                                                                                      is the full airport name and is to be used with true origin
                                                                                      and destination flights when the 4hour domestic/ 6 hour
     MDEST004      AirportName            City        MDEST       varchar      30     international layover rule applies.
                                                                                      Minute Rule - no connection destination region code
                                                                                      which is a standard 3 letter code identifying a region
                                                                                      and is to be used with true origin and destination flights
                                                                                      when the 4hour domestic/ 6 hour international layover
     MDEST005       RegionCode            City        MDEST       varchar      3      rule applies.
                                                                                      Minute Rule - no connection destination region name is
                                                                                      the name in full which is to be used with to be used with
                                                                                      true origin and destination flights when the 4hour
     MDEST006      RegionName             City        MDEST       varchar      30     domestic/ 6 hour international layover rule applies.
                                                                                      Minute Rule - no connection- destination state/province
                                                                                      code is a standard 2 letter code to be used with true
                                                                                      origin and destination flights flights when the 4hour
                                                                                      domestic/ 6 hour international layover rule applies.
     MDEST007    StateProvinceCode        City        MDEST       varchar      5
                                                                                      Minute Rule - no connection destination country code is
                                                                                      a standard 3 letter code with to be used with true origin
     MDEST008      CountryCode            City        MDEST       varchar      5      and destination flights when the 4hour domestic/ 6 hour
                                                                                      Minute Rule layover rule applies.
                                                                                      international - no connection- destination LATITUDE to
                                                                                      be used with true origin and destination flights when the
     MDEST009         Latitude            City        MDEST      Numeric       12     4hour domestic/ 6 hour international layover rule
                                                                                      applies. Rule - no connection- destination LONGITUDE
                                                                                       Minute
                                                                                      to be used with true origin and destination flights when
                                                                                      the 4hour domestic/ 6 hour international layover rule
     MDEST010        Longitude            City        MDEST      Numeric       12     applies.
                                                                                       Minute Rule - no connection- destination Time Zone
                                                                                      Difference to be used with true origin and destination
                                                                                      flights when the 4hour domestic/ 6 hour international
                                                                                      layover rule applies.
     MDEST011      TimeZoneDiff           City        MDEST      Numeric       12
                                                                                      Market city pairs - Minute Rule no connections
                                                                                      destination city code is the standard 3 letter city code to
     MMDEST001       CityCode             City        MMDEST      varchar      3      be used with true origin and destination flights when the
                                                                                      4hour domestic/ 6 hour international layover rule
                                                                                      Market city pairs- Minute Rule- no connections
                                                                                      destination Type code is the code identifies the method
                                                                                      of travel either Air or Rail travel. hour international
     MMDEST002      TypeCode              City        MMDEST      varchar      1      layover rule applies.
                                                                                      Market city pairs - Minute Rule no connections market
                                                                                      destination name is the destination name to be used
                                                                                      with true origin and destination flights when the 4hour
                                                                                      domestic/ 6 hour international layover rule applies. .
     MMDEST003       CityName             City        MMDEST      varchar      30
                                                                                      Market city pairs - Minute Rule no connections airport
                                                                                      name is the airport name to be used with true origin
                                                                                      and destination flights when the 4hour domestic/ 6 hour
                                                                                      international layover rule applies. .
     MMDEST004     AirportName            City        MMDEST      varchar      30
                                                                                      Market city pairs - Minute Rule no connections region
                                                                                      code is the region code to be used with true origin and
                                                                                      destination flights when the 4hour domestic/ 6 hour
                                                                                      international layover rule applies. .
     MMDEST005      RegionCode            City        MMDEST      varchar      3




                                                             9 of 18
Version 5.03                                      TravelMan Data Dictionary



     Field #        Field Name       Database Table    Alias   Field Type   Length                         Description
                                                                                     Market city pairs - Minute Rule no connections region
                                                                                     name is the airport name to be used with true origin
                                                                                     and destination flights when the 4hour domestic/ 6 hour
     MMDEST006     RegionName             City        MMDEST    varchar       30     international layover rule applies. .
                                                                                     Market city pairs - Minute Rule no connections
                                                                                     destination state province code is the state/province
                                                                                     name to be used with true origin and destination flights
     MMDEST007   StateProvinceCode        City        MMDEST    varchar       5      when the 4hour domestic/ 6 hour international layover
                                                                                     rule applies. .
                                                                                     Market city pairs - Minute Rule no connections
                                                                                     destination country code is the country code to be used
                                                                                     with true origin and destination flights when the 4hour
                                                                                     domestic/ 6 hour international layover rule applies. .
     MMDEST008     CountryCode            City        MMDEST    varchar       5
                                                                                     Market city pairs - Minute Rule no connections
                                                                                     destination latitude is the latitude to be used with true
                                                                                     origin and destination flights when the 4hour domestic/
                                                                                     6 hour international layover rule applies. .
     MMDEST009        Latitude            City        MMDEST    Numeric       12
                                                                                     Market city pairs - Minute Rule no connections
                                                                                     destination longitude is the longitude to be used with
                                                                                     true origin and destination flights when the 4hour
     MMDEST010       Longitude            City        MMDEST    Numeric       12     domestic/ 6 hour international layover rule applies. .
                                                                                     Market city pairs - Minute Rule no connections
                                                                                     destination time zone difference is the time zone to be
                                                                                     used with true origin and destination flights when the
                                                                                     4hour domestic/ 6 hour international layover rule
     MMDEST011     TimeZoneDiff           City        MMDEST    Numeric       12     applies. .
                                                                                     Market city pairs - Minute Rule- no connection - city
                                                                                     code. This is the airport name to be used with true
                                                                                     origin and destination flights when the 4hour domestic/
                                                                                     6 hour international layover rule applies.
     MMORIG001       CityCode             City        MMORIG    varchar       3
                                                                                     Market city pairs - Minute Rule- no connection origin
                                                                                     type code identifies the method of travel either Air or
                                                                                     Rail travel. "A" = Air , "R" = Rail to be used with true
                                                                                     origin and destination flights when the 4hour domestic/
                                                                                     6 hour international layover rule applies.
     MMORIG002      TypeCode              City        MMORIG    varchar       1
                                                                                     Market city pairs - Minute Rule- no connection origin
                                                                                     city name is the full to be used for true origin and
                                                                                     destination where the stopover rule applies.
     MMORIG003       CityName             City        MMORIG    varchar       30
                                                                                     Market city pairs - Minute Rule- no connection origin
                                                                                     airport name is the airport name to be used with true
                                                                                     origin and destination flights when the 4hour domestic/
                                                                                     6 hour international layover rule applies.
     MMORIG004     AirportName            City        MMORIG    varchar       30
                                                                                     Market city pairs - Minute Rule- no connection origin 3
                                                                                     letter city code-??? to be used for true origin and
                                                                                     destination where the stopover rule applies.
     MMORIG005      RegionCode            City        MMORIG    varchar       3
                                                                                     Market city pairs - Minute Rule- no connection origin 3
                                                                                     letter city code-??? to be used for true origin and
                                                                                     destination where the stopover rule applies.
     MMORIG006     RegionName             City        MMORIG    varchar       30
                                                                                     Market city pairs - Minute Rule- no connection origin
                                                                                     state/province code is the state/province code to be
                                                                                     used with true origin and destination flights when the
     MMORIG007   StateProvinceCode        City        MMORIG    varchar       5      4hour domestic/ 6 hour international layover rule
                                                                                     applies.
                                                                                     Market city pairs - Minute Rule- no connection origin
                                                                                     country code is the standard 3 letter country code to be
                                                                                     used with true origin and destination flights when the
                                                                                     4hour domestic/ 6 hour international layover rule
     MMORIG008     CountryCode            City        MMORIG    varchar       5      applies.
                                                                                     Market city pairs - Minute Rule- no connection - Origin
                                                                                     LATITUDE is the latitude to be used with true origin and
                                                                                     destination flights when the 4hour domestic/ 6 hour
     MMORIG009        Latitude            City        MMORIG    Numeric       12     international layover rule applies.
                                                                                     Market city pairs - Minute Rule- no connection - Origin
                                                                                     LONGITUDE is the longitude to be used with true origin
                                                                                     and destination flights when the 4hour domestic/ 6 hour
     MMORIG010       Longitude            City        MMORIG    Numeric       12     international layover rule applies.




                                                           10 of 18
Version 5.03                                      TravelMan Data Dictionary



     Field #        Field Name       Database Table    Alias   Field Type   Length                           Description
                                                                                     Market city pairs - Minute Rule- no connection - Origin
                                                                                     Time Zone Difference is the time zone difference to be
                                                                                     used with true origin and destination flights when the
                                                                                     4hour domestic/ 6 hour international layover rule
     MMORIG011    TimeZoneDiff           City         MMORIG  Numeric         12     applies.
     MNTH001        SortOrder           Months         MNTH Short Integer      5     Numbering of months in order from 1 - 12.
     MNTH002        MonthNum            Months         MNTH Short Integer      5     Month number is the number equivelent of month
     MNTH003       MonthName            Months         MNTH   varchar          3     Month name is the 3 letter month code
     MNTH004     LongMonthName          Months         MNTH   varchar          9     Long Month Name is name in full.
                                                                                     All connections - Origin city code is the airport name to
     ORIG001         CityCode             City         ORIG     varchar       3      be used with point to point flights.
                                                                                     All connections Origin type code identifies the method
                                                                                     of travel either Air or Rail travel. "A" = Air , "R" = Rail to
     ORIG002        TypeCode              City         ORIG     varchar       1      be used for flights/trains.
                                                                                     All connections Origin City Name is the name in full of
     ORIG003         CityName             City         ORIG     varchar       30     the city of origin.
                                                                                     All connections - Origin Airport Name is the airport
     ORIG004       AirportName            City         ORIG     varchar       30     name to be used with point to point flights.
                                                                                     All connection Origin Region code is a stanard 3 letter
     ORIG005        RegionCode            City         ORIG     varchar       3      code to be used with point to point flights .
                                                                                      All connection Origin Region name is the Region name
     ORIG006       RegionName             City         ORIG     varchar       30     to be used with point to point flights .
                                                                                     All connections - Origin state/province code is the
     ORIG007     StateProvinceCode        City         ORIG     varchar       5      state/province code to be used with point to point
                                                                                     flights.
                                                                                     All connections -Origin Country code is the Country
                                                                                     code to be used with point to point flights.
     ORIG008       CountryCode            City         ORIG     varchar       5
                                                                                     All connections - Origin LATITUDE is the latitude to be
     ORIG009          Latitude            City         ORIG     Numeric       12     used with point to point flights.
                                                                                     All connections - Origin LONGITUDE is the longitude to
     ORIG010         Longitude            City         ORIG     Numeric       12     be used with point to point flights.
                                                                                     All connections - Origin Time Zone Difference is the
                                                                                     Time Zone Difference to be used with point to point
     ORIG011       TimeZoneDiff           City         ORIG     Numeric       12     flights.
                                                                                     Record key is a unique code assigned by the system
                                                                                     when the data is being imported. It is used to link
                                                                                     together various tables such as tickets to airseg, car
     PAY001         RecordKey           Payment        PAY      varchar       50     and hotel.

     PAY002          IataNum            Payment        PAY      varchar       8      IATA number is the main IATA number for agency.
                                                                                     Primary Key - used to tie record with other detail
     PAY003          SeqNum             Payment        PAY      smallInt             records
                                                                                     Primary Key Ties record of multiple forms of payment
     PAY004      PaymentSeqNum          Payment        PAY      smallint             for a given invoice
     PAY005         ClientCode          Payment        PAY      varchar       15     Account Number
                                                                                     Invoice date is the date the record was invoiced into the
     PAY006         InvoiceDate         Payment        PAY     Date Time             back office.
                                                                                     Issue date is the date the record was issued (should be
     PAY007          IssueDate          Payment        PAY     Date Time             equal to or prior to Invoice date)
                                                                                     AR=Accounts Receivable, CC=Credit Card, CA=Cash,
     PAY008           FOP               Payment        PAY      varchar        2     CK=Check
     PAY009          CCCode             Payment        PAY      varchar        6     AX=American Express, DC=Diners Club, etc
     PAY010          CCNum              Payment        PAY      varchar       40     Card number no spaces
                                                                                     Month and year of expiration i.e.. 0301 for March 2001
     PAY011           CCExp             Payment        PAY      varchar       10
                                                                                     approval code assigned by the credit card company
     PAY012      CCApprovalCode         Payment         PAY     varchar       10
     PAY013        CurrCode             Payment         PAY     varchar        3     3 letter ISO code of local currency
     PAY014       PaymentAmt            Payment         PAY      money               amount of payment for this form of payment
     RANK            RANK                NONE          NONE     Numeric       5      Rank
                                                                                     All connections - destination city code is the airport
     SDEST001        CityCode             City        SDEST     varchar       3      name to be used with point to point flights.
                                                                                     All connections destination type code identifies the
                                                                                     method of travel either Air or Rail travel. "A" = Air , "R"
                                                                                     = Rail to be used for flights/trains when the 4hour
                                                                                     domestic/ 6 hour international layover rule applies.
     SDEST002       TypeCode              City        SDEST     varchar       1
                                                                                     All connection segment destination name city name in
     SDEST003        CityName             City        SDEST     varchar       30     full to be used with point to point flights.
                                                                                     All connections - Destination airport name is the airport
     SDEST004      AirportName            City        SDEST     varchar       30     name to be used with point to point flights.
                                                                                     All connections - destination Region code is the region
                                                                                     code to be used with point to point flights. .
     SDEST005       RegionCode            City        SDEST     varchar       3




                                                           11 of 18
Version 5.03                                      TravelMan Data Dictionary



     Field #        Field Name       Database Table    Alias   Field Type   Length                           Description
                                                                                     All connections destination Region name is the region
     SDEST006      RegionName             City        SDEST     varchar       30     name to be used with point to point flights.
                                                                                     All connections - Destination state/province code is the
                                                                                     state/province code to be used with point to point
     SDEST007    StateProvinceCode        City        SDEST     varchar       5      flights.
                                                                                     Market city pairs - all connections destination Country
                                                                                     code is to be used with true origin and destination
     SDEST008      CountryCode            City        SDEST     varchar       5      flights.
                                                                                     All connections - Destination LATITUDE is the latitude
     SDEST009         Latitude            City        SDEST     Numeric       12     to be used with point to point flights.
                                                                                     All connections - Destination LONGITUDE is the
     SDEST010        Longitude            City        SDEST     Numeric       12     longitude to be used with point to point flights.
                                                                                     All connections - Destination time zone difference is the
                                                                                     Time Zone Diff to be used with point to point flights.
     SDEST011      TimeZoneDiff           City        SDEST     Numeric       12
                                                                                     Market city pairs - all connections destination city code
                                                                                     is to be used with true origin and destination flights.
     SMDEST001       CityCode             City        SMDEST    varchar       3
                                                                                     Market city pairs - all connections - destination Type
                                                                                     code identifies the method of travel either Air or Rail
                                                                                     travel. "A" = Air , "R" = Rail to be used for flights/trains .
     SMDEST002      TypeCode              City        SMDEST    varchar       1
                                                                                     Market city pairs - all connections destination city name
                                                                                     is to be used with true origin and destination flights.
     SMDEST003       CityName             City        SMDEST    varchar       30
                                                                                     Market city pairs - all connections destination airport
                                                                                     name is to be used with true origin and destination
     SMDEST004     AirportName            City        SMDEST    varchar       30     flights.
                                                                                     Market city pairs - All Connections - Destination Region
                                                                                     code. This is the Region code to be used with true
     SMDEST005      RegionCode            City        SMDEST    varchar       3      origin and destination flights.
                                                                                     Market city pairs - All connections - Origin Region
                                                                                     name. This is the Region name to be used with true
     SMDEST006     RegionName             City        SMDEST    varchar       30     origin and destination flights.
                                                                                     Market city pairs - all connections destination
                                                                                     state/province code.This is to be used with true origin
     SMDEST007   StateProvinceCode        City        SMDEST    varchar       5      and destination flights.
                                                                                     All connections Market city pairs Origin Country code.
                                                                                     To be used with true origin and destion flights
     SMDEST008     CountryCode            City        SMDEST    varchar       5
                                                                                     Market city pairs - all connections destination
                                                                                     LATITUDE.This is to be used with true origin and
     SMDEST009        Latitude            City        SMDEST    Numeric       12     destination flights.
                                                                                     Market city pairs - all connections destination
                                                                                     LONGITUDE.This is to be used with true origin and
     SMDEST010       Longitude            City        SMDEST    Numeric       12     destination flights.
                                                                                     Market city pairs - all connections destination Time
                                                                                     Zone Diff.This is to be used with true origin and
     SMDEST011     TimeZoneDiff           City        SMDEST    Numeric       12     destination flights.
                                                                                     All connections Market city pairs Origin city code. To be
     SMORIG001       CityCode             City        SMORIG    varchar       3      used with true origin and destion flights
                                                                                     No connections - Minute Rule destination Type code.
                                                                                     This code identifies the method of travel either Air or
                                                                                     Rail travel. "A" = Air , "R" = Rail to be used for
                                                                                     flights/trains when the 4hour domestic/ 6 hour
     SMORIG002      TypeCode              City        SMORIG    varchar       1      international layover rule applies.
                                                                                     All connections Market city pairs Origin city name. To
     SMORIG003       CityName             City        SMORIG    varchar       30     be used with true origin and destion flights.
                                                                                     All connections Market city pairs Origin Airport Name.
                                                                                     To be used with true origin and destion flights
     SMORIG004     AirportName            City        SMORIG    varchar       30
                                                                                     Market city pairs - All connections - Origin Region code.
                                                                                     This is the Region code to be used with point to point
     SMORIG005      RegionCode            City        SMORIG    varchar       3      flights.
                                                                                     Market city pairs - All connections - Origin Region
                                                                                     name. This is the Region name to be used with point
     SMORIG006     RegionName             City        SMORIG    varchar       30     to point flights.
                                                                                     All connections Market city pairs Origin state/province
                                                                                     code. To be used with true origin and destion flights
     SMORIG007   StateProvinceCode        City        SMORIG    varchar       5
                                                                                     Market city pairs - All connections - Destination Country
     SMORIG008     CountryCode            City        SMORIG    varchar       5      code. To be used with point to point flights.




                                                           12 of 18
Version 5.03                                         TravelMan Data Dictionary



     Field #         Field Name         Database Table    Alias     Field Type   Length                          Description
                                                                                          All connections Market city pairs Origin LATITUDE. To
     SMORIG009          Latitude             City        SMORIG      Numeric       12     be used with true origin and destion flights
                                                                                          All connections Market city pairs Origin LONGITUDE.
     SMORIG010         Longitude             City        SMORIG      Numeric       12     To be used with true origin and destion flights
                                                                                          All connections Market city pairs Origin Time Zone Diff.
     SMORIG011       TimeZoneDiff            City        SMORIG      Numeric       12     To be used with true origin and destion flights
                                                                                          Record key is a unique code assigned by the system
                                                                                          when the data is being imported. It is used to link
                                                                                          together various tables such as tickets to airseg, car
     TS001            RecordKey            Transeg         TS        varchar       50     and hotel.
     TS002             IataNum             Transeg         TS        varchar       8      IATA number is the main IATA number for agency.
                                                                                          This sequence number links together the invoice detail
     TS003             SeqNum              Transeg         TS        SmallInt             records
                                                                                          Air Segment identifies the specific order of the air
     TS004          SegmentNum             Transeg         TS        smallint             segment in PNR
                                                                                          Air segment type code. This code identifies the method
                                                                                          of travel either Air or Rail travel. "A" = Air , "R" = Rail .
     TS005            TypeCode             Transeg         TS        varchar       1
                                                                                          DK number or DK number plus Branch number
     TS006            ClientCode           Transeg         TS        varchar       15     depending on customer
                                                                                          Invoice date is the date the record was invoiced into the
     TS007            InvoiceDate          Transeg         TS       Date Time             back office.
                                                                                          Issue date is the date the record was issued (should be
     TS008            IssueDate            Transeg         TS       Date Time             equal to or prior to Invoice date)
                                                                                          Air segment Origin city code is a 3 digit origin city code.
     TS009          OriginCityCode         Transeg         TS        varchar       3
                                                                                          Air segment carrier code is a standard 2 letter airline
     TS010       SegmentCarrierCode        Transeg         TS        varchar       3      code
                                                                                          Air segment carrier name is the airline name for the
     TS011       SegmentCarrierName        Transeg         TS        varchar       40     segment
                                                                                          Used to identify when the airline that operates the flight
     TS012       CodeShareCarrierCode      Transeg         TS        varchar        3     is different from the carrier code
     TS013          EquipmentCode          Transeg         TS        varchar       10     Type of equipment ie: 737, MD80
     TS014            PrefAirInd           Transeg         TS        varchar        1     User Defined
                                                                                          Air segment departure date is the departure date for
     TS015          DepartureDate          Transeg         TS       Date Time             the segment
                                                                                          Air segment departure time is the departure time for
     TS016          DepartureTime          Transeg         TS        varchar       5      the segment
                                                                                          Air segment Flight number identifies the flight number
     TS017            FlightNum            Transeg         TS        varchar       6      used on the flight segment
                                                                                          Air segment Class of service identifies the class
     TS018          ClassOfService         Transeg         TS        varchar        2     service code used on the flight segment
     TS019             FareBasis           Transeg         TS        varchar       30     Fare basis code defined by carrier
                                                                                          Air segment ticket designator identifies the class of
                                                                                          service (COS) code used on the flight segment or
     TS020          TktDesignator          Transeg         TS        varchar       15     contract (CON) code.
                                                                                          Connection indicator is a single letter code of either "X"
                                                                                          or "O" for connection or stopever indicator derived from
     TS021           ConnectionInd         Transeg         TS        varchar       1      ticket
     TS022          StopOverTime           Transeg         TS        smallint             Stop over time is the length of stopover
     TS023         FrequentFlyerNum        Transeg         TS         varchar      15     Frequent Flyer program number.
     TS024       FrequentFlyerMileage      Transeg         TS          float              FF Mileage
     TS025             CurrCode            Transeg         TS        varchar       3      3 letter ISO code for currency of segment value
     TS026        SEGDestCityCode          Transeg         TS        varchar       3      Segment specific 3 letter destination city code
                                                                                          Segment specific Domestic/International indicator. A
                                                                                          single letter of either "D" or "I" which identifies the
                                                                                          location of rental as either Domestic or International.
     TS027        SEGInternationalInd      Transeg         TS        varchar       1
                                                                                          Segment arrival date is the specific arrival time for the
     TS028         SEGArrivalDate          Transeg         TS       Date Time             segment.
                                                                                          Segment arrival time is the specific arrival date for the
     TS029         SEGArrivalTime          Transeg         TS        varchar       5      segment.
                                                                                          Segment segment value that comes through from
     TS030        SEGSegmentValue          Transeg         TS        money                PNR to Back Office also known as leg fare
     TS031       SEGSegmentMileage         Transeg         TS         Int                 Segment segment specific mileage
                                                                                          Segment total mileage is the cumulative segment
     TS032         SEGTotalMileage         Transeg         TS          Int                mileage for ticket
     TS033          SEGFlightTime          Transeg         TS        smallint             Segment flight time is the length of the flight
                                                                                          All connections Market city pairs Origin City Code. To
     TS034       SEGMktOrigCityCode        Transeg         TS        varchar       3      be used with true origin and destination flights.
                                                                                          Market city pairs - all connections destination city code
                                                                                          is to be used with true origin and destination flights.
     TS035       SEGMktDestCityCode        Transeg         TS        varchar       3




                                                                13 of 18
Version 5.03                                       TravelMan Data Dictionary



     Field #       Field Name         Database Table    Alias     Field Type   Length                         Description
     TS036        SEGReturnInd           Transeg         TS        smallint             Specifies if a segment is a return trip segment.
                                                                                        No connection (NOX) Destination city code to be used
     TS037      NOXDestCityCode          Transeg         TS        varchar       3      with point to point flights.
                                                                                        No connection specific Domestic/International indicator.
                                                                                        A single letter of either "D" or "I" which identifies the
                                                                                        location of rental as either Domestic or International.
     TS038     NOXInternationalInd       Transeg         TS        varchar       1
                                                                                        No Connection Specific Arrival Date - Arrival date of
     TS039       NOXArrivalDate          Transeg         TS       Date Time             the no connection segment.
                                                                                        No Connection Specific Arrival Time - Arrival time of
     TS040       NOXArrivalTime          Transeg         TS        varchar       5      the no connection segment.
                                                                                        No Connection Specific Segment Value - Segment
     TS041      NOXSegmentValue          Transeg         TS        money                value of the no connection segment.
                                                                                        No Connection Specific Segment Value - Segment
     TS042     NOXSegmentMileage         Transeg         TS          Int                value of the no connection segment.
                                                                                        No Connection Total Mileage - Cummulative mileage
     TS043       NOXTotalMileage         Transeg         TS          Int                of all segments.
                                                                                        No Connection Specific Flight Time - Segment flight
     TS044       NOXFlightTime           Transeg         TS        smallint             time of the no connection segment.
                                                                                        No connection Market city pair Origin city code. To be
     TS045     NOXMktOrigCityCode        Transeg         TS        varchar       3      used with true origin and destination flights.
                                                                                        No connection Market city pair Destination city code.
                                                                                        To be used with true origin and destination flights.
     TS046     NOXMktDestCityCode        Transeg         TS        varchar        3
     TS047     NOXConnectionString       Transeg         TS        varchar       19     The connecting city code.
     TS048       NOXReturnInd            Transeg         TS        smallint             Indicates a return segment.
                                                                                        Minute Rule - no connection- destination city code to be
                                                                                        used with true origin and destination flights when the
                                                                                        4hour domestic/ 6 hour international layover rule
     TS049      MINDestCityCode          Transeg         TS        varchar       3      applies.
                                                                                        Minute Rule specific Domestic/International indicator.
     TS050      MINInternationalInd      Transeg         TS        varchar       1
                                                                                        Minute Rule Specific Arrival Date - Specifies the
                                                                                        segment arrival date. Used with true origin and
                                                                                        destination flights when the 4hour domestic/ 6 hour
     TS051        MINArrivalDate         Transeg         TS       Date Time             international layover rule applies.
                                                                                        Minute Rule Specific Arrival Time - Specifies the
                                                                                        segment arrival time. Used with true origin and
                                                                                        destination flights when the 4hour domestic/ 6 hour
     TS052       MINArrivalTime          Transeg         TS        varchar       5      international layover rule applies.
                                                                                        Minute Rule Specific Segment Value - Specifies the
                                                                                        segment value. Used with true origin and destination
                                                                                        flights when the 4hour domestic/ 6 hour international
     TS053      MINSegmentValue          Transeg         TS        money                layover rule applies.
                                                                                        Minute Rule Specific Segment Mileage - Specifies the
                                                                                        segment mileage. Used with true origin and destination
                                                                                        flights when the 4hour domestic/ 6 hour international
     TS054     MINSegmentMileage         Transeg         TS          Int                layover rule applies.
                                                                                        Minute Rule Specific Total Mileage - Specifies the total
                                                                                        mileage of all segments. Used with true origin and
                                                                                        destination flights when the 4hour domestic/ 6 hour
                                                                                        international layover rule applies.
     TS055       MINTotalMileage         Transeg         TS          Int
                                                                                        Minute Rule Specific Flight Time - Specifies the
                                                                                        segment flight time. Used with true origin and
                                                                                        destination flights when the 4hour domestic/ 6 hour
     TS056        MINFlightTime          Transeg         TS        smallint             international layover rule applies.
                                                                                        Market city pairs - Minute Rule no connections origin
                                                                                        city code is the standard 3 letter city code to be used
                                                                                        with true origin and destination flights when the 4hour
                                                                                        domestic/ 6 hour international layover rule applies.
     TS057     MINMktOrigCityCode        Transeg         TS        varchar       3
                                                                                        Market city pairs - Minute Rule no connections
                                                                                        destination city code is the standard 3 letter city code to
     TS058     MINMktDestCityCode        Transeg         TS        varchar       3      be used with true origin and destination flights when the
                                                                                        Minutedomestic/ 6 hour international layoveris a single
                                                                                        4hour Rule Specific - Connection indicator rule
                                                                                        letter code of either "X" or "O" for connection or
                                                                                        stopever indicator derived from ticket.
     TS059     MINConnectionString       Transeg         TS        varchar       19
     TS060        MINReturnInd           Transeg         TS        smallint             Indicates a return segment.
     TS061          MealCode             Transeg         TS         varchar      4      Meal code
     TS062          YieldInd             Transeg         TS        varchar       1      Used with ProfitMan
     TS063          YieldAmt             Transeg         TS          float              Used with ProfitMan




                                                              14 of 18
Version 5.03                                  TravelMan Data Dictionary



     Field #     Field Name      Database Table    Alias     Field Type     Length                         Description
     TS064     YieldDatePosted      Transeg         TS       Date Time               Used with ProfitMan
                                                                                     Record key is a unique code assigned by the system
                                                                                     when the data is being imported. It is used to link
                                                                                     together various tables such as tickets to airseg, car
     TX001       RecordKey            Tax           TX        varchar         50     and hotel.
     TX002        IataNum             Tax           TX        varchar         8      IATA number is the main IATA number for agency.
                                                                                     Primary Key - used to tie record with other detail
     TX003        SeqNum              Tax           TX        smallInt               records
                                                                                     Primary Key Ties multiple taxes for a given invoice line
     TX004       TaxSeqNum            Tax           TX        smallint               item
     TX005        ClientCode          Tax           TX        varchar         15     Account Number
                                                                                     Invoice date is the date the record was invoiced into the
     TX006       InvoiceDate          Tax           TX       Date Time               back office.
                                                                                     Issue date is the date the record was issued (should be
     TX007        IssueDate           Tax           TX       Date Time               equal to or prior to Invoice date)
     TX008          TaxId             Tax           TX        varchar         10     YC, XT, XF, US, etc
     TX009         TaxAmt             Tax           TX        money                  amount of tax
     TX010        CurrCode            Tax           TX        varchar         3      3 letter ISO code of local currency
                                                                                     Record key is a unique code assigned by the system
                                                                                     when the data is being imported. It is used to link
                                                                                     together various tables such as tickets to airseg, car
     UD01001     RecordKey            Udef         UD01       varchar         50     and hotel.
                                                                                     IATA number is the main IATA number for agency.
     UD01002      IataNum             Udef         UD01       varchar         8
                                                                                     This sequence number links together the invoice detail
     UD01003      SeqNum              Udef         UD01       SmallInt               records
                                                                                     DK number or DK number plus Branch number
     UD01004     ClientCode           Udef         UD01       varchar         15     depending on customer
                                                                                     Invoice date is the date the record was invoiced into the
     UD01005     InvoiceDate          Udef         UD01      Date Time               back office.
                                                                                     Issue date is the date the record was issued (should be
     UD01006      IssueDate           Udef         UD01      Date Time               equal to or prior to Invoice date)
     UD01007       UdefNum            Udef         UD01     Short Integer     5                                   1
     UD01008      UdefType            Udef         UD01       varchar         1      Type of udid
                                                                                     Udef data is the value found in the UDDID/SORT or
     UD01009      UdefData            Udef         UD01       varchar        255     GOVT remark field.
                                                                                     Record key is a unique code assigned by the system
                                                                                     when the data is being imported. It is used to link
                                                                                     together various tables such as tickets to airseg, car
     UD02001     RecordKey            Udef         UD02       varchar         50     and hotel.
     UD02002      IataNum             Udef         UD02       varchar         8      IATA number is the main IATA number for agency.
                                                                                     This sequence number links together the invoice detail
     UD02003      SeqNum              Udef         UD02       SmallInt               records
                                                                                     DK number or DK number plus Branch number
     UD02004     ClientCode           Udef         UD02       varchar         15     depending on customer
                                                                                     Invoice date is the date the record was invoiced into the
     UD02005     InvoiceDate          Udef         UD02      Date Time               back office.
                                                                                     Issue date is the date the record was issued (should be
     UD02006      IssueDate           Udef         UD02      Date Time               equal to or prior to Invoice date)
     UD02007      UdefNum             Udef         UD02     Short Integer     5                                   2
     UD02008      UdefType            Udef         UD02       varchar         1      Type of udid
                                                                                     Udef data is the value found in the UDDID/SORT or
     UD02009      UdefData            Udef         UD02       varchar        255     GOVT remark field.
                                                                                     Record key is a unique code assigned by the system
                                                                                     when the data is being imported. It is used to link
                                                                                     together various tables such as tickets to airseg, car
     UD03001     RecordKey            Udef         UD03       varchar         50     and hotel.
     UD03002      IataNum             Udef         UD03       varchar         8      IATA number is the main IATA number for agency.
                                                                                     This sequence number links together the invoice detail
     UD03003      SeqNum              Udef         UD03       SmallInt               records
     UD03004     ClientCode           Udef         UD03       varchar         15     DK number or DK number plus Branch number
                                                                                     depending on the date
                                                                                     Invoice date iscustomer the record was invoiced into the
     UD03005     InvoiceDate          Udef         UD03      Date Time               back office.
                                                                                     Issue date is the date the record was issued (should be
     UD03006      IssueDate           Udef         UD03      Date Time               equal to or prior to Invoice date)
     UD03007       UdefNum            Udef         UD03     Short Integer     5                                   3
     UD03008      UdefType            Udef         UD03       varchar         1      Type of udid
                                                                                     Udef data is the value found in the UDDID/SORT or
     UD03009      UdefData            Udef         UD03       varchar        255     GOVT remark field.
                                                                                     Record key is a unique code assigned by the system
                                                                                     when the data is being imported. It is used to link
                                                                                     together various tables such as tickets to airseg, car
     UD04001     RecordKey            Udef         UD04       varchar         50     and hotel.




                                                         15 of 18
Version 5.03                              TravelMan Data Dictionary



     Field #   Field Name    Database Table    Alias   Field Type      Length                         Description
     UD04002    IataNum           Udef         UD04      varchar         8      IATA number is the main IATA number for agency.
                                                                                This sequence number links together the invoice detail
     UD04003    SeqNum            Udef         UD04      SmallInt               records
                                                                                DK number or DK number plus Branch number
     UD04004   ClientCode         Udef         UD04      varchar         15     depending on customer
                                                                                Invoice date is the date the record was invoiced into the
     UD04005   InvoiceDate        Udef         UD04     Date Time               back office.
                                                                                Issue date is the date the record was issued (should be
     UD04006   IssueDate          Udef         UD04     Date Time               equal to or prior to Invoice date)
     UD04007    UdefNum           Udef         UD04    Short Integer     5                                   4
     UD04008   UdefType           Udef         UD04      varchar         1      Type of udid
                                                                                Udef data is the value found in the UDDID/SORT or
     UD04009    UdefData          Udef         UD04      varchar        255     GOVT remark field.
                                                                                Record key is a unique code assigned by the system
                                                                                when the data is being imported. It is used to link
                                                                                together various tables such as tickets to airseg, car
     UD05001   RecordKey          Udef         UD05      varchar         50     and hotel.
     UD05002    IataNum           Udef         UD05      varchar         8      IATA number is the main IATA number for agency.
                                                                                This sequence number links together the invoice detail
     UD05003    SeqNum            Udef         UD05      SmallInt               records
                                                                                DK number or DK number plus Branch number
     UD05004   ClientCode         Udef         UD05      varchar         15     depending on customer
                                                                                Invoice date is the date the record was invoiced into the
     UD05005   InvoiceDate        Udef         UD05     Date Time               back office.
                                                                                Issue date is the date the record was issued (should be
     UD05006   IssueDate          Udef         UD05     Date Time               equal to or prior to Invoice date)
     UD05007    UdefNum           Udef         UD05    Short Integer     5                                   5
     UD05008    UdefType          Udef         UD05      varchar         1      Type of udid
                                                                                Udef data is the value found in the UDDID/SORT or
     UD05009    UdefData          Udef         UD05      varchar        255     GOVT remark field.
                                                                                Record key is a unique code assigned by the system
                                                                                when the data is being imported. It is used to link
                                                                                together various tables such as tickets to airseg, car
     UD06001   RecordKey          Udef         UD06      varchar         50     and hotel.
     UD06002    IataNum           Udef         UD06      varchar          8     IATA number is the main IATA number for agency.
                                                                                This sequence number links together the invoice detail
     UD06003    SeqNum            Udef         UD06      SmallInt               records
     UD06004   ClientCode         Udef         UD06      varchar         15     DK number or DK number plus Branch number
                                                                                Invoice date is the date the record was invoiced into the
     UD06005   InvoiceDate        Udef         UD06     Date Time               back office.
                                                                                Issue date is the date the record was issued (should be
     UD06006   IssueDate          Udef         UD06     Date Time               equal to or prior to Invoice date)
     UD06007    UdefNum           Udef         UD06    Short Integer     5                                   6
     UD06008   UdefType           Udef         UD06      varchar         1      Type of udid
                                                                                Udef data is the value found in the UDDID/SORT or
     UD06009    UdefData          Udef         UD06      varchar        255     GOVT remark field.
                                                                                Record key is a unique code assigned by the system
                                                                                when the data is being imported. It is used to link
     UD07001   RecordKey          Udef         UD07      varchar         50     together various tables such as tickets to airseg, car
                                                                                and hotel.
     UD07002    IataNum           Udef         UD07      varchar          8     IATA number is the main IATA number for agency.
                                                                                This sequence number links together the invoice detail
     UD07003    SeqNum            Udef         UD07      SmallInt               records
                                                                                DK number or DK number plus Branch number
     UD07004   ClientCode         Udef         UD07      varchar         15     depending on customer
                                                                                Invoice date is the date the record was invoiced into the
     UD07005   InvoiceDate        Udef         UD07     Date Time               back office.
                                                                                Issue date is the date the record was issued (should be
     UD07006   IssueDate          Udef         UD07     Date Time               equal to or prior to Invoice date)
     UD07007    UdefNum           Udef         UD07    Short Integer     5                                   7
     UD07008   UdefType           Udef         UD07      varchar         1      Type of udid
                                                                                Udef data is the value found in the UDDID/SORT or
     UD07009    UdefData          Udef         UD07      varchar        255     GOVT remark field.
                                                                                Record key is a unique code assigned by the system
                                                                                when the data is being imported. It is used to link
                                                                                together various tables such as tickets to airseg, car
     UD08001   RecordKey          Udef         UD08      varchar         50     and hotel.
     UD08002    IataNum           Udef         UD08      varchar         8      IATA number is the main IATA number for agency.
                                                                                This sequence number links together the invoice detail
     UD08003    SeqNum            Udef         UD08      SmallInt               records
                                                                                DK number or DK number plus Branch number
     UD08004   ClientCode         Udef         UD08      varchar         15     depending on customer
                                                                                Invoice date is the date the record was invoiced into the
     UD08005   InvoiceDate        Udef         UD08     Date Time               back office.




                                                   16 of 18
Version 5.03                                      TravelMan Data Dictionary



     Field #        Field Name       Database Table    Alias   Field Type      Length                          Description
                                                                                        Issue date is the date the record was issued (should be
     UD08006         IssueDate            Udef         UD08     Date Time               equal to or prior to Invoice date)
     UD08007          UdefNum             Udef         UD08    Short Integer     5                                   8
     UD08008         UdefType             Udef         UD08      varchar         1      Type of udid
                                                                                        Udef data is the value found in the UDDID/SORT or
     UD08009         UdefData             Udef         UD08      varchar        255     GOVT remark field.
                                                                                        Record key is a unique code assigned by the system
                                                                                        when the data is being imported. It is used to link
                                                                                        together various tables such as tickets to airseg, car
     UD09001        RecordKey             Udef         UD09      varchar         50     and hotel.
     UD09002         IataNum              Udef         UD09      varchar          8     IATA number is the main IATA number for agency.
                                                                                        This sequence number links together the invoice detail
     UD09003         SeqNum               Udef         UD09      SmallInt               records
                                                                                        DK number or DK number plus Branch number
     UD09004        ClientCode            Udef         UD09      varchar         15     depending on customer
                                                                                        Invoice date is the date the record was invoiced into the
     UD09005        InvoiceDate           Udef         UD09     Date Time               back office.
                                                                                        Issue date is the date the record was issued (should be
     UD09006         IssueDate            Udef         UD09     Date Time               equal to or prior to Invoice date)
     UD09007          UdefNum             Udef         UD09    Short Integer     5                                   9
     UD09008         UdefType             Udef         UD09      varchar         1      Type of udid
                                                                                        Udef data is the value found in the UDDID/SORT or
     UD09009         UdefData             Udef         UD09      varchar        255     GOVT remark field.
                                                                                        Record key is a unique code assigned by the system
                                                                                        when the data is being imported. It is used to link
                                                                                        together various tables such as tickets to airseg, car
     UDEF001        RecordKey             Udef         UDEF      varchar         50     and hotel.
     UDEF002         IataNum              Udef         UDEF      varchar          8     IATA number is the main IATA number for agency.
                                                                                        This sequence number links together the invoice detail
     UDEF003         SeqNum               Udef         UDEF      SmallInt               records
                                                                                        DK number or DK number plus Branch number
     UDEF004        ClientCode            Udef         UDEF      varchar         15     depending on customer
                                                                                        Invoice date is the date the record was invoiced into the
     UDEF005        InvoiceDate           Udef         UDEF     Date Time               back office.
                                                                                        Issue date is the date the record was issued (should be
     UDEF006         IssueDate            Udef         UDEF     Date Time               equal to or prior to Invoice date)
                                                                                        UDID definitions. UDEFNUM now can extend through
     UDEF007         UdefNum              Udef         UDEF    Short Integer     5      number 99
     UDEF008         UdefType             Udef         UDEF      varchar         1      Type of udid
                                                                                        Udef data is the value found in the UDDID/SORT or
     UDEF009         UdefData             Udef         UDEF      varchar        255     GOVT remark field.
                                                                                        No connection (NOX) Destination city code to be used
     XDEST001        CityCode             City        XDEST      varchar         3      with point to point flights.
                                                                                        No connections NOX destination type code identifies
                                                                                        the method of travel either Air or Rail travel. "A" = Air ,
                                                                                        "R" = Rail to be used for flights/trains.
     XDEST002       TypeCode              City        XDEST      varchar         1
                                                                                        No connection (NOX) Destination City Name. To be
     XDEST003        CityName             City        XDEST      varchar         30     used with point to point flights.
                                                                                        No connection (NOX) Destination Airport Name. To be
     XDEST004      AirportName            City        XDEST      varchar         30     used with point to point flights.
                                                                                        No connection (NOX) - Destination Region code. This
                                                                                        is the Region code to be used with point to point flights.
     XDEST005       RegionCode            City        XDEST      varchar         3
                                                                                        No connection (NOX) - Destination Region name. This
                                                                                        is the Region name to be used with point to point
     XDEST006      RegionName             City        XDEST      varchar         30     flights.
                                                                                        No connection (NOX) Destination state/province code.
     XDEST007    StateProvinceCode        City        XDEST      varchar         5      To be used with point to point flights.
                                                                                        No connection Market city pair Destination Country
     XDEST008      CountryCode            City        XDEST      varchar         5      code. To be used with point to point flights.
                                                                                        No connection (NOX) Destination LATITUDE. To be
     XDEST009         Latitude            City        XDEST      Numeric         12     used with point to point flights.
                                                                                        No connection (NOX) Destination LONGITUDE. To be
     XDEST010        Longitude            City        XDEST      Numeric         12     used with point to point flights.
                                                                                        No connection (NOX) Destination Time Zone Diff. to
     XDEST011      TimeZoneDiff           City        XDEST      Numeric         12     be used with point to point flights.
                                                                                        No connection Market city pair Destination city code.
     XMDEST001       CityCode             City        XMDEST     varchar         3      To be used with point to point flights.
                                                                                        No connections - Market destination Type code. This
                                                                                        code identifies the method of travel either Air or Rail
     XMDEST002      TypeCode              City        XMDEST     varchar         1      travel. "A" = Air , "R" = Rail.




                                                           17 of 18
Version 5.03                                      TravelMan Data Dictionary



     Field #        Field Name       Database Table    Alias   Field Type   Length                          Description
                                                                                     No connection Market city pair Destination city name.
     XMDEST003       CityName             City        XMDEST    varchar       30     To be used with point to point flights.
                                                                                     No connection Market city pair Destination Airport
     XMDEST004     AirportName            City        XMDEST    varchar       30     Name. To be used with point to point flights.
                                                                                     No Connection - Market city pairs - no connection
                                                                                     destination Region code.This is to be used with true
     XMDEST005      RegionCode            City        XMDEST    varchar       3      origin and destination flights.
                                                                                     No Connection - Market city pairs - No connection
     XMDEST006     RegionName             City        XMDEST    varchar       30     destination Region name.This is to be used with true
                                                                                     No connection Market city pair Destination
                                                                                     state/province code. To be used with point to point
     XMDEST007   StateProvinceCode        City        XMDEST    varchar       5      flights.
                                                                                     No connection Market city pair Origin Country code. To
     XMDEST008     CountryCode            City        XMDEST    varchar       5      be used with true origin and destination flights.
                                                                                     No connection Market city pair Destination LATITUDE.
     XMDEST009        Latitude            City        XMDEST    Numeric       12     To be used with point to point flights.
                                                                                     No connection Market city pair Destination
     XMDEST010       Longitude            City        XMDEST    Numeric       12     LONGITUDE. To be used with point to point flights.
                                                                                     No connection Market city pair Destination Time Zone
     XMDEST011     TimeZoneDiff           City        XMDEST    Numeric       12     Diff. To be used with point to point flights.
                                                                                     No connection Market city pair Origin city code. To be
     XMORIG001       CityCode             City        XMORIG    varchar       3      used with true origin and destination flights.
                                                                                     No connections - Market Origin Type code. This code
                                                                                     identifies the method of travel either Air or Rail travel.
     XMORIG002      TypeCode              City        XMORIG    varchar       1      "A" = Air , "R" = Rail.
                                                                                     No connection Market city pair Origin city name. To be
     XMORIG003       CityName             City        XMORIG    varchar       30     used with true origin and destination flights.
                                                                                     No connection Market city pair Origin Airport Name. To
     XMORIG004     AirportName            City        XMORIG    varchar       30     be used with true origin and destination flights.
                                                                                     No Connection - Market city pairs - no connection origin
                                                                                     Region code.This is to be used with true origin and
     XMORIG005      RegionCode            City        XMORIG    varchar       3      destination flights.
                                                                                     No Connection - Market city pairs - No connection
                                                                                     origin Region name.This is to be used with true origin
     XMORIG006     RegionName             City        XMORIG    varchar       30     and destination flights.
                                                                                     No connection Market city pair Origin state/province
                                                                                     code. To be used with true origin and destination
     XMORIG007   StateProvinceCode        City        XMORIG    varchar       5      flights.
                                                                                     No connection Market city pair Origin Country code. To
     XMORIG008     CountryCode            City        XMORIG    varchar       5      be used with true origin and destination flights.
                                                                                     No connection Market city pair Origin LATITUDE. To
     XMORIG009        Latitude            City        XMORIG    Numeric       12     be used with true origin and destination flights.
                                                                                     No connection Market city pair Origin LONGITUDE. To
     XMORIG010       Longitude            City        XMORIG    Numeric       12     be used with true origin and destination flights.
                                                                                     No connection Market city pair Origin Time Zone Diff.
                                                                                     To be used with true origin and destination flights.
     XMORIG011     TimeZoneDiff           City        XMORIG    Numeric       12




                                                           18 of 18

								
To top