Bookshelf v10.1.3.2: About the Grain at Which Currency Amounts and Quantities Are Stored

Quantities and currency amounts may be stored at different grains in the Order Cycle Time (W_SALES_CYCLE_LINE_F_HOLD_TMP) table, because of their unique ability to be rolled up.

Consider as an example a situation where a customer orders one package, which includes a computer, scanner, printer, and two speakers. In addition to the package, the customer also orders one monitor, which is not included in the package deal. In this case, the sales quantities are listed for the parent line item as well as for each child line items. However, the currency amounts are only listed for the parent line items; they are not listed for the individual child line items. Table 76 illustrates this example.

Table 76. Storing Currency Amounts at the Parent Line Level in Order Cycle Time table
Key_ID	SALES_ORDER_NUM	PRODUCT_ID	ORDHD_KEY _ID	ORDLN_KEY _ID	SALES_QTY	Currency Amount	Relation
Line_1	1000	Package	1000	Line_1	1	$1000	Parent A
Line_2	1000	Computer	1000	Line_1	1	-	Child A1
Line_3	1000	Scanner	1000	Line_1	1	-	Child A2
Line_4	1000	Printer	1000	Line_1	1	-	Child A3
Line_5	1000	Speaker	1000	Line_1	2	-	Child A4
Line_6	1000	Monitor	1000	Line_5	1	$400	Parent B (no children)

Consider another example. In this example, a customer orders the same package, which includes a computer, scanner, printer, and two speakers. In addition to the package, the customer also orders one monitor, which is not included in the package deal. In this case, the quantities are provided for the parent and child line item levels. In addition, the currency amounts are also listed for both the parent and child line item levels. Table 77 illustrates this example.

Table 77. Storing Currency Amounts at the Child Line Level in Order Cycle Time table
Key ID	Order #	Product	ORDHD_KEY_ID	ORDLN_KEY_ID	Relationship	Qty	Currency Amount
Line_1	1000	Package	1000	Line_1	Parent A	1	-
Line_2	1000	Computer	1000	Line_1	Child A1	1	725
Line_3	1000	Scanner	1000	Line_1	Child A2	1	75
Line_4	1000	Printer	1000	Line_1	Child A3	1	150
Line_5	1000	Speaker	1000	Line_1	Child A4	2	50
Line_6	1000	Monitor	1000	Line_5	Parent B (no children)	1	$400