| DB | Areas | X-idx | Tables | Sequences | <- lsc-mem-point | lsc-member-card -> | HtmlDict 11 |
Loyalty Member
| Area | ProdData |
|---|---|
| Dumpname | member |
| Label | Loyalty Member |
| Val.exp | ? |
| Val.msg |
| Order | Field Name | x | Label | Datatype | Format | Initial | Mand | Description |
|---|---|---|---|---|---|---|---|---|
| 450 | ben-mem-no | X | Beneficiary | integer | 9999999 | 0 | ||
| 120 | cell-no | X | Cell No | character | x(20) | |||
| 440 | city | X | City | character | x(24) | |||
| 225 | client-no | X | Client No | character | x(6) | |||
| 160 | create-date | X | Create Date | date | 99/99/9999 | ? | ||
| 210 | depend-dob | X | Depend Dob | date [10] | 99/99/9999 | ? | ||
| 220 | depend-name | X | Dependend Name | character [10] | x(25) | |||
| 170 | dob | X | Date of birth | date | 99/99/9999 | ? | ||
| 130 | X | character | x(30) | |||||
| 110 | fax-no | X | Fax No | character | x(20) | |||
| 20 | grp-cde | X | Group Code | character | x(8) | |||
| 90 | home-tel | X | Home Tel | character | x(20) | |||
| 30 | initials | X | Initials | character | x(5) | |||
| 460 | lang-cde | X | Language Code | character | x(4) | |||
| 330 | last-acti-date | X | Last Activity Date | date | 99/99/9999 | ? | ||
| 340 | last-comm-date | X | Last Communication Date | date | 99/99/9999 | ? | ||
| 10 | mem-no | X | Member No | integer | 9999999 | 0 | ||
| 50 | name | X | Name | character | x(25) | |||
| 200 | no-depend | X | No of Dependends | integer | 99 | 0 | ||
| 380 | point-accr | X | Points Accrued | decimal-2 | >>,>>>,>>9.99- | 0 | ||
| 350 | point-avail | X | Points Avail | decimal-2 | >>,>>>,>>9.99- | 0 | ||
| 370 | point-lost | X | Points Lost | decimal-2 | >>,>>>,>>9.99- | 0 | ||
| 360 | point-not-due | X | Points not due | decimal-2 | >>,>>>,>>9.99- | 0 | ||
| 390 | point-red | X | Points Redeemed | decimal-2 | >>,>>>,>>9.99- | 0 | ||
| 60 | post-addr | X | Postal Address | character [2] | x(20) | |||
| 70 | post-cde | X | Postal Code | character | x(8) | |||
| 140 | pref-comm | X | Pref Communication | character | ! | |||
| 180 | spouse-dob | X | Spouse Date of birth | date | 99/99/9999 | ? | ||
| 190 | spouse-name | X | Spouse Name | character | x(25) | |||
| 80 | st-addr | X | Street Address | character [3] | x(20) | |||
| 150 | stat-cde | X | Status Code | character | ! | |||
| 430 | suburb | X | Suburb | character | x(24) | |||
| 40 | surname | X | Surname | character | x(25) | |||
| 400 | upd-date | X | Updated | date | 99/99/9999 | ? | ||
| 410 | upd-time | X | At | integer | 99999 | 0 | ||
| 420 | upd-user-id | X | By | character | x(12) | |||
| 280 | user-fld1-data | X | User Field Data | character | x(25) | |||
| 290 | user-fld2-data | X | User Field Data | character | x(25) | |||
| 300 | user-fld3-data | X | User Field Data | character | x(25) | |||
| 310 | user-fld4-data | X | User Field Data | character | x(25) | |||
| 320 | user-fld5-data | X | User Field Data | character | x(25) | |||
| 100 | work-tel | X | Work Tel | character | x(20) |
| Index name | Flags | Fields | Datatype |
|---|---|---|---|
| mem-no | P U | mem-no (+) | integer |
| client-no | client-no (+) | character | |
| mem-stat | U | stat-cde (+) | character |
| mem-no (+) | integer | ||
| stat-grp | stat-cde (+) | character | |
| grp-cde (+) | character | ||
| upd-user-date | upd-date (+) | date | |
| upd-user-id (+) | character |
| + = Ascending | - = Descending | P = Primary | U = Unique | I = Inactive | W = Wordindex |
| Parent tables |
|---|
| acr-client inv-combocom inv-comboitem inv-discgrp sys-town |
| Child tables |
|---|
| acr-arinv acr-arinv-csh lsc-comp-entry lsc-feedback lsc-member-card lsc-memitm-use lsc-msg-member lsc-promo-rew lsc-purch-point |
| generated 24-6-2026 08:26 |