Marketing Download Order Header Interface Summary Report

Purpose: This report lists order summary information for records in the Marketing Download Order Header Table and Extract File.

The system creates a record in the Marketing Download Order Header table for each record in the Marketing Download Trigger table 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 Accept/Add Rcp) to an order in order maintenance.

See Marketing Download Order Header Table and Extract File for more information on how the system populates each field in a marketing download order header record.

How to print: Run the MDORDHD periodic function. See Setting up the Marketing Download Extract for more information.

For more information: See the  sample report    in PDF format.

Contents:

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

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.

How to print: Run the MDORDTL periodic function. See Setting up the Marketing Download Extract for more information.

For more information: See the  sample report    in PDF format.

Contents:

•         Total marketing download order detail records sent to marketing download: the total number of records that exist in the Marketing Download Order Detail table.

Marketing Download Customer Status Change Interface Report

Purpose: This report defines the number of sold to customers whose information has changed; this is the number of records in the Marketing Download Customer Status Change Table and Extract File.

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 and Extract File for more information on how the system populates each field in a marketing download customer status change record.

How to print: Run the MDCSCHG periodic function. See Setting up the Marketing Download Extract for more information.

For more information: See the  sample report    in PDF format.

Contents:

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.

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.

How to print: Run the MDINQSM periodic function. See Setting up the Marketing Download Extract for more information.

For more information: See the  sample report    in PDF format.

Contents:

•         Total Marketing Download Inquiry records sent to Marketing Download: the total number of records in the Marketing Download Customer Inquiry table.

Marketing Download Change of Address Interface Report

Purpose: This report lists customer address information for the records in the Marketing Download Customer Address Change Table and Extract File.

The system creates a record in the Marketing Download Customer Address Change table for each record in the Marketing Download Trigger table with a trigger type of CA (customer address change) that you download. The system creates CA (customer address change) trigger records when you change a customer sold to or change or create a permanent customer ship to address, including phone numbers and email address.

See Marketing Download Customer Address Change Table and Extract File for more information on how the system populates the fields in a marketing download customer address change record.

How to print: Run the MDADRCG 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:

•         Address type: the address type defined for the sold to customer or ship to customer in the Marketing Download Customer Address Change table for the specified company. The report lists the number of address changes for each address type by sold to address changes and ship to address changes.

•         USA sold to address: the sold to customer address change 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 sold to address: the sold to customer address change 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 sold to address: the sold to customer address change 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 ship to address: the ship to customer address change is a US address.

•         Canadian ship to address: the ship to customer address change is a Canadian address.

•         International ship to address: the ship to customer address change is an address other than US or Canadian.

•         Total: The total number of address changes for each address type, including sold to customer address changes and ship to customer address changes.

•         USA: the number of US address changes, including sold to customers and ship to customers.

•         Canadian: the number of Canadian address changes, including sold to customers and ship to customers.

•         International: the number of address changes other than US or Canadian, including sold to customers and ship to customers.

 

________________________________