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.