IN_CFGSTATE_LVW

(SQL View)
 Index Back

Rel language record

Date Initials Issue Description 052504 dms F-KNANN-V59N4 Rel lang rec for in_cfg_state_vw

SELECT X.FIELDVALUE , X.LANGUAGE_CD , X.XLATLONGNAME FROM PSXLATITEMLANG X WHERE X.FIELDNAME = 'IN_FULFILL_STATE' AND %EffdtCheck(PSXLATITEM, X, %CurrentDateIn) AND X.FIELDVALUE <= '60'

  • Related Language Record for IN_CFG_STATE_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 IN_FULFILL_STATE Character(2) VARCHAR2(2) NOT NULL Inventory Fulfillment State
    10=Pending
    20=Unfulfilled
    30=Releasable
    40=Released
    50=Confirmed
    60=Shipped
    70=Depleted
    90=Canceled
    2 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description