# View: Deposit Details Posting Journal

RotoID: BK0540
Table: BKJDEPD
Protocol: Detail, Ordered revisions
DLL: BKJDEPD

## Compositions: 1

RotoID | Tables | Title | DLL
--- | --- | --- | ---
BK0550 | BKJDEPH | Deposits Posting Journal | BKJDEPH

## Keys: 1

Title | Fields
--- | ---
Bank Deposit Detail | PSTSEQ, BANK, SERIAL, LINE

## Fields: 68

Field | Index | Type | Title | Attributes | Presentation
--- | --- | --- | --- | --- | ---
PSTSEQ | 1 | BCD*5.0 | Posting Sequence | E A K R |
BANK | 2 | String*8 | Bank Code | E A K R | Mask: %-8N
SERIAL | 3 | Long | Deposit Header Serial | E A K R |
LINE | 4 | Long | Deposit Detail Line | E A K R |
SRCEAPP | 5 | String*2 | Source Application | E A | Mask: %-2N
STATUS | 6 | Integer | Deposit Status | E A | List: 5 entries
1 | = | Not posted
2 | = | Void
3 | = | In transit
5 | = | Cleared with bank error
7 | = | Returned
DEPTYPE | 7 | Integer | Deposit Type | E A | List: 6 entries
1 | = | Deposit (Other)
2 | = | EFT
3 | = | Transfer
4 | = | Customer Check
5 | = | Credit Card
6 | = | Cash
IDREMIT | 8 | String*24 | Remittance ID | E A |
DATEREMIT | 9 | Date | Remit Date | E A |
BTCHNBR | 10 | BCD*5.0 | Batch Number | E A |
ENTRYNBR | 11 | BCD*4.0 | Entry Number | E A |
POSTSEQ | 12 | BCD*5.0 | Posting Sequence Number | E A |
POSTDATE | 13 | Date | Date Posted | E A |
REFERENCE | 14 | String*60 | Deposit Reference | E A |
COMMENT | 15 | String*60 | Deposit Description | E A |
PAYORID | 16 | String*12 | Payor ID | E A |
PAYORNAME | 17 | String*60 | Payor Name | E A |
DEPAMT | 18 | BCD*10.3 | Functional Deposit Amount | E A |
SDEPAMT | 19 | BCD*10.3 | Deposit Amount | E A |
RATETYPE | 20 | String*2 | Exchange Rate Type | E A | Mask: %-2N
SRCECURN | 21 | String*3 | Payment Currency | E A | Mask: %-3N
RATEDATE | 22 | Date | Exchange Rate Date | E A |
RATE | 23 | BCD*8.7 | Exchange Rate | E A |
RATESPREAD | 24 | BCD*8.7 | Rate Spread | E A |
RATEOP | 25 | Integer | Rate Operation | E A | List: 3 entries
1 | = | Multiply
2 | = | Divide
0 | = | Not Specified
TTYPE | 26 | String*6 | Transaction Type | E A | Mask: %-6N
IDACCT | 27 | String*45 | G/L Account | E A | Mask: %-45C
IDACCTOVR | 28 | Boolean | Account Number Override | E A |
CCTYPE | 29 | String*12 | Credit Card Type | E A | Mask: %-12N
CCNAME | 30 | String*60 | Cardholder Name | E A |
DDTYPE | 31 | Integer | Drilldown Type | E A |
DDLINK | 32 | BCD*10.0 | Drilldown Link | E A |
RECSTATUS | 33 | Integer | Reconciliation Status | E A | 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
RECSTATCHG | 34 | Date | Status Change Date | E A |
RECCOMMENT | 35 | String*60 | Reconciliation Description | E A |
RECCLEARED | 36 | BCD*10.3 | Reconciliation Amount Cleared | E A |
RECDATE | 37 | Date | Reconciliation Date | E A |
RECYEAR | 38 | String*4 | Reconciliation Fiscal Year | E A | Mask: %04D
RECPERIOD | 39 | Integer | Reconciliation Fiscal Period | E A | List: 14 entries
0 | = |
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
RECONCILED | 40 | Boolean | Reconciled | E A |
RECERR | 41 | BCD*10.3 | Reconciliation Error | E A |
RECERRPEND | 42 | BCD*10.3 | Reconciliation Error Pending | E A |
RECEXGAIN | 43 | BCD*10.3 | Reconciliation Exchange Gain | E A |
RECEXLOSS | 44 | BCD*10.3 | Reconciliation Exchange Loss | E A |
RECSUGGEST | 45 | Integer | Reconciliation Suggestion | E A |
RECDEPOSIT | 46 | BCD*10.3 | Reconciliation Deposit Amount | E A |
RECTRANSIT | 47 | BCD*10.3 | Reconciliation In Transit Amt | E A |
RECTARGET | 48 | Integer | Reconciliation Target | E A |
RECDELTA | 49 | BCD*10.3 | Reconciliation Amount Delta | E A |
RECCCC | 50 | BCD*10.3 | Reconciliation Credit Card Charge | E A |
RECPENDING | 51 | BCD*10.3 | Bank Error In Transit | E A |
RECWOSUM | 52 | BCD*10.3 | Reconciliation Write Off Sum | E A |
CURFUNC | 53 | String*3 | Functional Currency | E A |
CURSTMT | 54 | String*3 | Statement Currency | E A |
PAYMCODE | 55 | String*12 | Payment Code | E A |
RECDELTAF | 56 | BCD*10.3 | Functional Discrepancy | E A |
CCEXP | 57 | Date | Expiry Date | E A |
FSCYEAR | 58 | String*4 | Fiscal Year | E A |
FSCPERIOD | 59 | Integer | Fiscal Period | E A | List: 14 entries
0 | = |
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
SRCEDOCNUM | 60 | String*22 | Source Document Number | E A |
CANREVINVC | 61 | Integer | Can Reverse Invoice | E A | List: 2 entries
0 | = | No
1 | = | Yes
REVINVC | 62 | Integer | Reverse Invoice | E A | List: 2 entries
0 | = | No
1 | = | Yes
RECRCLR | 63 | BCD*10.3 | Fiscal Cleared To Current | E A |
RETDATE | 64 | Date | Return Date | E A |
RECFCLR | 123 | BCD*10.3 | Fiscal Cleared To Future | E A |
RECTDEPB | 124 | BCD*10.3 | Total Book Amount | E A |
RECTDEPREM | 125 | BCD*10.3 | Total Remaining Amount | E A |
SUMDEPOSIT | 126 | BCD*10.3 | Summated Deposit Amount | E A |

This page was generated on 2008-May-01

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