Table: Bank Check Posting Journal

Table: BKJCHK
View: BK0014
Record length: 774
Flags: A R 

Keys: 2

Title  Flags  Fields

Posting Sequence/Bank Code  PSTSEQ, BANK, CHECK, SERIAL
Bank Code/Check Number  D  BANK, CHECK

Fields: 65

Field  Type  Title  Presentation 

PSTSEQ  BCD*5.0  Posting Sequence   
BANK  String*8  Bank Code  Mask: %-8N
CHECK  BCD*5.0  Check Number   
SERIAL  Long  Serial Number   
AUDTDATE  Date     
AUDTTIME  Time     
AUDTUSER  String*8     
AUDTORG  String*6     
STATUS  Integer  Check Status  List: 9 entries
1=Alignment
2=Void
3=Outstanding
4=Reversed
6=Cleared with bank error
7=Non-negotiable
8=Continuation
9=Printed
10=Posting error
SRCEAPP  String*2  Source Application  Mask: %-2N
CHKTYPE  Integer  Check Type  List: 7 entries
1=Check
2=EFT
3=Transfer
4=Service Charge
5=Credit Card
6=Cash
7=Other
CHKFORM  String*6  Check Stock Code  Mask: %-6N
PAYEEID  String*12  Payee Code  Mask: %-12C
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  Functional Check Amount   
SISSUED  BCD*10.3  Check 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
RECSTATUS  Integer  Reconciliation Status  List: 13 entries
1=Alignment
2=Void
3=Outstanding
4=Reversed
5=Cleared
6=Cleared with bank error
7=Non-negotiable
8=Continuation
9=Printed
10=Posting error
11=Cleared with write-off
12=Cleared with exchange rate difference
13=Cleared with credit card charge
RECSTATCHG  Date  Status Change Date   
RECCOMMENT  String*60  Reconciliation Description   
RECCLEARED  BCD*10.3  Reconciliation Amount Cleared   
FSCYEAR  String*4  Fiscal Year  Mask: %04D
FSCPERIOD  Integer  Fiscal Period  List: 14 entries
0=
1=1
2=2
3=3
4=4
5=5
6=6
7=7
8=8
9=9
10=10
11=11
12=12
13=13
TTYPE  String*6  Transaction Type  Mask: %-6N
RECERR  BCD*10.3  Reconciliation Error   
RECERRPEND  BCD*10.3  Reconciliation Error Pending   
RECEXGAIN  BCD*10.3  Reconciliation Exchange Gain   
RECEXLOSS  BCD*10.3  Reconciliation Exchange Loss   
RECSUGGEST  Integer  Reconciliation Suggestion   
RECCHECK  BCD*10.3  Reconciliation Check Amount   
RECOUTSTND  BCD*10.3  Reconciliation Outstanding Amount   
RECTARGET  Integer  Reconciliation Target   
IDACCT  String*45  G/L Account   
IDACCTOVR  Boolean  Account Number Override   
RECDATE  Date  Reconciliation Date   
RECYEAR  String*4  Reconciliation Fiscal Year   
RECPERIOD  Integer  Reconciliation Fiscal Period  List: 14 entries
0=
1=1
2=2
3=3
4=4
5=5
6=6
7=7
8=8
9=9
10=10
11=11
12=12
13=13
RECONCILED  Boolean  Reconciled   
RECDELTA  BCD*10.3  Reconciliation Amount Delta   
CCTYPE  String*12  Credit Card Type  Mask: %-12N
CCNAME  String*60  Cardholder Name   
DDTYPE  Integer  Drilldown Type   
DDLINK  BCD*10.0  Drilldown Link   
RECCCC  BCD*10.3  Reconciliation Credit Card Charge   
RECPENDING  BCD*10.3  Bank Error Outstanding   
RECWOSUM  BCD*10.3  Reconciliation Write Off Sum   
CURFUNC  String*3  Functional Currency   
CURSTMT  String*3  Statement Currency   
RECDELTAF  BCD*10.3  Functional Discrepancy   
CCEXP  Date  Expiry Date   
PAYMCODE  String*12  Payment Code   
SRCEDOCNUM  String*22  Source Document Number   
CANREVINVC  Integer  Can Reverse Invoice  List: 2 entries
0=No
1=Yes
REVINVC  Integer  Reverse Invoice  List: 2 entries
0=No
1=Yes
RECRCLR  BCD*10.3  Fiscal Cleared To Current   

This page was generated on 2008-May-01

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