Back
/*
Table: PurchaseOrder

Columns:
    orderID int
    vendorID int
    creationDate datetime
    placed tinyint
    placedDate datetime
    userID int
    vendorOrderID varchar
    vendorInvoiceID varchar

Depends on:
    none

Use:
Stores general an order from a vendor.
One or more records in purchaseOrderItems
should go with this record to list the
individual items to order.

vendorOrderID and vendorInvoiceID are memo
fields. If the vendor puts numbers or other
identifiers on orders and/or invoices those
values can be saved here for reference.
*/
Back