<?xml version="1.0" encoding="UTF-8"?>
|
<CustomObject xmlns="http://soap.sforce.com/2006/04/metadata">
|
<actionOverrides>
|
<actionName>Accept</actionName>
|
<type>Default</type>
|
</actionOverrides>
|
<actionOverrides>
|
<actionName>CancelEdit</actionName>
|
<type>Default</type>
|
</actionOverrides>
|
<actionOverrides>
|
<actionName>Clone</actionName>
|
<type>Default</type>
|
</actionOverrides>
|
<actionOverrides>
|
<actionName>Delete</actionName>
|
<type>Default</type>
|
</actionOverrides>
|
<actionOverrides>
|
<actionName>Edit</actionName>
|
<type>Default</type>
|
</actionOverrides>
|
<actionOverrides>
|
<actionName>List</actionName>
|
<type>Default</type>
|
</actionOverrides>
|
<actionOverrides>
|
<actionName>New</actionName>
|
<type>Default</type>
|
</actionOverrides>
|
<actionOverrides>
|
<actionName>SaveEdit</actionName>
|
<type>Default</type>
|
</actionOverrides>
|
<actionOverrides>
|
<actionName>Tab</actionName>
|
<type>Default</type>
|
</actionOverrides>
|
<actionOverrides>
|
<actionName>View</actionName>
|
<type>Default</type>
|
</actionOverrides>
|
<allowInChatterGroups>false</allowInChatterGroups>
|
<compactLayoutAssignment>SYSTEM</compactLayoutAssignment>
|
<deploymentStatus>Deployed</deploymentStatus>
|
<description>Accountを隠すため、金額だけ見えます。</description>
|
<enableActivities>false</enableActivities>
|
<enableBulkApi>true</enableBulkApi>
|
<enableChangeDataCapture>false</enableChangeDataCapture>
|
<enableFeeds>false</enableFeeds>
|
<enableHistory>false</enableHistory>
|
<enableReports>true</enableReports>
|
<enableSearch>true</enableSearch>
|
<enableSharing>true</enableSharing>
|
<enableStreamingApi>true</enableStreamingApi>
|
<externalSharingModel>Private</externalSharingModel>
|
<fields>
|
<fullName>Active__c</fullName>
|
<externalId>false</externalId>
|
<formula>Owner:User.IsActive</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>启用</label>
|
<trackTrending>false</trackTrending>
|
<type>Checkbox</type>
|
</fields>
|
<fields>
|
<fullName>Agency_Contract_Date1__c</fullName>
|
<externalId>false</externalId>
|
<formula>Opportunity__r.Agency_Contract_Date1__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>Agency_Contract_Date1</label>
|
<required>false</required>
|
<trackTrending>false</trackTrending>
|
<type>Date</type>
|
</fields>
|
<fields>
|
<fullName>Amount_Without_Tax_T__c</fullName>
|
<externalId>false</externalId>
|
<label>OCSM成約予測金額(税抜き)_元</label>
|
<precision>15</precision>
|
<required>false</required>
|
<scale>2</scale>
|
<trackTrending>false</trackTrending>
|
<type>Currency</type>
|
</fields>
|
<fields>
|
<fullName>Amount_Without_Tax__c</fullName>
|
<description>以前=Opportunity__r.Amount_Without_Tax__c</description>
|
<externalId>false</externalId>
|
<formula>IF(Opportunity__r.Agency1__r.Special__c ||
|
Opportunity__r.Account.Parent.Special__c = True,
|
Estimation_List_Price_Without_Tax_T__c *0.45,
|
Amount_Without_Tax_T__c)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>OCSM预测成交金额(不含税)</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>2</scale>
|
<trackTrending>false</trackTrending>
|
<type>Currency</type>
|
</fields>
|
<fields>
|
<fullName>Assistant_Applied_Date__c</fullName>
|
<externalId>false</externalId>
|
<formula>Opportunity__r.Assistant_Applied_Date__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>Assistant_Applied_Date</label>
|
<required>false</required>
|
<trackTrending>false</trackTrending>
|
<type>Date</type>
|
</fields>
|
<fields>
|
<fullName>Autholization_Activated_Date__c</fullName>
|
<externalId>false</externalId>
|
<formula>Opportunity__r.Autholization_Activated_Date__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>Autholization_Activated_Date</label>
|
<required>false</required>
|
<trackTrending>false</trackTrending>
|
<type>Date</type>
|
</fields>
|
<fields>
|
<fullName>Authorized_Date__c</fullName>
|
<externalId>false</externalId>
|
<formula>Opportunity__r.Authorized_Date__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>Authorized_Date</label>
|
<required>false</required>
|
<trackTrending>false</trackTrending>
|
<type>Date</type>
|
</fields>
|
<fields>
|
<fullName>Bid_Date__c</fullName>
|
<externalId>false</externalId>
|
<formula>Opportunity__r.Bid_Date__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>Bid_Date</label>
|
<required>false</required>
|
<trackTrending>false</trackTrending>
|
<type>Date</type>
|
</fields>
|
<fields>
|
<fullName>Category__c</fullName>
|
<externalId>false</externalId>
|
<formula>CASE(Opportunity__r.StageName,
|
"完了", "业绩",
|
"出荷", "业绩",
|
"注残", "预期",
|
"目標", "目标",
|
"敗戦","不成立",
|
"削除","不成立",
|
"取消","不成立",
|
"预期"
|
)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>状态1(简单化)</label>
|
<required>false</required>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>City__c</fullName>
|
<externalId>false</externalId>
|
<formula>Opportunity__r.City__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>市</label>
|
<required>false</required>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Closeing_day_catagory__c</fullName>
|
<externalId>false</externalId>
|
<formula>Opportunity__r.Closeing_day_catagory__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>预测签约日分类</label>
|
<required>false</required>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Closing_Bid_Date__c</fullName>
|
<externalId>false</externalId>
|
<formula>Opportunity__r.Closing_Bid_Date__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>Closing_Bid_Date</label>
|
<required>false</required>
|
<trackTrending>false</trackTrending>
|
<type>Date</type>
|
</fields>
|
<fields>
|
<fullName>Estimation_List_Price_T__c</fullName>
|
<externalId>false</externalId>
|
<label>标准报价总金额(含税)</label>
|
<precision>15</precision>
|
<required>false</required>
|
<scale>2</scale>
|
<trackTrending>false</trackTrending>
|
<type>Currency</type>
|
</fields>
|
<fields>
|
<fullName>Estimation_List_Price_Without_Tax_T__c</fullName>
|
<externalId>false</externalId>
|
<label>标准报价总金额(不含税)</label>
|
<precision>15</precision>
|
<required>false</required>
|
<scale>2</scale>
|
<trackTrending>false</trackTrending>
|
<type>Currency</type>
|
</fields>
|
<fields>
|
<fullName>Forecast_Amount_All__c</fullName>
|
<externalId>false</externalId>
|
<formula>Opportunity__r.UnshippedAmount_DN__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>3.注残金额(含税)</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>2</scale>
|
<trackTrending>false</trackTrending>
|
<type>Currency</type>
|
</fields>
|
<fields>
|
<fullName>Forecast_Amount_All_withouttax_F__c</fullName>
|
<description>Case( Opportunity__r.Trade__c,
|
"内貿",Forecast_Amount_All__c / 1.17,
|
"外貿",Forecast_Amount_All__c * Opportunity__r.Today_Rate__c,0)</description>
|
<externalId>false</externalId>
|
<formula>Case( Opportunity__r.Trade__c,
|
"内貿",Forecast_Amount_All__c /Opportunity__r.Tax_Intra_F_Copy__c,
|
"外貿",Forecast_Amount_All__c * Opportunity__r.Today_Rate__c,0)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>3.注残金额(不含税)</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>2</scale>
|
<trackTrending>false</trackTrending>
|
<type>Currency</type>
|
</fields>
|
<fields>
|
<fullName>Job_Level__c</fullName>
|
<externalId>false</externalId>
|
<formula>Text(Owner:User.Post__c )</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>职位</label>
|
<required>false</required>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Job_category__c</fullName>
|
<externalId>false</externalId>
|
<formula>Text(Owner:User.Job_Category__c)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>职种</label>
|
<required>false</required>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>LTV_Account__c</fullName>
|
<externalId>false</externalId>
|
<formula>Opportunity__r.LTV_Account__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>LTV用户目标(不含税)</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>2</scale>
|
<trackTrending>false</trackTrending>
|
<type>Currency</type>
|
</fields>
|
<fields>
|
<fullName>LTV_Account_tax__c</fullName>
|
<externalId>false</externalId>
|
<formula>Opportunity__r.LTV_Account_tax__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>LTV用户目标(含税)</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>2</scale>
|
<trackTrending>false</trackTrending>
|
<type>Currency</type>
|
</fields>
|
<fields>
|
<fullName>Last_Follow_Up_Date__c</fullName>
|
<externalId>false</externalId>
|
<formula>Opportunity__r.Last_Follow_Up_Date__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>Last_Follow_Up_Date</label>
|
<required>false</required>
|
<trackTrending>false</trackTrending>
|
<type>Date</type>
|
</fields>
|
<fields>
|
<fullName>Matanity_leave__c</fullName>
|
<externalId>false</externalId>
|
<formula>Owner:User.Pregnant_Rest__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>是否产假</label>
|
<trackTrending>false</trackTrending>
|
<type>Checkbox</type>
|
</fields>
|
<fields>
|
<fullName>Min_FirstApproveDate__c</fullName>
|
<externalId>false</externalId>
|
<formula>Opportunity__r.Min_FirstApproveDate__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>Min_FirstApproveDate</label>
|
<required>false</required>
|
<trackTrending>false</trackTrending>
|
<type>Date</type>
|
</fields>
|
<fields>
|
<fullName>OCM__c</fullName>
|
<externalId>false</externalId>
|
<formula>Opportunity__r.OCM__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>OCSM分类</label>
|
<required>false</required>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>OPP__c</fullName>
|
<externalId>false</externalId>
|
<formula>CASE( StageName__c , "询价", Amount_Without_Tax__c ,0)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>4.询价(不含税)</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>2</scale>
|
<trackTrending>false</trackTrending>
|
<type>Currency</type>
|
</fields>
|
<fields>
|
<fullName>OPP_incl_tax__c</fullName>
|
<externalId>false</externalId>
|
<formula>CASE( StageName__c , "询价", Wholesale_Price__c ,0)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>4.询价(含税)</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>2</scale>
|
<trackTrending>false</trackTrending>
|
<type>Currency</type>
|
</fields>
|
<fields>
|
<fullName>Objective_Tax__c</fullName>
|
<externalId>false</externalId>
|
<formula>Opportunity__r.Objective_Tax__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>1.目標金額(含税)</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>2</scale>
|
<trackTrending>false</trackTrending>
|
<type>Currency</type>
|
</fields>
|
<fields>
|
<fullName>Objective__c</fullName>
|
<externalId>false</externalId>
|
<formula>Opportunity__r.Objective__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>1.目標金額(不含税)</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>2</scale>
|
<trackTrending>false</trackTrending>
|
<type>Currency</type>
|
</fields>
|
<fields>
|
<fullName>Opp_Actual__c</fullName>
|
<description>ShippedAmount_All_withouttax__c</description>
|
<externalId>false</externalId>
|
<formula>ShippedAmount_All_withouttax__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>2.发货(不含税)</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>2</scale>
|
<trackTrending>false</trackTrending>
|
<type>Currency</type>
|
</fields>
|
<fields>
|
<fullName>Opp_Actual_incl_tax__c</fullName>
|
<description>ShippedAmount__c</description>
|
<externalId>false</externalId>
|
<formula>ShippedAmount__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>2.发货(含税)</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>2</scale>
|
<trackTrending>false</trackTrending>
|
<type>Currency</type>
|
</fields>
|
<fields>
|
<fullName>Opp_Forecast__c</fullName>
|
<description>ShippedAmount_without_tax__c + Forecast_Amount_All_withouttax_F__c</description>
|
<externalId>false</externalId>
|
<formula>Opp_Actual__c + Forecast_Amount_All_withouttax_F__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>3.发货+注残(不含税)</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>2</scale>
|
<trackTrending>false</trackTrending>
|
<type>Currency</type>
|
</fields>
|
<fields>
|
<fullName>Opp_Forecast_after_tender__c</fullName>
|
<description>Opp_Actual__c + Forecast_Amount_All_withouttax_F__c +
|
IF(AND(StageName_Text__c = "引合",OR
|
(Status_Formula__c = "00 还没跟进",
|
Status_Formula__c = "01 还没拜访",
|
Status_Formula__c = "02 跟进中"
|
Status_Formula__c = "03 已授权")),
|
0,OPP__c)</description>
|
<externalId>false</externalId>
|
<formula>Opp_Actual__c + Forecast_Amount_All_withouttax_F__c +
|
IF(AND(StageName_Text__c = "引合",OR
|
(Not(ISNULL(Min_FirstApproveDate__c )),
|
OR(SAP_Send_OK__c, StageName_Text__c="注残", StageName_Text__c="出荷", StageName_Text__c="完了") ,
|
Not(ISNULL(Sales_Shop_Hospital_Contract__c )),
|
Not(ISNULL(Agency_Contract_Date1__c )) ,
|
Not(ISNULL(Assistant_Applied_Date__c )) ,
|
Not(ISNULL(Closing_Bid_Date__c )) ,
|
Not(ISNULL(Bid_Date__c )) ,
|
Not(ISNULL(Autholization_Activated_Date__c )) ,
|
Not(ISNULL(Authorized_Date__c)))),
|
OPP__c,0)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>4.5 发货+注残+中标后询价(不含税)</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>2</scale>
|
<trackTrending>false</trackTrending>
|
<type>Currency</type>
|
</fields>
|
<fields>
|
<fullName>Opp_Forecast_before_tender__c</fullName>
|
<description>Opp_Actual__c + Forecast_Amount_All_withouttax_F__c +
|
IF(AND(StageName_Text__c = "引合",OR
|
(Status_Formula__c = "00 还没跟进",
|
Status_Formula__c = "01 还没拜访",
|
Status_Formula__c = "02 跟进中")),
|
0,OPP__c)</description>
|
<externalId>false</externalId>
|
<formula>Opp_Actual__c + Forecast_Amount_All_withouttax_F__c +
|
IF(AND(StageName_Text__c = "引合",OR
|
(Opportunity__r.Status_Formula_Text__c = "00 还没更新",
|
Opportunity__r.Status_Formula_Text__c= "01 还没拜访",
|
Opportunity__r.Status_Formula_Text__c= "02 跟进中")),
|
0,OPP__c)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>4.5 发货+注残+授权后询价(不含税)</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>2</scale>
|
<trackTrending>false</trackTrending>
|
<type>Currency</type>
|
</fields>
|
<fields>
|
<fullName>Opp_Forecast_incl_tax__c</fullName>
|
<description>ShippedAmount__c + Forecast_Amount_All_F__c</description>
|
<externalId>false</externalId>
|
<formula>Opp_Actual_incl_tax__c + Forecast_Amount_All__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>3.发货+注残(含税)</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>2</scale>
|
<trackTrending>false</trackTrending>
|
<type>Currency</type>
|
</fields>
|
<fields>
|
<fullName>Opp_stage__c</fullName>
|
<externalId>false</externalId>
|
<formula>Case(Opportunity__r.StageName,
|
"注残","3.注残",
|
"出荷","2.发货",
|
"完了","2.发货",
|
"敗戦","8.失单",
|
"削除","9.取消",
|
"目標","1.目标",
|
"引合",
|
CASE(Opportunity_rank__c,
|
"A","4.A",
|
"B","5.B",
|
"C","6.C",
|
"D","7.D",
|
"E","8.E",
|
""),
|
""
|
)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>询价状态</label>
|
<required>false</required>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Opportunity2__c</fullName>
|
<description>询价=Opportunity__c</description>
|
<externalId>false</externalId>
|
<formula>Opp_Actual__c + Forecast_Amount_All_withouttax_F__c +
|
IF(
|
AND(StageName_Text__c = "引合",
|
Opportunity__r.Close_Forecasted_Date__c < IF(Month(Today()) < 4, Date(Year(Today()), 4, 1), Date(Year(Today())+1, 4, 1))
|
),
|
CASE(Opportunity__r.Competitor__c,
|
"A",0.8,
|
"B",0.5,
|
"C",0.3,
|
0) *OPP__c
|
,0)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>4.发货+注残+询价(不含税)</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>2</scale>
|
<trackTrending>false</trackTrending>
|
<type>Currency</type>
|
</fields>
|
<fields>
|
<fullName>OpportunityId__c</fullName>
|
<externalId>false</externalId>
|
<formula>Opportunity__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>OpportunityId</label>
|
<required>false</required>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Opportunity_Category__c</fullName>
|
<externalId>false</externalId>
|
<formula>CASE(Opportunity__r.Opportunity_Category__c,
|
"GI","1.GI",
|
"ET","2.ET",
|
"BF","3.BF",
|
"GS","4.GS",
|
"URO","5.URO",
|
"GYN","6.GYN",
|
"ENT","7.ENT",
|
"OTH","8.OTH",
|
Text(Opportunity__r.Opportunity_Category__c)
|
)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>询价科室分类</label>
|
<required>false</required>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Opportunity_Owner_IsMatch__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF( OwnerId = Opportunity__r.OwnerId , true, false)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>和询价的所有人一致</label>
|
<trackTrending>false</trackTrending>
|
<type>Checkbox</type>
|
</fields>
|
<fields>
|
<fullName>Opportunity__c</fullName>
|
<deleteConstraint>SetNull</deleteConstraint>
|
<externalId>false</externalId>
|
<label>Opportunity</label>
|
<referenceTo>Opportunity</referenceTo>
|
<relationshipName>Opportunity2</relationshipName>
|
<required>false</required>
|
<trackTrending>false</trackTrending>
|
<type>Lookup</type>
|
</fields>
|
<fields>
|
<fullName>Opportunity_incl_tax__c</fullName>
|
<description>询价=Opportunity_incl_tax__c</description>
|
<externalId>false</externalId>
|
<formula>Opp_Actual_incl_tax__c + Forecast_Amount_All__c +
|
IF(
|
AND(StageName_Text__c = "引合",
|
Opportunity__r.Close_Forecasted_Date__c < IF(Month(Today()) < 4, Date(Year(Today()), 4, 1), Date(Year(Today())+1, 4, 1))
|
),
|
CASE(Opportunity__r.Competitor__c,"A",OPP_incl_tax__c*0.8,
|
"B",OPP_incl_tax__c*0.5,
|
"C",OPP_incl_tax__c*0.3,0),0)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>4.发货+注残+询价(含税)</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>2</scale>
|
<trackTrending>false</trackTrending>
|
<type>Currency</type>
|
</fields>
|
<fields>
|
<fullName>Opportunity_rank__c</fullName>
|
<externalId>false</externalId>
|
<formula>CASE(Opportunity__r.Competitor__c,
|
"A","A",
|
"B","B",
|
"C","C",
|
"D","D",
|
"E","E",
|
"F","F",
|
"その他","目标",
|
Text(Opportunity__r.Competitor__c)
|
)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>询价等级</label>
|
<required>false</required>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Owner_ID__c</fullName>
|
<externalId>false</externalId>
|
<formula>Opportunity__r.OwnerId</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>所有者ID</label>
|
<required>false</required>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Owner_System__c</fullName>
|
<deleteConstraint>SetNull</deleteConstraint>
|
<externalId>false</externalId>
|
<label>所有者【システム】</label>
|
<referenceTo>User</referenceTo>
|
<relationshipName>Opp2_Owner</relationshipName>
|
<required>false</required>
|
<trackTrending>false</trackTrending>
|
<type>Lookup</type>
|
</fields>
|
<fields>
|
<fullName>Product_Rep__c</fullName>
|
<description>询价=Product_Rep__c</description>
|
<externalId>false</externalId>
|
<formula>IF(Opportunity__r.Product_Rep__c = True,"True","False")</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>产品担当</label>
|
<required>false</required>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Province_SAP__c</fullName>
|
<externalId>false</externalId>
|
<formula>TEXT( Opportunity__r.SAP_Province__c)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>省(SAP)</label>
|
<required>false</required>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>SAP_Send_OK__c</fullName>
|
<externalId>false</externalId>
|
<formula>Opportunity__r.SAP_Send_OK__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>SAP_Send_OK</label>
|
<trackTrending>false</trackTrending>
|
<type>Checkbox</type>
|
</fields>
|
<fields>
|
<fullName>Sales_Shop_Hospital_Contract__c</fullName>
|
<externalId>false</externalId>
|
<formula>Opportunity__r.Sales_Shop_Hospital_Contract__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>Sales_Shop_Hospital_Contract</label>
|
<required>false</required>
|
<trackTrending>false</trackTrending>
|
<type>Date</type>
|
</fields>
|
<fields>
|
<fullName>Sales_dept_SAP__c</fullName>
|
<externalId>false</externalId>
|
<formula>Opportunity__r.Salesdepartment_SAP__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>销售本部（SAP）</label>
|
<required>false</required>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Salesdepartment_Owner__c</fullName>
|
<externalId>false</externalId>
|
<formula>Owner_System__r.Salesdepartment__c</formula>
|
<label>销售本部（所有人）</label>
|
<required>false</required>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>ShippedAmount_All__c</fullName>
|
<externalId>false</externalId>
|
<formula>Opportunity__r.ShippedAmount_DN__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>已发货金额(含税)</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>2</scale>
|
<trackTrending>false</trackTrending>
|
<type>Currency</type>
|
</fields>
|
<fields>
|
<fullName>ShippedAmount_All_withouttax__c</fullName>
|
<externalId>false</externalId>
|
<formula>ShippedAmount_ThisYear_withoutax_PA__c + ShippedAmount_ThisYear_withoutax_PB__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>已发货金额(不含税)(146P)</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>2</scale>
|
<trackTrending>false</trackTrending>
|
<type>Currency</type>
|
</fields>
|
<fields>
|
<fullName>ShippedAmount_ThisYear_PA__c</fullName>
|
<externalId>false</externalId>
|
<formula>Opportunity__r.ShippedAmount_ThisYear_PATxt__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>已发货金额(含税)(146PA)</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>2</scale>
|
<trackTrending>false</trackTrending>
|
<type>Currency</type>
|
</fields>
|
<fields>
|
<fullName>ShippedAmount_ThisYear_PB__c</fullName>
|
<externalId>false</externalId>
|
<formula>Opportunity__r.ShippedAmount_ThisYear_PBTxt__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>已发货金额(含税)(146PB)</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>2</scale>
|
<trackTrending>false</trackTrending>
|
<type>Currency</type>
|
</fields>
|
<fields>
|
<fullName>ShippedAmount_ThisYear_withoutax_PA__c</fullName>
|
<externalId>false</externalId>
|
<formula>Opportunity__r.ShippedAmount_ThisYear_withoutax_PACP__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>已发货金额(不含税)(146PA)</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>2</scale>
|
<trackTrending>false</trackTrending>
|
<type>Currency</type>
|
</fields>
|
<fields>
|
<fullName>ShippedAmount_ThisYear_withoutax_PB__c</fullName>
|
<externalId>false</externalId>
|
<formula>Opportunity__r.ShippedAmount_ThisYear_withoutax_PBCP__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>已发货金额(不含税)(146PB)</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>2</scale>
|
<trackTrending>false</trackTrending>
|
<type>Currency</type>
|
</fields>
|
<fields>
|
<fullName>ShippedAmount__c</fullName>
|
<externalId>false</externalId>
|
<formula>ShippedAmount_ThisYear_PA__c + ShippedAmount_ThisYear_PB__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>已发货金额(含税)(146P)</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>2</scale>
|
<trackTrending>false</trackTrending>
|
<type>Currency</type>
|
</fields>
|
<fields>
|
<fullName>ShippedAmount_without_tax__c</fullName>
|
<externalId>false</externalId>
|
<formula>Case( Opportunity__r.Trade__c, "内貿",
|
Opportunity__r.NetWorthNoProviston_DN__c,
|
|
"外貿",
|
Opportunity__r.NetWorthNoProviston_DN__c/ Opportunity__r.Tax_Foreign_F__c
|
,Opportunity__r.NetWorthNoProviston_DN__c)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>已发货金额(不含税)</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>2</scale>
|
<trackTrending>false</trackTrending>
|
<type>Currency</type>
|
</fields>
|
<fields>
|
<fullName>Shipping_Date_For_Report__c</fullName>
|
<externalId>false</externalId>
|
<formula>Opportunity__r.Shipping_Date_For_Report__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>★日期(业绩统计用)★</label>
|
<required>false</required>
|
<trackTrending>false</trackTrending>
|
<type>Date</type>
|
</fields>
|
<fields>
|
<fullName>StageName_Text__c</fullName>
|
<externalId>false</externalId>
|
<label>状态1(文本)</label>
|
<length>10</length>
|
<required>false</required>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>StageName__c</fullName>
|
<externalId>false</externalId>
|
<formula>Case(Opportunity__r.StageName,
|
"引合","询价",
|
"注残","注残",
|
"出荷","发货",
|
"完了","完毕",
|
"敗戦","失单",
|
"削除","取消",
|
"目標","目标",
|
Text(Opportunity__r.StageName)
|
)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>状态1</label>
|
<required>false</required>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>State_Owner__c</fullName>
|
<externalId>false</externalId>
|
<formula>Text(Owner_System__r.Province__c)</formula>
|
<label>省（所有人）</label>
|
<required>false</required>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>State_Text__c</fullName>
|
<externalId>false</externalId>
|
<label>省(文本)</label>
|
<length>255</length>
|
<required>false</required>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Status_Formula__c</fullName>
|
<externalId>false</externalId>
|
<formula>Opportunity__r.Status_Formula__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>状态2</label>
|
<required>false</required>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Target_category__c</fullName>
|
<externalId>false</externalId>
|
<formula>CASE(Opportunity__r.Target_category__c,
|
"省目标","省目标",
|
"担当目标","担当目标",
|
"重点产品目标(数量)","重点产品目标(数量)",
|
"重点产品目标(金额)","重点产品目标(金额)",
|
"小组目标","小组目标",
|
"-"
|
)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>目标区分</label>
|
<required>false</required>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Town__c</fullName>
|
<externalId>false</externalId>
|
<formula>Opportunity__r.Town__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>县/区</label>
|
<required>false</required>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Wholesale_Price_T__c</fullName>
|
<externalId>false</externalId>
|
<label>OCSM成約予測金額(税込み)_元</label>
|
<precision>15</precision>
|
<required>false</required>
|
<scale>2</scale>
|
<trackTrending>false</trackTrending>
|
<type>Currency</type>
|
</fields>
|
<fields>
|
<fullName>Wholesale_Price__c</fullName>
|
<description>2013年7月8日修改
|
以前=Opportunity__r.Wholesale_Price__c</description>
|
<externalId>false</externalId>
|
<formula>IF(Opportunity__r.Agency1__r.Special__c ||
|
Opportunity__r.Account.Parent.Special__c = True,
|
Estimation_List_Price_T__c *0.45,
|
Wholesale_Price_T__c)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>OCSM预测成交金额(含税)</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>2</scale>
|
<trackTrending>false</trackTrending>
|
<type>Currency</type>
|
</fields>
|
<fields>
|
<fullName>order_Date_For_Report__c</fullName>
|
<externalId>false</externalId>
|
<formula>Opportunity__r.order_Date_For_Report__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>★日期(预测统计用)★</label>
|
<required>false</required>
|
<trackTrending>false</trackTrending>
|
<type>Date</type>
|
</fields>
|
<label>询价2</label>
|
<nameField>
|
<displayFormat>OP-{YYYY}{00000000}</displayFormat>
|
<label>询价2</label>
|
<type>AutoNumber</type>
|
</nameField>
|
<searchLayouts/>
|
<sharingModel>Private</sharingModel>
|
<visibility>Public</visibility>
|
</CustomObject>
|
