Navigation:  Deposit Reports > Deposit Reports - Numerical Order >

BAI File Creation Program (FPSDR179)

Navigation:  Deposit Reports > Deposit Reports - Numerical Order >

BAI File Creation Program (FPSDR179)

Previous pageReturn to chapter overviewNext page  Print this Topic

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.

 

honeycombgoldgpsonly

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.

©2021 GOLDPoint Systems. All rights reserved.