Order Entry

Order Entry

Order entry refers to receiving customer orders and converting what the customer needs into business practices The process of terminology, in the simplest case is to generate the shipping documents of the finished product, and in the more complex case it is to describe a series of activities that include the engineering requirements to produce the product to order.

Use the Order Entry system as an analogy for how this test would interface with a database. All interaction with the database is through stored procedures. The main stored procedures used during testing were:

sp_AddOrder – insert an order

sp_AddLineItem – insert an item for an order

sp_UpdateOrderShippingStatus – Update shipping status

sp_AssignOrderToLoadingDock – Insert a record to indicate which dock the order should be shipped from

sp_AddLoadingDock – Inserts a new record to define an available dock

sp_GetOrderAndLineItems – Select all information about an order and its items

The above is just a summary of the functions of stored procedures; obviously stored procedures also perform operations such as confirmation and auditing.

How many items are included in each order is random, ranging from one to three. The selection of items for an order is also randomized, chosen from a set of approximately 1,500 items.