| DB | Areas | X-idx | Tables | Sequences | <- pos-item | pos-ordln -> | HtmlDict 11 |
Online Order Header
| Area | ProdData |
|---|---|
| Dumpname | pos-ordhdr |
| Label | Online Order Header |
| Val.exp | ? |
| Val.msg |
| Order | Field Name | x | Label | Datatype | Format | Initial | Mand | Description |
|---|---|---|---|---|---|---|---|---|
| 20 | branch-no | X | Branch | integer | 999 | 0 | ||
| 310 | can-cde | X | Cancel Code | integer | 99 | 0 | D: Cancel Reason Code | |
| 280 | card-no | X | Card No | integer | 99999999 | 0 | ||
| 240 | comment | X | Comment | character | x(300) | |||
| 40 | cust-name | X | Customer Name | character | x(40) | |||
| 30 | cust-no | X | Customer Number | character | x(12) | |||
| 50 | cust-tel-no | X | Customer Tel No | character | x(25) | |||
| 190 | deliv-addr | X | Deliv Address | character [2] | x(60) | |||
| 210 | deliv-city | X | Deliv City | character | x(24) | |||
| 270 | deliv-fee | X | Delivery Fee | decimal-2 | ->>,>>9.99 | 0 | ||
| 250 | deliv-opt | X | Deliv Option | character | ! | |||
| 200 | deliv-suburb | X | Deliv Suburb | character | x(24) | |||
| 39 | driver-id | X | Driver User ID | character | x(12) | |||
| 320 | drv-tip | X | Driver Tip | decimal-2 | ->>,>>9.99 | 0 | ||
| 110 | inv-amt | X | Invoice Amount | decimal-2 | >>,>>>,>>9.99- | 0 | ||
| 100 | inv-no | X | Invoice No | character | x(12) | |||
| 70 | ord-amt | X | Ord Amt | decimal-2 | >,>>>,>>9.99- | 0 | ||
| 80 | ord-date | X | Order Date | date | 99/99/9999 | ? | ||
| 10 | ord-no | X | Order No | character | x(12) | |||
| 60 | ord-stat | X | Order Status | integer | 9 | 0 | ||
| 90 | ord-time | X | Order Time | integer | 999999 | 0 | ||
| 260 | pay-stat | X | Payment Status | character | x(2) | |||
| 160 | pick-date | X | Picked Date | date | 99/99/9999 | ? | ||
| 180 | pick-end-time | X | Picked End Time | integer | 999999 | 0 | ||
| 170 | pick-start-time | X | Picked Start Time | integer | 999999 | 0 | ||
| 150 | pick-user-id | X | Picker User ID | character | x(12) | |||
| 220 | recvd-by | X | Received By Name | character | x(40) | |||
| 230 | recvd-id | X | Received by ID | character | x(20) | |||
| 290 | sched-date | X | Sched Date | date | 99/99/9999 | ? | ||
| 300 | sched-time | X | Sched Time | integer | >>>>9 | 0 | ||
| 120 | upd-date | X | Updated | date | 99/99/9999 | ? | ||
| 130 | upd-time | X | At | integer | 99999 | 0 | ||
| 140 | upd-user-id | X | By | character | x(12) |
| Index name | Flags | Fields | Datatype |
|---|---|---|---|
| idx-ord | P U | ord-no (+) | character |
| idx-branch | branch-no (+) | integer | |
| idx-cust | cust-no (+) | character | |
| idx-driver-id | driver-id (+) | character | |
| idx-inv | inv-no (+) | character | |
| idx-stat | ord-stat (+) | integer | |
| branch-no (+) | integer |
| + = Ascending | - = Descending | P = Primary | U = Unique | I = Inactive | W = Wordindex |
| Parent tables |
|---|
| acr-arinv-csh acr-emptycrn inv-combocom inv-comboitem lsc-member-card pos-scanord pur-ordhdr sys-branch |
| Child tables |
|---|
| coe-disphdr coe-slipln pur-ordhdr |
| generated 24-6-2026 08:36 |