EDI 823 Lockbox

Functional Group LB

X12F Finance Subcommittee

This Draft Standard for Trial Use contains the format and establishes the data contents of the Lockbox Transaction Set (823) for use within the context of an Electronic Data Interchange (EDI) environment. The transaction set can be used to transmit lockbox (incoming payments) information and totals from a bank or any other lockbox service provider to a company.

Heading

1. 0100 · ST · Transaction Set Header · Max 1 · Mandatory

   To indicate the start of a transaction set and to assign a control number

2. N1 Loop Mandatory Repeat 2

   1. 0200 · N1 · Name · Max 1 · Mandatory

      To identify a party by type of organization, name, and code

      Mandatory: Lockbox (LBX) depository bank ID; optionally, identify ultimate recipient (company who has the LBX) of the LBX information.

   2. 0300 · N2 · Additional Name Information · Max 2 · Optional

      To specify additional names

   3. 0400 · N3 · Address Information · Max 2 · Optional

      To specify the location of the named party

   4. 0500 · N4 · Geographic Location · Max 1 · Optional

      To specify the geographic place of the named party

   5. 0600 · REF · Reference Identification · Max 12 · Optional

      To specify identifying information

   6. 0700 · PER · Administrative Communications Contact · Max 3 · Optional

      To identify a person or office to whom administrative communications should be directed

3. 0800 · TRN · Trace · Max 1 · Optional

   To uniquely identify a transaction to an application

   The TRN segment is used to uniquely identify a lockbox transaction set.

4. 0900 · DTM · Date/Time Reference · Max 2 · Optional

   To specify pertinent dates and times

   The DTM segment can be used to indicate the transaction creation (and, optionally, time) and the cutoff date and time for lockbox transactions reported in this transaction set.

Detail

