# 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 2009-Nov-19

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