| DB | Areas | X-idx | Tables | Sequences | <- cbk-bnkstmnt | cbk-bnktrntype -> | HtmlDict 11 |
Bank transactions from bank statement
| Area | FinData |
|---|---|
| Dumpname | bnktrn |
| Label | Bank transactions from bank statement |
| Val.exp | ? |
| Val.msg |
| Order | Field Name | x | Label | Datatype | Format | Initial | Mand | Description |
|---|---|---|---|---|---|---|---|---|
| 5 | bank-acct-id | X | Account ID | integer | >>9 | 0 | ||
| 60 | bank-stmnt-date | X | Bank Statement Date | date | 99/99/9999 | ? | ||
| 30 | bank-stmnt-no | X | Bank Statement No | integer | >>>>>9 | 0 | ||
| 50 | bank-trn-no | X | Bank Trn No | character | x(8) | |||
| 80 | bank-trn-stat | X | Bank Trn Stat | character | x(2) | |||
| 70 | bank-trn-type | X | Bank Trn Type | character | x(3) | |||
| 90 | chq-no | X | Cheque No | integer | 9999999999 | 0 | ||
| 220 | dt-cr-no | X | Dt/Cr No | character | xxxxxx-xx-x | |||
| 250 | import-bank-desc | X | Import Bank Description | character | x(30) | |||
| 240 | import-bank-trn-type | X | Imp Bank Trn Type | character | x(6) | |||
| 230 | line-type | X | Trn Line Type | character | x(3) | |||
| 260 | match-no | X | Match No | character | x(10) | |||
| 100 | recvd-name | X | Received Name | character | x(30) | |||
| 140 | trn-amt | X | Trans Amount | decimal-2 | >>,>>>,>>9.99- | 0 | ||
| 110 | trn-date | X | Transaction date | date | 99/99/9999 | ? | ||
| 270 | trn-no | X | Transaction No | character | x(10) | D: | ||
| 150 | upd-date | X | Updated | date | 99/99/9999 | ? | ||
| 160 | upd-time | X | At | integer | 99999 | 0 | ||
| 170 | upd-user-id | X | By | character | x(12) | D: User ID. |
| Index name | Flags | Fields | Datatype |
|---|---|---|---|
| bank-acct-id | P | bank-acct-id (+) | integer |
| bank-stmnt-no (+) | integer | ||
| trn-date (+) | date | ||
| bank-acct-match | bank-acct-id (+) | integer | |
| match-no (+) | character | ||
| bank-trn-no | U | bank-trn-no (+) | character |
| line-type | bank-acct-id (+) | integer | |
| line-type (+) | character | ||
| bank-trn-stat (+) | character | ||
| trn-date (+) | date | ||
| match-no | match-no (+) | character |
| + = Ascending | - = Descending | P = Primary | U = Unique | I = Inactive | W = Wordindex |
| Parent tables |
|---|
| cbk-bnkstmnt cbk-bnktrntype cbk-match inv-combocom inv-comboitem |
| generated 18-9-2026 10:01 |