EX_DOC_TYPEA=Cash Advance
C=Time Report
J=Time Adjustment
M=Accrual - My Wallet
R=Accrual - Expense Report
S=Expense Report
T=Travel Authorization
MBL_DOCTYPE_VW(SQL View) |
Index Back |
|---|
| SELECT %Substring(FIELDVALUE, 1, 1) , XLATLONGNAME FROM PS_MBL_XLATTABLEVW WHERE FIELDNAME='EX_DOC_TYPE' AND FIELDVALUE IN ('S','A','T') |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EX_DOC_TYPE |
Character(1) | VARCHAR2(1) NOT NULL |
Identifies Expenses Document Type
A=Cash Advance C=Time Report J=Time Adjustment M=Accrual - My Wallet R=Accrual - Expense Report S=Expense Report T=Travel Authorization |
| 2 | EX_DOC_TYPE_DESCR | Character(30) | VARCHAR2(30) NOT NULL | Expense Document Description |