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