# View: Bank Check Posting Journal

RotoID: BK0014
Table: BKJCHK
Protocol: Detail, Ordered revisions
DLL: BKJCHK

## Compositions: 1

RotoID | Tables | Title | DLL
--- | --- | --- | ---
BK0011 | BKJRNL | Bank Posting Journal | BKJRNL

## Keys: 2

Title | Fields
--- | ---
Posting Sequence/Bank Code | PSTSEQ, BANK, CHECK, SERIAL
Bank Code/Check Number | BANK, CHECK

## Fields: 66

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
CHECK | 3 | BCD*5.0 | Check Number | E A K R |
SERIAL | 4 | Long | Serial Number | E A K R |
STATUS | 5 | Integer | Check Status | E A | List: 9 entries
1 | = | Alignment
2 | = | Void
3 | = | Outstanding
4 | = | Reversed
6 | = | Cleared with bank error
7 | = | Non-negotiable
8 | = | Continuation
9 | = | Printed
10 | = | Posting error
SRCEAPP | 6 | String*2 | Source Application | E A | Mask: %-2N
CHKTYPE | 7 | Integer | Check Type | E A | List: 7 entries
1 | = | Check
2 | = | EFT
3 | = | Transfer
4 | = | Service Charge
5 | = | Credit Card
6 | = | Cash
7 | = | Other
CHKFORM | 8 | String*6 | Check Stock Code | E A | Mask: %-6N
PAYEEID | 9 | String*12 | Payee Code | E A | Mask: %-12C
PAYEENAME | 10 | String*60 | Payee Name | E A |
VENDORNAME | 11 | String*60 | Vendor Name | E A |
REFERENCE | 12 | String*60 | Check Reference | E A |
COMMENT | 13 | String*60 | Check Description | E A |
POSTED | 14 | Date | Date Check Printed | E A |
CHKDATE | 15 | Date | Check Date | E A |
ISSUED | 16 | BCD*10.3 | Functional Check Amount | E A |
SISSUED | 17 | BCD*10.3 | Check Amount | E A |
RATETYPE | 18 | String*2 | Exchange Rate Type | E A | Mask: %-2N
SRCECURN | 19 | String*3 | Payment Currency | E A | Mask: %-3N
RATEDATE | 20 | Date | Exchange Rate Date | E A |
RATE | 21 | BCD*8.7 | Exchange Rate | E A |
RATESPREAD | 22 | BCD*8.7 | Rate Spread | E A |
RATEOP | 23 | Integer | Rate Operation | E A | List: 3 entries
1 | = | Multiply
2 | = | Divide
0 | = | Not Specified
RECSTATUS | 24 | Integer | Reconciliation Status | E A | List: 13 entries
1 | = | Alignment
2 | = | Void
3 | = | Outstanding
4 | = | Reversed
5 | = | Cleared
6 | = | Cleared with bank error
7 | = | Non-negotiable
8 | = | Continuation
9 | = | Printed
10 | = | Posting error
11 | = | Cleared with write-off
12 | = | Cleared with exchange rate difference
13 | = | Cleared with credit card charge
RECSTATCHG | 25 | Date | Status Change Date | E A |
RECCOMMENT | 26 | String*60 | Reconciliation Description | E A |
RECCLEARED | 27 | BCD*10.3 | Reconciliation Amount Cleared | E A |
FSCYEAR | 28 | String*4 | Fiscal Year | E A | Mask: %04D
FSCPERIOD | 29 | 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
TTYPE | 30 | String*6 | Transaction Type | E A | Mask: %-6N
RECERR | 31 | BCD*10.3 | Reconciliation Error | E A |
RECERRPEND | 32 | BCD*10.3 | Reconciliation Error Pending | E A |
RECEXGAIN | 33 | BCD*10.3 | Reconciliation Exchange Gain | E A |
RECEXLOSS | 34 | BCD*10.3 | Reconciliation Exchange Loss | E A |
RECSUGGEST | 35 | Integer | Reconciliation Suggestion | E A |
RECCHECK | 36 | BCD*10.3 | Reconciliation Check Amount | E A |
RECOUTSTND | 37 | BCD*10.3 | Reconciliation Outstanding Amount | E A |
RECTARGET | 38 | Integer | Reconciliation Target | E A |
IDACCT | 39 | String*45 | G/L Account | E A |
IDACCTOVR | 40 | Boolean | Account Number Override | E A |
RECDATE | 41 | Date | Reconciliation Date | E A |
RECYEAR | 42 | String*4 | Reconciliation Fiscal Year | E A |
RECPERIOD | 43 | 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 | 44 | Boolean | Reconciled | E A |
RECDELTA | 45 | BCD*10.3 | Reconciliation Amount Delta | E A |
CCTYPE | 46 | String*12 | Credit Card Type | E A | Mask: %-12N
CCNAME | 47 | String*60 | Cardholder Name | E A |
DDTYPE | 48 | Integer | Drilldown Type | E A |
DDLINK | 49 | BCD*10.0 | Drilldown Link | E A |
RECCCC | 50 | BCD*10.3 | Reconciliation Credit Card Charge | E A |
RECPENDING | 51 | BCD*10.3 | Bank Error Outstanding | 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 |
RECDELTAF | 55 | BCD*10.3 | Functional Discrepancy | E A |
CCEXP | 56 | Date | Expiry Date | E A |
PAYMCODE | 57 | String*12 | Payment Code | E A |
SRCEDOCNUM | 58 | String*22 | Source Document Number | E A |
CANREVINVC | 59 | Integer | Can Reverse Invoice | E A | List: 2 entries
0 | = | No
1 | = | Yes
REVINVC | 60 | Integer | Reverse Invoice | E A | List: 2 entries
0 | = | No
1 | = | Yes
RECRCLR | 61 | BCD*10.3 | Fiscal Cleared To Current | E A |
RECFCLR | 123 | BCD*10.3 | Fiscal Cleared To Future | E A |
RECTCHKB | 124 | BCD*10.3 | Total Book Amount | E A |
RECTCHKREM | 125 | BCD*10.3 | Total Remaining Amount | E A |
SUMCHECK | 126 | BCD*10.3 | Summated Withdrawal Amount | E A |
POSTDATE | 127 | Date | Post Date | E A |

This page was generated on 2008-May-01

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