Consumer Usage Reconciliation - Usage Detail Report (INS9070)

Fields on this report include the following usage details:

Field or Control	Description
SEQ. No (sequence number)	Numeric sequence in which the items were used in the service event as identified by the service event ID.
Cost-Used	Cost of the items used in the service event sequence.
Item Usage QTY (item usage quantity)	Quantity of the item used in the service event as a whole.
Item Usage Cost	Cost of the items used in the service event as a whole.
Location Usage Cost	Total item usage costs for the location ID.

Fields on this report include the following shipment details:

Field or Control	Description
Demand Source	The identification code associated with the shipped item's demand source, derived from the MSR created by the Create Par Replenishment Requests process.
Demand Source BU (demand source business unit)	The business unit associated with the shipped item's demand source.
Order No (order number)	The MSR order number issued for the shipped item.
Order Line	The MSR order line number associated with the shipped item.
Schedule Line	The MSR order schedule line number associated with the shipped item.
Demand Line	The demand line number associated with the shipped item.
Ship Date	The date on which the item was shipped.
QTY-Shipped (quantity shipped) and UOM	The quantity of a shipped item and the associated UOM.
Cost-Shipment	The cost of the shipped item.
Item Ship QTY (item ship quantity)	The total quantity of shipped items.
Item Shipment Cost	The total cost of the shipped items.
Location Usage Cost	The total item shipment costs for the location ID.

Fields on this report include the following receipt details:

Field or Control	Description
BU-PO (purchase order business unit)	The PO business unit associated with the received item.
Receiver ID	The receipt number associated with the received item.
Receiver Line	The receipt line number associated with the received item.
Ship SEQ (receiver ship sequence)	The sequence in which the received item was shipped.
Distribute Line	The distribution line associated with the received item.
Receipt Date	The date on which the item was received into the system.
QTY-Receipt (quantity receipt)	The quantity of items received according to the item's receipt.
Cost-Receipt	The cost of the items received according to the item's receipt.
Item Receipt QTY (item receipt quantity)	The total quantity of items received, according to the item's receipt.
Item Receipt Cost	The total cost of the items received, according to the item's receipt.
Location Usage Cost	The total item receipt cost for the location ID.

The last page of the report provides the following grand total information:

Field or Control	Description
Grand Usage Cost	Total item usage cost for all location IDs included in the report.
Grand Shipment Cost	Total item shipment cost for all location IDs included in the report.
Grand Receipt Cost	Total item receipt cost for all location IDs included in the report.