DMT Order Detail Interface Summary Report

Purpose: This report displays order detail summary information for records in the DMT Order Detail File.

The system creates a record in the DMT Order Detail file for each record in the Marketing Download Trigger file with a trigger type of LH (order line history) or OH (order header) that you download.

• The system creates LH (order line history) trigger records when you create order line history (for example, cancelling an item on an order, adding an item, or performing other updates in order maintenance; or billing an order).

• The system creates OH (order header) trigger records when you create a new order in order entry or accept an order in batch order entry.

See DMT Order Detail File for more information on how the system populates each field in a DMT order detail record.

This report sorts in entity sequence. For each entity, the system provides totals for transactions associated with new orders for a specified company and entity and transactions associated with maintained orders for a specified company and entity and also provides totals across entities. The total number of records in the DMT Order Detail file displays at the end of the report.

How to print: At a command line, enter this command to print the DMT Order Detail Interface Summary report, where XXX is your company code: CALL CSX1058 (‘’ ‘’ ‘’ ‘COMPANY NAME’ X’XXXF’). See Printing the DMT Reports.

CWDirect Rel 6.0 DMT Order Detail Interface Summary kab co Entity 202 2002 ENTITY Record Order Ship Return Cancel Sold Out Exchange B/O Price Price Sale Count Qty Qty Qty Qty Qty Qty Flag Promotions Overrides Price OH Sent this week : 5 5 3 0 0 1 0 1 0 5 0 OH Not Sent this week : 4 0 1 1 0 1 0 0 0 4 0 Total : 9 5 4 1 0 2 0 1 0 9 0 Entity 302 JAPANESE ENTITY MAR 2002 Record Order Ship Return Cancel Sold Out Exchange B/O Price Price Sale Count Qty Qty Qty Qty Qty Qty Flag Promotions Overrides Price OH Sent this week : 6 7 2 0 0 2 1 1 0 5 0 OH Not Sent this week : 0 0 0 0 0 0 0 0 0 0 0 Total : 6 7 2 0 0 2 1 1 0 5 0 Entity 555 ENTITY 555 Record Order Ship Return Cancel Sold Out Exchange B/O Price Price Sale Count Qty Qty Qty Qty Qty Qty Flag Promotions Overrides Price OH Sent this week : 6 5 0 5 1 2 5 1 0 6 0 OH Not Sent this week : 0 0 0 0 0 0 0 0 0 0 0 Total : 6 5 0 5 1 2 5 1 0 6 0 DMT Order detail totals Record Order Ship Return Cancel Sold Out Exchange B/O Price Price Sale Count Qty Qty Qty Qty Qty Qty Flag Promotions Overrides Price OH Sent this week : 17 17 5 5 1 5 6 3 0 16 0 OH Not Sent this week : 4 0 1 1 0 1 0 0 0 4 0 Total : 21 17 6 6 1 6 6 3 0 20 0 Total DMT Order Detail records sent to DMT : 21

Contents:

• Entity: the code and description of the entity associated with the order line. This is the value defined in the Entity field in the DMT Order Detail file.

• OH sent this week: the number of DMT order detail records created as a result of an OH (order header) trigger record (the DMT order detail records are associated with DMT order header records). This is the number of order lines that exist on newly created orders for the specified company and entity.

• Record count: the number of new order lines in the DMT Order Detail file for the specified company and entity.

• Order quantity: the number of units ordered on new order lines for the specified company and entity. This is the sum of the values defined in the Quantity ordered field in the DMT Order Detail file for new order lines in the specified company and entity.

• Ship quantity: the number of units shipped on new order lines for the specified company and entity. This is the sum of the values defined in the Quantity shipped field in the DMT Order Detail file for new order lines in the specified company and entity.

• Return quantity: the number of units returned on new order lines for the specified company and entity. This is the sum of the values defined in the Quantity returned field in the DMT Order Detail file for new order lines in the specified company and entity.

• Cancel quantity: the number of units cancelled on new order lines for the specified company and entity. This is the sum of the values defined in the Quantity cancelled field in the DMT Order Detail file for new order lines in the specified company and entity.

• Sold out quantity: the number of units soldout on new order lines for the specified company and entity. This is the sum of the values defined in the Quantity sold out field in the DMT Order Detail file for new order lines in the specified company and entity.

• Exchange quantity: the number of units exchanged on new order lines for the specified company and entity. This is the sum of the values defined in the Quantity exchanged field in the DMT Order Detail file for new order lines in the specified company and entity.

• B/O flag: the number of new order lines in the DMT Order Detail file for the specified company and entity whose Backorder flag field is Y.

• Price promotions: the number of new order lines in the DMT Order Detail file for the specified company and entity whose Unit offer price field value does not match the Unit price field value and the Price override code field is blank.

• Price overrides: the number of new order lines in the DMT Order Detail file for the specified company and entity whose Unit offer price field value does not match the Unit price field value and the Price override code field contains a value.

• Sale price: the number of new order lines in the DMT Order Detail file for the specified company and entity whose Price method field is SB (sale book item).

