Bank Account ID Mapping Fields

The following field information is intended to assist those who design reports for Sage 50 using Crystal Reports.

Filename: BKACTMAP.DAT

BKACTMAP.DAT is the bank account ID mapping file. It associates Sage 50 account records with online banking accounts.

  • To add Sage 50 account fields to your Crystal reports, select BKACTMAP.DAT.

Indexes and Their Uses

This file has the following keys:

0 = ByRecordNumber. A unique key that will not change for the lifetime of the record.

1 = ByBKCloudAcctID. This is an index ordered by the Banking Cloud Account Guid.

2 = ByS50AcctID. This is an index ordered by the Sage 50 Account Guid.

Fields

The following table shows the fields available in the BKACTMAP.DAT file and includes the type and size in number of bytes of each field.

Field Name

Type

Size

Comment

RecordNumber Integer 4 Unique record key

BKAcctID

Ubinary

16

Banking Cloud Account GUID

ByS50AcctID

Ubinary

16

Sage 50 Account Guid

What do you want to do next?