1. Data Interface for Electronic Data Interchange Implementation Guide
  2. Mapping Guidelines (Release 9.1 Update)

Mapping Guidelines (Release 9.1 Update)

You can receive multiple transactions in a single EDI transmission. Each transaction can have multiple deposits, each deposit can have multiple payments, and each payment can have multiple remittances. The system differentiates transactions and their related components by using these fields:

  • EDI Document Key Company (EDKCO).

  • EDI Document Number (EDOC).

  • EDI Document Type (EDCT).

  • EDI Line Number (EDLN).

Total amounts are maintained by deposit and check for audit purposes, but are not transferred to the Electronic Receipts Input table.

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

These fields in the F47111 table must contain data before you can use the Edit/Update Lockbox EDI tables for lockbox transactions effectively:

  • EDI Document Key Company (Z1EKCO).

  • EDI Document Number (Z1EDOC).

  • EDI Document Type (Z1EDCT).

  • EDI Line Number (Z1EDLN).

  • EDI Transaction Set Number (Z1EDST).

    Use 823 for inbound lockbox transactions.

  • EDI Send/Receive Indicator (Z1EDER).

    Use R for inbound EDI lockbox transactions.

  • Alpha Name (Z1ALPH).

These fields in the F47112 table must contain data before you can use the Edit/Update Lockbox EDI tables for lockbox transactions effectively:

  • EDI Document Key Company (Z2EKCO).

  • EDI Document Number (Z2EDOC).

  • EDI Document Type (Z2EDCT).

  • EDI Line Number (Z2EDLN).

  • EDI Transaction Set Number (Z2EDST).

    Use 823 for inbound lockbox transactions.

  • EDI Send/Receive Indicator (Z2EDER).

    Use R for inbound EDI lockbox transactions.

  • Deposit Number (Z2DEPN).

  • Total Transaction Amount (Z2TTOT).

    This is the total amount of the deposit.

These fields in the F47113 table must contain data before you can use the Edit/Update Lockbox EDI tables for lockbox transactions effectively:

  • EDI Document Key Company (Z3EKCO).

  • EDI Document Number (Z3EDOC).

  • EDI Document Type (Z3EDCT).

  • EDI Line Number (Z3EDLN).

  • EDI Transaction Set Number (Z3EDST).

    Use 823 for inbound lockbox transactions.

  • EDI Send/Receive Indicator (Z3EDER).

    Use R for inbound EDI lockbox transactions.

  • Deposit Number (Z3DEPN).

  • Line Number (Z3LNID).

  • Check Number (Z3DOCM).

  • Bank Transit Number (Z3TNST).

  • Customer Bank Account Number (Z3CBNK).

  • Currency Code (Z3CRCD).

    Map this field only when you complete the Currency Amount field (Z4CRCA) in the EDI Lockbox/Payment Detail - Payment table (F47114).

  • Total Transaction Amount (Z3TTOT).

    This is the total amount of the check (receipt).

These fields in the F47114 table must contain data before you can use the Edit/Update Lockbox EDI tables for lockbox transactions effectively:

  • EDI Document Key Company (Z4EKCO).

  • EDI Document Number (Z4EDOC).

  • EDI Document Type (Z4EDCT).

  • EDI Line Number (Z4EDLN).

  • EDI Transaction Set Number (Z4EDST).

    Use 823 for inbound lockbox transactions.

  • EDI Send/Receive Indicator (Z4EDER).

    Use R for inbound EDI lockbox transactions.

  • Deposit Number (Z4DEPN).

  • Line Number (Z4LNID).

  • Sequence Number (Z4SEQN).

  • Check Number (Z4DOCM).

  • Document Number (Z4DOC).

    This is the invoice number that the receipt pays. You must have a separate record for each invoice and invoice pay item that the receipt pays.

  • Document Type (Z4DCT).

    This is the document type of the invoice that the receipt pays.

  • Document Pay Item (Z4SFX).

    This is the pay item of the invoice that the receipt pays. If the invoice has one pay item only, you can leave this field blank.

  • Gross Amount (Z4AG).

    Do not enter a value into this field if the receipt amount is foreign. Instead, use the Currency Amount field (Z4ACR).

  • Discount Taken (Z4ADSA).

  • Purchase Number (Z4PO).

    Complete this field instead of the invoice number.

    When the system processes this transaction, it copies the value of this field into the Generic Matching field (GMFD) in the F03B13Z1.

  • Purchase Order Document Type (Z4PDCT).

    The document type of the purchase order number that identifies the invoice that the receipt pays.

  • Currency Amount (Z4ACR).

    If you use multicurrency, but the receipt is in the domestic currency, do not enter the domestic amount in this field. Instead, use the Gross Amount field (Z4AG).

    If you complete this field, you must complete the Currency Code field (Z3CRCD) in the F47113.

  • Foreign Discount Taken (Z4CDSA).

  • Control/Statement Field (Z4CTL).

    Complete this field instead of the invoice number.

    When the system processes this transaction, it copies the value of this field into the Generic Matching field (GMFD) in the F03B13Z1 table.

