Table: Deposits Posting Journal

Table: BKJDEPH
View: BK0550
Record length: 476
Flags: A R 

Keys: 2

Title  Flags  Fields

Deposit Uniquifier  PSTSEQ, BANK, SERIAL
Deposit Slip Number  PSTSEQ, BANK, DEPOSIT, SERIAL

Fields: 49

Field  Type  Title  Presentation 

PSTSEQ  BCD*5.0  Posting Sequence   
BANK  String*8  Bank Code  Mask: %-8N
SERIAL  Long  Deposit Header Serial   
AUDTDATE  Date     
AUDTTIME  Time     
AUDTUSER  String*8     
AUDTORG  String*6     
SRCEAPP  String*2  Source Application  Mask: %-2N
REFERENCE  String*60  Deposit Reference   
COMMENT  String*60  Deposit Description   
DEPDATE  Date  Deposit Date   
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
PRINTED  Integer  Deposit Slip Printed  List: 2 entries
0=No
1=Yes
TOTDEPOSIT  BCD*10.3  Total Deposited   
TOTTRANSIT  BCD*10.3  Total In Transit   
TOTCLEARED  BCD*10.3  Total Cleared   
NXTLINE  Long  Next Deposit Detail Line   
LINES  Long  Lines   
LINESPOST  Long  Lines In Transit   
LINESREC  Long  Lines Reconciled   
STATUS  Integer  Deposit Status  List: 7 entries
1=Not posted
2=Partially in transit
3=In transit
4=Partially reconciled
5=Reconciled
6=Posted
7=Purged
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   
RECDEPOSIT  BCD*10.3  Reconciliation Deposit Amount   
RECTRANSIT  BCD*10.3  Reconciliation In Transit Amt   
DEPOSIT  BCD*5.0  Deposit Slip Number   
SUMMARY  Integer  Deposit Recorded in Summary  List: 3 entries
0=Detail
1=Summary
2=Transfer
RECCCC  BCD*10.3  Reconciliation Credit Card Charge   
RECCLEARED  BCD*10.3  Amount Cleared   
RECFUNCAMT  BCD*10.3  Functional Deposit Amount   
TOTFUNCAMT  BCD*10.3  Functional Total Deposited   
TOCLEAR  BCD*10.3  Amount to Clear   
TOWRITEOFF  BCD*10.3  Amount to Write Off   
TOREMAIN  BCD*10.3  Amount to Remain In Transit   
VARIANCE  Integer  Variance Type  List: 6 entries
0=None
1=In transit amount
2=Amount to write off
3=Bank error
4=Exchange rate difference
5=Credit card charge
WOMETHOD  Integer  Write Off Method  List: 3 entries
0=None
1=Prorate
2=Top down
RECDATE  Date  Default Reconciliation Date   
RECSTATUS  Integer  Default Reconciliation Status  List: 8 entries
1=Not posted
3=In transit
4=Cleared
5=Cleared with bank error
6=Cleared with write-off
8=Cleared with exchange rate difference
9=Cleared with credit card charge
10=Deleted
RECCOMMENT  String*60  Default Reconciliation Desc.   
RECWOSUM  BCD*10.3  Reconciliation Write Off Sum   
CURFUNC  String*3  Functional Currency   
CURSTMT  String*3  Statement Currency   
LINESJOUR  Long  Lines Journalled   
LINESPUR  Long  Lines Purged   
RECRCLR  BCD*10.3  Fiscal Cleared To Current   
TOCLEARR  BCD*10.3  Clear To Reconciliation Period   

This page was generated on 2008-May-01

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