• OH not sent this week: the number of DMT order detail records created as a result of an LH (order line history) trigger record. This is the number of order lines updated during order maintenance for the specified company and entity.

• Record count: the number of maintained order lines in the DMT Order Detail file for the specified company and entity.

• Order quantity: the number of units added to existing order lines for the specified company and entity. This is the sum of the values defined in the Quantity ordered field in the DMT Order Detail file for maintained order lines in the specified company and entity.

• Ship quantity: the number of units shipped on existing order lines for the specified company and entity. This is the sum of the values defined in the Quantity shipped field in the DMT Order Detail file for maintained order lines in the specified company and entity.

• Return quantity: the number of units returned on existing order lines for the specified company and entity. This is the sum of the values defined in the Quantity returned field in the DMT Order Detail file for maintained order lines in the specified company and entity.

• Cancel quantity: the number of units cancelled on existing order lines for the specified company and entity. This is the sum of the values defined in the Quantity cancelled field in the DMT Order Detail file for maintained order lines in the specified company and entity.

• Sold out quantity: the number of units soldout on existing order lines for the specified company and entity. This is the sum of the values defined in the Quantity sold out field in the DMT Order Detail file for maintained order lines in the specified company and entity.

• Exchange quantity: the number of units exchanged on existing order lines for the specified company and entity. This is the sum of the values defined in the Quantity exchanged field in the DMT Order Detail file for maintained order lines in the specified company and entity.

• B/O flag: the number of maintained order lines in the DMT Order Detail file for the specified company and entity whose Backorder flag field is Y.

• Price promotions: the number of maintained order lines in the DMT Order Detail file for the specified company and entity whose Unit offer price field value does not match the Unit price field value and the Price override code field is blank.

• Price overrides: the number of maintained order lines in the DMT Order Detail file for the specified company and entity whose Unit offer price field value does not match the Unit price field value and the Price override code field contains a value.

• Sale price: the number of maintained order lines in the DMT Order Detail file for the specified company and entity whose Price method field is SB (sale book item).

• Total: the total number of order lines in the DMT Order Detail file for the specified company and entity across new and maintained order lines.

• Record count: the number of order lines in the DMT Order Detail file for the specified company and entity.

• Order quantity: the number of units on order lines for the specified company and entity. This is the sum of the values defined in the Quantity ordered field in the DMT Order Detail file for order lines in the specified company and entity.

• Ship quantity: the number of units shipped on order lines for the specified company and entity. This is the sum of the values defined in the Quantity shipped field in the DMT Order Detail file for order lines in the specified company and entity.

• Return quantity: the number of units returned on order lines for the specified company and entity. This is the sum of the values defined in the Quantity returned field in the DMT Order Detail file for order lines in the specified company and entity.

• Cancel quantity: the number of units cancelled on order lines for the specified company and entity. This is the sum of the values defined in the Quantity cancelled field in the DMT Order Detail file for order lines in the specified company and entity.

• Sold out quantity: the number of units soldout on order lines for the specified company and entity. This is the sum of the values defined in the Quantity sold out field in the DMT Order Detail file for order lines in the specified company and entity.

• Exchange quantity: the number of units exchanged on order lines for the specified company and entity. This is the sum of the values defined in the Quantity exchanged field in the DMT Order Detail file for order lines in the specified company and entity.

• B/O flag: the number of order lines in the DMT Order Detail file for the specified company and entity whose Backorder flag field is Y.

• Price promotions: the number of order lines in the DMT Order Detail file for the specified company and entity whose Unit offer price field value does not match the Unit price field value and the Price override code field is blank.

• Price overrides: the number of order lines in the DMT Order Detail file for the specified company and entity whose Unit offer price field value does not match the Unit price field value and the Price override code field contains a value.

• Sale price: the number of order lines in the DMT Order Detail file for the specified company and entity whose Price method field is SB (sale book item).

• DMT order detail totals: the record count, order quantity, ship quantity, return quantity, cancel quantity, sold out quantity, exchange quantity, B/O flag, price promotions, price overrides, and sale price for new order lines across entities and maintained order lines across entities.

• DMT order detail totals OH sent this week: the number of DMT order detail records created as a result of an OH (order header) trigger record (the DMT order detail records are associated with DMT order header records). This is the number of order lines that exist on newly created orders for the specified company and across all entities.

• Record count: the number of new order lines in the DMT Order Detail file for the specified company and across all entities.

• Order quantity: the number of units ordered on new order lines for the specified company and across all entities. This is the sum of the values defined in the Quantity ordered field in the DMT Order Detail file for new order lines in the specified company and across entities.

• Ship quantity: the number of units shipped on new order lines for the specified company and across entities. This is the sum of the values defined in the Quantity shipped field in the DMT Order Detail file for new order lines in the specified company and across entities.

• Return quantity: the number of units returned on new order lines for the specified company and across entities. This is the sum of the values defined in the Quantity returned field in the DMT Order Detail file for new order lines in the specified company and across entities.

• Cancel quantity: the number of units cancelled on new order lines for the specified company and across entities. This is the sum of the values defined in the Quantity cancelled field in the DMT Order Detail file for new order lines in the specified company and across entities.

