Table: Bank Entry Posting Journal

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

Keys: 1

Title  Flags  Fields

Posting Sequence/Bank Code  PSTSEQ, BANK, UNIQUE

Fields: 172

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   
RECPENT  BCD*10.3  Fiscal Entry Amount   
RECPENTREC  BCD*10.3  Reconciled Entry Amount   
CURFUNC  String*3  Functional Currency   
CURSTMT  String*3  Statement Currency   
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   
BASETAXRC1  BCD*10.3  Tax Base Retainage amount1   
BASETAXRC2  BCD*10.3  Tax Base Retainage amount2   
BASETAXRC3  BCD*10.3  Tax Base Retainage amount3   
BASETAXRC4  BCD*10.3  Tax Base Retainage amount4   
BASETAXRC5  BCD*10.3  Tax Base Retainage amount5   
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   
AMTINCLUDE  BCD*10.3  Total Included Amount   
AMTEXCLUDE  BCD*10.3  Total Excluded Amount   
AMTDIST  BCD*10.3  Tax Distribution amount   
AMTNETDIST  BCD*10.3  Tax Net Distribution 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   
TXALOCRC  BCD*10.3  Total Tax Reporting Allocated Amount   
TXEXPNSRC  BCD*10.3  Tax Reporting Expensed Amount   
TXRECVBRC  BCD*10.3  Tax Reporting Recoverable Amount   
TXTOTRC  BCD*10.3  Total Tax Reporting 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
TXAU1DESC  String*60  Tax Authority Description 1   
TXAU2DESC  String*60  Tax Authority Description 2   
TXAU3DESC  String*60  Tax Authority Description 3   
TXAU4DESC  String*60  Tax Authority Description 4   
TXAU5DESC  String*60  Tax Authority Description 5   
VCLS1DESC  String*60  Vendor Tax Class Description 1   
VCLS2DESC  String*60  Vendor Tax Class Description 2   
VCLS3DESC  String*60  Vendor Tax Class Description 3   
VCLS4DESC  String*60  Vendor Tax Class Description 4   
VCLS5DESC  String*60  Vendor Tax Class Description 5   
ICLS1DESC  String*60  Item Tax Class Description 1   
ICLS2DESC  String*60  Item Tax Class Description 2   
ICLS3DESC  String*60  Item Tax Class Description 3   
ICLS4DESC  String*60  Item Tax Class Description 4   
ICLS5DESC  String*60  Item Tax Class Description 5   
FUNTXAMT1  BCD*10.3  Functional Tax Amount 1   
FUNTXAMT2  BCD*10.3  Functional Tax Amount 2   
FUNTXAMT3  BCD*10.3  Functional Tax Amount 3   
FUNTXAMT4  BCD*10.3  Functional Tax Amount 4   
FUNTXAMT5  BCD*10.3  Functional Tax Amount 5   
FUNTXBSE1  BCD*10.3  Functional Tax Base Amount 1   
FUNTXBSE2  BCD*10.3  Functional Tax Base Amount 2   
FUNTXBSE3  BCD*10.3  Functional Tax Base Amount 3   
FUNTXBSE4  BCD*10.3  Functional Tax Base Amount 4   
FUNTXBSE5  BCD*10.3  Functional Tax Base Amount 5   
FUNNETTAX  BCD*10.3  Functional Net of Tax   
FUNGRODIS  BCD*10.3  Functional Gross Distribution Amount   
FUNAMTALOC  BCD*10.3  Functional Total Tax Allocated   
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   
FUNTXEXP1  BCD*10.3  Functional Expensed Amount 1   
FUNTXEXP2  BCD*10.3  Functional Expensed Amount 2   
FUNTXEXP3  BCD*10.3  Functional Expensed Amount 3   
FUNTXEXP4  BCD*10.3  Functional Expensed Amount 4   
FUNTXEXP5  BCD*10.3  Functional Expensed Amount 5   
FUNTXRCB1  BCD*10.3  Functional Recoverable Amount 1   
FUNTXRCB2  BCD*10.3  Functional Recoverable Amount 2   
FUNTXRCB3  BCD*10.3  Functional Recoverable Amount 3   
FUNTXRCB4  BCD*10.3  Functional Recoverable Amount 4   
FUNTXRCB5  BCD*10.3  Functional Recoverable Amount 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   
TXGRPDESC  String*60  Tax Group Description   
CURNRCDESC  String*60  Tax Reporting Currency Description   
RATERCDESC  String*60  Tax Reporting RateType Description   
EXPNSACNT1  String*45  Tax Expense Account 1   
EXPNSACNT2  String*45  Tax Expense Account 2   
EXPNSACNT3  String*45  Tax Expense Account 3   
EXPNSACNT4  String*45  Tax Expense Account 4   
EXPNSACNT5  String*45  Tax Expense Account 5   
RECBLACNT1  String*45  Tax Recoverable Account 1   
RECBLACNT2  String*45  Tax Recoverable Account 2   
RECBLACNT3  String*45  Tax Recoverable Account 3   
RECBLACNT4  String*45  Tax Recoverable Account 4   
RECBLACNT5  String*45  Tax Recoverable Account 5   

This page was generated on 2008-May-01

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