EX_CCRD_FILE_VW(SQL View) |
Index Back |
|---|---|
Credit Card Load FileTable to hold data for Credit Card Load of files. |
| SELECT PROCESS_INSTANCE , EX_FILE_NAME , EX_FILE_STATUS , DATA_SOURCE_EX_LD FROM PS_EX_CCARD_FILE |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | EX_FILE_NAME |
Character(80) | VARCHAR2(80) NOT NULL | File Name |
| 3 | EX_FILE_STATUS |
Character(1) | VARCHAR2(1) NOT NULL |
File Load Status
E=Error L=Loaded X=Loaded with Errors |
| 4 | DATA_SOURCE_EX_LD | Character(3) | VARCHAR2(3) NOT NULL |
External Data Sources for PS Expenses
AIR=Airline Ticket AMA=American Express - GL1205 AMG=American Express - GL1025 AMH=American Express-Hotel Folio AMM=American Express - KR1205 AMX=American Express - KR1025 CNS=CONUS DC=Diners Club MC=MasterCard CDF2 MCX=MasterCard CDF3 NAP=PS NA Payroll PDA=Mobile Device RNZ=Runzheimer SAB=Sabre USB=US Bank USR=User Input VI4=Visa 4.4 VIS=Visa 4.0 |