PROBINSTBUSINESS_UNITINV_ITEM_IDSTART_DATEPL_STK_PERIODEL(SQL Table) |
Index Back |
|---|---|
PL Stock Periods Delete10/29/01 EGS (CN#PL900-1): Added, delete table for PL_STK_PERIODS |
| # | 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 | START_DATE |
Date(10) | DATE | Start Date for Gen Standing PO |
| 5 | END_DATE | Date(10) | DATE | End Date |
| 6 | SAFETY_LIMIT | Number(9,0) | DECIMAL(9) NOT NULL | Safety Limit |
| 7 | EXCESS_LIMIT | Number(9,0) | DECIMAL(9) NOT NULL | Excess Limit |
| 8 | VERSION | Number(10,0) | DECIMAL(10) NOT NULL | Version. Internal PeopleTools version for controlling caching of object. - Version/Table reference |