View: Bank Entries Journal Detail

RotoID: BK0660
Table: BKJENTD
Protocol: Detail, Ordered revisions
DLL:BKJENTD

Compositions: 1

RotoID Tables Title DLL
BK0665 BKJENTH Bank Entries Journal Header BKJENTH

Keys: 1

Title Fields
Bank Entry Detail PSTSEQ, SEQUENCENO, LINE

Fields: 177

Field Index Type Title Attributes Presentation
PSTSEQ 1 BCD*5.0 Posting Sequence E A K R 
SEQUENCENO 2 Long Sequence Number E A K R 
LINE 3 Long Line Number E A K R 
DISTCODE 4 String*6 Distribution Code E A  Mask: %-6N
REFERENCE 5 String*60 Reference E A 
COMMENT 6 String*60 Description E A 
AMOUNT 7 BCD*10.3 Amount E A 
SRCEAMT 8 BCD*10.3 Source Amount E A 
GLACCOUNT 9 String*45 G/L Account E A  Mask: %-45C
ENTRYTYPE 10 Integer Entry Type E A 
BIGCOMMENT 11 String*250 Comments E A 
SWTAXBL 12 Integer Taxable E A  List:2 entries
0 = No
1 = Yes
TXAMTCALC 13 Integer Tax Amount Calculation E A  List:2 entries
0 = No
1 = Yes
CODETAXGRP 14 String*12 Tax Group E A  Mask: %-12N
TAXAUTH1 15 String*12 Tax Authority 1 E A  Mask: %-12N
TAXAUTH2 16 String*12 Tax Authority 2 E A  Mask: %-12N
TAXAUTH3 17 String*12 Tax Authority 3 E A  Mask: %-12N
TAXAUTH4 18 String*12 Tax Authority 4 E A  Mask: %-12N
TAXAUTH5 19 String*12 Tax Authority 5 E A  Mask: %-12N
TAXVCLSS1 20 Integer Tax Vendor Class 1 E A 
TAXVCLSS2 21 Integer Tax Vendor Class 2 E A 
TAXVCLSS3 22 Integer Tax Vendor Class 3 E A 
TAXVCLSS4 23 Integer Tax Vendor Class 4 E A 
TAXVCLSS5 24 Integer Tax Vendor Class 5 E A 
TAXICLSS1 25 Integer Tax Item Class 1 E A 
TAXICLSS2 26 Integer Tax Item Class 2 E A 
TAXICLSS3 27 Integer Tax Item Class 3 E A 
TAXICLSS4 28 Integer Tax Item Class 4 E A 
TAXICLSS5 29 Integer Tax Item Class 5 E A 
TAXINCL1 30 Integer Tax Include 1 E A  List:2 entries
0 = No
1 = Yes
TAXINCL2 31 Integer Tax Include 2 E A  List:2 entries
0 = No
1 = Yes
TAXINCL3 32 Integer Tax Include 3 E A  List:2 entries
0 = No
1 = Yes
TAXINCL4 33 Integer Tax Include 4 E A  List:2 entries
0 = No
1 = Yes
TAXINCL5 34 Integer Tax Include 5 E A  List:2 entries
0 = No
1 = Yes
BASETAX1 35 BCD*10.3 Tax Base Amount 1 E A 
BASETAX2 36 BCD*10.3 Tax Base Amount 2 E A 
BASETAX3 37 BCD*10.3 Tax Base Amount 3 E A 
BASETAX4 38 BCD*10.3 Tax Base Amount 4 E A 
BASETAX5 39 BCD*10.3 Tax Base Amount 5 E A 
TXCALCBASE 40 Integer Tax Base Calculation Method E A  List:2 entries
0 = No
1 = Yes
AMTTAX1 41 BCD*10.3 Tax Amount 1 E A 
AMTTAX2 42 BCD*10.3 Tax Amount 2 E A 
AMTTAX3 43 BCD*10.3 Tax Amount 3 E A 
AMTTAX4 44 BCD*10.3 Tax Amount 4 E A 
AMTTAX5 45 BCD*10.3 Tax Amount 5 E A 
AMTTXBL 46 BCD*10.3 Taxable AMount E A 
AMTNOTTXBL 47 BCD*10.3 Non Taxable Amount E A 
AMTTAXTOT 48 BCD*10.3 Tax Total E A 
AMTDOCTOT 49 BCD*10.3 Document Total Before Tax E A 
AMTNETTOT 50 BCD*10.3 Document Total Including Tax E A 
AMTDIST 51 BCD*10.3 Tax Distribution amount E A 
AMTINCLUDE 52 BCD*10.3 Total Included Amount E A 
AMTNETDIST 53 BCD*10.3 Tax Net Distribution Amount E A 
AMTEXCLUDE 54 BCD*10.3 Total Excluded Amount E A 
AMTGRODIST 55 BCD*10.3 Tax Gross Distribution Amount E A 
AMTEXPENS1 56 BCD*10.3 Tax Expense Amount 1 E A 
AMTEXPENS2 57 BCD*10.3 Tax Expense Amount 2 E A 
AMTEXPENS3 58 BCD*10.3 Tax Expense Amount 3 E A 
AMTEXPENS4 59 BCD*10.3 Tax Expense Amount 4 E A 
AMTEXPENS5 60 BCD*10.3 Tax Expense Amount 5 E A 
AMTRECVRB1 61 BCD*10.3 Tax Recoverable Amount 1 E A 
AMTRECVRB2 62 BCD*10.3 Tax Recoverable Amount 2 E A 
AMTRECVRB3 63 BCD*10.3 Tax Recoverable Amount 3 E A 
AMTRECVRB4 64 BCD*10.3 Tax Recoverable Amount 4 E A 
AMTRECVRB5 65 BCD*10.3 Tax Recoverable Amount 5 E A 
AMTALLOC1 66 BCD*10.3 Tax Allocated Amount 1 E A 
AMTALLOC2 67 BCD*10.3 Tax Allocated Amount 2 E A 
AMTALLOC3 68 BCD*10.3 Tax Allocated Amount 3 E A 
AMTALLOC4 69 BCD*10.3 Tax Allocated Amount 4 E A 
AMTALLOC5 70 BCD*10.3 Tax Allocated Amount 5 E A 
TOTAMTALOC 71 BCD*10.3 Total Tax Allocated Amount E A 
TXAMT1RC 72 BCD*10.3 Tax Reporting Amount 1 E A 
TXAMT2RC 73 BCD*10.3 Tax Reporting Amount 2 E A 
TXAMT3RC 74 BCD*10.3 Tax Reporting Amount 3 E A 
TXAMT4RC 75 BCD*10.3 Tax Reporting Amount 4 E A 
TXAMT5RC 76 BCD*10.3 Tax Reporting Amount 5 E A 
TXEXPNS1RC 77 BCD*10.3 Tax Reporting Expensed 1 E A 
TXEXPNS2RC 78 BCD*10.3 Tax Reporting Expensed 2 E A 
TXEXPNS3RC 79 BCD*10.3 Tax Reporting Expensed 3 E A 
TXEXPNS4RC 80 BCD*10.3 Tax Reporting Expensed 4 E A 
TXEXPNS5RC 81 BCD*10.3 Tax Reporting Expensed 5 E A 
TXRECVB1RC 82 BCD*10.3 Tax Reporting Recoverable Amount 1 E A 
TXRECVB2RC 83 BCD*10.3 Tax Reporting Recoverable Amount 2 E A 
TXRECVB3RC 84 BCD*10.3 Tax Reporting Recoverable Amount 3 E A 
TXRECVB4RC 85 BCD*10.3 Tax Reporting Recoverable Amount 4 E A 
TXRECVB5RC 86 BCD*10.3 Tax Reporting Recoverable Amount 5 E A 
TXALLOC1RC 87 BCD*10.3 Tax Reporting Allocated Amount 1 E A 
TXALLOC2RC 88 BCD*10.3 Tax Reporting Allocated Amount 2 E A 
TXALLOC3RC 89 BCD*10.3 Tax Reporting Allocated Amount 3 E A 
TXALLOC4RC 90 BCD*10.3 Tax Reporting Allocated Amount 4 E A 
TXALLOC5RC 91 BCD*10.3 Tax Reporting Allocated Amount 5 E A 
TXALOCRC 92 BCD*10.3 Total Tax Reporting Allocated Amount E A 
TXTOTRC 93 BCD*10.3 Total Tax Reporting Amount E A 
FUNNETTAX 94 BCD*10.3 Functional Net of Tax E A 
FUNGRODIS 95 BCD*10.3 Functional Gross Distribution Amount E A 
TAXVERSION 96 Long Tax Version E A 
TXCALCRMET 97 Integer Tax Calculation Reporting Method E A  List:2 entries
0 = No
1 = Yes
CODECURNRC 98 String*3 Tax Reporting Currency Code E A  Mask: %-3N
RATERC 99 BCD*8.7 Tax Reporting Rate E A 
RATETYPERC 100 String*2 Tax Reporting Rate Type E A  Mask: %-2N
RATEDATERC 101 Date Tax Reporting Rate Date E A 
RATEOPRC 102 Integer Tax Reporting Rate Operation E A 
EXPNSACNT1 103 String*45 Tax Expense Account 1 E A  Mask: %-45C
EXPNSACNT2 104 String*45 Tax Expense Account 2 E A  Mask: %-45C
EXPNSACNT3 105 String*45 Tax Expense Account 3 E A  Mask: %-45C
EXPNSACNT4 106 String*45 Tax Expense Account 4 E A  Mask: %-45C
EXPNSACNT5 107 String*45 Tax Expense Account 5 E A  Mask: %-45C
RECBLACNT1 108 String*45 Tax Recoverable Account 1 E A  Mask: %-45C
RECBLACNT2 109 String*45 Tax Recoverable Account 2 E A  Mask: %-45C
RECBLACNT3 110 String*45 Tax Recoverable Account 3 E A  Mask: %-45C
RECBLACNT4 111 String*45 Tax Recoverable Account 4 E A  Mask: %-45C
RECBLACNT5 112 String*45 Tax Recoverable Account 5 E A  Mask: %-45C
TAXRATE1 113 BCD*8.7 Tax Rate 1 E A 
TAXRATE2 114 BCD*8.7 Tax Rate 2 E A 
TAXRATE3 115 BCD*8.7 Tax Rate 3 E A 
TAXRATE4 116 BCD*8.7 Tax Rate 4 E A 
TAXRATE5 117 BCD*8.7 Tax Rate 5 E A 
SRCECURN 118 String*3 Reserved E A 
POSTDATE 119 Date Reserved E A 
RATE 120 BCD*8.7 Reserved E A 
RATEOP 121 Integer Reserved E A 
FUNTXAMT1 122 BCD*10.3 Functional Tax Amount 1 E A 
FUNTXAMT2 123 BCD*10.3 Functional Tax Amount 2 E A 
FUNTXAMT3 124 BCD*10.3 Functional Tax Amount 3 E A 
FUNTXAMT4 125 BCD*10.3 Functional Tax Amount 4 E A 
FUNTXAMT5 126 BCD*10.3 Functional Tax Amount 5 E A 
FUNTXBSE1 127 BCD*10.3 Functional Tax Base Amount 1 E A 
FUNTXBSE2 128 BCD*10.3 Functional Tax Base Amount 2 E A 
FUNTXBSE3 129 BCD*10.3 Functional Tax Base Amount 3 E A 
FUNTXBSE4 130 BCD*10.3 Functional Tax Base Amount 4 E A 
FUNTXBSE5 131 BCD*10.3 Functional Tax Base Amount 5 E A 
FUNTOTTAX 132 BCD*10.3 Functional Tax Total E A 
FUNTXEXP1 133 BCD*10.3 Functional Expensed Amount 1 E A 
FUNTXEXP2 134 BCD*10.3 Functional Expensed Amount 2 E A 
FUNTXEXP3 135 BCD*10.3 Functional Expensed Amount 3 E A 
FUNTXEXP4 136 BCD*10.3 Functional Expensed Amount 4 E A 
FUNTXEXP5 137 BCD*10.3 Functional Expensed Amount 5 E A 
FUNTXRCB1 138 BCD*10.3 Functional Recoverable Amount 1 E A 
FUNTXRCB2 139 BCD*10.3 Functional Recoverable Amount 2 E A 
FUNTXRCB3 140 BCD*10.3 Functional Recoverable Amount 3 E A 
FUNTXRCB4 141 BCD*10.3 Functional Recoverable Amount 4 E A 
FUNTXRCB5 142 BCD*10.3 Functional Recoverable Amount 5 E A 
FUNTXALOC1 143 BCD*10.3 Functional Allocated Amount 1 E A 
FUNTXALOC2 144 BCD*10.3 Functional Allocated Amount 2 E A 
FUNTXALOC3 145 BCD*10.3 Functional Allocated Amount 3 E A 
FUNTXALOC4 146 BCD*10.3 Functional Allocated Amount 4 E A 
FUNTXALOC5 147 BCD*10.3 Functional Allocated Amount 5 E A 
FUNAMTALOC 148 BCD*10.3 Functional Total Tax Allocated E A 
ENTRYAMT 149 BCD*10.3 Statement Amount E A 
SRCEGROAMT 150 BCD*10.3 Gross Source Amount E A 
FUNCGROAMT 151 BCD*10.3 Gross Amount E A 
DISTCODED 152 String*60 Distribution Code Description E A 
GLACCOUNTD 153 String*60 G/L Account Description E A 
BANK 154 String*8 Bank E A 
LINEONE 155 Long Line E A 
TXGRPDESC 156 String*60 Tax Group Description E A 
PROCESSCMD 157 Integer Tax Process Command E A 
TXAU1DESC 158 String*60 Tax Authority Description 1 E A 
TXAU2DESC 159 String*60 Tax Authority Description 2 E A 
TXAU3DESC 160 String*60 Tax Authority Description 3 E A 
TXAU4DESC 161 String*60 Tax Authority Description 4 E A 
TXAU5DESC 162 String*60 Tax Authority Description 5 E A 
VCLS1DESC 163 String*60 Vendor Tax Class Description 1 E A 
VCLS2DESC 164 String*60 Vendor Tax Class Description 2 E A 
VCLS3DESC 165 String*60 Vendor Tax Class Description 3 E A 
VCLS4DESC 166 String*60 Vendor Tax Class Description 4 E A 
VCLS5DESC 167 String*60 Vendor Tax Class Description 5 E A 
ICLS1DESC 168 String*60 Item Tax Class Description 1 E A 
ICLS2DESC 169 String*60 Item Tax Class Description 2 E A 
ICLS3DESC 170 String*60 Item Tax Class Description 3 E A 
ICLS4DESC 171 String*60 Item Tax Class Description 4 E A 
ICLS5DESC 172 String*60 Item Tax Class Description 5 E A 
CURNRCDESC 173 String*60 Tax Reporting Currency Description E A 
RATERCDESC 174 String*60 Tax Reporting RateType Description E A 
RATETYPE 175 String*2 Reserved E A 
RATEDATE 176 Date Reserved E A 
RATESPREAD 177 BCD*8.7 Reserved E A 

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