# View: Deposits Posting Journal

RotoID: BK0550
Table: BKJDEPH
Protocol: Detail, Ordered revisions
DLL: BKJDEPH

## Compositions: 2

RotoID | Tables | Title | DLL
--- | --- | --- | ---
BK0011 | BKJRNL | Bank Posting Journal | BKJRNL
BK0540 | BKJDEPD | Deposit Details Posting Journal | BKJDEPD

## Keys: 2

Title | Fields
--- | ---
Deposit Uniquifier | PSTSEQ, BANK, SERIAL
Deposit Slip Number | PSTSEQ, BANK, DEPOSIT, SERIAL

## Fields: 48

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 |
SRCEAPP | 4 | String*2 | Source Application | E A | Mask: %-2N
REFERENCE | 5 | String*60 | Deposit Reference | E A |
COMMENT | 6 | String*60 | Deposit Description | E A |
DEPDATE | 7 | Date | Deposit Date | E A |
FSCYEAR | 8 | String*4 | Fiscal Year | E A | Mask: %04D
FSCPERIOD | 9 | 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
PRINTED | 10 | Integer | Deposit Slip Printed | E A | List: 2 entries
0 | = | No
1 | = | Yes
TOTDEPOSIT | 11 | BCD*10.3 | Total Deposited | E A |
TOTTRANSIT | 12 | BCD*10.3 | Total In Transit | E A |
TOTCLEARED | 13 | BCD*10.3 | Total Cleared | E A |
NXTLINE | 14 | Long | Next Deposit Detail Line | E A |
LINES | 15 | Long | Lines | E A |
LINESPOST | 16 | Long | Lines In Transit | E A |
LINESREC | 17 | Long | Lines Reconciled | E A |
STATUS | 18 | Integer | Deposit Status | E A | List: 7 entries
1 | = | Not posted
2 | = | Partially in transit
3 | = | In transit
4 | = | Partially reconciled
5 | = | Reconciled
6 | = | Posted
7 | = | Purged
RECERR | 19 | BCD*10.3 | Reconciliation Error | E A |
RECERRPEND | 20 | BCD*10.3 | Reconciliation Error Pending | E A |
RECEXGAIN | 21 | BCD*10.3 | Reconciliation Exchange Gain | E A |
RECEXLOSS | 22 | BCD*10.3 | Reconciliation Exchange Loss | E A |
RECDEPOSIT | 23 | BCD*10.3 | Reconciliation Deposit Amount | E A |
RECTRANSIT | 24 | BCD*10.3 | Reconciliation In Transit Amt | E A |
DEPOSIT | 25 | BCD*5.0 | Deposit Slip Number | E A |
SUMMARY | 26 | Integer | Deposit Recorded in Summary | E A | List: 3 entries
0 | = | Detail
1 | = | Summary
2 | = | Transfer
RECCCC | 27 | BCD*10.3 | Reconciliation Credit Card Charge | E A |
RECCLEARED | 28 | BCD*10.3 | Amount Cleared | E A |
RECFUNCAMT | 29 | BCD*10.3 | Functional Deposit Amount | E A |
TOTFUNCAMT | 30 | BCD*10.3 | Functional Total Deposited | E A |
TOCLEAR | 31 | BCD*10.3 | Amount to Clear | E A |
TOWRITEOFF | 32 | BCD*10.3 | Amount to Write Off | E A |
TOREMAIN | 33 | BCD*10.3 | Amount to Remain In Transit | E A |
VARIANCE | 34 | Integer | Variance Type | E A | List: 6 entries
0 | = | None
1 | = | In transit amount
2 | = | Amount to write off
3 | = | Bank error
4 | = | Exchange rate difference
5 | = | Credit card charge
WOMETHOD | 35 | Integer | Write Off Method | E A | List: 3 entries
0 | = | None
1 | = | Prorate
2 | = | Top down
RECDATE | 36 | Date | Default Reconciliation Date | E A |
RECSTATUS | 37 | Integer | Default Reconciliation Status | E A | List: 8 entries
1 | = | Not posted
3 | = | In transit
4 | = | Cleared
5 | = | Cleared with bank error
6 | = | Cleared with write-off
8 | = | Cleared with exchange rate difference
9 | = | Cleared with credit card charge
10 | = | Deleted
RECCOMMENT | 38 | String*60 | Default Reconciliation Desc. | E A |
RECWOSUM | 39 | BCD*10.3 | Reconciliation Write Off Sum | E A |
CURFUNC | 40 | String*3 | Functional Currency | E A |
CURSTMT | 41 | String*3 | Statement Currency | E A |
LINESJOUR | 42 | Long | Lines Journalled | E A |
LINESPUR | 43 | Long | Lines Purged | E A |
RECRCLR | 44 | BCD*10.3 | Fiscal Cleared To Current | E A |
TOCLEARR | 45 | BCD*10.3 | Clear To Reconciliation Period | E A |
RECFCLR | 123 | BCD*10.3 | Fiscal Cleared To Future | E A |
TOCLEARF | 124 | BCD*10.3 | Clear To Future Period | E A |
RECPREM | 125 | BCD*10.3 | Fiscal Remaining In Transit | E A |

This page was generated on 2008-May-01

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