# View: Bank Checks

RotoID: BK0004
Table: BKCHK
Protocol: Detail, Ordered revisions, Key auto generate
DLL: BKCHK

## Compositions: 6

RotoID | Tables | Title | DLL
--- | --- | --- | ---
BK0001 | BKACCT | Banks | BKACCT
BK0008 | BKFORM | Check Stocks | BKFORM
CS0004 | CSCRT | Rate Types | CSCRT
BK0002 | BKCUR | Bank Currencies | BKCUR
BK0003 | BKTT | Bank Transaction Types | BKTT
BK0240 | BKCCTYP | Credit Card Types | BKCCTYP

## Keys: 8

Title | Fields
--- | ---
Bank Check | BANK, CHECK, SERIAL
Bank Fiscal Check | BANK, FSCYEAR, FSCPERIOD, CHECK, SERIAL
Bank Serial Check | BANK, SERIAL, CHECK
Bank Reconciliation Fiscal Check | BANK, RECYEAR, RECPERIOD, CHECK, SERIAL
Bank Withdrawal Date | BANK, CHKDATE, CHECK, SERIAL
Bank Withdrawal Type | BANK, CHKTYPE, CHECK, SERIAL
Bank Withdrawal Total | BANK, SISSUED, CHECK, SERIAL
Bank Withdrawal Remaining Outsta | BANK, RECPENDING, CHECK, SERIAL

## Fields: 87

