<?xml version="1.0" encoding="UTF-8"?>
|
<CustomObject xmlns="http://soap.sforce.com/2006/04/metadata">
|
<actionOverrides>
|
<actionName>AddProduct</actionName>
|
<type>Default</type>
|
</actionOverrides>
|
<actionOverrides>
|
<actionName>CancelEdit</actionName>
|
<type>Default</type>
|
</actionOverrides>
|
<actionOverrides>
|
<actionName>ChoosePricebook</actionName>
|
<type>Default</type>
|
</actionOverrides>
|
<actionOverrides>
|
<actionName>Delete</actionName>
|
<type>Default</type>
|
</actionOverrides>
|
<actionOverrides>
|
<actionName>Edit</actionName>
|
<type>Default</type>
|
</actionOverrides>
|
<actionOverrides>
|
<actionName>EditAllProduct</actionName>
|
<type>Default</type>
|
</actionOverrides>
|
<actionOverrides>
|
<actionName>SaveEdit</actionName>
|
<type>Default</type>
|
</actionOverrides>
|
<actionOverrides>
|
<actionName>View</actionName>
|
<type>Default</type>
|
</actionOverrides>
|
<compactLayoutAssignment>SYSTEM</compactLayoutAssignment>
|
<enableFeeds>false</enableFeeds>
|
<fields>
|
<fullName>A_B_C_pcl_number__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(AND(
|
text(Opportunity.StageName)="引合",
|
OR(text(Opportunity.Competitor__c)="A",text(Opportunity.Competitor__c)="B",text(Opportunity.Competitor__c)="C"))
|
,Quantity, 0)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>A+B+C级询价数量</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>A_pcl_number__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(AND(
|
text(Opportunity.Competitor__c)="A",text(Opportunity.StageName)="引合"),Quantity, 0)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>A级询价数量</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Actual__c</fullName>
|
<externalId>false</externalId>
|
<formula>CASE( Category__c , "実績", OCM_Sales_Forecast_Without_Tax__c ,0)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>发货金额(不含税)</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>2</scale>
|
<type>Currency</type>
|
</fields>
|
<fields>
|
<fullName>AgencySubtotal__c</fullName>
|
<externalId>false</externalId>
|
<label>经销商小计</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>1</scale>
|
<type>Currency</type>
|
</fields>
|
<fields>
|
<fullName>AgencyUnitPrice__c</fullName>
|
<externalId>false</externalId>
|
<label>经销商单价</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>1</scale>
|
<type>Currency</type>
|
</fields>
|
<fields>
|
<fullName>Asset_Model_No__c</fullName>
|
<externalId>false</externalId>
|
<formula>PricebookEntry.Product2.Asset_Model_No__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>OCSM内部产品型号(略称)</label>
|
<required>false</required>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>BSS_Category__c</fullName>
|
<externalId>false</externalId>
|
<label>BSS分类</label>
|
<required>false</required>
|
<type>Picklist</type>
|
<valueSet>
|
<valueSetDefinition>
|
<sorted>false</sorted>
|
<value>
|
<fullName>G&R</fullName>
|
<default>false</default>
|
<label>G&R</label>
|
</value>
|
<value>
|
<fullName>ET</fullName>
|
<default>false</default>
|
<label>ET</label>
|
</value>
|
<value>
|
<fullName>Surgical</fullName>
|
<default>false</default>
|
<label>Surgical</label>
|
</value>
|
<value>
|
<fullName>Energy</fullName>
|
<default>false</default>
|
<label>Energy</label>
|
</value>
|
<value>
|
<fullName>R&S</fullName>
|
<default>false</default>
|
<label>R&S</label>
|
</value>
|
<value>
|
<fullName>ENG</fullName>
|
<default>false</default>
|
<label>ENG</label>
|
</value>
|
</valueSetDefinition>
|
</valueSet>
|
</fields>
|
<fields>
|
<fullName>B_pcl_number__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(AND(
|
text(Opportunity.Competitor__c)="B",text(Opportunity.StageName)="引合"),Quantity, 0)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>B级询价数量</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Backup_order_number__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(Opportunity.Backup_order_number__c > 0,"备货订单","")</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>是否备货询价</label>
|
<required>false</required>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>CV_190_OTV_190__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(PricebookEntry.Product2.Important_Rroduct_8GI__c = true, Quantity ,0)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>CV-190/OTV-190(台)</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>CV_290__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(PricebookEntry.Product2.Important_Rroduct_1GI__c = true, Quantity ,0)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>CV-290(台)</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>CYF_URF__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(PricebookEntry.Product2.Important_Rroduct_16GI__c = true, Quantity ,0) +
|
IF(PricebookEntry.Product2.Important_Rroduct_17GI__c = true, Quantity ,0)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>CYF/URF(条)</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>C_pcl_number__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(AND(
|
text(Opportunity.Competitor__c)="C",text(Opportunity.StageName)="引合"),Quantity, 0)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>C级询价数量</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>CanNotCancelFlag__c</fullName>
|
<defaultValue>false</defaultValue>
|
<description>如果是产品主数据是不可取消多年保，报价decide时，赋值为true；取消时，赋值为false</description>
|
<externalId>false</externalId>
|
<label>不可取消多年保标识</label>
|
<type>Checkbox</type>
|
</fields>
|
<fields>
|
<fullName>Category2__c</fullName>
|
<externalId>false</externalId>
|
<formula>PricebookEntry.Product2.Category2__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>第2分类</label>
|
<required>false</required>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Category3__c</fullName>
|
<externalId>false</externalId>
|
<formula>PricebookEntry.Product2.Category3__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>第3分类</label>
|
<required>false</required>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Category4__c</fullName>
|
<externalId>false</externalId>
|
<formula>PricebookEntry.Product2.Category4__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>第4分类</label>
|
<required>false</required>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Category__c</fullName>
|
<externalId>false</externalId>
|
<formula>Opportunity.Category__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>出荷状態分類</label>
|
<required>false</required>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Cost__c</fullName>
|
<externalId>false</externalId>
|
<label>原価</label>
|
<precision>15</precision>
|
<required>false</required>
|
<scale>2</scale>
|
<type>Currency</type>
|
</fields>
|
<fields>
|
<fullName>Cost_amount__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF( $User.Cost_Referable__c = False, null,
|
Quantity * Product_Cost__c )</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>成本总额(数量*成本)</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>2</scale>
|
<type>Currency</type>
|
</fields>
|
<fields>
|
<fullName>D_E_pcl_number__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(AND(
|
text(Opportunity.StageName)="引合",
|
OR(text(Opportunity.Competitor__c)="D",text(Opportunity.Competitor__c)="E"))
|
|
,Quantity, 0)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>D+E级询价数量</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>D_pcl_number__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(AND(
|
text(Opportunity.Competitor__c)="D",text(Opportunity.StageName)="引合"),Quantity, 0)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>D级询价数量</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Department__c</fullName>
|
<externalId>false</externalId>
|
<formula>Opportunity.Department_Name__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>科室名</label>
|
<required>false</required>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Description</fullName>
|
</fields>
|
<fields>
|
<fullName>Discount</fullName>
|
</fields>
|
<fields>
|
<fullName>Distributor_InCharge_opp__c</fullName>
|
<externalId>false</externalId>
|
<formula>Opportunity.Distributor_InCharge_opp__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>经销商管理课负责的询价</label>
|
<type>Checkbox</type>
|
</fields>
|
<fields>
|
<fullName>ENF_Video__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(PricebookEntry.Product2.Important_Rroduct_18GI__c = true, Quantity ,0)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>ENF-Video(条)</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>ENG_wave__c</fullName>
|
<externalId>false</externalId>
|
<formula>CASE( PricebookEntry.Product2.ENG__c,
|
'ENG','ENG',
|
'ENG共通',IF(Opportunity.STMS_Package_Sale__c = true, 'ENG', ''),
|
'')</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>ENG_wave</label>
|
<required>false</required>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>ESG_400__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(PricebookEntry.Product2.Important_Rroduct_13GI__c = true, Quantity ,0)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>ESG-400(台)</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>EU_ME2__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(PricebookEntry.Product2.Important_Rroduct_2GI__c = true, Quantity ,0)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>EU-ME2(台)</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>E_pcl_number__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(AND(
|
text(Opportunity.Competitor__c)="E",text(Opportunity.StageName)="引合"),Quantity, 0)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>E级询价数量</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>First_Category__c</fullName>
|
<externalId>false</externalId>
|
<formula>TEXT( PricebookEntry.Product2.Family )</formula>
|
<label>第一階層</label>
|
<required>false</required>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Forecast__c</fullName>
|
<externalId>false</externalId>
|
<formula>CASE( Category__c , "見込", OCM_Sales_Forecast_Without_Tax__c ,0)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>注残金额(不含税)</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>2</scale>
|
<type>Currency</type>
|
</fields>
|
<fields>
|
<fullName>Group_purchase_PCL__c</fullName>
|
<externalId>false</externalId>
|
<formula>Opportunity.Group_purchase_PCL__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>■■集中采购课负责的询价</label>
|
<type>Checkbox</type>
|
</fields>
|
<fields>
|
<fullName>GuaranteePeriod__c</fullName>
|
<externalId>false</externalId>
|
<label>保修年限</label>
|
<precision>3</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>GuranteePriceSum__c</fullName>
|
<externalId>false</externalId>
|
<formula>Quantity * GuranteePrice__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>计提金额(数量*计提)</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>2</scale>
|
<type>Currency</type>
|
</fields>
|
<fields>
|
<fullName>GuranteePrice__c</fullName>
|
<externalId>false</externalId>
|
<label>计提金额</label>
|
<precision>16</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<type>Currency</type>
|
</fields>
|
<fields>
|
<fullName>GuranteeType__c</fullName>
|
<externalId>false</externalId>
|
<label>保修类型</label>
|
<length>40</length>
|
<required>false</required>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>HD_EndoEYE__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(PricebookEntry.Product2.Important_Rroduct_9GI__c = true, Quantity ,0)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>HD EndoEYE(条)</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Hospital_Name__c</fullName>
|
<externalId>false</externalId>
|
<formula>Opportunity.Hospital__r.Name</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>医院名</label>
|
<required>false</required>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Hospital__c</fullName>
|
<externalId>false</externalId>
|
<formula>Opportunity.Hospital__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>医院</label>
|
<required>false</required>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Id__c</fullName>
|
<externalId>false</externalId>
|
<label>Id_System</label>
|
<length>80</length>
|
<required>false</required>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>If_170Pro_F__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(AND( OR(PricebookEntry.Product2.Category3__c = '主机',PricebookEntry.Product2.Category3__c = '电子镜'),PricebookEntry.Product2.Category5__c = '170系列'), true, false)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>是否170.</label>
|
<type>Checkbox</type>
|
</fields>
|
<fields>
|
<fullName>If_170Pro__c</fullName>
|
<defaultValue>false</defaultValue>
|
<externalId>false</externalId>
|
<label>是否170</label>
|
<type>Checkbox</type>
|
</fields>
|
<fields>
|
<fullName>If_AHPro_F__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(AND( OR(PricebookEntry.Product2.Category3__c = '主机',PricebookEntry.Product2.Category3__c = '电子镜'),OR(PricebookEntry.Product2.Category5__c = 'V1系列',PricebookEntry.Product2.Category5__c = 'LV系列')), true, false)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>是否奥辉.</label>
|
<type>Checkbox</type>
|
</fields>
|
<fields>
|
<fullName>If_AHPro__c</fullName>
|
<defaultValue>false</defaultValue>
|
<externalId>false</externalId>
|
<label>是否奥辉</label>
|
<type>Checkbox</type>
|
</fields>
|
<fields>
|
<fullName>If_Cancel_Guarantee__c</fullName>
|
<defaultValue>false</defaultValue>
|
<externalId>false</externalId>
|
<label>是否取消多年保修</label>
|
<type>Checkbox</type>
|
</fields>
|
<fields>
|
<fullName>If_EP_T1_F__c</fullName>
|
<defaultValue>false</defaultValue>
|
<externalId>false</externalId>
|
<label>是否EP-T1</label>
|
<type>Checkbox</type>
|
</fields>
|
<fields>
|
<fullName>If_EP_T1__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF( OR(PricebookEntry.Product2.MDM_Model_No__c = 'EP-T1(A)',PricebookEntry.Product2.MDM_Model_No__c = 'EP-T1(B)') , true, false)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>是否EP-T1.</label>
|
<type>Checkbox</type>
|
</fields>
|
<fields>
|
<fullName>If_OER_AW_F__c</fullName>
|
<externalId>false</externalId>
|
<formula>/*
|
CONTAINS(PricebookEntry.Product2.Name,'OER-AW')
|
*/
|
AND(CONTAINS(PricebookEntry.Product2.Name,'OER-AW'),PricebookEntry.Product2.Category2__c ='本体' )</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>是否OER-AW.</label>
|
<type>Checkbox</type>
|
</fields>
|
<fields>
|
<fullName>If_OER_AW__c</fullName>
|
<defaultValue>false</defaultValue>
|
<externalId>false</externalId>
|
<label>是否OER-AW</label>
|
<type>Checkbox</type>
|
</fields>
|
<fields>
|
<fullName>Important_Rroduct__c</fullName>
|
<defaultValue>false</defaultValue>
|
<externalId>false</externalId>
|
<label>重点製品</label>
|
<type>Checkbox</type>
|
</fields>
|
<fields>
|
<fullName>InqueryProductID__c</fullName>
|
<externalId>false</externalId>
|
<formula>Id</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>询价产品ID</label>
|
<required>false</required>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Is_DangerousChemicals_F__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(PricebookEntry.Product2.Is_DangerousChemicals__c, true, false)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>是否是危化品.</label>
|
<type>Checkbox</type>
|
</fields>
|
<fields>
|
<fullName>Is_DangerousChemicals__c</fullName>
|
<defaultValue>false</defaultValue>
|
<externalId>false</externalId>
|
<label>是否是危化品</label>
|
<type>Checkbox</type>
|
</fields>
|
<fields>
|
<fullName>Item_Order__c</fullName>
|
<externalId>false</externalId>
|
<label>並び順</label>
|
<precision>3</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Key_product_147P__c</fullName>
|
<externalId>false</externalId>
|
<formula>PricebookEntry.Product2.Key_product_147P__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>重点产品区分</label>
|
<required>false</required>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Key_product_for_Report__c</fullName>
|
<description>For report to show 149P target product name</description>
|
<externalId>false</externalId>
|
<formula>IF(ISPICKVAL(Opportunity.Important_Key_product_category__c, "重点产品01"),"01.CV-290",
|
IF(ISPICKVAL(Opportunity.Important_Key_product_category__c, "重点产品02"),"02.CV-170",
|
IF(ISPICKVAL(Opportunity.Important_Key_product_category__c, "重点产品03"),"03.290镜子",
|
IF(ISPICKVAL(Opportunity.Important_Key_product_category__c, "重点产品04"),"04.EU-ME2",
|
IF(ISPICKVAL(Opportunity.Important_Key_product_category__c, "重点产品05"),"05.OER-AW",
|
IF(ISPICKVAL(Opportunity.Important_Key_product_category__c, "重点产品06"),"06.ERCP",
|
IF(ISPICKVAL(Opportunity.Important_Key_product_category__c, "重点产品07"),"07.ESD",
|
IF(ISPICKVAL(Opportunity.Important_Key_product_category__c, "重点产品08"),"08.3DV-190",
|
IF(ISPICKVAL(Opportunity.Important_Key_product_category__c, "重点产品09"),"09.EXERAIII/ELITE",
|
IF(ISPICKVAL(Opportunity.Important_Key_product_category__c, "重点产品10"),"10.HD.EndoEYE./LTF",
|
IF(ISPICKVAL(Opportunity.Important_Key_product_category__c, "重点产品11"),"11.LTF-3D",
|
IF(ISPICKVAL(Opportunity.Important_Key_product_category__c, "重点产品12"),"12.USG-400",
|
IF(ISPICKVAL(Opportunity.Important_Key_product_category__c, "重点产品13"),"13.URF",
|
IF(ISPICKVAL(Opportunity.Important_Key_product_category__c, "重点产品14"),"14.CYF",
|
IF(ISPICKVAL(Opportunity.Important_Key_product_category__c, "重点产品15"),"15.Bipolar.Working.Element",
|
IF(ISPICKVAL(Opportunity.Important_Key_product_category__c, "重点产品16"),"16.ENF",
|
IF(ISPICKVAL(Opportunity.Important_Key_product_category__c, "重点产品17"),"17.TB",
|
IF(ISPICKVAL(Opportunity.Important_Key_product_category__c, "重点产品18"),"18.TURis/TCRis",
|
"#N/A")
|
)
|
)
|
)
|
)
|
)
|
)
|
)
|
)
|
)
|
)
|
)
|
)
|
)
|
)
|
)
|
)
|
)</formula>
|
<label>重点产品区分名称</label>
|
<required>false</required>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Key_product_sql__c</fullName>
|
<externalId>false</externalId>
|
<formula>PricebookEntry.Product2.Key_product_sql__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>重点产品区分_sql</label>
|
<required>false</required>
|
<type>Date</type>
|
</fields>
|
<fields>
|
<fullName>LTF_S190__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(PricebookEntry.Product2.Important_Rroduct_10GI__c = true, Quantity ,0)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>LTF-S190(台)</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>LastestMaintenance_Price_Year__c</fullName>
|
<description>1.如果是内贸,取产品主数据上的内贸维修合同报价
|
2.如果是外贸,取产品主数据上的外贸维修合同报价</description>
|
<externalId>false</externalId>
|
<formula>CASE(Text(Opportunity.Trade__c),
|
'内貿', PricebookEntry.Product2.Maintenance_Price_Year__c,
|
PricebookEntry.Product2.Repair_Contract_USD__c )</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>维修合同报价（最新）</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>2</scale>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>ListPrice</fullName>
|
</fields>
|
<fields>
|
<fullName>ListPrice__c</fullName>
|
<externalId>false</externalId>
|
<label>ListPrice</label>
|
<precision>15</precision>
|
<required>false</required>
|
<scale>2</scale>
|
<type>Currency</type>
|
</fields>
|
<fields>
|
<fullName>ListPrice_total_price__c</fullName>
|
<externalId>false</externalId>
|
<formula>Quantity * Product_ListPrice__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>最新ListPrice总额(数量*报价)</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>2</scale>
|
<type>Currency</type>
|
</fields>
|
<fields>
|
<fullName>Maintenance_Price_Year__c</fullName>
|
<externalId>false</externalId>
|
<label>维修合同报价</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>2</scale>
|
<type>Currency</type>
|
</fields>
|
<fields>
|
<fullName>Name</fullName>
|
</fields>
|
<fields>
|
<fullName>Name__c</fullName>
|
<externalId>false</externalId>
|
<label>商品名</label>
|
<length>255</length>
|
<required>false</required>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>NoDRMB_Without_Tax_1000TR__c</fullName>
|
<description>CHAN-BGU4RY</description>
|
<externalId>false</externalId>
|
<formula>CASE(Opportunity.Competitor__c ,
|
'A1', NoDRMB_Without_Tax_1000__c* 1,
|
'A', NoDRMB_Without_Tax_1000__c* 0.8,
|
'B', NoDRMB_Without_Tax_1000__c* 0.5,
|
'C', NoDRMB_Without_Tax_1000__c * 0.3,
|
'D', 0,
|
'E', 0,
|
0)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<inlineHelpText>NoD=NoDiscount</inlineHelpText>
|
<label>NoD合计金额（换算值，千元RMB,不含税）</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>2</scale>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>NoDRMB_Without_Tax_1000__c</fullName>
|
<description>CHAN-BGU4RY</description>
|
<externalId>false</externalId>
|
<formula>NoDRMB_Without_Tax__c/1000</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<inlineHelpText>NoD=NoDiscount</inlineHelpText>
|
<label>NoD合计金额（千元RMB,不含税）</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>2</scale>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>NoDRMB_Without_Tax__c</fullName>
|
<description>CHAN-BGU4RY</description>
|
<externalId>false</externalId>
|
<formula>Case( Opportunity.Trade__c,
|
"内貿",NoDiscountTotal__c/ Opportunity.Tax_Intra_F_Copy__c ,
|
"外貿", NoDiscountTotal__c* Opportunity.Tax_Foreign_F_Copy__c,
|
NoDiscountTotal__c * 1
|
)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<inlineHelpText>NoD=NoDiscount</inlineHelpText>
|
<label>NoD合计金额(不含税)_元(产品)</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>2</scale>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>NoDiscountTotal__c</fullName>
|
<externalId>false</externalId>
|
<label>NoDiscount小计</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>2</scale>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>NumberOfActual__c</fullName>
|
<externalId>false</externalId>
|
<formula>CASE( Category__c , "実績", Quantity,0)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>发货数量</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>NumberOfForecast__c</fullName>
|
<externalId>false</externalId>
|
<formula>CASE( Category__c , "見込", Quantity ,0)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>注残数量</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>NumberOfObjective_146P__c</fullName>
|
<externalId>false</externalId>
|
<label>1.目標数量(不使用)</label>
|
<precision>15</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>NumberOfObjective__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(IsPickval(Opportunity.Target_category__c, '重点产品目标(金额)') || IsPickval(Opportunity.Target_category__c, '担当重点产品目标') || IsPickval(Opportunity.Target_category__c, '省重点产品目标')
|
, IF(Opportunity.Proportion__c > 0, Opportunity.Proportion__c * Quantity, NumberOfObjective_146P__c)
|
, 0
|
)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>1.目標数量</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>4</scale>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>OCM_Sales_ForecastRMB_Without_Tax_1000TR__c</fullName>
|
<externalId>false</externalId>
|
<formula>CASE(Opportunity.Competitor__c ,
|
'A1', OCM_Sales_ForecastRMB_Without_Tax_1000__c * 1,
|
'A', OCM_Sales_ForecastRMB_Without_Tax_1000__c * 0.8,
|
'B', OCM_Sales_ForecastRMB_Without_Tax_1000__c * 0.5,
|
'C', OCM_Sales_ForecastRMB_Without_Tax_1000__c * 0.3,
|
'D', 0,
|
'E', 0,
|
0)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>OCSM预测成交金额（换算值，千元RMB不含税）</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>OCM_Sales_ForecastRMB_Without_Tax_1000__c</fullName>
|
<externalId>false</externalId>
|
<formula>OCM_Sales_ForecastRMB_Without_Tax__c / 1000</formula>
|
<label>OCSM预测金额</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>2</scale>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>OCM_Sales_ForecastRMB_Without_Tax__c</fullName>
|
<description>For Report
|
Case( Opportunity.Trade__c,
|
"内貿", IF(Opportunity.ShippingDate_For_Report__c < Datevalue("2018-05-01") ,OCM_Sales_Forecast__c /1.17,OCM_Sales_Forecast__c /1.16),
|
"外貿",
|
IF(Opportunity.ShippingDate_For_Report__c < Datevalue("2012-10-01") ,
|
OCM_Sales_Forecast__c * 6.6,
|
IF(Opportunity.ShippingDate_For_Report__c < Datevalue("2016-07-01") ,
|
OCM_Sales_Forecast__c * 6.3,
|
IF(Opportunity.ShippingDate_For_Report__c < Datevalue("2016-12-01") ,
|
OCM_Sales_Forecast__c * 6.5,
|
IF(Opportunity.ShippingDate_For_Report__c < Datevalue("2018-05-01") ,
|
OCM_Sales_Forecast__c * 6.8, OCM_Sales_Forecast__c * 6.3
|
)
|
)
|
)
|
),
|
OCM_Sales_Forecast__c * 1
|
)</description>
|
<externalId>false</externalId>
|
<formula>IF( ISBLANK( Opportunity.Estimation_Id__c ) , 0,
|
Case( Opportunity.Trade__c,
|
"内貿",OCM_Sales_Forecast__c / Opportunity.Tax_Intra_F_Copy__c ,
|
"外貿", OCM_Sales_Forecast__c * Opportunity.Tax_Foreign_F_Copy__c,
|
OCM_Sales_Forecast__c * 1
|
)
|
)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>OCSM预测成交金额(不含税)_元(产品)</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>2</scale>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>OCM_Sales_Forecast_F__c</fullName>
|
<description>OCSM预测成交金额(含税)</description>
|
<externalId>false</externalId>
|
<formula>IF((Opportunity.SAP_Send_OK__c && (Opportunity.Agency1__r.Special__c || Opportunity.Agency2__r.Special__c || Opportunity.Account.Parent.Special__c) && $User.ViewSpecialAgencyAmout__c == False) || ISBLANK(Opportunity.Estimation_Id__c), null,
|
OCM_Sales_Forecast__c
|
)</formula>
|
<label>OCSM预测成交金额(含税)</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>2</scale>
|
<type>Currency</type>
|
</fields>
|
<fields>
|
<fullName>OCM_Sales_Forecast_Product10_Number__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF (
|
OR(
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "GI") ,
|
PricebookEntry.Product2.Important_Rroduct_10GI__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "BF") ,
|
PricebookEntry.Product2.Important_Rroduct_10BF__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "GS") ,
|
PricebookEntry.Product2.Important_Rroduct_10GS__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "URO") ,
|
PricebookEntry.Product2.Important_Rroduct_10URO__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "GYN") ,
|
PricebookEntry.Product2.Important_Rroduct_10GYN__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "ENT") ,
|
PricebookEntry.Product2.Important_Rroduct_10ENT__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "OTH") ,
|
PricebookEntry.Product2.Important_Rroduct_10OTH__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "ET") ,
|
PricebookEntry.Product2.Important_Rroduct_10ET__c = true
|
)
|
),
|
"true",
|
"false"
|
)</formula>
|
<label>重点製品１０_有効</label>
|
<required>false</required>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>OCM_Sales_Forecast_Product10__c</fullName>
|
<description>OCSM预测发货金额－重点产品10(不含税)</description>
|
<externalId>false</externalId>
|
<formula>IF (
|
OR(
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "GI") ,
|
PricebookEntry.Product2.Important_Rroduct_10GI__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "BF") ,
|
PricebookEntry.Product2.Important_Rroduct_10BF__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "GS") ,
|
PricebookEntry.Product2.Important_Rroduct_10GS__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "URO") ,
|
PricebookEntry.Product2.Important_Rroduct_10URO__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "GYN") ,
|
PricebookEntry.Product2.Important_Rroduct_10GYN__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "ENT") ,
|
PricebookEntry.Product2.Important_Rroduct_10ENT__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "OTH") ,
|
PricebookEntry.Product2.Important_Rroduct_10OTH__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "ET") ,
|
PricebookEntry.Product2.Important_Rroduct_10ET__c = true
|
)
|
),
|
OCM_Sales_Forecast_Without_Tax__c,
|
0
|
)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>OCSM预测发货金额－重点产品10(不含税)</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>2</scale>
|
<type>Currency</type>
|
</fields>
|
<fields>
|
<fullName>OCM_Sales_Forecast_Product11_Number__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF (
|
OR(
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "GI") ,
|
PricebookEntry.Product2.Important_Rroduct_11GI__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "BF") ,
|
PricebookEntry.Product2.Important_Rroduct_11BF__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "GS") ,
|
PricebookEntry.Product2.Important_Rroduct_11GS__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "URO") ,
|
PricebookEntry.Product2.Important_Rroduct_11URO__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "GYN") ,
|
PricebookEntry.Product2.Important_Rroduct_11GYN__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "ENT") ,
|
PricebookEntry.Product2.Important_Rroduct_11ENT__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "OTH") ,
|
PricebookEntry.Product2.Important_Rroduct_11OTH__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "ET") ,
|
PricebookEntry.Product2.Important_Rroduct_11ET__c = true
|
)
|
),
|
"true",
|
"false"
|
)</formula>
|
<label>重点製品１１_有効</label>
|
<required>false</required>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>OCM_Sales_Forecast_Product11__c</fullName>
|
<description>OCSM预测发货金额－重点产品11(不含税)</description>
|
<externalId>false</externalId>
|
<formula>IF (
|
OR(
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "GI") ,
|
PricebookEntry.Product2.Important_Rroduct_11GI__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "BF") ,
|
PricebookEntry.Product2.Important_Rroduct_11BF__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "GS") ,
|
PricebookEntry.Product2.Important_Rroduct_11GS__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "URO") ,
|
PricebookEntry.Product2.Important_Rroduct_11URO__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "GYN") ,
|
PricebookEntry.Product2.Important_Rroduct_11GYN__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "ENT") ,
|
PricebookEntry.Product2.Important_Rroduct_11ENT__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "OTH") ,
|
PricebookEntry.Product2.Important_Rroduct_11OTH__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "ET") ,
|
PricebookEntry.Product2.Important_Rroduct_11ET__c = true
|
)
|
),
|
OCM_Sales_Forecast_Without_Tax__c,
|
0
|
)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>OCSM预测发货金额－重点产品11(不含税)</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>2</scale>
|
<type>Currency</type>
|
</fields>
|
<fields>
|
<fullName>OCM_Sales_Forecast_Product12_Number__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF (
|
OR(
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "GI") ,
|
PricebookEntry.Product2.Important_Rroduct_12GI__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "BF") ,
|
PricebookEntry.Product2.Important_Rroduct_12BF__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "GS") ,
|
PricebookEntry.Product2.Important_Rroduct_12GS__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "URO") ,
|
PricebookEntry.Product2.Important_Rroduct_12URO__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "GYN") ,
|
PricebookEntry.Product2.Important_Rroduct_12GYN__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "ENT") ,
|
PricebookEntry.Product2.Important_Rroduct_12ENT__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "OTH") ,
|
PricebookEntry.Product2.Important_Rroduct_12OTH__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "ET") ,
|
PricebookEntry.Product2.Important_Rroduct_12ET__c = true
|
)
|
),
|
"true",
|
"false"
|
)</formula>
|
<label>重点製品１２_有効</label>
|
<required>false</required>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>OCM_Sales_Forecast_Product12__c</fullName>
|
<description>OCSM预测发货金额－重点产品12(不含税)</description>
|
<externalId>false</externalId>
|
<formula>IF (
|
OR(
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "GI") ,
|
PricebookEntry.Product2.Important_Rroduct_12GI__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "BF") ,
|
PricebookEntry.Product2.Important_Rroduct_12BF__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "GS") ,
|
PricebookEntry.Product2.Important_Rroduct_12GS__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "URO") ,
|
PricebookEntry.Product2.Important_Rroduct_12URO__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "GYN") ,
|
PricebookEntry.Product2.Important_Rroduct_12GYN__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "ENT") ,
|
PricebookEntry.Product2.Important_Rroduct_12ENT__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "OTH") ,
|
PricebookEntry.Product2.Important_Rroduct_12OTH__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "ET") ,
|
PricebookEntry.Product2.Important_Rroduct_12ET__c = true
|
)
|
),
|
OCM_Sales_Forecast_Without_Tax__c,
|
0
|
)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>OCSM预测发货金额－重点产品12(不含税)</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>2</scale>
|
<type>Currency</type>
|
</fields>
|
<fields>
|
<fullName>OCM_Sales_Forecast_Product13_Number__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF (
|
OR(
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "GI") ,
|
PricebookEntry.Product2.Important_Rroduct_13GI__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "BF") ,
|
PricebookEntry.Product2.Important_Rroduct_13BF__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "GS") ,
|
PricebookEntry.Product2.Important_Rroduct_13GS__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "URO") ,
|
PricebookEntry.Product2.Important_Rroduct_13URO__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "GYN") ,
|
PricebookEntry.Product2.Important_Rroduct_13GYN__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "ENT") ,
|
PricebookEntry.Product2.Important_Rroduct_13ENT__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "OTH") ,
|
PricebookEntry.Product2.Important_Rroduct_13OTH__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "ET") ,
|
PricebookEntry.Product2.Important_Rroduct_13ET__c = true
|
)
|
),
|
"true",
|
"false"
|
)</formula>
|
<label>重点製品１３_有効</label>
|
<required>false</required>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>OCM_Sales_Forecast_Product13__c</fullName>
|
<description>OCSM预测发货金额－重点产品13(不含税)</description>
|
<externalId>false</externalId>
|
<formula>IF (
|
OR(
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "GI") ,
|
PricebookEntry.Product2.Important_Rroduct_13GI__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "BF") ,
|
PricebookEntry.Product2.Important_Rroduct_13BF__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "GS") ,
|
PricebookEntry.Product2.Important_Rroduct_13GS__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "URO") ,
|
PricebookEntry.Product2.Important_Rroduct_13URO__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "GYN") ,
|
PricebookEntry.Product2.Important_Rroduct_13GYN__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "ENT") ,
|
PricebookEntry.Product2.Important_Rroduct_13ENT__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "OTH") ,
|
PricebookEntry.Product2.Important_Rroduct_13OTH__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "ET") ,
|
PricebookEntry.Product2.Important_Rroduct_13ET__c = true
|
)
|
),
|
OCM_Sales_Forecast_Without_Tax__c,
|
0
|
)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>OCSM预测发货金额－重点产品13(不含税)</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>2</scale>
|
<type>Currency</type>
|
</fields>
|
<fields>
|
<fullName>OCM_Sales_Forecast_Product14_Number__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF (
|
OR(
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "GI") ,
|
PricebookEntry.Product2.Important_Rroduct_14GI__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "BF") ,
|
PricebookEntry.Product2.Important_Rroduct_14BF__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "GS") ,
|
PricebookEntry.Product2.Important_Rroduct_14GS__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "URO") ,
|
PricebookEntry.Product2.Important_Rroduct_14URO__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "GYN") ,
|
PricebookEntry.Product2.Important_Rroduct_14GYN__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "ENT") ,
|
PricebookEntry.Product2.Important_Rroduct_14ENT__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "OTH") ,
|
PricebookEntry.Product2.Important_Rroduct_14OTH__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "ET") ,
|
PricebookEntry.Product2.Important_Rroduct_14ET__c = true
|
)
|
),
|
"true",
|
"false"
|
)</formula>
|
<label>重点製品１４_有効</label>
|
<required>false</required>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>OCM_Sales_Forecast_Product14__c</fullName>
|
<description>OCSM预测发货金额－重点产品14(不含税)</description>
|
<externalId>false</externalId>
|
<formula>IF (
|
OR(
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "GI") ,
|
PricebookEntry.Product2.Important_Rroduct_14GI__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "BF") ,
|
PricebookEntry.Product2.Important_Rroduct_14BF__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "GS") ,
|
PricebookEntry.Product2.Important_Rroduct_14GS__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "URO") ,
|
PricebookEntry.Product2.Important_Rroduct_14URO__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "GYN") ,
|
PricebookEntry.Product2.Important_Rroduct_14GYN__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "ENT") ,
|
PricebookEntry.Product2.Important_Rroduct_14ENT__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "OTH") ,
|
PricebookEntry.Product2.Important_Rroduct_14OTH__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "ET") ,
|
PricebookEntry.Product2.Important_Rroduct_14ET__c = true
|
)
|
),
|
OCM_Sales_Forecast_Without_Tax__c,
|
0
|
)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>OCSM预测发货金额－重点产品14(不含税)</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>2</scale>
|
<type>Currency</type>
|
</fields>
|
<fields>
|
<fullName>OCM_Sales_Forecast_Product15_Number__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF (
|
OR(
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "GI") ,
|
PricebookEntry.Product2.Important_Rroduct_15GI__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "BF") ,
|
PricebookEntry.Product2.Important_Rroduct_15BF__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "GS") ,
|
PricebookEntry.Product2.Important_Rroduct_15GS__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "URO") ,
|
PricebookEntry.Product2.Important_Rroduct_15URO__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "GYN") ,
|
PricebookEntry.Product2.Important_Rroduct_15GYN__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "ENT") ,
|
PricebookEntry.Product2.Important_Rroduct_15ENT__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "OTH") ,
|
PricebookEntry.Product2.Important_Rroduct_15OTH__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "ET") ,
|
PricebookEntry.Product2.Important_Rroduct_15ET__c = true
|
)
|
),
|
"true",
|
"false"
|
)</formula>
|
<label>重点製品１５_有効</label>
|
<required>false</required>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>OCM_Sales_Forecast_Product15__c</fullName>
|
<description>OCSM预测发货金额－重点产品15(不含税)</description>
|
<externalId>false</externalId>
|
<formula>IF (
|
OR(
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "GI") ,
|
PricebookEntry.Product2.Important_Rroduct_15GI__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "BF") ,
|
PricebookEntry.Product2.Important_Rroduct_15BF__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "GS") ,
|
PricebookEntry.Product2.Important_Rroduct_15GS__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "URO") ,
|
PricebookEntry.Product2.Important_Rroduct_15URO__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "GYN") ,
|
PricebookEntry.Product2.Important_Rroduct_15GYN__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "ENT") ,
|
PricebookEntry.Product2.Important_Rroduct_15ENT__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "OTH") ,
|
PricebookEntry.Product2.Important_Rroduct_15OTH__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "ET") ,
|
PricebookEntry.Product2.Important_Rroduct_15ET__c = true
|
)
|
),
|
OCM_Sales_Forecast_Without_Tax__c,
|
0
|
)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>OCSM预测发货金额－重点产品15(不含税)</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>2</scale>
|
<type>Currency</type>
|
</fields>
|
<fields>
|
<fullName>OCM_Sales_Forecast_Product16_Number__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF (
|
OR(
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "GI") ,
|
PricebookEntry.Product2.Important_Rroduct_16GI__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "BF") ,
|
PricebookEntry.Product2.Important_Rroduct_16BF__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "GS") ,
|
PricebookEntry.Product2.Important_Rroduct_16GS__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "URO") ,
|
PricebookEntry.Product2.Important_Rroduct_16URO__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "GYN") ,
|
PricebookEntry.Product2.Important_Rroduct_16GYN__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "ENT") ,
|
PricebookEntry.Product2.Important_Rroduct_16ENT__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "OTH") ,
|
PricebookEntry.Product2.Important_Rroduct_16OTH__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "ET") ,
|
PricebookEntry.Product2.Important_Rroduct_16ET__c = true
|
)
|
),
|
"true",
|
"false"
|
)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>重点製品１６_有効</label>
|
<required>false</required>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>OCM_Sales_Forecast_Product16__c</fullName>
|
<description>OCSM预测发货金额－重点产品16(不含税)</description>
|
<externalId>false</externalId>
|
<formula>IF (
|
OR(
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "GI") ,
|
PricebookEntry.Product2.Important_Rroduct_16GI__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "BF") ,
|
PricebookEntry.Product2.Important_Rroduct_16BF__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "GS") ,
|
PricebookEntry.Product2.Important_Rroduct_16GS__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "URO") ,
|
PricebookEntry.Product2.Important_Rroduct_16URO__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "GYN") ,
|
PricebookEntry.Product2.Important_Rroduct_16GYN__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "ENT") ,
|
PricebookEntry.Product2.Important_Rroduct_16ENT__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "OTH") ,
|
PricebookEntry.Product2.Important_Rroduct_16OTH__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "ET") ,
|
PricebookEntry.Product2.Important_Rroduct_16ET__c = true
|
)
|
),
|
OCM_Sales_Forecast_Without_Tax__c,
|
0
|
)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>OCSM预测发货金额－重点产品16(不含税)</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>2</scale>
|
<type>Currency</type>
|
</fields>
|
<fields>
|
<fullName>OCM_Sales_Forecast_Product17_Number__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF (
|
OR(
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "GI") ,
|
PricebookEntry.Product2.Important_Rroduct_17GI__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "BF") ,
|
PricebookEntry.Product2.Important_Rroduct_17BF__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "GS") ,
|
PricebookEntry.Product2.Important_Rroduct_17GS__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "URO") ,
|
PricebookEntry.Product2.Important_Rroduct_17URO__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "GYN") ,
|
PricebookEntry.Product2.Important_Rroduct_17GYN__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "ENT") ,
|
PricebookEntry.Product2.Important_Rroduct_17ENT__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "OTH") ,
|
PricebookEntry.Product2.Important_Rroduct_17OTH__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "ET") ,
|
PricebookEntry.Product2.Important_Rroduct_17ET__c = true
|
)
|
),
|
"true",
|
"false"
|
)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>重点製品１７_有効</label>
|
<required>false</required>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>OCM_Sales_Forecast_Product17__c</fullName>
|
<description>OCSM预测发货金额－重点产品17(不含税)</description>
|
<externalId>false</externalId>
|
<formula>IF (
|
OR(
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "GI") ,
|
PricebookEntry.Product2.Important_Rroduct_17GI__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "BF") ,
|
PricebookEntry.Product2.Important_Rroduct_17BF__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "GS") ,
|
PricebookEntry.Product2.Important_Rroduct_17GS__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "URO") ,
|
PricebookEntry.Product2.Important_Rroduct_17URO__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "GYN") ,
|
PricebookEntry.Product2.Important_Rroduct_17GYN__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "ENT") ,
|
PricebookEntry.Product2.Important_Rroduct_17ENT__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "OTH") ,
|
PricebookEntry.Product2.Important_Rroduct_17OTH__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "ET") ,
|
PricebookEntry.Product2.Important_Rroduct_17ET__c = true
|
)
|
),
|
OCM_Sales_Forecast_Without_Tax__c,
|
0
|
)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>OCSM预测发货金额－重点产品17(不含税)</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>2</scale>
|
<type>Currency</type>
|
</fields>
|
<fields>
|
<fullName>OCM_Sales_Forecast_Product18_Number__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF (
|
OR(
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "GI") ,
|
PricebookEntry.Product2.Important_Rroduct_18GI__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "BF") ,
|
PricebookEntry.Product2.Important_Rroduct_18BF__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "GS") ,
|
PricebookEntry.Product2.Important_Rroduct_18GS__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "URO") ,
|
PricebookEntry.Product2.Important_Rroduct_18URO__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "GYN") ,
|
PricebookEntry.Product2.Important_Rroduct_18GYN__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "ENT") ,
|
PricebookEntry.Product2.Important_Rroduct_18ENT__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "OTH") ,
|
PricebookEntry.Product2.Important_Rroduct_18OTH__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "ET") ,
|
PricebookEntry.Product2.Important_Rroduct_18ET__c = true
|
)
|
),
|
"true",
|
"false"
|
)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>重点製品１８_有効</label>
|
<required>false</required>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>OCM_Sales_Forecast_Product18__c</fullName>
|
<description>OCSM预测发货金额－重点产品18(不含税)</description>
|
<externalId>false</externalId>
|
<formula>IF (
|
OR(
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "GI") ,
|
PricebookEntry.Product2.Important_Rroduct_18GI__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "BF") ,
|
PricebookEntry.Product2.Important_Rroduct_18BF__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "GS") ,
|
PricebookEntry.Product2.Important_Rroduct_18GS__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "URO") ,
|
PricebookEntry.Product2.Important_Rroduct_18URO__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "GYN") ,
|
PricebookEntry.Product2.Important_Rroduct_18GYN__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "ENT") ,
|
PricebookEntry.Product2.Important_Rroduct_18ENT__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "OTH") ,
|
PricebookEntry.Product2.Important_Rroduct_18OTH__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "ET") ,
|
PricebookEntry.Product2.Important_Rroduct_18ET__c = true
|
)
|
),
|
OCM_Sales_Forecast_Without_Tax__c,
|
0
|
)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>OCSM预测发货金额－重点产品18(不含税)</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>2</scale>
|
<type>Currency</type>
|
</fields>
|
<fields>
|
<fullName>OCM_Sales_Forecast_Product19_Number__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF (
|
OR(
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "GI") ,
|
PricebookEntry.Product2.Important_Rroduct_19GI__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "BF") ,
|
PricebookEntry.Product2.Important_Rroduct_19BF__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "GS") ,
|
PricebookEntry.Product2.Important_Rroduct_19GS__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "URO") ,
|
PricebookEntry.Product2.Important_Rroduct_19URO__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "GYN") ,
|
PricebookEntry.Product2.Important_Rroduct_19GYN__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "ENT") ,
|
PricebookEntry.Product2.Important_Rroduct_19ENT__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "OTH") ,
|
PricebookEntry.Product2.Important_Rroduct_19OTH__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "ET") ,
|
PricebookEntry.Product2.Important_Rroduct_19ET__c = true
|
)
|
),
|
"true",
|
"false"
|
)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>重点製品１９_有効</label>
|
<required>false</required>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>OCM_Sales_Forecast_Product19__c</fullName>
|
<description>OCSM预测发货金额－重点产品19(不含税)</description>
|
<externalId>false</externalId>
|
<formula>IF (
|
OR(
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "GI") ,
|
PricebookEntry.Product2.Important_Rroduct_19GI__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "BF") ,
|
PricebookEntry.Product2.Important_Rroduct_19BF__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "GS") ,
|
PricebookEntry.Product2.Important_Rroduct_19GS__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "URO") ,
|
PricebookEntry.Product2.Important_Rroduct_19URO__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "GYN") ,
|
PricebookEntry.Product2.Important_Rroduct_19GYN__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "ENT") ,
|
PricebookEntry.Product2.Important_Rroduct_19ENT__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "OTH") ,
|
PricebookEntry.Product2.Important_Rroduct_19OTH__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "ET") ,
|
PricebookEntry.Product2.Important_Rroduct_19ET__c = true
|
)
|
),
|
OCM_Sales_Forecast_Without_Tax__c,
|
0
|
)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>OCSM预测发货金额－重点产品19(不含税)</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>2</scale>
|
<type>Currency</type>
|
</fields>
|
<fields>
|
<fullName>OCM_Sales_Forecast_Product1_Number__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF (
|
OR(
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "GI") ,
|
PricebookEntry.Product2.Important_Rroduct_1GI__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "BF") ,
|
PricebookEntry.Product2.Important_Rroduct_1BF__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "GS") ,
|
PricebookEntry.Product2.Important_Rroduct_1GS__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "URO") ,
|
PricebookEntry.Product2.Important_Rroduct_1URO__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "GYN") ,
|
PricebookEntry.Product2.Important_Rroduct_1GYN__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "ENT") ,
|
PricebookEntry.Product2.Important_Rroduct_1ENT__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "OTH") ,
|
PricebookEntry.Product2.Important_Rroduct_1OTH__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "ET") ,
|
PricebookEntry.Product2.Important_Rroduct_1ET__c = true
|
)
|
),
|
"true",
|
"false"
|
)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>重点製品１_有効</label>
|
<required>false</required>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>OCM_Sales_Forecast_Product1__c</fullName>
|
<description>OCSM预测发货金额－重点产品1(不含税)</description>
|
<externalId>false</externalId>
|
<formula>IF (
|
OR(
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "GI") ,
|
PricebookEntry.Product2.Important_Rroduct_1GI__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "BF") ,
|
PricebookEntry.Product2.Important_Rroduct_1BF__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "GS") ,
|
PricebookEntry.Product2.Important_Rroduct_1GS__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "URO") ,
|
PricebookEntry.Product2.Important_Rroduct_1URO__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "GYN") ,
|
PricebookEntry.Product2.Important_Rroduct_1GYN__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "ENT") ,
|
PricebookEntry.Product2.Important_Rroduct_1ENT__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "OTH") ,
|
PricebookEntry.Product2.Important_Rroduct_1OTH__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "ET") ,
|
PricebookEntry.Product2.Important_Rroduct_1ET__c = true
|
)
|
),
|
OCM_Sales_Forecast_Without_Tax__c ,
|
0
|
)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>OCSM预测发货金额－重点产品1(不含税)</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>2</scale>
|
<type>Currency</type>
|
</fields>
|
<fields>
|
<fullName>OCM_Sales_Forecast_Product20_Number__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF (
|
OR(
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "GI") ,
|
PricebookEntry.Product2.Important_Rroduct_20GI__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "BF") ,
|
PricebookEntry.Product2.Important_Rroduct_20BF__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "GS") ,
|
PricebookEntry.Product2.Important_Rroduct_20GS__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "URO") ,
|
PricebookEntry.Product2.Important_Rroduct_20URO__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "GYN") ,
|
PricebookEntry.Product2.Important_Rroduct_20GYN__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "ENT") ,
|
PricebookEntry.Product2.Important_Rroduct_20ENT__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "OTH") ,
|
PricebookEntry.Product2.Important_Rroduct_20OTH__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "ET") ,
|
PricebookEntry.Product2.Important_Rroduct_20ET__c = true
|
)
|
),
|
"true",
|
"false"
|
)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>重点製品２０_有効</label>
|
<required>false</required>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>OCM_Sales_Forecast_Product20__c</fullName>
|
<description>OCSM预测发货金额－重点产品20(不含税)</description>
|
<externalId>false</externalId>
|
<formula>IF (
|
OR(
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "GI") ,
|
PricebookEntry.Product2.Important_Rroduct_20GI__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "BF") ,
|
PricebookEntry.Product2.Important_Rroduct_20BF__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "GS") ,
|
PricebookEntry.Product2.Important_Rroduct_20GS__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "URO") ,
|
PricebookEntry.Product2.Important_Rroduct_20URO__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "GYN") ,
|
PricebookEntry.Product2.Important_Rroduct_20GYN__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "ENT") ,
|
PricebookEntry.Product2.Important_Rroduct_20ENT__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "OTH") ,
|
PricebookEntry.Product2.Important_Rroduct_20OTH__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "ET") ,
|
PricebookEntry.Product2.Important_Rroduct_20ET__c = true
|
)
|
),
|
OCM_Sales_Forecast_Without_Tax__c,
|
0
|
)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>OCSM预测发货金额－重点产品20(不含税)</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>2</scale>
|
<type>Currency</type>
|
</fields>
|
<fields>
|
<fullName>OCM_Sales_Forecast_Product21_Number__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF (
|
OR(
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "GI") ,
|
PricebookEntry.Product2.Important_Rroduct_21GI__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "BF") ,
|
PricebookEntry.Product2.Important_Rroduct_21BF__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "GS") ,
|
PricebookEntry.Product2.Important_Rroduct_21GS__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "URO") ,
|
PricebookEntry.Product2.Important_Rroduct_21URO__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "GYN") ,
|
PricebookEntry.Product2.Important_Rroduct_21GYN__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "ENT") ,
|
PricebookEntry.Product2.Important_Rroduct_21ENT__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "OTH") ,
|
PricebookEntry.Product2.Important_Rroduct_21OTH__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "ET") ,
|
PricebookEntry.Product2.Important_Rroduct_21ET__c = true
|
)
|
),
|
"true",
|
"false"
|
)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>重点製品２１_有効</label>
|
<required>false</required>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>OCM_Sales_Forecast_Product21__c</fullName>
|
<description>OCSM预测发货金额－重点产品21(不含税)</description>
|
<externalId>false</externalId>
|
<formula>IF (
|
OR(
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "GI") ,
|
PricebookEntry.Product2.Important_Rroduct_21GI__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "BF") ,
|
PricebookEntry.Product2.Important_Rroduct_21BF__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "GS") ,
|
PricebookEntry.Product2.Important_Rroduct_21GS__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "URO") ,
|
PricebookEntry.Product2.Important_Rroduct_21URO__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "GYN") ,
|
PricebookEntry.Product2.Important_Rroduct_21GYN__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "ENT") ,
|
PricebookEntry.Product2.Important_Rroduct_21ENT__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "OTH") ,
|
PricebookEntry.Product2.Important_Rroduct_21OTH__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "ET") ,
|
PricebookEntry.Product2.Important_Rroduct_21ET__c = true
|
)
|
),
|
OCM_Sales_Forecast_Without_Tax__c,
|
0
|
)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>OCSM预测发货金额－重点产品21(不含税)</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>2</scale>
|
<type>Currency</type>
|
</fields>
|
<fields>
|
<fullName>OCM_Sales_Forecast_Product22_Number__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF (
|
OR(
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "GI") ,
|
PricebookEntry.Product2.Important_Rroduct_22GI__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "BF") ,
|
PricebookEntry.Product2.Important_Rroduct_22BF__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "GS") ,
|
PricebookEntry.Product2.Important_Rroduct_22GS__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "URO") ,
|
PricebookEntry.Product2.Important_Rroduct_22URO__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "GYN") ,
|
PricebookEntry.Product2.Important_Rroduct_22GYN__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "ENT") ,
|
PricebookEntry.Product2.Important_Rroduct_22ENT__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "OTH") ,
|
PricebookEntry.Product2.Important_Rroduct_22OTH__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "ET") ,
|
PricebookEntry.Product2.Important_Rroduct_22ET__c = true
|
)
|
),
|
"true",
|
"false"
|
)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>重点製品２２_有効</label>
|
<required>false</required>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>OCM_Sales_Forecast_Product22__c</fullName>
|
<description>OCSM预测发货金额－重点产品22(不含税)</description>
|
<externalId>false</externalId>
|
<formula>IF (
|
OR(
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "GI") ,
|
PricebookEntry.Product2.Important_Rroduct_22GI__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "BF") ,
|
PricebookEntry.Product2.Important_Rroduct_22BF__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "GS") ,
|
PricebookEntry.Product2.Important_Rroduct_22GS__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "URO") ,
|
PricebookEntry.Product2.Important_Rroduct_22URO__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "GYN") ,
|
PricebookEntry.Product2.Important_Rroduct_22GYN__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "ENT") ,
|
PricebookEntry.Product2.Important_Rroduct_22ENT__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "OTH") ,
|
PricebookEntry.Product2.Important_Rroduct_22OTH__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "ET") ,
|
PricebookEntry.Product2.Important_Rroduct_22ET__c = true
|
)
|
),
|
OCM_Sales_Forecast_Without_Tax__c,
|
0
|
)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>OCSM预测发货金额－重点产品22(不含税)</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>2</scale>
|
<type>Currency</type>
|
</fields>
|
<fields>
|
<fullName>OCM_Sales_Forecast_Product23_Number__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF (
|
OR(
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "GI") ,
|
PricebookEntry.Product2.Important_Rroduct_23GI__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "BF") ,
|
PricebookEntry.Product2.Important_Rroduct_23BF__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "GS") ,
|
PricebookEntry.Product2.Important_Rroduct_23GS__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "URO") ,
|
PricebookEntry.Product2.Important_Rroduct_23URO__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "GYN") ,
|
PricebookEntry.Product2.Important_Rroduct_23GYN__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "ENT") ,
|
PricebookEntry.Product2.Important_Rroduct_23ENT__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "OTH") ,
|
PricebookEntry.Product2.Important_Rroduct_23OTH__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "ET") ,
|
PricebookEntry.Product2.Important_Rroduct_23ET__c = true
|
)
|
),
|
"true",
|
"false"
|
)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>重点製品２３_有効</label>
|
<required>false</required>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>OCM_Sales_Forecast_Product23__c</fullName>
|
<description>OCSM预测发货金额－重点产品23(不含税)</description>
|
<externalId>false</externalId>
|
<formula>IF (
|
OR(
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "GI") ,
|
PricebookEntry.Product2.Important_Rroduct_23GI__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "BF") ,
|
PricebookEntry.Product2.Important_Rroduct_23BF__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "GS") ,
|
PricebookEntry.Product2.Important_Rroduct_23GS__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "URO") ,
|
PricebookEntry.Product2.Important_Rroduct_23URO__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "GYN") ,
|
PricebookEntry.Product2.Important_Rroduct_23GYN__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "ENT") ,
|
PricebookEntry.Product2.Important_Rroduct_23ENT__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "OTH") ,
|
PricebookEntry.Product2.Important_Rroduct_23OTH__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "ET") ,
|
PricebookEntry.Product2.Important_Rroduct_23ET__c = true
|
)
|
),
|
OCM_Sales_Forecast_Without_Tax__c,
|
0
|
)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>OCSM预测发货金额－重点产品23(不含税)</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>2</scale>
|
<type>Currency</type>
|
</fields>
|
<fields>
|
<fullName>OCM_Sales_Forecast_Product24_Number__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF (
|
OR(
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "GI") ,
|
PricebookEntry.Product2.Important_Rroduct_24GI__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "BF") ,
|
PricebookEntry.Product2.Important_Rroduct_24BF__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "GS") ,
|
PricebookEntry.Product2.Important_Rroduct_24GS__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "URO") ,
|
PricebookEntry.Product2.Important_Rroduct_24URO__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "GYN") ,
|
PricebookEntry.Product2.Important_Rroduct_24GYN__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "ENT") ,
|
PricebookEntry.Product2.Important_Rroduct_24ENT__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "OTH") ,
|
PricebookEntry.Product2.Important_Rroduct_24OTH__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "ET") ,
|
PricebookEntry.Product2.Important_Rroduct_24ET__c = true
|
)
|
),
|
"true",
|
"false"
|
)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>重点製品２４_有効</label>
|
<required>false</required>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>OCM_Sales_Forecast_Product24__c</fullName>
|
<description>OCSM预测发货金额－重点产品24(不含税)</description>
|
<externalId>false</externalId>
|
<formula>IF (
|
OR(
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "GI") ,
|
PricebookEntry.Product2.Important_Rroduct_24GI__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "BF") ,
|
PricebookEntry.Product2.Important_Rroduct_24BF__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "GS") ,
|
PricebookEntry.Product2.Important_Rroduct_24GS__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "URO") ,
|
PricebookEntry.Product2.Important_Rroduct_24URO__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "GYN") ,
|
PricebookEntry.Product2.Important_Rroduct_24GYN__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "ENT") ,
|
PricebookEntry.Product2.Important_Rroduct_24ENT__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "OTH") ,
|
PricebookEntry.Product2.Important_Rroduct_24OTH__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "ET") ,
|
PricebookEntry.Product2.Important_Rroduct_24ET__c = true
|
)
|
),
|
OCM_Sales_Forecast_Without_Tax__c,
|
0
|
)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>OCSM预测发货金额－重点产品24(不含税)</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>2</scale>
|
<type>Currency</type>
|
</fields>
|
<fields>
|
<fullName>OCM_Sales_Forecast_Product25_Number__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF (
|
OR(
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "GI") ,
|
PricebookEntry.Product2.Important_Rroduct_25GI__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "BF") ,
|
PricebookEntry.Product2.Important_Rroduct_25BF__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "GS") ,
|
PricebookEntry.Product2.Important_Rroduct_25GS__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "URO") ,
|
PricebookEntry.Product2.Important_Rroduct_25URO__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "GYN") ,
|
PricebookEntry.Product2.Important_Rroduct_25GYN__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "ENT") ,
|
PricebookEntry.Product2.Important_Rroduct_25ENT__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "OTH") ,
|
PricebookEntry.Product2.Important_Rroduct_25OTH__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "ET") ,
|
PricebookEntry.Product2.Important_Rroduct_25ET__c = true
|
)
|
),
|
"true",
|
"false"
|
)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>重点製品２５_有効</label>
|
<required>false</required>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>OCM_Sales_Forecast_Product25__c</fullName>
|
<description>OCSM预测发货金额－重点产品25(不含税)</description>
|
<externalId>false</externalId>
|
<formula>IF (
|
OR(
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "GI") ,
|
PricebookEntry.Product2.Important_Rroduct_25GI__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "BF") ,
|
PricebookEntry.Product2.Important_Rroduct_25BF__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "GS") ,
|
PricebookEntry.Product2.Important_Rroduct_25GS__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "URO") ,
|
PricebookEntry.Product2.Important_Rroduct_25URO__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "GYN") ,
|
PricebookEntry.Product2.Important_Rroduct_25GYN__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "ENT") ,
|
PricebookEntry.Product2.Important_Rroduct_25ENT__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "OTH") ,
|
PricebookEntry.Product2.Important_Rroduct_25OTH__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "ET") ,
|
PricebookEntry.Product2.Important_Rroduct_25ET__c = true
|
)
|
),
|
OCM_Sales_Forecast_Without_Tax__c,
|
0
|
)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>OCSM预测发货金额－重点产品25(不含税)</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>2</scale>
|
<type>Currency</type>
|
</fields>
|
<fields>
|
<fullName>OCM_Sales_Forecast_Product26_Number__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF (
|
OR(
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "GI") ,
|
PricebookEntry.Product2.Important_Rroduct_26GI__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "BF") ,
|
PricebookEntry.Product2.Important_Rroduct_26BF__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "GS") ,
|
PricebookEntry.Product2.Important_Rroduct_26GS__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "URO") ,
|
PricebookEntry.Product2.Important_Rroduct_26URO__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "GYN") ,
|
PricebookEntry.Product2.Important_Rroduct_26GYN__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "ENT") ,
|
PricebookEntry.Product2.Important_Rroduct_26ENT__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "OTH") ,
|
PricebookEntry.Product2.Important_Rroduct_26OTH__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "ET") ,
|
PricebookEntry.Product2.Important_Rroduct_26ET__c = true
|
)
|
),
|
"true",
|
"false"
|
)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>重点製品２６_有効</label>
|
<required>false</required>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>OCM_Sales_Forecast_Product26__c</fullName>
|
<description>OCSM预测发货金额－重点产品26(不含税)</description>
|
<externalId>false</externalId>
|
<formula>IF (
|
OR(
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "GI") ,
|
PricebookEntry.Product2.Important_Rroduct_26GI__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "BF") ,
|
PricebookEntry.Product2.Important_Rroduct_26BF__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "GS") ,
|
PricebookEntry.Product2.Important_Rroduct_26GS__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "URO") ,
|
PricebookEntry.Product2.Important_Rroduct_26URO__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "GYN") ,
|
PricebookEntry.Product2.Important_Rroduct_26GYN__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "ENT") ,
|
PricebookEntry.Product2.Important_Rroduct_26ENT__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "OTH") ,
|
PricebookEntry.Product2.Important_Rroduct_26OTH__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "ET") ,
|
PricebookEntry.Product2.Important_Rroduct_26ET__c = true
|
)
|
),
|
OCM_Sales_Forecast_Without_Tax__c,
|
0
|
)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>OCSM预测发货金额－重点产品26(不含税)</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>2</scale>
|
<type>Currency</type>
|
</fields>
|
<fields>
|
<fullName>OCM_Sales_Forecast_Product27_Number__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF (
|
OR(
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "GI") ,
|
PricebookEntry.Product2.Important_Rroduct_27GI__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "BF") ,
|
PricebookEntry.Product2.Important_Rroduct_27BF__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "GS") ,
|
PricebookEntry.Product2.Important_Rroduct_27GS__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "URO") ,
|
PricebookEntry.Product2.Important_Rroduct_27URO__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "GYN") ,
|
PricebookEntry.Product2.Important_Rroduct_27GYN__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "ENT") ,
|
PricebookEntry.Product2.Important_Rroduct_27ENT__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "OTH") ,
|
PricebookEntry.Product2.Important_Rroduct_27OTH__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "ET") ,
|
PricebookEntry.Product2.Important_Rroduct_27ET__c = true
|
)
|
),
|
"true",
|
"false"
|
)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>重点製品２７_有効</label>
|
<required>false</required>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>OCM_Sales_Forecast_Product27__c</fullName>
|
<description>OCSM预测发货金额－重点产品27(不含税)</description>
|
<externalId>false</externalId>
|
<formula>IF (
|
OR(
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "GI") ,
|
PricebookEntry.Product2.Important_Rroduct_27GI__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "BF") ,
|
PricebookEntry.Product2.Important_Rroduct_27BF__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "GS") ,
|
PricebookEntry.Product2.Important_Rroduct_27GS__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "URO") ,
|
PricebookEntry.Product2.Important_Rroduct_27URO__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "GYN") ,
|
PricebookEntry.Product2.Important_Rroduct_27GYN__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "ENT") ,
|
PricebookEntry.Product2.Important_Rroduct_27ENT__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "OTH") ,
|
PricebookEntry.Product2.Important_Rroduct_27OTH__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "ET") ,
|
PricebookEntry.Product2.Important_Rroduct_27ET__c = true
|
)
|
),
|
OCM_Sales_Forecast_Without_Tax__c,
|
0
|
)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>OCSM预测发货金额－重点产品27(不含税)</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>2</scale>
|
<type>Currency</type>
|
</fields>
|
<fields>
|
<fullName>OCM_Sales_Forecast_Product28_Number__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF (
|
OR(
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "GI") ,
|
PricebookEntry.Product2.Important_Rroduct_28GI__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "BF") ,
|
PricebookEntry.Product2.Important_Rroduct_28BF__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "GS") ,
|
PricebookEntry.Product2.Important_Rroduct_28GS__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "URO") ,
|
PricebookEntry.Product2.Important_Rroduct_28URO__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "GYN") ,
|
PricebookEntry.Product2.Important_Rroduct_28GYN__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "ENT") ,
|
PricebookEntry.Product2.Important_Rroduct_28ENT__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "OTH") ,
|
PricebookEntry.Product2.Important_Rroduct_28OTH__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "ET") ,
|
PricebookEntry.Product2.Important_Rroduct_28ET__c = true
|
)
|
),
|
"true",
|
"false"
|
)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>重点製品２８_有効</label>
|
<required>false</required>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>OCM_Sales_Forecast_Product28__c</fullName>
|
<description>OCSM预测发货金额－重点产品28(不含税)</description>
|
<externalId>false</externalId>
|
<formula>IF (
|
OR(
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "GI") ,
|
PricebookEntry.Product2.Important_Rroduct_28GI__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "BF") ,
|
PricebookEntry.Product2.Important_Rroduct_28BF__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "GS") ,
|
PricebookEntry.Product2.Important_Rroduct_28GS__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "URO") ,
|
PricebookEntry.Product2.Important_Rroduct_28URO__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "GYN") ,
|
PricebookEntry.Product2.Important_Rroduct_28GYN__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "ENT") ,
|
PricebookEntry.Product2.Important_Rroduct_28ENT__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "OTH") ,
|
PricebookEntry.Product2.Important_Rroduct_28OTH__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "ET") ,
|
PricebookEntry.Product2.Important_Rroduct_28ET__c = true
|
)
|
),
|
OCM_Sales_Forecast_Without_Tax__c,
|
0
|
)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>OCSM预测发货金额－重点产品28(不含税)</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>2</scale>
|
<type>Currency</type>
|
</fields>
|
<fields>
|
<fullName>OCM_Sales_Forecast_Product29_Number__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF (
|
OR(
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "GI") ,
|
PricebookEntry.Product2.Important_Rroduct_29GI__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "BF") ,
|
PricebookEntry.Product2.Important_Rroduct_29BF__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "GS") ,
|
PricebookEntry.Product2.Important_Rroduct_29GS__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "URO") ,
|
PricebookEntry.Product2.Important_Rroduct_29URO__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "GYN") ,
|
PricebookEntry.Product2.Important_Rroduct_29GYN__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "ENT") ,
|
PricebookEntry.Product2.Important_Rroduct_29ENT__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "OTH") ,
|
PricebookEntry.Product2.Important_Rroduct_29OTH__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "ET") ,
|
PricebookEntry.Product2.Important_Rroduct_29ET__c = true
|
)
|
),
|
"true",
|
"false"
|
)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>重点製品２９_有効</label>
|
<required>false</required>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>OCM_Sales_Forecast_Product29__c</fullName>
|
<description>OCSM预测发货金额－重点产品29(不含税)</description>
|
<externalId>false</externalId>
|
<formula>IF (
|
OR(
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "GI") ,
|
PricebookEntry.Product2.Important_Rroduct_29GI__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "BF") ,
|
PricebookEntry.Product2.Important_Rroduct_29BF__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "GS") ,
|
PricebookEntry.Product2.Important_Rroduct_29GS__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "URO") ,
|
PricebookEntry.Product2.Important_Rroduct_29URO__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "GYN") ,
|
PricebookEntry.Product2.Important_Rroduct_29GYN__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "ENT") ,
|
PricebookEntry.Product2.Important_Rroduct_29ENT__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "OTH") ,
|
PricebookEntry.Product2.Important_Rroduct_29OTH__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "ET") ,
|
PricebookEntry.Product2.Important_Rroduct_29ET__c = true
|
)
|
),
|
OCM_Sales_Forecast_Without_Tax__c,
|
0
|
)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>OCSM预测发货金额－重点产品29(不含税)</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>2</scale>
|
<type>Currency</type>
|
</fields>
|
<fields>
|
<fullName>OCM_Sales_Forecast_Product2_Number__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF (
|
OR(
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "GI") ,
|
PricebookEntry.Product2.Important_Rroduct_2GI__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "BF") ,
|
PricebookEntry.Product2.Important_Rroduct_2BF__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "GS") ,
|
PricebookEntry.Product2.Important_Rroduct_2GS__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "URO") ,
|
PricebookEntry.Product2.Important_Rroduct_2URO__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "GYN") ,
|
PricebookEntry.Product2.Important_Rroduct_2GYN__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "ENT") ,
|
PricebookEntry.Product2.Important_Rroduct_2ENT__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "OTH") ,
|
PricebookEntry.Product2.Important_Rroduct_2OTH__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "ET") ,
|
PricebookEntry.Product2.Important_Rroduct_2ET__c = true
|
)
|
),
|
"true",
|
"false"
|
)</formula>
|
<label>重点製品２_有効</label>
|
<required>false</required>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>OCM_Sales_Forecast_Product2__c</fullName>
|
<description>OCSM预测发货金额－重点产品2(不含税)</description>
|
<externalId>false</externalId>
|
<formula>IF (
|
OR(
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "GI") ,
|
PricebookEntry.Product2.Important_Rroduct_2GI__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "BF") ,
|
PricebookEntry.Product2.Important_Rroduct_2BF__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "GS") ,
|
PricebookEntry.Product2.Important_Rroduct_2GS__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "URO") ,
|
PricebookEntry.Product2.Important_Rroduct_2URO__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "GYN") ,
|
PricebookEntry.Product2.Important_Rroduct_2GYN__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "ENT") ,
|
PricebookEntry.Product2.Important_Rroduct_2ENT__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "OTH") ,
|
PricebookEntry.Product2.Important_Rroduct_2OTH__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "ET") ,
|
PricebookEntry.Product2.Important_Rroduct_2ET__c = true
|
)
|
),
|
OCM_Sales_Forecast_Without_Tax__c ,
|
0
|
)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>OCSM预测发货金额－重点产品2(不含税)</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>2</scale>
|
<type>Currency</type>
|
</fields>
|
<fields>
|
<fullName>OCM_Sales_Forecast_Product30_Number__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF (
|
OR(
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "GI") ,
|
PricebookEntry.Product2.Important_Rroduct_30GI__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "BF") ,
|
PricebookEntry.Product2.Important_Rroduct_30BF__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "GS") ,
|
PricebookEntry.Product2.Important_Rroduct_30GS__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "URO") ,
|
PricebookEntry.Product2.Important_Rroduct_30URO__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "GYN") ,
|
PricebookEntry.Product2.Important_Rroduct_30GYN__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "ENT") ,
|
PricebookEntry.Product2.Important_Rroduct_30ENT__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "OTH") ,
|
PricebookEntry.Product2.Important_Rroduct_30OTH__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "ET") ,
|
PricebookEntry.Product2.Important_Rroduct_30ET__c = true
|
)
|
),
|
"true",
|
"false"
|
)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>重点製品３０_有効</label>
|
<required>false</required>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>OCM_Sales_Forecast_Product30__c</fullName>
|
<description>OCSM预测发货金额－重点产品30(不含税)</description>
|
<externalId>false</externalId>
|
<formula>IF (
|
OR(
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "GI") ,
|
PricebookEntry.Product2.Important_Rroduct_30GI__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "BF") ,
|
PricebookEntry.Product2.Important_Rroduct_30BF__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "GS") ,
|
PricebookEntry.Product2.Important_Rroduct_30GS__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "URO") ,
|
PricebookEntry.Product2.Important_Rroduct_30URO__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "GYN") ,
|
PricebookEntry.Product2.Important_Rroduct_30GYN__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "ENT") ,
|
PricebookEntry.Product2.Important_Rroduct_30ENT__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "OTH") ,
|
PricebookEntry.Product2.Important_Rroduct_30OTH__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "ET") ,
|
PricebookEntry.Product2.Important_Rroduct_30ET__c = true
|
)
|
),
|
OCM_Sales_Forecast_Without_Tax__c,
|
0
|
)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>OCSM预测发货金额－重点产品30(不含税)</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>2</scale>
|
<type>Currency</type>
|
</fields>
|
<fields>
|
<fullName>OCM_Sales_Forecast_Product3_Number__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF (
|
OR(
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "GI") ,
|
PricebookEntry.Product2.Important_Rroduct_3GI__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "BF") ,
|
PricebookEntry.Product2.Important_Rroduct_3BF__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "GS") ,
|
PricebookEntry.Product2.Important_Rroduct_3GS__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "URO") ,
|
PricebookEntry.Product2.Important_Rroduct_3URO__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "GYN") ,
|
PricebookEntry.Product2.Important_Rroduct_3GYN__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "ENT") ,
|
PricebookEntry.Product2.Important_Rroduct_3ENT__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "OTH") ,
|
PricebookEntry.Product2.Important_Rroduct_3OTH__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "ET") ,
|
PricebookEntry.Product2.Important_Rroduct_3ET__c = true
|
)
|
),
|
"true",
|
"false"
|
)</formula>
|
<label>重点製品３_有効</label>
|
<required>false</required>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>OCM_Sales_Forecast_Product3__c</fullName>
|
<description>OCSM预测发货金额－重点产品3(不含税)</description>
|
<externalId>false</externalId>
|
<formula>IF (
|
OR(
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "GI") ,
|
PricebookEntry.Product2.Important_Rroduct_3GI__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "BF") ,
|
PricebookEntry.Product2.Important_Rroduct_3BF__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "GS") ,
|
PricebookEntry.Product2.Important_Rroduct_3GS__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "URO") ,
|
PricebookEntry.Product2.Important_Rroduct_3URO__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "GYN") ,
|
PricebookEntry.Product2.Important_Rroduct_3GYN__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "ENT") ,
|
PricebookEntry.Product2.Important_Rroduct_3ENT__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "OTH") ,
|
PricebookEntry.Product2.Important_Rroduct_3OTH__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "ET") ,
|
PricebookEntry.Product2.Important_Rroduct_3ET__c = true
|
)
|
),
|
OCM_Sales_Forecast_Without_Tax__c ,
|
0
|
)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>OCSM预测发货金额－重点产品3(不含税)</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>2</scale>
|
<type>Currency</type>
|
</fields>
|
<fields>
|
<fullName>OCM_Sales_Forecast_Product4_Number__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF (
|
OR(
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "GI") ,
|
PricebookEntry.Product2.Important_Rroduct_4GI__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "BF") ,
|
PricebookEntry.Product2.Important_Rroduct_4BF__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "GS") ,
|
PricebookEntry.Product2.Important_Rroduct_4GS__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "URO") ,
|
PricebookEntry.Product2.Important_Rroduct_4URO__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "GYN") ,
|
PricebookEntry.Product2.Important_Rroduct_4GYN__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "ENT") ,
|
PricebookEntry.Product2.Important_Rroduct_4ENT__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "OTH") ,
|
PricebookEntry.Product2.Important_Rroduct_4OTH__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "ET") ,
|
PricebookEntry.Product2.Important_Rroduct_4ET__c = true
|
)
|
),
|
"true",
|
"false"
|
)</formula>
|
<label>重点製品４_有効</label>
|
<required>false</required>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>OCM_Sales_Forecast_Product4__c</fullName>
|
<description>OCSM预测发货金额－重点产品4(不含税)</description>
|
<externalId>false</externalId>
|
<formula>IF (
|
OR(
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "GI") ,
|
PricebookEntry.Product2.Important_Rroduct_4GI__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "BF") ,
|
PricebookEntry.Product2.Important_Rroduct_4BF__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "GS") ,
|
PricebookEntry.Product2.Important_Rroduct_4GS__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "URO") ,
|
PricebookEntry.Product2.Important_Rroduct_4URO__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "GYN") ,
|
PricebookEntry.Product2.Important_Rroduct_4GYN__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "ENT") ,
|
PricebookEntry.Product2.Important_Rroduct_4ENT__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "OTH") ,
|
PricebookEntry.Product2.Important_Rroduct_4OTH__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "ET") ,
|
PricebookEntry.Product2.Important_Rroduct_4ET__c = true
|
)
|
),
|
OCM_Sales_Forecast_Without_Tax__c ,
|
0
|
)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>OCSM预测发货金额－重点产品4(不含税)</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>2</scale>
|
<type>Currency</type>
|
</fields>
|
<fields>
|
<fullName>OCM_Sales_Forecast_Product5_Number__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF (
|
OR(
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "GI") ,
|
PricebookEntry.Product2.Important_Rroduct_5GI__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "BF") ,
|
PricebookEntry.Product2.Important_Rroduct_5BF__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "GS") ,
|
PricebookEntry.Product2.Important_Rroduct_5GS__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "URO") ,
|
PricebookEntry.Product2.Important_Rroduct_5URO__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "GYN") ,
|
PricebookEntry.Product2.Important_Rroduct_5GYN__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "ENT") ,
|
PricebookEntry.Product2.Important_Rroduct_5ENT__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "OTH") ,
|
PricebookEntry.Product2.Important_Rroduct_5OTH__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "ET") ,
|
PricebookEntry.Product2.Important_Rroduct_5ET__c = true
|
)
|
),
|
"true",
|
"false"
|
)</formula>
|
<label>重点製品５_有効</label>
|
<required>false</required>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>OCM_Sales_Forecast_Product5__c</fullName>
|
<description>OCSM预测发货金额－重点产品5(不含税)</description>
|
<externalId>false</externalId>
|
<formula>IF (
|
OR(
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "GI") ,
|
PricebookEntry.Product2.Important_Rroduct_5GI__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "BF") ,
|
PricebookEntry.Product2.Important_Rroduct_5BF__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "GS") ,
|
PricebookEntry.Product2.Important_Rroduct_5GS__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "URO") ,
|
PricebookEntry.Product2.Important_Rroduct_5URO__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "GYN") ,
|
PricebookEntry.Product2.Important_Rroduct_5GYN__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "ENT") ,
|
PricebookEntry.Product2.Important_Rroduct_5ENT__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "OTH") ,
|
PricebookEntry.Product2.Important_Rroduct_5OTH__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "ET") ,
|
PricebookEntry.Product2.Important_Rroduct_5ET__c = true
|
)
|
),
|
OCM_Sales_Forecast_Without_Tax__c ,
|
0
|
)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>OCSM预测发货金额－重点产品5(不含税)</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>2</scale>
|
<type>Currency</type>
|
</fields>
|
<fields>
|
<fullName>OCM_Sales_Forecast_Product6_Number__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF (
|
OR(
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "GI") ,
|
PricebookEntry.Product2.Important_Rroduct_6GI__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "BF") ,
|
PricebookEntry.Product2.Important_Rroduct_6BF__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "GS") ,
|
PricebookEntry.Product2.Important_Rroduct_6GS__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "URO") ,
|
PricebookEntry.Product2.Important_Rroduct_6URO__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "GYN") ,
|
PricebookEntry.Product2.Important_Rroduct_6GYN__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "ENT") ,
|
PricebookEntry.Product2.Important_Rroduct_6ENT__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "OTH") ,
|
PricebookEntry.Product2.Important_Rroduct_6OTH__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "ET") ,
|
PricebookEntry.Product2.Important_Rroduct_6ET__c = true
|
)
|
),
|
"true",
|
"false"
|
)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>重点製品６_有効</label>
|
<required>false</required>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>OCM_Sales_Forecast_Product6__c</fullName>
|
<description>OCSM预测发货金额－重点产品6(不含税)</description>
|
<externalId>false</externalId>
|
<formula>IF (
|
OR(
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "GI") ,
|
PricebookEntry.Product2.Important_Rroduct_6GI__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "BF") ,
|
PricebookEntry.Product2.Important_Rroduct_6BF__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "GS") ,
|
PricebookEntry.Product2.Important_Rroduct_6GS__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "URO") ,
|
PricebookEntry.Product2.Important_Rroduct_6URO__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "GYN") ,
|
PricebookEntry.Product2.Important_Rroduct_6GYN__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "ENT") ,
|
PricebookEntry.Product2.Important_Rroduct_6ENT__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "OTH") ,
|
PricebookEntry.Product2.Important_Rroduct_6OTH__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "ET") ,
|
PricebookEntry.Product2.Important_Rroduct_6ET__c = true
|
)
|
),
|
OCM_Sales_Forecast_Without_Tax__c,
|
0
|
)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>OCSM预测发货金额－重点产品6(不含税)</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>2</scale>
|
<type>Currency</type>
|
</fields>
|
<fields>
|
<fullName>OCM_Sales_Forecast_Product7_Number__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF (
|
OR(
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "GI") ,
|
PricebookEntry.Product2.Important_Rroduct_7GI__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "BF") ,
|
PricebookEntry.Product2.Important_Rroduct_7BF__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "GS") ,
|
PricebookEntry.Product2.Important_Rroduct_7GS__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "URO") ,
|
PricebookEntry.Product2.Important_Rroduct_7URO__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "GYN") ,
|
PricebookEntry.Product2.Important_Rroduct_7GYN__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "ENT") ,
|
PricebookEntry.Product2.Important_Rroduct_7ENT__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "OTH") ,
|
PricebookEntry.Product2.Important_Rroduct_7OTH__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "ET") ,
|
PricebookEntry.Product2.Important_Rroduct_7ET__c = true
|
)
|
),
|
"true",
|
"false"
|
)</formula>
|
<label>重点製品７_有効</label>
|
<required>false</required>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>OCM_Sales_Forecast_Product7__c</fullName>
|
<description>OCSM预测发货金额－重点产品7(不含税)</description>
|
<externalId>false</externalId>
|
<formula>IF (
|
OR(
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "GI") ,
|
PricebookEntry.Product2.Important_Rroduct_7GI__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "BF") ,
|
PricebookEntry.Product2.Important_Rroduct_7BF__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "GS") ,
|
PricebookEntry.Product2.Important_Rroduct_7GS__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "URO") ,
|
PricebookEntry.Product2.Important_Rroduct_7URO__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "GYN") ,
|
PricebookEntry.Product2.Important_Rroduct_7GYN__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "ENT") ,
|
PricebookEntry.Product2.Important_Rroduct_7ENT__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "OTH") ,
|
PricebookEntry.Product2.Important_Rroduct_7OTH__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "ET") ,
|
PricebookEntry.Product2.Important_Rroduct_7ET__c = true
|
)
|
),
|
OCM_Sales_Forecast_Without_Tax__c ,
|
0
|
)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>OCSM预测发货金额－重点产品7(不含税)</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>2</scale>
|
<type>Currency</type>
|
</fields>
|
<fields>
|
<fullName>OCM_Sales_Forecast_Product8_Number__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF (
|
OR(
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "GI") ,
|
PricebookEntry.Product2.Important_Rroduct_8GI__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "BF") ,
|
PricebookEntry.Product2.Important_Rroduct_8BF__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "GS") ,
|
PricebookEntry.Product2.Important_Rroduct_8GS__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "URO") ,
|
PricebookEntry.Product2.Important_Rroduct_8URO__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "GYN") ,
|
PricebookEntry.Product2.Important_Rroduct_8GYN__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "ENT") ,
|
PricebookEntry.Product2.Important_Rroduct_8ENT__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "OTH") ,
|
PricebookEntry.Product2.Important_Rroduct_8OTH__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "ET") ,
|
PricebookEntry.Product2.Important_Rroduct_8ET__c = true
|
)
|
),
|
"true",
|
"false"
|
)</formula>
|
<label>重点製品８_有効</label>
|
<required>false</required>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>OCM_Sales_Forecast_Product8__c</fullName>
|
<description>OCSM预测发货金额－重点产品8(不含税)</description>
|
<externalId>false</externalId>
|
<formula>IF (
|
OR(
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "GI") ,
|
PricebookEntry.Product2.Important_Rroduct_8GI__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "BF") ,
|
PricebookEntry.Product2.Important_Rroduct_8BF__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "GS") ,
|
PricebookEntry.Product2.Important_Rroduct_8GS__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "URO") ,
|
PricebookEntry.Product2.Important_Rroduct_8URO__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "GYN") ,
|
PricebookEntry.Product2.Important_Rroduct_8GYN__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "ENT") ,
|
PricebookEntry.Product2.Important_Rroduct_8ENT__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "OTH") ,
|
PricebookEntry.Product2.Important_Rroduct_8OTH__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "ET") ,
|
PricebookEntry.Product2.Important_Rroduct_8ET__c = true
|
)
|
),
|
OCM_Sales_Forecast_Without_Tax__c ,
|
0
|
)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>OCSM预测发货金额－重点产品8(不含税)</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>2</scale>
|
<type>Currency</type>
|
</fields>
|
<fields>
|
<fullName>OCM_Sales_Forecast_Product9_Number__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF (
|
OR(
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "GI") ,
|
PricebookEntry.Product2.Important_Rroduct_9GI__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "BF") ,
|
PricebookEntry.Product2.Important_Rroduct_9BF__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "GS") ,
|
PricebookEntry.Product2.Important_Rroduct_9GS__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "URO") ,
|
PricebookEntry.Product2.Important_Rroduct_9URO__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "GYN") ,
|
PricebookEntry.Product2.Important_Rroduct_9GYN__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "ENT") ,
|
PricebookEntry.Product2.Important_Rroduct_9ENT__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "OTH") ,
|
PricebookEntry.Product2.Important_Rroduct_9OTH__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "ET") ,
|
PricebookEntry.Product2.Important_Rroduct_9ET__c = true
|
)
|
),
|
"true",
|
"false"
|
)</formula>
|
<label>重点製品９_有効</label>
|
<required>false</required>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>OCM_Sales_Forecast_Product9__c</fullName>
|
<description>OCSM预测发货金额－重点产品9(不含税)</description>
|
<externalId>false</externalId>
|
<formula>IF (
|
OR(
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "GI") ,
|
PricebookEntry.Product2.Important_Rroduct_9GI__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "BF") ,
|
PricebookEntry.Product2.Important_Rroduct_9BF__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "GS") ,
|
PricebookEntry.Product2.Important_Rroduct_9GS__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "URO") ,
|
PricebookEntry.Product2.Important_Rroduct_9URO__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "GYN") ,
|
PricebookEntry.Product2.Important_Rroduct_9GYN__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "ENT") ,
|
PricebookEntry.Product2.Important_Rroduct_9ENT__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "OTH") ,
|
PricebookEntry.Product2.Important_Rroduct_9OTH__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "ET") ,
|
PricebookEntry.Product2.Important_Rroduct_9ET__c = true
|
)
|
),
|
OCM_Sales_Forecast_Without_Tax__c ,
|
0
|
)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>OCSM预测发货金额－重点产品9(不含税)</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>2</scale>
|
<type>Currency</type>
|
</fields>
|
<fields>
|
<fullName>OCM_Sales_Forecast_Product_Number1__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF (
|
OR(
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "GI") ,
|
PricebookEntry.Product2.Important_Rroduct_1GI__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "BF") ,
|
PricebookEntry.Product2.Important_Rroduct_1BF__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "GS") ,
|
PricebookEntry.Product2.Important_Rroduct_1GS__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "URO") ,
|
PricebookEntry.Product2.Important_Rroduct_1URO__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "GYN") ,
|
PricebookEntry.Product2.Important_Rroduct_1GYN__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "ENT") ,
|
PricebookEntry.Product2.Important_Rroduct_1ENT__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "OTH") ,
|
PricebookEntry.Product2.Important_Rroduct_1OTH__c = true
|
),
|
AND(
|
ISPICKVAL( Opportunity.Opportunity_Category__c , "ET") ,
|
PricebookEntry.Product2.Important_Rroduct_1ET__c = true
|
)
|
),
|
"true",
|
"false"
|
)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>重点製品１_有効</label>
|
<required>false</required>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>OCM_Sales_Forecast_Without_Tax__c</fullName>
|
<description>OCM_Sales_Forecast_F__c /1.17
|
|
名字由 OCM预测成交金额（不含税） 变为 OCM预测成交金额</description>
|
<externalId>false</externalId>
|
<formula>IF( ISBLANK( Opportunity.Estimation_Id__c ) , 0,
|
Case( Opportunity.Trade__c,
|
"内貿", OCM_Sales_Forecast__c /Opportunity.Tax_Intra_F_Copy__c,
|
"外貿", OCM_Sales_Forecast__c * Opportunity.Tax_Foreign_F_Copy__c,
|
OCM_Sales_Forecast__c * 1
|
) )</formula>
|
<label>OCSM预测成交金额(不含税,已转换)</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>2</scale>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>OCM_Sales_Forecast__c</fullName>
|
<externalId>false</externalId>
|
<label>/OCSM预测成交金额(含税)</label>
|
<precision>15</precision>
|
<required>false</required>
|
<scale>2</scale>
|
<type>Currency</type>
|
</fields>
|
<fields>
|
<fullName>OCM_category__c</fullName>
|
<externalId>false</externalId>
|
<formula>Opportunity.OCM__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>OCSM分类</label>
|
<required>false</required>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>OCM_internal_product_name__c</fullName>
|
<externalId>false</externalId>
|
<formula>PricebookEntry.Product2.Asset_Model_No__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>OCSM内部产品型号</label>
|
<required>false</required>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>OCM_man_province__c</fullName>
|
<externalId>false</externalId>
|
<formula>Opportunity.OCM_man_province__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>OCSM管理省</label>
|
<required>false</required>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>OCM_man_province_txt__c</fullName>
|
<externalId>false</externalId>
|
<label>OCSM管理省(文本)</label>
|
<length>255</length>
|
<required>false</required>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>OCSMRMB_Without_Tax__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF( ISBLANK( Opportunity.Estimation_Id__c ) , 0, Case( Opportunity.Trade__c,
|
"内貿",OCSM_RMB__c/ Opportunity.Tax_Intra_F_Copy__c ,
|
"外貿", OCSM_RMB__c * Opportunity.Tax_Foreign_F_Copy__c,
|
TotalPrice__c* 1
|
) - GuranteePriceSum__c)</formula>
|
<label>OCSM产品预测成交金额（不含税）</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>2</scale>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>OCSM_RMB_Without_Tax_1000TR__c</fullName>
|
<externalId>false</externalId>
|
<formula>CASE(Opportunity.Competitor__c ,
|
'A1', OCSMRMB_Without_Tax__c* 1/1000,
|
'A', OCSMRMB_Without_Tax__c* 0.8/1000,
|
'B', OCSMRMB_Without_Tax__c* 0.5/1000,
|
'C', OCSMRMB_Without_Tax__c* 0.3/1000,
|
'D', 0,
|
'E', 0,
|
0)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>OCSM产品预测金额(换算值，千元RMB)</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>2</scale>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>OCSM_RMB_Without_Tax_1000__c</fullName>
|
<externalId>false</externalId>
|
<formula>OCSMRMB_Without_Tax__c/1000</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>OCSM产品预测金额</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>2</scale>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>OCSM_RMB__c</fullName>
|
<description>20201030BK调整为先除以税再减计提
|
if( Datevalue(CreatedDate) < DATE(2019,1,1) || Opportunity.opp_quotes_num__c = 0 ,OCM_Sales_Forecast__c - GuranteePriceSum__c , AgencySubtotal__c - GuranteePriceSum__c)</description>
|
<externalId>false</externalId>
|
<formula>IF( ISBLANK( Opportunity.Estimation_Id__c ) , 0,
|
if( Datevalue(CreatedDate) < DATE(2019,1,1) || Opportunity.opp_quotes_num__c = 0 ,OCM_Sales_Forecast__c , AgencySubtotal__c )
|
)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>OCSM产品预测成交金额（含税）</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>2</scale>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>OER_AW__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(PricebookEntry.Product2.Important_Rroduct_4GI__c = true, Quantity ,0)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>OER-AW(台)</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Objective_146P__c</fullName>
|
<description>不使用</description>
|
<externalId>false</externalId>
|
<label>XXX1.目標金額(不含税)</label>
|
<precision>15</precision>
|
<required>false</required>
|
<scale>2</scale>
|
<type>Currency</type>
|
</fields>
|
<fields>
|
<fullName>Objective__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(IsPickval(Opportunity.Target_category__c, '重点产品目标(数量)') || IsPickval(Opportunity.Target_category__c, '担当重点产品目标') || IsPickval(Opportunity.Target_category__c, '省重点产品目标')
|
, IF(Opportunity.Proportion__c > 0, Opportunity.Proportion__c * UnitPrice, Objective_146P__c)
|
, 0
|
)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>1.目標金額(不含税)</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>4</scale>
|
<type>Currency</type>
|
</fields>
|
<fields>
|
<fullName>Opp_Actual2_200Scope__c</fullName>
|
<description>产品分类4 = GIF,CF,JF,SIF，产品分类5 = 260系列，240系列，200系列其他</description>
|
<externalId>false</externalId>
|
<formula>CASE( Opportunity.StageName , "出荷",
|
IF(
|
AND(
|
OR((PricebookEntry.Product2.Category5__c = "260系列"),(PricebookEntry.Product2.Category5__c = "240系列"),(PricebookEntry.Product2.Category5__c = "200系列其他")),
|
OR((PricebookEntry.Product2.Category4__c = "GIF"),(PricebookEntry.Product2.Category4__c = "CF"),(PricebookEntry.Product2.Category4__c = "JF"),(PricebookEntry.Product2.Category4__c = "SIF"))),Quantity,0),
|
|
"完了",
|
IF(
|
AND(
|
OR((PricebookEntry.Product2.Category5__c = "260系列"),(PricebookEntry.Product2.Category5__c = "240系列"),(PricebookEntry.Product2.Category5__c = "200系列其他")),
|
OR((PricebookEntry.Product2.Category4__c = "GIF"),(PricebookEntry.Product2.Category4__c = "CF"),(PricebookEntry.Product2.Category4__c = "JF"),(PricebookEntry.Product2.Category4__c = "SIF"))),Quantity,0),
|
0)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>发货数量(200系列镜子)</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Opp_Actual2_260Processor__c</fullName>
|
<description>产品分类4 = CV，产品分类5 = 260系列，260SL系列</description>
|
<externalId>false</externalId>
|
<formula>CASE( Opportunity.StageName , "出荷",
|
|
IF(
|
AND(
|
OR((PricebookEntry.Product2.Category5__c = "260SL系列"),
|
(PricebookEntry.Product2.Category5__c = "260系列")), (PricebookEntry.Product2.Category4__c = "CV")),
|
Quantity,0),
|
|
"完了",
|
IF(
|
AND(
|
OR((PricebookEntry.Product2.Category5__c = "260SL系列"),
|
(PricebookEntry.Product2.Category5__c = "260系列")), (PricebookEntry.Product2.Category4__c = "CV")),
|
Quantity,0),0)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>发货数量(260系列主机)</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Opp_Actual2_BFFiber__c</fullName>
|
<description>BF所有纤维镜</description>
|
<externalId>false</externalId>
|
<formula>CASE( Opportunity.StageName , "出荷",
|
IF(
|
AND((PricebookEntry.Product2.Category3__c = "纤维镜"),(PricebookEntry.Product2.Category4__c = "BF")),Quantity,0),
|
|
"完了",
|
IF(
|
AND((PricebookEntry.Product2.Category3__c = "纤维镜"),(PricebookEntry.Product2.Category4__c = "BF")),Quantity,0),
|
0)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>发货数量(BF纤维镜)</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Opp_Actual2_BFVideo__c</fullName>
|
<description>BF所有电子镜</description>
|
<externalId>false</externalId>
|
<formula>CASE( Opportunity.StageName , "出荷",
|
IF(
|
AND((PricebookEntry.Product2.Category3__c = "电子镜"),(PricebookEntry.Product2.Category4__c = "BF")),Quantity,0),
|
|
"完了",
|
IF(
|
AND((PricebookEntry.Product2.Category3__c = "电子镜"),(PricebookEntry.Product2.Category4__c = "BF")),Quantity,0),
|
0)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>发货数量(BF电子镜子)</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Opp_Actual2__c</fullName>
|
<externalId>false</externalId>
|
<formula>CASE( Opportunity.StageName , "出荷", Quantity,"完了", Quantity,0)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>2.发货数量</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Opp_Actual2_plus_component__c</fullName>
|
<externalId>false</externalId>
|
<formula>CASE( Opportunity.StageName , "出荷", (Quantity * PricebookEntry.Product2.Packing_list_manual__c),"完了", (Quantity * PricebookEntry.Product2.Packing_list_manual__c),0)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>发货数量(*同梱数)</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Opp_Actual2k__c</fullName>
|
<externalId>false</externalId>
|
<formula>CASE( Opportunity.StageName , "出荷", OCM_Sales_Forecast_Without_Tax__c,"完了", OCM_Sales_Forecast_Without_Tax__c,0)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>2.发货金额(不含税)</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<type>Currency</type>
|
</fields>
|
<fields>
|
<fullName>Opp_Actual4__c</fullName>
|
<externalId>false</externalId>
|
<formula>CASE( Opportunity.StageName , "出荷", Quantity,"注残", Quantity ,"完了", Quantity ,"引合", Quantity ,0)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>4.发货+注残+询价数量</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Opp_Actual4_plus_component__c</fullName>
|
<externalId>false</externalId>
|
<formula>CASE( Opportunity.StageName , "出荷", (Quantity * PricebookEntry.Product2.Packing_list_manual__c),"注残", (Quantity * PricebookEntry.Product2.Packing_list_manual__c) ,"完了", (Quantity * PricebookEntry.Product2.Packing_list_manual__c) ,"引合", (Quantity * PricebookEntry.Product2.Packing_list_manual__c) ,0)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>发货+注残+预测数量(*同梱数)</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Opp_Actual4k__c</fullName>
|
<externalId>false</externalId>
|
<formula>CASE( Opportunity.StageName , "出荷", OCM_Sales_Forecast_Without_Tax__c ,"注残", OCM_Sales_Forecast_Without_Tax__c ,"完了", OCM_Sales_Forecast_Without_Tax__c ,"引合", OCM_Sales_Forecast_Without_Tax__c ,0)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>4.发货+注残+询价金額(不含税)</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<type>Currency</type>
|
</fields>
|
<fields>
|
<fullName>Opp_Forecast3__c</fullName>
|
<externalId>false</externalId>
|
<formula>CASE( Opportunity.StageName , "出荷", Quantity,"注残", Quantity ,"完了", Quantity ,0)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>3.发货+注残数量</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Opp_Forecast3_plus_component__c</fullName>
|
<externalId>false</externalId>
|
<formula>CASE( Opportunity.StageName , "出荷", (Quantity * PricebookEntry.Product2.Packing_list_manual__c),"注残", (Quantity * PricebookEntry.Product2.Packing_list_manual__c) ,"完了", (Quantity * PricebookEntry.Product2.Packing_list_manual__c) ,0)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>发货+注残数量(*同梱数)</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Opp_Forecast3k__c</fullName>
|
<externalId>false</externalId>
|
<formula>CASE( Opportunity.StageName , "出荷", OCM_Sales_Forecast_Without_Tax__c,"注残", OCM_Sales_Forecast_Without_Tax__c,"完了", OCM_Sales_Forecast_Without_Tax__c,0)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>3.发货+注残金额(不含税)</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<type>Currency</type>
|
</fields>
|
<fields>
|
<fullName>OpportunityId</fullName>
|
<type>Lookup</type>
|
</fields>
|
<fields>
|
<fullName>OpportunityId__c</fullName>
|
<externalId>false</externalId>
|
<formula>CASESAFEID(OpportunityId)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>询价ID</label>
|
<required>false</required>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Opportunity_Category__c</fullName>
|
<externalId>false</externalId>
|
<formula>Text(Opportunity.Opportunity_Category__c)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>询价科室分类</label>
|
<required>false</required>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Owner_ID__c</fullName>
|
<externalId>false</externalId>
|
<formula>Opportunity.OwnerId</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>所有人ID</label>
|
<required>false</required>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Packing_list_manual__c</fullName>
|
<externalId>false</externalId>
|
<formula>PricebookEntry.Product2.Packing_list_manual__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>同梱数</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Present__c</fullName>
|
<defaultValue>false</defaultValue>
|
<externalId>false</externalId>
|
<label>赠送</label>
|
<type>Checkbox</type>
|
</fields>
|
<fields>
|
<fullName>Product2Id</fullName>
|
<type>Lookup</type>
|
</fields>
|
<fields>
|
<fullName>Product2Id__c</fullName>
|
<externalId>false</externalId>
|
<formula>CASESAFEID(PricebookEntry.Product2Id)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>Product2Id</label>
|
<required>false</required>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>ProductCode</fullName>
|
</fields>
|
<fields>
|
<fullName>ProductCode__c</fullName>
|
<externalId>false</externalId>
|
<formula>PricebookEntry.Product2.ProductCode</formula>
|
<label>品目コード</label>
|
<required>false</required>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>ProductEntend_gurantee_period_all__c</fullName>
|
<externalId>false</externalId>
|
<label>产品多年保修期(年)</label>
|
<precision>3</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>ProductGuranteePrice__c</fullName>
|
<externalId>false</externalId>
|
<label>产品计提金额</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>2</scale>
|
<type>Currency</type>
|
</fields>
|
<fields>
|
<fullName>ProductName__c</fullName>
|
<externalId>false</externalId>
|
<formula>PricebookEntry.Product2.Name</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>产品名称</label>
|
<required>false</required>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Product_Cost__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF( $User.Cost_Referable__c = False, 0,
|
CASE(Text(Opportunity.Trade__c),
|
'外貿', PricebookEntry.Product2.Foreign_Trade_Cost_US__c,
|
'内貿', PricebookEntry.Product2.Intra_Trade_Cost_RMB__c,
|
0
|
))</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>最新商品コスト価格</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>2</scale>
|
<type>Currency</type>
|
</fields>
|
<fields>
|
<fullName>Product_ListPrice__c</fullName>
|
<externalId>false</externalId>
|
<formula>CASE(Text(Opportunity.Trade__c),
|
'外貿', PricebookEntry.Product2.Foreign_Trade_List_US__c,
|
'内貿', PricebookEntry.Product2.Intra_Trade_List_RMB__c,
|
0
|
)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>最新商品リスト価格</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>2</scale>
|
<type>Currency</type>
|
</fields>
|
<fields>
|
<fullName>Qty_Unit__c</fullName>
|
<externalId>false</externalId>
|
<label>単位</label>
|
<length>255</length>
|
<required>false</required>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Quantity</fullName>
|
</fields>
|
<fields>
|
<fullName>Quantity__c</fullName>
|
<externalId>false</externalId>
|
<formula>Quantity</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>数量</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>2</scale>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Received_order_High_PCL__c</fullName>
|
<externalId>false</externalId>
|
<formula>CASE( Opportunity.StageName ,
|
"出荷", Quantity,
|
"完了", Quantity,
|
"注残", Quantity,
|
"引合", IF(OR(text(Opportunity.Competitor__c)="A",text(Opportunity.Competitor__c)="B",text(Opportunity.Competitor__c)="C"),Quantity,0),
|
0)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>3.订货+询价(A-C)</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Received_order_PCL__c</fullName>
|
<externalId>false</externalId>
|
<formula>CASE( Opportunity.StageName ,
|
"出荷", Quantity,
|
"完了", Quantity,
|
"注残", Quantity,
|
"引合", Quantity,
|
0)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>4.订货+询价</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Received_order_number__c</fullName>
|
<externalId>false</externalId>
|
<formula>CASE( Opportunity.StageName ,
|
"出荷", Quantity,
|
"完了", Quantity,
|
"注残", Quantity,
|
0)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>2.订货数量</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>RecordType_Name__c</fullName>
|
<externalId>false</externalId>
|
<formula>Opportunity.RecordType.DeveloperName</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>RecordType_Name</label>
|
<required>false</required>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Register_alleffective__c</fullName>
|
<externalId>false</externalId>
|
<label>产品注册证</label>
|
<length>32768</length>
|
<type>LongTextArea</type>
|
<visibleLines>2</visibleLines>
|
</fields>
|
<fields>
|
<fullName>Report_Num1__c</fullName>
|
<externalId>false</externalId>
|
<formula>""</formula>
|
<label>件数分類</label>
|
<required>false</required>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>SAP_win__c</fullName>
|
<externalId>false</externalId>
|
<formula>Opportunity.SAP_Send_OK__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>SAP上传</label>
|
<type>Checkbox</type>
|
</fields>
|
<fields>
|
<fullName>SFDA_Status__c</fullName>
|
<externalId>false</externalId>
|
<label>CFDA状态</label>
|
<required>false</required>
|
<type>Picklist</type>
|
<valueSet>
|
<valueSetDefinition>
|
<sorted>false</sorted>
|
<value>
|
<fullName>不要</fullName>
|
<default>false</default>
|
<label>不要</label>
|
</value>
|
<value>
|
<fullName>準備中</fullName>
|
<default>false</default>
|
<label>準備中</label>
|
</value>
|
<value>
|
<fullName>新製品申請中</fullName>
|
<default>false</default>
|
<label>新製品申請中</label>
|
</value>
|
<value>
|
<fullName>有効</fullName>
|
<default>false</default>
|
<label>有効</label>
|
</value>
|
<value>
|
<fullName>失効（期限内生産済在庫対応）</fullName>
|
<default>false</default>
|
<label>失効（期限内生産済在庫対応）</label>
|
</value>
|
<value>
|
<fullName>失効（再申請中）</fullName>
|
<default>false</default>
|
<label>失効（再申請中）</label>
|
</value>
|
<value>
|
<fullName>失効（申請無）</fullName>
|
<default>false</default>
|
<label>失効（申請無）</label>
|
</value>
|
<value>
|
<fullName>有効（再申請中）</fullName>
|
<default>false</default>
|
<label>有効（再申請中）</label>
|
</value>
|
<value>
|
<fullName>停止</fullName>
|
<default>false</default>
|
<label>停止</label>
|
</value>
|
</valueSetDefinition>
|
</valueSet>
|
</fields>
|
<fields>
|
<fullName>SaleProvince_SAP__c</fullName>
|
<externalId>false</externalId>
|
<formula>Opportunity.SaleProvince_SAP__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>省（SAP业绩）</label>
|
<required>false</required>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>ServiceDate</fullName>
|
</fields>
|
<fields>
|
<fullName>ServicePrice__c</fullName>
|
<externalId>false</externalId>
|
<label>No Discount Price</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>2</scale>
|
<type>Currency</type>
|
</fields>
|
<fields>
|
<fullName>ShareWithPowerBI__c</fullName>
|
<externalId>false</externalId>
|
<formula>if((TEXT(Opportunity.StageName) = '引合' || TEXT(Opportunity.StageName) = '询价') && Opportunity.Backup_order_number__c = 0 && NOT(ISNULL(Product2Id__c)) , true,false)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>共享PowerBI</label>
|
<type>Checkbox</type>
|
</fields>
|
<fields>
|
<fullName>State__c</fullName>
|
<externalId>false</externalId>
|
<formula>Opportunity.State__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>OCSM省</label>
|
<required>false</required>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Subtotal</fullName>
|
</fields>
|
<fields>
|
<fullName>Target_category__c</fullName>
|
<externalId>false</externalId>
|
<formula>Text(Opportunity.Target_category__c)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>目标区分</label>
|
<required>false</required>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>TotalPrice</fullName>
|
</fields>
|
<fields>
|
<fullName>TotalPrice_F__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(Opportunity.SAP_Send_OK__c && (Opportunity.Agency1__r.Special__c || Opportunity.Agency2__r.Special__c || Opportunity.Account.Parent.Special__c) && $User.ViewSpecialAgencyAmout__c == False, null,
|
TotalPrice__c
|
)</formula>
|
<label>总价</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>2</scale>
|
<type>Currency</type>
|
</fields>
|
<fields>
|
<fullName>TotalPrice__c</fullName>
|
<description>WF「计算报价总额」 にて UnitPrice__c * Quantity を設定</description>
|
<externalId>false</externalId>
|
<label>总计_System_元</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>2</scale>
|
<type>Currency</type>
|
</fields>
|
<fields>
|
<fullName>USG_400__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(PricebookEntry.Product2.Important_Rroduct_11GI__c = true, Quantity ,0)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>USG-400(台)</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>UnitPrice</fullName>
|
</fields>
|
<fields>
|
<fullName>UnitPrice_F__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(Opportunity.SAP_Send_OK__c && (Opportunity.Agency1__r.Special__c || Opportunity.Agency2__r.Special__c || Opportunity.Account.Parent.Special__c) && $User.ViewSpecialAgencyAmout__c == False, null,
|
UnitPrice__c
|
)</formula>
|
<label>价格</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>2</scale>
|
<type>Currency</type>
|
</fields>
|
<fields>
|
<fullName>UnitPrice__c</fullName>
|
<externalId>false</externalId>
|
<label>价格_元</label>
|
<precision>15</precision>
|
<required>false</required>
|
<scale>2</scale>
|
<type>Currency</type>
|
</fields>
|
<fields>
|
<fullName>X200_serise_scope__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(PricebookEntry.Product2.Important_Rroduct_3GI__c = true, Quantity ,0)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>200系列(条)</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>X3DV_190__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(PricebookEntry.Product2.Important_Rroduct_7GI__c = true, Quantity ,0)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>3DV-190(台)</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>in_wave__c</fullName>
|
<externalId>false</externalId>
|
<formula>"in"</formula>
|
<label>in_wave</label>
|
<required>false</required>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>lastestGuaranteePeriod__c</fullName>
|
<description>1、如果是一般产品时时，传询价头上的保修年限;
|
|
2、如果是服务多年保修 或者 (产品是市场多年保修，询价未取消多年保修、产品主数据上的多年保修期（年）大于合同保修期)， 取产品主数据上的多年保修期（年）；
|
|
3、如果产品是市场多年保修，且询价取消多年保修，则保修期为1年；
|
|
4、如果不是多年保修且产品不是耗材 或者 (产品是市场多年保修，询价未取消多年保修、产品主数据上的多年保修期（年）小于等于合同保修期) 取询价上的合同保修期（年）；（去掉内贸的并列条件）
|
|
5、如果不是多年保修且产品是耗材，则为0
|
|
6、外贸4.1上线前切换 之前传询价头上的保修年限、之后取产品上的市场保修年限</description>
|
<externalId>false</externalId>
|
<formula>if(PricebookEntry.Product2.GuranteeType__c = '',
|
value(text(Opportunity.Gurantee_Period__c)),
|
if(PricebookEntry.Product2.GuranteeType__c = '服务',
|
PricebookEntry.Product2.Entend_gurantee_period_all__c,
|
if(PricebookEntry.Product2.GuranteeType__c = '市场'
|
&&(Opportunity.multiYearWarranty__c && Not(CanNotCancelFlag__c)),
|
1,
|
if(PricebookEntry.Product2.GuranteeType__c = '市场'
|
&& (not(Opportunity.multiYearWarranty__c) || CanNotCancelFlag__c )
|
&& PricebookEntry.Product2.Entend_gurantee_period_all__c > value(text(Opportunity.Gurantee_Period__c))
|
,
|
if(Text(Opportunity.Trade__c) = '外貿'&&Opportunity.DecideQuoteDate__c < DATEVALUE($Label.GuaranteeUSD),value(text(Opportunity.Gurantee_Period__c)),PricebookEntry.Product2.Entend_gurantee_period_all__c),
|
value(text(Opportunity.Gurantee_Period__c))
|
))))</formula>
|
<label>保修年限（最新）</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>lastestIf_Cancel_Guarantee__c</fullName>
|
<description>1.如果外贸是4.1之前deceid的，则默认取消多年保修 置为true
|
2.如产品的保修类型是市场多年保修且询价取消多年保修且行项目不是不可取消市场多年保，置true，
|
3.反之置为false</description>
|
<externalId>false</externalId>
|
<formula>if(Text(Opportunity.Trade__c) = '外貿'&&Opportunity.DecideQuoteDate__c < DATEVALUE($Label.GuaranteeUSD),true,PricebookEntry.Product2.GuranteeType__c = '市场' && Opportunity.multiYearWarranty__c && not(PricebookEntry.Product2.CanNotCancelledGurantee__c))</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>是否取消多年保修（最新）</label>
|
<type>Checkbox</type>
|
</fields>
|
<fields>
|
<fullName>lastestMultiYearWarranty__c</fullName>
|
<description>1.如果外贸是4.1之前deceid的，则默认取消多年保修 置为false
|
2.产品为服务多年保修时，则为真；
|
3.产品为市场多年保修时, (取消并且不可取消多年保为假)，为假，否则为真
|
4、其他情况不是多年保修；</description>
|
<externalId>false</externalId>
|
<formula>if (Text(Opportunity.Trade__c) = '外貿' && Opportunity.DecideQuoteDate__c < DATEVALUE($Label.GuaranteeUSD), false,
|
if (PricebookEntry.Product2.GuranteeType__c = '服务', true,
|
if (PricebookEntry.Product2.GuranteeType__c = '市场',
|
if ((Opportunity.multiYearWarranty__c && CanNotCancelFlag__c = false), false, true), false)))</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>多年保修（最新）</label>
|
<type>Checkbox</type>
|
</fields>
|
<fields>
|
<fullName>latestGuranteePrice__c</fullName>
|
<description>1、如果多年保修（最新）为真且询价的内贸/外贸是内贸，则取产品的多年保修内贸计提价格；
|
2、如果多年保修（最新）为真且询价的内贸/外贸是外贸，则取产品的多年保修外贸计提价格；
|
3、其他则为0</description>
|
<externalId>false</externalId>
|
<formula>if(lastestMultiYearWarranty__c,CASE(Text(Opportunity.Trade__c),
|
'内貿', PricebookEntry.Product2.Intra_Trade_Gurantee_RMB__c,
|
PricebookEntry.Product2.Intra_Trade_Foreign_RMB__c
|
), 0)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>计提金额（最新）</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>2</scale>
|
<type>Currency</type>
|
</fields>
|
<fields>
|
<fullName>latestProvistonPeriod__c</fullName>
|
<description>多年保修
|
如果多年保修（最新）为真， 则取产品的的多年保修期(年)，否则为0</description>
|
<externalId>false</externalId>
|
<formula>if(lastestMultiYearWarranty__c,PricebookEntry.Product2.Entend_gurantee_period_all__c, null)</formula>
|
<label>计提年限（最新）</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>latestServicePrice__c</fullName>
|
<description>1.如果是市场并且不是取消，根据内外贸取产品主数据上的nodiscount价格
|
2.如果是市场并且是不可取消多年保，根据内外贸取产品主数据上的nodiscount价格</description>
|
<externalId>false</externalId>
|
<formula>if (Text(Opportunity.Trade__c) = '外貿' && Opportunity.DecideQuoteDate__c < DATEVALUE($Label.GuaranteeUSD), 0,
|
if (PricebookEntry.Product2.GuranteeType__c = '市场' && (not(Opportunity.multiYearWarranty__c) || CanNotCancelFlag__c),
|
if (Text(Opportunity.Trade__c) = '外貿', PricebookEntry.Product2.NoDiscount_Foreign__c, PricebookEntry.Product2.Intra_Trade_Service_RMB__c), 0))</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>No Discount Price（最新）</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>2</scale>
|
<type>Currency</type>
|
</fields>
|
<fields>
|
<fullName>latestWarrantyType__c</fullName>
|
<description>1.如果产品为服务多年保修时，值为服务多年保修，如果产品为市场多年保修且没有取消市场多年保修或产品不可取消多年保修，则值为市场多年保修。</description>
|
<externalId>false</externalId>
|
<formula>if(PricebookEntry.Product2.GuranteeType__c = '服务', '服务多年保修',
|
if(PricebookEntry.Product2.GuranteeType__c = '市场' &&
|
(!Opportunity.multiYearWarranty__c || CanNotCancelFlag__c),
|
'市场多年保修', ''
|
))</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>保修（最新）</label>
|
<required>false</required>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>layer5__c</fullName>
|
<externalId>false</externalId>
|
<formula>PricebookEntry.Product2.Category5__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>第5分类</label>
|
<required>false</required>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>multiYearWarranty__c</fullName>
|
<defaultValue>false</defaultValue>
|
<externalId>false</externalId>
|
<label>多年保修</label>
|
<type>Checkbox</type>
|
</fields>
|
<fields>
|
<fullName>productServicePrice__c</fullName>
|
<externalId>false</externalId>
|
<label>产品servicePrice</label>
|
<precision>15</precision>
|
<required>false</required>
|
<scale>2</scale>
|
<type>Currency</type>
|
</fields>
|
<fields>
|
<fullName>provistonPeriod__c</fullName>
|
<externalId>false</externalId>
|
<label>计提年限</label>
|
<precision>3</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>strategyProductText__c</fullName>
|
<defaultValue>0</defaultValue>
|
<description>SWAG-BGCCB9</description>
|
<externalId>false</externalId>
|
<label>战略产品(文本)</label>
|
<precision>1</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>strategyProduct__c</fullName>
|
<description>SWAG-BGCCB9</description>
|
<externalId>false</externalId>
|
<formula>if(PricebookEntry.Product2.Important_Rroduct_1GI__c || PricebookEntry.Product2.Important_Rroduct_4GI__c ||
|
PricebookEntry.Product2.Important_Rroduct_8GI__c ||
|
PricebookEntry.Product2.Important_Rroduct_18GI__c ||
|
PricebookEntry.Product2.Important_Rroduct_25GI__c ||
|
PricebookEntry.Product2.Important_Rroduct_27GI__c ||
|
PricebookEntry.Product2.Important_Rroduct_29GI__c ,1,0)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>战略产品</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>2</scale>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>target__c</fullName>
|
<defaultValue>false</defaultValue>
|
<externalId>false</externalId>
|
<label>目標</label>
|
<type>Checkbox</type>
|
</fields>
|
<fields>
|
<fullName>test__c</fullName>
|
<externalId>false</externalId>
|
<formula>OCM_Sales_Forecast__c = AgencySubtotal__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>test</label>
|
<type>Checkbox</type>
|
</fields>
|
<fields>
|
<fullName>warrantyType__c</fullName>
|
<externalId>false</externalId>
|
<label>保修</label>
|
<required>false</required>
|
<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>
|
</CustomObject>
|
