# Table: Bank Entry Posting Journal

Table: BKJENT
View: BK0017
Record length: 3037
Flags: A R

## Keys: 1

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

## Fields: 172

Field | Type | Title | Presentation
--- | --- | --- | ---
PSTSEQ | BCD*5.0 | Posting Sequence |
BANK | String*8 | Bank Code | Mask: %-8N
UNIQUE | Long | Entry Uniquifier |
AUDTDATE | Date |  |
AUDTTIME | Time |  |
AUDTUSER | String*8 |  |
AUDTORG | String*6 |  |
DATE | Date | Entry Date |
TYPE | String*6 | Transaction Type | Mask: %-6N
REFERENCE | String*60 | Reference |
COMMENT | String*60 | Comment |
AMOUNT | BCD*10.3 | Amount |
SRCEAMT | BCD*10.3 | Source Amount |
RATETYPE | String*2 | Exchange Rate Type | Mask: %-2N
SRCECURN | String*3 | Payment Currency | Mask: %-3N
RATEDATE | Date | Exchange Rate Date |
RATE | BCD*8.7 | Exchange Rate |
RATESPREAD | BCD*8.7 | Rate Spread |
RATEOP | Integer | Rate Operation | List: 3 entries
1 | = | Multiply
2 | = | Divide
0 | = | Not Specified
SRCEAMTCR | BCD*10.3 | Source Credit Amount |
SRCEAMTDR | BCD*10.3 | Source Debit Amount |
AMTCR | BCD*10.3 | Credit Amount |
AMTDR | BCD*10.3 | Debit Amount |
ENTRYAMT | BCD*10.3 | Statement Amount |
IDACCT | String*45 | G/L Account | Mask: %-45C
IDACCTOVR | Boolean | Account Number Override |
ENTRYTYPE | Integer | Entry Type | List: 4 entries
0 | = | User-entered
10 | = | Unmatched OFX
19 | = | Unmatched OFX correction
20 | = | Unmatched OFX error
RECYEAR | String*4 | Reconciliation Fiscal Year | Mask: %04D
RECPERIOD | Integer | Reconciliation Fiscal Period | 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 | Boolean | Reconciled |
BIGCOMMENT | String*250 | Comments |
RECPENT | BCD*10.3 | Fiscal Entry Amount |
RECPENTREC | BCD*10.3 | Reconciled Entry Amount |
CURFUNC | String*3 | Functional Currency |
CURSTMT | String*3 | Statement Currency |
SWTAXBL | Integer | Taxable | List: 2 entries
0 | = | No
1 | = | Yes
TXAMTCALC | Integer | Tax Amount Calculation | List: 2 entries
0 | = | No
1 | = | Yes
CODETAXGRP | String*12 | Tax Group | Mask: %-12N
TAXAUTH1 | String*12 | Tax Authority 1 | Mask: %-12N
TAXAUTH2 | String*12 | Tax Authority 2 | Mask: %-12N
TAXAUTH3 | String*12 | Tax Authority 3 | Mask: %-12N
TAXAUTH4 | String*12 | Tax Authority 4 | Mask: %-12N
TAXAUTH5 | String*12 | Tax Authority 5 | Mask: %-12N
TAXVCLSS1 | Integer | Tax Vendor Class 1 |
TAXVCLSS2 | Integer | Tax Vendor Class 2 |
TAXVCLSS3 | Integer | Tax Vendor Class 3 |
TAXVCLSS4 | Integer | Tax Vendor Class 4 |
TAXVCLSS5 | Integer | Tax Vendor Class 5 |
TAXICLSS1 | Integer | Tax Item Class 1 |
TAXICLSS2 | Integer | Tax Item Class 2 |
TAXICLSS3 | Integer | Tax Item Class 3 |
TAXICLSS4 | Integer | Tax Item Class 4 |
TAXICLSS5 | Integer | Tax Item Class 5 |
TAXINCL1 | Integer | Tax Include 1 | List: 2 entries
0 | = | No
1 | = | Yes
TAXINCL2 | Integer | Tax Include 2 | List: 2 entries
0 | = | No
1 | = | Yes
TAXINCL3 | Integer | Tax Include 3 | List: 2 entries
0 | = | No
1 | = | Yes
TAXINCL4 | Integer | Tax Include 4 | List: 2 entries
0 | = | No
1 | = | Yes
TAXINCL5 | Integer | Tax Include 5 | List: 2 entries
0 | = | No
1 | = | Yes
BASETAX1 | BCD*10.3 | Tax Base Amount 1 |
BASETAX2 | BCD*10.3 | Tax Base Amount 2 |
BASETAX3 | BCD*10.3 | Tax Base Amount 3 |
BASETAX4 | BCD*10.3 | Tax Base Amount 4 |
BASETAX5 | BCD*10.3 | Tax Base Amount 5 |
BASETAXRC1 | BCD*10.3 | Tax Base Retainage amount1 |
BASETAXRC2 | BCD*10.3 | Tax Base Retainage amount2 |
BASETAXRC3 | BCD*10.3 | Tax Base Retainage amount3 |
BASETAXRC4 | BCD*10.3 | Tax Base Retainage amount4 |
BASETAXRC5 | BCD*10.3 | Tax Base Retainage amount5 |
TXCALCBASE | Integer | Tax Base Calculation Method | List: 2 entries
0 | = | No
1 | = | Yes
AMTTAX1 | BCD*10.3 | Tax Amount 1 |
AMTTAX2 | BCD*10.3 | Tax Amount 2 |
AMTTAX3 | BCD*10.3 | Tax Amount 3 |
AMTTAX4 | BCD*10.3 | Tax Amount 4 |
AMTTAX5 | BCD*10.3 | Tax Amount 5 |
AMTTXBL | BCD*10.3 | Taxable Amount |
AMTNOTTXBL | BCD*10.3 | Non Taxable Amount |
AMTTAXTOT | BCD*10.3 | Tax Total |
AMTDOCTOT | BCD*10.3 | Document Total Before Tax |
AMTNETTOT | BCD*10.3 | Document Total Including Tax |
AMTINCLUDE | BCD*10.3 | Total Included Amount |
AMTEXCLUDE | BCD*10.3 | Total Excluded Amount |
AMTDIST | BCD*10.3 | Tax Distribution amount |
AMTNETDIST | BCD*10.3 | Tax Net Distribution Amount |
AMTGRODIST | BCD*10.3 | Tax Gross Distribution Amount |
AMTEXPENS1 | BCD*10.3 | Tax Expense Amount 1 |
AMTEXPENS2 | BCD*10.3 | Tax Expense Amount 2 |
AMTEXPENS3 | BCD*10.3 | Tax Expense Amount 3 |
AMTEXPENS4 | BCD*10.3 | Tax Expense Amount 4 |
AMTEXPENS5 | BCD*10.3 | Tax Expense Amount 5 |
AMTRECVRB1 | BCD*10.3 | Tax Recoverable Amount 1 |
AMTRECVRB2 | BCD*10.3 | Tax Recoverable Amount 2 |
AMTRECVRB3 | BCD*10.3 | Tax Recoverable Amount 3 |
AMTRECVRB4 | BCD*10.3 | Tax Recoverable Amount 4 |
AMTRECVRB5 | BCD*10.3 | Tax Recoverable Amount 5 |
TOTAMTALOC | BCD*10.3 | Total Tax Allocated Amount |
TXAMT1RC | BCD*10.3 | Tax Reporting Amount 1 |
TXAMT2RC | BCD*10.3 | Tax Reporting Amount 2 |
TXAMT3RC | BCD*10.3 | Tax Reporting Amount 3 |
TXAMT4RC | BCD*10.3 | Tax Reporting Amount 4 |
TXAMT5RC | BCD*10.3 | Tax Reporting Amount 5 |
TXALOCRC | BCD*10.3 | Total Tax Reporting Allocated Amount |
TXEXPNSRC | BCD*10.3 | Tax Reporting Expensed Amount |
TXRECVBRC | BCD*10.3 | Tax Reporting Recoverable Amount |
TXTOTRC | BCD*10.3 | Total Tax Reporting Amount |
TAXVERSION | Long | Tax Version |
TXCALCRMET | Integer | Tax Calculation Reporting Method | List: 2 entries
0 | = | No
1 | = | Yes
CODECURNRC | String*3 | Tax Reporting Currency Code | Mask: %-3N
RATERC | BCD*8.7 | Tax Reporting Rate |
RATETYPERC | String*2 | Tax Reporting Rate Type | Mask: %-2N
RATEDATERC | Date | Tax Reporting Rate Date |
RATEOPRC | Integer | Tax Reporting Rate Operation | List: 3 entries
1 | = | Multiply
2 | = | Divide
0 | = | Not Specified
TXAU1DESC | String*60 | Tax Authority Description 1 |
TXAU2DESC | String*60 | Tax Authority Description 2 |
TXAU3DESC | String*60 | Tax Authority Description 3 |
TXAU4DESC | String*60 | Tax Authority Description 4 |
TXAU5DESC | String*60 | Tax Authority Description 5 |
VCLS1DESC | String*60 | Vendor Tax Class Description 1 |
VCLS2DESC | String*60 | Vendor Tax Class Description 2 |
VCLS3DESC | String*60 | Vendor Tax Class Description 3 |
VCLS4DESC | String*60 | Vendor Tax Class Description 4 |
VCLS5DESC | String*60 | Vendor Tax Class Description 5 |
ICLS1DESC | String*60 | Item Tax Class Description 1 |
ICLS2DESC | String*60 | Item Tax Class Description 2 |
ICLS3DESC | String*60 | Item Tax Class Description 3 |
ICLS4DESC | String*60 | Item Tax Class Description 4 |
ICLS5DESC | String*60 | Item Tax Class Description 5 |
FUNTXAMT1 | BCD*10.3 | Functional Tax Amount 1 |
FUNTXAMT2 | BCD*10.3 | Functional Tax Amount 2 |
FUNTXAMT3 | BCD*10.3 | Functional Tax Amount 3 |
FUNTXAMT4 | BCD*10.3 | Functional Tax Amount 4 |
FUNTXAMT5 | BCD*10.3 | Functional Tax Amount 5 |
FUNTXBSE1 | BCD*10.3 | Functional Tax Base Amount 1 |
FUNTXBSE2 | BCD*10.3 | Functional Tax Base Amount 2 |
FUNTXBSE3 | BCD*10.3 | Functional Tax Base Amount 3 |
FUNTXBSE4 | BCD*10.3 | Functional Tax Base Amount 4 |
FUNTXBSE5 | BCD*10.3 | Functional Tax Base Amount 5 |
FUNNETTAX | BCD*10.3 | Functional Net of Tax |
FUNGRODIS | BCD*10.3 | Functional Gross Distribution Amount |
FUNAMTALOC | BCD*10.3 | Functional Total Tax Allocated |
TAXRATE1 | BCD*8.7 | Tax Rate 1 |
TAXRATE2 | BCD*8.7 | Tax Rate 2 |
TAXRATE3 | BCD*8.7 | Tax Rate 3 |
TAXRATE4 | BCD*8.7 | Tax Rate 4 |
TAXRATE5 | BCD*8.7 | Tax Rate 5 |
FUNTXEXP1 | BCD*10.3 | Functional Expensed Amount 1 |
FUNTXEXP2 | BCD*10.3 | Functional Expensed Amount 2 |
FUNTXEXP3 | BCD*10.3 | Functional Expensed Amount 3 |
FUNTXEXP4 | BCD*10.3 | Functional Expensed Amount 4 |
FUNTXEXP5 | BCD*10.3 | Functional Expensed Amount 5 |
FUNTXRCB1 | BCD*10.3 | Functional Recoverable Amount 1 |
FUNTXRCB2 | BCD*10.3 | Functional Recoverable Amount 2 |
FUNTXRCB3 | BCD*10.3 | Functional Recoverable Amount 3 |
FUNTXRCB4 | BCD*10.3 | Functional Recoverable Amount 4 |
FUNTXRCB5 | BCD*10.3 | Functional Recoverable Amount 5 |
TXRECVB1RC | BCD*10.3 | Tax Reporting Recoverable Amount 1 |
TXRECVB2RC | BCD*10.3 | Tax Reporting Recoverable Amount 2 |
TXRECVB3RC | BCD*10.3 | Tax Reporting Recoverable Amount 3 |
TXRECVB4RC | BCD*10.3 | Tax Reporting Recoverable Amount 4 |
TXRECVB5RC | BCD*10.3 | Tax Reporting Recoverable Amount 5 |
TXGRPDESC | String*60 | Tax Group Description |
CURNRCDESC | String*60 | Tax Reporting Currency Description |
RATERCDESC | String*60 | Tax Reporting RateType Description |
EXPNSACNT1 | String*45 | Tax Expense Account 1 |
EXPNSACNT2 | String*45 | Tax Expense Account 2 |
EXPNSACNT3 | String*45 | Tax Expense Account 3 |
EXPNSACNT4 | String*45 | Tax Expense Account 4 |
EXPNSACNT5 | String*45 | Tax Expense Account 5 |
RECBLACNT1 | String*45 | Tax Recoverable Account 1 |
RECBLACNT2 | String*45 | Tax Recoverable Account 2 |
RECBLACNT3 | String*45 | Tax Recoverable Account 3 |
RECBLACNT4 | String*45 | Tax Recoverable Account 4 |
RECBLACNT5 | String*45 | Tax Recoverable Account 5 |

This page was generated on 2008-May-01

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