Datamart Revision History

TaxExempt

Negates an order item was marked tax exempt. i.e. the staff member made a tax adjustment and set

the order item to be tax exempt.

• When an order item is marked tax exempt an ItemSaleAdjustment record is add with AdjustmentTypeName="TaxExempt"

The amount of Tax which was forgiven due to TaxExempt being true.

• The TaxAmount column will report 0 when the TaxForgiven column has a value.

AdjustmentTypeName

Each time the staff applies a tax exempt adjustment to an order item a record is added to the ItemSaleAdjustment table. The AdjustmentTypeName is set to "TaxExempt"

• Note: You should block "TaxExempt" adjustments from your application if it's reporting all records in the ItemSaleAdjustment table for Sales Adjustment calculations,

ParentObjectId

Used to relate children ItemSale records to a parent ItemSale record.

i.e. A combo named "Lunch Meal Deal" is sold which consists of Burger, Fries, Drink.

The ItemSale data output will consist of:

• 1 ItemSale record which represents the combo "Lunch Meal Deal".
• 3 ItemSale records with a ParentObjectId which equals the ObjectId of the "Lunch Meal Deal"
  • The 3 ItemSale records represent the Burger, Fries, and Drink.