DMT Order Header Interface Summary Report

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

The system creates a record in the DMT Order Header file for each record in the Marketing Download Trigger file with a trigger type of OH (order header) that you download. 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. A separate record is created for each order ship to.

• add a new ship to address (using F19) to an order in order maintenance.

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

This report sorts in entity sequence. A summary of the totals on this report for the specified company and across entities displays at the end of the report.

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

CWDirect Rel 6.0 DMT Order Header Interface Summary KBOTTGER CSX1045 6/17/02 10:18:44 Page 1 kab co Entity 202 2002 ENTITY Total Order $ . : 324.10 Average Order $ : 36.01 Mailable Not Mailable Sold To Total Deliverable Deliverable Address Type Orders Orders Orders USA : 4 3 1 Canadian : 1 0 1 International : 4 0 4 Total : 9 3 6 Mail Do Not Club E-Mail Gift Ship-To |---- Flex Pmt ----| Code Rent Undlvrble Fraud Member Address Giver Flag Install Deferred 6 7 0 4 0 9 1 2 1 2 Order Type Quantity Percent P PHONE ORDERS 7 77.7 % X E-COMMERCE ORDER TYPE 2 22.2 % CWDirect Rel 6.0 DMT Order Header Interface Summary KBOTTGER CSX1045 6/17/02 10:18:44 Page 2 kab co DMT Order Header Interface Summary Total Order $ : 324.10 Average Order $ : 36.01 Mailable Not Mailable Sold To Total Deliverable Deliverable Address Type Orders Orders Orders USA : 4 3 1 Canadian : 1 0 1 International : 4 0 4 Total : 9 3 6 Mail Do Not Club E-Mail Gift Ship-To |---- Flex Pmt ----| Code Rent Undlvrble Fraud Member Address Giver Flag Install Deferred 6 7 0 4 0 9 1 2 1 2 Order Type Quantity Percent P PHONE ORDERS 7 77.7 % X E-COMMERCE ORDER TYPE 2 22.2 % Total DMT Order Header records sent to DMT : 9

Contents:

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

• Total order dollars: the total merchandise amount on the orders associated with the specified company and entity; this is the merchandise amount for the order ship tos, including soldout order lines and cancelled order lines if the cancel reason code has Reduce demand set to N. This is the sum of the values defined in the Order amount field in the DMT Order Header file for orders in the specified company and entity.

• Average order dollars: the average merchandise amount on orders associated with the specified company and entity. The system uses this calculation to determine the average order dollars: total order dollars / number of orders = average order dollars.

• Sold to address type: the address type defined for the sold to customer on the order in the DMT Order Header file for the specified company and entity. The system displays the total orders for each address type and provides a breakdown of the order total by orders that are deliverable and orders that are non-deliverable.

• USA: the sold to customer’s address is a US address. The system uses the value defined in the Default Country for Customer Address (B17) system control value as the country code used for US addresses.

• Canadian: the sold to customer’s address is a Canadian address. The system uses the country codes CA or CAN as the country code used for Canadian addresses and the following state codes: AB (Alberta), BC (British Columbia), MB (Manitoba), NB (New Brunswick), NF (New Foundland), NT (Northwest Territory), NS (Nova Scotia), ON (Ontario), PE (Price Edward Island), PQ (Quebec), QC (Quebec alternate), SK (Saskatchewan), YT (Yukon Territory).

• International: the sold to customer’s address is an address other than US or Canadian. The system uses any country code other than CA, CAN, or the country code defined in the Default Country for Customer Address (B17) system control value as the country code used for International addresses.

• USA total orders: the total number of orders in the DMT Order Header file for the specified company and entity whose sold to customer address is a US address.

• USA mailable deliverable orders: the total number of US orders in the DMT Order Header file for the specified company and entity that are considered deliverable. The system considers an address deliverable if all of the following is true:

• the Mail name field or the Entity mail name field for the DMT order header record is Y.

• the Deliverable code field for the DMT order header record is blank.

• the Hold/bypass/fraud field for the DMT order header record is blank or B (bypass).

• the Customer class field for the DMT order header record is blank.

