资源描述：
《资料接口配置手册--20120926》由会员上传分享，免费在线阅读，更多相关内容在行业资料-天天文库。
1、S资料接口配置手册描述：CRM和计费2.0的资料接口，需要配置套餐促销的转换关系。资料接口的配置转换涉及3张表：ZK.DISCT_RELATE----映射计费商品ZK.DISCT_OBJECT_RELATE----映射计费商品成员ZK.DISCT_PARAM_RELATE----映射计费商品参数环境：YZDB用户：ZK一产品包配置1、虚用户INSERTINTOZK.DISCT_RELATESELECTDISTINCTPAR_PLAN_ID,0,PAR_PLAN_ID,1,'客户级计划转组合商品（
2、河南）'FROMDATA.SYX_CUST_PRICING_DETAIL@NTEST_ZTWHEREPAR_PLAN_IDIN(虚用户PLAN_ID);INSERTINTOZK.DISCT_RELATESELECTPLAN_ID,PROM_ID,PROM_ID,2,'客户计划内必选（河南）'FROMDATA.SYX_CUST_PRICING_COMBINE@NTEST_ZTWHEREPLAN_IDIN(虚用户PLAN_ID);INSERTINTOZK.DISCT_OBJECT_RELATESEL
3、ECTDISTINCTPAR_PLAN_ID,PLAN_ID,0,NEW_DETAIL_ID,3,'客户级计划转组合产品套餐（河南）'FROMDATA.SYX_CUST_PRICING_DETAIL@NTEST_ZTWHEREPAR_PLAN_IDIN(虚用户PLAN_ID)ANDNEW_DETAIL_IDISNOTNULL;2、子计划INSERTINTOZK.DISCT_RELATESELECTPLAN_ID,PLAN_ID,PLAN_ID,12,'过渡期商品'FROMDATA.SYX_CUS
4、T_PRICING_DETAIL@NTEST_ZTWHEREPAR_PLAN_IDIN(虚用户PLAN_ID)ANDPLAN_IDIN(SELECTPLAN_IDFROMCP.PM_PLANSWHERE(PLAN_CLASSNOTIN(6,8)ANDPAY_MODE<>5));INSERTINTOZK.DISCT_OBJECT_RELATESELECTDISTINCT0,PLAN_ID,0,PLAN_ID,1,'用户级计划转单产品套餐（河南）'FROMCP.PM_PLANSWHEREPLAN_I
5、DIN(selectplan_idfromDATA.SYX_CUST_PRICING_DETAIL@NTEST_ZTWHEREPAR_PLAN_IDIN(虚用户PLAN_ID)ANDPLAN_IDIN(SELECTPLAN_IDFROMCP.PM_PLANSWHERE(PLAN_CLASSNOTIN(6,8)ANDPAY_MODE<>5)));3、子计划可选促销insertintoZK.DISCT_RELATEselecta.plan_id,a.prom_id,a.prom_id,6,'用户级计
6、划内可选促销（河南）'fromcp.pm_plan_promawhereplan_idin(selectplan_idfromdata.syx_cust_pricing_detail@NTEST_ZTwherepar_plan_idin(虚用户PLAN_ID)andnew_detail_idisnotnull);insertintoZK.DISCT_OBJECT_RELATEselect0,a.plan_id,a.prom_id,a.prom_id,2,'用户级计划下促销转单产品套餐（河南）'f
7、romcp.pm_plan_promawhereplan_idin(selectplan_idfromdata.syx_cust_pricing_detail@NTEST_ZTwherepar_plan_idin(虚用户PLAN_ID)andnew_detail_idisnotnull);4、客户级促销INSERTINTOZK.DISCT_RELATESELECTDISTINCTA.PLAN_ID,B.PROD_ID,B.PROD_ID,3,'客户计划内可选（河南）'FROMCP.PM_PLAN
8、SA,CP.PM_PRODUCTSBWHEREA.PAY_MODE=5ANDPLAN_ID=需用户PLAN_IDANDB.PROD_ID=促销ID;INSERTINTOZK.DISCT_OBJECT_RELATESELECTDISTINCTA.PLAN_ID,0,B.PROD_ID,B.PROD_ID,4,'客户级计划下促销转单产品套餐（河南）'FROMCP.PM_PLANSAWHERECP.PM_PLANSA,CP.PM_PRODUCTSBWHEREA.PAY_MODE=5ANDPLAN_ID
