qbfdecn.pur-auto-vend

Automatic Order Setup

Table details

Event	Procedure	Overr	CRC
DELETE	trigs/deauto-vend.t
WRITE	trigs/wrauto-vend.t

Order	Field Name	x	Label	Datatype	Format	Initial
20	branch-no	X	Branch No	integer	999	0
120	close-days	X	Close After Days	integer	>>9	0
87	create-date	X	Create Date	date	99/99/9999	?
88	create-time	X	At	integer	99999	0
86	create-user	X	User ID	character	x(12)
70	days-stock	X	Days Stock	integer	>>9	0
150	days-stock2	X	Week 2	integer	>>9	0
160	days-stock3	X	Week 3	integer	>>9	0
170	days-stock4	X	Week 4	integer	>>9	0
85	end-date	X	End Date	date	99/99/9999	?
130	last-ord	X	Last Order	logical	Yes/No	No
140	last-ord-days	X	Last Order Days	integer	>>9	0
75	max-ord-val	X	Max Ord Val	decimal-2	>,>>>,>>9.99-	0
60	next-ord-date	X	Next Ord Date	date	99/99/9999	?
80	ord-action	X	Order Action	logical	Order/Ignore	Order
50	ord-day	X	Ord Day	integer	9	0
40	ord-freq	X	Ord Freq	integer	>9	0
30	ord-freq-type	X	Ord Freq Type	character	!
180	release-time	X	Release Time	integer	99999	0
5	seq-no	X	Sequence No	integer	>>>>>>>9	0
100	upd-date	X	Updated	date	99/99/9999	?
110	upd-time	X	At	integer	99999	0
90	upd-user-id	X	By	character	x(12)
10	vendor-no	X	Vendor No	character	x(6)

Order	Field Name	x	Label	Datatype	Format	Initial
5	seq-no	X	Sequence No	integer	>>>>>>>9	0
10	vendor-no	X	Vendor No	character	x(6)
20	branch-no	X	Branch No	integer	999	0
30	ord-freq-type	X	Ord Freq Type	character	!
40	ord-freq	X	Ord Freq	integer	>9	0
50	ord-day	X	Ord Day	integer	9	0
60	next-ord-date	X	Next Ord Date	date	99/99/9999	?
70	days-stock	X	Days Stock	integer	>>9	0
75	max-ord-val	X	Max Ord Val	decimal-2	>,>>>,>>9.99-	0
80	ord-action	X	Order Action	logical	Order/Ignore	Order
85	end-date	X	End Date	date	99/99/9999	?
86	create-user	X	User ID	character	x(12)
87	create-date	X	Create Date	date	99/99/9999	?
88	create-time	X	At	integer	99999	0
90	upd-user-id	X	By	character	x(12)
100	upd-date	X	Updated	date	99/99/9999	?
110	upd-time	X	At	integer	99999	0
120	close-days	X	Close After Days	integer	>>9	0
130	last-ord	X	Last Order	logical	Yes/No	No
140	last-ord-days	X	Last Order Days	integer	>>9	0
150	days-stock2	X	Week 2	integer	>>9	0
160	days-stock3	X	Week 3	integer	>>9	0
170	days-stock4	X	Week 4	integer	>>9	0
180	release-time	X	Release Time	integer	99999	0

Index name	Flags	Fields	Datatype
brn-vend	P	branch-no (+)	integer
		vendor-no (+)	character
		ord-day (+)	integer
seq-no	U	seq-no (+)	integer
vend-brn		vendor-no (+)	character
		branch-no (+)	integer
		ord-day (+)	integer

+ = Ascending

- = Descending

P = Primary

U = Unique

I = Inactive

W = Wordindex

Parent tables
inv-combocom inv-comboitem pur-vendbrn sys-batch-job

generated 18-9-2026 10:03