View: Bank Journal Transaction Details

RotoID: BK0650
Table: BKJTRAND
Protocol: Detail, Ordered revisions
DLL:BKJTRAND

Compositions: 1

RotoID Tables Title DLL
BK0655 BKJTRANH Bank Journal Transaction Header BKJTRANH

Keys: 1

Title Fields
Bank Journal Transaction Detail PSTSEQ, BANK, SERIAL, LINE

Fields: 88

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 
LINE 4 Long Transaction Detail Line E A K R 
SRCEAPP 5 String*2 Source Application E A  Mask: %-2N
STATUS 6 Integer Transaction Detail Status E A  List:12 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
TRANSTYPE 7 Integer Transaction Type E A  List:2 entries
1 = Withdrawals
2 = Deposits
TYPE 8 Integer Detail Transaction Type E A  List:7 entries
1 = Check
2 = EFT
3 = Transfer
4 = Service Charge
5 = Credit Card
6 = Cash
7 = Other
IDREMIT 9 String*24 Remittance ID E A 
DATEREMIT 10 Date Transaction Date E A 
BTCHNBR 11 BCD*5.0 Batch Number E A 
ENTRYNBR 12 BCD*4.0 Entry Number E A 
POSTSEQ 13 BCD*5.0 Posting Sequence Number E A 
REFERENCE 14 String*60 Transaction Reference E A 
COMMENT 15 String*60 Transaction Description E A 
PAYORID 16 String*12 Payer Code E A  Mask: %-12C
PAYORNAME 17 String*60 Payee Name E A 
VENDORNAME 18 String*60 Vendor Name E A 
SRCEAMOUNT 19 BCD*10.3 Source Transaction Amount E A 
FUNCAMOUNT 20 BCD*10.3 Functional Transaction Amount E A 
RATETYPE 21 String*2 Exchange Rate Type E A  Mask: %-2N
SRCECURN 22 String*3 Receipt Currency E A  Mask: %-3N
RATEDATE 23 Date Exchange Rate Date E A 
RATE 24 BCD*8.7 Exchange Rate E A 
RATESPREAD 25 BCD*8.7 Rate Spread E A 
RATEOP 26 Integer Rate Operation E A  List:3 entries
1 = Multiply
2 = Divide
0 = Not Specified
DISTCODE 27 String*6 Distribution Code E A  Mask: %-6N
GLACCOUNT 28 String*45 G/L Account E A  Mask: %-45C
GLACCTOVR 29 Boolean GL Account Override E A 
DDTYPE 35 Integer Drilldown Type E A 
DDLINK 36 BCD*10.0 Drilldown Link E A 
RECSTATUS 37 Integer Reconciliation Status E A  List:12 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
RECSTATCHG 38 Date Status Change Date E A 
RECCOMMENT 39 String*60 Reconciliation Description E A 
RECCLEARED 40 BCD*10.3 Cleared Amount E A 
POSTDATE 41 Date Reconciliation Posting Date E A 
POSTYEAR 42 String*4 Reconciliation Posting Year E A  Mask: %04D
POSTPERIOD 43 Integer Reconciliation Posting Period E A 
RECONCILED 44 Boolean Reconciled E A 
RECPENDING 45 BCD*10.3 Remaining In Transit Amount E A 
RECERR 46 BCD*10.3 Reconciliation Error E A 
RECERRPEND 47 BCD*10.3 Reconciliation Error Pending E A 
RECEXGAIN 48 BCD*10.3 Reconciliation Exchange Gain E A 
RECEXLOSS 49 BCD*10.3 Reconciliation Exchange Loss E A 
RECSUGGEST 50 Integer Reconciliation Suggestion E A  List:12 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
RECAMOUNT 51 BCD*10.3 Transaction Amount E A 
RECOUTSTND 52 BCD*10.3 Outstanding Amount E A 
RECTARGET 53 Integer Reconciliation Target E A 
RECCCC 54 BCD*10.3 Reconciliation Credit Card Charge E A 
RECWOSUM 55 BCD*10.3 Write-Off Amount E A 
CURFUNC 56 String*3 Functional Currency E A 
CURSTMT 57 String*3 Statement Currency E A 
SUMAMOUNT 58 BCD*10.3 Summated Transaction Amount E A 
RECSPREAD 59 BCD*10.3 Reconciliation Spread E A 
RECPAMOUNT 60 BCD*10.3 Fiscal Transaction Remaining In Transit E A 
RECPOUTSTD 61 BCD*10.3 Fiscal Outstanding Amount E A 
RECPWO 62 BCD*10.3 Fiscal Write Offs E A 
RECPERR 63 BCD*10.3 Fiscal Bank Errors E A 
RECPGAIN 64 BCD*10.3 Fiscal Exchange Gain E A 
RECPLOSS 65 BCD*10.3 Fiscal Exchange Loss E A 
RECPCCC 66 BCD*10.3 Fiscal Credit Card Charge E A 
RECPCLR 67 BCD*10.3 Fiscal Cleared E A 
RECPFUNAM 68 BCD*10.3 Fiscal Functional Amount E A 
RECPORIG 69 BCD*10.3 Fiscal Original Transaction Amount E A 
RECTBOOK 70 BCD*10.3 Total Book Amount E A 
RECPBOOK 71 BCD*10.3 Fiscal Book Amount E A 
RECTREMAIN 72 BCD*10.3 Total Remaining Amount E A 
RECPREMAIN 73 BCD*10.3 Fiscal Remaining Amount E A 
RECRWOSUM 74 BCD*10.3 Fiscal Write-Off To This Period E A 
RECFCLR 75 BCD*10.3 Fiscal Cleared To Future E A 
RECRCLR 76 BCD*10.3 Fiscal Cleared To Current E A 
RECWOSUMR 77 BCD*10.3 Current Period's Write-Off E A 
RECFCLRR 78 BCD*10.3 Posted Fiscal Cleared To Future E A 
PAYMCODE 79 String*12 Payment Code E A 
CHKFORM 80 String*6 Check Stock Code E A  Mask: %-6N
OFXTID 81 String*50 OFX Transaction ID E A 
RECDELTAF 82 BCD*10.3 Future Reconciliation Delta E A 
FSCYEAR 83 String*4 Fiscal Year E A  Mask: %04D
FSCPERIOD 84 Integer Fiscal Period E A 
REVDATE 85 Date Reversal/Return Date E A 
SRCEDOCNUM 86 String*22 Source Document Number E A 
CANREVINVC 87 Integer Can Reverse Invoice E A  List:2 entries
0 = No
1 = Yes
REVINVC 88 Integer Reverse Invoice E A  List:2 entries
0 = No
1 = Yes
COMPLETED 89 Integer Reconciled and Journaled Transaction E A  List:2 entries
0 = Not Completed
10 = Completed
ENTRYTYPE 90 Integer Entry Type E A 
RECDELTA 91 BCD*10.3 Reconciliation Amount Delta E A 
POSTED 92 Date Document Posted Date E A 
RECLEVEL 93 Integer Reconciled By E A  List:2 entries
0 = Reconciled by Header
1 = Reconciled by Detail

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