# Table: OFX Transactions

Table: BKUNMAT
View: BK0870
Record length: 421
Flags: A R

## Keys: 1

Title | Flags | Fields
--- | --- | ---
Bank Entry |  | BANK, UNIQUE

## Fields: 33

Field | Type | Title | Presentation
--- | --- | --- | ---
BANK | String*8 | Bank Code | Mask: %-8N
UNIQUE | Long | Unique ID |
AUDTDATE | Date |  |
AUDTTIME | Time |  |
AUDTUSER | String*8 |  |
AUDTORG | String*6 |  |
SERIAL | Long | Serial Number of Bank Transaction |
LINE | Long | Line Number of Bank Transaction |
DATE | Date | Posted Date |
TYPE | String*6 | Distribution Code | Mask: %-6N
NUMBER | String*12 | Withdrawal Number |
REFERENCE | String*60 | Reference |
COMMENT | String*60 | Comment |
AMOUNT | BCD*10.3 | Amount |
SRCEAMT | BCD*10.3 | Source Amount |
STMTCURN | String*3 | Statement Currency | Mask: %-3N
AMTINSTMT | Boolean | Is Amount in Statment Currency? | List: 2 entries
0 | = | No
1 | = | Yes
PAYEEID | String*12 | Payee Code |
PAYEENAME | String*60 | Payee Name |
RATETYPE | String*2 | Rate Type | Mask: %-2N
SRCECURN | String*3 | Source Currency | Mask: %-3N
RATEDATE | Date | Rate Date |
RATE | BCD*8.7 | Rate |
RATESPREAD | BCD*8.7 | Rate Spread |
RATEOP | Integer | Rate Operator | List: 3 entries
1 | = | Multiply
2 | = | Divide
0 | = | Not Specified
GLACCOUNT | String*45 | G/L Account | Mask: %-45C
POSTNOW | Boolean | Post Now? | List: 2 entries
0 | = | No
1 | = | Yes
ENTRYTYPE | Integer | Entry Type | List: 1 entries
0 | = | User-entered
TRXTYPE | Integer | Distribution Code | List: 2 entries
1 | = | Withdrawal
2 | = | Deposit
OFXTID | String*50 | OFX Transaction ID |
RECYEAR | String*4 | Reconciliation Year | Mask: %04D
RECPERIOD | Integer | Reconciliation Period | List: 12 entries
1 | = | 1
2 | = | 2
3 | = | 3
4 | = | 4
5 | = | 5
6 | = | 6
7 | = | 7
8 | = | 8
9 | = | 9
10 | = | 10
11 | = | 11
12 | = | 12
RECONCILED | Boolean | Match Found? | List: 2 entries
0 | = | No
1 | = | Yes

This page was generated on 2009-Nov-19

Copyright © 2001–2009 Sage Software, Inc. All rights reserved.