Table: Bank Entry Posting Journal

Table: BKJENT
View: BK0017
Record length: 577
Flags: A R 

Keys: 1

Title  Flags  Fields
Posting Sequence/Bank Code   PSTSEQ, BANK, UNIQUE

Fields: 31

Field  Type  Title  Presentation 
PSTSEQ  BCD*5.0  Posting Sequence   
BANK  String*8  Bank Code  Mask: %-8N
UNIQUE  Long  Entry Uniquifier   
AUDTDATE  Date     
AUDTTIME  Time     
AUDTUSER  String*8     
AUDTORG  String*6     
DATE  Date  Entry Date   
TYPE  String*6  Transaction Type  Mask: %-6N
REFERENCE  String*60  Reference   
COMMENT  String*60  Comment   
AMOUNT  BCD*10.3  Amount   
SRCEAMT  BCD*10.3  Source Amount   
RATETYPE  String*2  Exchange Rate Type  Mask: %-2N
SRCECURN  String*3  Payment Currency  Mask: %-3N
RATEDATE  Date  Exchange Rate Date   
RATE  BCD*8.7  Exchange Rate   
RATESPREAD  BCD*8.7  Rate Spread   
RATEOP  Integer  Rate Operation  List: 3 entries
1=Multiply
2=Divide
0=Not Specified
SRCEAMTCR  BCD*10.3  Source Credit Amount   
SRCEAMTDR  BCD*10.3  Source Debit Amount   
AMTCR  BCD*10.3  Credit Amount   
AMTDR  BCD*10.3  Debit Amount   
ENTRYAMT  BCD*10.3  Statement Amount   
IDACCT  String*45  G/L Account  Mask: %-45C
IDACCTOVR  Boolean  Account Number Override   
ENTRYTYPE  Integer  Entry Type  List: 4 entries
0=User-entered
10=Unmatched OFX
19=Unmatched OFX correction
20=Unmatched OFX error
RECYEAR  String*4  Reconciliation Fiscal Year  Mask: %04D
RECPERIOD  Integer  Reconciliation Fiscal Period  List: 14 entries
0=
1=1
2=2
3=3
4=4
5=5
6=6
7=7
8=8
9=9
10=10
11=11
12=12
13=13
RECONCILED  Boolean  Reconciled   
BIGCOMMENT  String*250  Comments   

This page was generated on 2008-Apr-11

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