# Table: Bank Posting Journal

Table: BKJRNL
View: BK0011
Record length: 1573
Flags: A R

## Keys: 2

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

## Fields: 124

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 | Long | Next Check Serial Number |
NXTDEPOSIT | BCD*5.0 | Next Deposit Number |
DEPSERIAL | Long | 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 |

This page was generated on 2008-May-01

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