CS_SRC_TRAN_VW1

(SQL View)
 Index Back

Source trans view -- main ones

View for core source transaction xlats .. excludes the 2 hidden ones needed for processing behind the scenes.

SELECT %Substring(X.FIELDVALUE, 1, 2) , X.XLATSHORTNAME , X.XLATLONGNAME FROM PSXLATITEM X 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)

  • Related Language Record: CS_SRC_TRANLVW1

    • # 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 XLATSHORTNAME Character(10) VARCHAR2(10) NOT NULL Translate Value Short Name
    3 XLATLONGNAME Character(30) VARCHAR2(30) NOT NULL Translate Long Name