Navigation: Deposit Reports > Deposit Reports - Numerical Order >
Availability
This file is run daily in the afterhours for Cendant Corp. Treasuries.
Purpose
The purpose of this program is to create a BAI file containing daily balance and activity information to be sent to Cendant for processing. This file will be put out to the BLOB (Binary Large Object File), where it will be downloaded to the FTP server. From there, Cendant can capture it. All deposit account balances and activity will be reported each day. This report reads the deposit (DM) and transaction log (TG) records. Listed below is the file layout of the records created by this report. Each record is 132 characters long. Since the white space is removed from each record before the file is put out to the BLOB, the file Cendant captures has variable length records.
GOLDPoint Systems Only: To set a BAI file to report current-day, interim data, the Misc Opts 1 field must be set to "Y." This will cause the file to report all the day’s activity for every account up to the time the file is created. This option should only be run upon an institution's request; it is not meant to be run daily. |
---|
File Layout
Record 01
Field Description |
Position* |
Width |
Record Code (file header) |
12 |
2 |
Sender Identification |
4 |
13 |
Receiver Identification |
18 |
16 |
Sender Date |
34 |
6 |
Sender Time |
42 |
4 |
File Identification Number |
47 |
1 |
Physical Record Length |
49 |
3 |
Block Size |
53 |
1 |
Version Number (always 2) |
55 |
1 |
Ending Slash |
56 |
1 |
Blank Space |
57 |
76 |
Record 02
Field Description |
Position* |
Width |
Record Code (group header) |
1 |
2 |
File Receiver Identification |
4 |
15 |
Originator Identification |
20 |
13 |
Group Status |
34 |
1 |
As-of Date |
36 |
6 |
As-of Time |
43 |
4 |
Currency Code |
48 |
3 |
Modifier (2 (EOD) 3 (Iterim)) |
52 |
1 |
Ending Slash |
53 |
1 |
Blank Space |
54 |
79 |
Record 03
Field Description |
Position* |
Width |
Record Code (account identifier) |
1 |
2 |
Account Number |
4 |
18 |
Currency Code |
23 |
3 |
Type Code Field One |
27 |
3 |
Amount Field Field One |
31 |
11 |
Amount Sign Field One |
42 |
1 |
Item Count Field One |
44 |
5 |
Funds Type Field One |
50 |
1 |
Type Code Field Two |
52 |
3 |
Amount Field Field Two |
56 |
11 |
Amount Sign Field Two |
67 |
1 |
Item Count Field Two |
69 |
5 |
Funds Type Field Two |
75 |
1 |
Type Code Field Three |
77 |
3 |
Amount Field Field Three |
81 |
11 |
Amount Sign Field Three |
92 |
1 |
Item Count Field Three |
94 |
5 |
Funds Type Field Three |
100 |
1 |
Ending Slash |
101 |
1 |
Blank Space |
102 |
31 |
Record 16
Field Description |
Position* |
Width |
Record Code (transaction detail) |
1 |
2 |
Type Code |
4 |
3 |
Amount Field |
8 |
11 |
Funds Type |
20 |
1 |
Bank Reference Number |
22 |
16 |
Customer Reference Number |
39 |
16 |
Optional Text Field |
56 |
77 |
Record 49
Field Description |
Position* |
Width |
Record Code (account trailer) |
1 |
2 |
Account Amounts Fields Total |
4 |
15 |
Amount Total Sign |
19 |
1 |
Account Records Total |
21 |
3 |
Ending Slash |
24 |
1 |
Blank Space |
25 |
108 |
Record 98
Field Description |
Position* |
Width |
Record Code (group trailer) |
1 |
2 |
Group Amounts Fields Total |
4 |
15 |
Amount Total Sign |
19 |
1 |
Total Accounts |
21 |
6 |
Group Records Total |
28 |
9 |
Ending Slash |
37 |
1 |
Blank Space |
38 |
95 |
Record 99
Field Description |
Position* |
Width |
Record Code (file trailer) |
1 |
2 |
File Amount Fields Total |
4 |
17 |
Amount Total Sign |
21 |
1 |
Total Groups |
23 |
3 |
File Records Total |
27 |
10 |
Ending Slash |
37 |
1 |
Blank Space |
38 |
95 |
* All fields are separated with commas except the Ending Slash. This field is neither preceded nor followed by a comma.