DMT Customer Inquiry Interface Summary Report

Purpose: This report displays customer inquiry information for records that exist in the DMT Customer Inquiry File.

The system creates a record in the DMT Customer Inquiry file for each record in the Marketing Download Trigger file with a trigger type of CI (customer inquiry) or CN (customer action note) that you download. The system creates CI (customer inquiry) trigger records when you:

• create a catalog request.

• create a new customer in order entry, even if you don't accept the order.

• create a new customer entity record, if the Track Customer History at Entity Level (F89) system control value is set to Y.

The system creates CN (customer action note) trigger records when you create, work with, or resolve a customer action note.

See DMT Customer Inquiry File for more information on how the system populates each field in a DMT customer inquiry record.

This report sorts in entity sequence. Entity 0 (no entity specified) displays at the top of the report; DMT customer inquiry records that represent customer action notes do not include entity. The total number of records in the DMT Customer Inquiry file displays at the end of the report.

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

CWDirect Rel 6.0 DMT Customer Inquiry Interface KBOTTGER CSX1067 6/18/02 10:27:33 Page 1 kabco Entity 202 2002 ENTITY Mailable Not Mailable Customer Total Deliverable Deliverable Action Note Address Type Inquiries Inquiries Inquiries Inquiries USA : 6 0 3 3 Canadian : 3 0 3 0 International : 1 0 1 0 Total : 10 0 7 3 Entity Total Mail Do Not Club Mail Type Inquiries Code Rent Undeliverable Fraud Member Buyer : 2 7 6 2 4 0 Suspect : 3 Recipient : 0 Rental : 1 Catalog Req : 4 CWDirect Rel 6.0 DMT Customer Inquiry Interface KBOTTGER CSX1067 6/18/02 10:27:33 Page 2 kabco DMT Customer Inquiry Interface Summmary Mailable Not Mailable Customer Total Deliverable Deliverable Action Note Address Type Inquiries Inquiries Inquiries Inquiries USA : 6 0 3 3 Canadian : 3 0 3 0 International : 1 0 1 0 Total : 10 0 7 3 Entity Total Mail Do Not Club Mail Type Inquiries Code Rent Undeliverable Fraud Member Buyer : 2 7 6 2 4 0 Suspect : 3 Recipient : 0 Rental : 1 Catalog Req : 4 Total DMT inquiry records sent to DMT : 10

Contents:

• Entity: the code and description of the entity associated with the customer sold to. This is the value defined in the Entity field in the DMT Customer Inquiry file.

• Address type: the address type defined for the sold to customer in the DMT Customer Inquiry file for the specified company and entity. The system displays the total inquiries for each address type and provides a breakdown of the inquiries total by inquiries that are deliverable and inquiries that are non-deliverable.The total customer action note inquiries also displays for each address type.

• 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 code 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 inquiries: total number of inquiries in the DMT Customer Inquiry file for the specified company and entity whose sold to customer address is a US address.

• USA mailable deliverable inquiries: the total number of US inquiries in the DMT Customer Inquiry file for the specified company and entity that are considered deliverable, not including DMT customer inquiry records whose Action reason code field contains a value. 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 customer inquiry record is Y.

• the Deliverable code field for the DMT customer inquiry record is blank.

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

• the Customer class field for the DMT customer inquiry record is blank.

• USA not mailable deliverable inquiries: the total number of US inquiries in the DMT Customer Inquiry file for the specified company and entity that are considered non-deliverable, not including DMT customer inquiry records whose Action reason code field contains a value. 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 customer inquiry record is N.

• the Deliverable code field for the DMT customer inquiry record is not blank.

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

• the Customer class field for the DMT customer inquiry record is not blank.

• USA customer action note inquiries: the total number of US inquiries in the DMT Customer Inquiry file for the specified company and entity that are associated with customer action notes. A DMT customer inquiry record is associated with a customer action note if the Action reason code field contains a value.

• Canadian total inquiries: total number of inquiries in the DMT Customer Inquiry file for the specified company and entity whose sold to customer address is a Canadian address.

• Canadian mailable deliverable inquiries: the total number of Canadian inquiries in the DMT Customer Inquiry file for the specified company and entity that are considered deliverable, not including DMT customer inquiry records whose Action reason code field contains a value. 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 customer inquiry record is Y.

• the Deliverable code field for the DMT customer inquiry record is blank.

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

• the Customer class field for the DMT customer inquiry record is blank.

• Canadian not mailable deliverable inquiries: the total number of Canadian inquiries in the DMT Customer Inquiry file for the specified company and entity that are considered non-deliverable, not including DMT customer inquiry records whose Action reason code field contains a value. 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 customer inquiry record is N.

• the Deliverable code field for the DMT customer inquiry record is not blank.

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

• the Customer class field for the DMT customer inquiry record is not blank.

• Canadian customer action note inquiries: the total number of Canadian inquiries in the DMT Customer Inquiry file for the specified company and entity that are associated with customer action notes. A DMT customer inquiry record is associated with a customer action note if the Action reason code field contains a value.

