# Table: Deposit Details Posting Journal

Table: BKJDEPD
View: BK0540
Record length: 750
Flags: A R

## Keys: 1

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

## Fields: 68

Field | Type | Title | Presentation
--- | --- | --- | ---
PSTSEQ | BCD*5.0 | Posting Sequence |
BANK | String*8 | Bank Code | Mask: %-8N
SERIAL | Long | Deposit Header Serial |
LINE | Long | Deposit Detail Line |
AUDTDATE | Date |  |
AUDTTIME | Time |  |
AUDTUSER | String*8 |  |
AUDTORG | String*6 |  |
SRCEAPP | String*2 | Source Application | Mask: %-2N
STATUS | Integer | Deposit Status | List: 5 entries
1 | = | Not posted
2 | = | Void
3 | = | In transit
5 | = | Cleared with bank error
7 | = | Returned
DEPTYPE | Integer | Deposit Type | List: 6 entries
1 | = | Deposit (Other)
2 | = | EFT
3 | = | Transfer
4 | = | Customer Check
5 | = | Credit Card
6 | = | Cash
IDREMIT | String*24 | Remittance ID |
DATEREMIT | Date | Remit Date |
BTCHNBR | BCD*5.0 | Batch Number |
ENTRYNBR | BCD*4.0 | Entry Number |
POSTSEQ | BCD*5.0 | Posting Sequence Number |
POSTDATE | Date | Date Posted |
REFERENCE | String*60 | Deposit Reference |
COMMENT | String*60 | Deposit Description |
PAYORID | String*12 | Payor ID |
PAYORNAME | String*60 | Payor Name |
DEPAMT | BCD*10.3 | Functional Deposit Amount |
SDEPAMT | BCD*10.3 | Deposit Amount |
RATETYPE | String*2 | Exchange Rate Type | Mask: %-2N
SRCECURN | String*3 | Payment Currency | Mask: %-3N
RATEDATE | Date | Exchange Rate Date |
RATE | BCD*8.7 | Exchange Rate |
RATESPREAD | BCD*8.7 | Rate Spread |
RATEOP | Integer | Rate Operation | List: 3 entries
1 | = | Multiply
2 | = | Divide
0 | = | Not Specified
TTYPE | String*6 | Transaction Type | Mask: %-6N
IDACCT | String*45 | G/L Account | Mask: %-45C
IDACCTOVR | Boolean | Account Number Override |
CCTYPE | String*12 | Credit Card Type | Mask: %-12N
CCNAME | String*60 | Cardholder Name |
DDTYPE | Integer | Drilldown Type |
DDLINK | BCD*10.0 | Drilldown Link |
RECSTATUS | Integer | Reconciliation Status | 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 | Date | Status Change Date |
RECCOMMENT | String*60 | Reconciliation Description |
RECCLEARED | BCD*10.3 | Reconciliation Amount Cleared |
RECDATE | Date | Reconciliation Date |
RECYEAR | String*4 | Reconciliation Fiscal Year | Mask: %04D
RECPERIOD | Integer | Reconciliation 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
RECONCILED | Boolean | Reconciled |
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 |
RECSUGGEST | Integer | Reconciliation Suggestion |
RECDEPOSIT | BCD*10.3 | Reconciliation Deposit Amount |
RECTRANSIT | BCD*10.3 | Reconciliation In Transit Amt |
RECTARGET | Integer | Reconciliation Target |
RECDELTA | BCD*10.3 | Reconciliation Amount Delta |
RECCCC | BCD*10.3 | Reconciliation Credit Card Charge |
RECPENDING | BCD*10.3 | Bank Error In Transit |
RECWOSUM | BCD*10.3 | Reconciliation Write Off Sum |
CURFUNC | String*3 | Functional Currency |
CURSTMT | String*3 | Statement Currency |
PAYMCODE | String*12 | Payment Code |
RECDELTAF | BCD*10.3 | Functional Discrepancy |
CCEXP | Date | Expiry Date |
FSCYEAR | String*4 | Fiscal Year |
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
SRCEDOCNUM | String*22 | Source Document Number |
CANREVINVC | Integer | Can Reverse Invoice | List: 2 entries
0 | = | No
1 | = | Yes
REVINVC | Integer | Reverse Invoice | List: 2 entries
0 | = | No
1 | = | Yes
RECRCLR | BCD*10.3 | Fiscal Cleared To Current |
RETDATE | Date | Return Date |

This page was generated on 2008-May-01

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