Barcodes
Barcodes Structure
For adequate delivery control, each document must have a barcode printed in the window or in a visible part of the envelope. The barcode will have the following format:
• First two characters are the ID assigned by Urbano. Example: AE = Aerolíneas Emsa.
• The next two characters are the product ID, as established by Urbano. Example: EE = Statement of Account.
• The next four characters identify the closing day and month or date of delivery. Example: 1201 = 12 January.
• Up to 16 digits with the unique ID customer code, as for example: 1234567890123456 = Unique customer code.
Data base
The customer needs to furnish a database for each delivery cycle, which is used to validate the quality of the addresses and make any adjustments to minimize the number of undeliverable shipments due to bad addresses, incomplete or incorrect addresses. This is made by using the GIS system.
Database Structure
Structure to enter fields :
The database includes the following fields:
• Code
• Name
• Address 1
• Address 2
• Phone Number 1
• Phone Number 2
• City
Zoning
Process through which Urbano establishes a geographical area ID for each record in the database furnished to the customer.
The GIS system automatically assigns the area ID. Databases enter this process every month for control purposes and allocation of areas for address changes.
We will return the database to the customer with the following structure, in order that customer stores the information in its master database and is able to print the address in each mail piece.
•
Code
•
Area
Printing of documents
The printing process must take into account the inclusion of the barcode in a visible place, with the corresponding structure, the area ID assigned to the consignee by Urbano, and finally, documents must be printed in sequence applying the following criteria:
• City
• Area
• Address
Address Updates
During the telephone process, Urbano Express updates all addresses and at the end of each cycle sends the customer all the information, in order that customer updates its database.
The address update database includes the following fields:
•
Code
• Name
• Address 1 (Updated)
• Address 2 (Updated)
• Phone Number 1
• Phone Number 2
• City
• Area
• Previous address
NOTE: The update frequency is for each cycle and all files are in Excel format (dbf) or in the format specified by the customer.
|
