<?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"),OCM_Sales_Forecast_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>A_rank_PCL_qty__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"),Qty__c*0.8,0)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>A级询价(台数) 换算值</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>2</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Asset_Model_No__c</fullName>
|
<externalId>false</externalId>
|
<formula>Product2__r.Asset_Model_No__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>OCSM内部产品型号(略称)</label>
|
<required>false</required>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>BSSCategory__c</fullName>
|
<externalId>false</externalId>
|
<formula>text( Product2__r.BSSCategory__c)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>BSS分类</label>
|
<required>false</required>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>BSS_Category__c</fullName>
|
<externalId>false</externalId>
|
<label>■BSS分类</label>
|
<required>false</required>
|
<trackTrending>false</trackTrending>
|
<type>Picklist</type>
|
<valueSet>
|
<valueSetDefinition>
|
<sorted>false</sorted>
|
<value>
|
<fullName>G&R</fullName>
|
<default>false</default>
|
<label>G&R</label>
|
</value>
|
<value>
|
<fullName>ET</fullName>
|
<default>false</default>
|
<label>ET</label>
|
</value>
|
<value>
|
<fullName>Surgical</fullName>
|
<default>false</default>
|
<label>Surgical</label>
|
</value>
|
<value>
|
<fullName>Energy</fullName>
|
<default>false</default>
|
<label>Energy</label>
|
</value>
|
<value>
|
<fullName>R&S</fullName>
|
<default>false</default>
|
<label>R&S</label>
|
</value>
|
<value>
|
<fullName>ENG</fullName>
|
<default>false</default>
|
<label>ENG</label>
|
</value>
|
</valueSetDefinition>
|
</valueSet>
|
</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"),OCM_Sales_Forecast_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>B_rank_PCL_qty__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"),Qty__c*0.5,0)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>B级询价(台数) 换算值</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>2</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</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"),OCM_Sales_Forecast_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>C_rank_PCL_qty__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"),Qty__c*0.3,0)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>C级询价(台数) 换算值</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>2</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Category2__c</fullName>
|
<externalId>false</externalId>
|
<formula>Product2__r.Category2__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>第2分类</label>
|
<required>false</required>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Category3__c</fullName>
|
<externalId>false</externalId>
|
<formula>Product2__r.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>Product2__r.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>Product2__r.Category5__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>第5分类</label>
|
<required>false</required>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Category_dept4__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>Category_dept5__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>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>Customer_code__c</fullName>
|
<externalId>false</externalId>
|
<formula>/* 01210000000QemG == 医院的记录类型的Id */
|
IF(Opportunity__r.Account.Parent.Parent.RecordTypeId = "01210000000QemG",
|
Opportunity__r.Account.Management_Code__c,
|
/* 01210000000Qem1 == 经销商的记录类型的Id */
|
IF(Opportunity__r.Account.Parent.RecordTypeId = "01210000000Qem1",
|
Opportunity__r.Account.AgencyContract_Management_Code__c,
|
""
|
))</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>客户编码</label>
|
<required>false</required>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</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>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>ITEM_Code__c</fullName>
|
<description>OT CODE</description>
|
<externalId>false</externalId>
|
<label>■产品编码</label>
|
<length>250</length>
|
<required>false</required>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Important_Key_product_category__c</fullName>
|
<externalId>false</externalId>
|
<formula>text(Opportunity__r.Important_Key_product_category__c)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>重点产品目标区分</label>
|
<required>false</required>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Key_product__c</fullName>
|
<externalId>false</externalId>
|
<formula>Product2__r.Key_product_147P__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>MB重点产品</label>
|
<required>false</required>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>List_price__c</fullName>
|
<description>ListPrice__c</description>
|
<externalId>false</externalId>
|
<label>■List price</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>2</scale>
|
<trackTrending>false</trackTrending>
|
<type>Currency</type>
|
</fields>
|
<fields>
|
<fullName>NumberOfObjective_146P__c</fullName>
|
<externalId>false</externalId>
|
<label>XXX目標数量(不使用)</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>NumberOfObjective__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(IsPickval(Opportunity__r.Target_category__c, '重点产品目标(数量)')
|
, IF(Opportunity__r.Proportion__c > 0, Opportunity__r.Proportion__c * Qty__c, NumberOfObjective_146P__c)
|
, 0
|
)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>目標数量</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>2</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_Sales_Forecast_Without_Tax__c</fullName>
|
<description>Case( Trade__c,
|
"内貿", IF(Opportunity__r.Shipping_Date_For_Report__c < Datevalue("2018-05-01"),OCM_Sales_Forecast__c /1.17,OCM_Sales_Forecast__c /1.16),
|
"外貿",
|
IF(Opportunity__r.Shipping_Date_For_Report__c < Datevalue("2012-10-01") ,
|
OCM_Sales_Forecast__c * 6.6,
|
IF(Opportunity__r.Shipping_Date_For_Report__c < Datevalue("2016-07-01") ,
|
OCM_Sales_Forecast__c * 6.3,
|
IF(Opportunity__r.Shipping_Date_For_Report__c < Datevalue("2016-12-01"),
|
OCM_Sales_Forecast__c * 6.5,
|
IF(Opportunity__r.Shipping_Date_For_Report__c < Datevalue("2018-05-01"),
|
OCM_Sales_Forecast__c * 6.8, OCM_Sales_Forecast__c * 6.3
|
)
|
)
|
)
|
),
|
OCM_Sales_Forecast__c * 1
|
)</description>
|
<externalId>false</externalId>
|
<formula>Case( Trade__c,
|
"内貿",OCM_Sales_Forecast__c / Opportunity__r.Tax_Intra_F_Copy__c ,
|
"外貿", OCM_Sales_Forecast__c * Opportunity__r.Tax_Foreign_F_Copy__c ,
|
OCM_Sales_Forecast__c * 1
|
)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>OCSM预测成交金额(不含税)</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>2</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>OCM_Sales_Forecast__c</fullName>
|
<externalId>false</externalId>
|
<label>OCSM预测成交金额(含税)</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>2</scale>
|
<trackTrending>false</trackTrending>
|
<type>Currency</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>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>OCM_province__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>Objective_146P__c</fullName>
|
<externalId>false</externalId>
|
<label>目標金額</label>
|
<precision>15</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>OpportunityLineItemId__c</fullName>
|
<caseSensitive>false</caseSensitive>
|
<externalId>true</externalId>
|
<label>XXXOpportunityLineItemId</label>
|
<length>18</length>
|
<required>true</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_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_OpportunityLineItem</relationshipName>
|
<required>false</required>
|
<trackTrending>false</trackTrending>
|
<type>Lookup</type>
|
</fields>
|
<fields>
|
<fullName>Owner_ID__c</fullName>
|
<externalId>false</externalId>
|
<formula>Opportunity__r.OwnerId</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>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",
|
IF(month(CloseDate__c) = 5,"PA",
|
IF(month(CloseDate__c) = 6,"PA",
|
IF(month(CloseDate__c) = 7,"PA",
|
IF(month(CloseDate__c) = 8,"PA",
|
IF(month(CloseDate__c) = 9,"PA",
|
IF(month(CloseDate__c) = 10,"PB",
|
IF(month(CloseDate__c) = 11,"PB",
|
IF(month(CloseDate__c) = 12,"PB",
|
IF(month(CloseDate__c) = 1,"PB",
|
IF(month(CloseDate__c) = 2,"PB",
|
IF(month(CloseDate__c) = 3,"PB",
|
"")
|
)
|
)
|
)
|
)
|
)
|
)
|
)
|
)
|
)
|
)
|
)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>XXX不使用PA・PB(目标)</label>
|
<required>false</required>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Product2__c</fullName>
|
<deleteConstraint>SetNull</deleteConstraint>
|
<externalId>false</externalId>
|
<label>■产品</label>
|
<referenceTo>Product2</referenceTo>
|
<relationshipLabel>MB_询价产品</relationshipLabel>
|
<relationshipName>MB_OpportunityLineItem</relationshipName>
|
<required>false</required>
|
<trackTrending>false</trackTrending>
|
<type>Lookup</type>
|
</fields>
|
<fields>
|
<fullName>ProspectCode__c</fullName>
|
<externalId>false</externalId>
|
<formula>Case(Opportunity__r.Purchase_Type__c,
|
"一般引合", "PRO-00010",
|
"ET24時間販売", "PRO-00110",
|
"SI（手術室案件）", "PRO-00210",
|
""
|
)</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>Qty__c</fullName>
|
<externalId>false</externalId>
|
<label>■Qty</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</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_Amount_Total__c</fullName>
|
<externalId>false</externalId>
|
<formula>UnitPrice__c * Qty__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>Sales Amount (*Qty)</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>2</scale>
|
<trackTrending>false</trackTrending>
|
<type>Currency</type>
|
</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_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>Shouquan_PCL_price__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(
|
AND(Opportunity__r.Status_Formula_Text__c="03 已授权",Competitor__c="A"),UnitPrice__c*0.8,
|
|
IF(
|
AND(Opportunity__r.Status_Formula_Text__c="03 已授权",Competitor__c="B"),UnitPrice__c*0.5,
|
IF(Opportunity__r.Status_Formula_Text__c="03 已授权",OCM_Sales_Forecast_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>Shouquan_PCL_qty__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(
|
AND(Opportunity__r.Status_Formula_Text__c="03 已授权",Competitor__c="A"),Qty__c*0.8,
|
|
IF(
|
AND(Opportunity__r.Status_Formula_Text__c="03 已授权",Competitor__c="B"),Qty__c*0.5,
|
IF(Opportunity__r.Status_Formula_Text__c="03 已授权",Qty__c*0.3,0)))</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>已授权询价(台数) 换算值</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>2</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</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>State_Text__c</fullName>
|
<description>Opportunity__r.SaleProvince_SAP__c</description>
|
<externalId>false</externalId>
|
<label>■OCSM省(文本)</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>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>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>UnitPrice__c</fullName>
|
<externalId>false</externalId>
|
<label>■Sales Amount</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>2</scale>
|
<trackTrending>false</trackTrending>
|
<type>Currency</type>
|
</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 已中标"
|
)
|
|
,OCM_Sales_Forecast_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>Zhongbiao_PCL_qty__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 已中标"
|
)
|
|
,Qty__c,0)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>已中标询价(台数) 换算值</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>2</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>category_dept3__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>category_dept6__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>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>
|
<label>MB_询价产品</label>
|
<nameField>
|
<displayFormat>MB-OppL-{0000000000}</displayFormat>
|
<label>MB_询价产品名称</label>
|
<type>AutoNumber</type>
|
</nameField>
|
<searchLayouts/>
|
<sharingModel>Private</sharingModel>
|
<visibility>Public</visibility>
|
</CustomObject>
|
