<?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>
|
<content>RentalFixtureSetSelect</content>
|
<skipRecordTypeSelect>false</skipRecordTypeSelect>
|
<type>Visualforce</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>
|
<description>Name=申请名:配套名:IndexFromUniqueKey__c:(原的加 NG or Canceled, 新的加 Sub)
|
UniqueKey__c =
|
借出备品配套申请.RequestNoJoinStr2__c + ':' + 借出备品配套.Fixture_Set__r.Id + ':'
|
+ IndexFromUniqueKey__c（选择申请配套画面里 数量是 3 的话， 1，2，3）
|
+ Id (如果Cancel的话 or 代替品)</description>
|
<enableActivities>false</enableActivities>
|
<enableBulkApi>true</enableBulkApi>
|
<enableChangeDataCapture>false</enableChangeDataCapture>
|
<enableFeeds>false</enableFeeds>
|
<enableHistory>true</enableHistory>
|
<enableReports>true</enableReports>
|
<enableSearch>true</enableSearch>
|
<enableSharing>true</enableSharing>
|
<enableStreamingApi>true</enableStreamingApi>
|
<externalSharingModel>ControlledByParent</externalSharingModel>
|
<fieldSets>
|
<fullName>RentalApplyExtensions_L</fullName>
|
<description>延期申请(左边)</description>
|
<displayedFields>
|
<field>Rental_Apply__c</field>
|
<isFieldManaged>false</isFieldManaged>
|
<isRequired>false</isRequired>
|
</displayedFields>
|
<displayedFields>
|
<field>Name</field>
|
<isFieldManaged>false</isFieldManaged>
|
<isRequired>false</isRequired>
|
</displayedFields>
|
<label>延期申请(左边)</label>
|
</fieldSets>
|
<fieldSets>
|
<fullName>RentalApplyExtensions_R</fullName>
|
<description>延期申请(右边)</description>
|
<displayedFields>
|
<field>First_RAESD_Model_No_F__c</field>
|
<isFieldManaged>false</isFieldManaged>
|
<isRequired>false</isRequired>
|
</displayedFields>
|
<displayedFields>
|
<field>Set_Managment_Code__c</field>
|
<isFieldManaged>false</isFieldManaged>
|
<isRequired>false</isRequired>
|
</displayedFields>
|
<displayedFields>
|
<field>SerialNumber_F__c</field>
|
<isFieldManaged>false</isFieldManaged>
|
<isRequired>false</isRequired>
|
</displayedFields>
|
<displayedFields>
|
<field>Loaner_Set_No__c</field>
|
<isFieldManaged>false</isFieldManaged>
|
<isRequired>false</isRequired>
|
</displayedFields>
|
<displayedFields>
|
<field>RAES_Status__c</field>
|
<isFieldManaged>false</isFieldManaged>
|
<isRequired>false</isRequired>
|
</displayedFields>
|
<label>延期申请(右边)</label>
|
</fieldSets>
|
<fieldSets>
|
<fullName>RentalFixtureSetAssign_RightFieldSet</fullName>
|
<description>定义分配画面的借出备品配套一览的相关一览字段</description>
|
<displayedFields>
|
<field>First_RAESD_Model_No_F__c</field>
|
<isFieldManaged>false</isFieldManaged>
|
<isRequired>false</isRequired>
|
</displayedFields>
|
<displayedFields>
|
<field>Loaner_name_F__c</field>
|
<isFieldManaged>false</isFieldManaged>
|
<isRequired>false</isRequired>
|
</displayedFields>
|
<displayedFields>
|
<field>Zhu_Ti_Fen_Pei_Jia__c</field>
|
<isFieldManaged>false</isFieldManaged>
|
<isRequired>false</isRequired>
|
</displayedFields>
|
<displayedFields>
|
<field>Fu_Shu_Pin_Fen_Pei_Jia__c</field>
|
<isFieldManaged>false</isFieldManaged>
|
<isRequired>false</isRequired>
|
</displayedFields>
|
<displayedFields>
|
<field>Irreplaceable_flag__c</field>
|
<isFieldManaged>false</isFieldManaged>
|
<isRequired>false</isRequired>
|
</displayedFields>
|
<displayedFields>
|
<field>Substitute_flag__c</field>
|
<isFieldManaged>false</isFieldManaged>
|
<isRequired>false</isRequired>
|
</displayedFields>
|
<displayedFields>
|
<field>Body_Queue_Number__c</field>
|
<isFieldManaged>false</isFieldManaged>
|
<isRequired>false</isRequired>
|
</displayedFields>
|
<displayedFields>
|
<field>Pai_Dui_Jia__c</field>
|
<isFieldManaged>false</isFieldManaged>
|
<isRequired>false</isRequired>
|
</displayedFields>
|
<displayedFields>
|
<field>Ke_Yi_Fen_Pei_Zhu_Ti_Jia__c</field>
|
<isFieldManaged>false</isFieldManaged>
|
<isRequired>false</isRequired>
|
</displayedFields>
|
<displayedFields>
|
<field>Bie_Cun_Fang_Di_Ku_Cun_Jia__c</field>
|
<isFieldManaged>false</isFieldManaged>
|
<isRequired>false</isRequired>
|
</displayedFields>
|
<displayedFields>
|
<field>Bie_Yong_Tu_Ku_Cun_Jia__c</field>
|
<isFieldManaged>false</isFieldManaged>
|
<isRequired>false</isRequired>
|
</displayedFields>
|
<displayedFields>
|
<field>Bie_Ben_Bu_Ku_Cun_Jia__c</field>
|
<isFieldManaged>false</isFieldManaged>
|
<isRequired>false</isRequired>
|
</displayedFields>
|
<displayedFields>
|
<field>Bie_Chan_Pin_Fen_Lei_Jia__c</field>
|
<isFieldManaged>false</isFieldManaged>
|
<isRequired>false</isRequired>
|
</displayedFields>
|
<displayedFields>
|
<field>Rental_Start_Date__c</field>
|
<isFieldManaged>false</isFieldManaged>
|
<isRequired>false</isRequired>
|
</displayedFields>
|
<displayedFields>
|
<field>Rental_End_Date__c</field>
|
<isFieldManaged>false</isFieldManaged>
|
<isRequired>false</isRequired>
|
</displayedFields>
|
<displayedFields>
|
<field>Jie_Chu_Shi_Jian_Jia__c</field>
|
<isFieldManaged>false</isFieldManaged>
|
<isRequired>false</isRequired>
|
</displayedFields>
|
<label>借出备品配套一览(分配画面)右</label>
|
</fieldSets>
|
<fieldSets>
|
<fullName>RentalFixtureSetSelect_right</fullName>
|
<description>画面借出备品SET一览（配套选择）
|
不能使用参照先的字段(因为有GroupBy 备品配套)</description>
|
<displayedFields>
|
<field>Fixture_Set__r.Name</field>
|
<isFieldManaged>false</isFieldManaged>
|
<isRequired>false</isRequired>
|
</displayedFields>
|
<displayedFields>
|
<field>Fixture_Set__r.Loaner_name__c</field>
|
<isFieldManaged>false</isFieldManaged>
|
<isRequired>false</isRequired>
|
</displayedFields>
|
<displayedFields>
|
<field>Rental_Num__c</field>
|
<isFieldManaged>false</isFieldManaged>
|
<isRequired>false</isRequired>
|
</displayedFields>
|
<displayedFields>
|
<field>Irreplaceable_flag__c</field>
|
<isFieldManaged>false</isFieldManaged>
|
<isRequired>false</isRequired>
|
</displayedFields>
|
<displayedFields>
|
<field>Same_Accessory_flag__c</field>
|
<isFieldManaged>false</isFieldManaged>
|
<isRequired>false</isRequired>
|
</displayedFields>
|
<displayedFields>
|
<field>FixtureSetDetailSelect_VF__c</field>
|
<isFieldManaged>false</isFieldManaged>
|
<isRequired>false</isRequired>
|
</displayedFields>
|
<label>借出备品配套一览（配套选择）右</label>
|
</fieldSets>
|
<fieldSets>
|
<fullName>Rental_Apply_Set_Extend_List</fullName>
|
<description>定义备品借出申请的借出备品SET一览的关联一览的字段</description>
|
<label>借出备品SET一览(延期申请)</label>
|
</fieldSets>
|
<fieldSets>
|
<fullName>Rental_Apply_Set_Extend_List_L</fullName>
|
<description>EquipmentRentalExtend</description>
|
<displayedFields>
|
<field>Rental_Apply__r.Name</field>
|
<isFieldManaged>false</isFieldManaged>
|
<isRequired>false</isRequired>
|
</displayedFields>
|
<displayedFields>
|
<field>RAES_Status__c</field>
|
<isFieldManaged>false</isFieldManaged>
|
<isRequired>false</isRequired>
|
</displayedFields>
|
<displayedFields>
|
<field>Request_owner__c</field>
|
<isFieldManaged>false</isFieldManaged>
|
<isRequired>false</isRequired>
|
</displayedFields>
|
<displayedFields>
|
<field>Fixture_Set__r.Name</field>
|
<isFieldManaged>false</isFieldManaged>
|
<isRequired>false</isRequired>
|
</displayedFields>
|
<displayedFields>
|
<field>Fixture_Set__r.Loaner_code__c</field>
|
<isFieldManaged>false</isFieldManaged>
|
<isRequired>false</isRequired>
|
</displayedFields>
|
<displayedFields>
|
<field>Rental_Apply__r.Hospital__c</field>
|
<isFieldManaged>false</isFieldManaged>
|
<isRequired>false</isRequired>
|
</displayedFields>
|
<displayedFields>
|
<field>SerialNumber_F__c</field>
|
<isFieldManaged>false</isFieldManaged>
|
<isRequired>false</isRequired>
|
</displayedFields>
|
<label>借出备品SET一览(延期申请)-左边固定</label>
|
</fieldSets>
|
<fieldSets>
|
<fullName>Rental_Apply_Set_Extend_List_R</fullName>
|
<description>EquipmentRentalExtend</description>
|
<displayedFields>
|
<field>Demo_purpose1__c</field>
|
<isFieldManaged>false</isFieldManaged>
|
<isRequired>false</isRequired>
|
</displayedFields>
|
<displayedFields>
|
<field>Demo_purpose2__c</field>
|
<isFieldManaged>false</isFieldManaged>
|
<isRequired>false</isRequired>
|
</displayedFields>
|
<displayedFields>
|
<field>Loaner_name_F__c</field>
|
<isFieldManaged>false</isFieldManaged>
|
<isRequired>false</isRequired>
|
</displayedFields>
|
<displayedFields>
|
<field>Received_Confirm__c</field>
|
<isFieldManaged>false</isFieldManaged>
|
<isRequired>false</isRequired>
|
</displayedFields>
|
<displayedFields>
|
<field>Received_ng_detail__c</field>
|
<isFieldManaged>false</isFieldManaged>
|
<isRequired>false</isRequired>
|
</displayedFields>
|
<label>借出备品SET一览(延期申请)-右边</label>
|
</fieldSets>
|
<fieldSets>
|
<fullName>Rental_Apply_Set_Yet_List</fullName>
|
<description>定义备品借出申请的借出备品SET一览的关联一览的字段</description>
|
<displayedFields>
|
<field>Loaner_code_text__c</field>
|
<isFieldManaged>false</isFieldManaged>
|
<isRequired>false</isRequired>
|
</displayedFields>
|
<displayedFields>
|
<field>Loaner_name_text__c</field>
|
<isFieldManaged>false</isFieldManaged>
|
<isRequired>false</isRequired>
|
</displayedFields>
|
<displayedFields>
|
<field>Rental_Start_Date__c</field>
|
<isFieldManaged>false</isFieldManaged>
|
<isRequired>false</isRequired>
|
</displayedFields>
|
<displayedFields>
|
<field>Rental_End_Date__c</field>
|
<isFieldManaged>false</isFieldManaged>
|
<isRequired>false</isRequired>
|
</displayedFields>
|
<label>借出备品SET一览(未分配)</label>
|
</fieldSets>
|
<fields>
|
<fullName>Account__c</fullName>
|
<externalId>false</externalId>
|
<formula>Rental_Apply__r.Account__r.Name</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>备品使用方</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Add_Day_For_RC__c</fullName>
|
<externalId>false</externalId>
|
<label>RC未定到期延时.</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Date</type>
|
</fields>
|
<fields>
|
<fullName>Add_RetalFSetDetail_Text__c</fullName>
|
<externalId>false</externalId>
|
<label>追加明细审批Text</label>
|
<length>131072</length>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>LongTextArea</type>
|
<visibleLines>3</visibleLines>
|
</fields>
|
<fields>
|
<fullName>After_Inspection_time__c</fullName>
|
<externalId>false</externalId>
|
<label>****回收后-检测完毕时间</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>DateTime</type>
|
</fields>
|
<fields>
|
<fullName>Arrival_wh_time__c</fullName>
|
<externalId>false</externalId>
|
<label>****回库确认完毕时间</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>DateTime</type>
|
</fields>
|
<fields>
|
<fullName>Asset_loaner_start_day__c</fullName>
|
<externalId>false</externalId>
|
<formula>Rental_Apply__r.Asset_loaner_start_day__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>备品预计出货日(申请)</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Date</type>
|
</fields>
|
<fields>
|
<fullName>Asset_return_Day__c</fullName>
|
<externalId>false</externalId>
|
<inlineHelpText>排队参考信息</inlineHelpText>
|
<label>排队备品回寄日</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Date</type>
|
</fields>
|
<fields>
|
<fullName>Asset_return_Status__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(AND(RetalFSetDetail_Cnt__c > 0, RetalFSetDetail_Cnt__c != Wei_Return__c),/*全都没有回寄回寄状态显示空*/
|
IF(Wei_Return__c > 0, '部分归还', '全部归还'
|
)
|
,''
|
)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>回寄状态(Sys)</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Asset_return_day2__c</fullName>
|
<externalId>false</externalId>
|
<formula>DATEVALUE(Asset_return_time__c)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>配套回寄日</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Date</type>
|
</fields>
|
<fields>
|
<fullName>Asset_return_day_F__c</fullName>
|
<externalId>false</externalId>
|
<formula>DATEVALUE(Asset_return_time_F__c)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>第一条明细回寄日</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Date</type>
|
</fields>
|
<fields>
|
<fullName>Asset_return_time_F__c</fullName>
|
<externalId>false</externalId>
|
<formula>First_RAESD__r.Asset_return_time__c</formula>
|
<label>回寄时间F</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>DateTime</type>
|
</fields>
|
<fields>
|
<fullName>Asset_return_time__c</fullName>
|
<externalId>false</externalId>
|
<label>回寄时间</label>
|
<required>false</required>
|
<trackHistory>true</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>DateTime</type>
|
</fields>
|
<fields>
|
<fullName>Assigned_Not_Shipment__c</fullName>
|
<externalId>false</externalId>
|
<label>已分配未出库指示</label>
|
<summaryFilterItems>
|
<field>Rental_Apply_Equipment_Set_Detail__c.Select_Time__c</field>
|
<operation>notEqual</operation>
|
<value></value>
|
</summaryFilterItems>
|
<summaryFilterItems>
|
<field>Rental_Apply_Equipment_Set_Detail__c.Shipment_request_time2__c</field>
|
<operation>equals</operation>
|
<value></value>
|
</summaryFilterItems>
|
<summaryForeignKey>Rental_Apply_Equipment_Set_Detail__c.Rental_Apply_Equipment_Set__c</summaryForeignKey>
|
<summaryOperation>count</summaryOperation>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Summary</type>
|
</fields>
|
<fields>
|
<fullName>Average_day__c</fullName>
|
<description>回寄日-备品中心出库日</description>
|
<externalId>false</externalId>
|
<formula>Asset_return_day2__c - Bollow_Date__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>****借出日数</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>Back_Inspection_time__c</fullName>
|
<externalId>false</externalId>
|
<label>回收后-检测完毕时间</label>
|
<summarizedField>Rental_Apply_Equipment_Set_Detail__c.After_Inspection_time_F__c</summarizedField>
|
<summaryFilterItems>
|
<field>Rental_Apply_Equipment_Set_Detail__c.After_Inspection_time_F__c</field>
|
<operation>notEqual</operation>
|
<value></value>
|
</summaryFilterItems>
|
<summaryFilterItems>
|
<field>Rental_Apply_Equipment_Set_Detail__c.Cancel_Select__c</field>
|
<operation>equals</operation>
|
<value>False</value>
|
</summaryFilterItems>
|
<summaryForeignKey>Rental_Apply_Equipment_Set_Detail__c.Rental_Apply_Equipment_Set__c</summaryForeignKey>
|
<summaryOperation>min</summaryOperation>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Summary</type>
|
</fields>
|
<fields>
|
<fullName>Bie_Ben_Bu_Ku_Cun_Jia__c</fullName>
|
<externalId>false</externalId>
|
<label>别本部库存(Sys)</label>
|
<length>255</length>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Bie_Chan_Pin_Fen_Lei_Jia__c</fullName>
|
<externalId>false</externalId>
|
<label>别产品分类(Sys)</label>
|
<length>255</length>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Bie_Cun_Fang_Di_Ku_Cun_Jia__c</fullName>
|
<externalId>false</externalId>
|
<label>别存放地的库存(Sys)</label>
|
<length>255</length>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Bie_Sheng_Ku_Cun_jia__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>Bie_Yong_Tu_Ku_Cun_Jia__c</fullName>
|
<externalId>false</externalId>
|
<label>别用途库存(Sys)</label>
|
<length>255</length>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Body_Queue_Number__c</fullName>
|
<externalId>false</externalId>
|
<label>主体排队顺序</label>
|
<summarizedField>Rental_Apply_Equipment_Set_Detail__c.Queue_Number__c</summarizedField>
|
<summaryFilterItems>
|
<field>Rental_Apply_Equipment_Set_Detail__c.Is_Body__c</field>
|
<operation>equals</operation>
|
<value>True</value>
|
</summaryFilterItems>
|
<summaryFilterItems>
|
<field>Rental_Apply_Equipment_Set_Detail__c.Cancel_Select__c</field>
|
<operation>equals</operation>
|
<value>False</value>
|
</summaryFilterItems>
|
<summaryForeignKey>Rental_Apply_Equipment_Set_Detail__c.Rental_Apply_Equipment_Set__c</summaryForeignKey>
|
<summaryOperation>max</summaryOperation>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Summary</type>
|
</fields>
|
<fields>
|
<fullName>Bollow_Date_Add_10_WD__c</fullName>
|
<externalId>false</externalId>
|
<label>备品中心出库日(第10个工作日)</label>
|
<required>false</required>
|
<trackHistory>true</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Date</type>
|
</fields>
|
<fields>
|
<fullName>Bollow_Date_Add_7_WD__c</fullName>
|
<externalId>false</externalId>
|
<label>备品中心出库日(第7个工作日)</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Date</type>
|
</fields>
|
<fields>
|
<fullName>Bollow_Date__c</fullName>
|
<externalId>false</externalId>
|
<formula>DATEVALUE( Shippment_loaner_time2__c )</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>备品中心出库日</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Date</type>
|
</fields>
|
<fields>
|
<fullName>Borrow_day__c</fullName>
|
<description>2018/01/31: 报表中使用
|
2018/08/28之前：
|
IF(AND(Not(ISNULL(Shipment_request_command__c)),Not(ISNULL(Bollow_Date__c)),ISNULL(Asset_return_day2__c)), TODAY() - Bollow_Date__c,
|
IF(AND(Not(ISNULL(Shipment_request_command__c)),Not(ISNULL(Bollow_Date__c)),Not(ISNULL(Asset_return_day2__c)))
|
,Asset_return_day2__c- Bollow_Date__c ,0))</description>
|
<externalId>false</externalId>
|
<formula>IF(AND(Not(ISNULL(Shipment_request_command__c)),Not(ISNULL(Bollow_Date__c)),ISNULL(Asset_return_day2__c)), TODAY() - Bollow_Date__c,
|
IF(AND(Not(ISNULL(Shipment_request_command__c)),Not(ISNULL(Bollow_Date__c)),Not(ISNULL( Asset_return_day_F__c)),First_Lost_item_check__c <> '欠品')
|
,Asset_return_day_F__c- Bollow_Date__c ,
|
IF(
|
AND(Not(ISNULL(Shipment_request_command__c)),Not(ISNULL(Bollow_Date__c)),Not(ISNULL(Asset_return_day_F__c)),First_Lost_item_check__c = '欠品', First_RAESD__r.Lost_item_giveup__c = FALSE)
|
, TODAY()- Bollow_Date__c ,
|
IF(
|
AND(Not(ISNULL(Shipment_request_command__c)),Not(ISNULL(Bollow_Date__c)),Not(ISNULL(Asset_return_day_F__c)),First_Lost_item_check__c = '欠品', First_RAESD__r.Lost_item_giveup__c = TRUE)
|
, First_RAESD__r.Lost_item_check_day_F__c - Bollow_Date__c ,0
|
)
|
|
))
|
)</formula>
|
<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>BuchangApprovalManagerSales__c</fullName>
|
<deleteConstraint>SetNull</deleteConstraint>
|
<externalId>false</externalId>
|
<label>****部长(销售)</label>
|
<referenceTo>User</referenceTo>
|
<relationshipName>Buchang3dqh</relationshipName>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Lookup</type>
|
</fields>
|
<fields>
|
<fullName>BuchangApprovalManager__c</fullName>
|
<deleteConstraint>SetNull</deleteConstraint>
|
<externalId>false</externalId>
|
<label>****部长(服务)</label>
|
<referenceTo>User</referenceTo>
|
<relationshipName>Buchang2dqh</relationshipName>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Lookup</type>
|
</fields>
|
<fields>
|
<fullName>CDS_complete_time_sum__c</fullName>
|
<externalId>false</externalId>
|
<label>CDS完毕时间</label>
|
<summarizedField>Rental_Apply_Equipment_Set_Detail__c.CDS_complete_time__c</summarizedField>
|
<summaryFilterItems>
|
<field>Rental_Apply_Equipment_Set_Detail__c.CDS_complete_time__c</field>
|
<operation>notEqual</operation>
|
<value></value>
|
</summaryFilterItems>
|
<summaryFilterItems>
|
<field>Rental_Apply_Equipment_Set_Detail__c.Cancel_Select__c</field>
|
<operation>equals</operation>
|
<value>False</value>
|
</summaryFilterItems>
|
<summaryForeignKey>Rental_Apply_Equipment_Set_Detail__c.Rental_Apply_Equipment_Set__c</summaryForeignKey>
|
<summaryOperation>min</summaryOperation>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Summary</type>
|
</fields>
|
<fields>
|
<fullName>CDS_completed_day_sum__c</fullName>
|
<externalId>false</externalId>
|
<formula>DATEVALUE( CDS_complete_time_sum__c )</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>CDS完毕日</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Date</type>
|
</fields>
|
<fields>
|
<fullName>Cancel_Date__c</fullName>
|
<description>备品分配取消日期
|
RentalApplyEquipmentSetHandler.beforeSetValue() 里设定</description>
|
<externalId>false</externalId>
|
<label>取消日</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Date</type>
|
</fields>
|
<fields>
|
<fullName>Cancel_Mem_Name__c</fullName>
|
<description>Cancel_Mem__r.Name__c</description>
|
<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>Cancel_Mem__c</fullName>
|
<deleteConstraint>SetNull</deleteConstraint>
|
<description>取消分配的人员</description>
|
<externalId>false</externalId>
|
<label>取消者_Lookup</label>
|
<referenceTo>User</referenceTo>
|
<relationshipName>RAES_Cancel_Man</relationshipName>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Lookup</type>
|
</fields>
|
<fields>
|
<fullName>Cancel_Reason_And_Mem_And_Date__c</fullName>
|
<externalId>false</externalId>
|
<formula>Text(Cancel_Date__c) & IF(!isnull(Cancel_Date__c),'-','')& Cancel_Mem_Name__c& IF(!isnull(Cancel_Date__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>Cancel_Reason__c</fullName>
|
<description>只有正常取消(不是系统取消,用户手动操作)的时候才会有值</description>
|
<externalId>false</externalId>
|
<label>取消理由</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Picklist</type>
|
<valueSet>
|
<valueSetDefinition>
|
<sorted>false</sorted>
|
<value>
|
<fullName>主动取消</fullName>
|
<default>false</default>
|
<label>主动取消</label>
|
</value>
|
<value>
|
<fullName>被动取消</fullName>
|
<default>false</default>
|
<label>被动取消</label>
|
</value>
|
</valueSetDefinition>
|
</valueSet>
|
</fields>
|
<fields>
|
<fullName>Cancel_Select__c</fullName>
|
<defaultValue>false</defaultValue>
|
<description>在 RentalFixtureSetSelect 备品配套选择里 取消申请配套
|
正常取消和系统取消时都会打勾
|
例如申请者收货NG后一览重新分配就是系统取消</description>
|
<externalId>false</externalId>
|
<label>取消分配(Sys)</label>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Checkbox</type>
|
</fields>
|
<fields>
|
<fullName>Cancel_Time_F__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(ISBLANK(Cancel_Date__c), null
|
, DATETIMEVALUE(TEXT(Cancel_Date__c) + IF(ISBLANK(Cancel_Time__c)
|
, " 00:00:00", " " + LEFT(Text(Cancel_Time__c), 8)/* DATETIMEVALUE()函数不包含毫秒。 */
|
)
|
) + (-8/24)
|
)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>取消时间F</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>DateTime</type>
|
</fields>
|
<fields>
|
<fullName>Cancel_Time__c</fullName>
|
<externalId>false</externalId>
|
<label>取消时间</label>
|
<required>false</required>
|
<trackHistory>true</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Time</type>
|
</fields>
|
<fields>
|
<fullName>Canceled_Id__c</fullName>
|
<externalId>false</externalId>
|
<label>Canceled_Id (Text)</label>
|
<length>18</length>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Canceled__c</fullName>
|
<deleteConstraint>SetNull</deleteConstraint>
|
<description>一览ACancel后拷贝了一览B
|
一览B的这个字段是参照的一览A</description>
|
<externalId>false</externalId>
|
<label>Canceled</label>
|
<referenceTo>Rental_Apply_Equipment_Set__c</referenceTo>
|
<relationshipLabel>借出备品配套一览 (Copyed)</relationshipLabel>
|
<relationshipName>Copyed_Rental_Apply_Equipment_Set</relationshipName>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Lookup</type>
|
</fields>
|
<fields>
|
<fullName>CreatedDate__c</fullName>
|
<externalId>false</externalId>
|
<formula>DATEVALUE(CreatedDate)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>创建日期</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Date</type>
|
</fields>
|
<fields>
|
<fullName>DataMigration_Flag__c</fullName>
|
<defaultValue>false</defaultValue>
|
<description>validation check 等，看这个Flag，不报错</description>
|
<externalId>false</externalId>
|
<label>DataMigration_Flag</label>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Checkbox</type>
|
</fields>
|
<fields>
|
<fullName>Demo_purpose1__c</fullName>
|
<externalId>false</externalId>
|
<formula>Text(Rental_Apply__r.Demo_purpose1__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>Demo_purpose1_report__c</fullName>
|
<description>备品中心分析报表使用</description>
|
<externalId>false</externalId>
|
<formula>CASE(Demo_purpose1__c,
|
'产品试用','产品试用',
|
'维修代用','维修代用',
|
'协议借用','协议借用',
|
'其他','其他',
|
'')</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>使用目的1forReport</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Demo_purpose2_T__c</fullName>
|
<externalId>false</externalId>
|
<label>Demo_purpose2_Text</label>
|
<length>255</length>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Demo_purpose2__c</fullName>
|
<externalId>false</externalId>
|
<formula>Text( Rental_Apply__r.demo_purpose2__c )</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>使用目的2</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Demo_purpose2_report__c</fullName>
|
<description>For report</description>
|
<externalId>false</externalId>
|
<formula>CASE(Demo_purpose2__c,
|
'试用（无询价）','试用（无询价）',
|
'试用（有询价）','试用（有询价）',
|
'已购待货','已购待货',
|
'学会展会','学会展会',
|
'新产品评价','新产品评价',
|
'一般用户','一般用户',
|
'再修理','再修理',
|
'保修用户','保修用户',
|
'索赔QIS','索赔QIS',
|
'临床研究','临床研究',
|
'市场多年保修','市场多年保修',
|
'故障排查','故障排查',
|
'')</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>使用目的2forReport</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>ES_Stock_Status__c</fullName>
|
<description>/* modify by sunlei 20160714 增加根据根据备品set状态确定能否出库的判断 */
|
IF(!isnull(Shippment_loaner_time__c),'已出库',IF(Rental_Start_Date__c - TODAY() <= VALUE($Label.EquipmentRental_advance_days) && TODAY() <= Rental_End_Date__c &&
|
(RAES_Status__c = '出库前已检测' || RAES_Status__c = '已下架' ||
|
RAES_Status__c = '已出库指示' || BEGINS(RAES_Status__c, '引当')), '可以出库', '不能出库'))
|
|
/* 如果 备品中心出库时间 有内容已出库 备品预计出货日 - today <= 7 and today <= 备品预计回收日 可以出库 否则不能出库 */</description>
|
<externalId>false</externalId>
|
<formula>IF(!isnull(Shippment_loaner_time__c),'已出库',
|
IF(Rental_Start_Date__c - TODAY() <= VALUE($Label.EquipmentRental_advance_days)
|
&& TODAY() <= Rental_End_Date__c
|
&& (cnt_need_repair_before__c + cnt_need_abandon_before__c = 0 && !isnull(Pre_inspection_time__c) ||
|
isnull(Pre_inspection_time__c) && !isnull(StockDown_time__c) ||
|
isnull(StockDown_time__c) && !isnull(Shipment_request_time__c) ||
|
isnull(Shipment_request_time__c)
|
)
|
&& !Cancel_Select__c,
|
'可以出库',
|
'不能出库'
|
)
|
)
|
/* RAES_Status__c公式重复使用，导致公式超过5000，所以将其中逻辑抽出 */</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>****能否出库</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Equipment_Set_Borrowed__c</fullName>
|
<externalId>false</externalId>
|
<label>备品set(借出时)</label>
|
<length>255</length>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Equipment_Set__c</fullName>
|
<deleteConstraint>SetNull</deleteConstraint>
|
<externalId>false</externalId>
|
<label>备品Set</label>
|
<referenceTo>Equipment_Set__c</referenceTo>
|
<relationshipName>Rental_Apply_Equipment_Set</relationshipName>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Lookup</type>
|
</fields>
|
<fields>
|
<fullName>Equipment_Type__c</fullName>
|
<externalId>false</externalId>
|
<formula>First_RAESD__r.Equipment_Type__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>Exceed_Day_Category__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(ISBLANK(Asset_return_day2__c),'',IF(Asset_return_day2__c-Final_reply_day_text__c<=0,"0天",IF(Asset_return_day2__c -Final_reply_day_text__c >30,"30天以上","1-30天")))</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>超过天数分类</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Extend_Date_F__c</fullName>
|
<description>IF(Demo_purpose1__c == '维修代用'
|
, IF(NOT(ISBLANK(Rental_Apply__r.NewRepair__c))
|
&& NOT(ISBLANK(Rental_Apply__r.ExtensionApprovalDate__c)),
|
IF(NOT(ISBLANK(Rental_Apply__r.NewRepair_Repair_Shipped_Date__c))
|
, null, Rental_Apply__r.RcUnexpectExpiryDelay__c)
|
, null
|
)
|
, IF((Demo_purpose1__c == '产品试用' || Demo_purpose1__c == '协议借用') && NOT(ISBLANK(Rental_Apply__r.ExtensionApprovalDate__c)), Rental_Apply__r.RcUnexpectExpiryDelay__c
|
, null
|
)
|
)</description>
|
<externalId>false</externalId>
|
<formula>IF(Demo_purpose1__c == '维修代用'
|
, IF(NOT(ISBLANK(Rental_Apply__r.NewRepair__c))
|
&& NOT(ISBLANK(Rental_Apply__r.ExtensionApprovalDate__c)),
|
IF(NOT(ISBLANK(Rental_Apply__r.NewRepair_Repair_Shipped_Date__c))
|
, Rental_Apply__r.NewRepair_Repair_Shipped_Date__c + 14, Rental_Apply__r.RcUnexpectExpiryDelay__c)
|
, null
|
)
|
, IF((Demo_purpose1__c == '产品试用' || Demo_purpose1__c == '协议借用') && NOT(ISBLANK(Rental_Apply__r.ExtensionApprovalDate__c)), Rental_Apply__r.RcUnexpectExpiryDelay__c
|
, null
|
)
|
)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>延期时间F</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Date</type>
|
</fields>
|
<fields>
|
<fullName>Extend_Date__c</fullName>
|
<externalId>false</externalId>
|
<label>延期时间</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Date</type>
|
</fields>
|
<fields>
|
<fullName>Extend_Final_reply_day_F__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF((Demo_purpose2_T__c=='保修用户'||Demo_purpose2_T__c=='市场多年保修'||Demo_purpose2_T__c=='一般用户'||Demo_purpose2_T__c=='再修理')
|
&& NULLVALUE(Request_extend_day__c, DATE(1900,10,10))>NULLVALUE(RC_return_to_office__c, DATE(1900,10,10))+14
|
&& NULLVALUE(Request_extend_day__c, DATE(1900,10,10))>Rental_End_Date__c
|
, NULLVALUE(Request_extend_day__c, DATE(1900,10,10))
|
,null
|
)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>最新预定归还日_延迟_F</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Date</type>
|
</fields>
|
<fields>
|
<fullName>Extend_Final_reply_day_Text__c</fullName>
|
<externalId>false</externalId>
|
<label>最新预定归还日_延迟</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Date</type>
|
</fields>
|
<fields>
|
<fullName>Extend_Status__c</fullName>
|
<externalId>false</externalId>
|
<label>****延期申请状态</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Picklist</type>
|
<valueSet>
|
<valueSetDefinition>
|
<sorted>false</sorted>
|
<value>
|
<fullName>没申请</fullName>
|
<default>true</default>
|
<label>没申请</label>
|
</value>
|
<value>
|
<fullName>申请中</fullName>
|
<default>false</default>
|
<label>申请中</label>
|
</value>
|
<value>
|
<fullName>批准</fullName>
|
<default>false</default>
|
<label>批准</label>
|
</value>
|
<value>
|
<fullName>不批准</fullName>
|
<default>false</default>
|
<label>不批准</label>
|
</value>
|
<value>
|
<fullName>填写完毕</fullName>
|
<default>false</default>
|
<label>填写完毕</label>
|
</value>
|
</valueSetDefinition>
|
</valueSet>
|
</fields>
|
<fields>
|
<fullName>Extend_day__c</fullName>
|
<externalId>false</externalId>
|
<formula>Request_extend_day__c - Final_reply_day__c</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>Extend_request_reason__c</fullName>
|
<externalId>false</externalId>
|
<label>****延期申请理由</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>TextArea</type>
|
</fields>
|
<fields>
|
<fullName>Extend_workday__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>Final_approval_positon__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(Extend_workday__c <= 7,
|
CASE(Demo_purpose2__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>Final_reply_day_Changed__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(Nullvalue(Final_reply_day__c, Date(1900,1,1)) <> Nullvalue(Final_reply_day_text__c, Date(1900,1,1)), '1', '0')</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>最终借出备品回收期限（是否变化）</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Final_reply_day__c</fullName>
|
<description>IF( text(Extend_Status__c)="批准", Request_extend_day__c,
|
CASE(Demo_purpose2__c,
|
"QIS",
|
IF(ISBLANK(QIS_resolved_date__c),Rental_Apply__r.Asset_loaner_closed_day__c,QIS_resolved_date__c + 5),
|
"已购待货",
|
IF(ISBLANK(Shipping_Finished_Day_Func__c),Rental_Apply__r.Asset_loaner_closed_day__c,Shipping_Finished_Day_Func__c + 12),
|
"一般维修代用",RC_return_to_office__c + 5,
|
"提前借出修理代用",RC_return_to_office__c + 5,
|
"特殊产品修理代用",RC_return_to_office__c + 5,
|
"保修合同用户维修代用",RC_return_to_office__c + 5,Rental_End_Date__c)
|
)</description>
|
<externalId>false</externalId>
|
<formula>/* IF 收货NG && 一周之内没有回寄 -- OCSM_BP3-11 */
|
IF(NOT(ISBLANK(Extend_Date__c)), Extend_Date__c,
|
IF(TEXT(Received_Confirm__c) = 'NG'
|
&& (
|
(Not(ISNULL(Asset_return_day2__c)) && DATEVALUE(Loaner_received_time__c + 7) < Asset_return_day2__c)
|
|| (ISNULL(Asset_return_day2__c) && Loaner_received_time__c + 7 < now())
|
)
|
&& Rental_Apply__r.DataMigration_Flag__c = FALSE,
|
Min_Final_reply_day_Text__c,
|
/* ELSE Not(收货NG) */
|
IF(Demo_purpose2_T__c=="已购待货"&&Not(isblank(Rental_Apply__r.Follow_UP_Opp__r.Shipping_Finished_Day_Func__c)),
|
Min_Final_reply_day_Text__c,
|
IF(Demo_purpose2_T__c=="索赔QIS"&&Not(isblank(QIS_Final_reply_day_Text__c)),
|
QIS_Final_reply_day_Text__c,
|
IF(Demo_purpose2_T__c=='保修用户'||Demo_purpose2_T__c=='市场多年保修'||Demo_purpose2_T__c=='一般用户'||Demo_purpose2_T__c=='再修理'||Demo_purpose2_T__c=='故障排查',
|
IF(Not(isblank(Guzhangpaicha_Final_reply_day_Text__c)), Min_Final_reply_day_Text__c,
|
IF(Repair_Status_Text__c =='0.删除',Min_Final_reply_day_Text__c,
|
IF(Repair_Status_Text__c =='0.取消',Min_Final_reply_day_Text__c,
|
/* OLY_OCM-636 Start 添加或者条件, 因为返送预计归还日的条件变了,全加过来会超5000 */
|
IF((Not(isblank(RC_return_to_office__c)) || Not(isblank(Return_to_office_Final_reply_day_Text__c))) && NOT(ISBLANK(Min_Final_reply_day_Text__c)),Min_Final_reply_day_Text__c,
|
/* OLY_OCM-636 End */
|
IF(NULLVALUE(Request_extend_day__c, DATE(1900,10,10))>NULLVALUE(RC_return_to_office__c, DATE(1900,10,10))+14&&NULLVALUE(Request_extend_day__c, DATE(1900,10,10))>Rental_End_Date__c && NOT(ISBLANK(Min_Final_reply_day_Text__c)),
|
/* 有延迟的话 */
|
Min_Final_reply_day_Text__c,
|
/* 没有有延迟的话 */
|
IF((Not(isblank(Rental_Apply__r.Repair__r.Repair_Ordered_Date__c))
|
/* OLY_OCM-645 自然日调整为工作日的确认 Start 一周之内送修 Bollow_Date__c = Shippment_loaner_time2__c */
|
&& (Rental_Apply__r.Repair__r.Repair_Ordered_Date__c <= IF(Rental_Apply__r.Request_demo_day__c < DATEVALUE('2019-07-01'), Bollow_Date__c + 7, Bollow_Date_Add_7_WD__c)))
|
/* OLY_OCM-662 修理受理日为空的情况对应Start */
|
|| (Rental_Apply__r.Request_demo_day__c >= DATEVALUE('2019-07-01')
|
&& isblank(Bollow_Date_Add_7_WD__c)
|
&& NOT(isblank(Bollow_Date__c)))
|
/* 修理受理日为空的话如果没超过出库7内的话做一周内送修处理 */
|
|| isblank(Rental_Apply__r.Repair__r.Repair_Ordered_Date__c) && TODAY() <= IF(Rental_Apply__r.Request_demo_day__c < DATEVALUE('2019-07-01'), Bollow_Date__c + 7, Bollow_Date_Add_7_WD__c)
|
/* OLY_OCM-662 修理受理日为空的情况对应End */
|
/* OLY_OCM-645 End */
|
,NULLVALUE(Add_Day_For_RC__c,Rental_End_Date__c),
|
/* ELSE 一周之内未送修 */
|
IF((Demo_purpose2_T__c=='保修用户'||Demo_purpose2_T__c=='市场多年保修') && Not(ISBLANK(Shippment_loaner_time2__c)) && NOT(ISBLANK(Min_Final_reply_day_Text__c)),
|
/* 保修用户 一周之内未送修 -- OCSM_BP3-11 */
|
/* 备品中心出库时间不为空 -- OLY_OCM-595 */
|
Min_Final_reply_day_Text__c,
|
/* ELSE Not（保修用户）*/
|
NULLVALUE(Add_Day_For_RC__c,Rental_End_Date__c)
|
)
|
)
|
)
|
)
|
)
|
)
|
)
|
,NULLVALUE(Add_Day_For_RC__c,Rental_End_Date__c)
|
)
|
)
|
))
|
)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>最新预定归还日</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Date</type>
|
</fields>
|
<fields>
|
<fullName>Final_reply_day_text__c</fullName>
|
<externalId>false</externalId>
|
<label>最终借出备品回收期限(文本)</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Date</type>
|
</fields>
|
<fields>
|
<fullName>Final_reply_day_text_for_sum__c</fullName>
|
<description>借出备品回收期限を親の積上げで使用するためコピーする</description>
|
<externalId>false</externalId>
|
<label>借出备品回收期限(文本)</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Date</type>
|
</fields>
|
<fields>
|
<fullName>First_Lost_item_check__c</fullName>
|
<externalId>false</externalId>
|
<formula>First_RAESD__r.Check_lost_Item_F__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>First_RAESD_Arrival__c</fullName>
|
<externalId>false</externalId>
|
<formula>TEXT(First_RAESD__r.Arrival_wh_Result_Agency__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>First_RAESD_Is_Main__c</fullName>
|
<externalId>false</externalId>
|
<formula>First_RAESD__r.Is_Body__c</formula>
|
<label>第一条明细是否主体</label>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Checkbox</type>
|
</fields>
|
<fields>
|
<fullName>First_RAESD_Model_No_F__c</fullName>
|
<externalId>false</externalId>
|
<formula>First_RAESD__r.Fixture_Model_No_F__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>First_RAESD__c</fullName>
|
<deleteConstraint>SetNull</deleteConstraint>
|
<externalId>false</externalId>
|
<label>第一条备品配套明细</label>
|
<referenceTo>Rental_Apply_Equipment_Set_Detail__c</referenceTo>
|
<relationshipLabel>借出备品配套一览</relationshipLabel>
|
<relationshipName>First_RAES</relationshipName>
|
<required>false</required>
|
<trackHistory>true</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Lookup</type>
|
</fields>
|
<fields>
|
<fullName>First_Status_All__c</fullName>
|
<description>主体的所有状态</description>
|
<externalId>false</externalId>
|
<formula>IF(First_RAESD__r.Is_Body__c,First_RAESD__r.RAESD_Status_Text__c,'')</formula>
|
<label>主体状态_all</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>First_Status__c</fullName>
|
<externalId>false</externalId>
|
<formula>First_RAESD__r.Shipment_Status_Text__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>First_You_Xiao_Ku_Cun__c</fullName>
|
<externalId>false</externalId>
|
<formula>First_RAESD__r.Asset__r.You_Xiao_Ku_Cun__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>第一条主体保有设备有效库存</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>FixtureSetDetailSelect_VF__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(IsBlank(UniqueKey__c)
|
, '选择配套明细'
|
, HYPERLINK('/apex/RentalFixtureSetDetilSelect?sids=' + UniqueKey__c, '选择配套明细', '_blank')
|
)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>选择申请明细</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Fixture_Set_Idx__c</fullName>
|
<externalId>false</externalId>
|
<formula>Fixture_Set__r.Name + ':' + Text(IndexFromUniqueKey__c)</formula>
|
<label>备品配套型号.</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Fixture_Set__c</fullName>
|
<deleteConstraint>Restrict</deleteConstraint>
|
<externalId>false</externalId>
|
<label>备品配套</label>
|
<referenceTo>Fixture_Set__c</referenceTo>
|
<relationshipLabel>借出备品配套一览</relationshipLabel>
|
<relationshipName>Rental_Apply_Equipment_Set</relationshipName>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Lookup</type>
|
</fields>
|
<fields>
|
<fullName>Fixture_Set_answer_day__c</fullName>
|
<externalId>false</externalId>
|
<formula>DATEVALUE(Fixture_Set_answer_time__c)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>备品首次分配日</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Date</type>
|
</fields>
|
<fields>
|
<fullName>Fixture_Set_answer_time__c</fullName>
|
<externalId>false</externalId>
|
<label>备品首次分配时间</label>
|
<summarizedField>Rental_Apply_Equipment_Set_Detail__c.Select_Time__c</summarizedField>
|
<summaryFilterItems>
|
<field>Rental_Apply_Equipment_Set_Detail__c.Cancel_Select__c</field>
|
<operation>notEqual</operation>
|
<value>True</value>
|
</summaryFilterItems>
|
<summaryFilterItems>
|
<field>Rental_Apply_Equipment_Set_Detail__c.AgencyTempCancel__c</field>
|
<operation>notEqual</operation>
|
<value>True</value>
|
</summaryFilterItems>
|
<summaryForeignKey>Rental_Apply_Equipment_Set_Detail__c.Rental_Apply_Equipment_Set__c</summaryForeignKey>
|
<summaryOperation>min</summaryOperation>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Summary</type>
|
</fields>
|
<fields>
|
<fullName>ForBatch_Changed1_F__c</fullName>
|
<externalId>false</externalId>
|
<formula>Text(NG_Final_reply_day_Text__c) != Text(NG_Final_reply_day_F__c)
|
|| Text(Yizhouweixiu_Final_reply_day_Text__c) != Text(Yizhouweixiu_Final_reply_day_F__c)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>ForBatch_Changed1_F</label>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Checkbox</type>
|
</fields>
|
<fields>
|
<fullName>ForBatch_Changed2_F__c</fullName>
|
<externalId>false</externalId>
|
<formula>Text(Repair_cancel_Final_reply_day_Text__c) != Text(Repair_cancel_Final_reply_day_F__c)
|
|| Text(Return_to_office_Final_reply_day_Text__c) != Text(Return_to_office_Final_reply_day_F__c)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>ForBatch_Changed2_F</label>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Checkbox</type>
|
</fields>
|
<fields>
|
<fullName>ForBatch_Changed3_F__c</fullName>
|
<externalId>false</externalId>
|
<formula>Text(QIS_Final_reply_day_Text__c) != Text(QIS_Final_reply_day_F__c)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>ForBatch_Changed3_F</label>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Checkbox</type>
|
</fields>
|
<fields>
|
<fullName>ForBatch_Changed4_F__c</fullName>
|
<externalId>false</externalId>
|
<formula>Text(Repair_delete_Final_reply_day_Text__c) != Text(Repair_delete_Final_reply_day_F__c)
|
|| Text(Yigoudaihuo_Final_reply_day_Text__c) != Text(Yigoudaihuo_Final_reply_day_F__c)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>ForBatch_Changed4_F</label>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Checkbox</type>
|
</fields>
|
<fields>
|
<fullName>ForBatch_Changed5_F__c</fullName>
|
<externalId>false</externalId>
|
<formula>Text(Extend_Final_reply_day_Text__c) != Text(Extend_Final_reply_day_F__c)
|
|| Return_to_office_Final_reply_day_U_RC__c != Return_to_office_Final_reply_day_U_RC_F__c
|
|| Demo_purpose2_T__c != Demo_purpose2__c
|
|| Extend_Date_F__c != Extend_Date__c
|
|| Received_NG_ReAssign_Text__c != Received_NG_ReAssign__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>ForBatch_Changed5_F</label>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Checkbox</type>
|
</fields>
|
<fields>
|
<fullName>ForBatch_Changed_F__c</fullName>
|
<externalId>false</externalId>
|
<formula>(Received_Confirm_NG_Not_Return__c <> Received_Confirm_NG_Not_Return_Text__c ) /* 现场收货NG未寄回不看Cancel */
|
|| (Received_Confirm_Status_F__c <> Received_Confirm_Status_Text__c
|
/* OLY_OCM-510 Start */
|
&& Cancel_Select__c = False
|
/* OLY_OCM-510 End */
|
)
|
/* OLY_OCM-636 Start */
|
|| Repair_Agreed_Quotation_F__c <> Repair_Agreed_Quotation_Text__c
|
/* OLY_OCM-636 End */</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>ForBatch_Changed_F</label>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Checkbox</type>
|
</fields>
|
<fields>
|
<fullName>Fu_Shu_Pin_Fen_Pei_Jia__c</fullName>
|
<externalId>false</externalId>
|
<label>附属品分配(Sys)</label>
|
<length>255</length>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Groupby_SortInt__c</fullName>
|
<externalId>false</externalId>
|
<label>Groupby_SortInt</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>Guzhangpaicha_Final_reply_day_F__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(Demo_purpose2_T__c == '故障排查',
|
/*RC受理日为空或超过出库后10天*/
|
IF(ISBLANK(Rental_Apply__r.RC_Ordered_Date__c)|| Rental_Apply__r.RC_Ordered_Date__c > Bollow_Date_Add_10_WD__c,
|
IF(ISBLANK(Rental_Apply__r.RC_Ordered_Date__c) && TODAY() <= Bollow_Date_Add_10_WD__c,
|
Rental_End_Date__c,
|
Bollow_Date_Add_10_WD__c),
|
/* 在21天内同意维修报价 */
|
IF(ISBLANK(Rental_Apply__r.Repair__r.Agreed_Date__c),
|
IF(TODAY() <= Rental_Apply__r.Repair__r.Repair_Quotation_date__c + 21,
|
Rental_End_Date__c, Rental_Apply__r.Repair__r.Repair_Quotation_date__c + 24
|
),
|
IF(Rental_Apply__r.Repair__r.Agreed_Date__c <= Rental_Apply__r.Repair__r.Repair_Quotation_date__c + 21,
|
Rental_Apply__r.Repair__r.Repair_Shipped_Date__c + 14, Rental_Apply__r.Repair__r.Repair_Quotation_date__c + 24
|
)
|
)
|
)
|
,null)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>最新预定归还日_故障排查_F</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Date</type>
|
</fields>
|
<fields>
|
<fullName>Guzhangpaicha_Final_reply_day_Text__c</fullName>
|
<externalId>false</externalId>
|
<label>最新预定归还日_故障排查</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Date</type>
|
</fields>
|
<fields>
|
<fullName>HP_loan_day__c</fullName>
|
<externalId>false</externalId>
|
<formula>Asset_return_day2__c - received_sign_day__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>医院借用天数</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>HopeDay_Sat__c</fullName>
|
<description>Use for report</description>
|
<externalId>false</externalId>
|
<formula>if(isnull(Bollow_Date__c),0,IF(Rental_Apply__r.Request_shipping_day__c > Bollow_Date__c,1,0))</formula>
|
<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>IndexFromUniqueKey__c</fullName>
|
<externalId>false</externalId>
|
<label>IndexFromUniqueKey</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>Inspection_after_ng__c</fullName>
|
<externalId>false</externalId>
|
<label>****回收后检查NG判断</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Picklist</type>
|
<valueSet>
|
<valueSetDefinition>
|
<sorted>false</sorted>
|
<value>
|
<fullName>维修</fullName>
|
<default>false</default>
|
<label>维修</label>
|
</value>
|
<value>
|
<fullName>废弃</fullName>
|
<default>false</default>
|
<label>废弃</label>
|
</value>
|
</valueSetDefinition>
|
</valueSet>
|
</fields>
|
<fields>
|
<fullName>Inspection_after_ng_cnt__c</fullName>
|
<externalId>false</externalId>
|
<label>回收后检测NG</label>
|
<summaryFilterItems>
|
<field>Rental_Apply_Equipment_Set_Detail__c.Cancel_Select__c</field>
|
<operation>equals</operation>
|
<value>False</value>
|
</summaryFilterItems>
|
<summaryFilterItems>
|
<field>Rental_Apply_Equipment_Set_Detail__c.Inspection_result_after_F__c</field>
|
<operation>equals</operation>
|
<value>NG</value>
|
</summaryFilterItems>
|
<summaryFilterItems>
|
<field>Rental_Apply_Equipment_Set_Detail__c.Detail_Finish__c</field>
|
<operation>equals</operation>
|
<value>False</value>
|
</summaryFilterItems>
|
<summaryForeignKey>Rental_Apply_Equipment_Set_Detail__c.Rental_Apply_Equipment_Set__c</summaryForeignKey>
|
<summaryOperation>count</summaryOperation>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Summary</type>
|
</fields>
|
<fields>
|
<fullName>Inspection_before_ng__c</fullName>
|
<description>//bp2 货前检测NG通知 用
|
需要在 @future 里清空</description>
|
<externalId>false</externalId>
|
<label>发货前检查NG判断</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Picklist</type>
|
<valueSet>
|
<valueSetDefinition>
|
<sorted>false</sorted>
|
<value>
|
<fullName>维修</fullName>
|
<default>false</default>
|
<label>维修</label>
|
</value>
|
<value>
|
<fullName>废弃</fullName>
|
<default>false</default>
|
<label>废弃</label>
|
</value>
|
</valueSetDefinition>
|
</valueSet>
|
</fields>
|
<fields>
|
<fullName>Inspection_not_finish__c</fullName>
|
<externalId>false</externalId>
|
<label>发货前检测未完了数</label>
|
<summaryFilterItems>
|
<field>Rental_Apply_Equipment_Set_Detail__c.Inspection_result__c</field>
|
<operation>equals</operation>
|
<value></value>
|
</summaryFilterItems>
|
<summaryFilterItems>
|
<field>Rental_Apply_Equipment_Set_Detail__c.Cancel_Select__c</field>
|
<operation>equals</operation>
|
<value>False</value>
|
</summaryFilterItems>
|
<summaryForeignKey>Rental_Apply_Equipment_Set_Detail__c.Rental_Apply_Equipment_Set__c</summaryForeignKey>
|
<summaryOperation>count</summaryOperation>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Summary</type>
|
</fields>
|
<fields>
|
<fullName>Inspection_result_after_OK__c</fullName>
|
<externalId>false</externalId>
|
<inlineHelpText>排队参考信息</inlineHelpText>
|
<label>排队备品检测OK时间</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Date</type>
|
</fields>
|
<fields>
|
<fullName>Internal_asset_location__c</fullName>
|
<externalId>false</externalId>
|
<formula>null</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>备品存放地</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Irreplaceable_flag__c</fullName>
|
<defaultValue>false</defaultValue>
|
<externalId>false</externalId>
|
<label>代替品不可</label>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Checkbox</type>
|
</fields>
|
<fields>
|
<fullName>IsAgree21__c</fullName>
|
<externalId>false</externalId>
|
<formula>if(Rental_Apply__r.Repair__r.Agreed_Date__c <= Rental_Apply__r.Repair__r.Repair_Quotation_date__c + 21,true,false)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>是否21天内同意维修报价(报表使用)</label>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Checkbox</type>
|
</fields>
|
<fields>
|
<fullName>IsBackNGWeekOK__c</fullName>
|
<externalId>false</externalId>
|
<formula>if((text(Received_Confirm__c )== 'NG'&& (DATEVALUE(Asset_return_time__c)<DATEVALUE(Loaner_received_time__c+7))) || (Received_Confirm_Text__c == 'OK' || Received_Confirm_Text__c == '默认签收-OK' ), true,false)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>到货NG一周之内是否寄回/到货OK(报表使用）</label>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Checkbox</type>
|
</fields>
|
<fields>
|
<fullName>IsCreate10_RC__c</fullName>
|
<externalId>false</externalId>
|
<formula>if(ISBLANK(Rental_Apply__r.RC_Ordered_Date__c)|| Rental_Apply__r.RC_Ordered_Date__c > Bollow_Date_Add_10_WD__c,false,true)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>出库之后10个工作日是否生成RC受理日(报表使用)</label>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Checkbox</type>
|
</fields>
|
<fields>
|
<fullName>IsOPD_Account__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>Is_All_Postpone__c</fullName>
|
<defaultValue>false</defaultValue>
|
<description>如果批量延期，那么在提交批量延期审批时，会把此字段赋值为true</description>
|
<externalId>false</externalId>
|
<label>是否批量延期</label>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Checkbox</type>
|
</fields>
|
<fields>
|
<fullName>Is_Final_reply_day_today__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(TODAY()>= Final_reply_day__c,true,false)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>是否今日之前最新预定归还日(报表使用)</label>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Checkbox</type>
|
</fields>
|
<fields>
|
<fullName>Jie_Chu_Shi_Jian_Jia__c</fullName>
|
<externalId>false</externalId>
|
<label>借出时间 (天)(Sys)</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>JingliApprovalManager__c</fullName>
|
<deleteConstraint>SetNull</deleteConstraint>
|
<externalId>false</externalId>
|
<label>****经理(服务)</label>
|
<referenceTo>User</referenceTo>
|
<relationshipName>Jingli2dqX</relationshipName>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Lookup</type>
|
</fields>
|
<fields>
|
<fullName>Ke_Yi_Fen_Pei_Zhu_Ti_Jia__c</fullName>
|
<externalId>false</externalId>
|
<label>可以分配主体(Sys)</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>KeyCode__c</fullName>
|
<externalId>false</externalId>
|
<label>备品信息转移KeyCode</label>
|
<length>100</length>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Last_Assigned_Time__c</fullName>
|
<externalId>false</externalId>
|
<label>最后分配时间</label>
|
<summarizedField>Rental_Apply_Equipment_Set_Detail__c.Select_Time__c</summarizedField>
|
<summaryFilterItems>
|
<field>Rental_Apply_Equipment_Set_Detail__c.Cancel_Select__c</field>
|
<operation>equals</operation>
|
<value>False</value>
|
</summaryFilterItems>
|
<summaryFilterItems>
|
<field>Rental_Apply_Equipment_Set_Detail__c.AgencyTempCancel__c</field>
|
<operation>equals</operation>
|
<value>False</value>
|
</summaryFilterItems>
|
<summaryForeignKey>Rental_Apply_Equipment_Set_Detail__c.Rental_Apply_Equipment_Set__c</summaryForeignKey>
|
<summaryOperation>max</summaryOperation>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Summary</type>
|
</fields>
|
<fields>
|
<fullName>LendNum__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>Loaner_Borrow_cnt__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(AND(Not(ISNULL(Shipment_request_command__c)),Not(ISNULL(Bollow_Date__c)),ISNULL(Asset_return_day2__c)),1,0)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>出借中件数</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>Loaner_Set_No__c</fullName>
|
<externalId>false</externalId>
|
<formula>First_RAESD__r.Loaner_asset_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>Loaner_cancel_Remarks__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>Loaner_cancel_reason__c</fullName>
|
<externalId>false</externalId>
|
<label>一览取消理由</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Picklist</type>
|
<valueSet>
|
<controllingField>Cancel_Reason__c</controllingField>
|
<valueSetDefinition>
|
<sorted>false</sorted>
|
<value>
|
<fullName>计划调整变更</fullName>
|
<default>false</default>
|
<label>计划调整变更</label>
|
</value>
|
<value>
|
<fullName>重复申请</fullName>
|
<default>false</default>
|
<label>重复申请</label>
|
</value>
|
<value>
|
<fullName>信息填写错误</fullName>
|
<default>false</default>
|
<label>信息填写错误</label>
|
</value>
|
<value>
|
<fullName>医院取消试用</fullName>
|
<default>false</default>
|
<label>医院取消试用</label>
|
</value>
|
<value>
|
<fullName>不合理申请</fullName>
|
<default>false</default>
|
<label>不合理申请</label>
|
</value>
|
<value>
|
<fullName>小修理不对应</fullName>
|
<default>false</default>
|
<label>小修理不对应</label>
|
</value>
|
<value>
|
<fullName>未受理修理品已返回</fullName>
|
<default>false</default>
|
<label>未受理修理品已返回</label>
|
</value>
|
<value>
|
<fullName>担当离职</fullName>
|
<default>false</default>
|
<label>担当离职</label>
|
</value>
|
<value>
|
<fullName>库存不足</fullName>
|
<default>false</default>
|
<label>库存不足</label>
|
</value>
|
<value>
|
<fullName>修理品已返回</fullName>
|
<default>false</default>
|
<label>修理品已返回</label>
|
</value>
|
<value>
|
<fullName>无保有</fullName>
|
<default>false</default>
|
<label>无保有</label>
|
</value>
|
<value>
|
<fullName>其他</fullName>
|
<default>false</default>
|
<label>其他</label>
|
</value>
|
<value>
|
<fullName>备品申请无效</fullName>
|
<default>false</default>
|
<label>备品申请无效</label>
|
</value>
|
<value>
|
<fullName>学会取消</fullName>
|
<default>false</default>
|
<label>学会取消</label>
|
</value>
|
<value>
|
<fullName>申请单合并</fullName>
|
<default>false</default>
|
<label>申请单合并</label>
|
</value>
|
</valueSetDefinition>
|
<valueSettings>
|
<controllingFieldValue>被动取消</controllingFieldValue>
|
<valueName>库存不足</valueName>
|
</valueSettings>
|
<valueSettings>
|
<controllingFieldValue>被动取消</controllingFieldValue>
|
<valueName>修理品已返回</valueName>
|
</valueSettings>
|
<valueSettings>
|
<controllingFieldValue>被动取消</controllingFieldValue>
|
<valueName>无保有</valueName>
|
</valueSettings>
|
<valueSettings>
|
<controllingFieldValue>被动取消</controllingFieldValue>
|
<valueName>其他</valueName>
|
</valueSettings>
|
<valueSettings>
|
<controllingFieldValue>主动取消</controllingFieldValue>
|
<valueName>计划调整变更</valueName>
|
</valueSettings>
|
<valueSettings>
|
<controllingFieldValue>主动取消</controllingFieldValue>
|
<valueName>重复申请</valueName>
|
</valueSettings>
|
<valueSettings>
|
<controllingFieldValue>主动取消</controllingFieldValue>
|
<valueName>信息填写错误</valueName>
|
</valueSettings>
|
<valueSettings>
|
<controllingFieldValue>主动取消</controllingFieldValue>
|
<valueName>医院取消试用</valueName>
|
</valueSettings>
|
<valueSettings>
|
<controllingFieldValue>主动取消</controllingFieldValue>
|
<valueName>不合理申请</valueName>
|
</valueSettings>
|
<valueSettings>
|
<controllingFieldValue>主动取消</controllingFieldValue>
|
<valueName>小修理不对应</valueName>
|
</valueSettings>
|
<valueSettings>
|
<controllingFieldValue>主动取消</controllingFieldValue>
|
<valueName>未受理修理品已返回</valueName>
|
</valueSettings>
|
<valueSettings>
|
<controllingFieldValue>主动取消</controllingFieldValue>
|
<valueName>担当离职</valueName>
|
</valueSettings>
|
</valueSet>
|
</fields>
|
<fields>
|
<fullName>Loaner_categoryII_F__c</fullName>
|
<externalId>false</externalId>
|
<formula>TEXT(Fixture_Set__r.Loaner_categoryII__c)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>备品类型II</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Loaner_categoryI_F__c</fullName>
|
<externalId>false</externalId>
|
<formula>TEXT(Fixture_Set__r.Loaner_categoryI__c)</formula>
|
<label>备品类型I</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Loaner_centre_mail_address_F__c</fullName>
|
<externalId>false</externalId>
|
<formula>Rental_Apply__r.Loaner_centre_mail_address__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>备品中心的邮箱地址F</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Loaner_centre_mail_address__c</fullName>
|
<description>before trigger にて、親の备品中心的邮箱地址をコピーする。</description>
|
<externalId>false</externalId>
|
<label>备品中心的邮箱地址</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Email</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Loaner_code_F__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(ISBLANK(Loaner_code_text__c), Loaner_code__c, Loaner_code_text__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>Loaner_code__c</fullName>
|
<externalId>false</externalId>
|
<formula>Fixture_Set__r.Loaner_code__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>Loaner_code_text__c</fullName>
|
<externalId>false</externalId>
|
<label>备品配套型号(借出时)</label>
|
<length>200</length>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Loaner_name_F__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(ISBLANK( Loaner_name_text__c ), Loaner_name__c , Loaner_name_text__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>Loaner_name__c</fullName>
|
<externalId>false</externalId>
|
<formula>Fixture_Set__r.Loaner_name__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>Loaner_name_text__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>Loaner_received_day2__c</fullName>
|
<externalId>false</externalId>
|
<formula>DATEVALUE(Loaner_received_time__c)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>现场签收日</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Date</type>
|
</fields>
|
<fields>
|
<fullName>Loaner_received_time__c</fullName>
|
<externalId>false</externalId>
|
<label>现场签收时间</label>
|
<required>false</required>
|
<trackHistory>true</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>DateTime</type>
|
</fields>
|
<fields>
|
<fullName>Lost_item_check_OK__c</fullName>
|
<externalId>false</externalId>
|
<inlineHelpText>排队参考信息</inlineHelpText>
|
<label>排队备品欠品OK时间</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Date</type>
|
</fields>
|
<fields>
|
<fullName>Lost_item_check_not_finish__c</fullName>
|
<externalId>false</externalId>
|
<label>欠品确认未完了数</label>
|
<summaryFilterItems>
|
<field>Rental_Apply_Equipment_Set_Detail__c.Check_lost_Item_F__c</field>
|
<operation>equals</operation>
|
<value></value>
|
</summaryFilterItems>
|
<summaryFilterItems>
|
<field>Rental_Apply_Equipment_Set_Detail__c.Cancel_Select__c</field>
|
<operation>equals</operation>
|
<value>False</value>
|
</summaryFilterItems>
|
<summaryForeignKey>Rental_Apply_Equipment_Set_Detail__c.Rental_Apply_Equipment_Set__c</summaryForeignKey>
|
<summaryOperation>count</summaryOperation>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Summary</type>
|
</fields>
|
<fields>
|
<fullName>Lost_item_check_time__c</fullName>
|
<externalId>false</externalId>
|
<label>欠品确认时间</label>
|
<summarizedField>Rental_Apply_Equipment_Set_Detail__c.Lost_item_check_time_F__c</summarizedField>
|
<summaryFilterItems>
|
<field>Rental_Apply_Equipment_Set_Detail__c.Lost_item_check_time_F__c</field>
|
<operation>notEqual</operation>
|
<value></value>
|
</summaryFilterItems>
|
<summaryFilterItems>
|
<field>Rental_Apply_Equipment_Set_Detail__c.Cancel_Select__c</field>
|
<operation>equals</operation>
|
<value>False</value>
|
</summaryFilterItems>
|
<summaryForeignKey>Rental_Apply_Equipment_Set_Detail__c.Rental_Apply_Equipment_Set__c</summaryForeignKey>
|
<summaryOperation>min</summaryOperation>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Summary</type>
|
</fields>
|
<fields>
|
<fullName>Lost_item_giveup__c</fullName>
|
<externalId>false</externalId>
|
<formula>First_RAESD__r.Lost_item_giveup__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>第一条明细是否放弃欠品回收</label>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Checkbox</type>
|
</fields>
|
<fields>
|
<fullName>Lost_product_cnt__c</fullName>
|
<externalId>false</externalId>
|
<label>欠品确认数</label>
|
<summaryFilterItems>
|
<field>Rental_Apply_Equipment_Set_Detail__c.Check_lost_Item_F__c</field>
|
<operation>equals</operation>
|
<value>欠品</value>
|
</summaryFilterItems>
|
<summaryFilterItems>
|
<field>Rental_Apply_Equipment_Set_Detail__c.Cancel_Select__c</field>
|
<operation>equals</operation>
|
<value>False</value>
|
</summaryFilterItems>
|
<summaryFilterItems>
|
<field>Rental_Apply_Equipment_Set_Detail__c.Detail_Finish__c</field>
|
<operation>equals</operation>
|
<value>False</value>
|
</summaryFilterItems>
|
<summaryForeignKey>Rental_Apply_Equipment_Set_Detail__c.Rental_Apply_Equipment_Set__c</summaryForeignKey>
|
<summaryOperation>count</summaryOperation>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Summary</type>
|
</fields>
|
<fields>
|
<fullName>Lost_product_cnt_serial__c</fullName>
|
<externalId>false</externalId>
|
<label>欠品数（主机）</label>
|
<summaryFilterItems>
|
<field>Rental_Apply_Equipment_Set_Detail__c.Loaner_accsessary__c</field>
|
<operation>equals</operation>
|
<value>False</value>
|
</summaryFilterItems>
|
<summaryFilterItems>
|
<field>Rental_Apply_Equipment_Set_Detail__c.Check_lost_Item_F__c</field>
|
<operation>equals</operation>
|
<value>欠品, 消耗</value>
|
</summaryFilterItems>
|
<summaryFilterItems>
|
<field>Rental_Apply_Equipment_Set_Detail__c.Cancel_Select__c</field>
|
<operation>equals</operation>
|
<value>False</value>
|
</summaryFilterItems>
|
<summaryForeignKey>Rental_Apply_Equipment_Set_Detail__c.Rental_Apply_Equipment_Set__c</summaryForeignKey>
|
<summaryOperation>count</summaryOperation>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Summary</type>
|
</fields>
|
<fields>
|
<fullName>Mail_Send_Btn__c</fullName>
|
<externalId>false</externalId>
|
<label>Mail Send Btn</label>
|
<length>1</length>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Manual_Queue__c</fullName>
|
<defaultValue>false</defaultValue>
|
<externalId>false</externalId>
|
<label>手动排队</label>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Checkbox</type>
|
</fields>
|
<fields>
|
<fullName>Min_Final_reply_day_F__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF (
|
(Date(1970, 1, 1) +
|
MIN(
|
BLANKVALUE(NG_Final_reply_day_Text__c, Date(2900, 1, 1)) - Date(1970, 1, 1),
|
BLANKVALUE(Yizhouweixiu_Final_reply_day_Text__c, Date(2900, 1, 1)) - Date(1970, 1, 1),
|
BLANKVALUE(Extend_Final_reply_day_Text__c, Date(2900, 1, 1)) - Date(1970, 1, 1),
|
BLANKVALUE(Repair_cancel_Final_reply_day_Text__c, Date(2900, 1, 1)) - Date(1970, 1, 1),
|
BLANKVALUE(Return_to_office_Final_reply_day_Text__c, Date(2900, 1, 1)) - Date(1970, 1, 1),
|
BLANKVALUE(Repair_delete_Final_reply_day_Text__c, Date(2900, 1, 1)) - Date(1970, 1, 1),
|
BLANKVALUE(Yigoudaihuo_Final_reply_day_Text__c, Date(2900, 1, 1)) - Date(1970, 1, 1),
|
BLANKVALUE(Guzhangpaicha_Final_reply_day_Text__c, Date(2900, 1, 1)) - Date(1970, 1, 1),
|
BLANKVALUE(Rental_Apply__r.NewRepair_Repair_Shipped_Date__c + 14, Date(2900, 1, 1)) - Date(1970, 1, 1)
|
)
|
)
|
!= Date(2900, 1, 1),Date(1970, 1, 1) +
|
MIN(
|
BLANKVALUE(NG_Final_reply_day_Text__c, Date(2900, 1, 1)) - Date(1970, 1, 1),
|
BLANKVALUE(Yizhouweixiu_Final_reply_day_Text__c, Date(2900, 1, 1)) - Date(1970, 1, 1),
|
BLANKVALUE(Extend_Final_reply_day_Text__c, Date(2900, 1, 1)) - Date(1970, 1, 1),
|
BLANKVALUE(Repair_cancel_Final_reply_day_Text__c, Date(2900, 1, 1)) - Date(1970, 1, 1),
|
BLANKVALUE(Return_to_office_Final_reply_day_Text__c, Date(2900, 1, 1)) - Date(1970, 1, 1),
|
BLANKVALUE(Repair_delete_Final_reply_day_Text__c, Date(2900, 1, 1)) - Date(1970, 1, 1),
|
BLANKVALUE(Yigoudaihuo_Final_reply_day_Text__c, Date(2900, 1, 1)) - Date(1970, 1, 1),
|
BLANKVALUE(Guzhangpaicha_Final_reply_day_Text__c, Date(2900, 1, 1)) - Date(1970, 1, 1),
|
BLANKVALUE(Rental_Apply__r.NewRepair_Repair_Shipped_Date__c + 14, Date(2900, 1, 1)) - Date(1970, 1, 1)
|
)
|
, null
|
)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>最新预定归还日_最小_F</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Date</type>
|
</fields>
|
<fields>
|
<fullName>Min_Final_reply_day_Text__c</fullName>
|
<externalId>false</externalId>
|
<label>最新预定归还日_最小</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Date</type>
|
</fields>
|
<fields>
|
<fullName>NG_Final_reply_day_F__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(TEXT(Received_Confirm__c) = 'NG'
|
&& (
|
(Not(ISNULL(Asset_return_day2__c)) && DATEVALUE(Loaner_received_time__c + 7) < Asset_return_day2__c)
|
|| (ISNULL(Asset_return_day2__c) && Loaner_received_time__c + 7 < now())
|
)
|
&& Rental_Apply__r.DataMigration_Flag__c = FALSE, DATEVALUE(Shippment_loaner_time2__c + 14),
|
null
|
)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>最新预定归还日_收货NG_F</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Date</type>
|
</fields>
|
<fields>
|
<fullName>NG_Final_reply_day_Text__c</fullName>
|
<externalId>false</externalId>
|
<label>最新预定归还日_收货NG</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Date</type>
|
</fields>
|
<fields>
|
<fullName>NG_Return_DeliverySlip_Information__c</fullName>
|
<externalId>false</externalId>
|
<label>申请者收货NG回寄单信息</label>
|
<length>65535</length>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Html</type>
|
<visibleLines>25</visibleLines>
|
</fields>
|
<fields>
|
<fullName>NG_Return_DeliverySlip__c</fullName>
|
<deleteConstraint>SetNull</deleteConstraint>
|
<externalId>false</externalId>
|
<label>申请者收货NG回寄单</label>
|
<referenceTo>FixtureDeliverySlip__c</referenceTo>
|
<relationshipLabel>借出备品配套一览</relationshipLabel>
|
<relationshipName>NG_Return_DeliverySlip</relationshipName>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Lookup</type>
|
</fields>
|
<fields>
|
<fullName>NG_Select_Again__c</fullName>
|
<defaultValue>false</defaultValue>
|
<externalId>false</externalId>
|
<label>NG重新分配</label>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Checkbox</type>
|
</fields>
|
<fields>
|
<fullName>New_Loaner_code__c</fullName>
|
<externalId>false</externalId>
|
<formula>New_Rental_Apply_Equipment__r.Loaner_code_text__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>New_Loaner_name__c</fullName>
|
<externalId>false</externalId>
|
<formula>New_Rental_Apply_Equipment__r.Loaner_name_text__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>New_Rental_Apply_Equipment__c</fullName>
|
<deleteConstraint>SetNull</deleteConstraint>
|
<description>该一览clone出的新一览</description>
|
<externalId>false</externalId>
|
<label>新借出备品配套一览</label>
|
<referenceTo>Rental_Apply_Equipment_Set__c</referenceTo>
|
<relationshipLabel>借出备品配套一览 (旧借出备品配套一览)</relationshipLabel>
|
<relationshipName>Old_Rental_Apply_Equipment</relationshipName>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Lookup</type>
|
</fields>
|
<fields>
|
<fullName>New_RetalFSetDetail_Cnt__c</fullName>
|
<externalId>false</externalId>
|
<formula>New_Rental_Apply_Equipment__r.RetalFSetDetail_Cnt__c</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>No_Link__c</fullName>
|
<description>項目セットに表示するためのリンク</description>
|
<externalId>false</externalId>
|
<formula>HYPERLINK("/" & Id, SortInt_F__c + "_" + Fixture_Set_Idx__c, "_top")</formula>
|
<label>No_Link</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Normal_Rental_case_num__c</fullName>
|
<description>For Report</description>
|
<externalId>false</externalId>
|
<formula>if(isnull(Over_Loaner_Status__c),0,IF(Over_Loaner_Status__c='正常出借',1,0))</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>Number_of_loaner_history__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>Old_Fixture_Set__c</fullName>
|
<description>Canceled__r.Fixture_Set__r.Name</description>
|
<externalId>false</externalId>
|
<formula>Canceled__r.Fixture_Set__r.Name</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>原备品配套</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Old_Loaner_code_F__c</fullName>
|
<description>Canceled__r.Loaner_code_F__c</description>
|
<externalId>false</externalId>
|
<formula>Canceled__r.Loaner_code_F__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>Old_Loaner_name_F__c</fullName>
|
<description>Canceled__r.Loaner_name_F__c</description>
|
<externalId>false</externalId>
|
<formula>Canceled__r.Loaner_name_F__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>Old_Rental_Apply_F__c</fullName>
|
<externalId>false</externalId>
|
<formula>Rental_Apply__r.Root_Rental_Apply__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>旧借出申请F</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Old_Rental_Apply__c</fullName>
|
<deleteConstraint>SetNull</deleteConstraint>
|
<description>分割出来的一览的原申请单</description>
|
<externalId>false</externalId>
|
<label>旧借出申请</label>
|
<referenceTo>Rental_Apply__c</referenceTo>
|
<relationshipLabel>借出备品配套一览 (已分单)</relationshipLabel>
|
<relationshipName>Split_Rental_Apply_Equipment_Set</relationshipName>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Lookup</type>
|
</fields>
|
<fields>
|
<fullName>Old_RetalFSetDetail_Cnt__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>Old_Substitute_flag__c</fullName>
|
<externalId>false</externalId>
|
<formula>Canceled__r.Substitute_flag__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>原一览代替品</label>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Checkbox</type>
|
</fields>
|
<fields>
|
<fullName>OtCode__c</fullName>
|
<externalId>false</externalId>
|
<formula>First_RAESD__r.Asset__r.Product2.ProductCode</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>OtCode</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Over_Loaner_Status__c</fullName>
|
<description>//bp2 用確認
|
IF(
|
AND(Final_reply_day_text__c < TODAY(),
|
Not(ISNULL(Shipment_request_day__c)),
|
Not(ISNULL(Bollow_Date__c)),
|
ISNULL(Asset_return_day2__c)
|
),'逾期出借',
|
|
IF(
|
AND(Final_reply_day_text__c >= TODAY(),
|
Not(ISNULL(Shipment_request_day__c)) ,
|
Not(ISNULL(Bollow_Date__c)),
|
ISNULL(Asset_return_day2__c)
|
) ,'正常出借',
|
|
IF(
|
AND(NOT(ISNULL(Shipment_request_day__c)),
|
Not(ISNULL(Bollow_Date__c)),
|
NOT(ISNULL(Asset_return_day2__c)),
|
Final_reply_day_text__c < Asset_return_day2__c
|
), '逾期返回',
|
|
IF(
|
AND(NOT(ISNULL(Shipment_request_day__c)),
|
Not(ISNULL(Bollow_Date__c)),
|
NOT(ISNULL(Asset_return_day2__c)),
|
Final_reply_day_text__c >= Asset_return_day2__c
|
), '正常返回', ''
|
)
|
)
|
)
|
)</description>
|
<externalId>false</externalId>
|
<formula>IF(
|
AND(Final_reply_day_text__c < TODAY(),
|
Not(ISNULL(Shipment_request_command__c)),
|
Not(ISNULL(Bollow_Date__c)),
|
ISNULL(Asset_return_day2__c)
|
),'逾期出借',
|
|
IF(
|
AND(Final_reply_day_text__c >= TODAY(),
|
Not(ISNULL(Shipment_request_command__c)) ,
|
Not(ISNULL(Bollow_Date__c)),
|
ISNULL(Asset_return_day2__c)
|
) ,'正常出借',
|
|
IF(
|
AND(NOT(ISNULL(Shipment_request_command__c)),
|
Not(ISNULL(Bollow_Date__c)),
|
NOT(ISNULL(Asset_return_day2__c)),
|
Final_reply_day_text__c < Asset_return_day2__c
|
), '逾期返回',
|
|
IF(
|
AND(NOT(ISNULL(Shipment_request_command__c)),
|
Not(ISNULL(Bollow_Date__c)),
|
NOT(ISNULL(Asset_return_day2__c)),
|
Final_reply_day_text__c >= Asset_return_day2__c
|
), '正常返回', ''
|
)
|
)
|
)
|
)</formula>
|
<label>****借出状态</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>OverdueBorrowDay__c</fullName>
|
<description>2018/01/31: 报表中使用</description>
|
<externalId>false</externalId>
|
<formula>IF(AND(Final_reply_day_text__c < TODAY(), Not(ISNULL(Shipment_request_command__c)),Not(ISNULL(Bollow_Date__c)),ISNULL(Asset_return_day2__c)), TODAY() - Final_reply_day_text__c,
|
IF(AND(Final_reply_day_text__c < Asset_return_day2__c,Not(ISNULL(Shipment_request_command__c)),Not(ISNULL(Bollow_Date__c)),
|
Not(ISNULL(Asset_return_day2__c)))
|
,Asset_return_day2__c- Final_reply_day_text__c ,0))</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>Pai_Dui_Jia__c</fullName>
|
<externalId>false</externalId>
|
<label>排队(Sys)</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>Past_return_day__c</fullName>
|
<externalId>false</externalId>
|
<formula>BLANKVALUE(Asset_return_day2__c, today()) - Final_reply_day_text__c</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>Past_update_date__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF( Rental_Apply__r.RecordTypeId ="01210000000RHIn","过去转移信息","")</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>是否过去转移信息</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Pre_inspection_time__c</fullName>
|
<externalId>false</externalId>
|
<label>****发货前-检测合格时间</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>DateTime</type>
|
</fields>
|
<fields>
|
<fullName>Product2F__c</fullName>
|
<externalId>false</externalId>
|
<formula>First_RAESD__r.Asset__r.Key_product__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>主体产品F</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Product2__c</fullName>
|
<externalId>false</externalId>
|
<label>主体产品</label>
|
<length>128</length>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Product_category__c</fullName>
|
<externalId>false</externalId>
|
<formula>TEXT(Rental_Apply__r.Product_category__c)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>产品分类(GI/SP)</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>QIS_Final_reply_day_F__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(Demo_purpose2__c=="索赔QIS",
|
IF(Rental_Apply__r.Request_demo_day__c >= DATEVALUE('2019-09-01'),
|
IF((Rental_Apply__r.next_action_Text__c == '有偿维修'
|
|| Rental_Apply__r.next_action_Text__c == '无偿维修'
|
|| Rental_Apply__r.next_action_Text__c == '有偿维修+无偿维修'
|
)
|
&& NOT(ISBLANK(Rental_Apply__r.QIS_Repair_Shipped_Date__c))
|
, IF(NOT(ISBLANK(Rental_Apply__r.NewRepair_Repair_Shipped_Date__c)), Min_Final_reply_day_Text__c, Rental_Apply__r.QIS_Repair_Shipped_Date__c + 14),
|
IF(Rental_Apply__r.next_action_Text__c == '无偿更换'
|
&& NOT(ISBLANK(Rental_Apply__r.QIS_ReplaceDeliveryDate__c)),
|
Rental_Apply__r.QIS_ReplaceDeliveryDate__c + 14,
|
IF(Rental_Apply__r.next_action_Text__c == '送回'
|
&& NOT(ISBLANK(Rental_Apply__r.QIS_Reply_day__c))
|
, Rental_Apply__r.QIS_Reply_day__c + 14,
|
IF(ISBLANK(Rental_Apply__r.next_action_Text__c),
|
IF(NOT(ISBLANK(Rental_Apply__r.QIS_cancel_date__c)),
|
DATEVALUE(Rental_Apply__r.QIS_cancel_date__c) + 7,
|
IF(NOT(ISBLANK(Rental_Apply__r.QIS_Cancel_Submit_day__c)),
|
Rental_Apply__r.QIS_Cancel_Submit_day__c + 7
|
, null
|
)
|
)
|
, null
|
)
|
)
|
)
|
|
),
|
IF (Not(isblank(Rental_Date_byHand__c)), Rental_Date_byHand__c,
|
null
|
)
|
), null
|
)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>最新预定归还日_索赔QIS_F</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Date</type>
|
</fields>
|
<fields>
|
<fullName>QIS_Final_reply_day_Text__c</fullName>
|
<externalId>false</externalId>
|
<label>最新预定归还日_索赔QIS</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Date</type>
|
</fields>
|
<fields>
|
<fullName>QueueDetail__c</fullName>
|
<externalId>false</externalId>
|
<label>排队备品预计明细</label>
|
<length>32</length>
|
<required>false</required>
|
<trackHistory>true</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>QueueShippmentDateNew__c</fullName>
|
<externalId>false</externalId>
|
<formula>NULLVALUE(First_RAESD__r.UQueueShippmentDateText__c,QueueShippmentDate__c)</formula>
|
<inlineHelpText>排队参考信息</inlineHelpText>
|
<label>排队备品预计出库时间</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Date</type>
|
</fields>
|
<fields>
|
<fullName>QueueShippmentDate__c</fullName>
|
<externalId>false</externalId>
|
<label>排队备品预计出库时间Sys</label>
|
<required>false</required>
|
<trackHistory>true</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Date</type>
|
</fields>
|
<fields>
|
<fullName>QueueType__c</fullName>
|
<externalId>false</externalId>
|
<formula>Text(First_RAESD__r.QuenType__c)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>QueueType</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Queue_Count__c</fullName>
|
<externalId>false</externalId>
|
<label>排队数</label>
|
<summaryFilterItems>
|
<field>Rental_Apply_Equipment_Set_Detail__c.Cancel_Select__c</field>
|
<operation>equals</operation>
|
<value>False</value>
|
</summaryFilterItems>
|
<summaryFilterItems>
|
<field>Rental_Apply_Equipment_Set_Detail__c.Queue_Day__c</field>
|
<operation>notEqual</operation>
|
<value></value>
|
</summaryFilterItems>
|
<summaryFilterItems>
|
<field>Rental_Apply_Equipment_Set_Detail__c.Queue_Number__c</field>
|
<operation>greaterThan</operation>
|
<value>0</value>
|
</summaryFilterItems>
|
<summaryFilterItems>
|
<field>Rental_Apply_Equipment_Set_Detail__c.Select_Time__c</field>
|
<operation>equals</operation>
|
<value></value>
|
</summaryFilterItems>
|
<summaryForeignKey>Rental_Apply_Equipment_Set_Detail__c.Rental_Apply_Equipment_Set__c</summaryForeignKey>
|
<summaryOperation>count</summaryOperation>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Summary</type>
|
</fields>
|
<fields>
|
<fullName>Queue_Status__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF (RetalFSetDetail_Cnt__c > 0,
|
IF ( Queue_Count__c == RetalFSetDetail_Cnt__c, '全部排队',
|
IF (AND (Queue_Count__c < RetalFSetDetail_Cnt__c, Queue_Count__c > 0), '部分排队', '无排队'
|
)
|
), ''
|
)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>排队状态</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>RAES_Status__c</fullName>
|
<description>草案中
|
申请中
|
待分配
|
排队中
|
暂定分配
|
已分配
|
已出库指示
|
已下架
|
出库前已检测
|
已出库
|
申请者已收货 (申请者收货NG) ← 申请单的
|
医院已装机确认
|
已回寄
|
欠品中
|
已回收
|
回收后已CDS
|
回收后检测NG
|
回收后已检测
|
已回库</description>
|
<externalId>false</externalId>
|
<formula>IF (AND(Cancel_Select__c, NOT(NG_Select_Again__c)), '取消',
|
IF(Not(OR(Rental_Apply__r.Status_Text__c == '已批准', Rental_Apply__r.Status_Text__c == '已出库指示')), Rental_Apply__r.RA_Status_Text__c,
|
IF(Not(RetalFSetDetail_Cnt__c > 0), '待分配', /* 没有明细 */
|
IF (Wei_Arrival_in_wh__c == 0, '已回库',
|
IF (AND(Inspection_after_ng_cnt__c > 0 , Lost_product_cnt__c = 0), '回收后检测NG',
|
IF (Wei_Inspection_result_after_F__c == 0, '回收后已检测',
|
IF (Wei_CDS_complete__c == 0, '回收后已CDS',
|
IF (Wei_Received_loaner__c == 0, '已回收',
|
IF(Wei_Consumption_Cnt__c = 0, '已回收', /* 全部消耗的时候，一览状态为已回收 */
|
IF (Wei_Return__c == 0,IF (Lost_product_cnt__c > 0, '欠品中', '已回寄'),
|
IF (Wei_loaner_arranged__c == 0, IF ( OR(ISPICKVAL(Received_Confirm__c, 'OK') ,ISPICKVAL(Received_Confirm__c, '默认签收-OK')), IF (Rental_Apply__r.HP_received_Confirmed_F__c, '医院已装机确认','申请者已收货'),
|
IF (ISPICKVAL(Received_Confirm__c, 'NG'), '申请者收货NG',
|
'已出库')),
|
IF (Inspection_not_finish__c == 0, '出库前已检测',
|
IF (Wei_StockDown__c == 0, '已下架',
|
IF (Wei_Shipment_request__c == 0, '已出库指示',
|
IF (Wei_Assigned_Cnt__c == 0, '已分配',
|
IF (Wei_Request_approve_finish__c > 0, Text(Rental_Apply__r.Add_Approval_Status__c), /* 申请单里有, 申请中？追加附属品 未已批准, 显示 Add_Approval_Status__c */
|
/*IF(AND(Wei_Assigned_Cnt__c = 1,NOT(ISBLANK(First_RAESD__r.Queue_Day__c)), ISBLANK(First_RAESD__r.Select_Time__c)), 20211230 ljh 排队*/
|
IF(AND(Wei_Assigned_Cnt__c = 1,NOT(ISBLANK(First_RAESD__r.Queue_Number__c)), ISBLANK(First_RAESD__r.Select_Time__c)),
|
IF (First_RAESD__r.Queue_Number__c > 0, '排队中', '暂定分配')
|
,'待分配' /* 有明细, 有一条什么都没有干 */
|
)
|
)
|
)
|
)
|
)
|
)
|
)
|
)
|
)
|
)
|
)
|
)
|
)
|
)
|
)
|
)
|
)</formula>
|
<inlineHelpText>草案中
|
申请中
|
待分配
|
排队中
|
暂定分配
|
已分配
|
已出库指示
|
已下架
|
出库前已检测
|
已出库
|
申请者已收货 (申请者收货NG) ← 申请单的
|
医院已装机确认
|
已回寄
|
欠品中
|
已回收
|
回收后已CDS
|
回收后检测NG
|
回收后已检测
|
已回库</inlineHelpText>
|
<label>借出备品配套一览状态</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>RARecordTypeId__c</fullName>
|
<externalId>false</externalId>
|
<formula>Rental_Apply__r.RecordTypeId</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>备品申请的记录类型</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>RC_Bollow_Compare__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(
|
(AND(NOT(ISBLANK(Rental_Apply__r.RC_Ordered_Date__c)),Rental_Apply__r.RC_Ordered_Date__c > Bollow_Date_Add_7_WD__c)) ||
|
(AND(ISBLANK(Rental_Apply__r.RC_Ordered_Date__c),TODAY() > Bollow_Date_Add_7_WD__c))
|
,1,0)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>受理日是否大于备品中心出库日7个工作日</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>RC_Bollow_Sub__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(NOT(ISBLANK(Rental_Apply__r.RC_Ordered_Date__c)),Rental_Apply__r.RC_Ordered_Date__c-Bollow_Date__c,TODAY()-Bollow_Date__c)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>RC修理品受理日-备品中心出库日（天数）</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>RC_return_to_office__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(Rental_Apply__r.Re_repair__r.Repair_Shipped_Date__c!=null,Rental_Apply__r.Re_repair__r.Repair_Shipped_Date__c,Rental_Apply__r.Repair__r.Repair_Shipped_Date__c)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>RC修理品返送日</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Date</type>
|
</fields>
|
<fields>
|
<fullName>Ra_Cancel_Select__c</fullName>
|
<externalId>false</externalId>
|
<formula>NOT( ISBLANK(Rental_Apply__r.Cancel_time__c))</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>申请单取消</label>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Checkbox</type>
|
</fields>
|
<fields>
|
<fullName>RcUnexpectExpiryDelay__c</fullName>
|
<externalId>false</externalId>
|
<label>RC未定到期延时</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Date</type>
|
</fields>
|
<fields>
|
<fullName>Re_Delay_Apply_Date__c</fullName>
|
<externalId>false</externalId>
|
<label>再延长申请日期</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Date</type>
|
</fields>
|
<fields>
|
<fullName>Re_Inform_Mail__c</fullName>
|
<description>備品Setを入庫してから、関連する次の貸出備品Set一覧を通知</description>
|
<externalId>false</externalId>
|
<label>Re Inform Mail</label>
|
<length>1</length>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Received_Confirm_NG_Not_Return_Text__c</fullName>
|
<externalId>false</externalId>
|
<label>现场收货NG未寄回(文本)</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>Received_Confirm_NG_Not_Return__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(Loaner_received_time__c + 7 < NOW() && TEXT(Received_Confirm__c) = 'NG' && ISNULL(Asset_return_day2__c) && Rental_Apply__r.DataMigration_Flag__c = FALSE , VALUE($Label.EquipmentRentalBlackListPoint_1), 0)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>现场收货NG未寄回</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>Received_Confirm_Status_F__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF ( OR(Received_Confirm_Text__c = 'OK' ,Received_Confirm_Text__c = '默认签收-OK'), IF (Rental_Apply__r.HP_received_Confirmed__c, '医院已装机确认','申请者已收货'),
|
IF (Received_Confirm_Text__c = 'NG', '申请者收货NG', '')
|
)</formula>
|
<label>收货确认状态</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Received_Confirm_Status_Text__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>Received_Confirm_Text__c</fullName>
|
<description>公式超, 改成用Text</description>
|
<externalId>false</externalId>
|
<label>现场收到确认结果(Text)</label>
|
<length>255</length>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Received_Confirm__c</fullName>
|
<description>OK, NG, 默认签收-OK</description>
|
<externalId>false</externalId>
|
<label>现场收到确认结果</label>
|
<required>false</required>
|
<trackHistory>true</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Picklist</type>
|
<valueSet>
|
<valueSetDefinition>
|
<sorted>false</sorted>
|
<value>
|
<fullName>OK</fullName>
|
<default>false</default>
|
<label>OK</label>
|
</value>
|
<value>
|
<fullName>NG</fullName>
|
<default>false</default>
|
<label>NG</label>
|
</value>
|
</valueSetDefinition>
|
</valueSet>
|
</fields>
|
<fields>
|
<fullName>Received_NG_ReAssign_Text__c</fullName>
|
<defaultValue>false</defaultValue>
|
<externalId>false</externalId>
|
<label>到货NG重新分配（Text）</label>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Checkbox</type>
|
</fields>
|
<fields>
|
<fullName>Received_NG_ReAssign__c</fullName>
|
<externalId>false</externalId>
|
<formula>Canceled__r.NG_Select_Again__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>到货NG重新分配</label>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Checkbox</type>
|
</fields>
|
<fields>
|
<fullName>Received_confirmation_staff2__c</fullName>
|
<deleteConstraint>SetNull</deleteConstraint>
|
<externalId>false</externalId>
|
<label>****回寄-确认者</label>
|
<referenceTo>User</referenceTo>
|
<relationshipName>Received_confirmation_staff2</relationshipName>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Lookup</type>
|
</fields>
|
<fields>
|
<fullName>Received_confirmation_staff__c</fullName>
|
<externalId>false</externalId>
|
<formula>First_RAESD__r.Return_DeliverySlip__r.CreatedBy_Name_Text__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>Received_ng_detail__c</fullName>
|
<externalId>false</externalId>
|
<label>收到确认NG内容</label>
|
<required>false</required>
|
<trackHistory>true</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>TextArea</type>
|
</fields>
|
<fields>
|
<fullName>Rental_Apply__c</fullName>
|
<externalId>false</externalId>
|
<label>备品借出申请No</label>
|
<referenceTo>Rental_Apply__c</referenceTo>
|
<relationshipLabel>借出备品配套一览</relationshipLabel>
|
<relationshipName>Rental_Apply_Equipment_Set</relationshipName>
|
<relationshipOrder>0</relationshipOrder>
|
<reparentableMasterDetail>true</reparentableMasterDetail>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>MasterDetail</type>
|
<writeRequiresMasterRead>false</writeRequiresMasterRead>
|
</fields>
|
<fields>
|
<fullName>Rental_Apply_r_Name__c</fullName>
|
<externalId>false</externalId>
|
<formula>Rental_Apply__r.Name</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>Rental_Apply_r_Name</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Rental_Asset_SerialNumber__c</fullName>
|
<description>出库時、配套明细にあるすべてのシリアル番号をここにセットする</description>
|
<externalId>false</externalId>
|
<inlineHelpText>例：「,0387,」、「,0378,0387,」</inlineHelpText>
|
<label>借出设备机身号码</label>
|
<length>65535</length>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>LongTextArea</type>
|
<visibleLines>3</visibleLines>
|
</fields>
|
<fields>
|
<fullName>Rental_Date_byHand__c</fullName>
|
<externalId>false</externalId>
|
<label>备品预计回收日(手动)</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Date</type>
|
</fields>
|
<fields>
|
<fullName>Rental_End_Date__c</fullName>
|
<externalId>false</externalId>
|
<label>备品预计回收日</label>
|
<required>false</required>
|
<trackHistory>true</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Date</type>
|
</fields>
|
<fields>
|
<fullName>Rental_Num__c</fullName>
|
<defaultValue>0</defaultValue>
|
<externalId>false</externalId>
|
<label>数量(Sys)</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>Rental_Start_Date__c</fullName>
|
<externalId>false</externalId>
|
<label>备品预计出货日</label>
|
<required>false</required>
|
<trackHistory>true</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Date</type>
|
</fields>
|
<fields>
|
<fullName>Rental_workday__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>Repair_Agreed_Date__c</fullName>
|
<externalId>false</externalId>
|
<formula>Rental_Apply__r.Repair__r.Agreed_Date__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>修理报价用户同意日</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Date</type>
|
</fields>
|
<fields>
|
<fullName>Repair_Agreed_Quotation_F__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(Demo_purpose2__c == '一般用户' && Rental_Apply__r.Request_demo_day__c < DATEVALUE('2019-07-01'), 0
|
, IF(isblank(Repair_Agreed_Date__c), Today() - Rental_Apply__r.Repair__r.Repair_Quotation_date__c
|
,Repair_Agreed_Date__c - Rental_Apply__r.Repair__r.Repair_Quotation_date__c
|
)
|
)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>维修报价日-维修同意日(天数)F</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>Repair_Agreed_Quotation_Text__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>Repair_Status1__c</fullName>
|
<externalId>false</externalId>
|
<formula>Rental_Apply__r.Repair_status__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>Repair_Status2__c</fullName>
|
<externalId>false</externalId>
|
<formula>Rental_Apply__r.Repair_status2__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>修理状态2</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Repair_Status_Changed2__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(IsBlank(Substitute(Blankvalue(Repair_Status1__c, ""), Blankvalue(Repair_Status_Text__c, ""), "")), "0", "1")</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>Repair_Status_Changed2</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Repair_Status_Changed__c</fullName>
|
<description>WF设置的text字段中，原字段和它的text字段是否一致</description>
|
<externalId>false</externalId>
|
<formula>IF(Repair_Status1__c <> Repair_Status_Text__c, '1', '0')</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>修理状态（是否变化）</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Repair_Status_Text__c</fullName>
|
<description>UpdateRentalApplyEquipmentSetBatch里 判断修理有没有变化</description>
|
<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>Repair_altanative_asset_return_limit__c</fullName>
|
<externalId>false</externalId>
|
<formula>Rental_Apply__r.Repair__r.Repair_Shipped_Date__c +7</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>修理代品返送期限</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Date</type>
|
</fields>
|
<fields>
|
<fullName>Repair_cancel_Final_reply_day_F__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF((Demo_purpose2_T__c=='保修用户'||Demo_purpose2_T__c=='市场多年保修'||Demo_purpose2_T__c=='一般用户'||Demo_purpose2_T__c=='再修理'||Demo_purpose2_T__c=='故障排查')
|
&& Repair_Status_Text__c =='0.取消'
|
, Rental_Apply__r.Repair__r.repair_cancel_date__c+7
|
, null
|
)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>最新预定归还日_修理取消_F</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Date</type>
|
</fields>
|
<fields>
|
<fullName>Repair_cancel_Final_reply_day_Text__c</fullName>
|
<externalId>false</externalId>
|
<label>最新预定归还日_修理取消</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Date</type>
|
</fields>
|
<fields>
|
<fullName>Repair_delete_Final_reply_day_F__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF((Demo_purpose2_T__c=='保修用户'||Demo_purpose2_T__c=='市场多年保修'||Demo_purpose2_T__c=='一般用户'||Demo_purpose2_T__c=='再修理'||Demo_purpose2_T__c=='故障排查')
|
&& Repair_Status_Text__c =='0.删除'
|
, Rental_Apply__r.Repair__r.SAP_not_accept_repair_result__c+7
|
, null
|
)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>最新预定归还日_修理删除_F</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Date</type>
|
</fields>
|
<fields>
|
<fullName>Repair_delete_Final_reply_day_Text__c</fullName>
|
<externalId>false</externalId>
|
<label>最新预定归还日_修理删除</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Date</type>
|
</fields>
|
<fields>
|
<fullName>Repair_product_Name__c</fullName>
|
<externalId>false</externalId>
|
<formula>Rental_Apply__r.Repair_product_Name__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>Repair_product_body_number__c</fullName>
|
<externalId>false</externalId>
|
<formula>Rental_Apply__r.Repair_product_body_number__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>Request_Status__c</fullName>
|
<externalId>false</externalId>
|
<formula>Rental_Apply__r.RA_Status__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>Request_answer_day__c</fullName>
|
<externalId>false</externalId>
|
<formula>Rental_Apply__r.Application_accept_day__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>申请受理日(回答日)</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Date</type>
|
</fields>
|
<fields>
|
<fullName>Request_answer_time__c</fullName>
|
<externalId>false</externalId>
|
<formula>Rental_Apply__r.Application_accept_time__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>申请受理时间(回答时间)</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>DateTime</type>
|
</fields>
|
<fields>
|
<fullName>Request_approval_day__c</fullName>
|
<externalId>false</externalId>
|
<formula>Rental_Apply__r.Request_approval_day__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>批准日(申请提交日)</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Date</type>
|
</fields>
|
<fields>
|
<fullName>Request_approval_time__c</fullName>
|
<externalId>false</externalId>
|
<formula>Rental_Apply__r.Request_approval_time__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>批准时间(申请提交时间)</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>DateTime</type>
|
</fields>
|
<fields>
|
<fullName>Request_asset_extend_day__c</fullName>
|
<externalId>false</externalId>
|
<formula>DATEVALUE( Request_asset_extend_time__c )</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>****延期申请日</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Date</type>
|
</fields>
|
<fields>
|
<fullName>Request_asset_extend_time__c</fullName>
|
<externalId>false</externalId>
|
<label>****延期申请时间</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>DateTime</type>
|
</fields>
|
<fields>
|
<fullName>Request_demo_day_del__c</fullName>
|
<externalId>false</externalId>
|
<formula>Rental_Apply__r.Request_demo_day__c</formula>
|
<label>申请日期</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Date</type>
|
</fields>
|
<fields>
|
<fullName>Request_demo_time__c</fullName>
|
<externalId>false</externalId>
|
<formula>Rental_Apply__r.Request_demo_time__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>申请时间</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>DateTime</type>
|
</fields>
|
<fields>
|
<fullName>Request_extend_day__c</fullName>
|
<externalId>false</externalId>
|
<label>****延期希望结束日</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Date</type>
|
</fields>
|
<fields>
|
<fullName>Request_owner__c</fullName>
|
<externalId>false</externalId>
|
<formula>Rental_Apply__r.Owner:User.Alias</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>备品出借担当</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Request_shipping_day__c</fullName>
|
<externalId>false</externalId>
|
<formula>Rental_Apply__r.Request_shipping_day__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>希望到货日</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Date</type>
|
</fields>
|
<fields>
|
<fullName>RetalFSetDetail_Cnt__c</fullName>
|
<externalId>false</externalId>
|
<label>借出备品配套明细数</label>
|
<summaryFilterItems>
|
<field>Rental_Apply_Equipment_Set_Detail__c.Cancel_Select__c</field>
|
<operation>equals</operation>
|
<value>False</value>
|
</summaryFilterItems>
|
<summaryForeignKey>Rental_Apply_Equipment_Set_Detail__c.Rental_Apply_Equipment_Set__c</summaryForeignKey>
|
<summaryOperation>count</summaryOperation>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Summary</type>
|
</fields>
|
<fields>
|
<fullName>Return_Distributor_method2_F__c</fullName>
|
<externalId>false</externalId>
|
<formula>TEXT(First_RAESD__r.Return_DeliverySlip__r.Distributor_method__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>Return_Distributor_method2__c</fullName>
|
<externalId>false</externalId>
|
<label>****回寄-运输方式</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Picklist</type>
|
<valueSet>
|
<controllingField>Return_delivery_company2__c</controllingField>
|
<valueSetDefinition>
|
<sorted>false</sorted>
|
<value>
|
<fullName>陆运</fullName>
|
<default>false</default>
|
<label>陆运</label>
|
</value>
|
<value>
|
<fullName>空运</fullName>
|
<default>false</default>
|
<label>空运</label>
|
</value>
|
<value>
|
<fullName>优先达</fullName>
|
<default>false</default>
|
<label>优先达</label>
|
</value>
|
<value>
|
<fullName>普达</fullName>
|
<default>false</default>
|
<label>普达</label>
|
</value>
|
</valueSetDefinition>
|
<valueSettings>
|
<controllingFieldValue>Fedex</controllingFieldValue>
|
<valueName>优先达</valueName>
|
</valueSettings>
|
<valueSettings>
|
<controllingFieldValue>Fedex</controllingFieldValue>
|
<valueName>普达</valueName>
|
</valueSettings>
|
<valueSettings>
|
<controllingFieldValue>利讯</controllingFieldValue>
|
<controllingFieldValue>嘉里大通</controllingFieldValue>
|
<controllingFieldValue>莱比特</controllingFieldValue>
|
<controllingFieldValue>慧通速递</controllingFieldValue>
|
<valueName>陆运</valueName>
|
</valueSettings>
|
<valueSettings>
|
<controllingFieldValue>利讯</controllingFieldValue>
|
<controllingFieldValue>嘉里大通</controllingFieldValue>
|
<controllingFieldValue>莱比特</controllingFieldValue>
|
<controllingFieldValue>慧通速递</controllingFieldValue>
|
<valueName>空运</valueName>
|
</valueSettings>
|
</valueSet>
|
</fields>
|
<fields>
|
<fullName>Return_Fedex_number2_F__c</fullName>
|
<externalId>false</externalId>
|
<formula>First_RAESD__r.Return_DeliverySlip__r.Name</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>回寄-发货运输单号F</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Return_Fedex_number2__c</fullName>
|
<externalId>false</externalId>
|
<label>****回寄-发货运输单号</label>
|
<length>30</length>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Return_Time_Day__c</fullName>
|
<externalId>false</externalId>
|
<formula>DATEVALUE( Return_Time_New__c )</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>回寄日(最新)</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Date</type>
|
</fields>
|
<fields>
|
<fullName>Return_Time_New__c</fullName>
|
<externalId>false</externalId>
|
<label>回寄时间(最新)</label>
|
<summarizedField>Rental_Apply_Equipment_Set_Detail__c.Asset_return_time__c</summarizedField>
|
<summaryForeignKey>Rental_Apply_Equipment_Set_Detail__c.Rental_Apply_Equipment_Set__c</summaryForeignKey>
|
<summaryOperation>max</summaryOperation>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Summary</type>
|
</fields>
|
<fields>
|
<fullName>Return_case_num__c</fullName>
|
<description>For Report</description>
|
<externalId>false</externalId>
|
<formula>if(isnull(Over_Loaner_Status__c),0,IF(Over_Loaner_Status__c='正常返回',1,0))</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>****正常返回数量</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>Return_delivery_company2_F__c</fullName>
|
<externalId>false</externalId>
|
<formula>TEXT(First_RAESD__r.Return_DeliverySlip__r.DeliveryCompany__c)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>回寄-物流公司F</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Return_delivery_company2__c</fullName>
|
<externalId>false</externalId>
|
<label>****回寄-物流公司</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Picklist</type>
|
<valueSet>
|
<valueSetDefinition>
|
<sorted>false</sorted>
|
<value>
|
<fullName>利讯</fullName>
|
<default>false</default>
|
<label>利讯</label>
|
</value>
|
<value>
|
<fullName>Fedex</fullName>
|
<default>false</default>
|
<label>Fedex</label>
|
</value>
|
<value>
|
<fullName>嘉里大通</fullName>
|
<default>false</default>
|
<label>嘉里大通</label>
|
</value>
|
<value>
|
<fullName>莱比特</fullName>
|
<default>false</default>
|
<label>莱比特</label>
|
</value>
|
<value>
|
<fullName>慧通速递</fullName>
|
<default>false</default>
|
<label>慧通速递</label>
|
</value>
|
</valueSetDefinition>
|
</valueSet>
|
</fields>
|
<fields>
|
<fullName>Return_to_office_Final_reply_day_F__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF((Demo_purpose2_T__c == '保修用户' || Demo_purpose2_T__c == '市场多年保修' || Demo_purpose2_T__c=='再修理')
|
, IF(NOT(ISBLANK(Rental_Apply__r.NewRepair_Repair_Shipped_Date__c)), null, RC_return_to_office__c + 14)
|
/* OLY_OCM-636 一般用户的最新预订归还日逻辑调整 Start */
|
, IF (Demo_purpose2_T__c == '一般用户'
|
/* 在21天内同一维修报价 */
|
/* OLY_OCM-675 追加逻辑7.用户同意日≤申请时间 3、最新预定归还日=11.RC修理品返送日+14天 */
|
, IF(NOT(ISBLANK(Rental_Apply__r.NewRepair_Repair_Shipped_Date__c)), null,
|
IF(Return_to_office_Final_reply_day_U_RC__c
|
, RC_return_to_office__c + 14
|
, IF(Repair_Agreed_Quotation_Text__c > 21
|
/* 超过21天内同意维修报价 */
|
, Rental_Apply__r.Repair__r.Repair_Quotation_date__c + 24
|
, null
|
)
|
)
|
)
|
, null
|
/* OLY_OCM-636 一般用户的最新预订归还日逻辑调整 End */
|
)
|
)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>最新预定归还日_修理品返送日_F</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Date</type>
|
</fields>
|
<fields>
|
<fullName>Return_to_office_Final_reply_day_Text__c</fullName>
|
<externalId>false</externalId>
|
<label>最新预定归还日_修理品返送日</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Date</type>
|
</fields>
|
<fields>
|
<fullName>Return_to_office_Final_reply_day_U_RC_F__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF((Demo_purpose2_T__c == '保修用户' || Demo_purpose2_T__c == '市场多年保修' || Demo_purpose2_T__c=='再修理')
|
, false
|
/* OLY_OCM-636 一般用户的最新预订归还日逻辑调整 Start */
|
, IF (Demo_purpose2_T__c == '一般用户'
|
/* 在21天内同一维修报价 */
|
/* OLY_OCM-675 追加逻辑7.用户同意日≤申请时间 3、最新预定归还日=11.RC修理品返送日+14天 */
|
, IF(Repair_Agreed_Quotation_Text__c <= 21
|
|| (Repair_Agreed_Date__c <= DATEVALUE(Request_demo_time__c)
|
&& DATEVALUE(Request_demo_time__c) >= DATEVALUE("2019-12-01")
|
)
|
, true
|
, false
|
)
|
, false
|
/* OLY_OCM-636 一般用户的最新预订归还日逻辑调整 End */
|
)
|
)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>最新预定归还日(使用)_一般用户_RC修理品返送日使用条件F</label>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Checkbox</type>
|
</fields>
|
<fields>
|
<fullName>Return_to_office_Final_reply_day_U_RC__c</fullName>
|
<defaultValue>false</defaultValue>
|
<externalId>false</externalId>
|
<label>最新预定归还日(使用)_一般用户_RC修理品返送日使用条件</label>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Checkbox</type>
|
</fields>
|
<fields>
|
<fullName>Root_Rental_Apply__c</fullName>
|
<externalId>false</externalId>
|
<formula>Rental_Apply__r.Root_Rental_Apply__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>SalesManager__c</fullName>
|
<deleteConstraint>SetNull</deleteConstraint>
|
<externalId>false</externalId>
|
<label>****经理(销售)</label>
|
<referenceTo>User</referenceTo>
|
<relationshipName>Jingli3dqX</relationshipName>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Lookup</type>
|
</fields>
|
<fields>
|
<fullName>Salesdept__c</fullName>
|
<externalId>false</externalId>
|
<formula>Rental_Apply__r.Salesdept__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>Same_Accessory_flag__c</fullName>
|
<defaultValue>false</defaultValue>
|
<externalId>false</externalId>
|
<label>同一附属品</label>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Checkbox</type>
|
</fields>
|
<fields>
|
<fullName>Select_Again_Cnt__c</fullName>
|
<externalId>false</externalId>
|
<label>被重新分配件数</label>
|
<summaryFilterItems>
|
<field>Rental_Apply_Equipment_Set_Detail__c.Cancel_Select__c</field>
|
<operation>equals</operation>
|
<value>False</value>
|
</summaryFilterItems>
|
<summaryFilterItems>
|
<field>Rental_Apply_Equipment_Set_Detail__c.Canceled_Id__c</field>
|
<operation>notEqual</operation>
|
<value></value>
|
</summaryFilterItems>
|
<summaryFilterItems>
|
<field>Rental_Apply_Equipment_Set_Detail__c.AgencyTempCancel__c</field>
|
<operation>equals</operation>
|
<value>False</value>
|
</summaryFilterItems>
|
<summaryForeignKey>Rental_Apply_Equipment_Set_Detail__c.Rental_Apply_Equipment_Set__c</summaryForeignKey>
|
<summaryOperation>count</summaryOperation>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Summary</type>
|
</fields>
|
<fields>
|
<fullName>Select_Status__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(RetalFSetDetail_Cnt__c > 0,
|
IF(Wei_Assigned_Cnt__c == RetalFSetDetail_Cnt__c,'待分配',
|
IF (AND (Wei_Assigned_Cnt__c > 0, Wei_Assigned_Cnt__c < RetalFSetDetail_Cnt__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>Send_to_return_email__c</fullName>
|
<defaultValue>false</defaultValue>
|
<externalId>false</externalId>
|
<label>发送回收结果反馈邮件</label>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Checkbox</type>
|
</fields>
|
<fields>
|
<fullName>SerialNumber_F__c</fullName>
|
<externalId>false</externalId>
|
<formula>First_RAESD__r.SerialNumber_F__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>Serial_Lost_Confirm__c</fullName>
|
<externalId>false</externalId>
|
<inlineHelpText>有值说明主机以回收</inlineHelpText>
|
<label>主机欠品确认_回收</label>
|
<summaryFilterItems>
|
<field>Rental_Apply_Equipment_Set_Detail__c.Loaner_accsessary__c</field>
|
<operation>equals</operation>
|
<value>False</value>
|
</summaryFilterItems>
|
<summaryFilterItems>
|
<field>Rental_Apply_Equipment_Set_Detail__c.Check_lost_Item_F__c</field>
|
<operation>equals</operation>
|
<value>OK</value>
|
</summaryFilterItems>
|
<summaryFilterItems>
|
<field>Rental_Apply_Equipment_Set_Detail__c.Cancel_Select__c</field>
|
<operation>equals</operation>
|
<value>False</value>
|
</summaryFilterItems>
|
<summaryForeignKey>Rental_Apply_Equipment_Set_Detail__c.Rental_Apply_Equipment_Set__c</summaryForeignKey>
|
<summaryOperation>count</summaryOperation>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Summary</type>
|
</fields>
|
<fields>
|
<fullName>Serial_Lost_item_check_time__c</fullName>
|
<externalId>false</externalId>
|
<inlineHelpText>有值说明主机已做了欠品确认</inlineHelpText>
|
<label>主机欠品确认时间</label>
|
<summarizedField>Rental_Apply_Equipment_Set_Detail__c.Lost_item_check_time_F__c</summarizedField>
|
<summaryFilterItems>
|
<field>Rental_Apply_Equipment_Set_Detail__c.Loaner_accsessary__c</field>
|
<operation>equals</operation>
|
<value>False</value>
|
</summaryFilterItems>
|
<summaryFilterItems>
|
<field>Rental_Apply_Equipment_Set_Detail__c.Lost_item_check_time_F__c</field>
|
<operation>notEqual</operation>
|
<value></value>
|
</summaryFilterItems>
|
<summaryFilterItems>
|
<field>Rental_Apply_Equipment_Set_Detail__c.Cancel_Select__c</field>
|
<operation>equals</operation>
|
<value>False</value>
|
</summaryFilterItems>
|
<summaryForeignKey>Rental_Apply_Equipment_Set_Detail__c.Rental_Apply_Equipment_Set__c</summaryForeignKey>
|
<summaryOperation>min</summaryOperation>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Summary</type>
|
</fields>
|
<fields>
|
<fullName>Serial_NG_Cnt__c</fullName>
|
<externalId>false</externalId>
|
<label>主机维修/废弃汇总</label>
|
<summaryFilterItems>
|
<field>Rental_Apply_Equipment_Set_Detail__c.Loaner_accsessary__c</field>
|
<operation>equals</operation>
|
<value>False</value>
|
</summaryFilterItems>
|
<summaryFilterItems>
|
<field>Rental_Apply_Equipment_Set_Detail__c.Inspection_result_after_F__c</field>
|
<operation>equals</operation>
|
<value>NG</value>
|
</summaryFilterItems>
|
<summaryFilterItems>
|
<field>Rental_Apply_Equipment_Set_Detail__c.Cancel_Select__c</field>
|
<operation>equals</operation>
|
<value>False</value>
|
</summaryFilterItems>
|
<summaryForeignKey>Rental_Apply_Equipment_Set_Detail__c.Rental_Apply_Equipment_Set__c</summaryForeignKey>
|
<summaryOperation>count</summaryOperation>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Summary</type>
|
</fields>
|
<fields>
|
<fullName>SetOrderPoint_sum_Text__c</fullName>
|
<externalId>false</externalId>
|
<label>本配套的犯规点数(文本)</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>SetOrderPoint_sum__c</fullName>
|
<externalId>false</externalId>
|
<formula>MAX( Set_Borrow_Date_Fouls__c , Set_UnSign_Foul_point__c , Set_Not_Create_Repair_Ordered_Date__c,IF(Received_Confirm_NG_Not_Return__c!=0,1,0))</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>本配套的犯规点数</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>Set_Borrow_Date_Fouls__c</fullName>
|
<description>20180320：
|
修改整套欠品时，借出日期也计犯规点数
|
&& Rental_Apply__r.DataMigration_Flag__c = FALSE</description>
|
<externalId>false</externalId>
|
<formula>IF(((Demo_purpose1__c!='维修代用'&&Demo_purpose2__c!='已购待货'&&Demo_purpose1__c!='协议借用')&&( NOT(ISBLANK(Bollow_Date__c))&& today()- Bollow_Date__c> 90&& (ISBLANK(Asset_return_day2__c) || (NOT(ISBLANK(Asset_return_day2__c)) && RetalFSetDetail_Cnt__c = Lost_product_cnt__c)
|
)
|
) && Rental_Apply__r.DataMigration_Flag__c = FALSE
|
)
|
||((Demo_purpose1__c=='维修代用'||Demo_purpose2__c=='已购待货'||Demo_purpose1__c=='协议借用')&&( NOT(ISBLANK(Bollow_Date__c))&&
|
(today()-Final_reply_day_text__c>=60)&& (ISBLANK(Asset_return_day2__c) || (NOT(ISBLANK(Asset_return_day2__c)) && RetalFSetDetail_Cnt__c = Lost_product_cnt__c
|
)
|
)
|
)),
|
VALUE( $Label.EquipmentRentalBlackListPoint),
|
IF( NOT(ISBLANK(Bollow_Date__c))&&today()> Final_reply_day_text__c && (ISBLANK(Asset_return_day2__c) || (NOT(ISBLANK(Asset_return_day2__c)) && RetalFSetDetail_Cnt__c = Lost_product_cnt__c)
|
)&& Rental_Apply__r.DataMigration_Flag__c = FALSE
|
,
|
VALUE( $Label.EquipmentRentalBlackListPoint_1),0))</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>借出日期犯规点数</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>Set_Managment_Code__c</fullName>
|
<externalId>false</externalId>
|
<formula>First_RAESD__r.EquipmentSet_Managment_Code_formula__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>Set_Not_Create_Repair_Ordered_Date__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(Demo_purpose2__c='保修用户' &&
|
ISNULL( Rental_Apply__r.Repair__r.Repair_Ordered_Date__c ) &&
|
Bollow_Date__c + 7 < TODAY() &&
|
Lost_item_check_not_finish__c != 0, VALUE($Label.EquipmentRentalBlackListPoint_1), 0)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>未生成RC受理日犯规</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>Set_Rental_Received_Day__c</fullName>
|
<externalId>false</externalId>
|
<formula>Rental_Apply__r.Rental_Received_Day__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>到货签收确认日</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Date</type>
|
</fields>
|
<fields>
|
<fullName>Set_StockDown_time_New__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(RARecordTypeId__c == '01210000000NPGK' ,null,Set_StockDown_time__c)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>下架时间</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>DateTime</type>
|
</fields>
|
<fields>
|
<fullName>Set_StockDown_time__c</fullName>
|
<externalId>false</externalId>
|
<label>下架时间(Sys)</label>
|
<summarizedField>Rental_Apply_Equipment_Set_Detail__c.StockDown_time__c</summarizedField>
|
<summaryFilterItems>
|
<field>Rental_Apply_Equipment_Set_Detail__c.StockDown_time__c</field>
|
<operation>notEqual</operation>
|
<value></value>
|
</summaryFilterItems>
|
<summaryFilterItems>
|
<field>Rental_Apply_Equipment_Set_Detail__c.Cancel_Select__c</field>
|
<operation>equals</operation>
|
<value>False</value>
|
</summaryFilterItems>
|
<summaryFilterItems>
|
<field>Rental_Apply_Equipment_Set_Detail__c.AgencyTempCancel__c</field>
|
<operation>equals</operation>
|
<value>False</value>
|
</summaryFilterItems>
|
<summaryForeignKey>Rental_Apply_Equipment_Set_Detail__c.Rental_Apply_Equipment_Set__c</summaryForeignKey>
|
<summaryOperation>min</summaryOperation>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Summary</type>
|
</fields>
|
<fields>
|
<fullName>Set_UnSign_Foul_point__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF( AND( TEXT(Received_Confirm__c) = 'OK' ,ISNULL( Set_Rental_Received_Day__c) ,today()- Bollow_Date__c>10, ISBLANK( Lost_item_check_time__c ) ), VALUE( $Label.EquipmentRentalBlackListPoint_1) ,0)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>未签字确认犯规点数</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>Ship_Pre_inspection_time__c</fullName>
|
<externalId>false</externalId>
|
<label>发货前-检测合格时间</label>
|
<summarizedField>Rental_Apply_Equipment_Set_Detail__c.Pre_inspection_time__c</summarizedField>
|
<summaryFilterItems>
|
<field>Rental_Apply_Equipment_Set_Detail__c.Pre_inspection_time__c</field>
|
<operation>notEqual</operation>
|
<value></value>
|
</summaryFilterItems>
|
<summaryFilterItems>
|
<field>Rental_Apply_Equipment_Set_Detail__c.Cancel_Select__c</field>
|
<operation>equals</operation>
|
<value>False</value>
|
</summaryFilterItems>
|
<summaryFilterItems>
|
<field>Rental_Apply_Equipment_Set_Detail__c.AgencyTempCancel__c</field>
|
<operation>equals</operation>
|
<value>False</value>
|
</summaryFilterItems>
|
<summaryForeignKey>Rental_Apply_Equipment_Set_Detail__c.Rental_Apply_Equipment_Set__c</summaryForeignKey>
|
<summaryOperation>min</summaryOperation>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Summary</type>
|
</fields>
|
<fields>
|
<fullName>Shipment_request_command_New__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(RARecordTypeId__c== '01210000000NPGK',null,Shipment_request_command__c)</formula>
|
<label>出库指示时间</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>DateTime</type>
|
</fields>
|
<fields>
|
<fullName>Shipment_request_command__c</fullName>
|
<externalId>false</externalId>
|
<label>出库指示时间(Sys)</label>
|
<summarizedField>Rental_Apply_Equipment_Set_Detail__c.Shipment_request_time2__c</summarizedField>
|
<summaryFilterItems>
|
<field>Rental_Apply_Equipment_Set_Detail__c.Shipment_request_time2__c</field>
|
<operation>notEqual</operation>
|
<value></value>
|
</summaryFilterItems>
|
<summaryFilterItems>
|
<field>Rental_Apply_Equipment_Set_Detail__c.Cancel_Select__c</field>
|
<operation>equals</operation>
|
<value>False</value>
|
</summaryFilterItems>
|
<summaryForeignKey>Rental_Apply_Equipment_Set_Detail__c.Rental_Apply_Equipment_Set__c</summaryForeignKey>
|
<summaryOperation>min</summaryOperation>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Summary</type>
|
</fields>
|
<fields>
|
<fullName>Shipment_request_day__c</fullName>
|
<externalId>false</externalId>
|
<formula>DATEVALUE( Shipment_request_time__c )</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>****出库指示日</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Date</type>
|
</fields>
|
<fields>
|
<fullName>Shipment_request_time__c</fullName>
|
<externalId>false</externalId>
|
<label>****出库指示时间</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>DateTime</type>
|
</fields>
|
<fields>
|
<fullName>Shipping_Finished_Day_Func__c</fullName>
|
<externalId>false</externalId>
|
<formula>Rental_Apply__r.Shipping_Finished_Day_Func__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>最终发货日(已购待货)</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Date</type>
|
</fields>
|
<fields>
|
<fullName>Shippment_loaner_time2__c</fullName>
|
<externalId>false</externalId>
|
<label>备品中心出库时间</label>
|
<summarizedField>Rental_Apply_Equipment_Set_Detail__c.Shippment_loaner_time__c</summarizedField>
|
<summaryFilterItems>
|
<field>Rental_Apply_Equipment_Set_Detail__c.Shippment_loaner_time__c</field>
|
<operation>notEqual</operation>
|
<value></value>
|
</summaryFilterItems>
|
<summaryForeignKey>Rental_Apply_Equipment_Set_Detail__c.Rental_Apply_Equipment_Set__c</summaryForeignKey>
|
<summaryOperation>min</summaryOperation>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Summary</type>
|
</fields>
|
<fields>
|
<fullName>Shippment_loaner_time__c</fullName>
|
<externalId>false</externalId>
|
<label>****备品中心出库时间</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>DateTime</type>
|
</fields>
|
<fields>
|
<fullName>Skip__c</fullName>
|
<defaultValue>false</defaultValue>
|
<externalId>false</externalId>
|
<label>Skip</label>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Checkbox</type>
|
</fields>
|
<fields>
|
<fullName>SortInt_F__c</fullName>
|
<externalId>false</externalId>
|
<formula>LPad(Text(Groupby_SortInt__c), 3, '0')</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>明细顺序</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>StockDown_time__c</fullName>
|
<externalId>false</externalId>
|
<label>****下架时间</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>DateTime</type>
|
</fields>
|
<fields>
|
<fullName>Substitute_Select_Again__c</fullName>
|
<externalId>false</externalId>
|
<formula>Text(Canceled__r.Cancel_Reason__c) = '分配代替品'</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>代替品重新分配</label>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Checkbox</type>
|
</fields>
|
<fields>
|
<fullName>Substitute_Select_Again_text__c</fullName>
|
<defaultValue>false</defaultValue>
|
<externalId>false</externalId>
|
<label>代替品重新分配（Text）</label>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Checkbox</type>
|
</fields>
|
<fields>
|
<fullName>Substitute_flag__c</fullName>
|
<defaultValue>false</defaultValue>
|
<externalId>false</externalId>
|
<label>代替品</label>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Checkbox</type>
|
</fields>
|
<fields>
|
<fullName>Sum_Accessory_Cnt__c</fullName>
|
<description>发货确认单统计显示字段使用</description>
|
<externalId>false</externalId>
|
<label>附属品数量汇总</label>
|
<summaryFilterItems>
|
<field>Rental_Apply_Equipment_Set_Detail__c.Is_Body__c</field>
|
<operation>equals</operation>
|
<value>False</value>
|
</summaryFilterItems>
|
<summaryFilterItems>
|
<field>Rental_Apply_Equipment_Set_Detail__c.Cancel_Select__c</field>
|
<operation>equals</operation>
|
<value>False</value>
|
</summaryFilterItems>
|
<summaryFilterItems>
|
<field>Rental_Apply_Equipment_Set_Detail__c.Shipment_request__c</field>
|
<operation>equals</operation>
|
<value>True</value>
|
</summaryFilterItems>
|
<summaryForeignKey>Rental_Apply_Equipment_Set_Detail__c.Rental_Apply_Equipment_Set__c</summaryForeignKey>
|
<summaryOperation>count</summaryOperation>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Summary</type>
|
</fields>
|
<fields>
|
<fullName>Test_Day__c</fullName>
|
<externalId>false</externalId>
|
<formula>Rental_End_Date__c - Rental_Start_Date__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>借用天数</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>Today__c</fullName>
|
<externalId>false</externalId>
|
<formula>today()</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>今天</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Date</type>
|
</fields>
|
<fields>
|
<fullName>UniqueKey__c</fullName>
|
<caseSensitive>false</caseSensitive>
|
<description>Rental_Apply__r.RequestNoJoinStr2__c:Fixture_Set__c:#Index
|
cancel的话会加Id</description>
|
<externalId>true</externalId>
|
<label>UniqueKey</label>
|
<length>255</length>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>true</unique>
|
</fields>
|
<fields>
|
<fullName>VF_Rental_Num__c</fullName>
|
<externalId>false</externalId>
|
<label>数量(VF)</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>Wei_Arrival_in_wh__c</fullName>
|
<externalId>false</externalId>
|
<label>未回库件数</label>
|
<summaryFilterItems>
|
<field>Rental_Apply_Equipment_Set_Detail__c.Cancel_Select__c</field>
|
<operation>equals</operation>
|
<value>False</value>
|
</summaryFilterItems>
|
<summaryFilterItems>
|
<field>Rental_Apply_Equipment_Set_Detail__c.Detail_Finish__c</field>
|
<operation>equals</operation>
|
<value>False</value>
|
</summaryFilterItems>
|
<summaryForeignKey>Rental_Apply_Equipment_Set_Detail__c.Rental_Apply_Equipment_Set__c</summaryForeignKey>
|
<summaryOperation>count</summaryOperation>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Summary</type>
|
</fields>
|
<fields>
|
<fullName>Wei_Assigned_Cnt__c</fullName>
|
<externalId>false</externalId>
|
<label>未分配件数</label>
|
<summaryFilterItems>
|
<field>Rental_Apply_Equipment_Set_Detail__c.Select_Time__c</field>
|
<operation>equals</operation>
|
<value></value>
|
</summaryFilterItems>
|
<summaryFilterItems>
|
<field>Rental_Apply_Equipment_Set_Detail__c.Cancel_Select__c</field>
|
<operation>equals</operation>
|
<value>False</value>
|
</summaryFilterItems>
|
<summaryFilterItems>
|
<field>Rental_Apply_Equipment_Set_Detail__c.AgencyTempCancel__c</field>
|
<operation>equals</operation>
|
<value>False</value>
|
</summaryFilterItems>
|
<summaryForeignKey>Rental_Apply_Equipment_Set_Detail__c.Rental_Apply_Equipment_Set__c</summaryForeignKey>
|
<summaryOperation>count</summaryOperation>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Summary</type>
|
</fields>
|
<fields>
|
<fullName>Wei_CDS_complete__c</fullName>
|
<externalId>false</externalId>
|
<label>未回收后已CDS完毕件数</label>
|
<summaryFilterItems>
|
<field>Rental_Apply_Equipment_Set_Detail__c.CDS_complete__c</field>
|
<operation>equals</operation>
|
<value>False</value>
|
</summaryFilterItems>
|
<summaryFilterItems>
|
<field>Rental_Apply_Equipment_Set_Detail__c.Cancel_Select__c</field>
|
<operation>equals</operation>
|
<value>False</value>
|
</summaryFilterItems>
|
<summaryFilterItems>
|
<field>Rental_Apply_Equipment_Set_Detail__c.Detail_Finish__c</field>
|
<operation>equals</operation>
|
<value>False</value>
|
</summaryFilterItems>
|
<summaryForeignKey>Rental_Apply_Equipment_Set_Detail__c.Rental_Apply_Equipment_Set__c</summaryForeignKey>
|
<summaryOperation>count</summaryOperation>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Summary</type>
|
</fields>
|
<fields>
|
<fullName>Wei_Consumption_Cnt__c</fullName>
|
<externalId>false</externalId>
|
<label>未消耗件数</label>
|
<summaryFilterItems>
|
<field>Rental_Apply_Equipment_Set_Detail__c.Cancel_Select__c</field>
|
<operation>equals</operation>
|
<value>False</value>
|
</summaryFilterItems>
|
<summaryFilterItems>
|
<field>Rental_Apply_Equipment_Set_Detail__c.Check_lost_Item_F__c</field>
|
<operation>notEqual</operation>
|
<value>消耗</value>
|
</summaryFilterItems>
|
<summaryForeignKey>Rental_Apply_Equipment_Set_Detail__c.Rental_Apply_Equipment_Set__c</summaryForeignKey>
|
<summaryOperation>count</summaryOperation>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Summary</type>
|
</fields>
|
<fields>
|
<fullName>Wei_Inspection_result_after_F__c</fullName>
|
<externalId>false</externalId>
|
<label>未回收后已检测</label>
|
<summaryFilterItems>
|
<field>Rental_Apply_Equipment_Set_Detail__c.Cancel_Select__c</field>
|
<operation>equals</operation>
|
<value>False</value>
|
</summaryFilterItems>
|
<summaryFilterItems>
|
<field>Rental_Apply_Equipment_Set_Detail__c.Inspection_result_after_F__c</field>
|
<operation>equals</operation>
|
<value></value>
|
</summaryFilterItems>
|
<summaryFilterItems>
|
<field>Rental_Apply_Equipment_Set_Detail__c.Detail_Finish__c</field>
|
<operation>equals</operation>
|
<value>False</value>
|
</summaryFilterItems>
|
<summaryForeignKey>Rental_Apply_Equipment_Set_Detail__c.Rental_Apply_Equipment_Set__c</summaryForeignKey>
|
<summaryOperation>count</summaryOperation>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Summary</type>
|
</fields>
|
<fields>
|
<fullName>Wei_Received_loaner__c</fullName>
|
<externalId>false</externalId>
|
<label>未回收件数</label>
|
<summaryFilterItems>
|
<field>Rental_Apply_Equipment_Set_Detail__c.Check_lost_Item_F__c</field>
|
<operation>notEqual</operation>
|
<value>OK</value>
|
</summaryFilterItems>
|
<summaryFilterItems>
|
<field>Rental_Apply_Equipment_Set_Detail__c.Cancel_Select__c</field>
|
<operation>equals</operation>
|
<value>False</value>
|
</summaryFilterItems>
|
<summaryFilterItems>
|
<field>Rental_Apply_Equipment_Set_Detail__c.Detail_Finish__c</field>
|
<operation>equals</operation>
|
<value>False</value>
|
</summaryFilterItems>
|
<summaryForeignKey>Rental_Apply_Equipment_Set_Detail__c.Rental_Apply_Equipment_Set__c</summaryForeignKey>
|
<summaryOperation>count</summaryOperation>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Summary</type>
|
</fields>
|
<fields>
|
<fullName>Wei_Request_approve_finish__c</fullName>
|
<description>申请的追加附属品状态需要在一览表里自己判</description>
|
<externalId>false</externalId>
|
<label>未追加附属品已批准</label>
|
<summaryFilterItems>
|
<field>Rental_Apply_Equipment_Set_Detail__c.Cancel_Select__c</field>
|
<operation>equals</operation>
|
<value>False</value>
|
</summaryFilterItems>
|
<summaryFilterItems>
|
<field>Rental_Apply_Equipment_Set_Detail__c.ApplyPersonAppended__c</field>
|
<operation>equals</operation>
|
<value>True</value>
|
</summaryFilterItems>
|
<summaryFilterItems>
|
<field>Rental_Apply_Equipment_Set_Detail__c.Add_Request_approval_time__c</field>
|
<operation>equals</operation>
|
<value></value>
|
</summaryFilterItems>
|
<summaryForeignKey>Rental_Apply_Equipment_Set_Detail__c.Rental_Apply_Equipment_Set__c</summaryForeignKey>
|
<summaryOperation>count</summaryOperation>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Summary</type>
|
</fields>
|
<fields>
|
<fullName>Wei_Return_Finish__c</fullName>
|
<externalId>false</externalId>
|
<label>未回寄未完了件数</label>
|
<summaryFilterItems>
|
<field>Rental_Apply_Equipment_Set_Detail__c.Cancel_Select__c</field>
|
<operation>equals</operation>
|
<value>False</value>
|
</summaryFilterItems>
|
<summaryFilterItems>
|
<field>Rental_Apply_Equipment_Set_Detail__c.Return_DeliverySlip_Text__c</field>
|
<operation>equals</operation>
|
<value></value>
|
</summaryFilterItems>
|
<summaryFilterItems>
|
<field>Rental_Apply_Equipment_Set_Detail__c.Detail_Finish__c</field>
|
<operation>equals</operation>
|
<value>False</value>
|
</summaryFilterItems>
|
<summaryForeignKey>Rental_Apply_Equipment_Set_Detail__c.Rental_Apply_Equipment_Set__c</summaryForeignKey>
|
<summaryOperation>count</summaryOperation>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Summary</type>
|
</fields>
|
<fields>
|
<fullName>Wei_Return__c</fullName>
|
<description>欠品的时候不会清除回寄时间
|
不能加出库单的条件，加了的话对状态有影响</description>
|
<externalId>false</externalId>
|
<label>未回寄确认件数</label>
|
<summaryFilterItems>
|
<field>Rental_Apply_Equipment_Set_Detail__c.Asset_return_time__c</field>
|
<operation>equals</operation>
|
<value></value>
|
</summaryFilterItems>
|
<summaryFilterItems>
|
<field>Rental_Apply_Equipment_Set_Detail__c.Cancel_Select__c</field>
|
<operation>equals</operation>
|
<value>False</value>
|
</summaryFilterItems>
|
<summaryForeignKey>Rental_Apply_Equipment_Set_Detail__c.Rental_Apply_Equipment_Set__c</summaryForeignKey>
|
<summaryOperation>count</summaryOperation>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Summary</type>
|
</fields>
|
<fields>
|
<fullName>Wei_Shipment_request__c</fullName>
|
<externalId>false</externalId>
|
<label>未出库指示件数</label>
|
<summaryFilterItems>
|
<field>Rental_Apply_Equipment_Set_Detail__c.Cancel_Select__c</field>
|
<operation>equals</operation>
|
<value>False</value>
|
</summaryFilterItems>
|
<summaryFilterItems>
|
<field>Rental_Apply_Equipment_Set_Detail__c.Shipment_request_time2__c</field>
|
<operation>equals</operation>
|
<value></value>
|
</summaryFilterItems>
|
<summaryForeignKey>Rental_Apply_Equipment_Set_Detail__c.Rental_Apply_Equipment_Set__c</summaryForeignKey>
|
<summaryOperation>count</summaryOperation>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Summary</type>
|
</fields>
|
<fields>
|
<fullName>Wei_StockDown__c</fullName>
|
<externalId>false</externalId>
|
<label>未下架件数</label>
|
<summaryFilterItems>
|
<field>Rental_Apply_Equipment_Set_Detail__c.StockDown__c</field>
|
<operation>equals</operation>
|
<value>False</value>
|
</summaryFilterItems>
|
<summaryFilterItems>
|
<field>Rental_Apply_Equipment_Set_Detail__c.Cancel_Select__c</field>
|
<operation>equals</operation>
|
<value>False</value>
|
</summaryFilterItems>
|
<summaryFilterItems>
|
<field>Rental_Apply_Equipment_Set_Detail__c.AgencyTempCancel__c</field>
|
<operation>equals</operation>
|
<value>False</value>
|
</summaryFilterItems>
|
<summaryForeignKey>Rental_Apply_Equipment_Set_Detail__c.Rental_Apply_Equipment_Set__c</summaryForeignKey>
|
<summaryOperation>count</summaryOperation>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Summary</type>
|
</fields>
|
<fields>
|
<fullName>Wei_loaner_arranged__c</fullName>
|
<externalId>false</externalId>
|
<label>未出库件数</label>
|
<summaryFilterItems>
|
<field>Rental_Apply_Equipment_Set_Detail__c.Cancel_Select__c</field>
|
<operation>equals</operation>
|
<value>False</value>
|
</summaryFilterItems>
|
<summaryFilterItems>
|
<field>Rental_Apply_Equipment_Set_Detail__c.Shippment_loaner_time__c</field>
|
<operation>equals</operation>
|
<value></value>
|
</summaryFilterItems>
|
<summaryForeignKey>Rental_Apply_Equipment_Set_Detail__c.Rental_Apply_Equipment_Set__c</summaryForeignKey>
|
<summaryOperation>count</summaryOperation>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Summary</type>
|
</fields>
|
<fields>
|
<fullName>WorkPlace_Province__c</fullName>
|
<externalId>false</externalId>
|
<formula>Rental_Apply__r.WorkPlace__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>Yi_Arrival_in_wh__c</fullName>
|
<externalId>false</externalId>
|
<formula>RetalFSetDetail_Cnt__c - Wei_Arrival_in_wh__c</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>Yi_Assigned_Cnt__c</fullName>
|
<externalId>false</externalId>
|
<formula>RetalFSetDetail_Cnt__c - Wei_Assigned_Cnt__c</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>Yi_CDS_complete__c</fullName>
|
<externalId>false</externalId>
|
<formula>RetalFSetDetail_Cnt__c - Wei_CDS_complete__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>已回收后已CDS完毕件数</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>Yi_Inspection_not_finish__c</fullName>
|
<externalId>false</externalId>
|
<formula>RetalFSetDetail_Cnt__c - Inspection_not_finish__c</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>Yi_Inspection_result_after_F__c</fullName>
|
<externalId>false</externalId>
|
<formula>RetalFSetDetail_Cnt__c - Wei_Inspection_result_after_F__c</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>Yi_Received_loaner__c</fullName>
|
<externalId>false</externalId>
|
<formula>RetalFSetDetail_Cnt__c - Wei_Received_loaner__c</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>Yi_Return__c</fullName>
|
<externalId>false</externalId>
|
<formula>RetalFSetDetail_Cnt__c - Wei_Return__c</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>Yi_Shipment_request_New__c</fullName>
|
<externalId>false</externalId>
|
<formula>if(RARecordTypeId__c = '01210000000NPGK',null,Yi_Shipment_request__c)</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>Yi_Shipment_request__c</fullName>
|
<externalId>false</externalId>
|
<formula>RetalFSetDetail_Cnt__c - Wei_Shipment_request__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>已出库指示件数(Sys)</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>Yi_StockDown_New__c</fullName>
|
<externalId>false</externalId>
|
<formula>if(RARecordTypeId__c = '01210000000NPGK',null,Yi_StockDown__c)</formula>
|
<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>Yi_StockDown__c</fullName>
|
<externalId>false</externalId>
|
<formula>RetalFSetDetail_Cnt__c - Wei_StockDown__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>已下架件数(Sys)</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>Yi_loaner_arranged__c</fullName>
|
<externalId>false</externalId>
|
<formula>RetalFSetDetail_Cnt__c - Wei_loaner_arranged__c</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>Yigoudaihuo_Final_reply_day_F__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(Demo_purpose2__c=="已购待货" && Not(isblank(Rental_Apply__r.Follow_UP_Opp__r.Shipping_Finished_Day_Func__c)),
|
Rental_Apply__r.Follow_UP_Opp__r.Shipping_Finished_Day_Func__c +14
|
,null
|
)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>最新预定归还日_已购待货_F</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Date</type>
|
</fields>
|
<fields>
|
<fullName>Yigoudaihuo_Final_reply_day_Text__c</fullName>
|
<externalId>false</externalId>
|
<label>最新预定归还日_已购待货</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Date</type>
|
</fields>
|
<fields>
|
<fullName>Yizhouweixiu_Final_reply_day_F__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(NOT((Not(isblank(Rental_Apply__r.Repair__r.Repair_Ordered_Date__c))
|
/* OLY_OCM-645 Start*/
|
/* 一周之内送修 Bollow_Date__c = Shippment_loaner_time2__c */
|
&& (Rental_Apply__r.Repair__r.Repair_Ordered_Date__c <= IF(Rental_Apply__r.Request_demo_day__c < DATEVALUE('2019-07-01'), Bollow_Date__c + 7, Bollow_Date_Add_7_WD__c))
|
)
|
/* OLY_OCM-662 修理受理日为空的情况对应Start */
|
/* 20170901以后已经出库但是7天工作日没有更新的这段时间做一周内送修处理 */
|
|| (Rental_Apply__r.Request_demo_day__c >= DATEVALUE('2019-07-01')
|
&& isblank(Bollow_Date_Add_7_WD__c)
|
&& NOT(isblank(Bollow_Date__c))
|
)
|
/* 修理受理日为空的话如果没超过出库7内的话做一周内送修处理 */
|
|| isblank(Rental_Apply__r.Repair__r.Repair_Ordered_Date__c) && TODAY() <= IF(Rental_Apply__r.Request_demo_day__c < DATEVALUE('2019-07-01'), Bollow_Date__c + 7, Bollow_Date_Add_7_WD__c)
|
/* OLY_OCM-662 修理受理日为空的情况对应End */
|
)
|
/* OLY_OCM-645 End*/
|
&& (Demo_purpose2_T__c == '保修用户' || Demo_purpose2_T__c == '市场多年保修') && Not(ISBLANK(Shippment_loaner_time2__c))
|
, DATEVALUE(Shippment_loaner_time2__c + 14)
|
,null
|
)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>最新预定归还日_一周之内未送修_F</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Date</type>
|
</fields>
|
<fields>
|
<fullName>Yizhouweixiu_Final_reply_day_Text__c</fullName>
|
<externalId>false</externalId>
|
<label>最新预定归还日_一周之内未送修</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Date</type>
|
</fields>
|
<fields>
|
<fullName>Zhu_Ti_Fen_Pei_Jia__c</fullName>
|
<externalId>false</externalId>
|
<label>主体分配(Sys)</label>
|
<length>255</length>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>ZongjianApprovalManager__c</fullName>
|
<deleteConstraint>SetNull</deleteConstraint>
|
<externalId>false</externalId>
|
<label>****总监</label>
|
<referenceTo>User</referenceTo>
|
<relationshipName>Zongjian2dr1</relationshipName>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Lookup</type>
|
</fields>
|
<fields>
|
<fullName>Zsq_Rental_Apply__c</fullName>
|
<deleteConstraint>SetNull</deleteConstraint>
|
<externalId>false</externalId>
|
<label>再申请的原备品</label>
|
<referenceTo>Rental_Apply__c</referenceTo>
|
<relationshipLabel>借出备品配套一览 (再申请)</relationshipLabel>
|
<relationshipName>Zsq_Rental_Apply_YL</relationshipName>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Lookup</type>
|
</fields>
|
<fields>
|
<fullName>applyUser__c</fullName>
|
<deleteConstraint>SetNull</deleteConstraint>
|
<externalId>false</externalId>
|
<label>操作者</label>
|
<referenceTo>User</referenceTo>
|
<relationshipName>SET</relationshipName>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Lookup</type>
|
</fields>
|
<fields>
|
<fullName>asset_extend_approval_day__c</fullName>
|
<externalId>false</externalId>
|
<formula>DATEVALUE( asset_extend_approval_time__c )</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>****延期申请批准日</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Date</type>
|
</fields>
|
<fields>
|
<fullName>asset_extend_approval_time__c</fullName>
|
<externalId>false</externalId>
|
<label>****延期申请批准时间</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>DateTime</type>
|
</fields>
|
<fields>
|
<fullName>canDelete__c</fullName>
|
<defaultValue>false</defaultValue>
|
<externalId>false</externalId>
|
<label>办事处分配替代品删除跳过验证</label>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Checkbox</type>
|
</fields>
|
<fields>
|
<fullName>cancel_after_loaner_arranged__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(TEXT(Rental_Apply__r.Status__c)='取消' &&
|
NOT(ISBLANK(Shipment_request_time__c)), true, false)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>出库指示后取消</label>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Checkbox</type>
|
</fields>
|
<fields>
|
<fullName>cnt_need_abandon__c</fullName>
|
<description>备品用途附属品（文本）等于False</description>
|
<externalId>false</externalId>
|
<label>废弃明细数量-回收后</label>
|
<summaryFilterItems>
|
<field>Rental_Apply_Equipment_Set_Detail__c.Inspection_result_after_NG_F__c</field>
|
<operation>equals</operation>
|
<value>废弃</value>
|
</summaryFilterItems>
|
<summaryFilterItems>
|
<field>Rental_Apply_Equipment_Set_Detail__c.Cancel_Select__c</field>
|
<operation>equals</operation>
|
<value>False</value>
|
</summaryFilterItems>
|
<summaryForeignKey>Rental_Apply_Equipment_Set_Detail__c.Rental_Apply_Equipment_Set__c</summaryForeignKey>
|
<summaryOperation>count</summaryOperation>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Summary</type>
|
</fields>
|
<fields>
|
<fullName>cnt_need_abandon_before__c</fullName>
|
<description>AND 备品用途附属品（文本）等于False</description>
|
<externalId>false</externalId>
|
<label>废弃明细数量-发货前</label>
|
<summaryFilterItems>
|
<field>Rental_Apply_Equipment_Set_Detail__c.Inspection_result_NG__c</field>
|
<operation>equals</operation>
|
<value>废弃</value>
|
</summaryFilterItems>
|
<summaryForeignKey>Rental_Apply_Equipment_Set_Detail__c.Rental_Apply_Equipment_Set__c</summaryForeignKey>
|
<summaryOperation>count</summaryOperation>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Summary</type>
|
</fields>
|
<fields>
|
<fullName>cnt_need_repair__c</fullName>
|
<description>备品用途附属品（文本）等于False</description>
|
<externalId>false</externalId>
|
<label>维修明细数量-回收后</label>
|
<summaryFilterItems>
|
<field>Rental_Apply_Equipment_Set_Detail__c.Inspection_result_after_NG_F__c</field>
|
<operation>equals</operation>
|
<value>维修</value>
|
</summaryFilterItems>
|
<summaryFilterItems>
|
<field>Rental_Apply_Equipment_Set_Detail__c.Cancel_Select__c</field>
|
<operation>equals</operation>
|
<value>False</value>
|
</summaryFilterItems>
|
<summaryForeignKey>Rental_Apply_Equipment_Set_Detail__c.Rental_Apply_Equipment_Set__c</summaryForeignKey>
|
<summaryOperation>count</summaryOperation>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Summary</type>
|
</fields>
|
<fields>
|
<fullName>cnt_need_repair_before__c</fullName>
|
<description>AND 备品用途附属品（文本）等于False</description>
|
<externalId>false</externalId>
|
<label>维修明细数量-发货前</label>
|
<summaryFilterItems>
|
<field>Rental_Apply_Equipment_Set_Detail__c.Inspection_result_NG__c</field>
|
<operation>equals</operation>
|
<value>维修</value>
|
</summaryFilterItems>
|
<summaryForeignKey>Rental_Apply_Equipment_Set_Detail__c.Rental_Apply_Equipment_Set__c</summaryForeignKey>
|
<summaryOperation>count</summaryOperation>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Summary</type>
|
</fields>
|
<fields>
|
<fullName>faraway__c</fullName>
|
<externalId>false</externalId>
|
<formula>Rental_Apply__r.faraway__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>loaner_Status__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(RetalFSetDetail_Cnt__c > 0,
|
IF(Wei_loaner_arranged__c == RetalFSetDetail_Cnt__c,'',
|
IF (AND (Wei_loaner_arranged__c > 0, Wei_loaner_arranged__c < RetalFSetDetail_Cnt__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>loaner_install_num__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(ISBLANK( received_sign_day__c ),0,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>received_sign_day__c</fullName>
|
<externalId>false</externalId>
|
<formula>Rental_Apply__r.HP_received_sign_day__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>用户装机日</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Date</type>
|
</fields>
|
<fields>
|
<fullName>requestNoJoinStr2__c</fullName>
|
<externalId>false</externalId>
|
<formula>Rental_Apply__r.requestNoJoinStr2__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>申请No.用字符2</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>zsqybpyl__c</fullName>
|
<deleteConstraint>SetNull</deleteConstraint>
|
<externalId>false</externalId>
|
<label>再申请的原备品一览</label>
|
<referenceTo>Rental_Apply_Equipment_Set__c</referenceTo>
|
<relationshipLabel>借出备品配套一览 (再申请)</relationshipLabel>
|
<relationshipName>Zsq_Rental_Apply_Set</relationshipName>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Lookup</type>
|
</fields>
|
<label>借出备品配套一览</label>
|
<listViews>
|
<fullName>All</fullName>
|
<columns>Rental_Apply__c</columns>
|
<columns>NAME</columns>
|
<columns>RAES_Status__c</columns>
|
<columns>Account__c</columns>
|
<columns>Loaner_code_F__c</columns>
|
<columns>SerialNumber_F__c</columns>
|
<columns>Request_shipping_day__c</columns>
|
<columns>Final_reply_day__c</columns>
|
<columns>Request_owner__c</columns>
|
<columns>Received_Confirm_NG_Not_Return__c</columns>
|
<columns>Set_Not_Create_Repair_Ordered_Date__c</columns>
|
<columns>Set_Borrow_Date_Fouls__c</columns>
|
<columns>Set_UnSign_Foul_point__c</columns>
|
<columns>SetOrderPoint_sum__c</columns>
|
<filterScope>Everything</filterScope>
|
<filters>
|
<field>SetOrderPoint_sum__c</field>
|
<operation>greaterThan</operation>
|
<value>0</value>
|
</filters>
|
<label>70_违规点数查询</label>
|
<language>zh_CN</language>
|
</listViews>
|
<listViews>
|
<fullName>All_Set</fullName>
|
<columns>NAME</columns>
|
<columns>RAES_Status__c</columns>
|
<columns>Account__c</columns>
|
<columns>Loaner_code_F__c</columns>
|
<columns>SerialNumber_F__c</columns>
|
<columns>Request_shipping_day__c</columns>
|
<columns>Final_reply_day__c</columns>
|
<columns>Rental_Start_Date__c</columns>
|
<columns>Request_owner__c</columns>
|
<columns>applyUser__c</columns>
|
<columns>Request_Status__c</columns>
|
<filterScope>Everything</filterScope>
|
<label>01_所有的备品Set一览</label>
|
<language>zh_CN</language>
|
</listViews>
|
<listViews>
|
<fullName>All_loaner_Losted</fullName>
|
<columns>NAME</columns>
|
<columns>RAES_Status__c</columns>
|
<columns>Account__c</columns>
|
<columns>Loaner_code_F__c</columns>
|
<columns>SerialNumber_F__c</columns>
|
<columns>Request_shipping_day__c</columns>
|
<columns>Final_reply_day__c</columns>
|
<columns>Rental_Start_Date__c</columns>
|
<columns>Request_owner__c</columns>
|
<columns>Request_Status__c</columns>
|
<filterScope>Everything</filterScope>
|
<filters>
|
<field>RAES_Status__c</field>
|
<operation>equals</operation>
|
<value>欠品中</value>
|
</filters>
|
<label>08_欠品中的备品Set一览</label>
|
<language>zh_CN</language>
|
</listViews>
|
<listViews>
|
<fullName>All_loaner_NotShipped</fullName>
|
<columns>NAME</columns>
|
<columns>RAES_Status__c</columns>
|
<columns>Account__c</columns>
|
<columns>Loaner_code_F__c</columns>
|
<columns>SerialNumber_F__c</columns>
|
<columns>Request_shipping_day__c</columns>
|
<columns>Final_reply_day__c</columns>
|
<columns>Rental_Start_Date__c</columns>
|
<columns>Request_owner__c</columns>
|
<columns>Request_Status__c</columns>
|
<filterScope>Everything</filterScope>
|
<filters>
|
<field>RAES_Status__c</field>
|
<operation>equals</operation>
|
<value>已出库指示,已下架,出库前已检测</value>
|
</filters>
|
<label>03_未出库的备品Set一览</label>
|
<language>zh_CN</language>
|
</listViews>
|
<listViews>
|
<fullName>All_loaner_NotShipped_Errored</fullName>
|
<columns>NAME</columns>
|
<columns>RAES_Status__c</columns>
|
<columns>Account__c</columns>
|
<columns>Loaner_code_F__c</columns>
|
<columns>SerialNumber_F__c</columns>
|
<columns>Request_shipping_day__c</columns>
|
<columns>Rental_Start_Date__c</columns>
|
<columns>Final_reply_day__c</columns>
|
<columns>Request_owner__c</columns>
|
<columns>Request_Status__c</columns>
|
<filterScope>Everything</filterScope>
|
<filters>
|
<field>Inspection_before_ng__c</field>
|
<operation>equals</operation>
|
<value>维修</value>
|
</filters>
|
<label>04_出库检查NG的备品Set一览</label>
|
<language>zh_CN</language>
|
</listViews>
|
<listViews>
|
<fullName>All_loaner_ReturnShipped</fullName>
|
<columns>NAME</columns>
|
<columns>RAES_Status__c</columns>
|
<columns>Account__c</columns>
|
<columns>Loaner_code_F__c</columns>
|
<columns>SerialNumber_F__c</columns>
|
<columns>Request_shipping_day__c</columns>
|
<columns>Final_reply_day__c</columns>
|
<columns>Rental_Start_Date__c</columns>
|
<columns>Request_owner__c</columns>
|
<columns>Request_Status__c</columns>
|
<filterScope>Everything</filterScope>
|
<filters>
|
<field>RAES_Status__c</field>
|
<operation>equals</operation>
|
<value>已回寄</value>
|
</filters>
|
<label>07_已回寄的备品Set一览</label>
|
<language>zh_CN</language>
|
</listViews>
|
<listViews>
|
<fullName>All_loaner_Returned</fullName>
|
<columns>NAME</columns>
|
<columns>RAES_Status__c</columns>
|
<columns>Account__c</columns>
|
<columns>Loaner_code_F__c</columns>
|
<columns>SerialNumber_F__c</columns>
|
<columns>Request_shipping_day__c</columns>
|
<columns>Final_reply_day__c</columns>
|
<columns>Rental_Start_Date__c</columns>
|
<columns>Request_owner__c</columns>
|
<columns>Request_Status__c</columns>
|
<filterScope>Everything</filterScope>
|
<filters>
|
<field>RAES_Status__c</field>
|
<operation>equals</operation>
|
<value>已回收,回收后已CDS,回收后已检测</value>
|
</filters>
|
<label>09_已回收的备品Set一览</label>
|
<language>zh_CN</language>
|
</listViews>
|
<listViews>
|
<fullName>All_loaner_Returned_NG</fullName>
|
<columns>NAME</columns>
|
<columns>RAES_Status__c</columns>
|
<columns>Account__c</columns>
|
<columns>Loaner_code_F__c</columns>
|
<columns>SerialNumber_F__c</columns>
|
<columns>Request_shipping_day__c</columns>
|
<columns>Final_reply_day__c</columns>
|
<columns>Rental_Start_Date__c</columns>
|
<columns>Request_owner__c</columns>
|
<columns>Request_Status__c</columns>
|
<filterScope>Everything</filterScope>
|
<filters>
|
<field>RAES_Status__c</field>
|
<operation>equals</operation>
|
<value>回收后检测NG</value>
|
</filters>
|
<label>10_回收后检查NG的备品Set一览</label>
|
<language>zh_CN</language>
|
</listViews>
|
<listViews>
|
<fullName>All_loaner_Selected</fullName>
|
<columns>NAME</columns>
|
<columns>RAES_Status__c</columns>
|
<columns>Account__c</columns>
|
<columns>Loaner_code_F__c</columns>
|
<columns>SerialNumber_F__c</columns>
|
<columns>Request_shipping_day__c</columns>
|
<columns>Final_reply_day__c</columns>
|
<columns>Rental_Start_Date__c</columns>
|
<columns>Request_owner__c</columns>
|
<columns>applyUser__c</columns>
|
<columns>Request_Status__c</columns>
|
<filterScope>Everything</filterScope>
|
<filters>
|
<field>RAES_Status__c</field>
|
<operation>equals</operation>
|
<value>已分配</value>
|
</filters>
|
<label>02_已分配的备品Set一览</label>
|
<language>zh_CN</language>
|
</listViews>
|
<listViews>
|
<fullName>All_loaner_Shipped</fullName>
|
<columns>NAME</columns>
|
<columns>RAES_Status__c</columns>
|
<columns>Account__c</columns>
|
<columns>Loaner_code_F__c</columns>
|
<columns>SerialNumber_F__c</columns>
|
<columns>Request_shipping_day__c</columns>
|
<columns>Final_reply_day__c</columns>
|
<columns>Rental_Start_Date__c</columns>
|
<columns>Request_owner__c</columns>
|
<columns>Request_Status__c</columns>
|
<filterScope>Everything</filterScope>
|
<filters>
|
<field>RAES_Status__c</field>
|
<operation>equals</operation>
|
<value>已出库,申请者已收货,医院已装机确认</value>
|
</filters>
|
<label>05_已出库的备品Set一览</label>
|
<language>zh_CN</language>
|
</listViews>
|
<listViews>
|
<fullName>All_loaner_Stored</fullName>
|
<columns>NAME</columns>
|
<columns>RAES_Status__c</columns>
|
<columns>Account__c</columns>
|
<columns>Loaner_code_F__c</columns>
|
<columns>SerialNumber_F__c</columns>
|
<columns>Request_shipping_day__c</columns>
|
<columns>Final_reply_day__c</columns>
|
<columns>Rental_Start_Date__c</columns>
|
<columns>Request_owner__c</columns>
|
<columns>Request_Status__c</columns>
|
<filterScope>Everything</filterScope>
|
<filters>
|
<field>RAES_Status__c</field>
|
<operation>contains</operation>
|
<value>已回库,待废弃</value>
|
</filters>
|
<label>11_已回库的备品Set一览</label>
|
<language>zh_CN</language>
|
</listViews>
|
<listViews>
|
<fullName>All_loaner_confirm_NG</fullName>
|
<columns>NAME</columns>
|
<columns>RAES_Status__c</columns>
|
<columns>Account__c</columns>
|
<columns>Loaner_code_F__c</columns>
|
<columns>SerialNumber_F__c</columns>
|
<columns>Request_shipping_day__c</columns>
|
<columns>Final_reply_day__c</columns>
|
<columns>Received_Confirm__c</columns>
|
<columns>Received_ng_detail__c</columns>
|
<columns>Request_owner__c</columns>
|
<columns>Request_Status__c</columns>
|
<filterScope>Everything</filterScope>
|
<filters>
|
<field>Received_Confirm__c</field>
|
<operation>equals</operation>
|
<value>NG</value>
|
</filters>
|
<filters>
|
<field>RAES_Status__c</field>
|
<operation>notEqual</operation>
|
<value>已回库,回收后检测NG,回收后已检测,回收后已CDS,已回收,欠品中</value>
|
</filters>
|
<label>06_现场收到确认NG备品Set一览</label>
|
<language>zh_CN</language>
|
</listViews>
|
<nameField>
|
<label>No.</label>
|
<trackHistory>false</trackHistory>
|
<type>Text</type>
|
</nameField>
|
<searchLayouts>
|
<customTabListAdditionalFields>RAES_Status__c</customTabListAdditionalFields>
|
<customTabListAdditionalFields>Request_owner__c</customTabListAdditionalFields>
|
<customTabListAdditionalFields>Account__c</customTabListAdditionalFields>
|
<customTabListAdditionalFields>Loaner_code_text__c</customTabListAdditionalFields>
|
<customTabListAdditionalFields>Rental_Asset_SerialNumber__c</customTabListAdditionalFields>
|
<customTabListAdditionalFields>Request_answer_day__c</customTabListAdditionalFields>
|
<customTabListAdditionalFields>Bollow_Date__c</customTabListAdditionalFields>
|
<customTabListAdditionalFields>Final_reply_day__c</customTabListAdditionalFields>
|
<searchResultsAdditionalFields>RAES_Status__c</searchResultsAdditionalFields>
|
<searchResultsAdditionalFields>Loaner_code_text__c</searchResultsAdditionalFields>
|
<searchResultsAdditionalFields>Loaner_code__c</searchResultsAdditionalFields>
|
<searchResultsAdditionalFields>Rental_Apply__c</searchResultsAdditionalFields>
|
<searchResultsAdditionalFields>Request_owner__c</searchResultsAdditionalFields>
|
<searchResultsAdditionalFields>Demo_purpose1__c</searchResultsAdditionalFields>
|
<searchResultsAdditionalFields>Demo_purpose2__c</searchResultsAdditionalFields>
|
<searchResultsAdditionalFields>Rental_Start_Date__c</searchResultsAdditionalFields>
|
<searchResultsAdditionalFields>Final_reply_day__c</searchResultsAdditionalFields>
|
</searchLayouts>
|
<sharingModel>ControlledByParent</sharingModel>
|
<validationRules>
|
<fullName>Can_Not_Cancel_When_Have_Shipment</fullName>
|
<active>true</active>
|
<description>有出库明细的一览不能取消
|
申请者收货NG的例外</description>
|
<errorConditionFormula>DataMigration_Flag__c == false &&
|
Yi_loaner_arranged__c > 0 &&
|
Cancel_Select__c &&
|
TEXT(Received_Confirm__c) <> 'NG'</errorConditionFormula>
|
<errorMessage>有出库明细的一览不能取消</errorMessage>
|
</validationRules>
|
<validationRules>
|
<fullName>Can_Not_Chagne_Cancel_Reason_ToSubstitut</fullName>
|
<active>true</active>
|
<errorConditionFormula>NOT( ISBLANK(Text(PRIORVALUE(Cancel_Reason__c)))) && Text(PRIORVALUE(Cancel_Reason__c)) != '代替品' && Text(Cancel_Reason__c) = '代替品'</errorConditionFormula>
|
<errorMessage>取消理由不能从别的理由变成代替品</errorMessage>
|
</validationRules>
|
<validationRules>
|
<fullName>Can_Not_Change_Name</fullName>
|
<active>true</active>
|
<errorConditionFormula>DataMigration_Flag__c == false
|
&& Not(ISNEW())
|
&& ISBLANK(Fixture_Set__c)
|
&& ISCHANGED(Name)</errorConditionFormula>
|
<errorMessage>没有备品配套不能修改Name字段</errorMessage>
|
</validationRules>
|
<validationRules>
|
<fullName>Can_Not_Change_Received_Confirm</fullName>
|
<active>true</active>
|
<errorConditionFormula>(ISPICKVAL(Rental_Apply__r.ExtensionStatus__c, '申请中')
|
|| ISPICKVAL(Rental_Apply__r.ExtensionStatus__c, '已批准')
|
|| ISPICKVAL(Rental_Apply__r.ExtensionStatus__c, '驳回')
|
)
|
&& ISCHANGED(Received_Confirm__c)
|
&& Demo_purpose1__c == '产品试用'</errorConditionFormula>
|
<errorDisplayField>Received_Confirm__c</errorDisplayField>
|
<errorMessage>提交延期审批后不能修改现场收到确认结果</errorMessage>
|
</validationRules>
|
<validationRules>
|
<fullName>Cancel_reason_not_null</fullName>
|
<active>true</active>
|
<description>取消的时候，取消理由不能为空</description>
|
<errorConditionFormula>DataMigration_Flag__c == false &&
|
Cancel_Select__c &&
|
NOT(Text(Received_Confirm__c) == 'NG') &&
|
ISBLANK( TEXT(Cancel_Reason__c) )</errorConditionFormula>
|
<errorDisplayField>Cancel_Reason__c</errorDisplayField>
|
<errorMessage>请选择取消理由</errorMessage>
|
</validationRules>
|
<validationRules>
|
<fullName>Cannot_Cancel_When_Application</fullName>
|
<active>true</active>
|
<errorConditionFormula>(ISPICKVAL(Rental_Apply__r.Status__c, '申请中')
|
|| (ISPICKVAL(Rental_Apply__r.Add_Approval_Status__c, '申请中')
|
&& Wei_Request_approve_finish__c > 0
|
)
|
)
|
&& ISCHANGED(Cancel_Select__c)
|
&& Cancel_Select__c = true</errorConditionFormula>
|
<errorDisplayField>Cancel_Select__c</errorDisplayField>
|
<errorMessage>需要撤回申请才能取消</errorMessage>
|
</validationRules>
|
<validationRules>
|
<fullName>Cannot_Change_CancelANDCancelR</fullName>
|
<active>true</active>
|
<errorConditionFormula>DataMigration_Flag__c == false
|
&& PRIORVALUE(Cancel_Select__c)
|
&& (ISCHANGED(Cancel_Select__c)
|
|| ISCHANGED(Cancel_Reason__c))</errorConditionFormula>
|
<errorMessage>取消理由和取消分配Flag设置完了后，不能修改。</errorMessage>
|
</validationRules>
|
<validationRules>
|
<fullName>Cannot_Receive_Without_LogisticInfo</fullName>
|
<active>false</active>
|
<errorConditionFormula>DataMigration_Flag__c == false &&
|
(Received_confirmation_staff2__c = null || Return_Fedex_number2__c = null) &&
|
(RAES_Status__c = '已回收' || RAES_Status__c = '欠品中')</errorConditionFormula>
|
<errorDisplayField>Return_delivery_company2__c</errorDisplayField>
|
<errorMessage>货物运到时，需要填所有的物流信息</errorMessage>
|
</validationRules>
|
<validationRules>
|
<fullName>Cannot_change_rental_end_date</fullName>
|
<active>false</active>
|
<errorConditionFormula>DataMigration_Flag__c == false
|
&& ISNULL(asset_extend_approval_time__c) && ISCHANGED(Rental_End_Date__c)</errorConditionFormula>
|
<errorMessage>延期申请没有批准之前，不能更改“备品预计回收日”</errorMessage>
|
</validationRules>
|
<validationRules>
|
<fullName>Cannot_reply_before_received</fullName>
|
<active>true</active>
|
<errorConditionFormula>/*bp2
|
AND(Send_to_return_email__c = TRUE,
|
OR(
|
NOT(Status_F__c = "已回库,还没通知"),
|
NOT(Status_F__c = "完毕")))
|
*/
|
false</errorConditionFormula>
|
<errorMessage>//bp2 备品还没回库，不可以回收结果反馈邮件</errorMessage>
|
</validationRules>
|
<validationRules>
|
<fullName>First_RAESD_Cannot_Canceled</fullName>
|
<active>true</active>
|
<errorConditionFormula>ISCHANGED(First_RAESD__c)
|
&& First_RAESD__r.Cancel_Select__c == true</errorConditionFormula>
|
<errorDisplayField>First_RAESD__c</errorDisplayField>
|
<errorMessage>请重新刷新该画面。</errorMessage>
|
</validationRules>
|
<validationRules>
|
<fullName>Need_detail_when_confirm_ng</fullName>
|
<active>true</active>
|
<errorConditionFormula>DataMigration_Flag__c == false &&
|
TEXT(Received_Confirm__c) = 'NG' && Received_ng_detail__c = null</errorConditionFormula>
|
<errorMessage>确认结果NG的时候，必须填写详细的异常内容</errorMessage>
|
</validationRules>
|
<validationRules>
|
<fullName>Not_date_over_37_or_47_day_for_trial</fullName>
|
<active>true</active>
|
<description>产品试用(除学会展会和新产品评价外)的时候，不允许入力超过37天(偏远地47天)以上的期间</description>
|
<errorConditionFormula>(ISNew() ||
|
text(Rental_Apply__r.Status__c) = '草案中' ||
|
ISCHANGED(Rental_End_Date__c) ||
|
ISCHANGED(Rental_Start_Date__c)) &&
|
DataMigration_Flag__c == false &&
|
AND(Demo_purpose2__c = "试用（无询价）" || Demo_purpose2__c = '试用（有询价）',
|
OR(AND((Rental_End_Date__c - Rental_Start_Date__c ) > 37, faraway__c = '0'),
|
AND((Rental_End_Date__c - Rental_Start_Date__c ) > 47, faraway__c = '1')
|
)
|
)</errorConditionFormula>
|
<errorDisplayField>Rental_End_Date__c</errorDisplayField>
|
<errorMessage>试用（无询价），试用（有询价）时候，不允许申请超过37天(偏远地47天)以上的期间</errorMessage>
|
</validationRules>
|
<validationRules>
|
<fullName>Not_date_over_90_day_for_newproduct</fullName>
|
<active>true</active>
|
<description>分配画面入力备品预计回收日Check（新产品评价：出货日起90天内）</description>
|
<errorConditionFormula>DataMigration_Flag__c == false
|
&& ((Demo_purpose2__c = "新产品评价")
|
&&(Rental_End_Date__c - Rental_Start_Date__c) > 90)</errorConditionFormula>
|
<errorDisplayField>Rental_End_Date__c</errorDisplayField>
|
<errorMessage>新产品评价时候，不允许入力超过90天以上的期间</errorMessage>
|
</validationRules>
|
<validationRules>
|
<fullName>Received_Confirm_Not_Changed</fullName>
|
<active>true</active>
|
<description>2018/0115: IT修改
|
因为Phase2有分批发货的情况，修改了规则。</description>
|
<errorConditionFormula>DataMigration_Flag__c == false &&
|
($User.ProfileId <>'00e10000000dEQx')&&
|
($User.ProfileId <>'00e10000000xnoT')&&
|
(NOT(CONTAINS($Label.ProfileId_EquCenAdmin, $User.ProfileId)))&&
|
(NOT(CONTAINS($Label.ProfileId_EquCenCheckAndDepot, $User.ProfileId)))&&
|
($User.ProfileId <>'00e10000000Y3o5')&&
|
NOT(ISBLANK(Rental_Apply__r.HP_received_sign_text__c)) &&
|
(ISCHANGED(Received_Confirm__c) ||
|
ISCHANGED(Received_ng_detail__c)
|
)
|
&&
|
NOT(ISBLANK(TEXT(PRIORVALUE(Received_Confirm__c))))</errorConditionFormula>
|
<errorMessage>已上传签收单，不能再修改现场确认收货内容</errorMessage>
|
</validationRules>
|
<validationRules>
|
<fullName>Rental_Asset_SerialNumber_Validation</fullName>
|
<active>false</active>
|
<errorConditionFormula>DataMigration_Flag__c == false &&
|
NOT(ISBLANK(Rental_Asset_SerialNumber__c))
|
&& (ISNEW() || ISCHANGED(Rental_Asset_SerialNumber__c))
|
&& (
|
LEFT(Rental_Asset_SerialNumber__c, 1) <> ","
|
|| RIGHT(Rental_Asset_SerialNumber__c, 1) <> ","
|
|| CONTAINS(Rental_Asset_SerialNumber__c, " ")
|
)</errorConditionFormula>
|
<errorMessage>借出设备机身号码的前后需要「,」、同时不能有「空白」</errorMessage>
|
</validationRules>
|
<validationRules>
|
<fullName>Request_input_extend_day</fullName>
|
<active>true</active>
|
<errorConditionFormula>DataMigration_Flag__c == false &&
|
AND(
|
NOT(ISBLANK(Request_extend_day__c)),
|
ISBLANK(Extend_request_reason__c))</errorConditionFormula>
|
<errorMessage>请输入延期申请理由</errorMessage>
|
</validationRules>
|
<validationRules>
|
<fullName>Start_day_no_bigger_than_end_day</fullName>
|
<active>true</active>
|
<description>[备品预计出货日]必须小于等于[备品预计回收日]</description>
|
<errorConditionFormula>DataMigration_Flag__c == false &&
|
Rental_Start_Date__c > Rental_End_Date__c</errorConditionFormula>
|
<errorDisplayField>Rental_Start_Date__c</errorDisplayField>
|
<errorMessage>[备品预计出货日]必须小于等于[备品预计回收日]</errorMessage>
|
</validationRules>
|
<validationRules>
|
<fullName>UniqueKey_Not_Null</fullName>
|
<active>true</active>
|
<description>借出备品配套一览数据的UniqueKey不允许为空</description>
|
<errorConditionFormula>IsNew() && DataMigration_Flag__c == false &&
|
(ISBLANK(IndexFromUniqueKey__c) || ISBLANK(UniqueKey__c))</errorConditionFormula>
|
<errorMessage>借出备品配套一览数据的UniqueKey不允许为空</errorMessage>
|
</validationRules>
|
<validationRules>
|
<fullName>allow_second_delay</fullName>
|
<active>true</active>
|
<description>维修代用の場合、延長申請を2回できるようにする。</description>
|
<errorConditionFormula>DataMigration_Flag__c == false &&
|
if(Re_Delay_Apply_Date__c!=null
|
, OR(Final_reply_day__c<asset_extend_approval_day__c, Rental_Apply__r.Re_repair__c ==null,
|
(Demo_purpose2__c!='一般用户'&&Demo_purpose2__c!='保修用户'&&Demo_purpose2__c!='市场多年保修'&&Demo_purpose2__c!='再修理')
|
)
|
, false
|
)</errorConditionFormula>
|
<errorMessage>本单不能再次申请延期</errorMessage>
|
</validationRules>
|
<validationRules>
|
<fullName>cannot_hospital_sign_without_site_time</fullName>
|
<active>true</active>
|
<description>当没有收到现场确认处理，不能进行医院收到签字处理；</description>
|
<errorConditionFormula>/*bp2 HP_received_time__c を削除したい
|
ISNULL( Loaner_received_time__c ) && NOT(ISNULL( HP_received_time__c ))
|
*/
|
False</errorConditionFormula>
|
<errorMessage>//bp2 现场签收还没有处理，不能进行医院接受签字处理；请先进行现场签收确认；</errorMessage>
|
</validationRules>
|
<validationRules>
|
<fullName>cannot_update1</fullName>
|
<active>false</active>
|
<description>一般营业，在提交申请后不能修改备品借出历史，出库后回库前可以修改延期相关字段。</description>
|
<errorConditionFormula>NOT($User.EquipmentRentalSpecial__c)
|
&& NOT(ISNEW())
|
&& NOT(ISCHANGED(Repair_Status_Text__c))
|
&& (Request_Status__c <> '草案中'
|
&& NOT(ISNULL(Request_Status__c))
|
&& NOT((Status_F__c = '备品出库'
|
|| Status_F__c = '延期申请'
|
)
|
&& (ISCHANGED(Request_extend_day__c)
|
|| ISCHANGED(Extend_request_reason__c)
|
)
|
)
|
)</errorConditionFormula>
|
<errorMessage>不能更新［借出备品SET一览］</errorMessage>
|
</validationRules>
|
<validationRules>
|
<fullName>cannot_update2</fullName>
|
<active>true</active>
|
<description>备品管理员，在出库指示之后不能修改其他字段，出库后回库前可以修改延期相关字段。</description>
|
<errorConditionFormula>DataMigration_Flag__c == false &&
|
NOT(ISNEW())
|
&& Request_Status__c = '出库指示済'
|
&& NOT(ISCHANGED(Repair_Status_Text__c))
|
/*bp2
|
&& (
|
(
|
ISNULL(Shippment_loaner_time__c)
|
&& NOT(ISCHANGED(Shipment_request_time__c))
|
&& NOT(ISCHANGED(Pre_inspection_time__c))
|
&& NOT(ISCHANGED(Shippment_loaner_time__c))
|
&& NOT(ISCHANGED(Forecast_arrival_day__c))
|
&& NOT(ISCHANGED(Request_asset_extend_time__c))
|
&& NOT(ISCHANGED(asset_extend_approval_time__c))
|
&& NOT(ISCHANGED(Asset_return_time__c))
|
&& NOT(ISCHANGED(Received_loaner_time__c))
|
&& NOT(ISCHANGED(Lost_item_check_time__c))
|
&& NOT(ISCHANGED(CDS_complete_time__c))
|
&& NOT(ISCHANGED(After_Inspection_time__c))
|
&& NOT(ISCHANGED(Arrival_wh_time__c))
|
&& NOT(ISCHANGED(StockDown_time__c))
|
)
|
||
|
(
|
(NOT(ISNULL(Shippment_loaner_time__c))
|
&& ISNULL(Received_loaner_time__c)
|
)
|
&& NOT(ISCHANGED(Shipment_request_time__c))
|
&& NOT(ISCHANGED(Pre_inspection_time__c))
|
&& NOT(ISCHANGED(Shippment_loaner_time__c))
|
&& NOT(ISCHANGED(Forecast_arrival_day__c))
|
&& NOT(ISCHANGED(Request_extend_day__c))
|
&& NOT(ISCHANGED(Extend_request_reason__c))
|
&& NOT(ISCHANGED(Extend_Status__c))
|
&& NOT(ISCHANGED(Request_asset_extend_time__c))
|
&& NOT(ISCHANGED(asset_extend_approval_time__c))
|
&& NOT(ISCHANGED(Asset_return_time__c))
|
&& NOT(ISCHANGED(Received_loaner_time__c))
|
&& NOT(ISCHANGED(Lost_item_check_time__c))
|
&& NOT(ISCHANGED(CDS_complete_time__c))
|
&& NOT(ISCHANGED(After_Inspection_time__c))
|
&& NOT(ISCHANGED(Arrival_wh_time__c))
|
&& NOT(ISCHANGED(StockDown_time__c))
|
)
|
||
|
(
|
NOT(ISNULL(Received_loaner_time__c))
|
&& NOT(ISCHANGED(Shipment_request_time__c))
|
&& NOT(ISCHANGED(Pre_inspection_time__c))
|
&& NOT(ISCHANGED(Shippment_loaner_time__c))
|
&& NOT(ISCHANGED(Forecast_arrival_day__c))
|
&& NOT(ISCHANGED(Request_asset_extend_time__c))
|
&& NOT(ISCHANGED(asset_extend_approval_time__c))
|
&& NOT(ISCHANGED(Asset_return_time__c))
|
&& NOT(ISCHANGED(Received_loaner_time__c))
|
&& NOT(ISCHANGED(Lost_item_check_time__c))
|
&& NOT(ISCHANGED(CDS_complete_time__c))
|
&& NOT(ISCHANGED(After_Inspection_time__c))
|
&& NOT(ISCHANGED(Arrival_wh_time__c))
|
&& NOT(ISCHANGED(StockDown_time__c))
|
)
|
)
|
*/</errorConditionFormula>
|
<errorMessage>//bp2 出库指示后，不能再更新［借出备品SET一览］</errorMessage>
|
</validationRules>
|
<validationRules>
|
<fullName>outTimeVerify</fullName>
|
<active>true</active>
|
<description>点【发货】时，如预计出库日≠今天，则报错且不可进行下一步操作。</description>
|
<errorConditionFormula>AND(RAES_Status__c == '已出库', Rental_Start_Date__c != today())</errorConditionFormula>
|
<errorMessage>预计出库日≠今天</errorMessage>
|
</validationRules>
|
<validationRules>
|
<fullName>rentalNumReduceChk</fullName>
|
<active>true</active>
|
<description>只有状态是草案中时，数量可以变更</description>
|
<errorConditionFormula>DataMigration_Flag__c == false
|
&& Canceled_Id__c = null
|
&& (
|
(Not(IsNew())
|
&& NOT( TEXT(Rental_Apply__r.Status__c) = '草案中' )
|
&& ISCHANGED(Rental_Num__c)
|
&& VF_Rental_Num__c <> Rental_Num__c )
|
|| (IsNew()
|
&& NOT( TEXT(Rental_Apply__r.Status__c) = '草案中' )
|
/*不是早案中并且不是申请者收货NG重新分配的一览时 新建报错*/
|
&& ISBLANK(Canceled_Id__c)
|
)
|
)</errorConditionFormula>
|
<errorDisplayField>Rental_Num__c</errorDisplayField>
|
<errorMessage>只有在草案中的状态下,可以进行数量变更操作</errorMessage>
|
</validationRules>
|
<visibility>Public</visibility>
|
<webLinks>
|
<fullName>Cancel_Select</fullName>
|
<availability>online</availability>
|
<displayType>massActionButton</displayType>
|
<linkType>javascript</linkType>
|
<masterLabel>取消</masterLabel>
|
<openType>onClickJavaScript</openType>
|
<protected>false</protected>
|
<requireRowSelection>false</requireRowSelection>
|
<url>window.open("/apex/EquipmentRentalCancel?raid={!URLENCODE(Rental_Apply__c.Id)}");</url>
|
</webLinks>
|
<webLinks>
|
<fullName>Clear_Return_DeliverySlip</fullName>
|
<availability>online</availability>
|
<displayType>button</displayType>
|
<linkType>javascript</linkType>
|
<masterLabel>清空回寄运输单</masterLabel>
|
<openType>onClickJavaScript</openType>
|
<protected>false</protected>
|
<url>{!RequireScript("/soap/ajax/51.0/connection.js")}
|
{!RequireScript("/soap/ajax/51.0/apex.js")}
|
//2021-10-21 gwy 版本更改为51.0
|
var raesId = "{!Rental_Apply_Equipment_Set__c.Id}";
|
var soql = "Select Id From Rental_Apply_Equipment_Set_Detail__c Where Return_DeliverySlip__c != null AND Check_lost_Item_F__c = null AND Rental_Apply_Equipment_Set__c = '{!Rental_Apply_Equipment_Set__c.Id}' AND Cancel_Select__c = false";
|
|
var result = sforce.connection.query(soql);
|
var objs = result.getArray("records");
|
if (objs.length< 1) {
|
alert('没有需要清空的一览明细');
|
} else {
|
var newraesds = [];
|
for (var i = 0; i < objs.length; i++) {
|
var raesd = new sforce.SObject("Rental_Apply_Equipment_Set_Detail__c");
|
raesd.Id = objs[i].Id;
|
raesd.Return_DeliverySlip__c = null; /*回寄运输单*/
|
raesd.Asset_return_time__c = null; /*回寄时间*/
|
newraesds.push(raesd);
|
}
|
var result = sforce.connection.update(newraesds);
|
if (result[0].getBoolean("success")) {
|
// success
|
alert("回寄运输单信息已清空");
|
setTimeout(function() {
|
location.href = "/{!Rental_Apply_Equipment_Set__c.Id}";
|
}
|
, 100
|
);
|
} else {
|
alert("failed to update:" + result[0].errors.fields + " " + result[0].errors.message);
|
}
|
}</url>
|
</webLinks>
|
<webLinks>
|
<fullName>CustomSubmit</fullName>
|
<availability>online</availability>
|
<displayType>button</displayType>
|
<linkType>javascript</linkType>
|
<masterLabel>提交延期申请</masterLabel>
|
<openType>onClickJavaScript</openType>
|
<protected>false</protected>
|
<url>{!RequireScript("/soap/ajax/51.0/connection.js")}
|
{!RequireScript("/soap/ajax/51.0/apex.js")}
|
{!RequireScript("/resource/CommonUtilJs")}
|
//2021-10-21 gwy 版本更改为51.0
|
var foo = function() {
|
if ('{!Rental_Apply_Equipment_Set__c.Request_extend_day__c}' == ""
|
|| '{!Rental_Apply_Equipment_Set__c.Extend_request_reason__c}' == "") {
|
alert("必须填写延期希望结束日，延期申请理由");
|
return;
|
}
|
|
var rtn = sforce.apex.execute("RentalApplyWebService","postponeCheck",{endDate:'{!Rental_Apply_Equipment_Set__c.Rental_End_Date__c}',d:-5});
|
if (rtn != "OK") {
|
alert(rtn);
|
return;
|
}
|
|
var resultSet = sforce.connection.query("SELECT Id, JingliApprovalManager__c, SalesManager__c, BuchangApprovalManager__c, BuchangApprovalManagerSales__c, ZongjianApprovalManager__c FROM Rental_Apply__c WHERE Id = '{!Rental_Apply_Equipment_Set__c.Rental_ApplyId__c}'");
|
var records = resultSet.getArray("records");
|
|
var rac = new sforce.SObject("Rental_Apply_Equipment_Set__c");
|
rac.Id = "{!Rental_Apply_Equipment_Set__c.Id}";
|
rac.JingliApprovalManager__c = records[0].JingliApprovalManager__c;
|
rac.SalesManager__c = records[0].SalesManager__c;
|
rac.BuchangApprovalManager__c = records[0].BuchangApprovalManager__c;
|
rac.BuchangApprovalManagerSales__c = records[0].BuchangApprovalManagerSales__c;
|
rac.ZongjianApprovalManager__c = records[0].ZongjianApprovalManager__c;
|
rac.Extend_Status__c = "填写完毕";
|
var result = sforce.connection.update([rac]);
|
var messages = getConnectDMLErrorMessages(result);
|
if (messages.length > 0) {
|
alert(messages.join("\n"));
|
return;
|
}
|
|
var request = new sforce.ProcessSubmitRequest();
|
request.objectId = "{!Rental_Apply_Equipment_Set__c.Id}";
|
var processResults = sforce.connection.process([request]);
|
if (processResults[0].errors != null) {
|
alert(processResults[0].errors.message);
|
return;
|
}
|
window.location.reload();
|
}
|
foo();</url>
|
</webLinks>
|
<webLinks>
|
<fullName>EquipmentSetRental_Order</fullName>
|
<availability>online</availability>
|
<displayType>massActionButton</displayType>
|
<linkType>javascript</linkType>
|
<masterLabel>分配</masterLabel>
|
<openType>onClickJavaScript</openType>
|
<protected>false</protected>
|
<requireRowSelection>false</requireRowSelection>
|
<url>{!RequireScript("/soap/ajax/51.0/connection.js")}
|
{!RequireScript("/soap/ajax/51.0/apex.js")}
|
{!RequireScript("/resource/CommonUtilJs")}
|
//2021-10-21 gwy 版本更改为51.0
|
var foo = function() {
|
var raid = '{!Rental_Apply__c.Id}';
|
var rtn = sforce.apex.execute("RentalApplyWebService", "AssignBtn", {Rid: raid});
|
if('{!Rental_Apply__c.Status__c}' == '取消' && '{!Rental_Apply__c.Rental_Apply_Equipment_Set_Cnt__c}' != '0') {
|
window.open("/apex/EquipmentRentalApply?raid={!URLENCODE(Rental_Apply__c.Id)}");
|
}
|
else if(('{!Rental_Apply__c.demo_purpose2__c}' == '学会／展台' || '{!Rental_Apply__c.demo_purpose2__c}' == '课题研究' || '{!Rental_Apply__c.demo_purpose2__c}' == '培训中心')
|
&& '{!Rental_Apply__c.Status__c}' == '草案中') {
|
alert("不能引当，请确认申请的状态");
|
}
|
else if(('{!Rental_Apply__c.demo_purpose2__c}' == '试用（无询价）' || '{!Rental_Apply__c.demo_purpose2__c}' == '试用（有询价）' || '{!Rental_Apply__c.demo_purpose2__c}' == '动物实验' ||
|
'{!Rental_Apply__c.demo_purpose2__c}' == '一般维修代用' ||
|
'{!Rental_Apply__c.demo_purpose2__c}' == '保修合同用户维修代用' ||
|
'{!Rental_Apply__c.demo_purpose2__c}' == '已购待货')
|
&& '{!Rental_Apply__c.Status__c}' != '批准完了'
|
&& '{!Rental_Apply__c.Status__c}' != '引当完了'
|
&& '{!Rental_Apply__c.Status__c}' != '出库指示完了') {
|
alert("不能引当，请确认申请的状态");
|
} else if(rtn == 'Fin') {
|
window.open("/apex/EquipmentRentalApply?raid={!URLENCODE(Rental_Apply__c.Id)}");
|
}else{
|
alert(rtn);
|
}
|
}
|
foo();</url>
|
</webLinks>
|
<webLinks>
|
<fullName>Loaner_arranged_e_mail</fullName>
|
<availability>online</availability>
|
<displayType>button</displayType>
|
<linkType>javascript</linkType>
|
<masterLabel>出库指示</masterLabel>
|
<openType>onClickJavaScript</openType>
|
<protected>false</protected>
|
<url>{!RequireScript("/soap/ajax/51.0/connection.js")}
|
{!RequireScript("/soap/ajax/51.0/apex.js")}
|
//2021-10-21 gwy 版本更改为51.0
|
var buttons = document.getElementsByName('loaner_arranged_e_mail');
|
for (var i=0; i<buttons.length; i++)
|
{
|
buttons[i].className = "btnDisabled";
|
buttons[i].disabled = true;
|
}
|
|
var campaignStatus = '';
|
|
var raliveryGood = new Array();
|
reliveryGood = sforce.connection.query("select Id,Campaign__c,Repair__c,Status__c, Demo_purpose1__c,Contract_pdf_updated__c,Repair_Final_Inspection_Date_F__c,RC_return_to_office__c from Rental_Apply__c where Name='{!Rental_Apply_Equipment_Set__c.Rental_Apply__c}'");
|
var rarecords= reliveryGood.getArray("records");
|
var RentalApply = rarecords[0];
|
|
if(RentalApply.Campaign__c != '' && RentalApply.Campaign__c != null) {
|
var DeliveryGood = new Array();
|
DeliveryGood = sforce.connection.query("select Status, Rental_Apply_Flag__c from Campaign where id ='" + RentalApply.Campaign__c + "'");
|
var records= DeliveryGood.getArray("records");
|
|
campaignStatus = records[0].Status;
|
|
}
|
if("{!Rental_Apply__c.Wei_Assigned_Cnt__c}" > "0") {
|
alert("申请单内存在未分配的配套，请分配备品或分割申请单");
|
}else if(campaignStatus == '取消'){
|
alert("学会取消，不可出库指示");
|
}else if ("{!Rental_Apply_Equipment_Set__c.Assigned_Not_Shipment__c}" == "0") {
|
alert("没有可以出库指示的明细");
|
} else if (RentalApply.Demo_purpose1__c == "长期借出" && RentalApply.Contract_pdf_updated__c == "0") {
|
alert("长期借出时，必须先上传契约书");
|
} else if(RentalApply.Repair__c != '' && RentalApply.Repair__c != null && (RentalApply.Repair_Final_Inspection_Date_F__c != null && RentalApply.Repair_Final_Inspection_Date_F__c != '') || (RentalApply.RC_return_to_office__c != null && RentalApply.RC_return_to_office__c != '')) {
|
alert("修理有最终检测日或修理品返送日，不可出库指示");
|
} else {
|
sforce.connection.sessionId = "{!GETSESSIONID()}";
|
//154p 1388 yc 20211020
|
var raid = RentalApply.Id+";"+"{!Rental_Apply_Equipment_Set__c.Id}";
|
var rs1 = sforce.apex.execute("RentalApplyWebService", "approvalCheck", {rentalApplyId: raid});
|
if (rs1 != '1') {
|
alert(rs1);
|
} else {
|
//bp2 var rs2 = sforce.apex.execute("RentalApplyWebService", "reserve", {rentalApplyId: raid});
|
//bp2 if (rs2 != '1') {
|
//bp2 alert(rs2);
|
//bp2 } else {
|
|
sforce.apex.execute("RentalApplyWebService", "setRaesShipment_request", {raesid: "{!Rental_Apply_Equipment_Set__c.Id}"},function(res) {
|
if (res == "状态更新到已出库指示") {
|
alert("状态更新到已出库指示");
|
print();
|
setTimeout(function() {
|
location.href = "/{!Rental_Apply__c.Id}";
|
}
|
, 100
|
);
|
} else {
|
alert(res);
|
}
|
});
|
//bp2 }
|
}
|
}
|
function print(){
|
var sql;
|
if('{!Rental_Apply__c.Bollow_Date__c}' != ''){
|
sql = "select Id from Rental_Apply_Equipment_Set__c where Rental_Apply__c = '" + RentalApply.Id + "' and Shippment_loaner_time2__c != null and RAES_Status__c != '已分配' and RAES_Status__c != '取消分配'";
|
}else{
|
sql = "select Id from Rental_Apply_Equipment_Set__c where Rental_Apply__c = '" + RentalApply.Id + "' and RAES_Status__c != '已分配' and RAES_Status__c != '取消分配'";
|
}
|
var sqlResult = sforce.connection.query(sql);
|
var records = sqlResult.getArray("records");
|
var size =records.length;
|
var length = size%10 ==0? size/10 : parseInt(size/10) +1;
|
for(var i =0;i<length;i++){
|
window.open('/apex/FixtureRentalPDF?raid=' + RentalApply.Id + '&page=' + i);
|
}
|
}
|
|
|
function fixTime(time){
|
if(time < 10) {time = "0" + time};
|
return time;
|
}
|
function fixDate(date){
|
var Month = fixTime(date.getMonth() + 1);
|
var Day = fixTime(date.getDate());
|
var UTC = date.toUTCString();
|
var Time = UTC.substring(UTC.indexOf(':')-2, UTC.indexOf(':')+6);
|
var Minutes = fixTime(date.getMinutes());
|
var Seconds = fixTime(date.getSeconds());
|
return date.getFullYear() + "-" + Month + "-" + Day + "T" + Time;
|
}</url>
|
</webLinks>
|
<webLinks>
|
<fullName>Reassign</fullName>
|
<availability>online</availability>
|
<displayType>massActionButton</displayType>
|
<linkType>javascript</linkType>
|
<masterLabel>重新分配</masterLabel>
|
<openType>onClickJavaScript</openType>
|
<protected>false</protected>
|
<requireRowSelection>true</requireRowSelection>
|
<url>{!RequireScript("/soap/ajax/51.0/connection.js")}
|
{!RequireScript("/soap/ajax/51.0/apex.js")}
|
//2021-10-21 gwy 版本更改为51.0
|
var records = {!GETRECORDIDS($ObjectType.Rental_Apply_Equipment_Set__c)};
|
|
if (records.length < 1) {
|
alert("请选择借出备品一览");
|
} else {
|
if (confirm("你确定要重新分配吗")) {
|
var rs1 = sforce.apex.execute("RentalApplyEquipmentSetWebService", "rentalApplyEquipmentSetReassign", {raesID : records[0]});
|
|
if (rs1 == "1") {
|
alert("已重新分配");
|
location.reload();
|
} else {
|
alert(rs1);
|
}
|
}
|
}</url>
|
</webLinks>
|
<webLinks>
|
<fullName>RentalApplyJump</fullName>
|
<availability>online</availability>
|
<displayType>massActionButton</displayType>
|
<linkType>javascript</linkType>
|
<masterLabel>插队申请</masterLabel>
|
<openType>onClickJavaScript</openType>
|
<protected>false</protected>
|
<requireRowSelection>true</requireRowSelection>
|
<url>{!RequireScript("/soap/ajax/51.0/connection.js")}
|
{!RequireScript("/soap/ajax/51.0/apex.js")}
|
var foo = function() {
|
// 首先判断是否有此权限
|
var userIdArr = ['00510000001O6HoAAK','00510000001O6I2AAK','00510000000gW9pAAE','00510000000gW9BAAU','00510000008pVbWAAU','00510000001OOMjAAO','00510000005sEEMAA2','00510000004pNOtAAM','00510000005QJ2eAAG','00510000007iCmcAAE','00510000006kIg8AAE','00510000004rbkzAAA','00510000003LMHuAAO','00510000000gW92AAE'];
|
//当前用户登录id
|
var userId = "{!CASESAFEID($User.Id)}";
|
if(userIdArr.indexOf(userId)== -1){
|
alert('对不起你没有此操作的权限！');
|
}else{
|
var records = {!GETRECORDIDS($ObjectType.Rental_Apply_Equipment_Set__c)};
|
if (records.length < 1) {
|
alert("请选择借出备品一览记录");
|
} else {
|
var raid = '{!Rental_Apply__c.Id}';
|
var soql = "select Allow_Adjust_Queue_Flag__c from Rental_Apply_Equipment_Set_Detail__c where Rental_Apply__c='"
|
+ raid + "'";
|
var allRecords = sforce.connection.query(soql).getArray("records");
|
var validSize= allRecords .length;
|
var canJump = false;
|
for(i=0;i<validSize;i++){
|
if(allRecords[i].Allow_Adjust_Queue_Flag__c == true){
|
canJump = true;
|
break;
|
}
|
}
|
if(canJump == true){
|
alert("选择借出备品一览记录有已经允许插队的，请选择未允许的一览");
|
}else{
|
window.open("/apex/RentalApplyJump?objId={!URLENCODE(Rental_Apply__c.Id)}&raesIds="+records, 'RentalApplyJump', 'width=700,height=300');
|
}
|
}
|
}
|
};
|
foo();</url>
|
</webLinks>
|
<webLinks>
|
<fullName>RentalFixtureSetAssign</fullName>
|
<availability>online</availability>
|
<description>申請画面から分配に移ったときは分配が自動提案される。
|
申請者使用目的と本部に基づき、分配可能な備品の用途と所在本部が
|
特定される。备品存放地は、備品センター窓口の所属で決める。</description>
|
<displayType>massActionButton</displayType>
|
<linkType>javascript</linkType>
|
<masterLabel>分配画面</masterLabel>
|
<openType>onClickJavaScript</openType>
|
<protected>false</protected>
|
<requireRowSelection>false</requireRowSelection>
|
<url>{!RequireScript("/soap/ajax/51.0/connection.js")}
|
{!RequireScript("/soap/ajax/51.0/apex.js")}
|
{!RequireScript("/resource/CommonUtilJs")}
|
//2021-10-21 gwy 版本更改为51.0
|
var foo = function() {
|
if('{!Rental_Apply__c.Campaign__c}' != '') {
|
DeliveryGood = sforce.connection.query("select Status, Rental_Apply_Flag__c from Campaign where id ='{!Rental_Apply__c.CampaignId__c}'");
|
var records= DeliveryGood.getArray("records");
|
var campaignStatus = records[0].Status;
|
if(campaignStatus == '取消'){
|
alert("学会取消，不可分配");
|
return;
|
} }
|
|
if('{!Rental_Apply__c.Repair__c}' != '') {
|
if(('{!Rental_Apply__c.Repair_Final_Inspection_Date_F__c}' != null && '{!Rental_Apply__c.Repair_Final_Inspection_Date_F__c}' != '') || ('{!Rental_Apply__c.RC_return_to_office__c}' != null && '{!Rental_Apply__c.RC_return_to_office__c}' != '')){
|
alert("修理有最终检测日或修理品返送日，不可分配");
|
return;
|
} }
|
|
var raid = '{!Rental_Apply__c.Id}';
|
var rtn = sforce.apex.execute("RentalApplyWebService", "AssignBtn", {Rid: raid});
|
if('{!Rental_Apply__c.Status__c}' == '取消' && '{!Rental_Apply__c.Rental_Apply_Equipment_Set_Cnt__c}' != '0') {
|
window.open("/apex/RentalFixtureSetAssign?pt_recid={!URLENCODE(Rental_Apply__c.Id)}");
|
}
|
else if(('{!Rental_Apply__c.demo_purpose2__c}' == '学会展会' || '{!Rental_Apply__c.demo_purpose2__c}' == '课题研究' || '{!Rental_Apply__c.demo_purpose2__c}' == '培训中心')
|
&& '{!Rental_Apply__c.Status__c}' == '草案中') {
|
alert("不能分配，请确认申请的状态");
|
}
|
else if(('{!Rental_Apply__c.demo_purpose2__c}' == '试用（无询价）' || '{!Rental_Apply__c.demo_purpose2__c}' == '试用（有询价）' || '{!Rental_Apply__c.demo_purpose2__c}' == '动物实验' ||
|
'{!Rental_Apply__c.demo_purpose2__c}' == '一般维修代用' ||
|
'{!Rental_Apply__c.demo_purpose2__c}' == '保修合同用户维修代用' ||
|
'{!Rental_Apply__c.demo_purpose2__c}' == '已购待货')
|
&& '{!Rental_Apply__c.Status__c}' != '已批准'
|
//申请书Status__c已经没有 '引当完了' 选项。这里不需要判断(逻辑不变)
|
//&& '{!Rental_Apply__c.Status__c}' != '引当完了'
|
&& '{!Rental_Apply__c.Status__c}' != '已出库指示') {
|
alert("不能分配，请确认申请的状态");
|
} else if(rtn == 'Fin') {
|
window.open("/apex/RentalFixtureSetAssign?pt_recid={!URLENCODE(Rental_Apply__c.Id)}");
|
}else{
|
alert(rtn);
|
}
|
}
|
foo();</url>
|
</webLinks>
|
<webLinks>
|
<fullName>RentalFixtureSetAssignAgency</fullName>
|
<availability>online</availability>
|
<displayType>massActionButton</displayType>
|
<linkType>javascript</linkType>
|
<masterLabel>分配画面(办事处)</masterLabel>
|
<openType>onClickJavaScript</openType>
|
<protected>false</protected>
|
<requireRowSelection>true</requireRowSelection>
|
<url>{!RequireScript("/soap/ajax/51.0/connection.js")}
|
{!RequireScript("/soap/ajax/51.0/apex.js")}
|
{!RequireScript("/resource/CommonUtilJs")}
|
//2021-10-21 gwy 版本更改为51.0
|
var foo = function() {
|
// 20210803 ljh SFDC-C5HDC7 start
|
/*if('{!Rental_Apply__c.Campaign__c}' != '') {
|
DeliveryGood = sforce.connection.query("select Status, Rental_Apply_Flag__c from Campaign where id ='{!Rental_Apply__c.CampaignId__c}'");
|
var records= DeliveryGood.getArray("records");
|
var campaignStatus = records[0].Status;
|
if(campaignStatus == '取消'){
|
alert("学会取消，不可分配");
|
return;
|
}
|
}
|
if('{!Rental_Apply__c.Repair__c}' != '') {
|
if(('{!Rental_Apply__c.Repair_Final_Inspection_Date_F__c}' != null && '{!Rental_Apply__c.Repair_Final_Inspection_Date_F__c}' != '') || ('{!Rental_Apply__c.RC_return_to_office__c}' != null && '{!Rental_Apply__c.RC_return_to_office__c}' != '')){
|
alert("修理有最终检测日或修理品返送日，不可分配");
|
return;
|
}
|
}
|
*/
|
// 20210803 ljh SFDC-C5HDC7 end
|
var raid = '{!Rental_Apply__c.Id}';
|
var rtn = sforce.apex.execute("RentalApplyWebService", "AssignBtn", {Rid: raid});
|
if('{!Rental_Apply__c.Status__c}' == '取消' && '{!Rental_Apply__c.Rental_Apply_Equipment_Set_Cnt__c}' != '0') {
|
window.open("/apex/RentalFixtureSetAssignAgency?pt_recid={!URLENCODE(Rental_Apply__c.Id)}");
|
}
|
else if(('{!Rental_Apply__c.demo_purpose2__c}' == '学会展会' || '{!Rental_Apply__c.demo_purpose2__c}' == '课题研究' || '{!Rental_Apply__c.demo_purpose2__c}' == '培训中心')
|
&& '{!Rental_Apply__c.Status__c}' == '草案中') {
|
alert("不能分配，请确认申请的状态");
|
}
|
else if(('{!Rental_Apply__c.demo_purpose2__c}' == '试用（无询价）' || '{!Rental_Apply__c.demo_purpose2__c}' == '试用（有询价）' || '{!Rental_Apply__c.demo_purpose2__c}' == '动物实验' ||
|
'{!Rental_Apply__c.demo_purpose2__c}' == '一般维修代用' ||
|
'{!Rental_Apply__c.demo_purpose2__c}' == '保修合同用户维修代用' ||
|
'{!Rental_Apply__c.demo_purpose2__c}' == '已购待货')
|
&& '{!Rental_Apply__c.Status__c}' != '已批准'
|
//申请书Status__c已经没有 '引当完了' 选项。这里不需要判断(逻辑不变)
|
//&& '{!Rental_Apply__c.Status__c}' != '引当完了'
|
&& '{!Rental_Apply__c.Status__c}' != '已出库指示') {
|
alert("不能分配，请确认申请的状态");
|
} else if(rtn == 'Fin') {
|
window.open("/apex/RentalFixtureSetAssignAgency?pt_recid={!URLENCODE(Rental_Apply__c.Id)}");
|
}else{
|
alert(rtn);
|
}
|
}
|
foo();</url>
|
</webLinks>
|
<webLinks>
|
<fullName>RentalFixtureSetSelect</fullName>
|
<availability>online</availability>
|
<displayType>massActionButton</displayType>
|
<linkType>javascript</linkType>
|
<masterLabel>选择申请配套</masterLabel>
|
<openType>onClickJavaScript</openType>
|
<protected>false</protected>
|
<requireRowSelection>false</requireRowSelection>
|
<url>{!RequireScript("/soap/ajax/51.0/connection.js")}
|
{!RequireScript("/soap/ajax/51.0/apex.js")}
|
//2021-10-21 gwy 版本更改为51.0
|
window.open("/apex/RentalFixtureSetSelect?pt_recid={!Rental_Apply__c.Id}", "_top");</url>
|
</webLinks>
|
<webLinks>
|
<fullName>Select_Substitute</fullName>
|
<availability>online</availability>
|
<displayType>massActionButton</displayType>
|
<linkType>javascript</linkType>
|
<masterLabel>分配代替品</masterLabel>
|
<openType>onClickJavaScript</openType>
|
<protected>false</protected>
|
<requireRowSelection>true</requireRowSelection>
|
<url>{!RequireScript("/soap/ajax/51.0/connection.js")}
|
{!RequireScript("/soap/ajax/51.0/apex.js")}
|
{!RequireScript("/resource/CommonUtilJs")}
|
//2021-10-21 gwy 版本更改为51.0
|
var records = {!GETRECORDIDS($ObjectType.Rental_Apply_Equipment_Set__c)};
|
|
if (records.length < 1) {
|
alert("请选择一条借出备品一览记录");
|
} else if (records.length > 1) {
|
alert("只能选择一条记录");
|
} else {
|
|
// 可分配代替品前提1 -- 备品借出申请的状态：“已批准”到“已出库指示”
|
if('{!Rental_Apply__c.Status__c}' != '已批准' && '{!Rental_Apply__c.Status__c}' != '已出库指示') {
|
alert('申请书状态不符合分配代替品条件，请确认申请的状态');
|
} else {
|
// 可分配代替品前提2 -- 所选借出备品配套一览的状态：‘已批准’到‘出库前已检测’
|
var soql = "select Cancel_Select__c,Irreplaceable_flag__c,RAES_Status__c,Shippment_loaner_time2__c from Rental_Apply_Equipment_Set__c where Id='"
|
+ records[0] + "'";
|
var soqlRecords = sforce.connection.query(soql).getArray("records");
|
var status = soqlRecords[0].RAES_Status__c;
|
var irreplaceable = soqlRecords[0].Irreplaceable_flag__c;
|
var shipTime = soqlRecords[0].Shippment_loaner_time2__c;
|
|
if(status == "草案中" || status == "申请中" || shipTime != null) {
|
alert("一览的状态不符合分配替代品条件");
|
} else if(irreplaceable=="true") {
|
alert("申请人勾选了代替品不可");
|
} else {
|
window.open("/apex/RentalFixtureSetSelect?pt_recid={!Rental_Apply__c.Id}&raesid="+records[0]);
|
}
|
}
|
|
}</url>
|
</webLinks>
|
<webLinks>
|
<fullName>Split_Apply</fullName>
|
<availability>online</availability>
|
<displayType>massActionButton</displayType>
|
<linkType>javascript</linkType>
|
<masterLabel>分单</masterLabel>
|
<openType>onClickJavaScript</openType>
|
<protected>false</protected>
|
<requireRowSelection>true</requireRowSelection>
|
<url>{!RequireScript("/soap/ajax/51.0/connection.js")}
|
{!RequireScript("/soap/ajax/51.0/apex.js")}
|
//2021-10-21 gwy 版本更改为51.0
|
var foo = function() {
|
var records = {!GETRECORDIDS($ObjectType.Rental_Apply_Equipment_Set__c)};
|
if (records.length < 1) {
|
alert("请选择借出备品一览记录");
|
} else {
|
//弹框选择 分单到办事处OR备品中心
|
window.open("/apex/RentalApplySplit?objId={!URLENCODE(Rental_Apply__c.Id)}&raesIds="+records, 'RentalApplySplit', 'width=600,height=200');
|
}
|
};
|
foo()</url>
|
</webLinks>
|
<webLinks>
|
<fullName>Unassign</fullName>
|
<availability>online</availability>
|
<displayType>massActionButton</displayType>
|
<linkType>javascript</linkType>
|
<masterLabel>取消分配</masterLabel>
|
<openType>onClickJavaScript</openType>
|
<protected>false</protected>
|
<requireRowSelection>true</requireRowSelection>
|
<url>{!RequireScript("/soap/ajax/51.0/connection.js")}
|
{!RequireScript("/soap/ajax/51.0/apex.js")}
|
//2021-10-21 gwy 版本更改为51.0
|
var foo = function() {
|
var records = {!GETRECORDIDS($ObjectType.Rental_Apply_Equipment_Set__c)};
|
if (records.length < 1) {
|
window.open("/apex/EquipmentRentalUnassign?raId={!URLENCODE(Rental_Apply__c.Id)}");
|
} else {
|
//弹框选择
|
window.open("/apex/EquipmentRentalUnassign?raId={!URLENCODE(Rental_Apply__c.Id)}&EquipmentId="+records);
|
}
|
};
|
foo()</url>
|
</webLinks>
|
<webLinks>
|
<fullName>refresh_status</fullName>
|
<availability>online</availability>
|
<description>From 借出Set</description>
|
<displayType>button</displayType>
|
<linkType>javascript</linkType>
|
<masterLabel>状态即时更新</masterLabel>
|
<openType>onClickJavaScript</openType>
|
<protected>false</protected>
|
<url>{!RequireScript("/soap/ajax/51.0/connection.js")}
|
{!RequireScript("/soap/ajax/51.0/apex.js")}
|
//2021-10-21 gwy 版本更改为51.0
|
var raeSet = '{!Rental_Apply_Equipment_Set__c.Id}';
|
try {
|
var rtn = sforce.apex.execute("RentalApplyWebService", "eSetRefreshStatus", {raeSetId: raeSet});
|
if (rtn = '1') {
|
alert("状态更新完毕!");
|
location.href = "/{!Rental_Apply_Equipment_Set__c.Id}";
|
} else {
|
alert(rtn);
|
}
|
} catch(e) {
|
alert(e);
|
}</url>
|
</webLinks>
|
</CustomObject>
|
