EX_AIRLINE_TKT2

(SQL Table)
Index Back

Expense Transactions

Used for SABRE/BTS Credit Card Feed. Credit Card Transactions are loaded into this table for expense sheet processing.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
2 TRANS_NBR Character(24) VARCHAR2(24) NOT NULL Transaction Number
3 CCTRANS_TYPE_CD Character(2) VARCHAR2(2) NOT NULL Credit Card Transaction Code
4 EXPENSE_TYPE Character(7) VARCHAR2(7) NOT NULL Expense Type
5 AIRFARE_RCPT_NBR Character(16) VARCHAR2(16) NOT NULL Airfare Receipt Number
6 AIR_TKT_RECON_STAT Character(1) VARCHAR2(1) NOT NULL Airline Ticket Reconciliation Status
C=Cancelled
N=Not Reconciled
R=Reconciled
7 MERCHANT Character(40) VARCHAR2(40) NOT NULL Merchant
8 TRANS_DT Date(10) DATE Transaction Date
9 TXN_CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Transaction Currency
10 TXN_AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Transaction Amount
11 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
12 MONETARY_AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Specifies the monetary amount of a debit or credit in the business unit base currency. Debit entries are positive and credit entries are negative. This amount is only zero if associated with a statistical account.
13 CITY Character(30) VARCHAR2(30) NOT NULL City
14 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country
15 CRDMEM_ACCT_NBR Character(44) VARCHAR2(44) NOT NULL Cardmember Number
16 MERCHANT_CD Character(10) VARCHAR2(10) NOT NULL Preferred Merchant