| DB | Areas | X-idx | Tables | Sequences | <- pur-vendac | pur-vendcitem -> | HtmlDict 11 |
Address types
| Area | ProdData |
|---|---|
| Dumpname | pur-vend |
| Label | Address types |
| Val.exp | ? |
| Val.msg |
| Event | Procedure | Overr | CRC |
|---|---|---|---|
| DELETE | trigs/depur-vend.t | ||
| WRITE | trigs/wrpur-vend.t |
| Order | Field Name | x | Label | Datatype | Format | Initial | Mand | Description |
|---|---|---|---|---|---|---|---|---|
| 5 | addr-type | X | Address Type | character | !99 | |||
| 4 | branch-no | X | Branch No | integer | 999 | 0 | ||
| 10 | post-addr | X | Postal Address | character [2] | x(24) | |||
| 40 | post-cde | X | Postal Code | character | 9999 | |||
| 30 | post-city | X | Postal City | character | x(24) | |||
| 20 | post-suburb | X | Postal Suburb | character | x(24) | |||
| 50 | province | X | Province | character | x(15) | |||
| 3 | vendor-no | X | Vendor No | character | x(6) |
| Index name | Flags | Fields | Datatype |
|---|---|---|---|
| vendor-no | P U | vendor-no (+) | character |
| branch-no (+) | integer | ||
| addr-type (+) | character |
| + = Ascending | - = Descending | P = Primary | U = Unique | I = Inactive | W = Wordindex |
| Parent tables |
|---|
| pur-scanex-brn |
| generated 24-6-2026 08:36 |