EX_ER_LN_AW_VW(SQL View) |
Index Back |
|---|---|
Expense Report LineExpense Report Line |
| SELECT SHEET_ID , LINE_NBR , EX_LINE_STATUS , EXPENSE_TYPE , APPROVE_FLAG 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]
Default Value: 1 |
| 3 | EX_LINE_STATUS | Character(3) | VARCHAR2(3) NOT NULL |
The Line Status of an Expenses transaction (i.e. Expense Report, Cash Advance, Travel Authorization, Time Report)
ADJ=Adjusted APR=Approved APY=Approved for Payment CLS=Closed DEN=Denied DNA=Denied by Approver DNC=Denied DNU=Denied by Auditor ESC=Escheated Payment HDA=Hold by Approver HDU=Hold by Auditor HLD=Hold MFS=Marked For Submit OPN=Open PAR=Approvals in Process PD=Paid PND=Pending PRO=In Process RAP=Approved STG=Staged SUB=Submitted XML=Submitted, Pending Validation Default Value: PND |
| 4 | EXPENSE_TYPE | Character(7) | VARCHAR2(7) NOT NULL | Expense Type |
| 5 | APPROVE_FLAG | Character(1) | VARCHAR2(1) NOT NULL | Approve Flag |