# View: Bank Deposits

RotoID: BK0005
Tables: BKDEP
DLL: BKDEP

## Compositions: 4

RotoID | Title | Tables | DLL
--- | --- | --- | ---
BK0001 | Banks | BKACCT | BKACCT
CS0004 | Rate Types | CSCRT | CSCRT
BK0002 | Bank Currencies | BKCUR | BKCUR
BK0003 | Bank Transaction Types | BKTT | BKTT

## Keys: 4

Title | Fields
--- | ---
Bank Deposit | BANK, DEPOSIT, SERIAL
Bank Fiscal Deposit | BANK, FSCYEAR, FSCPERIOD, DEPOSIT, SERIAL
Bank Serial Deposit | BANK, SERIAL, DEPOSIT
Bank Reconciliation Fiscal Depos | BANK, RECYEAR, RECPERIOD, DEPOSIT, SERIAL

## Fields: 45

Field | Index | Type | Title | Attributes | Presentation
--- | --- | --- | --- | --- | ---
BANK | 1 | String*8 | Bank Code | E A K R | Mask: %-8N
DEPOSIT | 2 | BCD*5.0 | Deposit Number | E A K R |
SERIAL | 3 | Long | Serial Number | E A K R |
STATUS | 4 | Integer | Deposit Status | E A X | List: 4 entries
1 | = | Not posted
2 | = | Void
3 | = | In transit
5 | = | Cleared with bank error
SRCEAPP | 5 | String*2 | Source Application | E A R X | Mask: %-2N
DEPTYPE | 6 | Integer | Deposit Type | E A X | List: 3 entries
1 | = | Deposit
2 | = | EFT
3 | = | Transfer
BTCHNBR | 7 | BCD*5.0 | Batch Number | E A X |
ERRBTCHNBR | 8 | BCD*5.0 | Error Batch Number | E A X |
POSTSEQ | 9 | BCD*5.0 | Posting Sequence Number | E A X |
COMMENT | 10 | String*60 | Deposit Description | E A X |
DEPDATE | 11 | Date | Deposit Date | E A X |
DEPAMT | 12 | BCD*10.3 | Functional Posted Batch Total | E A X |
PRTAMT | 13 | BCD*10.3 | Functional Batch Total | E A X |
SDEPAMT | 14 | BCD*10.3 | Posted Batch Total | E A X |
SPRTAMT | 15 | BCD*10.3 | Batch Total | E A X |
RATETYPE | 16 | String*2 | Rate Type | E A X | Mask: %-2N
SRCECURN | 17 | String*3 | Source Currency | E A X | Mask: %-3N
RATEDATE | 18 | Date | Rate Date | E A X |
RATE | 19 | BCD*8.7 | Rate | E A X |
RATESPREAD | 20 | BCD*8.7 | Rate Spread | E A X |
RATEOP | 21 | Integer | Rate Operation | E A X | List: 3 entries
1 | = | Multiply
2 | = | Divide
0 | = | Not Specified
RECSTATUS | 22 | Integer | Reconciliation Status | A P X | List: 3 entries
1 | = | Not posted
2 | = | Void
3 | = | In transit
RECSTATCHG | 23 | Date | Status Change Date | A C |
RECCOMMENT | 24 | String*60 | Reconciliation Description | A X |
RECCLEARED | 25 | BCD*10.3 | Reconciliation Amount Cleared | A X |
FSCYEAR | 26 | String*4 | Fiscal Year | E A X | Mask: %4D
FSCPERIOD | 27 | Integer | Fiscal Period | E A P X | 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
TTYPE | 28 | String*6 | Transaction Type | A X | Mask: %-6N
REFERENCE | 29 | String*60 | Deposit Reference | E A X |
GLACCOUNT | 30 | String*45 | G/L Account | A X | Mask: %-45C
RECDATE | 31 | Date | Reconciliation Date | A X |
RECYEAR | 32 | String*4 | Reconciliation Fiscal Year | A X | Mask: %4D
RECPERIOD | 33 | Integer | Reconciliation Fiscal Period | A P X | 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
RECONCILED | 34 | Boolean | Reconciled | A C |
RECERR | 39 | BCD*10.3 | Reconciliation Error | A C |
RECERRPEND | 40 | BCD*10.3 | Reconciliation Error Pending | A C |
RECEXGAIN | 41 | BCD*10.3 | Reconciliation Exchange Gain | A C |
RECEXLOSS | 42 | BCD*10.3 | Reconciliation Exchange Loss | A C |
RECSUGGEST | 43 | Integer | Reconciliation Suggestion | A C | List: 6 entries
1 | = | Not posted
2 | = | Void
3 | = | In transit
4 | = | Cleared
5 | = | Cleared with bank error
6 | = | Cleared with write-off
RECDEPOSIT | 44 | BCD*10.3 | Reconciliation Deposit Amount | A C |
RECTRANSIT | 45 | BCD*10.3 | Reconciliation In Transit Amt | A C |
RECTARGET | 46 | Integer | Reconciliation Target | A C | List: 5 entries
0 | = | No Target
1 | = | Bank Error
2 | = | Bank Pending Error
3 | = | Exchange Gain
4 | = | Exchange Loss
TTYPED | 47 | String*60 | Transaction Type Description | A |
GLACCOUNTD | 48 | String*60 | G/L Account Description | A |
RECDELTA | 49 | BCD*10.3 | Reconciliation Amount Delta | A C |

This page was generated on 2004-Oct-28

Copyright © 2000–2004 ACCPAC International, Inc. All rights reserved.