4Site
Support Request System
View Patch #50.036.004
Description
Patch ID:
Date Implemented:
Patch Title:
Patch Type:
Request IDs:
Bug
Enhancement
Other
02935 -
Modification to Spares List for Equipment Report
02911 -
Reports enhancements - BOM change and Equipment History Report
Symptoms:
Bills of Materials - addition of the manufacturer part number to the report. Many parts are derived from the maintenance manuals and it requires a lot of time to cross reference the manufacturer number to the stock number. Addition of the manufacturer number to the report will eliminate this problem.
Solution:
Replaced table "r#eqpartslist" with "r_eqpartslist" with additional columns "catalogid" and "mfctpartid" Revised code to include supplier catalog# and manufacturer part# in the SQL Select query which populates the result table "r_eqpartslist" used by the report. Modified table creation and reload scripts to include "catalogid" and "mfctpartid" data. Revisesd Crystal Reports file to use the new result table, and reformatted the report detail section to accommodate the "Catalog #" and "Manufacturer #" data.
Browse Patches
Find a Patch
Return to Request System Menu
