# Table: Bank Check Register

Table: BKREG
View: BK0009
Record length: 551
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 | Long | Serial Number |
CHECK | BCD*5.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 2009-Nov-19

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