PROBINSTBUSINESS_UNITINV_ITEM_IDCONFIG_CODEY/N Table Edit
Default Value: N
PL_BU_CFG_ITEMS(SQL Table) |
Index Back |
|---|---|
Planning Configured Items08/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 | CONFIG_CODE |
Character(50) | VARCHAR2(50) NOT NULL | Product Configurator |
| 5 | INV_QTY_DTTM | DateTime(26) | TIMESTAMP | 08/16/01 EGS (CN#PL900-1.0): Added |
| 6 | INV_QTY | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | 08/16/01 EGS (CN#PL900-1.0): Added |
| 7 | QTY_AVAIL | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Quantity Available |
| 8 | QTY_RESERVED | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Quantity Reserved |
| 9 | STAGED_INF_QTY | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | 08/16/01 EGS (CN#PL900-1.0): Added |
| 10 | STAGED_ITEM_QTY | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | 08/16/01 EGS (CN#PL900-1.0): Added |
| 11 | QUAR_QTY | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | 08/16/01 EGS (CN#PL900-1.0): Added |
| 12 | SHIP_NOT_DEPL_QTY | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | 08/16/01 EGS (CN#PL900-1.0): Added |
| 13 | NET_CHANGE_QOH | Character(1) | VARCHAR2(1) NOT NULL |
02/11/02 EGS (CN#PL900-1): Added.
Y/N Table Edit Default Value: N |
| 14 | PL_UNIT_COST | Signed Number(19,4) | DECIMAL(17,4) NOT NULL | 09/27/02 EGS (CN#PL880-1): Changed to 13.4 |
| 15 | PL_PROJ_USE_DT | Date(10) | DATE | 11/04/02 JC (CN#PL880-1): Added USEUP_DATE label |
| 16 | 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. |
| 17 | VERSION | Number(10,0) | DECIMAL(10) NOT NULL | Version. Internal PeopleTools version for controlling caching of object. - Version/Table reference |