qbfdecn.lsc-bonus-point

Loyalty Bonus Points

Table details

Area	ProdData
Dumpname	bonus-point
Label	Loyalty Bonus 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)
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)
180	vendor-no	X	Vendor No	character	x(6)
170	Vendor-point	X	Vendor Point	logical	yes/no	no

Indexes

Index name	Flags	Fields	Datatype
grp-mem	P	grp-cde (+)	character
		mem-no (+)	integer
		stat-cde (+)	character
		point-due-date (-)	date
inv-item		inv-no (+)	character
		item-no (+)	character
		return-ind (+)	logical
mem-stat		mem-no (+)	integer
		stat-cde (+)	character
		point-due-date (+)	date

+ = Ascending

- = Descending

P = Primary

U = Unique

I = Inactive

W = Wordindex

Related tables

Parent tables
cbk-pcinvhdr inv-discgrp inv-item-audit lsc-bp-acct lsc-promotion lsc-vendor-point pur-vendor

Child tables
lsc-purch-point lsc-vendor-point

generated 18-9-2026 10:03