Mapping
ä Mapping is used to create the relationship between our
database and the EDI data.
For example, if our partner sends us a purchase order number mapping would tell the system where to store the
purchase order number in the database.
At the same time we could tell the map to manipulate the purchase order number by removing or adding letters, for example. This manipulation of data can
be done using a formula or using a data
translation table. A formula would be used when the data you are manipulating is dynamic. A data translation table would be used when the data is static. A
purchase order number would be
considered dynamic because it is always different, therefore if it must be manipulated then you
would use a formula. A customer number
would be static because they are finite, therefore if the number must be manipulated then you would
use a translation table. However, if
there is a one to one relationship between
your partners representation of the customer number and your internal number you may use a formula to manipulate
the number so that it matches
yours. For example, if your partner sends you 1000 and your internal customer number is A01000, then
you could use a formula to
concatenate A0 to the front of the 1000.
ä