• Sold out quantity: the number of units soldout on new order lines for the specified company and across entities. This is the sum of the values defined in the Quantity sold out field in the DMT Order Detail file for new order lines in the specified company and across entities.

• Exchange quantity: the number of units exchanged on new order lines for the specified company and across entities. This is the sum of the values defined in the Quantity exchanged field in the DMT Order Detail file for new order lines in the specified company and across entities.

• B/O flag: the number of new order lines in the DMT Order Detail file for the specified company and across entities whose Backorder flag field is Y.

• Price promotions: the number of new order lines in the DMT Order Detail file for the specified company and across entities whose Unit offer price field value does not match the Unit price field value and the Price override code field is blank.

• Price overrides: the number of new order lines in the DMT Order Detail file for the specified company and across entities whose Unit offer price field value does not match the Unit price field value and the Price override code field contains a value.

• Sale price: the number of new order lines in the DMT Order Detail file for the specified company and across entities whose Price method field is SB (sale book item).

• DMT order detail totals OH not sent this week: the number of DMT order detail records created as a result of an LH (order line history) trigger record. This is the number of order lines updated during order maintenance for the specified company and across entities.

• Record count: the number of maintained order lines in the DMT Order Detail file for the specified company and across entities.

• Order quantity: the number of units added to existing order lines for the specified company and across entities. This is the sum of the values defined in the Quantity ordered field in the DMT Order Detail file for maintained order lines in the specified company and across entities.

• Ship quantity: the number of units shipped on existing order lines for the specified company and across entities. This is the sum of the values defined in the Quantity shipped field in the DMT Order Detail file for maintained order lines in the specified company and across entities.

• Return quantity: the number of units returned on existing order lines for the specified company and across entities. This is the sum of the values defined in the Quantity returned field in the DMT Order Detail file for maintained order lines in the specified company and across entities.

• Cancel quantity: the number of units cancelled on existing order lines for the specified company and across entities. This is the sum of the values defined in the Quantity cancelled field in the DMT Order Detail file for maintained order lines in the specified company and across entities.

• Sold out quantity: the number of units soldout on existing order lines for the specified company and across entities. This is the sum of the values defined in the Quantity sold out field in the DMT Order Detail file for maintained order lines in the specified company and across entities.

• Exchange quantity: the number of units exchanged on existing order lines for the specified company and across entities. This is the sum of the values defined in the Quantity exchanged field in the DMT Order Detail file for maintained order lines in the specified company and across entities.

• B/O flag: the number of maintained order lines in the DMT Order Detail file for the specified company and across entities whose Backorder flag field is Y.

• Price promotions: the number of maintained order lines in the DMT Order Detail file for the specified company and across entities whose Unit offer price field value does not match the Unit price field value and the Price override code field is blank.

• Price overrides: the number of maintained order lines in the DMT Order Detail file for the specified company and across entities whose Unit offer price field value does not match the Unit price field value and the Price override code field contains a value.

• Sale price: the number of maintained order lines in the DMT Order Detail file for the specified company and across entities whose Price method field is SB (sale book item).

• Total: the total number of order lines in the DMT Order Detail file for the specified company and across new and maintained order lines for all entities.

• Record count: the number of order lines in the DMT Order Detail file for the specified company and across entities.

• Order quantity: the number of units on order lines for the specified company and across entities. This is the sum of the values defined in the Quantity ordered field in the DMT Order Detail file for order lines in the specified company and entity.

• Ship quantity: the number of units shipped on order lines for the specified company and entity. This is the sum of the values defined in the Quantity shipped field in the DMT Order Detail file for order lines in the specified company and across entities.

• Return quantity: the number of units returned on order lines for the specified company and across entities. This is the sum of the values defined in the Quantity returned field in the DMT Order Detail file for order lines in the specified company and across entities.

• Cancel quantity: the number of units cancelled on order lines for the specified company and across entities. This is the sum of the values defined in the Quantity cancelled field in the DMT Order Detail file for order lines in the specified company and across entities.

• Sold out quantity: the number of units soldout on order lines for the specified company and across entities. This is the sum of the values defined in the Quantity sold out field in the DMT Order Detail file for order lines in the specified company and across entities.

• Exchange quantity: the number of units exchanged on order lines for the specified company and across entities. This is the sum of the values defined in the Quantity exchanged field in the DMT Order Detail file for order lines in the specified company and across entities.

• B/O flag: the number of order lines in the DMT Order Detail file for the specified company and across entities whose Backorder flag field is Y.

• Price promotions: the number of order lines in the DMT Order Detail file for the specified company and across entities whose Unit offer price field value does not match the Unit price field value and the Price override code field is blank.

• Price overrides: the number of order lines in the DMT Order Detail file for the specified company and across entities whose Unit offer price field value does not match the Unit price field value and the Price override code field contains a value.

• Sale price: the number of order lines in the DMT Order Detail file for the specified company and across entities whose Price method field is SB (sale book item).

• Total DMT order detail records sent to DMT: the total number of records that exist in the DMT Order Detail file.