<?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>true</enableReports>
|
<enableSearch>true</enableSearch>
|
<enableSharing>true</enableSharing>
|
<enableStreamingApi>true</enableStreamingApi>
|
<externalSharingModel>Read</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>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>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>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>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>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>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>Grade__c</fullName>
|
<externalId>false</externalId>
|
<formula>CASE(Opportunity__r.Grade__c,
|
"三级甲", "01.三级甲",
|
"三级乙", "02.三级乙",
|
"三级丙", "03.三级丙",
|
"三级", "04.三级",
|
"二级甲", "05.二级甲",
|
"二级乙", "06.二级乙",
|
"二级丙", "07.二级丙",
|
"二级", "08.二级",
|
"一级甲", "09.一级甲",
|
"一级乙", "10.一级乙",
|
"一级丙", "11.一级丙",
|
"一级", "12.一级",
|
"一般", "98.一般",
|
"99.无")</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>政府等级</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>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","全国",
|
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_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发货Open</relationshipLabel>
|
<relationshipName>SAP_Open</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发货Open</relationshipLabel>
|
<relationshipName>SAP_shipopen_product_ID</relationshipName>
|
<required>false</required>
|
<trackTrending>false</trackTrending>
|
<type>Lookup</type>
|
</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>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>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("2012-10-01"), Sales_Amount__c * 0.8076915, IF Shipping_date__c >= 2016-07-01, Sales_Amount__c * 0.8333325 , 2012-10-01之前的，Sales_Amount__c * 0.846153),Sales_Amount__c * 1)
|
20190327前
|
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>
|
<inlineHelpText>数字</inlineHelpText>
|
<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>20</length>
|
<required>false</required>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</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>Shipping_month__c</fullName>
|
<externalId>false</externalId>
|
<formula>TEXT(YEAR(Shipping_date__c)) & "年" & TEXT(MONTH(Shipping_date__c)) & "月"</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>发货月</label>
|
<required>false</required>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</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>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>
|
<label>SAP发货Open</label>
|
<nameField>
|
<displayFormat>Ship-{0000000000}</displayFormat>
|
<label>发货No</label>
|
<type>AutoNumber</type>
|
</nameField>
|
<searchLayouts/>
|
<sharingModel>Read</sharingModel>
|
<visibility>Public</visibility>
|
</CustomObject>
|
