MBL_DOCTYPEVLNG

(SQL View)

SELECT %Substring(FIELDVALUE, 1, 1) , LANGUAGE_CD , XLATLONGNAME FROM PS_MBL_XLATITEMVWL WHERE FIELDNAME='EX_DOC_TYPE' AND FIELDVALUE IN ('S','A','T')

Related Language Record for MBL_DOCTYPE_VW

# 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 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code

3 EX_DOC_TYPE_DESCR Character(30) VARCHAR2(30) NOT NULL Expense Document Description

#	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	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
3	EX_DOC_TYPE_DESCR	Character(30)	VARCHAR2(30) NOT NULL	Expense Document Description