# 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.