| DB | Areas | X-idx | Tables | Sequences | <- inv-itemtax | inv-lotstat -> | HtmlDict 11 |
Store Movement Transactions
| Area | ProdData |
|---|---|
| Dumpname | itemtrn |
| Label | Store Movement Transactions |
| Val.exp | ? |
| Val.msg |
| Order | Field Name | x | Label | Datatype | Format | Initial | Mand | Description |
|---|---|---|---|---|---|---|---|---|
| 190 | acct-cde | X | Account | character | x(4) | |||
| 175 | area-cde | X | Area Code | character | x(3) | |||
| 300 | auth-user | X | Authrsd By | character | x(12) | |||
| 130 | bin-loc | X | Bin Location | character | X(10) | |||
| 85 | bonus-bal | X | Bonus Balance | decimal-2 | >>>>>9.99- | 0 | ||
| 165 | bonus-qty | X | Bonus Qty | decimal-2 | >>>>>9.99- | 0 | ||
| 440 | brn-trn-date | X | Branch Trans date | date | 99/99/9999 | ? | ||
| 450 | brn-trn-time | X | Branch Trans time | integer | 99999 | 0 | ||
| 400 | commit-amt | X | Commit Amount | decimal-2 | >>,>>>,>>9.99- | 0 | ||
| 90 | consign-bal | X | Consign Bal | decimal-2 | >>>>>9.99- | 0 | ||
| 167 | consign-qty | X | Consignment Qty | decimal-0 | >,>>>,>>9 | 0 | ||
| 168 | consign-qty-wgt | X | Consignment Qty Weight | decimal-2 | >,>>>,>>9.99- | 0 | ||
| 180 | cost-cde | X | Cost Code | character | x(4) | |||
| 60 | doc-ln | X | Document Line | integer | >>9 | 0 | ||
| 50 | doc-no | X | Document No | character | x(12) | |||
| 330 | fifo-ref | X | Fifo Reference | character | x(11) | |||
| 110 | grn-no | X | GRN No | character | x(10) | |||
| 380 | inv-acct-cde | X | Inv Acct Code | character | x(4) | |||
| 360 | inv-area-cde | X | Inv Area Code | character | x(3) | |||
| 370 | inv-cost-cde | X | Inv Cost Code | character | x(4) | |||
| 20 | item-no | X | Item No | character | x(15) | |||
| 420 | lot-exp-date | X | Lot Expiry Date | date | 99/99/9999 | ? | ||
| 120 | lot-no | X | Lot No | character | x(10) | |||
| 350 | lot-stat | X | Lot Status | character | ! | |||
| 150 | next-store | X | Next Store | character | !!! | |||
| 80 | oh-bal | X | Bal On Hand | decimal-0 | >,>>>,>>9- | 0 | ||
| 310 | reason-cde | X | Reason Code | character | 999 | |||
| 320 | ref-no | X | Reference No | character | X(15) | |||
| 430 | return-qty | X | Returned Qty | decimal-7 | >>>>>9.99- | 0 | ||
| 173 | sls-val | X | Sales Value | decimal-2 | >>,>>>,>>9.99- | 0 | ||
| 10 | store-cde | X | Store Code | character | x(3) | |||
| 174 | tot-ac | X | Total A/Cost | decimal-2 | >>,>>>,>>9.99- | 0 | ||
| 172 | tot-cost | X | Total Cost | decimal-7 | >>,>>>,>>9.99- | 0 | ||
| 94 | tot-insp-val | X | Total Insp Value | decimal-2 | >>,>>>,>>9.99- | 0 | ||
| 92 | tot-val | X | Total Value | decimal-7 | >>>,>>>,>>9.9999 | 0 | ||
| 170 | trn-amt | X | Trans Amount | decimal-7 | >>,>>>,>>9.99- | 0 | ||
| 30 | trn-date | X | Transaction Date | date | 99/99/9999 | TODAY | ||
| 160 | trn-qty | X | Trans Qty | decimal-7 | >>>>>9.99- | 0 | ||
| 40 | trn-time | X | Transaction Time | integer | >>>>9 | 0 | ||
| 70 | trn-type | X | Transaction Type | character | x(3) | |||
| 100 | user-id | X | By | character | x(12) | |||
| 390 | var-acct-cde | X | Var Account | character | x(4) |
| Index name | Flags | Fields | Datatype |
|---|---|---|---|
| item-trn-date | P | item-no (+) | character |
| trn-date (-) | date | ||
| doc-no-ln | doc-no (+) | character | |
| doc-ln (+) | integer | ||
| item-area | item-no (+) | character | |
| inv-area-cde (+) | character | ||
| inv-cost-cde (+) | character | ||
| trn-date (-) | date | ||
| trn-time (-) | integer | ||
| item-area-store | item-no (+) | character | |
| inv-area-cde (+) | character | ||
| inv-cost-cde (+) | character | ||
| store-cde (+) | character | ||
| trn-date (-) | date | ||
| trn-time (-) | integer | ||
| item-area-type | item-no (+) | character | |
| inv-area-cde (+) | character | ||
| inv-cost-cde (+) | character | ||
| trn-type (+) | character | ||
| trn-date (-) | date | ||
| trn-time (-) | integer | ||
| trn-date | trn-date (+) | date |
| + = Ascending | - = Descending | P = Primary | U = Unique | I = Inactive | W = Wordindex |
| Parent tables |
|---|
| coe-slipln glr-dates inv-lotstat inv-storeacc pur-grnhdr pur-item-vend sys-trntype |
| Child tables |
|---|
| job-quote mfr-wotrn |
| generated 18-9-2026 09:32 |