IN_CFG_STATE_VW

(SQL View)
 Index Back

In Fulfill State values

Date Initials Issue Description 052504 dms F-KNANN-V59N4 Prompt table for change config

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

  • Related Language Record: IN_CFGSTATE_LVW

    • # 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 DESCR Character(30) VARCHAR2(30) NOT NULL Description