Marketing Download Customer Status Change Interface Report
Purpose: This report lists customer information for sold to customers whose information has changed; this is customer status change information for records in the Marketing Download Customer Status Change Table.
The system creates a record in the Marketing Download Customer Status Change table for each record in the Marketing Download Trigger table with a trigger type of CS (customer status change) that you download. The system creates CS (customer status change) trigger records when you change one or more of these fields for a customer sold to:
• Mail name
• Customer sold to entity mail name
• Rent name
• Deliverable code
• Hold/bypass/fraud
• Customer class
• Mail code
• Call code
See Marketing Download Customer Status Change Table for more information on how the system populates each field in a marketing download customer status change record.
This report sorts in entity sequence. Entity 0 (no entity specified) is at the top of the report. The total number of records in the Marketing Download Customer Status Change table is at the end of the report.
How to print: Run the MDCSCHG 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 updated sold to customer. From the Entity field in the Marketing Download Customer Status Change table.
• Address type: the address type defined for the updated sold to customers in the Marketing Download Customer Status Change table for the specified company and entity. The report lists the total number of updated customers for each address type.
• USA: the number of updated sold to customers in the Marketing Download Customer Status Change table for the specified company and entity whose 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 number of updated sold to customers in the Marketing Download Customer Status Change table for the specified company and entity whose 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 number of updated sold to customers in the Marketing Download Customer Status Change table for the specified company and entity whose address is an International address. 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.
• Customer: the mail name setting defined for the updated sold to customers in the Marketing Download Customer Status Change table for the specified company and entity. The report lists the total number of updated customers for each mail name setting (Y or N).
• Mail flag = Y: the number of updated sold to customers in the Marketing Download Customer Status Change table for the specified company and entity whose Mail name value is selected.
• Mail flag = N: the number of updated sold to customers in the Marketing Download Customer Status Change table for the specified company and entity whose Mail name value is unselected.
• Entity: the entity mail name setting defined for the updated sold to customers in the Marketing Download Customer Status Change table for the specified company and entity. The report lists the total number of updated sold to customers for each entity mail name setting (Y or N).
• Mail flag = Y: the number of updated sold to customers in the Marketing Download Customer Status Change table for the specified company and entity whose Entity mail name value is selected.
• Mail flag = N: the number of updated sold to customers in the Marketing Download Customer Status Change table for the specified company and entity whose Entity mail name value is unselected.
• Mail code: the number of updated sold to customers in the Marketing Download Customer Status Change table for the specified company and entity whose Mail code field contains a value.
• Do not rent: the number of updated sold to customers in the Marketing Download Customer Status Change table for the specified company and entity whose Mail name field or Entity mail name field is unselected.
• Undeliverable: the number of updated sold to customers in the Marketing Download Customer Status Change table for the specified company and entity whose Deliverable code field contains a value.
• Fraud: the number of updated sold to customers in the Marketing Download Customer Status Change table for the specified company and entity whose Hold/bypass/fraud field is F (fraud) or H (hold).
• Customer class: the number of updated sold to customers in the Marketing Download Customer Status Change table for the specified company and entity whose Customer class field contains a value.
Marketing download customer status change totals: the address type, customer mail flag, entity mail flag, mail code, do not rent, undeliverable, fraud, and customer class totals for the updated sold to customers in the Marketing Download Customer Status Change table for the specified company and across entities.
• Address type: the address type defined for the updated sold to customers in the Marketing Download Customer Status Change table for the specified company and across entities. The report lists the total number of updated customers for each address type.
• USA: the number of updated sold to cosmetics in the Marketing Download Customer Status Change table for the specified company and across entities whose address is a US address.
• Canadian: the number of updated sold to customers in the Marketing Download Customer Status Change table for the specified company and across entities whose address is a Canadian address.
• International: the number of updated sold to customers in the Marketing Download Customer Status Change table for the specified company and across entities whose address is an International address.
• Customer: the mail name setting defined for the updated sold to customers in the Marketing Download Customer Status Change table for the specified company and across entities. The report lists the total number of updated customers for each mail name setting (Y or N).
• Mail flag = Y: the number of updated sold to customers in the Marketing Download Customer Status Change table for the specified company and across entities whose Mail name value is selected.
• Mail flag = N: the number of updated sold to customers in the Marketing Download Customer Status Change table for the specified company and across entities whose Mail name value is unselected.
• Entity: the entity mail name setting defined for the updated sold to customers in the Marketing Download Customer Status Change table for the specified company and across entities. The report lists the total number of updated sold to customers for each entity mail name setting (Y or N).
• Mail flag = Y: the number of updated sold to customers in the Marketing Download Customer Status Change table for the specified company and across entities whose Entity mail name value is selected.
• Mail flag = N: the number of updated sold to customers in the Marketing Download Customer Status Change table for the specified company and across entities whose Entity mail name value is unselected.
• Mail code: the number of updated sold to customers in the Marketing Download Customer Status Change table for the specified company and across entities whose Mail code field contains a value.
• Do not rent: the number of updated sold to customers in the Marketing Download Customer Status Change table for the specified company and across entities whose Mail name field or Entity mail name field is unselected.
• Undeliverable: the number of updated sold to customers in the Marketing Download Customer Status Change table for the specified company and across entities whose Deliverable code field contains a value.
• Fraud: the number of updated sold to customers in the Marketing Download Customer Status Change table for the specified company and across entities whose Hold/bypass/fraud field is F (fraud) or H (hold).
• Customer class: the number of updated sold to customers in the Marketing Download Customer Status Change table for the specified company and across entities whose Customer class field contains a value.
• Total Marketing Download customer status change records sent to Marketing Download: the total number of records that exist in the Marketing Download Customer Status Change table for the specified company.
