Table: Bank Entries Journal Detail

Table: BKJENTD
View: BK0660
Record length: 3251
Flags: A R 

Keys: 1

Title  Flags  Fields

Bank Entry Detail  PSTSEQ, SEQUENCENO, LINE

Fields: 181

Field  Type  Title  Presentation 

PSTSEQ  BCD*5.0  Posting Sequence   
SEQUENCENO  Long  Sequence Number   
LINE  Long  Line Number   
AUDTDATE  Date     
AUDTTIME  Time     
AUDTUSER  String*8     
AUDTORG  String*6     
DISTCODE  String*6  Distribution Code  Mask: %-6N
REFERENCE  String*60  Reference   
COMMENT  String*60  Description   
AMOUNT  BCD*10.3  Amount   
SRCEAMT  BCD*10.3  Source Amount   
GLACCOUNT  String*45  G/L Account  Mask: %-45C
ENTRYTYPE  Integer  Entry Type   
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   
AMTALLOC1  BCD*10.3  Tax Allocated Amount 1   
AMTALLOC2  BCD*10.3  Tax Allocated Amount 2   
AMTALLOC3  BCD*10.3  Tax Allocated Amount 3   
AMTALLOC4  BCD*10.3  Tax Allocated Amount 4   
AMTALLOC5  BCD*10.3  Tax Allocated 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   
TXALLOC1RC  BCD*10.3  Tax Reporting Allocated Amount 1   
TXALLOC2RC  BCD*10.3  Tax Reporting Allocated Amount 2   
TXALLOC3RC  BCD*10.3  Tax Reporting Allocated Amount 3   
TXALLOC4RC  BCD*10.3  Tax Reporting Allocated Amount 4   
TXALLOC5RC  BCD*10.3  Tax Reporting Allocated 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   
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   
SRCECURN  String*3  Reserved   
POSTDATE  Date  Reserved   
RATE  BCD*8.7  Reserved   
RATEOP  Integer  Reserved   
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   
FUNTOTTAX  BCD*10.3  Functional Tax Total   
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   
FUNTXALOC1  BCD*10.3  Functional Allocated Amount 1   
FUNTXALOC2  BCD*10.3  Functional Allocated Amount 2   
FUNTXALOC3  BCD*10.3  Functional Allocated Amount 3   
FUNTXALOC4  BCD*10.3  Functional Allocated Amount 4   
FUNTXALOC5  BCD*10.3  Functional Allocated Amount 5   
FUNAMTALOC  BCD*10.3  Functional Total Tax Allocated   
ENTRYAMT  BCD*10.3  Statement Amount   
SRCEGROAMT  BCD*10.3  Gross Source Amount   
FUNCGROAMT  BCD*10.3  Gross Amount   
DISTCODED  String*60  Distribution Code Description   
GLACCOUNTD  String*60  G/L Account Description   
BANK  String*8  Bank   
LINEONE  Long  Line   
TXGRPDESC  String*60  Tax Group Description   
PROCESSCMD  Integer  Tax Process Command   
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   
CURNRCDESC  String*60  Tax Reporting Currency Description   
RATERCDESC  String*60  Tax Reporting RateType Description   
RATETYPE  String*2  Reserved   
RATEDATE  Date  Reserved   
RATESPREAD  BCD*8.7  Reserved   

This page was generated on 2009-Nov-19

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