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

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