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

qbfdebr.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
coe-cust-item   coe-lostsls   inv-combocom   inv-comboitem   inv-commodity   inv-excess   inv-item   inv-serv-itmdef   lsc-exclusion   pur-empty   pur-vendor  
Child tables
acr-milling   acr-slsgrpitem   coe-scanln   coe-scanranln   coe-usage-hist   inv-alloc   inv-bonus-item   inv-dist-item   inv-fifohist   inv-item   inv-item-uplift   inv-itemcost   inv-itemfifo   inv-itemstd   inv-itemtax   inv-itemtrn   inv-millcost   inv-prchist   inv-prcprt   inv-prodln   inv-prodorder   inv-serv-itm   inv-serv-itmdef   inv-slsprc   inv-trans-claim   job-trans   lsc-exclusion   mfr-bomstd   mfr-mrptrig   mfr-opsstd   mfr-packops   mfr-packreq   mfr-prodhdr   mfr-prodline   mfr-sumops   pos-yardreq-ln   pur-ediln   pur-empty   pur-grnln   pur-item   pur-ordln   pur-overprov   pur-prln   pur-retln   pur-scanex   pur-scanex-brn   pur-scanln   pur-scanranln  
generated 18-9-2026 09:33