DMT Customer Status Change Interface Report

Purpose: This report displays customer information for sold to customers whose information has changed; this is customer status change information for records in the DMT Customer Status Change File.

The system creates a record in the DMT Customer Status Change file for each record in the Marketing Download Trigger file 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 DMT Customer Status Change File for more information on how the system populates each field in a DMT customer status change record.

This report sorts in entity sequence. Entity 0 (no entity specified) displays at the top of the report. The total number of records in the DMT Customer Status Change file displays at the end of the report.

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

CWDirect Rel 6.0 DMT Customer Status Change Interface KBOTTGER CSX1062 6/17/02 16:00:30 Page 1 kabco Entity 0 ENTITY NOT SPECIFIED |----------- Address Type ------------| |---------- Customer ----------| |----------- Entity -----------| USA Canadian International Mail Flag = Y Mail Flag = N Mail Flag = Y Mail Flag = N 7 1 2 6 4 10 0 Mail Do Not Customer Code Rent Undeliverable Fraud Class 5 4 0 4 4 DMT customer status change totals : |----------- Address Type ------------| |---------- Customer ----------| |----------- Entity -----------| USA Canadian International Mail Flag = Y Mail Flag = N Mail Flag = Y Mail Flag = N 7 1 2 6 4 10 0 Mail Do Not Customer Code Rent Undeliverable Fraud Class 5 4 0 4 4 Total DMT customer status change records sent to DMT : 10

Contents:

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

• Address type: the address type defined for the updated sold to customers in the DMT Customer Status Change file for the specified company and entity. The system displays the total number of updated customers for each address type.

• USA: the number of updated sold to customers in the DMT Customer Status Change file for the specified company and entity whose 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 number of updated sold to customers in the DMT Customer Status Change file 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 (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 number of updated sold to customers in the DMT Customer Status Change file 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 DMT Customer Status Change file for the specified company and entity. The system displays 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 DMT Customer Status Change file for the specified company and entity whose Mail name value is Y.

• Mail flag = N: the number of updated sold to customers in the DMT Customer Status Change file for the specified company and entity whose Mail name value is N.

• Entity: the entity mail name setting defined for the updated sold to customers in the DMT Customer Status Change file for the specified company and entity. The system displays 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 DMT Customer Status Change file for the specified company and entity whose Entity mail name value is Y or blank.

• Mail flag = N: the number of updated sold to customers in the DMT Customer Status Change file for the specified company and entity whose Entity mail name value is N.

• Mail code: the number of updated sold to customers in the DMT Customer Status Change file 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 DMT Customer Status Change file for the specified company and entity whose Mail name field or Entity mail name field is N.

• Undeliverable: the number of updated sold to customers in the DMT Customer Status Change file for the specified company and entity whose Deliverable code field contains a value.

• Fraud: the number of updated sold to customers in the DMT Customer Status Change file 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 DMT Customer Status Change file for the specified company and entity whose Customer class field contains a value.

DMT 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 DMT Customer Status Change file for the specified company and across entities.

• Address type: the address type defined for the updated sold to customers in the DMT Customer Status Change file for the specified company and across entities. The system displays the total number of updated customers for each address type.

• USA: the number of updated sold to cosmetics in the DMT Customer Status Change file for the specified company and across entities whose address is a US address.

• Canadian: the number of updated sold to customers in the DMT Customer Status Change file for the specified company and across entities whose address is a Canadian address.

• International: the number of updated sold to customers in the DMT Customer Status Change file 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 DMT Customer Status Change file for the specified company and across entities. The system displays 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 DMT Customer Status Change file for the specified company and across entities whose Mail name value is Y.

• Mail flag = N: the number of updated sold to customers in the DMT Customer Status Change file for the specified company and across entities whose Mail name value is N.

• Entity: the entity mail name setting defined for the updated sold to customers in the DMT Customer Status Change file for the specified company and across entities. The system displays 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 DMT Customer Status Change file for the specified company and across entities whose Entity mail name value is Y or blank.

• Mail flag = N: the number of updated sold to customers in the DMT Customer Status Change file for the specified company and across entities whose Entity mail name value is N.

• Mail code: the number of updated sold to customers in the DMT Customer Status Change file 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 DMT Customer Status Change file for the specified company and across entities whose Mail name field or Entity mail name field is N.

• Undeliverable: the number of updated sold to customers in the DMT Customer Status Change file for the specified company and across entities whose Deliverable code field contains a value.

• Fraud: the number of updated sold to customers in the DMT Customer Status Change file 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 DMT Customer Status Change file for the specified company and across entities whose Customer class field contains a value.

• Total DMT customer status change records sent to DMT: the total number of records that exist in the DMT Customer Status Change file for the specified company.