Marketing Download Order Detail Interface Summary Report
Purpose: This report lists order detail summary information for records in the Marketing Download Order Detail Table and Extract File.
The system creates a record in the Marketing Download Order Detail table for each record in the Marketing Download Trigger table 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 Marketing Download Order Detail Table and Extract File for more information on how the system populates each field in a marketing download 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 Marketing Download Order Detail table is at the end of the report.
How to print: Run the MDORDTL periodic function. See Setting up the Marketing Download Extract for more information.
Note: To make sure the report prints correctly, select an option that reduces the page or fits the content to the printer margins at the Print dialog box.
For more information: See the sample report in PDF format.
Contents:
• Entity: the code and description of the entity associated with the order line. From the Entity field in the Marketing Download Order Detail table.
• OH sent this week: the number of marketing download order detail records created as a result of an OH (order header) trigger record (the marketing download order detail records are associated with marketing download 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 Marketing Download Order Detail table 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 Marketing Download Order Detail table 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 Marketing Download Order Detail table 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 Marketing Download Order Detail table 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 Marketing Download Order Detail table 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 Marketing Download Order Detail table 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 Marketing Download Order Detail table for new order lines in the specified company and entity.
• B/O flag: the number of new order lines in the Marketing Download Order Detail table for the specified company and entity whose Backorder flag field is selected.
• Price promotions: the number of new order lines in the Marketing Download Order Detail table 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 Marketing Download Order Detail table 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 Marketing Download Order Detail table for the specified company and entity whose Price method field is SB (sale book item).
• OH not sent this week: the number of marketing download 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 Marketing Download Order Detail table 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 Marketing Download Order Detail table 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 Marketing Download Order Detail table 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 Marketing Download Order Detail table 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 Marketing Download Order Detail table 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 Marketing Download Order Detail table 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 Marketing Download Order Detail table for maintained order lines in the specified company and entity.
• B/O flag: the number of maintained order lines in the Marketing Download Order Detail table for the specified company and entity whose Backorder flag field is selected.
• Price promotions: the number of maintained order lines in the Marketing Download Order Detail table 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 Marketing Download Order Detail table 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 Marketing Download Order Detail table for the specified company and entity whose Price method field is SB (sale book item).
• Total: the total number of order lines in the Marketing Download Order Detail table for the specified company and entity across new and maintained order lines.
• Record count: the number of order lines in the Marketing Download Order Detail table 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 Marketing Download Order Detail table 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 Marketing Download Order Detail table 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 Marketing Download Order Detail table 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 Marketing Download Order Detail table 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 Marketing Download Order Detail table 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 Marketing Download Order Detail table for order lines in the specified company and entity.
• B/O flag: the number of order lines in the Marketing Download Order Detail table for the specified company and entity whose Backorder flag field is selected.
• Price promotions: the number of order lines in the Marketing Download Order Detail table 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 Marketing Download Order Detail table 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 Marketing Download Order Detail table for the specified company and entity whose Price method field is SB (sale book item).
• Marketing Download 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.
• Marketing Download order detail totals OH sent this week: the number of Marketing Download order detail records created as a result of an OH (order header) trigger record (the Marketing Download order detail records are associated with marketing download 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 Marketing Download Order Detail table 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 Marketing Download Order Detail table 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 Marketing Download Order Detail table 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 Marketing Download Order Detail table 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 Marketing Download Order Detail table 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 Marketing Download Order Detail table 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 Marketing Download Order Detail table for new order lines in the specified company and across entities.
• B/O flag: the number of new order lines in the Marketing Download Order Detail table for the specified company and across entities whose Backorder flag field is selected.
• Price promotions: the number of new order lines in the Marketing Download Order Detail table 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 Marketing Download Order Detail table 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 Marketing Download Order Detail table for the specified company and across entities whose Price method field is SB (sale book item).
• Marketing Download order detail totals OH not sent this week: the number of marketing download 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 Marketing Download Order Detail table 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 Marketing Download Order Detail table 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 Marketing Download Order Detail table 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 Marketing Download Order Detail table 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 Marketing Download Order Detail table 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 Marketing Download Order Detail table 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 Marketing Download Order Detail table for maintained order lines in the specified company and across entities.
• B/O flag: the number of maintained order lines in the Marketing Download Order Detail table for the specified company and across entities whose Backorder flag field is selected.
• Price promotions: the number of maintained order lines in the Marketing Download Order Detail table 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 Marketing Download Order Detail table 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 Marketing Download Order Detail table 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 Marketing Download Order Detail table for the specified company and across new and maintained order lines for all entities.
• Record count: the number of order lines in the Marketing Download Order Detail table 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 Marketing Download Order Detail table 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 Marketing Download Order Detail table 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 Marketing Download Order Detail table 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 Marketing Download Order Detail table 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 Marketing Download Order Detail table 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 Marketing Download Order Detail table for order lines in the specified company and across entities.
• B/O flag: the number of order lines in the Marketing Download Order Detail table for the specified company and across entities whose Backorder flag field is selected.
• Price promotions: the number of order lines in the Marketing Download Order Detail table 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 Marketing Download Order Detail table 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 Marketing Download Order Detail table for the specified company and across entities whose Price method field is SB (sale book item).
• Total marketing download order detail records sent to marketing download: the total number of records that exist in the Marketing Download Order Detail table.
