CS_DOCT_ACT_VW

(SQL View)
 Index Back

Available Document Types

SCC 12/02/05: Available Document Types

SELECT SETID , CS_DOCUMENT_TYPE , CS_SOURCE_TRANS , DESCR254 , DESCR FROM PS_CS_DOC_TYPE_TBL WHERE CS_DOCTYPE_STATUS='01'

  • Related Language Record: CS_DOCT_ACT_LVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 CS_SETID Character(5) VARCHAR2(5) NOT NULL setid for the document objects
    2 CS_DOCUMENT_TYPE Character(20) VARCHAR2(20) NOT NULL Document Type
    001=Main Document
    002=Amendment
    003=Preview Document
    004=Compare File
    3 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
    4 DESCR254 Character(254) VARCHAR2(254) NOT NULL Description of length 254
    5 DESCR Character(30) VARCHAR2(30) NOT NULL Description