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

Position
Segment
Name
Max use
  1. To indicate the start of a transaction set and to assign a control number

  2. N1 Loop Mandatory
    Repeat 2
    1. 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. To specify additional names or those longer than 35 characters in length

    3. To specify the location of the named party

    4. To specify the geographic place of the named party

    5. To specify identifying information

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

  3. To uniquely identify a transaction to an application

    The TRN segment is used to uniquely identify a lockbox transaction set.
  4. 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

Position
Segment
Name
Max use
  1. DEP Loop Mandatory
    Repeat 100
    1. 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. To indicate the total monetary amount

      AMT = Total deposit dollars.
    3. To specify quantity information

      QTY = Number of batches in deposit; number of checks in deposit.
    4. To specify identifying information

      REF = Identifies deposit number and/or deposit sequence number.
    5. To specify pertinent dates and times

      Identifies processing or other date/time information.
    6. BAT Loop Optional
      Repeat 100
      1. To indicate batch identifying information

      2. To indicate the funds availability in days

      3. To indicate the total monetary amount

        AMT = Total batch dollars.
      4. To specify quantity information

        QTY = Number of checks in batch.
      5. To specify pertinent dates and times

        DTM = Identifies processing or other date/time information.
      6. BPR Loop Optional
        Repeat >1
        1. 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. To uniquely identify a transaction to an application

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

        4. To specify identifying information

          REF = Identifies payee code, MICR line, check number and scan line.
        5. To specify pertinent dates and times

          DTM = Identifies check date, postmark date, date/time check received by LBX.
        6. To indicate the funds availability in days

        7. ADX Loop Optional
          Repeat >1
          1. 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. To transmit information in a free-form format, if necessary, for comment or special instruction

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

          4. To specify pertinent dates and times

          5. REF Loop Optional
            Repeat >1
            1. To specify identifying information

            2. To specify pertinent dates and times

          6. IT1 Loop Optional
            Repeat >1
            1. 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. To specify identifying information

              2. To specify pertinent dates and times

            3. SAC Loop Optional
              Repeat >1
              1. To request or identify a service, promotion, allowance, or charge; to specify the amount or percentage for the service, promotion, allowance, or charge

              2. To specify tax information

            4. SLN Loop Optional
              Repeat >1
              1. To specify product subline detail item data

              2. REF Loop Optional
                Repeat >1
                1. To specify identifying information

                2. To specify pertinent dates and times

              3. SAC Loop Optional
                Repeat >1
                1. To request or identify a service, promotion, allowance, or charge; to specify the amount or percentage for the service, promotion, allowance, or charge

                2. To specify tax information

        8. N1 Loop Optional
          Repeat 200
          1. To identify a party by type of organization, name, and code

            N1 = Identifies payer/remitter name, number.
          2. To specify additional names or those longer than 35 characters in length

          3. To specify the location of the named party

          4. To specify the geographic place of the named party

          5. To specify identifying information

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

        9. RMR Loop Optional
          Repeat >1
          1. 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. To identify a party by type of organization, name, and code

            N1 = Identifies payer name, number if distinct from remitter name, number.
          3. To specify the currency (dollars, pounds, francs, etc.) used in a transaction

          4. To specify identifying information

            REF = Identifies scan line.
          5. To specify pertinent dates and times

            DTM = Identifies document date.
          6. IT1 Loop Optional
            Repeat >1
            1. 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. To specify identifying information

              2. To specify pertinent dates and times

            3. SAC Loop Optional
              Repeat >1
              1. To request or identify a service, promotion, allowance, or charge; to specify the amount or percentage for the service, promotion, allowance, or charge

              2. To specify tax information

            4. SLN Loop Optional
              Repeat >1
              1. To specify product subline detail item data

              2. REF Loop Optional
                Repeat >1
                1. To specify identifying information

                2. To specify pertinent dates and times

              3. SAC Loop Optional
                Repeat >1
                1. To request or identify a service, promotion, allowance, or charge; to specify the amount or percentage for the service, promotion, allowance, or charge

                2. To specify tax information

          7. ADX Loop Optional
            Repeat >1
            1. 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. To transmit information in a free-form format, if necessary, for comment or special instruction

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

            4. REF Loop Optional
              Repeat >1
              1. To specify identifying information

              2. To specify pertinent dates and times

            5. IT1 Loop Optional
              Repeat >1
              1. 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. To specify identifying information

                2. To specify pertinent dates and times

              3. SAC Loop Optional
                Repeat >1
                1. To request or identify a service, promotion, allowance, or charge; to specify the amount or percentage for the service, promotion, allowance, or charge

                2. To specify tax information

              4. SLN Loop Optional
                Repeat >1
                1. To specify product subline detail item data

                2. REF Loop Optional
                  Repeat >1
                  1. To specify identifying information

                  2. To specify pertinent dates and times

                3. SAC Loop Optional
                  Repeat >1
                  1. To request or identify a service, promotion, allowance, or charge; to specify the amount or percentage for the service, promotion, allowance, or charge

                  2. To specify tax information

        10. TXP Loop Optional
          Repeat >1
          1. To identify tax payment data

          2. To specify tax information

        11. DED Loop Optional
          Repeat >1
          1. To specify payment related information for child support payment deductions

        12. LX Loop Optional
          Repeat >1
          1. To reference a line number in a transaction set

          2. To specify identifying information

          3. To uniquely identify a transaction to an application

          4. NM1 Loop Optional
            Repeat >1
            1. To supply the full name of an individual or organizational entity

            2. To specify identifying information

            3. To identify the specific type of item maintenance

            4. AIN Loop Optional
              Repeat >1
              1. To provide type and amount of income obtained

              2. To specify quantity information

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

            5. PEN Loop Optional
              Repeat >1
              1. To specify financial activity for a pension plan

              2. To indicate the total monetary amount

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

              4. INV Loop Optional
                Repeat >1
                1. To specify type of investment vehicle or account and other basic data about the investment

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

Summary

Position
Segment
Name
Max use
  1. To indicate the end of the transaction set and provide the count of the transmitted segments (including the beginning (ST) and ending (SE) segments)

Stedi is a registered trademark of Stedi, Inc. Stedi's EDI Reference is provided for marketing purposes and is free of charge. All names, logos, and brands of third parties listed on our site are trademarks of their respective owners (including “X12”, which is a trademark of X12 Incorporated). Stedi, Inc. and its products and services are not endorsed by, sponsored by, or affiliated with these third parties. Our use of these names, logos, and brands is for identification purposes only, and does not imply any such endorsement, sponsorship, or affiliation.