View: Bank Journal Transaction Header

RotoID: BK0655
Table: BKJTRANH
Protocol: Detail, Ordered revisions
DLL:BKJTRANH

Compositions: 2

RotoID Tables Title DLL
BK0011 BKJRNL Bank Posting Journal BKJRNL
BK0650 BKJTRAND Bank Journal Transaction Details BKJTRAND

Keys: 2

Title Fields
Bank Journal Transaction Uniquif PSTSEQ, BANK, SERIAL
PSTSEQ, BANK, TRANSTYPE, SERIAL

Fields: 77

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  Mask: %-8N
SERIAL 3 ??? Transaction Header Serial E A K R 
TRANSNUM 4 BCD*8.0 Transaction Number E A 
SRCEAPP 5 String*2 Source Application E A  Mask: %-2N
TRANSTYPE 6 Integer Transaction Type E A  List:2 entries
1 = Withdrawals
2 = Deposits
OLDSERIAL 7 ??? Old Serial Number E A 
ENTRYTYPE 8 Integer Entry Type E A  List:7 entries
1 = Bank Entered
2 = Miscellaneous
3 = Subledger
4 = Transfer
5 = Returned Customer Check
6 = Alignment
7 = Non Negotiable
REFERENCE 9 String*60 Transaction Reference E A 
DESC 10 String*60 Transaction Description E A 
TRANSDATE 11 Date Transaction Date E A 
FSCYEAR 12 String*4 Fiscal Year E A  Mask: %04D
FSCPERIOD 13 Integer Fiscal Period E A 
PRINTED 14 Integer Transaction Slip Printed E A  List:2 entries
0 = No
1 = Yes
TOTAMOUNT 15 BCD*10.3 Transaction Total E A 
TOTBALAMT 16 BCD*10.3 Transaction Remaining Balance Amount E A 
TOTCLEARED 17 BCD*10.3 Fiscal Transaction Total E A 
NXTLINE 18 Long Next Transaction Detail Line E A 
LINES 19 Long Lines E A 
LINESPOST 20 Long Lines In Transit E A 
LINESREC 21 Long Lines Reconciled E A 
STATUS 22 Integer Transaction Status E A  List:8 entries
1 = Not posted
2 = Partially Outstanding
3 = Outstanding
4 = Partially Reconciled
5 = Reconciled
6 = Pending Journal
7 = Posted
8 = Purged
RECERR 23 BCD*10.3 Reconciliation Error E A 
RECERRPEND 24 BCD*10.3 Reconciliation Error Pending E A 
RECEXGAIN 25 BCD*10.3 Reconciliation Exchange Gain E A 
RECEXLOSS 26 BCD*10.3 Reconciliation Exchange Loss E A 
RECAMOUNT 27 BCD*10.3 Reconciliation Deposit Amount E A 
RECOUTSTND 28 BCD*10.3 Reconciliation In Transit Amt E A 
SUMMARY 29 Integer Transaction Recorded in Summary E A  List:4 entries
0 = Detail
1 = Summary
2 = Transfer
3 = Bank Error
RECCCC 30 BCD*10.3 Reconciliation Credit Card Charge E A 
RECCLEARED 31 BCD*10.3 Amount Cleared E A 
RECFUNCAMT 32 BCD*10.3 Functional Transaction Amount E A 
TOTFUNCAMT 33 BCD*10.3 Functional Transaction Total E A 
TOCLEAR 34 BCD*10.3 Reconciliation Cleared Amount E A 
TOWRITEOFF 35 BCD*10.3 Write-Off Amount E A 
TOREMAIN 36 BCD*10.3 In Transit Amount E A 
VARIANCE 37 Integer Variance Type E A  List:6 entries
0 = None
1 = Outstanding amount
2 = Amount to write off
3 = Bank error
4 = Exchange rate difference
5 = Credit card charge
LINESREVIN 38 Long Lines Can Reverse Invoice E A 
POSTDATE 39 Date Default Posting Date E A 
RECSTATUS 40 Integer Default Reconciliation Status E A  List:14 entries
1 = Not Posted
2 = Void
3 = Outstanding
4 = Reversed
5 = Cleared
6 = Cleared with bank error
7 = Non-negotiable
8 = Continuation
9 = Printed
10 = Cleared with write-off
11 = Cleared with exchange rate difference
12 = Cleared with credit card charge
13 = Deleted
14 = Reconcile by deposit detail
RECCOMMENT 41 String*60 Default Reconciliation Desc. E A 
LINESJOUR 42 Long Lines Journalled E A 
LINESPUR 43 Long Lines Purged E A 
TOCLEARF 44 BCD*10.3 Clear To Future Period E A 
RECFCLR 45 BCD*10.3 Fiscal Cleared To Future E A 
RECRCLR 46 BCD*10.3 Fiscal Cleared To Current E A 
COMPLETED 47 Integer Reconciled and Journaled Transaction E A  List:2 entries
0 = Not Completed
10 = Completed
RECWOSUMR 48 BCD*10.3 Current Period's Write-Off E A 
TOCLEARR 49 BCD*10.3 Clear To Reconciliation Period E A 
RECRWOSUM 50 BCD*10.3 Fiscal Write-Off To This Period E A 
RECPREM 51 BCD*10.3 Fiscal Remaining Outstanding E A 
RECTWO 52 BCD*10.3 Total Delta Write Offs E A 
RECTERR 53 BCD*10.3 Total Delta Bank Errors E A 
RECTGAIN 54 BCD*10.3 Total Delta Exchange Gain E A 
RECTLOSS 55 BCD*10.3 Total Delta Exchange Loss E A 
RECTCCC 56 BCD*10.3 Total Delta Credit Card Charge E A 
RECTCLR 57 BCD*10.3 Total Delta Cleared E A 
RECTFUNAM 58 BCD*10.3 Total Delta Functional Amount E A 
CURFUNC 59 String*3 Functional Currency E A 
CURSTMT 60 String*3 Statement Currency E A 
RECWOSUM 61 BCD*10.3 Reconciliation Write Off Sum E A 
POSTYEAR 62 String*4 Reconciliation posting Year E A  Mask: %04D
POSTPERIOD 63 Integer Reconciliation posting Period E A 
RECDELTA 64 BCD*10.3 Reconciliation Delta E A 
RECFCMISC 65 BCD*10.3 Fiscal Miscellaneous Entry E A 
RECFCWMISC 66 BCD*10.3 Withdrawal Misc. Entries To Fiscal Period E A 
RECFCDMISC 67 BCD*10.3 Deposit Misc. Entries To Fiscal Period E A 
RECFWMISC 68 BCD*10.3 Withdrawal Misc. Entries To Future Period E A 
RECFDMISC 69 BCD*10.3 Deposit Misc. Entries To Future Period E A 
PAYORNAME 70 String*60 Payment Payee Name E A 
VENDORNAME 71 String*60 Payment Vendor Name E A 
ENTRYNBR 72 String*22 Bank Entry/Transfer Number E A 
LINESPROC 73 Long Lines Processed E A 
REVINVC 74 Integer Reverse Invoice E A  List:2 entries
0 = No
1 = Yes
GLACCOUNT 75 String*45 G/L Account of Discrepancy E A 
AMTDTLREC 76 BCD*10.3 Reconcile by Detail Reconciled E A 
AMTDTLOUT 77 BCD*10.3 Reconcile by Detail Outstanding E A 

This page was generated on 2023-Aug-31

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