Table: OFX Transactions

Table: BKUNMAT
View: BK0870
Record Length: 676

Flags: A R 

Keys: 1

Title Flags Fields

Bank Entry BANKUNIQUE

Fields: 34

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 1
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
MEMO String*255 Comment 2