PRC_PARTORD_VW

(SQL View)
Index Back

partial order ship flag

partial order ship flag

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

  • Related Language Record: PRC_PARTORD_LVW
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SHIP_PARTIAL_ORD Character(1) VARCHAR2(1) NOT NULL Partial Order
    N=Partial Order No
    Y=Partial Order Yes
    2 EOEP_CHAR Character(254) VARCHAR2(254) NOT NULL Long field