Maybe it's better to read the example as HTML-formatted email. -- initial data fill -- ProductA inventory_item_detail[inventoryItemId: 9000, inventoryItemDetailSeqId: 0001, quantityOnHandDiff: 300,0, availableToPromiseDiff: 200.0] inventory_item[ inventoryItemId: 9000, productId: ProductA, quantityOnHandTotal: 300.0, availableToPromiseTotal: 200.0]
-- order (5x ProductA, 2x ProductB) -- ProductA inventory_item_detail[inventoryItemId: 9000, inventoryItemDetailSeqId: 10002, quantityOnHandDiff: 0.0, availableToPromiseDiff: -5.0] inventory_item[ inventoryItemId: 9000, productId: ProductA, quantityOnHandTotal: 300.0, availableToPromiseTotal: 195.0] -- ProductB inventory_item_detail[inventoryItemId: 10000, inventoryItemDetailSeqId: 10001, quantityOnHandDiff: 0.0, availableToPromiseDiff: -2.0] inventory_item_detail[inventoryItemId: 10000, inventoryItemDetailSeqId: 10003, quantityOnHandDiff: 0.0, availableToPromiseDiff: 2.0] inventory_item_detail[inventoryItemId: 10001, inventoryItemDetailSeqId: 10004, quantityOnHandDiff: 0.0, availableToPromiseDiff: -2.0] inventory_item[ inventoryItemId: 10000, productId: ProductB, quantityOnHandTotal: 0.0, availableToPromiseTotal: 0.0] inventory_item[ inventoryItemId: 10001, productId: ProductB, quantityOnHandTotal: 0.0, availableToPromiseTotal: -2.0] On 08/31/2010 05:43 PM, Rene Scheibe wrote: > -- order (5x ProductA, 2x ProductB) > > -- ProductA > > inventory_item_detail[inventoryItemId: 9000, inventoryItemDetailSeqId: > 10002, quantityOnHandDiff: 0.0, availableToPromiseDiff: -5.0] > > inventory_item[ inventoryItemId: 9000, productId: > ProductA, quantityOnHandTotal: 300.0, > availableToPromiseTotal: 195.0] > > > -- ProductB > > inventory_item_detail[inventoryItemId: 10000, > inventoryItemDetailSeqId: 10001, quantityOnHandDiff: 0.0, > availableToPromiseDiff: -2.0] > > inventory_item_detail[inventoryItemId: 10000, > inventoryItemDetailSeqId: 10003, quantityOnHandDiff: 0.0, > availableToPromiseDiff: 2.0] > > inventory_item_detail[inventoryItemId: 10001, > inventoryItemDetailSeqId: 10004, quantityOnHandDiff: 0.0, > availableToPromiseDiff: -2.0] > > inventory_item[ inventoryItemId: 10000, productId: > ProductB, quantityOnHandTotal: 0.0, > availableToPromiseTotal: 0.0] > > inventory_item[ inventoryItemId: 10001, productId: > ProductB, quantityOnHandTotal: 0.0, > availableToPromiseTotal: -2.0] > -- René Scheibe * [email protected] TNG Technology Consulting GmbH, Betastr. 13a, 85774 Unterföhring Geschäftsführer: Henrik Klagges, Gerhard Müller, Christoph Stock Sitz: Unterföhring * Amtsgericht München * HRB 135082
