<?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>ControlledByParent</externalSharingModel>
|
<fieldSets>
|
<fullName>Weekly_01210000000QemL</fullName>
|
<description>AccountPCLController，消化科</description>
|
<displayedFields>
|
<field>Submit_Customer_target_new__c</field>
|
<isFieldManaged>false</isFieldManaged>
|
<isRequired>false</isRequired>
|
</displayedFields>
|
<displayedFields>
|
<field>Department_Budget_Sum_Price__c</field>
|
<isFieldManaged>false</isFieldManaged>
|
<isRequired>false</isRequired>
|
</displayedFields>
|
<displayedFields>
|
<field>Target_amount_CV290__c</field>
|
<isFieldManaged>false</isFieldManaged>
|
<isRequired>false</isRequired>
|
</displayedFields>
|
<displayedFields>
|
<field>OPD_CV290__c</field>
|
<isFieldManaged>false</isFieldManaged>
|
<isRequired>false</isRequired>
|
</displayedFields>
|
<displayedFields>
|
<field>Target_amount_EUME2__c</field>
|
<isFieldManaged>false</isFieldManaged>
|
<isRequired>false</isRequired>
|
</displayedFields>
|
<displayedFields>
|
<field>OPD_EUME2__c</field>
|
<isFieldManaged>false</isFieldManaged>
|
<isRequired>false</isRequired>
|
</displayedFields>
|
<displayedFields>
|
<field>Target_amount_OERAW__c</field>
|
<isFieldManaged>false</isFieldManaged>
|
<isRequired>false</isRequired>
|
</displayedFields>
|
<displayedFields>
|
<field>OPD_OERAW__c</field>
|
<isFieldManaged>false</isFieldManaged>
|
<isRequired>false</isRequired>
|
</displayedFields>
|
<displayedFields>
|
<field>Target_amount_170_190__c</field>
|
<isFieldManaged>false</isFieldManaged>
|
<isRequired>false</isRequired>
|
</displayedFields>
|
<displayedFields>
|
<field>OPD_170_190__c</field>
|
<isFieldManaged>false</isFieldManaged>
|
<isRequired>false</isRequired>
|
</displayedFields>
|
<label>消化科 周会-右边</label>
|
</fieldSets>
|
<fieldSets>
|
<fullName>Weekly_01210000000QezZ</fullName>
|
<description>AccountPCLController，呼吸科</description>
|
<displayedFields>
|
<field>Submit_Customer_target_new__c</field>
|
<isFieldManaged>false</isFieldManaged>
|
<isRequired>false</isRequired>
|
</displayedFields>
|
<displayedFields>
|
<field>Department_Budget_Sum_Price__c</field>
|
<isFieldManaged>false</isFieldManaged>
|
<isRequired>false</isRequired>
|
</displayedFields>
|
<displayedFields>
|
<field>Target_amount_CV290__c</field>
|
<isFieldManaged>false</isFieldManaged>
|
<isRequired>false</isRequired>
|
</displayedFields>
|
<displayedFields>
|
<field>OPD_CV290__c</field>
|
<isFieldManaged>false</isFieldManaged>
|
<isRequired>false</isRequired>
|
</displayedFields>
|
<displayedFields>
|
<field>Target_amount_EUME2__c</field>
|
<isFieldManaged>false</isFieldManaged>
|
<isRequired>false</isRequired>
|
</displayedFields>
|
<displayedFields>
|
<field>OPD_EUME2__c</field>
|
<isFieldManaged>false</isFieldManaged>
|
<isRequired>false</isRequired>
|
</displayedFields>
|
<displayedFields>
|
<field>Target_amount_OERAW__c</field>
|
<isFieldManaged>false</isFieldManaged>
|
<isRequired>false</isRequired>
|
</displayedFields>
|
<displayedFields>
|
<field>OPD_OERAW__c</field>
|
<isFieldManaged>false</isFieldManaged>
|
<isRequired>false</isRequired>
|
</displayedFields>
|
<displayedFields>
|
<field>Target_amount_170_190__c</field>
|
<isFieldManaged>false</isFieldManaged>
|
<isRequired>false</isRequired>
|
</displayedFields>
|
<displayedFields>
|
<field>OPD_170_190__c</field>
|
<isFieldManaged>false</isFieldManaged>
|
<isRequired>false</isRequired>
|
</displayedFields>
|
<label>呼吸科 周会-右边</label>
|
</fieldSets>
|
<fieldSets>
|
<fullName>Weekly_01210000000Qeze</fullName>
|
<description>AccountPCLController，普外科</description>
|
<displayedFields>
|
<field>Submit_Customer_target_new__c</field>
|
<isFieldManaged>false</isFieldManaged>
|
<isRequired>false</isRequired>
|
</displayedFields>
|
<displayedFields>
|
<field>Department_Budget_Sum_Price__c</field>
|
<isFieldManaged>false</isFieldManaged>
|
<isRequired>false</isRequired>
|
</displayedFields>
|
<displayedFields>
|
<field>Target_amount_OTVS400__c</field>
|
<isFieldManaged>false</isFieldManaged>
|
<isRequired>false</isRequired>
|
</displayedFields>
|
<displayedFields>
|
<field>OPD_OTVS400__c</field>
|
<isFieldManaged>false</isFieldManaged>
|
<isRequired>false</isRequired>
|
</displayedFields>
|
<displayedFields>
|
<field>Target_amount_3D__c</field>
|
<isFieldManaged>false</isFieldManaged>
|
<isRequired>false</isRequired>
|
</displayedFields>
|
<displayedFields>
|
<field>OPD_3D__c</field>
|
<isFieldManaged>false</isFieldManaged>
|
<isRequired>false</isRequired>
|
</displayedFields>
|
<displayedFields>
|
<field>Target_amount_USG400__c</field>
|
<isFieldManaged>false</isFieldManaged>
|
<isRequired>false</isRequired>
|
</displayedFields>
|
<displayedFields>
|
<field>OPD_USG400__c</field>
|
<isFieldManaged>false</isFieldManaged>
|
<isRequired>false</isRequired>
|
</displayedFields>
|
<displayedFields>
|
<field>Target_amount_CYF__c</field>
|
<isFieldManaged>false</isFieldManaged>
|
<isRequired>false</isRequired>
|
</displayedFields>
|
<displayedFields>
|
<field>OPD_CYF__c</field>
|
<isFieldManaged>false</isFieldManaged>
|
<isRequired>false</isRequired>
|
</displayedFields>
|
<displayedFields>
|
<field>Target_amount_170_190__c</field>
|
<isFieldManaged>false</isFieldManaged>
|
<isRequired>false</isRequired>
|
</displayedFields>
|
<displayedFields>
|
<field>OPD_170_190__c</field>
|
<isFieldManaged>false</isFieldManaged>
|
<isRequired>false</isRequired>
|
</displayedFields>
|
<label>普外科 周会-右边</label>
|
</fieldSets>
|
<fieldSets>
|
<fullName>Weekly_01210000000Qezj</fullName>
|
<description>AccountPCLController，泌尿科</description>
|
<displayedFields>
|
<field>Submit_Customer_target_new__c</field>
|
<isFieldManaged>false</isFieldManaged>
|
<isRequired>false</isRequired>
|
</displayedFields>
|
<displayedFields>
|
<field>Department_Budget_Sum_Price__c</field>
|
<isFieldManaged>false</isFieldManaged>
|
<isRequired>false</isRequired>
|
</displayedFields>
|
<displayedFields>
|
<field>Target_amount_OTVS400__c</field>
|
<isFieldManaged>false</isFieldManaged>
|
<isRequired>false</isRequired>
|
</displayedFields>
|
<displayedFields>
|
<field>OPD_OTVS400__c</field>
|
<isFieldManaged>false</isFieldManaged>
|
<isRequired>false</isRequired>
|
</displayedFields>
|
<displayedFields>
|
<field>Target_amount_3D__c</field>
|
<isFieldManaged>false</isFieldManaged>
|
<isRequired>false</isRequired>
|
</displayedFields>
|
<displayedFields>
|
<field>OPD_3D__c</field>
|
<isFieldManaged>false</isFieldManaged>
|
<isRequired>false</isRequired>
|
</displayedFields>
|
<displayedFields>
|
<field>Target_amount_USG400__c</field>
|
<isFieldManaged>false</isFieldManaged>
|
<isRequired>false</isRequired>
|
</displayedFields>
|
<displayedFields>
|
<field>OPD_USG400__c</field>
|
<isFieldManaged>false</isFieldManaged>
|
<isRequired>false</isRequired>
|
</displayedFields>
|
<displayedFields>
|
<field>Target_amount_CYF__c</field>
|
<isFieldManaged>false</isFieldManaged>
|
<isRequired>false</isRequired>
|
</displayedFields>
|
<displayedFields>
|
<field>OPD_CYF__c</field>
|
<isFieldManaged>false</isFieldManaged>
|
<isRequired>false</isRequired>
|
</displayedFields>
|
<displayedFields>
|
<field>Target_amount_170_190__c</field>
|
<isFieldManaged>false</isFieldManaged>
|
<isRequired>false</isRequired>
|
</displayedFields>
|
<displayedFields>
|
<field>OPD_170_190__c</field>
|
<isFieldManaged>false</isFieldManaged>
|
<isRequired>false</isRequired>
|
</displayedFields>
|
<label>泌尿科 周会-右边</label>
|
</fieldSets>
|
<fieldSets>
|
<fullName>Weekly_01210000000Qezo</fullName>
|
<description>AccountPCLController，妇科</description>
|
<displayedFields>
|
<field>Submit_Customer_target_new__c</field>
|
<isFieldManaged>false</isFieldManaged>
|
<isRequired>false</isRequired>
|
</displayedFields>
|
<displayedFields>
|
<field>Department_Budget_Sum_Price__c</field>
|
<isFieldManaged>false</isFieldManaged>
|
<isRequired>false</isRequired>
|
</displayedFields>
|
<displayedFields>
|
<field>Target_amount_OTVS400__c</field>
|
<isFieldManaged>false</isFieldManaged>
|
<isRequired>false</isRequired>
|
</displayedFields>
|
<displayedFields>
|
<field>OPD_OTVS400__c</field>
|
<isFieldManaged>false</isFieldManaged>
|
<isRequired>false</isRequired>
|
</displayedFields>
|
<displayedFields>
|
<field>Target_amount_3D__c</field>
|
<isFieldManaged>false</isFieldManaged>
|
<isRequired>false</isRequired>
|
</displayedFields>
|
<displayedFields>
|
<field>OPD_3D__c</field>
|
<isFieldManaged>false</isFieldManaged>
|
<isRequired>false</isRequired>
|
</displayedFields>
|
<displayedFields>
|
<field>Target_amount_USG400__c</field>
|
<isFieldManaged>false</isFieldManaged>
|
<isRequired>false</isRequired>
|
</displayedFields>
|
<displayedFields>
|
<field>OPD_USG400__c</field>
|
<isFieldManaged>false</isFieldManaged>
|
<isRequired>false</isRequired>
|
</displayedFields>
|
<displayedFields>
|
<field>Target_amount_CYF__c</field>
|
<isFieldManaged>false</isFieldManaged>
|
<isRequired>false</isRequired>
|
</displayedFields>
|
<displayedFields>
|
<field>OPD_CYF__c</field>
|
<isFieldManaged>false</isFieldManaged>
|
<isRequired>false</isRequired>
|
</displayedFields>
|
<displayedFields>
|
<field>Target_amount_170_190__c</field>
|
<isFieldManaged>false</isFieldManaged>
|
<isRequired>false</isRequired>
|
</displayedFields>
|
<displayedFields>
|
<field>OPD_170_190__c</field>
|
<isFieldManaged>false</isFieldManaged>
|
<isRequired>false</isRequired>
|
</displayedFields>
|
<label>妇科 周会-右边</label>
|
</fieldSets>
|
<fieldSets>
|
<fullName>Weekly_01210000000Qezt</fullName>
|
<description>AccountPCLController，耳鼻喉科</description>
|
<displayedFields>
|
<field>Submit_Customer_target_new__c</field>
|
<isFieldManaged>false</isFieldManaged>
|
<isRequired>false</isRequired>
|
</displayedFields>
|
<displayedFields>
|
<field>Department_Budget_Sum_Price__c</field>
|
<isFieldManaged>false</isFieldManaged>
|
<isRequired>false</isRequired>
|
</displayedFields>
|
<displayedFields>
|
<field>Target_amount_OTVS400__c</field>
|
<isFieldManaged>false</isFieldManaged>
|
<isRequired>false</isRequired>
|
</displayedFields>
|
<displayedFields>
|
<field>OPD_OTVS400__c</field>
|
<isFieldManaged>false</isFieldManaged>
|
<isRequired>false</isRequired>
|
</displayedFields>
|
<displayedFields>
|
<field>Target_amount_3D__c</field>
|
<isFieldManaged>false</isFieldManaged>
|
<isRequired>false</isRequired>
|
</displayedFields>
|
<displayedFields>
|
<field>OPD_3D__c</field>
|
<isFieldManaged>false</isFieldManaged>
|
<isRequired>false</isRequired>
|
</displayedFields>
|
<displayedFields>
|
<field>Target_amount_USG400__c</field>
|
<isFieldManaged>false</isFieldManaged>
|
<isRequired>false</isRequired>
|
</displayedFields>
|
<displayedFields>
|
<field>OPD_USG400__c</field>
|
<isFieldManaged>false</isFieldManaged>
|
<isRequired>false</isRequired>
|
</displayedFields>
|
<displayedFields>
|
<field>Target_amount_CYF__c</field>
|
<isFieldManaged>false</isFieldManaged>
|
<isRequired>false</isRequired>
|
</displayedFields>
|
<displayedFields>
|
<field>OPD_CYF__c</field>
|
<isFieldManaged>false</isFieldManaged>
|
<isRequired>false</isRequired>
|
</displayedFields>
|
<displayedFields>
|
<field>Target_amount_170_190__c</field>
|
<isFieldManaged>false</isFieldManaged>
|
<isRequired>false</isRequired>
|
</displayedFields>
|
<displayedFields>
|
<field>OPD_170_190__c</field>
|
<isFieldManaged>false</isFieldManaged>
|
<isRequired>false</isRequired>
|
</displayedFields>
|
<label>耳鼻喉科 周会-右边</label>
|
</fieldSets>
|
<fields>
|
<fullName>Account_HP__c</fullName>
|
<deleteConstraint>SetNull</deleteConstraint>
|
<externalId>false</externalId>
|
<label>医院名</label>
|
<lookupFilter>
|
<active>true</active>
|
<filterItems>
|
<field>Account.RecordTypeId</field>
|
<operation>equals</operation>
|
<value>病院</value>
|
</filterItems>
|
<isOptional>false</isOptional>
|
</lookupFilter>
|
<referenceTo>Account</referenceTo>
|
<relationshipLabel>客户-目标客户(客户-医院)</relationshipLabel>
|
<relationshipName>Account_target_hp</relationshipName>
|
<required>false</required>
|
<trackTrending>false</trackTrending>
|
<type>Lookup</type>
|
</fields>
|
<fields>
|
<fullName>Account__c</fullName>
|
<externalId>false</externalId>
|
<label>战略科室名</label>
|
<lookupFilter>
|
<active>true</active>
|
<filterItems>
|
<field>Account.Parent.RecordTypeId</field>
|
<operation>equals</operation>
|
<value>病院</value>
|
</filterItems>
|
<isOptional>false</isOptional>
|
</lookupFilter>
|
<referenceTo>Account</referenceTo>
|
<relationshipLabel>客户-目标客户 (战略科室名)</relationshipLabel>
|
<relationshipName>Account_target_acc</relationshipName>
|
<relationshipOrder>0</relationshipOrder>
|
<reparentableMasterDetail>true</reparentableMasterDetail>
|
<trackTrending>false</trackTrending>
|
<type>MasterDetail</type>
|
<writeRequiresMasterRead>false</writeRequiresMasterRead>
|
</fields>
|
<fields>
|
<fullName>Additional_comment__c</fullName>
|
<externalId>false</externalId>
|
<label>备注</label>
|
<length>32768</length>
|
<trackTrending>false</trackTrending>
|
<type>LongTextArea</type>
|
<visibleLines>8</visibleLines>
|
</fields>
|
<fields>
|
<fullName>AllHostsNumber__c</fullName>
|
<externalId>false</externalId>
|
<label>所有主机数</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>AllHostsNumber_first__c</fullName>
|
<externalId>false</externalId>
|
<label>所有主机数（期初）</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>AllOP_ThousandY__c</fullName>
|
<externalId>false</externalId>
|
<label>7.全部询价(不含税,千元)</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>2</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Amount_Without_Tax_Thousand__c</fullName>
|
<externalId>false</externalId>
|
<label>OCSM预测成交金额（千元RMB，不含税）</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>2</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Asset_Cnt_190Main__c</fullName>
|
<externalId>false</externalId>
|
<formula>Asset_Cnt_CV190__c + Asset_Cnt_OTVS190__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>保有设备数：190主机</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Asset_Cnt_290MiroBF__c</fullName>
|
<externalId>false</externalId>
|
<label>保有设备数：290镜子BF</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Asset_Cnt_290MiroGI_CF__c</fullName>
|
<externalId>false</externalId>
|
<label>保有设备数：下消化放大内镜</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Asset_Cnt_290MiroGI_Plus__c</fullName>
|
<externalId>false</externalId>
|
<label>保有设备数：上消化放大内镜</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Asset_Cnt_290MiroGI__c</fullName>
|
<externalId>false</externalId>
|
<label>保有设备数：SIF-H290S</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Asset_Cnt_CV170__c</fullName>
|
<externalId>false</externalId>
|
<label>保有设备数：CV170</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Asset_Cnt_CV190__c</fullName>
|
<externalId>false</externalId>
|
<label>保有设备数：CV-190</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Asset_Cnt_CV290__c</fullName>
|
<externalId>false</externalId>
|
<label>保有设备数：CV-290</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Asset_Cnt_ESG400__c</fullName>
|
<externalId>false</externalId>
|
<label>保有设备数：ESG-400</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Asset_Cnt_EUME2__c</fullName>
|
<externalId>false</externalId>
|
<label>保有设备数：EU-ME2</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Asset_Cnt_GFUCT260__c</fullName>
|
<externalId>false</externalId>
|
<label>保有设备数：GF-UCT260</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Asset_Cnt_OTVS190__c</fullName>
|
<externalId>false</externalId>
|
<label>保有设备数：OTV-S190</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Asset_Cnt_OTVS300__c</fullName>
|
<externalId>false</externalId>
|
<label>保有设备数：OTV-S300</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Asset_Cnt_OTVS400__c</fullName>
|
<externalId>false</externalId>
|
<label>保有设备数：OTV-S400</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Asset_Cnt_TB__c</fullName>
|
<externalId>false</externalId>
|
<label>保有设备数：TB</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Asset_Cnt_USG400__c</fullName>
|
<externalId>false</externalId>
|
<label>保有设备数：USG-400</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>BO_Forecast_ThousandY__c</fullName>
|
<externalId>false</externalId>
|
<label>3.今年注残(不含税,千元)</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>2</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Delivery_cnt_170_190__c</fullName>
|
<description>20190719备份
|
Delivery_cnt_CV170__c + Delivery_cnt_CV190__c + Delivery_cnt_OTVS190__c</description>
|
<externalId>false</externalId>
|
<formula>Delivery_cnt_CV170__c + Delivery_cnt_CV190__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>发货数：170/190</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Delivery_cnt_190Main__c</fullName>
|
<externalId>false</externalId>
|
<formula>Delivery_cnt_CV190__c + Delivery_cnt_OTVS190__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>发货数：190主机</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Delivery_cnt_290MiroBF__c</fullName>
|
<externalId>false</externalId>
|
<label>发货数：290镜子BF</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Delivery_cnt_290MiroGI_CF__c</fullName>
|
<externalId>false</externalId>
|
<label>发货数：下消化放大内镜</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Delivery_cnt_290MiroGI_Plus__c</fullName>
|
<externalId>false</externalId>
|
<label>发货数：上消化放大内镜</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Delivery_cnt_290MiroGI__c</fullName>
|
<externalId>false</externalId>
|
<label>发货数：SIF-H290S</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Delivery_cnt_290Miro_F__c</fullName>
|
<externalId>false</externalId>
|
<formula>Delivery_cnt_290MiroBF__c + Delivery_cnt_290MiroGI__c + Delivery_cnt_290MiroGI_CF__c + Delivery_cnt_290MiroGI_Plus__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>发货数：290镜子（公式）</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Delivery_cnt_290Miro__c</fullName>
|
<externalId>false</externalId>
|
<label>发货数：290镜子</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Delivery_cnt_3D__c</fullName>
|
<externalId>false</externalId>
|
<label>发货数：3D</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Delivery_cnt_CV170__c</fullName>
|
<externalId>false</externalId>
|
<label>发货数：CV-170</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Delivery_cnt_CV190__c</fullName>
|
<externalId>false</externalId>
|
<label>发货数：CV-190</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Delivery_cnt_CV290__c</fullName>
|
<externalId>false</externalId>
|
<label>发货数：CV-290</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Delivery_cnt_CYF__c</fullName>
|
<externalId>false</externalId>
|
<label>发货数：CYF</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Delivery_cnt_ENG__c</fullName>
|
<externalId>false</externalId>
|
<formula>Delivery_cnt_ESG400__c + Delivery_cnt_USG400__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>发货数：ENG主机</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Delivery_cnt_ESG400__c</fullName>
|
<externalId>false</externalId>
|
<label>发货数：ESG-400</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Delivery_cnt_EUME2__c</fullName>
|
<externalId>false</externalId>
|
<label>发货数：EU-ME2</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Delivery_cnt_GFUCT260__c</fullName>
|
<externalId>false</externalId>
|
<label>发货数：GF-UCT260</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Delivery_cnt_OERAW__c</fullName>
|
<externalId>false</externalId>
|
<label>发货数：OER-AW</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Delivery_cnt_OTVS190__c</fullName>
|
<externalId>false</externalId>
|
<label>发货数：OTV-S190</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Delivery_cnt_OTVS300S400__c</fullName>
|
<externalId>false</externalId>
|
<formula>Delivery_cnt_OTVS300__c + Delivery_cnt_OTVS400__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>发货数：OTV-S300/S400</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Delivery_cnt_OTVS300__c</fullName>
|
<externalId>false</externalId>
|
<label>发货数：OTV-S300</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Delivery_cnt_OTVS400__c</fullName>
|
<externalId>false</externalId>
|
<label>发货数：OTV-S400</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Delivery_cnt_TB__c</fullName>
|
<externalId>false</externalId>
|
<label>发货数：TB</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Delivery_cnt_USG400__c</fullName>
|
<externalId>false</externalId>
|
<label>发货数：USG-400</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Department_Budget_Sum_Price1__c</fullName>
|
<description>2018/06/21修改前：
|
Department_Budget_Sum_Price__c/1000
|
|
20180325修改前
|
if( TODAY() < Datevalue( $Label.Tax_Date ),Department_Budget_Sum_Price__c / 1.17 / 1000,Department_Budget_Sum_Price__c / 1.16 / 1000)</description>
|
<externalId>false</externalId>
|
<formula>if( TODAY() < Datevalue( $Label.Tax_Date_13 ),Department_Budget_Sum_Price__c / 1.16 / 1000,Department_Budget_Sum_Price__c / 1.13 / 1000)</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>Department_Budget_Sum_Price__c</fullName>
|
<externalId>false</externalId>
|
<label>科室预算总金额(元)</label>
|
<precision>10</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>EventCount_M10_Eng__c</fullName>
|
<externalId>false</externalId>
|
<label>活动数10月(能量)</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>EventCount_M10_FSE__c</fullName>
|
<externalId>false</externalId>
|
<label>活动数10月(FSE)</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>EventCount_M10__c</fullName>
|
<externalId>false</externalId>
|
<label>活动数10月</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>EventCount_M11_Eng__c</fullName>
|
<externalId>false</externalId>
|
<label>活动数11月(能量)</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>EventCount_M11_FSE__c</fullName>
|
<externalId>false</externalId>
|
<label>活动数11月(FSE)</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>EventCount_M11__c</fullName>
|
<externalId>false</externalId>
|
<label>活动数11月</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>EventCount_M12_Eng__c</fullName>
|
<externalId>false</externalId>
|
<label>活动数12月(能量)</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>EventCount_M12_FSE__c</fullName>
|
<externalId>false</externalId>
|
<label>活动数12月(FSE)</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>EventCount_M12__c</fullName>
|
<externalId>false</externalId>
|
<label>活动数12月</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>EventCount_M1_Eng__c</fullName>
|
<externalId>false</externalId>
|
<label>活动数1月(能量)</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>EventCount_M1_FSE__c</fullName>
|
<externalId>false</externalId>
|
<label>活动数1月(FSE)</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>EventCount_M1__c</fullName>
|
<externalId>false</externalId>
|
<label>活动数1月</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>EventCount_M2_Eng__c</fullName>
|
<externalId>false</externalId>
|
<label>活动数2月(能量)</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>EventCount_M2_FSE__c</fullName>
|
<externalId>false</externalId>
|
<label>活动数2月(FSE)</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>EventCount_M2__c</fullName>
|
<externalId>false</externalId>
|
<label>活动数2月</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>EventCount_M3_Eng__c</fullName>
|
<externalId>false</externalId>
|
<label>活动数3月(能量)</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>EventCount_M3_FSE__c</fullName>
|
<externalId>false</externalId>
|
<label>活动数3月(FSE)</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>EventCount_M3__c</fullName>
|
<externalId>false</externalId>
|
<label>活动数3月</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>EventCount_M4_Eng__c</fullName>
|
<externalId>false</externalId>
|
<label>活动数4月(能量)</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>EventCount_M4_FSE__c</fullName>
|
<externalId>false</externalId>
|
<label>活动数4月(FSE)</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>EventCount_M4__c</fullName>
|
<externalId>false</externalId>
|
<label>活动数4月</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>EventCount_M5_Eng__c</fullName>
|
<externalId>false</externalId>
|
<label>活动数5月(能量)</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>EventCount_M5_FSE__c</fullName>
|
<externalId>false</externalId>
|
<label>活动数5月(FSE)</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>EventCount_M5__c</fullName>
|
<externalId>false</externalId>
|
<label>活动数5月</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>EventCount_M6_Eng__c</fullName>
|
<externalId>false</externalId>
|
<label>活动数6月(能量)</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>EventCount_M6_FSE__c</fullName>
|
<externalId>false</externalId>
|
<label>活动数6月(FSE)</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>EventCount_M6__c</fullName>
|
<externalId>false</externalId>
|
<label>活动数6月</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>EventCount_M7_Eng__c</fullName>
|
<externalId>false</externalId>
|
<label>活动数7月(能量)</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>EventCount_M7_FSE__c</fullName>
|
<externalId>false</externalId>
|
<label>活动数7月(FSE)</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>EventCount_M7__c</fullName>
|
<externalId>false</externalId>
|
<label>活动数7月</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>EventCount_M8_Eng__c</fullName>
|
<externalId>false</externalId>
|
<label>活动数8月(能量)</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>EventCount_M8_FSE__c</fullName>
|
<externalId>false</externalId>
|
<label>活动数8月(FSE)</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>EventCount_M8__c</fullName>
|
<externalId>false</externalId>
|
<label>活动数8月</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>EventCount_M9_Eng__c</fullName>
|
<externalId>false</externalId>
|
<label>活动数9月(能量)</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>EventCount_M9_FSE__c</fullName>
|
<externalId>false</externalId>
|
<label>活动数9月(FSE)</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>EventCount_M9__c</fullName>
|
<externalId>false</externalId>
|
<label>活动数9月</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>EventCover_M10_Eng__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(NOT(ISBLANK(EventCount_M10_Eng__c)) && EventCount_M10_Eng__c > 0, 1, 0)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>活动覆盖10月(能量)</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>EventCover_M10_FSE__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(NOT(ISBLANK(EventCount_M10_FSE__c)) && EventCount_M10_FSE__c > 0, 1, 0)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>活动覆盖10月(FSE)</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>EventCover_M10__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(NOT(ISBLANK(EventCount_M10__c)) && EventCount_M10__c > 0, 1, 0)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>活动覆盖10月</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>EventCover_M11_Eng__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(NOT(ISBLANK(EventCount_M11_Eng__c)) && EventCount_M11_Eng__c > 0, 1, 0)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>活动覆盖11月(能量)</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>EventCover_M11_FSE__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(NOT(ISBLANK(EventCount_M11_FSE__c)) && EventCount_M11_FSE__c > 0, 1, 0)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>活动覆盖11月(FSE)</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>EventCover_M11__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(NOT(ISBLANK(EventCount_M11__c)) && EventCount_M11__c > 0, 1, 0)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>活动覆盖11月</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>EventCover_M12_Eng__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(NOT(ISBLANK(EventCount_M12_Eng__c)) && EventCount_M12_Eng__c > 0, 1, 0)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>活动覆盖12月(能量)</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>EventCover_M12_FSE__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(NOT(ISBLANK(EventCount_M12_FSE__c)) && EventCount_M12_FSE__c > 0, 1, 0)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>活动覆盖12月(FSE)</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>EventCover_M12__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(NOT(ISBLANK(EventCount_M12__c)) && EventCount_M12__c > 0, 1, 0)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>活动覆盖12月</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>EventCover_M1_Eng__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(NOT(ISBLANK(EventCount_M1_Eng__c)) && EventCount_M1_Eng__c > 0, 1, 0)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>活动覆盖1月(能量)</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>EventCover_M1_FSE__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(NOT(ISBLANK(EventCount_M1_FSE__c)) && EventCount_M1_FSE__c > 0, 1, 0)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>活动覆盖1月(FSE)</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>EventCover_M1__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(NOT(ISBLANK(EventCount_M1__c)) && EventCount_M1__c > 0, 1, 0)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>活动覆盖1月</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>EventCover_M2_Eng__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(NOT(ISBLANK(EventCount_M2_Eng__c)) && EventCount_M2_Eng__c > 0, 1, 0)</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>EventCover_M2_FSE__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(NOT(ISBLANK(EventCount_M2_FSE__c)) && EventCount_M2_FSE__c > 0, 1, 0)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>活动覆盖2月(FSE)</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>EventCover_M2__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(NOT(ISBLANK(EventCount_M2__c)) && EventCount_M2__c > 0, 1, 0)</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>EventCover_M3_Eng__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(NOT(ISBLANK(EventCount_M3_Eng__c)) && EventCount_M3_Eng__c > 0, 1, 0)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>活动覆盖3月(能量)</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>EventCover_M3_FSE__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(NOT(ISBLANK(EventCount_M3_FSE__c)) && EventCount_M3_FSE__c > 0, 1, 0)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>活动覆盖3月(FSE)</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>EventCover_M3__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(NOT(ISBLANK(EventCount_M3__c)) && EventCount_M3__c > 0, 1, 0)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>活动覆盖3月</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>EventCover_M4_Eng__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(NOT(ISBLANK(EventCount_M4_Eng__c)) && EventCount_M4_Eng__c > 0, 1, 0)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>活动覆盖4月(能量)</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>EventCover_M4_FSE__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(NOT(ISBLANK(EventCount_M4_FSE__c)) && EventCount_M4_FSE__c > 0, 1, 0)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>活动覆盖4月(FSE)</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>EventCover_M4__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(NOT(ISBLANK(EventCount_M4__c)) && EventCount_M4__c > 0, 1, 0)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>活动覆盖4月</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>EventCover_M5_Eng__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(NOT(ISBLANK(EventCount_M5_Eng__c)) && EventCount_M5_Eng__c > 0, 1, 0)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>活动覆盖5月(能量)</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>EventCover_M5_FSE__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(NOT(ISBLANK(EventCount_M5_FSE__c)) && EventCount_M5_FSE__c > 0, 1, 0)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>活动覆盖5月(FSE)</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>EventCover_M5__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(NOT(ISBLANK(EventCount_M5__c)) && EventCount_M5__c > 0, 1, 0)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>活动覆盖5月</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>EventCover_M6_Eng__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(NOT(ISBLANK(EventCount_M6_Eng__c)) && EventCount_M6_Eng__c > 0, 1, 0)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>活动覆盖6月(能量)</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>EventCover_M6_FSE__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(NOT(ISBLANK(EventCount_M6_FSE__c)) && EventCount_M6_FSE__c > 0, 1, 0)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>活动覆盖6月(FSE)</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>EventCover_M6__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(NOT(ISBLANK(EventCount_M6__c)) && EventCount_M6__c > 0, 1, 0)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>活动覆盖6月</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>EventCover_M7_Eng__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(NOT(ISBLANK(EventCount_M7_Eng__c)) && EventCount_M7_Eng__c > 0, 1, 0)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>活动覆盖7月(能量)</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>EventCover_M7_FSE__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(NOT(ISBLANK(EventCount_M7_FSE__c)) && EventCount_M7_FSE__c > 0, 1, 0)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>活动覆盖7月(FSE)</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>EventCover_M7__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(NOT(ISBLANK(EventCount_M7__c)) && EventCount_M7__c > 0, 1, 0)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>活动覆盖7月</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>EventCover_M8_Eng__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(NOT(ISBLANK(EventCount_M8_Eng__c)) && EventCount_M8_Eng__c > 0, 1, 0)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>活动覆盖8月(能量)</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>EventCover_M8_FSE__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(NOT(ISBLANK(EventCount_M8_FSE__c)) && EventCount_M8_FSE__c > 0, 1, 0)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>活动覆盖8月(FSE)</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>EventCover_M8__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(NOT(ISBLANK(EventCount_M8__c)) && EventCount_M8__c > 0, 1, 0)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>活动覆盖8月</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>EventCover_M9_Eng__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(NOT(ISBLANK(EventCount_M9_Eng__c)) && EventCount_M9_Eng__c > 0, 1, 0)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>活动覆盖9月(能量)</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>EventCover_M9_FSE__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(NOT(ISBLANK(EventCount_M9_FSE__c)) && EventCount_M9_FSE__c > 0, 1, 0)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>活动覆盖9月(FSE)</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>EventCover_M9__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(NOT(ISBLANK(EventCount_M9__c)) && EventCount_M9__c > 0, 1, 0)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>活动覆盖9月</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Is_EventCover_Eng__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF((EventCover_M4_Eng__c + EventCover_M5_Eng__c + EventCover_M6_Eng__c + EventCover_M7_Eng__c + EventCover_M8_Eng__c + EventCover_M9_Eng__c + EventCover_M10_Eng__c + EventCover_M11_Eng__c + EventCover_M12_Eng__c + EventCover_M1_Eng__c +EventCover_M2_Eng__c + EventCover_M3_Eng__c)>0, 1, 0)</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>Is_EventCover_FSE__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF((EventCover_M4_FSE__c + EventCover_M5_FSE__c + EventCover_M6_FSE__c + EventCover_M7_FSE__c + EventCover_M8_FSE__c + EventCover_M9_FSE__c + EventCover_M10_FSE__c + EventCover_M11_FSE__c + EventCover_M12_FSE__c + EventCover_M1_FSE__c +EventCover_M2_FSE__c + EventCover_M3_FSE__c) > 0, 1, 0)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>是否活动覆盖(FSE)</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Is_EventCover__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF((EventCover_M4__c + EventCover_M5__c + EventCover_M6__c + EventCover_M7__c + EventCover_M8__c + EventCover_M9__c + EventCover_M10__c + EventCover_M11__c + EventCover_M12__c + EventCover_M1__c +EventCover_M2__c + EventCover_M3__c)>0, 1, 0)</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>Is_Target_Account_Energy__c</fullName>
|
<externalId>false</externalId>
|
<formula>if(OR(Account__r.RecordType.DeveloperName='Department_Class_GI',
|
Account__r.RecordType.DeveloperName='Department_Class_BF',
|
Account__r.RecordType.DeveloperName='Department_Class_GS',
|
Account__r.RecordType.DeveloperName='Department_Class_URO',
|
Account__r.RecordType.DeveloperName='Department_Class_GYN',
|
Account__r.RecordType.DeveloperName='Department_Class_ENT'),
|
IF(Target_amount_TB__c > 0, 1, 0),0)</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>Is_Target_Account__c</fullName>
|
<description>19-5-16前：
|
IF(OR(Account__r.RecordType.DeveloperName='Department_Class_GI',
|
Account__r.RecordType.DeveloperName='Department_Class_BF'),IF( (NULLVALUE(Target_amount_CV290__c, 0) + NULLVALUE(Target_amount_CV170__c, 0)
|
+ NULLVALUE(Target_amount_EUME2__c, 0) + NULLVALUE(Target_amount_290Miro__c, 0)
|
+ NULLVALUE(Target_amount_OERAW__c, 0) ) > 0
|
,1, 0
|
)
|
,IF(OR(Account__r.RecordType.DeveloperName='Department_Class_GS',
|
Account__r.RecordType.DeveloperName='Department_Class_URO',
|
Account__r.RecordType.DeveloperName='Department_Class_GYN',
|
Account__r.RecordType.DeveloperName='Department_Class_ENT')
|
,IF( (NULLVALUE(Target_amount_OTVS400__c, 0) + NULLVALUE(Target_amount_CHS400XZ__c, 0)
|
+ NULLVALUE(Target_amount_3D__c, 0) + NULLVALUE(Target_amount_CV190__c, 0)
|
+ NULLVALUE(Target_amount_OTVS190__c, 0) + NULLVALUE(Target_amount_CV170__c, 0)
|
+ NULLVALUE(Target_amount_UCES3__c, 0) )</description>
|
<externalId>false</externalId>
|
<formula>IF(
|
Account__r.RecordType.DeveloperName = 'Department_Class_GI',
|
IF((NULLVALUE(Target_amount_CV290__c, 0) + NULLVALUE(Target_amount_EUME2__c, 0) + NULLVALUE(Target_amount_290Miro__c, 0) + NULLVALUE(Target_amount_GFUCT260__c, 0)) > 0,
|
1,
|
0),
|
IF(
|
Account__r.RecordType.DeveloperName = 'Department_Class_BF',
|
IF((NULLVALUE(Target_amount_CV290__c, 0) + NULLVALUE(Target_amount_EUME2__c, 0)+ NULLVALUE(Target_amount_290Miro__c, 0)) > 0,
|
1,
|
0),
|
IF(
|
OR(Account__r.RecordType.DeveloperName = 'Department_Class_GS',
|
Account__r.RecordType.DeveloperName = 'Department_Class_URO',
|
Account__r.RecordType.DeveloperName = 'Department_Class_GYN',
|
Account__r.RecordType.DeveloperName = 'Department_Class_ENT'),
|
IF((NULLVALUE(Target_amount_OTVS300S400__c, 0) + NULLVALUE(Target_amount_CV170__c, 0)
|
+ NULLVALUE(Target_amount_ENG__c, 0) + NULLVALUE(Target_amount_190Main__c, 0)) > 0,
|
1,
|
0),
|
0)))</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>Is_this_year__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(LEFT(TEXT(OCM_Period__c), 3) = TEXT(YEAR(TODAY()) - 1867 - IF(MONTH(TODAY()) < 4, 1, 0)), true, false)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>是否今年</label>
|
<trackTrending>false</trackTrending>
|
<type>Checkbox</type>
|
</fields>
|
<fields>
|
<fullName>MonthVisitCoverageRate10Text__c</fullName>
|
<externalId>false</externalId>
|
<label>10月拜访覆盖率（文本）</label>
|
<precision>10</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Percent</type>
|
</fields>
|
<fields>
|
<fullName>MonthVisitCoverageRate10_ENG_Text__c</fullName>
|
<externalId>false</externalId>
|
<label>10月拜访覆盖率（能量）（文本）</label>
|
<precision>10</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Percent</type>
|
</fields>
|
<fields>
|
<fullName>MonthVisitCoverageRate10_ENG__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(Is_Target_Account_Energy__c ==0,null , EventCover_M10_Eng__c/Is_Target_Account_Energy__c)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>10月拜访覆盖率（能量）</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Percent</type>
|
</fields>
|
<fields>
|
<fullName>MonthVisitCoverageRate10__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(Is_Target_Account__c ==0,null , EventCover_M10__c/Is_Target_Account__c)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>10月拜访覆盖率</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Percent</type>
|
</fields>
|
<fields>
|
<fullName>MonthVisitCoverageRate11Text__c</fullName>
|
<externalId>false</externalId>
|
<label>11月拜访覆盖率（文本）</label>
|
<precision>10</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Percent</type>
|
</fields>
|
<fields>
|
<fullName>MonthVisitCoverageRate11_ENG_Text__c</fullName>
|
<externalId>false</externalId>
|
<label>11月拜访覆盖率（能量）（文本）</label>
|
<precision>10</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Percent</type>
|
</fields>
|
<fields>
|
<fullName>MonthVisitCoverageRate11_ENG__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(Is_Target_Account_Energy__c ==0,null , EventCover_M11_Eng__c/Is_Target_Account_Energy__c)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>11月拜访覆盖率（能量）</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Percent</type>
|
</fields>
|
<fields>
|
<fullName>MonthVisitCoverageRate11__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(Is_Target_Account__c ==0,null , EventCover_M11__c/Is_Target_Account__c)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>11月拜访覆盖率</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Percent</type>
|
</fields>
|
<fields>
|
<fullName>MonthVisitCoverageRate12Text__c</fullName>
|
<externalId>false</externalId>
|
<label>12月拜访覆盖率（文本）</label>
|
<precision>10</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Percent</type>
|
</fields>
|
<fields>
|
<fullName>MonthVisitCoverageRate12_ENG_Text__c</fullName>
|
<externalId>false</externalId>
|
<label>12月拜访覆盖率（能量）（文本）</label>
|
<precision>10</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Percent</type>
|
</fields>
|
<fields>
|
<fullName>MonthVisitCoverageRate12_ENG__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(Is_Target_Account_Energy__c ==0,null , EventCover_M12_Eng__c/Is_Target_Account_Energy__c)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>12月拜访覆盖率（能量）</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Percent</type>
|
</fields>
|
<fields>
|
<fullName>MonthVisitCoverageRate12__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(Is_Target_Account__c ==0,null , EventCover_M12__c/Is_Target_Account__c)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>12月拜访覆盖率</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Percent</type>
|
</fields>
|
<fields>
|
<fullName>MonthVisitCoverageRate1Text__c</fullName>
|
<externalId>false</externalId>
|
<label>1月拜访覆盖率（文本）</label>
|
<precision>10</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Percent</type>
|
</fields>
|
<fields>
|
<fullName>MonthVisitCoverageRate1_ENG_Text__c</fullName>
|
<externalId>false</externalId>
|
<label>1月拜访覆盖率（能量）（文本）</label>
|
<precision>10</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Percent</type>
|
</fields>
|
<fields>
|
<fullName>MonthVisitCoverageRate1_ENG__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(Is_Target_Account_Energy__c ==0,null , EventCover_M1_Eng__c/Is_Target_Account_Energy__c)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>1月拜访覆盖率（能量）</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Percent</type>
|
</fields>
|
<fields>
|
<fullName>MonthVisitCoverageRate1__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(Is_Target_Account__c ==0,null , EventCover_M1__c/Is_Target_Account__c)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>1月拜访覆盖率</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Percent</type>
|
</fields>
|
<fields>
|
<fullName>MonthVisitCoverageRate2Text__c</fullName>
|
<externalId>false</externalId>
|
<label>2月拜访覆盖率（文本）</label>
|
<precision>10</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Percent</type>
|
</fields>
|
<fields>
|
<fullName>MonthVisitCoverageRate2_ENG_Text__c</fullName>
|
<externalId>false</externalId>
|
<label>2月拜访覆盖率（能量）（文本）</label>
|
<precision>10</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Percent</type>
|
</fields>
|
<fields>
|
<fullName>MonthVisitCoverageRate2_ENG__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(Is_Target_Account_Energy__c ==0,null , EventCover_M2_Eng__c/Is_Target_Account_Energy__c)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>2月拜访覆盖率（能量）</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Percent</type>
|
</fields>
|
<fields>
|
<fullName>MonthVisitCoverageRate2__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(Is_Target_Account__c ==0,null , EventCover_M2__c/Is_Target_Account__c)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>2月拜访覆盖率</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Percent</type>
|
</fields>
|
<fields>
|
<fullName>MonthVisitCoverageRate3Text__c</fullName>
|
<externalId>false</externalId>
|
<label>3月拜访覆盖率（文本）</label>
|
<precision>10</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Percent</type>
|
</fields>
|
<fields>
|
<fullName>MonthVisitCoverageRate3_ENG_Text__c</fullName>
|
<externalId>false</externalId>
|
<label>3月拜访覆盖率（能量）（文本）</label>
|
<precision>10</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Percent</type>
|
</fields>
|
<fields>
|
<fullName>MonthVisitCoverageRate3_ENG__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(Is_Target_Account_Energy__c ==0,null , EventCover_M3_Eng__c/Is_Target_Account_Energy__c)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>3月拜访覆盖率（能量）</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Percent</type>
|
</fields>
|
<fields>
|
<fullName>MonthVisitCoverageRate3__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(Is_Target_Account__c ==0,null , EventCover_M3__c/Is_Target_Account__c)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>3月拜访覆盖率</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Percent</type>
|
</fields>
|
<fields>
|
<fullName>MonthVisitCoverageRate4Text__c</fullName>
|
<externalId>false</externalId>
|
<label>4月拜访覆盖率（文本）</label>
|
<precision>10</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Percent</type>
|
</fields>
|
<fields>
|
<fullName>MonthVisitCoverageRate4_ENG_Text__c</fullName>
|
<externalId>false</externalId>
|
<label>4月拜访覆盖率（能量）（文本）</label>
|
<precision>10</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Percent</type>
|
</fields>
|
<fields>
|
<fullName>MonthVisitCoverageRate4_ENG__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(Is_Target_Account_Energy__c ==0,null , EventCover_M4_Eng__c/Is_Target_Account_Energy__c)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>4月拜访覆盖率（能量）</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Percent</type>
|
</fields>
|
<fields>
|
<fullName>MonthVisitCoverageRate4__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(Is_Target_Account__c ==0,null , EventCover_M4__c/Is_Target_Account__c)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>4月拜访覆盖率</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Percent</type>
|
</fields>
|
<fields>
|
<fullName>MonthVisitCoverageRate5Text__c</fullName>
|
<externalId>false</externalId>
|
<label>5月拜访覆盖率（文本）</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Percent</type>
|
</fields>
|
<fields>
|
<fullName>MonthVisitCoverageRate5_ENG_Text__c</fullName>
|
<externalId>false</externalId>
|
<label>5月拜访覆盖率（能量）（文本）</label>
|
<precision>10</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Percent</type>
|
</fields>
|
<fields>
|
<fullName>MonthVisitCoverageRate5_ENG__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(Is_Target_Account_Energy__c ==0,null , EventCover_M5_Eng__c/Is_Target_Account_Energy__c)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>5月拜访覆盖率（能量）</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Percent</type>
|
</fields>
|
<fields>
|
<fullName>MonthVisitCoverageRate5__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(Is_Target_Account__c ==0,null , EventCover_M5__c/Is_Target_Account__c)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>5月拜访覆盖率</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Percent</type>
|
</fields>
|
<fields>
|
<fullName>MonthVisitCoverageRate6Text__c</fullName>
|
<externalId>false</externalId>
|
<label>6月拜访覆盖率（文本）</label>
|
<precision>10</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Percent</type>
|
</fields>
|
<fields>
|
<fullName>MonthVisitCoverageRate6_ENG_Text__c</fullName>
|
<externalId>false</externalId>
|
<label>6月拜访覆盖率（能量）（文本）</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Percent</type>
|
</fields>
|
<fields>
|
<fullName>MonthVisitCoverageRate6_ENG__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(Is_Target_Account_Energy__c ==0,null , EventCover_M6_Eng__c/Is_Target_Account_Energy__c)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>6月拜访覆盖率（能量）</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Percent</type>
|
</fields>
|
<fields>
|
<fullName>MonthVisitCoverageRate6__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(Is_Target_Account__c ==0,null , EventCover_M6__c/Is_Target_Account__c)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>6月拜访覆盖率</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Percent</type>
|
</fields>
|
<fields>
|
<fullName>MonthVisitCoverageRate7Text__c</fullName>
|
<externalId>false</externalId>
|
<label>7月拜访覆盖率（文本）</label>
|
<precision>10</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Percent</type>
|
</fields>
|
<fields>
|
<fullName>MonthVisitCoverageRate7_ENG_Text__c</fullName>
|
<externalId>false</externalId>
|
<label>7月拜访覆盖率（能量）（文本）</label>
|
<precision>10</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Percent</type>
|
</fields>
|
<fields>
|
<fullName>MonthVisitCoverageRate7_ENG__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(Is_Target_Account_Energy__c ==0,null , EventCover_M7_Eng__c/Is_Target_Account_Energy__c)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>7月拜访覆盖率（能量）</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Percent</type>
|
</fields>
|
<fields>
|
<fullName>MonthVisitCoverageRate7__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(Is_Target_Account__c ==0,null , EventCover_M7__c/Is_Target_Account__c)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>7月拜访覆盖率</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Percent</type>
|
</fields>
|
<fields>
|
<fullName>MonthVisitCoverageRate8Text__c</fullName>
|
<externalId>false</externalId>
|
<label>8月拜访覆盖率（文本）</label>
|
<precision>10</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Percent</type>
|
</fields>
|
<fields>
|
<fullName>MonthVisitCoverageRate8_ENG_Text__c</fullName>
|
<externalId>false</externalId>
|
<label>8月拜访覆盖率（能量）（文本）</label>
|
<precision>10</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Percent</type>
|
</fields>
|
<fields>
|
<fullName>MonthVisitCoverageRate8_ENG__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(Is_Target_Account_Energy__c ==0,null , EventCover_M8_Eng__c/Is_Target_Account_Energy__c)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>8月拜访覆盖率（能量）</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Percent</type>
|
</fields>
|
<fields>
|
<fullName>MonthVisitCoverageRate8__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(Is_Target_Account__c ==0,null , EventCover_M8__c/Is_Target_Account__c)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>8月拜访覆盖率</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Percent</type>
|
</fields>
|
<fields>
|
<fullName>MonthVisitCoverageRate9Text__c</fullName>
|
<externalId>false</externalId>
|
<label>9月拜访覆盖率（文本）</label>
|
<precision>10</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Percent</type>
|
</fields>
|
<fields>
|
<fullName>MonthVisitCoverageRate9_ENG_Text__c</fullName>
|
<externalId>false</externalId>
|
<label>9月拜访覆盖率（能量）（文本）</label>
|
<precision>10</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Percent</type>
|
</fields>
|
<fields>
|
<fullName>MonthVisitCoverageRate9_ENG__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(Is_Target_Account_Energy__c ==0,null , EventCover_M9_Eng__c/Is_Target_Account_Energy__c)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>9月拜访覆盖率（能量）</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Percent</type>
|
</fields>
|
<fields>
|
<fullName>MonthVisitCoverageRate9__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(Is_Target_Account__c ==0,null , EventCover_M9__c/Is_Target_Account__c)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>9月拜访覆盖率</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Percent</type>
|
</fields>
|
<fields>
|
<fullName>Name_OCMCategory__c</fullName>
|
<externalId>false</externalId>
|
<formula>CASE( Account_HP__r.OCM_Category__c ,
|
"H0", "1. H0 ",
|
"H1", "2. H1 ",
|
"M0", "3. M0 ",
|
"M1", "4. M1 ",
|
"一般(M2)", "5. 一般(M2) ",
|
"L", "6. L ",
|
""
|
) & Account_HP__r.Name</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>TEXT(Account_HP__r.OCM_Category__c)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>OCSM分类(医院)</label>
|
<required>false</required>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>OCM_Period__c</fullName>
|
<externalId>false</externalId>
|
<label>OCSM期</label>
|
<required>false</required>
|
<trackTrending>false</trackTrending>
|
<type>Picklist</type>
|
<valueSet>
|
<valueSetDefinition>
|
<sorted>false</sorted>
|
<value>
|
<fullName>149P</fullName>
|
<default>false</default>
|
<label>149P</label>
|
</value>
|
<value>
|
<fullName>150P</fullName>
|
<default>false</default>
|
<label>150P</label>
|
</value>
|
<value>
|
<fullName>151P</fullName>
|
<default>false</default>
|
<label>151P</label>
|
</value>
|
<value>
|
<fullName>152P</fullName>
|
<default>false</default>
|
<label>152P</label>
|
</value>
|
<value>
|
<fullName>153P</fullName>
|
<default>false</default>
|
<label>153P</label>
|
</value>
|
<value>
|
<fullName>154P</fullName>
|
<default>false</default>
|
<label>FY2022</label>
|
</value>
|
<value>
|
<fullName>155P</fullName>
|
<default>false</default>
|
<label>FY2023</label>
|
</value>
|
<value>
|
<fullName>156P</fullName>
|
<default>false</default>
|
<label>FY2024</label>
|
</value>
|
<value>
|
<fullName>157P</fullName>
|
<default>false</default>
|
<label>FY2025</label>
|
</value>
|
<value>
|
<fullName>158P</fullName>
|
<default>false</default>
|
<label>FY2026</label>
|
</value>
|
</valueSetDefinition>
|
</valueSet>
|
</fields>
|
<fields>
|
<fullName>OCM_Year__c</fullName>
|
<externalId>false</externalId>
|
<label>OCSM年度</label>
|
<required>false</required>
|
<trackTrending>false</trackTrending>
|
<type>Picklist</type>
|
<valueSet>
|
<valueSetDefinition>
|
<sorted>false</sorted>
|
<value>
|
<fullName>2016年度</fullName>
|
<default>false</default>
|
<label>2016年度</label>
|
</value>
|
<value>
|
<fullName>2017年度</fullName>
|
<default>false</default>
|
<label>2017年度</label>
|
</value>
|
<value>
|
<fullName>2018年度</fullName>
|
<default>false</default>
|
<label>2018年度</label>
|
</value>
|
<value>
|
<fullName>2019年度</fullName>
|
<default>false</default>
|
<label>2019年度</label>
|
</value>
|
<value>
|
<fullName>2020年度</fullName>
|
<default>false</default>
|
<label>2020年度</label>
|
</value>
|
<value>
|
<fullName>2021年度</fullName>
|
<default>false</default>
|
<label>2021年度</label>
|
</value>
|
<value>
|
<fullName>2022年度</fullName>
|
<default>false</default>
|
<label>2022年度</label>
|
</value>
|
<value>
|
<fullName>2023年度</fullName>
|
<default>false</default>
|
<label>2023年度</label>
|
</value>
|
<value>
|
<fullName>2024年度</fullName>
|
<default>false</default>
|
<label>2024年度</label>
|
</value>
|
<value>
|
<fullName>2025年度</fullName>
|
<default>false</default>
|
<label>2025年度</label>
|
</value>
|
</valueSetDefinition>
|
</valueSet>
|
</fields>
|
<fields>
|
<fullName>OCSMYear__c</fullName>
|
<externalId>false</externalId>
|
<formula>VALUE(LEFT(Text(OCM_Year__c), 4))</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>OCSM年份（后台用）</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>OPD_170_190__c</fullName>
|
<externalId>false</externalId>
|
<label>OPD对象：170/190</label>
|
<precision>1</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>OPD_190Main_F__c</fullName>
|
<externalId>false</externalId>
|
<formula>if(OPD_CV190__c + OPD_OTVS190__c > 0, 1, 0)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>OPD对象：190主机(公式)</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>OPD_190Main__c</fullName>
|
<externalId>false</externalId>
|
<inlineHelpText>CV-190+OTV-S190</inlineHelpText>
|
<label>OPD对象：190主机</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>OPD_290Miro__c</fullName>
|
<externalId>false</externalId>
|
<label>OPD对象：290镜子</label>
|
<precision>1</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>OPD_3D__c</fullName>
|
<externalId>false</externalId>
|
<label>OPD对象：3D</label>
|
<precision>1</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>OPD_CHS400XZ__c</fullName>
|
<externalId>false</externalId>
|
<label>OPD对象：CH-S400-XZ</label>
|
<precision>1</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>OPD_CV170__c</fullName>
|
<externalId>false</externalId>
|
<label>OPD对象：CV-170</label>
|
<precision>1</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>OPD_CV190__c</fullName>
|
<externalId>false</externalId>
|
<label>OPD对象：CV-190</label>
|
<precision>1</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>OPD_CV290__c</fullName>
|
<externalId>false</externalId>
|
<label>OPD对象：CV-290</label>
|
<precision>1</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>OPD_CYF__c</fullName>
|
<externalId>false</externalId>
|
<label>OPD对象：CYF</label>
|
<precision>1</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>OPD_CYOPD_cover_CYFF__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(OPD_amount_CYF__c > 0, 1, 0)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>OPD覆盖：CYF</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>OPD_ENG_F__c</fullName>
|
<externalId>false</externalId>
|
<formula>if(OPD_ESG400__c + OPD_USG400__c > 0 , 1, 0)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>OPD对象：ENG主机(公式)</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>OPD_ENG__c</fullName>
|
<externalId>false</externalId>
|
<label>OPD对象：ENG主机</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>OPD_ESG400__c</fullName>
|
<externalId>false</externalId>
|
<label>OPD对象：ESG-400</label>
|
<precision>1</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>OPD_EUME2__c</fullName>
|
<externalId>false</externalId>
|
<label>OPD对象：EU-ME2</label>
|
<precision>1</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>OPD_GFUCT260__c</fullName>
|
<externalId>false</externalId>
|
<label>OPD对象：GF-UCT260</label>
|
<precision>1</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>OPD_GW__c</fullName>
|
<externalId>false</externalId>
|
<label>OPD对象：导丝(GW)</label>
|
<precision>1</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>OPD_OERAW__c</fullName>
|
<externalId>false</externalId>
|
<label>OPD对象：OER-AW</label>
|
<precision>1</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>OPD_OTVS190__c</fullName>
|
<externalId>false</externalId>
|
<label>OPD对象：OTV-S190</label>
|
<precision>1</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>OPD_OTVS300S400_F__c</fullName>
|
<externalId>false</externalId>
|
<formula>if(OPD_OTVS300__c + OPD_OTVS400__c > 0 , 1, 0)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>OPD对象：OTV-S300/S400(公式)</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>OPD_OTVS300S400__c</fullName>
|
<externalId>false</externalId>
|
<label>OPD对象：OTV-S300/S400</label>
|
<precision>1</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>OPD_OTVS300__c</fullName>
|
<externalId>false</externalId>
|
<label>OPD对象：OTV-S300</label>
|
<precision>1</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>OPD_OTVS400__c</fullName>
|
<externalId>false</externalId>
|
<label>OPD对象：OTV-S400</label>
|
<precision>1</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>OPD_PlanMonth_190Main__c</fullName>
|
<externalId>false</externalId>
|
<label>OPD计划月：190主机</label>
|
<required>false</required>
|
<trackTrending>false</trackTrending>
|
<type>Picklist</type>
|
<valueSet>
|
<restricted>true</restricted>
|
<valueSetName>Month</valueSetName>
|
</valueSet>
|
</fields>
|
<fields>
|
<fullName>OPD_PlanMonth_290Miro__c</fullName>
|
<externalId>false</externalId>
|
<label>OPD计划月：290镜子</label>
|
<required>false</required>
|
<trackTrending>false</trackTrending>
|
<type>Picklist</type>
|
<valueSet>
|
<restricted>true</restricted>
|
<valueSetName>Month</valueSetName>
|
</valueSet>
|
</fields>
|
<fields>
|
<fullName>OPD_PlanMonth_CV170__c</fullName>
|
<externalId>false</externalId>
|
<label>OPD计划月：CV-170</label>
|
<required>false</required>
|
<trackTrending>false</trackTrending>
|
<type>Picklist</type>
|
<valueSet>
|
<restricted>true</restricted>
|
<valueSetName>Month</valueSetName>
|
</valueSet>
|
</fields>
|
<fields>
|
<fullName>OPD_PlanMonth_CV190__c</fullName>
|
<externalId>false</externalId>
|
<label>OPD计划月：CV-190</label>
|
<required>false</required>
|
<trackTrending>false</trackTrending>
|
<type>Picklist</type>
|
<valueSet>
|
<restricted>true</restricted>
|
<valueSetName>Month</valueSetName>
|
</valueSet>
|
</fields>
|
<fields>
|
<fullName>OPD_PlanMonth_CV290__c</fullName>
|
<externalId>false</externalId>
|
<label>OPD计划月：CV-290</label>
|
<required>false</required>
|
<trackTrending>false</trackTrending>
|
<type>Picklist</type>
|
<valueSet>
|
<restricted>true</restricted>
|
<valueSetName>Month</valueSetName>
|
</valueSet>
|
</fields>
|
<fields>
|
<fullName>OPD_PlanMonth_ENG__c</fullName>
|
<externalId>false</externalId>
|
<label>OPD计划月：ENG主机</label>
|
<required>false</required>
|
<trackTrending>false</trackTrending>
|
<type>Picklist</type>
|
<valueSet>
|
<restricted>true</restricted>
|
<valueSetName>Month</valueSetName>
|
</valueSet>
|
</fields>
|
<fields>
|
<fullName>OPD_PlanMonth_ESG400__c</fullName>
|
<description>ESG-400</description>
|
<externalId>false</externalId>
|
<label>OPD计划月：ESG-400</label>
|
<required>false</required>
|
<trackTrending>false</trackTrending>
|
<type>Picklist</type>
|
<valueSet>
|
<restricted>true</restricted>
|
<valueSetName>Month</valueSetName>
|
</valueSet>
|
</fields>
|
<fields>
|
<fullName>OPD_PlanMonth_EUME2__c</fullName>
|
<externalId>false</externalId>
|
<label>OPD计划月：EU-ME2</label>
|
<required>false</required>
|
<trackTrending>false</trackTrending>
|
<type>Picklist</type>
|
<valueSet>
|
<restricted>true</restricted>
|
<valueSetName>Month</valueSetName>
|
</valueSet>
|
</fields>
|
<fields>
|
<fullName>OPD_PlanMonth_GFUCT260__c</fullName>
|
<externalId>false</externalId>
|
<label>OPD计划月：GF-UCT260</label>
|
<required>false</required>
|
<trackTrending>false</trackTrending>
|
<type>Picklist</type>
|
<valueSet>
|
<restricted>true</restricted>
|
<valueSetName>Month</valueSetName>
|
</valueSet>
|
</fields>
|
<fields>
|
<fullName>OPD_PlanMonth_OTVS190__c</fullName>
|
<description>OPD_PlanMonth_OTVS190</description>
|
<externalId>false</externalId>
|
<label>OPD计划月：OTV-S190</label>
|
<required>false</required>
|
<trackTrending>false</trackTrending>
|
<type>Picklist</type>
|
<valueSet>
|
<restricted>true</restricted>
|
<valueSetName>Month</valueSetName>
|
</valueSet>
|
</fields>
|
<fields>
|
<fullName>OPD_PlanMonth_OTVS300S400__c</fullName>
|
<externalId>false</externalId>
|
<label>OPD计划月：OTV-S300/S400</label>
|
<required>false</required>
|
<trackTrending>false</trackTrending>
|
<type>Picklist</type>
|
<valueSet>
|
<restricted>true</restricted>
|
<valueSetName>Month</valueSetName>
|
</valueSet>
|
</fields>
|
<fields>
|
<fullName>OPD_PlanMonth_OTVS300__c</fullName>
|
<externalId>false</externalId>
|
<label>OPD计划月：OTV-S300</label>
|
<required>false</required>
|
<trackTrending>false</trackTrending>
|
<type>Picklist</type>
|
<valueSet>
|
<restricted>true</restricted>
|
<valueSetName>Month</valueSetName>
|
</valueSet>
|
</fields>
|
<fields>
|
<fullName>OPD_PlanMonth_OTVS400__c</fullName>
|
<externalId>false</externalId>
|
<label>OPD计划月：OTV-S400</label>
|
<required>false</required>
|
<trackTrending>false</trackTrending>
|
<type>Picklist</type>
|
<valueSet>
|
<restricted>true</restricted>
|
<valueSetName>Month</valueSetName>
|
</valueSet>
|
</fields>
|
<fields>
|
<fullName>OPD_PlanMonth_TB__c</fullName>
|
<externalId>false</externalId>
|
<label>OPD计划月：TB</label>
|
<required>false</required>
|
<trackTrending>false</trackTrending>
|
<type>Picklist</type>
|
<valueSet>
|
<restricted>true</restricted>
|
<valueSetName>Month</valueSetName>
|
</valueSet>
|
</fields>
|
<fields>
|
<fullName>OPD_PlanMonth_USG400__c</fullName>
|
<description>USG400</description>
|
<externalId>false</externalId>
|
<label>OPD计划月：USG-400</label>
|
<required>false</required>
|
<trackTrending>false</trackTrending>
|
<type>Picklist</type>
|
<valueSet>
|
<restricted>true</restricted>
|
<valueSetName>Month</valueSetName>
|
</valueSet>
|
</fields>
|
<fields>
|
<fullName>OPD_TB__c</fullName>
|
<externalId>false</externalId>
|
<label>OPD对象：TB</label>
|
<precision>1</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>OPD_UCES3__c</fullName>
|
<externalId>false</externalId>
|
<label>OPD对象：UCES-3</label>
|
<precision>1</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>OPD_USG400__c</fullName>
|
<externalId>false</externalId>
|
<label>OPD对象：USG-400</label>
|
<precision>1</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>OPD_amount_170_190__c</fullName>
|
<externalId>false</externalId>
|
<formula>OPD_amount_CV170__c + OPD_amount_CV190__c + OPD_amount_OTVS190__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>OPD数（今年）：170/190</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>OPD_amount_190Main__c</fullName>
|
<externalId>false</externalId>
|
<formula>OPD_amount_CV190__c + OPD_amount_OTVS190__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>OPD数（今年）：190主机</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>OPD_amount_290MiroBF__c</fullName>
|
<externalId>false</externalId>
|
<label>OPD数（今年）：290镜子BF</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>OPD_amount_290MiroGI_CF__c</fullName>
|
<externalId>false</externalId>
|
<label>OPD数（今年）：下消化放大内镜</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>OPD_amount_290MiroGI_Plus__c</fullName>
|
<externalId>false</externalId>
|
<label>OPD数（今年）：上消化放大内镜</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>OPD_amount_290MiroGI__c</fullName>
|
<externalId>false</externalId>
|
<label>OPD数（今年）：.SIF-H290S</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>OPD_amount_290Miro_F__c</fullName>
|
<externalId>false</externalId>
|
<formula>OPD_amount_290MiroBF__c + OPD_amount_290MiroGI__c + OPD_amount_290MiroGI_CF__c + OPD_amount_290MiroGI_Plus__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>OPD数（今年）：290镜子（公式）</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>OPD_amount_290Miro__c</fullName>
|
<externalId>false</externalId>
|
<label>OPD数（今年）：290镜子（不使用）</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>OPD_amount_3D__c</fullName>
|
<externalId>false</externalId>
|
<label>OPD数（今年）：3D</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>OPD_amount_CHS400XZ__c</fullName>
|
<externalId>false</externalId>
|
<label>OPD数（今年）：CH-S400-XZ</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>OPD_amount_CV170__c</fullName>
|
<externalId>false</externalId>
|
<label>OPD数（今年）：CV-170</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>OPD_amount_CV190__c</fullName>
|
<externalId>false</externalId>
|
<label>OPD数（今年）：CV-190</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>OPD_amount_CV290__c</fullName>
|
<externalId>false</externalId>
|
<label>OPD数（今年）：CV-290</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>OPD_amount_CYF__c</fullName>
|
<externalId>false</externalId>
|
<label>OPD数（今年）：CYF</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>OPD_amount_ENG__c</fullName>
|
<externalId>false</externalId>
|
<formula>OPD_amount_ESG400__c + OPD_amount_USG400__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>OPD数（今年）：ENG主机</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>OPD_amount_ESG400__c</fullName>
|
<externalId>false</externalId>
|
<label>OPD数（今年）：ESG-400</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>OPD_amount_EUME2__c</fullName>
|
<externalId>false</externalId>
|
<label>OPD数（今年）：EU-ME2</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>OPD_amount_GFUCT260__c</fullName>
|
<externalId>false</externalId>
|
<label>OPD数（今年）：GF-UCT260</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>OPD_amount_GW__c</fullName>
|
<externalId>false</externalId>
|
<label>OPD数（今年）：导丝(GW)</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>OPD_amount_OERAW__c</fullName>
|
<externalId>false</externalId>
|
<label>OPD数（今年）：OER-AW</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>OPD_amount_OTVS190__c</fullName>
|
<externalId>false</externalId>
|
<label>OPD数（今年）：OTV-S190</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>OPD_amount_OTVS300S400__c</fullName>
|
<externalId>false</externalId>
|
<formula>OPD_amount_OTVS300__c + OPD_amount_OTVS400__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>OPD数（今年）：OTV-S300/S400</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>OPD_amount_OTVS300__c</fullName>
|
<externalId>false</externalId>
|
<label>OPD数（今年）：OTV-S300</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>OPD_amount_OTVS400__c</fullName>
|
<externalId>false</externalId>
|
<label>OPD数（今年）：OTV-S400</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>OPD_amount_TB__c</fullName>
|
<externalId>false</externalId>
|
<label>OPD数（今年）：TB</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>OPD_amount_UCES3__c</fullName>
|
<externalId>false</externalId>
|
<label>OPD数（今年）：UCES-3</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>OPD_amount_USG400__c</fullName>
|
<externalId>false</externalId>
|
<label>OPD数（今年）：USG400</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>OPD_cover_170_190__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(NOT(ISBLANK(OPD_amount_170_190__c)) && OPD_amount_170_190__c > 0, 1, 0)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>OPD覆盖：170/190</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>OPD_cover_190Main__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(NOT(ISBLANK(OPD_amount_190Main__c)) && OPD_amount_190Main__c > 0, 1, 0)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<inlineHelpText>CV-190+OTV-S190</inlineHelpText>
|
<label>OPD覆盖：190主机</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>OPD_cover_290MiroBF__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(NOT(ISBLANK(OPD_amount_290MiroBF__c)) && OPD_amount_290MiroBF__c > 0, 1, 0)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>OPD覆盖：290镜子BF</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>OPD_cover_290Miro__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(NOT(ISBLANK(OPD_amount_290Miro__c)) && OPD_amount_290Miro__c > 0, 1, 0)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>OPD覆盖：290镜子（不使用）</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>OPD_cover_3D__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(NOT(ISBLANK(OPD_amount_3D__c)) && OPD_amount_3D__c > 0, 1, 0)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>OPD覆盖：3D</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>OPD_cover_CHS400XZ__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(NOT(ISBLANK(OPD_amount_CHS400XZ__c)) && OPD_amount_CHS400XZ__c > 0, 1, 0)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>OPD覆盖：CH-S400-XZ</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>OPD_cover_CV170__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(NOT(ISBLANK(OPD_amount_CV170__c)) && OPD_amount_CV170__c > 0, 1, 0)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>OPD覆盖：CV-170</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>OPD_cover_CV190__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(NOT(ISBLANK(OPD_amount_CV190__c)) && OPD_amount_CV190__c > 0, 1, 0)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>OPD覆盖：CV-190</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>OPD_cover_CV290__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(NOT(ISBLANK(OPD_amount_CV290__c)) && OPD_amount_CV290__c > 0, 1, 0)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>OPD覆盖：CV-290</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>OPD_cover_ENG__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(NOT(ISBLANK(OPD_amount_ENG__c)) && OPD_amount_ENG__c > 0, 1, 0)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>OPD覆盖：ENG主机</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>OPD_cover_ESG400__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(NOT(ISBLANK(OPD_amount_ESG400__c)) && OPD_amount_ESG400__c> 0, 1, 0)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>OPD覆盖：ESG-400</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>OPD_cover_EUME2__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(NOT(ISBLANK(OPD_amount_EUME2__c)) && OPD_amount_EUME2__c > 0, 1, 0)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>OPD覆盖：EU-ME2</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>OPD_cover_GFUCT260__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(NOT(ISBLANK(OPD_amount_GFUCT260__c)) && OPD_amount_GFUCT260__c > 0, 1, 0)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>OPD覆盖：GF-UCT260</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>OPD_cover_GW__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(NOT(ISBLANK(OPD_amount_GW__c)) && OPD_amount_GW__c> 0, 1, 0)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>OPD覆盖：导丝(GW)</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>OPD_cover_OERAW__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(NOT(ISBLANK(OPD_amount_OERAW__c)) && OPD_amount_OERAW__c > 0, 1, 0)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>OPD覆盖：OER-AW</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>OPD_cover_OTVS190__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(NOT(ISBLANK(OPD_amount_OTVS190__c)) && OPD_amount_OTVS190__c > 0, 1, 0)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>OPD覆盖：OTV-S190</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>OPD_cover_OTVS300S400__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(NOT(ISBLANK(OPD_amount_OTVS300S400__c)) && OPD_amount_OTVS300S400__c> 0, 1, 0)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>OPD覆盖：OTV-S300/S400</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>OPD_cover_OTVS300__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(NOT(ISBLANK(OPD_amount_OTVS300__c)) && OPD_amount_OTVS300__c > 0, 1, 0)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>OPD覆盖：OTV-S300</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>OPD_cover_OTVS400__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(NOT(ISBLANK(OPD_amount_OTVS400__c)) && OPD_amount_OTVS400__c > 0, 1, 0)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>OPD覆盖：OTV-S400</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>OPD_cover_TB__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(NOT(ISBLANK(OPD_amount_TB__c)) && OPD_amount_TB__c > 0, 1, 0)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>OPD覆盖：TB</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>OPD_cover_UCES3__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(NOT(ISBLANK(OPD_amount_UCES3__c)) && OPD_amount_UCES3__c > 0, 1, 0)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>OPD覆盖：UCES-3</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>OPD_cover_USG400__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(NOT(ISBLANK(OPD_amount_USG400__c)) && OPD_amount_USG400__c > 0, 1, 0)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>OPD覆盖：USG-400</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>OP_ThousandY__c</fullName>
|
<externalId>false</externalId>
|
<label>4.今年询价(不含税,千元)</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>2</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Opp_Actual_ThousandY__c</fullName>
|
<externalId>false</externalId>
|
<label>2.今年发货(不含税,千元)</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>2</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Opp_Forecast_ThousandY__c</fullName>
|
<externalId>false</externalId>
|
<label>5.今年发货+注残(不含税,千元)</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>2</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Opp_cnt_170_190__c</fullName>
|
<description>20190719备份
|
Opp_cnt_CV170__c + Opp_cnt_CV190__c + Opp_cnt_OTVS190__c</description>
|
<externalId>false</externalId>
|
<formula>Opp_cnt_CV170__c + Opp_cnt_CV190__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>询价数：170/190</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Opp_cnt_190Main__c</fullName>
|
<externalId>false</externalId>
|
<formula>Opp_cnt_CV190__c + Opp_cnt_OTVS190__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>询价数：190主机</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Opp_cnt_290MiroBF__c</fullName>
|
<externalId>false</externalId>
|
<label>询价数：290镜子BF</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Opp_cnt_290MiroGI_CF__c</fullName>
|
<externalId>false</externalId>
|
<label>询价数：下消化放大内镜</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Opp_cnt_290MiroGI_Plus__c</fullName>
|
<externalId>false</externalId>
|
<label>询价数：上消化放大内镜</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Opp_cnt_290MiroGI__c</fullName>
|
<externalId>false</externalId>
|
<label>询价数：SIF-H290S</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Opp_cnt_290Miro_F__c</fullName>
|
<externalId>false</externalId>
|
<formula>Opp_cnt_290MiroBF__c + Opp_cnt_290MiroGI__c + Opp_cnt_290MiroGI_CF__c + Opp_cnt_290MiroGI_Plus__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>询价数：290镜子（公式）</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Opp_cnt_290Miro__c</fullName>
|
<externalId>false</externalId>
|
<label>询价数：290镜子</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Opp_cnt_3D__c</fullName>
|
<externalId>false</externalId>
|
<label>询价数：3D</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Opp_cnt_CHS400XZ__c</fullName>
|
<externalId>false</externalId>
|
<label>询价数：CH-S400-XZ</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Opp_cnt_CV170__c</fullName>
|
<externalId>false</externalId>
|
<label>询价数：CV-170</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Opp_cnt_CV190__c</fullName>
|
<externalId>false</externalId>
|
<label>询价数：CV-190</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Opp_cnt_CV290__c</fullName>
|
<externalId>false</externalId>
|
<label>询价数：CV-290</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Opp_cnt_CYF__c</fullName>
|
<externalId>false</externalId>
|
<label>询价数：CYF</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Opp_cnt_ENG__c</fullName>
|
<externalId>false</externalId>
|
<formula>Opp_cnt_ESG400__c + Opp_cnt_USG400__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>询价数：ENG主机</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Opp_cnt_ESG400__c</fullName>
|
<externalId>false</externalId>
|
<label>询价数：ESG-400</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Opp_cnt_EUME2__c</fullName>
|
<externalId>false</externalId>
|
<label>询价数：EU-ME2</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Opp_cnt_GFUCT260__c</fullName>
|
<externalId>false</externalId>
|
<label>询价数：GF-UCT260</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Opp_cnt_GW__c</fullName>
|
<externalId>false</externalId>
|
<label>询价数：导丝(GW)</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Opp_cnt_OERAW__c</fullName>
|
<externalId>false</externalId>
|
<label>询价数：OER-AW</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Opp_cnt_OTVS190__c</fullName>
|
<externalId>false</externalId>
|
<label>询价数：OTV-S190</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Opp_cnt_OTVS300400__c</fullName>
|
<externalId>false</externalId>
|
<formula>Opp_cnt_OTVS400__c + Opp_cnt_OTVS300__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>询价数：OTV-S300/S400</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Opp_cnt_OTVS300__c</fullName>
|
<externalId>false</externalId>
|
<label>询价数：OTV-S300</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Opp_cnt_OTVS400__c</fullName>
|
<externalId>false</externalId>
|
<label>询价数：OTV-S400</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Opp_cnt_TB__c</fullName>
|
<externalId>false</externalId>
|
<label>询价数：TB</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Opp_cnt_UCES3__c</fullName>
|
<externalId>false</externalId>
|
<label>询价数：UCES-3</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Opp_cnt_USG400__c</fullName>
|
<externalId>false</externalId>
|
<label>询价数：USG-400</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Opportunity_ThousandY__c</fullName>
|
<externalId>false</externalId>
|
<label>6.发货+注残+询价(不含税,千元)</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>2</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Order_cnt_190Main__c</fullName>
|
<externalId>false</externalId>
|
<formula>Order_cnt_CV190__c + Order_cnt_OTVS190__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>订货数：190主机</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Order_cnt_290MiroBF__c</fullName>
|
<externalId>false</externalId>
|
<label>订货数：290镜子BF</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Order_cnt_290MiroGI_CF__c</fullName>
|
<externalId>false</externalId>
|
<label>订货数：下消化放大内镜</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Order_cnt_290MiroGI_Plus__c</fullName>
|
<externalId>false</externalId>
|
<label>订货数：上消化放大内镜</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Order_cnt_290MiroGI__c</fullName>
|
<externalId>false</externalId>
|
<label>订货数：SIF-H290S</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Order_cnt_290Miro_F__c</fullName>
|
<externalId>false</externalId>
|
<formula>Order_cnt_290MiroBF__c + Order_cnt_290MiroGI__c + Order_cnt_290MiroGI_CF__c + Order_cnt_290MiroGI_Plus__c</formula>
|
<label>订货数：290镜子（公式）</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Order_cnt_290Miro__c</fullName>
|
<externalId>false</externalId>
|
<label>订货数：290镜子</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Order_cnt_3D__c</fullName>
|
<externalId>false</externalId>
|
<label>订货数：3D</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Order_cnt_CHS400XZ__c</fullName>
|
<externalId>false</externalId>
|
<label>订货数：CH-S400-XZ</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Order_cnt_CV170__c</fullName>
|
<externalId>false</externalId>
|
<label>订货数：CV-170</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Order_cnt_CV190__c</fullName>
|
<externalId>false</externalId>
|
<label>订货数：CV-190</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Order_cnt_CV290__c</fullName>
|
<externalId>false</externalId>
|
<label>订货数：CV-290</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Order_cnt_CYF__c</fullName>
|
<externalId>false</externalId>
|
<label>订货数：CYF</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Order_cnt_ENG__c</fullName>
|
<externalId>false</externalId>
|
<formula>Order_cnt_ESG400__c + Order_cnt_USG400__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>订货数：ENG主机</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Order_cnt_ESG400__c</fullName>
|
<externalId>false</externalId>
|
<label>订货数：ESG-400</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Order_cnt_EUME2__c</fullName>
|
<externalId>false</externalId>
|
<label>订货数：EU-ME2</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Order_cnt_GFUCT260__c</fullName>
|
<externalId>false</externalId>
|
<label>订货数：GF-UCT260</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Order_cnt_GW__c</fullName>
|
<externalId>false</externalId>
|
<label>订货数：导丝(GW)</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Order_cnt_OERAW__c</fullName>
|
<externalId>false</externalId>
|
<label>订货数：OER-AW</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Order_cnt_OTVS190__c</fullName>
|
<externalId>false</externalId>
|
<label>订货数：OTV-S190</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Order_cnt_OTVS300400__c</fullName>
|
<externalId>false</externalId>
|
<formula>Order_cnt_OTVS300__c + Order_cnt_OTVS400__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>订货数：OTV-S300/S400</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Order_cnt_OTVS300__c</fullName>
|
<externalId>false</externalId>
|
<label>订货数：OTV-S300</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Order_cnt_OTVS400__c</fullName>
|
<externalId>false</externalId>
|
<label>订货数：OTV-S400</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Order_cnt_TB__c</fullName>
|
<externalId>false</externalId>
|
<label>订货数：TB</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Order_cnt_UCES3__c</fullName>
|
<externalId>false</externalId>
|
<label>订货数：UCES-3</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Order_cnt_USG400__c</fullName>
|
<externalId>false</externalId>
|
<label>订货数：USG-400</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>PAAverageCoverageRate__c</fullName>
|
<externalId>false</externalId>
|
<formula>if(Year(today()) > OCSMYear__c || MONTH(today())-4 > 5, (MonthVisitCoverageRate4Text__c + MonthVisitCoverageRate5Text__c+ MonthVisitCoverageRate6Text__c+ MonthVisitCoverageRate7Text__c+ MonthVisitCoverageRate8Text__c+ MonthVisitCoverageRate9Text__c)/6,
|
if( MONTH(today()) = 4, 0
|
,
|
(MonthVisitCoverageRate4Text__c
|
+
|
if(if(MONTH(today())-4< 0, MONTH(today())+8, MONTH(today())-4)> 1,MonthVisitCoverageRate5Text__c ,0)
|
+
|
if(if(MONTH(today())-4< 0, MONTH(today())+8, MONTH(today())-4)> 2,MonthVisitCoverageRate6Text__c ,0)
|
+
|
if(if(MONTH(today())-4< 0, MONTH(today())+8, MONTH(today())-4)> 3,MonthVisitCoverageRate7Text__c ,0)
|
+
|
if(if(MONTH(today())-4< 0, MONTH(today())+8, MONTH(today())-4)> 4,MonthVisitCoverageRate8Text__c ,0)
|
+
|
if(if(MONTH(today())-4< 0, MONTH(today())+8, MONTH(today())-4)> 5,MonthVisitCoverageRate9Text__c ,0)
|
)
|
/if(MONTH(today())-4< 0, MONTH(today())+8, MONTH(today())-4)
|
))</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>覆盖率（1H'）</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Percent</type>
|
</fields>
|
<fields>
|
<fullName>PAENGAverageCoverageRate__c</fullName>
|
<externalId>false</externalId>
|
<formula>if(Year(today()) > OCSMYear__c || MONTH(today())-4 > 5, (MonthVisitCoverageRate4_ENG_Text__c + MonthVisitCoverageRate5_ENG_Text__c+ MonthVisitCoverageRate6_ENG_Text__c+ MonthVisitCoverageRate7_ENG_Text__c+ MonthVisitCoverageRate8_ENG_Text__c+ MonthVisitCoverageRate9_ENG_Text__c)/6,
|
if( MONTH(today()) = 4, 0
|
,
|
(MonthVisitCoverageRate4_ENG_Text__c
|
+
|
if(if(MONTH(today())-4< 0, MONTH(today())+8, MONTH(today())-4)> 1,MonthVisitCoverageRate5_ENG_Text__c ,0)
|
+
|
if(if(MONTH(today())-4< 0, MONTH(today())+8, MONTH(today())-4)> 2,MonthVisitCoverageRate6_ENG_Text__c ,0)
|
+
|
if(if(MONTH(today())-4< 0, MONTH(today())+8, MONTH(today())-4)> 3,MonthVisitCoverageRate7_ENG_Text__c ,0)
|
+
|
if(if(MONTH(today())-4< 0, MONTH(today())+8, MONTH(today())-4)> 4,MonthVisitCoverageRate8_ENG_Text__c ,0)
|
+
|
if(if(MONTH(today())-4< 0, MONTH(today())+8, MONTH(today())-4)> 5,MonthVisitCoverageRate9_ENG_Text__c ,0)
|
)
|
/if(MONTH(today())-4< 0, MONTH(today())+8, MONTH(today())-4)
|
))</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>覆盖率（PA能量）</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Percent</type>
|
</fields>
|
<fields>
|
<fullName>PBAverageCoverageRate__c</fullName>
|
<externalId>false</externalId>
|
<formula>if(Year(today()) > OCSMYear__c + 1 || Year(today()) > OCSMYear__c && MONTH(today()) > 3, (MonthVisitCoverageRate10Text__c+ MonthVisitCoverageRate11Text__c+ MonthVisitCoverageRate12Text__c+ MonthVisitCoverageRate1Text__c+ MonthVisitCoverageRate2Text__c+ MonthVisitCoverageRate3Text__c)/6,
|
if( MONTH(today()) = 10 , 0
|
,
|
|
(if(if(MONTH(today())-4< 0, MONTH(today())+8, MONTH(today())-4)> 6,MonthVisitCoverageRate10Text__c ,0)
|
+
|
if(if(MONTH(today())-4< 0, MONTH(today())+8, MONTH(today())-4)> 7,MonthVisitCoverageRate11Text__c ,0)
|
+
|
if(if(MONTH(today())-4< 0, MONTH(today())+8, MONTH(today())-4)> 8,MonthVisitCoverageRate12Text__c ,0)
|
+
|
if(if(MONTH(today())-4< 0, MONTH(today())+8, MONTH(today())-4)> 9,MonthVisitCoverageRate1Text__c ,0)
|
+
|
if(if(MONTH(today())-4< 0, MONTH(today())+8, MONTH(today())-4)> 10,MonthVisitCoverageRate2Text__c ,0)
|
)
|
/if(MONTH(today())-4< 0, MONTH(today())+2, MONTH(today())-10)
|
))</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>覆盖率（2H’）</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Percent</type>
|
</fields>
|
<fields>
|
<fullName>PBENGAverageCoverageRate__c</fullName>
|
<externalId>false</externalId>
|
<formula>if(Year(today()) > OCSMYear__c + 1 || Year(today()) > OCSMYear__c && MONTH(today()) > 3, (MonthVisitCoverageRate10_ENG_Text__c+ MonthVisitCoverageRate11_ENG_Text__c+ MonthVisitCoverageRate12_ENG_Text__c+ MonthVisitCoverageRate1_ENG_Text__c+ MonthVisitCoverageRate2_ENG_Text__c+ MonthVisitCoverageRate3_ENG_Text__c)/6,
|
if( MONTH(today()) = 10 , 0
|
,
|
|
(if(if(MONTH(today())-4< 0, MONTH(today())+8, MONTH(today())-4)> 6,MonthVisitCoverageRate10_ENG_Text__c ,0)
|
+
|
if(if(MONTH(today())-4< 0, MONTH(today())+8, MONTH(today())-4)> 7,MonthVisitCoverageRate11_ENG_Text__c ,0)
|
+
|
if(if(MONTH(today())-4< 0, MONTH(today())+8, MONTH(today())-4)> 8,MonthVisitCoverageRate12_ENG_Text__c ,0)
|
+
|
if(if(MONTH(today())-4< 0, MONTH(today())+8, MONTH(today())-4)> 9,MonthVisitCoverageRate1_ENG_Text__c ,0)
|
+
|
if(if(MONTH(today())-4< 0, MONTH(today())+8, MONTH(today())-4)> 10,MonthVisitCoverageRate2_ENG_Text__c ,0)
|
)
|
/if(MONTH(today())-4< 0, MONTH(today())+2, MONTH(today())-10)
|
))</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>覆盖率（PB能量）</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Percent</type>
|
</fields>
|
<fields>
|
<fullName>ProductDetails__c</fullName>
|
<externalId>false</externalId>
|
<formula>if(Text(OPD_PlanMonth_190Main__c)='4月','190主机;','')
|
|
+if(Text(OPD_PlanMonth_290Miro__c)='4月','290镜子;','')
|
|
+if(Text(OPD_PlanMonth_CV170__c)='4月','CV-170;','')
|
|
+if(Text(OPD_PlanMonth_CV290__c)='4月','CV-290;','')
|
|
+if(Text(OPD_PlanMonth_ENG__c)='4月','ENG主机;','')
|
|
+if(Text(OPD_PlanMonth_EUME2__c)='4月','EU-ME2;','')
|
|
+if(Text(OPD_PlanMonth_GFUCT260__c)='4月','GF-UCT260;','')
|
|
+if(Text(OPD_PlanMonth_OTVS300S400__c)='4月','OTV-S300/S400;','')</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>产品明细(不用)</label>
|
<required>false</required>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Product_Leader__c</fullName>
|
<deleteConstraint>SetNull</deleteConstraint>
|
<externalId>false</externalId>
|
<label>产品担当</label>
|
<referenceTo>User</referenceTo>
|
<relationshipName>ProductleadertargetAccount</relationshipName>
|
<required>false</required>
|
<trackTrending>false</trackTrending>
|
<type>Lookup</type>
|
</fields>
|
<fields>
|
<fullName>Proposal_Submit_Status__c</fullName>
|
<externalId>false</externalId>
|
<label>提案书提交情况</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Proposal_target_customer__c</fullName>
|
<externalId>false</externalId>
|
<label>提案目标客户</label>
|
<required>false</required>
|
<trackTrending>false</trackTrending>
|
<type>Picklist</type>
|
<valueSet>
|
<restricted>true</restricted>
|
<valueSetDefinition>
|
<sorted>false</sorted>
|
<value>
|
<fullName>是</fullName>
|
<default>false</default>
|
<label>是</label>
|
</value>
|
<value>
|
<fullName>否</fullName>
|
<default>false</default>
|
<label>否</label>
|
</value>
|
</valueSetDefinition>
|
</valueSet>
|
</fields>
|
<fields>
|
<fullName>Proposal_target_customer_number__c</fullName>
|
<externalId>false</externalId>
|
<label>提案目标客户数</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Rental_Cnt_190Main__c</fullName>
|
<externalId>false</externalId>
|
<formula>if(Rental_Cnt_CV190__c+Rental_Cnt_OTVS190__c = 0, null, Rental_Cnt_CV190__c+Rental_Cnt_OTVS190__c)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>出借次数：190主机</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Rental_Cnt_290MiroBF__c</fullName>
|
<externalId>false</externalId>
|
<label>出借次数：290镜子BF</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Rental_Cnt_290MiroGI_CF__c</fullName>
|
<externalId>false</externalId>
|
<label>出借次数：下消化放大内镜</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Rental_Cnt_290MiroGI_Plus__c</fullName>
|
<externalId>false</externalId>
|
<label>出借次数：上消化放大内镜</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Rental_Cnt_290MiroGI__c</fullName>
|
<externalId>false</externalId>
|
<label>出借次数：SIF-H290S</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Rental_Cnt_290Miro_F__c</fullName>
|
<externalId>false</externalId>
|
<formula>if(Rental_Cnt_290MiroBF__c +Rental_Cnt_290MiroGI__c + Rental_Cnt_290MiroGI_CF__c + Rental_Cnt_290MiroGI_Plus__c = 0, null, Rental_Cnt_290MiroBF__c +Rental_Cnt_290MiroGI__c + Rental_Cnt_290MiroGI_CF__c + Rental_Cnt_290MiroGI_Plus__c)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>出借次数：290镜子（公式）</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Rental_Cnt_CV170__c</fullName>
|
<externalId>false</externalId>
|
<label>出借次数：CV-170</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Rental_Cnt_CV190__c</fullName>
|
<externalId>false</externalId>
|
<label>出借次数：CV-190</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Rental_Cnt_CV290__c</fullName>
|
<externalId>false</externalId>
|
<label>出借次数：CV-290</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Rental_Cnt_ENG__c</fullName>
|
<externalId>false</externalId>
|
<formula>if(Rental_Cnt_ESG400__c + Rental_Cnt_USG400__c = 0, null, Rental_Cnt_ESG400__c + Rental_Cnt_USG400__c)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>出借次数：ENG主机</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Rental_Cnt_ESG400__c</fullName>
|
<externalId>false</externalId>
|
<label>出借次数：ESG-400</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Rental_Cnt_EUME2__c</fullName>
|
<externalId>false</externalId>
|
<label>出借次数：EU-ME2</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Rental_Cnt_GFUCT260__c</fullName>
|
<externalId>false</externalId>
|
<label>出借次数：GF-UCT260</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Rental_Cnt_OTVS190__c</fullName>
|
<externalId>false</externalId>
|
<label>出借次数：OTV-S190</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Rental_Cnt_OTVS300400__c</fullName>
|
<externalId>false</externalId>
|
<formula>if(Rental_Cnt_OTVS300__c+Rental_Cnt_OTVS400__c=0, null, Rental_Cnt_OTVS300__c+Rental_Cnt_OTVS400__c)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>出借次数：OTV-S300/S400</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Rental_Cnt_OTVS300__c</fullName>
|
<externalId>false</externalId>
|
<label>出借次数：OTV-S300</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Rental_Cnt_OTVS400__c</fullName>
|
<externalId>false</externalId>
|
<label>出借次数：OTV-S400 4K主机</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Rental_Cnt_TB__c</fullName>
|
<externalId>false</externalId>
|
<label>出借次数：TB</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Rental_Cnt_USG400__c</fullName>
|
<externalId>false</externalId>
|
<label>出借次数：USG-400</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>RivalCustomers__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(RivalHostsProportion__c == 1,
|
'完全对手客户',
|
IF(RivalHostsProportion__c >= 0.5,
|
'部分对手客户',
|
''
|
)
|
)</formula>
|
<label>对手客户</label>
|
<required>false</required>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>RivalCustomers_first__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF( RivalHostsProportion_first__c == 1, '完全对手客户', IF( RivalHostsProportion_first__c > 0.5, '部分对手客户',''))</formula>
|
<label>对手客户（期初）</label>
|
<required>false</required>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>RivalHostsNumber__c</fullName>
|
<externalId>false</externalId>
|
<label>对手主机数</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>RivalHostsNumber_first__c</fullName>
|
<externalId>false</externalId>
|
<label>对手主机数（期初）</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>RivalHostsProportion__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(!ISNULL(RivalHostsNumber__c) && !ISNULL(AllHostsNumber__c) && AllHostsNumber__c > 0,
|
RivalHostsNumber__c / AllHostsNumber__c,
|
null
|
)</formula>
|
<label>对手主机占比</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>2</scale>
|
<trackTrending>false</trackTrending>
|
<type>Percent</type>
|
</fields>
|
<fields>
|
<fullName>RivalHostsProportion_first__c</fullName>
|
<externalId>false</externalId>
|
<formula>( RivalHostsNumber_first__c / AllHostsNumber_first__c )</formula>
|
<label>对手主机占比（期初）</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>2</scale>
|
<trackTrending>false</trackTrending>
|
<type>Percent</type>
|
</fields>
|
<fields>
|
<fullName>Sales_target_170_190__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(NOT(ISBLANK(Target_amount_170_190__c)) && Target_amount_170_190__c > 0, 1, 0)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>目标客户：170/190</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Sales_target_190Main__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(NOT(ISBLANK(Target_amount_190Main__c)) && Target_amount_190Main__c > 0, 1, 0)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>目标客户：190主机</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Sales_target_290Miro__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(NOT(ISBLANK(Target_amount_290Miro__c)) && Target_amount_290Miro__c > 0, 1, 0)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>目标客户：290镜子</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Sales_target_3D__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(NOT(ISBLANK(Target_amount_3D__c)) && Target_amount_3D__c > 0, 1, 0)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>目标客户：3D</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Sales_target_CHS400XZ__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(NOT(ISBLANK(Target_amount_CHS400XZ__c)) && Target_amount_CHS400XZ__c > 0, 1, 0)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>目标客户：CH-S400-XZ</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Sales_target_CV170__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(NOT(ISBLANK(Target_amount_CV170__c)) && Target_amount_CV170__c > 0, 1, 0)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>目标客户：CV-170</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Sales_target_CV190__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(NOT(ISBLANK(Target_amount_CV190__c)) && Target_amount_CV190__c > 0, 1, 0)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>目标客户：CV-190</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Sales_target_CV290__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(NOT(ISBLANK(Target_amount_CV290__c)) && Target_amount_CV290__c > 0, 1, 0)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>目标客户：CV-290</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Sales_target_CYF__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(NOT(ISBLANK(Target_amount_CYF__c)) && Target_amount_CYF__c > 0, 1, 0)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>目标客户：CYF</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Sales_target_ENG__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(NOT(ISBLANK(Target_amount_ENG__c)) && Target_amount_ENG__c > 0, 1, 0)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>目标客户：ENG主机</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Sales_target_ESG400__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(NOT(ISBLANK(Target_amount_ESG400__c)) && Target_amount_ESG400__c > 0, 1, 0)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>目标客户：ESG-400</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Sales_target_EUME2__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(NOT(ISBLANK(Target_amount_EUME2__c)) && Target_amount_EUME2__c > 0, 1, 0)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>目标客户：EU-ME2</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Sales_target_GFUCT260__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(NOT(ISBLANK(Target_amount_GFUCT260__c)) && Target_amount_GFUCT260__c > 0, 1, 0)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>目标客户：GF-UCT260</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Sales_target_GW__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(NOT(ISBLANK(Target_amount_GW__c)) && Target_amount_GW__c > 0, 1, 0)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>目标客户：导丝(GW)</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Sales_target_OERAW__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(NOT(ISBLANK(Target_amount_OERAW__c)) && Target_amount_OERAW__c > 0, 1, 0)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>目标客户：OER-AW</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Sales_target_OTVS190__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(NOT(ISBLANK(Target_amount_OTVS190__c)) && Target_amount_OTVS190__c > 0, 1, 0)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>目标客户：OTV-S190</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Sales_target_OTVS300S400__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(NOT(ISBLANK(Target_amount_OTVS300S400__c)) && Target_amount_OTVS300S400__c > 0, 1, 0)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>目标客户：OTV-S300/S400</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Sales_target_OTVS300__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(NOT(ISBLANK(Target_amount_OTVS300__c)) && Target_amount_OTVS300__c > 0, 1, 0)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>目标客户：OTV-S300</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Sales_target_OTVS400__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(NOT(ISBLANK(Target_amount_OTVS400__c)) && Target_amount_OTVS400__c > 0, 1, 0)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>目标客户：OTV-S400</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Sales_target_TB__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(NOT(ISBLANK(Target_amount_TB__c)) && Target_amount_TB__c > 0, 1, 0)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>目标客户：TB</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Sales_target_UCES3__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(NOT(ISBLANK(Target_amount_UCES3__c)) && Target_amount_UCES3__c > 0, 1, 0)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>目标客户：UCES-3</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Sales_target_USG400__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(NOT(ISBLANK(Target_amount_USG400__c)) && Target_amount_USG400__c > 0, 1, 0)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>目标客户：USG-400</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Submit_Customer_target__c</fullName>
|
<defaultValue>false</defaultValue>
|
<externalId>false</externalId>
|
<label>计划申请(销售)</label>
|
<trackTrending>false</trackTrending>
|
<type>Checkbox</type>
|
</fields>
|
<fields>
|
<fullName>Submit_Customer_target_new__c</fullName>
|
<externalId>false</externalId>
|
<formula>Target_amount_CV290__c > 0 ||
|
Target_amount_EUME2__c > 0 ||
|
Target_amount_290Miro__c > 0 ||
|
Target_amount_GFUCT260__c > 0 ||
|
Target_amount_OTVS300S400__c > 0 ||
|
Target_amount_CV170__c > 0 ||
|
Target_amount_190Main__c > 0 ||
|
Target_amount_ENG__c> 0 ||
|
Target_amount_TB__c > 0 ||
|
OPD_CV290__c > 0 ||
|
OPD_EUME2__c > 0 ||
|
OPD_290Miro__c > 0 ||
|
OPD_GFUCT260__c > 0 ||
|
OPD_OTVS300S400__c > 0 ||
|
OPD_CV170__c > 0 ||
|
OPD_190Main__c > 0 ||
|
OPD_ENG__c> 0 ||
|
OPD_TB__c > 0 || Department_Budget_Sum_Price__c > 0</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>目标客户确认</label>
|
<trackTrending>false</trackTrending>
|
<type>Checkbox</type>
|
</fields>
|
<fields>
|
<fullName>Submit_proposal_document_SD__c</fullName>
|
<externalId>false</externalId>
|
<label>是否提交提案书</label>
|
<length>255</length>
|
<required>false</required>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Submit_proposal_document__c</fullName>
|
<externalId>false</externalId>
|
<label>是否提交提案书(医院)</label>
|
<length>255</length>
|
<required>false</required>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>TargetCustomerMTIME__c</fullName>
|
<externalId>false</externalId>
|
<label>目标客户修改时间</label>
|
<length>255</length>
|
<required>false</required>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>TargetCustomerModifier__c</fullName>
|
<deleteConstraint>SetNull</deleteConstraint>
|
<externalId>false</externalId>
|
<label>目标客户修改人</label>
|
<referenceTo>User</referenceTo>
|
<relationshipName>SublevelTargetCustomerModifier</relationshipName>
|
<required>false</required>
|
<trackTrending>false</trackTrending>
|
<type>Lookup</type>
|
</fields>
|
<fields>
|
<fullName>Target_amount_170_190__c</fullName>
|
<externalId>false</externalId>
|
<label>目标数：170/190</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Target_amount_190Main_F__c</fullName>
|
<externalId>false</externalId>
|
<formula>Target_amount_CV190__c + Target_amount_OTVS190__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>目标数：190主机(公式)</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Target_amount_190Main__c</fullName>
|
<externalId>false</externalId>
|
<label>目标数：190主机</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Target_amount_290Miro__c</fullName>
|
<externalId>false</externalId>
|
<label>目标数：290镜子</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Target_amount_3D__c</fullName>
|
<externalId>false</externalId>
|
<label>目标数：3D</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Target_amount_CHS400XZ__c</fullName>
|
<externalId>false</externalId>
|
<label>目标数：CH-S400-XZ</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Target_amount_CV170__c</fullName>
|
<externalId>false</externalId>
|
<label>目标数：CV-170</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Target_amount_CV190__c</fullName>
|
<externalId>false</externalId>
|
<label>目标数：CV-190</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Target_amount_CV290__c</fullName>
|
<externalId>false</externalId>
|
<label>目标数：CV-290</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Target_amount_CYF__c</fullName>
|
<externalId>false</externalId>
|
<label>目标数：CYF</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Target_amount_ENG_F__c</fullName>
|
<externalId>false</externalId>
|
<formula>Target_amount_ESG400__c + Target_amount_USG400__c</formula>
|
<label>目标数：ENG主机(公式)</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Target_amount_ENG__c</fullName>
|
<externalId>false</externalId>
|
<label>目标数：ENG主机</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Target_amount_ESG400__c</fullName>
|
<externalId>false</externalId>
|
<label>目标数：ESG-400</label>
|
<precision>10</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Target_amount_EUME2__c</fullName>
|
<externalId>false</externalId>
|
<label>目标数：EU-ME2</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Target_amount_GFUCT260__c</fullName>
|
<externalId>false</externalId>
|
<label>目标数：GF-UCT260</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Target_amount_GW__c</fullName>
|
<externalId>false</externalId>
|
<label>目标数：导丝(GW)</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Target_amount_OERAW__c</fullName>
|
<externalId>false</externalId>
|
<label>目标数：OER-AW</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Target_amount_OTVS190__c</fullName>
|
<externalId>false</externalId>
|
<label>目标数：OTV-S190</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Target_amount_OTVS300S400_F__c</fullName>
|
<externalId>false</externalId>
|
<formula>Target_amount_OTVS300__c + Target_amount_OTVS400__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>目标数：OTV-S300/S400(公式)</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Target_amount_OTVS300S400__c</fullName>
|
<externalId>false</externalId>
|
<label>目标数：OTV-S300/S400</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Target_amount_OTVS300__c</fullName>
|
<externalId>false</externalId>
|
<label>目标数：OTV-S300</label>
|
<precision>10</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Target_amount_OTVS400__c</fullName>
|
<externalId>false</externalId>
|
<label>目标数：OTV-S400</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Target_amount_TB__c</fullName>
|
<externalId>false</externalId>
|
<label>目标数：TB</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Target_amount_UCES3__c</fullName>
|
<externalId>false</externalId>
|
<label>目标数：UCES-3</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Target_amount_USG400__c</fullName>
|
<externalId>false</externalId>
|
<label>目标数：USG-400</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>X170_190__c</fullName>
|
<description>20190719备份
|
Order_cnt_CV170__c + Order_cnt_CV190__c + Order_cnt_OTVS190__c</description>
|
<externalId>false</externalId>
|
<formula>Order_cnt_CV170__c + Order_cnt_CV190__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>订货数：170/190</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>annualAverageCoverageRate__c</fullName>
|
<externalId>false</externalId>
|
<formula>if( Year(today()) > OCSMYear__c + 1 || Year(today()) > OCSMYear__c && MONTH(today()) > 3, (MonthVisitCoverageRate4Text__c + MonthVisitCoverageRate5Text__c+ MonthVisitCoverageRate6Text__c+ MonthVisitCoverageRate7Text__c+ MonthVisitCoverageRate8Text__c+ MonthVisitCoverageRate9Text__c+ MonthVisitCoverageRate10Text__c+ MonthVisitCoverageRate11Text__c+ MonthVisitCoverageRate12Text__c+ MonthVisitCoverageRate1Text__c+ MonthVisitCoverageRate2Text__c+ MonthVisitCoverageRate3Text__c)/12,
|
if( MONTH(today()) = 4, 0
|
,
|
(MonthVisitCoverageRate4Text__c
|
+
|
if(if(MONTH(today())-4< 0, MONTH(today())+8, MONTH(today())-4)> 1,MonthVisitCoverageRate5Text__c ,0)
|
+
|
if(if(MONTH(today())-4< 0, MONTH(today())+8, MONTH(today())-4)> 2,MonthVisitCoverageRate6Text__c ,0)
|
+
|
if(if(MONTH(today())-4< 0, MONTH(today())+8, MONTH(today())-4)> 3,MonthVisitCoverageRate7Text__c ,0)
|
+
|
if(if(MONTH(today())-4< 0, MONTH(today())+8, MONTH(today())-4)> 4,MonthVisitCoverageRate8Text__c ,0)
|
+
|
if(if(MONTH(today())-4< 0, MONTH(today())+8, MONTH(today())-4)> 5,MonthVisitCoverageRate9Text__c ,0)
|
+
|
if(if(MONTH(today())-4< 0, MONTH(today())+8, MONTH(today())-4)> 6,MonthVisitCoverageRate10Text__c ,0)
|
+
|
if(if(MONTH(today())-4< 0, MONTH(today())+8, MONTH(today())-4)> 7,MonthVisitCoverageRate11Text__c ,0)
|
+
|
if(if(MONTH(today())-4< 0, MONTH(today())+8, MONTH(today())-4)> 8,MonthVisitCoverageRate12Text__c ,0)
|
+
|
if(if(MONTH(today())-4< 0, MONTH(today())+8, MONTH(today())-4)> 9,MonthVisitCoverageRate1Text__c ,0)
|
+
|
if(if(MONTH(today())-4< 0, MONTH(today())+8, MONTH(today())-4)> 10,MonthVisitCoverageRate2Text__c ,0)
|
)
|
/if(MONTH(today())-4< 0, MONTH(today())+8, MONTH(today())-4)
|
))</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>覆盖率（平均）</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Percent</type>
|
</fields>
|
<fields>
|
<fullName>annualENGAverageCoverageRate__c</fullName>
|
<externalId>false</externalId>
|
<formula>if( Year(today()) > OCSMYear__c + 1 || Year(today()) > OCSMYear__c && MONTH(today()) > 3, (MonthVisitCoverageRate4_ENG_Text__c + MonthVisitCoverageRate5_ENG_Text__c+ MonthVisitCoverageRate6_ENG_Text__c+ MonthVisitCoverageRate7_ENG_Text__c+ MonthVisitCoverageRate8_ENG_Text__c+ MonthVisitCoverageRate9_ENG_Text__c+ MonthVisitCoverageRate10_ENG_Text__c+ MonthVisitCoverageRate11_ENG_Text__c+ MonthVisitCoverageRate12_ENG_Text__c+ MonthVisitCoverageRate1_ENG_Text__c+ MonthVisitCoverageRate2_ENG_Text__c+ MonthVisitCoverageRate3_ENG_Text__c)/12,
|
if( MONTH(today()) = 4, 0
|
,
|
(MonthVisitCoverageRate4_ENG_Text__c
|
+
|
if(if(MONTH(today())-4< 0, MONTH(today())+8, MONTH(today())-4)> 1,MonthVisitCoverageRate5_ENG_Text__c ,0)
|
+
|
if(if(MONTH(today())-4< 0, MONTH(today())+8, MONTH(today())-4)> 2,MonthVisitCoverageRate6_ENG_Text__c ,0)
|
+
|
if(if(MONTH(today())-4< 0, MONTH(today())+8, MONTH(today())-4)> 3,MonthVisitCoverageRate7_ENG_Text__c ,0)
|
+
|
if(if(MONTH(today())-4< 0, MONTH(today())+8, MONTH(today())-4)> 4,MonthVisitCoverageRate8_ENG_Text__c ,0)
|
+
|
if(if(MONTH(today())-4< 0, MONTH(today())+8, MONTH(today())-4)> 5,MonthVisitCoverageRate9_ENG_Text__c ,0)
|
+
|
if(if(MONTH(today())-4< 0, MONTH(today())+8, MONTH(today())-4)> 6,MonthVisitCoverageRate10_ENG_Text__c ,0)
|
+
|
if(if(MONTH(today())-4< 0, MONTH(today())+8, MONTH(today())-4)> 7,MonthVisitCoverageRate11_ENG_Text__c ,0)
|
+
|
if(if(MONTH(today())-4< 0, MONTH(today())+8, MONTH(today())-4)> 8,MonthVisitCoverageRate12_ENG_Text__c ,0)
|
+
|
if(if(MONTH(today())-4< 0, MONTH(today())+8, MONTH(today())-4)> 9,MonthVisitCoverageRate1_ENG_Text__c ,0)
|
+
|
if(if(MONTH(today())-4< 0, MONTH(today())+8, MONTH(today())-4)> 10,MonthVisitCoverageRate2_ENG_Text__c ,0)
|
)
|
/if(MONTH(today())-4< 0, MONTH(today())+8, MONTH(today())-4)
|
))</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>覆盖率（平均能量）</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Percent</type>
|
</fields>
|
<label>客户-目标客户</label>
|
<listViews>
|
<fullName>BF</fullName>
|
<columns>NAME</columns>
|
<columns>Account_HP__c</columns>
|
<columns>OCM_Category__c</columns>
|
<columns>Department_Budget_Sum_Price__c</columns>
|
<columns>Target_amount_CV290__c</columns>
|
<columns>OPD_CV290__c</columns>
|
<columns>Target_amount_EUME2__c</columns>
|
<columns>OPD_EUME2__c</columns>
|
<columns>Target_amount_OERAW__c</columns>
|
<columns>OPD_OERAW__c</columns>
|
<columns>Proposal_target_customer__c</columns>
|
<columns>Submit_Customer_target__c</columns>
|
<filterScope>Everything</filterScope>
|
<filters>
|
<field>Account_HP__c</field>
|
<operation>notContain</operation>
|
<value>TEST,OLYMPUS</value>
|
</filters>
|
<filters>
|
<field>Account__c</field>
|
<operation>contains</operation>
|
<value>呼吸科</value>
|
</filters>
|
<filters>
|
<field>OCM_Period__c</field>
|
<operation>equals</operation>
|
<value>152P</value>
|
</filters>
|
<filters>
|
<field>OCM_Category__c</field>
|
<operation>contains</operation>
|
<value>H,M</value>
|
</filters>
|
<label>2.呼吸科</label>
|
<language>zh_CN</language>
|
</listViews>
|
<listViews>
|
<fullName>ENT_OPD</fullName>
|
<columns>Account_HP__c</columns>
|
<columns>OCM_Category__c</columns>
|
<columns>Department_Budget_Sum_Price__c</columns>
|
<columns>Target_amount_OTVS400__c</columns>
|
<columns>OPD_OTVS400__c</columns>
|
<columns>Target_amount_3D__c</columns>
|
<columns>OPD_3D__c</columns>
|
<columns>Target_amount_CYF__c</columns>
|
<columns>OPD_amount_CYF__c</columns>
|
<columns>Proposal_target_customer_number__c</columns>
|
<columns>Submit_Customer_target__c</columns>
|
<filterScope>Everything</filterScope>
|
<filters>
|
<field>Account_HP__c</field>
|
<operation>notContain</operation>
|
<value>TEST,OLYMPUS</value>
|
</filters>
|
<filters>
|
<field>Account__c</field>
|
<operation>contains</operation>
|
<value>耳鼻喉科</value>
|
</filters>
|
<filters>
|
<field>OCM_Period__c</field>
|
<operation>equals</operation>
|
<value>152P</value>
|
</filters>
|
<filters>
|
<field>OCM_Category__c</field>
|
<operation>contains</operation>
|
<value>H,M</value>
|
</filters>
|
<label>6.耳鼻喉科</label>
|
<language>zh_CN</language>
|
</listViews>
|
<listViews>
|
<fullName>GI</fullName>
|
<columns>Account__c</columns>
|
<columns>OCM_Category__c</columns>
|
<columns>Department_Budget_Sum_Price__c</columns>
|
<columns>Target_amount_CV290__c</columns>
|
<columns>OPD_CV290__c</columns>
|
<columns>Target_amount_EUME2__c</columns>
|
<columns>OPD_EUME2__c</columns>
|
<columns>Target_amount_OERAW__c</columns>
|
<columns>OPD_OERAW__c</columns>
|
<columns>Proposal_target_customer__c</columns>
|
<columns>Submit_Customer_target__c</columns>
|
<filterScope>Everything</filterScope>
|
<filters>
|
<field>Account_HP__c</field>
|
<operation>notContain</operation>
|
<value>TEST,OLYMPUS</value>
|
</filters>
|
<filters>
|
<field>Account__c</field>
|
<operation>contains</operation>
|
<value>消化科</value>
|
</filters>
|
<filters>
|
<field>OCM_Period__c</field>
|
<operation>equals</operation>
|
<value>152P</value>
|
</filters>
|
<filters>
|
<field>OCM_Category__c</field>
|
<operation>contains</operation>
|
<value>H,M</value>
|
</filters>
|
<label>1.消化科</label>
|
<language>zh_CN</language>
|
</listViews>
|
<listViews>
|
<fullName>GS_ENG</fullName>
|
<columns>Account__c</columns>
|
<columns>OCM_Category__c</columns>
|
<columns>Target_amount_USG400__c</columns>
|
<columns>OPD_USG400__c</columns>
|
<columns>Submit_Customer_target__c</columns>
|
<filterScope>Everything</filterScope>
|
<filters>
|
<field>Account_HP__c</field>
|
<operation>notContain</operation>
|
<value>TEST,OLYMPUS</value>
|
</filters>
|
<filters>
|
<field>Account__c</field>
|
<operation>contains</operation>
|
<value>普外科,妇科,泌尿,耳鼻喉</value>
|
</filters>
|
<filters>
|
<field>OCM_Period__c</field>
|
<operation>equals</operation>
|
<value>152P</value>
|
</filters>
|
<filters>
|
<field>OCM_Category__c</field>
|
<operation>contains</operation>
|
<value>H,M</value>
|
</filters>
|
<label>7.能量</label>
|
<language>zh_CN</language>
|
</listViews>
|
<listViews>
|
<fullName>GS_OPD</fullName>
|
<columns>Account_HP__c</columns>
|
<columns>OCM_Category__c</columns>
|
<columns>Department_Budget_Sum_Price__c</columns>
|
<columns>Target_amount_OTVS400__c</columns>
|
<columns>OPD_OTVS400__c</columns>
|
<columns>Target_amount_3D__c</columns>
|
<columns>OPD_3D__c</columns>
|
<columns>Target_amount_CYF__c</columns>
|
<columns>OPD_amount_CYF__c</columns>
|
<columns>Proposal_target_customer_number__c</columns>
|
<columns>Submit_Customer_target__c</columns>
|
<filterScope>Everything</filterScope>
|
<filters>
|
<field>Account_HP__c</field>
|
<operation>notContain</operation>
|
<value>TEST,OLYMPUS</value>
|
</filters>
|
<filters>
|
<field>Account__c</field>
|
<operation>contains</operation>
|
<value>普外科</value>
|
</filters>
|
<filters>
|
<field>OCM_Period__c</field>
|
<operation>equals</operation>
|
<value>152P</value>
|
</filters>
|
<filters>
|
<field>OCM_Category__c</field>
|
<operation>contains</operation>
|
<value>H,M</value>
|
</filters>
|
<label>3.普外科</label>
|
<language>zh_CN</language>
|
</listViews>
|
<listViews>
|
<fullName>GYN_OPD</fullName>
|
<columns>Account_HP__c</columns>
|
<columns>OCM_Category__c</columns>
|
<columns>Department_Budget_Sum_Price__c</columns>
|
<columns>Target_amount_OTVS400__c</columns>
|
<columns>OPD_OTVS400__c</columns>
|
<columns>Target_amount_3D__c</columns>
|
<columns>OPD_3D__c</columns>
|
<columns>Target_amount_CYF__c</columns>
|
<columns>OPD_amount_CYF__c</columns>
|
<columns>Proposal_target_customer_number__c</columns>
|
<columns>Submit_Customer_target__c</columns>
|
<filterScope>Everything</filterScope>
|
<filters>
|
<field>Account_HP__c</field>
|
<operation>notContain</operation>
|
<value>TEST,OLYMPUS</value>
|
</filters>
|
<filters>
|
<field>Account__c</field>
|
<operation>contains</operation>
|
<value>妇科</value>
|
</filters>
|
<filters>
|
<field>OCM_Period__c</field>
|
<operation>equals</operation>
|
<value>152P</value>
|
</filters>
|
<filters>
|
<field>OCM_Category__c</field>
|
<operation>contains</operation>
|
<value>H,M</value>
|
</filters>
|
<label>5.妇科</label>
|
<language>zh_CN</language>
|
</listViews>
|
<listViews>
|
<fullName>URO_OPD</fullName>
|
<columns>Account_HP__c</columns>
|
<columns>OCM_Category__c</columns>
|
<columns>Department_Budget_Sum_Price__c</columns>
|
<columns>Target_amount_OTVS400__c</columns>
|
<columns>OPD_OTVS400__c</columns>
|
<columns>Target_amount_3D__c</columns>
|
<columns>OPD_3D__c</columns>
|
<columns>Target_amount_CYF__c</columns>
|
<columns>OPD_amount_CYF__c</columns>
|
<columns>Proposal_target_customer_number__c</columns>
|
<columns>Submit_Customer_target__c</columns>
|
<filterScope>Everything</filterScope>
|
<filters>
|
<field>Account_HP__c</field>
|
<operation>notContain</operation>
|
<value>TEST,OLYMPUS</value>
|
</filters>
|
<filters>
|
<field>Account__c</field>
|
<operation>contains</operation>
|
<value>泌尿科</value>
|
</filters>
|
<filters>
|
<field>OCM_Period__c</field>
|
<operation>equals</operation>
|
<value>152P</value>
|
</filters>
|
<filters>
|
<field>OCM_Category__c</field>
|
<operation>contains</operation>
|
<value>H,M</value>
|
</filters>
|
<label>4.泌尿科</label>
|
<language>zh_CN</language>
|
</listViews>
|
<nameField>
|
<displayFormat>AT-{YYYY}-{000000}</displayFormat>
|
<label>客户目标管理编号</label>
|
<type>AutoNumber</type>
|
</nameField>
|
<searchLayouts/>
|
<sharingModel>ControlledByParent</sharingModel>
|
<visibility>Public</visibility>
|
</CustomObject>
|
