View: Bank Check Register

RotoID: BK0009
Table: BKREG
Protocol: Flat
DLL:BKREG

Keys: 2

Title Fields
Bank Check SRCEAPP, APPRUNNUM, BANK, SORTCODE, PAYEEID
Bank Language Check SRCEAPP, APPRUNNUM, BANK, LANGUAGE, SORTCODE

Fields: 36

Field Index Type Title Attributes Presentation
SRCEAPP 1 String*2 Source Application E A K R  Mask: %-2N
APPRUNNUM 2 String*10 Application Run Number E A K R 
BANK 3 String*8 Bank Code E A K R  Mask: %-8N
SORTCODE 4 BCD*10.0 Sort Code E A K R 
PAYEEID 5 String*12 Payee Code E A K R  Mask: %-12C
SERIAL 7 ??? Serial Number E A 
CHECK 8 BCD*8.0 Check Number E A 
STATUS 9 Integer Check Status E A  List:4 entries
-2 = Not Printed
-1 = Advice Not Printed
9 = Printed
999 = Posted
CHKTYPE 10 Integer Check Type E A  List:2 entries
1 = Check
2 = EFT
CHKFORM 11 String*6 Check Stock Code E A  Mask: %-6N
PAYEENAME 12 String*60 Payee Name E A 
VENDORNAME 13 String*60 Vendor Name E A 
REFERENCE 14 String*60 Check Reference E A 
COMMENT 15 String*60 Check Description E A 
POSTED 16 Date Date Check Printed E A 
CHKDATE 17 Date Check Date E A 
ISSUED 18 BCD*10.3 Check Amount E A 
SISSUED 19 BCD*10.3 Check Source Amount E A 
RATETYPE 20 String*2 Exchange Rate Type E A  Mask: %-2N
SRCECURN 21 String*3 Payment Currency E A  Mask: %-3N
RATEDATE 22 Date Exchange Rate Date E A 
RATE 23 BCD*8.7 Exchange Rate E A 
RATESPREAD 24 BCD*8.7 Rate Spread E A 
RATEOP 25 Integer Rate Operation E A  List:3 entries
1 = Multiply
2 = Divide
0 = Not Specified
EXTRA 26 Binary*102 Extra Application Data E A 
LANGUAGE 27 String*3 Language Code A C  Mask: %-3C
ADVICE 28 BCD*5.0 Advice Lines E A 
FSCYEAR 29 String*4 Fiscal Year E A  Mask: %04D
FSCPERIOD 30 Integer Fiscal Period E A 
LANGCODE 31 Integer Language E A  List:7 entries
5658 = English
7092 = French
5845 = Spanish
738 = Australian
15719 = Mexican
2857 = Chinese (Simplified)
2863 = Chinese (Traditional)
SDECIMALS 32 Integer Source Currency Decimals E A 
DDTYPE 33 Integer Drilldown Type E A 
DDLINK 34 BCD*10.0 Drilldown Link E A 
PAYMCODE 35 String*12 Payment Code E A 
SRCEDOCNUM 36 String*22 Source Document Number E A X 
CANREVINVC 37 Integer Can Reverse Invoice E A X  List:2 entries
0 = No
1 = Yes

This page was generated on 2023-Aug-31

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