PROBINSTBUSINESS_UNITINV_ITEM_IDBOM_CODERTG_CODEPRODUCTION_TYPEPR=Production
RW=Rework
SV=Service
TD=Teardown
N=Based on Routings
Y=Based on Lead Times
DY=Days
HR=Hours
MN=Minutes
SC=Seconds
DY=Days
HR=Hours
MN=Minutes
SC=Seconds
PL_PROD_OPT(SQL Table) |
Index Back |
|---|---|
Planning Production Options08/16/01 EGS (CN#PL900-1.0): Added |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PROBINST |
Character(20) | VARCHAR2(20) NOT NULL | Optimization Problem Instance |
| 2 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 3 | INV_ITEM_ID |
Character(18) | VARCHAR2(18) NOT NULL | Item ID |
| 4 | BOM_CODE |
Number(2,0) | SMALLINT NOT NULL | CN# EN800-3.0, anna 09/21 added new field to database |
| 5 | RTG_CODE |
Number(2,0) | SMALLINT NOT NULL | Routing Code |
| 6 | PRODUCTION_TYPE |
Character(2) | VARCHAR2(2) NOT NULL |
JNW 11/1/98 (CN#SF800-13) activated teardown xlat
PR=Production RW=Rework SV=Service TD=Teardown |
| 7 | BOM_QTY | Number(7,0) | INTEGER NOT NULL | 06/02/00 LAJ (8.0) Changed field length from 8.0 to 7.0. All other quantity fields have a standardized length of 7, so this change will make bom_qty standard. |
| 8 | MFG_LEAD_TIME_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
08/04/99 MACN (CN#MG800-4.0) Converted from Y/N field to translate field.
N=Based on Routings Y=Based on Lead Times |
| 9 | MFG_LEADTIME_F | Number(3,0) | SMALLINT NOT NULL | 03/10/98 SCC CN# PL750-SCHEW-JV26Y: Changed long/short descr. |
| 10 | MFG_LTRATEF | Character(2) | VARCHAR2(2) NOT NULL |
mfg fixed lead time rate
DY=Days HR=Hours MN=Minutes SC=Seconds |
| 11 | MFG_LEADTIME_V | Number(3,0) | SMALLINT NOT NULL | 03/10/98 SCC CN# PL750-SCHEW-JV26Y: Changed long/short descr. |
| 12 | MFG_LTRATEV | Character(2) | VARCHAR2(2) NOT NULL |
Mfg var lead time rate
DY=Days HR=Hours MN=Minutes SC=Seconds |
| 13 | MFG_MIN_ORDER | Number(12,4) | DECIMAL(11,4) NOT NULL | CN#PL800-18.0 MACN 11/02/99 - Changed short description from Minimum Order to Min Order Qty. jnw 01/20/00 di-jwillia2-2 - expanded field format from 7.0 to 7.4 KPN 08/23/02: Added label PL_MIN_ORDER |
| 14 | MFG_MAX_ORDER | Number(12,4) | DECIMAL(11,4) NOT NULL | jnw 01/20/00 di-jwillia2-2 - expanded field format from 7.0 to 7.4 KPN 08/23/02: Added label PL_MAX_ORDER |
| 15 | MFG_ORDER_MULTIPLE | Number(12,4) | DECIMAL(11,4) NOT NULL | jnw 01/20/00 di-jwillia2-2 - expanded field format from 7.0 to 7.4 |
| 16 | CUM_YIELD | Number(8,4) | DECIMAL(7,4) NOT NULL | Expected Yield % |
| 17 | PL_UNIT_COST | Signed Number(19,4) | DECIMAL(17,4) NOT NULL | 09/27/02 EGS (CN#PL880-1): Changed to 13.4 |
| 18 | VERSION | Number(10,0) | DECIMAL(10) NOT NULL | Version. Internal PeopleTools version for controlling caching of object. - Version/Table reference |