• USA not mailable deliverable orders: the total number of US orders in the DMT Order Header file for the specified company and entity that are considered non-deliverable. The system considers an address non-deliverable if one or more of the following is true:

• the Mail name field or the Entity mail name field for the DMT order header record is N.

• the Deliverable code field for the DMT order header record is not blank.

• the Hold/bypass/fraud field for the DMT order header record is F (fraud) or H (hold).

• the Customer class field for the DMT order header record is not blank.

• Canadian total orders: the total number of orders in the DMT Order Header file for the specified company and entity whose sold to customer address is a Canadian address.

• Canadian mailable deliverable orders: the total number of Canadian orders in the DMT Order Header file for the specified company and entity that are considered deliverable. The system considers an address deliverable if all of the following is true:

• the Mail name field or the Entity mail name field for the DMT order header record is Y.

• the Deliverable code field for the DMT order header record is blank.

• the Hold/bypass/fraud field for the DMT order header record is blank or B (bypass).

• the Customer class field for the DMT order header record is blank.

• Canadian not mailable deliverable orders: the total number of Canadian orders in the DMT Order Header file for the specified company and entity that are considered non-deliverable. The system considers an address non-deliverable if one or more of the following is true:

• the Mail name field or the Entity mail name field for the DMT order header record is N.

• the Deliverable code field for the DMT order header record is not blank.

• the Hold/bypass/fraud field for the DMT order header record is F (fraud) or H (hold).

• the Customer class field for the DMT order header record is not blank.

• International total orders: the total number of orders in the DMT Order Header file for the specified company and entity whose sold to customer address is an International address.

• International mailable deliverable orders: the total number of International orders in the DMT Order Header file for the specified company and entity that are considered deliverable. The system considers an address deliverable if all of the following is true:

• the Mail name field or the Entity mail name field for the DMT order header record is Y.

• the Deliverable code field for the DMT order header record is blank.

• the Hold/bypass/fraud field for the DMT order header record is blank or B (bypass).

• the Customer class field for the DMT order header record is blank.

• International not mailable deliverable orders: the total number of International orders in the DMT Order Header file for the specified company and entity that are considered non-deliverable. The system considers an address non-deliverable if one or more of the following is true:

• the Mail name field or the Entity mail name field for the DMT order header record is N.

• the Deliverable code field for the DMT order header record is not blank.

• the Hold/bypass/fraud field for the DMT order header record is F (fraud) or H (hold).

• the Customer class field for the DMT order header record is not blank.

• Total orders: the total number of orders in the DMT Order Header file for the specified company and entity across US, Canadian, and International addresses.

• Total mailable deliverable orders: the total number of US, Canadian, and International orders in the DMT Order Header file for the specified company and entity that are considered deliverable.

• Total not mailable deliverable orders: the total number of US, Canadian, and International orders in the DMT Order Header file for the specified company and entity that are considered non-deliverable.

• Mail code: the number of orders in the DMT Order Header file for the specified company and entity whose Mail code field contains a value.

• Do not rent: the number of orders in the DMT Order Header file for the specified company and entity whose Rent name field is N.

• Undeliverable: the number of orders in the DMT Order Header file for the specified company and entity whose Deliverable code field contains a value.

• Fraud: the number of orders in the DMT Order Header file for the specified company and entity whose Hold/bypass/fraud field is F (fraud).

• Club member: this value is not implemented.

• E-mail address: the number of orders in the DMT Order Header file for the specified company and entity whose Internet address field contains a value.

• Gift giver: the number of orders in the DMT Order Header file for the specified company and entity whose Recipient field contains a value.

• Ship-to flag: the number of orders in the DMT Order Header file for the specified company and entity whose Ship to field is Y.

• Installment flexible payment: the number of orders in the DMT Order Header file for the specified company and entity whose FPO type field is I.

• Deferred flexible payment: the number of orders in the DMT Order Header file for the specified company and entity whose FPO type field is D.

• Order type: the code and description of the order type defined for the order in the DMT Order Header file for the specified company and entity. The system displays the total number of orders and total percentage of orders for each order type.

