View: Bank Entries

RotoID: BK0460
Table: BKENTD
Protocol: Detail, Sequenced revisions, Key auto generate
DLL:BKENTD

Compositions: 3

RotoID Tables Title DLL
BK0450 BKENTH Bank Entries Header BKENTH
BK0003 BKTT Bank Distribution Codes BKTT
CS0004 CSCRT Rate Types CSCRT

Keys: 1

Title Fields
Bank Entry Detail SEQUENCENO, LINE

Fields: 178

Field Index Type Title Attributes Presentation
SEQUENCENO 1 Long Sequence Number E A K R 
LINE 2 Long Line Number E A K R 
BANK 3 String*8 Bank A 
POSTDATE 4 Date Reserved E A C 
DISTCODE 5 String*6 Distribution Code E A  Mask: %-6N
REFERENCE 6 String*60 Reference E A 
COMMENT 7 String*60 Description E A 
AMOUNT 8 BCD*10.3 Amount A C 
SRCEAMT 9 BCD*10.3 Source Amount E A 
RATETYPE 10 String*2 Reserved E A C 
SRCECURN 11 String*3 Reserved E A C 
RATEDATE 12 Date Reserved E A C 
RATE 13 BCD*8.7 Reserved E A C 
RATESPREAD 14 BCD*8.7 Reserved E A C 
RATEOP 15 Integer Reserved E A C 
GLACCOUNT 16 String*45 G/L Account E A X  Mask: %-45C
ENTRYTYPE 17 Integer Entry Type E A P  List:4 entries
0 = User-entered
10 = Unmatched OFX
19 = Unmatched OFX correction
20 = Unmatched OFX error
BIGCOMMENT 18 String*250 Comments E A 
ENTRYAMT 26 BCD*10.3 Statement Amount A 
SRCEGROAMT 27 BCD*10.3 Gross Source Amount A 
FUNCGROAMT 28 BCD*10.3 Gross Amount A 
DISTCODED 29 String*60 Distribution Code Description A 
GLACCOUNTD 30 String*60 G/L Account Description A 
LINEONE 31 Long Line A 
SETDEFAULT 32 Integer Set Default Setup Values E A C 
CREATEDIST 33 Integer Call for Create Distribution E A C 
SWTAXBL 50 Integer Taxable E A C  List:2 entries
0 = No
1 = Yes
TXAMTCALC 51 Integer Tax Amount Calculation E A  List:2 entries
0 = No
1 = Yes
CODETAXGRP 52 String*12 Tax Group E A  Mask: %-12N
TAXAUTH1 53 String*12 Tax Authority 1 E A C  Mask: %-12N
TAXAUTH2 54 String*12 Tax Authority 2 E A C  Mask: %-12N
TAXAUTH3 55 String*12 Tax Authority 3 E A C  Mask: %-12N
TAXAUTH4 56 String*12 Tax Authority 4 E A C  Mask: %-12N
TAXAUTH5 57 String*12 Tax Authority 5 E A C  Mask: %-12N
TAXVCLSS1 58 Integer Tax Vendor Class 1 E A 
TAXVCLSS2 59 Integer Tax Vendor Class 2 E A 
TAXVCLSS3 60 Integer Tax Vendor Class 3 E A 
TAXVCLSS4 61 Integer Tax Vendor Class 4 E A 
TAXVCLSS5 62 Integer Tax Vendor Class 5 E A 
TAXICLSS1 63 Integer Tax Item Class 1 E A 
TAXICLSS2 64 Integer Tax Item Class 2 E A 
TAXICLSS3 65 Integer Tax Item Class 3 E A 
TAXICLSS4 66 Integer Tax Item Class 4 E A 
TAXICLSS5 67 Integer Tax Item Class 5 E A 
TAXINCL1 68 Integer Tax Include 1 E A  List:2 entries
0 = No
1 = Yes
TAXINCL2 69 Integer Tax Include 2 E A  List:2 entries
0 = No
1 = Yes
TAXINCL3 70 Integer Tax Include 3 E A  List:2 entries
0 = No
1 = Yes
TAXINCL4 71 Integer Tax Include 4 E A  List:2 entries
0 = No
1 = Yes
TAXINCL5 72 Integer Tax Include 5 E A  List:2 entries
0 = No
1 = Yes
BASETAX1 73 BCD*10.3 Tax Base Amount 1 E A 
BASETAX2 74 BCD*10.3 Tax Base Amount 2 E A 
BASETAX3 75 BCD*10.3 Tax Base Amount 3 E A 
BASETAX4 76 BCD*10.3 Tax Base Amount 4 E A 
BASETAX5 77 BCD*10.3 Tax Base Amount 5 E A 
TXCALCBASE 78 Integer Tax Base Calculation Method E A  List:2 entries
0 = No
1 = Yes
AMTTAX1 79 BCD*10.3 Tax Amount 1 E A 
AMTTAX2 80 BCD*10.3 Tax Amount 2 E A 
AMTTAX3 81 BCD*10.3 Tax Amount 3 E A 
AMTTAX4 82 BCD*10.3 Tax Amount 4 E A 
AMTTAX5 83 BCD*10.3 Tax Amount 5 E A 
AMTTXBL 84 BCD*10.3 Taxable AMount E A C 
AMTNOTTXBL 85 BCD*10.3 Non Taxable Amount E A C 
AMTTAXTOT 86 BCD*10.3 Tax Total E A C 
AMTDOCTOT 87 BCD*10.3 Document Total Before Tax E A C 
AMTNETTOT 88 BCD*10.3 Document Total Including Tax E A C 
AMTDIST 89 BCD*10.3 Tax Distribution amount E A C 
AMTINCLUDE 90 BCD*10.3 Total Included Amount E A C 
AMTNETDIST 91 BCD*10.3 Tax Net Distribution Amount E A C 
AMTEXCLUDE 92 BCD*10.3 Total Excluded Amount E A C 
AMTGRODIST 93 BCD*10.3 Tax Gross Distribution Amount E A C 
AMTEXPENS1 94 BCD*10.3 Tax Expense Amount 1 E A C 
AMTEXPENS2 95 BCD*10.3 Tax Expense Amount 2 E A C 
AMTEXPENS3 96 BCD*10.3 Tax Expense Amount 3 E A C 
AMTEXPENS4 97 BCD*10.3 Tax Expense Amount 4 E A C 
AMTEXPENS5 98 BCD*10.3 Tax Expense Amount 5 E A C 
AMTRECVRB1 99 BCD*10.3 Tax Recoverable Amount 1 E A C 
AMTRECVRB2 100 BCD*10.3 Tax Recoverable Amount 2 E A C 
AMTRECVRB3 101 BCD*10.3 Tax Recoverable Amount 3 E A C 
AMTRECVRB4 102 BCD*10.3 Tax Recoverable Amount 4 E A C 
AMTRECVRB5 103 BCD*10.3 Tax Recoverable Amount 5 E A C 
AMTALLOC1 104 BCD*10.3 Tax Allocated Amount 1 E A C 
AMTALLOC2 105 BCD*10.3 Tax Allocated Amount 2 E A C 
AMTALLOC3 106 BCD*10.3 Tax Allocated Amount 3 E A C 
AMTALLOC4 107 BCD*10.3 Tax Allocated Amount 4 E A C 
AMTALLOC5 108 BCD*10.3 Tax Allocated Amount 5 E A C 
TOTAMTALOC 109 BCD*10.3 Total Tax Allocated Amount E A C 
TXAMT1RC 110 BCD*10.3 Tax Reporting Amount 1 E A 
TXAMT2RC 111 BCD*10.3 Tax Reporting Amount 2 E A 
TXAMT3RC 112 BCD*10.3 Tax Reporting Amount 3 E A 
TXAMT4RC 113 BCD*10.3 Tax Reporting Amount 4 E A 
TXAMT5RC 114 BCD*10.3 Tax Reporting Amount 5 E A 
TXEXPNS1RC 115 BCD*10.3 Tax Reporting Expensed 1 E A C 
TXEXPNS2RC 116 BCD*10.3 Tax Reporting Expensed 2 E A C 
TXEXPNS3RC 117 BCD*10.3 Tax Reporting Expensed 3 E A C 
TXEXPNS4RC 118 BCD*10.3 Tax Reporting Expensed 4 E A C 
TXEXPNS5RC 119 BCD*10.3 Tax Reporting Expensed 5 E A C 
TXRECVB1RC 120 BCD*10.3 Tax Reporting Recoverable Amount 1 E A C 
TXRECVB2RC 121 BCD*10.3 Tax Reporting Recoverable Amount 2 E A C 
TXRECVB3RC 122 BCD*10.3 Tax Reporting Recoverable Amount 3 E A C 
TXRECVB4RC 123 BCD*10.3 Tax Reporting Recoverable Amount 4 E A C 
TXRECVB5RC 124 BCD*10.3 Tax Reporting Recoverable Amount 5 E A C 
TXALLOC1RC 125 BCD*10.3 Tax Reporting Allocated Amount 1 E A C 
TXALLOC2RC 126 BCD*10.3 Tax Reporting Allocated Amount 2 E A C 
TXALLOC3RC 127 BCD*10.3 Tax Reporting Allocated Amount 3 E A C 
TXALLOC4RC 128 BCD*10.3 Tax Reporting Allocated Amount 4 E A C 
TXALLOC5RC 129 BCD*10.3 Tax Reporting Allocated Amount 5 E A C 
TXALOCRC 130 BCD*10.3 Total Tax Reporting Allocated Amount E A C 
TXTOTRC 131 BCD*10.3 Total Tax Reporting Amount E A C 
FUNNETTAX 132 BCD*10.3 Functional Net of Tax E A C 
FUNGRODIS 133 BCD*10.3 Functional Gross Distribution Amount E A C 
TAXVERSION 134 Long Tax Version E A C 
TXCALCRMET 135 Integer Tax Calculation Reporting Method E A  List:2 entries
0 = No
1 = Yes
CODECURNRC 136 String*3 Tax Reporting Currency Code E A  Mask: %-3N
RATERC 137 BCD*8.7 Tax Reporting Rate E A 
RATETYPERC 138 String*2 Tax Reporting Rate Type E A  Mask: %-2N
RATEDATERC 139 Date Tax Reporting Rate Date E A 
RATEOPRC 140 Integer Tax Reporting Rate Operation E A C  List:3 entries
1 = Multiply
2 = Divide
0 = Not Specified
EXPNSACNT1 141 String*45 Tax Expense Account 1 E A X  Mask: %-45C
EXPNSACNT2 142 String*45 Tax Expense Account 2 E A X  Mask: %-45C
EXPNSACNT3 143 String*45 Tax Expense Account 3 E A X  Mask: %-45C
EXPNSACNT4 144 String*45 Tax Expense Account 4 E A X  Mask: %-45C
EXPNSACNT5 145 String*45 Tax Expense Account 5 E A X  Mask: %-45C
RECBLACNT1 146 String*45 Tax Recoverable Account 1 E A X  Mask: %-45C
RECBLACNT2 147 String*45 Tax Recoverable Account 2 E A X  Mask: %-45C
RECBLACNT3 148 String*45 Tax Recoverable Account 3 E A X  Mask: %-45C
RECBLACNT4 149 String*45 Tax Recoverable Account 4 E A X  Mask: %-45C
RECBLACNT5 150 String*45 Tax Recoverable Account 5 E A X  Mask: %-45C
TAXRATE1 151 BCD*8.7 Tax Rate 1 E A 
TAXRATE2 152 BCD*8.7 Tax Rate 2 E A 
TAXRATE3 153 BCD*8.7 Tax Rate 3 E A 
TAXRATE4 154 BCD*8.7 Tax Rate 4 E A 
TAXRATE5 155 BCD*8.7 Tax Rate 5 E A 
TXGRPDESC 200 String*60 Tax Group Description E A C 
PROCESSCMD 201 Integer Tax Process Command E A X  List:2 entries
0 = Calculate Taxes
1 = Derive Tax Reporting Exchange Rate
TXAU1DESC 202 String*60 Tax Authority Description 1 E A C 
TXAU2DESC 203 String*60 Tax Authority Description 2 E A C 
TXAU3DESC 204 String*60 Tax Authority Description 3 E A C 
TXAU4DESC 205 String*60 Tax Authority Description 4 E A C 
TXAU5DESC 206 String*60 Tax Authority Description 5 E A C 
VCLS1DESC 207 String*60 Vendor Tax Class Description 1 E A C 
VCLS2DESC 208 String*60 Vendor Tax Class Description 2 E A C 
VCLS3DESC 209 String*60 Vendor Tax Class Description 3 E A C 
VCLS4DESC 210 String*60 Vendor Tax Class Description 4 E A C 
VCLS5DESC 211 String*60 Vendor Tax Class Description 5 E A C 
ICLS1DESC 212 String*60 Item Tax Class Description 1 E A C 
ICLS2DESC 213 String*60 Item Tax Class Description 2 E A C 
ICLS3DESC 214 String*60 Item Tax Class Description 3 E A C 
ICLS4DESC 215 String*60 Item Tax Class Description 4 E A C 
ICLS5DESC 216 String*60 Item Tax Class Description 5 E A C 
FUNTXAMT1 217 BCD*10.3 Functional Tax Amount 1 E A C 
FUNTXAMT2 218 BCD*10.3 Functional Tax Amount 2 E A C 
FUNTXAMT3 219 BCD*10.3 Functional Tax Amount 3 E A C 
FUNTXAMT4 220 BCD*10.3 Functional Tax Amount 4 E A C 
FUNTXAMT5 221 BCD*10.3 Functional Tax Amount 5 E A C 
FUNTXBSE1 222 BCD*10.3 Functional Tax Base Amount 1 E A C 
FUNTXBSE2 223 BCD*10.3 Functional Tax Base Amount 2 E A C 
FUNTXBSE3 224 BCD*10.3 Functional Tax Base Amount 3 E A C 
FUNTXBSE4 225 BCD*10.3 Functional Tax Base Amount 4 E A C 
FUNTXBSE5 226 BCD*10.3 Functional Tax Base Amount 5 E A C 
FUNTOTTAX 227 BCD*10.3 Functional Tax Total E A C 
FUNTXEXP1 228 BCD*10.3 Functional Expensed Amount 1 E A C 
FUNTXEXP2 229 BCD*10.3 Functional Expensed Amount 2 E A C 
FUNTXEXP3 230 BCD*10.3 Functional Expensed Amount 3 E A C 
FUNTXEXP4 231 BCD*10.3 Functional Expensed Amount 4 E A C 
FUNTXEXP5 232 BCD*10.3 Functional Expensed Amount 5 E A C 
FUNTXRCB1 233 BCD*10.3 Functional Recoverable Amount 1 E A C 
FUNTXRCB2 234 BCD*10.3 Functional Recoverable Amount 2 E A C 
FUNTXRCB3 235 BCD*10.3 Functional Recoverable Amount 3 E A C 
FUNTXRCB4 236 BCD*10.3 Functional Recoverable Amount 4 E A C 
FUNTXRCB5 237 BCD*10.3 Functional Recoverable Amount 5 E A C 
FUNTXALOC1 238 BCD*10.3 Functional Allocated Amount 1 E A C 
FUNTXALOC2 239 BCD*10.3 Functional Allocated Amount 2 E A C 
FUNTXALOC3 240 BCD*10.3 Functional Allocated Amount 3 E A C 
FUNTXALOC4 241 BCD*10.3 Functional Allocated Amount 4 E A C 
FUNTXALOC5 242 BCD*10.3 Functional Allocated Amount 5 E A C 
FUNAMTALOC 243 BCD*10.3 Functional Total Tax Allocated E A C 
CURNRCDESC 244 String*60 Tax Reporting Currency Description E A C 
RATERCDESC 245 String*60 Tax Reporting RateType Description E A C 

This page was generated on 2021-Nov-24

© 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).