View: Bank Transaction Portal Superview

RotoID: BK0850

Protocol: Superview
DLL:BKTRANS

Compositions: 3

RotoID Tables Title DLL
BK0001 BKACCT Banks BKACCT
BK0840 BKTRAND Bank Transaction Details BKTRAND
BK0845 BKTRANH Bank Transaction Header BKTRANH

Keys: 0

Title Fields

Fields: 68

Field Index Type Title Attributes Presentation
BANK 1 String*8 Bank Code E A 
SERIAL 2 ??? Transaction Header Serial E A 
LINE 3 Long Transaction Detail Line E A 
SRCEAPP 4 String*2 Source Application E A 
OPCODE 5 Integer Operation E A  List:17 entries
1 = Create Header
2 = Create Detail
3 = Update
4 = Read
5 = Read Detail
6 = Fetch Detail
7 = Delete Detail
8 = Delete Header
9 = Create Bank Entered Transaction
10 = Create Miscellaneous Entry
11 = Create a Reversal Entry
12 = Create Withdrawal
13 = Get the highest transaction number
14 = Get the lowest transaction number
15 = Get the number of transactions
20 = Get the highest and lowest transaction numbers
21 = Clear the range of transactions
TRANSTYPE 6 Integer Transaction Type E A  List:2 entries
1 = Withdrawals
2 = Deposits
ENTRYTYPE 7 Integer Entry Type E A  List:4 entries
1 = Bank Entered
3 = Subledger
4 = Transfer
5 = Returned Customer Check
TRANSNUM 8 BCD*8.0 Transaction Number E A 
TRANSDATE 9 Date Transaction Date E A X 
HREFERENCE 10 String*60 Transaction Reference E A X 
DESC 11 String*60 Transaction Description E A X 
HSTATUS 12 Integer Transaction Status A C 
HRECSTATUS 13 Integer Default Reconciliation Status E A P X 
OLDSERIAL 14 ??? Old Serial Number E A 
LINESREC 15 Long Lines Reconciled E A X 
LINESJOUR 16 Long Lines Journalled E A X 
LINESPROC 17 Long Lines Processed E A X 
TOCLEAR 18 BCD*10.3 Reconciliation Cleared Amount E A X 
STATUS 19 Integer Receipt Status E A X 
TYPE 20 Integer Detail Transaction Type E A X  List:7 entries
1 = Check
2 = EFT
3 = Transfer
4 = Service Charge
5 = Credit Card
6 = Cash
7 = Other
IDREMIT 21 String*24 Remittance ID E A X 
DATEREMIT 22 Date Transaction Date E A X 
BATCHNBR 23 BCD*5.0 Batch Number E A X 
ENTRYNBR 24 BCD*4.0 Entry Number E A X 
POSTSEQ 25 BCD*5.0 Posting Sequence Number E A X 
REFERENCE 26 String*60 Transaction Reference E A X 
COMMENT 27 String*60 Transaction Description E A X 
RECSTATUS 28 Integer Reconciliation Status E A P X 
PAYORID 29 String*12 Payer Code E A X 
PAYORNAME 30 String*60 Payee Name E A X 
VENDORNAME 31 String*60 Vendor Name E A X 
SRCEAMOUNT 32 BCD*10.3 Source Amount E A X 
FUNCAMOUNT 33 BCD*10.3 Functional Amount E A X 
RATETYPE 34 String*2 Exchange Rate Type E A X 
SRCECURN 35 String*3 Receipt Currency E A X 
RATEDATE 36 Date Exchange Rate Date E A X 
RATE 37 BCD*8.7 Exchange Rate E A X 
RATESPREAD 38 BCD*8.7 Rate Spread E A X 
RATEOP 39 Integer Rate Operation E A X 
DISTCODE 40 String*6 Distribution Code E A X 
GLACCOUNT 41 String*45 G/L Account E A X 
DDTYPE 47 Integer Drilldown Type E A 
DDLINK 48 BCD*10.0 Drilldown Link E A 
PAYMCODE 49 String*12 Payment Code E A X 
CHKFORM 50 String*6 Check Stock Code E A R X 
OFXTID 51 String*50 OFX Transaction ID E A X 
FSCYEAR 52 String*4 Fiscal Year E A X 
FSCPERIOD 53 Integer Fiscal Period E A P X 
SRCEDOCNUM 54 String*22 Source Document Number E A X 
CANREVINVC 55 Integer Can Reverse Invoice E A X 
REVINVC 56 Integer Reverse Invoice E A X 
DCODEDESC 57 String*60 Distribution Code Description A 
GLACCOUNTD 58 String*60 G/L Account Description A 
POSTDATE 59 Date Reconciliation Posting Date E A X 
POSTYEAR 60 String*4 Reconciliation Posting Year E A X 
POSTPERIOD 61 Integer Reconciliation Posting Period E A P X 
CURFUNC 62 String*3 Functional Currency A 
CURSTMT 63 String*3 Statement Currency A 
COMPLETED 64 Integer Reconciled and Journaled Transaction E A X 
PSTSEQ 65 BCD*5.0 Posting Sequence E A 
RECONCILED 66 Boolean Reconciled E A X 
POSTED 67 Date Document Posted Date E A X 
SUMAMOUNT 68 BCD*10.3 Summated Transaction Amount A C 
CURNAME 69 String*60 Source Currency Description A 
RESULTCODE 70 Integer Process Result Code E A 
QCFROMTRAN 71 BCD*8.0 Reconcile From Transaction E A 
QCTOTRAN 72 BCD*8.0 Reconcile To Transaction E A 
QCSTATUS 73 Integer Reconcile To Status E A P  List:3 entries
0 = Cleared
1 = Outstanding
2 = Reversed

This page was generated on 2021-Nov-24

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