# View: Bank Deposit Details

RotoID: BK0400
Table: BKDEPD
Protocol: Detail, Ordered revisions, Key auto generate
DLL: BKDEPD

## Compositions: 6

RotoID | Tables | Title | DLL
--- | --- | --- | ---
BK0420 | BKDEPH | Bank Deposits | BKDEPH
BK0001 | BKACCT | Banks | BKACCT
CS0004 | CSCRT | Rate Types | CSCRT
BK0002 | BKCUR | Bank Currencies | BKCUR
BK0003 | BKTT | Bank Transaction Types | BKTT
BK0240 | BKCCTYP | Credit Card Types | BKCCTYP

## Keys: 3

Title | Fields
--- | ---
Bank Deposit Detail | BANK, SERIAL, LINE
Bank Reconciliation Fiscal Depos | BANK, SERIAL, RECYEAR, RECPERIOD, LINE
Bank Fiscal Period Deposit | BANK, SERIAL, FSCYEAR, FSCPERIOD, LINE

## Fields: 92

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 |
LINE | 3 | Long | Deposit Detail Line | E A K R |
SRCEAPP | 4 | String*2 | Source Application | E A R X | Mask: %-2N
STATUS | 5 | Integer | Receipt Status | E A X | List: 5 entries
1 | = | Not posted
2 | = | Void
3 | = | In transit
5 | = | Cleared with bank error
7 | = | Returned
DEPTYPE | 6 | Integer | Payment Type | E A X | List: 6 entries
1 | = | Deposit (Other)
2 | = | EFT
3 | = | Transfer
4 | = | Customer Check
5 | = | Credit Card
6 | = | Cash
IDREMIT | 7 | String*24 | Transaction Number | E A X |
DATEREMIT | 8 | Date | Transaction Date | E A X |
BTCHNBR | 9 | BCD*5.0 | Batch Number | E A X |
ENTRYNBR | 10 | BCD*4.0 | Entry Number | E A X |
POSTSEQ | 11 | BCD*5.0 | Posting Sequence Number | E A X |
POSTDATE | 12 | Date | Document Posting Date | E A X |
REFERENCE | 13 | String*60 | Transaction Reference | E A X |
COMMENT | 14 | String*60 | Transaction Description | E A X |
PAYORID | 15 | String*12 | Payer Code | E A X | Mask: %-12C
PAYORNAME | 16 | String*60 | Payee Name | E A X |
DEPAMT | 17 | BCD*10.3 | Functional Receipt Amount | E A X |
SDEPAMT | 18 | BCD*10.3 | Receipt Amount | E A X |
RATETYPE | 19 | String*2 | Exchange Rate Type | E A X | Mask: %-2N
SRCECURN | 20 | String*3 | Receipt Currency | E A X | Mask: %-3N
RATEDATE | 21 | Date | Exchange Rate Date | E A X |
RATE | 22 | BCD*8.7 | Exchange Rate | E A X |
RATESPREAD | 23 | BCD*8.7 | Rate Spread | E A X |
RATEOP | 24 | Integer | Rate Operation | E A X | List: 3 entries
1 | = | Multiply
2 | = | Divide
0 | = | Not Specified
TTYPE | 25 | String*6 | Transaction Type | A X | Mask: %-6N
GLACCOUNT | 26 | String*45 | G/L Account | A X | Mask: %-45C
CCTYPE | 27 | String*12 | Credit Card Type | A X | Mask: %-12N
CCNUMBER | 28 | Binary*32 | Credit Card Number | A X |
CCNAME | 29 | String*60 | Cardholder Name | A X |
CCAUTHCODE | 30 | String*20 | Authorization Code | A X |
CCEXP | 31 | Date | Expiry Date | A X |
DDTYPE | 32 | Integer | Drilldown Type | E A |
DDLINK | 33 | BCD*10.0 | Drilldown Link | E A |
RECSTATUS | 34 | Integer | Reconciliation Status | A P X | List: 3 entries
1 | = | Not posted
2 | = | Void
3 | = | In transit
RECSTATCHG | 35 | Date | Status Change Date | A C |
RECCOMMENT | 36 | String*60 | Reconciliation Description | A X |
RECCLEARED | 37 | BCD*10.3 | Cleared Amount | A X |
RECDATE | 38 | Date | Reconciliation Date | A X |
RECYEAR | 39 | String*4 | Reconciliation Fiscal Year | A X | Mask: %04D
RECPERIOD | 40 | Integer | Reconciliation Fiscal Period | A P X | List: 1 entries
0 | = |
RECONCILED | 41 | Boolean | Reconciled | A |
RECPENDING | 42 | BCD*10.3 | Remaining In Transit Amount | A |
PAYMCODE | 43 | String*12 | Payment Code | E A X |
FSCYEAR | 44 | String*4 | Fiscal Year | E A X | Mask: %04D
FSCPERIOD | 45 | Integer | Fiscal Period | E A P X | 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 | 46 | Date | Return Date | A X |
SRCEDOCNUM | 47 | String*22 | Source Document Number | E A X |
CANREVINVC | 48 | Integer | Can Reverse Invoice | E A X | List: 2 entries
0 | = | No
1 | = | Yes
REVINVC | 49 | Integer | Reverse Invoice | A X | List: 2 entries
0 | = | No
1 | = | Yes
COMPLETED | 50 | Integer | Reconciled and Journaled Transaction | E A X | List: 2 entries
0 | = | Not Completed
10 | = | Completed
PSTSEQ | 51 | BCD*5.0 | Posting Sequence | E A |
RECERR | 80 | BCD*10.3 | Reconciliation Error | A C |
RECERRPEND | 81 | BCD*10.3 | Reconciliation Error Pending | A C |
RECEXGAIN | 82 | BCD*10.3 | Reconciliation Exchange Gain | A C |
RECEXLOSS | 83 | BCD*10.3 | Reconciliation Exchange Loss | A C |
RECSUGGEST | 84 | Integer | Reconciliation Suggestion | A C | List: 9 entries
1 | = | Not posted
2 | = | Void
3 | = | In transit
4 | = | Cleared
5 | = | Cleared with bank error
6 | = | Cleared with write-off
7 | = | Returned
8 | = | Cleared with exchange rate difference
9 | = | Cleared with credit card charge
RECDEPOSIT | 85 | BCD*10.3 | Deposit Amount | A C |
RECTRANSIT | 86 | BCD*10.3 | In transit Amount | A C |
RECTARGET | 87 | Integer | Reconciliation Target | A C | List: 6 entries
0 | = | No Target
1 | = | Bank Error
2 | = | Bank Pending Error
3 | = | Exchange Gain
4 | = | Exchange Loss
5 | = | Credit Card Charge
TTYPED | 88 | String*60 | Transaction Description | A |
GLACCOUNTD | 89 | String*60 | G/L Account Description | A |
RECDELTA | 90 | BCD*10.3 | Reconciliation Amount Delta | A C |
LINEONE | 91 | Long | Line | A C |
LINEPOST | 92 | Long | Line In Transit | A C |
LINEREC | 93 | Long | Line Reconciled | A C |
XCCNUMBER | 94 | String*32 | Decrypted Credit Card Number | E A | Mask: %-32D
RECCCC | 95 | BCD*10.3 | Reconciliation Credit Card Charge | A C |
RECWOSUM | 96 | BCD*10.3 | Write-Off Amount | A C |
CURFUNC | 97 | String*3 | Functional Currency | A C |
CURSTMT | 98 | String*3 | Statement Currency | A C |
SUMDEPOSIT | 99 | BCD*10.3 | Summated Deposit Amount | A C |
RECSPREAD | 100 | BCD*10.3 | Reconciliation Spread | A C |
RECPDEP | 101 | BCD*10.3 | Fiscal Deposit Remaining In Transit | A C |
RECPDEPIT | 102 | BCD*10.3 | Fiscal In Transit Amount | A C |
RECPWO | 103 | BCD*10.3 | Fiscal Write Offs | A C |
RECPERR | 104 | BCD*10.3 | Fiscal Bank Errors | A C |
RECPGAIN | 105 | BCD*10.3 | Fiscal Exchange Gain | A C |
RECPLOSS | 106 | BCD*10.3 | Fiscal Exchange Loss | A C |
RECPCCC | 107 | BCD*10.3 | Fiscal Credit Card Charge | A C |
RECPCLR | 108 | BCD*10.3 | Fiscal Cleared | A C |
RECPFUNAM | 109 | BCD*10.3 | Fiscal Functional Amount | A C |
RECPDEPO | 110 | BCD*10.3 | Fiscal Deposit Amount | A C |
RECTDEPB | 111 | BCD*10.3 | Total Book Amount | A C |
RECPDEPB | 112 | BCD*10.3 | Fiscal Book Amount | A C |
RECTDEPREM | 113 | BCD*10.3 | Total Remaining Amount | A C |
RECPDEPREM | 114 | BCD*10.3 | Fiscal Remaining Amount | A C |
RECRWOSUM | 115 | BCD*10.3 | Fiscal Write-Off To This Period | A C |
RECFCLR | 116 | BCD*10.3 | Fiscal Cleared To Future | A C |
RECRCLR | 117 | BCD*10.3 | Fiscal Cleared To Current | A C |
RECWOSUMR | 118 | BCD*10.3 | Current Period's Write-Off | A C |
RECFCLRR | 119 | BCD*10.3 | Posted Fiscal Cleared To Future | A C |
AGERECLD | 120 | Integer | No. of Days Since Reconciled | A C |

This page was generated on 2008-May-01

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