DB | Areas | X-idx | Tables | Sequences <- inv-invacct inv-item-grp -> HtmlDict 11

qbfdebr.inv-item

Item Master

Table details

Area ProdData
Dumpname item
Label Item Master
Val.exp ?
Val.msg

Triggers

Event Procedure Overr CRC
DELETE trigs/deitem.t
WRITE trigs/writem.t

Fields

Order Field Name x Label Datatype Format Initial Mand Description
750 afr-short-desc X Afr Description character x(20)
940 available-online X Available Online logical yes/no no D: is the item available online
890 brand-cde X Brand Code character x(8)
40 commodity-cde X Category character X(6)
710 consign-ind X Consignment Ind logical Yes/No no
780 conv-fct X Conversion Factor decimal-3 >,>>>,>>9.999 1
570 create-date X Date Created date 99/99/9999 ?
800 def-disc-perc X Default Discount Percent decimal-2 [5] >>9.99 0
930 dtl-desc X Detailed Description character x(100)
490 fin-mth X Fin Month integer 99 0
810 gp-perc X GP Perc decimal-2 >>9.99 0
910 image-url X Image URL character x(50)
30 inv-acct X Department character x(4)
690 item-hgt X Item Height decimal-2 >>>9.99 0
670 item-len X Item Length decimal-2 >>>9.99 0
10 item-no X Item No character x(15)
700 item-wgt X Item Weight decimal-3 >>>9.999 0
680 item-width X Item Width decimal-2 >>>9.99 0
100 lot-ctrl X Lot Control logical Yes/No No
790 m2m3-ind X Sold In character x(2)
720 markup-perc X Markup Perc decimal-2 >>9.99 0
170 mfr-cde X Mfr Code character x(6)
950 min-temp X Minimum Temperature decimal-2 ->9.99 0 D: Minimum temperature that item stays fresh for receiving stock
70 neg-cde X Negotiator character x(3)
820 pack-size X Pack Size character x(10)
180 primary-loc X Primary Loc character x(3)
50 restrict-cde X Restrict Code character !
860 restrict-open-date X Restrict Reopen Date date 99/99/9999 ?
830 scale-ind X Scale Ind logical Yes/No No
760 sched-ind X Sched Ind logical Yes/No No
880 segment-cde X Segment Code character x(8)
900 sell-by-days X Sell By Days integer >>9 0
770 settl-disc-ind X Settl Disc Ind logical Yes/No Yes
120 shelf-life X Shelf Life integer >>,>>9 0
920 shlf-life X Shelf Life Months integer >>9 0
20 short-desc X Description character X(35)
840 size X Size decimal-6 >>>>9.999999 0
850 size-unit X Size Unit character x(10)
90 source X Source character !
130 stat-ctrl X Status Control logical Yes/No No
870 sub-cde X Sub Category Code character x(8)
960 temp-ind X Temperature Regulated logical yes/no no D: Indicate if this item needs to be below a certain temperature for receiving
740 till-item-ind X Till Item Ind logical Yes/No No
60 uom X Std UOM character x(10)
140 upd-date X Updated date 99/99/9999 TODAY
150 upd-time X At integer 99999 0
160 upd-user-id X By character x(12)
730 wgt-ind X Weighted Ind logical Yes/No No

Indexes

Index name Flags Fields Datatype
item P U item-no (+) character
commodity-cde commodity-cde (+) character
    item-no (+) character
inv-acct inv-acct (+) character
    short-desc (+) character
mfr-item mfr-cde (+) character
    item-no (+) character
neg-item U neg-cde (+) character
    item-no (+) character
restrict-cde restrict-cde (+) character
    restrict-open-date (-) date
short-desc short-desc (+) character
short-desc-word W short-desc (+) character
+ = Ascending - = Descending P = Primary U = Unique I = Inactive W = Wordindex

Related tables

Parent tables
inv-combocom   inv-comboitem   inv-commodity   inv-invacct   inv-negrem   inv-segments   pur-item-vend   sys-monthname  
Child tables
coe-cust-item   coe-lostsls   coe-ordline   coe-slipln   inv-comboitem   inv-discitem   inv-excess   inv-grp-item   inv-packno   pos-item   pos-ordln   pos-yardreq-itm   pos-yardscan-ln   pur-barcode   pur-item-vend   pur-retln   pur-scanex  
generated 24-6-2026 08:35