qbfdecn.lsc-vendor-point

Loyalty Vendor Points

Table details

Area	ProdData
Dumpname	vendor-point
Label	Loyalty Vendor Points
Val.exp	?
Val.msg

Fields

Order	Field Name	x	Label	Datatype	Format	Initial	Mand	Description
140	acct-cde	X	Acct Code	character	x(4)
150	area-cde	X	Area Code	character	x(3)
180	card-no	X	Card No	integer	99999999	0
160	cost-cde	X	Cost Code	character	x(4)
10	grp-cde	X	Group Code	character	x(8)
120	inv-no	X	Invoice No	character	x(12)
110	item-no	X	Item No	character	x(15)
20	mem-no	X	Member No	integer	9999999	0
50	point-descr	X	Description	character	x(30)
40	point-due-date	X	Due Date	date	99/99/9999	?
30	point-earn	X	Points Earned	decimal-2	>>,>>>,>>9.99-	0
100	promo-no	X	Promotion No	integer	9999999	0
130	return-ind	X	Return Ind	logical	Yes/No	no
60	stat-cde	X	Status Code	character	!
70	upd-date	X	Updated	date	99/99/9999	?
80	upd-time	X	At	integer	99999	0
90	upd-user-id	X	By	character	x(12)
170	vendor-no	X	Vendor No	character	x(6)

Indexes

Index name	Flags	Fields	Datatype
mem-stat	P	mem-no (+)	integer
		stat-cde (+)	character
		point-due-date (+)	date
grp-mem		grp-cde (+)	character
		mem-no (+)	integer
		stat-cde (+)	character
		point-due-date (+)	date
vend-mem		vendor-no (+)	character
		mem-no (+)	integer

+ = Ascending

- = Descending

P = Primary

U = Unique

I = Inactive

W = Wordindex

Related tables

Parent tables
cbk-pcinvhdr inv-item-audit lsc-bonus-point lsc-bp-acct lsc-member-card lsc-promotion pur-vendor

Child tables
lsc-bonus-point lsc-mem-point

generated 24-6-2026 08:26