Loading Address Updates | Contents | SCVs | Search | Glossary | Reports | Solutions | XML | Index | Work with Changed Customers Screen (MBSI) |
Process Address Changes Screen (PACS)
Purpose: Use this screen to process address changes when the ACS Tape or the MBS Tape tables are already loaded with address change information.
For more information: See Loading Address Updates for background.
How to display this screen: Enter PACS in the Fast path field at the top of any menu, or select Process Address Changes from a menu.
Field |
Description |
Process deliverable addresses only |
Indicates whether to process only those names and addresses identified as deliverable. Valid values are: • Selected = Process only deliverable addresses • Unselected = (default): Process all received records, including those identified as undeliverable. When processing the records for non-deliverable addresses, the system updates the values in the Mail and Rent fields to unselected. This ensures that you do not send any more catalogs to this address or sell the customer's name to another company. |
Change date |
The date when the address changes become effective. The system compares this date against the change date in the Customer Sold To table. If the change date you specify here is: • later than the change date in the Sold To Customer table: the system applies the name and address change • earlier than the change date in the Customer Sold To table: the system does not apply the name and address change; instead, the system creates a record in the MBS Address Change table for you to review. Use the Work with Unchanged Customers Screen (MBSF). Numeric, 6 positions (MMDDYY format); required. |
Indicates where the address changes are located. Valid values are: • ACS = The system checks the ACS Tape table for address changes. • MBS = The system checks the MBS Tape table. Alphanumeric, 3 positions; required. |
Completing this screen: Complete each field as indicated above and select Submit to submit address updates. See Process Overview for more information.
Purpose: This table describes the format of the MBS and ACS Tape tables. The Process Address Changes Screen (PACS) and MBS and ACS Table Formats require tables in one of the formats described below.
|
MBS Tape table (CSMBST) |
ACS Tape table (CSACST) |
|
||
Field |
Position (From-To) |
Length |
Position (From-To) |
Length |
Valid values |
Customer # |
|
|
17-25 |
9 |
|
First name |
1-20 |
20 |
64-78 |
15 |
If the ACS move type (position 39) is set to B (business), then positions 44-87 are not parsed into name components, but are treated as a single 41-character business name field. |
Last name |
21-40 |
20 |
44-63 |
20 |
|
Prefix code |
41 |
1 |
79-81 |
3 |
The MBS format uses a single-position code, whereas the ACS format uses the literal value. • 1 = MR • 2 = MRS • 3 = MIS • 4 = DR • 5 = REV • 6 = SR • 7 = MS • 8 = FR • 9 = CO • * = MR & MRS • & = DR & MRS |
Suffix code |
42 |
1 |
85-87 |
3 |
The MBS format uses a single-position code, whereas the ACS format uses the literal value. • A = JR • B = SR • C = MD • D = DDS • E = II • F = III |
Address 1 |
43-72 |
30 |
118-177 |
60 |
The components of the ACS old address field are parsed as follows: Field Position Size Primary No. 118-127 10 Pre-directional 128-129 2 Street name 130-157 28 Street suffix 158-161 4 Post-directional 162-163 2 Unit designator 164-167 4 Secondary no. 168-177 10 If the literal APT, #, SUITE, STE, or UNIT displays after the street address, the system moves this information from Address line 1 to the Apartment field, retaining the literal and any text that follows it. Example: If the street address is 123 MAIN ST SUITE 15, the street address is 123 MAIN ST and the apartment is SUITE 15. |
Address 2 |
73-102 |
30 |
|||
City |
103-122 |
20 |
178-205 |
28 |
The first 20 positions of the ACS city maps to the MBS city code. |
Filler |
123-127 |
5 |
|
|
|
State |
128-129 |
2 |
206-207 |
2 |
|
Zip |
130-134 |
5 |
208-212 |
5 |
|
Zip+4 |
135-138 |
4 |
|
|
ACS does not provide old ZIP+4. |
Filler |
139-150 |
12 |
|
|
|
Dwelling code |
151 |
1 |
40 |
1 |
Valid MBS codes: • U = Unknown • S = Single • B = Business • A = Multi with Apartment • M = Multi, with no Apartment. The ACS record does not have a matching field, but a code may derive from the ACS Move type. Valid move types: • F = Family move (equals U in MBS layout) • I = Individual move (equals U in MBS layout) • B = Business (equals B in MBS layout) |
Filler |
152-158 |
7 |
|
|
|
Priority |
159-161 |
3 |
|
|
No matching ACS field. |
Key |
162-169 |
8 |
|
|
No matching ACS field. |
Multi-buyer Code |
170 |
1 |
|
|
No matching ACS field. |
Filler |
171-185 |
15 |
|
|
|
Zip Level |
186-188 |
3 |
|
|
No matching ACS field. |
Carrier Route |
191-194 |
4 |
|
|
No matching ACS field. |
NCOA Indicator |
195 |
1 |
37 |
1 |
• F = Family Move • I = Individual Move • B = Business (ACS code) If F or I, new address at position 491 |
Filler |
196-198 |
3 |
|
|
|
Zap Indicator |
199 |
1 |
1 |
1 |
Valid MBS codes: • X = Undeliverable • Z = Zip Change If Z, new zip at position 130 If ACS position 38 is set to one of the following values, then this is a "Nixie" record (undeliverable) and the MBS Zap indicator are loaded with a value of X: |
|
|
|
|
|
• A = attempted, not known • B = returned for better address • C = not deliverable as addressed • D = outside delivery limits • E = in dispute • G = PO box closed • I = insufficient address • K = moved, left no address • L = illegible • M = no mail receptacle |
|
|
|
|
|
• N = no such number • P = returned for postage • Q = not deliverable as addressed • R = refused • S = no such street • U = unclaimed • V = vacant • W = temporarily away • X = no such office |
|
|
|
|
|
The MBS table will not contain COA records reflecting changes only to the ZIP code. A postal customer would not submit a COA form if the zip code changed but he/she did not move, so there would be no COA request to trigger a record in this table. Note: The first record on the ACS Tape table has an H in this field, indicating that this is a header record and should not be used. |
Tier Code |
200 |
1 |
|
|
No matching ACS field. |
Filler |
201-233 |
33 |
|
|
|
Old Zip Code |
234-238 |
5 |
208-212 |
5 |
|
NCOA Move Date |
239-242 |
4 |
33-36 |
4 |
|
Filler |
243-275 |
33 |
|
|
|
DT Dwelling Code |
276 |
1 |
|
|
No matching ACS field. |
Old DMT Dwelling Code |
277 |
1 |
|
|
No matching ACS field. |
Old Finalist Dwelling Code |
278 |
1 |
|
|
No matching ACS field. |
Filler |
279-364 |
86 |
|
|
|
Address Reverse Indicator |
365 |
1 |
|
|
No matching ACS field. |
Filler |
366-381 |
16 |
|
|
|
String |
382-383 |
2 |
|
|
No matching ACS field. |
Standard Addr1 |
384-413 |
30 |
|
|
No matching ACS field. |
Standard Addr2 |
414-443 |
30 |
|
|
No matching ACS field. |
Standard City |
444-456 |
13 |
|
|
No matching ACS field. |
Standard State |
457-458 |
2 |
|
|
No matching ACS field. |
Filler |
459-478 |
20 |
|
|
|
Delivery Point Barcode |
479-481 |
3 |
342-344 |
3 |
|
Filler |
482-490 |
9 |
|
|
|
New Addr1 |
491-520 |
30 |
244-303 |
60 |
The components of the ACS new address field are parsed as follows: Field Position Size Primary No. 244-253 10 Pre-directional 254-255 2 Street name 256-283 28 Street suffix 284-287 4 Post-directional 288-289 2 Unit designator 290-293 4 Secondary no. 294-303 10 |
New Addr2 |
521-550 |
30 |
|
|
|
New City |
551-565 |
15 |
304-328 |
25 |
|
New State |
566-567 |
2 |
332-333 |
2 |
|
New 9-digit Zip |
568-576 |
9 |
334-343 |
10 |
|
New Carrier Route |
577-580 |
4 |
|
|
No matching ACS field. |
Move Type |
581 |
1 |
39 |
1 |
• I = Individual Move • F = Family Move • C = Company Move • B = Business Move |
Undeliverable Type |
582 |
1 |
38 |
1 |
• C = Not Deliverable • G = Box Closed • K = Moved, Left No Address • F = Moved to Foreign Address • Z = Invalid Postal Record • F = Moved to foreign address If ' ', zip code or address change |
|
|
|
|
|
If ACS position 38 is set to one of the following values, then this is a "Nixie" record (undeliverable), and the MBS Zap indicator will be loaded with a value of X: • A = attempted, not known • B = returned for better address • C = not deliverable as addressed • D = outside delivery limits • E = in dispute • G = PO box closed |
|
|
|
|
|
• I = insufficient address • K = moved, left no address • L = illegible • M = no mail receptacle • N = no such number • P = returned for postage • Q = not deliverable as addressed • R = refused • S = no such street • U = unclaimed • V = vacant • W = temporarily away • X = no such office |
Filler |
583-592 |
|
|
|
|
Customer code |
593-601 |
9 |
17-25 |
9 |
|
|
602-772 |
|
|
|
Not used by MICROS. |
Loading Address Updates | Contents | SCVs | Search | Glossary | Reports | Solutions | XML | Index | Work with Changed Customers Screen (MBSI) |
CSAPP_D OROMS 5.0 2018 OTN