# Shiseido CRM Raw Data Schema
###### tags: `shiseido`
## Orders

| Column Name | Data Type | Remark |
| -------- | -------- | -------- |
| MARKNO | String | |
| CUSTNO | Int | |
| MDKEY1 | String | |
| MDDATE | String | |
| MDTIME | String | |
| BCID | String | |
| VIPIDS | String | |
| MDKEY2 | Int | |
| MDTYPE | Int | |
| PRODNO | String | |
| MDPRIC | Int | |
| MDQTY | Int | |
| MDDISC | Double | |
| MDTOT | Double | |

## Products

| Column Name | Data Type | Remark |
| -------- | -------- | -------- |
| MARKNO | String | |
| PRODNO | Int | |
| PMPDCN | String | |
| PMPDEN | String | |
| PMSAPS | Double | |
| PROD_BRAND | String | |
| PROD_BRAND_DESC | String | |
| PROD_LINE | String | |
| PROD_LINE_DESC | String | |
| PROD_SUBLINE | String | |
| PROD_SUBLINE_DESC | String | |
| BEAUTY_CATG_LVL1 | String | |
| BEAUTY_CATG_LVL1_DESC | String | |
| BEAUTY_CATG_LVL2 | String | |
| BEAUTY_CATG_LVL2_DESC | String | |
| BEAUTY_CATG_LVL3 | String | |
| BEAUTY_CATG_LVL3_DESC | String | |

## Stores

| Column Name | Data Type | Remark |
| -------- | -------- | -------- |
| MARKNO | String | |
| CUSTNO | String | |
| CMABNM | String | |
| CMTELN | String | |
| CMNOT1 | String | |
| CHANNELID | Int | |
| CMMRSP | Int | |
| SAPCUSTNO | String | |

## Members

| Column Name | Data Type | Remark |
| -------- | -------- | -------- |
| MARKNO | String | |
| CUSTNO | Int | |
| VIPIDS | Long | |
| VIPSRC | Int | |
| VIPNM | String | |
| SBIRTH | String | |
| IDNO | String | |
| SCLUBNO | String | |
| CARDTYPE | String | |
| INDATE | String | |
| STAGE | String | |
| SEX | String | |
| MARRIE | Int | |
| ISMAIL | Int | |
| ISTEL | Int | |
| ISEMAIL | Int | |
| ZIP| String | |
| ADDR | String | |
| MAIL | String | |
| TELM | String | |
| TELCODEH | String | |
| TELH | String | |
| TELCODEO | String | |
| TELO | String | |
| TELEXTO | String | |
| BCYC | String | |
| OCCU | Int | |
| OCCU2 | Int | |
| SCHOOL | String | |
| OCCU3 | Int | |
| COMPANY | String | |
| OTHER | String | |
| V01 | Int | |
| V02 | Int | |
| V03 | Int | |
| V04 | Int | |
| V05 | Int | |
| V06 | Int | |
| V07 | Int | |
| V08 | Int | |
| MKDATE | String | |
| LASTBONUS | Int | |
| THISBONUS | Int | |
| VIPMG | String | |
| LINE_UID1 | String | |
| LINE_UID1 | String | |
| NEW_OCCU | String | |
| CELLPHONE_HASH_KEY | String | |
| ~~AGE~~ | ~~String~~ | |