qbfdecn.fra-ordln

Franchise Order Lines

Table details

Area	ProdData
Dumpname	fraordln
Label	Franchise Order Lines
Val.exp	?
Val.msg

Fields

Order	Field Name	x	Label	Datatype	Format	Initial	Mand	Description
110	contr-no	X	Contract No	character	x(15)
60	item-desc	X	Item Description	character	x(30)
50	item-no	X	Item No	character	x(15)
40	ln-no	X	Line No	integer	>>>>>>9	0
30	mem-comp-no	X	Member Company No	integer	9999999	0
130	ord-item-rem	X	Remark	character	x(30)
10	ord-no	X	Order No	character	x(8)	0
70	ord-qty	X	Order Quantity	decimal-0	>>>>>9	0
80	purc-uom	X	Purchase UoM	character	x(10)
90	purc-uom-conv	X	Purchase UoM Conv	decimal-4	>,>>9.9999	0
120	recvd-qty	X	Received Qty	decimal-0	>>>>>9	0
5	seq-no	X	Sequence No	integer	>>>>>>9	0
160	tax-amt	X	Tax Amount	decimal-2	>,>>>,>>9.99-	0
150	tax-cat	X	Tax Category	character	X(2)
140	tax-cde	X	Tax Code	character	x(2)	0
170	tax-rate	X	Tax Rate	decimal-2	>9.99	0
100	unit-prc	X	Unit Price	decimal-2	>,>>>,>>9.99	0
20	vendor-no	X	Vendor No	character	x(6)

Indexes

Index name	Flags	Fields	Datatype
seq-ln	P U	seq-no (+)	integer
		ln-no (+)	integer
mem-ord-ln		mem-comp-no (+)	integer
		ord-no (+)	character
		ln-no (+)	integer
mem-vend-ord-ln		mem-comp-no (+)	integer
		vendor-no (+)	character
		ord-no (+)	character
		ln-no (+)	integer

+ = Ascending

- = Descending

P = Primary

U = Unique

I = Inactive

W = Wordindex

Related tables

Parent tables
coe-ordline fra-member icc-taxtyp pur-scanex sys-batch-job

generated 18-9-2026 10:02