Table: Bank Transaction Header

Table: BKTRANH
View: BK0845
Record length: 633
Flags: A R 

Keys: 5

Title  Flags  Fields
Bank Transaction Uniquifier  BANK, SERIAL
Bank Transaction Old Serial  D  BANK, TRANSTYPE, OLDSERIAL
Bank Fiscal Transaction  D M  BANK, FSCYEAR, FSCPERIOD, SERIAL
Bank Transaction Date  D M  BANK, TRANSDATE, SERIAL
Bank Transaction Number  D M  BANK, TRANSNUM, SERIAL

Fields: 57

Field  Type  Title  Presentation 
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  List: 12 entries
1=1
2=2
3=3
4=4
5=5
6=6
7=7
8=8
9=9
10=10
11=11
12=12
PRINTED  Integer  Transaction Slip Printed  List: 2 entries
0=No
1=Yes
TOTAMOUNT  BCD*10.3  Transaction Total   
TOTBALAMT  BCD*10.3  Transaction Total in Statement   
TOTCLEARED  BCD*10.3  Fiscal Transaction Total   
NXTLINE  Long  Next Transaction Detail Line   
LINES  Long  Lines   
LINESPOST  Long  Lines Outstanding   
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 Amount   
RECOUTSTND  BCD*10.3  Reconciliation Outstanding 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  Outstanding Amount   
VARIANCE  Integer  Variance Type  List: 1 entries
0=None
LINESREVIN  Long  Lines Can Reverse Invoice   
POSTDATE  Date  Reconciliation Date   
RECSTATUS  Integer  Reconciliation Status  List: 5 entries
1=Not Posted
2=Void
9=Printed
7=Non-negotiable
8=Continuation
RECCOMMENT  String*60  Reconciliation Description   
LINESJOUR  Long  Lines Journalled   
LINESPUR  Long  Lines Purged   
LINESPROC  Long  Lines Processed   
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
PAYORNAME  String*60  Payment Payee Name   
VENDORNAME  String*60  Payment Vendor Name   
ENTRYNBR  String*22  Bank Entry/Transfer Number  Mask: %-22C
LINESCCC  Long  Lines Credit Card   
LINESEXCH  Long  Lines Exchange Difference   
REVINVC  Integer  Reverse Invoice  List: 2 entries
0=No
1=Yes

This page was generated on 2009-Nov-19

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