PRODUCT DATASHEET
Date released~ June 18, 2020.
Summary – 4CSQL Features
• Multi-site organization capability.
• Asset hierarchy.
• Multilingual – 4CSQL supports many languages including Thai.
• Custom re-labeling of fields.
• Work Request & Work order management.
• Preventive Maintenance: Time based & Meter based
scheduling.
• Materials (store) & Purchase Order management.
• Web (Online) – work request module.
• Supports creation of custom reports.
• Data “Export to Excel” widely available.
• Can be centrally installed and operated with Citrix or Windows
Remote Desktop Services servers.
• 3 application add-Ons, “Email Notification Dispatcher, “Remote
Web Request” & “4C Mobile”.
Date released~ June 18, 2020.
4CSQL- Modules & Features
• Track internal work requests and prioritise it. • Register employee details.
• Generate work orders from the work requests. A click • Register employee hourly rates inclusive of overtime rates.
of a button to generate work orders from a valid work • Control user permissions and access to all modules in the application.
request. • Assign Site permissions which takes effect in all other modules.
• User can view the status of the work request and the
work orders.
• Attach files to a work request and email a work
request. • Captures location / functional location data.
• Displays Work Order details by location.
• Limit records displayed in the Location List to only display
• Record asset nameplate information.
records for Sites assigned to the logged in user in
• Displays Work Order histories and total maintenance
Administration – Employees / Users.
costs.
• Ability to attach document to assets.
• Track movement of assets via the Assets Transfer
feature. • Full suite of reports.
• Comprehensive Excel style filtering capabilities via the • Fast screen based filter and search list reports for fast
asset list with export to Excel capability for easy reporting.
reporting. • Export to MS Excel for easy report writing on a familiar
platform.
Date released~ June 18, 2020.
• Track information on orders, purchases and receipt. • Register part items and specify maximum, re-order, minimum
• Able to capture Discounts, Taxes, GST & Freight Charges. levels and re-order quantities within individual holding
• Supports multiple currencies. stores within a site.
• Fully or partially receive items ordered in the Good Receive • Generates Purchase Proposals for part items where the stock
Module (GRN). balance is below re-order or minimum levels in the
• Email Purchase Orders to approvers or suppliers. designated store.
• Print Purchase Order on “Base Currency” or “Foreign Currency”. • Print bar code labels for part items.
• Register and manage allocation of Tools to employees.
• Record & track who, what, where, why, when and how of each maintenance work.
• Record & track employee labour hours and labour costs.
• Integrated to the materials module to track materials (parts) consumed and costs.
• Show PM work orders materials requirements forecast.
• Integrated to the Purchase Order Module to display all Purchase Orders raised against the Work Order no.
• Ability to Email Work Orders to assigned employees or suppliers.
• Limit records displayed in the Work Order List to only display records for Sites assigned to the logged in user in Administration – Employees / Users.
• Schedule Preventive Work Orders based on Time Intervals.
• Three (3) time-based scheduling methods are supported;
o Fixed Time Interval/Based: For example, every 7 days, 28 days, 365 days etc. This scheduling type allows generation of the next PM Work Order by
actual complete date as opposed to only scheduled date.
o Fixed Day & Week: This method of scheduling allows users to specify the specific day of the week and the month week number as the PM work
order generation criteria.
o Fixed Date / by Month: This method allows users to define a fixed date with an optional monthly work period (target completion period)
• Attach a document or file against a PM Task.
• Metered PM - Record readings against a meter no assigned to an asset.
• Scheduling of PM Work Orders by a combination of meter readings or time on a whichever comes first basis.
• Comprehensive Excel style filtering capabilities via the PM Schedule list with export to Excel capability for easy reporting.
Date released~ June 18, 2020.
4CSQL Add-Ons
If you would like to go paperless, we have Add-Ons that you can
purchase.
4CMobile
4CMobile is a mobile application for Engineers to assign Work
Request or Work Orders or Preventive Works Order to technicians
and engineers whom are on the move. Once work is completed,
users can close the Work Orders from this application. Users can
also add and return materials used against a Work Order.
Remote Web Request
Remote Web Request is a module purpose built to enable non-
maintenance employees to raise requests to the maintenance
department. It consists of a set of simplified Work Request module
screens specifically designed for use by employees who are not
day to day users of the system.
Email Notification dispatcher
Email Notification Dispatcher is an application which dispatches
email notifications to specified employees when preset criteria are
met. This application is a standalone app which can be installed on
the server which hosts 4CSQL database or on a machine which is
on 24 hours a day with a connection to 4CSQL database. Options
in the configuration screens allows administrators to define which
employees the notifications should be sent. The frequency of
execution of the app is scheduled as a Windows Scheduled Task.
Visit our website for more info.
Date released~ June 18, 2020.
License Pricing
Pricing in USD
$950 $1,750 $5,850
4CSQL 4CSQL 4CSQL
User License User License Site License
with 1year annual
support ✓ One (1) site license
✓ One (1) Concurrent user ✓ One (1) Concurrent user
(unlimited users)
✓ Includes all modules ✓ Includes all modules
✓ Includes all modules
✓ File attachments ✓ File attachments
✓ File attachments
✓ Multilingual ✓ Multilingual
✓ Multilingual
✓ No support included ✓ 1year annual support
✓ No support included
$6,750 4CSQL
4CSQL
Site License Corporate License
with 1year annual support
✓ One (1) site license
Please email us
(unlimited users)
email@[Link] for
✓ Includes all modules
corporate license.
✓ File attachments
✓ Multilingual
✓ 1year annual support
Date released~ June 18, 2020.
License Pricing
Pricing in USD
$1,200 $450
Add-Ons Add-Ons
Remote Web Request 4CMobile
✓ One (1) server license ✓ Includes five (5) user
✓ Includes Remote license
Installation assistance. ✓ 1year annual support
Second year annual support
is USD200 which is optional
** The price listed above will be valid from the effective date and may be subject to changes at the Company’s discretion.
Date released~ June 18, 2020.
Technical Support
4CSQL CMMS - Annual Support
✓ Free software updates for duration of subscription
✓ Response within 24hours, excluding weekends and public holidays.
✓ Support from our offices in USA and Australia (Business days)
✓ Priority email support
✓ Telephone support
✓ Skype support
✓ Online remote access assistance (GOTO meeting)
Support Fees
(optional for the second year onwards)
User Licenses Site Licenses
1-9users ~ $800 1Site ~ $900
10users < ~ $1,300 2Sites ~ $1,600
20users < ~ $2,700 3Sites ~ $2,500
30users < ~ email us 4Sites ~ $3,400
5Sites ~ $4,200
5Sites < ~ email us
Price effective 1st July 2020.
Date released~ June 18, 2020.
Requirements
Client Machine
✓ Supported Operating Systems:
▪ Windows XP SP3
▪ Windows Vista SP1 or later
▪ Windows 7
▪ Windows 8
▪ Windows 10
▪ Windows Server 2003 SP2
▪ Windows Server 2008
▪ Windows Server 2008 R2
▪ Windows Server 2012
▪ Windows Server 2012 R2
▪ Windows Server 2016
✓ Supported Architectures:
▪ x86
▪ x64
✓ Hardware Requirements:
▪ Recommended Minimum:
▪ CPU: Quad core processor
▪ RAM: 4GB RAM as minimum is recommended.
▪ Minimum disk space: 2 GB
✓ Prerequisites:
▪ .Net Framework 4.0 or later
▪ Microsoft Office 2003 or later. Only Microsoft Excel is required for
exporting reports.
▪ Windows Installer 3.1 or later.
Date released~ June 18, 2020.
Requirements
SQL Server Database Server
✓ Supported Database Engine:
▪ Microsoft SQL Server 2005 or later.
▪ Both 32 and 64 bit editions are supported.
▪ Express Editions of SQL Server are also fully compatible.
✓ Supported Operating Systems:
▪ Windows Server 2008 R2 or higher including;
▪ Windows Server 2012
▪ Windows Server 2012 R2
▪ Windows Server 2016
▪ Windows Server 2019
▪ Windows XP SP3 or higher including;
▪ Windows Vista SP1 or later
▪ Windows 7
▪ Windows 8
▪ Windows 10
✓ Hardware Requirements:
▪ Quad core processor
▪ Hard Disk - Min. 5 GB free space.
▪ Memory – 4GB or higher recommended.
Date released~ June 18, 2020.
Requirements
Citrix Server Hardware
(If using Citrix / Remote Desktop virtualizations Server)
✓ Application Server
▪ Intel Xeon Quad Core processor or higher (any current server spec processor will
also be suffice).
▪ Hard Disk - Min. 10 GB free space.
▪ Memory – 8GB or higher recommended.
▪ Server Software;
▪ Operating System: Microsoft Windows Server 2008R2 Standard Edition(32 or
64 bit editions) or higher.
▪ [Link] Framework version 4.5 installed.
▪ IIS 7 or higher to host the web request application.
▪ Microsoft Office 2003 or higher.
✓ SQL Server Database Server
▪ Intel Xeon Quad Core or higher (any current server spec processor will also be
suffice).
▪ Hard Disk - Min. 5 GB free space.
▪ Memory – 4GB or higher
▪ Server Software;
▪ Operating System: Microsoft Windows Server 2008R2 Standard Edition (32 or
64 bit editions) or higher.
▪ Database: Microsoft SQL Server 2005 or higher. Both 32 and 64 bit editions
are supported. Express Editions of SQL Server are also compatible.
Date released~ June 18, 2020.
4C Systems Services
Implementation Services
Standard on-site implementation services includes;
• Requirement surveys
• Work process consulting
• Master data coding development
• Data collection, compilation, QC and porting
• PM schedules collection, compilation, QC and porting
• Installation and commissioning
• Training
Customization Services
To ensure 4CSQL fits your purpose, we offer affordable and high-quality customization
services.
▪ Software customization to include all requirements on operational processes.
▪ User specified reports.
Training Services (On-Site or online)
Training Services max 6 persons per 2 days session
▪ 4CSQL CMMS Modules Training
▪ Preventive Maintenance Training
▪ Excluding traveling and accommodation, which is chargeable at cost.
▪ All training is to be conducted at customers premise unless it is provided for by the
Company.
Notes
• All software will be delivered via a download link.
• Services Rates are excluding traveling and accommodation, which is chargeable at cost.
• All training is to be conducted at customers premise unless it is provided for by the Company.
Date released~ June 18, 2020.
Implementation plan
Data Extraction and Data Quality Checks
Collection and compilation of data into the required formats. Company XYZ
should provide the data in softcopies to enable efficient data migration. Typical
data includes;
• Supplier Register.
• Asset / Employee Register.
• Asset / Equipment register.
• Preventive checklists and tasks.
• Preventive maintenance schedules.
• Materials / Inventory register.
Data Importing INTO 4CSQL
Verified and finalized data shall be imported into the 4CSQL database using
Microsoft SQL data importing features and append queries.
Testing With DATA IN 4CSQL
The finalized system with the imported masters’ data shall be tested and
presented to the client for validation and approval. Further modifications to the
system shall be made if required.
4CSQL User Training
User training shall be conducted according to the following target audience.
User Champion / System Administrator – comprehensive training on all modules
and administration of the system.
Daily Users – This training will provide an overview of the system in order to give
users a basic understanding.
Go Live - 4CSQL CMMS software.
Date released~ June 18, 2020.
Contact Us
Main Office
4C Systems LLC.
Address: 1967 Wehrle Drive, Suite 1, Williamsville, NY 14221 USA
Phone : +1 (716) 406-7966
Email : email@[Link] / support@[Link]
Licensed Agent
Cworks Systems Pty Ltd (Australia)
Phone : +61 3 9013 6188
Email : info@[Link]
EMaintE Consulting(South Africa)
Phone :+27 11 057 6463
Email : gracious@[Link]
GRUPO IH ASESORES SA DE CV (Mexico)
Phone : +52 81 82662090
Email: issa@[Link]
Al Safwa Company (Egypt)
Phone :+20122.335.3315
Email : mohamed@[Link]
ZP Technologies Sdn Bhd (Brunei)
Phone :+673 819 6170
Email : info@[Link]
Binary Integrated Technology Solutions (Saudi Arabia)
Phone :+966 11460 3033
Email : muhannad@[Link]
Date released~ June 18, 2020.