PL_POST_REQ(SQL Table) |
Index Back |
|---|---|
Post Updates Request01/17/01 EBN (CN#PL900-1.0): Added for posting changes from planning to the transaction system. |
| # | 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 | PROBINST | Character(20) | VARCHAR2(20) NOT NULL |
Optimization Problem Instance
Prompt Table: SP_PRBINS_NONVW |
| 4 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table: PL_GROUP_INV_VW |
| 5 | PL_POST_INIT_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Initialize Data Types
1=All Data Types 2=Posted Data Types Default Value: 2 |
| 6 | PL_POST_INIT_ITEM | Character(1) | VARCHAR2(1) NOT NULL |
Initialize Items
1=All by Selected Planned By 2=Selected by Planning Instance Default Value: 2 |
| 7 | PL_DISTRIB_PLAN | Character(1) | VARCHAR2(1) NOT NULL |
Distribution Plan
Y/N Table Edit Default Value: Y |
| 8 | PL_MASTER_PLAN | Character(1) | VARCHAR2(1) NOT NULL |
Master Plan
Y/N Table Edit Default Value: Y |
| 9 | PL_MATERIAL_PLAN | Character(1) | VARCHAR2(1) NOT NULL |
Material Plan
Y/N Table Edit Default Value: Y |
| 10 | SHUTDOWN_PI_FLG | Character(1) | VARCHAR2(1) NOT NULL |
01/29/03 EGS (CN#PL880-1): Added
Y/N Table Edit Default Value: N |
| 11 | STARTUP_PI_FLG | Character(1) | VARCHAR2(1) NOT NULL |
01/29/03 EGS (CN#PL880-1): Added.
Y/N Table Edit Default Value: N |
| 12 | URL | Character(254) | VARCHAR2(254) NOT NULL |
Internet URL (Universal Resource Locator)
Prompt Table: SPL_DOMN_URL_VW |