| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 2 |
OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
|
| 3 |
RUN_CNTL_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Run Control ID
|
| 4 |
DT_TIMESTAMP |
DateTime(26) |
TIMESTAMP |
Date Timestamp
|
| 5 |
PROBINST |
Character(20) |
VARCHAR2(20) NOT NULL |
Optimization Problem Instance
|
| 6 |
BU_GROUP |
Character(6) |
VARCHAR2(6) NOT NULL |
08/16/01 EGS (CN#PL880-1.0): Added
|
| 7 |
DBR_RUN_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Run Type
N=Net Change
R=Regenerative
S=Regenerative Select
|
| 8 |
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. "
|
| 9 |
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.
|
| 10 |
REGEN_DTTM |
DateTime(26) |
TIMESTAMP |
09/07/01 EGS (CN#PL900-1): Added.
|
| 11 |
UPDATE_DTTM |
DateTime(26) |
TIMESTAMP |
02/28/02 EGS (CN#PL900-1): Added
|
| 12 |
PROCESS_DTTM |
DateTime(26) |
TIMESTAMP |
Process Date Time
|
| 13 |
START_OFFSET |
Signed Number(6,0) |
DECIMAL(5) NOT NULL |
Start Fence
|
| 14 |
END_OFFSET |
Signed Number(6,0) |
DECIMAL(5) NOT NULL |
End Fence
|
| 15 |
START_DATE |
Date(10) |
DATE |
Start Date for Gen Standing PO
|
| 16 |
END_DATE |
Date(10) |
DATE |
End Date
|
| 17 |
CAL_START_DATE |
Date(10) |
DATE |
12/04/02 EGS (CN#PL880-1): Added
|
| 18 |
CAL_END_DATE |
Date(10) |
DATE |
Calendar End Date
|
| 19 |
PLAN_START_DTTM |
DateTime(26) |
TIMESTAMP |
08/29/01 EGS (CN#PL900-1): Added.
|
| 20 |
PLAN_END_DTTM |
DateTime(26) |
TIMESTAMP |
08/29/01 EGS (CN#PL900-1): Added.
|
| 21 |
EARLY_FENCE |
Signed Number(6,0) |
DECIMAL(5) NOT NULL |
Early Fence
|
| 22 |
ITEM_EARLY_FENCE |
Signed Number(4,0) |
DECIMAL(3) NOT NULL |
09/07/01 EGS (CN#PL900-1): Added.
|
| 23 |
GBL_EARLY_FENCE |
Character(1) |
VARCHAR2(1) NOT NULL |
09/07/01 EGS (CN#PL900-1): Added.
|
| 24 |
EARLY_DATE |
Date(10) |
DATE |
08/31/01 EGS (CN#PL900-1): Added.
|
| 25 |
LATE_FENCE |
Signed Number(6,0) |
DECIMAL(5) NOT NULL |
Late Fence
|
| 26 |
LATE_DATE |
Date(10) |
DATE |
08/31/01 EGS (CN#PL900-1): Added.
|
| 27 |
CAP_FENCE_OFF |
Signed Number(6,0) |
DECIMAL(5) NOT NULL |
Capacity Fence
|
| 28 |
CAPACITY_DATE |
Date(10) |
DATE |
08/31/01 EGS (CN#PL900-1): Added.
|
| 29 |
FCST_FULFILL_OFF |
Signed Number(4,0) |
DECIMAL(3) NOT NULL |
Forecast Fulfillment Fence
|
| 30 |
FCST_FULFILL_DATE |
Date(10) |
DATE |
08/31/01 EGS (CN#PL900-1): Added.
|
| 31 |
CURRENT_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
08/07/02 EGS (CN#PL880-1): Added.
10/18/02 JC (CN#PL880-1):Added FROM label
1=Date
2=Offset
|
| 32 |
CURRENT_DATE1 |
Date(10) |
DATE |
12/20/01 EGS (CN#PL900-1): Added
10/07/02 JC (CN#PL880-1): Added FROM_DATE label
|
| 33 |
CURRENT_OFFSET |
Signed Number(6,0) |
DECIMAL(5) NOT NULL |
09/05/01 EGS (CN#PL900-1): Added.
10/07/02 JC (CN#PL880-1): Added FROM_OFFSET label
|
| 34 |
CURRENT_DTTM |
DateTime(26) |
TIMESTAMP |
08/27/01 EGS (CN#PL900-1.0): Added
|
| 35 |
DEMAND_FENCE_DATE |
Date(10) |
DATE |
08/16/01 EGS (CN#PL900-1.0): Added
|
| 36 |
DATE_VALUE |
Date(10) |
DATE |
Date Value
|
| 37 |
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
|
| 38 |
SPL_FREEZE_PEGGED |
Character(1) |
VARCHAR2(1) NOT NULL |
11/02/2004 NRA: Added
Default Value: Y
|
| 39 |
INCL_SALES_ORDERS |
Character(1) |
VARCHAR2(1) NOT NULL |
03/10/98 SCC CN# PL750-SCHEW-JV26Y: Changed long/short descr.
|
| 40 |
INCL_QUOTES |
Character(1) |
VARCHAR2(1) NOT NULL |
03/10/98 SCC CN# PL750-SCHEW-JV26Y: Changed long/short descr.
|
| 41 |
INCL_BUYING_AGREE |
Character(1) |
VARCHAR2(1) NOT NULL |
05/02/02 JNW (CN#PL900-1): Added
|
| 42 |
INCL_STOCK_REQUEST |
Character(1) |
VARCHAR2(1) NOT NULL |
03/10/98 SCC CN# PL750-SCHEW-JV26Y: Changed long/short descr.
|
| 43 |
INCL_TFR_DEMAND |
Character(1) |
VARCHAR2(1) NOT NULL |
03/10/98 SCC CN# PL750-SCHEW-JV26Y: Changed long/short descr.
|
| 44 |
INCL_TFR_PL_DEMAND |
Character(1) |
VARCHAR2(1) NOT NULL |
03/10/98 SCC CN# PL750-SCHEW-JV26Y: Changed long/short descr.
|
| 45 |
INCL_FORECAST |
Character(1) |
VARCHAR2(1) NOT NULL |
03/10/98 SCC CN# PL750-SCHEW-JV26Y: Changed long/short descr.
|
| 46 |
INCL_PURCH_ORDERS |
Character(1) |
VARCHAR2(1) NOT NULL |
03/10/98 SCC CN# PL750-SCHEW-JV26Y: Changed long/short descr.
|
| 47 |
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
|
| 48 |
INCL_TFR_SUPPLY |
Character(1) |
VARCHAR2(1) NOT NULL |
03/10/98 SCC CN# PL750-SCHEW-JV26Y: Changed long/short descr.
|
| 49 |
INCL_PL_PURCH_ORD |
Character(1) |
VARCHAR2(1) NOT NULL |
03/10/98 SCC CN# PL750-SCHEW-JV26Y: Changed long/short descr.
|
| 50 |
INCL_PL_PROD_ORD |
Character(1) |
VARCHAR2(1) NOT NULL |
03/10/98 SCC CN# PL750-SCHEW-JV26Y: Changed long/short descr.
|
| 51 |
INCL_TFR_PL_SUPPLY |
Character(1) |
VARCHAR2(1) NOT NULL |
03/10/98 SCC CN# PL750-SCHEW-JV26Y: Changed long/short descr.
|
| 52 |
INCL_PRIORITIES |
Character(1) |
VARCHAR2(1) NOT NULL |
Apply Demand Priorities
|
| 53 |
INCL_CAL |
Character(1) |
VARCHAR2(1) NOT NULL |
09/17/01 EGS (CN#PL900-1): Added
|
| 54 |
INCL_QOH |
Character(1) |
VARCHAR2(1) NOT NULL |
09/03/01 EGS (CN#PL900-1): Added.
|
| 55 |
INCL_PURCH_CLOSED |
Character(1) |
VARCHAR2(1) NOT NULL |
INCL_PURCH_CLOSED
|
| 56 |
FIRM_PLAN_ONLY |
Character(1) |
VARCHAR2(1) NOT NULL |
09/23/02 EGS (CN#PL880-1): Added.
|
| 57 |
NET_CHANGE_QOH |
Character(1) |
VARCHAR2(1) NOT NULL |
02/11/02 EGS (CN#PL900-1): Added.
|
| 58 |
AUTO_MASS_MAINT |
Character(1) |
VARCHAR2(1) NOT NULL |
Auto Mass Maintenance
|
| 59 |
POST_LOAD_SOLVER |
Character(1) |
VARCHAR2(1) NOT NULL |
Run Solver after Load
1=Material Solver
2=Feasible Solver
3=Enterprise Feasible Solver
|
| 60 |
QUOTE_PERCENT |
Number(3,0) |
SMALLINT NOT NULL |
Acceptance Percentage
|
| 61 |
PL_FORECAST_SOURCE |
Character(1) |
VARCHAR2(1) NOT NULL |
PL_FORECAST_SOURCE
N=No Forecast
P=Published Forecasts
S=Forecast Sets
|
| 62 |
FORECAST_SOURCE |
Character(1) |
VARCHAR2(1) NOT NULL |
08/28/01 EGS (CN#PL900-1): Added
1=Inventory
2=Demand Planning
|
| 63 |
FORECAST_SET |
Character(20) |
VARCHAR2(20) NOT NULL |
Forecast Set
|
| 64 |
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
|
| 65 |
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
|
| 66 |
FORECAST_LOAD |
Character(1) |
VARCHAR2(1) NOT NULL |
Forecast Load
B=Back Load
F=Front Load
|
| 67 |
ALLOW_FCST_CONSUME |
Character(1) |
VARCHAR2(1) NOT NULL |
Allow Forecast Consumption
|
| 68 |
FCST_CONS_SEQ |
Character(1) |
VARCHAR2(1) NOT NULL |
08/28/01 EGS (CN#PL900-1.0): Added
1=Before Proration
2=After Proration
|
| 69 |
FCST_CONS_EDATE |
Date(10) |
DATE |
09/11/01 JNW (CN#PL900-1): Added
|
| 70 |
FCST_CONS_SDATE |
Date(10) |
DATE |
09/11/01 JNW (CN#PL900-1): Added
|
| 71 |
FCST_CONS_SDTTM |
DateTime(26) |
TIMESTAMP |
FCST_CONS_SDTTM
|
| 72 |
FCST_CONS_EDTTM |
DateTime(26) |
TIMESTAMP |
FCST_CONS_EDTTM
|
| 73 |
PL_DDD_FCST_CNSMP |
Character(1) |
VARCHAR2(1) NOT NULL |
Explode Demand for Consumption
|
| 74 |
INCL_SO_SHIP |
Character(1) |
VARCHAR2(1) NOT NULL |
jnw 10/01/99 (cn#mg800-12) added field
|
| 75 |
INCL_MSR_SHIP |
Character(1) |
VARCHAR2(1) NOT NULL |
jnw 10/01/99 (cn# mg800-12) added field
|
| 76 |
INCL_TFR_SHIP |
Character(1) |
VARCHAR2(1) NOT NULL |
jnw 10/01/99 (cn# mg800-12) added field
|
| 77 |
PL_NET_CHG_FCST |
Character(1) |
VARCHAR2(1) NOT NULL |
Net Change Forecast
|
| 78 |
PLANNING_MODE |
Character(1) |
VARCHAR2(1) NOT NULL |
Planning Mode
N=Net Change
R=Regenerative
|
| 79 |
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
|
| 80 |
SOLVER_LEVEL_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
08/28/01 EGS (CN#PL900-1): Added.
|
| 81 |
LOW_LEVEL_CD |
Number(3,0) |
SMALLINT NOT NULL |
08/16/01 EGS (CN#PL900-1.0): Added
|
| 82 |
INV_PROD_FAM_CD |
Character(10) |
VARCHAR2(10) NOT NULL |
Family
|
| 83 |
INV_ITEM_GROUP |
Character(15) |
VARCHAR2(15) NOT NULL |
Item Group
|
| 84 |
PLANNER_CD |
Character(12) |
VARCHAR2(12) NOT NULL |
Planner Code
|
| 85 |
INV_ITEM_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
Item ID
|
| 86 |
CATEGORY_ID |
Character(5) |
VARCHAR2(5) NOT NULL |
Category ID
|
| 87 |
UTILIZ_CD |
Character(4) |
VARCHAR2(4) NOT NULL |
Utilization Type
|
| 88 |
SOLVER_LOWER_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
08/28/01 EGS (CN#PL900-1): Added.
|
| 89 |
LP_DMD_RUNOVER |
Number(3,0) |
SMALLINT NOT NULL |
Demand Runover
|
| 90 |
LP_LTSHIPPENALTY |
Number(12,2) |
DECIMAL(11,2) NOT NULL |
Late Ship Penalty
|
| 91 |
LP_NEGINVPENALTY |
Number(12,2) |
DECIMAL(11,2) NOT NULL |
Negative Invetory Penalty
|
| 92 |
LP_PRIMSRCPENALTY |
Number(12,2) |
DECIMAL(11,2) NOT NULL |
Primary Sourcing Incentive
|
| 93 |
LP_SUBSTPENALTY |
Number(12,2) |
DECIMAL(11,2) NOT NULL |
Substitution Penalty
|
| 94 |
LP_UNSFSTKPENALTY |
Number(12,2) |
DECIMAL(11,2) NOT NULL |
Unsafe Stock Penalty
|
| 95 |
LP_RESOLVETHRESH |
Number(6,2) |
DECIMAL(5,2) NOT NULL |
Enterprise Solver Resolve
|
| 96 |
LP_DEMANDTHRESH |
Number(6,2) |
DECIMAL(5,2) NOT NULL |
Enterprise Solver Demand
|
| 97 |
LP_INVHOLDPENALTY |
Number(12,2) |
DECIMAL(11,2) NOT NULL |
Inventory Holding Penalty
|
| 98 |
LP_INVCARRYPENALTY |
Number(12,2) |
DECIMAL(11,2) NOT NULL |
Inventory Carry Over Penalty
|
| 99 |
REGEN_TEMPLATES |
Character(1) |
VARCHAR2(1) NOT NULL |
Regenerate Sourcing Templates
|
| 100 |
PL_SEARCH_DEPTH |
Number(2,0) |
SMALLINT NOT NULL |
Search Depth
|
| 101 |
DATE_WRK |
Date(10) |
DATE |
Date Work Field
|
| 102 |
SETID_INV_ITEM |
Character(5) |
VARCHAR2(5) NOT NULL |
Inv Items SETID
|
| 103 |
TRANSACTION_LOCKED |
Character(1) |
VARCHAR2(1) NOT NULL |
"An internal work field that
|
| 104 |
CK_PROC_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 105 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
|
| 106 |
DEMAND_FENCE_OF |
Signed Number(9,2) |
DECIMAL(7,2) NOT NULL |
Demand Time Fence [days]
|
| 107 |
DAYOFWEEK |
Number(1,0) |
SMALLINT NOT NULL |
Day of Week
|
| 108 |
DAY_OFWEEK |
Character(1) |
VARCHAR2(1) NOT NULL |
Day
0=0: Sunday
1=1: Monday
2=2: Tuesday
3=3 :Wednesday
4=4: Thursday
5=5: Friday
6=6: Saturday
|
| 109 |
CONTINUATION_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Continuation Flag
|
| 110 |
AE_APPLID |
Character(12) |
VARCHAR2(12) NOT NULL |
Program Name (see PSAEAPPLDEFN).
|
| 111 |
AE_SECTION |
Character(8) |
VARCHAR2(8) NOT NULL |
Section
|
| 112 |
PL_CALENDAR_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
08/16/01 EGS (CN#PL900-1.0): Added
1=Manufacturing
2=Receiving
3=Shipping
|
| 113 |
AE_SQLID |
Character(30) |
VARCHAR2(30) NOT NULL |
SQL Object Identifier
|
| 114 |
DUMMY_FIELD |
Character(1) |
VARCHAR2(1) NOT NULL |
Dummy Field for Hiding Groups
|
| 115 |
PL_ITEM_PREC |
Number(3,0) |
SMALLINT NOT NULL |
10/08/01 EGS (CN#PL900-1): Added.
Default Value: 4
|
| 116 |
PL_COMP_PREC |
Number(3,0) |
SMALLINT NOT NULL |
10/08/01 EGS (CN#PL900-1): Added.
Default Value: 10
|
| 117 |
QPA_ROUNDING |
Number(2,0) |
SMALLINT NOT NULL |
QPA Rounding Precision
|
| 118 |
CALENDAR_CODE |
Character(10) |
VARCHAR2(10) NOT NULL |
This code is for a group of dates associated with exchange (stock, money, commodity) traded future or option contracts.
|
| 119 |
MIN_DATE |
Date(10) |
DATE |
10/09/01 EGS (CN#PL900-1): Added
|
| 120 |
MAX_DATE |
Date(10) |
DATE |
10/09/01 EGS (CN#PL900-1): Added.
|
| 121 |
TIME_FROM |
Time(15) |
TIMESTAMP |
From Time
|
| 122 |
TIME_TO |
Time(15) |
TIMESTAMP |
To Time
|
| 123 |
WHERE_CLAUSE_LONG |
Long Character(4000) |
CLOB |
Where Clause
|
| 124 |
WHERE_CLAUSE1 |
Character(254) |
VARCHAR2(254) NOT NULL |
Where Clause
|
| 125 |
WHERE_CLAUSE2 |
Character(254) |
VARCHAR2(254) NOT NULL |
Where Clause
|
| 126 |
WHERE_CLAUSE3 |
Character(254) |
VARCHAR2(254) NOT NULL |
Where Clause
|
| 127 |
FROM_CLAUSE |
Character(254) |
VARCHAR2(254) NOT NULL |
From Clause
|
| 128 |
SELECT_CLAUSE |
Character(254) |
VARCHAR2(254) NOT NULL |
Select Clause
|
| 129 |
SELECT_CLAUSE2 |
Character(254) |
VARCHAR2(254) NOT NULL |
Select Clause 2
|
| 130 |
PO |
Character(1) |
VARCHAR2(1) NOT NULL |
Purchasing
Y/N Table Edit
Default Value: N
|
| 131 |
MG |
Character(1) |
VARCHAR2(1) NOT NULL |
Manufacturing
Y/N Table Edit
Default Value: N
|
| 132 |
OM |
Character(1) |
VARCHAR2(1) NOT NULL |
Order Management
Y/N Table Edit
Default Value: N
|
| 133 |
PL_SEQ_NBR_PO |
Number(9,0) |
DECIMAL(9) NOT NULL |
01/10/02 EGS (CN#PL900-1): Added
|
| 134 |
PL_SEQ_NBR_PRDN |
Number(9,0) |
DECIMAL(9) NOT NULL |
01/10/02 EGS (CN#PL900-1): Added
|
| 135 |
PL_SEQ_NBR_TR |
Number(9,0) |
DECIMAL(9) NOT NULL |
01/10/02 EGS (CN#PL900-1): Added
|
| 136 |
MESSAGE_PARM |
Character(254) |
VARCHAR2(254) NOT NULL |
Message Parameter Text
|
| 137 |
MESSAGE_PARM1 |
Character(30) |
VARCHAR2(30) NOT NULL |
Message Parameter 1
|
| 138 |
MESSAGE_NBR |
Number(5,0) |
INTEGER NOT NULL |
Message Number. This field refers to the Message Number in the Message Catalog.
|
| 139 |
PL_USE_FC_SETS |
Character(1) |
VARCHAR2(1) NOT NULL |
Use Forecast Sets
Y/N Table Edit
Default Value: Y
|
| 140 |
PL_USE_PUB_FC |
Character(1) |
VARCHAR2(1) NOT NULL |
Use Published Forecasts
Y/N Table Edit
Default Value: N
|
| 141 |
DP_PUBLISH_DATE |
Date(10) |
DATE |
DP_PUBLISH_DATE
|
| 142 |
DP_PUB_DATE_LAST |
Character(1) |
VARCHAR2(1) NOT NULL |
03/27/02 PCL (CN#PL900-1.0): Added
|
| 143 |
DP_WEIGHTPROFILE |
Character(20) |
VARCHAR2(20) NOT NULL |
DP_WEIGHTPROFILE
|
| 144 |
DP_PUBLISHNAME |
Character(20) |
VARCHAR2(20) NOT NULL |
Publish Name
|
| 145 |
PL_DP_ARRAY_FLD |
Character(24) |
VARCHAR2(24) NOT NULL |
Array Name
|
| 146 |
PL_DP_BU_FLD |
Character(24) |
VARCHAR2(24) NOT NULL |
Business Unit Field
Default Value: DP_LOCATION
|
| 147 |
PL_DP_FCST_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Forecast Type
I=Item Based
P=Product Based
|
| 148 |
PL_DP_ITEM_FLD |
Character(24) |
VARCHAR2(24) NOT NULL |
Item/Product Field
Default Value: DP_ITEMCODE
|
| 149 |
INV_POLICY |
Character(1) |
VARCHAR2(1) NOT NULL |
11/25/02 EGS (CN#PL880-1): Added
1=Standard
2=Published
3=Published Override Standard
|
| 150 |
PL_IP_PUBLISHNAME |
Character(20) |
VARCHAR2(20) NOT NULL |
11/25/02 EGS (CN#PL880-1): Added
|
| 151 |
PL_IP_PUBLISH_DATE |
Date(10) |
DATE |
11/25/02 EGS (CN#PL880-1): Added
|
| 152 |
PL_IP_BU_FLD |
Character(24) |
VARCHAR2(24) NOT NULL |
01/07/03 EGS (CN#PL880-1): Added
|
| 153 |
PL_IP_ITEM_FLD |
Character(24) |
VARCHAR2(24) NOT NULL |
01/07/03 EGS (CN#PL880-1): Added
|
| 154 |
DEL_EXTRA_DMD |
Character(1) |
VARCHAR2(1) NOT NULL |
02/28/02 EGS (CN#PL900-1): Added
|
| 155 |
MULTI_PROC |
Character(1) |
VARCHAR2(1) NOT NULL |
06/11/02 EGS (CN#PL900-1): Added.
|
| 156 |
RUN_CNTL_ID_PI |
Character(30) |
VARCHAR2(30) NOT NULL |
06/17/02 EGS (CN#PL900-1): Added
|
| 157 |
DEM_SUP_TYPE |
Character(2) |
VARCHAR2(2) NOT NULL |
06/17/02 EGS (CN#PL900-1): Added.
01=Sales Orders
02=Quotes
03=Buying Agreement
04=Stock Request
05=Transfer Demand
06=Planned Transfer Demand
07=Forecast
08=Purchase Orders
09=Production Orders
10=Transfer Supply
11=Planned Purchase Orders
12=Planned Production Orders
13=Planned Transfer Supply
14=Quantity On Hand
|
| 158 |
PROCESS_INSTANCE2 |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 159 |
PL_BU_LIST |
Character(254) |
VARCHAR2(254) NOT NULL |
Business Unit List
|
| 160 |
DUMMY_NUM |
Number(6,0) |
INTEGER NOT NULL |
DUMMY NUM
|
| 161 |
JOBINSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Job Instance
|
| 162 |
PI_STATUS |
Signed Number(4,0) |
DECIMAL(3) NOT NULL |
11/11/02 EGS (CN#PL880-1): Added
|
| 163 |
NUMROWS |
Number(15,0) |
DECIMAL(15) NOT NULL |
Number of Rows fetched.
|
| 164 |
SHUTDOWN_PI_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
01/29/03 EGS (CN#PL880-1): Added
|
| 165 |
STARTUP_PI_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
01/29/03 EGS (CN#PL880-1): Added.
|
| 166 |
URL |
Character(254) |
VARCHAR2(254) NOT NULL |
Internet URL (Universal Resource Locator)
|
| 167 |
SCM_INTEGRATION |
Character(2) |
VARCHAR2(2) NOT NULL |
02/11/03 EGS (CN#PL880-1): Added
1=Release 8.8
|
| 168 |
ERROR_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Error Flag
|
| 169 |
PL_PO_LEAD_TIME |
Number(10,0) |
DECIMAL(10) NOT NULL |
11/01/01 PCL (CN#PL900-1): Added
|
| 170 |
ITEM_EARLY_DATE |
Date(10) |
DATE |
08/16/01 EGS (CN#PL900-1.0): Added
|
| 171 |
DBTYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Database Type
0=SQLBase
1=DB2
2=Oracle
3=Informix
4=DB2/UNIX
5=AllBase
6=Sybase
7=Microsoft
8=DB2/400
|