This structure illustrates how the EDI Lockbox tables are linked:

GS

F47111 - ST EDOC=111 EDLN=001

F47112 - Deposit EDOC=111 EDLN=001 DEPN=45-103

F47113 - Payment EDOC=111 EDLN=001 DEPN=45-103 LNID=001

F47114 - Remit EDOC=111 EDLN=001 DEPN=45-103 LNID=001 SEQN=1

F47114 - Remit EDOC=111 EDLN=001 DEPN=45-103 LNID=001 SEQN=2

F47113 - Payment EDOC=111 EDLN=001 DEPN=45-103 LNID=002

F47114 - Remit EDOC=111 EDLN=001 DEPN=45 103 LNID=002 SEQN=1

F47114 - Remit EDOC=111 EDLN=001 DEPN=45-103 LNID=002 SEQN=2

F47111 - ST EDOC=111 EDLN=002

F47112 - Deposit EDOC=111 EDLN=002 DEPN=76-323

F47113 - Payment EDOC=111 EDLN=002 DEPN=76-323 LNID=001

F47114 - Remit EDOC=111 EDLN=002 DEPN=76-323 LNID=001 SEQN=1

F47114 - Remit EDOC=111 EDLN=002 DEPN=76-323 LNID=001 SEQN=2

F47113 - Payment EDOC=111 EDLN=002 DEPN=76-323 LNID=002

F47114 - Remit EDOC=111 EDLN=002 DEPN=76-323 LNID=002 SEQN=1

F47114 - Remit EDOC=111 EDLN=002 DEPN=76-323 LNID=002 SEQN=2

F47111 - ST EDOC=112 EDLN=001

F47112 - Deposit EDOC=112 EDLN=001 DEPN=77-777

F47113 - Payment EDOC=112 EDLN=001 DEPN=77-777 LNID=001

F47114 - Remit EDOC=112 EDLN=001 DEPN=77-777 LNID=001 SEQN=1

F47114 - Remit EDOC=112 EDLN=001 DEPN=77-777 LNID=001 SEQN=2

F47113 - Payment EDOC=112 EDLN=001 DEPN=77-777 LNID=002

F47114 - Remit EDOC=112 EDLN=001 DEPN=77-777 LNID=002 SEQN=1

F47114 - Remit EDOC=112 EDLN=001 DEPN=77-777 LNID=002 SEQN=2

F47111 - ST EDOC=113 EDLN=001

F47112 - Deposit EDOC=113 EDLN=001 DEPN=88-888

F47113 - Payment EDOC=113 EDLN=001 DEPN=88-888 LNID=001

F47114 - Remit EDOC=113 EDLN=001 DEPN=88-888 LNID=001 SEQN=1

F47114 - Remit EDOC=113 EDLN=001 DEPN=88-888 LNID=001 SEQN=2

F47113 - Payment EDOC=113 EDLN=001 DEPN=88-888 LNID=002

F47114 - Remit EDOC=113 EDLN=001 DEPN=88-888 LNID=002 SEQN=1

F47114 - Remit EDOC=112 EDLN=001 DEPN=88-888 LNID=002 SEQN=2

You should map EDBT and EDOC fields from some unique data item in the EDI GS or ST segments or you should have them compute by a Next Number API. You can generate EDLN, LNID, and SEQN from Translator accumulators or loop counters. You can map DEPN from the transaction data (DEP01).

The system displays the Total Amount field (TTOT) in the Deposit record to verify the check amounts against the deposit totals.

The Total Amount field (TTOT) is provided in the Check record to verify the remittance amounts against the check total. If the amounts do not agree, then the system prints an error message on the report.

You should map either the Customers Address Book Number (AN8) or their bank account number (CBNK) into the Check record.