DB | Areas | X-idx | Tables | Sequences <- pur-vendgrp pur-vendprc -> HtmlDict 11

qbfdebr.pur-vendor

Purchase Vendor detail

Table details

Area ProdData
Dumpname vendor
Label Purchase Vendor detail
Val.exp ?
Val.msg

Triggers

Event Procedure Overr CRC
DELETE trigs/devendor.t
WRITE trigs/wrvendor.t

Fields

Order Field Name x Label Datatype Format Initial Mand Description
420 add-spent-perc X Add Spent % decimal-2 >>9.99 0
450 add-spent-prd-ind X Add Spent Period Ind logical Yes/No FALSE
330 agri-bonus-ind X Agri Bonus Ind logical Yes/No No
560 allow-write-off X Allow Write-offs logical yes/no no
190 bank-acct-no X Bank Account No character x(12)
180 bank-acct-type X Bank Acct Type character !
200 bank-branch-no X Bank Branch No character x(8)
170 bank-cde X Bank Code character x(2)
550 bank-ref X Bank Reference character x(30)
210 branch-name X Branch Name character x(15)
70 clerk-no X Clerk No integer >9 01
40 create-date X Date Created date 99/99/9999 ?
160 currcy-cde X Currency Code character !!! NAD
510 days-stock X Days Stock integer >>9 0
460 depot-cde X Depo integer 99 0
280 foreign-ind X Foreign Ind logical Yes/No No
430 inv-reqd-ind X Invoice Required logical Yes/No NO
30 lead-time X Lead Time integer >>9 5
540 manual-ord X Manual Order logical Yes/No Yes
120 me-date X Month end Date integer 99 0
360 min-ord-amt X Min Ord Amt decimal-2 >,>>>,>>9.99 0
370 min-ord-qty X Min Ord Qty decimal-2 >>>>>9.99 0
310 next-ord-date X Next Ord Date date 99/99/9999 ?
350 next-ord-term X Next Order Term character !!
300 ord-day X Ord Day integer 9 0
290 ord-freq X Ord Freq integer >9 0
285 ord-freq-type X Ord Freq Type character !
340 ord-term X Order Term character !!
490 parent-foreign-ind X Parent Foreign Ind logical Yes/No No
90 pay-method X Payment Method integer 9 0
80 pay-term X Payment Term character x(4) S030
391 proj-perc X Project Perc decimal-2 >>9.99 0
470 rebate-nett-ind X Rebate Nett Ind logical Yes/No NO
380 rebate-perc X Rebate % decimal-2 >>9.99 0
440 rebate-prd-ind X Rebate Period Ind logical Yes/No FALSE
500 remit-email X Remittance Email character x(35)
520 remit-ind X Allow Remit logical Yes/No Yes
240 remit-to-vendor-no X Remittance To No character X(6)
435 reord-ind X Reorder Ind logical Yes/No No
480 save-to-ind X Save To Ind logical Yes/No No
100 settl-disc-perc X Settl Disc decimal-2 >>9.99 0
60 stat-date X Status date date 99/99/9999 ?
320 stmnt-recon X Statement Recon logical Yes/No NO
390 swell-perc X Swell % decimal-2 >>9.99 0
260 tax-reg-ind X Tax Registered logical Yes/No No
270 tax-reg-no X Tax Registr No character X(15)
95 trade-disc-perc X Trade Disc decimal-2 >>9.99 0
410 transp-ord-term X Transp Ord Term character !!
400 transp-perc X Transport % decimal-2 >>9.99 0
130 upd-date X Updated date 99/99/9999 ?
140 upd-time X At integer 99999 0
150 upd-user-id X By character x(12)
250 vendor-acct-no X Account No character x(10)
220 vendor-grp X Vendor Group character x(2) MF
20 vendor-name X Name character x(40)
10 vendor-no X Vendor No character x(6)
50 vendor-stat X Status character !
530 vendor-type X Type character X O

Indexes

Index name Flags Fields Datatype
vendor-no P U vendor-no (+) character
clerk-no clerk-no (+) integer
next-ord-date next-ord-date (+) date
remit-to remit-to-vendor-no (+) character
vendor-grp vendor-grp (+) character
vendor-name vendor-name (+) character
+ = Ascending - = Descending P = Primary U = Unique I = Inactive W = Wordindex

Related tables

Parent tables
inv-combocom   inv-comboitem   pos-apprcheq   pur-clerk   pur-vendgrp  
Child tables
cbk-prodtl   inv-countrecord   inv-int-claim   inv-itemcost   inv-lottrn   inv-serv-itm   inv-serv-itmdef   inv-serv-prov   inv-stktake-vnd   inv-trans-claim   inv-vendadj   job-jobcard   pos-armregister   pur-edihdr   pur-grnhdr   pur-intvend   pur-item-vend   pur-ordhdr   pur-overprov   pur-prhdr   pur-recvlog   pur-rethdr   pur-scanex   pur-scanex-brn   pur-scanranhdr   pur-vend-uplift   sca-card-issue   sys-user-vendor  
generated 18-9-2026 09:33