TCSO_PRTY Account Basic Information Table

mdfy_apsvc_id Last modifier service name

jn_dt Join datetimeunused
8 : long-term
usr_sts_cd 9
M::withdrawal
Mobile
jn_chnl_cd W
SW Web
: : Setup Wizard
jn_chnl_dtl_cd PA : PC Application
prvc_acpt_dt Privacy acceptance datetime
brth_dd Birthday
cnty_cd Country code
sms_rcv_yn_fg SMS reception flag
gvn_nm Given name
email_rcv_yn_fg Email reception flag
rcv_email_txt Email address for email reception
crt_apsvc_id First creator service name
prvc_acpt_yn_fg Privacy acceptance flag
email_vld_chk Email validation check flag
advt_acpt_yn_fg Advertisement acceptance flag
fam_nm Family name
custz_svc_cltn_usg_acpt_yn_fg Customized service usage acceptance flag
usr_nm User name
3 : Device
usr_tp_cd 4 : Guest
TCSO_PRTY_IDNTN Account loginID Management Table
mdfy_apsvc_id Last modifier service name
sf_lgn_id Login ID
lgn_id Login ID
crt_apsvc_id First creator service name
usr_pwd_chng_dt User Password Change Datetime
TCSO_TNC_ACPTNC Account Terms and Conditions Acceptance Table
mdfy_apsvc_id Last modifier service name
tnc_acpt_dt Terms and Conditions acceptance datetime
tnc_acpt_lang_cd Terms and Conditions acceptance language code
tnc_acpt_fg Terms and Conditions acceptance flag
mbl_cnty_cd Mobile country code
tnc_ver_txt Terms and Conditions version
crt_apsvc_id First creator service name
TCSO_PRTY_DVCE Account Device Registration Table
mdfy_apsvc_id Last modifier service name
9 : OVEN
dvce_tp_cd 10 : ROBOTCLEANER
dvce_phsl_addr_txt Device physical address text
dvce_clnt_ver Client version
dvce_cust_cd_txt Device customer code
dvce_model_id Device model ID
dvce_mlt_usr_id Device multi user ID
dvce_nm Device name
dvce_mnc_txt Device mobile network code
crt_apsvc_id First creator service name
dvce_mcc_txt Device mobile country code
sw_ver_txt Software version text
dvce_reg_dt Device registration datetime
dvce_seq Sequence number
dvce_clnt_os_ver OS version
phon_num_sms_auth_fg Phone number SMS authentification flag
dvce_unq_id Device
Device unique ID
status code
dvce_sts_cd 1: active
dvce_srl_num_txt Device serial number text
phon_num_txt Phone number text
TCSO_PRTY_CNTCT_ADDR Account Contact Address Table
mdfy_apsvc_id Last modifier service name
itntnl_yn_fg Domestic or international flag for address type detail
addr_tp_seq Sequence number
pref_addr_tp_yn_fg Preferenced address type flag
post_cd_txt Postal code
crt_apsvc_id First creator service name
addr_tp_dtl_txt Contact address type detail
TCSO_PRTY_PRF_NM Account Profile Name Table
mdfy_apsvc_id Last modifier service name
fam_nm Family name
gvn_nm Given name
sfx_nm Suffix name
prfx_nm Prefix name
midl_nm Middle Name
crt_apsvc_id First creator service name
mdfy_tsp Last modified timestamp
Consent Agreement History
app_key Application ID
device_id User's device ID
model_name Model name
os_version OS version
region Agreed country code
consent_id Consent ID
status Agreed or withdrawn
j5p7ll8g33
2021-10-08 01:44:58.0
1
M
PD
2023-06-01 07:14:41.0
1987-06-29 00:00:00.0
USA
N
Ryan
N
[email protected]
j5p7ll8g33
Y
Y
Y
Todd
Y
Ryan Todd
1

j5p7ll8g33
[email protected]
[email protected]
j5p7ll8g33
2021-10-08 01:44:58.392714

j5p7ll8g33
2023-02-12 15:46:57.0
KOR
Y
310
3.3
j5p7ll8g33

j5p7ll8g33
1
IMEI:357014530167055
1410000008
TMK
SM-A025U
0
Samsung Galaxy A02s
26
j5p7ll8g33
310
SP1A.210812.016/A025USQU2CWD2
2021-10-08 01:44:58.0
7W2ts1juBL
31
N
OZI22E5KMGYCU
1
R9PR904KHNN
17347950537

ea2r064y73
N
7116391979
Y
48035
j5p7ll8g33
POSTAL

j5p7ll8g33
Todd
Ryan

j5p7ll8g33
2021-10-08 01:45:02.843

j5p7ll8g33 j5p7ll8g33 j5p7ll8g33 j5p7ll8g33

OZI22E5KMGYCU OZI22E5KMGYCU Profile_Server OZI22E5KMGYCU
SM-A025U SM-A025U Sync_ProfileConsent SM-A025U
Android 12 Android 11 Profile_to_CMS Android 12
USA USA USA USA
300 174 343 303
A A A A
j5p7ll8g33 j5p7ll8g33 j5p7ll8g33 j5p7ll8g33
OZI22E5KMGYCU account-profile-server OZI22E5KMGYCU OZI22E5KMGYCU
SM-A025U account-profile SM-A025U SM-A025U
Android 12 account-profile Android 11 Android 11
USA USA USA USA
312 299 156 203
A W A A
j5p7ll8g33 j5p7ll8g33 j5p7ll8g33 j5p7ll8g33 j5p7ll8g33
account-profile-server OZI22E5KMGYCU OZI22E5KMGYCU OZI22E5KMGYCU OZI22E5KMGYCU
account-profile SM-A025U SM-A025U SM-A025U SM-A025U
account-profile Android 11 30 Android 12 Android 12
USA USA USA USA USA
298 247 160 314 313
A A A W W
j5p7ll8g33 j5p7ll8g33 j5p7ll8g33 j5p7ll8g33
OZI22E5KMGYCU OZI22E5KMGYCU Profile_Server OZI22E5KMGYCU
SM-A025U SM-A025U Sync_ProfileConsent SM-A025U
30 31 Profile_to_CMS Android 12
USA USA USA USA
4 298 343 317
A W W A