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