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 |