qbfderv.pur-recvlog

Receiving Log

Table details

Order	Field Name	x	Label	Datatype	Format	Initial
90	accept-date	X	Accepted	date	99/99/9999	?
100	accept-time	X	At	integer	99999	0
110	accept-user-id	X	By	character	x(12)
50	arrive-date	X	Arrived	date	99/99/9999	?
60	arrive-time	X	At	integer	99999	0
70	arrive-user-id	X	By	character	x(12)
120	branch-no	X	Branch No	integer	999	0
190	count-sht-date	X	Updated	date	99/99/9999	?
200	count-sht-time	X	At	integer	99999	0
180	count-sht-user	X	By	character	x(12)
80	grn-no	X	Grn No	character	x(10)	0
30	inv-amt	X	Invoice Amount	decimal-2	>>,>>>,>>9.99-	0
160	ord-no	X	Order No	character	x(8)	0
130	prov-amt	X	Provisional Amount	decimal-2	>>,>>>,>>9.99-	0
140	prov-tax-amt	X	Provisional Tax Amount	decimal-2	>>,>>>,>>9.99-	0
150	queue-no	X	Queue No	integer	>>>>>9	0
170	stat-cde	X	Status Code	character	!
40	tax-amt	X	Tax Amount	decimal-2	>,>>>,>>9.99-	0
20	vendor-inv-no	X	Vendor Invoice No	character	x(12)
10	vendor-no	X	Vendor No	character	x(6)

Order	Field Name	x	Label	Datatype	Format	Initial
10	vendor-no	X	Vendor No	character	x(6)
20	vendor-inv-no	X	Vendor Invoice No	character	x(12)
30	inv-amt	X	Invoice Amount	decimal-2	>>,>>>,>>9.99-	0
40	tax-amt	X	Tax Amount	decimal-2	>,>>>,>>9.99-	0
50	arrive-date	X	Arrived	date	99/99/9999	?
60	arrive-time	X	At	integer	99999	0
70	arrive-user-id	X	By	character	x(12)
80	grn-no	X	Grn No	character	x(10)	0
90	accept-date	X	Accepted	date	99/99/9999	?
100	accept-time	X	At	integer	99999	0
110	accept-user-id	X	By	character	x(12)
120	branch-no	X	Branch No	integer	999	0
130	prov-amt	X	Provisional Amount	decimal-2	>>,>>>,>>9.99-	0
140	prov-tax-amt	X	Provisional Tax Amount	decimal-2	>>,>>>,>>9.99-	0
150	queue-no	X	Queue No	integer	>>>>>9	0
160	ord-no	X	Order No	character	x(8)	0
170	stat-cde	X	Status Code	character	!
180	count-sht-user	X	By	character	x(12)
190	count-sht-date	X	Updated	date	99/99/9999	?
200	count-sht-time	X	At	integer	99999	0

Index name	Flags	Fields	Datatype
vendor-inv-no	P U	vendor-no (+)	character
		vendor-inv-no (+)	character
accpt-date		accept-date (+)	date
arrive-date		arrive-date (+)	date
branch-no		branch-no (+)	integer
vend-ord		vendor-no (+)	character
		ord-no (+)	character

+ = Ascending

- = Descending

P = Primary

U = Unique

I = Inactive

W = Wordindex

Parent tables
pur-grnhdr pur-ordhdr pur-vendor rpl-ctrl rpl-srv sys-branch sys-branchctrl sys-branchmng

Child tables
pur-grnac

generated 24-6-2026 08:40