PL_CYCLE_DTL_RQ(SQL Table) |
Index Back |
---|---|
PL_CYCLE_DTL_RQPL_CYCLE_DTL_RQ |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | OPRID | Character(30) | VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
Prompt Table: OPRID_VW |
2 | RUN_CNTL_ID | Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
3 | PL_SEQ_NBR | Number(9,0) | DECIMAL(9) NOT NULL | 01/09/02 EGS (CN#PL900-1): Added |
4 | STEP | Number(2,0) | SMALLINT NOT NULL | Step |
5 | PLAN_PROCESS_TYPE | Character(2) | VARCHAR2(2) NOT NULL |
PLAN_PROCESS_TYPE
1=Start Planning Engine 10=Load Planning Instance 11=Shutdown Planning Engine 15=Mass Maintenance 20=Initiate Material Solver 30=Extract Demand Violations 35=Post Updates 40=Initiate Feasible Solver 45=Initiate Forecast Consumption 50=Extract Pegging Information 55=Planning Report 60=Excess Stock Report 65=Capacity Report 70=Detail Resources Report 75=PO Auto Sourcing Option 80=Slow Moving Inventory Report 85=Projected Stock Out Report 90=Planning Reschedule Report 92=Planning Updates Report 94=Planning Useup Report 96=Apply Inventory Updates 98=Apply Production Updates |
6 | RUN_CNTL_ID2 | Character(30) | VARCHAR2(30) NOT NULL |
Run Control ID
Prompt Table: %EDITTABLE |
7 | URL | Character(254) | VARCHAR2(254) NOT NULL |
Internet URL (Universal Resource Locator)
Prompt Table: SPL_DOMN_URL_VW |
8 | SELECT_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Selection Flag
N=No Y=Yes |