Work with Unchanged Customers Screen (MBSF)
Purpose: Use this option to:
• review the unprocessed records in the MBS Work table
• remove a record from the table
• review the type of name and address change
• purge all records in the table
• process the records in the table
For more information: See Loading Address Updates for background.
Selecting this option: Enter MBSF in the Fast path field at the top of any menu or select the Work with MBS Address Change File option from the menu.
Field |
Description |
Customer # |
A number to identify a customer. The customer record must exist on the system for any address updates to be performed. Numeric, 9 positions; display-only, assigned by the system. |
Change status |
The status of the record, which may indicate reason that the customer name and address was not updated. Valid values are: • Not Processed • Open Orders Exist • Last Change Date Greater Than • Customer Does Not Exist Display-only, updated by the system. |
Change type |
Identifies the reason for the name and address change. Valid values are: • Zip Code Change • Family Move • Individual Move Display-only, updated by the system. |
Deliverable address |
Indicates whether the address is a valid, deliverable address. Valid values are: • YES • NO If NO, the system changes the values in the Mail and Rent fields in the Sold To Customer table to unselected so that you do not send any more catalogs to the customer or sell the customer's address to other companies. Display-only, updated by the system. |
Screen Option |
Procedure |
Update the status of a record to Not Processed |
Select Reset for a record to update its status to Not Processed. |
Remove a record from the work table |
Select Delete for a record to delete it. |
Review the change |
Select Display for a record to display the Work with Customer Changes Screen (Reviewing Unapplied Address Changes). |
Purge all records in the work table after you process or review them |
Select Purge. |
Process the updates |
Select Process. |
Print a report of the unchanged customers that identifies the customer number, change condition, change type, whether it is a deliverable address, the address, the delivery code, and whether the address is a P.O. box |
Select Print to print the Unchanged Customers Report. |
Work with Customer Changes Screen (Reviewing Unapplied Address Changes)
Purpose: Use this screen to review an unapplied address change.
How to display this screen: Select Display for a customer number at the Work with Unchanged Customers Screen (MBSF).
Field |
Description |
Customer # |
A number to identify a customer. The customer record must exist on the system for any address updates to be performed. Numeric, 9 positions; display-only, assigned by the system. |
Change status |
The status of the record, which may indicate the reason that the customer address was not updated. Valid values are: • Not Processed • Open Orders Exist • Last Change Date Greater Than • Customer Does Not Exist Alphanumeric, 25 positions; display-only, updated by the system. |
Change type |
Identifies the reason for the change. Valid values are: • Zip Code Change • Family Move • Individual Move Alphanumeric, 15 positions; display-only, updated by the system. |
Deliverable |
Indicates whether the address is a valid, deliverable address. Valid values are: • YES • NO If NO, the system changes the values in the Mail and Rent fields in the Sold To Customer table to unselected so that you do not send any more catalogs to the customer or sell the customer's address to other companies. Alphanumeric, 3 positions; display-only, updated by the system. |
PO box? |
Indicates whether the address is a post office box. Valid values are: • selected = PO box. • unselected = Not a PO box. |
Delivery code |
Indicates whether the address is a business or residence. This information is used by shippers who charge different rates for shipping a package to a business or home. Display-only, updated by the system. |
Address |
The customer's address BEFORE the address update. |
Purpose: Use this screen to process name and address updates.
How to display this screen: Select Process at the Work with Unchanged Customers Screen (MBSF).
Field |
Description |
Change Date |
The date when the changes become effective. The system compares this date against the change date in the Customer Sold To table. If the change date for the received record is later than the change date in the Sold To Customer table, the system applies the address change. If the change date for the received record is earlier than the change date in the Customer Sold To table, the system does not apply the address change; instead, the system creates a record in the MBS Address Change table for you to review. Numeric, 6 positions (in user date format); required. |
Source of Update |
Indicates the table from which the system uploads changes. Valid values are: • ACS = The USPS ACS (address change service) format. The system converts the ACS table to MBS format to process the information. • MBS = The MBS format. Alphanumeric, 4 positions; required. |
| Work with Changed Customers Screen (MBSI) | Contents | SCVs | Search | Glossary | Reports | Solutions | XML | Index | Changed Customers Report |
CSAPP_D OMSCS 18.1 April 2019 OTN