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 PSTSEQSEQUENCENOLINE

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