EX_RNZ_MSG(SQL Table) |
Index Back |
|---|---|
Runzheimer MessageRunzheimer Message |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | DATE_STRING | Character(25) | VARCHAR2(25) NOT NULL | Label for Completion Date |
| 2 | CITY | Character(30) | VARCHAR2(30) NOT NULL | City |
| 3 | STATE | Character(6) | VARCHAR2(6) NOT NULL | State |
| 4 | COUNTRY_FLD | Character(18) | VARCHAR2(18) NOT NULL | Country Field |
| 5 | COUNTRY_NAME | Character(30) | VARCHAR2(30) NOT NULL | Country |
| 6 | REPORT_DATE | Character(15) | VARCHAR2(15) NOT NULL | Report Date |
| 7 | KEY_CHAR_40_01 | Character(40) | VARCHAR2(40) NOT NULL | Key Char 40/01 |
| 8 | KEY_CHAR_40_02 | Character(40) | VARCHAR2(40) NOT NULL | Key Char 40/02 |
| 9 | KEY_CHAR_40_03 | Character(40) | VARCHAR2(40) NOT NULL | Key Char 40/03 |
| 10 | KEY_CHAR_40_04 | Character(40) | VARCHAR2(40) NOT NULL | Key Char 40/04 |
| 11 | KEY_CHAR_40_05 | Character(40) | VARCHAR2(40) NOT NULL | Key Char 40/05 |
| 12 | KEY_CHAR_40_06 | Character(40) | VARCHAR2(40) NOT NULL | Key_Char 40/06 |
| 13 | KEY_CHAR_40_07 | Character(40) | VARCHAR2(40) NOT NULL | Key Char 40/07 |
| 14 | BID_RESP_1 | Character(50) | VARCHAR2(50) NOT NULL | Bid Response 1 |
| 15 | BID_RESP_2 | Character(50) | VARCHAR2(50) NOT NULL | Bid Response 2 |
| 16 | BID_RESP_3 | Character(50) | VARCHAR2(50) NOT NULL | Bid Response 3 |
| 17 | BID_RESP_4 | Character(50) | VARCHAR2(50) NOT NULL | Bidder 4 |
| 18 | BID_RESP_5 | Character(50) | VARCHAR2(50) NOT NULL | Bidder 5 |
| 19 | BID_RESP_6 | Character(50) | VARCHAR2(50) NOT NULL | Bidder 6 |
| 20 | BID_RESP_7 | Character(50) | VARCHAR2(50) NOT NULL | Bidder 7 |
| 21 | BID_RESP_8 | Character(50) | VARCHAR2(50) NOT NULL | Bidder 8 |
| 22 | BID_RESP_9 | Character(50) | VARCHAR2(50) NOT NULL | Bidder 9 |
| 23 | BID_RESP_10 | Character(50) | VARCHAR2(50) NOT NULL | Bidder 10 |
| 24 | BID_RESP_11 | Character(50) | VARCHAR2(50) NOT NULL | Bidder 11 |
| 25 | BID_RESP_12 | Character(50) | VARCHAR2(50) NOT NULL | Bidder 12 |
| 26 | BID_RESP_13 | Character(50) | VARCHAR2(50) NOT NULL | Bidder 13 |
| 27 | BID_RESP_14 | Character(50) | VARCHAR2(50) NOT NULL | Bidder 14 |
| 28 | BID_RESP_15 | Character(50) | VARCHAR2(50) NOT NULL | Bidder 15 |
| 29 | BID_RESP_16 | Character(50) | VARCHAR2(50) NOT NULL | Bidder 16 |
| 30 | BID_RESP_17 | Character(50) | VARCHAR2(50) NOT NULL | Bidder 17 |
| 31 | BID_RESP_18 | Character(50) | VARCHAR2(50) NOT NULL | Bidder 18 |
| 32 | BID_RESP_19 | Character(50) | VARCHAR2(50) NOT NULL | Bidder 19 |
| 33 | BID_RESP_20 | Character(50) | VARCHAR2(50) NOT NULL | Bidder 20 |
| 34 | BID_RESP_21 | Character(50) | VARCHAR2(50) NOT NULL | Bidder 21 |
| 35 | BID_RESP_22 | Character(50) | VARCHAR2(50) NOT NULL | Bidder 22 |
| 36 | BID_RESP_23 | Character(50) | VARCHAR2(50) NOT NULL | Bidder 23 |
| 37 | BID_RESP_24 | Character(50) | VARCHAR2(50) NOT NULL | Bidder 24 |
| 38 | BID_RESP_25 | Character(50) | VARCHAR2(50) NOT NULL | Bidder 25 |
| 39 | BID_RESP_26 | Character(50) | VARCHAR2(50) NOT NULL | Bidder 26 |
| 40 | BID_RESP_27 | Character(50) | VARCHAR2(50) NOT NULL | Bidder 27 |
| 41 | BID_RESP_28 | Character(50) | VARCHAR2(50) NOT NULL | Bidder 28 |
| 42 | BID_RESP_29 | Character(50) | VARCHAR2(50) NOT NULL | Bidder 29 |
| 43 | BID_RESP_30 | Character(50) | VARCHAR2(50) NOT NULL | Bidder 30 |
| 44 | BID_RESP_31 | Character(50) | VARCHAR2(50) NOT NULL | Bidder 31 |
| 45 | BID_RESP_32 | Character(50) | VARCHAR2(50) NOT NULL | Bidder 32 |
| 46 | BID_RESP_33 | Character(50) | VARCHAR2(50) NOT NULL | Bidder 33 |
| 47 | BID_RESP_34 | Character(50) | VARCHAR2(50) NOT NULL | Bidder 34 |
| 48 | BID_RESP_35 | Character(50) | VARCHAR2(50) NOT NULL | Bidder 35 |
| 49 | BID_RESP_36 | Character(50) | VARCHAR2(50) NOT NULL | Bidder 36 |
| 50 | BID_RESP_37 | Character(50) | VARCHAR2(50) NOT NULL | Bidder 37 |
| 51 | BID_RESP_38 | Character(50) | VARCHAR2(50) NOT NULL | Bidder 38 |
| 52 | BID_RESP_39 | Character(50) | VARCHAR2(50) NOT NULL | Bidder 39 |
| 53 | BID_RESP_40 | Character(50) | VARCHAR2(50) NOT NULL | Bidder 40 |
| 54 | BID_RESP_41 | Character(50) | VARCHAR2(50) NOT NULL | Bidder 41 |
| 55 | BID_RESP_42 | Character(50) | VARCHAR2(50) NOT NULL | Bidder 42 |
| 56 | BID_RESP_43 | Character(50) | VARCHAR2(50) NOT NULL | Bidder 43 |
| 57 | BID_RESP_44 | Character(50) | VARCHAR2(50) NOT NULL | Bidder 44 |
| 58 | BID_RESP_45 | Character(50) | VARCHAR2(50) NOT NULL | Bidder 45 |
| 59 | BID_RESP_46 | Character(50) | VARCHAR2(50) NOT NULL | Bidder 46 |
| 60 | BID_RESP_47 | Character(50) | VARCHAR2(50) NOT NULL | Bidder 47 |
| 61 | BID_RESP_48 | Character(50) | VARCHAR2(50) NOT NULL | Bidder 48 |
| 62 | BID_RESP_49 | Character(50) | VARCHAR2(50) NOT NULL | Bidder 49 |
| 63 | BID_RESP_50 | Character(50) | VARCHAR2(50) NOT NULL | Bidder 50 |
| 64 | DESCR_LN1 | Character(50) | VARCHAR2(50) NOT NULL | Description Line 1 |
| 65 | DESCR_LN2 | Character(50) | VARCHAR2(50) NOT NULL | Description Line 2 |
| 66 | DESCR_LN3 | Character(50) | VARCHAR2(50) NOT NULL | Description Line 3 |
| 67 | 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 |