| DB | Areas | X-idx | Tables | Sequences | <- pos-item | pos-quoteln -> | HtmlDict 11 |
Point of Sale Quotation
| Area | FinData |
|---|---|
| Dumpname | transac4 |
| Label | Point of Sale Quotation |
| Val.exp | |
| Val.msg |
| Order | Field Name | x | Label | Datatype | Format | Initial | Mand | Description |
|---|---|---|---|---|---|---|---|---|
| 60 | acct-no | X | Acct | character | xxxxxx-xx-x | |||
| 80 | addr | X | Address | character [2] | x(24) | |||
| 150 | agri-bonus-no | X | Agri Bonus No | character | x(10) | |||
| 100 | city | X | City | character | x(24) | |||
| 250 | comment | X | Comment | character | x(30) | |||
| 140 | cust-ord-no | X | Cust Order | character | x(12) | |||
| 170 | exp-date | X | Quote Expiry Date | date | 99/99/9999 | ? | ||
| 160 | id-no | X | Id No | character | x(13) | |||
| 70 | inv-name | X | Invoice Name | character | x(30) | |||
| 190 | owner-user-id | X | Owner User ID | character | x(12) | |||
| 120 | pay-type | X | Payment Type | logical | Tender/Acct | True | ||
| 110 | post-cde | X | Postal Code | character | 9999 | |||
| 50 | prc-cat | X | Price Category | character | ! | |||
| 260 | prc-comment | X | Prc Comment | character | x(30) | |||
| 240 | proj-desc | X | Project | character | X(30) | |||
| 270 | prom-date | X | Promised Date | date | 99/99/9999 | ? | ||
| 5 | quote-no | X | Quote No | integer | 99999999 | 0 | ||
| 180 | quote-rules | X | Quote Rules | character | X(8) | |||
| 130 | ref-inv-no | X | Ref Invoice No | character | x(12) | |||
| 230 | sls-rep | X | Sales Rep | character | x(3) | |||
| 90 | suburb | X | Suburb | character | x(24) | |||
| 115 | tel-no | X | Tel No | character | x(20) | |||
| 10 | till-ses | X | Till Session | decimal-0 | 9999999999 | 0 | ||
| 40 | trn-date | X | Transaction date | date | 99/99/9999 | ? | ||
| 20 | trn-no | X | Trans No | integer | 999 | 0 | ||
| 30 | trn-type | X | Transaction Type | character | ! | |||
| 210 | upd-date | X | Updated | date | 99/99/9999 | ? | ||
| 220 | upd-time | X | At | integer | 99999 | 0 | ||
| 200 | upd-user-id | X | By | character | x(12) |
| Index name | Flags | Fields | Datatype |
|---|---|---|---|
| pos-quote | P U | quote-no (+) | integer |
| + = Ascending | - = Descending | P = Primary | U = Unique | I = Inactive | W = Wordindex |
| Parent tables |
|---|
| acr-clntacct inv-combocom inv-comboitem pos-trn sys-town sys-trntype |
| Child tables |
|---|
| pos-quoteln |
| generated 24-6-2026 08:43 |