DMT Change of Address Interface Summary Report

Purpose: This report displays customer address information for the records in the DMT Customer Address Change File.

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

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

CWDirect Rel 6.0 DMT Change of Address Interface KBOTTGER CSX1070 6/18/02 11:20:51 Page 1 kabco ¦--------------- Address Type ---------------¦ USA Canadian International Sold To Address 3 4 3 Ship To Address 1 1 1 Total 4 5 4

Contents:

• Address type: the address type defined for the sold to customer or ship to customer in the DMT Customer Address Change file for the specified company. The system displays 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 value defined in 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 (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 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.