Tag Archives: mapping

EDI Mapping & B2B Translation Services

Quality EDI Mapping is Critical

With regards to B2B operations, EDI mapping and B2B translations are where things become real. The point by point and intricate work included guarantees that the correct data streams easily and flawlessly between organizations.

We perform a high level of accuracy and quality and they are the main focus points when we perform mapping and translation of data, whether the transaction is EDI, XML, any other format or even any-to-any format or protocol.  Otherwise valuable resources will be needed to fix the issues that result.

Some businesses choose to perform their own mappings and whilst this can be beneficial, often these resources are limited and overburdened. Other businesses simply don’t have the necessary skill or resources to perform these tasks, and need outside assistance to help complete the work.

Skilled EDI Mapping Resources

Appleyard Solutions has a vast amount of experience in all areas of EDI mapping and our programmers can provide quality mapping tasks on behalf of your company.

We can provide you EDI mapping assistance for existing and new, inbound and outbound EDI documents,.  We have experience with all major EDI mapping, integration tools and networks, including IBM Sterling, Seeburger, GXS and others, and can assist you with everything from your initial EDI maps, to EDI map enhancements to ongoing EDI map development.

We offer any-to-any mapping and support any version of ANSI and EDIFACT standards.  Our EDI mappers can work with you on-site, or can work remotely – we’ll discuss which fits your needs, budgets and timeframes best.

Our EDI mapping services include:

  • On-shore / near-shore map development and maintenance
  • Mapping Requirements Specification (MRS) development
  • Performing a gap analysis between the application layout and EDI layout
  • Building EDI specifications and developing implementation guidelines for your company
  • Building maps using leading software applications, including IBM Sterling Gentran
  • Support for SAP IDOCS, flat files, ODBC, and application files
  • EDI mapping for the following transactions
    • Purchasing documents, including Purchase Orders (850), PO Acknowledgement (855), or PO Changes (860, 855 or 856)
    • Logistics documents, including Pick up Orders (204), Shipment Status (214), and others
    • Shipment documents, including Advanced Ship Notice (856) and Application Advice (824)
    • Other major documents like Invoices (810), Remittances (820), Price/Sales Catalog (832), Functional Acknowledgements (997), and Health Care Claims (837)
    • And many others
  • Map integration testing
  • Sharing of mapping and translations best practices gained across multiple industries, including Manufacturing, Retail, Pharmaceutical, CPG, Healthcare, Financial, and others
  • Onsite and remote mapping support

Appleyard Solutions EDI Mappers

With Appleyard Solutions EDI mappers on your B2B integration team, your EDI maps will be developed or migrated quickly and accurately.  You’ll benefit from faster response to business needs, rapid completion of maps by expert consultants, and the ability to change and adapt quickly to new standards or regulations.  And you can scale up or down based on your need for mapping services.

Contact us today to discuss how we can help you with your next EDI mapping project.

How To Use Indexing Rules (Example 2)

The following document explains how complex indexing works in map editor

The input file is an XML IDoc file and we want to group all LOT_NUMBER fields together along with the quantity accumulated per Lot Number.  The only way to do this is using indexing within the Extended Rules as shown below. Continue reading

SQL Mapping – A General Note


This paper will discuss SQL (ODBC) maps and outline general information necessary to complete a SQL map.  The paper will also cover the flow of the translator for outbound SQL (ODBC) Maps and how to use the components available with the SQL File Format to design a map to process the result set returned via the SQL statement defined in the map. Continue reading

Selecting and Updating Process Data in SI

Storing values into process data can be really useful.  However, when you “update” process data, it is an update TO process data.  It is not an update OF process data.  If you have multiple updates, it will create multiple entries.  Multiple updates will NOT overwrite the value in process data. Continue reading

Some Extended Rule Tips

Uppercase and Lowercase in mapping

#stringField = new("java.lang.String",#stringField).toUpperCase();
#stringField = new("java.lang.String",#stringField).toLowerCase();

Date Difference in map extended rule

object date1;
object date2;
#Number_of_days = (date2.getTimeInMillis() - date1.getTimeInMillis()) / 86400000;

Using Replace Function

object obj;

if len(#0166:19) > 0 then
    obj = new ("java.lang.String",#0166:19);
    #0166:19 = obj.replace("*","");

X-path interaction

String[20] BPID;

Customised java class calling from ER

Object xref;
xref = new("com.CVAM.utility.CVAMUserExits");

Click below to find out more what Appleyard’s EDI Services can do for you

How to Use Indexing Rule in SI

The following document explains (hopefully) how indexing works.

The input file is a flat-file and we want to group all PROD’s together as shown in the OUTPUT file result.  The only way to do this is using indexing within the Sterling Integrator Mapper Extended Rules. Continue reading

Generating a DDF Layout from IDoc


This document will discuss how Gentran Integration Suite uses the SAP Meta Data Builder to generate a Data Definition File (DDF) from an IDoc layout.  This functionality saves time by generating the IDoc layout in a format that can be imported into the Map Editor so users do not have to create the IDoc layout by hand. Continue reading

EDI B2B Integration



Electronic data interchange (EDI), as the name implies, is a method of electronic information exchange between two business entities. It involves the usage of computer networks and related software to transmit information related to businesses. Continue reading

edi integration

Inhouse or Outsource EDI

In-House or Outsource….it’s a question that almost every company has to answer at one time or another regardless of your size. When we look at the options it can be overwhelming, but what are the true pros and cons of keeping your EDI In-house or outsourcing? Continue reading

edi integration

How EDI Is Jumping Through New Hoops

In the age of the web, most likely EDI is an idea whose time has gone? Not really, there’s life in the old pooch yet as it discovers ways… Continue reading