| DB | Areas | X-idx | Tables | Sequences | <- pos-quote | pos-recpt -> | HtmlDict 11 |
Point of Sale Quotation Lines
| Area | FinData |
|---|---|
| Dumpname | transac5 |
| Label | Point of Sale Quotation Lines |
| Val.exp | |
| Val.msg |
| Order | Field Name | x | Label | Datatype | Format | Initial | Mand | Description |
|---|---|---|---|---|---|---|---|---|
| 280 | bank-acct-no | X | Bank Account No | character | x(12) | |||
| 270 | bank-branch-no | X | Bank Branch No | character | x(8) | |||
| 260 | bank-cde | X | Bank Code | character | x(2) | |||
| 210 | bin-loc | X | Bin Location | character | X(10) | |||
| 300 | chq-date | X | Cheque Date | date | 99/99/9999 | ? | ||
| 290 | chq-no | X | Cheque No | integer | >>>>>>9 | 0 | ||
| 320 | cr-card-no | X | Credit Card No | character | x(16) | |||
| 310 | drawer-name | X | Drawer Name | character | x(50) | |||
| 330 | expiry-date | X | Expiry Date | character | 99/9999 | |||
| 140 | handl-fee | X | Handling Fee | decimal-2 | >>,>>>,>>9.99- | 0 | ||
| 170 | inv-amt | X | Invoice Amount | decimal-2 | >>,>>>,>>9.99- | 0 | ||
| 460 | item-hgt | X | Item Height | decimal-5 | >>>9.99999 | 0 | ||
| 440 | item-len | X | Item Length | decimal-5 | >>>9.99999 | 0 | ||
| 40 | item-no | X | Item No | character | x(15) | |||
| 450 | item-width | X | Item Width | decimal-5 | >>>9.99999 | 0 | ||
| 420 | level-disc-acct | X | Level Disc Acct Code | character [3] | x(4) | |||
| 410 | level-disc-amt | X | Level Discount Amount | decimal-2 [3] | >>>,>>>,>>9.99- | 0 | ||
| 400 | level-disc-perc | X | Level Disc % | decimal-3 [3] | >>9.999 | 0 | ||
| 50 | ln-desc | X | Line Description | character | x(30) | |||
| 60 | ln-qty | X | Line Quantity | decimal-4 | >,>>9.9999 | 0 | ||
| 200 | lot-no | X | Batch No | character | x(10) | |||
| 390 | mill-id | X | Mill Id | integer | >9 | 0 | ||
| 370 | mill-ind | X | Mill Ind | logical | Yes/No | No | ||
| 380 | mill-item-qty | X | Mill Qty | decimal-2 | >>,>>9.99 | 0.0 | ||
| 490 | prc-cat-break | X | Price Category Break | decimal-4 | >>>9.9999 | 0 | ||
| 480 | prc-cat-ext | X | Price Category Extents | integer | >9 | 1 | ||
| 80 | qty-per | X | Qty Per | decimal-4 | >>>9.99 | 0 | ||
| 7 | quote-ln | X | Quote Line | integer | 999 | 0 | ||
| 5 | quote-no | X | Quote No | integer | 99999999 | 0 | ||
| 350 | recpt-no | X | Receipt No | character | x(12) | |||
| 230 | ref-inv-ln | X | Ref Invoice Line | integer | 999 | 0 | ||
| 220 | ref-inv-no | X | Ref Invoice No | character | x(12) | |||
| 470 | spec-ind | X | Special Ind | character | X(8) | |||
| 190 | store-cde | X | Store Code | character | x(3) | |||
| 160 | tax-amt | X | Tax Amount | decimal-2 | >,>>>,>>9.99- | 0 | ||
| 110 | tax-cat | X | Tax Category | character | X(2) | |||
| 100 | tax-cde | X | Tax Code | character | x(2) | 0 | ||
| 120 | tax-rate | X | Tax Rate | decimal-2 | >9.99 | 0 | ||
| 360 | tel-no | X | Tel No | character | x(20) | |||
| 250 | tender-amt | X | Tender Amount | decimal-2 | >>>,>>>,>>9.99 | 0 | ||
| 240 | tender-type | X | Tender Type | character | x(2) | |||
| 10 | till-ses | X | Till Session | decimal-0 | 9999999999 | 0 | ||
| 180 | tot-cost | X | Total Cost | decimal-2 | >>,>>>,>>9.99- | 0 | ||
| 430 | trade-disc-acct | X | Trade Disc Acct Code | character | x(4) | |||
| 150 | trade-disc-amt | X | Trade Disc Amt | decimal-2 | >>,>>>,>>9.99- | 0 | ||
| 130 | trade-disc-perc | X | Trade Disc | decimal-2 | >>9.99 | 0 | ||
| 30 | trn-ln | X | Trans Line | integer | 99999 | 0 | ||
| 20 | trn-no | X | Trans No | integer | 999 | 0 | ||
| 90 | unit-prc | X | Unit Price | decimal-3 | >,>>>,>>9.999 | 0 | ||
| 70 | uom | X | UOM | character | x(10) | |||
| 340 | vouch-no | X | Voucher No | integer | 9999999 | 0 |
| Index name | Flags | Fields | Datatype |
|---|---|---|---|
| quote-ln | P U | quote-no (+) | integer |
| quote-ln (+) | integer |
| + = Ascending | - = Descending | P = Primary | U = Unique | I = Inactive | W = Wordindex |
| Parent tables |
|---|
| pos-blacklist pos-quote pos-recpt pos-tendertype pos-trnln pur-empty |
| generated 24-6-2026 08:43 |