# View: Bank Transaction Header

RotoID: BK0845
Table: BKTRANH
Protocol: Detail, Ordered revisions, Key auto generate
DLL: BKTRANH

## Compositions: 2

RotoID | Tables | Title | DLL
--- | --- | --- | ---
BK0001 | BKACCT | Banks | BKACCT
BK0840 | BKTRAND | Bank Transaction Details | BKTRAND

## Keys: 5

Title | Fields
--- | ---
Bank Transaction Uniquifier | BANK, SERIAL
Bank Transaction Old Serial | BANK, TRANSTYPE, OLDSERIAL
Bank Fiscal Transaction | BANK, FSCYEAR, FSCPERIOD, SERIAL
Bank Transaction Date | BANK, TRANSDATE, SERIAL
Bank Transaction Number | BANK, TRANSNUM, SERIAL

## Fields: 114

Field | Index | Type | Title | Attributes | Presentation
--- | --- | --- | --- | --- | ---
BANK | 1 | String*8 | Bank Code | E A K R | Mask: %-8N
SERIAL | 2 | Long | Transaction Header Serial | E A K R |
TRANSNUM | 3 | BCD*5.0 | Transaction Number | E A |
SRCEAPP | 4 | String*2 | Source Application | E A | Mask: %-2N
TRANSTYPE | 5 | Integer | Transaction Type | E A X | List: 2 entries
1 | = | Withdrawals
2 | = | Deposits
OLDSERIAL | 6 | Long | Old Serial Number | E A |
ENTRYTYPE | 7 | Integer | Entry Type | E A X | List: 7 entries
1 | = | Bank Entered
2 | = | Miscellaneous
3 | = | Subledger
4 | = | Transfer
5 | = | Returned Customer Check
6 | = | Alignment
7 | = | Non Negotiable
REFERENCE | 8 | String*60 | Transaction Reference | E A X |
DESC | 9 | String*60 | Transaction Description | E A X |
TRANSDATE | 10 | Date | Transaction Date | E A X |
FSCYEAR | 11 | String*4 | Fiscal Year | E A X | Mask: %04D
FSCPERIOD | 12 | Integer | Fiscal Period | E A P X | 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 | 13 | Integer | Transaction Slip Printed | E A | List: 2 entries
0 | = | No
1 | = | Yes
TOTAMOUNT | 14 | BCD*10.3 | Transaction Total | A C |
TOTBALAMT | 15 | BCD*10.3 | Transaction Total in Statement | A C |
TOTCLEARED | 16 | BCD*10.3 | Fiscal Transaction Total | A C |
NXTLINE | 17 | Long | Next Transaction Detail Line | E A C |
LINES | 18 | Long | Lines | E A C |
LINESPOST | 19 | Long | Lines Outstanding | E A C |
LINESREC | 20 | Long | Lines Reconciled | E A C |
STATUS | 21 | Integer | Transaction Status | A C | List: 8 entries
1 | = | Not posted
2 | = | Partially Outstanding
3 | = | Outstanding
4 | = | Partially reconciled
5 | = | Reconciled
6 | = | Pending Journal
7 | = | Posted
8 | = | Purged
RECERR | 22 | BCD*10.3 | Reconciliation Error | E A C |
RECERRPEND | 23 | BCD*10.3 | Reconciliation Error Pending | E A C |
RECEXGAIN | 24 | BCD*10.3 | Reconciliation Exchange Gain | E A C |
RECEXLOSS | 25 | BCD*10.3 | Reconciliation Exchange Loss | E A C |
RECAMOUNT | 26 | BCD*10.3 | Reconciliation Amount | E A C |
RECOUTSTND | 27 | BCD*10.3 | Reconciliation Outstanding Amt | E A C |
SUMMARY | 28 | Integer | Transaction Recorded in Summary | E A X | List: 4 entries
0 | = | Detail
1 | = | Summary
2 | = | Transfer
3 | = | Bank Error
RECCCC | 29 | BCD*10.3 | Reconciliation Credit Card Charge | E A C |
RECCLEARED | 30 | BCD*10.3 | Amount Cleared | E A C |
RECFUNCAMT | 31 | BCD*10.3 | Functional Transaction Amount | E A C |
TOTFUNCAMT | 32 | BCD*10.3 | Functional Transaction Total | A C |
TOCLEAR | 33 | BCD*10.3 | Reconciliation Cleared Amount | A X |
TOWRITEOFF | 34 | BCD*10.3 | Write-Off Amount | A X |
TOREMAIN | 35 | BCD*10.3 | Outstanding Amount | A X |
VARIANCE | 36 | Integer | Variance Type | A P X | List: 1 entries
0 | = | None
LINESREVIN | 37 | Long | Lines Can Reverse Invoice | A C |
POSTDATE | 38 | Date | Reconciliation Date | A X |
RECSTATUS | 39 | Integer | Reconciliation Status | E A P X | List: 5 entries
1 | = | Not Posted
2 | = | Void
9 | = | Printed
7 | = | Non-negotiable
8 | = | Continuation
RECCOMMENT | 40 | String*60 | Reconciliation Description | A X |
LINESJOUR | 41 | Long | Lines Journalled | A C |
LINESPUR | 42 | Long | Lines Purged | A C |
LINESPROC | 43 | Long | Lines Processed | A C |
TOCLEARF | 44 | BCD*10.3 | Clear To Future Period | A |
RECFCLR | 45 | BCD*10.3 | Fiscal Cleared To Future | E A C |
RECRCLR | 46 | BCD*10.3 | Fiscal Cleared To Current | E A C |
COMPLETED | 47 | Integer | Reconciled and Journaled Transaction | E A X | List: 2 entries
0 | = | Not Completed
10 | = | Completed
PAYORNAME | 48 | String*60 | Payment Payee Name | E A C |
VENDORNAME | 49 | String*60 | Payment Vendor Name | E A X |
ENTRYNBR | 50 | String*22 | Bank Entry/Transfer Number | E A | Mask: %-22C
LINESCCC | 51 | Long | Lines Credit Card | E A C |
LINESEXCH | 52 | Long | Lines Exchange Difference | E A C |
REVINVC | 53 | Integer | Reverse Invoice | A X | List: 2 entries
0 | = | No
1 | = | Yes
RECWOSUMR | 114 | BCD*10.3 | Current Period's Write-Off | A C |
TOCLEARR | 115 | BCD*10.3 | Clear To Reconciliation Period | A C |
RECRWOSUM | 116 | BCD*10.3 | Fiscal Write-Off To This Period | E A C |
RECPREM | 117 | BCD*10.3 | Fiscal Remaining Outstanding | E A C |
RECTWO | 118 | BCD*10.3 | Total Delta Write Offs | E A C |
RECTERR | 119 | BCD*10.3 | Total Delta Bank Errors | E A C |
RECTGAIN | 120 | BCD*10.3 | Total Delta Exchange Gain | E A C |
RECTLOSS | 121 | BCD*10.3 | Total Delta Exchange Loss | E A C |
RECTCCC | 122 | BCD*10.3 | Total Delta Credit Card Charge | E A C |
RECTCLR | 123 | BCD*10.3 | Total Delta Cleared | E A C |
RECTFUNAM | 124 | BCD*10.3 | Total Delta Functional Amount | E A C |
CURFUNC | 125 | String*3 | Functional Currency | A |
CURSTMT | 126 | String*3 | Statement Currency | A |
RECWOSUM | 127 | BCD*10.3 | Reconciliation Write Off Sum | A C |
POSTYEAR | 128 | String*4 | Reconciliation posting Year | E A X | Mask: %04D
POSTPERIOD | 129 | Integer | Reconciliation posting Period | E A P X |
SUMDEPOSIT | 130 | BCD*10.3 | Total Deposits | A C |
RECINTRANS | 131 | BCD*10.3 | Deposits in Transit | A C |
FUNDTAMT | 132 | BCD*10.3 | Deposit Functional Total | A C |
RECDTWOSUM | 133 | BCD*10.3 | Sum of Deposit Total Write Offs | A C |
RECDTERR | 134 | BCD*10.3 | Total Deposit Bank Errors | A C |
RECDTGAIN | 135 | BCD*10.3 | Total Deposit Exchange Gain | A C |
RECDTLOSS | 136 | BCD*10.3 | Total Deposit Exchange Loss | A C |
RECDTCCC | 137 | BCD*10.3 | Total Deposit Credit Card Charges | A C |
RECDTCLR | 138 | BCD*10.3 | Total Deposit Cleared | A C |
RECDPWOSUM | 139 | BCD*10.3 | Fiscal Deposit Write-Off To This Period | A C |
RECDPERR | 140 | BCD*10.3 | Fiscal Deposit Bank Errors | A C |
RECDPGAIN | 141 | BCD*10.3 | Fiscal Deposit Exchange Gain | A C |
RECDPLOSS | 142 | BCD*10.3 | Fiscal Deposit Exchange Loss | A C |
RECDPCCC | 143 | BCD*10.3 | Fiscal Deposit Credit Card Charges | A C |
RECDPCLR | 144 | BCD*10.3 | Fiscal Deposit Cleared | A C |
RECDEXDIFF | 145 | BCD*10.3 | Deposit Cleared with Exchange Rate Diff | A C |
RECFCDEPIT | 146 | BCD*10.3 | Deposits In Transit To Fisc.Per. | A C |
RECDFCLR | 147 | BCD*10.3 | Fiscal Deposit Cleared To Future | A C |
SUMCHECK | 148 | BCD*10.3 | Total Checks | A C |
RECWOUTSTD | 149 | BCD*10.3 | Checks Outstanding | A C |
FUNWTAMT | 150 | BCD*10.3 | Withdrawal Functional Total | A C |
RECWTWOSUM | 151 | BCD*10.3 | Sum of Withdrawal Total Write Offs | A C |
RECWTERR | 152 | BCD*10.3 | Total Withdrawal Bank Errors | A C |
RECWTGAIN | 153 | BCD*10.3 | Total Withdrawal Exchange Gain | A C |
RECWTLOSS | 154 | BCD*10.3 | Total Withdrawal Exchange Loss | A C |
RECWTCCC | 155 | BCD*10.3 | Total Withdrawal Credit Card Charges | A C |
RECWTCLR | 156 | BCD*10.3 | Total Withdrawal Cleared | A C |
RECWPWOSUM | 157 | BCD*10.3 | Fiscal Withdrawal Write-Off To This Period | A C |
RECWPERR | 158 | BCD*10.3 | Fiscal Withdrawal Bank Errors | A C |
RECWPGAIN | 159 | BCD*10.3 | Fiscal Withdrawal Exchange Gain | A C |
RECWPLOSS | 160 | BCD*10.3 | Fiscal Withdrawal Exchange Loss | A C |
RECWPCCC | 161 | BCD*10.3 | Fiscal Withdrawal Credit Card Charges | A C |
RECWPCLR | 162 | BCD*10.3 | Clear To Reconciliation Period | A C |
RECWEXDIFF | 163 | BCD*10.3 | Checks Cleared with Exch. Rate Diff. | A C |
RECFCCHKOS | 164 | BCD*10.3 | Checks Outstanding To Fisc.Per. | A C |
RECWFCLR | 165 | BCD*10.3 | Fiscal Withdrawal Cleared To Future | A C |
RECFCMISC | 166 | BCD*10.3 | Fiscal Miscellaneous Entry | A C |
RECFCWMISC | 167 | BCD*10.3 | Payment Misc. Entries To Fiscal Period | A C |
RECFCDMISC | 168 | BCD*10.3 | Deposit Misc. Entries To Fiscal Period | A C |
RECFWMISC | 169 | BCD*10.3 | Payment Misc. Entries To Future Period | A C |
RECFDMISC | 170 | BCD*10.3 | Deposit Misc. Entries To Future Period | A C |
RECPDEPB | 171 | BCD*10.3 | Fiscal Deposit Book Amount | A C |
RECPCHKB | 172 | BCD*10.3 | Fiscal Withdrawal Book Amount | A C |
DTLACCESS | 173 | Integer | Detail Access Portal | E A X | List: 2 entries
0 | = | No
1 | = | Yes
RECDELTA | 174 | BCD*10.3 | Reconciliation Delta | A C |

This page was generated on 2009-Nov-19

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