qbfdecn.pur-vendac

Vendor additional costs

Table details

Order	Field Name	x	Label	Datatype	Format	Initial
115	acct-cde	X	Account Code	character	x(4)
65	alt-no	X	Alternative No	integer	9	0
20	branch-no	X	Branch No	integer	999	0
110	contr-no	X	Contract No	character	x(15)
105	cost-perc	X	Cost Perc	decimal-2	>9.99	0
70	cost-type	X	Cost Type	integer	99	0
30	end-date	X	End Date	date	99/99/9999	?
10	item-no	X	Item No	character	x(15)
80	min-ord-qty	X	Min Ord Qty	decimal-2	>>>>>9.99-	0
90	min-ord-val	X	Min Ord Value	decimal-0	>,>>>,>>9	0
60	remit-to	X	Remit to Vendor	character	x(6)
40	start-date	X	Start date	date	99/99/9999	?
170	tax-cat	X	Tax Category	character	X(2)
160	tax-cde	X	Tax Code	character	x(2)	0
150	tax-ind	X	Tax Ind	logical	Yes/No	Yes
100	tot-cost	X	Total Cost	decimal-4	>,>>9.9999	0
120	upd-date	X	Updated	date	99/99/9999	?
130	upd-time	X	At	integer	99999	0
140	upd-user-id	X	By	character	x(12)
50	vendor-no	X	Vendor No	character	x(6)

Order	Field Name	x	Label	Datatype	Format	Initial
10	item-no	X	Item No	character	x(15)
20	branch-no	X	Branch No	integer	999	0
30	end-date	X	End Date	date	99/99/9999	?
40	start-date	X	Start date	date	99/99/9999	?
50	vendor-no	X	Vendor No	character	x(6)
60	remit-to	X	Remit to Vendor	character	x(6)
65	alt-no	X	Alternative No	integer	9	0
70	cost-type	X	Cost Type	integer	99	0
80	min-ord-qty	X	Min Ord Qty	decimal-2	>>>>>9.99-	0
90	min-ord-val	X	Min Ord Value	decimal-0	>,>>>,>>9	0
100	tot-cost	X	Total Cost	decimal-4	>,>>9.9999	0
105	cost-perc	X	Cost Perc	decimal-2	>9.99	0
110	contr-no	X	Contract No	character	x(15)
115	acct-cde	X	Account Code	character	x(4)
120	upd-date	X	Updated	date	99/99/9999	?
130	upd-time	X	At	integer	99999	0
140	upd-user-id	X	By	character	x(12)
150	tax-ind	X	Tax Ind	logical	Yes/No	Yes
160	tax-cde	X	Tax Code	character	x(2)	0
170	tax-cat	X	Tax Category	character	X(2)

Index name	Flags	Fields	Datatype
item-br-end-date	P U	vendor-no (+)	character
		item-no (+)	character
		branch-no (+)	integer
		alt-no (+)	integer
		end-date (-)	date
vendor-no		vendor-no (+)	character
		end-date (+)	date

+ = Ascending

- = Descending

P = Primary

U = Unique

I = Inactive

W = Wordindex

Parent tables
glr-mainacct icc-taxtyp inv-combocom inv-comboitem pur-itemvendbrn

generated 24-6-2026 08:27