# View: Bank Posting Journal

RotoID: BK0011
Table: BKJRNL
Protocol: Header
DLL: BKJRNL

## Compositions: 2

RotoID | Tables | Title | DLL
--- | --- | --- | ---
BK0020 | BKJCTL | Bank Posting Journal Control | BKJCTL
BK0655 | BKJTRANH | Bank Journal Transaction Header | BKJTRANH

## Keys: 2

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

## Fields: 128

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 |
NAME | 3 | String*60 | Description | E A |
ADDR1 | 4 | String*60 | Address Line 1 | E A |
ADDR2 | 5 | String*60 | Address Line 2 | E A |
ADDR3 | 6 | String*60 | Address Line 3 | E A |
ADDR4 | 7 | String*60 | Address Line 4 | E A |
CITY | 8 | String*30 | City | E A |
STATE | 9 | String*30 | State | E A |
COUNTRY | 10 | String*30 | Country | E A |
POSTAL | 11 | String*20 | Zip/Postal Code | E A |
CONTACT | 12 | String*60 | Contact | E A |
PHONE | 15 | String*30 | Phone Number | E A |
FAX | 16 | String*30 | Fax Number | E A |
TRANSIT | 17 | String*12 | Transit Number | E A |
MULTICUR | 18 | Boolean | Multicurrency Switch | E A |
CURNSTMT | 19 | String*3 | Statement Currency | E A |
INACTIVE | 20 | Boolean | Inactive Switch | E A |
INACTDATE | 21 | Date | Date Inactived | E A |
BKACCT | 22 | String*22 | Bank Account Number | E A |
IDACCT | 24 | String*45 | Bank G/L Account | E A |
IDACCTERR | 25 | String*45 | Bank Error G/L Account | E A |
ERRSPREAD | 26 | BCD*10.3 | Error Spread | E A |
LSTMNTND | 27 | Date | Last Maintained | E A |
RECFY | 28 | String*4 | Fiscal Year | E A |
RECFP | 29 | Integer | Fiscal Period | E A |
RECLSTFY | 30 | String*4 | Last Fiscal Year | E A |
RECLSTFP | 31 | Integer | Last Fiscal Period | E A |
RECLSTDATE | 32 | Date | Last Reconciliation Date | E A |
RECLSTBAL | 33 | BCD*10.3 | Last Closing Statement Balance | E A |
RECDATE | 34 | Date | Reconciliation Date | E A |
RECSTMTDAT | 35 | Date | Statement Date | E A |
RECSTMTBAL | 36 | BCD*10.3 | Closing Statement Balance | E A |
RECINTRANS | 37 | BCD*10.3 | Deposits in Transit | E A |
RECOUTSTND | 38 | BCD*10.3 | Checks Outstanding | E A |
RECBKERRPN | 39 | BCD*10.3 | Bank Error Pending Amount | E A |
RECBKENT | 40 | BCD*10.3 | Bank Entries Amount | E A |
RECBKERR | 41 | BCD*10.3 | Bank Error Amount | E A |
RECEXGAIN | 42 | BCD*10.3 | Exchange Amount Gained | E A |
RECEXLOSS | 43 | BCD*10.3 | Exchange Amount Lost | E A |
RECDEPOSIT | 44 | BCD*10.3 | Total Deposits | E A |
RECCHECK | 45 | BCD*10.3 | Total Checks | E A |
RECFCDEP | 46 | BCD*10.3 | Deposits To Fiscal Period | E A |
RECFCCHK | 47 | BCD*10.3 | Checks To Fiscal Period | E A |
RECFCDEPIT | 48 | BCD*10.3 | Deposits In Transit To Fiscal Period | E A |
RECFCCHKOS | 49 | BCD*10.3 | Checks Outstanding To Fiscal Period | E A |
RECRECALC | 50 | Boolean | Recalculate Fiscal Period Data | E A |
ADJBOOKBAL | 51 | BCD*10.3 | Adjusted Book Balance | E A |
ADJSTMTBAL | 52 | BCD*10.3 | Adjusted Statement Balance | E A |
BALANCES | 53 | Boolean | Bank Reconciliation Balanced | E A |
ADJBALDIFF | 54 | BCD*10.3 | Adjusted Balance Difference | E A |
CHKSERIAL | 55 | Long | Next Check Serial Number | E A |
NXTDEPOSIT | 56 | BCD*5.0 | Next Deposit Number | E A |
DEPSERIAL | 57 | Long | Next Deposit Serial Number | E A |
RECAVAIL | 58 | BCD*10.3 | Current Balance | E A |
RECBOOKBAL | 59 | BCD*10.3 | Reconciliation Book Balance | E A |
RECLSMDATE | 60 | Date | Last Statement Date | E A |
RECFCBKENT | 61 | BCD*10.3 | Bank Entries To Fiscal Period | E A |
RECFCGAIN | 62 | BCD*10.3 | Exchange Gain To Fiscal Period | E A |
RECFCLOSS | 63 | BCD*10.3 | Exchange Loss To Fiscal Period | E A |
RECFCERRPN | 64 | BCD*10.3 | Bank Error Pending To Fiscal Period | E A |
RECFCERR | 65 | BCD*10.3 | Bank Error To Fiscal Period | E A |
RECFCENTRE | 66 | BCD*10.3 | Reconciled Entries To Fiscal Period | E A |
IDACCTCCC | 67 | String*45 | Credit Card Charge G/L Account | E A |
CCCSPREAD | 68 | BCD*10.3 | Credit Card Charge Spread | E A |
EXSPREAD | 69 | BCD*10.3 | Exchange Rate Difference Spread | E A |
RECWTERR | 70 | BCD*10.3 | Total Withdrawal Bank Errors | E A |
RECWTWO | 71 | BCD*10.3 | Total Withdrawal Write Offs | E A |
RECWTGAIN | 72 | BCD*10.3 | Total Withdrawal Exchange Gain | E A |
RECWTLOSS | 73 | BCD*10.3 | Total Withdrawal Exchange Loss | E A |
RECWTCCC | 74 | BCD*10.3 | Total Withdrawal Credit Card Charges | E A |
RECWTCLR | 75 | BCD*10.3 | Total Withdrawal Cleared | E A |
RECWTFUNAM | 76 | BCD*10.3 | Total Withdrawal Functional Amounts | E A |
RECWPERR | 77 | BCD*10.3 | Fiscal Withdrawal Bank Errors | E A |
RECWPWO | 78 | BCD*10.3 | Fiscal Withdrawal Write Offs | E A |
RECWPGAIN | 79 | BCD*10.3 | Fiscal Withdrawal Exchange Gain | E A |
RECWPLOSS | 80 | BCD*10.3 | Fiscal Withdrawal Exchange Loss | E A |
RECWPCCC | 81 | BCD*10.3 | Fiscal Withdrawal Credit Card Charges | E A |
RECWPCLR | 82 | BCD*10.3 | Fiscal Withdrawal Cleared | E A |
RECWPFUNAM | 83 | BCD*10.3 | Fiscal Withdrawal Functional Amounts | E A |
RECDTERR | 84 | BCD*10.3 | Total Deposit Bank Errors | E A |
RECDTWO | 85 | BCD*10.3 | Total Deposit Write Offs | E A |
RECDTGAIN | 86 | BCD*10.3 | Total Deposit Exchange Gain | E A |
RECDTLOSS | 87 | BCD*10.3 | Total Deposit Exchange Loss | E A |
RECDTCCC | 88 | BCD*10.3 | Total Deposit Credit Card Charges | E A |
RECDTCLR | 89 | BCD*10.3 | Total Deposit Cleared | E A |
RECDTFUNAM | 90 | BCD*10.3 | Total Deposit Functional Amounts | E A |
RECDPERR | 91 | BCD*10.3 | Fiscal Deposit Bank Errors | E A |
RECDPWO | 92 | BCD*10.3 | Fiscal Deposit Write Offs | E A |
RECDPGAIN | 93 | BCD*10.3 | Fiscal Deposit Exchange Gain | E A |
RECDPLOSS | 94 | BCD*10.3 | Fiscal Deposit Exchange Loss | E A |
RECDPCCC | 95 | BCD*10.3 | Fiscal Deposit Credit Card Charges | E A |
RECDPCLR | 96 | BCD*10.3 | Fiscal Deposit Cleared | E A |
RECDPFUNAM | 97 | BCD*10.3 | Fiscal Deposit Functional Amounts | E A |
CURRTYPE | 98 | Integer | Bank Statement Type | E A |
RECTWO | 99 | BCD*10.3 | Total Write Offs | E A |
RECTCCC | 100 | BCD*10.3 | Total Credit Card Charges | E A |
RECPWO | 101 | BCD*10.3 | Fiscal Period Write Off | E A |
RECPCCC | 102 | BCD*10.3 | Fiscal Period Credit Card Charges | E A |
RECWTWOSUM | 103 | BCD*10.3 | Sum of Withdrawal Total Write Offs | E A |
RECDTWOSUM | 104 | BCD*10.3 | Sum of Deposit Total Write Offs | E A |
RECWPWOSUM | 105 | BCD*10.3 | Sum of Withdrawal Fiscal Write Offs | E A |
RECDPWOSUM | 106 | BCD*10.3 | Sum of Deposit Fiscal Write Offs | E A |
CURFUNC | 107 | String*3 | Functional Currency | E A |
BANKSEQ | 108 | Long | Bank Sequence | E A |
CODETXGRP | 109 | String*12 | Tax Group Code | E A |
TAXAUTH1 | 110 | String*12 | Tax Authorization 1 | E A |
TAXAUTH2 | 111 | String*12 | Tax Authorization 2 | E A |
TAXAUTH3 | 112 | String*12 | Tax Authorization 3 | E A |
TAXAUTH4 | 113 | String*12 | Tax Authorization 4 | E A |
TAXAUTH5 | 114 | String*12 | Tax Authorization 5 | E A |
TXVCLSS1 | 115 | Integer | Vendor Tax Class 1 | E A |
TXVCLSS2 | 116 | Integer | Vendor Tax Class 2 | E A |
TXVCLSS3 | 117 | Integer | Vendor Tax Class 3 | E A |
TXVCLSS4 | 118 | Integer | Vendor Tax Class 4 | E A |
TXVCLSS5 | 119 | Integer | Vendor Tax Class 5 | E A |
RECWRCLR | 120 | BCD*10.3 | Withdrawals Cleared To Current | E A |
RECDRCLR | 121 | BCD*10.3 | Deposits Cleared To Current | E A |
POSTDATE | 122 | Date | Posting Date | E A |
LSTPOSTDAT | 123 | Date | Last Reconciliation Posting Date | E A |
RECCOMMENT | 124 | String*60 | Default Reconciliation Description | E A |
RECWEXDIFF | 125 | BCD*10.3 | Checks Cleared with Exch. Rate Diff. | E A |
RECDEXDIFF | 126 | BCD*10.3 | Deposit Cleared with Exchange Rate Diff | E A |
LSTSTMTBAL | 127 | BCD*10.3 | Last Available Statement Balance | E A |
RECWFCLR | 195 | BCD*10.3 | Withdrawals Cleared To Future | E A |
RECDFCLR | 196 | BCD*10.3 | Deposits Cleared To Future | E A |
RECWPREM | 197 | BCD*10.3 | Fiscal Remaining OutStanding | E A |
RECDPREM | 198 | BCD*10.3 | Fiscal Remaining In Transit | E A |

This page was generated on 2009-Nov-19

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