# View: Bank Deposits

RotoID: BK0420
Table: BKDEPH
Protocol: Detail, Ordered revisions, Key auto generate
DLL: BKDEPH

## Compositions: 2

RotoID | Tables | Title | DLL
--- | --- | --- | ---
BK0001 | BKACCT | Banks | BKACCT
BK0400 | BKDEPD | Bank Deposit Details | BKDEPD

## Keys: 5

Title | Fields
--- | ---
Bank Deposit Uniquifier | BANK, SERIAL
Bank Fiscal Deposit | BANK, FSCYEAR, FSCPERIOD, SERIAL
Bank Deposit Slip | BANK, DEPOSIT, SERIAL
Bank Deposit Date | BANK, DEPDATE, SERIAL
Bank Deposit Total | BANK, TOTDEPOSIT, SERIAL

## Fields: 57

Field | Index | Type | Title | Attributes | Presentation
--- | --- | --- | --- | --- | ---
BANK | 1 | String*8 | Bank Code | E A K R | Mask: %-8N
SERIAL | 2 | Long | Deposit Header Serial | E A K R |
SRCEAPP | 3 | String*2 | Source Application | E A | Mask: %-2N
REFERENCE | 4 | String*60 | Deposit Reference | E A X |
COMMENT | 5 | String*60 | Deposit Description | E A X |
DEPDATE | 6 | Date | Deposit Date | E A X |
FSCYEAR | 7 | String*4 | Fiscal Year | E A X | Mask: %04D
FSCPERIOD | 8 | 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
PRINTED | 9 | Integer | Deposit Slip Printed | E A | List: 2 entries
0 | = | No
1 | = | Yes
TOTDEPOSIT | 10 | BCD*10.3 | Deposit Total | A C |
TOTTRANSIT | 11 | BCD*10.3 | Deposit Remaining In Transit | A C |
TOTCLEARED | 12 | BCD*10.3 | Fiscal Deposit Total | A C |
NXTLINE | 13 | Long | Next Deposit Detail Line | E A C |
LINES | 14 | Long | Lines | E A C |
LINESPOST | 15 | Long | Lines In Transit | E A C |
LINESREC | 16 | Long | Lines Reconciled | E A C |
STATUS | 17 | Integer | Deposit Status | A C | List: 7 entries
1 | = | Not posted
2 | = | Partially in transit
3 | = | In transit
4 | = | Partially reconciled
5 | = | Reconciled
6 | = | Posted
7 | = | Purged
RECERR | 18 | BCD*10.3 | Reconciliation Error | E A C |
RECERRPEND | 19 | BCD*10.3 | Reconciliation Error Pending | E A C |
RECEXGAIN | 20 | BCD*10.3 | Reconciliation Exchange Gain | E A C |
RECEXLOSS | 21 | BCD*10.3 | Reconciliation Exchange Loss | E A C |
RECDEPOSIT | 22 | BCD*10.3 | Reconciliation Deposit Amount | E A C |
RECTRANSIT | 23 | BCD*10.3 | Reconciliation In Transit Amt | E A C |
DEPOSIT | 24 | BCD*5.0 | Deposit Slip Number | E A |
SUMMARY | 25 | Integer | Deposit Recorded in Summary | E A X | List: 3 entries
0 | = | Detail
1 | = | Summary
2 | = | Transfer
RECCCC | 26 | BCD*10.3 | Reconciliation Credit Card Charge | E A C |
RECCLEARED | 27 | BCD*10.3 | Amount Cleared | E A C |
RECFUNCAMT | 28 | BCD*10.3 | Functional Deposit Amount | E A C |
TOTFUNCAMT | 29 | BCD*10.3 | Functional Deposit Total | A C |
TOCLEAR | 30 | BCD*10.3 | Reconciliation Cleared Amount | A X |
TOWRITEOFF | 31 | BCD*10.3 | Write-Off Amount | A X |
TOREMAIN | 32 | BCD*10.3 | In Transit Amount | A X |
VARIANCE | 33 | Integer | Variance Type | A P X | List: 1 entries
0 | = | None
WOMETHOD | 34 | Integer | Write Off Method | A P X | List: 1 entries
0 | = | None
RECDATE | 35 | Date | Default Reconciliation Date | A X |
RECSTATUS | 36 | Integer | Default Reconciliation Status | E A P X | List: 2 entries
1 | = | Not posted
10 | = | Deleted
RECCOMMENT | 37 | String*60 | Default Reconciliation Desc. | A X |
LINESJOUR | 38 | Long | Lines Journalled | A C |
LINESPUR | 39 | Long | Lines Purged | A C |
TOCLEARF | 40 | BCD*10.3 | Clear To Future Period | A |
RECFCLR | 41 | BCD*10.3 | Fiscal Cleared To Future | E A C |
RECRCLR | 42 | BCD*10.3 | Fiscal Cleared To Current | E A C |
COMPLETED | 43 | Integer | Reconciled and Journaled Transaction | E A X | List: 2 entries
0 | = | Not Completed
10 | = | Completed
RECWOSUMR | 114 | BCD*10.3 | Current Period's Write-Off | A C |
TOCLEARR | 115 | BCD*10.3 | Clear To Reconciliation Period | A C |
RECRWOSUM | 116 | BCD*10.3 | Fiscal Write-Off To This Period | E A C |
RECPREM | 117 | BCD*10.3 | Fiscal Remaining In Transit | E A C |
RECTWO | 118 | BCD*10.3 | Total Delta Write Offs | E A C |
RECTERR | 119 | BCD*10.3 | Total Delta Bank Errors | E A C |
RECTGAIN | 120 | BCD*10.3 | Total Delta Exchange Gain | E A C |
RECTLOSS | 121 | BCD*10.3 | Total Delta Exchange Loss | E A C |
RECTCCC | 122 | BCD*10.3 | Total Delta Credit Card Charge | E A C |
RECTCLR | 123 | BCD*10.3 | Total Delta Cleared | E A C |
RECTFUNAM | 124 | BCD*10.3 | Total Delta Functional Amount | E A C |
CURFUNC | 125 | String*3 | Functional Currency | A |
CURSTMT | 126 | String*3 | Statement Currency | A |
RECWOSUM | 127 | BCD*10.3 | Reconciliation Write Off Sum | A C |

This page was generated on 2008-May-01

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