PRC_ORDTYPE_VW

(SQL View)
 Index Back

order type code

order type code

SELECT %Substring(A.FIELDVALUE, 1 , 3) , A.XLATLONGNAME FROM PSXLATITEM A WHERE FIELDNAME = 'ORDER_TYPE_CD' AND %EffdtCheck(PSXLATITEM, A, %CurrentDateIn) AND a.eff_status='A'

  • Related Language Record: PRC_ORDTYPE_LVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 ORDER_TYPE_CD Character(3) VARCHAR2(3) NOT NULL Order Type
    QUO=Sales Quote
    SO=Sales Order
    2 EOEP_CHAR Character(254) VARCHAR2(254) NOT NULL Long field