<?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>false</enableReports>
|
<enableSearch>true</enableSearch>
|
<enableSharing>true</enableSharing>
|
<enableStreamingApi>true</enableStreamingApi>
|
<externalSharingModel>Private</externalSharingModel>
|
<fields>
|
<fullName>AccountName__c</fullName>
|
<externalId>false</externalId>
|
<formula>Account__r.Name</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>客户名</label>
|
<required>false</required>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Account__c</fullName>
|
<deleteConstraint>SetNull</deleteConstraint>
|
<externalId>false</externalId>
|
<label>XXX客户</label>
|
<referenceTo>Account</referenceTo>
|
<relationshipLabel>MB_客户</relationshipLabel>
|
<relationshipName>MB_Account</relationshipName>
|
<required>false</required>
|
<trackTrending>false</trackTrending>
|
<type>Lookup</type>
|
</fields>
|
<fields>
|
<fullName>Account_number__c</fullName>
|
<externalId>false</externalId>
|
<formula>1</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>客户数</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>BF_Competitor_endoscopy_room__c</fullName>
|
<externalId>false</externalId>
|
<formula>Account__r.BF_Competitor_endoscopy_room__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>XXXBF:内镜检查竞争对手房间数</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>BF_Endoscope_Inspection_Room_Num__c</fullName>
|
<externalId>false</externalId>
|
<formula>Account__r.BF_Endoscope_Inspection_Room_Num__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>XXXBF:内镜检查房间总数</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>BF_OLY_endscopy_room__c</fullName>
|
<externalId>false</externalId>
|
<formula>Account__r.BF_OLY_endscopy_room__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>XXXBF:内镜检查OLY房间数</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>BO_A_B_C_coverage__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF((ShippedAmount_HP__c + Forecast_Amount_HP__c + RANK_A_tax_HP__c + RANK_B_tax_HP__c + RANK_C_tax_HP__c)=0,0,1)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>订货+A+B+C级询价覆盖率</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>BO_A_B_coverage__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF((ShippedAmount_HP__c + Forecast_Amount_HP__c + RANK_A_tax_HP__c + RANK_B_tax_HP__c)=0,0,1)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>订货+A+B级询价覆盖率</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>BO_A_coverage__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF((ShippedAmount_HP__c + Forecast_Amount_HP__c + RANK_A_tax_HP__c)=0,0,1)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>订货+A级询价覆盖率</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>BO_coverage__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF((ShippedAmount_HP__c + Forecast_Amount_HP__c )=0,0,1)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>订货覆盖率</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>CV_180_Count__c</fullName>
|
<externalId>false</externalId>
|
<formula>Account__r.CV_180_Count_formula__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>CV-180(台)</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>CV_190__c</fullName>
|
<externalId>false</externalId>
|
<formula>Account__r.CV_190_Count_formula__c</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>CV_240__c</fullName>
|
<externalId>false</externalId>
|
<formula>Account__r.CV_240_Other_Count_formula__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>CV-240系列(台)</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>CV_260SL__c</fullName>
|
<externalId>false</externalId>
|
<formula>Account__r.CV_260SL_Count_formula__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>CV-260SL(台)</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>CV_260__c</fullName>
|
<externalId>false</externalId>
|
<formula>Account__r.CV_260_Count_formula__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>CV-260(台)</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>CV_290_OPD_coverage1__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(
|
AND(
|
Text( Account__r.Important_Product_opd1__c) = "是",
|
Important_product1_c__c >= 1),1,0)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>CV-290目标客户OPD覆盖</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>CV_290_OPD_coverage__c</fullName>
|
<externalId>false</externalId>
|
<formula>Account__r.CV_290_OPD_coverage__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>XXX今年是否进行CV-290的OPD</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>CV_290__c</fullName>
|
<externalId>false</externalId>
|
<formula>Account__r.CV_290_Count_formula__c</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>CV_Other_Count__c</fullName>
|
<externalId>false</externalId>
|
<formula>Account__r.CV_Other_Count_formula__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>其他CV(台)</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Competitor_Count__c</fullName>
|
<externalId>false</externalId>
|
<formula>Account__r.Competitor_Count_formula__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>GI主机对手(台)</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Competitor_endoscopy_room__c</fullName>
|
<externalId>false</externalId>
|
<formula>Account__r.Competitor_endoscopy_room__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>XXXGI:内镜检查竞争对手房间数</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Department_category_EN__c</fullName>
|
<description>case(Account__r.Department_Class_Name__c,
|
"消化科","GI",
|
"呼吸科","BF",
|
"普外科","GS",
|
"泌尿科","URO",
|
"妇科","GYN",
|
"耳鼻喉科","ENT",
|
"其他","OTH","")</description>
|
<externalId>false</externalId>
|
<formula>case(Opportunity_Category_text__c,
|
"消化科","GI",
|
"ET","ET",
|
"呼吸科","BF",
|
"普外科","GS",
|
"泌尿科","URO",
|
"妇科","GYN",
|
"耳鼻喉科","ENT",
|
"其他","OTH","")</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>科室分类(英文)</label>
|
<required>false</required>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Department_category__c</fullName>
|
<externalId>false</externalId>
|
<formula>Account__r.Department_Class_Name__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>科室分类</label>
|
<required>false</required>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Dept_annual_budget__c</fullName>
|
<externalId>false</externalId>
|
<formula>Account__r.Department_Budget_Sum_Price__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>XXX科室购买预算总金额(含税:元)</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>2</scale>
|
<trackTrending>false</trackTrending>
|
<type>Currency</type>
|
</fields>
|
<fields>
|
<fullName>Endoscope_Inspection_Room_Num__c</fullName>
|
<externalId>false</externalId>
|
<formula>Account__r.Endoscope_Inspection_Room_Num__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>XXXGI:内镜检查房间总数</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Fiscal_Start_Date__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(Month(Today()) < 4,
|
Date(Year(Today()) - 1, 4, 1),
|
Date(Year(Today()), 4, 1)
|
)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>期首日</label>
|
<required>false</required>
|
<trackTrending>false</trackTrending>
|
<type>Date</type>
|
</fields>
|
<fields>
|
<fullName>Forecast_Amount_HP__c</fullName>
|
<externalId>false</externalId>
|
<formula>Account__r.Forecast_Amount_HP_formula__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>XXX注残金额(含税)</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>2</scale>
|
<trackTrending>false</trackTrending>
|
<type>Currency</type>
|
</fields>
|
<fields>
|
<fullName>GI_processor__c</fullName>
|
<externalId>false</externalId>
|
<formula>Account__r.GI_processor__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>XXXGI主机总数(台)</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>GI_processor_total__c</fullName>
|
<externalId>false</externalId>
|
<formula>Account__r.GI_processor__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>GI主机总数(台)</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Hospital_ID__c</fullName>
|
<externalId>false</externalId>
|
<formula>Account__r.Id</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>医院ID</label>
|
<required>false</required>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Hospital_management_code__c</fullName>
|
<externalId>false</externalId>
|
<formula>Account__r.Management_Code__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>医院编码</label>
|
<required>false</required>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Hospital_management_code_auto__c</fullName>
|
<externalId>false</externalId>
|
<formula>Account__r.Management_Code_Auto__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>医院编码（Auto）</label>
|
<required>false</required>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Hospital_name__c</fullName>
|
<externalId>false</externalId>
|
<formula>Account__r.Hospital_Name__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>医院</label>
|
<required>false</required>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>ID_Month_Hospital__c</fullName>
|
<externalId>false</externalId>
|
<formula>Account__r.Parent.Id</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>医院(母)ID</label>
|
<required>false</required>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Important_Product_opd13_number__c</fullName>
|
<externalId>false</externalId>
|
<formula>Account__r.Important_Product_opd13_number__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>XXX・TURis/TCRis : OPD目标客户数</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Important_Product_opd1_number__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(Text( Account__r.Important_Product_opd1__c) = "是",1,0)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>XXX・CV-290 : OPD目标客户数</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Important_Product_opd2_number__c</fullName>
|
<externalId>false</externalId>
|
<formula>Account__r.Important_Product_opd2_number__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>XXX・SP新主机 OPD目标客户数</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Important_Product_opd5_number__c</fullName>
|
<externalId>false</externalId>
|
<formula>Account__r.Important_Product_opd5_number__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>XXX・能量主机 : OPD目标客户数</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Important_product1_c__c</fullName>
|
<externalId>false</externalId>
|
<formula>Account__r.Important_product1_formula__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>XXX今年CV-290的OPD</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Key_HP_management_ratio_SalesKPI__c</fullName>
|
<externalId>false</externalId>
|
<formula>Account__r.Key_HP_management_ratio_SalesKPI__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>价值客户管理KPI达成率(销售)</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>2</scale>
|
<trackTrending>false</trackTrending>
|
<type>Percent</type>
|
</fields>
|
<fields>
|
<fullName>NBI_processpr_number__c</fullName>
|
<externalId>false</externalId>
|
<formula>Account__r.NBI_processpr_number__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>XXXNBI主机台数</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>NBI_ratio__c</fullName>
|
<description>Account__r.NBI_ratio__c</description>
|
<externalId>false</externalId>
|
<formula>IF(GI_processor_total__c=0,0,
|
IF((CV_290__c+CV_260SL__c)=0,0,((CV_290__c+CV_260SL__c)/GI_processor_total__c)))</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>NBI比率</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>1</scale>
|
<trackTrending>false</trackTrending>
|
<type>Percent</type>
|
</fields>
|
<fields>
|
<fullName>Number_of_OPD_this_year__c</fullName>
|
<externalId>false</externalId>
|
<formula>Account__r.DoOPDHospital_ThisYear__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>XXX已做OPD次数(医院)今年</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Number_of_visit_this_year__c</fullName>
|
<externalId>false</externalId>
|
<formula>Account__r.VisitCountThisFiscalYear__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>XXX今年拜访次数</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>OCM_Category__c</fullName>
|
<externalId>false</externalId>
|
<formula>Account__r.HP_146POCM_Category_From_Dept__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>OCSM分类</label>
|
<required>false</required>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>OCM_department_seg__c</fullName>
|
<externalId>false</externalId>
|
<formula>text(Account__r.Segment__c)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>OCSM科室等级</label>
|
<required>false</required>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>OCM_province__c</fullName>
|
<externalId>false</externalId>
|
<formula>Account__r.OCM_Province_formula__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>XXXOCSM省</label>
|
<required>false</required>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>OLY_endscopy_room__c</fullName>
|
<externalId>false</externalId>
|
<formula>Account__r.OLY_endscopy_room__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>XXXGI:内镜检查OLY房间数</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Opp_OCM_text__c</fullName>
|
<externalId>false</externalId>
|
<label>■■OCSM分类(文本)</label>
|
<length>250</length>
|
<required>false</required>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Opportunity_Category_text__c</fullName>
|
<externalId>false</externalId>
|
<label>■■科室分类(文本)</label>
|
<length>250</length>
|
<required>false</required>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Past_month__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(month(Today())>=4,
|
((month(today())+1)-month(Fiscal_Start_Date__c)),
|
((month(today())+13)-month(Fiscal_Start_Date__c))
|
)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>经过月</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Proposal_target_customer_number__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(Text(Account__r.Proposal_target_customer__c)="是",1,0)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>XXX提案目标客户数</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Province_SAP__c</fullName>
|
<externalId>false</externalId>
|
<formula>Case(State_Text__c,
|
"安徽省","安徽",
|
"北京市","北京",
|
"福建省","福建",
|
"甘肃省","甘肃",
|
"广东省","广东",
|
"广西自治区","广西",
|
"贵州省","贵州",
|
"海南省","广东",
|
"河北省","河北",
|
"河南省","河南",
|
"黑龙江","黑龙江",
|
"湖北省","湖北",
|
"湖南省","湖南",
|
"吉林省","吉林",
|
"江苏省","江苏",
|
"江西省","江西",
|
"辽宁省","辽宁",
|
"内蒙古自治区","内蒙古",
|
"宁夏回族自治区","宁夏",
|
"青海省","青海",
|
"山东省","山东",
|
"山西省","山西",
|
"陕西省","陕西",
|
"上海市","上海",
|
"四川省","四川",
|
"天津市","天津",
|
"西藏自治区","四川",
|
"新疆维吾尔自治区","新疆",
|
"云南省","云南",
|
"浙江省","浙江",
|
"重庆市","重庆","")</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>省(SAP) & MB</label>
|
<required>false</required>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Province__c</fullName>
|
<externalId>false</externalId>
|
<formula>Account__r.Province_formula__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>省</label>
|
<required>false</required>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>RANK_A_tax_HP__c</fullName>
|
<externalId>false</externalId>
|
<formula>Account__r.RANK_A_tax_HP_formula__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>XXXA级询价(含税)</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>2</scale>
|
<trackTrending>false</trackTrending>
|
<type>Currency</type>
|
</fields>
|
<fields>
|
<fullName>RANK_A_withouttax_HP__c</fullName>
|
<description>20190326前
|
if( TODAY() < Datevalue( $Label.Tax_Date ),RANK_A_tax_HP__c / 1.17,RANK_A_tax_HP__c / 1.16)</description>
|
<externalId>false</externalId>
|
<formula>if( TODAY() < Datevalue( $Label.Tax_Date_13 ),RANK_A_tax_HP__c / 1.16,RANK_A_tax_HP__c / 1.13)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>XXXA级询价(不含税)</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>2</scale>
|
<trackTrending>false</trackTrending>
|
<type>Currency</type>
|
</fields>
|
<fields>
|
<fullName>RANK_B_tax_HP__c</fullName>
|
<externalId>false</externalId>
|
<formula>Account__r.RANK_B_tax_HP_Formula__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>XXXB级询价(含税)</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>2</scale>
|
<trackTrending>false</trackTrending>
|
<type>Currency</type>
|
</fields>
|
<fields>
|
<fullName>RANK_C_tax_HP__c</fullName>
|
<externalId>false</externalId>
|
<formula>Account__r.RANK_C_tax_HP_formula__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>XXXC级询价(含税)</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>2</scale>
|
<trackTrending>false</trackTrending>
|
<type>Currency</type>
|
</fields>
|
<fields>
|
<fullName>RANK_D_tax_HP__c</fullName>
|
<externalId>false</externalId>
|
<formula>Account__r.RANK_D_tax_HP_formula__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>XXXD级询价(含税)</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>2</scale>
|
<trackTrending>false</trackTrending>
|
<type>Currency</type>
|
</fields>
|
<fields>
|
<fullName>RANK_E_tax_HP__c</fullName>
|
<externalId>false</externalId>
|
<formula>Account__r.RANK_E_tax_HP_formula__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>XXXE级询价(含税)</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>2</scale>
|
<trackTrending>false</trackTrending>
|
<type>Currency</type>
|
</fields>
|
<fields>
|
<fullName>RecordType__c</fullName>
|
<externalId>false</externalId>
|
<formula>Account__r.RecordType.Name</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>客户记录类型</label>
|
<required>false</required>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>SalesDept__c</fullName>
|
<externalId>false</externalId>
|
<formula>Case(State_Text__c,
|
"安徽省","5.华东",
|
"北京市","1.华北",
|
"福建省","5.华东",
|
"甘肃省","3.西北",
|
"广东省","6.华南",
|
"广西自治区","6.华南",
|
"贵州省","4.西南",
|
"海南省","6.华南",
|
"河北省","1.华北",
|
"河南省","3.西北",
|
"黑龙江","2.东北",
|
"湖北省","6.华南",
|
"湖南省","6.华南",
|
"吉林省","2.东北",
|
"江苏省","5.华东",
|
"江西省","5.华东",
|
"辽宁省","2.东北",
|
"内蒙古自治区","1.华北",
|
"宁夏回族自治区","3.西北",
|
"青海省","3.西北",
|
"山东省","1.华北",
|
"山西省","3.西北",
|
"陕西省","3.西北",
|
"上海市","5.华东",
|
"四川省","4.西南",
|
"天津市","1.华北",
|
"西藏自治区","4.西南",
|
"新疆维吾尔自治区","3.西北",
|
"云南省","4.西南",
|
"浙江省","5.华东",
|
"重庆市","4.西南","")</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>销售本部</label>
|
<required>false</required>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Shipment_coverage__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(ShippedAmount_HP__c = 0,0,1)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>发货覆盖率</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>ShippedAmount_HP__c</fullName>
|
<externalId>false</externalId>
|
<formula>Account__r.ShippedAmount_HP_formula__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>XXX发货金额(含税)</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>2</scale>
|
<trackTrending>false</trackTrending>
|
<type>Currency</type>
|
</fields>
|
<fields>
|
<fullName>State_Text__c</fullName>
|
<description>参考Account的Province_formula__c。MB_客户的Province__c一样的字段</description>
|
<externalId>false</externalId>
|
<label>■■省(文本)</label>
|
<length>250</length>
|
<required>false</required>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>This_year_visit_coverage__c</fullName>
|
<externalId>false</externalId>
|
<formula>Account__r.This_year_visit_coverage__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>今年拜访次数</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>XXXCV_290_target_visit_coverage__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(AND(Important_Product_opd1_number__c = 1,Number_of_visit_this_year__c=1),1,0)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>XXXCV-290目标客户拜访覆盖</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Yealy_annual_budege_without_tax__c</fullName>
|
<description>20190326前
|
if( TODAY() < Datevalue( $Label.Tax_Date ),Dept_annual_budget__c /1.17,Dept_annual_budget__c /1.16)</description>
|
<externalId>false</externalId>
|
<formula>if( TODAY() < Datevalue( $Label.Tax_Date_13 ),Dept_annual_budget__c /1.13,Dept_annual_budget__c /1.16)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>科室购买预算总金额(不含税:元)</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>2</scale>
|
<trackTrending>false</trackTrending>
|
<type>Currency</type>
|
</fields>
|
<label>MB_客户</label>
|
<nameField>
|
<displayFormat>MB-{00000000}</displayFormat>
|
<label>MB客户管理编码</label>
|
<type>AutoNumber</type>
|
</nameField>
|
<searchLayouts/>
|
<sharingModel>Private</sharingModel>
|
<visibility>Public</visibility>
|
</CustomObject>
|
