PL_PRB_TMP(SQL Table) |
Index Back |
|---|
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PROBINST | Character(20) | VARCHAR2(20) NOT NULL | Optimization Problem Instance |
| 2 | BU_GROUP | Character(6) | VARCHAR2(6) NOT NULL |
08/16/01 EGS (CN#PL880-1.0): Added
Prompt Table: PL_GROUP_IN_VW |
| 3 | PROBINST_STATUS | Character(2) | VARCHAR2(2) NOT NULL |
05/13/02 EGS (CN#PL900-1): Added
10/30/02 NRA Added Status of 'Deleted'
10=Defined 20=Regenerated 30=Net Change 40=Loaded 50=Posted 60=Deleted Default Value: 10 |
| 4 | STATUS_DTTM | DateTime(26) | TIMESTAMP | 05/13/02 EGS (CN#PL900-1): Added |
| 5 | DBR_RUN_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Run Type
N=Net Change R=Regenerative S=Regenerative Select Default Value: R |
| 6 | REGEN_DTTM | DateTime(26) | TIMESTAMP | 09/07/01 EGS (CN#PL900-1): Added. |
| 7 | UPDATE_DTTM | DateTime(26) | TIMESTAMP | 02/28/02 EGS (CN#PL900-1): Added |
| 8 | PROCESS_DTTM | DateTime(26) | TIMESTAMP | Process Date Time |
| 9 | TRANSACTION_LOCKED | Character(1) | VARCHAR2(1) NOT NULL |
"An internal work field that
Y/N Table Edit Default Value: N |
| 10 | CURRENT_DTTM | DateTime(26) | TIMESTAMP | 08/27/01 EGS (CN#PL900-1.0): Added |
| 11 | PL_LOADED_FLG | Character(1) | VARCHAR2(1) NOT NULL |
03/14/02 EGS (CN#PL900-1): Added
Y/N Table Edit Default Value: N |
| 12 | START_DATE | Date(10) | DATE | Start Date for Gen Standing PO |
| 13 | END_DATE | Date(10) | DATE | End Date |
| 14 | EARLY_DATE | Date(10) | DATE | 08/31/01 EGS (CN#PL900-1): Added. |
| 15 | LATE_DATE | Date(10) | DATE | 08/31/01 EGS (CN#PL900-1): Added. |
| 16 | CAPACITY_DATE | Date(10) | DATE | 08/31/01 EGS (CN#PL900-1): Added. |
| 17 | FCST_FULFILL_DATE | Date(10) | DATE | 08/31/01 EGS (CN#PL900-1): Added. |
| 18 | PLAN_ITEM_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
08/28/01 EGS (CN#PL900-1): Added.
1=Distribution and Master 2=Master and Material 3=All 4=Distribution Only 5=Master Only 6=Material Only Default Value: 3 |
| 19 | INCL_SALES_ORDERS | Character(1) | VARCHAR2(1) NOT NULL |
03/10/98 SCC CN# PL750-SCHEW-JV26Y: Changed long/short descr.
Y/N Table Edit Default Value: N |
| 20 | INCL_QUOTES | Character(1) | VARCHAR2(1) NOT NULL |
03/10/98 SCC CN# PL750-SCHEW-JV26Y: Changed long/short descr.
Y/N Table Edit Default Value: N |
| 21 | INCL_BUYING_AGREE | Character(1) | VARCHAR2(1) NOT NULL |
05/02/02 JNW (CN#PL900-1): Added
Y/N Table Edit Default Value: N |
| 22 | INCL_STOCK_REQUEST | Character(1) | VARCHAR2(1) NOT NULL |
03/10/98 SCC CN# PL750-SCHEW-JV26Y: Changed long/short descr.
Y/N Table Edit Default Value: N |
| 23 | INCL_TFR_DEMAND | Character(1) | VARCHAR2(1) NOT NULL |
03/10/98 SCC CN# PL750-SCHEW-JV26Y: Changed long/short descr.
Y/N Table Edit Default Value: N |
| 24 | INCL_TFR_PL_DEMAND | Character(1) | VARCHAR2(1) NOT NULL |
03/10/98 SCC CN# PL750-SCHEW-JV26Y: Changed long/short descr.
Y/N Table Edit Default Value: N |
| 25 | INCL_FORECAST | Character(1) | VARCHAR2(1) NOT NULL |
03/10/98 SCC CN# PL750-SCHEW-JV26Y: Changed long/short descr.
Y/N Table Edit Default Value: N |
| 26 | INCL_PURCH_ORDERS | Character(1) | VARCHAR2(1) NOT NULL |
03/10/98 SCC CN# PL750-SCHEW-JV26Y: Changed long/short descr.
Y/N Table Edit Default Value: N |
| 27 | INCL_PROD_ORDERS | Character(1) | VARCHAR2(1) NOT NULL |
03/10/98 SCC CN# PL750-SCHEW-JV26Y: Changed long/short descr.
08/28/01 EGS (CN#PL900-1): Removed Y/N translates
0=off 1=on Y/N Table Edit Default Value: N |
| 28 | INCL_TFR_SUPPLY | Character(1) | VARCHAR2(1) NOT NULL |
03/10/98 SCC CN# PL750-SCHEW-JV26Y: Changed long/short descr.
Y/N Table Edit Default Value: N |
| 29 | INCL_PL_PURCH_ORD | Character(1) | VARCHAR2(1) NOT NULL |
03/10/98 SCC CN# PL750-SCHEW-JV26Y: Changed long/short descr.
Y/N Table Edit Default Value: N |
| 30 | INCL_PL_PROD_ORD | Character(1) | VARCHAR2(1) NOT NULL |
03/10/98 SCC CN# PL750-SCHEW-JV26Y: Changed long/short descr.
Y/N Table Edit Default Value: N |
| 31 | INCL_TFR_PL_SUPPLY | Character(1) | VARCHAR2(1) NOT NULL |
03/10/98 SCC CN# PL750-SCHEW-JV26Y: Changed long/short descr.
Y/N Table Edit Default Value: N |
| 32 | INCL_QOH | Character(1) | VARCHAR2(1) NOT NULL |
09/03/01 EGS (CN#PL900-1): Added.
Y/N Table Edit Default Value: N |
| 33 | FIRM_PLAN_ONLY | Character(1) | VARCHAR2(1) NOT NULL |
09/23/02 EGS (CN#PL880-1): Added.
Y/N Table Edit Default Value: Y |
| 34 | NET_CHANGE_QOH | Character(1) | VARCHAR2(1) NOT NULL |
02/11/02 EGS (CN#PL900-1): Added.
Y/N Table Edit Default Value: N |
| 35 | DEL_EXTRA_DMD | Character(1) | VARCHAR2(1) NOT NULL |
02/28/02 EGS (CN#PL900-1): Added
Y/N Table Edit Default Value: N |
| 36 | INCL_PRIORITIES | Character(1) | VARCHAR2(1) NOT NULL |
Apply Demand Priorities
Y/N Table Edit Default Value: N |
| 37 | AUTO_MASS_MAINT | Character(1) | VARCHAR2(1) NOT NULL |
Auto Mass Maintenance
Y/N Table Edit Default Value: N |
| 38 | POST_LOAD_SOLVER | Character(1) | VARCHAR2(1) NOT NULL |
Run Solver after Load
1=Material Solver 2=Feasible Solver 3=Enterprise Feasible Solver Default Value: 1 |
| 39 | QUOTE_PERCENT | Number(3,0) | SMALLINT NOT NULL |
Acceptance Percentage
Default Value: 100 |
| 40 | PL_FORECAST_SOURCE | Character(1) | VARCHAR2(1) NOT NULL |
PL_FORECAST_SOURCE
N=No Forecast P=Published Forecasts S=Forecast Sets |
| 41 | FORECAST_SOURCE | Character(1) | VARCHAR2(1) NOT NULL |
08/28/01 EGS (CN#PL900-1): Added
1=Inventory 2=Demand Planning Default Value: 1 |
| 42 | FORECAST_SET | Character(20) | VARCHAR2(20) NOT NULL | Forecast Set |
| 43 | PL_CONS_METHOD | Character(1) | VARCHAR2(1) NOT NULL |
jnw 10/1/99 cn# mg800-12 created field
jaa 10/20/00 (cn# v080-Planning Phoenix). The consumption method is used in both the forecast consumption and within the solvers. Added the label Sales Order Demand Date for the PL_GENERATE_PLAN project.
P=Schedule Date R=Request Date Default Value: P |
| 44 | PLAN_BUCKET | Character(1) | VARCHAR2(1) NOT NULL |
08/03/99 MACN (CN#PL800-33.0) Changed the translate values from D, W, M to 0, 1, 2
0=Daily 1=Weekly 2=Monthly Default Value: 1 |
| 45 | FORECAST_LOAD | Character(1) | VARCHAR2(1) NOT NULL |
Forecast Load
B=Back Load F=Front Load Default Value: F |
| 46 | ALLOW_FCST_CONSUME | Character(1) | VARCHAR2(1) NOT NULL |
Allow Forecast Consumption
Y/N Table Edit Default Value: Y |
| 47 | FCST_CONS_SEQ | Character(1) | VARCHAR2(1) NOT NULL |
08/28/01 EGS (CN#PL900-1.0): Added
1=Before Proration 2=After Proration Default Value: 1 |
| 48 | PL_DDD_FCST_CNSMP | Character(1) | VARCHAR2(1) NOT NULL |
Explode Demand for Consumption
Y/N Table Edit Default Value: N |
| 49 | INCL_SO_SHIP | Character(1) | VARCHAR2(1) NOT NULL |
jnw 10/01/99 (cn#mg800-12) added field
Y/N Table Edit Default Value: Y |
| 50 | INCL_MSR_SHIP | Character(1) | VARCHAR2(1) NOT NULL |
jnw 10/01/99 (cn# mg800-12) added field
Y/N Table Edit Default Value: Y |
| 51 | INCL_TFR_SHIP | Character(1) | VARCHAR2(1) NOT NULL |
jnw 10/01/99 (cn# mg800-12) added field
Y/N Table Edit Default Value: Y |
| 52 | PL_NET_CHG_FCST | Character(1) | VARCHAR2(1) NOT NULL |
Net Change Forecast
Y/N Table Edit Default Value: Y |
| 53 | REGEN_FORECAST | Character(1) | VARCHAR2(1) NOT NULL |
07/17/02 EGS (CN#PL880-1): Added
Y/N Table Edit Default Value: N |
| 54 | PLANNING_MODE | Character(1) | VARCHAR2(1) NOT NULL |
Planning Mode
N=Net Change R=Regenerative Default Value: R |
| 55 | SOLVER_ITEM_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
08/28/01 EGS (CN#PL900-1): Added
1=Distribution 2=Master 3=Material 4=All Default Value: 4 |
| 56 | SOLVER_LEVEL_FLG | Character(1) | VARCHAR2(1) NOT NULL |
08/28/01 EGS (CN#PL900-1): Added.
Y/N Table Edit Default Value: N |
| 57 | LOW_LEVEL_CD | Number(3,0) | SMALLINT NOT NULL | 08/16/01 EGS (CN#PL900-1.0): Added |
| 58 | INV_PROD_FAM_CD | Character(10) | VARCHAR2(10) NOT NULL |
Family
Prompt Table: INV_ITEM_FAM |
| 59 | INV_ITEM_GROUP | Character(15) | VARCHAR2(15) NOT NULL |
Item Group
Prompt Table: INV_ITEM_GROUP |
| 60 | PLANNER_CD | Character(12) | VARCHAR2(12) NOT NULL |
Planner Code
Prompt Table: PLANNER_TBL |
| 61 | INV_ITEM_ID | Character(18) | VARCHAR2(18) NOT NULL | Item ID |
| 62 | CATEGORY_ID | Character(5) | VARCHAR2(5) NOT NULL | Category ID |
| 63 | UTILIZ_CD | Character(4) | VARCHAR2(4) NOT NULL |
Utilization Type
Prompt Table: UTILIZ_TYPE_INV |
| 64 | SOLVER_LOWER_FLG | Character(1) | VARCHAR2(1) NOT NULL |
08/28/01 EGS (CN#PL900-1): Added.
Y/N Table Edit Default Value: N |
| 65 | LP_DMD_RUNOVER | Number(3,0) | SMALLINT NOT NULL | Demand Runover |
| 66 | LP_LTSHIPPENALTY | Number(12,2) | DECIMAL(11,2) NOT NULL | Late Ship Penalty |
| 67 | LP_NEGINVPENALTY | Number(12,2) | DECIMAL(11,2) NOT NULL | Negative Invetory Penalty |
| 68 | LP_PRIMSRCPENALTY | Number(12,2) | DECIMAL(11,2) NOT NULL | Primary Sourcing Incentive |
| 69 | LP_SUBSTPENALTY | Number(12,2) | DECIMAL(11,2) NOT NULL | Substitution Penalty |
| 70 | LP_UNSFSTKPENALTY | Number(12,2) | DECIMAL(11,2) NOT NULL | Unsafe Stock Penalty |
| 71 | LP_DEMANDTHRESH | Number(6,2) | DECIMAL(5,2) NOT NULL | Enterprise Solver Demand |
| 72 | LP_RESOLVETHRESH | Number(6,2) | DECIMAL(5,2) NOT NULL | Enterprise Solver Resolve |
| 73 | LP_INVCARRYPENALTY | Number(12,2) | DECIMAL(11,2) NOT NULL | Inventory Carry Over Penalty |
| 74 | LP_INVHOLDPENALTY | Number(12,2) | DECIMAL(11,2) NOT NULL | Inventory Holding Penalty |
| 75 | REGEN_TEMPLATES | Character(1) | VARCHAR2(1) NOT NULL |
Regenerate Sourcing Templates
Y/N Table Edit Default Value: N |
| 76 | PL_SEARCH_DEPTH | Number(2,0) | SMALLINT NOT NULL |
Search Depth
Default Value: 1 |
| 77 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 78 | PROCESSED_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Plan Processed Flag
C=Complete E=Errors N=Initialize P=In Process Y/N Table Edit Default Value: N |
| 79 | PL_COMP_PREC | Number(3,0) | SMALLINT NOT NULL |
10/08/01 EGS (CN#PL900-1): Added.
Default Value: 10 |
| 80 | LOCK_FCST | Character(1) | VARCHAR2(1) NOT NULL |
12/24/01 EGS (CN#PL900-1): Merry Christmas
Y/N Table Edit Default Value: N |
| 81 | LOCK_PRDN | Character(1) | VARCHAR2(1) NOT NULL |
12/24/01 EGS (CN#PL900-1): Merry Christmas
Y/N Table Edit Default Value: N |
| 82 | LOCK_PURCH | Character(1) | VARCHAR2(1) NOT NULL |
12/24/01 EGS (CN#PL900-1): Merry Christmas
Y/N Table Edit Default Value: N |
| 83 | LOCK_XFER | Character(1) | VARCHAR2(1) NOT NULL |
12/24/01 EGS (CN#PL900-1): Merry Christmas
Y/N Table Edit Default Value: N |
| 84 | LOCK_MSR | Character(1) | VARCHAR2(1) NOT NULL |
12/24/01 EGS (CN#PL900-1): Merry Christmas
Y/N Table Edit Default Value: N |
| 85 | LOCK_PLNPRDN | Character(1) | VARCHAR2(1) NOT NULL |
12/24/01 EGS (CN#PL900-1): Merry Christmas
Y/N Table Edit Default Value: N |
| 86 | LOCK_PLNPUR | Character(1) | VARCHAR2(1) NOT NULL |
12/24/01 EGS (CN#PL900-1): Merry Christmas
Y/N Table Edit Default Value: N |
| 87 | LOCK_PLNXFER | Character(1) | VARCHAR2(1) NOT NULL |
12/24/01 EGS (CN#PL900-1): Merry Christmas
Y/N Table Edit Default Value: N |
| 88 | LOCK_QOH | Character(1) | VARCHAR2(1) NOT NULL |
12/26/01 EGS (CN#PL900-1): Added
Y/N Table Edit Default Value: N |
| 89 | LOCK_SO | Character(1) | VARCHAR2(1) NOT NULL |
01/02/02 EGS (CN#PL900-1): Added
Y/N Table Edit Default Value: N |
| 90 | LOCK_BA | Character(1) | VARCHAR2(1) NOT NULL |
05/02/02 JNW (CN#PL900-1): Added
Y/N Table Edit Default Value: N |
| 91 | LOCK_QUO | Character(1) | VARCHAR2(1) NOT NULL |
02/25/02 EGS (CN#PL900-1): Added
Y/N Table Edit Default Value: N |
| 92 | LOCK_USEUP | Character(1) | VARCHAR2(1) NOT NULL |
10/29/02 EGS (CN#PL880-1): Added
Y/N Table Edit Default Value: N |
| 93 | PL_SEQ_NBR_PO | Number(9,0) | DECIMAL(9) NOT NULL | 01/10/02 EGS (CN#PL900-1): Added |
| 94 | PL_SEQ_NBR_PRDN | Number(9,0) | DECIMAL(9) NOT NULL | 01/10/02 EGS (CN#PL900-1): Added |
| 95 | PL_SEQ_NBR_TR | Number(9,0) | DECIMAL(9) NOT NULL | 01/10/02 EGS (CN#PL900-1): Added |
| 96 | PL_SEQ_NBR_EXTDMD | Number(9,0) | DECIMAL(9) NOT NULL |
05/09/02 EGS (CN#PL900-1): Added
Default Value: 1 |
| 97 | PL_USE_FC_SETS | Character(1) | VARCHAR2(1) NOT NULL |
Use Forecast Sets
Y/N Table Edit Default Value: Y |
| 98 | PL_USE_PUB_FC | Character(1) | VARCHAR2(1) NOT NULL |
Use Published Forecasts
Y/N Table Edit Default Value: N |
| 99 | DP_PUBLISH_DATE | Date(10) | DATE | DP_PUBLISH_DATE |
| 100 | DP_PUB_DATE_LAST | Character(1) | VARCHAR2(1) NOT NULL |
03/27/02 PCL (CN#PL900-1.0): Added
Y/N Table Edit Default Value: N |
| 101 | DP_WEIGHTPROFILE | Character(20) | VARCHAR2(20) NOT NULL | DP_WEIGHTPROFILE |
| 102 | DP_PUBLISHNAME | Character(20) | VARCHAR2(20) NOT NULL | Publish Name |
| 103 | PL_DP_ARRAY_FLD | Character(24) | VARCHAR2(24) NOT NULL | Array Name |
| 104 | PL_DP_BU_FLD | Character(24) | VARCHAR2(24) NOT NULL |
Business Unit Field
Default Value: DP_LOCATION |
| 105 | PL_DP_FCST_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Forecast Type
I=Item Based P=Product Based |
| 106 | PL_DP_ITEM_FLD | Character(24) | VARCHAR2(24) NOT NULL |
Item/Product Field
Default Value: DP_ITEMCODE |
| 107 | INV_POLICY | Character(1) | VARCHAR2(1) NOT NULL |
11/25/02 EGS (CN#PL880-1): Added
1=Standard 2=Published 3=Published Override Standard Default Value: 1 |
| 108 | PL_IP_PUBLISHNAME | Character(20) | VARCHAR2(20) NOT NULL | 11/25/02 EGS (CN#PL880-1): Added |
| 109 | PL_IP_PUBLISH_DATE | Date(10) | DATE | 11/25/02 EGS (CN#PL880-1): Added |
| 110 | PL_IP_BU_FLD | Character(24) | VARCHAR2(24) NOT NULL | 01/07/03 EGS (CN#PL880-1): Added |
| 111 | PL_IP_ITEM_FLD | Character(24) | VARCHAR2(24) NOT NULL | 01/07/03 EGS (CN#PL880-1): Added |
| 112 | BASE_CURRENCY | Character(3) | VARCHAR2(3) NOT NULL | "Specifies the primary currency for a general ledger business unit, and is sometimes referred to as the ""book"" currency. Each business unit has one base currency. which is usually, but not always, the local currency for the organization. Journal entries are posted to a business unit in its base currency. " |
| 113 | RT_TYPE | Character(5) | VARCHAR2(5) NOT NULL | Defines a category of market rates for currency conversion. Some examples of rate types are commercial, average, floating, and historical. |
| 114 | PL_SOLVER_INT1 | Number(5,0) | INTEGER NOT NULL | 11/11/02 EGS (CN#PL880-1): Added...generic problem instance values for solvers. 1/13/2011 JWOO: Use PL_SOLVER_INT1 for Ignore Safety Stock option (IGNORE_SAFETY), in show demand transaction. |
| 115 | PL_SOLVER_INT2 | Number(5,0) | INTEGER NOT NULL | 11/11/02 EGS (CN#PL880-1): Added...generic problem instance values for solvers. |
| 116 | PL_SOLVER_INT3 | Number(5,0) | INTEGER NOT NULL | 11/11/02 EGS (CN#PL880-1): Added...generic problem instance values for solvers. |
| 117 | PL_SOLVER_INT4 | Number(5,0) | INTEGER NOT NULL | 11/11/02 EGS (CN#PL880-1): Added...generic problem instance values for solvers. |
| 118 | PL_SOLVER_INT5 | Number(5,0) | INTEGER NOT NULL | 11/11/02 EGS (CN#PL880-1): Added...generic problem instance values for solvers. |
| 119 | PL_SOLVER_INT6 | Number(5,0) | INTEGER NOT NULL | 11/11/02 EGS (CN#PL880-1): Added...generic problem instance values for solvers. |
| 120 | PL_SOLVER_INT7 | Number(5,0) | INTEGER NOT NULL | 11/11/02 EGS (CN#PL880-1): Added...generic problem instance values for solvers. |
| 121 | PL_SOLVER_INT8 | Number(5,0) | INTEGER NOT NULL | 11/11/02 EGS (CN#PL880-1): Added...generic problem instance values for solvers. |
| 122 | PL_SOLVER_INT9 | Number(5,0) | INTEGER NOT NULL | 11/11/02 EGS (CN#PL880-1): Added...generic problem instance values for solvers. |
| 123 | PL_SOLVER_INT10 | Number(5,0) | INTEGER NOT NULL | 11/11/02 EGS (CN#PL880-1): Added...generic problem instance values for solvers. |
| 124 | PL_SOLVER_FLG1 | Character(1) | VARCHAR2(1) NOT NULL |
11/11/02 EGS (CN#PL880-1): Added...generic solver parameter.
Y/N Table Edit Default Value: N |
| 125 | PL_SOLVER_FLG2 | Character(1) | VARCHAR2(1) NOT NULL |
11/11/02 EGS (CN#PL880-1): Added...generic solver parameter.
Y/N Table Edit Default Value: N |
| 126 | PL_SOLVER_FLG3 | Character(1) | VARCHAR2(1) NOT NULL |
11/11/02 EGS (CN#PL880-1): Added...generic solver parameter.
Y/N Table Edit Default Value: N |
| 127 | PL_SOLVER_FLG4 | Character(1) | VARCHAR2(1) NOT NULL |
11/11/02 EGS (CN#PL880-1): Added...generic solver parameter.
Y/N Table Edit Default Value: N |
| 128 | PL_SOLVER_FLG5 | Character(1) | VARCHAR2(1) NOT NULL |
11/11/02 EGS (CN#PL880-1): Added...generic solver parameter.
Y/N Table Edit Default Value: N |
| 129 | PL_SOLVER_FLG6 | Character(1) | VARCHAR2(1) NOT NULL |
11/11/02 EGS (CN#PL880-1): Added...generic solver parameter.
Y/N Table Edit Default Value: N |
| 130 | PL_SOLVER_FLG7 | Character(1) | VARCHAR2(1) NOT NULL |
11/11/02 EGS (CN#PL880-1): Added...generic solver parameter.
Y/N Table Edit Default Value: N |
| 131 | PL_SOLVER_FLG8 | Character(1) | VARCHAR2(1) NOT NULL |
11/11/02 EGS (CN#PL880-1): Added...generic solver parameter.
Y/N Table Edit Default Value: N |
| 132 | PL_SOLVER_FLG9 | Character(1) | VARCHAR2(1) NOT NULL |
11/11/02 EGS (CN#PL880-1): Added...generic solver parameter.
Y/N Table Edit Default Value: N |
| 133 | PL_SOLVER_FLG10 | Character(1) | VARCHAR2(1) NOT NULL |
11/11/02 EGS (CN#PL880-1): Added...generic solver parameter.
Y/N Table Edit Default Value: N |
| 134 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 135 | TEXT254 | Character(254) | VARCHAR2(254) NOT NULL | Text |
| 136 | VERSION | Number(10,0) | DECIMAL(10) NOT NULL | Version. Internal PeopleTools version for controlling caching of object. - Version/Table reference |