In Progress

Database Application for Work Order Management

Create a database management application for workorder management. Based on MySQL the app will interface with the outside world using a udp packet scheme that will be provided by us.

Modules include

Customer Information

Includes creation, editing, and deletion

Resource Information

Includes creation, editing, and deletion

Service Information

Includes creation, editing, and deletion

Work Order Information

Includes creation, editing, and deletion

Schedule Information

Includes creation, editing, and deletion

Job Status Information

Includes creation, editing, and deletion

Invoice Information

Includes creation, editing, and deletion

Supplier Information

Includes creation, editing, and deletion

Material Information

Includes creation, editing, and deletion

Purchasing Information

Includes creation, editing, and deletion

## Deliverables

Create a database management application for workorder management. Based on MySQL the app will interface with the outside world using a udp packet scheme that will be provided by us.

Modules include

Customer Information

Includes creation, editing, and deletion

(Company Name, Contact Name, Address, Phone, Email, Customer Type, Date Entered, Date Edited)

Request Information

Includes creation, editing, and deletion

(CustomerID, TakenBy, Date/Time, AssignedTo, Status, WorkOrderID, Source, Type, Priority)

Resource Information

Includes creation, editing, and deletion

(Resource Name, Resource Type, Resource Status)

Service Information

Includes creation, editing, and deletion

(Service Name, Service Type, Service Status, Service Cost)

Work Order Information

Includes creation, editing, and deletion

(WorkOrderNbr, Customer, Resource List, Service List, Cost List, Schedule Start, Schedule End, AssignedBy, Status, Date Entered, Date Completed, RequestID)

Schedule Information

Includes creation, editing, and deletion

(SchedID, SchedTitle, WorkOrderNbr, Date, Time, Priority, status, JobStatusID)

Job Status Information

Includes creation, editing, and deletion

(WhenToFollowUp, WorkOrderNbr, RequestNbr

Invoice Information

Includes creation, editing, and deletion

(WorkOrderNbr, Date Issued, ItemList, Cost List, Freight, Tax, Terms, Discount)

Supplier Information

Includes creation, editing, and deletion

(Company Name, Contact Name, Address, Phone, Email, Customer Type, Date Entered, Date Edited)

Material Information

Includes creation, editing, and deletion

(MaterialID, Name, InternalPN, SupplierPN, SupplierList, QtyOnHand, MinQty, MaxQty, LastOrdered, LastCost, LastQtyOrdered, Unit Cost, Location)

Purchasing Information

Includes creation, editing, and deletion

(Supplier,Material,qty,unitcost,requestedDeliverydate,actualDeliveryDate, Order Status, OrderedBy,Department,WorkorderNbr)

Reports - Generate PDF Doc or XML File for

Invoices, Workorders, Requests by Date/Type/Customer,Schedule by Date/WorkOrder/Resource/Time, Purchase Orders, Material On Hand, Material at Min Lavel, Open Invoices, Open Purchase Orders

## Platform

XP,Vista,7,Server 200x

Skills: .NET, Engineering, Microsoft, MySQL, PHP, Project Management, Software Architecture, Software Testing, SQL, Visual Basic, Windows Desktop

See more: mysql database application, mysql customer database, min cost, app creation company, email database management, xml supplier, work schedule, the outside company, service management database, purchase order, order management app, management application, invoice app, for work, editing file for, database management, database application, create purchase order, create reports php using mysql database, phone file application, schedule management, service request management, xml invoice, supplier purchase order, udp application

About the Employer:
( 8 reviews ) Parkvile, United States

Project ID: #3007870

Awarded to:

thundercoders

See private message.

$323 USD in 21 days
(53 Reviews)
7.2

9 freelancers are bidding on average $418 for this job

dexcoder

See private message.

$403.75 USD in 21 days
(23 Reviews)
4.9
izharuislam

See private message.

$255 USD in 21 days
(28 Reviews)
4.5
docilevw

See private message.

$850 USD in 21 days
(14 Reviews)
4.0
zorangasic

See private message.

$170 USD in 21 days
(11 Reviews)
2.8
angan

See private message.

$527 USD in 21 days
(10 Reviews)
2.6
alienwebsl

See private message.

$212.5 USD in 21 days
(6 Reviews)
2.7
hify

See private message.

$850 USD in 21 days
(0 Reviews)
0.0
lokesh755

See private message.

$170 USD in 21 days
(1 Review)
0.0