# Table: Deposits Posting Journal

Table: BKJDEPH
View: BK0550
Record length: 456
Flags: A R

## Keys: 2

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

## Fields: 47

Field | Type | Title | Presentation
--- | --- | --- | ---
PSTSEQ | BCD*5.0 | Posting Sequence |
BANK | String*8 | Bank Code | Mask: %-8N
SERIAL | Long | Deposit Header Serial |
AUDTDATE | Date |  |
AUDTTIME | Time |  |
AUDTUSER | String*8 |  |
AUDTORG | String*6 |  |
SRCEAPP | String*2 | Source Application | Mask: %-2N
REFERENCE | String*60 | Deposit Reference |
COMMENT | String*60 | Deposit Description |
DEPDATE | Date | Deposit Date |
FSCYEAR | String*4 | Fiscal Year | Mask: %04D
FSCPERIOD | Integer | Fiscal Period | 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 | Integer | Deposit Slip Printed | List: 2 entries
0 | = | No
1 | = | Yes
TOTDEPOSIT | BCD*10.3 | Total Deposited |
TOTTRANSIT | BCD*10.3 | Total In Transit |
TOTCLEARED | BCD*10.3 | Total Cleared |
NXTLINE | Long | Next Deposit Detail Line |
LINES | Long | Lines |
LINESPOST | Long | Lines In Transit |
LINESREC | Long | Lines Reconciled |
STATUS | Integer | Deposit Status | List: 7 entries
1 | = | Unposted
2 | = | Partially in transit
3 | = | In transit
4 | = | Partially reconciled
5 | = | Reconciled
6 | = | Posted
7 | = | Purged
RECERR | BCD*10.3 | Reconciliation Error |
RECERRPEND | BCD*10.3 | Reconciliation Error Pending |
RECEXGAIN | BCD*10.3 | Reconciliation Exchange Gain |
RECEXLOSS | BCD*10.3 | Reconciliation Exchange Loss |
RECDEPOSIT | BCD*10.3 | Reconciliation Deposit Amount |
RECTRANSIT | BCD*10.3 | Reconciliation In Transit Amt |
DEPOSIT | BCD*5.0 | Deposit Slip Number |
SUMMARY | Integer | Deposit Recorded in Summary | List: 3 entries
0 | = | Detail
1 | = | Summary
2 | = | Transfer
RECCCC | BCD*10.3 | Reconciliation Credit Card Charg |
RECCLEARED | BCD*10.3 | Amount Cleared |
RECFUNCAMT | BCD*10.3 | Functional Deposit Amount |
TOTFUNCAMT | BCD*10.3 | Functional Total Deposited |
TOCLEAR | BCD*10.3 | Amount to Clear |
TOWRITEOFF | BCD*10.3 | Amount to Write Off |
TOREMAIN | BCD*10.3 | Amount to Remain In Transit |
VARIANCE | Integer | Variance Type | 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 | Integer | Write Off Method | List: 3 entries
0 | = | None
1 | = | Prorate
2 | = | Top down
RECDATE | Date | Default Reconciliation Date |
RECSTATUS | Integer | Default Reconciliation Status | List: 7 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
RECCOMMENT | String*60 | Default Reconciliation Desc. |
RECWOSUM | BCD*10.3 | Reconciliation Write Off Sum |
CURFUNC | String*3 | Functional Currency |
CURSTMT | String*3 | Statement Currency |
LINESJOUR | Long | Lines Journalled |
LINESPUR | Long | Lines Purged |

This page was generated on 2006-Sep-07

Copyright © 2001–2005 Sage Accpac International, Inc.