# View: Bank Transaction Details

RotoID: BK0840
Table: BKTRAND
Protocol: Detail, Ordered revisions, Key auto generate
DLL: BKTRAND

## Compositions: 6

RotoID | Tables | Title | DLL
--- | --- | --- | ---
BK0845 | BKTRANH | Bank Transaction Header | BKTRANH
BK0001 | BKACCT | Banks | BKACCT
CS0004 | CSCRT | Rate Types | CSCRT
BK0002 | BKCUR | Bank Currencies | BKCUR
BK0003 | BKTT | Bank Distribution Codes | BKTT
BK0240 | BKCCTYP | Credit Card Types | BKCCTYP

## Keys: 7

Title | Fields
--- | ---
Bank Transaction Detail | BANK, SERIAL, LINE
Bank Reconciliation Fiscal Trans | BANK, SERIAL, POSTYEAR, POSTPERIOD, LINE
Bank Fiscal Period Transaction | BANK, SERIAL, FSCYEAR, FSCPERIOD, LINE
Header Context Remittance Date | BANK, SERIAL, DATEREMIT, IDREMIT, LINE
Header Context Remiitance ID | BANK, SERIAL, IDREMIT, DATEREMIT, LINE
Transaction Remittance Date | BANK, DATEREMIT, IDREMIT, SERIAL, LINE
Transaction Remiitance ID | BANK, IDREMIT, DATEREMIT, SERIAL, LINE

