<?xml version="1.0" encoding="UTF-8"?>
|
<CustomObject xmlns="http://soap.sforce.com/2006/04/metadata">
|
<actionOverrides>
|
<actionName>Accept</actionName>
|
<type>Default</type>
|
</actionOverrides>
|
<actionOverrides>
|
<actionName>CancelEdit</actionName>
|
<type>Default</type>
|
</actionOverrides>
|
<actionOverrides>
|
<actionName>Clone</actionName>
|
<type>Default</type>
|
</actionOverrides>
|
<actionOverrides>
|
<actionName>Delete</actionName>
|
<type>Default</type>
|
</actionOverrides>
|
<actionOverrides>
|
<actionName>Edit</actionName>
|
<type>Default</type>
|
</actionOverrides>
|
<actionOverrides>
|
<actionName>List</actionName>
|
<type>Default</type>
|
</actionOverrides>
|
<actionOverrides>
|
<actionName>New</actionName>
|
<type>Default</type>
|
</actionOverrides>
|
<actionOverrides>
|
<actionName>SaveEdit</actionName>
|
<type>Default</type>
|
</actionOverrides>
|
<actionOverrides>
|
<actionName>Tab</actionName>
|
<type>Default</type>
|
</actionOverrides>
|
<actionOverrides>
|
<actionName>View</actionName>
|
<type>Default</type>
|
</actionOverrides>
|
<allowInChatterGroups>false</allowInChatterGroups>
|
<compactLayoutAssignment>SYSTEM</compactLayoutAssignment>
|
<deploymentStatus>Deployed</deploymentStatus>
|
<enableActivities>false</enableActivities>
|
<enableBulkApi>true</enableBulkApi>
|
<enableChangeDataCapture>false</enableChangeDataCapture>
|
<enableFeeds>false</enableFeeds>
|
<enableHistory>false</enableHistory>
|
<enableReports>true</enableReports>
|
<enableSearch>true</enableSearch>
|
<enableSharing>true</enableSharing>
|
<enableStreamingApi>true</enableStreamingApi>
|
<externalSharingModel>Private</externalSharingModel>
|
<fields>
|
<fullName>A_rank_PCL_price__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(
|
AND(OR(
|
Opportunity__r.Status_Formula_Text__c="02 跟进中",
|
Opportunity__r.Status_Formula_Text__c="01 还没拜访",
|
Opportunity__r.Status_Formula_Text__c="00 还没跟进"),
|
Competitor__c="A"),Amount_Without_Tax__c*0.8,0)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>A级询价(不含税) 换算值</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>2</scale>
|
<trackTrending>false</trackTrending>
|
<type>Currency</type>
|
</fields>
|
<fields>
|
<fullName>After_tender_past_2week__c</fullName>
|
<externalId>false</externalId>
|
<formula>Opportunity__r.After_tender_past_2week__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>已中标状态后超过2周</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Amount_Without_Tax__c</fullName>
|
<externalId>false</externalId>
|
<formula>Opportunity__r.Amount_Without_Tax__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>OCSM预测成交金额(不含税)_元</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>2</scale>
|
<trackTrending>false</trackTrending>
|
<type>Currency</type>
|
</fields>
|
<fields>
|
<fullName>B_rank_PCL_price__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(
|
AND(OR(
|
Opportunity__r.Status_Formula_Text__c="02 跟进中",
|
Opportunity__r.Status_Formula_Text__c="01 还没拜访",
|
Opportunity__r.Status_Formula_Text__c="00 还没跟进"),
|
Competitor__c="B"),Amount_Without_Tax__c*0.5,0)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>B级询价(不含税) 换算值</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>2</scale>
|
<trackTrending>false</trackTrending>
|
<type>Currency</type>
|
</fields>
|
<fields>
|
<fullName>Backup_order_number__c</fullName>
|
<externalId>false</externalId>
|
<formula>Opportunity__r.Backup_order_number__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>备货订单数</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>C_rank_PCL_price__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(
|
AND(OR(
|
Opportunity__r.Status_Formula_Text__c="02 跟进中",
|
Opportunity__r.Status_Formula_Text__c="01 还没拜访",
|
Opportunity__r.Status_Formula_Text__c="00 还没跟进"),
|
Competitor__c="C"),Amount_Without_Tax__c*0.3,0)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>C级询价(不含税) 换算值</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>2</scale>
|
<trackTrending>false</trackTrending>
|
<type>Currency</type>
|
</fields>
|
<fields>
|
<fullName>Category3__c</fullName>
|
<externalId>false</externalId>
|
<formula>Owner:User.Category3__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>第3层区分</label>
|
<required>false</required>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Category4__c</fullName>
|
<externalId>false</externalId>
|
<formula>Opportunity__r.Owner.Category4__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>第4层区分</label>
|
<required>false</required>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Category5__c</fullName>
|
<externalId>false</externalId>
|
<formula>Opportunity__r.Owner.Category5__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>销售部</label>
|
<required>false</required>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Category6__c</fullName>
|
<externalId>false</externalId>
|
<formula>Opportunity__r.Owner.Category6__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>销售课</label>
|
<required>false</required>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>CloseDate__c</fullName>
|
<externalId>false</externalId>
|
<formula>Opportunity__r.CloseDate</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>预测发货日(结束日)</label>
|
<required>false</required>
|
<trackTrending>false</trackTrending>
|
<type>Date</type>
|
</fields>
|
<fields>
|
<fullName>Close_Forecasted_Date__c</fullName>
|
<externalId>false</externalId>
|
<formula>Opportunity__r.Close_Forecasted_Date__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>XXX预测OCSM签约日</label>
|
<required>false</required>
|
<trackTrending>false</trackTrending>
|
<type>Date</type>
|
</fields>
|
<fields>
|
<fullName>Competitor__c</fullName>
|
<externalId>false</externalId>
|
<formula>text( Opportunity__r.Competitor__c)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>询价等级</label>
|
<required>false</required>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Contract_recognized_day_1__c</fullName>
|
<externalId>false</externalId>
|
<formula>Opportunity__r.Contract_recognized_day_1__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>初审日期(订货日)</label>
|
<required>false</required>
|
<trackTrending>false</trackTrending>
|
<type>Date</type>
|
</fields>
|
<fields>
|
<fullName>Created_day__c</fullName>
|
<externalId>false</externalId>
|
<formula>Opportunity__r.CreatedDate</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>询价创建日</label>
|
<required>false</required>
|
<trackTrending>false</trackTrending>
|
<type>Date</type>
|
</fields>
|
<fields>
|
<fullName>Distributor_InCharge_opp__c</fullName>
|
<defaultValue>false</defaultValue>
|
<externalId>false</externalId>
|
<label>■■经销商管理课负责的询价</label>
|
<trackTrending>false</trackTrending>
|
<type>Checkbox</type>
|
</fields>
|
<fields>
|
<fullName>Distributor_InCharge_opp_formula__c</fullName>
|
<externalId>false</externalId>
|
<formula>Opportunity__r.Distributor_InCharge_opp__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>XXX经销商管理科负责询价</label>
|
<trackTrending>false</trackTrending>
|
<type>Checkbox</type>
|
</fields>
|
<fields>
|
<fullName>Elapsed_day_after_authorized_cate__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(Elapsed_day_after_authorized_doc__c <= 30,"30天以内",
|
IF(Elapsed_day_after_authorized_doc__c <= 60,"60天以内",
|
IF(Elapsed_day_after_authorized_doc__c <= 90,"90天以内","90天以上")))</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>XXX授权后经过天数区分</label>
|
<required>false</required>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Elapsed_day_after_authorized_doc__c</fullName>
|
<externalId>false</externalId>
|
<formula>Opportunity__r.Elapsed_day_after_authorized_doc__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>XXX授权后经过天数</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Elapsed_day_after_tender__c</fullName>
|
<externalId>false</externalId>
|
<formula>Opportunity__r.Elapsed_day_after_tender__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>中标后各个状态留在天数</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Elapsed_day_each_status__c</fullName>
|
<description>2018/6025 修改前(CHAN-AZQDEQ)：
|
Opportunity__r.Elapsed_day_each_status__c</description>
|
<externalId>false</externalId>
|
<formula>Opportunity__r.Status_Formula_Retention_Days__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>XXX各个状态进过天数（询价）</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Feedback__c</fullName>
|
<externalId>false</externalId>
|
<formula>Opportunity__r.Manager_feedback__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>经理反馈</label>
|
<required>false</required>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Follow_or_not__c</fullName>
|
<externalId>false</externalId>
|
<formula>Opportunity__r.Follow_or_not__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>是否已跟进</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Follow_up_comment__c</fullName>
|
<externalId>false</externalId>
|
<formula>Opportunity__r.Follow_up_comment__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>询价跟进情况</label>
|
<required>false</required>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Forecast_shipping_day__c</fullName>
|
<externalId>false</externalId>
|
<formula>Opportunity__r.Forecast_shipping_day__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>预测发货日</label>
|
<required>false</required>
|
<trackTrending>false</trackTrending>
|
<type>Date</type>
|
</fields>
|
<fields>
|
<fullName>Forecast_this_month__c</fullName>
|
<externalId>false</externalId>
|
<formula>text(Opportunity__r.Forecast_this_month__c)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>是否本月预测</label>
|
<required>false</required>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Group_purchase_PCL__c</fullName>
|
<defaultValue>false</defaultValue>
|
<externalId>false</externalId>
|
<label>■■集中采购课负责的询价</label>
|
<trackTrending>false</trackTrending>
|
<type>Checkbox</type>
|
</fields>
|
<fields>
|
<fullName>Group_purchase_PCL_formula__c</fullName>
|
<externalId>false</externalId>
|
<formula>Opportunity__r.Group_purchase_PCL__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>XXX集中采购课负责的询价</label>
|
<trackTrending>false</trackTrending>
|
<type>Checkbox</type>
|
</fields>
|
<fields>
|
<fullName>Hospital_ID__c</fullName>
|
<externalId>false</externalId>
|
<formula>Opportunity__r.Hospital__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>XXX医院ID</label>
|
<required>false</required>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Hospital__c</fullName>
|
<externalId>false</externalId>
|
<formula>Opportunity__r.HP_Name__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>XXX医院</label>
|
<required>false</required>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Job_category__c</fullName>
|
<externalId>false</externalId>
|
<formula>Opportunity__r.Job_category__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>XXX职种</label>
|
<required>false</required>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>LTV_Account__c</fullName>
|
<externalId>false</externalId>
|
<formula>Opportunity__r.LTV_Account__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>XXX1.LTV用户目标(含税)</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>2</scale>
|
<trackTrending>false</trackTrending>
|
<type>Currency</type>
|
</fields>
|
<fields>
|
<fullName>LTV_Account_tax__c</fullName>
|
<externalId>false</externalId>
|
<formula>Opportunity__r.LTV_Account_tax__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>XXX1.LTV用户目标(不含税)</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>2</scale>
|
<trackTrending>false</trackTrending>
|
<type>Currency</type>
|
</fields>
|
<fields>
|
<fullName>Last_Follow_Up_Date__c</fullName>
|
<externalId>false</externalId>
|
<formula>Opportunity__r.Last_Follow_Up_Date__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>最后跟进日</label>
|
<required>false</required>
|
<trackTrending>false</trackTrending>
|
<type>Date</type>
|
</fields>
|
<fields>
|
<fullName>Lost_Opportunity_Date__c</fullName>
|
<externalId>false</externalId>
|
<formula>Opportunity__r.Lost_Opportunity_Date__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>取消/失单日</label>
|
<required>false</required>
|
<trackTrending>false</trackTrending>
|
<type>Date</type>
|
</fields>
|
<fields>
|
<fullName>Num_Of_OPD__c</fullName>
|
<externalId>false</externalId>
|
<formula>Opportunity__r.Num_Of_OPD__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>XXXOPD活动次数</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Number_of_PCL__c</fullName>
|
<externalId>false</externalId>
|
<formula>1</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>询价数量</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>OCM_IsSame__c</fullName>
|
<externalId>false</externalId>
|
<formula>Opp_OCM_text__c == Opportunity__r.OCM__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>OCSM分类_IsSame</label>
|
<trackTrending>false</trackTrending>
|
<type>Checkbox</type>
|
</fields>
|
<fields>
|
<fullName>OCM_Target_period__c</fullName>
|
<externalId>false</externalId>
|
<formula>Opportunity__r.OCM_Target_period__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>目标OCSM期</label>
|
<required>false</required>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>OCM_category__c</fullName>
|
<externalId>false</externalId>
|
<formula>Opportunity__r.OCM__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>OCSM分类</label>
|
<required>false</required>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>OCM_cateogry_formula__c</fullName>
|
<externalId>false</externalId>
|
<formula>Opportunity__r.OCM__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>XXXOCSM分类</label>
|
<required>false</required>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>OCM_department_seg__c</fullName>
|
<externalId>false</externalId>
|
<formula>Opportunity__r.OCM_department_seg__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>OCSM科室等级</label>
|
<required>false</required>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>OPD__c</fullName>
|
<externalId>false</externalId>
|
<formula>Opportunity__r.DoOPD__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>是否做OPD</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Objective_Tax__c</fullName>
|
<externalId>false</externalId>
|
<formula>Opportunity__r.Objective_Tax__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>目標</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>2</scale>
|
<trackTrending>false</trackTrending>
|
<type>Currency</type>
|
</fields>
|
<fields>
|
<fullName>Objective__c</fullName>
|
<externalId>false</externalId>
|
<formula>Opportunity__r.Objective__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>XXX1.目標(含税)</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>2</scale>
|
<trackTrending>false</trackTrending>
|
<type>Currency</type>
|
</fields>
|
<fields>
|
<fullName>Opp_OCM_text__c</fullName>
|
<externalId>false</externalId>
|
<label>■■OCSM分类(文本)</label>
|
<length>250</length>
|
<required>false</required>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>OpportunityId__c</fullName>
|
<caseSensitive>false</caseSensitive>
|
<externalId>true</externalId>
|
<label>OpportunityId</label>
|
<length>18</length>
|
<required>false</required>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>true</unique>
|
</fields>
|
<fields>
|
<fullName>Opportunity_Category__c</fullName>
|
<externalId>false</externalId>
|
<formula>Text(Opportunity__r.Opportunity_Category__c)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>科室分类</label>
|
<required>false</required>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Opportunity_Category_text__c</fullName>
|
<externalId>false</externalId>
|
<label>■■询价科室分类(文本)</label>
|
<length>250</length>
|
<required>false</required>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Opportunity_ID__c</fullName>
|
<externalId>false</externalId>
|
<formula>Opportunity__r.Id</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>询价ID</label>
|
<required>false</required>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Opportunity_No__c</fullName>
|
<externalId>false</externalId>
|
<formula>Opportunity__r.Opportunity_No__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>询价编码</label>
|
<required>false</required>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Opportunity__c</fullName>
|
<deleteConstraint>SetNull</deleteConstraint>
|
<externalId>false</externalId>
|
<label>询价</label>
|
<referenceTo>Opportunity</referenceTo>
|
<relationshipLabel>MB_询价</relationshipLabel>
|
<relationshipName>MB_Opportunity</relationshipName>
|
<required>false</required>
|
<trackTrending>false</trackTrending>
|
<type>Lookup</type>
|
</fields>
|
<fields>
|
<fullName>Opportunity_possibility__c</fullName>
|
<externalId>false</externalId>
|
<formula>Opportunity__r.Opportunity_possibility__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>询价等级可能性</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Owner_ID__c</fullName>
|
<externalId>false</externalId>
|
<formula>CASESAFEID(Opportunity__r.Owner.Id)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>所有人ID</label>
|
<required>false</required>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Owner__c</fullName>
|
<externalId>false</externalId>
|
<formula>Opportunity__r.Owner.Alias</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>所有人</label>
|
<required>false</required>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Owner_fullname__c</fullName>
|
<externalId>false</externalId>
|
<formula>Opportunity__r.Owner.Name__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>所有者</label>
|
<required>false</required>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>PA_PB__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF( Opportunity__r.RecordTypeId ="01210000000QekK",
|
|
IF(month(Forecast_shipping_day__c) = 4,"PA:4月(1Q)",
|
IF(month(Forecast_shipping_day__c) = 5,"PA:5月(1Q)",
|
IF(month(Forecast_shipping_day__c) = 6,"PA:6月(1Q)",
|
IF(month(Forecast_shipping_day__c) = 7,"PA:7月(2Q)",
|
IF(month(Forecast_shipping_day__c) = 8,"PA:8月(2Q)",
|
IF(month(Forecast_shipping_day__c) = 9,"PA:9月(2Q)",
|
IF(month(Forecast_shipping_day__c) = 10,"PB:10月(3Q)",
|
IF(month(Forecast_shipping_day__c) = 11,"PB:11月(3Q)",
|
IF(month(Forecast_shipping_day__c) = 12,"PB:12月(3Q)",
|
IF(month(Forecast_shipping_day__c) = 1,"PB:01月(4Q)",
|
IF(month(Forecast_shipping_day__c) = 2,"PB:02月(4Q)",
|
IF(month(Forecast_shipping_day__c) = 3,"PB:03月(4Q)",
|
"")
|
)
|
)
|
)
|
)
|
)
|
)
|
)
|
)
|
)
|
)
|
),
|
|
IF(month(CloseDate__c) = 4,"PA:4月(1Q)",
|
IF(month(CloseDate__c) = 5,"PA:5月(1Q)",
|
IF(month(CloseDate__c) = 6,"PA:6月(1Q)",
|
IF(month(CloseDate__c) = 7,"PA:7月(2Q)",
|
IF(month(CloseDate__c) = 8,"PA:8月(2Q)",
|
IF(month(CloseDate__c) = 9,"PA:9月(2Q)",
|
IF(month(CloseDate__c) = 10,"PB:10月(3Q)",
|
IF(month(CloseDate__c) = 11,"PB:11月(3Q)",
|
IF(month(CloseDate__c) = 12,"PB:12月(3Q)",
|
IF(month(CloseDate__c) = 1,"PB:01月(4Q)",
|
IF(month(CloseDate__c) = 2,"PB:02月(4Q)",
|
IF(month(CloseDate__c) = 3,"PB:03月(4Q)",
|
"")
|
)
|
)
|
)
|
)
|
)
|
)
|
)
|
)
|
)
|
)
|
))</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>PA・PB</label>
|
<required>false</required>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>PA_PB_target__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(month(CloseDate__c) = 4,"PA:4月(1Q)",
|
IF(month(CloseDate__c) = 5,"PA:5月(1Q)",
|
IF(month(CloseDate__c) = 6,"PA:6月(1Q)",
|
IF(month(CloseDate__c) = 7,"PA:7月(2Q)",
|
IF(month(CloseDate__c) = 8,"PA:8月(2Q)",
|
IF(month(CloseDate__c) = 9,"PA:9月(2Q)",
|
IF(month(CloseDate__c) = 10,"PB:10月(3Q)",
|
IF(month(CloseDate__c) = 11,"PB:11月(3Q)",
|
IF(month(CloseDate__c) = 12,"PB:12月(3Q)",
|
IF(month(CloseDate__c) = 1,"PB:1月(4Q)",
|
IF(month(CloseDate__c) = 2,"PB:2月(4Q)",
|
IF(month(CloseDate__c) = 3,"PB:3月(4Q)",
|
"")
|
)
|
)
|
)
|
)
|
)
|
)
|
)
|
)
|
)
|
)
|
)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>XXX不使用：PA・PB(目标)</label>
|
<required>false</required>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Past_authorization_valide_day__c</fullName>
|
<externalId>false</externalId>
|
<formula>Opportunity__r.Past_authorization_valide_day__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>已超过授权截至日的询价数</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Post__c</fullName>
|
<externalId>false</externalId>
|
<formula>Opportunity__r.Post__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>XXX职位</label>
|
<required>false</required>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Product_category__c</fullName>
|
<externalId>false</externalId>
|
<formula>Case(Opportunity_Category__c,
|
"GI","GI",
|
"ET","ET",
|
"BF","BF",
|
"GS","SP",
|
"URO","SP",
|
"GYN","SP",
|
"ENT","SP",
|
"OTH","SP","")</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>产品分类</label>
|
<required>false</required>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Prospect_name__c</fullName>
|
<externalId>false</externalId>
|
<formula>Opportunity__r.Name</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>询价名</label>
|
<required>false</required>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Province_BA__c</fullName>
|
<externalId>false</externalId>
|
<formula>Opportunity__r.Province_BA__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>省</label>
|
<required>false</required>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Province_formula__c</fullName>
|
<externalId>false</externalId>
|
<formula>Opportunity__r.State__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>XXX省</label>
|
<required>false</required>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>RecordType_Name__c</fullName>
|
<externalId>false</externalId>
|
<label>■■记录类型</label>
|
<length>250</length>
|
<required>false</required>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>RecordType__c</fullName>
|
<externalId>false</externalId>
|
<formula>Opportunity__r.RecordType.Name</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>XXX记录类型</label>
|
<required>false</required>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>SaleProvince_SAP__c</fullName>
|
<externalId>false</externalId>
|
<formula>Opportunity__r.SaleProvince_SAP__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>XXX省（SAP业绩）</label>
|
<required>false</required>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Sales_Speciality__c</fullName>
|
<externalId>false</externalId>
|
<formula>Opportunity__r.Sales_Speciality__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>销售工作内容</label>
|
<required>false</required>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Sales_forecast_YM_BA__c</fullName>
|
<externalId>false</externalId>
|
<formula>SUBSTITUTE(Mid(Text(Opportunity__r.Sales_forecast_day_BA__c), 3, 5), "-", "年") + "月"</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>预测OCSM签约年月</label>
|
<required>false</required>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Sales_forecast_day_BA__c</fullName>
|
<externalId>false</externalId>
|
<formula>Opportunity__r.Sales_forecast_day_BA__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>预测OCSM签约日</label>
|
<required>false</required>
|
<trackTrending>false</trackTrending>
|
<type>Date</type>
|
</fields>
|
<fields>
|
<fullName>Salesdepartment_SAP__c</fullName>
|
<externalId>false</externalId>
|
<formula>Opportunity__r.Salesdepartment_SAP__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>销售本部</label>
|
<required>false</required>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Shipping_Date_For_Report__c</fullName>
|
<externalId>false</externalId>
|
<formula>Opportunity__r.Shipping_Date_For_Report__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>日期(业绩统计用)★</label>
|
<required>false</required>
|
<trackTrending>false</trackTrending>
|
<type>Date</type>
|
</fields>
|
<fields>
|
<fullName>Shouquan_PCL_price__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(
|
AND(Opportunity__r.Status_Formula_Text__c="03 已授权",Competitor__c="A"),Amount_Without_Tax__c*0.8,
|
|
IF(
|
AND(Opportunity__r.Status_Formula_Text__c="03 已授权",Competitor__c="B"),Amount_Without_Tax__c*0.5,
|
IF(Opportunity__r.Status_Formula_Text__c="03 已授权",Amount_Without_Tax__c*0.3,0)))</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>已授权询价(不含税) 换算值</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>2</scale>
|
<trackTrending>false</trackTrending>
|
<type>Currency</type>
|
</fields>
|
<fields>
|
<fullName>StageName__c</fullName>
|
<externalId>false</externalId>
|
<formula>text(Opportunity__r.StageName)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>状态1</label>
|
<required>false</required>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>StageName_formula__c</fullName>
|
<externalId>false</externalId>
|
<formula>Opportunity__r.StageName__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>XXX状态1(公式)</label>
|
<required>false</required>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Stage_name_chinese__c</fullName>
|
<externalId>false</externalId>
|
<formula>case(StageName__c,
|
"引合","询价",
|
"完了","完毕",
|
"削除","取消",
|
"敗戦","失单",
|
"目標","目标",
|
"出荷","发货",
|
"注残","注残","")</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>状态1(中文)</label>
|
<required>false</required>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Stage_prospect__c</fullName>
|
<externalId>false</externalId>
|
<formula>Opportunity__r.Stage_prospect__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>Stage</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>State_Text__c</fullName>
|
<description>Opportunity__r.SaleProvince_SAP__c</description>
|
<externalId>false</externalId>
|
<label>■■省(文本)</label>
|
<length>250</length>
|
<required>false</required>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Status_Formula__c</fullName>
|
<externalId>false</externalId>
|
<formula>Opportunity__r.Status_Formula__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>状态2</label>
|
<required>false</required>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Strategic_Department_Class_Id__c</fullName>
|
<externalId>false</externalId>
|
<formula>Opportunity__r.Strategic_Department_Class_Id__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>XXX战略科室分类ID</label>
|
<required>false</required>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Target_category__c</fullName>
|
<externalId>false</externalId>
|
<formula>text( Opportunity__r.Target_category__c)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>目标区分</label>
|
<required>false</required>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Team__c</fullName>
|
<externalId>false</externalId>
|
<formula>Opportunity__r.Owner.Group__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>组</label>
|
<required>false</required>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Test_staff__c</fullName>
|
<externalId>false</externalId>
|
<formula>Opportunity__r.Test_staff__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>XXX开发/测试员工</label>
|
<trackTrending>false</trackTrending>
|
<type>Checkbox</type>
|
</fields>
|
<fields>
|
<fullName>Trade__c</fullName>
|
<externalId>false</externalId>
|
<formula>text(Opportunity__r.Trade__c)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>XXX内貿/外貿</label>
|
<required>false</required>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Visit_Head_Doctor_Flag__c</fullName>
|
<externalId>false</externalId>
|
<formula>Opportunity__r.Visit_Head_Doctor_Flag__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>是否已拜访了主任</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Wholesale_Price__c</fullName>
|
<externalId>false</externalId>
|
<formula>Opportunity__r.Wholesale_Price__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>XXXOCSM预测成交金额(含税)_元</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>2</scale>
|
<trackTrending>false</trackTrending>
|
<type>Currency</type>
|
</fields>
|
<fields>
|
<fullName>Xin_Gross_Follow_Num__c</fullName>
|
<externalId>false</externalId>
|
<formula>Opportunity__r.Xin_Gross_Follow_Num__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>XXX跟进次数</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Zhongbiao_PCL_price__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(
|
OR(
|
Opportunity__r.Status_Formula_Text__c="08 已签约",
|
Opportunity__r.Status_Formula_Text__c="07 用户已签约",
|
Opportunity__r.Status_Formula_Text__c="06 用户未签约",
|
Opportunity__r.Status_Formula_Text__c="05 价格申请中",
|
Opportunity__r.Status_Formula_Text__c="04 已中标"
|
)
|
|
,Amount_Without_Tax__c,0)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>已中标询价(不含税) 换算值</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>2</scale>
|
<trackTrending>false</trackTrending>
|
<type>Currency</type>
|
</fields>
|
<fields>
|
<fullName>folow_up_activity_category__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(Num_Of_OPD__c >= 1,"已做OPD",
|
IF(Xin_Gross_Follow_Num__c >= 1,"已拜访","还没拜访"))</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>XXX跟进活动区分</label>
|
<required>false</required>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>order_Date_For_Report__c</fullName>
|
<externalId>false</externalId>
|
<formula>Opportunity__r.order_Date_For_Report__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>日期(预测统计用)★</label>
|
<required>false</required>
|
<trackTrending>false</trackTrending>
|
<type>Date</type>
|
</fields>
|
<label>MB_询价</label>
|
<nameField>
|
<displayFormat>MB-{0000000}</displayFormat>
|
<label>MB询价编码</label>
|
<type>AutoNumber</type>
|
</nameField>
|
<searchLayouts/>
|
<sharingModel>Private</sharingModel>
|
<visibility>Public</visibility>
|
</CustomObject>
|
