| DB | Areas | X-idx | Tables | Sequences | <- icc-dealitem | icc-dept -> | HtmlDict 11 |
Deals for Region
| Area | ProdData |
|---|---|
| Dumpname | dealreg |
| Label | Deals for Region |
| Val.exp | ? |
| Val.msg |
| Order | Field Name | x | Label | Datatype | Format | Initial | Mand | Description |
|---|---|---|---|---|---|---|---|---|
| 20 | deal_id | X | Deal ID | integer | >>>>>9 | 0 | ||
| 10 | deal_region_id | X | Deal Region ID | integer | >>>>>9 | 0 | ||
| 30 | region_id | X | Region ID | integer | >>>>>9 | 0 | ||
| 50 | upd-date | X | Updated | date | 99/99/9999 | ? | ||
| 60 | upd-time | X | At | integer | 99999 | 0 | ||
| 40 | upd-user-id | X | By | character | x(12) |
| Index name | Flags | Fields | Datatype |
|---|---|---|---|
| region-deal | P | region_id (+) | integer |
| deal_id (+) | integer | ||
| deal-region | deal_id (+) | integer | |
| region_id (+) | integer | ||
| deal_region_id | U | deal_region_id (+) | integer |
| + = Ascending | - = Descending | P = Primary | U = Unique | I = Inactive | W = Wordindex |
| Parent tables |
|---|
| icc-region inv-combocom inv-comboitem |
| generated 24-6-2026 08:24 |