You are here: Setup Guide > Connect Data Fields Using a Data Map > Connect the Data Fields Using the Order Lookup Data Map

Connect the Data Fields Using the Order Lookup Data Map

After you have established the data source connection and created the initial SELECT statement, Endicia Professional displays the Order Lookup Data Map window if your data source connection retrieves order information on the Order Lookup tab.

On the Order Lookup Data Map window, you connect (map) your database fields to the Endicia Professional fields.

At a minimum, Endicia Professional needs to assemble a shipping label address. The Order Number and Address fields are the only required fields. More address fields than necessary are provided to accommodate different database table structures. An address may have a maximum of six lines. Endicia Professional assembles the address in the following way:

[Name] [Last Name]

[Company]

[Address 1]

[Address 2]

[Address 3]

[Address 4]

[City]

[State]

[Zip Code]

[Country] Important! Use the two-character country codes or the full name of the country. For more information about official country names and two-character codes, go to: https://www.iso.org/obp/ui/#search

 

Prerequisites

Steps

  1. Depending on your situation:
  2. Select Edit > Preferences.
  3. Select the Data Source and Post-Back tab.
  4. Click the Configure button.
  5. In the Data Source list, select the data source connection.
  6. The Order Number field should already be mapped from the initial connection setup wizard, but if the Order Number field is not mapped, you must set this up. To change the field that corresponds to Order Number to a different field, you must do either of the following:

  7. For the remaining fields, as needed, continue mapping your data source fields to the Endicia Professional fields on the Package Details, Recipient Address, Return Address, and Rubber Stamps tabs.
  8. If you are using the Weight field and prefer to display the weight in pounds rather than ounces, select the Weight is in pounds check box.
  9. When you have completed your field mapping, click OK.

After you have connected the data fields using the source data map, you can:

 


 

Image of Endicia Logo

Copyright © 2017 Endicia. All Rights Reserved.