BUSINESS_UNITINV_ITEM_IDCONFIG_CODEPL_USEUP_ITEMS(SQL Table) |
Index Back |
|---|---|
Planning Useup Items10/31/02 JC (CN#PL880-1): Added CONFIG_CODE, PROBINST |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | INV_ITEM_ID |
Character(18) | VARCHAR2(18) NOT NULL | Item ID |
| 3 | CONFIG_CODE |
Character(50) | VARCHAR2(50) NOT NULL | Product Configurator |
| 4 | PL_PROJ_USE_DT | Date(10) | DATE | 11/04/02 JC (CN#PL880-1): Added USEUP_DATE label |
| 5 | PL_PROJ_USE_QOH | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | 11/03/02 JC (CN#PL880-1): Added QOH_USEUP label 12/18/02 EGS (CN#PL880-1): Changed to 11.4. |
| 6 | PROBINST | Character(20) | VARCHAR2(20) NOT NULL | Optimization Problem Instance |
| 7 | PLANNING_TIMESTAMP | DateTime(26) | TIMESTAMP | Planning Date/Time |