Field | Index | Type | Title | Attributes | Presentation
--- | --- | --- | --- | --- | ---
BANK | 1 | String*8 | Bank Code | E A K R | Mask: %-8N
CHECK | 2 | BCD*5.0 | Withdrawal Number | E A K R |
SERIAL | 3 | Long | Serial Number | E A K R |
STATUS | 4 | Integer | Withdrawal Status | E A X | 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 | 5 | String*2 | Source Application | E A R X | Mask: %-2N
CHKTYPE | 6 | Integer | Withdrawal Type | E A R X | List: 7 entries
1 | = | Check
2 | = | EFT
3 | = | Transfer
4 | = | Service Charge
5 | = | Credit Card
6 | = | Cash
7 | = | Other
CHKFORM | 7 | String*6 | Check Stock Code | E A R X | Mask: %-6N
PAYEEID | 8 | String*12 | Payee Code | E A X | Mask: %-12C
PAYEENAME | 9 | String*60 | Payee Name | E A X |
VENDORNAME | 10 | String*60 | Vendor Name | E A X |
REFERENCE | 11 | String*60 | Withdrawal Reference | E A X |
COMMENT | 12 | String*60 | Withdrawal Description | E A X |
POSTED | 13 | Date | Document Posting Date | E A X |
CHKDATE | 14 | Date | Withdrawal Date | E A X |
ISSUED | 15 | BCD*10.3 | Functional Withdrawal Amount | E A X |
SISSUED | 16 | BCD*10.3 | Payment Amount | E A X |
RATETYPE | 17 | String*2 | Exchange Rate Type | E A X | Mask: %-2N
SRCECURN | 18 | String*3 | Payment Currency | E A X | Mask: %-3N
RATEDATE | 19 | Date | Exchange Rate Date | E A X |
RATE | 20 | BCD*8.7 | Exchange Rate | E A X |
RATESPREAD | 21 | BCD*8.7 | Rate Spread | E A X |
RATEOP | 22 | Integer | Rate Operation | E A X | List: 3 entries
1 | = | Multiply
2 | = | Divide
0 | = | Not Specified
RECSTATUS | 23 | Integer | Reconciliation Status | A P X | List: 4 entries
2 | = | Void
3 | = | Outstanding
9 | = | Printed
10 | = | Posting error
RECSTATCHG | 24 | Date | Status Change Date | A C |
RECCOMMENT | 25 | String*60 | Reconciliation Description | A X |
RECCLEARED | 26 | BCD*10.3 | Reconciliation Cleared Amount | A X |
FSCYEAR | 27 | String*4 | Fiscal Year | E A X | Mask: %04D
FSCPERIOD | 28 | Integer | Fiscal Period | E A P X | List: 12 entries
1 | = | 1
2 | = | 2
3 | = | 3
4 | = | 4
5 | = | 5
6 | = | 6
7 | = | 7
8 | = | 8
9 | = | 9
10 | = | 10
11 | = | 11
12 | = | 12
TTYPE | 29 | String*6 | Transaction Type | A X | Mask: %-6N
GLACCOUNT | 30 | String*45 | G/L Account | A X | Mask: %-45C
RECDATE | 31 | Date | Reconciliation Date | A X |
RECYEAR | 32 | String*4 | Reconciliation Fiscal Year | A X | Mask: %04D
RECPERIOD | 33 | Integer | Reconciliation Fiscal Period | A P X | List: 1 entries
0 | = |
RECONCILED | 34 | Boolean | Reconciled | A C |
CCTYPE | 35 | String*12 | Credit Card Type | A X | Mask: %-12N
CCNUMBER | 36 | Binary*32 | Credit Card Number | A X |
CCNAME | 37 | String*60 | Cardholder Name | A X |
CCAUTHCODE | 38 | String*20 | Authorization Code | A X |
CCEXP | 39 | Date | Expiry Date | A X |
RECERR | 40 | BCD*10.3 | Reconciliation Error | A C |
RECERRPEND | 41 | BCD*10.3 | Reconciliation Error Pending | A C |
RECEXGAIN | 42 | BCD*10.3 | Reconciliation Exchange Gain | A C |
RECEXLOSS | 43 | BCD*10.3 | Reconciliation Exchange Loss | A C |
RECSUGGEST | 44 | Integer | Reconciliation Suggestion | A C | 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
RECCHECK | 45 | BCD*10.3 | Withdrawal Amount | A C |
RECOUTSTND | 46 | BCD*10.3 | Outstanding Amount | A C |
RECTARGET | 47 | Integer | Reconciliation Target | A C | List: 6 entries
0 | = | No Target
1 | = | Bank Error
2 | = | Bank Pending Error
3 | = | Exchange Gain
4 | = | Exchange Loss
5 | = | Credit Card Charge
TTYPED | 48 | String*60 | Transaction Type Description | A |
GLACCOUNTD | 49 | String*60 | G/L Account Description | A |
RECDELTA | 50 | BCD*10.3 | Reconciliation Amount Delta | A C |
XCCNUMBER | 51 | String*32 | Decrypted Credit Card Number | E A | Mask: %-32D
RECCCC | 52 | BCD*10.3 | Reconciliation Credit Card Charge | A C |
RECWOSUM | 53 | BCD*10.3 | Write-Off Amount | A C |
CURFUNC | 54 | String*3 | Functional Currency | A C |
CURSTMT | 55 | String*3 | Statement Currency | A C |
SUMCHECK | 56 | BCD*10.3 | Summated Withdrawal Amount | A C |
RECSPREAD | 57 | BCD*10.3 | Reconciliation Spread | A C |
RECPCHK | 58 | BCD*10.3 | Fiscal Withdrawal Remaining Outstanding | A C |
RECPCHKOS | 59 | BCD*10.3 | Fiscal Outstanding Amount | A C |
RECPWO | 60 | BCD*10.3 | Fiscal Write Offs | A C |
RECPERR | 61 | BCD*10.3 | Fiscal Bank Errors | A C |
RECPGAIN | 62 | BCD*10.3 | Fiscal Exchange Gain | A C |
RECPLOSS | 63 | BCD*10.3 | Fiscal Exchange Loss | A C |
RECPCCC | 64 | BCD*10.3 | Fiscal Credit Card Charges | A C |
RECPCLR | 65 | BCD*10.3 | Fiscal Cleared | A C |
RECPFUNAM | 66 | BCD*10.3 | Fiscal Withdrawal Amount | A C |
RECTCHKB | 67 | BCD*10.3 | Total Book Amount | A C |
RECPCHKB | 68 | BCD*10.3 | Fiscal Book Amount | A C |
RECTCHKREM | 69 | BCD*10.3 | Total Remaining Amount | A C |
RECPCHKREM | 70 | BCD*10.3 | Fiscal Remaining Amount | A C |
RECRWOSUM | 71 | BCD*10.3 | Fiscal Write-Off To This Period | A C |
RECFCLR | 72 | BCD*10.3 | Fiscal Cleared To Future | A C |
RECRCLR | 73 | BCD*10.3 | Fiscal Cleared To Current | A C |
RECWOSUMR | 74 | BCD*10.3 | Current Period's Write-Off | A C |
RECPCHKO | 75 | BCD*10.3 | Fiscal Withdrawal Amount | A C |
RECFCLRR | 76 | BCD*10.3 | Posted Fiscal Cleared To Future | A C |
AGERECLD | 77 | Integer | No. of Days Since Reconciled | A C |
DDTYPE | 80 | Integer | Drilldown Type | E A |
DDLINK | 81 | BCD*10.0 | Drilldown Link | E A |
PAYMCODE | 82 | String*12 | Payment Code | E A X |
RECPENDING | 83 | BCD*10.3 | Withdrawal Remaining Outstanding | A |
SRCEDOCNUM | 84 | String*22 | Source Document Number | E A X |
CANREVINVC | 85 | Integer | Can Reverse Invoice | E A X | List: 2 entries
0 | = | No
1 | = | Yes
REVINVC | 86 | Integer | Reverse Invoice | A X | List: 2 entries
0 | = | No
1 | = | Yes
COMPLETED | 87 | Integer | Reconciled and Journaled Transaction | E A X | List: 2 entries
0 | = | Not Completed
10 | = | Completed
PSTSEQ | 88 | BCD*5.0 | Posting Sequence | E A |
POSTDATE | 89 | Date | Reconciliation Posting Date | A X |

This page was generated on 2008-May-01

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