<?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>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>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>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>250</length>
|
<required>false</required>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Date_wave__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(isnull(Shipping_date__c),Opportunity__r.CloseDate,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>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_OCSM_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>凭证号码</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","全国",
|
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(ISNULL(Today__c), null,
|
IF(MONTH(Today__c) <= 3,
|
text(YEAR(Today__c) - 1- 1867)&"P",
|
text(YEAR(Today__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>BackOrder_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(month(Today()) = 4,"PA:4月(1Q)",
|
IF(month(Today()) = 5,"PA:5月(1Q)",
|
IF(month(Today()) = 6,"PA:6月(1Q)",
|
IF(month(Today()) = 7,"PA:7月(2Q)",
|
IF(month(Today()) = 8,"PA:8月(2Q)",
|
IF(month(Today()) = 9,"PA:9月(2Q)",
|
IF(month(Today()) = 10,"PB:10月(3Q)",
|
IF(month(Today()) = 11,"PB:11月(3Q)",
|
IF(month(Today()) = 12,"PB:12月(3Q)",
|
IF(month(Today()) = 1,"PB:01月(4Q)",
|
IF(month(Today()) = 2,"PB:02月(4Q)",
|
IF(month(Today()) = 3,"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_backorder_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__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>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>
|
<externalId>false</externalId>
|
<formula>Case( Currency__c,"RMB", Sales_Amount__c / Opportunity__r.Tax_Intra_F_Copy__c
|
,"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
|
)
|
)
|
)
|
)
|
)
|
,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__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>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>Today__c</fullName>
|
<externalId>false</externalId>
|
<formula>today()</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>今天</label>
|
<required>false</required>
|
<trackTrending>false</trackTrending>
|
<type>Date</type>
|
</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>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>BO-{0000000000}</displayFormat>
|
<label>注残No</label>
|
<type>AutoNumber</type>
|
</nameField>
|
<searchLayouts/>
|
<sharingModel>Private</sharingModel>
|
<visibility>Public</visibility>
|
</CustomObject>
|
