CA_EXP_TYPE_VW (SQL View)	Index Back
CA_EXP_TYPE_VW CRM/Contracts Expense Type view created from translate values of field EXP_TYPE. This view is used as prompt table for EXP_TYPE field on CRM Accounting Rules tables.

CA_EXP_TYPE_VW

(SQL View)

CA_EXP_TYPE_VW

CRM/Contracts Expense Type view created from translate values of field EXP_TYPE. This view is used as prompt table for EXP_TYPE field on CRM Accounting Rules tables.

SELECT %Substring(X.FIELDVALUE,1,3) , X.XLATLONGNAME FROM PSXLATITEM X WHERE X.FIELDNAME = 'EXP_TYPE' AND %EffdtCheck(PSXLATITEM XX, X, %CurrentDateIn) AND X.EFF_STATUS = 'A'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EXP_TYPE Character(3) VARCHAR2(3) NOT NULL This field is used to store the type of expense.
AIR=Airfare
ENT=Entertainment
FDB=Food - Breakfast
FDD=Food - Dinner
FDL=Food - Lunch
GAS=Gas
LOD=Lodging
MIL=Mileage
MIS=Miscellaneous
PAR=Parking
PHO=Phone
REN=Rental Car
TOL=Tolls

2 XLATLONGNAME Character(30) VARCHAR2(30) NOT NULL Translate Long Name

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EXP_TYPE	Character(3)	VARCHAR2(3) NOT NULL	This field is used to store the type of expense. AIR=Airfare ENT=Entertainment FDB=Food - Breakfast FDD=Food - Dinner FDL=Food - Lunch GAS=Gas LOD=Lodging MIL=Mileage MIS=Miscellaneous PAR=Parking PHO=Phone REN=Rental Car TOL=Tolls
2	XLATLONGNAME	Character(30)	VARCHAR2(30) NOT NULL	Translate Long Name