EX_AIRLINE_TKT2(SQL Table) |
Index Back |
---|---|
Expense TransactionsUsed 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 |