CS_DOC_HDR_LVW2

(SQL View)
 Index Back

REL lang view


SELECT A.CS_SOURCE_TRANS , A.CS_DOC_ID , B.LANGUAGE_CD , B.DESCR60 FROM PS_CS_DOC_HDR A , PS_CS_DOC_HDR_LANG B WHERE A.CS_DOC_ID = B.CS_DOC_ID

  • Related Language Record for CS_DOC_HDR_VW2

    • # 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 CS_DOC_ID Character(25) VARCHAR2(25) NOT NULL Document ID
    3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 DESCR60 Character(60) VARCHAR2(60) NOT NULL Description