BAI2 Parser Validations

The BAI2 parser validates the structure and field values in BAI2 statement files during import. If a required value is missing or a value does not use the expected format, the import fails, and NetSuite shows a file import error.

To help resolve BAI2-related import errors, see BAI2 File Import Error Messages.

The following table lists the BAI2 records and fields that the parser validates for a specific value or format:

Record 01 File Header
Record 02 Group Header
Record 03 Account Identifier
Record 16 Transaction Detail
Record 88 Continuation Record
Record 49 Account Trailer
Record 98 Group Trailer
Record 99 File Trailer

Record 01 File Header

BAI2 Field	Requirement	Validation
Record Code	Required	01
Sender Identification	Required	Alphanumeric
Receiver Identification	Required	Alphanumeric
File Creation Date	Required	Enter the date in YYMMDD format. The format must meet the following requirements: Month is 01 through 12. Day is 01 through 31. This validation does not confirm whether the value is a valid calendar date.
File Creation Time	Required	Enter the time in HHMM format. The value must be 0000 through 2400. If no value is provided, the bank automatically uses 9999.
File Identification Number	Required	Alphanumeric
Physical Record Length	Optional	If provided, the value must be numeric and contain only digits 0 through 9.
Block Size	Optional	If provided, the value must be numeric and contain only digits 0 through 9.
Version Number	Required	2

BAI2 Field

Requirement

Validation

Record Code

Required

Sender Identification

Required

Alphanumeric

Receiver Identification

Required

Alphanumeric

File Creation Date

Required

Enter the date in YYMMDD format.

The format must meet the following requirements:

Month is 01 through 12.
Day is 01 through 31.
This validation does not confirm whether the value is a valid calendar date.

File Creation Time

Required

Enter the time in HHMM format.

The value must be 0000 through 2400. If no value is provided, the bank automatically uses 9999.

File Identification Number

Required

Alphanumeric

Physical Record Length

Optional

If provided, the value must be numeric and contain only digits 0 through 9.

Block Size

Optional

If provided, the value must be numeric and contain only digits 0 through 9.

Version Number

Required

Record 02 Group Header

BAI2 Field	Requirement	Validation
Record Code	Required	02
Ultimate Receiver Identification	Optional	Alphanumeric
Originator Identification	Required	Alphanumeric
Group Status	Required	1, 2, 3, or 4
As-of-Date	Required	Enter the date in YYMMDD format. The format must meet the following requirements: Month is 01 through 12. Day is 01 through 31. This validation does not confirm whether the value is a valid calendar date.
As-of-Time	Optional	Enter the time in HHMM format. The value must be 0000 through 2400. If no value is provided, the bank automatically uses 9999.
Currency Code	Optional	Valid currency code, such as USD or GBP
As-Of-Date Modifier	Optional	If provided, the value must be 1, 2, 3, or 4

BAI2 Field

Requirement

Validation

Record Code

Required

Ultimate Receiver Identification

Optional

Alphanumeric

Originator Identification

Required

Alphanumeric

Group Status

Required

1, 2, 3, or 4

As-of-Date

Required

Enter the date in YYMMDD format.

The format must meet the following requirements:

Month is 01 through 12.
Day is 01 through 31.
This validation does not confirm whether the value is a valid calendar date.

As-of-Time

Optional

Enter the time in HHMM format.

The value must be 0000 through 2400. If no value is provided, the bank automatically uses 9999.

Currency Code

Optional

Valid currency code, such as USD or GBP

As-Of-Date Modifier

Optional

If provided, the value must be 1, 2, 3, or 4

Record 03 Account Identifier

BAI2 Field	Requirement	Validation
Record Code	Required	03
Customer Account Number	Required	Alphanumeric value. The value must not contain forward slash (/) or comma (,).
Currency Code	Optional	Valid currency code, such as USD or GBP
Type Code	Optional	If provided, the value must be a three-digit type code. For example, 400.
Amount	Optional	Numeric value with an optional plus sign (+) or minus sign (-)
Funds Type	Optional	If provided, the value must be 0, 1, 2, S, V, D, or Z. Alphabetic values must be uppercase.
Immediate Availability Amount	Optional Applicable only when Funds Type value is S.	Numeric value with an optional plus sign (+) or minus sign (-)
One-Day Availability Amount	Optional Applicable only when Funds Type value is S.	Numeric value with an optional plus sign (+) or minus sign (-)
More than One Day Availability Amount	Optional Applicable only when Funds Type value is S.	Numeric value with an optional plus sign (+) or minus sign (-)
Value Date	Required when Funds Type value is V.	Enter the date in YYMMDD format. The format must meet the following requirements: Month is 01 through 12. Day is 01 through 31. This validation does not confirm whether the value is a valid calendar date.
Value Time	Optional Applicable only when Funds Type value is V.	Enter the time in HHMM format. The value must be 0000 through 2400. If no value is provided, the bank automatically uses 9999.
Number of Distributions	Required when Funds Type value is D.	The value must be numeric and contain only digits 0 through 9.
Availability in Days	Required when Funds Type value is D and Number of Distributions is greater than 0.	The value must be numeric and contain only digits 0 through 9.
Availability Amount	Required when Funds Type value is D and Number of Distributions is greater than 0.	Numeric value with an optional plus sign (+) or minus sign (-)

