PL_XACTIONLTBL(SQL Table) |
Index Back |
---|---|
PL Action Table11/18/02 NRA (CN#PL880-1): Defined |
# | 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 | LANGUAGE_CD | Character(3) | VARCHAR2(3) NOT NULL | Language Code |
4 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |