OPRIDTRANS_NBRSEQ_NBRPrompt Table: EX_TYP_MYWAL_VW
Default Value: BUS_UNIT_TBL_EX.BASE_CURRENCY
Prompt Table: CURRENCY_CD_TBL
3=Metres
K=Kilometers
M=Miles
EX_IPHONE_TRANS(SQL Table) |
Index Back |
|---|---|
iReceipts TransactioniReceipts Transaction |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | OPRID |
Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 2 | TRANS_NBR |
Character(24) | VARCHAR2(24) NOT NULL | Transaction Number |
| 3 | SEQ_NBR |
Number(15,0) | DECIMAL(15) NOT NULL | Sequence Number |
| 4 | DESCR60 | Character(60) | VARCHAR2(60) NOT NULL | Description |
| 5 | LOCATION_DESCR | Character(30) | VARCHAR2(30) NOT NULL | Location |
| 6 | EXPENSE_TYPE | Character(7) | VARCHAR2(7) NOT NULL |
Expense Type
Prompt Table: EX_TYP_MYWAL_VW |
| 7 | TRANS_DT | Date(10) | DATE | Transaction Date |
| 8 | TXN_AMOUNT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Transaction Amount |
| 9 | TXN_CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL |
Transaction Currency
Default Value: BUS_UNIT_TBL_EX.BASE_CURRENCY Prompt Table: CURRENCY_CD_TBL |
| 10 | DISTANCE | Number(8,2) | DECIMAL(7,2) NOT NULL | Distance Traveled |
| 11 | DISTANCE_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Distance Type
3=Metres K=Kilometers M=Miles |
| 12 | DESCR60_2 | Character(60) | VARCHAR2(60) NOT NULL | Description |