qbfdebr.pur-empty

Empties/Crates

Table details

Area	ProdData
Dumpname	empty
Label	Empties/Crates
Val.exp
Val.msg

Triggers

Event	Procedure	Overr	CRC
DELETE	trigs/deempty.t
WRITE	trigs/wrempty.t

Fields

Order	Field Name	x	Label	Datatype	Format	Initial	Mand	Description
10	item-no	X	Item No	character	x(15)
60	sel-ind	X	Sell Item	logical	Yes/No	NO
20	unit-prc	X	Unit Price	decimal-2	>,>>>,>>9.99	0
30	upd-date	X	Updated	date	99/99/9999	?
40	upd-time	X	At	integer	99999	0
50	upd-user-id	X	By	character	x(12)

Indexes

Index name	Flags	Fields	Datatype
item-no	P U	item-no (+)	character

+ = Ascending

- = Descending

P = Primary

U = Unique

I = Inactive

W = Wordindex

Related tables

Parent tables
inv-combocom inv-comboitem pur-item-vend

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:33