DB | Areas | X-idx | Tables | Sequences <- inv-itemtrn inv-lotstat -> HtmlDict 11

qbfdecn.inv-itemvar

Item Master Variable Fields

Table details

Area ProdData
Dumpname itemvar
Label Item Master Variable Fields
Val.exp ?
Val.msg

Fields

Order Field Name x Label Datatype Format Initial Mand Description
40 alloc-qty X Allocated Qty decimal-2 >>>>>9.99- 0
240 apu X Ave Period Usage decimal-2 >>>>>9.99- 0
45 bonus-alloc X Bonus Alloc decimal-2 >>>>>9.99- 0
20 bonus-qty X Bonus Qty decimal-2 >>>>>9.99- 0
25 consign-qty X Consign Qty decimal-2 >>>>>9.99- 0
330 cost-prc X Cost Price decimal-2 >,>>>,>>9.99- 0
10 item-no X Item No character x(15)
270 last-act X Last Activity date 99/99/9999 TODAY
280 last-purc X Last Purchase date 99/99/9999 ?
290 last-recpt X Last Received date 99/99/9999 ?
300 last-used X Last Used date 99/99/9999 ?
15 oh-qty X Qty on Hand decimal-2 >>>>>9.99- 0
70 tot-cost X Total Cost decimal-2 >>,>>>,>>9.99- 0
80 tot-insp-val X Total Insp Value decimal-2 >>,>>>,>>9.99- 0

Indexes

Index name Flags Fields Datatype
item-no P U item-no (+) character
+ = Ascending - = Descending P = Primary U = Unique I = Inactive W = Wordindex

Related tables

Parent tables
pur-item-vend  
Child tables
coe-cust-item   coe-lostsls   coe-ordline   icc-item   inv-comboitem   inv-discitem   inv-excess   inv-grp-item   inv-mfritem   inv-model-allow   inv-packno   inv-serv-itmdef   lsc-exclusion   lsc-memitm-use   lsc-promo-rew   pos-item   pur-empty   pur-icc-deal   pur-item-vend   pur-retln   pur-scanex   pur-schedln   pur-schedpur  
generated 18-9-2026 10:02