View: Bank Transaction Reversals

RotoID: BK0855
Table: BKTRANR
Protocol: Flat, Ordered revisions
DLL:BKTRANR

Keys: 1

Title Fields
Reversal Detail Sequence BANK, SEQUENCE

Fields: 48

Field Index Type Title Attributes Presentation
BANK 1 String*8 Bank Code E A K R 
SEQUENCE 2 Long Detail Sequence E A K R 
SWREVDOC 3 Integer Reverse Document E A  List:3 entries
0 = No
1 = Yes
2 = Reversed
SWREVINVC 4 Integer Reverse Invoice E A  List:4 entries
3 = Not Applicable
0 = No
1 = Yes
2 = Reversed
REVDATE 5 Date Reversal Date E A 
REVFISCYR 6 String*4 Reversal Fiscal Year A 
REVFISCPER 7 Integer Reversal Fiscal Period A 
REASON 8 String*60 Reversal Reason E A 
SERIAL 9 ??? Transaction Header Serial E A 
LINE 10 Long Transaction Detail Line E A 
SRCEAPP 11 String*2 Source Application A 
TRANSTYPE 12 Integer Transaction Type A 
ENTRYTYPE 13 Integer Header Type A 
DETAILTYPE 14 Integer Detail Type A 
IDREMIT 15 String*24 Remittance ID E A 
DDTYPE 16 Integer Drilldown Type A 
DDLINK 17 BCD*10.0 Drilldown Link A 
DATEREMIT 18 Date Remittance Date A 
FUNCAMOUNT 19 BCD*10.3 Transaction Functional Amount A 
SRCEAMOUNT 20 BCD*10.3 Transaction Source Amount A 
SRCECURN 21 String*3 Transaction Source Currency A 
PAYORID 22 String*12 Payor Code E A  Mask: %-12C
PAYORNAME 23 String*60 Payor Name A 
PROCESSCMD 100 Integer Process Command Code E A  List:4 entries
1 = Load Selections
2 = Select All Selections
3 = Clear Selections
4 = Post Reversal Selections
PBANK 101 String*8 Process Bank Code E A  Mask: %-8N
PSRCEAPP 102 Integer Process Source Application E A  List:4 entries
116 = Accounts Payable
118 = Accounts Receivable
211 = Bank Services
316 = Canadian Payroll
SWMULTTRAN 103 Integer Reverse Multiple Transactions E A  List:2 entries
0 = No
1 = Yes
DOCTYPE 104 Integer Reverse Transaction Type E A P X  List:1 entries
1 = Payments
IDREMITFR 105 String*24 Remittance ID From E A 
IDREMITTO 106 String*24 Remittance ID To E A 
DATREMITFR 107 Date Remittance Date From E A 
DATREMITTO 108 Date Remittance Date To E A 
FUNCAMTFR 109 BCD*10.3 Func. Transaction Amount From E A 
FUNCAMTTO 110 BCD*10.3 Func. Transaction Amount To E A 
SRCEAMTFR 111 BCD*10.3 Srce. Transaction Amount From E A 
SRCEAMTTO 112 BCD*10.3 Srce. Transaction Amount To E A 
SRCECURNFR 113 String*3 Srce. Currency From E A  Mask: %-3N
SRCECURNTO 114 String*3 Srce. Currency To E A  Mask: %-3N
PAYORIDFR 115 String*12 Payer Code From E A  Mask: %-12C
PAYORIDTO 116 String*12 Payer Code To E A  Mask: %-12C
BKACCT 117 String*22 Process Bank Account Number A 
IDACCT 118 String*45 Process Bank Account A 
CURNSTMT 119 String*3 Process Statement Currency A 
SWDUPRMIT 120 Integer Duplicate Remittance ID A  List:2 entries
0 = No
1 = Yes
CNTREVERSE 121 Long Number of Reversals A 
RUNID 122 Long Restart Run ID A 
HASRESTART 123 Integer Has restart record A  List:2 entries
0 = No
1 = Yes
SRCEDOCNUM 124 String*22 Source Document Number E A 

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