<?xml version="1.0" encoding="UTF-8"?>
|
<CustomObject xmlns="http://soap.sforce.com/2006/04/metadata">
|
<actionOverrides>
|
<actionName>Accept</actionName>
|
<type>Default</type>
|
</actionOverrides>
|
<actionOverrides>
|
<actionName>CancelEdit</actionName>
|
<type>Default</type>
|
</actionOverrides>
|
<actionOverrides>
|
<actionName>Clone</actionName>
|
<type>Default</type>
|
</actionOverrides>
|
<actionOverrides>
|
<actionName>Delete</actionName>
|
<type>Default</type>
|
</actionOverrides>
|
<actionOverrides>
|
<actionName>Edit</actionName>
|
<type>Default</type>
|
</actionOverrides>
|
<actionOverrides>
|
<actionName>List</actionName>
|
<type>Default</type>
|
</actionOverrides>
|
<actionOverrides>
|
<actionName>New</actionName>
|
<type>Default</type>
|
</actionOverrides>
|
<actionOverrides>
|
<actionName>SaveEdit</actionName>
|
<type>Default</type>
|
</actionOverrides>
|
<actionOverrides>
|
<actionName>Tab</actionName>
|
<type>Default</type>
|
</actionOverrides>
|
<actionOverrides>
|
<actionName>View</actionName>
|
<type>Default</type>
|
</actionOverrides>
|
<allowInChatterGroups>false</allowInChatterGroups>
|
<compactLayoutAssignment>SYSTEM</compactLayoutAssignment>
|
<deploymentStatus>Deployed</deploymentStatus>
|
<enableActivities>false</enableActivities>
|
<enableBulkApi>true</enableBulkApi>
|
<enableChangeDataCapture>false</enableChangeDataCapture>
|
<enableFeeds>false</enableFeeds>
|
<enableHistory>false</enableHistory>
|
<enableReports>false</enableReports>
|
<enableSearch>true</enableSearch>
|
<enableSharing>true</enableSharing>
|
<enableStreamingApi>true</enableStreamingApi>
|
<externalSharingModel>Private</externalSharingModel>
|
<fields>
|
<fullName>Agent1__c</fullName>
|
<externalId>false</externalId>
|
<label>Agent1</label>
|
<length>250</length>
|
<required>false</required>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Agent2__c</fullName>
|
<externalId>false</externalId>
|
<label>Agent2</label>
|
<length>250</length>
|
<required>false</required>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>All_result_flag__c</fullName>
|
<externalId>false</externalId>
|
<label>全国业绩标识</label>
|
<length>200</length>
|
<required>false</required>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Area__c</fullName>
|
<externalId>false</externalId>
|
<label>Area</label>
|
<length>250</length>
|
<required>false</required>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Asset_Model_No__c</fullName>
|
<externalId>false</externalId>
|
<formula>Product_ID__r.Asset_Model_No__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>OCSM内部产品型号(略称)</label>
|
<required>false</required>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>BC_Wave__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(All_result_flag__c="Y","全国",
|
IF( ENG_wave__c="ENG","能量",
|
Case(Area__c,
|
"安徽", "华东三部",
|
"北京", "华北一部",
|
"福建", "华东二部",
|
"甘肃", "西北三部",
|
"广东", "华南一部",
|
"深圳", "华南二部",
|
"广西", "华南三部",
|
"贵州", "西南二部",
|
"河北", "华北二部",
|
"河南", "西北二部",
|
"黑龙江","东北一部",
|
"湖北", "华南三部",
|
"湖南", "华南三部",
|
"吉林", "东北一部",
|
"江苏", "华东二部",
|
"江西", "华东二部",
|
"辽宁", "东北二部",
|
"大连", "东北二部",
|
"内蒙古","华北二部",
|
"宁夏", "西北二部",
|
"青海", "西北二部",
|
"山东", "华北三部",
|
"青岛", "华北三部",
|
"山西", "西北一部",
|
"陕西", "西北一部",
|
"上海", "华东一部",
|
"四川", "西南一部",
|
"西藏", "西南一部",
|
"天津", "华北二部",
|
"新疆", "西北三部",
|
"云南", "西南二部",
|
"浙江", "华东三部",
|
"重庆", "西南一部",
|
"海南", "华南二部",
|
"其他")))</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>部 Wave</label>
|
<required>false</required>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>BSSCategory__c</fullName>
|
<externalId>false</externalId>
|
<formula>text(Product_ID__r.BSSCategory__c)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>BSS第1分类</label>
|
<required>false</required>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Business_Model__c</fullName>
|
<externalId>false</externalId>
|
<formula>Product_ID__r.Business_Model__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>Business Model</label>
|
<required>false</required>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Category2__c</fullName>
|
<externalId>false</externalId>
|
<formula>Product_ID__r.Category2__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>第2分类</label>
|
<required>false</required>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Category3__c</fullName>
|
<externalId>false</externalId>
|
<formula>Product_ID__r.Category3__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>第3分类</label>
|
<required>false</required>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Category4__c</fullName>
|
<externalId>false</externalId>
|
<formula>Product_ID__r.Category4__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>第4分类</label>
|
<required>false</required>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Category5__c</fullName>
|
<externalId>false</externalId>
|
<formula>Product_ID__r.Category5__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>第5分类</label>
|
<required>false</required>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Category__c</fullName>
|
<externalId>false</externalId>
|
<label>Category</label>
|
<length>100</length>
|
<required>false</required>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>China_BSS_Tier1_del__c</fullName>
|
<externalId>false</externalId>
|
<formula>Product_ID__r.China_BSS_Tier1_del__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>China BSS Tier1</label>
|
<required>false</required>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>City__c</fullName>
|
<externalId>false</externalId>
|
<label>City</label>
|
<length>200</length>
|
<required>false</required>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Code__c</fullName>
|
<externalId>false</externalId>
|
<label>Code</label>
|
<length>250</length>
|
<required>false</required>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Commission_1__c</fullName>
|
<externalId>false</externalId>
|
<label>Commission 1</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>2</scale>
|
<trackTrending>false</trackTrending>
|
<type>Currency</type>
|
</fields>
|
<fields>
|
<fullName>Condtion__c</fullName>
|
<externalId>false</externalId>
|
<label>Condtion</label>
|
<length>100</length>
|
<required>false</required>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Cost_Waimao__c</fullName>
|
<externalId>false</externalId>
|
<label>Cost(外贸)</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>2</scale>
|
<trackTrending>false</trackTrending>
|
<type>Currency</type>
|
</fields>
|
<fields>
|
<fullName>Cost__c</fullName>
|
<externalId>false</externalId>
|
<label>Cost</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>2</scale>
|
<trackTrending>false</trackTrending>
|
<type>Currency</type>
|
</fields>
|
<fields>
|
<fullName>Currency__c</fullName>
|
<externalId>false</externalId>
|
<label>Currency</label>
|
<required>false</required>
|
<trackTrending>false</trackTrending>
|
<type>Picklist</type>
|
<valueSet>
|
<valueSetDefinition>
|
<sorted>false</sorted>
|
<value>
|
<fullName>RMB</fullName>
|
<default>false</default>
|
<label>RMB</label>
|
</value>
|
<value>
|
<fullName>USD</fullName>
|
<default>false</default>
|
<label>USD</label>
|
</value>
|
</valueSetDefinition>
|
</valueSet>
|
</fields>
|
<fields>
|
<fullName>Current_owner__c</fullName>
|
<externalId>false</externalId>
|
<formula>Opportunity__r.Owner.Name__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>担当者(现在)</label>
|
<required>false</required>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>DN__c</fullName>
|
<externalId>false</externalId>
|
<label>DN号</label>
|
<length>200</length>
|
<required>false</required>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Date_Ordered__c</fullName>
|
<externalId>false</externalId>
|
<label>Date Ordered</label>
|
<length>250</length>
|
<required>false</required>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Date_Returned__c</fullName>
|
<externalId>false</externalId>
|
<label>Date Returned</label>
|
<length>250</length>
|
<required>false</required>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Date_Shipped__c</fullName>
|
<externalId>false</externalId>
|
<label>Date Shipped</label>
|
<length>8</length>
|
<required>false</required>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Date_wave__c</fullName>
|
<externalId>false</externalId>
|
<formula>/* すでに Return_date__c 見ているので、そのまま Shipping_date__c を使う */
|
Shipping_date__c</formula>
|
<label>Date_wave</label>
|
<required>false</required>
|
<trackTrending>false</trackTrending>
|
<type>Date</type>
|
</fields>
|
<fields>
|
<fullName>Department_name__c</fullName>
|
<externalId>false</externalId>
|
<label>科室名称</label>
|
<length>200</length>
|
<required>false</required>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Description__c</fullName>
|
<externalId>false</externalId>
|
<label>Description</label>
|
<length>250</length>
|
<required>false</required>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Discount_Waimao__c</fullName>
|
<externalId>false</externalId>
|
<label>Discount(外贸)</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>2</scale>
|
<trackTrending>false</trackTrending>
|
<type>Currency</type>
|
</fields>
|
<fields>
|
<fullName>Discount__c</fullName>
|
<externalId>false</externalId>
|
<label>Discount</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>2</scale>
|
<trackTrending>false</trackTrending>
|
<type>Currency</type>
|
</fields>
|
<fields>
|
<fullName>ENG_wave__c</fullName>
|
<externalId>false</externalId>
|
<formula>CASE(Product_ID__r.ENG__c,
|
'ENG','ENG',
|
'ENG共通',IF(Opportunity__r.STMS_Package_Sale__c = true, 'ENG', ''),
|
'')</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>ENG_wave</label>
|
<required>false</required>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Enduser_NO__c</fullName>
|
<externalId>false</externalId>
|
<label>Enduser NO</label>
|
<length>250</length>
|
<required>false</required>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Enduser__c</fullName>
|
<externalId>false</externalId>
|
<label>Enduser</label>
|
<length>250</length>
|
<required>false</required>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Equipment_Order_Flg__c</fullName>
|
<externalId>false</externalId>
|
<label>备品订单标识</label>
|
<length>10</length>
|
<required>false</required>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Fifth_layer__c</fullName>
|
<externalId>false</externalId>
|
<formula>Opportunity__r.Owner.Category5__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>第5层区分</label>
|
<required>false</required>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Forth_layer__c</fullName>
|
<externalId>false</externalId>
|
<formula>Opportunity__r.Owner.Category4__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>第4层区分</label>
|
<required>false</required>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>GBIC__c</fullName>
|
<externalId>true</externalId>
|
<label>GBIC</label>
|
<length>20</length>
|
<required>false</required>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>GI_SP_Code__c</fullName>
|
<externalId>false</externalId>
|
<formula>Case(GBIC__c,
|
"GI","消化/呼吸科",
|
"ET","消化/呼吸科",
|
"BF","消化/呼吸科",
|
"GS","外科",
|
"URO","外科",
|
"GYN","外科",
|
"ENT","外科",
|
"OTH","外科","")</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>GI/SP領业</label>
|
<required>false</required>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>GI_SP__c</fullName>
|
<externalId>false</externalId>
|
<formula>Case(GBIC__c,
|
"GI","GI",
|
"ET","GI",
|
"BF","GI",
|
"GS","SP",
|
"URO","SP",
|
"GYN","SP",
|
"ENT","SP",
|
"OTH","SP","")</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>GI/SP</label>
|
<required>false</required>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>HP_OCM_Category_From_Class__c</fullName>
|
<externalId>false</externalId>
|
<formula>Opportunity__r.HP_OCM_Category_From_Class__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>HP_OCM_Category_From_Class</label>
|
<required>false</required>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Item__c</fullName>
|
<externalId>false</externalId>
|
<label>Item</label>
|
<length>250</length>
|
<required>false</required>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>LTV__c</fullName>
|
<externalId>false</externalId>
|
<label>LTV</label>
|
<length>30</length>
|
<required>false</required>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>LastModifiedDate__c</fullName>
|
<externalId>false</externalId>
|
<formula>DATEVALUE(LastModifiedDate)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>最终更新日（公式）</label>
|
<required>false</required>
|
<trackTrending>false</trackTrending>
|
<type>Date</type>
|
</fields>
|
<fields>
|
<fullName>Line_number__c</fullName>
|
<externalId>false</externalId>
|
<label>项目号</label>
|
<length>250</length>
|
<required>false</required>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>NO__c</fullName>
|
<externalId>false</externalId>
|
<label>NO</label>
|
<length>250</length>
|
<required>false</required>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Net_Value__c</fullName>
|
<externalId>false</externalId>
|
<label>净值</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>2</scale>
|
<trackTrending>false</trackTrending>
|
<type>Currency</type>
|
</fields>
|
<fields>
|
<fullName>New_department_category__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(ISBLANK( Opportunity__c),"9.不明",
|
Opportunity__r.New_department_category__c)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>战略科室分类(新)</label>
|
<required>false</required>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>News__c</fullName>
|
<externalId>false</externalId>
|
<label>科室编号（News）</label>
|
<length>100</length>
|
<required>false</required>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>OCM_Province__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(All_result_flag__c="Y","全国",
|
IF( ENG_wave__c="ENG","能量",
|
Case(Area__c,
|
"安徽","安徽",
|
"北京","北京",
|
"福建","福建",
|
"甘肃","甘肃",
|
"广东","广东",
|
"海南","海南",
|
"广西","广西",
|
"贵州","贵州",
|
"河北","河北",
|
"河南","河南",
|
"黑龙江","黑龙江",
|
"湖北","湖北",
|
"湖南","湖南",
|
"吉林","吉林",
|
"江苏","江苏",
|
"江西","江西",
|
"辽宁","辽宁",
|
"内蒙古","内蒙古",
|
"宁夏","宁夏",
|
"青海","青海",
|
"山东","山东",
|
"山西","山西",
|
"陕西","陕西",
|
"上海","上海",
|
"四川","四川",
|
"西藏","四川",
|
"天津","天津",
|
"新疆","新疆",
|
"云南","云南",
|
"浙江","浙江",
|
"重庆","重庆",
|
"深圳","深圳","其他")))</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>OCSM省</label>
|
<required>false</required>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>OCM_department_seg__c</fullName>
|
<externalId>false</externalId>
|
<formula>Opportunity__r.OCM_department_seg__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>OCSM科室等级</label>
|
<required>false</required>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>OCM_man_province__c</fullName>
|
<externalId>false</externalId>
|
<formula>Opportunity__r.OCM_man_province_no_dealer__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>OCSM管理省</label>
|
<required>false</required>
|
<trackTrending>false</trackTrending>
|
<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>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>OCM_period__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(MONTH(Shipping_date__c) <= 3,
|
text(YEAR(Shipping_date__c) - 1868)&"P",
|
text(YEAR(Shipping_date__c) - 1867 )&"P"
|
)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>OCSM期</label>
|
<required>false</required>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Opportunity__c</fullName>
|
<deleteConstraint>SetNull</deleteConstraint>
|
<externalId>false</externalId>
|
<label>询价</label>
|
<referenceTo>Opportunity</referenceTo>
|
<relationshipLabel>SAP发货</relationshipLabel>
|
<relationshipName>Ship_Opp</relationshipName>
|
<required>false</required>
|
<trackTrending>false</trackTrending>
|
<type>Lookup</type>
|
</fields>
|
<fields>
|
<fullName>Order_category__c</fullName>
|
<externalId>false</externalId>
|
<label>订单类型</label>
|
<length>200</length>
|
<required>false</required>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Order_category_discription__c</fullName>
|
<externalId>false</externalId>
|
<label>订单类型描述</label>
|
<length>200</length>
|
<required>false</required>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Order_date__c</fullName>
|
<externalId>false</externalId>
|
<formula>DATE(VALUE(mid(Date_Ordered__c,1,4)),VALUE(mid(Date_Ordered__c,5,2)),VALUE(mid(Date_Ordered__c,7,2)))</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>订货日</label>
|
<required>false</required>
|
<trackTrending>false</trackTrending>
|
<type>Date</type>
|
</fields>
|
<fields>
|
<fullName>Owner_current_alias__c</fullName>
|
<externalId>false</externalId>
|
<formula>Opportunity__r.Owner.Alias__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>担当者(现在) 无空</label>
|
<required>false</required>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>PA_PB__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(ISBLANK(Date_Shipped__c),
|
IF(mid(Date_Returned__c,5,2) = "04","PA:4月(1Q)",
|
IF(mid(Date_Returned__c,5,2) = "05","PA:5月(1Q)",
|
IF(mid(Date_Returned__c,5,2) = "06","PA:6月(1Q)",
|
IF(mid(Date_Returned__c,5,2) = "07","PA:7月(2Q)",
|
IF(mid(Date_Returned__c,5,2) = "08","PA:8月(2Q)",
|
IF(mid(Date_Returned__c,5,2) = "09","PA:9月(2Q)",
|
IF(mid(Date_Returned__c,5,2) = "10","PB:10月(3Q)",
|
IF(mid(Date_Returned__c,5,2)= "11","PB:11月(3Q)",
|
IF(mid(Date_Returned__c,5,2) = "12","PB:12月(3Q)",
|
IF(mid(Date_Returned__c,5,2) = "01","PB:01月(4Q)",
|
IF(mid(Date_Returned__c,5,2) = "02","PB:02月(4Q)",
|
IF(mid(Date_Returned__c,5,2) = "03","PB:03月(4Q)",
|
"")
|
)
|
)
|
)
|
)
|
)
|
)
|
)
|
)
|
)
|
)
|
)
|
,
|
|
IF(mid(Date_Shipped__c,5,2) = "04","PA:4月(1Q)",
|
IF(mid(Date_Shipped__c,5,2) = "05","PA:5月(1Q)",
|
IF(mid(Date_Shipped__c,5,2) = "06","PA:6月(1Q)",
|
IF(mid(Date_Shipped__c,5,2) = "07","PA:7月(2Q)",
|
IF(mid(Date_Shipped__c,5,2) = "08","PA:8月(2Q)",
|
IF(mid(Date_Shipped__c,5,2) = "09","PA:9月(2Q)",
|
IF(mid(Date_Shipped__c,5,2) = "10","PB:10月(3Q)",
|
IF(mid(Date_Shipped__c,5,2)= "11","PB:11月(3Q)",
|
IF(mid(Date_Shipped__c,5,2) = "12","PB:12月(3Q)",
|
IF(mid(Date_Shipped__c,5,2) = "01","PB:01月(4Q)",
|
IF(mid(Date_Shipped__c,5,2) = "02","PB:02月(4Q)",
|
IF(mid(Date_Shipped__c,5,2) = "03","PB:03月(4Q)",
|
"")
|
)
|
)
|
)
|
)
|
)
|
)
|
)
|
)
|
)
|
)
|
))</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>PA/PB</label>
|
<required>false</required>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Product_ID__c</fullName>
|
<deleteConstraint>SetNull</deleteConstraint>
|
<externalId>false</externalId>
|
<label>产品编码</label>
|
<referenceTo>Product2</referenceTo>
|
<relationshipLabel>SAP发货</relationshipLabel>
|
<relationshipName>SAP_ship_product_ID</relationshipName>
|
<required>false</required>
|
<trackTrending>false</trackTrending>
|
<type>Lookup</type>
|
</fields>
|
<fields>
|
<fullName>Product_category__c</fullName>
|
<externalId>false</externalId>
|
<formula>Case(GBIC__c,
|
"GI","GI",
|
"ET","ET",
|
"BF","BF",
|
"GS","SP",
|
"URO","SP",
|
"GYN","SP",
|
"ENT","SP",
|
"OTH","SP","")</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>产品分类</label>
|
<required>false</required>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>ProspectCode__c</fullName>
|
<externalId>false</externalId>
|
<label>ProspectCode</label>
|
<length>100</length>
|
<required>false</required>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Prospect_ID__c</fullName>
|
<externalId>false</externalId>
|
<formula>Opportunity__r.Id</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>询价ID</label>
|
<required>false</required>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Qty_Copy__c</fullName>
|
<externalId>false</externalId>
|
<formula>Qty__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>Qty Copy</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Qty__c</fullName>
|
<externalId>false</externalId>
|
<label>Qty</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Return_date__c</fullName>
|
<externalId>false</externalId>
|
<formula>DATE(VALUE(mid(Date_Returned__c,1,4)),VALUE(mid(Date_Returned__c,5,2)),VALUE(mid(Date_Returned__c,7,2)))</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>退货日</label>
|
<required>false</required>
|
<trackTrending>false</trackTrending>
|
<type>Date</type>
|
</fields>
|
<fields>
|
<fullName>STMS_Package_Sale__c</fullName>
|
<externalId>false</externalId>
|
<label>STMS打包销售标识</label>
|
<length>10</length>
|
<required>false</required>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>SalesDept__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(All_result_flag__c="Y","全国",
|
Case(Area__c,
|
"安徽","5.华东",
|
"北京","1.华北",
|
"福建","5.华东",
|
"甘肃","3.西北",
|
"广东","6.华南",
|
"海南","6.华南",
|
"广西","6.华南",
|
"贵州","4.西南",
|
"河北","1.华北",
|
"河南","3.西北",
|
"黑龙江","2.东北",
|
"湖北","6.华南",
|
"湖南","6.华南",
|
"吉林","2.东北",
|
"江苏","5.华东",
|
"江西","5.华东",
|
"辽宁","2.东北",
|
"内蒙古","1.华北",
|
"宁夏","3.西北",
|
"青海","3.西北",
|
"山东","1.华北",
|
"山西","3.西北",
|
"陕西","3.西北",
|
"上海","5.华东",
|
"四川","4.西南",
|
"西藏","4.西南",
|
"天津","1.华北",
|
"新疆","3.西北",
|
"云南","4.西南",
|
"浙江","5.华东",
|
"重庆","4.西南",""))</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>SalesDept</label>
|
<required>false</required>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>SalesDept_wave__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(All_result_flag__c="Y","全国",
|
IF( ENG_wave__c="ENG","能量",
|
Case(Area__c,
|
"安徽","4.华东销售本部",
|
"北京","1.华北销售本部",
|
"福建","4.华东销售本部",
|
"甘肃","3.西北销售本部",
|
"广东","5.华南销售本部",
|
"海南","5.华南销售本部",
|
"广西","5.华南销售本部",
|
"贵州","6.西南销售本部",
|
"河北","1.华北销售本部",
|
"河南","3.西北销售本部",
|
"黑龙江","2.东北销售本部",
|
"湖北","5.华南销售本部",
|
"湖南","5.华南销售本部",
|
"深圳","5.华南销售本部",
|
"吉林","2.东北销售本部",
|
"江苏","4.华东销售本部",
|
"江西","4.华东销售本部",
|
"辽宁","2.东北销售本部",
|
"内蒙古","1.华北销售本部",
|
"宁夏","3.西北销售本部",
|
"青海","3.西北销售本部",
|
"山东","1.华北销售本部",
|
"山西","3.西北销售本部",
|
"陕西","3.西北销售本部",
|
"上海","4.华东销售本部",
|
"四川","6.西南销售本部",
|
"西藏","6.西南销售本部",
|
"天津","1.华北销售本部",
|
"新疆","3.西北销售本部",
|
"云南","6.西南销售本部",
|
"浙江","4.华东销售本部",
|
"重庆","6.西南销售本部","")))</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>SalesDept_wave</label>
|
<required>false</required>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Sales_Amount_Waimao__c</fullName>
|
<externalId>false</externalId>
|
<label>Sales Amount(外贸)</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>2</scale>
|
<trackTrending>false</trackTrending>
|
<type>Currency</type>
|
</fields>
|
<fields>
|
<fullName>Sales_Amount__c</fullName>
|
<externalId>false</externalId>
|
<label>Sales Amount</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>2</scale>
|
<trackTrending>false</trackTrending>
|
<type>Currency</type>
|
</fields>
|
<fields>
|
<fullName>Sales_PIC_ID__c</fullName>
|
<externalId>false</externalId>
|
<label>销售担当ID</label>
|
<length>250</length>
|
<required>false</required>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Sales_PIC__c</fullName>
|
<externalId>false</externalId>
|
<label>销售担当</label>
|
<length>20</length>
|
<required>false</required>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Sales_Price__c</fullName>
|
<externalId>false</externalId>
|
<label>Sales Price</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>2</scale>
|
<trackTrending>false</trackTrending>
|
<type>Currency</type>
|
</fields>
|
<fields>
|
<fullName>Sales_Sub_PIC_ID__c</fullName>
|
<externalId>false</externalId>
|
<label>推进担当ID</label>
|
<length>250</length>
|
<required>false</required>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Sales_amount_without_tax__c</fullName>
|
<description>Case( Currency__c,"RMB", Sales_Amount__c /1.17
|
,"USD",IF(Shipping_date__c>=Datevalue("2016-12-01"),Sales_Amount__c * 6.8,
|
IF(Shipping_date__c>=Datevalue("2016-07-01"),Sales_Amount__c * 6.5,
|
IF(Shipping_date__c>=Datevalue("2012-10-01"),
|
Sales_Amount__c * 6.3, Sales_Amount__c * 6.6
|
)
|
)
|
)
|
,0
|
)
|
|
20190326前
|
Case( Currency__c,"RMB", if(today()>=Datevalue("2018-05-01"), Sales_Amount__c /1.16,Sales_Amount__c /1.17)
|
,"USD",IF(Shipping_date_Copy__c>=Datevalue($Label.Tax_Foreign_Date),Sales_Amount__c * 6.8,
|
IF(Shipping_date_Copy__c>=Datevalue("2018-05-01"),Sales_Amount__c * 6.3,
|
IF(Shipping_date_Copy__c>=Datevalue("2016-12-01"),Sales_Amount__c * 6.8,
|
IF(Shipping_date_Copy__c>=Datevalue("2016-07-01"),Sales_Amount__c * 6.5,
|
IF(Shipping_date_Copy__c>=Datevalue("2012-10-01"),
|
Sales_Amount__c * 6.3, Sales_Amount__c * 6.6
|
)
|
)
|
)
|
)
|
)
|
,0
|
)</description>
|
<externalId>false</externalId>
|
<formula>Case( Currency__c,"RMB", if(today()>=Datevalue($Label.Tax_Date_13), Sales_Amount__c /1.13,Sales_Amount__c /1.16)
|
,"USD",IF(Shipping_date_Copy__c>=Datevalue($Label.Tax_Foreign_Date),Sales_Amount__c * 6.8,
|
IF(Shipping_date_Copy__c>=Datevalue("2018-05-01"),Sales_Amount__c * 6.3,
|
IF(Shipping_date_Copy__c>=Datevalue("2016-12-01"),Sales_Amount__c * 6.8,
|
IF(Shipping_date_Copy__c>=Datevalue("2016-07-01"),Sales_Amount__c * 6.5,
|
IF(Shipping_date_Copy__c>=Datevalue("2012-10-01"),
|
Sales_Amount__c * 6.3, Sales_Amount__c * 6.6
|
)
|
)
|
)
|
)
|
)
|
,0
|
)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>发货金额(不含税)</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>2</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Sales_amount_without_tax_copy__c</fullName>
|
<externalId>false</externalId>
|
<formula>Sales_amount_without_tax__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>发货金额(不含税) Copy</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>2</scale>
|
<trackTrending>false</trackTrending>
|
<type>Currency</type>
|
</fields>
|
<fields>
|
<fullName>Sales_cost_without_tax__c</fullName>
|
<externalId>false</externalId>
|
<formula>Case( Currency__c,"RMB", Cost__c,
|
"USD",IF(today()>=Datevalue($Label.Tax_Foreign_Date),Cost__c * 6.8,Cost__c * 6.3),
|
0
|
|
)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>发货成本(不含税)</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>2</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Sales_sub_PIC__c</fullName>
|
<externalId>false</externalId>
|
<label>推进担当</label>
|
<length>20</length>
|
<required>false</required>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Set_Target_DC_wave__c</fullName>
|
<externalId>false</externalId>
|
<formula>Opportunity__r.Account.Parent.Set_Target_DC_wave__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>Set_Target_DC_wave</label>
|
<trackTrending>false</trackTrending>
|
<type>Checkbox</type>
|
</fields>
|
<fields>
|
<fullName>Shipping_date_Copy__c</fullName>
|
<externalId>false</externalId>
|
<label>发货日Copy</label>
|
<required>false</required>
|
<trackTrending>false</trackTrending>
|
<type>Date</type>
|
</fields>
|
<fields>
|
<fullName>Shipping_date__c</fullName>
|
<description>IF(ISBLANK(Date_Shipped__c),
|
DATE(VALUE(mid(Date_Returned__c,1,4)),VALUE(mid(Date_Returned__c,6,2)),VALUE(mid(Date_Returned__c,9,2))),
|
|
|
DATE(VALUE(mid(Date_Shipped__c,1,4)),VALUE(mid(Date_Shipped__c,6,2)),VALUE(mid(Date_Shipped__c,9,2))))</description>
|
<externalId>false</externalId>
|
<formula>IF(ISBLANK(Date_Shipped__c),
|
DATE(VALUE(mid(Date_Returned__c,1,4)),VALUE(mid(Date_Returned__c,5,2)),VALUE(mid(Date_Returned__c,7,2))),
|
|
|
DATE(VALUE(mid(Date_Shipped__c,1,4)),VALUE(mid(Date_Shipped__c,5,2)),VALUE(mid(Date_Shipped__c,7,2))))</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>发货日</label>
|
<required>false</required>
|
<trackTrending>false</trackTrending>
|
<type>Date</type>
|
</fields>
|
<fields>
|
<fullName>Sixth_layer__c</fullName>
|
<externalId>false</externalId>
|
<formula>Opportunity__r.Owner.Category6__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>第6层区分</label>
|
<required>false</required>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Strategic_dept__c</fullName>
|
<externalId>false</externalId>
|
<formula>Case(GBIC__c,
|
"GI","消化科",
|
"ET","ET",
|
"BF","呼吸科",
|
"GS","普外科",
|
"URO","泌尿科",
|
"GYN","妇科",
|
"ENT","耳鼻喉科",
|
"OTH","其他","")</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>战略科室分类</label>
|
<required>false</required>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Team__c</fullName>
|
<externalId>false</externalId>
|
<formula>Opportunity__r.Owner.Group__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>组</label>
|
<required>false</required>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Third_layer__c</fullName>
|
<externalId>false</externalId>
|
<formula>Opportunity__r.Owner.Category3__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>第3层区分</label>
|
<required>false</required>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Upsert_UniqueKey__c</fullName>
|
<caseSensitive>true</caseSensitive>
|
<externalId>true</externalId>
|
<label>Upsert_UniqueKey</label>
|
<length>255</length>
|
<required>false</required>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>true</unique>
|
</fields>
|
<fields>
|
<fullName>X12_BSS__c</fullName>
|
<externalId>false</externalId>
|
<formula>Product_ID__r.X12_BSS__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>12分类(BSS)</label>
|
<required>false</required>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>X12_BSS_for_OCAP__c</fullName>
|
<externalId>false</externalId>
|
<formula>Product_ID__r.BSS_2_for_OCAP__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>12分类(BSS) for OCAP</label>
|
<required>false</required>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>in_wave__c</fullName>
|
<externalId>false</externalId>
|
<formula>"in"</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>in_wave</label>
|
<required>false</required>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<label>SAP发货</label>
|
<nameField>
|
<displayFormat>Ship-{0000000000}</displayFormat>
|
<label>发货No</label>
|
<type>AutoNumber</type>
|
</nameField>
|
<searchLayouts/>
|
<sharingModel>Private</sharingModel>
|
<visibility>Public</visibility>
|
</CustomObject>
|
