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