Programmer:Member

Technical Specification

1. Customer's account book must have enabled Bonus Point module. 2.

Columns Specification

Columns Table
Column Name	Data Type	Size	Mandatory	Remark
MemberNo	string	20	Yes
MemberType	string	20	Yes	Value must be maintained at Bonus Point > Member Type Maintenance
ID	string	20	No	Can be used for member identification
Name	string	100	No	Name of the membership
Address1	string	40	No
Address2	string	40	No
Address3	string	40	No
Address4	string	40	No
AreaCode	string	12	No	Value is maintained at General Maintenance > Area Maintenance
Individual	string	1	Yes	Though is a bool type, it uses value of "T" or "F"
Race	string	10	No	Value is maintained at Bonus Point > Race Maintenance
DOB	DateTime		No
DebtorCode	string	12	No	Value is maintained at A/R > Debtor Maintenance
Company Name	string	100	No
Department	string	30	No
Title	string	40	No
MobilePhone	string	25	No
EmailAddress	string	80	No
OpeningPoints	decimal	19,2	Yes	Total carry forward points that has no transaction
Gender	string	1	No

See Also

• AR Debtor (Customer) - [1.8, 1.9] [2.0]
• Stock Item (Item Maintenance) - [1.8, 1.9] [2.0]

Maintenance (Master Data)

• Member - [1.8, 1.9] [2.0]
• Member Type - [1.8, 1.9] [2.0]
• Race - [1.8, 1.9] [2.0]

Transactions

• Bonus Point Adjustment - [1.8, 1.9] [2.0]
• Bonus Point Redemption - [1.8, 1.9] [2.0]
• Earn Point with Sale Invoice - [1.8, 1.9] [2.0]

Reporting

Member List and Point Balance - [1.8, 1.9] [2.0]

Go to menu

Go to top

Resources For AutoCount Software Developers