<?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>250</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>Category__c</fullName>
|
<externalId>false</externalId>
|
<label>Category</label>
|
<length>250</length>
|
<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>250</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>DN__c</fullName>
|
<externalId>false</externalId>
|
<label>DN号</label>
|
<length>250</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>250</length>
|
<required>false</required>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Department_name__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>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__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_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>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>false</externalId>
|
<label>GBIC</label>
|
<length>250</length>
|
<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>GI_SP_category__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>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>Item_code_with_0__c</fullName>
|
<externalId>false</externalId>
|
<label>Item code with 0</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>250</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>
|
<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>News__c</fullName>
|
<externalId>false</externalId>
|
<label>科室编号（News）</label>
|
<length>250</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","全国",
|
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(ISNULL(Order_date__c), null,
|
IF(MONTH(Order_date__c) <= 3,
|
text(YEAR(Order_date__c) - 1- 1867)&"P",
|
text(YEAR(Order_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>SAP</relationshipName>
|
<required>false</required>
|
<trackTrending>false</trackTrending>
|
<type>Lookup</type>
|
</fields>
|
<fields>
|
<fullName>Order_category__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>Order_category_discription__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>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(mid(Date_Ordered__c,5,2) = "04","PA:4月(1Q)",
|
IF(mid(Date_Ordered__c,5,2) = "05","PA:5月(1Q)",
|
IF(mid(Date_Ordered__c,5,2) = "06","PA:6月(1Q)",
|
IF(mid(Date_Ordered__c,5,2) = "07","PA:7月(2Q)",
|
IF(mid(Date_Ordered__c,5,2) = "08","PA:8月(2Q)",
|
IF(mid(Date_Ordered__c,5,2) = "09","PA:9月(2Q)",
|
IF(mid(Date_Ordered__c,5,2) = "10","PB:10月(3Q)",
|
IF(mid(Date_Ordered__c,5,2)= "11","PB:11月(3Q)",
|
IF(mid(Date_Ordered__c,5,2) = "12","PB:12月(3Q)",
|
IF(mid(Date_Ordered__c,5,2) = "01","PB:01月(4Q)",
|
IF(mid(Date_Ordered__c,5,2) = "02","PB:02月(4Q)",
|
IF(mid(Date_Ordered__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_order_history</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>250</length>
|
<required>false</required>
|
<trackTrending>false</trackTrending>
|
<type>Text</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>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>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>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>250</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>20190327前
|
Case( Currency__c,"RMB", IF(Order_date__c >= Datevalue("2018-05-01"),Sales_Amount__c /1.16,Sales_Amount__c /1.17)
|
,"USD",IF(Order_date__c >= Datevalue($Label.Tax_Foreign_Date),Sales_Amount__c * 6.8,
|
IF(Order_date__c >= Datevalue("2018-05-01"),Sales_Amount__c * 6.3,
|
IF(Order_date__c >= Datevalue("2016-12-01"),Sales_Amount__c * 6.8,
|
IF(Order_date__c >= Datevalue("2016-07-01"),Sales_Amount__c * 6.5,
|
IF(Order_date__c >= Datevalue("2012-10-01"),
|
Sales_Amount__c * 6.3, Sales_Amount__c * 6.6
|
)
|
)
|
)
|
)
|
)
|
,Sales_Amount__c * 1
|
)</description>
|
<externalId>false</externalId>
|
<formula>Case(Currency__c,"RMB",
|
IF(
|
Order_date__c < Datevalue($Label.Tax_Date),
|
Sales_Amount__c/1.17,
|
if(
|
And(Order_date__c >= Datevalue( $Label.Tax_Date ),Order_date__c < Datevalue($Label.Tax_Date_13 )),
|
Sales_Amount__c/1.16,
|
Sales_Amount__c/1.13
|
)
|
)
|
,"USD", Sales_Amount__c * Usd_Tax_Formula__c
|
,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_sub_PIC__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>Shipping_date__c</fullName>
|
<externalId>false</externalId>
|
<formula>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>
|
<externalId>false</externalId>
|
<label>Upsert_UniqueKey</label>
|
<length>250</length>
|
<required>false</required>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Usd_Tax_Formula__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(text(Currency__c) = 'USD',
|
IF(Order_date__c >= Datevalue("2018-05-01"), 6.3,
|
IF(Order_date__c >= Datevalue("2016-12-01"), 6.8,
|
IF(Order_date__c >= Datevalue("2016-07-01"), 6.5,
|
IF(Order_date__c >= Datevalue("2012-10-01"), 6.3,
|
6.6
|
)
|
)
|
)
|
),1
|
)</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>
|
<label>SAP订货历史</label>
|
<nameField>
|
<displayFormat>OrderHis-{0000000000}</displayFormat>
|
<label>SAP订货历史No</label>
|
<type>AutoNumber</type>
|
</nameField>
|
<searchLayouts/>
|
<sharingModel>Private</sharingModel>
|
<visibility>Public</visibility>
|
</CustomObject>
|
