1. Data Interface for Electronic Data Interchange Implementation Guide
  2. Mapping Guidelines

Mapping Guidelines

Mapping is the process of converting information from one table structure to another.

In the F47011 table, the following fields must contain data before you can effectively use the Inbound Edit/Update program for customer orders:

  • EDI Document Number (EDOC).

  • EDI Document Type (EDCT).

  • EDI Document Key Company (EKCO).

  • EDI Transaction Set (EDST).

  • Send/Receive Flag = R (EDER).

  • Transaction Set Purpose (TPUR).

  • Address Number or Ship to Address (AN8 or SHAN).

  • Business Unit (SYMCU).

In the F47012 table, these fields must contain data before you can effectively use the Inbound Edit/Update program for customer orders:

  • EDI Document Number (EDOC).

  • EDI Document Type (EDCT).

  • EDI Document Key Company (EKCO).

  • EDI Transaction Set (EDST).

  • EDI Line Number (EDLN).

  • Send/Receive Flag = R (EDER).

  • Address Number or Ship To Address (AN8 or SHAN).

  • Short Item Number (ITM), Second Item Number (LITM), Third Item Number (AITM), or Customer Item Number (CITM).

    If you use the Customer Item Number field (CITM), you must precede the value in that field with the symbol for customer/supplier item numbers as specified in the Branch Plant Constants for the business unit.

  • Order/Transaction Quantity (UORG).

In the F47013 table (if used), these fields must contain data before you can effectively use the Inbound Edit/Update program for customer orders:

  • EDI Document Number (EDOC).

  • EDI Document Type (EDCT).

  • EDI Document Key Company (EKCO).

  • EDI Line Number (EDLN).

  • EDI Record Sequence (EDSQ).

    This field must contain a counter that is incremental for each F47013 record. Each record relates to a single F47012 record. When the next F47012 record is processed, this counter must be reset to a value of 1.

  • Item Number (UITM).

  • Ship To Location (LC01...10).

  • Quantity (QT01...10).

In the F4706 table (if used), the following fields must contain data before you can effectively use the Inbound Edit/Update program for customer orders:

  • EDI Document Number (EDOC.)

  • EDI Document Type (EDCT).

  • EDI Line Number (EDLN).

  • File Name (FILE) = F47011.

  • Type Address Number (ANTY) (1=Sold to and 2=Ship to).

In the F4714 table (if used), these fields must contain data before you can effectively use the Inbound Edit/Update program for customer orders:

  • EDI Document Number (EDOC).

  • EDI Document Type (EDCT).

  • EDI Document Key Company (EKCO).

  • EDI Line Number (EDLN).

  • File Name (FILE) = F47011.

  • Line Number Work Order (LINS) (must be sequentially assigned).

In the F4715 table (if used), these fields must contain data before you can effectively use the Inbound Edit/Update program for customer orders:

  • EDI Document Number (EDOC).

  • EDI Document Type (EDCT).

  • EDI Document Key Company (EKCO).

  • EDI Line Number (EDLN)

  • File Name (FILE) = F47011.

  • Line Number Work Order (LINS) (must be sequentially assigned).