BAI2 Field

Requirement

Validation

Record Code

Required

Customer Account Number

Required

Alphanumeric value. The value must not contain forward slash (/) or comma (,).

Currency Code

Optional

Valid currency code, such as USD or GBP

Type Code

Optional

If provided, the value must be a three-digit type code. For example, 400.

Amount

Optional

Numeric value with an optional plus sign (+) or minus sign (-)

Funds Type

Optional

If provided, the value must be 0, 1, 2, S, V, D, or Z. Alphabetic values must be uppercase.

Immediate Availability Amount

Optional

Applicable only when Funds Type value is S.

Numeric value with an optional plus sign (+) or minus sign (-)

One-Day Availability Amount

Optional

Applicable only when Funds Type value is S.

Numeric value with an optional plus sign (+) or minus sign (-)

More than One Day Availability Amount

Optional

Applicable only when Funds Type value is S.

Numeric value with an optional plus sign (+) or minus sign (-)

Value Date

Required when Funds Type value is V.

Enter the date in YYMMDD format.

The format must meet the following requirements:

Month is 01 through 12.
Day is 01 through 31.
This validation does not confirm whether the value is a valid calendar date.

Value Time

Optional

Applicable only when Funds Type value is V.

Enter the time in HHMM format.

The value must be 0000 through 2400. If no value is provided, the bank automatically uses 9999.

Number of Distributions

Required when Funds Type value is D.

The value must be numeric and contain only digits 0 through 9.

Availability in Days

Required when Funds Type value is D and Number of Distributions is greater than 0.

The value must be numeric and contain only digits 0 through 9.

Availability Amount

Required when Funds Type value is D and Number of Distributions is greater than 0.

Numeric value with an optional plus sign (+) or minus sign (-)

Record 16 Transaction Detail

BAI2 Field	Requirement	Validation
Record Code	Required	16
Type Code	Required	The value must be a three-digit type code. For example, 400.
Amount	Optional	Numeric value with an optional plus sign (+). Negative values are not allowed.
Funds Type	Optional	If provided, the value must be 0, 1, 2, S, V, D, or Z. Alphabetic values must be uppercase.
Immediate Availability Amount	Optional Applicable only when Funds Type value is S.	Numeric value with an optional plus sign (+) or minus sign (-)
One-Day Availability Amount	Optional Applicable only when Funds Type value is S.	Numeric value with an optional plus sign (+) or minus sign (-)
More than One Day Availability Amount	Optional Applicable only when Funds Type value is S.	Numeric value with an optional plus sign (+) or minus sign (-)
Value Date	Required when Funds Type value is V.	Enter the date in YYMMDD format. The format must meet the following requirements: Month is 01 through 12. Day is 01 through 31. This validation does not confirm whether the value is a valid calendar date.
Value Time	Optional Applicable only when Funds Type value is V.	Enter the time in HHMM format. The value must be 0000 through 2400. If no value is provided, the bank automatically uses 9999.
Number of Distributions	Required when Funds Type value is D.	The value must be numeric and contain only digits 0 through 9.
Availability in Days	Required when Funds Type value is D and Number of Distributions is greater than 0.	The value must be numeric and contain only digits 0 through 9.
Availability Amount	Required when Funds Type value is D and Number of Distributions is greater than 0.	Numeric value with an optional plus sign (+) or minus sign (-)
Bank Reference Number	Optional	Alphanumeric value. The value must not contain forward slash (/) or comma (,).
Customer Reference Number	Optional	Alphanumeric value. The value must not contain forward slash (/) or comma (,).
Text	Optional	Alphanumeric

BAI2 Field

Requirement

Validation

Record Code

Required

Type Code

Required

The value must be a three-digit type code. For example, 400.

Amount

Optional

Numeric value with an optional plus sign (+). Negative values are not allowed.

Funds Type

Optional

If provided, the value must be 0, 1, 2, S, V, D, or Z. Alphabetic values must be uppercase.

Immediate Availability Amount

Optional

Applicable only when Funds Type value is S.

Numeric value with an optional plus sign (+) or minus sign (-)

