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: 6

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, COMPLETED, TRANSDATE, SERIAL
Bank Transaction Number BANK, TRANSNUM, SERIAL
Bank Transaction Completed BANK, COMPLETED, TRANSNUM, SERIAL

Fields: 117

Field Index Type Title Attributes Presentation
BANK 1 String*8 Bank Code E A K R  Mask: %-8N
SERIAL 2 ??? Transaction Header Serial E A K R 
TRANSNUM 3 BCD*8.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 ??? 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
AMTDTLREC 54 BCD*10.3 Reconcile by Detail Reconciled E A C 
AMTDTLOUT 55 BCD*10.3 Reconcile by Detail Outstanding E A C 
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 
PROCESSCMD 175 Integer Process Command Code E A C  List:3 entries
0 = Sum Details
1 = Apply Details Cleared
2 = Apply Details Outstanding

This page was generated on 2022-Aug-18

© 2021 Sage Software, Inc. All rights reserved. Reproduction of part or all of the contents in any form is prohibited unless for personal use. None of the content of this article may be copied or otherwise incorporated into any other document, publication or other work in any form (whether written, electronic or other format).

Sage Software, Inc. makes no warranties, representations or undertakings about any of the content of articles (including, without limitation, any as to the quality, accuracy, completeness or fitness for any particular purpose of such content).