Table: Bank Entries

Table: BKENTD
View: BK0460
Record Length: 1987

Flags: A R 

Keys: 1

Title Flags Fields
Bank Entry Detail SEQUENCENO, LINE

Fields: 151

Field Type Title Presentation
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 List:4 entries
0 = User-entered
10 = Unmatched OFX
19 = Unmatched OFX correction
20 = Unmatched OFX error
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 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
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

This page was generated on 2022-Aug-18

© 2021 Sage Software, Inc. All rights reserved. Reproduction of part or all of the contents in any form is prohibited unless for personal use. None of the content of this article may be copied or otherwise incorporated into any other document, publication or other work in any form (whether written, electronic or other format).

Sage Software, Inc. makes no warranties, representations or undertakings about any of the content of articles (including, without limitation, any as to the quality, accuracy, completeness or fitness for any particular purpose of such content).