Customers(ID, Company, Last Name, First Name, E-mail Address, Job Title, Business Phone, Home Phone, Mobile Phone, Fax Number, Address, City, State/Province, ZIP/Postal Code, Country/Region, Web Page, Notes, Attachments)
Employee Privileges(Employee ID, Privilege ID)
Employees(ID, Company, Last Name, First Name, E-mail Address, Job Title, Business Phone, Home Phone, Mobile Phone, Fax Number, Address, City, State/Province, ZIP/Postal Code, Country/Region, Web Page, Notes, Attachments)
Inventory Transaction Types(ID, Type Name)
Inventory Transactions(Transaction ID, Transaction Type, Transaction Created Date, Transaction Modified Date, Product ID, Quantity, Purchase Order ID, Customer Order ID, Comments)
Invoices(Invoice ID, Order ID, Invoice Date, Due Date, Tax, Shipping, Amount Due)
Order Details(ID, Order ID, Product ID, Quantity, Unit Price, Discount, Status ID, Date Allocated, Purchase Order ID, Inventory ID)
Order Details Status(Status ID, Status Name)
Orders(Order ID, Employee ID, Customer ID, Order Date, Shipped Date, Shipper ID, Ship Name, Ship Address, Ship City, Ship State/Province, Ship ZIP/Postal Code, Ship Country/Region, Shipping Fee, Taxes, Payment Type, Paid Date, Notes, Tax Rate, Tax Status, Status ID)
Orders Status(Status ID, Status Name)
Orders Tax Status(ID, Tax Status Name)
Privileges(Privilege ID, Privilege Name)
Products(Supplier IDs, ID, Product Code, Product Name, Description, Standard Cost, List Price, Reorder Level, Target Level, Quantity Per Unit, Discontinued, Minimum Reorder Quantity, Category, Attachments)
Purchase Order Details(ID, Purchase Order ID, Product ID, Quantity, Unit Cost, Date Received, Posted To Inventory, Inventory ID)
Purchase Order Status(Status ID, Status)
Purchase Orders(Purchase Order ID, Supplier ID, Created By, Submitted Date, Creation Date, Status ID, Expected Date, Shipping Fee, Taxes, Payment Date, Payment Amount, Payment Method, Notes, Approved By, Approved Date, Submitted By)
Sales Reports(Group By, Display, Title, Filter Row Source, Default)
Shippers(ID, Company, Last Name, First Name, E-mail Address, Job Title, Business Phone, Home Phone, Mobile Phone, Fax Number, Address, City, State/Province, ZIP/Postal Code, Country/Region, Web Page, Notes, Attachments)
Strings(String ID, String Data)
Suppliers(ID, Company, Last Name, First Name, E-mail Address, Job Title, Business Phone, Home Phone, Mobile Phone, Fax Number, Address, City, State/Province, ZIP/Postal Code, Country/Region, Web Page, Notes, Attachments)