| DB | Areas | X-idx | Tables | Sequences | <- acr-clntinv-ln | acr-control -> | HtmlDict 11 |
Client contact persons
| Area | FinData |
|---|---|
| Dumpname | arcont |
| Label | Client contact persons |
| Val.exp | ? |
| Val.msg |
| Event | Procedure | Overr | CRC |
|---|---|---|---|
| DELETE | trigs/dearcont.t | ||
| WRITE | trigs/wrarcont.t |
| Order | Field Name | x | Label | Datatype | Format | Initial | Mand | Description |
|---|---|---|---|---|---|---|---|---|
| 10 | acct-no | X | Acct | character | xxxxxx-xx-x | |||
| 84 | birth-day | X | Birth Day | character | 99/99 | |||
| 70 | cell-no | X | Cell No | character | x(15) | |||
| 26 | contact-title | X | Title | character | x(5) | |||
| 20 | contact-type | X | Contact Type | character | !x | |||
| 80 | X | character | x(24) | |||||
| 60 | fax-no | X | Fax No | character | x(15) | |||
| 36 | first-name | X | First Name | character | x(12) | |||
| 24 | initials | X | Initials | character | x(10) | |||
| 40 | lang-pref | X | Language | character | x(3) | |||
| 82 | pos | X | Position | character | x(25) | |||
| 22 | surname | X | Surname | character | x(50) | |||
| 50 | tel-no | X | Tel No | character | x(20) | |||
| 90 | upd-date | X | Updated | date | 99/99/9999 | ? | ||
| 100 | upd-time | X | At | integer | 99999 | 0 | ||
| 110 | upd-user-id | X | By | character | x(12) |
| Index name | Flags | Fields | Datatype |
|---|---|---|---|
| acct-no-contact-type | P | acct-no (+) | character |
| contact-type (+) | character | ||
| birth-day | birth-day (+) | character | |
| surname-init | surname (+) | character | |
| initials (+) | character |
| + = Ascending | - = Descending | P = Primary | U = Unique | I = Inactive | W = Wordindex |
| Parent tables |
|---|
| acr-clntacct inv-combocom inv-comboitem |
| generated 18-9-2026 10:01 |