Following is a sample of how you want to view the data:
07/20/11 PAGE 1 18:23:59 DETAIL ITM_ID SHIP_QTY UNIT_PRICE EXPRESSION 01 ---------- ---------- ---------- ------------------- A10002 4 19.99 79.96000 A20000 1 149.99 149.99000 A30000 2 39.99 79.98000 A40000 5 5.99 29.95000 A60000 4 49.99 199.96000 H10003 100 12.99 1299.00000 H20005 200 17.99 3598.00000 H30001 102 14.99 1528.98000 H40000 900 15.99 14391.00000
Check the highlighted number of the report items against the following chart for a description of each item.
|
Report Item |
Description |
|---|---|
|
ITM_ID |
You want to know which items have been shipped. |
|
SHIP_QTY |
You want to know how many of each item have been shipped. |
|
UNIT_PRICE |
You want to know the price of each item. |
|
EXPRESSION 01 |
You want to create a result of the SHIP_QTY multiplied by the UNIT_PRICE for each row to get the total invoice amount. CA Dataquery automatically generates this kind of heading for mathematical results. (If you want your reports to have more descriptive column headings, you can specify headings during the report definition phase of execution.) |
|
Copyright © 2014 CA.
All rights reserved.
|
|