EX_TRANS_RC_VW(SQL View) |
Index Back |
|---|---|
EX_TRANS for Receipt CaptureThis view is used for Receipt Capture - Mobile PDA - Release 8.9 |
| SELECT EMPLID , DATA_SOURCE_EX , TRANS_NBR , SEQ_NBR FROM PS_EX_TRANS |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  EMPLID |
Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: PERSONAL_DATA |
| 2 | DATA_SOURCE_EX |
Character(3) | VARCHAR2(3) NOT NULL |
External Data Sources for PS Expenses
AIR=Airline Ticket AMA=American Express AMG=American Express AMH=American Express-Hotel Folio AMM=American Express - Member List AMX=American Express CNS=CONUS DC=Diners Club IPH=iReceipts MC=MasterCard CDFv2 MCX=MasterCard CDFv3 MSG=Text Message NAP=PS NA Payroll PDA=PDA RNZ=Runzheimer SAB=Sabre UBT=User Chatbot USB=US Bank USR=User Input VI4=Visa VIS=Visa |
| 3 | TRANS_NBR |
Character(24) | VARCHAR2(24) NOT NULL | Transaction Number |
| 4 | SEQ_NBR |
Number(15,0) | DECIMAL(15) NOT NULL | Sequence Number |