| DB | Areas | X-idx | Tables | Sequences | <- pos-savetrn | pos-scanord -> | HtmlDict 11 |
Temporary Point of Sale Lines
| Area | FinData |
|---|---|
| Dumpname | transac3 |
| Label | Temporary Point of Sale 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) | |||
| 490 | disc-ind | X | Discount Ind | logical | Yes/No | NO | ||
| 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 | ||
| 440 | item-hgt | X | Item Height | decimal-5 | >>>9.99999 | 0 | ||
| 420 | item-len | X | Item Length | decimal-5 | >>>9.99999 | 0 | ||
| 40 | item-no | X | Item No | character | x(15) | |||
| 430 | item-width | X | Item Width | decimal-5 | >>>9.99999 | 0 | ||
| 400 | level-disc-acct | X | Level Disc Acct Code | character [3] | x(4) | |||
| 390 | level-disc-amt | X | Discount Amount | decimal-2 [3] | >>>,>>>,>>9.99- | 0 | ||
| 380 | 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) | |||
| 370 | mill-ind | X | Mill Ind | logical | Yes/No | No | ||
| 450 | ord-item | X | Order Item | logical | Yes/No | NO | ||
| 460 | pro-no | X | Provider No | character | x(8) | |||
| 80 | qty-per | X | Qty Per | decimal-4 | >>>9.99 | 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) | |||
| 480 | ref-no | X | Ref No | character | x(30) | |||
| 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 | ||
| 410 | 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) | |||
| 470 | vouch | X | Voucher No | character | x(30) | 0 | ||
| 340 | vouch-no | X | Voucher No | integer | 9999999 | 0 |
| Index name | Flags | Fields | Datatype |
|---|---|---|---|
| trn-ln | P U | till-ses (+) | decimal |
| trn-no (+) | integer | ||
| trn-ln (+) | integer |
| + = Ascending | - = Descending | P = Primary | U = Unique | I = Inactive | W = Wordindex |
| Parent tables |
|---|
| inv-serv-itm pos-blacklist pos-recpt pos-tendertype pos-trnln |
| Child tables |
|---|
| pos-trnln |
| generated 24-6-2026 08:43 |