1. DEP Loop Mandatory Repeat 100

   1. 0100 · DEP · Deposit · Max 1 · Mandatory

      To indicate the lockbox ID, date, time, deposit number, and bank account information

      DEP segment contains LBX ID number, depository bank ABA number, and bank acct. number, deposit date/time.

   2. 0200 · AMT · Monetary Amount · Max 1 · Mandatory

      To indicate the total monetary amount

      AMT = Total deposit dollars.

   3. 0300 · QTY · Quantity · Max 2 · Mandatory

      To specify quantity information

      QTY = Number of batches in deposit; number of checks in deposit.

   4. 0400 · REF · Reference Identification · Max 5 · Optional

      To specify identifying information

      REF = Identifies deposit number and/or deposit sequence number.

   5. 0500 · DTM · Date/Time Reference · Max 10 · Optional

      To specify pertinent dates and times

      Identifies processing or other date/time information.

   6. BAT Loop Optional Repeat >1

      1. 0600 · BAT · Batch · Max 1 · Mandatory

         To indicate batch identifying information

      2. 0700 · AVA · Funds Availability · Max 10 · Optional

         To indicate the funds availability in days

      3. 0800 · AMT · Monetary Amount · Max 1 · Optional

         To indicate the total monetary amount

         AMT = Total batch dollars.

      4. 0900 · QTY · Quantity · Max 1 · Optional

         To specify quantity information

         QTY = Number of checks in batch.

      5. 1000 · DTM · Date/Time Reference · Max 10 · Optional

         To specify pertinent dates and times

         DTM = Identifies processing or other date/time information.

      6. BPR Loop Optional Repeat >1

         1. 1100 · BPR · Beginning Segment for Payment Order/Remittance Advice · Max 1 · Mandatory

            To indicate the beginning of a Payment Order/Remittance Advice Transaction Set and total payment amount, or to enable related transfer of funds and/or information from payer to payee to occur

            The BPR segment identifies the payment method.

         2. 1150 · TRN · Trace · Max 1 · Optional

            To uniquely identify a transaction to an application

         3. 1200 · CUR · Currency · Max 1 · Optional

            To specify the currency (dollars, pounds, francs, etc.) used in a transaction

         4. 1300 · REF · Reference Identification · Max >1 · Optional

            To specify identifying information

            REF = Identifies payee code, MICR line, check number and scan line.

         5. 1400 · DTM · Date/Time Reference · Max >1 · Optional

            To specify pertinent dates and times

            DTM = Identifies check date, postmark date, date/time check received by LBX.

         6. 1420 · AVA · Funds Availability · Max 1 · Optional

            To indicate the funds availability in days

         7. ADX Loop Optional Repeat >1

            1. 1440 · ADX · Adjustment · Max 1 · Mandatory

               To convey accounts-payable adjustment information for the purpose of cash application, including payer-generated debit/credit memos

               This ADX loop contains adjustment items which are not netted to an RMR segment in this transaction set.

            2. 1450 · NTE · Note/Special Instruction · Max >1 · Optional

               To transmit information in a free-form format, if necessary, for comment or special instruction

            3. 1460 · PER · Administrative Communications Contact · Max >1 · Optional

               To identify a person or office to whom administrative communications should be directed

            4. 1470 · DTM · Date/Time Reference · Max 1 · Optional

               To specify pertinent dates and times

            5. REF Loop Optional Repeat >1

               1. 1480 · REF · Reference Identification · Max 1 · Mandatory

                  To specify identifying information

               2. 1490 · DTM · Date/Time Reference · Max >1 · Optional

                  To specify pertinent dates and times

            6. IT1 Loop Optional Repeat >1

               1. 1500 · IT1 · Baseline Item Data (Invoice) · Max 1 · Mandatory

                  To specify the basic and most frequently used line item data for the invoice and related transactions

                  Loop IT1 within the ADX loop is the adjustment line detail loop.

               2. REF Loop Optional Repeat >1

                  1. 1510 · REF · Reference Identification · Max 1 · Mandatory

                     To specify identifying information

                  2. 1520 · DTM · Date/Time Reference · Max 1 · Optional

                     To specify pertinent dates and times

               3. SAC Loop Optional Repeat >1

                  1. 1530 · SAC · Service, Promotion, Allowance, or Charge Information · Max 1 · Mandatory

                     To request or identify a service, promotion, allowance, or charge; to specify the amount or percentage for the service, promotion, allowance, or charge

                  2. 1540 · TXI · Tax Information · Max >1 · Optional

                     To specify tax information

               4. SLN Loop Optional Repeat >1

                  1. 1550 · SLN · Subline Item Detail · Max 1 · Mandatory

                     To specify product subline detail item data

                  2. REF Loop Optional Repeat >1

                     1. 1560 · REF · Reference Identification · Max 1 · Mandatory

                        To specify identifying information

                     2. 1570 · DTM · Date/Time Reference · Max >1 · Optional

                        To specify pertinent dates and times

                  3. SAC Loop Optional Repeat >1

                     1. 1580 · SAC · Service, Promotion, Allowance, or Charge Information · Max 1 · Mandatory

                        To request or identify a service, promotion, allowance, or charge; to specify the amount or percentage for the service, promotion, allowance, or charge

                     2. 1590 · TXI · Tax Information · Max >1 · Optional

                        To specify tax information

         8. N1 Loop Optional Repeat 200

            1. 1600 · N1 · Name · Max 1 · Mandatory

               To identify a party by type of organization, name, and code

               N1 = Identifies payer/remitter name, number.

            2. 1700 · N2 · Additional Name Information · Max 2 · Optional

               To specify additional names

            3. 1800 · N3 · Address Information · Max 2 · Optional

               To specify the location of the named party

            4. 1900 · N4 · Geographic Location · Max 1 · Optional

               To specify the geographic place of the named party

            5. 2000 · REF · Reference Identification · Max 12 · Optional

               To specify identifying information

            6. 2100 · PER · Administrative Communications Contact · Max 3 · Optional

               To identify a person or office to whom administrative communications should be directed

         9. RMR Loop Optional Repeat >1

            1. 2200 · RMR · Remittance Advice Accounts Receivable Open Item Reference · Max 1 · Mandatory

               To specify the accounts receivable open item(s) to be included in the cash application and to convey the appropriate detail

               Loop RMR is for open items being referenced or for payment on account.

            2. 2300 · N1 · Name · Max 1 · Optional

               To identify a party by type of organization, name, and code

               N1 = Identifies payer name, number if distinct from remitter name, number.

            3. 2400 · CUR · Currency · Max 1 · Optional

               To specify the currency (dollars, pounds, francs, etc.) used in a transaction

            4. 2500 · REF · Reference Identification · Max >1 · Optional

               To specify identifying information

               REF = Identifies scan line.

            5. 2600 · DTM · Date/Time Reference · Max >1 · Optional

               To specify pertinent dates and times

               DTM = Identifies document date.

            6. IT1 Loop Optional Repeat >1

               1. 2700 · IT1 · Baseline Item Data (Invoice) · Max 1 · Mandatory

                  To specify the basic and most frequently used line item data for the invoice and related transactions

                  Loop IT1 within the RMR loop is the remittance line detail loop.

               2. REF Loop Optional Repeat >1

                  1. 2800 · REF · Reference Identification · Max 1 · Mandatory

                     To specify identifying information

                  2. 2900 · DTM · Date/Time Reference · Max 1 · Optional

                     To specify pertinent dates and times

               3. SAC Loop Optional Repeat >1

                  1. 3000 · SAC · Service, Promotion, Allowance, or Charge Information · Max 1 · Mandatory

                     To request or identify a service, promotion, allowance, or charge; to specify the amount or percentage for the service, promotion, allowance, or charge

                  2. 3100 · TXI · Tax Information · Max >1 · Optional

                     To specify tax information

               4. SLN Loop Optional Repeat >1

                  1. 3200 · SLN · Subline Item Detail · Max 1 · Mandatory

                     To specify product subline detail item data

                  2. REF Loop Optional Repeat >1

                     1. 3300 · REF · Reference Identification · Max 1 · Mandatory

                        To specify identifying information

                     2. 3400 · DTM · Date/Time Reference · Max >1 · Optional

                        To specify pertinent dates and times

                  3. SAC Loop Optional Repeat >1

                     1. 3500 · SAC · Service, Promotion, Allowance, or Charge Information · Max 1 · Mandatory

                        To request or identify a service, promotion, allowance, or charge; to specify the amount or percentage for the service, promotion, allowance, or charge

                     2. 3600 · TXI · Tax Information · Max >1 · Optional

                        To specify tax information

            7. ADX Loop Optional Repeat >1

               1. 3700 · ADX · Adjustment · Max 1 · Mandatory

                  To convey accounts-payable adjustment information for the purpose of cash application, including payer-generated debit/credit memos

                  This ADX loop can only contain adjustment information for the immediately preceding RMR segment and affects the amount (RMR04) calculation. If this adjustment amount is not netted to the immediately preceding RMR, use the outer ADX loop.

               2. 3800 · NTE · Note/Special Instruction · Max >1 · Optional

                  To transmit information in a free-form format, if necessary, for comment or special instruction

               3. 3900 · PER · Administrative Communications Contact · Max >1 · Optional

                  To identify a person or office to whom administrative communications should be directed

               4. REF Loop Optional Repeat >1

                  1. 4000 · REF · Reference Identification · Max 1 · Mandatory

                     To specify identifying information

                  2. 4100 · DTM · Date/Time Reference · Max >1 · Optional

                     To specify pertinent dates and times

               5. IT1 Loop Optional Repeat >1

                  1. 4200 · IT1 · Baseline Item Data (Invoice) · Max 1 · Mandatory

                     To specify the basic and most frequently used line item data for the invoice and related transactions

                     Loop IT1 within the ADX loop is the adjustment line detail loop.

                  2. REF Loop Optional Repeat >1

                     1. 4300 · REF · Reference Identification · Max 1 · Mandatory

                        To specify identifying information

                     2. 4400 · DTM · Date/Time Reference · Max 1 · Optional

                        To specify pertinent dates and times

                  3. SAC Loop Optional Repeat >1

                     1. 4500 · SAC · Service, Promotion, Allowance, or Charge Information · Max 1 · Mandatory

                        To request or identify a service, promotion, allowance, or charge; to specify the amount or percentage for the service, promotion, allowance, or charge

                     2. 4600 · TXI · Tax Information · Max >1 · Optional

                        To specify tax information

                  4. SLN Loop Optional Repeat >1

                     1. 4700 · SLN · Subline Item Detail · Max 1 · Mandatory

                        To specify product subline detail item data

                     2. REF Loop Optional Repeat >1

                        1. 4800 · REF · Reference Identification · Max 1 · Mandatory

                           To specify identifying information

                        2. 4900 · DTM · Date/Time Reference · Max >1 · Optional

                           To specify pertinent dates and times

                     3. SAC Loop Optional Repeat >1

                        1. 5000 · SAC · Service, Promotion, Allowance, or Charge Information · Max 1 · Mandatory

                           To request or identify a service, promotion, allowance, or charge; to specify the amount or percentage for the service, promotion, allowance, or charge

                        2. 5100 · TXI · Tax Information · Max >1 · Optional

                           To specify tax information

         10. TXP Loop Optional Repeat >1

             1. 5200 · TXP · Tax Payment · Max 1 · Mandatory

                To identify tax payment data

             2. 5300 · TXI · Tax Information · Max >1 · Optional

                To specify tax information

         11. DED Loop Optional Repeat >1

             1. 5400 · DED · Deductions · Max 1 · Mandatory

                To specify payment related information for child support payment deductions

         12. LX Loop Optional Repeat >1

             1. 5500 · LX · Assigned Number · Max 1 · Mandatory

                To reference a line number in a transaction set

             2. 5600 · REF · Reference Identification · Max >1 · Optional

                To specify identifying information

             3. 5700 · TRN · Trace · Max >1 · Optional

                To uniquely identify a transaction to an application

             4. NM1 Loop Optional Repeat >1

                1. 5800 · NM1 · Individual or Organizational Name · Max 1 · Mandatory

                   To supply the full name of an individual or organizational entity

                2. 5900 · REF · Reference Identification · Max >1 · Optional

                   To specify identifying information

                3. 6000 · G53 · Maintenance Type · Max >1 · Optional

                   To identify the specific type of item maintenance

                4. AIN Loop Optional Repeat >1

                   1. 6100 · AIN · Income · Max 1 · Mandatory

                      To provide type and amount of income obtained

                   2. 6200 · QTY · Quantity · Max >1 · Optional

                      To specify quantity information

                   3. 6300 · DTP · Date or Time or Period · Max >1 · Optional

                      To specify any or all of a date, a time, or a time period

                5. PEN Loop Optional Repeat >1

                   1. 6400 · PEN · Pension Information · Max 1 · Mandatory

                      To specify financial activity for a pension plan

                   2. 6500 · AMT · Monetary Amount · Max >1 · Optional

                      To indicate the total monetary amount

                   3. 6600 · DTP · Date or Time or Period · Max >1 · Optional

                      To specify any or all of a date, a time, or a time period

                   4. INV Loop Optional Repeat >1

                      1. 6700 · INV · Investment Vehicle Selection · Max 1 · Mandatory

                         To specify type of investment vehicle or account and other basic data about the investment

                      2. 6800 · DTP · Date or Time or Period · Max >1 · Optional

                         To specify any or all of a date, a time, or a time period

Summary

1. 0100 · SE · Transaction Set Trailer · Max 1 · Mandatory

   To indicate the end of the transaction set and provide the count of the transmitted segments (including the beginning (ST) and ending (SE) segments)