qbfdecn.inv-plline

Pick List Line Detail

Table details

Order	Field Name	x	Label	Datatype	Format	Initial
100	acct-cde	X	Account	character	x(4)
80	area-cde	X	Area Code	character	x(3)
150	auth-user	X	Authrsd By	character	x(8)
60	bin-loc	X	Bin Location	character	X(10)
132	bonus-qty	X	Bonus Qty	decimal-2	>>>>>9.99-	0
134	consign-qty	X	Consignment Qty	decimal-0	>,>>>,>>9	0
90	cost-cde	X	Cost Code	character	x(4)
170	doc-ln	X	Document Line	integer	>>9	0
160	doc-no	X	Document No	character	x(12)
40	grn-no	X	GRN No	character	x(10)
140	iss-qty	X	Issue Quantity	decimal-7	>>>>>9.99-	0
30	item-no	X	Item No	character	x(15)
50	lot-no	X	Batch No	character	x(10)
20	pl-ln	X	Picklist Line	integer	>9	0
10	pl-no	X	Picklist Number	character	x(12)
180	pl-stat	X	Picklist Status	integer	9	0
145	rej-qty	X	Reject Qty	decimal-7	>>>>>9.99-	0
138	sls-val	X	Sales Value	decimal-7	>>,>>>,>>9.99-	0
70	to-bin-loc	X	To Bin Location	character	X(10)
136	tot-cost	X	Total Cost	decimal-7	>>,>>>,>>9.99-	0
130	trn-qty	X	Transaction Qty	decimal-7	>>>>>9.99-	0

Order	Field Name	x	Label	Datatype	Format	Initial
10	pl-no	X	Picklist Number	character	x(12)
20	pl-ln	X	Picklist Line	integer	>9	0
30	item-no	X	Item No	character	x(15)
40	grn-no	X	GRN No	character	x(10)
50	lot-no	X	Batch No	character	x(10)
60	bin-loc	X	Bin Location	character	X(10)
70	to-bin-loc	X	To Bin Location	character	X(10)
80	area-cde	X	Area Code	character	x(3)
90	cost-cde	X	Cost Code	character	x(4)
100	acct-cde	X	Account	character	x(4)
130	trn-qty	X	Transaction Qty	decimal-7	>>>>>9.99-	0
132	bonus-qty	X	Bonus Qty	decimal-2	>>>>>9.99-	0
134	consign-qty	X	Consignment Qty	decimal-0	>,>>>,>>9	0
136	tot-cost	X	Total Cost	decimal-7	>>,>>>,>>9.99-	0
138	sls-val	X	Sales Value	decimal-7	>>,>>>,>>9.99-	0
140	iss-qty	X	Issue Quantity	decimal-7	>>>>>9.99-	0
145	rej-qty	X	Reject Qty	decimal-7	>>>>>9.99-	0
150	auth-user	X	Authrsd By	character	x(8)
160	doc-no	X	Document No	character	x(12)
170	doc-ln	X	Document Line	integer	>>9	0
180	pl-stat	X	Picklist Status	integer	9	0

Index name	Flags	Fields	Datatype
pl-no-ln	P U	pl-no (+)	character
		pl-ln (+)	integer
doc-no-ln		doc-no (+)	character
		doc-ln (+)	integer

+ = Ascending

- = Descending

P = Primary

U = Unique

I = Inactive

W = Wordindex

Parent tables
acr-paytrnsfer inv-itemlot inv-plhdr lsc-bp-acct pur-grnhdr

generated 18-9-2026 10:02