Data Services Repository > Data service reference > BAI
  

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 01 record is a file header that contains information such as the sender and receiver IDs. The 02 records designate account groups. The other records contain data for specific bank transactions. The 88 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>