<?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>BSS_category__c</fullName>
|
<externalId>false</externalId>
|
<formula>text(Product_ID__r.BSSCategory__c )</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>BSS分类</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>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>200</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__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_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>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__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>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__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>30</length>
|
<required>false</required>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</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>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>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>OCM_Province__c</fullName>
|
<externalId>false</externalId>
|
<formula>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_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>SAP1</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>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_Shiphistory</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>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>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__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_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_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>20180326前
|
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_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>
|
<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>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>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>
|
<label>SAP发货历史</label>
|
<nameField>
|
<displayFormat>ShipHis-{0000000000}</displayFormat>
|
<label>SAP发货NO</label>
|
<type>AutoNumber</type>
|
</nameField>
|
<searchLayouts/>
|
<sharingModel>Private</sharingModel>
|
<visibility>Public</visibility>
|
</CustomObject>
|