One-Day Availability Amount

Optional

Applicable only when Funds Type value is S.

Numeric value with an optional plus sign (+) or minus sign (-)

More than One Day Availability Amount

Optional

Applicable only when Funds Type value is S.

Numeric value with an optional plus sign (+) or minus sign (-)

Value Date

Required when Funds Type value is V.

Enter the date in YYMMDD format.

The format must meet the following requirements:

Month is 01 through 12.
Day is 01 through 31.
This validation does not confirm whether the value is a valid calendar date.

Value Time

Optional

Applicable only when Funds Type value is V.

Enter the time in HHMM format.

The value must be 0000 through 2400. If no value is provided, the bank automatically uses 9999.

Number of Distributions

Required when Funds Type value is D.

The value must be numeric and contain only digits 0 through 9.

Availability in Days

Required when Funds Type value is D and Number of Distributions is greater than 0.

The value must be numeric and contain only digits 0 through 9.

Availability Amount

Required when Funds Type value is D and Number of Distributions is greater than 0.

Numeric value with an optional plus sign (+) or minus sign (-)

Bank Reference Number

Optional

Alphanumeric value. The value must not contain forward slash (/) or comma (,).

Customer Reference Number

Optional

Alphanumeric value. The value must not contain forward slash (/) or comma (,).

Text

Optional

Alphanumeric

Record 88 Continuation Record

Note:

Record 88 does not define its own data fields. The parser removes the 88 record code and parses the remaining values as part of the immediately preceding record.

BAI2 Field	Requirement	Validation
Record Code	Optional	If provided, the value must be 88.
Continuation Data	Optional	Must follow the field sequence and validation rules of the preceding record being continued.

BAI2 Field

Requirement

Validation

Record Code

Optional

If provided, the value must be 88.

Continuation Data

Optional

Must follow the field sequence and validation rules of the preceding record being continued.

Record 49 Account Trailer

BAI2 Field	Requirement	Validation
Record Code	Required	49
Account Control Total	Required	Numeric value with an optional plus sign (+) or minus sign (-). The value must match the account control total calculated from Record 03 Amount values and Record 16 Amount values whose Type Code is not 890.
Number of Records	Required	Numeric value. The value must match the total number of records for the account, including Record 03, 16, 88, and 49 records.

BAI2 Field

Requirement

Validation

Record Code

Required

Account Control Total

Required

Numeric value with an optional plus sign (+) or minus sign (-).

The value must match the account control total calculated from Record 03 Amount values and Record 16 Amount values whose Type Code is not 890.

Number of Records

Required

Numeric value. The value must match the total number of records for the account, including Record 03, 16, 88, and 49 records.

Record 98 Group Trailer

BAI2 Field	Requirement	Validation
Record Code	Required	98
Group Control Total	Required	Numeric value with an optional plus sign (+) or minus sign (-). The value must match the sum of all Account Control Total field values in the group.
Number of Accounts	Required	Numeric value. The value must match the total number of Record 03 accounts in the group.
Number of Records	Required	Numeric value. The value must match the total number of records in the group, including Record 02, 03, 16, 88, 49, and 98 records.

BAI2 Field

Requirement

Validation

Record Code

Required

Group Control Total

Required

Numeric value with an optional plus sign (+) or minus sign (-).

The value must match the sum of all Account Control Total field values in the group.

Number of Accounts

Required

Numeric value. The value must match the total number of Record 03 accounts in the group.

Number of Records

Required

Numeric value. The value must match the total number of records in the group, including Record 02, 03, 16, 88, 49, and 98 records.

Record 99 File Trailer

BAI2 Field	Requirement	Validation
Record Code	Required	99
File Control Total	Required	Numeric value with an optional plus sign (+) or minus sign (-). The value must match the sum of all Group Control Total field values in the file.
Number of Groups	Required	Numeric value. The value must match the total number of Record 02 groups in the file.
Number of Records	Required	Numeric value. The value must match the total number of records in the file, including Record 01, 02, 03, 16, 88, 49, 98, and 99 records.

BAI2 Field

Requirement

Validation

Record Code

Required

File Control Total

Required

Numeric value with an optional plus sign (+) or minus sign (-).

The value must match the sum of all Group Control Total field values in the file.

Number of Groups

Required

Numeric value. The value must match the total number of Record 02 groups in the file.

Number of Records

Required

Numeric value. The value must match the total number of records in the file, including Record 01, 02, 03, 16, 88, 49, 98, and 99 records.

Record 01 File Header

Record 02 Group Header

Record 03 Account Identifier

Record 16 Transaction Detail

Record 88 Continuation Record

Record 49 Account Trailer

Record 98 Group Trailer

Record 99 File Trailer

Related Topics