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

qbfderv.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-commodity   inv-item   pur-empty   pur-vendor  
Child tables
inv-item   inv-item-uplift   inv-itembin   inv-itemlot   inv-itemtax   inv-stktake-itm   pur-barcode   pur-ediln   pur-empty   pur-grnln   pur-item   pur-ordln   pur-retln   pur-scanex   pur-scanex-brn   pur-scanln   pur-scanranln  
generated 24-6-2026 08:40