# View: Returned Customer Checks

RotoID: BK0006
Table: BKNSF
Protocol: Detail, Sequenced revisions, Key auto generate
DLL: BKNSF

## Compositions: 2

RotoID | Tables | Title | DLL
--- | --- | --- | ---
BK0001 | BKACCT | Banks | BKACCT
BK0026 | BKNSFD | Returned Customer Checks | BKNSFD

## Keys: 2

Title | Fields
--- | ---
Bank Code | BANK, UNIQUE
Bank Rec. Fiscal Returned Check | BANK, RECYEAR, RECPERIOD, UNIQUE

## Fields: 36

Field | Index | Type | Title | Attributes | Presentation
--- | --- | --- | --- | --- | ---
BANK | 1 | String*8 | Bank Code | E A K R | Mask: %-8N
UNIQUE | 2 | Long | Uniquifier | E A K C R |
SERIAL | 3 | Long | Serial Number | E A X |
DEPOSIT | 4 | BCD*5.0 | Deposit Number | E A X |
PAYER | 5 | String*12 | Customer Number | E A X | Mask: %-12C
ADDKEY | 6 | Binary*82 | Additional Check Segments | E A X |
SRCEAPP | 7 | String*2 | Source Application | E A X | Mask: %-2N
PAYOR | 8 | String*60 | Customer Name | E A X |
IDRMIT | 9 | String*24 | Transaction Number | E A X |
DATERMIT | 10 | Date | Transaction Date | E A X |
REFERENCE | 11 | String*60 | Transaction Reference | E A X |
POSTED | 12 | Date | Date Transaction Posted | E A X |
RECCOMMENT | 13 | String*60 | Reason For Return | E A |
RECAMOUNT | 14 | BCD*10.3 | Transaction Amount | E A X |
RECSTATUS | 17 | Integer | Reconciliation Status | E A | List: 2 entries
1 | = | Outstanding
2 | = | Cleared
RECSTATCHG | 18 | Date | Status Change Date | A C |
RECFAMOUNT | 19 | BCD*10.3 | Functional Transaction Amount | E A X |
RECDATE | 20 | Date | Reconciliation Date | E A X |
RECYEAR | 21 | String*4 | Reconciliation Fiscal Year | E A X | Mask: %04D
RECPERIOD | 22 | Integer | Reconciliation 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
RECONCILED | 23 | Boolean | Reconciled | A |
LINE | 24 | Long | Line Number | E A |
DDTYPE | 25 | Integer | Drilldown Type | E A |
DDLINK | 26 | BCD*10.0 | Drilldown Link | E A |
COMMENT | 27 | String*60 | Transaction Description | E A X |
SRCECURN | 28 | String*3 | Transaction Currency | E A | Mask: %-3N
REVINVC | 29 | Integer | Reverse Invoice | E A X | List: 2 entries
0 | = | No
1 | = | Yes
POSTDATE | 30 | Date | Post Date | E A X |
RECDEPOSIT | 31 | BCD*10.3 | Deposit Return Amount | A C |
RECTRANSIT | 32 | BCD*10.3 | In Transit Return Amount | A C |
MULTIPOST | 33 | Boolean | Posting Multiple Returns? | E A |
CURFUNC | 34 | String*3 | Functional Currency | A C |
CURSTMT | 35 | String*3 | Statement Currency | A C |
RECSTMTAMT | 36 | BCD*10.3 | Original Statement Amount | A C |
RECRDEP | 37 | BCD*10.3 | Deposit Up To This Period | A C |
RECRDEPIT | 38 | BCD*10.3 | In Transit Up To This Period | A C |

This page was generated on 2008-May-01

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