CS_DOC_CNTH_LVW

(SQL View)
 Index Back

REL lang view


SELECT '0008' ,PO.CS_DOC_ID ,PO.SETID ,PO.CNTRCT_ID , B.LANGUAGE_CD , B.DESCR60 FROM PS_CS_DOC_PO_KEYS PO ,PS_CS_DOC_HDR H , PS_CS_DOC_HDR_LANG B WHERE PO.CS_DOC_ID = H.CS_DOC_ID AND B.CS_DOC_ID = H.CS_DOC_ID

  • Related Language Record for CS_DOC_CNTH_SVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 CS_CONTENT_TYPE Character(4) VARCHAR2(4) NOT NULL 06/08/09 F-AHAYT-XOES6 Add capability to use binds in headers and/or footers of contract document; new translate value added to support Where Used from Document Templates and Styles 06/25/07 F-AHAYT-XOES6 Added 0016 for Document Format and Options; this type is only used when displayed where a word template is used with doc options. We do not search doc format and options.
    0001=Clause
    0002=Section
    0003=Ad Hoc Clause
    0004=Rule
    0005=Bind Variables
    0006=Wizard Definition
    0007=Document Configurator
    0008=Document
    0009=Contract Agreement
    0010=Bid Factor
    0011=Contract
    0012=Sourcing Event
    0013=Question Group
    0014=Document Type
    0015=Word Template
    0016=Document Format and Options
    2 CS_DOC_ID Character(25) VARCHAR2(25) NOT NULL Document ID
    3 SETID Character(5) VARCHAR2(5) NOT NULL SetID
    4 CS_CONTENT_ID Character(30) VARCHAR2(30) NOT NULL Content ID
    5 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    6 DESCR60 Character(60) VARCHAR2(60) NOT NULL Description