qbfdebr.pur-rethdr

Additional Return Header

Table details

Order	Field Name	x	Label	Datatype	Format	Initial
140	act-wgt	X	Actual Weight	decimal-3	>>>>9.999	0
180	auto-appr-date	X	Automatic Approved Date	date	99/99/9999	?
170	auto-email-date	X	Automatic Email Date	date	99/99/9999	?
57	origin	X	Origin	character	x(1)
58	pl-no	X	Picklist Number	character	x(12)
90	rec-ind	X	Receive Indicator	logical	Yes/No	No
55	ref-no	X	Ref No	character	x(12)
30	ret-amt	X	Return Amt	decimal-2	>>,>>>,>>9.99-	0
10	ret-no	X	Return No	character	x(10)	0
50	ret-stat	X	Status	integer	9	0
40	ret-tax-amt	X	Tax Amt	decimal-2	>,>>>,>>9.99-	0
150	suppl-batch-no	X	Supplier Batch Number	character	x(15)
160	suppl-ref-no	X	Supplier Reference No	character	x(15)
120	suppl-rep-name	X	Supplier Rep Name	character	x(20)
100	suppl-rep-pres	X	Supplier Representative Presen	logical	yes/no	no
110	suppl-seal-no	X	Supplier Seal Number	character	x(20)
130	sys-wgt	X	System Weight	decimal-2	->>,>>9.99	0
70	upd-date	X	Updated	date	99/99/9999	?
80	upd-time	X	At	integer	99999	0
60	upd-user-id	X	By	character	x(12)
20	vendor-no	X	Vendor No	character	x(6)

Order	Field Name	x	Label	Datatype	Format	Initial
10	ret-no	X	Return No	character	x(10)	0
20	vendor-no	X	Vendor No	character	x(6)
30	ret-amt	X	Return Amt	decimal-2	>>,>>>,>>9.99-	0
40	ret-tax-amt	X	Tax Amt	decimal-2	>,>>>,>>9.99-	0
50	ret-stat	X	Status	integer	9	0
55	ref-no	X	Ref No	character	x(12)
57	origin	X	Origin	character	x(1)
58	pl-no	X	Picklist Number	character	x(12)
60	upd-user-id	X	By	character	x(12)
70	upd-date	X	Updated	date	99/99/9999	?
80	upd-time	X	At	integer	99999	0
90	rec-ind	X	Receive Indicator	logical	Yes/No	No
100	suppl-rep-pres	X	Supplier Representative Presen	logical	yes/no	no
110	suppl-seal-no	X	Supplier Seal Number	character	x(20)
120	suppl-rep-name	X	Supplier Rep Name	character	x(20)
130	sys-wgt	X	System Weight	decimal-2	->>,>>9.99	0
140	act-wgt	X	Actual Weight	decimal-3	>>>>9.999	0
150	suppl-batch-no	X	Supplier Batch Number	character	x(15)
160	suppl-ref-no	X	Supplier Reference No	character	x(15)
170	auto-email-date	X	Automatic Email Date	date	99/99/9999	?
180	auto-appr-date	X	Automatic Approved Date	date	99/99/9999	?

Index name	Flags	Fields	Datatype
ret-no	P U	ret-no (+)	character
ret-stat		ret-stat (+)	integer
		ret-no (+)	character
vendor-ret		vendor-no (+)	character
		ret-no (+)	character

+ = Ascending

- = Descending

P = Primary

U = Unique

I = Inactive

W = Wordindex

Parent tables
inv-combocom inv-comboitem inv-plhdr pur-vendor

Child tables
coe-scanranhdr pur-retln pur-scanranhdr

generated 18-9-2026 09:33