The records I want to keep include:
Assets: Production Equipment (over 50 pcs 5 main types), HVAC equipment (25pcs), Emergency Lighting Equipment (30pcs 3 types), Fire Extinguishers (20pcs), and more
Parts and Supplies: example: 20 parts used for Prod. Equip. repairs across 5 suppliers with differeing costs.
Manufacturers: Info for Purchase Order forms, Manuf. Tech dept Contact info, Manuf Sales contact info for sending units in or ordering parts (this has overlap with supplier table I will need to resolve)
Suppliers: The suppliers for the parts and their contact info.
Cost: Latest prices for parts available from more than one supplier.
Maintenance Records: Any monthly, annual, or scheduled maintenance, as well as repairs and ongoing status updates regarding equipment.
Location: To help differentiate simple assets like emergency lighting, or fire extinguishers, but also for seperating records for futrue proofing, we have 2 building and may consolidate, as well as move some departmentss/ equipment. Location can also be used for inventory, to say these bulbs are stored in this storage area, and those toilet repair parts are stored in a different storage area.
Ideally I want to also record:
Asset to Asset Assignment: Production equipment has interchangeability, so printers can be swapped from this autmoated duplicator to that one, or into my shop for repairs, then put back onto a different automated duplicator then it was removed from.
Inventory: Inventory of parts and suppliers on hand, like filters, belts, as well as specific repair parts for production equipment.
Repair or user Manual/materials: Some sort of location guidance to pdf files, or physical folders in file cabinet, etc
Service Companies: Contact info for service companies HVAC, plumbers, etc. Possibly with records of what they did, and on what PO.