View: OFX Transactions

RotoID: BK0870
Table: BKUNMAT
Protocol: Detail, Sequenced revisions, Key auto generate
DLL:BKUNMAT

Compositions: 1

RotoID Tables Title DLL
BK0001 BKACCT Banks BKACCT

Keys: 1

Title Fields
Bank Entry BANK, UNIQUE

Fields: 30

Field Index Type Title Attributes Presentation
BANK 1 String*8 Bank Code E A K R  Mask: %-8N
UNIQUE 2 Long Unique ID E A K C R 
SERIAL 3 Long Serial Number of Bank Transaction E A 
LINE 4 Long Line Number of Bank Transaction E A 
DATE 5 Date Posted Date E A X 
TYPE 6 String*6 Distribution Code E A X  Mask: %-6N
NUMBER 7 String*12 Withdrawal Number E A 
REFERENCE 8 String*60 Reference E A 
COMMENT 9 String*60 Comment 1 E A 
AMOUNT 10 BCD*10.3 Amount A C 
SRCEAMT 11 BCD*10.3 Source Amount A C 
STMTCURN 12 String*3 Statement Currency E A X  Mask: %-3N
AMTINSTMT 13 Boolean Is Amount in Statment Currency? E A X  List:2 entries
0 = No
1 = Yes
PAYEEID 14 String*12 Payee Code E A 
PAYEENAME 15 String*60 Payee Name E A 
RATETYPE 16 String*2 Rate Type E A X  Mask: %-2N
SRCECURN 17 String*3 Source Currency E A X  Mask: %-3N
RATEDATE 18 Date Rate Date E A X 
RATE 19 BCD*8.7 Rate E A X 
RATESPREAD 20 BCD*8.7 Rate Spread E A X 
RATEOP 21 Integer Rate Operator E A X  List:3 entries
1 = Multiply
2 = Divide
0 = Not Specified
GLACCOUNT 22 String*45 G/L Account E A X  Mask: %-45C
POSTNOW 23 Boolean Post Now? E A X  List:2 entries
0 = No
1 = Yes
ENTRYTYPE 24 Integer Entry Type E A P  List:1 entries
0 = User-entered
TRXTYPE 25 Integer Distribution Code E A P  List:2 entries
1 = Withdrawal
2 = Deposit
OFXTID 26 String*50 OFX Transaction ID A X 
RECYEAR 27 String*4 Reconciliation Year E A X  Mask: %04D
RECPERIOD 28 Integer Reconciliation Period E A P X  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 29 Boolean Match Found? E A X  List:2 entries
0 = No
1 = Yes
MEMO 30 String*255 Comment 2 E A 

This page was generated on 2022-Aug-18

© 2021 Sage Software, Inc. All rights reserved. Reproduction of part or all of the contents in any form is prohibited unless for personal use. None of the content of this article may be copied or otherwise incorporated into any other document, publication or other work in any form (whether written, electronic or other format).

Sage Software, Inc. makes no warranties, representations or undertakings about any of the content of articles (including, without limitation, any as to the quality, accuracy, completeness or fitness for any particular purpose of such content).