Table: Bank Check Register

Table: BKREG
View: BK0009
Record Length: 558

Flags: A R 

Keys: 2

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

Fields: 40

Field Type Title Presentation
SRCEAPP String*2 Source Application Mask: %-2N
APPRUNNUM String*10 Application Run Number
BANK String*8 Bank Code Mask: %-8N
SORTCODE BCD*10.0 Sort Code
PAYEEID String*12 Payee Code Mask: %-12C
AUDTDATE Date
AUDTTIME Time
AUDTUSER String*8
AUDTORG String*6
SERIAL ??? Serial Number
CHECK BCD*8.0 Check Number
STATUS Integer Check Status List:4 entries
-2 = Not Printed
-1 = Advice Not Printed
9 = Printed
999 = Posted
CHKTYPE Integer Check Type List:2 entries
1 = Check
2 = EFT
CHKFORM String*6 Check Stock Code Mask: %-6N
PAYEENAME String*60 Payee Name
VENDORNAME String*60 Vendor Name
REFERENCE String*60 Check Reference
COMMENT String*60 Check Description
POSTED Date Date Check Printed
CHKDATE Date Check Date
ISSUED BCD*10.3 Check Amount
SISSUED BCD*10.3 Check Source Amount
RATETYPE String*2 Exchange Rate Type Mask: %-2N
SRCECURN String*3 Payment Currency Mask: %-3N
RATEDATE Date Exchange Rate Date
RATE BCD*8.7 Exchange Rate
RATESPREAD BCD*8.7 Rate Spread
RATEOP Integer Rate Operation List:3 entries
1 = Multiply
2 = Divide
0 = Not Specified
EXTRA Binary*102 Extra Application Data
LANGUAGE String*3 Language Code Mask: %-3C
ADVICE BCD*5.0 Advice Lines
FSCYEAR String*4 Fiscal Year Mask: %04D
FSCPERIOD Integer Fiscal Period
LANGCODE Integer Language List:7 entries
5658 = English
7092 = French
5845 = Spanish
738 = Australian
15719 = Mexican
2857 = Chinese (Simplified)
2863 = Chinese (Traditional)
SDECIMALS Integer Source Currency Decimals
DDTYPE Integer Drilldown Type
DDLINK BCD*10.0 Drilldown Link
PAYMCODE String*12 Payment Code
SRCEDOCNUM String*22 Source Document Number
CANREVINVC Integer Can Reverse Invoice List:2 entries
0 = No
1 = Yes

This page was generated on 2022-Aug-18

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