PL_ERRCNTGRID2(SQL Table) |
Index Back |
---|---|
PL_ERRCNTGRID2PL_ERRCNTGRID2 |
# | 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 | PL_ERROR_CODE | Character(4) | VARCHAR2(4) NOT NULL |
ERROR CODES USED BY PL_ERROR_COUNTS RECORD
E001=Negative Projected Quantity E002=Safety Stock E003=Work Center Capacity E004=Operations Without Capacity E005=Customer Order Ship Dates E006=Transfer Ship Dates E007=Extra Demand Ship Dates E008=Stock Request Ship Dates E009=Forecast Fulfillment E010=Production Supply Shortages E011=Purchase Material Shortages E012=Transfer Supply Shortages E101=Invalid Ship Dates E102=Invalid Receiving Dates E103=Plnd Supply Before Early Fence E104=Receipt before Current Time E105=Production Opt not Effectiv E106=BOM Components not Effective E107=Substitute Comp not Effective E108=Supply Occurs After Phase Out E109=Invalid BOM Structure E110=Supplier Capacity Exceeded E111=Excess Limit Exceeded E112=Order Quantity Below Minimum E113=Order Quantity Above Maximum E114=Order Quantity not Increment E115=Missed Request Dates E116=Substitutions |
5 | PL_MESSAGE_TEXT | Character(100) | VARCHAR2(100) NOT NULL | PL_MESSAGE_TEXT |
6 | PL_COUNT_FILTERED | Number(9,0) | DECIMAL(9) NOT NULL | PL_COUNT_FILTERED |
7 | PL_COUNT_TOTAL | Number(9,0) | DECIMAL(9) NOT NULL | PL_COUNT_TOTAL |