| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 TRIP_NUMID |
Number(18,0) |
DECIMAL(18) NOT NULL |
Trip Number
|
| 2 |
SEG_NUM |
Number(18,0) |
DECIMAL(18) NOT NULL |
Airline Flight Segment Number
|
| 3 |
CC_TRXID |
Number(18,0) |
DECIMAL(18) NOT NULL |
Used for the SABRE/BTS Data Feed/Import.
Unique number generated by SABRE BTS. Links rows to the Outbound Trip Data Table.
|
| 4 |
EXPENSE_TYPE |
Character(7) |
VARCHAR2(7) NOT NULL |
Expense Type
|
| 5 |
EXPENSE_DATE |
Character(10) |
VARCHAR2(10) NOT NULL |
Credit Card Expense Date
|
| 6 |
AIRPORT_CODE |
Character(6) |
VARCHAR2(6) NOT NULL |
Airport Code
|
| 7 |
ARVL_AIRPORT_CODE |
Character(6) |
VARCHAR2(6) NOT NULL |
Arival Airport Code
|
| 8 |
CNXTN_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Indicates Connecting Flight
|
| 9 |
TKT_NUM |
Character(20) |
VARCHAR2(20) NOT NULL |
Ticket Number
|
| 10 |
ORIG_TKT_NUM |
Character(20) |
VARCHAR2(20) NOT NULL |
Ticket Number
|
| 11 |
COS_CODE |
Character(6) |
VARCHAR2(6) NOT NULL |
Airline Class of service Code
|
| 12 |
VENDOR_CODE |
Character(6) |
VARCHAR2(6) NOT NULL |
Vendor Code from Credit Card Feed
|
| 13 |
SABRE_PROP_XID |
Character(7) |
VARCHAR2(7) NOT NULL |
SABRE Property XID
|
| 14 |
PROPERTY_NAME |
Character(50) |
VARCHAR2(50) NOT NULL |
Property Name
|
| 15 |
FOP_CODE |
Character(6) |
VARCHAR2(6) NOT NULL |
FOP Code
|
| 16 |
CURR_CODE |
Character(6) |
VARCHAR2(6) NOT NULL |
Credit Card Currency Code
|
| 17 |
COST |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Total Cost
|
| 18 |
TAX |
Number(27,3) |
DECIMAL(26,3) NOT NULL |
Tax
|