Table: Bank Transaction Header

Table: BKTRANH
View: BK0845
Record Length: 664

Flags: A R 

Keys: 6

Title Flags Fields

Bank Transaction Uniquifier BANKSERIAL
Bank Transaction Old Serial D  BANKTRANSTYPEOLDSERIAL
Bank Fiscal Transaction M  BANKFSCYEARFSCPERIODSERIAL
Bank Transaction Date M  BANKCOMPLETEDTRANSDATESERIAL
Bank Transaction Number M  BANKTRANSNUMSERIAL
Bank Transaction Completed M  BANKCOMPLETEDTRANSNUMSERIAL

Fields: 59

Field Type Title Presentation

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 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
AMTDTLREC BCD*10.3 Reconcile by Detail Reconciled
AMTDTLOUT BCD*10.3 Reconcile by Detail Outstanding