SalesAmount OrderDate Quantity TerritoryName ShipMethodName ProductName Primary key for SalesPerson records. Sales territory assigned to the salesperson. Sales quota assigned to the salesperson. Bonus awarded to the salesperson for achieving sales targets. Commission percentage earned by the salesperson on sales. Total sales year-to-date for the salesperson. Total sales made by the salesperson in the previous year. Globally unique identifier for the row. Date when the record was last modified. Primary key for ShipMethod records. Shipping company name. Minimum shipping charge. Shipping charge per pound. Globally unique identifier for the row. Date when the record was last modified. Primary key. Foreign key to Product.ProductID. Primary key. Foreign key to Vendor.BusinessEntityID. The average span of time (in days) between placing an order with the vendor and receiving the purchased product. The vendor's usual selling price. The selling price when last purchased. Date the product was last received by the vendor. The minimum quantity that should be ordered. The maximum quantity that should be ordered. The quantity currently on order. The product's unit of measure. Date when the record was last modified. Primary key. Incremental number to track changes to the purchase order over time. Order current status. 1 = Pending; 2 = Approved; 3 = Rejected; 4 = Complete. Employee who created the purchase order. Foreign key to Employee.BusinessEntityID. Vendor with whom the purchase order is placed. Foreign key to Vendor.BusinessEntityID. Shipping method. Foreign key to ShipMethod.ShipMethodID. Purchase order creation date. Estimated shipment date from the vendor. Purchase order subtotal. Computed as SUM(PurchaseOrderDetail.LineTotal) for the appropriate PurchaseOrderID. Tax amount. Shipping cost. Primary key. Foreign key to PurchaseOrderHeader.PurchaseOrderID. Primary key. One line number per purchased product. Date the product is expected to be received. Quantity ordered. Product identification number. Foreign key to Product.ProductID. Vendor's selling price of a single product. Quantity actually received from the vendor. Quantity rejected during inspection. Primary key for Vendor records. Foreign key to BusinessEntity.BusinessEntityID. Vendor account (identification) number. Company name. 1 = Superior, 2 = Excellent, 3 = Above average, 4 = Average, 5 = Below average. 0 = Do not use if another vendor is available. 1 = Preferred over other vendors supplying the same product. 0 = Vendor no longer used. 1 = Vendor is actively used. Vendor URL. hasProduct hasProductCostHistory hasSalesOrderDetail hasSpecialOffer hasSpecialOfferProduct CurrentListPrice CurrentStandardCost MaximumOfferQuantity MinimumOfferQuantity OfferDescription OfferEndDate OferStartDate OfferType OnlineOrderFlag OrderQuantity SalesAmount TotalDue ProductCostEndDate ProductCostStartDate ProductID ProductName SaleOrderDate SalesOrderDetailID SalesPersonID ShipMethodID SalesOrderID SpecialOfferID UnitPrice UnitPriceDiscount Product ProductCostHistory Production Sales SalesOrderDetail SalesOrderHeader SpecialOffer SpecialOfferProduct