Table: Bank Journal Transaction Details

Table: BKJTRAND
View: BK0650
Record Length: 1001

Flags: A R 

Keys: 1

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

Fields: 92

Field Type Title Presentation
PSTSEQ BCD*5.0 Posting Sequence
BANK String*8 Bank Code Mask: %-8N
SERIAL ??? Transaction Header Serial
LINE Long Transaction Detail Line
AUDTDATE Date
AUDTTIME Time
AUDTUSER String*8
AUDTORG String*6
SRCEAPP String*2 Source Application Mask: %-2N
STATUS Integer Transaction Detail Status 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 Integer Transaction Type List:2 entries
1 = Withdrawals
2 = Deposits
TYPE Integer Detail Transaction Type List:7 entries
1 = Check
2 = EFT
3 = Transfer
4 = Service Charge
5 = Credit Card
6 = Cash
7 = Other
IDREMIT String*24 Remittance ID
DATEREMIT Date Transaction Date
BTCHNBR BCD*5.0 Batch Number
ENTRYNBR BCD*4.0 Entry Number
POSTSEQ BCD*5.0 Posting Sequence Number
REFERENCE String*60 Transaction Reference
COMMENT String*60 Transaction Description
PAYORID String*12 Payer Code Mask: %-12C
PAYORNAME String*60 Payee Name
VENDORNAME String*60 Vendor Name
SRCEAMOUNT BCD*10.3 Source Transaction Amount
FUNCAMOUNT BCD*10.3 Functional Transaction Amount
RATETYPE String*2 Exchange Rate Type Mask: %-2N
SRCECURN String*3 Receipt Currency Mask: %-3N
RATEDATE Date Exchange Rate Date
RATE BCD*8.7 Exchange Rate
RATESPREAD BCD*8.7 Rate Spread
RATEOP Integer Rate Operation List:3 entries
1 = Multiply
2 = Divide
0 = Not Specified
DISTCODE String*6 Distribution Code Mask: %-6N
GLACCOUNT String*45 G/L Account Mask: %-45C
GLACCTOVR Boolean GL Account Override
DDTYPE Integer Drilldown Type
DDLINK BCD*10.0 Drilldown Link
RECSTATUS Integer Reconciliation Status 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 Date Status Change Date
RECCOMMENT String*60 Reconciliation Description
RECCLEARED BCD*10.3 Cleared Amount
POSTDATE Date Reconciliation Posting Date
POSTYEAR String*4 Reconciliation Posting Year Mask: %04D
POSTPERIOD Integer Reconciliation Posting Period
RECONCILED Boolean Reconciled
RECPENDING BCD*10.3 Remaining In Transit Amount
RECERR BCD*10.3 Reconciliation Error
RECERRPEND BCD*10.3 Reconciliation Error Pending
RECEXGAIN BCD*10.3 Reconciliation Exchange Gain
RECEXLOSS BCD*10.3 Reconciliation Exchange Loss
RECSUGGEST Integer Reconciliation Suggestion 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 BCD*10.3 Transaction Amount
RECOUTSTND BCD*10.3 Outstanding Amount
RECTARGET Integer Reconciliation Target
RECCCC BCD*10.3 Reconciliation Credit Card Charge
RECWOSUM BCD*10.3 Write-Off Amount
CURFUNC String*3 Functional Currency
CURSTMT String*3 Statement Currency
SUMAMOUNT BCD*10.3 Summated Transaction Amount
RECSPREAD BCD*10.3 Reconciliation Spread
RECPAMOUNT BCD*10.3 Fiscal Transaction Remaining In Transit
RECPOUTSTD BCD*10.3 Fiscal Outstanding Amount
RECPWO BCD*10.3 Fiscal Write Offs
RECPERR BCD*10.3 Fiscal Bank Errors
RECPGAIN BCD*10.3 Fiscal Exchange Gain
RECPLOSS BCD*10.3 Fiscal Exchange Loss
RECPCCC BCD*10.3 Fiscal Credit Card Charge
RECPCLR BCD*10.3 Fiscal Cleared
RECPFUNAM BCD*10.3 Fiscal Functional Amount
RECPORIG BCD*10.3 Fiscal Original Transaction Amount
RECTBOOK BCD*10.3 Total Book Amount
RECPBOOK BCD*10.3 Fiscal Book Amount
RECTREMAIN BCD*10.3 Total Remaining Amount
RECPREMAIN BCD*10.3 Fiscal Remaining Amount
RECRWOSUM BCD*10.3 Fiscal Write-Off To This Period
RECFCLR BCD*10.3 Fiscal Cleared To Future
RECRCLR BCD*10.3 Fiscal Cleared To Current
RECWOSUMR BCD*10.3 Current Period's Write-Off
RECFCLRR BCD*10.3 Posted Fiscal Cleared To Future
PAYMCODE String*12 Payment Code
CHKFORM String*6 Check Stock Code Mask: %-6N
OFXTID String*50 OFX Transaction ID
RECDELTAF BCD*10.3 Future Reconciliation Delta
FSCYEAR String*4 Fiscal Year Mask: %04D
FSCPERIOD Integer Fiscal Period
REVDATE Date Reversal/Return Date
SRCEDOCNUM String*22 Source Document Number
CANREVINVC Integer Can Reverse Invoice List:2 entries
0 = No
1 = Yes
REVINVC Integer Reverse Invoice List:2 entries
0 = No
1 = Yes
COMPLETED Integer Reconciled and Journaled Transaction List:2 entries
0 = Not Completed
10 = Completed
ENTRYTYPE Integer Entry Type
RECDELTA BCD*10.3 Reconciliation Amount Delta
POSTED Date Document Posted Date
RECLEVEL Integer Reconciled By List:2 entries
0 = Reconciled by Header
1 = Reconciled by Detail

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