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

CHNG_SOURCE_VW

(SQL View)

Change Source

Change Source related language

SELECT %Substring(X.fieldvalue, 1, 3) , X.xlatlongname FROM PSXLATITEM X WHERE X.FIELDNAME = 'CHNG_SOURCE' AND X.FIELDVALUE IN ('CRT','CST', 'DRP', 'EDX', 'EPO', 'EPR', 'IMC', 'PLN', 'PRD', 'PMC') AND %EffdtCheck(PSXLATITEM XX, X, %CurrentDateIn)

Related Language Record: CHNG_SOURCE_LVW

# 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 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	XLATLONGNAME	Character(30)	VARCHAR2(30) NOT NULL	Translate Long Name