1 / 14

Trucking Company

Trucking Company. By: Rebecca Sheppard. Database Used. AS 400 Accounts Payable Accounts Receivable Vouchering of Invoices Repair Orders (Main Use) Truck and Trailer info Daily Time. Several Locations. Main branch (Sandersville) Augusta Jeffersonville Savannah (Garden City)

macha
Download Presentation

Trucking Company

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Trucking Company By: Rebecca Sheppard

  2. Database Used • AS 400 • Accounts Payable • Accounts Receivable • Vouchering of Invoices • Repair Orders (Main Use) • Truck and Trailer info • Daily Time

  3. Several Locations • Main branch (Sandersville) • Augusta • Jeffersonville • Savannah (Garden City) • Charleston

  4. Creating Table From Terminal info CREATE TABLE Site ( Terminal_Code CHAR (6), Site_Description VARCHAR2(15), CONSTRAINT Site_PK PRIMARY KEY (Terminal_Code) );

  5. Data for Site Table

  6. Creating Table From RO info CREATE TABLE RepairOrder ( Terminal_Code CHAR(6), RO_Number NUMBER(6,0), ID CHAR (1), Unit_Number CHAR(5), RO_Date DATE, Parts_Cost NUMBER(6,2), Labor_Cost NUMBER(6,2), CONSTRAINT RO_PK PRIMARY KEY (RO_Number), CONSTRAINT RO_Site_Code_FK FOREIGN KEY (Terminal_Code) REFERENCES Site(Terminal_Code) );

  7. Data for Repair Order Table

  8. Prompt User • To enter Site Code • Display • Repair Order Number • Unit ID • Unit Number

  9. Include Terminal Code Site Description RO Number ID Unit Number RO Date Parts Cost Labor Cost Total Amount (Parts Costs + Labor Costs) Compute Sum of Total Amount by Terminal Code Sum Parts Cost at end of Report Sum Labor Cost at end of Report Sum Total Amount at end of Report Create View and Report

  10. Info on Howard Sheppard, Inc. • www.howardsheppard.com

More Related