# View: Bank Entry Posting Journal

RotoID: BK0017
Table: BKJENT
Protocol: Detail, Sequenced revisions, Key auto generate
DLL: BKJENT

## Compositions: 1

RotoID | Tables | Title | DLL
--- | --- | --- | ---
BK0011 | BKJRNL | Bank Posting Journal | BKJRNL

## Keys: 1

Title | Fields
--- | ---
Posting Sequence/Bank Code | PSTSEQ, BANK, UNIQUE

## Fields: 168

Field | Index | Type | Title | Attributes | Presentation
--- | --- | --- | --- | --- | ---
PSTSEQ | 1 | BCD*5.0 | Posting Sequence | E A K R |
BANK | 2 | String*8 | Bank Code | E A K R | Mask: %-8N
UNIQUE | 3 | Long | Entry Uniquifier | E A K R |
DATE | 4 | Date | Entry Date | E A |
TYPE | 5 | String*6 | Transaction Type | E A | Mask: %-6N
REFERENCE | 6 | String*60 | Reference | E A |
COMMENT | 7 | String*60 | Comment | E A |
AMOUNT | 8 | BCD*10.3 | Amount | E A |
SRCEAMT | 9 | BCD*10.3 | Source Amount | E A |
RATETYPE | 10 | String*2 | Exchange Rate Type | E A | Mask: %-2N
SRCECURN | 11 | String*3 | Payment Currency | E A | Mask: %-3N
RATEDATE | 12 | Date | Exchange Rate Date | E A |
RATE | 13 | BCD*8.7 | Exchange Rate | E A |
RATESPREAD | 14 | BCD*8.7 | Rate Spread | E A |
RATEOP | 15 | Integer | Rate Operation | E A | List: 3 entries
1 | = | Multiply
2 | = | Divide
0 | = | Not Specified
SRCEAMTCR | 16 | BCD*10.3 | Source Credit Amount | E A |
SRCEAMTDR | 17 | BCD*10.3 | Source Debit Amount | E A |
AMTCR | 18 | BCD*10.3 | Credit Amount | E A |
AMTDR | 19 | BCD*10.3 | Debit Amount | E A |
ENTRYAMT | 20 | BCD*10.3 | Statement Amount | E A |
IDACCT | 21 | String*45 | G/L Account | E A | Mask: %-45C
IDACCTOVR | 22 | Boolean | Account Number Override | E A |
ENTRYTYPE | 23 | Integer | Entry Type | E A | List: 4 entries
0 | = | User-entered
10 | = | Unmatched OFX
19 | = | Unmatched OFX correction
20 | = | Unmatched OFX error
RECYEAR | 24 | String*4 | Reconciliation Fiscal Year | E A | Mask: %04D
RECPERIOD | 25 | Integer | Reconciliation Fiscal Period | E A | List: 14 entries
0 | = |
1 | = | 1
2 | = | 2
3 | = | 3
4 | = | 4
5 | = | 5
6 | = | 6
7 | = | 7
8 | = | 8
9 | = | 9
10 | = | 10
11 | = | 11
12 | = | 12
13 | = | 13
RECONCILED | 26 | Boolean | Reconciled | E A |
BIGCOMMENT | 27 | String*250 | Comments | E A |
RECPENT | 28 | BCD*10.3 | Fiscal Entry Amount | E A |
RECPENTREC | 29 | BCD*10.3 | Reconciled Entry Amount | E A |
CURFUNC | 30 | String*3 | Functional Currency | E A |
CURSTMT | 31 | String*3 | Statement Currency | E A |
SWTAXBL | 32 | Integer | Taxable | E A | List: 2 entries
0 | = | No
1 | = | Yes
TXAMTCALC | 33 | Integer | Tax Amount Calculation | E A | List: 2 entries
0 | = | No
1 | = | Yes
CODETAXGRP | 34 | String*12 | Tax Group | E A | Mask: %-12N
TAXAUTH1 | 35 | String*12 | Tax Authority 1 | E A | Mask: %-12N
TAXAUTH2 | 36 | String*12 | Tax Authority 2 | E A | Mask: %-12N
TAXAUTH3 | 37 | String*12 | Tax Authority 3 | E A | Mask: %-12N
TAXAUTH4 | 38 | String*12 | Tax Authority 4 | E A | Mask: %-12N
TAXAUTH5 | 39 | String*12 | Tax Authority 5 | E A | Mask: %-12N
TAXVCLSS1 | 40 | Integer | Tax Vendor Class 1 | E A |
TAXVCLSS2 | 41 | Integer | Tax Vendor Class 2 | E A |
TAXVCLSS3 | 42 | Integer | Tax Vendor Class 3 | E A |
TAXVCLSS4 | 43 | Integer | Tax Vendor Class 4 | E A |
TAXVCLSS5 | 44 | Integer | Tax Vendor Class 5 | E A |
TAXICLSS1 | 45 | Integer | Tax Item Class 1 | E A |
TAXICLSS2 | 46 | Integer | Tax Item Class 2 | E A |
TAXICLSS3 | 47 | Integer | Tax Item Class 3 | E A |
TAXICLSS4 | 48 | Integer | Tax Item Class 4 | E A |
TAXICLSS5 | 49 | Integer | Tax Item Class 5 | E A |
TAXINCL1 | 50 | Integer | Tax Include 1 | E A | List: 2 entries
0 | = | No
1 | = | Yes
TAXINCL2 | 51 | Integer | Tax Include 2 | E A | List: 2 entries
0 | = | No
1 | = | Yes
TAXINCL3 | 52 | Integer | Tax Include 3 | E A | List: 2 entries
0 | = | No
1 | = | Yes
TAXINCL4 | 53 | Integer | Tax Include 4 | E A | List: 2 entries
0 | = | No
1 | = | Yes
TAXINCL5 | 54 | Integer | Tax Include 5 | E A | List: 2 entries
0 | = | No
1 | = | Yes
BASETAX1 | 55 | BCD*10.3 | Tax Base Amount 1 | E A |
BASETAX2 | 56 | BCD*10.3 | Tax Base Amount 2 | E A |
BASETAX3 | 57 | BCD*10.3 | Tax Base Amount 3 | E A |
BASETAX4 | 58 | BCD*10.3 | Tax Base Amount 4 | E A |
BASETAX5 | 59 | BCD*10.3 | Tax Base Amount 5 | E A |
BASETAXRC1 | 60 | BCD*10.3 | Tax Base Retainage amount1 | E A |
BASETAXRC2 | 61 | BCD*10.3 | Tax Base Retainage amount2 | E A |
BASETAXRC3 | 62 | BCD*10.3 | Tax Base Retainage amount3 | E A |
BASETAXRC4 | 63 | BCD*10.3 | Tax Base Retainage amount4 | E A |
BASETAXRC5 | 64 | BCD*10.3 | Tax Base Retainage amount5 | E A |
TXCALCBASE | 65 | Integer | Tax Base Calculation Method | E A | List: 2 entries
0 | = | No
1 | = | Yes
AMTTAX1 | 66 | BCD*10.3 | Tax Amount 1 | E A |
AMTTAX2 | 67 | BCD*10.3 | Tax Amount 2 | E A |
AMTTAX3 | 68 | BCD*10.3 | Tax Amount 3 | E A |
AMTTAX4 | 69 | BCD*10.3 | Tax Amount 4 | E A |
AMTTAX5 | 70 | BCD*10.3 | Tax Amount 5 | E A |
AMTTXBL | 71 | BCD*10.3 | Taxable Amount | E A |
AMTNOTTXBL | 72 | BCD*10.3 | Non Taxable Amount | E A |
AMTTAXTOT | 73 | BCD*10.3 | Tax Total | E A |
AMTDOCTOT | 74 | BCD*10.3 | Document Total Before Tax | E A |
AMTNETTOT | 75 | BCD*10.3 | Document Total Including Tax | E A |
AMTINCLUDE | 76 | BCD*10.3 | Total Included Amount | E A |
AMTEXCLUDE | 77 | BCD*10.3 | Total Excluded Amount | E A |
AMTDIST | 78 | BCD*10.3 | Tax Distribution amount | E A |
AMTNETDIST | 79 | BCD*10.3 | Tax Net Distribution Amount | E A |
AMTGRODIST | 80 | BCD*10.3 | Tax Gross Distribution Amount | E A |
AMTEXPENS1 | 81 | BCD*10.3 | Tax Expense Amount 1 | E A |
AMTEXPENS2 | 82 | BCD*10.3 | Tax Expense Amount 2 | E A |
AMTEXPENS3 | 83 | BCD*10.3 | Tax Expense Amount 3 | E A |
AMTEXPENS4 | 84 | BCD*10.3 | Tax Expense Amount 4 | E A |
AMTEXPENS5 | 85 | BCD*10.3 | Tax Expense Amount 5 | E A |
AMTRECVRB1 | 86 | BCD*10.3 | Tax Recoverable Amount 1 | E A |
AMTRECVRB2 | 87 | BCD*10.3 | Tax Recoverable Amount 2 | E A |
AMTRECVRB3 | 88 | BCD*10.3 | Tax Recoverable Amount 3 | E A |
AMTRECVRB4 | 89 | BCD*10.3 | Tax Recoverable Amount 4 | E A |
AMTRECVRB5 | 90 | BCD*10.3 | Tax Recoverable Amount 5 | E A |
TOTAMTALOC | 91 | BCD*10.3 | Total Tax Allocated Amount | E A |
TXAMT1RC | 92 | BCD*10.3 | Tax Reporting Amount 1 | E A |
TXAMT2RC | 93 | BCD*10.3 | Tax Reporting Amount 2 | E A |
TXAMT3RC | 94 | BCD*10.3 | Tax Reporting Amount 3 | E A |
TXAMT4RC | 95 | BCD*10.3 | Tax Reporting Amount 4 | E A |
TXAMT5RC | 96 | BCD*10.3 | Tax Reporting Amount 5 | E A |
TXALOCRC | 97 | BCD*10.3 | Total Tax Reporting Allocated Amount | E A |
TXEXPNSRC | 98 | BCD*10.3 | Tax Reporting Expensed Amount | E A |
TXRECVBRC | 99 | BCD*10.3 | Tax Reporting Recoverable Amount | E A |
TXTOTRC | 100 | BCD*10.3 | Total Tax Reporting Amount | E A |
TAXVERSION | 101 | Long | Tax Version | E A |
TXCALCRMET | 102 | Integer | Tax Calculation Reporting Method | E A | List: 2 entries
0 | = | No
1 | = | Yes
CODECURNRC | 103 | String*3 | Tax Reporting Currency Code | E A | Mask: %-3N
RATERC | 104 | BCD*8.7 | Tax Reporting Rate | E A |
RATETYPERC | 105 | String*2 | Tax Reporting Rate Type | E A | Mask: %-2N
RATEDATERC | 106 | Date | Tax Reporting Rate Date | E A |
RATEOPRC | 107 | Integer | Tax Reporting Rate Operation | E A | List: 3 entries
1 | = | Multiply
2 | = | Divide
0 | = | Not Specified
TXAU1DESC | 108 | String*60 | Tax Authority Description 1 | E A |
TXAU2DESC | 109 | String*60 | Tax Authority Description 2 | E A |
TXAU3DESC | 110 | String*60 | Tax Authority Description 3 | E A |
TXAU4DESC | 111 | String*60 | Tax Authority Description 4 | E A |
TXAU5DESC | 112 | String*60 | Tax Authority Description 5 | E A |
VCLS1DESC | 113 | String*60 | Vendor Tax Class Description 1 | E A |
VCLS2DESC | 114 | String*60 | Vendor Tax Class Description 2 | E A |
VCLS3DESC | 115 | String*60 | Vendor Tax Class Description 3 | E A |
VCLS4DESC | 116 | String*60 | Vendor Tax Class Description 4 | E A |
VCLS5DESC | 117 | String*60 | Vendor Tax Class Description 5 | E A |
ICLS1DESC | 118 | String*60 | Item Tax Class Description 1 | E A |
ICLS2DESC | 119 | String*60 | Item Tax Class Description 2 | E A |
ICLS3DESC | 120 | String*60 | Item Tax Class Description 3 | E A |
ICLS4DESC | 121 | String*60 | Item Tax Class Description 4 | E A |
ICLS5DESC | 122 | String*60 | Item Tax Class Description 5 | E A |
FUNTXAMT1 | 123 | BCD*10.3 | Functional Tax Amount 1 | E A |
FUNTXAMT2 | 124 | BCD*10.3 | Functional Tax Amount 2 | E A |
FUNTXAMT3 | 125 | BCD*10.3 | Functional Tax Amount 3 | E A |
FUNTXAMT4 | 126 | BCD*10.3 | Functional Tax Amount 4 | E A |
FUNTXAMT5 | 127 | BCD*10.3 | Functional Tax Amount 5 | E A |
FUNTXBSE1 | 128 | BCD*10.3 | Functional Tax Base Amount 1 | E A |
FUNTXBSE2 | 129 | BCD*10.3 | Functional Tax Base Amount 2 | E A |
FUNTXBSE3 | 130 | BCD*10.3 | Functional Tax Base Amount 3 | E A |
FUNTXBSE4 | 131 | BCD*10.3 | Functional Tax Base Amount 4 | E A |
FUNTXBSE5 | 132 | BCD*10.3 | Functional Tax Base Amount 5 | E A |
FUNNETTAX | 133 | BCD*10.3 | Functional Net of Tax | E A |
FUNGRODIS | 134 | BCD*10.3 | Functional Gross Distribution Amount | E A |
FUNAMTALOC | 135 | BCD*10.3 | Functional Total Tax Allocated | E A |
TAXRATE1 | 136 | BCD*8.7 | Tax Rate 1 | E A |
TAXRATE2 | 137 | BCD*8.7 | Tax Rate 2 | E A |
TAXRATE3 | 138 | BCD*8.7 | Tax Rate 3 | E A |
TAXRATE4 | 139 | BCD*8.7 | Tax Rate 4 | E A |
TAXRATE5 | 140 | BCD*8.7 | Tax Rate 5 | E A |
FUNTXEXP1 | 141 | BCD*10.3 | Functional Expensed Amount 1 | E A |
FUNTXEXP2 | 142 | BCD*10.3 | Functional Expensed Amount 2 | E A |
FUNTXEXP3 | 143 | BCD*10.3 | Functional Expensed Amount 3 | E A |
FUNTXEXP4 | 144 | BCD*10.3 | Functional Expensed Amount 4 | E A |
FUNTXEXP5 | 145 | BCD*10.3 | Functional Expensed Amount 5 | E A |
FUNTXRCB1 | 146 | BCD*10.3 | Functional Recoverable Amount 1 | E A |
FUNTXRCB2 | 147 | BCD*10.3 | Functional Recoverable Amount 2 | E A |
FUNTXRCB3 | 148 | BCD*10.3 | Functional Recoverable Amount 3 | E A |
FUNTXRCB4 | 149 | BCD*10.3 | Functional Recoverable Amount 4 | E A |
FUNTXRCB5 | 150 | BCD*10.3 | Functional Recoverable Amount 5 | E A |
TXRECVB1RC | 151 | BCD*10.3 | Tax Reporting Recoverable Amount 1 | E A |
TXRECVB2RC | 152 | BCD*10.3 | Tax Reporting Recoverable Amount 2 | E A |
TXRECVB3RC | 153 | BCD*10.3 | Tax Reporting Recoverable Amount 3 | E A |
TXRECVB4RC | 154 | BCD*10.3 | Tax Reporting Recoverable Amount 4 | E A |
TXRECVB5RC | 155 | BCD*10.3 | Tax Reporting Recoverable Amount 5 | E A |
TXGRPDESC | 156 | String*60 | Tax Group Description | E A |
CURNRCDESC | 157 | String*60 | Tax Reporting Currency Description | E A |
RATERCDESC | 158 | String*60 | Tax Reporting RateType Description | E A |
EXPNSACNT1 | 159 | String*45 | Tax Expense Account 1 | E A |
EXPNSACNT2 | 160 | String*45 | Tax Expense Account 2 | E A |
EXPNSACNT3 | 161 | String*45 | Tax Expense Account 3 | E A |
EXPNSACNT4 | 162 | String*45 | Tax Expense Account 4 | E A |
EXPNSACNT5 | 163 | String*45 | Tax Expense Account 5 | E A |
RECBLACNT1 | 164 | String*45 | Tax Recoverable Account 1 | E A |
RECBLACNT2 | 165 | String*45 | Tax Recoverable Account 2 | E A |
RECBLACNT3 | 166 | String*45 | Tax Recoverable Account 3 | E A |
RECBLACNT4 | 167 | String*45 | Tax Recoverable Account 4 | E A |
RECBLACNT5 | 168 | String*45 | Tax Recoverable Account 5 | E A |

This page was generated on 2008-May-01

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