Order adjustment data model

This diagram shows the relationship between database tables that contain information about order adjustments. Each OrderAdjustment represents the total of the OrderItemAdjustments created by applying the results from a particular CalculationCode calculation. OrderAdjustments are created by the ApplyOrderAdjustments task command, which is invoked by the OrderPrepare controller command. A SubOrderAdjustment represents the sub-total of the just those OrderItemAdjustments whose OrderItems have the same shipping address. 

Normally an OrderItemAdjustment is taxable, meaning it effects tax calculations, but those whose OrderAdjustment is marked as tax exempt for certain tax categories do not affect the tax calculations for those tax categories.

An OrderAdjustment has a multi-lingual description, suitable for display to customers, normally copied from the description of the CalculationCode used to create it.

Click on any of the database table boxes to see more information about that table.

storeent taxcgry language ordadjdsc ordadjtxex orders ordadjust suborders calusage calcode subordadj orderitems ordiadjust Diagram showing the database relationships described in the preceding paragraph. Each link on the image leads to a related database table.