Online Banking Transactions Fields

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

Filename: OLTRANS.DAT

OLTRANS.DAT contains the online banking transactions downloaded from a bank and the reconciliation of downloaded transactions to journal records.

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

Indexes and Their Uses

This file has the following keys:

0 = By m_GUID

1 = By m_GUID and then by dtPosted

2 = By sBankID and then by sAcctID and then by sAcctType

3 = By sBankID and then by sAcctID and then by sAcctType and then by dtPosted

4 = By guidJrnlRowGUID

5 = By guidJrnlRowGUID and then by dtPosted

6 = By lGLAcctNumber

7 = By lGLAcctNumber and then by dtPosted

8 = By dtPosted

Fields

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

Field Name

Type

Size

Comment

GUID

16

GUID

Primary key

BankID

33

String

The bank id for the parent account of the transaction, usually the aba number.

AcctID

33

String

The account id for the parent account of the transaction.

AcctType

11

String

The account type for the parent account of the transaction.  This must be one of {CHECKING, SAVINGS, MONEYMRKT, CREDITLINE}

GuidJrnlRowGUID

16

GUID

The unique identifier of the journal row to which this transaction was reconciled.

GLAcctNumber

4

LONG

Which GL account does this refer to? Populated with value in AccountType::RecordNumber

TrnType

12

String

The transaction type.  This must be one of {CREDIT, DEBIT, INT, DIV, FEE, SRVCHG, DEP, ATM, POS, XFER, CHECK, PAYMENT, CASH, DIRECTDEP, DIRECTDEBIT, REPEATPMT, OTHER}

PostedDate

4

Date

The posting date for the transaction

TrnAmt

Decimal

The dollar amount of the transaction

FITID

256

String

The financial institution transaction id of the transaction

SRVRTID

33

String

The server transaction id of the transaction, this is used to identify a transaction in any payment modification/cancellation requests.

RefNum

33

String

The transactions reference number

Desc

33

String

A description for the transaction

Memo

256

String

The transactions memo field

CurSYM

4

The currency symbol for the transaction

CurRate

The exchange rate between the currency of the transaction and the default currency type for the financial institution.

LastUpdateCounter

4