<?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>false</enableBulkApi>
|
<enableChangeDataCapture>false</enableChangeDataCapture>
|
<enableFeeds>false</enableFeeds>
|
<enableHistory>true</enableHistory>
|
<enableReports>true</enableReports>
|
<enableSearch>true</enableSearch>
|
<enableSharing>false</enableSharing>
|
<enableStreamingApi>false</enableStreamingApi>
|
<externalSharingModel>Private</externalSharingModel>
|
<fields>
|
<fullName>Account_name__c</fullName>
|
<externalId>false</externalId>
|
<label>客户名</label>
|
<length>250</length>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Agent1__c</fullName>
|
<externalId>false</externalId>
|
<label>经销商1</label>
|
<length>250</length>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Amount_Without_Tax_F_forecast__c</fullName>
|
<externalId>false</externalId>
|
<label>预测对象 : OCSM预测成交金额(不含税)</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>2</scale>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Currency</type>
|
</fields>
|
<fields>
|
<fullName>Amount_Without_Tax_Thousand_F__c</fullName>
|
<externalId>false</externalId>
|
<label>OCSM预测成交金额（千元RMB，不含税）</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>B_1_shipping_date__c</fullName>
|
<externalId>false</externalId>
|
<label>20.最新发货日（B-1报表用）</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Date</type>
|
</fields>
|
<fields>
|
<fullName>City__c</fullName>
|
<externalId>false</externalId>
|
<label>市</label>
|
<length>250</length>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Contract_recognized_day_1__c</fullName>
|
<externalId>false</externalId>
|
<label>初审日期(订货日)</label>
|
<required>false</required>
|
<trackHistory>true</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Date</type>
|
</fields>
|
<fields>
|
<fullName>Create_data__c</fullName>
|
<externalId>false</externalId>
|
<label>创建日</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Date</type>
|
</fields>
|
<fields>
|
<fullName>CreatedDate_wave__c</fullName>
|
<externalId>false</externalId>
|
<formula>DATEVALUE(CreatedDate)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>CreatedDate_wave</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Date</type>
|
</fields>
|
<fields>
|
<fullName>Date__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(ISBLANK(Day_Update__c),DATEVALUE(CreatedDate),Day_Update__c)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>日期</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Date</type>
|
</fields>
|
<fields>
|
<fullName>Day_Update__c</fullName>
|
<externalId>false</externalId>
|
<label>日期(Update)</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Date</type>
|
</fields>
|
<fields>
|
<fullName>Department__c</fullName>
|
<externalId>false</externalId>
|
<label>销售部（预测）</label>
|
<length>255</length>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Department_category__c</fullName>
|
<externalId>false</externalId>
|
<label>询价科室分类</label>
|
<length>250</length>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Distributor_InCharge_opp__c</fullName>
|
<defaultValue>false</defaultValue>
|
<externalId>false</externalId>
|
<label>经销商管理课负责的询价</label>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Checkbox</type>
|
</fields>
|
<fields>
|
<fullName>ET_SP_Consumption__c</fullName>
|
<defaultValue>false</defaultValue>
|
<externalId>false</externalId>
|
<label>ET/SP耗材</label>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Checkbox</type>
|
</fields>
|
<fields>
|
<fullName>Evaluation_date__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(ISBLANK(Day_Update__c),DATEVALUE(CreatedDate)-15,Day_Update__c-15)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>考核月</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Date</type>
|
</fields>
|
<fields>
|
<fullName>ForecastAccuracyObject__c</fullName>
|
<defaultValue>false</defaultValue>
|
<externalId>false</externalId>
|
<label>预测精度对象</label>
|
<trackHistory>true</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Checkbox</type>
|
</fields>
|
<fields>
|
<fullName>Forecast_Received_day__c</fullName>
|
<externalId>false</externalId>
|
<label>预测OCSM签约日</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Date</type>
|
</fields>
|
<fields>
|
<fullName>Forecast_last_month__c</fullName>
|
<externalId>false</externalId>
|
<formula>Text(OpportunityId__r.Forecast_last_month__c)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>月初_是否上月预测（验证用）</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Forecast_shipping_day__c</fullName>
|
<externalId>false</externalId>
|
<label>预测发货日</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Date</type>
|
</fields>
|
<fields>
|
<fullName>Forecast_target_FF__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(AND(OR(NM_Forecast_onemonth_before__c = "次月发货预测",NM_Forecast_onemonth_before__c = "次月订发货预测"),
|
MONTH(Last_Shipping_Date__c) = 11,
|
YEAR(Last_Shipping_Date__c) = 2019),
|
1,0)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>Forecast_target_ship_thismonth</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Forecast_target_ship_lastmonth__c</fullName>
|
<externalId>false</externalId>
|
<label>预测内发货条数(KPI)</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackHistory>true</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Forecast_target_ship_nextmonth__c</fullName>
|
<externalId>false</externalId>
|
<label>次月预测内发货条数（KPI）</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackHistory>true</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Forecast_target_ship_prospect__c</fullName>
|
<externalId>false</externalId>
|
<label>预测内发货条数（KPI）</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Forecast_target_ship_thismonth__c</fullName>
|
<externalId>false</externalId>
|
<label>次月的上月预测内发货询价条数</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Forecast_this_month__c</fullName>
|
<externalId>false</externalId>
|
<label>是否本月预测询价（KPI）</label>
|
<length>255</length>
|
<required>false</required>
|
<trackHistory>true</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Forecast_this_month_formula__c</fullName>
|
<externalId>false</externalId>
|
<label>是否本月预测询价.</label>
|
<length>255</length>
|
<required>false</required>
|
<trackHistory>true</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Group_purchase_PCL__c</fullName>
|
<defaultValue>false</defaultValue>
|
<externalId>false</externalId>
|
<label>集中采购课负责的询价</label>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Checkbox</type>
|
</fields>
|
<fields>
|
<fullName>IStest1_KPI__c</fullName>
|
<externalId>false</externalId>
|
<formula>test1_KPI__c!= Monthly_Forecast_in_nextmonth__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>次月预测内订货条数（KPI）不一样</label>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Checkbox</type>
|
</fields>
|
<fields>
|
<fullName>If_30_complete__c</fullName>
|
<externalId>false</externalId>
|
<label>是否30天内成交</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackHistory>true</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Is_in_1month2__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(ISBLANK(Contract_recognized_day_1__c) && NOT(ISBLANK(Day_Update__c)), true,
|
YEAR(Contract_recognized_day_1__c) = YEAR(Evaluation_date__c) && MONTH(Contract_recognized_day_1__c) = MONTH(Evaluation_date__c)
|
)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>是否初审日期(订货日)是快照日的上个月</label>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Checkbox</type>
|
</fields>
|
<fields>
|
<fullName>Is_in_1month__c</fullName>
|
<externalId>false</externalId>
|
<formula>YEAR(Last_Shipping_Date__c) = YEAR(Evaluation_date__c) && MONTH(Last_Shipping_Date__c) = MONTH(Evaluation_date__c)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>是否发货日是快照日的上个月</label>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Checkbox</type>
|
</fields>
|
<fields>
|
<fullName>Is_in_2month2__c</fullName>
|
<description>IF(ISBLANK(Contract_recognized_day_1__c) && NOT(ISBLANK(Day_Update__c)), true,
|
YEAR(Contract_recognized_day_1__c) = YEAR(Evaluation_date__c) && MONTH(Contract_recognized_day_1__c) = ( MONTH(Evaluation_date__c) - 1 )
|
)</description>
|
<externalId>false</externalId>
|
<formula>IF(ISBLANK(Contract_recognized_day_1__c) && NOT(ISBLANK(Day_Update__c)), true,
|
(YEAR(Contract_recognized_day_1__c) < YEAR(Evaluation_date__c)&& MONTH(Contract_recognized_day_1__c) <> 12 && MONTH(Contract_recognized_day_1__c)<> 1) || (YEAR(Contract_recognized_day_1__c) = YEAR(Evaluation_date__c) && MONTH(Contract_recognized_day_1__c) = ( MONTH(Evaluation_date__c) - 1 ))
|
)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>是否初审日期(订货日)是快照日的上上个月</label>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Checkbox</type>
|
</fields>
|
<fields>
|
<fullName>Is_in_2month__c</fullName>
|
<externalId>false</externalId>
|
<formula>YEAR(Last_Shipping_Date__c) = YEAR(Evaluation_date__c) && MONTH(Last_Shipping_Date__c) = MONTH(Evaluation_date__c) - 1</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>是否发货日是快照日的上上个月</label>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Checkbox</type>
|
</fields>
|
<fields>
|
<fullName>Istest__c</fullName>
|
<externalId>false</externalId>
|
<formula>test__c != Monthly_Forecast_in__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>预测内订货条数（KPI）不一样</label>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Checkbox</type>
|
</fields>
|
<fields>
|
<fullName>Last_Shipping_Date__c</fullName>
|
<externalId>false</externalId>
|
<label>最新发货日</label>
|
<required>false</required>
|
<trackHistory>true</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Date</type>
|
</fields>
|
<fields>
|
<fullName>Monthly3_order_target__c</fullName>
|
<defaultValue>false</defaultValue>
|
<externalId>false</externalId>
|
<label>预测对象 : 3个月订货预测(公式)</label>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Checkbox</type>
|
</fields>
|
<fields>
|
<fullName>Monthly3_ship_target__c</fullName>
|
<defaultValue>false</defaultValue>
|
<externalId>false</externalId>
|
<label>预测对象 : 3个月发货预测(公式)</label>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Checkbox</type>
|
</fields>
|
<fields>
|
<fullName>Monthly3_ship_target_stock__c</fullName>
|
<defaultValue>false</defaultValue>
|
<externalId>false</externalId>
|
<label>预测对象 : 3个月发货预测 可备货(公式)</label>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Checkbox</type>
|
</fields>
|
<fields>
|
<fullName>Monthly_Forecast_in__c</fullName>
|
<externalId>false</externalId>
|
<label>预测内订货条数（KPI）</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackHistory>true</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Monthly_Forecast_in_nextmonth__c</fullName>
|
<externalId>false</externalId>
|
<label>次月预测内订货条数（KPI）</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackHistory>true</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Monthly_order_target__c</fullName>
|
<defaultValue>false</defaultValue>
|
<externalId>false</externalId>
|
<label>预测对象 : 单月订货预测(公式)</label>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Checkbox</type>
|
</fields>
|
<fields>
|
<fullName>Monthly_order_target_stock__c</fullName>
|
<defaultValue>false</defaultValue>
|
<externalId>false</externalId>
|
<label>预测对象 : 单月订货预测 可备货(公式)</label>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Checkbox</type>
|
</fields>
|
<fields>
|
<fullName>Monthly_ship_target__c</fullName>
|
<defaultValue>false</defaultValue>
|
<externalId>false</externalId>
|
<label>预测对象 : 单月发货预测(公式)</label>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Checkbox</type>
|
</fields>
|
<fields>
|
<fullName>NM_ForecastF__c</fullName>
|
<externalId>false</externalId>
|
<formula>Text(OpportunityId__r.NM_Forecast__c)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>月初_是否次月预测（验证用）</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>NM_Forecast_F__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(NextMonthly_ship_target_F__c = '1' &&
|
(Forecast_Received_day__c > IF(
|
MONTH(today()) = 12,
|
DATE(YEAR(today()), 12, 31),
|
DATE(YEAR(today()), MONTH(today()) + 1, 1) - 1 ) &&
|
Forecast_Received_day__c <=IF(
|
MONTH( today() ) = 11,
|
DATE( YEAR( today() ), 12, 31 ),IF(
|
MONTH( today() ) = 12,
|
DATE( YEAR( today() ) + 1, 01, 31 ),
|
DATE( YEAR( today() ), MONTH ( today() ) + 2, 1 ) - 1 ))
|
) && StageName__c = '询价'
|
&& ForecastAccuracyObject__c = true,"次月订发货预测",
|
IF(NextMonthly_ship_target_F__c = '1' && StageName__c = '询价'
|
&& ForecastAccuracyObject__c = true,"次月发货预测",
|
IF(NextMonthly_order_target_F__c = '1' && (StageName__c = '询价')
|
&& ForecastAccuracyObject__c = true,"次月订货预测","")))</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>NM_Forecast_F</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>NM_Forecast__c</fullName>
|
<externalId>false</externalId>
|
<label>是否次月预测询价</label>
|
<length>225</length>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>NM_Forecast_formula__c</fullName>
|
<externalId>false</externalId>
|
<label>是否次月预测询价.</label>
|
<length>225</length>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>NM_Forecast_onemonth_beforeF__c</fullName>
|
<externalId>false</externalId>
|
<formula>OpportunityId__r.NM_Forecast_onemonth_before__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>月初_询价上月预测（验证用）</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>NM_Forecast_onemonth_before__c</fullName>
|
<externalId>false</externalId>
|
<label>询价上月预测（KPI）</label>
|
<length>100</length>
|
<required>false</required>
|
<trackHistory>true</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>NM_Forecast_twomonth_before__c</fullName>
|
<externalId>false</externalId>
|
<label>询价上上月预测（不要）</label>
|
<length>225</length>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>NextMonthly_order_target_F__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(AND(
|
StageName__c="询价",
|
Forecast_Received_day__c > IF(
|
MONTH(today()) = 12,
|
DATE(YEAR(today()), 12, 31),
|
DATE(YEAR(today()), MONTH(today()) + 1, 1) - 1 ),
|
Forecast_Received_day__c <= IF(
|
MONTH( today() ) = 11,
|
DATE( YEAR( today() ), 12, 31 ),IF(
|
MONTH( today() ) = 12,
|
DATE( YEAR( today() ) + 1, 01, 31 ),
|
DATE( YEAR( today() ), MONTH ( today() ) + 2, 1 ) - 1 ))
|
),
|
'1','0')</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>NextMonthly_order_target_F</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>NextMonthly_order_target__c</fullName>
|
<defaultValue>false</defaultValue>
|
<externalId>false</externalId>
|
<label>预测对象 : 订货次月预测(公式)</label>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Checkbox</type>
|
</fields>
|
<fields>
|
<fullName>NextMonthly_ship_target_F__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(
|
AND(
|
OR(StageName__c="询价",StageName__c="注残"),
|
OpportunityId__r.Inquiry_forcast_date_copy__c > IF(
|
MONTH(today()) = 12,
|
DATE(YEAR(today()), 12, 31),
|
DATE(YEAR(today()), MONTH(today()) + 1, 1) - 1 ),
|
OpportunityId__r.Inquiry_forcast_date_copy__c<= IF(
|
MONTH( today() ) = 11,
|
DATE( YEAR( today() ), 12, 31 ),IF(
|
MONTH( today() ) = 12,
|
DATE( YEAR( today() ) + 1, 01, 31 ),
|
DATE( YEAR( today() ), MONTH ( today() ) + 2, 1 ) - 1 ))),
|
'1','0'
|
)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>NextMonthly_ship_target_F</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>NextMonthly_ship_target__c</fullName>
|
<defaultValue>false</defaultValue>
|
<externalId>false</externalId>
|
<label>预测对象 : 发货次月预测(公式)</label>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Checkbox</type>
|
</fields>
|
<fields>
|
<fullName>NoDRMB_Without_Tax_1000TR__c</fullName>
|
<externalId>false</externalId>
|
<label>NoD合计金额（换算值，千元RMB,不含税）</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>2</scale>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>NoDWithout_Tax_Thousand__c</fullName>
|
<externalId>false</externalId>
|
<label>NoD合计金额（千元RMB,不含税）</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>2</scale>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Number_of_deep_proposale__c</fullName>
|
<externalId>false</externalId>
|
<label>是否进行深度提案</label>
|
<precision>10</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Number_of_follow_up__c</fullName>
|
<externalId>false</externalId>
|
<label>累计跟进次数</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>OCM_cateogy__c</fullName>
|
<externalId>false</externalId>
|
<label>OCSM分类</label>
|
<length>250</length>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>OCM_man_province__c</fullName>
|
<externalId>false</externalId>
|
<label>OCSM管理省(预测用)</label>
|
<length>255</length>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>OCM_man_province_lastmonth__c</fullName>
|
<externalId>false</externalId>
|
<label>OCSM管理省(预测用上月)</label>
|
<length>255</length>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>OCSM_RMB_Without_Tax_1000TR__c</fullName>
|
<externalId>false</externalId>
|
<label>OCSM产品预测金额（换算值，千元RMB不含税）</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>2</scale>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>OCSM_RMB_Without_Tax_1000__c</fullName>
|
<externalId>false</externalId>
|
<label>OCSM产品预测金额（千元RMB不含税）</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>2</scale>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Opp_Forecast_this_month__c</fullName>
|
<externalId>false</externalId>
|
<formula>TEXT(OpportunityId__r.Forecast_this_month__c)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>月初_是否本月预测（验证用）</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Opp_Owner_Id__c</fullName>
|
<externalId>false</externalId>
|
<formula>Opp_owner__r.Id</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>询价所有人ID</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Opp_StageName__c</fullName>
|
<externalId>false</externalId>
|
<formula>OpportunityId__r.StageName__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>询价状态1</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Opp_owner__c</fullName>
|
<deleteConstraint>SetNull</deleteConstraint>
|
<externalId>false</externalId>
|
<label>询价所有人</label>
|
<referenceTo>User</referenceTo>
|
<relationshipName>SS_Opp_owner</relationshipName>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Lookup</type>
|
</fields>
|
<fields>
|
<fullName>OpportunityId__c</fullName>
|
<deleteConstraint>Restrict</deleteConstraint>
|
<externalId>false</externalId>
|
<label>业务机会Id</label>
|
<referenceTo>Opportunity</referenceTo>
|
<relationshipLabel>SS_每月3个工作日询价清单</relationshipLabel>
|
<relationshipName>SS_Prospect_5days_list</relationshipName>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Lookup</type>
|
</fields>
|
<fields>
|
<fullName>Opportunity_Id__c</fullName>
|
<externalId>false</externalId>
|
<formula>OpportunityId__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>询价ID</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Opportunity_Name__c</fullName>
|
<externalId>false</externalId>
|
<label>询价名称</label>
|
<length>250</length>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Opportunity_No__c</fullName>
|
<externalId>false</externalId>
|
<label>询价编码</label>
|
<length>250</length>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Opportunity_sub_owner__c</fullName>
|
<externalId>false</externalId>
|
<label>询价副担当(产品专业)</label>
|
<length>250</length>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Owner_Employee_No__c</fullName>
|
<externalId>false</externalId>
|
<formula>Opp_owner__r.Employee_No__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>询价所有人员工编码</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Owner_IsActive__c</fullName>
|
<externalId>false</externalId>
|
<formula>Opp_owner__r.IsActive</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>启用</label>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Checkbox</type>
|
</fields>
|
<fields>
|
<fullName>Owner_lastmonth__c</fullName>
|
<externalId>false</externalId>
|
<label>所有人（上月）</label>
|
<length>100</length>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Person_in_charge__c</fullName>
|
<externalId>false</externalId>
|
<label>询价担当</label>
|
<length>250</length>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Propose_OPD_number__c</fullName>
|
<externalId>false</externalId>
|
<label>是否做OPD</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Prospect_follow_up_Situation__c</fullName>
|
<externalId>false</externalId>
|
<label>询价跟进情况</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>TextArea</type>
|
</fields>
|
<fields>
|
<fullName>Province_Wave__c</fullName>
|
<externalId>false</externalId>
|
<formula>OpportunityId__r.Province_BA__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>Province_Wave</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Province__c</fullName>
|
<externalId>false</externalId>
|
<label>省</label>
|
<length>250</length>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Purchase_Type__c</fullName>
|
<externalId>false</externalId>
|
<label>订货流程类别</label>
|
<length>255</length>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Rank__c</fullName>
|
<externalId>false</externalId>
|
<label>询价等级</label>
|
<length>10</length>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>RecordCount__c</fullName>
|
<externalId>false</externalId>
|
<formula>1</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>询价件数</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>SAP_WIN__c</fullName>
|
<defaultValue>false</defaultValue>
|
<externalId>false</externalId>
|
<label>SAP上传(WIN)</label>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Checkbox</type>
|
</fields>
|
<fields>
|
<fullName>SFDCLast_Process_Date__c</fullName>
|
<externalId>false</externalId>
|
<label>13.SFDC最终处理日</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Date</type>
|
</fields>
|
<fields>
|
<fullName>SalesAmount__c</fullName>
|
<externalId>false</externalId>
|
<label>OCSM预测成交金额(不含税)</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>2</scale>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Currency</type>
|
</fields>
|
<fields>
|
<fullName>SalesDept_SAP__c</fullName>
|
<externalId>false</externalId>
|
<label>销售本部（SAP业绩）</label>
|
<length>255</length>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>SalesDept_Wave__c</fullName>
|
<externalId>false</externalId>
|
<formula>OpportunityId__r.Salesdepartment_SAP__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>SalesDept_Wave</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>SalesDept__c</fullName>
|
<externalId>false</externalId>
|
<label>销售本部（所有人）</label>
|
<length>250</length>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>SalesdepartmentForecast__c</fullName>
|
<externalId>false</externalId>
|
<label>销售本部（预测）</label>
|
<length>255</length>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>SalesdepartmentForecast_lastmonth__c</fullName>
|
<externalId>false</externalId>
|
<label>销售本部（预测上月）</label>
|
<length>255</length>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Salesdepartment_Owner_lastmonth__c</fullName>
|
<externalId>false</externalId>
|
<label>销售本部（所有人上月）</label>
|
<length>255</length>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Shipping_Date_For_Report__c</fullName>
|
<externalId>false</externalId>
|
<label>日期(业绩统计用)★</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Date</type>
|
</fields>
|
<fields>
|
<fullName>Shipping_Finished_Day__c</fullName>
|
<externalId>false</externalId>
|
<label>20.订单发货完毕日</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Date</type>
|
</fields>
|
<fields>
|
<fullName>SpecialApplyMemo__c</fullName>
|
<externalId>false</externalId>
|
<label>特殊对应栏</label>
|
<length>255</length>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>SpecialApply__c</fullName>
|
<deleteConstraint>SetNull</deleteConstraint>
|
<externalId>false</externalId>
|
<label>最新特殊对应</label>
|
<referenceTo>OpportunitySpecialApply__c</referenceTo>
|
<relationshipLabel>SS_每月3个工作日询价清单</relationshipLabel>
|
<relationshipName>SS_3</relationshipName>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Lookup</type>
|
</fields>
|
<fields>
|
<fullName>Special_Apply_Content__c</fullName>
|
<externalId>false</externalId>
|
<label>最新特殊对应-本月申请</label>
|
<length>50</length>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Special_Apply_Reason__c</fullName>
|
<externalId>false</externalId>
|
<label>最新特殊对应-理由</label>
|
<length>255</length>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Special_Approval_Date__c</fullName>
|
<externalId>false</externalId>
|
<label>最新特殊对应-批准日</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Date</type>
|
</fields>
|
<fields>
|
<fullName>StageName_Forecast__c</fullName>
|
<externalId>false</externalId>
|
<label>状态(预测)</label>
|
<length>50</length>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>StageName__c</fullName>
|
<externalId>false</externalId>
|
<label>状态1</label>
|
<length>250</length>
|
<required>false</required>
|
<trackHistory>true</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>StageName_lastmonth__c</fullName>
|
<externalId>false</externalId>
|
<label>状态（KPI）</label>
|
<length>50</length>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>State_Owner__c</fullName>
|
<externalId>false</externalId>
|
<label>OCSM管理省（所有人）</label>
|
<length>255</length>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>State_Owner_lastmonth__c</fullName>
|
<externalId>false</externalId>
|
<label>OCSM管理省（所有人上月）</label>
|
<length>100</length>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Statge2__c</fullName>
|
<externalId>false</externalId>
|
<label>状态2</label>
|
<length>250</length>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Team__c</fullName>
|
<externalId>false</externalId>
|
<label>组</label>
|
<length>250</length>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>This_mont_update_PCL__c</fullName>
|
<externalId>false</externalId>
|
<label>是否本月更新询价</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Visit_president__c</fullName>
|
<externalId>false</externalId>
|
<label>是否已拜访了院长</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Visit_professor__c</fullName>
|
<externalId>false</externalId>
|
<label>是否已拜访了主任</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>check_this_month__c</fullName>
|
<externalId>false</externalId>
|
<formula>if(Forecast_this_month_formula__c!= text(OpportunityId__r.Forecast_this_month__c),false,
|
if(NM_Forecast_formula__c!=text(OpportunityId__r.NM_Forecast__c),false,
|
if(NM_Forecast__c!= OpportunityId__r.NM_Forecast_onemonth_before__c,false,true)))</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>一致检查</label>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Checkbox</type>
|
</fields>
|
<fields>
|
<fullName>created_time__c</fullName>
|
<externalId>false</externalId>
|
<formula>DATETIMEVALUE(CreatedDate)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>创建时间</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>DateTime</type>
|
</fields>
|
<fields>
|
<fullName>order_Date_For_Report__c</fullName>
|
<externalId>false</externalId>
|
<label>日期(预测统计用)★</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Date</type>
|
</fields>
|
<fields>
|
<fullName>owner__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF( ISBLANK( owner_txt__c ) , Opp_owner__r.Alias ,owner_txt__c)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>所有人</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>owner_txt__c</fullName>
|
<externalId>false</externalId>
|
<label>所有人（文本）</label>
|
<length>100</length>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>tempflag__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(Forecast_this_month_formula__c = TEXT(OpportunityId__r.Forecast_this_month__c),true,false)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>tempflag</label>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Checkbox</type>
|
</fields>
|
<fields>
|
<fullName>test1_KPI__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(AND(OR(NM_Forecast_onemonth_before__c = "次月订货预测",NM_Forecast_onemonth_before__c = "次月订发货预测"),
|
MONTH(Contract_recognized_day_1__c) = IF(MONTH(TODAY()) = 1, 12, MONTH(TODAY())-1),
|
YEAR(Contract_recognized_day_1__c) = IF(MONTH(TODAY()) = 1, YEAR(TODAY())-1, YEAR(TODAY()))),
|
1,0)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>test1次月预测内订货条数（KPI）</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>test__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(AND(NOT(ISBLANK(Forecast_this_month__c)),
|
MONTH(Contract_recognized_day_1__c) = IF(MONTH(TODAY()) = 1, 12, MONTH(TODAY())-1),
|
YEAR(Contract_recognized_day_1__c) = IF(MONTH(TODAY()) = 1, YEAR(TODAY())-1, YEAR(TODAY()))),
|
1,0)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>test预测内订货条数（KPI）</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<label>SS_每月3个工作日询价清单</label>
|
<nameField>
|
<displayFormat>SSPCL5Days-{YYYY}{MM}-{00000}</displayFormat>
|
<label>SS_每月3号询价清单名称</label>
|
<trackHistory>false</trackHistory>
|
<type>AutoNumber</type>
|
</nameField>
|
<searchLayouts/>
|
<sharingModel>Private</sharingModel>
|
<visibility>Public</visibility>
|
</CustomObject>
|
