Mapping Requirements for Processing Inbound EDI Transmissions
These tables are used to receive EDI transmissions:
EDI Lockbox/Payment Header - Transaction (F47111): The system stores transaction information in this table.
EDI Lockbox Header - Transaction (F47112): The system stores deposit information in this table.
EDI Lockbox/Payment Detail - Batch (F47113): The system stores payment (receipt) information in this table.
EDI Lockbox/Payment Detail - Payment (F47114): The system stores remittance (invoice) information in this table.
You can receive multiple transactions in a single EDI transmission; each transaction can have one deposit, each deposit can have multiple payments, and each payment can have multiple remittances (that is, it can pay multiple invoices). Total amounts are maintained by deposit and check for audit purposes, but are not transferred to the F03B13Z1 table.
The system uses key fields in EDI tables F47111, F47112, F47113, and F47114 to differentiate transactions and their related components. You should assign the same value to the key fields in all of the EDI tables. This table describes these key fields:
Field Name |
Alias |
Type |
Length |
Definition and Values to Enter |
|---|---|---|---|---|
EDI Document Key Company |
EKCO |
Number |
5 |
A number that is used in conjunction with the values in the EDI Document Number (EDOC), EDI Document Type (EDCT), and EDI Line Number (EDLN) fields to uniquely identify a transaction. The number that you enter must exist in the Company Constants table (F0010). |
EDI Document Number |
EDOC |
Number |
9 |
A number that is used in conjunction with the values in the EDI Document Key Company (EKCO), EDI Document Type (EDCT), and EDI Line Number (EDLN) fields to uniquely identify a transaction. |
EDI Document Type |
EDCT |
Alpha |
2 |
A two-character code that is used in conjunction with the values in the EDI Document Key Company (EKCO), EDI Document Number (EDOC), and EDI Line Number (EDLN) fields to uniquely identify a transaction. |
EDI Line Number |
EDLN |
Number |
7 |
A number that is used in conjunction with the values in the EDI Document Key Company (EKCO), EDI Document Number (EDOC), and EDI Document Type (EDCT) fields to uniquely identify a transaction. Enter 1 for both 823 and 820 transaction sets. |
To successfully process EDI transactions, complete the additional required fields in the EDI Lockbox/Payment Header - Transaction table (F47111):
Field Name |
Alias |
Type |
Length |
Definition and Values to Enter |
|---|---|---|---|---|
EDI Transaction Set Number |
Z1EDST |
Number |
6 |
A number that specifies the format of the transfer program. Enter 823 to specify EDI lockbox transactions and 820 to specify EDI inbound payment-order transactions. |
EDI Send/Receive Indicator |
Z1EDER |
Alpha |
1 |
A code that indicates whether the transaction is inbound or outbound. Enter R to indicate inbound transactions. |
Alpha Name |
Z1ALPH |
Alpha |
40 |
The name of the payor. If you process lockbox transactions (823), this is the name of the bank. |
EDI Transmission Date |
Z1EDDT |
Date |
6 |
The date on which the EDI data is transmitted. The system does not require a value in this field to process records; however, the EDI Inbound Receipt Inquiry program (P47110) uses this field to limit the number of records that appear. |
To successfully process EDI transactions, complete the additional required fields in the EDI Lockbox Header - Transaction table (F47112):
Field Name |
Alias |
Type |
Length |
Definition and Values to Enter |
|---|---|---|---|---|
EDI Transaction Set Number |
Z2EDST |
Number |
6 |
A number that specifies the format of the transfer program. Enter 823 to specify EDI lockbox transactions and 820 to specify EDI inbound payment order transactions. |
EDI Send/Receive Indicator |
Z2EDER |
Alpha |
1 |
A code that specifies whether the transaction is inbound or outbound. Enter R to specify inbound transactions. |
Deposit Number |
Z2DEPN |
Alpha |
30 |
A number that identifies a group of payments. |
Total Amount Transmitted |
Z2TTOT |
Number |
15 |
A number that represents the total amount of the deposit. |
To successfully process EDI transactions, complete the additional required fields in the EDI Lockbox/Payment Detail - Batch table (F47113):
Field Name |
Alias |
Type |
Length |
Definition and Values to Enter |
|---|---|---|---|---|
Deposit Number |
Z3DEPN |
Alpha |
30 |
A number that identifies a group of payments. Enter the same information in this field that you enter in the corresponding field in the EDI Lockbox Header - Transaction table (F47112). |
Line Number |
Z3LNID |
Number |
6 |
A number that identifies a receipt within a deposit. You must enter a unique value for each record. |
Receipt Number |
Z3DOCM |
Alpha |
8 |
A number that identifies a receipt. When you process the record, the system updates the check number field (CKNU) in the F03B13Z1 table with the value in this field. |
Bank Transit Number |
Z3TNST |
Alpha |
20 |
A number that identifies the bank from which the customer's payment is made. |
Customer Bank Account Number |
Z3CBNK |
Alpha |
20 |
A number that identifies the customer's account at a bank. |
Address Number |
Z3AN8 |
Number |
8 |
The customer's address book number. As an alternative to providing values for the Bank Transit Number and Customer Bank Account Number fields, you can enter the customer's address book number. The system locates the customer bank-account information, based on the customer's address book number, as long as it has been set up in the system. |
Total Amount Transmitted |
Z3TTOT |
Number |
15 |
A number that represents the amount of the receipt. If multiple receipts exist for one deposit, the sum of this field should equal the value in the Total Amount Transmitted field (Z2TTOT) in the F47112 table. |
Currency Code |
Z3CRCD |
Alpha |
3 |
The currency of the receipt amount. Complete this field only if you use multicurrency processing and you enter a value in the Currency Amount field (CRCA) in the F47114 table. |
To successfully process EDI transactions, complete the additional required fields in the EDI Lockbox/Payment Detail - Payment table (F47114):
Field Name |
Alias |
Type |
Length |
Definition and Values to Enter |
|---|---|---|---|---|
Deposit Number |
Z4DEPN |
Alpha |
30 |
The value that you enter must be the same as the deposit number that is entered in the corresponding field in the F47112 table. |
Line Number |
Z4LNID |
Number |
6 |
The number that you enter must be the same as the line number that is entered in the corresponding field in the F47113 table. |
Sequence Number |
Z4SEQN |
Number |
7 |
A number that identifies a receipt pay item when one receipt pays multiple invoices. |
Receipt Number |
Z4DOCM |
Number |
8 |
The number that you enter must correspond to a check number (data item DOCM) in the F47113 table. |
Document Number |
Z4DOC |
Number |
8 |
See the note after the table. |
Document Type |
Z4DCT |
Alpha |
2 |
See the note after the table. |
Document Pay Item |
Z4SFX |
Number |
3 |
See the note after the table. |
Gross Amount |
Z4AG |
Number |
15 |
A number that represents the amount of the receipt to apply to the invoice. Do not enter a value into this field if the receipt amount is foreign. Instead, use the Currency Amount field (Z4ACR). |
Currency Amount |
Z4ACR |
Number |
15 |
The foreign amount of the receipt to apply to the invoice. 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 table. |
Receipt Matching Reference 1 |
RMR1 |
A string variable that is used to match AR Invoices with AR Receipts. |
The Document Number (Z4DOC), Document Type (Z4DCT), and Document Pay Item (Z4SFX) fields identify the invoice that the receipt pays. You must have a separate record for each invoice and invoice pay item that the receipt pays.
If the invoice has only one pay item, you can leave the Pay Item field blank. The system numbers the pay items beginning with 001.
As an alternative to specifying the invoice document number (DOC, DCT, and SFX fields) in the F47114 table, you can complete one of these fields:
Purchase Order (Z4PO)
Control/Statement Number (Z4CTL)
This number is either the statement number on which the invoice appears or the user-defined reference number.
Shipment Number (Z4SHPN)
When the system processes transactions that use any of these fields, it copies the value from the field into the Generic Matching Field (GMFD) in the F03B13Z1 table.
Do not use multiple methods to identify the invoice. Use the DOC, DCT, and SFX fields, or the PO field, or the CTL field, or the SHPN field.