CS_CNT_OPT_VW

(SQL View)
 Index Back

Contract Opt Xlat View

View for contract process option xlats.

SELECT %Substring(X.FIELDVALUE, 1, 4) , X.XLATSHORTNAME , X.XLATLONGNAME FROM PSXLATITEM X WHERE X.FIELDNAME = 'CNTRCT_PROC_OPT' AND X.EFF_STATUS = 'A' AND %EffdtCheck(PSXLATITEM XX, X, %CurrentDateIn)

  • Related Language Record: CS_CNT_OPT_LVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 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
    2 XLATSHORTNAME Character(10) VARCHAR2(10) NOT NULL Translate Value Short Name
    3 XLATLONGNAME Character(30) VARCHAR2(30) NOT NULL Translate Long Name