OMEC_ORDSTAT_VW

(SQL View)
 Index Back

OMEC Header status

Valid status for ORD_HEADER in OMEC Date Initials Issue Description 030703 dms F-CJORGENS-43 Allow 'X' as a value

SELECT x.fieldvalue , x.xlatlongname FROM PSXLATITEM x WHERE x.fieldname = 'ORDER_STATUS' AND x.fieldvalue IN ('O','X') AND x.eff_status = 'A' AND %EffdtCheck(PSXLATITEM, x, %CurrentDateIn)

  • Related Language Record: OMEC_ORDSTATLVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 ORDER_STATUS Character(3) VARCHAR2(3) NOT NULL Order Status
    C=Closed
    O=Open
    P=Pending
    X=Canceled
    2 XLATLONGNAME Character(30) VARCHAR2(30) NOT NULL Translate Long Name