| DB | Areas | X-idx | Tables | Sequences | <- pur-ordac | pur-ordln -> | HtmlDict 11 |
Order Header
| Area | ProdData |
|---|---|
| Dumpname | pur-ordh |
| Label | Order Header |
| Val.exp | ? |
| Val.msg |
| Order | Field Name | x | Label | Datatype | Format | Initial | Mand | Description |
|---|---|---|---|---|---|---|---|---|
| 243 | act-comm-val | X | Actual Commitment Value | decimal-2 | >>,>>>,>>9.99 | 0 | ||
| 241 | act-ord-tax | X | Act Order Tax Value | decimal-2 | >>,>>>,>>9.99 | 0 | ||
| 240 | act-ord-val | X | Act Order Value | decimal-2 | >>,>>>,>>9.99 | 0 | ||
| 320 | action-ind | X | Action | logical | Export/Manual | Manual | ||
| 47 | agent-no | X | Agent No | character | x(6) | |||
| 220 | auth-by | X | Auth By | character | x(12) | |||
| 410 | auto-run-no | X | Run No | integer | >>>>>>9 | 0 | ||
| 310 | bo-ind | X | Back Order Ind | logical | Yes/No | yes | ||
| 65 | buyer-cde | X | Buyer Code | character | x(2) | |||
| 210 | buyer-note | X | Buyer Note | character | x(30) | |||
| 470 | comment | X | Comment | character | x(30) | |||
| 430 | confirm-ind | X | Confirm Ind | logical | Yes/No | NO | ||
| 280 | contr-no | X | Contract No | character | x(15) | |||
| 100 | currcy-cde | X | Currency Code | character | !!! | |||
| 370 | cust-name | X | Customer Name | character | x(40) | |||
| 360 | cust-ord | X | Customer Order Flag | logical | Yes/No | NO | ||
| 380 | cust-tel-no | X | Customer Tel No | character | x(25) | |||
| 120 | deliv-addr | X | Deliv Address | character [2] | x(30) | |||
| 140 | deliv-city | X | Deliv City | character | x(24) | |||
| 130 | deliv-suburb | X | Deliv Suburb | character | x(24) | |||
| 110 | exchange-rate | X | Exchange Rate | decimal-4 | >>,>>9.9999 | 0 | ||
| 330 | export-stat | X | Export Status | integer | 9 | 0 | ||
| 90 | foreign-ind | X | Foreign Ind | logical | Yes/No | No | ||
| 290 | full-deliv-ind | X | Full Deliv Ind | logical | Yes/No | NO | ||
| 390 | intern-ind | X | Internal Ind | logical | Yes/No | No | ||
| 340 | jab-ind | X | Jab Order | logical | Yes/No | No | ||
| 480 | mach-no | X | Machine No | character | x(20) | |||
| 230 | max-ord-val | X | Max Order Value | decimal-2 | >>,>>>,>>9.99 | 0 | ||
| 450 | opn-date | X | Open Date | date | 99/99/9999 | ? | ||
| 460 | opn-time | X | At | integer | 99999 | 0 | ||
| 440 | opn-user-id | X | User ID | character | x(12) | |||
| 60 | ord-date | X | Order Date | date | 99/99/9999 | ? | ||
| 10 | ord-no | X | Order No | character | x(8) | |||
| 80 | ord-rem | X | Remark | character | x(30) | |||
| 20 | ord-rev-no | X | Rev No | integer | >9 | 0 | ||
| 50 | ord-stat | X | Order Status | integer | 9 | 0 | ||
| 180 | ord-term | X | Order Term | character | !! | |||
| 30 | ord-type | X | Order Type | character | !! | |||
| 350 | origin | X | Origin | character | x(8) | |||
| 400 | over-deliv-ind | X | Over Deliv Ind | logical | Yes/No | NO | ||
| 160 | pay-term | X | Payment Term | character | x(4) | |||
| 300 | prom-date | X | Promised Date | date | 99/99/9999 | ? | ||
| 62 | prt-date | X | Date Printed | date | 99/99/9999 | ? | ||
| 245 | prt-ind | X | Printer Ind | logical | Yes/No | NO | ||
| 45 | remit-to-vendor-no | X | Remittance To No | character | X(6) | |||
| 170 | settl-disc-perc | X | Settl Disc Perc | decimal-2 | >>9.99 | 0 | ||
| 420 | sht-no | X | Sheet No | character | X(8) | |||
| 115 | store-cde | X | Store Code | character | x(3) | |||
| 250 | upd-date | X | Updated | date | 99/99/9999 | ? | ||
| 260 | upd-time | X | At | integer | 99999 | 0 | ||
| 270 | user-id | X | User ID | character | x(12) | |||
| 150 | vendor-contact | X | Contact Person | character | x(20) | |||
| 40 | vendor-no | X | Vendor No | character | x(6) | |||
| 200 | vendor-ref | X | Vendor Ref | character | x(15) |
| Index name | Flags | Fields | Datatype |
|---|---|---|---|
| ord-no | P U | ord-no (+) | character |
| auto-run-no | auto-run-no (+) | integer | |
| opn-date | opn-date (+) | date | |
| ord-no (+) | character | ||
| ord-date | ord-date (+) | date | |
| ord-stat | ord-stat (+) | integer | |
| sht-no | sht-no (+) | character | |
| ord-no (+) | character | ||
| type-stat | ord-type (+) | character | |
| ord-stat (+) | integer | ||
| vend-confirm | vendor-no (+) | character | |
| confirm-ind (+) | logical | ||
| vendor-no | vendor-no (+) | character |
| + = Ascending | - = Descending | P = Primary | U = Unique | I = Inactive | W = Wordindex |
| Parent tables |
|---|
| inv-store prn-spoolfile pur-vendor |
| Child tables |
|---|
| pur-barcode pur-edihdr pur-grnhdr pur-ordln pur-ordstdrem pur-recvlog pur-scanhdr |
| generated 24-6-2026 08:40 |