EX_AIRLN_TKT_VW

(SQL View)
 Index Back

Expense Transactions

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

SELECT A.AIRFARE_RCPT_NBR , A.EMPLID , B.NAME , A.AIR_TKT_RECON_STAT , A.AIR_TKT_RECON_STAT , A.MERCHANT , A.TRAN_DATE , A.TRANS_DT , A.MONETARY_AMOUNT , A.CURRENCY_CD , A.CRDMEM_ACCT_NBR , A.SHEET_ID , A.LINE_NBR FROM PS_EX_AIRLINE_TKT A , PS_PERSONAL_DATA B WHERE A.EMPLID = B.EMPLID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 AIRFARE_RCPT_NBR Character(16) VARCHAR2(16) NOT NULL Airfare Receipt Number
2 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
3 NAME Character(50) VARCHAR2(50) NOT NULL Name
4 AIR_TKT_RECON_STAT Character(1) VARCHAR2(1) NOT NULL Airline Ticket Reconciliation Status
C=Cancelled
N=Not Reconciled
R=Reconciled
5 AIR_RCN_STAT_SAVE Character(1) VARCHAR2(1) NOT NULL Airline Ticket Reconciliation Status
C=Cancelled
N=Not Reconciled
R=Reconciled
6 MERCHANT Character(40) VARCHAR2(40) NOT NULL Merchant
7 TRAN_DATE Character(10) VARCHAR2(10) NOT NULL Transaction Date
8 TRANS_DT Date(10) DATE Transaction Date
9 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.
10 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
11 CRDMEM_ACCT_NBR Character(44) VARCHAR2(44) NOT NULL Cardmember Number
12 SHEET_ID Character(10) VARCHAR2(10) NOT NULL Report ID
13 LINE_NBR Number(5,0) INTEGER NOT NULL Line Number: 11/24/08 - Added TARGET label [PC product]