qbfdetl.inv-comboitem


Table details

Area ProdData
Dumpname inv-comboitem
Label ?
Val.exp ?
Val.msg

Fields

Order Field Name x Label Datatype Format Initial Mand Description
10 combo-no X Combination No integer 9999999999 0
20 item-no X Item No character x(15)
30 qty X Quantity decimal-2 >,>>>,>>9.99- 0
50 upd-date X Updated date 99/99/9999 ?
60 upd-time X At integer 99999 0
40 upd-user-id X By character x(12)

Indexes

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

Related tables

Parent tables
inv-combocom   inv-combohdr   inv-serv-itmdef   pur-empty  
Child tables
acr-acctcard   acr-client   acr-clientcard   acr-clntacct   acr-emptycrn   cbk-probrn   cbk-prodev   cbk-prodtl   cbk-protrn   inv-combobrn   inv-combocom   inv-combohdr   inv-grp-item   inv-itemstd   inv-itemtax   inv-packno   inv-serv-itm   inv-serv-itmdef   inv-serv-probrn   inv-serv-prov   inv-service   inv-slsprc   lsc-group-rew   lsc-group-spec   lsc-member   lsc-member-card   pos-blacklist   pos-ctrl   pos-floatadj   pos-item   pos-quote   pos-slsprc   pos-sup-intv   pos-tendertype   pos-waiter   pos-yardreq-hdr   pos-yardreq-ln   prn-spoolfile   pur-empty   rpl-ent-field   sys-branch   sys-company   sys-emailhist   sys-finmth-aud   sys-histctrl   sys-superuser  


generated 24-6-2026 08:43