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 ??? Next Check Serial Number E A 
NXTDEPOSIT 56 BCD*8.0 Next Deposit Number E A 
DEPSERIAL 57 ??? 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 128 BCD*10.3 Withdrawals Cleared To Future E A 
RECDFCLR 129 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 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).