CNTRCT_SE_HD_VW

(SQL View)
 Index Back

Contract Header for PTSF

Contract Header for PTSF GTIN 8/22/2018 LAK add fields for GTIN/PUNCHOUT

SELECT H.SETID , H.CNTRCT_ID , H.VERSION_NBR , H.VERSION_STATUS , H.CNTRCT_STATUS , H.CNTRCT_PROC_OPT , H.OPRID_ENTERED_BY , H.CONTROL_TYPE ,H.PCHOUTPRICE_OPTION , %Substring(%Cast(H.CNTRCT_BEGIN_DT , Date, Character), 6, 2) , %Substring(%Cast(H.CNTRCT_BEGIN_DT, Date, Character), 6, 2) , %Coalesce(M.OPRDEFNDESC, H.BUYER_ID) , %DatePart(H.LAST_DTTM_UPDATE) FROM PS_CNTRCT_HDR H LEFT OUTER JOIN PSOPRDEFN M ON H.BUYER_ID = M.OPRID

  • Parent record: CNTRCT_HDR

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
    2 CNTRCT_ID Character(25) VARCHAR2(25) NOT NULL Buying Agreement ID
    3 VERSION_NBR Number(5,0) INTEGER NOT NULL Contract Version number

    Default Value: 1

    4 VERSION_STATUS Character(1) VARCHAR2(1) NOT NULL Contract version status
    C=Current
    D=Draft
    H=History
    5 CNTRCT_STATUS Character(1) VARCHAR2(1) NOT NULL Contract Status
    A=Approved
    C=Closed
    H=On-Hold
    O=Open
    P=Pre-Approved
    X=Canceled
    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 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    8 CONTROL_TYPE Character(4) VARCHAR2(4) NOT NULL PO002 Manufacturer Contract
    BU=Business Unit
    CDOM=Contract Domain
    SHIP=Ship To
    X=Not Used
    9 PCHOUTPRICE_OPTION Character(4) VARCHAR2(4) NOT NULL Punchout Pricing Option
    AUCP=Always Use Contract Price
    AUPP=Always Use Punchout Price
    UPPL=Use Punchout Price if Lower
    X=Not Used
    10 SES_MONTH Character(2) VARCHAR2(2) NOT NULL Month
    01=01: January
    02=02: February
    03=03: March
    04=04: April
    05=05: May
    06=06: June
    07=07: July
    08=08: August
    09=09: September
    10=10: October
    11=11: November
    12=12: December
    11 SES_MONTH2 Character(2) VARCHAR2(2) NOT NULL Month
    01=01: January
    02=02: February
    03=03: March
    04=04: April
    05=05: May
    06=06: June
    07=07: July
    08=08: August
    09=09: September
    10=10: October
    11=11: November
    12=12: December
    12 OPRDEFNDESC Character(30) VARCHAR2(30) NOT NULL Description field for a user
    13 LAST_DATE_WORKED Date(10) DATE Last Date Worked