| DB | Areas | X-idx | Tables | Sequences | <- pos-apprcheq | pos-blacklist -> | HtmlDict 11 |
Arms Register
| Area | FinData |
|---|---|
| Dumpname | armregis |
| Label | Arms Register |
| Val.exp | ? |
| Val.msg |
| Order | Field Name | x | Label | Datatype | Format | Initial | Mand | Description |
|---|---|---|---|---|---|---|---|---|
| 140 | acct-no | X | Acct | character | xxxxxx-xx-x | |||
| 200 | add-desc | X | Addisional Info | character | x(30) | |||
| 40 | addr | X | Address | character [2] | x(24) | |||
| 110 | cell-no | X | Cell No | character | x(15) | |||
| 60 | city | X | City | character | x(24) | |||
| 30 | client-name | X | Client Name | character | x(50) | |||
| 210 | comment | X | Comment | character | x(30) | |||
| 170 | deliv-date | X | Delivered date | date | 99/99/9999 | ? | ||
| 120 | X | character | x(24) | |||||
| 100 | home-tel | X | Home Tel | character | x(15) | |||
| 80 | id-no | X | Id No | character | x(13) | |||
| 160 | inv-date | X | Invoice Date | date | 99/99/9999 | ? | ||
| 10 | item-no | X | Item No | character | x(15) | |||
| 20 | lot-no | X | Batch No | character | x(10) | |||
| 70 | post-cde | X | Postal Code | character | 9999 | |||
| 150 | recvd-date | X | Received Date | date | 99/99/9999 | ? | ||
| 180 | sls-val | X | Sales Value | decimal-2 | >>,>>>,>>9.99- | 0 | ||
| 50 | suburb | X | Suburb | character | x(24) | |||
| 220 | upd-date | X | Updated | date | 99/99/9999 | ? | ||
| 230 | upd-time | X | At | integer | 99999 | 0 | ||
| 240 | upd-user-id | X | By | character | x(12) | |||
| 190 | vat-amt | X | Vat Amount | decimal-2 | >,>>9.99- | 0 | ||
| 130 | vendor-no | X | Vendor No | character | x(6) | |||
| 90 | work-tel | X | Work Tel | character | x(15) |
| Index name | Flags | Fields | Datatype |
|---|---|---|---|
| pos-armreg | P U | item-no (+) | character |
| lot-no (+) | character | ||
| name-reg | client-name (+) | character |
| + = Ascending | - = Descending | P = Primary | U = Unique | I = Inactive | W = Wordindex |
| Parent tables |
|---|
| coe-comment inv-combocom inv-comboitem inv-itemlot pur-vendor sys-town |
| Child tables |
|---|
| inv-lottrn |
| generated 18-9-2026 09:33 |