• International total inquiries: total number of inquiries in the DMT Customer Inquiry file for the specified company and entity whose sold to customer address is an International address.

• International mailable deliverable inquiries: the total number of International inquiries in the DMT Customer Inquiry file for the specified company and entity that are considered deliverable, not including DMT customer inquiry records whose Action reason code field contains a value. 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 customer inquiry record is Y.

• the Deliverable code field for the DMT customer inquiry record is blank.

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

• the Customer class field for the DMT customer inquiry record is blank.

• International not mailable deliverable inquiries: the total number of International inquiries in the DMT Customer Inquiry file for the specified company and entity that are considered non-deliverable, not including DMT customer inquiry records whose Action reason code field contains a value. 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 customer inquiry record is N.

• the Deliverable code field for the DMT customer inquiry record is not blank.

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

• the Customer class field for the DMT customer inquiry record is not blank.

• International customer action note inquiries: the total number of International inquiries in the DMT Customer Inquiry file for the specified company and entity that are associated with customer action notes. A DMT customer inquiry record is associated with a customer action note if the Action reason code field contains a value.

• Total inquiries: the total number of customer inquiries in the DMT Customer Inquiry 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 customer inquiries in the DMT Customer Inquiry file for the specified company and entity that are considered deliverable.

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

• Total customer action note inquiries: the total number of US, Canadian, and International inquiries in the DMT Customer Inquiry file for the specified company and entity that are associated with customer action notes.

• Mail type: the mail type defined for the sold to customer in the DMT Customer Inquiry file for the specified company and entity. The system displays the total inquiries for each mail type.

• Buyer: the total number of inquiries in the DMT Customer Inquiry file for the specified company and entity whose mail type is B (buyer).

• Suspect: the total number of inquiries in the DMT Customer Inquiry file for the specified company and entity whose mail type is S (suspect).

• Recipient: the total number of inquiries in the DMT Customer Inquiry file for the specified company and entity whose mail type is R (recipient).

• Rental: the total number of inquiries in the DMT Customer Inquiry file for the specified company and entity whose mail type is L (rental).

• Catalog request: the total number of inquiries in the DMT Customer Inquiry file for the specified company and entity whose mail type is C (catalog request).

• Mail code: the number of customer inquiries in the DMT Customer Inquiry file for the specified company and entity whose Mail code field contains a value.

• Do not rent: the number of customer inquiries in the DMT Customer Inquiry file for the specified company and entity whose Rent name field is N.

• Undeliverable: the number of customer inquiries in the DMT Customer Inquiry file for the specified company and entity whose Deliverable code field contains a value.

• Fraud: the number of customer inquiries in the DMT Customer Inquiry file for the specified company and entity whose Fraud field is F or H.

• Club member: this value is not implemented.

DMT Customer Inquiry Interface Summary: the total inquiries, mailable deliverable inquiries, not mailable deliverable inquiries, customer action note inquiries, entity mail type total inquiries, mail code, do not rent, undeliverable, fraud, and club member totals for the updated sold to customers in the DMT Customer Inquiry file for the specified company and across entities.

• Address type: the address type (USA, Canadian, International) defined for the sold to customer in the DMT Customer Inquiry file for the specified company and across entities. The system displays the total inquiries for each address type and provides a breakdown of the inquiries total by inquiries that are deliverable and inquiries that are non-deliverable.The total customer action note inquiries also displays for each address type.

• Total inquiries: total number of inquiries in the DMT Customer Inquiry file for the specified company and across entities for each address type and a total across address types.

• Mailable deliverable inquiries: the total number of inquiries in the DMT Customer Inquiry file for the specified company and across entities that are considered deliverable for each address type and a total across address types; these totals do not include DMT customer inquiry records whose Action reason code field contains a value.

• Not mailable deliverable inquiries: the total number of inquiries in the DMT Customer Inquiry file for the specified company and across entities that are considered non-deliverable for each address type and a total across address types; these totals do not include DMT customer inquiry records whose Action reason code field contains a value.

• Customer action note inquiries: the total number of inquiries in the DMT Customer Inquiry file for the specified company and across entities that are associated with customer action notes for each address type and a total across address types.

• Mail type total inquiries: the mail type defined for the sold to customer in the DMT Customer Inquiry file for the specified company and across entities. The system displays the total inquiries for each mail type: buyer, suspect, recipient, rental, catalog request.

• Mail code: the number of customer inquiries in the DMT Customer Inquiry file for the specified company and across entities whose Mail code field contains a value.

• Do not rent: the number of customer inquiries in the DMT Customer Inquiry file for the specified company and across entities whose Rent name field is N.

• Undeliverable: the number of customer inquiries in the DMT Customer Inquiry file for the specified company and across entities whose Deliverable code field contains a value.

• Fraud: the number of customer inquiries in the DMT Customer Inquiry file for the specified company and across entities whose Fraud field is F or H.

• Club member: this value is not implemented.

• Total DMT Inquiry records sent to DMT: the total number of records in the DMT Customer Inquiry file.