| Name | Description | Type | Additional information |
|---|---|---|---|
| personId | integer |
None. |
|
| eventCode | string |
Max length: 10 |
|
| clientCode | string |
Max length: 12 |
|
| channelCode | string |
Max length: 10 |
|
| leadCode | string |
Max length: 15 |
|
| crmCode | string |
Max length: 20 |
|
| customerCode | string |
Max length: 20 |
|
| companyName | string |
Max length: 100 |
|
| personType | string |
Required Max length: 1 |
|
| titleName | string |
Max length: 100 |
|
| firstName | string |
Max length: 100 |
|
| lastName | string |
Max length: 100 |
|
| birthday | date |
None. |
|
| sex | string |
Max length: 1 |
|
| status | string |
Max length: 1 |
|
| occupationCode | string |
Max length: 10 |
|
| citizenId | string |
Max length: 13 |
|
| taxId | string |
Max length: 13 |
|
| passport | string |
Max length: 20 |
|
| lineId | string |
Max length: 255 |
|
| mobile | string |
None. |
|
| crediteCardPrimary | integer |
None. |
|
| crediteCardSecondary | integer |
None. |
|
| isActive | string |
Max length: 1 |
|
| createBy | string |
None. |
|
| isMember | string |
None. |
|
| updateBy | string |
None. |
|
| memberDate | date |
None. |
|
| isCutomer | string |
None. |
|
| nationCode | string |
None. |
|
| tierCode | string |
None. |
|
| facebookId | string |
None. |
|
| facebookAds | string |
None. |
|
| facebookName | string |
None. |
|
| tierStartDate | date |
None. |
|
| allowSMS | string |
None. |
|
| allowEmail | string |
None. |
|
| allowLine | string |
None. |
|
| allowOnCall | string |
None. |
|
| allowFacebook | string |
None. |
|
| allowTwitter | string |
None. |
|
| remark | string |
None. |
|
| isSubscription | string |
None. |
|
| memberID | integer |
None. |
|
| updateAuto | boolean |
None. |