| DB | Areas | X-idx | Tables | Sequences | <- pos-blacklist | pos-cashier -> | HtmlDict 11 |
Cancelled Lines
| Area | FinData |
|---|---|
| Dumpname | can-ln |
| Label | Cancelled Lines |
| 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) | |||
| 360 | bank-acct-no | X | Bank Account No | character | x(10) | |||
| 350 | bank-branch-no | X | Bank Branch No | character | x(8) | |||
| 340 | bank-cde | X | Bank Code | character | x(2) | |||
| 270 | bin-loc | X | Bin Location | character | X(10) | |||
| 300 | can-reason | X | Cancel Reason | integer | 999 | 0 | ||
| 380 | chq-date | X | Cheque Date | date | 99/99/9999 | ? | ||
| 370 | chq-no | X | Cheque No | integer | 9999999999 | 0 | ||
| 100 | city | X | City | character | x(24) | |||
| 400 | cr-card-no | X | Credit Card No | character | x(20) | |||
| 390 | drawer-name | X | Name | character | x(30) | |||
| 410 | expiry-date | X | Expiry Date | character | 99/99 | |||
| 220 | handl-fee | X | Handling Fee | decimal-2 | >>,>>>,>>9.99- | 0 | ||
| 240 | inv-amt | X | Invoice Amount | decimal-2 | >>,>>>,>>9.99- | 0 | ||
| 70 | inv-name | X | Invoice Name | character | x(30) | |||
| 140 | item-no | X | Item No | character | x(15) | |||
| 150 | ln-desc | X | Line Description | character | x(30) | |||
| 160 | ln-qty | X | Line Quantity | decimal-4 | >>>,>>9.<<<< | 0 | ||
| 260 | lot-no | X | Batch No | character | x(10) | |||
| 55 | pay-type | X | Payment Type | logical | Tender/Account | NO | ||
| 110 | post-cde | X | Postal Code | character | 9999 | |||
| 290 | prc-cat | X | Price Category | character | ! | |||
| 130 | ref-inv-ln | X | Ref Invoice Line | integer | 999 | 0 | ||
| 120 | ref-inv-no | X | Ref Invoice No | character | x(12) | |||
| 20 | seq-no | X | Sequence No | integer | >>9 | 0 | ||
| 280 | store-cde | X | Store Code | character | x(3) | |||
| 90 | suburb | X | Suburb | character | x(24) | |||
| 310 | super-id | X | Supervisor | character | x(12) | |||
| 215 | tax-amt | X | Tax Amount | decimal-2 | >,>>>,>>9.99- | 0 | ||
| 200 | tax-cat | X | Tax Category | character | X(2) | |||
| 190 | tax-cde | X | Tax Code | character | x(2) | 0 | ||
| 210 | tax-rate | X | Tax Rate | decimal-2 | >9.99 | 0 | ||
| 330 | tender-amt | X | Tender Amount | decimal-2 | >>>,>>>,>>9.99 | 0 | ||
| 320 | tender-type | X | Tender Type | character | x(2) | |||
| 10 | till-ses | X | Till Session | decimal-0 | 9999999999 | 0 | ||
| 250 | tot-cost | X | Total Cost | decimal-2 | >>,>>>,>>9.99- | 0 | ||
| 235 | trade-disc-amt | X | Trade Disc Amt | decimal-2 | >>,>>>,>>9.99- | 0 | ||
| 230 | trade-disc-perc | X | Trade Disc | decimal-2 | >>9.99 | 0 | ||
| 30 | trn-date | X | Transaction date | date | 99/99/9999 | ? | ||
| 40 | trn-time | X | Trans time | integer | 99999 | 0 | ||
| 50 | trn-type | X | Transaction Type | character | x(3) | |||
| 170 | unit-prc | X | Unit Price | decimal-2 | >,>>>,>>9.99 | 0 | ||
| 180 | uom | X | UOM | character | x(10) | |||
| 420 | vouch-no | X | Voucher No | integer | 9999999 | 0 |
| Index name | Flags | Fields | Datatype |
|---|---|---|---|
| can-trn | P U | till-ses (+) | decimal |
| seq-no (+) | integer |
| + = Ascending | - = Descending | P = Primary | U = Unique | I = Inactive | W = Wordindex |
| Parent tables |
|---|
| acr-clntacct pos-blacklist pos-tendertype pos-tilltrn pur-empty sys-town sys-trntype |
| Child tables |
|---|
| pos-floatadj pos-time-rel pos-trntime |
| generated 24-6-2026 08:43 |