EMPLIDAIRFARE_RCPT_NBRTRANS_DTC=Cancelled
N=Not Reconciled
R=Reconciled
EX_EMP_AIR_TKT(SQL View) |
Index Back |
|---|
| SELECT DISTINCT A.EMPLID , A.AIRFARE_RCPT_NBR , A.TRANS_DT , A.AIR_TKT_RECON_STAT , A.DAYS_OUTSTANDING , A.MERCHANT , A.TRANS_NBR , A.MONETARY_AMOUNT , A.CURRENCY_CD FROM PS_EX_TRANS A , PS_EX_TYPES_TBL B WHERE A.AIR_TKT_RECON_STAT IN ('N','O','C') AND A.EXPENSE_TYPE=B.EXPENSE_TYPE AND B.EXPENSE_TYPE_EDIT='AIR' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 2 | AIRFARE_RCPT_NBR |
Character(16) | VARCHAR2(16) NOT NULL | Airfare Receipt Number |
| 3 | TRANS_DT |
Date(10) | DATE | Transaction Date |
| 4 | AIR_TKT_RECON_STAT | Character(1) | VARCHAR2(1) NOT NULL |
Airline Ticket Reconciliation Status
C=Cancelled N=Not Reconciled R=Reconciled |
| 5 | DAYS_OUTSTANDING | Number(4,0) | SMALLINT NOT NULL | Days Outstanding |
| 6 | MERCHANT | Character(40) | VARCHAR2(40) NOT NULL | Merchant |
| 7 | TRANS_NBR | Character(24) | VARCHAR2(24) NOT NULL | Transaction Number |
| 8 | 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. |
| 9 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |