| DB | Areas | X-idx | Tables | Sequences | <- csd-client-func | csd-ctrl -> | HtmlDict 11 |
CSD Contracts
| Area | Data |
|---|---|
| Dumpname | csdcntrc |
| Label | CSD Contracts |
| Val.exp | ? |
| Val.msg |
| Order | Field Name | x | Label | Datatype | Format | Initial | Mand | Description |
|---|---|---|---|---|---|---|---|---|
| 50 | add-hour | X | Add Tariff | integer | >,>>9 | 0 | ||
| 70 | bill-hour | X | Billed Hours | decimal-1 | >>,>>9.9 | 0 | ||
| 20 | client-no | X | Client No | character | x(6) | |||
| 30 | contr-hour | X | Contr Hours | integer | >>,>>9 | 0 | ||
| 10 | contr-no | X | Contract No | character | x(15) | |||
| 22 | contr-type | X | Type | integer | 99 | 0 | ||
| 40 | hour-tar | X | Hour Tariff | integer | >,>>9 | 0 | ||
| 80 | paid-hour | X | Paid Hours | decimal-1 | >>,>>9.9 | 0 | ||
| 60 | remain-time | X | Remaining Time | decimal-0 | (>>,>>9.9) | 0.0 | ||
| 25 | stat-cde | X | Status Code | integer | 99 | 01 |
| Index name | Flags | Fields | Datatype |
|---|---|---|---|
| contr-no | P U | contr-no (+) | character |
| client-stat | client-no (+) | character | |
| stat-cde (+) | integer | ||
| contr-no (+) | character |
| + = Ascending | - = Descending | P = Primary | U = Unique | I = Inactive | W = Wordindex |
| generated 3-3-2025 10:31 |