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

qbfdecn.inv-item-audit

Item Audit Details

Table details

Area ProdData
Dumpname item-aud
Label Item Audit Details
Val.exp
Val.msg

Fields

Order Field Name x Label Datatype Format Initial Mand Description
100 consign-ind X Consignment Ind logical Yes/No no
60 conv-fct X Conversion Factor decimal-2 >,>>>,>>9.99 1
130 gp-perc X GP Perc decimal-2 >>9.99 0
10 item-no X Item No character x(15)
90 lot-ctrl X Lot Control logical Yes/No No
120 markup-perc X Markup Perc decimal-2 >>9.99 0
140 reason X Reason character x(40)
20 restrict-cde X Restrict Cde character !
50 sched-ind X Sched Ind logical Yes/No No
80 source X Source character !
110 stat-ctrl X Status Control logical Yes/No No
40 till-item-ind X Till Item Ind logical Yes/No No
70 uom X UOM character x(10)
150 upd-date X Updated date 99/99/9999 ?
160 upd-time X At integer 99999 0
170 upd-user-id X By character x(12)
30 wgt-ind X Weighted Ind logical Yes/No No

Indexes

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

Related tables

Parent tables
icc-stat   inv-combocom   inv-comboitem   pur-item-vend  
Child tables
acr-slsgrpitem   inv-abonusitem   inv-negrem   inv-prcimport   inv-prodorder   inv-scaleprc   inv-serv-itmcos   inv-serv-itmprc   inv-serv-itmtrn   lsc-bonus-point   lsc-comp-item   lsc-group-spec   lsc-purch-point   lsc-vendor-point   pur-allow-item   pur-fvordln   pur-grnaud   pur-ordaud   pur-palletitm   pur-scanex-brn   pur-tallyitem   pur-vendcitem  
generated 18-9-2026 10:02