| DB | Areas | X-idx | Tables | Sequences | <- cbk-benific | cbk-bnkrecon -> | HtmlDict 11 |
Bank Accounts for organisation
| Area | FinData |
|---|---|
| Dumpname | bnkacct |
| Label | Bank Accounts for organisation |
| Val.exp | ? |
| Val.msg |
| Event | Procedure | Overr | CRC |
|---|---|---|---|
| DELETE | trigs/debnkacct.t | ||
| WRITE | trigs/wrbnkacct.t |
| Order | Field Name | x | Label | Datatype | Format | Initial | Mand | Description |
|---|---|---|---|---|---|---|---|---|
| 6 | acct-name | X | Account Name | character | x(30) | |||
| 5 | bank-acct-id | X | Account ID | integer | >>9 | 0 | ||
| 10 | bank-acct-no | X | Bank Account No | character | x(12) | |||
| 30 | bank-acct-type | X | Bank Account Type | character | ! | |||
| 20 | bank-branch-no | X | Bank Branch No | character | x(8) | |||
| 35 | bank-cde | X | Bank Code | character | x(2) | |||
| 40 | branch-name | X | Branch Name | character | x(15) | |||
| 220 | com-acct-cde | X | Commision Acct Code | character | x(4) | |||
| 200 | com-ind | X | Commission Ind | logical | Yes/No | NO | ||
| 210 | com-perc | X | Commission Perc | decimal-2 | >>9.99 | 0 | ||
| 150 | ctrl-acct-cde | X | Control Acct Code | character | x(4) | |||
| 143 | ctrl-area-cde | X | Control Area Code | character | x(3) | |||
| 146 | ctrl-cost-cde | X | Control Cost Code | character | x(4) | |||
| 240 | date-input | X | Statement/input date | logical | Statement/input | no | D: Specify which input of date will be used statement or screen | |
| 190 | deposit-ind | X | Deposit Ind | logical | Yes/No | Yes | ||
| 180 | e-bank-cde | X | Elec Bank Code | character | x(2) | |||
| 50 | e-ln-no | X | Elec Line No | character | x(10) | |||
| 100 | X | character | x(24) | |||||
| 55 | e-trnf-ind | X | Electronic Transfer Ind | logical | Yes/No | NO | ||
| 80 | fax-cde | X | Fax Code | character | x(7) | |||
| 90 | fax-no | X | Fax No | character | x(10) | |||
| 160 | int-acct-cde | X | Interst Acct Code | character | x(4) | |||
| 110 | post-addr | X | Postal Address | character | x(24) | |||
| 140 | post-cde | X | Postal Code | character | 9999 | 0000 | ||
| 130 | post-city | X | Postal City | character | x(24) | |||
| 120 | post-suburb | X | Postal Suburb | character | x(24) | |||
| 230 | sb-id | X | Standardbank Id | character | x(15) | |||
| 170 | serv-acct-cde | X | Service Acct Code | character | x(4) | |||
| 60 | tel-cde | X | Tel Code | character | x(7) | |||
| 70 | tel-no | X | Tel No | character | x(10) |
| Index name | Flags | Fields | Datatype |
|---|---|---|---|
| bank-acct-no | P U | bank-acct-no (+) | character |
| bank-branch-no (+) | character | ||
| bank-acct-id | U | bank-acct-id (+) | integer |
| + = Ascending | - = Descending | P = Primary | U = Unique | I = Inactive | W = Wordindex |
| Parent tables |
|---|
| pos-apprcheq |
| Child tables |
|---|
| acr-clntacct acs-payreq cbk-benific cbk-cheqreg cbk-rdcheq cbk-tender ins-company pos-blacklist prs-employee pur-vendor sal-benefic |
| generated 18-9-2026 10:01 |