PROBINSTBUSINESS_UNITINV_ITEM_IDBOM_CODERTG_CODEPL_PROD_OPT_VW(SQL View) |
Index Back |
|---|---|
PL_PROD_OPT_VWPL_PROD_OPT_VW |
| SELECT PROBINST , BUSINESS_UNIT , INV_ITEM_ID , BOM_CODE , RTG_CODE FROM PS_PL_PROD_OPT |
| # | 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 |