Table: Bank Journal Transaction Header

Table: BKJTRANH
View: BK0655
Record length: 867
Flags: A R 

Keys: 2

Title  Flags  Fields

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

Fields: 79

Field  Type  Title  Presentation 

PSTSEQ  BCD*5.0  Posting Sequence   
BANK  String*8  Bank Code  Mask: %-8N
SERIAL  Long  Transaction Header Serial   
AUDTDATE  Date     
AUDTTIME  Time     
AUDTUSER  String*8     
AUDTORG  String*6     
TRANSNUM  BCD*5.0  Transaction Number   
SRCEAPP  String*2  Source Application  Mask: %-2N
TRANSTYPE  Integer  Transaction Type  List: 2 entries
1=Withdrawals
2=Deposits
OLDSERIAL  Long  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: 13 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
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   

This page was generated on 2009-Nov-19

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