DB | Areas | X-idx | Tables | Sequences <- pur-item pur-item-vendbrn -> HtmlDict 11

qbfdecn.pur-item-vend

Item Vendor Relationship

Table details

Area ProdData
Dumpname itemvend
Label Item Vendor Relationship
Val.exp ?
Val.msg

Fields

Order Field Name x Label Datatype Format Initial Mand Description
25 agent-no X Agent No character x(6)
180 agri-bonus-ind X Agri Bonus Ind logical Yes/No No
50 commodity-cde X Commodity Code character X(6)
10 item-no X Item No character x(15)
130 last-disc-perc X Last Disc % decimal-2 >9.99 0
140 last-purc X Last Purchase date 99/99/9999 ?
120 last-purc-prc X Last Price decimal-2 >,>>>,>>9.99 0
70 last-quoted X Last Quoted date 99/99/9999 ?
40 lead-time X Lead Time integer >>9 0
30 mfr-item-cde X Mfr Item Code character x(15)
210 next-purc-uom X Next Purc UoM character x(10)
220 next-purc-uom-conv X Next UoM Conv decimal-4 >,>>9.9999 0
27 prc-neg-ind X Price Negotiated logical Yes/No No
80 pref-vendor X Pref logical Yes/No Yes
190 purc-uom X Purchase UoM character x(10)
200 purc-uom-conv X Purchase UoM Conv decimal-4 >,>>9.9999 0
230 red-flag-ind X Red Flag Ind logical Yes/No No
160 upd-date X Updated date 99/99/9999 ?
170 upd-time X At integer 99999 0
150 upd-user-id X By character x(12)
20 vendor-no X Vendor No character x(6)

Indexes

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

Related tables

Parent tables
inv-combocom   inv-comboitem   inv-commodity   inv-item   inv-itemvar   pur-vendor  
Child tables
acr-milling   coe-cust-item   coe-lostsls   coe-ordline   coe-usage-hist   icc-item   inv-alloc   inv-bonus-item   inv-comboitem   inv-discitem   inv-excess   inv-grp-item   inv-impwgt   inv-item   inv-item-audit   inv-item-uplift   inv-itemcost   inv-itemmloc   inv-itemtax   inv-itemtrig   inv-itemtrn   inv-itemvar   inv-mfritem   inv-millitem   inv-model-allow   inv-packno   inv-prcexport   inv-serv-item   inv-serv-itm   inv-serv-itmdef   inv-volbrk   lsc-exclusion   lsc-memitm-use   lsc-promo-rew   pos-item   pur-empty   pur-grnln   pur-icc-deal   pur-item   pur-scan   pur-schedadv  
generated 18-9-2026 10:03