Table: Bank Deposit Details

Table: BKDEPD
View: BK0400
Record length: 682
Flags: A R 

Keys: 3

Title  Flags  Fields

Bank Deposit Detail  BANK, SERIAL, LINE
Bank Reconciliation Fiscal Depos  M  BANK, SERIAL, RECYEAR, RECPERIOD, LINE
Bank Fiscal Period Deposit  M  BANK, SERIAL, FSCYEAR, FSCPERIOD, LINE

Fields: 55

Field  Type  Title  Presentation 

BANK  String*8  Bank Code  Mask: %-8N
SERIAL  Long  Deposit Header Serial   
LINE  Long  Deposit Detail Line   
AUDTDATE  Date     
AUDTTIME  Time     
AUDTUSER  String*8     
AUDTORG  String*6     
SRCEAPP  String*2  Source Application  Mask: %-2N
STATUS  Integer  Receipt Status  List: 5 entries
1=Not posted
2=Void
3=In transit
5=Cleared with bank error
7=Returned
DEPTYPE  Integer  Payment Type  List: 6 entries
1=Deposit (Other)
2=EFT
3=Transfer
4=Customer Check
5=Credit Card
6=Cash
IDREMIT  String*24  Transaction Number   
DATEREMIT  Date  Transaction Date   
BTCHNBR  BCD*5.0  Batch Number   
ENTRYNBR  BCD*4.0  Entry Number   
POSTSEQ  BCD*5.0  Posting Sequence Number   
POSTDATE  Date  Document Posting Date   
REFERENCE  String*60  Transaction Reference   
COMMENT  String*60  Transaction Description   
PAYORID  String*12  Payer Code  Mask: %-12C
PAYORNAME  String*60  Payee Name   
DEPAMT  BCD*10.3  Functional Receipt Amount   
SDEPAMT  BCD*10.3  Receipt Amount   
RATETYPE  String*2  Exchange Rate Type  Mask: %-2N
SRCECURN  String*3  Receipt 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
TTYPE  String*6  Transaction Type  Mask: %-6N
GLACCOUNT  String*45  G/L Account  Mask: %-45C
CCTYPE  String*12  Credit Card Type  Mask: %-12N
CCNUMBER  Binary*32  Credit Card Number   
CCNAME  String*60  Cardholder Name   
CCAUTHCODE  String*20  Authorization Code   
CCEXP  Date  Expiry Date   
DDTYPE  Integer  Drilldown Type   
DDLINK  BCD*10.0  Drilldown Link   
RECSTATUS  Integer  Reconciliation Status  List: 3 entries
1=Not posted
2=Void
3=In transit
RECSTATCHG  Date  Status Change Date   
RECCOMMENT  String*60  Reconciliation Description   
RECCLEARED  BCD*10.3  Cleared Amount   
RECDATE  Date  Reconciliation Date   
RECYEAR  String*4  Reconciliation Fiscal Year  Mask: %04D
RECPERIOD  Integer  Reconciliation Fiscal Period  List: 1 entries
0=
RECONCILED  Boolean  Reconciled   
RECPENDING  BCD*10.3  Remaining In Transit Amount   
PAYMCODE  String*12  Payment Code   
FSCYEAR  String*4  Fiscal Year  Mask: %04D
FSCPERIOD  Integer  Fiscal Period  List: 13 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
13=13
RETDATE  Date  Return Date   
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
COMPLETED  Integer  Reconciled and Journaled Transaction  List: 2 entries
0=Not Completed
10=Completed
PSTSEQ  BCD*5.0  Posting Sequence   

This page was generated on 2008-May-01

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