Marketing Download Customer Inquiry Interface Report
Purpose: This report lists customer inquiry information for records that exist in the Marketing Download Customer Inquiry Table and Extract File.
The system creates a record in the Marketing Download Customer Inquiry table for each record in the Marketing Download Trigger table 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 selected.
The system creates CN (customer action note) trigger records when you create, work with, or resolve a customer action note.
See Marketing Download Customer Inquiry Table and Extract File for more information on how the system populates each field in a marketing download customer inquiry record.
This report sorts in entity sequence. Entity 0 (no entity specified) is at the top of the report; marketing download customer inquiry records that represent customer action notes do not include entity. The total number of records in the Marketing Download Customer Inquiry table is at the end of the report.
How to print: Run the MDINQSM 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 customer sold to. From the Entity field in the Marketing Download Customer Inquiry table.
• Address type: the address type defined for the sold to customer in the Marketing Download Customer Inquiry table for the specified company and entity. The report lists 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 are also listed for each address type.
• USA: the sold to customer’s address is a US address. The system uses 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 (Newfoundland), 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 Marketing Download Customer Inquiry table 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 Marketing Download Customer Inquiry table for the specified company and entity that are considered deliverable, not including marketing download 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 marketing download customer inquiry record is selected.
• the Deliverable code field for the marketing download customer inquiry record is blank.
• the Hold/bypass/fraud field for the marketing download customer inquiry record is blank or B (bypass).
• the Customer class field for the marketing download customer inquiry record is blank.
• USA not mailable deliverable inquiries: the total number of US inquiries in the Marketing Download Customer Inquiry table for the specified company and entity that are considered non-deliverable, not including marketing download 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 marketing download customer inquiry record is unselected.
• the Deliverable code field for the marketing download customer inquiry record is not blank.
• the Hold/bypass/fraud field for the marketing download customer inquiry record is F (fraud) or H (hold).
• the Customer class field for the marketing download customer inquiry record is not blank.
• USA customer action note inquiries: the total number of US inquiries in the Marketing Download Customer Inquiry table for the specified company and entity that are associated with customer action notes. A marketing download 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 Marketing Download Customer Inquiry table 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 Marketing Download Customer Inquiry table for the specified company and entity that are considered deliverable, not including marketing download 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 marketing download customer inquiry record is selected.
• the Deliverable code field for the marketing download customer inquiry record is blank.
• the Hold/bypass/fraud field for the marketing download customer inquiry record is blank or B (bypass).
• the Customer class field for the marketing download customer inquiry record is blank.
• Canadian not mailable deliverable inquiries: the total number of Canadian inquiries in the Marketing Download Customer Inquiry table for the specified company and entity that are considered non-deliverable, not including marketing download 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 marketing download customer inquiry record is unselected.
• the Deliverable code field for the marketing download customer inquiry record is not blank.
• the Hold/bypass/fraud field for the marketing download customer inquiry record is F (fraud) or H (hold).
• the Customer class field for the marketing download customer inquiry record is not blank.
• Canadian customer action note inquiries: the total number of Canadian inquiries in the Marketing Download Customer Inquiry table for the specified company and entity that are associated with customer action notes. A marketing download 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 Marketing Download Customer Inquiry table 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 Marketing Download Customer Inquiry table for the specified company and entity that are considered deliverable, not including marketing download 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 marketing download customer inquiry record is selected.
• the Deliverable code field for the marketing download customer inquiry record is blank.
• the Hold/bypass/fraud field for the marketing download customer inquiry record is blank or B (bypass).
• the Customer class field for the marketing download customer inquiry record is blank.
• International not mailable deliverable inquiries: the total number of International inquiries in the Marketing Download Customer Inquiry table for the specified company and entity that are considered non-deliverable, not including marketing download 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 marketing download customer inquiry record is unselected.
• the Deliverable code field for the marketing download customer inquiry record is not blank.
• the Hold/bypass/fraud field for the marketing download customer inquiry record is F (fraud) or H (hold).
• the Customer class field for the marketing download customer inquiry record is not blank.
• International customer action note inquiries: the total number of International inquiries in the Marketing Download Customer Inquiry table for the specified company and entity that are associated with customer action notes. A marketing download 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 Marketing Download Customer Inquiry table 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 Marketing Download Customer Inquiry table 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 Marketing Download Customer Inquiry table 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 Marketing Download Customer Inquiry table 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 Marketing Download Customer Inquiry table for the specified company and entity. The report lists the total inquiries for each mail type.
• Buyer: the total number of inquiries in the Marketing Download Customer Inquiry table for the specified company and entity whose mail type is B (buyer).
• Suspect: the total number of inquiries in the Marketing Download Customer Inquiry table for the specified company and entity whose mail type is S (suspect).
• Recipient: the total number of inquiries in the Marketing Download Customer Inquiry table for the specified company and entity whose mail type is R (recipient).
• Rental: the total number of inquiries in the Marketing Download Customer Inquiry table for the specified company and entity whose mail type is L (rental).
• Catalog request: the total number of inquiries in the Marketing Download Customer Inquiry table for the specified company and entity whose mail type is C (catalog request).
• Mail code: the number of customer inquiries in the Marketing Download Customer Inquiry table for the specified company and entity whose Mail code field contains a value.
• Do not rent: the number of customer inquiries in the Marketing Download Customer Inquiry table for the specified company and entity whose Rent name field is unselected.
• Undeliverable: the number of customer inquiries in the Marketing Download Customer Inquiry table for the specified company and entity whose Deliverable code field contains a value.
• Fraud: the number of customer inquiries in the Marketing Download Customer Inquiry table for the specified company and entity whose Fraud field is F or H.
• Club member: this value is not implemented.
Marketing Download 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 Marketing Download Customer Inquiry table for the specified company and across entities.
• Address type: the address type (USA, Canadian, International) defined for the sold to customer in the Marketing Download Customer Inquiry table for the specified company and across entities. The report lists 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 are also listed for each address type.
• Total inquiries: total number of inquiries in the Marketing Download Customer Inquiry table 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 Marketing Download Customer Inquiry table 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 marketing download customer inquiry records whose Action reason code field contains a value.
• Not mailable deliverable inquiries: the total number of inquiries in the Marketing Download Customer Inquiry table 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 marketing download customer inquiry records whose Action reason code field contains a value.
• Customer action note inquiries: the total number of inquiries in the Marketing Download Customer Inquiry table 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 Marketing Download Customer Inquiry table for the specified company and across entities. The report lists the total inquiries for each mail type: buyer, suspect, recipient, rental, catalog request.
• Mail code: the number of customer inquiries in the Marketing Download Customer Inquiry table for the specified company and across entities whose Mail code field contains a value.
• Do not rent: the number of customer inquiries in the Marketing Download Customer Inquiry table for the specified company and across entities whose Rent name field is unselected.
• Undeliverable: the number of customer inquiries in the Marketing Download Customer Inquiry table for the specified company and across entities whose Deliverable code field contains a value.
• Fraud: the number of customer inquiries in the Marketing Download Customer Inquiry table for the specified company and across entities whose Fraud field is F or H.
• Club member: this value is not implemented.
• Total Marketing Download Inquiry records sent to Marketing Download: the total number of records in the Marketing Download Customer Inquiry table.
