Following is the description of the key field segments in the EDI
820 flat file format:
Field Name |
Description |
External Source ID |
Uniquely identifies the lockbox. |
External Transmission ID |
Uniquely identifies the transmission. To ensure this transmission,
the date component (such as, 20150813) should match the deposit date
and there should only be one file per deposit date. |
External Batch ID |
Uniquely identifies the batch of payments in a transmission.
To ensure these payments, if there are multiple ST records in a file,
the transaction set control number (such as, 0101, 0202, ..) should
be unique. |
Payment Transaction |
The following table describes the fields that are included
in the payment transaction:
Field |
Description |
Attributes |
Following are the attributes of payment transaction:
-
Payment Amount
-
Payment Method
-
Payment Date
-
Payor Name
|
Reference Records |
Uniquely identifies the transaction. This is retrieved from
different reference records based on the payment method. The following
table indicates the external reference ID based on the payment methods
used in the transaction:
External Reference ID Value |
Description |
ACH |
Use the automated clearinghouse trace number. (Reference
Identifier Code is 8G). |
CHK |
Use the transaction reference number. (Reference Identifier
Code TN). |
FWT |
Use the FEDWIRE confirmation number. (Reference Identifier
Code 8I). |
CAS |
Use the transaction reference number. (Reference Identifier
Code TN). |
OBP |
Use the online payment trace number. (Reference Identifier
Code 8G). |
|
Source Customer Number |
Uniquely identifies the customer. This is retrieved from
the internal customer number reference record. (Reference Identifier
Code is IT). |
MICR |
Uniquely identifies the MICR. (Reference Identifier Code
is MICR) |
Check Number |
Uniquely identifies the check number. (Reference Identifier
Code is CK) |
Taxpayer Identification Number |
Uniquely Identifies the taxpayer. (Reference Identifier Code
is EI) |
|
Remittance Advice |
he following table describes the fields that are involved
in the remittance advice:
Field |
Description |
Attributes |
Following are the attributes:
-
Invoice Number
-
Payment Amount
|
Reference Records |
Uniquely identifies the remittance advice. The following
table indicates the external reference ID based on the payment methods
used in the remittance advice:
External Reference ID Value |
Description |
Billing Account ID |
Uniquely identifies the account. (Reference Identifier Code
is 12). |
Bill Group ID |
Uniquely identifies the billing group. (Reference Identifier
Code is U1). |
|
|
You can refer the following sample of EDI 820 flat file for better
understanding:
Sample EDI 820 Flat File