qbfdecn.inv-serv-itm

Service Provider Item Detail

Table details

Area	ProdData
Dumpname	inv-serv-itm
Label	Service Provider Item Detail
Val.exp	?
Val.msg

Order	Field Name	x	Label	Datatype	Format	Initial
220	com-amt	X	Commission Amount	decimal-2	>>>,>>9.99	0
210	com-perc	X	Commission Perc	decimal-2	>>9.99	0
70	curr-tarif	X	Tariff	decimal-2	>,>>9.99	0
140	disc-amt	X	Discount Amount	decimal-2	>,>>9.99	0
150	disc-perc	X	Discount Percentage	decimal-1	>,>>9.99	0
180	expiry-days	X	Expiry Days	integer	99999	0
40	item-desc	X	Item Description	character	x(30)
50	item-instruct	X	Instruction	character	x(50)
30	item-no	X	Item No	character	x(16)
200	item-type	X	Item Type	logical	Physical/Virtual	NO
190	print-prog	X	Print Program	character	x(8)
10	pro-no	X	Provider No	character	x(8)
80	prog-name	X	Program Name	character	x(8)
130	stat-cde	X	Status Code	character	!
60	tarif-type	X	Tariff Type	logical	Fixed/Variable	NO
170	tax-cat	X	Tax Category	character	X(2)
160	tax-cde	X	Tax Code	character	x(2)	0
100	upd-date	X	Updated	date	99/99/9999	?
110	upd-time	X	At	integer	99999	0
120	upd-user-id	X	By	character	x(12)
20	vendor-no	X	Vendor No	character	x(6)
90	web-prog-name	X	Program Name	character	x(8)

Order	Field Name	x	Label	Datatype	Format	Initial
10	pro-no	X	Provider No	character	x(8)
20	vendor-no	X	Vendor No	character	x(6)
30	item-no	X	Item No	character	x(16)
40	item-desc	X	Item Description	character	x(30)
50	item-instruct	X	Instruction	character	x(50)
60	tarif-type	X	Tariff Type	logical	Fixed/Variable	NO
70	curr-tarif	X	Tariff	decimal-2	>,>>9.99	0
80	prog-name	X	Program Name	character	x(8)
90	web-prog-name	X	Program Name	character	x(8)
100	upd-date	X	Updated	date	99/99/9999	?
110	upd-time	X	At	integer	99999	0
120	upd-user-id	X	By	character	x(12)
130	stat-cde	X	Status Code	character	!
140	disc-amt	X	Discount Amount	decimal-2	>,>>9.99	0
150	disc-perc	X	Discount Percentage	decimal-1	>,>>9.99	0
160	tax-cde	X	Tax Code	character	x(2)	0
170	tax-cat	X	Tax Category	character	X(2)
180	expiry-days	X	Expiry Days	integer	99999	0
190	print-prog	X	Print Program	character	x(8)
200	item-type	X	Item Type	logical	Physical/Virtual	NO
210	com-perc	X	Commission Perc	decimal-2	>>9.99	0
220	com-amt	X	Commission Amount	decimal-2	>>>,>>9.99	0

Index name	Flags	Fields	Datatype
idx-item	P U	item-no (+)	character
		pro-no (+)	character
pro-no		pro-no (+)	character
		item-no (+)	character
stat-cde		pro-no (+)	character
		stat-cde (+)	character

+ = Ascending

- = Descending

P = Primary

U = Unique

I = Inactive

W = Wordindex

Parent tables
icc-taxtyp inv-combocom inv-comboitem inv-itemvar inv-serv-prov pur-vendor

generated 24-6-2026 08:25