View: Banks

RotoID: BK0001
Table: BKACCT
Protocol: Header
DLL:BKACCT

Compositions: 11

RotoID Tables Title DLL
BK0002 BKCUR Bank Currencies BKCUR
BK0998 GENSTUB
BK0845 BKTRANH Bank Transaction Header BKTRANH
BK0997 GENSTUB
BK0996 GENSTUB
BK0008 BKFORM Check Stocks BKFORM
BK0003 BKTT Bank Distribution Codes BKTT
GL0001 GLAMF Accounts GLAMF
CS0003 CSCCD Currency Codes CSCCD
BK0870 BKUNMAT OFX Transactions BKUNMAT
BK0840 BKTRAND Bank Transaction Details BKTRAND

Keys: 1

Title Fields
Bank Code BANK

Fields: 148

Field Index Type Title Attributes Presentation
BANK 1 String*8 Bank Code E A K R  Mask: %-8N
NAME 2 String*60 Description E A 
ADDR1 3 String*60 Address Line 1 E A 
ADDR2 4 String*60 Address Line 2 E A 
ADDR3 5 String*60 Address Line 3 E A 
ADDR4 6 String*60 Address Line 4 E A 
CITY 7 String*30 City E A 
STATE 8 String*30 State/Province E A 
COUNTRY 9 String*30 Country E A 
POSTAL 10 String*20 Zip/Postal Code E A 
CONTACT 11 String*60 Contact E A 
PHONE 14 String*30 Phone Number E A P  Mask: (%-3C) %-3C-%-24C
FAX 15 String*30 Fax Number E A P  Mask: (%-3C) %-3C-%-24C
TRANSIT 16 String*12 Transit Number E A  Mask: %-12D
MULTICUR 17 Boolean Multicurrency E A X  List:2 entries
0 = No
1 = Yes
CURNSTMT 18 String*3 Statement Currency A X  Mask: %-3N
INACTIVE 19 Boolean Status E A  List:2 entries
0 = Active
1 = Inactive
INACTDATE 20 Date Inactive Date A C 
BKACCT 21 String*22 Bank Account Number E A 
IDACCT 23 String*45 Bank Account E A  Mask: %-45C
IDACCTERR 24 String*45 Write-Off Account E A  Mask: %-45C
ERRSPREAD 25 BCD*10.3 Error Spread E A 
LSTMNTND 26 Date Last Maintained A C 
RECFY 27 String*4 Fiscal Year A  Mask: %04D
RECFP 28 Integer Fiscal Period A P  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
RECLSTFY 29 String*4 Last Reconciliation Year E A C 
RECLSTFP 30 Integer Last Reconciliation Period E A C 
RECLSTDATE 31 Date Last Reconciliation Date E A 
RECLSTBAL 32 BCD*10.3 Last Closing Statement Balance E A 
RECDATE 33 Date Reconciliation Date E A 
RECSTMTDAT 34 Date Statement Date E A 
RECSTMTBAL 35 BCD*10.3 Statement Balance E A 
RECINTRANS 36 BCD*10.3 Deposits in Transit E A C 
RECOUTSTND 37 BCD*10.3 Checks Outstanding E A C 
RECBKERRPN 38 BCD*10.3 Bank Errors A C 
RECBKENT 39 BCD*10.3 Total Not Posted Bank Entries E A C 
RECBKERR 40 BCD*10.3 Write-Offs A C 
RECEXGAIN 41 BCD*10.3 Exchange Gain A C 
RECEXLOSS 42 BCD*10.3 Exchange Loss A C 
RECDEPOSIT 43 BCD*10.3 Total Deposits E A C 
RECCHECK 44 BCD*10.3 Total Checks E A C 
RECFCDEP 45 BCD*10.3 Deposits To Fiscal Period E A C 
RECFCCHK 46 BCD*10.3 Checks To Fiscal Period E A C 
RECFCDEPIT 47 BCD*10.3 Deposits In Transit To Fisc.Per. E A C 
RECFCCHKOS 48 BCD*10.3 Checks Outstanding To Fisc.Per. E A C 
RECRECALC 49 Boolean Calculate Fiscal Period Data E A C  List:2 entries
0 = Fiscal balances are up to date.
1 = Fiscal balances need to be recalculated.
RECLSMDATE 50 Date Last Statement Date E A 
RECFCBKENT 51 BCD*10.3 Difference of Bank Entries To Fiscal Period E A C 
RECFCGAIN 52 BCD*10.3 Exchange Gain To Fiscal Period A C 
RECFCLOSS 53 BCD*10.3 Exchange Loss To Fiscal Period A C 
RECFCERRPN 54 BCD*10.3 Bank Error Pending To Fiscal Period A C 
RECFCERR 55 BCD*10.3 Bank Error To Fiscal Period A C 
RECFCENTRE 56 BCD*10.3 Total Not Posted Bank Entries To Fiscal Period E A C 
IDACCTCCC 57 String*45 Charges Account E A  Mask: %-45C
CCCSPREAD 58 BCD*10.3 Credit Card Charge Spread E A 
EXSPREAD 59 BCD*10.3 Exchange Rate Difference Spread E A 
ADJBOOKBAL 70 BCD*10.3 Adjusted Book Balance A C 
ADJSTMTBAL 71 BCD*10.3 Adjusted Statement Balance A C 
BALANCES 72 Boolean Bank Reconciliation Balanced A C 
ADJBALDIFF 73 BCD*10.3 Out Of Balance By A C 
CHKSERIAL 74 ??? Next Check Serial Number E A C 
NXTDEPOSIT 75 BCD*8.0 Next Deposit Slip Number E A C 
DEPSERIAL 76 ??? Next Deposit Uniquifier E A C 
RECAVAIL 77 BCD*10.3 Current Balance A C 
RECBOOKBAL 78 BCD*10.3 Book Balance A C 
CURRTYPE 79 Integer Bank Statement Type A C  List:4 entries
0 = Invalid
1 = Single
2 = Multiple
3 = Foreign
RECTWO 80 BCD*10.3 Total Write Offs A C 
RECTCCC 81 BCD*10.3 Total Credit Card Charges A C 
RECPWO 82 BCD*10.3 Fiscal Period Write Off A C 
RECPCCC 83 BCD*10.3 Fiscal Period Credit Card Charges A C 
RECWTWOSUM 84 BCD*10.3 Sum of Withdrawal Total Write Offs A C 
RECDTWOSUM 85 BCD*10.3 Sum of Deposit Total Write Offs A C 
RECWPWOSUM 86 BCD*10.3 Sum of Withdrawal Fiscal Write Offs A C 
RECDPWOSUM 87 BCD*10.3 Sum of Deposit Fiscal Write Offs A C 
CURFUNC 88 String*3 Functional Currency A 
RECWTREM 89 BCD*10.3 Total Remaining OutStanding A C 
RECWPREM 90 BCD*10.3 Fiscal Remaining OutStanding A C 
RECDTREM 91 BCD*10.3 Total Remaining In Transit A C 
RECDPREM 92 BCD*10.3 Fiscal Remaining In Transit A C 
RECWRCLR 93 BCD*10.3 Fiscal Withdrawal Cleared To Current A C 
RECDRCLR 94 BCD*10.3 Fiscal Deposit Cleared To Current A C 
TXGRPDESC 95 String*60 Tax Group Description E A 
TXAUTDESC1 96 String*60 Tax Authorization Description 1 E A 
TXAUTDESC2 97 String*60 Tax Authorization Description 2 E A 
TXAUTDESC3 98 String*60 Tax Authorization Description 3 E A 
TXAUTDESC4 99 String*60 Tax Authorization Description 4 E A 
TXAUTDESC5 100 String*60 Tax Authorization Description 5 E A 
TXCLSDESC1 101 String*60 Vendor Tax Class Description 1 E A 
TXCLSDESC2 102 String*60 Vendor Tax Class Description 2 E A 
TXCLSDESC3 103 String*60 Vendor Tax Class Description 3 E A 
TXCLSDESC4 104 String*60 Vendor Tax Class Description 4 E A 
TXCLSDESC5 105 String*60 Vendor Tax Class Description 5 E A 
NEXTSERIAL 106 ??? Next Serial Number E A C 
RECDEXDIFF 107 BCD*10.3 Deposit Cleared with Exchange Rate Diff E A C 
RECWEXDIFF 108 BCD*10.3 Withdrawals Cleared with Exch. Rate Diff. E A C 
RECWTERR 150 BCD*10.3 Total Withdrawal Bank Errors E A C 
RECWTWO 151 BCD*10.3 Total Withdrawal Write Offs E A C 
RECWTGAIN 152 BCD*10.3 Total Withdrawal Exchange Gain E A C 
RECWTLOSS 153 BCD*10.3 Total Withdrawal Exchange Loss E A C 
RECWTCCC 154 BCD*10.3 Total Withdrawal Credit Card Charges E A C 
RECWTCLR 155 BCD*10.3 Total Withdrawal Cleared E A C 
RECWTFUNAM 156 BCD*10.3 Withdrawal Total E A C 
RECWPERR 157 BCD*10.3 Fiscal Withdrawal Bank Errors E A C 
RECWPWO 158 BCD*10.3 Fiscal Withdrawal Write Offs E A C 
RECWPGAIN 159 BCD*10.3 Fiscal Withdrawal Exchange Gain E A C 
RECWPLOSS 160 BCD*10.3 Fiscal Withdrawal Exchange Loss E A C 
RECWPCCC 161 BCD*10.3 Fiscal Withdrawal Credit Card Charges E A C 
RECWPCLR 162 BCD*10.3 Fiscal Withdrawal Cleared E A C 
RECWPFUNAM 163 BCD*10.3 Fiscal Withdrawal Total E A C 
RECDTERR 164 BCD*10.3 Total Deposit Bank Errors E A C 
RECDTWO 165 BCD*10.3 Total Deposit Write Offs E A C 
RECDTGAIN 166 BCD*10.3 Total Deposit Exchange Gain E A C 
RECDTLOSS 167 BCD*10.3 Total Deposit Exchange Loss E A C 
RECDTCCC 168 BCD*10.3 Total Deposit Credit Card Charges E A C 
RECDTCLR 169 BCD*10.3 Total Deposit Cleared E A C 
RECDTFUNAM 170 BCD*10.3 Deposit Total E A C 
RECDPERR 171 BCD*10.3 Fiscal Deposit Bank Errors E A C 
RECDPWO 172 BCD*10.3 Fiscal Deposit Write Offs E A C 
RECDPGAIN 173 BCD*10.3 Fiscal Deposit Exchange Gain E A C 
RECDPLOSS 174 BCD*10.3 Fiscal Deposit Exchange Loss E A C 
RECDPCCC 175 BCD*10.3 Fiscal Deposit Credit Card Charges E A C 
RECDPCLR 176 BCD*10.3 Fiscal Deposit Cleared E A C 
RECDPFUNAM 177 BCD*10.3 Fiscal Deposit Total E A C 
RECWFCLR 178 BCD*10.3 Fiscal Withdrawal Cleared To Future E A C 
RECDFCLR 179 BCD*10.3 Fiscal Deposit Cleared To Future E A C 
FUNWTAMT 180 BCD*10.3 Withdrawal Functional Total E A C 
FUNWPAMT 181 BCD*10.3 Fiscal Withdrawal Functional Total E A C 
FUNDTAMT 182 BCD*10.3 Deposit Functional Total E A C 
FUNDPAMT 183 BCD*10.3 Fiscal Deposit Functional Total E A C 
CODETXGRP 184 String*12 Tax Group Code E A  Mask: %-12N
TAXAUTH1 185 String*12 Tax Authorization 1 A 
TAXAUTH2 186 String*12 Tax Authorization 2 A 
TAXAUTH3 187 String*12 Tax Authorization 3 A 
TAXAUTH4 188 String*12 Tax Authorization 4 A 
TAXAUTH5 189 String*12 Tax Authorization 5 A 
TXVCLSS1 190 Integer Vendor Tax Class 1 E A 
TXVCLSS2 191 Integer Vendor Tax Class 2 E A 
TXVCLSS3 192 Integer Vendor Tax Class 3 E A 
TXVCLSS4 193 Integer Vendor Tax Class 4 E A 
TXVCLSS5 194 Integer Vendor Tax Class 5 E A 
AGEPURGE 195 Integer Days Before Eligible for Clearing E A 
POSTDATE 196 Date Reconciliation Date E A X 
LSTPOSTDAT 197 Date Last Reconciliation Date E A X 
LSTSTMTBAL 198 BCD*10.3 Last Available Statement Balance E A 
RECCOMMENT 199 String*60 Default Reconciliation Description E A X 
BCACCT 200 Binary*32 Banking Cloud Account E A X 
BCCONNECT 201 Boolean Banking Cloud Connected E A X  List:2 entries
0 = No
1 = Yes
BCLSTIDX 202 Long Banking Cloud Last Index E A C 

This page was generated on 2023-Aug-31

© 2023 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).