# View: Bank Journal Transaction Header

RotoID: BK0655
Table: BKJTRANH
Protocol: Detail, Ordered revisions
DLL: BKJTRANH

## Compositions: 2

RotoID | Tables | Title | DLL
--- | --- | --- | ---
BK0011 | BKJRNL | Bank Posting Journal | BKJRNL
BK0650 | BKJTRAND | Bank Journal Transaction Details | BKJTRAND

## Keys: 2

Title | Fields
--- | ---
Bank Journal Transaction Uniquif | PSTSEQ, BANK, SERIAL
| PSTSEQ, BANK, TRANSTYPE, SERIAL

## Fields: 75

Field | Index | Type | Title | Attributes | Presentation
--- | --- | --- | --- | --- | ---
PSTSEQ | 1 | BCD*5.0 | Posting Sequence | E A K R |
BANK | 2 | String*8 | Bank Code | E A K R | Mask: %-8N
SERIAL | 3 | Long | Transaction Header Serial | E A K R |
TRANSNUM | 4 | BCD*5.0 | Transaction Number | E A |
SRCEAPP | 5 | String*2 | Source Application | E A | Mask: %-2N
TRANSTYPE | 6 | Integer | Transaction Type | E A | List: 2 entries
1 | = | Withdrawals
2 | = | Deposits
OLDSERIAL | 7 | Long | Old Serial Number | E A |
ENTRYTYPE | 8 | Integer | Entry Type | E A | List: 7 entries
1 | = | Bank Entered
2 | = | Miscellaneous
3 | = | Subledger
4 | = | Transfer
5 | = | Returned Customer Check
6 | = | Alignment
7 | = | Non Negotiable
REFERENCE | 9 | String*60 | Transaction Reference | E A |
DESC | 10 | String*60 | Transaction Description | E A |
TRANSDATE | 11 | Date | Transaction Date | E A |
FSCYEAR | 12 | String*4 | Fiscal Year | E A | Mask: %04D
FSCPERIOD | 13 | Integer | Fiscal Period | E A |
PRINTED | 14 | Integer | Transaction Slip Printed | E A | List: 2 entries
0 | = | No
1 | = | Yes
TOTAMOUNT | 15 | BCD*10.3 | Transaction Total | E A |
TOTBALAMT | 16 | BCD*10.3 | Transaction Remaining Balance Amount | E A |
TOTCLEARED | 17 | BCD*10.3 | Fiscal Transaction Total | E A |
NXTLINE | 18 | Long | Next Transaction Detail Line | E A |
LINES | 19 | Long | Lines | E A |
LINESPOST | 20 | Long | Lines In Transit | E A |
LINESREC | 21 | Long | Lines Reconciled | E A |
STATUS | 22 | Integer | Transaction Status | E A | List: 8 entries
1 | = | Not posted
2 | = | Partially Outstanding
3 | = | Outstanding
4 | = | Partially reconciled
5 | = | Reconciled
6 | = | Pending Journal
7 | = | Posted
8 | = | Purged
RECERR | 23 | BCD*10.3 | Reconciliation Error | E A |
RECERRPEND | 24 | BCD*10.3 | Reconciliation Error Pending | E A |
RECEXGAIN | 25 | BCD*10.3 | Reconciliation Exchange Gain | E A |
RECEXLOSS | 26 | BCD*10.3 | Reconciliation Exchange Loss | E A |
RECAMOUNT | 27 | BCD*10.3 | Reconciliation Deposit Amount | E A |
RECOUTSTND | 28 | BCD*10.3 | Reconciliation In Transit Amt | E A |
SUMMARY | 29 | Integer | Transaction Recorded in Summary | E A | List: 4 entries
0 | = | Detail
1 | = | Summary
2 | = | Transfer
3 | = | Bank Error
RECCCC | 30 | BCD*10.3 | Reconciliation Credit Card Charge | E A |
RECCLEARED | 31 | BCD*10.3 | Amount Cleared | E A |
RECFUNCAMT | 32 | BCD*10.3 | Functional Transaction Amount | E A |
TOTFUNCAMT | 33 | BCD*10.3 | Functional Transaction Total | E A |
TOCLEAR | 34 | BCD*10.3 | Reconciliation Cleared Amount | E A |
TOWRITEOFF | 35 | BCD*10.3 | Write-Off Amount | E A |
TOREMAIN | 36 | BCD*10.3 | In Transit Amount | E A |
VARIANCE | 37 | Integer | Variance Type | E A | 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 | 38 | Long | Lines Can Reverse Invoice | E A |
POSTDATE | 39 | Date | Default Posting Date | E A |
RECSTATUS | 40 | Integer | Default Reconciliation Status | E A | 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 | 41 | String*60 | Default Reconciliation Desc. | E A |
LINESJOUR | 42 | Long | Lines Journalled | E A |
LINESPUR | 43 | Long | Lines Purged | E A |
TOCLEARF | 44 | BCD*10.3 | Clear To Future Period | E A |
RECFCLR | 45 | BCD*10.3 | Fiscal Cleared To Future | E A |
RECRCLR | 46 | BCD*10.3 | Fiscal Cleared To Current | E A |
COMPLETED | 47 | Integer | Reconciled and Journaled Transaction | E A | List: 2 entries
0 | = | Not Completed
10 | = | Completed
RECWOSUMR | 48 | BCD*10.3 | Current Period's Write-Off | E A |
TOCLEARR | 49 | BCD*10.3 | Clear To Reconciliation Period | E A |
RECRWOSUM | 50 | BCD*10.3 | Fiscal Write-Off To This Period | E A |
RECPREM | 51 | BCD*10.3 | Fiscal Remaining Outstanding | E A |
RECTWO | 52 | BCD*10.3 | Total Delta Write Offs | E A |
RECTERR | 53 | BCD*10.3 | Total Delta Bank Errors | E A |
RECTGAIN | 54 | BCD*10.3 | Total Delta Exchange Gain | E A |
RECTLOSS | 55 | BCD*10.3 | Total Delta Exchange Loss | E A |
RECTCCC | 56 | BCD*10.3 | Total Delta Credit Card Charge | E A |
RECTCLR | 57 | BCD*10.3 | Total Delta Cleared | E A |
RECTFUNAM | 58 | BCD*10.3 | Total Delta Functional Amount | E A |
CURFUNC | 59 | String*3 | Functional Currency | E A |
CURSTMT | 60 | String*3 | Statement Currency | E A |
RECWOSUM | 61 | BCD*10.3 | Reconciliation Write Off Sum | E A |
POSTYEAR | 62 | String*4 | Reconciliation posting Year | E A | Mask: %04D
POSTPERIOD | 63 | Integer | Reconciliation posting Period | E A |
RECDELTA | 64 | BCD*10.3 | Reconciliation Delta | E A |
RECFCMISC | 65 | BCD*10.3 | Fiscal Miscellaneous Entry | E A |
RECFCWMISC | 66 | BCD*10.3 | Withdrawal Misc. Entries To Fiscal Period | E A |
RECFCDMISC | 67 | BCD*10.3 | Deposit Misc. Entries To Fiscal Period | E A |
RECFWMISC | 68 | BCD*10.3 | Withdrawal Misc. Entries To Future Period | E A |
RECFDMISC | 69 | BCD*10.3 | Deposit Misc. Entries To Future Period | E A |
PAYORNAME | 70 | String*60 | Payment Payee Name | E A |
VENDORNAME | 71 | String*60 | Payment Vendor Name | E A |
ENTRYNBR | 72 | String*22 | Bank Entry/Transfer Number | E A |
LINESPROC | 73 | Long | Lines Processed | E A |
REVINVC | 74 | Integer | Reverse Invoice | E A | List: 2 entries
0 | = | No
1 | = | Yes
GLACCOUNT | 75 | String*45 | G/L Account of Discrepancy | E A |

This page was generated on 2009-Nov-19

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