CS_SRC_TRANLVW1

(SQL View)
 Index Back

Source Trans view -- main ones

Source trans view .. only the main ones ..excludes the two invisible ones needed.

SELECT %Substring(X.FIELDVALUE, 1, 2) , L.LANGUAGE_CD , L.XLATSHORTNAME , L.XLATLONGNAME FROM PSXLATITEM X , PSXLATITEMLANG L WHERE X.FIELDNAME = 'CS_SOURCE_TRANS' AND X.EFF_STATUS = 'A' AND X.FIELDVALUE <> '98' AND X.FIELDVALUE <> '99' AND %EffdtCheck(PSXLATITEM XX, X, %CurrentDateIn) AND %Join(COMMON_KEYS, PSXLATITEM X, PSXLATITEMLANG L, EFFDT)

  • Related Language Record for CS_SRC_TRAN_VW1

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 CS_SOURCE_TRANS Character(2) VARCHAR2(2) NOT NULL Source Transaction 03/22/07 cel F-AHAYT-748L7: Added Purchase Order (03) as a new source transaction 01/12/11 tbg SCMT-92-MDEM-04: Added RFx (04) as new source transaction for strat sourcing (doc authoring)
    01=Ad Hoc
    02=Purchasing Contracts
    03=Purchase Orders
    04=Sourcing Events
    97=All Sources
    98=Multiple Sources
    99=Not Transactional
    2 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    3 XLATSHORTNAME Character(10) VARCHAR2(10) NOT NULL Translate Value Short Name
    4 XLATLONGNAME Character(30) VARCHAR2(30) NOT NULL Translate Long Name