PRC_SRCTYPE_LVW (SQL View)	Index Back
Source type Source type

PRC_SRCTYPE_LVW

(SQL View)

Source type

SELECT %Substring(A.FIELDVALUE, 1 , 1) , A.LANGUAGE_CD , A.XLATLONGNAME FROM PSXLATITEMLANG A WHERE FIELDNAME = 'TRFT_SRC_TYPE' AND %EffdtCheck(PSXLATITEMLANG, A, %CurrentDateIn)

Related Language Record for PRC_SRCTYPE_VW

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 TRFT_SRC_TYPE Character(1) VARCHAR2(1) NOT NULL Alternate Source Type
0=All Sources
1=Inventory Business Unit
2=Distribution Network
3=New Requisition
4=New Purchase Order
5=Existing Requisition
6=Existing Purchase Order
7=Existing Interunit Transfer
8=Existing Production Order
9=New Production Order

2 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code

3 EOEP_CHAR Character(254) VARCHAR2(254) NOT NULL Long field

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	TRFT_SRC_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Alternate Source Type 0=All Sources 1=Inventory Business Unit 2=Distribution Network 3=New Requisition 4=New Purchase Order 5=Existing Requisition 6=Existing Purchase Order 7=Existing Interunit Transfer 8=Existing Production Order 9=New Production Order
2	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
3	EOEP_CHAR	Character(254)	VARCHAR2(254) NOT NULL	Long field