Em Andamento

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

Habilidades: .NET, Engenharia, Microsoft, MySQL, PHP, Gestão de projetos, Arquitetura de software, Teste de Software, SQL, Visual Basic, Área de trabalho do Windows

Ver mais: 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

Acerca do Empregador:
( 8 comentários ) Parkvile, United States

ID do Projeto: #3007870

Premiar a:

thundercoders

See private message.

$323 USD em 21 dias
(53 Avaliações)
7.2

9 freelancers estão ofertando em média $418 para este trabalho

dexcoder

See private message.

$403.75 USD in 21 dias
(23 Comentários)
4.9
izharuislam

See private message.

$255 USD in 21 dias
(28 Comentários)
4.5
docilevw

See private message.

$850 USD in 21 dias
(14 Comentários)
4.0
zorangasic

See private message.

$170 USD in 21 dias
(11 Comentários)
2.8
angan

See private message.

$527 USD in 21 dias
(10 Comentários)
2.6
alienwebsl

See private message.

$212.5 USD in 21 dias
(6 Comentários)
2.7
hify

See private message.

$850 USD in 21 dias
(0 Comentários)
0.0
lokesh755

See private message.

$170 USD in 21 dias
(1 Comentário)
0.0