NetSalesValues

Superclass

InternalTransfersValues

Subclasses

none

Referenced By

none

Net Sales and Transfers = Gross Sales and Transfers - Warranty.

       Gross Sales and Transfers = Aurora Prime Products Sales and Transfers + SCM Prime
Products Sales and Transfers + Non-Aurora/SCM Prime Products Sales and Transfers + Parts
Sales + Warranty = Aurora Warranty + SCM Warranty + Non-Aurora/SCM Warranty.

       Aurora Prime Product Sales and Transfers = Select Sum(trans_price) from
Prime_Product_Sums where manufacturer = 12 
       SCM Prime Product Sales and Transfers = Select Sum(trans_price) from
Prime_Product_Sums where (manufacturer = 66 or manufacturer = 84). 
       Non-Aurora/SCM Prime Product Sales and Transfers = Select Sum(trans_price) from
Prime_Product_Sums where manufacturer ~= 12 and manufacturer ~= 66 and manufacturer ~= 84 
       Part Sales = Select Sum(trans_price) from Parts_And_Comps_Sums where line_item_num =
'021002' or line_item_num = '031001'. 
       Component Sales = Select Sum(trans_price) from Parts_And_Comps_Sums where
line_item_num = '011006' or line_item_num = '021003'.

       Aurora Warranty = Select Sum(claim_amount) from Warranties where manufacturer = 12.

       SCM Warranty = Select Sum(claim_amount) from where Warranties manufacturer = 66 or
manufacturer = 84. 
       Non-Aurora/SCM Warranty = Select Sum(claim_amount) from Warranties where
manufacturer ~= 12 and manufacturer ~= 66 and manufacturer~= 84. 

Instance Variables
	none

Class Variables
	none

Contacts
	yoder@cat.ncsa.uiuc.edu