CS_CNT_SL_VW

(SQL View)
Index Back

Contract Style View

Contract Style View 11/15/2015 JOHAN PO0025 - Master contract fluid

SELECT CNTRCT_STYLE , CNTRCT_STYLE_NAME , CNTRCT_STRUCT_CD , DESCR50 , STYLE_STATUS , CNTRCT_PROC_OPT , ALLOW_ALL_DOCTYPES FROM PS_CNTRCT_STYLE WHERE 1=1

  • Related Language Record: CS_CNT_SL_LVW
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 CNTRCT_STYLE Character(10) VARCHAR2(10) NOT NULL Contract Style
    2 CNTRCT_STYLE_NAME Character(30) VARCHAR2(30) NOT NULL Style Description
    3 CNTRCT_STRUCT_CD Character(4) VARCHAR2(4) NOT NULL Valid Structures for Contract Styles
    ADHD=Ad Hoc Document
    AP=Recurring Voucher
    BPO=Release to Single PO Only
    DST=Distributor
    GN=General Contract
    GRPM=Group Multi Supplier
    GRPS=Group Single Supplier
    MFG=Manufacturer
    PADV=Prepaid Voucher w/ Advance PO
    PO=Purchase Order
    POD=Purchase Order Document
    PPAY=Prepaid Voucher
    RPOV=Recurring PO Voucher
    SED=Sourcing Event Document
    SPP=Special Purpose
    4 DESCR50 Character(50) VARCHAR2(50) NOT NULL Description of length 50
    5 STYLE_STATUS Character(1) VARCHAR2(1) NOT NULL Contract Style Status
    A=Active
    I=Inactive
    6 CNTRCT_PROC_OPT Character(4) VARCHAR2(4) NOT NULL Contract Process Option
    AP=Recurring Voucher
    BPO=Release to Single PO Only
    DST=Distributor
    GN=General Contract
    GRPM=Group Multi Supplier
    GRPS=Group Single Supplier
    MFG=Manufacturer
    PADV=Prepaid Voucher w/ Advance PO
    PO=Purchase Order
    PPAY=Prepaid Voucher
    RPOV=Recurring PO Voucher
    SPP=Special Purpose
    7 ALLOW_ALL_DOCTYPES Character(1) VARCHAR2(1) NOT NULL Contract Style Status