CNTRCT_SRCHLNG2

(SQL View)
 Index Back

Contract Search Record


SELECT DISTINCT a.SETID , a.CNTRCT_ID , a.CNTRCT_STYLE , a.CNTRCT_PROC_OPT , c.LANGUAGE_CD FROM PS_CNTRCT_HDR a , PS_VENDOR_LANG c WHERE a.version_status = 'C' AND a.vendor_setid = c.setid AND a.vendor_id = c.vendor_id

  • Related Language Record for CNTRCT_SRCH

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

    Default Value: OPR_DEF_TBL_FS.SETID

    Prompt Table: SP_SETID_NONVW

    2 CNTRCT_ID Character(25) VARCHAR2(25) NOT NULL Buying Agreement ID

    Default Value: NEXT

    3 CNTRCT_STYLE Character(10) VARCHAR2(10) NOT NULL Contract Style
    4 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

    Default Value: GN

    5 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code