Table: Bank Posting Journal

Table: BKJRNL
View: BK0011
Record Length: 1694

Flags: A R 

Keys: 2

Title Flags Fields
Posting Sequence/Bank Code PSTSEQ, BANK
Posting Sequence/Bank Sequence PSTSEQ, BANKSEQ

Fields: 130

Field Type Title Presentation
PSTSEQ BCD*5.0 Posting Sequence
BANK String*8 Bank Code
AUDTDATE Date
AUDTTIME Time
AUDTUSER String*8
AUDTORG String*6
NAME String*60 Description
ADDR1 String*60 Address Line 1
ADDR2 String*60 Address Line 2
ADDR3 String*60 Address Line 3
ADDR4 String*60 Address Line 4
CITY String*30 City
STATE String*30 State
COUNTRY String*30 Country
POSTAL String*20 Zip/Postal Code
CONTACT String*60 Contact
PHONE String*30 Phone Number
FAX String*30 Fax Number
TRANSIT String*12 Transit Number
MULTICUR Boolean Multicurrency Switch
CURNSTMT String*3 Statement Currency
INACTIVE Boolean Inactive Switch
INACTDATE Date Date Inactived
BKACCT String*22 Bank Account Number
IDACCT String*45 Bank G/L Account
IDACCTERR String*45 Bank Error G/L Account
ERRSPREAD BCD*10.3 Error Spread
LSTMNTND Date Last Maintained
RECFY String*4 Fiscal Year
RECFP Integer Fiscal Period
RECLSTFY String*4 Last Fiscal Year
RECLSTFP Integer Last Fiscal Period
RECLSTDATE Date Last Reconciliation Date
RECLSTBAL BCD*10.3 Last Closing Statement Balance
RECDATE Date Reconciliation Date
RECSTMTDAT Date Statement Date
RECSTMTBAL BCD*10.3 Closing Statement Balance
RECINTRANS BCD*10.3 Deposits in Transit
RECOUTSTND BCD*10.3 Checks Outstanding
RECBKERRPN BCD*10.3 Bank Error Pending Amount
RECBKENT BCD*10.3 Bank Entries Amount
RECBKERR BCD*10.3 Bank Error Amount
RECEXGAIN BCD*10.3 Exchange Amount Gained
RECEXLOSS BCD*10.3 Exchange Amount Lost
RECDEPOSIT BCD*10.3 Total Deposits
RECCHECK BCD*10.3 Total Checks
RECFCDEP BCD*10.3 Deposits To Fiscal Period
RECFCCHK BCD*10.3 Checks To Fiscal Period
RECFCDEPIT BCD*10.3 Deposits In Transit To Fiscal Period
RECFCCHKOS BCD*10.3 Checks Outstanding To Fiscal Period
RECRECALC Boolean Recalculate Fiscal Period Data
ADJBOOKBAL BCD*10.3 Adjusted Book Balance
ADJSTMTBAL BCD*10.3 Adjusted Statement Balance
BALANCES Boolean Bank Reconciliation Balanced
ADJBALDIFF BCD*10.3 Adjusted Balance Difference
CHKSERIAL ??? Next Check Serial Number
NXTDEPOSIT BCD*8.0 Next Deposit Number
DEPSERIAL ??? Next Deposit Serial Number
RECAVAIL BCD*10.3 Current Balance
RECBOOKBAL BCD*10.3 Reconciliation Book Balance
RECLSMDATE Date Last Statement Date
RECFCBKENT BCD*10.3 Bank Entries To Fiscal Period
RECFCGAIN BCD*10.3 Exchange Gain To Fiscal Period
RECFCLOSS BCD*10.3 Exchange Loss To Fiscal Period
RECFCERRPN BCD*10.3 Bank Error Pending To Fiscal Period
RECFCERR BCD*10.3 Bank Error To Fiscal Period
RECFCENTRE BCD*10.3 Reconciled Entries To Fiscal Period
IDACCTCCC String*45 Credit Card Charge G/L Account
CCCSPREAD BCD*10.3 Credit Card Charge Spread
EXSPREAD BCD*10.3 Exchange Rate Difference Spread
RECWTERR BCD*10.3 Total Withdrawal Bank Errors
RECWTWO BCD*10.3 Total Withdrawal Write Offs
RECWTGAIN BCD*10.3 Total Withdrawal Exchange Gain
RECWTLOSS BCD*10.3 Total Withdrawal Exchange Loss
RECWTCCC BCD*10.3 Total Withdrawal Credit Card Charges
RECWTCLR BCD*10.3 Total Withdrawal Cleared
RECWTFUNAM BCD*10.3 Total Withdrawal Functional Amounts
RECWPERR BCD*10.3 Fiscal Withdrawal Bank Errors
RECWPWO BCD*10.3 Fiscal Withdrawal Write Offs
RECWPGAIN BCD*10.3 Fiscal Withdrawal Exchange Gain
RECWPLOSS BCD*10.3 Fiscal Withdrawal Exchange Loss
RECWPCCC BCD*10.3 Fiscal Withdrawal Credit Card Charges
RECWPCLR BCD*10.3 Fiscal Withdrawal Cleared
RECWPFUNAM BCD*10.3 Fiscal Withdrawal Functional Amounts
RECDTERR BCD*10.3 Total Deposit Bank Errors
RECDTWO BCD*10.3 Total Deposit Write Offs
RECDTGAIN BCD*10.3 Total Deposit Exchange Gain
RECDTLOSS BCD*10.3 Total Deposit Exchange Loss
RECDTCCC BCD*10.3 Total Deposit Credit Card Charges
RECDTCLR BCD*10.3 Total Deposit Cleared
RECDTFUNAM BCD*10.3 Total Deposit Functional Amounts
RECDPERR BCD*10.3 Fiscal Deposit Bank Errors
RECDPWO BCD*10.3 Fiscal Deposit Write Offs
RECDPGAIN BCD*10.3 Fiscal Deposit Exchange Gain
RECDPLOSS BCD*10.3 Fiscal Deposit Exchange Loss
RECDPCCC BCD*10.3 Fiscal Deposit Credit Card Charges
RECDPCLR BCD*10.3 Fiscal Deposit Cleared
RECDPFUNAM BCD*10.3 Fiscal Deposit Functional Amounts
CURRTYPE Integer Bank Statement Type
RECTWO BCD*10.3 Total Write Offs
RECTCCC BCD*10.3 Total Credit Card Charges
RECPWO BCD*10.3 Fiscal Period Write Off
RECPCCC BCD*10.3 Fiscal Period Credit Card Charges
RECWTWOSUM BCD*10.3 Sum of Withdrawal Total Write Offs
RECDTWOSUM BCD*10.3 Sum of Deposit Total Write Offs
RECWPWOSUM BCD*10.3 Sum of Withdrawal Fiscal Write Offs
RECDPWOSUM BCD*10.3 Sum of Deposit Fiscal Write Offs
CURFUNC String*3 Functional Currency
BANKSEQ Long Bank Sequence
CODETXGRP String*12 Tax Group Code
TAXAUTH1 String*12 Tax Authorization 1
TAXAUTH2 String*12 Tax Authorization 2
TAXAUTH3 String*12 Tax Authorization 3
TAXAUTH4 String*12 Tax Authorization 4
TAXAUTH5 String*12 Tax Authorization 5
TXVCLSS1 Integer Vendor Tax Class 1
TXVCLSS2 Integer Vendor Tax Class 2
TXVCLSS3 Integer Vendor Tax Class 3
TXVCLSS4 Integer Vendor Tax Class 4
TXVCLSS5 Integer Vendor Tax Class 5
RECWRCLR BCD*10.3 Withdrawals Cleared To Current
RECDRCLR BCD*10.3 Deposits Cleared To Current
POSTDATE Date Posting Date
LSTPOSTDAT Date Last Reconciliation Posting Date
RECCOMMENT String*60 Default Reconciliation Description
RECWEXDIFF BCD*10.3 Checks Cleared with Exch. Rate Diff.
RECDEXDIFF BCD*10.3 Deposit Cleared with Exchange Rate Diff
LSTSTMTBAL BCD*10.3 Last Available Statement Balance
RECWFCLR BCD*10.3 Withdrawals Cleared To Future
RECDFCLR BCD*10.3 Deposits Cleared To Future

This page was generated on 2022-Aug-18

© 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).