Data Services Repository

Back Next

BAI

The BAI data services implement specifications developed by the BAI financial services industry organization. They include Cash Management Balance Reporting Specifications Version 2 (BAI2) and Lockbox Communications Standards for Banks (BAI Lockbox).

BAI2 message structure

BAI2 messages have a record format. Each record ends with a line break and contains comma-delimited fields.

The first two digits of each record indicate the record type. For example, notice the record types in the following BAI2 message:

01,122099999,123456789,040621,0200,1,65,,2/
02,031001234,122099999,1,040620,2359,,2/
03,0123456789,,010,+4350000,,,040,2830000,,/
88,072,1020000,,,074,500000,,/
16,115,450000,S,100000,200000,150000,,,/
16,115,10000000,S,5000000,4000000,1000000/
88,AX13612,B096132,AMALGAMATED CORP. LOCKBOX
88,DEPOSIT-MISC. RECEIVABLES
49,9150000,4/
03,9876543210,,010,-500000,,,100,1000000,,,400,2000000,,,190/
88,500000,,,110,1000000,,,072,500000,,,074,500000,,,040/
88,-1500000,,/
16,115,500000,S,,200000,300000,,,LOCK BOX NO.68751
49,4000000,5/
98,13150000,2,11/
02,053003456,122099999,1,040620,2359,,2/
03,4589761203,,010,10000000,,,040,5000000,,,074,4000000,,/
...

The

record is a file header that contains information such as the sender and receiver IDs. The

records designate account groups. The other records contain data for specific bank transactions. The

records are continuation lines.

BAI2 message in XML format

The BAI2 parser data services can convert BAI2 messages into XML format. The following example shows a BAI2 message in XML format:

<BAI>
  <Delimiters>
    <RecordDelimiter>/</RecordDelimiter>
    <FieldDelimiter>,</FieldDelimiter>
  </Delimiters>
  <FileHeader_01>
    <SenderIdentification>072000096</SenderIdentification>
    <ReceiverIdentification>072000096</ReceiverIdentification>
    <FileCreationDate>060322</FileCreationDate>
    <FileCreationTime>0433</FileCreationTime>
    <FileIdentificationNumber>1</FileIdentificationNumber>
    <PhysicalRecordLength>80</PhysicalRecordLength>
    <VersionNumber>2</VersionNumber>
  </FileHeader_01>
  <LoopGroups>
    <GroupHeader_02>
      <UltimateReceiverIdentification>000000000</UltimateReceiverIdentification>
      <OriginatorIdentification>072000096</OriginatorIdentification>
      <GroupStatus>1</GroupStatus>
      <AsOfDate>060321</AsOfDate>
      <AsOfTime>0433</AsOfTime>
      <CurrencyCode />
      <AsOfDateModifier>2</AsOfDateModifier>
    </GroupHeader_02>
    <LoopAccounts>
      <AccountIdentifier_03>
        <CustomerAccountNumber>1000000001</CustomerAccountNumber>
        <CurrencyCode />
        <TypeCode>015</TypeCode>
        <Amount>+0000016668216</Amount>
        <FundsType />
        <TypeCode>040</TypeCode>
        <Amount>+0000016668216</Amount>

BAI Lockbox message structure

BAI Lockbox messages have a positional structure, such as in the following example:

100412109254801210002480611210505                                               
241210925480121000248000000000040008000801                                      
5001001020174506112141210925480121000248                                        
60010010000377969111000614634566970 071324    MAYDAY                            
4001001601034145204       0000016750                                            
4001001602034145409       0000009500

BAI Lockbox message in XML format

The BAI Lockbox parser data services can convert BAI Lockbox messages into XML format. The following example shows a BAI Lockbox message in XML format:

<BAI_Lockbox>
  <ImmediateAddressHeader>
    <PriorityCode>00</PriorityCode>
    <ImmediateDestination>4121092548</ImmediateDestination>
    <OriginCode>0121000248</OriginCode>
    <DepositDate>061121</DepositDate>
    <TransmissionTime>0505</TransmissionTime>
  </ImmediateAddressHeader>
  <ServiceRecord>
    <UltimateDestination>4121092548</UltimateDestination>
    <OriginCode>0121000248</OriginCode>
    <ReferenceCode>0000000000</ReferenceCode>
    <ServiceType>400</ServiceType>
    <RecordSize>80</RecordSize>
    <BlockingFactor>0080</BlockingFactor>
    <FormatCode>1</FormatCode>
  </ServiceRecord>
  <Lockbox>
    <DetailHeader>
      <BatchNumber>001</BatchNumber>
      <ItemNumber>001</ItemNumber>
      <LockboxCode>0201745</LockboxCode>
      <DepositDate>061121</DepositDate>
      <UltimateDestination>4121092548</UltimateDestination>
      <OriginCode>0121000248</OriginCode>
    </DetailHeader>
    <Batch>
      <DetailRecord>
        <BatchNumber>1</BatchNumber>
        <ItemNumber>1</ItemNumber>
        <RemittanceAmount>377969</RemittanceAmount>
        <RemitterIdentification>11100061</RemitterIdentification>

Rename Saved Search

Table of Contents

Data Services Repository

Data Services Repository

BAI

BAI

BAI2 message structure

BAI2 message in XML format

BAI Lockbox message structure

BAI Lockbox message in XML format