本体协作平台
F I E L D S · 汇 总 视 图

字段库

25 库 · 1,594 表 · 39,726 字段 · 导入 v1(2026-07-19 21:19)· 重导:python3 scripts/import_dicts.py。切片专项机筛与判定在 切片工作台 → 字段对照(P3)。

命中 39,726 条 · 第 254/398
库.表字段类型中文名 / 英文解释业务定义码值/单位置信敏感
tcbtrd_imeg_cindy_ods_safe_maskt_payment_goods_info_allo_ipgreference_nostring编号记录t_payment_goods_info_allo_ipg中的编号类字段,用于业务关联或明细定位。20260601000000010117802468812836;20260601000000020117802468875832;20260601000000030117802468922203
tcbtrd_imeg_cindy_ods_safe_maskt_payment_goods_info_allo_ipgidbigintID记录t_payment_goods_info_allo_ipg中的唯一ID或外部系统标识。910168;910169;910170
tcbtrd_imeg_cindy_ods_safe_maskt_payment_goods_info_allo_ipgupdate_timestring更新时间update time更新时间
tcbtrd_imeg_cindy_ods_safe_maskt_payment_goods_info_allo_ipgupdate_bystring更新人update by更新人
tcbtrd_imeg_cindy_ods_safe_maskt_payment_goods_info_allo_ipgcreate_timestring创建时间create time创建时间
tcbtrd_imeg_cindy_ods_safe_maskt_payment_goods_info_allo_ipgcreate_bystring创建人create by记录配置、任务或业务记录的创建人/创建账号。system
tcbtrd_imeg_cindy_ods_safe_maskt_payment_goods_info_allo_ipggoods_numdouble数量goods num订单、优惠券、积分、客户或业务对象的数量统计字段。 · 个/次
tcbtrd_imeg_cindy_ods_safe_maskt_payment_goods_info_allo_ipggoods_idstringIDgoods id记录t_payment_goods_info_allo_ipg中的ID类业务标识,用于关联上下游记录。20260601001430257031;20260601001416966003;20260601001410682863
tcbtrd_imeg_cindy_ods_safe_maskt_payment_goods_info_allo_ipgdsstring数据日期data date数据分区日期或统计日期。 · yyyymmdd
tcbtrd_imeg_cindy_ods_safe_maskt_payment_goods_info_allo_ipgdcnstringDCN编号DCN identifier数据切分或区域标识编号。1A0
tcbtrd_imeg_cindy_ods_safe_maskt_payment_order_allo_ipgidbigintID记录t_payment_order_allo_ipg中的唯一ID或外部系统标识。856298;856303;856307
tcbtrd_imeg_cindy_ods_safe_maskt_payment_order_allo_ipgreference_nostring编号记录t_payment_order_allo_ipg中的编号类字段,用于业务关联或明细定位。20260531000038770117802446949502;20260531000038820117802448388173;20260531000038860117802448932091
tcbtrd_imeg_cindy_ods_safe_maskt_payment_order_allo_ipgpartner_reference_nostring编号记录t_payment_order_allo_ipg中的编号类字段,用于业务关联或明细定位。20260531001414957524;20260531001430735507;20260531001447791429
tcbtrd_imeg_cindy_ods_safe_maskt_payment_order_allo_ipgorder_nostring编号记录t_payment_order_allo_ipg中的编号类字段,用于业务关联或明细定位。20260531001414957524;20260531001430735507;20260531001447791429
tcbtrd_imeg_cindy_ods_safe_maskt_payment_order_allo_ipgbiz_seq_nostring编号记录t_payment_order_allo_ipg中的编号类字段,用于业务关联或明细定位。260531011082514i1223245502506215;260531011082514i2223271801343326;260531011082514i1123281321973411
tcbtrd_imeg_cindy_ods_safe_maskt_payment_order_allo_ipgmerchant_idstring商户号merchant identifier记录商户的唯一编号。SNAP01DNA01;SNAP01PLN01🔒
tcbtrd_imeg_cindy_ods_safe_maskt_payment_order_allo_ipgmerchant_user_idstringIDmerchant user id记录t_payment_order_allo_ipg中的ID类业务标识,用于关联上下游记录。2025121011121583011IDANAW3ID243394191748;2026042911121583011IDANAW3ID077304552046;2026042011121583011IDANAW3ID296896512170
tcbtrd_imeg_cindy_ods_safe_maskt_payment_order_allo_ipgmsisdn_global_roamingstring金额/比例msisdn global roaming表示t_payment_order_allo_ipg中的金额/比例金额字段,样例值如 +62。
tcbtrd_imeg_cindy_ods_safe_maskt_payment_order_allo_ipgmsisdnstring哈希值样例值表现为哈希/摘要值,表示t_payment_order_allo_ipg中的文件、主键、外部对象或脱敏关联键。709A5951438CE3E00155377DCF00B387;D6C7EEF0C99D73DC5E22A20F3849DAE6;5CA888E58ABC96B8FCE2B9C57862CCD4
tcbtrd_imeg_cindy_ods_safe_maskt_payment_order_allo_ipgmpc_uidstringID记录t_payment_order_allo_ipg中的唯一ID或外部系统标识。5000201000138383871;5000201000149840502;5000201000148406722
tcbtrd_imeg_cindy_ods_safe_maskt_payment_order_allo_ipgmdc_idstringIDmdc id记录t_payment_order_allo_ipg中的ID类业务标识,用于关联上下游记录。000201000151838442;000201000163372782;000201000161934431
tcbtrd_imeg_cindy_ods_safe_maskt_payment_order_allo_ipgdevice_idstringIDdevice id记录t_payment_order_allo_ipg中的ID类业务标识,用于关联上下游记录。91f3a2ccf49c9fdd5d463517b2b61f1c;2f879d1a51dc82bb0d7b0a5f76827e7b;2ae35454f846401c39740d65373b59ec
tcbtrd_imeg_cindy_ods_safe_maskt_payment_order_allo_ipgpayment_methodstring枚举/状态值payment method样例值表现为代码或短文本枚举,表示t_payment_order_allo_ipg中的状态、类型、渠道、角色或处理方式。样例为短代码/枚举值
tcbtrd_imeg_cindy_ods_safe_maskt_payment_order_allo_ipgtransaction_datestring业务日期时间transaction date样例值表现为日期/时间,表示t_payment_order_allo_ipg中的业务发生、创建、更新、统计或生效时间。
tcbtrd_imeg_cindy_ods_safe_maskt_payment_order_allo_ipgtransaction_timestring业务日期时间transaction time样例值表现为日期/时间,表示t_payment_order_allo_ipg中的业务发生、创建、更新、统计或生效时间。
tcbtrd_imeg_cindy_ods_safe_maskt_payment_order_allo_ipgorder_expired_timestring业务日期时间order expired time样例值表现为日期/时间,表示t_payment_order_allo_ipg中的业务发生、创建、更新、统计或生效时间。
tcbtrd_imeg_cindy_ods_safe_maskt_payment_order_allo_ipgtransaction_amountdouble金额transaction amount记录交易、费用、汇总或结算场景中的金额值。 · 金额
tcbtrd_imeg_cindy_ods_safe_maskt_payment_order_allo_ipgtransaction_currencystring币种transaction currency金额字段对应的币种代码。IDR · 币种码
tcbtrd_imeg_cindy_ods_safe_maskt_payment_order_allo_ipgdeduction_amountdouble金额deduction amount记录交易、费用、汇总或结算场景中的金额值。 · 金额
tcbtrd_imeg_cindy_ods_safe_maskt_payment_order_allo_ipgdeduction_currencystring币种deduction currency金额字段对应的币种代码。IDR;NULL · 币种码
tcbtrd_imeg_cindy_ods_safe_maskt_payment_order_allo_ipgfee_typestring类型type用于区分该业务记录的类型或处理模式,具体码值需结合系统码表确认。样例为短代码/枚举值
tcbtrd_imeg_cindy_ods_safe_maskt_payment_order_allo_ipgfee_amountdouble金额fee amount记录交易、费用、汇总或结算场景中的金额值。 · 金额
tcbtrd_imeg_cindy_ods_safe_maskt_payment_order_allo_ipgfee_currencystring币种fee currency金额字段对应的币种代码。IDR;NULL · 币种码
tcbtrd_imeg_cindy_ods_safe_maskt_payment_order_allo_ipgbalance_payment_amountdouble金额balance payment amount记录交易、费用、汇总或结算场景中的金额值。 · 金额
tcbtrd_imeg_cindy_ods_safe_maskt_payment_order_allo_ipgbalance_payment_currencystring币种balance payment currency金额字段对应的币种代码。IDR;NULL · 币种码
tcbtrd_imeg_cindy_ods_safe_maskt_payment_order_allo_ipgpaylater_payment_amountdouble金额paylater payment amount记录交易、费用、汇总或结算场景中的金额值。 · 金额
tcbtrd_imeg_cindy_ods_safe_maskt_payment_order_allo_ipgpaylater_payment_currencystring币种paylater payment currency金额字段对应的币种代码。NULL · 币种码
tcbtrd_imeg_cindy_ods_safe_maskt_payment_order_allo_ipgpointdoublepoint表示t_payment_order_allo_ipg中的point业务字段,样例值如 0.0,NULL。
tcbtrd_imeg_cindy_ods_safe_maskt_payment_order_allo_ipgrefund_amountdouble金额refund amount记录交易、费用、汇总或结算场景中的金额值。 · 金额
tcbtrd_imeg_cindy_ods_safe_maskt_payment_order_allo_ipgstatusstring枚举/状态值样例值表现为代码或短文本枚举,表示t_payment_order_allo_ipg中的状态、类型、渠道、角色或处理方式。样例为短代码/枚举值
tcbtrd_imeg_cindy_ods_safe_maskt_payment_order_allo_ipgcore_resp_codestring代码core resp code记录t_payment_order_allo_ipg中的代码类字段,具体码值需结合系统码表确认。82641111;8122B11010016;82640000
tcbtrd_imeg_cindy_ods_safe_maskt_payment_order_allo_ipgcore_resp_msgstring哈希值core resp msg样例值表现为哈希/摘要值,表示t_payment_order_allo_ipg中的文件、主键、外部对象或脱敏关联键。3000425C7F2B5B65BC5CA58D41E8C670;1858FC98878F42915103C2A5350B1DEB;5B05BA4589A87C437CC05E964C1E85DD
tcbtrd_imeg_cindy_ods_safe_maskt_payment_order_allo_ipgcallback_urlstring回调URLcallback url接口处理完成后用于通知上游系统的回调地址。URL
tcbtrd_imeg_cindy_ods_safe_maskt_payment_order_allo_ipgcallback_url_typestring类型type用于区分该业务记录的类型或处理模式,具体码值需结合系统码表确认。样例为短代码/枚举值
tcbtrd_imeg_cindy_ods_safe_maskt_payment_order_allo_ipgis_callback_url_deep_linkstring是否标志is callback url deep link布尔型或标志位字段,用于表示某业务条件是否成立。是否类标志
tcbtrd_imeg_cindy_ods_safe_maskt_payment_order_allo_ipgcreate_bystring创建人create by记录配置、任务或业务记录的创建人/创建账号。system
tcbtrd_imeg_cindy_ods_safe_maskt_payment_order_allo_ipgcreate_timestring创建时间create time创建时间
tcbtrd_imeg_cindy_ods_safe_maskt_payment_order_allo_ipgupdate_bystring更新人update by更新人
tcbtrd_imeg_cindy_ods_safe_maskt_payment_order_allo_ipgupdate_timestring更新时间update time更新时间
tcbtrd_imeg_cindy_ods_safe_maskt_payment_order_allo_ipgdsstring数据日期data date数据分区日期或统计日期。 · yyyymmdd
tcbtrd_imeg_cindy_ods_safe_maskt_payment_order_allo_ipgdcnstringDCN编号DCN identifier数据切分或区域标识编号。1A0
tcbtrd_imeg_cindy_ods_safe_maskt_payment_order_ipg_billpaymentpaylater_payment_amountdouble金额paylater payment amount记录交易、费用、汇总或结算场景中的金额值。 · 金额
tcbtrd_imeg_cindy_ods_safe_maskt_payment_order_ipg_billpaymentdevice_idstringIDdevice id记录t_payment_order_ipg_billpayment中的ID类业务标识,用于关联上下游记录。2D61B93627F24A1E80AE6A7677619827;E4B8072E95644CBCAC86FE7A14027874;b9499aaa34cac48331c7387b8be966f5
tcbtrd_imeg_cindy_ods_safe_maskt_payment_order_ipg_billpaymentmpc_uidstringID记录t_payment_order_ipg_billpayment中的唯一ID或外部系统标识。5000201000142652202;5000201000141352411;5000201000147467362
tcbtrd_imeg_cindy_ods_safe_maskt_payment_order_ipg_billpaymentmdc_idstringIDmdc id记录t_payment_order_ipg_billpayment中的ID类业务标识,用于关联上下游记录。000201000156116422;000201000154813202;000201000160986491
tcbtrd_imeg_cindy_ods_safe_maskt_payment_order_ipg_billpaymentmsisdnstring哈希值样例值表现为哈希/摘要值,表示t_payment_order_ipg_billpayment中的文件、主键、外部对象或脱敏关联键。89E9DFD46A8C5DE7E351F12C0B5B54AD;87C10A3A872B35DC666F3052ABEB62EF;24B9E68E16081BB8FB632B514E00A3D1
tcbtrd_imeg_cindy_ods_safe_maskt_payment_order_ipg_billpaymentmsisdn_global_roamingstring金额/比例msisdn global roaming表示t_payment_order_ipg_billpayment中的金额/比例金额字段,样例值如 +62。
tcbtrd_imeg_cindy_ods_safe_maskt_payment_order_ipg_billpaymentmerchant_namestring商户名称merchant name业务记录关联的商户名称。
tcbtrd_imeg_cindy_ods_safe_maskt_payment_order_ipg_billpaymentpayment_methodstring枚举/状态值payment method样例值表现为代码或短文本枚举,表示t_payment_order_ipg_billpayment中的状态、类型、渠道、角色或处理方式。样例为短代码/枚举值
tcbtrd_imeg_cindy_ods_safe_maskt_payment_order_ipg_billpaymenttransaction_datestring业务日期时间transaction date样例值表现为日期/时间,表示t_payment_order_ipg_billpayment中的业务发生、创建、更新、统计或生效时间。
tcbtrd_imeg_cindy_ods_safe_maskt_payment_order_ipg_billpaymenttransaction_timestring业务日期时间transaction time样例值表现为日期/时间,表示t_payment_order_ipg_billpayment中的业务发生、创建、更新、统计或生效时间。
tcbtrd_imeg_cindy_ods_safe_maskt_payment_order_ipg_billpaymenttransaction_amountdouble金额transaction amount记录交易、费用、汇总或结算场景中的金额值。 · 金额
tcbtrd_imeg_cindy_ods_safe_maskt_payment_order_ipg_billpaymenttransaction_currencystring币种transaction currency金额字段对应的币种代码。IDR · 币种码
tcbtrd_imeg_cindy_ods_safe_maskt_payment_order_ipg_billpaymentdeduction_amountdouble金额deduction amount记录交易、费用、汇总或结算场景中的金额值。 · 金额
tcbtrd_imeg_cindy_ods_safe_maskt_payment_order_ipg_billpaymentdeduction_currencystring币种deduction currency金额字段对应的币种代码。NULL;IDR · 币种码
tcbtrd_imeg_cindy_ods_safe_maskt_payment_order_ipg_billpaymentbalance_payment_amountdouble金额balance payment amount记录交易、费用、汇总或结算场景中的金额值。 · 金额
tcbtrd_imeg_cindy_ods_safe_maskt_payment_order_ipg_billpaymentbalance_payment_currencystring币种balance payment currency金额字段对应的币种代码。IDR · 币种码
tcbtrd_imeg_cindy_ods_safe_maskt_payment_order_ipg_billpaymentpaylater_payment_currencystring币种paylater payment currency金额字段对应的币种代码。NULL · 币种码
tcbtrd_imeg_cindy_ods_safe_maskt_payment_order_ipg_billpaymentpointdoublepoint表示t_payment_order_ipg_billpayment中的point业务字段,样例值如 NULL,5000.0,7000.0。
tcbtrd_imeg_cindy_ods_safe_maskt_payment_order_ipg_billpaymentstatusstring枚举/状态值样例值表现为代码或短文本枚举,表示t_payment_order_ipg_billpayment中的状态、类型、渠道、角色或处理方式。样例为短代码/枚举值
tcbtrd_imeg_cindy_ods_safe_maskt_payment_order_ipg_billpaymentcore_payment_respstring响应报文core payment resp样例值表现为结构化JSON/报文内容,表示t_payment_order_ipg_billpayment中的响应报文或扩展业务数据。JSON/结构化文本
tcbtrd_imeg_cindy_ods_safe_maskt_payment_order_ipg_billpaymentcore_status_inquiry_countint数量core status inquiry count订单、优惠券、积分、客户或业务对象的数量统计字段。是否类标志 · 个/次
tcbtrd_imeg_cindy_ods_safe_maskt_payment_order_ipg_billpaymentcore_status_inquiry_respstring状态core status inquiry resp表示t_payment_order_ipg_billpayment中的状态,用于描述业务状态或处理结果,样例值如 NULL。NULL
tcbtrd_imeg_cindy_ods_safe_maskt_payment_order_ipg_billpaymentcore_resp_msgstring响应报文core resp msg样例值表现为结构化JSON/报文内容,表示t_payment_order_ipg_billpayment中的响应报文或扩展业务数据。JSON/结构化文本
tcbtrd_imeg_cindy_ods_safe_maskt_payment_order_ipg_billpaymentbusiness_scenariostringbusiness scenariobusiness scenario表示t_payment_order_ipg_billpayment中的business scenario业务字段,样例值如 01。
tcbtrd_imeg_cindy_ods_safe_maskt_payment_order_ipg_billpaymentcreated_bystring创建人created by记录配置、任务或业务记录的创建人/创建账号。system
tcbtrd_imeg_cindy_ods_safe_maskt_payment_order_ipg_billpaymentcreated_timestring创建时间created time创建时间
tcbtrd_imeg_cindy_ods_safe_maskt_payment_order_ipg_billpaymentupdated_bystring更新人updated by更新人
tcbtrd_imeg_cindy_ods_safe_maskt_payment_order_ipg_billpaymentupdated_timestring创建时间updated time创建时间
tcbtrd_imeg_cindy_ods_safe_maskt_payment_order_ipg_billpaymentmerchant_idstring商户号merchant identifier记录商户的唯一编号。50002SPK01🔒
tcbtrd_imeg_cindy_ods_safe_maskt_payment_order_ipg_billpaymentbiz_seq_nostring编号记录t_payment_order_ipg_billpayment中的编号类字段,用于业务关联或明细定位。260601011082514i2200000302597258;260601011082514i2200014601352247;260601011082514i2200070902598742
tcbtrd_imeg_cindy_ods_safe_maskt_payment_order_ipg_billpaymentorder_nostring编号记录t_payment_order_ipg_billpayment中的编号类字段,用于业务关联或明细定位。20260601000000010217802468034240;20260601000000020217802469067529;20260601000000030217802472289762
tcbtrd_imeg_cindy_ods_safe_maskt_payment_order_ipg_billpaymentbiz_order_nostring编号记录t_payment_order_ipg_billpayment中的编号类字段,用于业务关联或明细定位。946FM1026FDBOFCF88A58SP;8143M1026FDBVBEB58A58SP;E84AM1026FDBUDHD7EA58SP
tcbtrd_imeg_cindy_ods_safe_maskt_payment_order_ipg_billpaymentticket_numberstringticket numberticket number表示t_payment_order_ipg_billpayment中的ticket number业务字段,样例值如 946FM1026FDBOFCF88A58SP,8143M1026FDBVBEB58A58SP,E84AM1026FDBUDHD7EA58SP。
tcbtrd_imeg_cindy_ods_safe_maskt_payment_order_ipg_billpaymentpartner_reference_nostring编号记录t_payment_order_ipg_billpayment中的编号类字段,用于业务关联或明细定位。6cc2614d45c2f2116fcbad7da23346d3;bda1ca101503d7fc99a1545ad2260c96;3c80c57073bd32feb91534db0e93aa8a
tcbtrd_imeg_cindy_ods_safe_maskt_payment_order_ipg_billpaymentreference_nostring编号记录t_payment_order_ipg_billpayment中的编号类字段,用于业务关联或明细定位。20260601000000010117802468032385;20260601000000020117802469067470;20260601000000030117802472289722
tcbtrd_imeg_cindy_ods_safe_maskt_payment_order_ipg_billpaymentidbigintID记录t_payment_order_ipg_billpayment中的唯一ID或外部系统标识。2602532;2602533;2602534
tcbtrd_imeg_cindy_ods_safe_maskt_payment_order_ipg_billpaymentdsstring数据日期data date数据分区日期或统计日期。 · yyyymmdd
tcbtrd_imeg_cindy_ods_safe_maskt_payment_order_ipg_billpaymentdcnstringDCN编号DCN identifier数据切分或区域标识编号。1A0
tcbtrd_imeg_cindy_ods_safe_maskt_payment_order_paylater_allo_ipgidbigintID记录t_payment_order_paylater_allo_ipg中的唯一ID或外部系统标识。2061139802405277698;2061196781790523393;2061197273157431297
tcbtrd_imeg_cindy_ods_safe_maskt_payment_order_paylater_allo_ipgpayment_reference_nostring编号记录t_payment_order_paylater_allo_ipg中的编号类字段,用于业务关联或明细定位。20260601000001050117802489725186;20260601000007210117802625201468;20260601000007290117802626905127
tcbtrd_imeg_cindy_ods_safe_maskt_payment_order_paylater_allo_ipgloan_codestring代码loan code记录t_payment_order_paylater_allo_ipg中的代码类字段,具体码值需结合系统码表确认。样例为短代码/枚举值
tcbtrd_imeg_cindy_ods_safe_maskt_payment_order_paylater_allo_ipgloan_start_datestring业务日期时间loan start date样例值表现为日期/时间,表示t_payment_order_paylater_allo_ipg中的业务发生、创建、更新、统计或生效时间。
tcbtrd_imeg_cindy_ods_safe_maskt_payment_order_paylater_allo_ipgloan_termsstring期数term count贷款、分期或协议的期数/期限配置。 · 期
tcbtrd_imeg_cindy_ods_safe_maskt_payment_order_paylater_allo_ipgfee_ratiodouble比例/占比fee ratio贷款、额度、费用或经营分析中的比例/占比字段。 · 比例
tcbtrd_imeg_cindy_ods_safe_maskt_payment_order_paylater_allo_ipgpayment_due_datestring业务日期时间payment due date样例值表现为日期/时间,表示t_payment_order_paylater_allo_ipg中的业务发生、创建、更新、统计或生效时间。
tcbtrd_imeg_cindy_ods_safe_maskt_payment_order_paylater_allo_ipgfirst_payment_due_datestring业务日期时间first payment due date样例值表现为日期/时间,表示t_payment_order_paylater_allo_ipg中的业务发生、创建、更新、统计或生效时间。
tcbtrd_imeg_cindy_ods_safe_maskt_payment_order_paylater_allo_ipgcreate_bystring创建人create by记录配置、任务或业务记录的创建人/创建账号。system
tcbtrd_imeg_cindy_ods_safe_maskt_payment_order_paylater_allo_ipgcreate_timestring创建时间create time创建时间
tcbtrd_imeg_cindy_ods_safe_maskt_payment_order_paylater_allo_ipgupdate_bystring更新人update by更新人