Generated using SQL Data Dictionary demo version.

Procedure Website.InsertCustomerOrders

Uses:

• Function 

  Website.CalculateCustomerPrice

  
  
  
• Sequence 

  Sequences.OrderID

  
  
  
• Table 

  Sales.OrderLines

  
  
  
  • Description
  • LastEditedBy
  • LastEditedWhen
  • OrderID
  • PackageTypeID
  • PickedQuantity
  • PickingCompletedWhen
  • Quantity
  • StockItemID
  • TaxRate
  • UnitPrice
  
  
• Table 

  Sales.Orders

  
  
  
  • BackorderOrderID
  • Comments
  • ContactPersonID
  • CustomerID
  • CustomerPurchaseOrderNumber
  • DeliveryInstructions
  • ExpectedDeliveryDate
  • InternalComments
  • IsUndersupplyBackordered
  • LastEditedBy
  • LastEditedWhen
  • OrderDate
  • OrderID
  • PickedByPersonID
  • PickingCompletedWhen
  • SalespersonPersonID
  
  
• Table 

  Warehouse.StockItems

  
  
  
  • StockItemID
  • TaxRate
  • UnitPackageID