View: Bank Transaction Details

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

Compositions: 5

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

Keys: 8

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 Remittance ID BANK, SERIAL, IDREMIT, DATEREMIT, LINE
Transaction Remittance Date BANK, DATEREMIT, IDREMIT, SERIAL, LINE
Transaction Remittance ID BANK, IDREMIT, DATEREMIT, SERIAL, LINE
Payer Code Remittance ID BANK, SRCEAPP, PAYORID, IDREMIT, SERIAL, LINE

Fields: 102

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 
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
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 
RECLEVEL 58 Integer Reconciled By A  List:2 entries
0 = Reconciled by Header
1 = Reconciled by Detail
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 
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 
AMTDTLREC 128 BCD*10.3 Reconcile by Detail Reconciled A C 
AMTDTLOUT 129 BCD*10.3 Reconcile by Detail Outstanding A C 

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