PL_ERROR_CO_DEL(SQL Table) |
Index Back |
---|---|
Error Counts Delete RecordError Counts Delete Record |
# | 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 |