Table: Bank Journal Transaction Header

Table: BKJTRANH
View: BK0655
Record Length: 898

Flags: A R 

Keys: 2

Title Flags Fields

Bank Journal Transaction Uniquif PSTSEQBANKSERIAL
PSTSEQBANKTRANSTYPESERIAL

Fields: 81

Field Type Title Presentation

PSTSEQ BCD*5.0 Posting Sequence
BANK String*8 Bank Code Mask: %-8N
SERIAL ??? Transaction Header Serial
AUDTDATE Date
AUDTTIME Time
AUDTUSER String*8
AUDTORG String*6
TRANSNUM BCD*8.0 Transaction Number
SRCEAPP String*2 Source Application Mask: %-2N
TRANSTYPE Integer Transaction Type List:2 entries
1 = Withdrawals
2 = Deposits
OLDSERIAL ??? Old Serial Number
ENTRYTYPE Integer Entry Type List:7 entries
1 = Bank Entered
2 = Miscellaneous
3 = Subledger
4 = Transfer
5 = Returned Customer Check
6 = Alignment
7 = Non Negotiable
REFERENCE String*60 Transaction Reference
DESC String*60 Transaction Description
TRANSDATE Date Transaction Date
FSCYEAR String*4 Fiscal Year Mask: %04D
FSCPERIOD Integer Fiscal Period
PRINTED Integer Transaction Slip Printed List:2 entries
0 = No
1 = Yes
TOTAMOUNT BCD*10.3 Transaction Total
TOTBALAMT BCD*10.3 Transaction Remaining Balance Amount
TOTCLEARED BCD*10.3 Fiscal Transaction Total
NXTLINE Long Next Transaction Detail Line
LINES Long Lines
LINESPOST Long Lines In Transit
LINESREC Long Lines Reconciled
STATUS Integer Transaction Status List:8 entries
1 = Not posted
2 = Partially Outstanding
3 = Outstanding
4 = Partially Reconciled
5 = Reconciled
6 = Pending Journal
7 = Posted
8 = Purged
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
RECAMOUNT BCD*10.3 Reconciliation Deposit Amount
RECOUTSTND BCD*10.3 Reconciliation In Transit Amt
SUMMARY Integer Transaction Recorded in Summary List:4 entries
0 = Detail
1 = Summary
2 = Transfer
3 = Bank Error
RECCCC BCD*10.3 Reconciliation Credit Card Charge
RECCLEARED BCD*10.3 Amount Cleared
RECFUNCAMT BCD*10.3 Functional Transaction Amount
TOTFUNCAMT BCD*10.3 Functional Transaction Total
TOCLEAR BCD*10.3 Reconciliation Cleared Amount
TOWRITEOFF BCD*10.3 Write-Off Amount
TOREMAIN BCD*10.3 In Transit Amount
VARIANCE Integer Variance Type 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 Long Lines Can Reverse Invoice
POSTDATE Date Default Posting Date
RECSTATUS Integer Default Reconciliation Status 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 String*60 Default Reconciliation Desc.
LINESJOUR Long Lines Journalled
LINESPUR Long Lines Purged
TOCLEARF BCD*10.3 Clear To Future Period
RECFCLR BCD*10.3 Fiscal Cleared To Future
RECRCLR BCD*10.3 Fiscal Cleared To Current
COMPLETED Integer Reconciled and Journaled Transaction List:2 entries
0 = Not Completed
10 = Completed
RECWOSUMR BCD*10.3 Current Period's Write-Off
TOCLEARR BCD*10.3 Clear To Reconciliation Period
RECRWOSUM BCD*10.3 Fiscal Write-Off To This Period
RECPREM BCD*10.3 Fiscal Remaining Outstanding
RECTWO BCD*10.3 Total Delta Write Offs
RECTERR BCD*10.3 Total Delta Bank Errors
RECTGAIN BCD*10.3 Total Delta Exchange Gain
RECTLOSS BCD*10.3 Total Delta Exchange Loss
RECTCCC BCD*10.3 Total Delta Credit Card Charge
RECTCLR BCD*10.3 Total Delta Cleared
RECTFUNAM BCD*10.3 Total Delta Functional Amount
CURFUNC String*3 Functional Currency
CURSTMT String*3 Statement Currency
RECWOSUM BCD*10.3 Reconciliation Write Off Sum
POSTYEAR String*4 Reconciliation posting Year Mask: %04D
POSTPERIOD Integer Reconciliation posting Period
RECDELTA BCD*10.3 Reconciliation Delta
RECFCMISC BCD*10.3 Fiscal Miscellaneous Entry
RECFCWMISC BCD*10.3 Withdrawal Misc. Entries To Fiscal Period
RECFCDMISC BCD*10.3 Deposit Misc. Entries To Fiscal Period
RECFWMISC BCD*10.3 Withdrawal Misc. Entries To Future Period
RECFDMISC BCD*10.3 Deposit Misc. Entries To Future Period
PAYORNAME String*60 Payment Payee Name
VENDORNAME String*60 Payment Vendor Name
ENTRYNBR String*22 Bank Entry/Transfer Number
LINESPROC Long Lines Processed
REVINVC Integer Reverse Invoice List:2 entries
0 = No
1 = Yes
GLACCOUNT String*45 G/L Account of Discrepancy
AMTDTLREC BCD*10.3 Reconcile by Detail Reconciled
AMTDTLOUT BCD*10.3 Reconcile by Detail Outstanding