Table: Returned Customer Checks

Table: BKNSF
View: BK0006
Record length: 481
Flags: A R 

Keys: 2

Title  Flags  Fields
Bank Code  BANK, UNIQUE
Bank Rec. Fiscal Returned Check  D M  BANK, RECYEAR, RECPERIOD, UNIQUE

Fields: 32

Field  Type  Title  Presentation 
BANK  String*8  Bank Code  Mask: %-8N
UNIQUE  Long  Uniquifier   
AUDTDATE  Date     
AUDTTIME  Time     
AUDTUSER  String*8     
AUDTORG  String*6     
SERIAL  Long  Serial Number   
DEPOSIT  BCD*5.0  Deposit Number   
PAYER  String*12  Customer Number  Mask: %-12C
ADDKEY  Binary*82  Additional Check Segments   
SRCEAPP  String*2  Source Application  Mask: %-2N
PAYOR  String*60  Customer Name   
IDRMIT  String*24  Transaction Number   
DATERMIT  Date  Transaction Date   
REFERENCE  String*60  Transaction Reference   
POSTED  Date  Date Transaction Posted   
RECCOMMENT  String*60  Reason For Return   
RECAMOUNT  BCD*10.3  Transaction Amount   
RECSTATUS  Integer  Reconciliation Status  List: 2 entries
1=Outstanding
2=Cleared
RECSTATCHG  Date  Status Change Date   
RECFAMOUNT  BCD*10.3  Functional Transaction Amount   
RECDATE  Date  Reconciliation Date   
RECYEAR  String*4  Reconciliation Fiscal Year  Mask: %04D
RECPERIOD  Integer  Reconciliation Fiscal Period  List: 12 entries
1=1
2=2
3=3
4=4
5=5
6=6
7=7
8=8
9=9
10=10
11=11
12=12
RECONCILED  Boolean  Reconciled   
LINE  Long  Line Number   
DDTYPE  Integer  Drilldown Type   
DDLINK  BCD*10.0  Drilldown Link   
COMMENT  String*60  Transaction Description   
SRCECURN  String*3  Transaction Currency  Mask: %-3N
REVINVC  Integer  Reverse Invoice  List: 2 entries
0=No
1=Yes
POSTDATE  Date  Post Date   

This page was generated on 2008-May-01

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