qbfdebr.inv-actexppar

Active Explosions Parent Records

Table details

Area	ProdData
Dumpname	actexppa
Label	Active Explosions Parent Records
Val.exp	?
Val.msg

Fields

Order	Field Name	x	Label	Datatype	Format	Initial	Mand	Description
40	basis-qty	X	Basis Qty	integer	>>>>>9-	0
50	basis-uom	X	Basis UOM	character	x(10)
10	branch-no	X	Branch No	integer	999	0
90	cost-prc	X	Cost Price	decimal-2	>,>>>,>>9.99-	0
70	cut-loss-perc	X	Cut Loss %	decimal-2	>>9.99	0
100	exp-no	X	Explosion No	integer	>>>>>9	0
20	item-no	X	Item No	character	x(15)
80	loss-acct-cde	X	Loss Acct	character	x(4)
60	moist-loss-perc	X	Moist Loss %	decimal-2	>>9.99	0
30	short-desc	X	Description	character	x(20)
150	upd-date	X	Updated	date	99/99/9999	?
160	upd-time	X	At	integer	99999	0
140	upd-user-id	X	By	character	x(12)

Indexes

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

+ = Ascending

- = Descending

P = Primary

U = Unique

I = Inactive

W = Wordindex

Related tables

Parent tables
inv-combocom inv-comboitem inv-explnkcost

Child tables
coe-item-min inv-expitem inv-explnkcost inv-expsum inv-negrem inv-ownitem inv-stktake-err inv-stktake-itm mfr-item mfr-mrpdem mfr-mrpsup mfr-prline mfr-schedreq mfr-worksord pos-yardreq-itm

generated 18-9-2026 09:32