PL_XACTION_TBL

(SQL Table)
 Index Back

PL Action Table

11/18/02 NRA (CN#PL880-1): Defined 04/25/03 NRA (CN#PL880-1): Added PL_XACTION_DESCR to support related language displays of transaction types. Had to make PL_XACTION_DESCR a key so that the MM page could see the description. PL_XACTION_TYPE is the coded value for PL_XACTION_DESCR, and should be the key value.

  • Related Language Record: PL_XACTIONLTBL

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 PL_MAINT_ACTIVITY Character(2) VARCHAR2(2) NOT NULL 12/10/02 NRA (CN#PL880-1): Defined
    01=Freeze
    02=Unfreeze
    03=Include Quantity
    04=Exclude Quantity
    05=Freeze Substitutes
    06=Unfreeze Substitutes
    07=Approve
    08=Unapprove
    09=Consume Forecast
    10=Unconsume Forecast
    11=Cancel
    12=Uncancel
    21=Set Demand Priority
    22=Set Order Status
    31=Reschedule Forward
    32=Reschedule Backward
    33=Consolidate/Reschedule Fwd
    34=Consolidate/Reschedule Bkwd
    41=Change Sourcing Option
    2 PL_XACTION_TYPE Character(4) VARCHAR2(4) NOT NULL 11/15/02 NRA - Created for Set Value actions
    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description