PL_ERRCNTGRID4

(SQL Table)
Index Back

PL_ERRCNTGRID4

PL_ERRCNTGRID4

# 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