SHEET_IDLINE_NBRPrompt Table: EX_TYPES_TBL
AIR=Airfare
ATT=Attendees
AUT=Automobile
HTL=Hotel
NON=None
PDL=Per Diem Lodging
PDM=Per Diem
RTL=Rental
EX_SHTLN_CPY_VW(SQL View) |
Index Back |
|---|---|
Expense Sheet Line Copy ViewView used to display expense lines selected by the user to copy during Expense Report Entry. |
| SELECT SHEET_ID , LINE_NBR , EXPENSE_TYPE , ' ' , TRANS_DT , TXN_AMOUNT , TXN_CURRENCY_CD FROM PS_EX_SHEET_LINE |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SHEET_ID |
Character(10) | VARCHAR2(10) NOT NULL | Report ID |
| 2 | LINE_NBR |
Number(5,0) | INTEGER NOT NULL | Line Number: 11/24/08 - Added TARGET label [PC product] |
| 3 | EXPENSE_TYPE | Character(7) | VARCHAR2(7) NOT NULL |
Expense Type
Prompt Table: EX_TYPES_TBL |
| 4 | EXPENSE_TYPE_EDIT | Character(3) | VARCHAR2(3) NOT NULL |
Expense Type Edit
AIR=Airfare ATT=Attendees AUT=Automobile HTL=Hotel NON=None PDL=Per Diem Lodging PDM=Per Diem RTL=Rental |
| 5 | TRANS_DT | Date(10) | DATE | Transaction Date |
| 6 | TXN_AMOUNT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Transaction Amount |
| 7 | TXN_CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Transaction Currency |