Table: Bank Entries

Table: BKENT
View: BK0007
Record length: 1696
Flags: A R 

Keys: 2

Title  Flags  Fields

Bank Entry  BANK, UNIQUE
Bank Reconciliation Fiscal Entry  D M  BANK, RECYEAR, RECPERIOD, UNIQUE

Fields: 122

Field  Type  Title  Presentation 

BANK  String*8  Bank Code  Mask: %-8N
UNIQUE  Long  Entry Uniquifier   
AUDTDATE  Date     
AUDTTIME  Time     
AUDTUSER  String*8     
AUDTORG  String*6     
DATE  Date  Trans. Date   
TYPE  String*6  Transaction Type  Mask: %-6N
REFERENCE  String*60  Reference   
COMMENT  String*60  Description   
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
GLACCOUNT  String*45  G/L Account  Mask: %-45C
POSTNOW  Boolean  Post Immediately  List: 2 entries
0=No
1=Yes
ENTRYTYPE  Integer  Entry Type  List: 1 entries
0=User-entered
OFXTID  String*50  OFX Transaction ID   
RECYEAR  String*4  Reconciliation Fiscal Year  Mask: %04D
RECPERIOD  Integer  Reconciliation Fiscal 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  Reconciled   
BIGCOMMENT  String*250  Comments   
SWTAXBL  Integer  Taxable  List: 2 entries
0=No
1=Yes
TXAMTCALC  Integer  Tax Amount Calculation  List: 2 entries
0=No
1=Yes
CODETAXGRP  String*12  Tax Group  Mask: %-12N
TAXAUTH1  String*12  Tax Authority 1  Mask: %-12N
TAXAUTH2  String*12  Tax Authority 2  Mask: %-12N
TAXAUTH3  String*12  Tax Authority 3  Mask: %-12N
TAXAUTH4  String*12  Tax Authority 4  Mask: %-12N
TAXAUTH5  String*12  Tax Authority 5  Mask: %-12N
TAXVCLSS1  Integer  Tax Vendor Class 1   
TAXVCLSS2  Integer  Tax Vendor Class 2   
TAXVCLSS3  Integer  Tax Vendor Class 3   
TAXVCLSS4  Integer  Tax Vendor Class 4   
TAXVCLSS5  Integer  Tax Vendor Class 5   
TAXICLSS1  Integer  Tax Item Class 1   
TAXICLSS2  Integer  Tax Item Class 2   
TAXICLSS3  Integer  Tax Item Class 3   
TAXICLSS4  Integer  Tax Item Class 4   
TAXICLSS5  Integer  Tax Item Class 5   
TAXINCL1  Integer  Tax Include 1  List: 2 entries
0=No
1=Yes
TAXINCL2  Integer  Tax Include 2  List: 2 entries
0=No
1=Yes
TAXINCL3  Integer  Tax Include 3  List: 2 entries
0=No
1=Yes
TAXINCL4  Integer  Tax Include 4  List: 2 entries
0=No
1=Yes
TAXINCL5  Integer  Tax Include 5  List: 2 entries
0=No
1=Yes
BASETAX1  BCD*10.3  Tax Base Amount 1   
BASETAX2  BCD*10.3  Tax Base Amount 2   
BASETAX3  BCD*10.3  Tax Base Amount 3   
BASETAX4  BCD*10.3  Tax Base Amount 4   
BASETAX5  BCD*10.3  Tax Base Amount 5   
TXCALCBASE  Integer  Tax Base Calculation Method  List: 2 entries
0=No
1=Yes
AMTTAX1  BCD*10.3  Tax Amount 1   
AMTTAX2  BCD*10.3  Tax Amount 2   
AMTTAX3  BCD*10.3  Tax Amount 3   
AMTTAX4  BCD*10.3  Tax Amount 4   
AMTTAX5  BCD*10.3  Tax Amount 5   
AMTTXBL  BCD*10.3  Taxable AMount   
AMTNOTTXBL  BCD*10.3  Non Taxable Amount   
AMTTAXTOT  BCD*10.3  Tax Total   
AMTDOCTOT  BCD*10.3  Document Total Before Tax   
AMTNETTOT  BCD*10.3  Document Total Including Tax   
AMTDIST  BCD*10.3  Tax Distribution amount   
AMTINCLUDE  BCD*10.3  Total Included Amount   
AMTNETDIST  BCD*10.3  Tax Net Distribution Amount   
AMTEXCLUDE  BCD*10.3  Total Excluded Amount   
AMTGRODIST  BCD*10.3  Tax Gross Distribution Amount   
AMTEXPENS1  BCD*10.3  Tax Expense Amount 1   
AMTEXPENS2  BCD*10.3  Tax Expense Amount 2   
AMTEXPENS3  BCD*10.3  Tax Expense Amount 3   
AMTEXPENS4  BCD*10.3  Tax Expense Amount 4   
AMTEXPENS5  BCD*10.3  Tax Expense Amount 5   
AMTRECVRB1  BCD*10.3  Tax Recoverable AMount 1   
AMTRECVRB2  BCD*10.3  Tax Recoverable AMount 2   
AMTRECVRB3  BCD*10.3  Tax Recoverable AMount 3   
AMTRECVRB4  BCD*10.3  Tax Recoverable AMount 4   
AMTRECVRB5  BCD*10.3  Tax Recoverable AMount 5   
TOTAMTALOC  BCD*10.3  Total Tax Allocated Amount   
TXAMT1RC  BCD*10.3  Tax Reporting Amount 1   
TXAMT2RC  BCD*10.3  Tax Reporting Amount 2   
TXAMT3RC  BCD*10.3  Tax Reporting Amount 3   
TXAMT4RC  BCD*10.3  Tax Reporting Amount 4   
TXAMT5RC  BCD*10.3  Tax Reporting Amount 5   
TXEXPNS1RC  BCD*10.3  Tax Reporting Expensed 1   
TXEXPNS2RC  BCD*10.3  Tax Reporting Expensed 2   
TXEXPNS3RC  BCD*10.3  Tax Reporting Expensed 3   
TXEXPNS4RC  BCD*10.3  Tax Reporting Expensed 4   
TXEXPNS5RC  BCD*10.3  Tax Reporting Expensed 5   
TXRECVB1RC  BCD*10.3  Tax Reporting Recoverable Amount 1   
TXRECVB2RC  BCD*10.3  Tax Reporting Recoverable Amount 2   
TXRECVB3RC  BCD*10.3  Tax Reporting Recoverable Amount 3   
TXRECVB4RC  BCD*10.3  Tax Reporting Recoverable Amount 4   
TXRECVB5RC  BCD*10.3  Tax Reporting Recoverable Amount 5   
TXALOCRC  BCD*10.3  Total Tax Reporting Allocated Amount   
TXTOTRC  BCD*10.3  Total Tax Reporting Amount   
FUNNETTAX  BCD*10.3  Functional Net of Tax   
FUNGRODIS  BCD*10.3  Functional Gross Distribution Amount   
TAXVERSION  Long  Tax Version   
TXCALCRMET  Integer  Tax Calculation Reporting Method  List: 2 entries
0=No
1=Yes
CODECURNRC  String*3  Tax Reporting Currency Code  Mask: %-3N
RATERC  BCD*8.7  Tax Reporting Rate   
RATETYPERC  String*2  Tax Reporting Rate Type  Mask: %-2N
RATEDATERC  Date  Tax Reporting Rate Date   
RATEOPRC  Integer  Tax Reporting Rate Operation  List: 3 entries
1=Multiply
2=Divide
0=Not Specified
EXPNSACNT1  String*45  Tax Expense Account 1  Mask: %-45C
EXPNSACNT2  String*45  Tax Expense Account 2  Mask: %-45C
EXPNSACNT3  String*45  Tax Expense Account 3  Mask: %-45C
EXPNSACNT4  String*45  Tax Expense Account 4  Mask: %-45C
EXPNSACNT5  String*45  Tax Expense Account 5  Mask: %-45C
RECBLACNT1  String*45  Tax Recoverable Account 1  Mask: %-45C
RECBLACNT2  String*45  Tax Recoverable Account 2  Mask: %-45C
RECBLACNT3  String*45  Tax Recoverable Account 3  Mask: %-45C
RECBLACNT4  String*45  Tax Recoverable Account 4  Mask: %-45C
RECBLACNT5  String*45  Tax Recoverable Account 5  Mask: %-45C
TAXRATE1  BCD*8.7  Tax Rate 1   
TAXRATE2  BCD*8.7  Tax Rate 2   
TAXRATE3  BCD*8.7  Tax Rate 3   
TAXRATE4  BCD*8.7  Tax Rate 4   
TAXRATE5  BCD*8.7  Tax Rate 5   

This page was generated on 2008-May-01

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