PL_EXCEP_CO_DEL

(SQL Table)
Index Back

Exception Counts Delete Record

for reporting

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROBINST Character(20) VARCHAR2(20) NOT NULL Optimization Problem Instance
2 PL_RECORD_DTTM DateTime(26) TIMESTAMP a record timestamp used by PL_RECORD_COUNTS
3 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
4 ERROR_COUNT Number(9,0) DECIMAL(9) NOT NULL Error Count
5 VERSION Number(10,0) DECIMAL(10) NOT NULL Version. Internal PeopleTools version for controlling caching of object. - Version/Table reference