Difference between revisions of "Programmer:Member List and Point Balance v2"

Jump to navigation Jump to search
no edit summary
(Created page with "==Assemblies version 2.0== {{BaseReferenceAC20}} '''AutoCount.GeneralMaint.dll''' '''AutoCount.Invoicing.dll''' '''AutoCount.Invoicing.Sales.dll''' ==Load Member data== Re...")
 
 
==Technical Specification==
#Customer's account book must enable '''Bonus Point''' module.
#To learn how AutoCount Bonus Point works, click [[Bonus Point]]
 
==Columns Specification==
{| class="wikitable mw-collapsible mw-collapsed"
!colspan=5|Columns Table
|-
! Column Name !! Data Type !! Size !! Mandatory !! Remark
|-
| MemberNo || string || 20 || Yes ||
|-
| MemberType || string || 20 || Yes || Value must be maintained at Bonus Point > [[Programmer:Member Type|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, applicable value is "T" or "F"<br/>Default: "T"
|-
| Race || string || 10 || No || Value is maintained at Bonus Point > [[Programmer:Member Race|Race Maintenance]]
|-
| DOB || DateTime || || No ||
|-
| DebtorCode || string || 12 || No || Value is maintained at A/R > [[AR Debtor|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<br/>Default:0
|-
| Gender || string || 1 || No || null, "M" or "F"
|-
| RegisterDate || DateTime || || No ||
|-
| ExpiryDate || DateTime || || No ||
|-
| IsActive || string || 1 || Yes || Though is a bool type, applicable value is "T" or "F"<br/>Default: "T"
|}
 
==Assemblies version 2.0==
{{BaseReferenceAC20}}
authors, Bureaucrats, Confirmed users, Rollbackers, Administrators
2,374
edits
Cookies help us deliver our services. By using our services, you agree to our use of cookies.

Navigation menu