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 |
|
|