This week in  eBridge Support Services we have been dealing with a number of cases related to Data Lookup tables.

Data Lookup tables require ongoing maintenance to ensure transaction stability with all of your EDI trading partners.

Data Lookup tables are essential to the smooth exchange of information between trading partners because different parties using different accounting applications will store information in different ways.

For example, you may sell an “ItemABC” to your customer, but your customer may refer to the same item as “Item123”. The eBridge application uses Data Lookup (or Translation) tables to check equivalencies for the following information:

• Customer
• Ship To Address
• Inventory Item

Upon initial installation of your eBridge application, these Data Lookup tables are empty and must be populated so that all mandatory fields on inbound and outbound documents contain valid information. This is typically completed during the implementation process.

However, these tables require ongoing maintenance, and this is where Support Services enters the picture. If these tables are not kept current, errors will result.

Updates to your Data Lookup tables are required in the following cases:

• When your accounting application is updated with a new EDI trading partner;
• When a new Ship To address is used by an EDI trading partner; or
• When a new Inventory Item is to be ordered by an EDI trading partner

This information must be added into the Data Lookup table to avoid errors and ensure timely exchange of vital information.  Should you be undergoing any of these changes, do not hesitate to contact Support Services and we will be happy to guide you through this process.

If you have any questions related to Data Lookup tables, please don’t hesitate to leave a comment and we will be happy to address your concerns!

Until next week,

Paul Tittel

Help Desk Administrator

Support, eBRIDGE Blog Data Lookup tables, Support