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.