## Fields: 105

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 |
LINE | 3 | Long | Transaction Detail Line | E A K R |
SRCEAPP | 4 | String*2 | Source Application | E A R X | Mask: %-2N
STATUS | 5 | Integer | Transaction Detail Status | E A P X | List: 8 entries
1 | = | Not Posted
2 | = | Void
3 | = | Outstanding
6 | = | Cleared with bank error
4 | = | Reversed
7 | = | Non-negotiable
8 | = | Continuation
9 | = | Printed
TRANSTYPE | 6 | Integer | Transaction Type | E A R X | List: 2 entries
1 | = | Withdrawals
2 | = | Deposits
TYPE | 7 | 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 | 8 | String*24 | Remittance ID | E A X |
DATEREMIT | 9 | Date | Transaction Date | E A X |
BTCHNBR | 10 | BCD*5.0 | Batch Number | E A X |
ENTRYNBR | 11 | BCD*4.0 | Entry Number | E A X |
POSTSEQ | 12 | BCD*5.0 | Posting Sequence Number | E A X |
REFERENCE | 13 | String*60 | Transaction Reference | E A X |
COMMENT | 14 | String*60 | Transaction Description | E A X |
PAYORID | 15 | String*12 | Payer Code | E A X | Mask: %-12C
PAYORNAME | 16 | String*60 | Payee Name | E A X |
VENDORNAME | 17 | String*60 | Vendor Name | E A X |
SRCEAMOUNT | 18 | BCD*10.3 | Source Transaction Amount | E A X |
FUNCAMOUNT | 19 | BCD*10.3 | Functional Transaction Amount | E A X |
RATETYPE | 20 | String*2 | Exchange Rate Type | E A X | Mask: %-2N
SRCECURN | 21 | String*3 | Receipt Currency | E A X | Mask: %-3N
RATEDATE | 22 | Date | Exchange Rate Date | E A X |
RATE | 23 | BCD*8.7 | Exchange Rate | E A X |
RATESPREAD | 24 | BCD*8.7 | Rate Spread | E A X |
RATEOP | 25 | Integer | Rate Operation | E A X | List: 3 entries
1 | = | Multiply
2 | = | Divide
0 | = | Not Specified
DISTCODE | 26 | String*6 | Distribution Code | A X | Mask: %-6N
GLACCOUNT | 27 | String*45 | G/L Account | A X | Mask: %-45C
CCTYPE | 28 | String*12 | Credit Card Type | A X | Mask: %-12N
CCNUMBER | 29 | Binary*32 | Credit Card Number | A X |
CCNAME | 30 | String*60 | Cardholder Name | A X |
CCAUTHCODE | 31 | String*20 | Authorization Code | A X |
CCEXP | 32 | Date | Expiry Date | A X |
DDTYPE | 33 | Integer | Drilldown Type | E A |
DDLINK | 34 | BCD*10.0 | Drilldown Link | E A |
RECSTATUS | 35 | Integer | Reconciliation Status | A P X | List: 3 entries
1 | = | Not Posted
2 | = | Void
3 | = | Outstanding
RECSTATCHG | 36 | Date | Status Change Date | A C |
RECCOMMENT | 37 | String*60 | Reconciliation Description | A X |
RECCLEARED | 38 | BCD*10.3 | Cleared Amount | A X |
POSTDATE | 39 | Date | Reconciliation Posting Date | A X |
POSTYEAR | 40 | String*4 | Reconciliation Posting Year | A X | Mask: %04D
POSTPERIOD | 41 | Integer | Reconciliation Posting Period | A P X | List: 1 entries
0 | = |
RECONCILED | 42 | Boolean | Reconciled | A |
RECPENDING | 43 | BCD*10.3 | Remaining In Transit Amount | A |
PAYMCODE | 44 | String*12 | Payment Code | E A X |
CHKFORM | 45 | String*6 | Check Stock Code | E A X | Mask: %-6N
OFXTID | 46 | String*50 | OFX Transaction ID | A X |
FSCYEAR | 47 | String*4 | Fiscal Year | E A X | Mask: %04D
FSCPERIOD | 48 | Integer | Fiscal Period | E A P X | List: 13 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
13 | = | 13
REVDATE | 49 | Date | Reversal/Return Date | A X |
SRCEDOCNUM | 50 | String*22 | Source Document Number | E A X |
CANREVINVC | 51 | Integer | Can Reverse Invoice | E A X | List: 2 entries
0 | = | No
1 | = | Yes
REVINVC | 52 | Integer | Reverse Invoice | A X | List: 2 entries
0 | = | No
1 | = | Yes
COMPLETED | 53 | Integer | Reconciled and Journaled Transaction | E A X | List: 2 entries
0 | = | Not Completed
10 | = | Completed
PSTSEQ | 54 | BCD*5.0 | Posting Sequence | E A |
ENTRYTYPE | 55 | Integer | Entry Type | E A X |
POSTED | 56 | Date | Document Posted Date | E A X |
LSTRECSTAT | 57 | Integer | Last Reconciliation Status | E A X |
RECERR | 80 | BCD*10.3 | Reconciliation Error | A C |
RECERRPEND | 81 | BCD*10.3 | Reconciliation Error Pending | A C |
RECEXGAIN | 82 | BCD*10.3 | Reconciliation Exchange Gain | A C |
RECEXLOSS | 83 | BCD*10.3 | Reconciliation Exchange Loss | A C |
RECSUGGEST | 84 | Integer | Reconciliation Suggestion | A C | List: 12 entries
1 | = | Not Posted
2 | = | Void
3 | = | Outstanding
4 | = | Reversed
5 | = | Cleared
6 | = | Cleared with bank error
7 | = | Non-negotiable
8 | = | Continuation
9 | = | Printed
10 | = | Cleared with write-off
11 | = | Cleared with exchange rate difference
12 | = | Cleared with credit card charge
RECAMOUNT | 85 | BCD*10.3 | Transaction Amount | A C |
RECOUTSTND | 86 | BCD*10.3 | Outstanding Amount | A C |
RECTARGET | 87 | Integer | Reconciliation Target | A C | List: 6 entries
0 | = | No Target
1 | = | Bank Error
2 | = | Bank Pending Error
3 | = | Exchange Gain
4 | = | Exchange Loss
5 | = | Credit Card Charge
DCODEDESC | 88 | String*60 | Distribution Code Description | A |
GLACCOUNTD | 89 | String*60 | G/L Account Description | A |
RECDELTA | 90 | BCD*10.3 | Reconciliation Amount Delta | A C |
LINEONE | 91 | Long | Line | A C |
LINEPOST | 92 | Long | Line Outstanding | A C |
LINEREC | 93 | Long | Line Reconciled | A C |
XCCNUMBER | 94 | String*32 | Decrypted Credit Card Number | E A | Mask: %-32D
RECCCC | 95 | BCD*10.3 | Reconciliation Credit Card Charge | A C |
RECWOSUM | 96 | BCD*10.3 | Write-Off Amount | A C |
CURFUNC | 97 | String*3 | Functional Currency | A C |
CURSTMT | 98 | String*3 | Statement Currency | A C |
SUMAMOUNT | 99 | BCD*10.3 | Summated Transaction Amount | A C |
RECSPREAD | 100 | BCD*10.3 | Reconciliation Spread | A C |
RECPAMOUNT | 101 | BCD*10.3 | Fiscal Transaction Remaining In Transit | A C |
RECPOUTSTD | 102 | BCD*10.3 | Fiscal Outstanding Amount | A C |
RECPWO | 103 | BCD*10.3 | Fiscal Write Offs | A C |
RECPERR | 104 | BCD*10.3 | Fiscal Bank Errors | A C |
RECPGAIN | 105 | BCD*10.3 | Fiscal Exchange Gain | A C |
RECPLOSS | 106 | BCD*10.3 | Fiscal Exchange Loss | A C |
RECPCCC | 107 | BCD*10.3 | Fiscal Credit Card Charge | A C |
RECPCLR | 108 | BCD*10.3 | Fiscal Cleared | A C |
RECPFUNAM | 109 | BCD*10.3 | Fiscal Functional Amount | A C |
RECPORIG | 110 | BCD*10.3 | Fiscal Original Transaction Amount | A C |
RECTBOOK | 111 | BCD*10.3 | Total Book Amount | A C |
RECPBOOK | 112 | BCD*10.3 | Fiscal Book Amount | A C |
RECTREMAIN | 113 | BCD*10.3 | Total Remaining Amount | A C |
RECPREMAIN | 114 | BCD*10.3 | Fiscal Remaining Amount | A C |
RECRWOSUM | 115 | BCD*10.3 | Fiscal Write-Off To This Period | A C |
RECFCLR | 116 | BCD*10.3 | Fiscal Cleared To Future | A C |
RECRCLR | 117 | BCD*10.3 | Fiscal Cleared To Current | A C |
RECWOSUMR | 118 | BCD*10.3 | Current Period's Write-Off | A C |
RECFCLRR | 119 | BCD*10.3 | Posted Fiscal Cleared To Future | A C |
AGERECLD | 120 | Integer | No. of Days Since Reconciled | A C |
STMTAMOUNT | 121 | BCD*10.3 | Statement Amount | A C |
LINECCC | 122 | Long | Line Credit Card | E A C |
LINEEXCH | 123 | Long | Line Exchange Difference | E A C |
LINEREVINV | 124 | Long | Line Can Reverse Invoice | E A C |
CURRTYPE | 125 | Integer | Bank Statement Type | E A X |
RECYEAR | 126 | String*4 | Reconciliation Year | E A X | Mask: %04D
RECPERIOD | 127 | Integer | Reconciliation Period | E A X |

This page was generated on 2009-Nov-19

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