qbfdebr.inv-serv-itmdef

Service Item Default

Table details

Order	Field Name	x	Label	Datatype	Format	Initial
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

Index name	Flags	Fields	Datatype
item-no	P U	item-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
inv-combocom inv-comboitem inv-serv-prov pur-item-vend pur-vendor

Child tables
coe-cust-item coe-lostsls coe-ordline coe-slipln inv-comboitem inv-discitem inv-excess inv-grp-item inv-packno pos-item pos-ordln pos-yardreq-itm pos-yardscan-ln pur-barcode pur-item-vend pur-retln pur-scanex

generated 18-9-2026 09:32