PRCSINSTANCEPL_RECORD_DTTMPROBINSTBUSINESS_UNITINV_ITEM_IDCONFIG_CODEFROM_DATEPL_PASSED_FILTERPL_EXCP_EXCSSTK(SQL Table) |
Index Back |
|---|---|
PL_EXCP_EXCSSTKPL_EXCP_EXCSSTK |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PRCSINSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | PL_RECORD_DTTM |
DateTime(26) | TIMESTAMP | a record timestamp used by PL_RECORD_COUNTS |
| 3 | PROBINST |
Character(20) | VARCHAR2(20) NOT NULL | Optimization Problem Instance |
| 4 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 5 | INV_ITEM_ID |
Character(18) | VARCHAR2(18) NOT NULL | Item ID |
| 6 | CONFIG_CODE |
Character(50) | VARCHAR2(50) NOT NULL | Product Configurator |
| 7 | FROM_DATE |
Date(10) | DATE | From Date |
| 8 | PL_PASSED_FILTER |
Character(1) | VARCHAR2(1) NOT NULL | PL_PASSED_FILTER |
| 9 | TO_DATE | Date(10) | DATE | To Date |
| 10 | PL_DURATION | Signed Number(8,2) | DECIMAL(6,2) NOT NULL | PL_DURATION |
| 11 | PL_MAX_EXCESS_QTY | Number(16,4) | DECIMAL(15,4) NOT NULL | PL_MAX_EXCESS_QTY |
| 12 | EXCESS_LIMIT | Number(9,0) | DECIMAL(9) NOT NULL | Excess Limit |