| CARRID |
Airline Code |
CHAR |
3 |
0 |
|
S_CARR_ID
|
|
| CONNID |
Flight Connection Number |
NUMC |
4 |
0 |
*
|
S_CONN_ID
|
|
| FLDATE |
Flight date |
DATS |
8 |
0 |
|
S_DATE
|
|
| SCOL_BOOKID |
Persistent Booking ID for Flight Example |
NUMC |
10 |
0 |
|
SCOL_BOOKID
|
|
| CUSTOMID |
Customer Number |
NUMC |
8 |
0 |
*
|
S_CUSTOMER
|
|
| CUSTTYPE |
Customer type |
CHAR |
1 |
0 |
|
S_CUSTTYPE
|
| B |
Business Customer |
| P |
Private Customer |
|
| SMOKER |
Smoker |
CHAR |
1 |
0 |
|
S_SMOKER
|
|
| LUGGWEIGHT |
Weight of Luggage |
QUAN |
8 |
4 |
|
S_LUGWEIGH
|
|
| WUNIT |
Weight Unit |
UNIT |
3 |
0 |
*
|
S_WEIUNIT
|
|
| INVOICE |
Invoice flag |
CHAR |
1 |
0 |
|
S_INVFLAG
|
|
| CLASS |
Flight Class |
CHAR |
1 |
0 |
|
S_CLASS
|
| C |
Business Class |
| F |
First Class |
| Y |
Economy Class |
|
| FORCURAM |
Booking price in foreign currency (dependent on location) |
CURR |
15 |
2 |
|
S_F_CUR_PR
|
|
| FORCURKEY |
Payment currency |
CUKY |
5 |
0 |
*
|
S_CURR
|
|
| LOCCURAM |
Price of booking in local currency of airline |
CURR |
15 |
2 |
|
S_L_CUR_PR
|
|
| LOCCURKEY |
Local currency of airline |
CUKY |
5 |
0 |
*
|
S_CURRCODE
|
|
| ORDER_DATE |
Booking Date |
DATS |
8 |
0 |
|
S_BDATE
|
|
| COUNTER |
Number of sales office |
NUMC |
8 |
0 |
*
|
S_COUNTNUM
|
|
| AGENCYNUM |
Travel Agency Number |
NUMC |
8 |
0 |
|
S_AGNCYNUM
|
|
| CANCELLED |
Cancelation flag |
CHAR |
1 |
0 |
|
S_CANCEL
|
|
Flight booked |
| X |
Booking canceled |
|
| RESERVED |
Reservation flag |
CHAR |
1 |
0 |
|
S_RESERV
|
|
| PASSNAME |
Name of the Passenger |
CHAR |
25 |
0 |
|
S_PASSNAME
|
|
| PASSFORM |
Form of address |
CHAR |
15 |
0 |
|
S_FORM
|
|
| PASSBIRTH |
Date of Birth of a Passenger |
DATS |
8 |
0 |
|
S_BIRTHDAT
|
|
| BOOKID |
Booking number |
NUMC |
8 |
0 |
|
S_BOOK_ID
|
|
| UPDATE_FLAG |
Character Field of Length 1 |
CHAR |
1 |
0 |
|
CHAR01
|
|
| ENQUEUE_STATE |
ESF Lock Mode |
CHAR |
2 |
0 |
|
SCOL_LOCKMODE
|
|
No Lock |
| PR |
Promotion to Exclusive |
| S |
"Shared" Lock |
| SP |
"Shared-Promotable" Lock |
| X |
Exclusive Lock |
|