# 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

## Fields: 70

Field | Index | Type | Title | Attributes | Presentation
--- | --- | --- | --- | --- | ---
BANK | 1 | String*8 | Bank Code | E A |
SERIAL | 2 | Long | 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: 12 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
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*5.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 | Long | 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 |
CCTYPE | 42 | String*12 | Credit Card Type | E A X |
CCNUMBER | 43 | Binary*32 | Credit Card Number | E A X |
CCNAME | 44 | String*60 | Cardholder Name | E A X |
CCAUTHCODE | 45 | String*20 | Authorization Code | E A X |
CCEXP | 46 | Date | Expiry Date | 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 |

This page was generated on 2009-Nov-19

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