• Quantity: the total number of orders associated with the specified order type in the DMT Order Header file for the specified company and entity.

• Percent: the total percentage of orders associated with the specified order type in the DMT Order Header file for the specified company and entity. The system uses this calculation to determine the order percentage: order type record count / entity record count = order type percentage count.

DMT Order Header Interface Summary: the system provides totals at the end of the report for the above fields for the specified company and across entities.

• Total order dollars: the total merchandise amount on the orders associated with the specified company and across entities.

• Average order dollars: the average merchandise amount on orders associated with the specified company and across entities.

• Sold to address type: the address type defined for the sold to customer on the order in the DMT Order Header file for the specified company and across entities.

• USA: the total number of orders, mailable deliverable orders, and not mailable deliverable orders for US addresses for the specified company and across entities.

• total orders: the total number of orders in the DMT Order Header file for the specified company and across entities whose sold to customer address is a US address.

• mailable deliverable orders: the total number of US orders in the DMT Order Header file for the specified company and across entities that are considered deliverable.

• not mailable deliverable orders: the total number of US orders in the DMT Order Header file for the specified company and across entities that are considered non-deliverable.

• Canadian: the total number of orders, mailable deliverable orders, and not mailable deliverable orders for Canadian addresses for the specified company and across entities.

• total orders: the total number of orders in the DMT Order Header file for the specified company and across entities whose sold to customer address is a Canadian address.

• mailable deliverable orders: the total number of Canadian orders in the DMT Order Header file for the specified company and across entities that are considered deliverable.

• not mailable deliverable orders: the total number of Canadian orders in the DMT Order Header file for the specified company and across entities that are considered non-deliverable.

• International: the total number of orders, mailable deliverable orders, and not mailable deliverable orders for International addresses for the specified company and across entities.

• total orders: the total number of orders in the DMT Order Header file for the specified company and across entities whose sold to customer address is an International address.

• mailable deliverable orders: the total number of International orders in the DMT Order Header file for the specified company and across entities that are considered deliverable.

• not mailable deliverable orders: the total number of International orders in the DMT Order Header file for the specified company and across entities that are considered non-deliverable.

• Total: the total number of orders, total mailable deliverable orders, and total non mailable deliverable orders in the DMT Order Header file for the specified company and across entities and address types.

• total orders: the total number of orders in the DMT Order Header file for the specified company and across entities and address types.

• total mailable deliverable orders: the total number of orders in the DMT Order Header file for the specified company and across entities and address types that are considered deliverable.

• total non mailable deliverable orders: the total number of orders in the DMT Order Header file for the specified company and across entities and address types that are considered non-deliverable.

• Mail code: the number of orders in the DMT Order Header file for the specified company and across entities whose Mail code field contains a value.

• Do not rent: the number of orders in the DMT Order Header file for the specified company and across entities whose Rent name field is N.

• Undeliverable: the number of orders in the DMT Order Header file for the specified company and across entities whose Deliverable code field contains a value.

• Fraud: the number of orders in the DMT Order Header file for the specified company and across entities whose Hold/bypass/fraud field is F (fraud).

• Club member: this value is not implemented.

• Email address: the number of orders in the DMT Order Header file for the specified company and across entities whose Internet address field contains a value.

• Gift giver: the number of orders in the DMT Order Header file for the specified company and across entities whose Recipient field contains a value.

• Ship to flag: the number of orders in the DMT Order Header file for the specified company and across entities whose Ship to field is Y.

• Installment flexible payment: the number of orders in the DMT Order Header file for the specified company and across entities whose FPO type field is I.

• Deferred flexible payment: the number of orders in the DMT Order Header file for the specified company and across entities whose FPO type field is D.

• Order type: the code and description of the order type defined for the order in the DMT Order Header file for the specified company and across entities. The system displays the total number of orders and total percentage of orders for each order type.

• quantity: the total number of orders associated with the specified order type in the DMT Order Header file for the specified company and across entities.

• percent: the total percentage of orders associated with the specified order type in the DMT Order Header file for the specified company and across entities.

• Total DMT order header records sent to DMT: the total number of orders in the DMT Order Header file for the specified company, and across entities.