Using Mapping Guidelines

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

In the F47071 table, the following fields must contain data before you can effectively use the EDI Receiving Advice Edit/Create - Purchasing program (R47071) for receiving advice into purchasing:

  • EDI Document Number (EDOC).

  • EDI Document Type (EDCT).

  • EDI Document Key Company (EKCO).

  • EDI Transaction Set (EDST).

  • Send/Receive Flag (EDER).

  • Transaction Set Purpose (TPUR).

  • Receiving Advice Type (RATY).

    This field relates to ANSI X12 element 962.

  • Order Number (DOCO).

  • Document Type (DCTO).

  • Order Company (KCOO).

  • Order Suffix (SFXO).

In the F47072 table, the following fields must contain data before you can effectively use the EDI Receiving Advice Edit/Create - Purchasing program (R47071) for receiving advice into purchasing:

  • EDI Document Number (EDOC).

  • EDI Document Type (EDCT).

  • EDI Document Key Company (EKCO).

  • EDI Line Number (EDLN).

  • EDI Transaction Set (EDST).

  • Send/Receive Flag (EDER).

  • Order Number (DOCO).

  • Order Document Type (DCTO).

  • Order Company (KCOO).

  • Order Suffix (SFXO).

  • Purchase Order Line Number (LNID).

  • Item Number (LITM).

  • Line Item Status Code, as follows (LSTS):

    • 1 Match order line

    • 7 Close order line

    • 9 Cancel order line

  • Quantity Received (UREC)

    Map the total quantity received to UREC.

  • Unit Cost (PRRC) and Amount Received (AREC) (only if changing cost on the purchase order)

    If you are receiving an advice for a nonstock line on a purchase order, you must map a dollar amount to the Amount Received field (AREC).