Table: Bank Deposits

Table: BKDEPH
View: BK0420
Record length: 467
Flags: A R 

Keys: 5

Title  Flags  Fields

Bank Deposit Uniquifier  BANK, SERIAL
Bank Fiscal Deposit  M  BANK, FSCYEAR, FSCPERIOD, SERIAL
Bank Deposit Slip  BANK, DEPOSIT, SERIAL
Bank Deposit Date  M  BANK, DEPDATE, SERIAL
Bank Deposit Total  M  BANK, TOTDEPOSIT, SERIAL

Fields: 47

Field  Type  Title  Presentation 

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: 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
PRINTED  Integer  Deposit Slip Printed  List: 2 entries
0=No
1=Yes
TOTDEPOSIT  BCD*10.3  Deposit Total   
TOTTRANSIT  BCD*10.3  Deposit Remaining In Transit   
TOTCLEARED  BCD*10.3  Fiscal Deposit Total   
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 Deposit Total   
TOCLEAR  BCD*10.3  Reconciliation Cleared Amount   
TOWRITEOFF  BCD*10.3  Write-Off Amount   
TOREMAIN  BCD*10.3  In Transit Amount   
VARIANCE  Integer  Variance Type  List: 1 entries
0=None
WOMETHOD  Integer  Write Off Method  List: 1 entries
0=None
RECDATE  Date  Default Reconciliation Date   
RECSTATUS  Integer  Default Reconciliation Status  List: 2 entries
1=Not posted
10=Deleted
RECCOMMENT  String*60  Default Reconciliation Desc.   
LINESJOUR  Long  Lines Journalled   
LINESPUR  Long  Lines Purged   
TOCLEARF  BCD*10.3  Clear To Future Period   
RECFCLR  BCD*10.3  Fiscal Cleared To Future   
RECRCLR  BCD*10.3  Fiscal Cleared To Current   
COMPLETED  Integer  Reconciled and Journaled Transaction  List: 2 entries
0=Not Completed
10=Completed

This page was generated on 2008-May-01

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