CHNG_SOURCE_VLN (SQL View)	Index Back
Change Source Change Source related language

CHNG_SOURCE_VLN

(SQL View)

Change Source

Change Source related language

SELECT %Substring(X.fieldvalue, 1, 3) , X.LANGUAGE_CD , X.xlatlongname FROM PSXLATITEMLANG X WHERE X.FIELDNAME = 'CHNG_SOURCE' AND %EffdtCheck(PSXLATITEM XX, X, %CurrentDateIn)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 CHNG_SOURCE Character(3) VARCHAR2(3) NOT NULL Change Source
BPA=Contract Release to Single PO
CAP=Contract Batch Auto Approval
CRT=PAR Replenish/Close Backorders
CST=Close Short Purchase Orders
DRP=Order Management Referenced
EDX=PO Acknowledgments
EMC=Req. Requester Mass Change
EPO=eProcurement Change Request
EPR=User Change Request
IMC=Inventory Mass Change
ONL=On-line Purchase Order
PLN=Planning System
PMC=PO Buyer Mass Change
POC=PO Change Batch Process
PRD=Production/Shop Floor

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

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	CHNG_SOURCE	Character(3)	VARCHAR2(3) NOT NULL	Change Source BPA=Contract Release to Single PO CAP=Contract Batch Auto Approval CRT=PAR Replenish/Close Backorders CST=Close Short Purchase Orders DRP=Order Management Referenced EDX=PO Acknowledgments EMC=Req. Requester Mass Change EPO=eProcurement Change Request EPR=User Change Request IMC=Inventory Mass Change ONL=On-line Purchase Order PLN=Planning System PMC=PO Buyer Mass Change POC=PO Change Batch Process PRD=Production/Shop Floor
2	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
3	XLATLONGNAME	Character(30)	VARCHAR2(30) NOT NULL	Translate Long Name