<?xml version="1.0" encoding="UTF-8"?>
|
<CustomObject xmlns="http://soap.sforce.com/2006/04/metadata">
|
<actionOverrides>
|
<actionName>Accept</actionName>
|
<type>Default</type>
|
</actionOverrides>
|
<actionOverrides>
|
<actionName>CancelEdit</actionName>
|
<type>Default</type>
|
</actionOverrides>
|
<actionOverrides>
|
<actionName>Clone</actionName>
|
<type>Default</type>
|
</actionOverrides>
|
<actionOverrides>
|
<actionName>Delete</actionName>
|
<type>Default</type>
|
</actionOverrides>
|
<actionOverrides>
|
<actionName>Edit</actionName>
|
<type>Default</type>
|
</actionOverrides>
|
<actionOverrides>
|
<actionName>List</actionName>
|
<type>Default</type>
|
</actionOverrides>
|
<actionOverrides>
|
<actionName>New</actionName>
|
<type>Default</type>
|
</actionOverrides>
|
<actionOverrides>
|
<actionName>SaveEdit</actionName>
|
<type>Default</type>
|
</actionOverrides>
|
<actionOverrides>
|
<actionName>Tab</actionName>
|
<type>Default</type>
|
</actionOverrides>
|
<actionOverrides>
|
<actionName>View</actionName>
|
<type>Default</type>
|
</actionOverrides>
|
<allowInChatterGroups>false</allowInChatterGroups>
|
<compactLayoutAssignment>SYSTEM</compactLayoutAssignment>
|
<deploymentStatus>Deployed</deploymentStatus>
|
<enableActivities>true</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>Private</externalSharingModel>
|
<fields>
|
<fullName>AccountParentId__c</fullName>
|
<externalId>false</externalId>
|
<formula>Account__r.ParentId</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>AccountParentId</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>AccountParentParentId__c</fullName>
|
<externalId>false</externalId>
|
<formula>Strategic_dept__r.ParentId</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>AccountParentParentId</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Account_ID__c</fullName>
|
<externalId>false</externalId>
|
<formula>Account__r.Id</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>科室ID</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Account__c</fullName>
|
<deleteConstraint>SetNull</deleteConstraint>
|
<externalId>false</externalId>
|
<label>科室</label>
|
<lookupFilter>
|
<active>true</active>
|
<filterItems>
|
<field>Account.RecordTypeId</field>
|
<operation>equals</operation>
|
<value>診療科 その他, 診療科 呼吸科, 診療科 婦人科, 診療科 普外科, 診療科 泌尿科, 診療科 消化科, 診療科 耳鼻喉科</value>
|
</filterItems>
|
<isOptional>true</isOptional>
|
</lookupFilter>
|
<referenceTo>Account</referenceTo>
|
<relationshipName>Rental_Apply_AccountConsum</relationshipName>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Lookup</type>
|
</fields>
|
<fields>
|
<fullName>Address_Level1_Id__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF (Not(IsBlank(Hospital__c)),
|
Hospital__r.State_Master__c,
|
IF (Not(IsBlank(Campaign__c)),
|
Campaign__r.Internal_in_charge_province__c,
|
Account__r.State_Master__c
|
))</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>住所阶层1_Id</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>All_Delivery_Flag_c__c</fullName>
|
<defaultValue>false</defaultValue>
|
<description>全部出库和部分出库区分标示：全部出库 true 部分出库 false</description>
|
<externalId>false</externalId>
|
<label>全部出库标志</label>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Checkbox</type>
|
</fields>
|
<fields>
|
<fullName>AnimalExerimentFlag__c</fullName>
|
<defaultValue>false</defaultValue>
|
<externalId>false</externalId>
|
<inlineHelpText>动物实验的时候必须钩</inlineHelpText>
|
<label>动物实验</label>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Checkbox</type>
|
</fields>
|
<fields>
|
<fullName>Answer_for_request__c</fullName>
|
<externalId>false</externalId>
|
<label>耗材回答</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>TextArea</type>
|
</fields>
|
<fields>
|
<fullName>Application_accept_day__c</fullName>
|
<externalId>false</externalId>
|
<formula>DATEVALUE(Application_accept_time__c)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<inlineHelpText>首次应答沟通后请刷新页面</inlineHelpText>
|
<label>申请受理日(回答日)</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Date</type>
|
</fields>
|
<fields>
|
<fullName>Application_accept_time__c</fullName>
|
<externalId>false</externalId>
|
<inlineHelpText>首次应答沟通后请刷新页面</inlineHelpText>
|
<label>申请受理时间(回答时间)</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>DateTime</type>
|
</fields>
|
<fields>
|
<fullName>ApplyPerson_Phone__c</fullName>
|
<externalId>false</externalId>
|
<label>申请人电话</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Phone</type>
|
</fields>
|
<fields>
|
<fullName>Arrival_wh_cnt__c</fullName>
|
<externalId>false</externalId>
|
<label>已回库件数</label>
|
<summaryFilterItems>
|
<field>Consum_Apply_Equipment_Set__c.Wei_loaner_arranged__c</field>
|
<operation>equals</operation>
|
<value>0</value>
|
</summaryFilterItems>
|
<summaryFilterItems>
|
<field>Consum_Apply_Equipment_Set__c.Cancel_Select__c</field>
|
<operation>equals</operation>
|
<value>False</value>
|
</summaryFilterItems>
|
<summaryFilterItems>
|
<field>Consum_Apply_Equipment_Set__c.Yi_Arrival_in_wh__c</field>
|
<operation>greaterThan</operation>
|
<value>0</value>
|
</summaryFilterItems>
|
<summaryForeignKey>Consum_Apply_Equipment_Set__c.Consum_Apply__c</summaryForeignKey>
|
<summaryOperation>count</summaryOperation>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Summary</type>
|
</fields>
|
<fields>
|
<fullName>AssetManageConfirmYN__c</fullName>
|
<description>为了备品申请月报</description>
|
<externalId>false</externalId>
|
<formula>IF( AssetManageConfirm__c =true, '是', '否')</formula>
|
<label>备品中心确认YN</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>AssetManageConfirm__c</fullName>
|
<defaultValue>false</defaultValue>
|
<externalId>false</externalId>
|
<label>备品中心确认</label>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Checkbox</type>
|
</fields>
|
<fields>
|
<fullName>Asset_loaner_start_date__c</fullName>
|
<externalId>false</externalId>
|
<label>预计使用日</label>
|
<summarizedField>Consum_Apply_Equipment_Set__c.Consum_Start_Date__c</summarizedField>
|
<summaryForeignKey>Consum_Apply_Equipment_Set__c.Consum_Apply__c</summaryForeignKey>
|
<summaryOperation>max</summaryOperation>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Summary</type>
|
</fields>
|
<fields>
|
<fullName>Asset_return_Status__c</fullName>
|
<externalId>false</externalId>
|
<formula>/* OLY_OCM-451 start 王硕修改*/
|
IF(Lost_item_Return_Flag__c, '欠品归还 ',
|
IF(Consum_Apply_Equipment_Set_Cnt__c > 0,
|
IF(Wei_Return_Cnt__c > 0, '部分归还'
|
, '全部归还'
|
)
|
,''
|
)
|
)
|
/* OLY_OCM-451 end 王硕修改 */</formula>
|
<label>回寄状态(Sys)</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Asset_return_Text__c</fullName>
|
<externalId>false</externalId>
|
<label>回寄通知（文本）</label>
|
<length>65535</length>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Html</type>
|
<visibleLines>10</visibleLines>
|
</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_ng_num__c</fullName>
|
<externalId>false</externalId>
|
<label>归还发送未完了数</label>
|
<summaryFilterItems>
|
<field>Consum_Apply_Equipment_Set__c.Asset_return_time__c</field>
|
<operation>equals</operation>
|
<value></value>
|
</summaryFilterItems>
|
<summaryFilterItems>
|
<field>Consum_Apply_Equipment_Set__c.Cancel_Select__c</field>
|
<operation>equals</operation>
|
<value>False</value>
|
</summaryFilterItems>
|
<summaryForeignKey>Consum_Apply_Equipment_Set__c.Consum_Apply__c</summaryForeignKey>
|
<summaryOperation>count</summaryOperation>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Summary</type>
|
</fields>
|
<fields>
|
<fullName>Asset_return_time__c</fullName>
|
<externalId>false</externalId>
|
<label>回寄时间</label>
|
<summarizedField>Consum_Apply_Equipment_Set__c.Asset_return_time__c</summarizedField>
|
<summaryFilterItems>
|
<field>Consum_Apply_Equipment_Set__c.Asset_return_time__c</field>
|
<operation>notEqual</operation>
|
<value></value>
|
</summaryFilterItems>
|
<summaryForeignKey>Consum_Apply_Equipment_Set__c.Consum_Apply__c</summaryForeignKey>
|
<summaryOperation>min</summaryOperation>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Summary</type>
|
</fields>
|
<fields>
|
<fullName>Assign_Person__c</fullName>
|
<deleteConstraint>SetNull</deleteConstraint>
|
<description>分配时设置，有值之后不重新设置
|
先上线字段，用于Powerbi</description>
|
<externalId>false</externalId>
|
<label>分配人</label>
|
<referenceTo>User</referenceTo>
|
<relationshipName>Assign_PersonConsum</relationshipName>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Lookup</type>
|
</fields>
|
<fields>
|
<fullName>Assigned_Count__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>Assigned_Hash__c</fullName>
|
<externalId>false</externalId>
|
<label>分配通知（Hash）</label>
|
<length>255</length>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Assigned_Not_Shipment__c</fullName>
|
<externalId>false</externalId>
|
<label>已分配未出库指示</label>
|
<summarizedField>Consum_Apply_Equipment_Set__c.Assigned_Not_Shipment__c</summarizedField>
|
<summaryFilterItems>
|
<field>Consum_Apply_Equipment_Set__c.Cancel_Select__c</field>
|
<operation>equals</operation>
|
<value>False</value>
|
</summaryFilterItems>
|
<summaryForeignKey>Consum_Apply_Equipment_Set__c.Consum_Apply__c</summaryForeignKey>
|
<summaryOperation>sum</summaryOperation>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Summary</type>
|
</fields>
|
<fields>
|
<fullName>Assigned_Text__c</fullName>
|
<externalId>false</externalId>
|
<label>分配通知（文本）</label>
|
<length>65535</length>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Html</type>
|
<visibleLines>10</visibleLines>
|
</fields>
|
<fields>
|
<fullName>BRId__c</fullName>
|
<externalId>false</externalId>
|
<label>BRId</label>
|
<length>18</length>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</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_time__c )</formula>
|
<inlineHelpText>初次备品出库日</inlineHelpText>
|
<label>备品中心出库日</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Date</type>
|
</fields>
|
<fields>
|
<fullName>Branch__c</fullName>
|
<externalId>false</externalId>
|
<formula>text(Owner:User.Branch__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>Branch_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>BuchangApprovalManagerSales__c</fullName>
|
<deleteConstraint>SetNull</deleteConstraint>
|
<externalId>false</externalId>
|
<label>部长</label>
|
<referenceTo>User</referenceTo>
|
<relationshipName>BuchangSalesKr1RConsum</relationshipName>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Lookup</type>
|
</fields>
|
<fields>
|
<fullName>BuchangApprovalManagerSales_eq_Zongjian__c</fullName>
|
<externalId>false</externalId>
|
<formula>Is_Special_Rental__c
|
&& BuchangApprovalManagerSales__c = ZongjianApprovalManager__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>部长=总监</label>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Checkbox</type>
|
</fields>
|
<fields>
|
<fullName>BuchangApprovalManager__c</fullName>
|
<deleteConstraint>SetNull</deleteConstraint>
|
<externalId>false</externalId>
|
<label>部长(服务)</label>
|
<referenceTo>User</referenceTo>
|
<relationshipName>BuchangKr1bConsum</relationshipName>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Lookup</type>
|
</fields>
|
<fields>
|
<fullName>BuchangApprovalManager_eq_Zongjian__c</fullName>
|
<externalId>false</externalId>
|
<formula>BuchangApprovalManager__c = ZongjianApprovalManager__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>部长(服务)=总监</label>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Checkbox</type>
|
</fields>
|
<fields>
|
<fullName>CC_EmailUser__c</fullName>
|
<deleteConstraint>SetNull</deleteConstraint>
|
<externalId>false</externalId>
|
<label>CC用户</label>
|
<referenceTo>User</referenceTo>
|
<relationshipName>RA_CC_EmailUserConsum</relationshipName>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Lookup</type>
|
</fields>
|
<fields>
|
<fullName>Calendar_start_date__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(ISBLANK(Asset_loaner_start_date__c), TODAY(), IF(Asset_loaner_start_date__c < TODAY(), Asset_loaner_start_date__c, TODAY()))</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>日历开始日</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Date</type>
|
</fields>
|
<fields>
|
<fullName>CampaignMeeting_Type__c</fullName>
|
<externalId>false</externalId>
|
<formula>TEXT( Campaign__r.Meeting_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>CampaignOpen_scope__c</fullName>
|
<externalId>false</externalId>
|
<formula>TEXT(Campaign__r.Open_scope__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>Campaign_EndDate_F__c</fullName>
|
<externalId>false</externalId>
|
<formula>Campaign__r.EndDate</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>学会展会结束日F</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Date</type>
|
</fields>
|
<fields>
|
<fullName>Campaign_Num__c</fullName>
|
<externalId>false</externalId>
|
<formula>Campaign__r.Num__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>Campaign__c</fullName>
|
<deleteConstraint>SetNull</deleteConstraint>
|
<externalId>false</externalId>
|
<label>学会</label>
|
<referenceTo>Campaign</referenceTo>
|
<relationshipName>Rental_Apply_CampaignConsum</relationshipName>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Lookup</type>
|
</fields>
|
<fields>
|
<fullName>Cancel_Reason__c</fullName>
|
<externalId>false</externalId>
|
<label>取消理由</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Picklist</type>
|
<valueSet>
|
<restricted>true</restricted>
|
<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>
|
<externalId>false</externalId>
|
<label>取消件数</label>
|
<summaryFilterItems>
|
<field>Consum_Apply_Equipment_Set__c.Cancel_Reason__c</field>
|
<operation>notEqual</operation>
|
<value></value>
|
</summaryFilterItems>
|
<summaryForeignKey>Consum_Apply_Equipment_Set__c.Consum_Apply__c</summaryForeignKey>
|
<summaryOperation>count</summaryOperation>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Summary</type>
|
</fields>
|
<fields>
|
<fullName>Cancel_date__c</fullName>
|
<externalId>false</externalId>
|
<formula>DATEVALUE( Cancel_time__c )</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>备品申请取消日</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Date</type>
|
</fields>
|
<fields>
|
<fullName>Cancel_time__c</fullName>
|
<externalId>false</externalId>
|
<label>备品申请取消时间</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>DateTime</type>
|
</fields>
|
<fields>
|
<fullName>Cant_Ship_All_Mail_Time__c</fullName>
|
<externalId>false</externalId>
|
<label>没有全部出库通知送信时间</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>DateTime</type>
|
</fields>
|
<fields>
|
<fullName>Cant_Ship_All__c</fullName>
|
<externalId>false</externalId>
|
<formula>Shipment_requested_cnt__c < Consum_Apply_Equipment_Set_Cnt__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>无法全部出库</label>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Checkbox</type>
|
</fields>
|
<fields>
|
<fullName>Category5_F__c</fullName>
|
<externalId>false</externalId>
|
<formula>Owner:User.Category5__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>ConsumApplyRemind_Text__c</fullName>
|
<defaultValue>$Label.ConsumApplyRemind</defaultValue>
|
<externalId>false</externalId>
|
<label>耗材申请日期提醒</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>TextArea</type>
|
</fields>
|
<fields>
|
<fullName>ConsumApplyRemind__c</fullName>
|
<externalId>false</externalId>
|
<label>耗材申请日期提醒</label>
|
<length>32768</length>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Html</type>
|
<visibleLines>25</visibleLines>
|
</fields>
|
<fields>
|
<fullName>Consum_Apply_Detail_ForEmail__c</fullName>
|
<externalId>false</externalId>
|
<label>邮件-耗材申请明细内容</label>
|
<length>32768</length>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>LongTextArea</type>
|
<visibleLines>10</visibleLines>
|
</fields>
|
<fields>
|
<fullName>Consum_Apply_Equipment_Set_Cnt__c</fullName>
|
<externalId>false</externalId>
|
<label>耗材备品SET一览总件数</label>
|
<summaryFilterItems>
|
<field>Consum_Apply_Equipment_Set__c.Cancel_Reason__c</field>
|
<operation>equals</operation>
|
<value></value>
|
</summaryFilterItems>
|
<summaryForeignKey>Consum_Apply_Equipment_Set__c.Consum_Apply__c</summaryForeignKey>
|
<summaryOperation>count</summaryOperation>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Summary</type>
|
</fields>
|
<fields>
|
<fullName>Consum_Apply_Equipment_Set_Detail_Cnt__c</fullName>
|
<externalId>false</externalId>
|
<label>耗材备品配套一览明细总件数</label>
|
<summarizedField>Consum_Apply_Equipment_Set__c.RetalFSetDetail_Cnt__c</summarizedField>
|
<summaryFilterItems>
|
<field>Consum_Apply_Equipment_Set__c.Cancel_Reason__c</field>
|
<operation>equals</operation>
|
<value></value>
|
</summaryFilterItems>
|
<summaryForeignKey>Consum_Apply_Equipment_Set__c.Consum_Apply__c</summaryForeignKey>
|
<summaryOperation>sum</summaryOperation>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Summary</type>
|
</fields>
|
<fields>
|
<fullName>Consum_Assistant2__c</fullName>
|
<deleteConstraint>SetNull</deleteConstraint>
|
<externalId>false</externalId>
|
<label>耗材备品助理2</label>
|
<referenceTo>User</referenceTo>
|
<relationshipName>RqAss2Consum</relationshipName>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Lookup</type>
|
</fields>
|
<fields>
|
<fullName>Consum_Assistant3__c</fullName>
|
<deleteConstraint>SetNull</deleteConstraint>
|
<externalId>false</externalId>
|
<label>耗材备品助理3</label>
|
<referenceTo>User</referenceTo>
|
<relationshipName>RqAss3Consum</relationshipName>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Lookup</type>
|
</fields>
|
<fields>
|
<fullName>Consum_Assistant__c</fullName>
|
<deleteConstraint>SetNull</deleteConstraint>
|
<externalId>false</externalId>
|
<label>耗材备品助理</label>
|
<referenceTo>User</referenceTo>
|
<relationshipName>RentalAssistantConsum</relationshipName>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Lookup</type>
|
</fields>
|
<fields>
|
<fullName>Consum_Received_Day__c</fullName>
|
<externalId>false</externalId>
|
<label>到货签收确认日</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Date</type>
|
</fields>
|
<fields>
|
<fullName>Consum_Trial_Email_First_Time__c</fullName>
|
<externalId>false</externalId>
|
<label>邮件-上传试用表邮件首次发送时间</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>DateTime</type>
|
</fields>
|
<fields>
|
<fullName>Consum_Trial_Table__c</fullName>
|
<externalId>false</externalId>
|
<label>试用表</label>
|
<length>32768</length>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Html</type>
|
<visibleLines>10</visibleLines>
|
</fields>
|
<fields>
|
<fullName>Consum_Trial_Update_Time__c</fullName>
|
<externalId>false</externalId>
|
<label>耗材试用表上传时间</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>DateTime</type>
|
</fields>
|
<fields>
|
<fullName>Consum_Trial_Update_Time_c__c</fullName>
|
<externalId>false</externalId>
|
<label>耗材试用表上传时间</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>DateTime</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>Dealer__c</fullName>
|
<deleteConstraint>SetNull</deleteConstraint>
|
<externalId>false</externalId>
|
<label>经销商</label>
|
<referenceTo>Account</referenceTo>
|
<relationshipName>rentalApply_DealerConsum</relationshipName>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Lookup</type>
|
</fields>
|
<fields>
|
<fullName>DeliveryCombine_Pack__c</fullName>
|
<externalId>false</externalId>
|
<formula>DeliverySlip__r.Combine_Pack_P1__c & DeliverySlip__r.Combine_Pack_P2__c & DeliverySlip__r.Combine_Pack_P3__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>DeliverySlip__c</fullName>
|
<deleteConstraint>SetNull</deleteConstraint>
|
<externalId>false</externalId>
|
<label>发货运输单</label>
|
<referenceTo>FixtureDeliverySlip__c</referenceTo>
|
<relationshipName>Rental_ApplyConsum</relationshipName>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Lookup</type>
|
</fields>
|
<fields>
|
<fullName>Delivery_Company_New__c</fullName>
|
<externalId>false</externalId>
|
<formula>TEXT(DeliverySlip__r.DeliveryCompany__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>Delivery_Detail_ForEmail__c</fullName>
|
<externalId>false</externalId>
|
<label>邮件-发货明细内容</label>
|
<length>32768</length>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>LongTextArea</type>
|
<visibleLines>3</visibleLines>
|
</fields>
|
<fields>
|
<fullName>Delivery_Distributor_Method__c</fullName>
|
<externalId>false</externalId>
|
<formula>TEXT(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>Delivery_to_wh_staff__c</fullName>
|
<externalId>false</externalId>
|
<formula>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>Demo_purpose_text__c</fullName>
|
<externalId>false</externalId>
|
<label>申请理由</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>TextArea</type>
|
</fields>
|
<fields>
|
<fullName>Department_name__c</fullName>
|
<externalId>false</externalId>
|
<formula>Account__r.Department_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>Dept_PowerBi__c</fullName>
|
<externalId>false</externalId>
|
<formula>CASE( Salesdept_text__c ,
|
'医疗东北营业本部', '1.医疗东北营业本部',
|
'医疗西北营业本部', '2.医疗西北营业本部',
|
'医疗华北营业本部', '3.医疗华北营业本部',
|
'医疗西南营业本部', '4.医疗西南营业本部',
|
'医疗华南营业本部', '5.医疗华南营业本部',
|
'医疗华东营业本部', '6.医疗华东营业本部',
|
'消化·呼吸内镜事业本部', '7.消化·呼吸内镜事业本部',
|
'外科事业本部', '8.外科事业本部',
|
'能量事业本部', '9.能量事业本部',
|
'医疗产品培训本部', '10.医疗产品培训本部',
|
'MA本部', '11.MA本部',
|
'医疗服务本部', '12.医疗服务本部',
|
'医疗备品管理中心', '13.医疗备品管理中心',
|
'')</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>本部（PowerBi）</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Email_Consum_Apply_Equipment_Set__c</fullName>
|
<externalId>false</externalId>
|
<label>邮件用耗材备品一览中文名</label>
|
<length>131072</length>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Html</type>
|
<visibleLines>10</visibleLines>
|
</fields>
|
<fields>
|
<fullName>Equipment_Type_F__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(ISPICKVAL(demo_purpose2__c,'试用（无询价）'), '产品试用',
|
IF(ISPICKVAL(demo_purpose2__c,'试用（有询价）'), '产品试用',
|
IF(ISPICKVAL(demo_purpose2__c,'新产品评价'), '产品试用',
|
IF(ISPICKVAL(demo_purpose2__c,'学会展会'), '学会展会,产品试用',
|
IF(ISPICKVAL(demo_purpose2__c,'已购待货'), '产品试用',
|
IF(ISPICKVAL(demo_purpose2__c,'索赔QIS'), '维修代用（保修合同）',
|
IF(ISPICKVAL(demo_purpose2__c,'再修理'), '维修代用（一般维修）',
|
IF(ISPICKVAL(demo_purpose2__c,'保修用户'), '维修代用（保修合同）',
|
IF(ISPICKVAL(demo_purpose2__c,'一般用户'), '维修代用（一般维修）',
|
IF(ISPICKVAL(demo_purpose2__c,'其他'), '',
|
IF(ISPICKVAL(demo_purpose2__c,'协议借用'), '协议借用', ''
|
)
|
)
|
)
|
)
|
)
|
)
|
)
|
)
|
)
|
)
|
)</formula>
|
<label>备品分类</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Event_Id__c</fullName>
|
<deleteConstraint>SetNull</deleteConstraint>
|
<externalId>false</externalId>
|
<label>活動ID</label>
|
<referenceTo>Event__c</referenceTo>
|
<relationshipName>Rental_Apply_Event_3fiiConsum</relationshipName>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Lookup</type>
|
</fields>
|
<fields>
|
<fullName>HP_City__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>HP_Province__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>HP_received_Confirmed_F__c</fullName>
|
<externalId>false</externalId>
|
<formula>AND(AssetManageConfirm__c, NOT(ISBLANK(HP_received_sign_day__c)))</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>医院收到确认完了_F</label>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Checkbox</type>
|
</fields>
|
<fields>
|
<fullName>HP_received_Confirmed__c</fullName>
|
<defaultValue>false</defaultValue>
|
<externalId>false</externalId>
|
<label>医院收到确认完了</label>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Checkbox</type>
|
</fields>
|
<fields>
|
<fullName>HP_received_sign_NG_Reason__c</fullName>
|
<externalId>false</externalId>
|
<label>耗材试用表不合格理由</label>
|
<required>false</required>
|
<trackHistory>true</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>TextArea</type>
|
</fields>
|
<fields>
|
<fullName>HP_received_sign_NG__c</fullName>
|
<defaultValue>false</defaultValue>
|
<externalId>false</externalId>
|
<label>耗材试用表不合格</label>
|
<trackHistory>true</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Checkbox</type>
|
</fields>
|
<fields>
|
<fullName>HP_received_sign_day__c</fullName>
|
<externalId>false</externalId>
|
<label>####用户装机日</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Date</type>
|
</fields>
|
<fields>
|
<fullName>HP_received_sign_rich__c</fullName>
|
<externalId>false</externalId>
|
<label>耗材试用表上传记录</label>
|
<length>32768</length>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Html</type>
|
<visibleLines>10</visibleLines>
|
</fields>
|
<fields>
|
<fullName>HP_received_sign_text__c</fullName>
|
<description>之前lable为 【医院收到备品签字(文本)】</description>
|
<externalId>false</externalId>
|
<label>耗材试用表上传记录(文本)</label>
|
<length>32768</length>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>LongTextArea</type>
|
<visibleLines>3</visibleLines>
|
</fields>
|
<fields>
|
<fullName>Hospital_ID__c</fullName>
|
<externalId>false</externalId>
|
<formula>Hospital__r.Id</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>医院ID</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Hospital__c</fullName>
|
<deleteConstraint>SetNull</deleteConstraint>
|
<externalId>false</externalId>
|
<label>医院</label>
|
<lookupFilter>
|
<active>true</active>
|
<filterItems>
|
<field>Account.RecordTypeId</field>
|
<operation>equals</operation>
|
<value>病院</value>
|
</filterItems>
|
<isOptional>true</isOptional>
|
</lookupFilter>
|
<referenceTo>Account</referenceTo>
|
<relationshipName>Rental_Apply_HospitalConsum</relationshipName>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Lookup</type>
|
</fields>
|
<fields>
|
<fullName>Internal_asset_location_F__c</fullName>
|
<description>固定为 ‘上海 备品中心’</description>
|
<externalId>false</externalId>
|
<formula>'上海 备品中心'</formula>
|
<label>备品存放地</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>IsProceedOPD__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(OPDAmount__c>0, True, False)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>是否进行OPD</label>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Checkbox</type>
|
</fields>
|
<fields>
|
<fullName>Is_Special_Rental__c</fullName>
|
<defaultValue>false</defaultValue>
|
<externalId>false</externalId>
|
<label>是否特殊申请</label>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Checkbox</type>
|
</fields>
|
<fields>
|
<fullName>JingliApprovalManager__c</fullName>
|
<deleteConstraint>SetNull</deleteConstraint>
|
<externalId>false</externalId>
|
<label>经理(服务)</label>
|
<referenceTo>User</referenceTo>
|
<relationshipName>JingliKr1lConsum</relationshipName>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Lookup</type>
|
</fields>
|
<fields>
|
<fullName>JingliApprovalManager_eq_Buchang__c</fullName>
|
<externalId>false</externalId>
|
<formula>JingliApprovalManager__c = BuchangApprovalManager__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>经理(服务)=部长(服务)</label>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Checkbox</type>
|
</fields>
|
<fields>
|
<fullName>Job_type__c</fullName>
|
<externalId>false</externalId>
|
<formula>text(Owner:User.Job_Category__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>Last_Assigned_Time__c</fullName>
|
<externalId>false</externalId>
|
<label>最后分配时间</label>
|
<summarizedField>Consum_Apply_Equipment_Set__c.Last_Assigned_Time__c</summarizedField>
|
<summaryFilterItems>
|
<field>Consum_Apply_Equipment_Set__c.Cancel_Select__c</field>
|
<operation>equals</operation>
|
<value>False</value>
|
</summaryFilterItems>
|
<summaryForeignKey>Consum_Apply_Equipment_Set__c.Consum_Apply__c</summaryForeignKey>
|
<summaryOperation>max</summaryOperation>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Summary</type>
|
</fields>
|
<fields>
|
<fullName>Loaner_cancel_request__c</fullName>
|
<externalId>false</externalId>
|
<label>备品申请取消理由备注</label>
|
<length>250</length>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Loaner_centre_mail_address__c</fullName>
|
<defaultValue>'sfdc_developer01@olympus.com.cn'</defaultValue>
|
<description>北方、南方を判断して、項目自動更新にてメールアドレスをセットする。</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_medical_Staff__c</fullName>
|
<deleteConstraint>SetNull</deleteConstraint>
|
<externalId>false</externalId>
|
<label>科室负责人</label>
|
<lookupFilter>
|
<active>true</active>
|
<filterItems>
|
<field>Contact.RecordTypeId</field>
|
<operation>equals</operation>
|
<value>医師,販売店</value>
|
</filterItems>
|
<isOptional>false</isOptional>
|
</lookupFilter>
|
<referenceTo>Contact</referenceTo>
|
<relationshipName>Loaner_medical_Staff32tdConsum</relationshipName>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Lookup</type>
|
</fields>
|
<fields>
|
<fullName>Loaner_received_day__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_ng_num__c</fullName>
|
<externalId>false</externalId>
|
<label>申请者收到确认未完了数</label>
|
<summaryFilterItems>
|
<field>Consum_Apply_Equipment_Set__c.Cancel_Select__c</field>
|
<operation>equals</operation>
|
<value>False</value>
|
</summaryFilterItems>
|
<summaryFilterItems>
|
<field>Consum_Apply_Equipment_Set__c.Wei_Received_Confirm_Cnt__c</field>
|
<operation>greaterThan</operation>
|
<value>0</value>
|
</summaryFilterItems>
|
<summaryForeignKey>Consum_Apply_Equipment_Set__c.Consum_Apply__c</summaryForeignKey>
|
<summaryOperation>count</summaryOperation>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Summary</type>
|
</fields>
|
<fields>
|
<fullName>Loaner_received_staff__c</fullName>
|
<externalId>false</externalId>
|
<label>收件者姓名 (销售或FSE)</label>
|
<length>30</length>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Loaner_received_staff_phone__c</fullName>
|
<externalId>false</externalId>
|
<label>收件者电话(销售或FSE)</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Phone</type>
|
</fields>
|
<fields>
|
<fullName>Loaner_received_time__c</fullName>
|
<description>原则只有一个延长申请，申请前和申请中的值一样，不会变化
|
2018/09/06:
|
延长申请功能不需要了，改为现场签收时间</description>
|
<externalId>false</externalId>
|
<label>现场签收时间</label>
|
<summarizedField>Consum_Apply_Equipment_Set__c.Loaner_received_time_Rollup__c</summarizedField>
|
<summaryFilterItems>
|
<field>Consum_Apply_Equipment_Set__c.Cancel_Select__c</field>
|
<operation>equals</operation>
|
<value>False</value>
|
</summaryFilterItems>
|
<summaryForeignKey>Consum_Apply_Equipment_Set__c.Consum_Apply__c</summaryForeignKey>
|
<summaryOperation>min</summaryOperation>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Summary</type>
|
</fields>
|
<fields>
|
<fullName>Lost_item_Return_Flag__c</fullName>
|
<defaultValue>false</defaultValue>
|
<description>如果只有欠品归还的情况，title显示 [欠品归还]</description>
|
<externalId>false</externalId>
|
<label>欠品归还Flag</label>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Checkbox</type>
|
</fields>
|
<fields>
|
<fullName>Lost_product_cnt__c</fullName>
|
<externalId>false</externalId>
|
<label>欠品确认数(明细)</label>
|
<summarizedField>Consum_Apply_Equipment_Set__c.Lost_product_cnt__c</summarizedField>
|
<summaryForeignKey>Consum_Apply_Equipment_Set__c.Consum_Apply__c</summaryForeignKey>
|
<summaryOperation>sum</summaryOperation>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Summary</type>
|
</fields>
|
<fields>
|
<fullName>Manager_email__c</fullName>
|
<externalId>false</externalId>
|
<formula>Owner:User.Manager.Email</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>经理的邮箱</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Min_Consum_Can_Request_approval_Date__c</fullName>
|
<externalId>false</externalId>
|
<label>最小可以提交申请日期</label>
|
<summarizedField>Consum_Apply_Equipment_Set__c.Min_Consum_Can_Request_approval_Date__c</summarizedField>
|
<summaryFilterItems>
|
<field>Consum_Apply_Equipment_Set__c.Cancel_Select__c</field>
|
<operation>equals</operation>
|
<value>False</value>
|
</summaryFilterItems>
|
<summaryFilterItems>
|
<field>Consum_Apply_Equipment_Set__c.Min_Consum_Can_Request_approval_Date__c</field>
|
<operation>notEqual</operation>
|
<value></value>
|
</summaryFilterItems>
|
<summaryForeignKey>Consum_Apply_Equipment_Set__c.Consum_Apply__c</summaryForeignKey>
|
<summaryOperation>min</summaryOperation>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Summary</type>
|
</fields>
|
<fields>
|
<fullName>Name_No__c</fullName>
|
<externalId>false</externalId>
|
<formula>SUBSTITUTE(Name, "H’", "H")</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>申请No.(条形码)</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Need_Send_Trial_Upload_Email__c</fullName>
|
<defaultValue>false</defaultValue>
|
<externalId>false</externalId>
|
<label>邮件-需要提醒上传试用表</label>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Checkbox</type>
|
</fields>
|
<fields>
|
<fullName>No_length__c</fullName>
|
<externalId>false</externalId>
|
<formula>len( Name )</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>申请No长度</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>NotSendMessageFlag__c</fullName>
|
<defaultValue>false</defaultValue>
|
<description>暂时只用在全部归还邮件发送
|
在申请者收货NG重新分配时会设置
|
默认false会发送</description>
|
<externalId>false</externalId>
|
<label>不发送邮件Flag</label>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Checkbox</type>
|
</fields>
|
<fields>
|
<fullName>NotWatch_RA_Status_F__c</fullName>
|
<externalId>false</externalId>
|
<formula>OR(Status_Text__c == '已批准', Status_Text__c == '已出库指示')</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>不看申请状态_F</label>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Checkbox</type>
|
</fields>
|
<fields>
|
<fullName>NotWatch_RA_Status__c</fullName>
|
<defaultValue>false</defaultValue>
|
<externalId>false</externalId>
|
<label>不看申请状态</label>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Checkbox</type>
|
</fields>
|
<fields>
|
<fullName>Notice_of_Delivery_Hash__c</fullName>
|
<externalId>false</externalId>
|
<label>出库通知（Hash）</label>
|
<length>255</length>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Notice_of_Delivery_Text__c</fullName>
|
<externalId>false</externalId>
|
<label>出库通知（文本）</label>
|
<length>65535</length>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Html</type>
|
<visibleLines>32</visibleLines>
|
</fields>
|
<fields>
|
<fullName>OCM_dept_category__c</fullName>
|
<externalId>false</externalId>
|
<formula>text(Strategic_dept__r.Department_Class_Label__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>OCM_man_province__c</fullName>
|
<externalId>false</externalId>
|
<formula>Owner:User.OCM_man_province__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>OCSM管理省</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>OCM_segmentation__c</fullName>
|
<externalId>false</externalId>
|
<formula>Text(Hospital__r.OCM_Category__c)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>OCSM分类</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>OPDAmount__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>OPDPlan__c</fullName>
|
<deleteConstraint>SetNull</deleteConstraint>
|
<externalId>false</externalId>
|
<label>OPD计划</label>
|
<referenceTo>OPDPlan__c</referenceTo>
|
<relationshipName>OPDPlanRentalApplyConsum</relationshipName>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Lookup</type>
|
</fields>
|
<fields>
|
<fullName>OPD__c</fullName>
|
<deleteConstraint>SetNull</deleteConstraint>
|
<externalId>false</externalId>
|
<label>OPD报告书</label>
|
<referenceTo>Report__c</referenceTo>
|
<relationshipName>Rental_Apply_OPDConsum</relationshipName>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Lookup</type>
|
</fields>
|
<fields>
|
<fullName>Old_Consum_Apply__c</fullName>
|
<deleteConstraint>SetNull</deleteConstraint>
|
<externalId>false</externalId>
|
<label>旧耗材申请</label>
|
<referenceTo>Consum_Apply__c</referenceTo>
|
<relationshipLabel>耗材备品申请 (已分单)</relationshipLabel>
|
<relationshipName>Old_Rental_ApplyConsum</relationshipName>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Lookup</type>
|
</fields>
|
<fields>
|
<fullName>Onwer_job_category__c</fullName>
|
<externalId>false</externalId>
|
<formula>text(Owner:User.Job_Category__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>Onwer_job_category_text__c</fullName>
|
<externalId>false</externalId>
|
<label>耗材申请人-职种(文本)</label>
|
<length>250</length>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Owner_province__c</fullName>
|
<externalId>false</externalId>
|
<formula>Text(Owner:User.Province__c)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>耗材申请人-省</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Owner_province_text__c</fullName>
|
<externalId>false</externalId>
|
<label>耗材申请人-省(文本)</label>
|
<length>250</length>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Person_In_Charge__c</fullName>
|
<deleteConstraint>SetNull</deleteConstraint>
|
<externalId>false</externalId>
|
<label>备品出借担当</label>
|
<referenceTo>User</referenceTo>
|
<relationshipName>Person_In_ChargeConsum</relationshipName>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Lookup</type>
|
</fields>
|
<fields>
|
<fullName>Phone_number__c</fullName>
|
<externalId>false</externalId>
|
<label>联系电话</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Phone</type>
|
</fields>
|
<fields>
|
<fullName>Post_Code__c</fullName>
|
<description>邮编</description>
|
<externalId>false</externalId>
|
<label>邮编</label>
|
<length>12</length>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Pre_inspection_ng_num__c</fullName>
|
<description>发货前-检测合格时间 = null</description>
|
<externalId>false</externalId>
|
<label>出库前检查未完了数</label>
|
<summaryFilterItems>
|
<field>Consum_Apply_Equipment_Set__c.Inspection_not_finish__c</field>
|
<operation>greaterThan</operation>
|
<value>0</value>
|
</summaryFilterItems>
|
<summaryFilterItems>
|
<field>Consum_Apply_Equipment_Set__c.Cancel_Select__c</field>
|
<operation>equals</operation>
|
<value>False</value>
|
</summaryFilterItems>
|
<summaryForeignKey>Consum_Apply_Equipment_Set__c.Consum_Apply__c</summaryForeignKey>
|
<summaryOperation>count</summaryOperation>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Summary</type>
|
</fields>
|
<fields>
|
<fullName>ProductCode_Ext_Formula__c</fullName>
|
<description>SWAG-BDV589
|
对应QIS 所对应保有设备对应的OT-code</description>
|
<externalId>false</externalId>
|
<formula>QIS_number__r.ProductCode_Ext_Text__c</formula>
|
<label>OT-Code（公式）</label>
|
<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>
|
<label>产品分类(ET/DISP)</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Picklist</type>
|
<valueSet>
|
<restricted>true</restricted>
|
<valueSetDefinition>
|
<sorted>false</sorted>
|
<value>
|
<fullName>ET</fullName>
|
<default>false</default>
|
<label>ET</label>
|
</value>
|
<value>
|
<fullName>DISP</fullName>
|
<default>false</default>
|
<label>DISP</label>
|
</value>
|
<value>
|
<fullName>GI</fullName>
|
<default>false</default>
|
<isActive>false</isActive>
|
<label>GI</label>
|
</value>
|
<value>
|
<fullName>SP</fullName>
|
<default>false</default>
|
<isActive>false</isActive>
|
<label>SP</label>
|
</value>
|
</valueSetDefinition>
|
</valueSet>
|
</fields>
|
<fields>
|
<fullName>Province__c</fullName>
|
<externalId>false</externalId>
|
<formula>Hospital__r.State_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>QISRepair__c</fullName>
|
<deleteConstraint>SetNull</deleteConstraint>
|
<description>SWAG-BE532K 新增字段</description>
|
<externalId>false</externalId>
|
<label>QIS修理</label>
|
<referenceTo>Repair__c</referenceTo>
|
<relationshipName>QISRepairConsum</relationshipName>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Lookup</type>
|
</fields>
|
<fields>
|
<fullName>QIS_Cancel_Submit_day__c</fullName>
|
<externalId>false</externalId>
|
<label>QIS取消申请日</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Date</type>
|
</fields>
|
<fields>
|
<fullName>QIS_ID_Line__c</fullName>
|
<externalId>false</externalId>
|
<formula>QIS_number__r.Id</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>QIS的ID值</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>QIS_Repair_Shipped_Date__c</fullName>
|
<externalId>false</externalId>
|
<label>QIS_RC修理品返送日</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Date</type>
|
</fields>
|
<fields>
|
<fullName>QIS_ReplaceDeliveryDate__c</fullName>
|
<externalId>false</externalId>
|
<label>QIS_新品发货日</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Date</type>
|
</fields>
|
<fields>
|
<fullName>QIS_Reply_day__c</fullName>
|
<externalId>false</externalId>
|
<label>QIS OCM服务本部回答日</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Date</type>
|
</fields>
|
<fields>
|
<fullName>QIS_cancel_date__c</fullName>
|
<externalId>false</externalId>
|
<label>QIS取消日</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>DateTime</type>
|
</fields>
|
<fields>
|
<fullName>QIS_number__c</fullName>
|
<deleteConstraint>SetNull</deleteConstraint>
|
<externalId>false</externalId>
|
<label>QIS</label>
|
<referenceTo>QIS_Report__c</referenceTo>
|
<relationshipName>QIS_Number_iUTTConsum</relationshipName>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Lookup</type>
|
</fields>
|
<fields>
|
<fullName>QRId__c</fullName>
|
<externalId>false</externalId>
|
<label>QRId</label>
|
<length>18</length>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>QRImg__c</fullName>
|
<externalId>false</externalId>
|
<formula>IMAGE("/servlet/servlet.FileDownload?file=" & QRId__c, "qrcode")</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>QRImg</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Queue_PIC_F__c</fullName>
|
<externalId>false</externalId>
|
<formula>applyUser__r.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>RA_Status_Text__c</fullName>
|
<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>RA_Status__c</fullName>
|
<description>Wei_Assigned_Cnt__c==0是不是在每个IF文里 都包含了? 需要仔细确认
|
每个Wei 字段的汇总 都要这样一层一层往上check</description>
|
<externalId>false</externalId>
|
<formula>IF(TEXT(Status__c) = '取消','取消',
|
IF(TEXT(Status__c) = '删除','删除',
|
IF(AND(Cancel_Select__c > 0, Consum_Apply_Equipment_Set_Cnt__c = 0), '取消',
|
IF(Not(OR(Status_Text__c == '已批准', Status_Text__c == '已出库指示')), TEXT(Status__c),
|
IF(Wei_Consumption_Check_Cnt__c > 0 && Wei_Consumption_Check_Cnt__c = ShelfUp_ng_num__c, '待消耗',
|
IF (ShelfUp_ng_num__c == 0, '完了',
|
IF ( Wei_Received_loaner__c == 0, '已回收',
|
IF (AND(Lost_product_cnt__c > 0, Wei_Return__c == 0), '欠品中',
|
IF ( Wei_Return__c == 0, '已回寄',
|
IF (AND(Loaner_received_ng_num__c == 0, Shippment_ng_num__c == 0),IF (HP_received_Confirmed_F__c, '医院已装机确认', '申请者已收货'),
|
IF (Shippment_ng_num__c == 0, '已出库',
|
IF ( Pre_inspection_ng_num__c == 0, '出库前已检测',
|
IF ( StockDown_ng_num__c == 0, '已下架',
|
IF ( Wei_Shipment_request__c == 0, '已出库指示',
|
IF ( Wei_Assigned_Cnt__c == 0, '已分配', '已批准')
|
)
|
)
|
)
|
)
|
)
|
)
|
)
|
)
|
)
|
)
|
)
|
)
|
)
|
)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<inlineHelpText>草案中
|
申请中
|
已批准
|
已出库指示
|
已下架
|
出库前已检测
|
已出库
|
申请者已收货
|
医院已装机确认
|
已回寄
|
欠品中
|
已回收
|
完了</inlineHelpText>
|
<label>耗材备品状态</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Received_Confirm_NG_amount__c</fullName>
|
<externalId>false</externalId>
|
<label>####现场收到确认NG数</label>
|
<summaryFilterItems>
|
<field>Consum_Apply_Equipment_Set__c.Received_Confirm__c</field>
|
<operation>equals</operation>
|
<value>NG</value>
|
</summaryFilterItems>
|
<summaryFilterItems>
|
<field>Consum_Apply_Equipment_Set__c.Cancel_Reason__c</field>
|
<operation>equals</operation>
|
<value></value>
|
</summaryFilterItems>
|
<summaryForeignKey>Consum_Apply_Equipment_Set__c.Consum_Apply__c</summaryForeignKey>
|
<summaryOperation>count</summaryOperation>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Summary</type>
|
</fields>
|
<fields>
|
<fullName>Received_NG_Content_Modified_ForEmail__c</fullName>
|
<description>收货NG的明细，当NG理由或图片有变化时发邮件用。</description>
|
<externalId>false</externalId>
|
<label>邮件-到货NG内容修改</label>
|
<length>32768</length>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>LongTextArea</type>
|
<visibleLines>3</visibleLines>
|
</fields>
|
<fields>
|
<fullName>Received_NG_Content_Modified_Time__c</fullName>
|
<externalId>false</externalId>
|
<label>邮件-到货NG内容修改时间</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>DateTime</type>
|
</fields>
|
<fields>
|
<fullName>Received_NG_Detail_ForEmail__c</fullName>
|
<externalId>false</externalId>
|
<label>邮件-到货NG明细内容</label>
|
<length>131072</length>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>LongTextArea</type>
|
<visibleLines>5</visibleLines>
|
</fields>
|
<fields>
|
<fullName>Received_NG_Reject_Detail_ForEmail__c</fullName>
|
<externalId>false</externalId>
|
<label>邮件-到货NG确认不合格内容</label>
|
<length>32768</length>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>LongTextArea</type>
|
<visibleLines>3</visibleLines>
|
</fields>
|
<fields>
|
<fullName>Rental_Apply_Mail_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>Rental_Apply_Mail__c</fullName>
|
<externalId>false</externalId>
|
<label>备品借出中心邮件地址</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Email</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Rental_Apply__c</fullName>
|
<deleteConstraint>Restrict</deleteConstraint>
|
<externalId>false</externalId>
|
<label>备品借出申请</label>
|
<referenceTo>Rental_Apply__c</referenceTo>
|
<relationshipLabel>耗材备品申请</relationshipLabel>
|
<relationshipName>Consum_Apply</relationshipName>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Lookup</type>
|
</fields>
|
<fields>
|
<fullName>Repair__c</fullName>
|
<deleteConstraint>SetNull</deleteConstraint>
|
<externalId>false</externalId>
|
<label>####修理</label>
|
<lookupFilter>
|
<active>true</active>
|
<filterItems>
|
<field>Repair__c.Hospital__c</field>
|
<operation>equals</operation>
|
<valueField>$Source.Hospital__c</valueField>
|
</filterItems>
|
<filterItems>
|
<field>Repair__c.RecordType.Name</field>
|
<operation>equals</operation>
|
<value>修理</value>
|
</filterItems>
|
<filterItems>
|
<field>Repair__c.Agreed_Date__c</field>
|
<operation>notEqual</operation>
|
<value></value>
|
</filterItems>
|
<isOptional>true</isOptional>
|
</lookupFilter>
|
<referenceTo>Repair__c</referenceTo>
|
<relationshipName>Rental_Apply_RepairConsum</relationshipName>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Lookup</type>
|
</fields>
|
<fields>
|
<fullName>Request_Shipping_7days_Before__c</fullName>
|
<externalId>false</externalId>
|
<label>希望到货日前7个工作日</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Date</type>
|
</fields>
|
<fields>
|
<fullName>Request_answer_day__c</fullName>
|
<externalId>false</externalId>
|
<formula>DATEVALUE(Request_answer_time__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>
|
<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>DATEVALUE(Request_approval_time__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>
|
<label>批准时间(申请提交时间)</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>DateTime</type>
|
</fields>
|
<fields>
|
<fullName>Request_demo_day__c</fullName>
|
<externalId>false</externalId>
|
<formula>DATEVALUE(Request_demo_time__c)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>申请日期</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Date</type>
|
</fields>
|
<fields>
|
<fullName>Request_demo_detail__c</fullName>
|
<externalId>false</externalId>
|
<label>申请借用备品</label>
|
<length>5000</length>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>LongTextArea</type>
|
<visibleLines>10</visibleLines>
|
</fields>
|
<fields>
|
<fullName>Request_demo_time__c</fullName>
|
<externalId>false</externalId>
|
<label>申请时间</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>DateTime</type>
|
</fields>
|
<fields>
|
<fullName>Request_shipping_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>ResponseNew__c</fullName>
|
<externalId>false</externalId>
|
<label>耗材实时应答沟通</label>
|
<length>131072</length>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Html</type>
|
<visibleLines>13</visibleLines>
|
</fields>
|
<fields>
|
<fullName>Response__c</fullName>
|
<externalId>false</externalId>
|
<label>耗材应答沟通</label>
|
<length>131072</length>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Html</type>
|
<visibleLines>13</visibleLines>
|
</fields>
|
<fields>
|
<fullName>Responsible_Lending__c</fullName>
|
<deleteConstraint>SetNull</deleteConstraint>
|
<externalId>false</externalId>
|
<label>貸出責任者</label>
|
<referenceTo>User</referenceTo>
|
<relationshipName>Responsible_LendingConsum</relationshipName>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Lookup</type>
|
</fields>
|
<fields>
|
<fullName>Return_Details_ForEmail__c</fullName>
|
<externalId>false</externalId>
|
<label>邮件-回寄明细</label>
|
<length>32768</length>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>LongTextArea</type>
|
<visibleLines>3</visibleLines>
|
</fields>
|
<fields>
|
<fullName>Return_Distrubutor_Method__c</fullName>
|
<externalId>false</externalId>
|
<label>回库-运输方式</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Picklist</type>
|
<valueSet>
|
<controllingField>Return_Track_Company__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>嘉里大通</controllingFieldValue>
|
<controllingFieldValue>利讯</controllingFieldValue>
|
<controllingFieldValue>莱比特</controllingFieldValue>
|
<controllingFieldValue>慧通速递</controllingFieldValue>
|
<valueName>陆运</valueName>
|
</valueSettings>
|
<valueSettings>
|
<controllingFieldValue>嘉里大通</controllingFieldValue>
|
<controllingFieldValue>利讯</controllingFieldValue>
|
<controllingFieldValue>莱比特</controllingFieldValue>
|
<controllingFieldValue>慧通速递</controllingFieldValue>
|
<valueName>空运</valueName>
|
</valueSettings>
|
<valueSettings>
|
<controllingFieldValue>联邦快递Fedex</controllingFieldValue>
|
<valueName>优先达</valueName>
|
</valueSettings>
|
<valueSettings>
|
<controllingFieldValue>联邦快递Fedex</controllingFieldValue>
|
<valueName>普达</valueName>
|
</valueSettings>
|
</valueSet>
|
</fields>
|
<fields>
|
<fullName>Return_Email_Time__c</fullName>
|
<externalId>false</externalId>
|
<label>邮件-回寄邮件发送时间</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>DateTime</type>
|
</fields>
|
<fields>
|
<fullName>Return_Track_Company__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_Track_Number__c</fullName>
|
<externalId>false</externalId>
|
<label>回库_回库运输单号</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>TextArea</type>
|
</fields>
|
<fields>
|
<fullName>Return_Trake_Staff__c</fullName>
|
<deleteConstraint>SetNull</deleteConstraint>
|
<externalId>false</externalId>
|
<label>回库-回库担当者</label>
|
<referenceTo>User</referenceTo>
|
<relationshipName>RTS_cS01Consum</relationshipName>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Lookup</type>
|
</fields>
|
<fields>
|
<fullName>SalesManager__c</fullName>
|
<deleteConstraint>SetNull</deleteConstraint>
|
<externalId>false</externalId>
|
<label>经理</label>
|
<referenceTo>User</referenceTo>
|
<relationshipName>SalesManagerKr1HConsum</relationshipName>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Lookup</type>
|
</fields>
|
<fields>
|
<fullName>SalesManager_eq_Buchang__c</fullName>
|
<externalId>false</externalId>
|
<formula>SalesManager__c = BuchangApprovalManagerSales__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>经理=部长</label>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Checkbox</type>
|
</fields>
|
<fields>
|
<fullName>Salesdepartment1_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>Salesdepartment1__c</fullName>
|
<externalId>false</externalId>
|
<formula>CASE( Owner:User.Dept__c ,
|
'医疗备品管理中心','0.备品中心',
|
'医疗华北营业本部', '1.华北营业本部',
|
'医疗东北营业本部', '2.东北营业本部',
|
'医疗西北营业本部', '3.西北营业本部',
|
'医疗华东营业本部', '4.华东营业本部',
|
'医疗华南营业本部', '5.华南营业本部',
|
'医疗西南营业本部', '6.西南营业本部',
|
'消化·呼吸内镜事业本部', '7.GIR市场本部',
|
'外科事业本部', '8.SP市场本部',
|
'MA本部', '9.MA本部',
|
'医疗服务本部', '10.服务本部',
|
'医疗产品培训本部', '11.医疗产品培训本部',
|
'消化·呼吸领域解决方案本部', '16.消化·呼吸领域解决方案本部',
|
'市场企划本部', '17.市场企划本部',
|
'能量事业本部', '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>Salesdepartment__c</fullName>
|
<description>2018/6/01修改之前：
|
CASE( Owner:User.Dept__c ,
|
'备品管理中心','0.备品中心',
|
'医疗华北营业本部', '1.华北营业本部',
|
'医疗东北营业本部', '2.东北营业本部',
|
'医疗西北营业本部', '3.西北营业本部',
|
'医疗华东营业本部', '4.华东营业本部',
|
'医疗华南营业本部', '5.华南营业本部',
|
'医疗西南营业本部', '6.西南营业本部',
|
'消化·呼吸内镜事业本部', '7.GIR市场本部',
|
'外科事业本部', '8.SP市场本部',
|
'GIR MA本部', '9.GIR MA本部',
|
'外科 MA本部', '10.SP MA本部',
|
'服务本部', '11.服务本部',
|
'人才教育培训本部', '12.教育培训本部',
|
'能量事业本部', '13.能量事业本部','')
|
|
2018/11/12:把'能量事业本部', '13.能量事业本部'改为0.备品中心
|
能量事业本部的单子，分配0.备品中心的库存</description>
|
<externalId>false</externalId>
|
<formula>IF(NOT(isblank(Text(Owner:User.Dept__c))),CASE( Owner:User.Dept__c ,
|
'医疗备品管理中心','0.备品中心',
|
'医疗华北营业本部', '1.华北营业本部',
|
'医疗东北营业本部', '2.东北营业本部',
|
'医疗西北营业本部', '3.西北营业本部',
|
'医疗华东营业本部', '4.华东营业本部',
|
'医疗华南营业本部', '5.华南营业本部',
|
'医疗西南营业本部', '6.西南营业本部',
|
'消化·呼吸内镜事业本部', '7.GIR市场本部',
|
'外科事业本部', '8.SP市场本部',
|
'MA本部', '9.MA本部',
|
'医疗服务本部', '10.服务本部',
|
'医疗产品培训本部', '11.医疗产品培训本部',
|
'消化·呼吸领域解决方案本部', '16.消化·呼吸领域解决方案本部',
|
'市场企划本部', '17.市场企划本部',
|
'能量事业本部', '0.备品中心',''),
|
IF(Onwer_job_category_text__c = "销售推广"
|
|| Onwer_job_category_text__c = "销售市场"
|
|| Onwer_job_category_text__c = "销售服务"
|
|| Onwer_job_category_text__c = "支援",
|
Case(Owner_province_text__c,
|
"北京市","1.华北营业本部",
|
"天津市","1.华北营业本部",
|
"河南省","3.西北营业本部",
|
"河北省","1.华北营业本部",
|
"山西省","3.西北营业本部",
|
"内蒙古","1.华北营业本部",
|
"山东省","1.华北营业本部",
|
"陕西省","3.西北营业本部",
|
"青海省","3.西北营业本部",
|
"宁夏自治区","3.西北营业本部",
|
"甘肃省","3.西北营业本部",
|
"新疆自治区","3.西北营业本部",
|
"辽宁省","2.东北营业本部",
|
"黑龙江省","2.东北营业本部",
|
"吉林省","2.东北营业本部",
|
"上海市","4.华东营业本部",
|
"江苏省","4.华东营业本部",
|
"浙江省","4.华东营业本部",
|
"福建省","4.华东营业本部",
|
"安徽省","4.华东营业本部",
|
"江西省","4.华东营业本部",
|
"广东省","5.华南营业本部",
|
"广西自治区","5.华南营业本部",
|
"海南省","5.华南营业本部",
|
"四川省","6.西南营业本部",
|
"重庆市","6.西南营业本部",
|
"云南省","6.西南营业本部",
|
"贵州省","6.西南营业本部",
|
"西藏自治区","6.西南营业本部",
|
"湖北省","5.华南营业本部",
|
"湖南省","5.华南营业本部",
|
"深圳市","5.华南营业本部",
|
"大连市","2.东北营业本部",
|
"青岛市","1.华北营业本部",
|
"其他"),''
|
))</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>耗材申请人-销售本部</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Salesdepartment_text__c</fullName>
|
<externalId>false</externalId>
|
<label>耗材申请人-销售本部(文本)</label>
|
<length>250</length>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Salesdept__c</fullName>
|
<description>2018/6/01修改前：
|
TEXT(Owner:User.Dept__c)</description>
|
<externalId>false</externalId>
|
<formula>IF(NOT(isblank(Text(Owner:User.Dept__c))),TEXT(Owner:User.Dept__c),
|
IF(Onwer_job_category_text__c = "销售推广"
|
|| Onwer_job_category_text__c = "销售市场"
|
|| Onwer_job_category_text__c = "销售服务"
|
|| Onwer_job_category_text__c = "支援",
|
Case(Owner_province_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>Salesdept_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>Select_Status__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(OR(ISPICKVAL(Status__c, '已批准'), ISPICKVAL(Status__c, '已出库指示')),
|
IF(Consum_Apply_Equipment_Set_Cnt__c > 0,
|
IF ( Wei_Assigned_Cnt__c == Consum_Apply_Equipment_Set_Cnt__c, '待分配',
|
IF (AND (Wei_Assigned_Cnt__c < Consum_Apply_Equipment_Set_Cnt__c, Wei_Assigned_Cnt__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>Send_Rental_Apply_EmailTime__c</fullName>
|
<externalId>false</externalId>
|
<label>备品借出申请出库指示邮件发送时间</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>DateTime</type>
|
</fields>
|
<fields>
|
<fullName>ShelfUp_ng_num__c</fullName>
|
<externalId>false</externalId>
|
<label>未回库数</label>
|
<summarizedField>Consum_Apply_Equipment_Set__c.Wei_Arrival_in_wh__c</summarizedField>
|
<summaryFilterItems>
|
<field>Consum_Apply_Equipment_Set__c.Wei_Arrival_in_wh__c</field>
|
<operation>greaterThan</operation>
|
<value>0</value>
|
</summaryFilterItems>
|
<summaryFilterItems>
|
<field>Consum_Apply_Equipment_Set__c.Cancel_Reason__c</field>
|
<operation>equals</operation>
|
<value></value>
|
</summaryFilterItems>
|
<summaryForeignKey>Consum_Apply_Equipment_Set__c.Consum_Apply__c</summaryForeignKey>
|
<summaryOperation>sum</summaryOperation>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Summary</type>
|
</fields>
|
<fields>
|
<fullName>Shipment_Post_Code__c</fullName>
|
<externalId>false</externalId>
|
<formula>Shipment_address__r.Post_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>Shipment_Slip_tmp__c</fullName>
|
<externalId>false</externalId>
|
<label>发货运输单数据(临时保存)</label>
|
<length>800</length>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>LongTextArea</type>
|
<visibleLines>3</visibleLines>
|
</fields>
|
<fields>
|
<fullName>Shipment_address__c</fullName>
|
<deleteConstraint>SetNull</deleteConstraint>
|
<externalId>false</externalId>
|
<label>办事处地址</label>
|
<referenceTo>Shipment_address__c</referenceTo>
|
<relationshipName>Shipment_addreessConsum</relationshipName>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Lookup</type>
|
</fields>
|
<fields>
|
<fullName>Shipment_request_Cnt__c</fullName>
|
<externalId>false</externalId>
|
<label>出库指示明细数</label>
|
<summarizedField>Consum_Apply_Equipment_Set__c.Yi_Shipment_request__c</summarizedField>
|
<summaryFilterItems>
|
<field>Consum_Apply_Equipment_Set__c.Yi_Shipment_request__c</field>
|
<operation>greaterThan</operation>
|
<value>0</value>
|
</summaryFilterItems>
|
<summaryFilterItems>
|
<field>Consum_Apply_Equipment_Set__c.Cancel_Select__c</field>
|
<operation>equals</operation>
|
<value>False</value>
|
</summaryFilterItems>
|
<summaryForeignKey>Consum_Apply_Equipment_Set__c.Consum_Apply__c</summaryForeignKey>
|
<summaryOperation>sum</summaryOperation>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Summary</type>
|
</fields>
|
<fields>
|
<fullName>Shipment_requested_cnt__c</fullName>
|
<externalId>false</externalId>
|
<label>已出库指示配套数</label>
|
<summaryFilterItems>
|
<field>Consum_Apply_Equipment_Set__c.Yi_Shipment_request__c</field>
|
<operation>greaterThan</operation>
|
<value>0</value>
|
</summaryFilterItems>
|
<summaryFilterItems>
|
<field>Consum_Apply_Equipment_Set__c.Cancel_Select__c</field>
|
<operation>equals</operation>
|
<value>False</value>
|
</summaryFilterItems>
|
<summaryForeignKey>Consum_Apply_Equipment_Set__c.Consum_Apply__c</summaryForeignKey>
|
<summaryOperation>count</summaryOperation>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Summary</type>
|
</fields>
|
<fields>
|
<fullName>Shippment_adress_detail__c</fullName>
|
<description>Case( Shippment_adreess__c,
|
"大连办事处","大连办事处:辽宁省大连市沙河口区黄河路620号现代服务业总部大厦9层E/F 邮编116021 电话 86-411-84456084",
|
"哈尔滨办事处","哈尔滨办事处:哈尔滨市南岗区东大直街146号上和置地广场1号写字楼1905室 邮编150001 电话 86-451-82562084/82522084 ",
|
"沈阳办事处","沈阳办事处:辽宁省沈阳市和平区南京北街206号沈阳城市广场1座2-1003-1006座 邮编110001 电话 86-24-23342084",
|
"长春办事处","长春办事处:吉林省长春市朝阳区西安大路727号中银大厦A座13层1301室 邮编130061 电话86-431-85085055 ",
|
"")
|
==========
|
Shipment_address__r.Address__c</description>
|
<externalId>false</externalId>
|
<formula>CASE(TEXT(direct_send__c),
|
'办事处', Shipment_address__r.Address__c,
|
'医院', Hospital__r.Address_Together__c,
|
'经销商', Dealer__r.Address_Together__c,
|
'直送', direct_shippment_address__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>Shippment_loaner_time__c</fullName>
|
<externalId>false</externalId>
|
<label>备品中心出库时间</label>
|
<summarizedField>Consum_Apply_Equipment_Set__c.Shippment_loaner_time2__c</summarizedField>
|
<summaryFilterItems>
|
<field>Consum_Apply_Equipment_Set__c.Shippment_loaner_time2__c</field>
|
<operation>notEqual</operation>
|
<value></value>
|
</summaryFilterItems>
|
<summaryForeignKey>Consum_Apply_Equipment_Set__c.Consum_Apply__c</summaryForeignKey>
|
<summaryOperation>min</summaryOperation>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Summary</type>
|
</fields>
|
<fields>
|
<fullName>Shippment_ng_num__c</fullName>
|
<externalId>false</externalId>
|
<label>出库未完了数</label>
|
<summaryFilterItems>
|
<field>Consum_Apply_Equipment_Set__c.Wei_loaner_arranged__c</field>
|
<operation>greaterThan</operation>
|
<value>0</value>
|
</summaryFilterItems>
|
<summaryFilterItems>
|
<field>Consum_Apply_Equipment_Set__c.Cancel_Select__c</field>
|
<operation>equals</operation>
|
<value>False</value>
|
</summaryFilterItems>
|
<summaryForeignKey>Consum_Apply_Equipment_Set__c.Consum_Apply__c</summaryForeignKey>
|
<summaryOperation>count</summaryOperation>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Summary</type>
|
</fields>
|
<fields>
|
<fullName>Split_Apply_Reason__c</fullName>
|
<externalId>false</externalId>
|
<label>分单理由</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Picklist</type>
|
<valueSet>
|
<restricted>true</restricted>
|
<valueSetDefinition>
|
<sorted>false</sorted>
|
<value>
|
<fullName>分批发货分单</fullName>
|
<default>false</default>
|
<label>分批发货分单</label>
|
</value>
|
<value>
|
<fullName>到货NG分单</fullName>
|
<default>false</default>
|
<label>到货NG分单</label>
|
</value>
|
<value>
|
<fullName>排队分单</fullName>
|
<default>false</default>
|
<isActive>false</isActive>
|
<label>排队分单</label>
|
</value>
|
<value>
|
<fullName>追加附属品分单</fullName>
|
<default>false</default>
|
<isActive>false</isActive>
|
<label>追加附属品分单</label>
|
</value>
|
</valueSetDefinition>
|
</valueSet>
|
</fields>
|
<fields>
|
<fullName>Status_Text__c</fullName>
|
<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>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>
|
<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>Status_for_report__c</fullName>
|
<description>To summarise status for report from informatica</description>
|
<externalId>false</externalId>
|
<label>状态forReport</label>
|
<length>50</length>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>StockDown_ng_num__c</fullName>
|
<externalId>false</externalId>
|
<label>未下架件数</label>
|
<summarizedField>Consum_Apply_Equipment_Set__c.Wei_StockDown__c</summarizedField>
|
<summaryFilterItems>
|
<field>Consum_Apply_Equipment_Set__c.Cancel_Select__c</field>
|
<operation>equals</operation>
|
<value>False</value>
|
</summaryFilterItems>
|
<summaryForeignKey>Consum_Apply_Equipment_Set__c.Consum_Apply__c</summaryForeignKey>
|
<summaryOperation>sum</summaryOperation>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Summary</type>
|
</fields>
|
<fields>
|
<fullName>Strategic_dept__c</fullName>
|
<deleteConstraint>SetNull</deleteConstraint>
|
<externalId>false</externalId>
|
<label>战略科室</label>
|
<lookupFilter>
|
<active>true</active>
|
<filterItems>
|
<field>Account.RecordTypeId</field>
|
<operation>equals</operation>
|
<value>戦略科室分類 その他, 戦略科室分類 不明, 戦略科室分類 呼吸科, 戦略科室分類 婦人科, 戦略科室分類 普外科, 戦略科室分類 泌尿科, 戦略科室分類 消化科, 戦略科室分類 耳鼻喉科, 戦略科室分類（共通）,戦略科室分類ET</value>
|
</filterItems>
|
<isOptional>true</isOptional>
|
</lookupFilter>
|
<referenceTo>Account</referenceTo>
|
<relationshipName>Strategic_deptXLSMConsum</relationshipName>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Lookup</type>
|
</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>TongkuoZongjian__c</fullName>
|
<deleteConstraint>SetNull</deleteConstraint>
|
<externalId>false</externalId>
|
<label>统括总监</label>
|
<referenceTo>User</referenceTo>
|
<relationshipName>RA_TongkuoZongjianConsum</relationshipName>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Lookup</type>
|
</fields>
|
<fields>
|
<fullName>Tracking_Delivery_Number__c</fullName>
|
<externalId>false</externalId>
|
<formula>DeliverySlip__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>User_Salesdept__c</fullName>
|
<externalId>false</externalId>
|
<formula>Owner:User.Salesdepartment__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>Wei_Assigned_Cnt__c</fullName>
|
<externalId>false</externalId>
|
<label>未分配件数</label>
|
<summaryFilterItems>
|
<field>Consum_Apply_Equipment_Set__c.Cancel_Select__c</field>
|
<operation>equals</operation>
|
<value>False</value>
|
</summaryFilterItems>
|
<summaryFilterItems>
|
<field>Consum_Apply_Equipment_Set__c.Wei_Assigned_Cnt__c</field>
|
<operation>greaterThan</operation>
|
<value>0</value>
|
</summaryFilterItems>
|
<summaryForeignKey>Consum_Apply_Equipment_Set__c.Consum_Apply__c</summaryForeignKey>
|
<summaryOperation>count</summaryOperation>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Summary</type>
|
</fields>
|
<fields>
|
<fullName>Wei_Consumption_Check_Cnt__c</fullName>
|
<externalId>false</externalId>
|
<label>已消耗未备品中心确认件数</label>
|
<summarizedField>Consum_Apply_Equipment_Set__c.Wei_Consumption_Check_Cnt__c</summarizedField>
|
<summaryFilterItems>
|
<field>Consum_Apply_Equipment_Set__c.Wei_Consumption_Check_Cnt__c</field>
|
<operation>greaterThan</operation>
|
<value>0</value>
|
</summaryFilterItems>
|
<summaryFilterItems>
|
<field>Consum_Apply_Equipment_Set__c.Cancel_Select__c</field>
|
<operation>equals</operation>
|
<value>False</value>
|
</summaryFilterItems>
|
<summaryForeignKey>Consum_Apply_Equipment_Set__c.Consum_Apply__c</summaryForeignKey>
|
<summaryOperation>sum</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>Consum_Apply_Equipment_Set__c.Cancel_Reason__c</field>
|
<operation>equals</operation>
|
<value></value>
|
</summaryFilterItems>
|
<summaryFilterItems>
|
<field>Consum_Apply_Equipment_Set__c.Wei_Received_loaner__c</field>
|
<operation>greaterThan</operation>
|
<value>0</value>
|
</summaryFilterItems>
|
<summaryForeignKey>Consum_Apply_Equipment_Set__c.Consum_Apply__c</summaryForeignKey>
|
<summaryOperation>count</summaryOperation>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Summary</type>
|
</fields>
|
<fields>
|
<fullName>Wei_Return_Cnt__c</fullName>
|
<externalId>false</externalId>
|
<label>未回寄件数(回寄邮件用)</label>
|
<summaryFilterItems>
|
<field>Consum_Apply_Equipment_Set__c.Cancel_Reason__c</field>
|
<operation>equals</operation>
|
<value></value>
|
</summaryFilterItems>
|
<summaryFilterItems>
|
<field>Consum_Apply_Equipment_Set__c.Wei_Return_Finish__c</field>
|
<operation>greaterThan</operation>
|
<value>0</value>
|
</summaryFilterItems>
|
<summaryForeignKey>Consum_Apply_Equipment_Set__c.Consum_Apply__c</summaryForeignKey>
|
<summaryOperation>count</summaryOperation>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Summary</type>
|
</fields>
|
<fields>
|
<fullName>Wei_Return__c</fullName>
|
<externalId>false</externalId>
|
<label>未回寄件数</label>
|
<summaryFilterItems>
|
<field>Consum_Apply_Equipment_Set__c.Cancel_Reason__c</field>
|
<operation>equals</operation>
|
<value></value>
|
</summaryFilterItems>
|
<summaryFilterItems>
|
<field>Consum_Apply_Equipment_Set__c.Wei_Return__c</field>
|
<operation>greaterThan</operation>
|
<value>0</value>
|
</summaryFilterItems>
|
<summaryForeignKey>Consum_Apply_Equipment_Set__c.Consum_Apply__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>Consum_Apply_Equipment_Set__c.Cancel_Select__c</field>
|
<operation>equals</operation>
|
<value>False</value>
|
</summaryFilterItems>
|
<summaryFilterItems>
|
<field>Consum_Apply_Equipment_Set__c.Wei_Shipment_request__c</field>
|
<operation>greaterThan</operation>
|
<value>0</value>
|
</summaryFilterItems>
|
<summaryForeignKey>Consum_Apply_Equipment_Set__c.Consum_Apply__c</summaryForeignKey>
|
<summaryOperation>count</summaryOperation>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Summary</type>
|
</fields>
|
<fields>
|
<fullName>WorkPlace__c</fullName>
|
<externalId>false</externalId>
|
<formula>TEXT(Owner:User.Work_Location__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>Work_Location__c</fullName>
|
<externalId>false</externalId>
|
<formula>text(Owner:User.Work_Location__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>Work_Location_text__c</fullName>
|
<externalId>false</externalId>
|
<label>耗材申请人-工作地(文本)</label>
|
<length>250</length>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Workshop_category__c</fullName>
|
<externalId>false</externalId>
|
<formula>TEXT(Campaign__r.Workshop_category__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_Assigned_Cnt_Sum__c</fullName>
|
<externalId>false</externalId>
|
<label>已分配件数(明细)</label>
|
<summarizedField>Consum_Apply_Equipment_Set__c.Yi_Assigned_Cnt__c</summarizedField>
|
<summaryFilterItems>
|
<field>Consum_Apply_Equipment_Set__c.Yi_Assigned_Cnt__c</field>
|
<operation>greaterThan</operation>
|
<value>0</value>
|
</summaryFilterItems>
|
<summaryForeignKey>Consum_Apply_Equipment_Set__c.Consum_Apply__c</summaryForeignKey>
|
<summaryOperation>sum</summaryOperation>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Summary</type>
|
</fields>
|
<fields>
|
<fullName>Yi_Assigned_Cnt__c</fullName>
|
<externalId>false</externalId>
|
<formula>Consum_Apply_Equipment_Set_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_loaner_arranged__c</fullName>
|
<externalId>false</externalId>
|
<label>已出库件数</label>
|
<summarizedField>Consum_Apply_Equipment_Set__c.Yi_loaner_arranged__c</summarizedField>
|
<summaryFilterItems>
|
<field>Consum_Apply_Equipment_Set__c.Cancel_Select__c</field>
|
<operation>equals</operation>
|
<value>False</value>
|
</summaryFilterItems>
|
<summaryForeignKey>Consum_Apply_Equipment_Set__c.Consum_Apply__c</summaryForeignKey>
|
<summaryOperation>sum</summaryOperation>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Summary</type>
|
</fields>
|
<fields>
|
<fullName>ZongjianApprovalManager__c</fullName>
|
<deleteConstraint>SetNull</deleteConstraint>
|
<externalId>false</externalId>
|
<label>总监</label>
|
<referenceTo>User</referenceTo>
|
<relationshipName>ZongjianKr1vConsum</relationshipName>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Lookup</type>
|
</fields>
|
<fields>
|
<fullName>Zongjian_eq_TongkuoZongjian__c</fullName>
|
<externalId>false</externalId>
|
<formula>ZongjianApprovalManager__c = TongkuoZongjian__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>总监=统括总监</label>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Checkbox</type>
|
</fields>
|
<fields>
|
<fullName>applyUser__c</fullName>
|
<deleteConstraint>SetNull</deleteConstraint>
|
<externalId>false</externalId>
|
<label>操作者</label>
|
<referenceTo>User</referenceTo>
|
<relationshipName>E86rConsum</relationshipName>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Lookup</type>
|
</fields>
|
<fields>
|
<fullName>borrow_application_date1__c</fullName>
|
<externalId>false</externalId>
|
<label>照片首次上传日期(borrow_application)</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>DateTime</type>
|
</fields>
|
<fields>
|
<fullName>borrow_application_date__c</fullName>
|
<externalId>false</externalId>
|
<label>照片上传日期(borrow_application)</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>DateTime</type>
|
</fields>
|
<fields>
|
<fullName>demo_purpose2__c</fullName>
|
<externalId>false</externalId>
|
<label>出借目的</label>
|
<required>false</required>
|
<trackHistory>true</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Picklist</type>
|
<valueSet>
|
<valueSetDefinition>
|
<sorted>false</sorted>
|
<value>
|
<fullName>学会展会</fullName>
|
<default>false</default>
|
<label>学会展会</label>
|
</value>
|
<value>
|
<fullName>OPD试用</fullName>
|
<default>false</default>
|
<label>OPD试用</label>
|
</value>
|
<value>
|
<fullName>索赔QIS</fullName>
|
<default>false</default>
|
<label>索赔QIS</label>
|
</value>
|
<value>
|
<fullName>动物实验</fullName>
|
<default>false</default>
|
<label>动物实验</label>
|
</value>
|
<value>
|
<fullName>ET展箱</fullName>
|
<default>false</default>
|
<label>ET展箱</label>
|
</value>
|
<value>
|
<fullName>其他</fullName>
|
<default>false</default>
|
<label>其他</label>
|
</value>
|
</valueSetDefinition>
|
</valueSet>
|
</fields>
|
<fields>
|
<fullName>direct_send__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>经销商</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>direct_shippment_address__c</fullName>
|
<externalId>false</externalId>
|
<label>直送发送地址</label>
|
<length>250</length>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>faraway__c</fullName>
|
<description>2019/06/04修改前：
|
Case(Province__c,
|
'内蒙古自治区','1',
|
'青海省','1',
|
'宁夏回族自治区','1',
|
'新疆维吾尔自治区','1',
|
'黑龙江','1',
|
'吉林省','1',
|
'云南省',IF(HP_City__c = '昆明市', '0', '1'),
|
'0'
|
)
|
追加甘肃省</description>
|
<externalId>false</externalId>
|
<formula>Case(Province__c,
|
'内蒙古自治区','1',
|
'青海省','1',
|
'宁夏回族自治区','1',
|
'新疆维吾尔自治区','1',
|
'黑龙江','1',
|
'吉林省','1',
|
'甘肃省','1',
|
'云南省',IF(HP_City__c = '昆明市', '0', '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>isCanceled_TF_Set_Cnt__c</fullName>
|
<externalId>false</externalId>
|
<label>被动取消一览数</label>
|
<summaryFilterItems>
|
<field>Consum_Apply_Equipment_Set__c.Cancel_Select__c</field>
|
<operation>equals</operation>
|
<value>True</value>
|
</summaryFilterItems>
|
<summaryFilterItems>
|
<field>Consum_Apply_Equipment_Set__c.Cancel_Reason__c</field>
|
<operation>equals</operation>
|
<value>被动取消</value>
|
</summaryFilterItems>
|
<summaryFilterItems>
|
<field>Consum_Apply_Equipment_Set__c.Loaner_cancel_Remarks__c</field>
|
<operation>equals</operation>
|
<value>本一览60天内无库存，取消一览申请</value>
|
</summaryFilterItems>
|
<summaryForeignKey>Consum_Apply_Equipment_Set__c.Consum_Apply__c</summaryForeignKey>
|
<summaryOperation>count</summaryOperation>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Summary</type>
|
</fields>
|
<fields>
|
<fullName>isCanceled_TF__c</fullName>
|
<defaultValue>false</defaultValue>
|
<externalId>false</externalId>
|
<label>被动取消</label>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Checkbox</type>
|
</fields>
|
<fields>
|
<fullName>loaner_Status__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(Consum_Apply_Equipment_Set_Cnt__c > 0,
|
IF ( Yi_loaner_arranged__c > 0,
|
IF (AND (Shippment_ng_num__c < Consum_Apply_Equipment_Set_Cnt__c, Shippment_ng_num__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>next_action_Text__c</fullName>
|
<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>next_action__c</fullName>
|
<externalId>false</externalId>
|
<formula>TEXT(QIS_number__r.next_action__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>photoType__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>borrow_application</fullName>
|
<default>true</default>
|
<label>borrow_application</label>
|
</value>
|
</valueSetDefinition>
|
</valueSet>
|
</fields>
|
<fields>
|
<fullName>pickup_time__c</fullName>
|
<externalId>false</externalId>
|
<label>自提时间</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>DateTime</type>
|
</fields>
|
<fields>
|
<fullName>requestNoJoinStr1__c</fullName>
|
<description>text( CreatedBy.Province__c )</description>
|
<externalId>false</externalId>
|
<formula>IF(TEXT(Owner:User.Dept__c) ="能量事业本部","EN",
|
IF(TEXT(Owner:User.Dept__c) ="医疗产品培训本部","CP",
|
IF(TEXT(Owner:User.Dept__c) ="外科事业本部","SP",
|
IF(TEXT(Owner:User.Dept__c) ="消化·呼吸内镜事业本部","GI",
|
IF(TEXT(Owner:User.Dept__c) ="MA本部","MA",
|
IF(TEXT(Owner:User.Dept__c) ="医疗备品管理中心","BP",
|
IF(TEXT(Owner:User.Dept__c) ="医疗服务本部","FW",
|
IF(TEXT(Owner:User.Dept__c) ="市场企划本部","MP",
|
IF(TEXT(Owner:User.Dept__c) ="消化·呼吸领域解决方案本部","EP",
|
Case(text(Owner:User.Province__c),
|
"安徽省","HD",
|
"北京市","HB",
|
"福建省","HD",
|
"甘肃省","XB",
|
"广东省","HN",
|
"广西自治区","HN",
|
"贵州省","XN",
|
"海南省","HN",
|
"河北省","HB",
|
"河南省","XB",
|
"黑龙江省","DB",
|
"湖北省","HN",
|
"湖南省","HN",
|
"吉林省","DB",
|
"江苏省","HD",
|
"江西省","HD",
|
"辽宁省","DB",
|
"大连市","DB",
|
"内蒙古","HB",
|
"宁夏自治区","XB",
|
"青海省","XB",
|
"山东省","HB",
|
"青岛市","HB",
|
"山西省","XB",
|
"陕西省","XB",
|
"上海市","HD",
|
"四川省","XN",
|
"天津市","HB",
|
"西藏自治区","XN",
|
"新疆自治区","XB",
|
"云南省","XN",
|
"浙江省","HD",
|
"深圳市","HN",
|
"重庆市","XN","")
|
) ))))))))
|
+'-'+
|
IF(NOT(ISBLANK(Text(Product_category__c))),Text(Product_category__c),'ET')</formula>
|
<label>申请No.用字符1</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>requestNoJoinStr2__c</fullName>
|
<displayFormat>{00000}</displayFormat>
|
<externalId>false</externalId>
|
<label>申请No.用字符2</label>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>AutoNumber</type>
|
</fields>
|
<fields>
|
<fullName>requestNoJoinStr3_New__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(YEAR(DATEVALUE(CreatedDate)) <= 2021 && month(DATEVALUE(CreatedDate)) <= 3,
|
text(YEAR(DATEVALUE(CreatedDate)) - 1- 1867) & "P" &
|
IF(OR(month(DATEVALUE(CreatedDate)) <=3, month(DATEVALUE(CreatedDate)) >=10), "B", "A"),
|
if(YEAR(DATEVALUE(CreatedDate)) < 2021 && month(DATEVALUE(CreatedDate)) > 3,
|
text(YEAR(DATEVALUE(CreatedDate))- 1867 ) & "P" &
|
IF(OR(month(DATEVALUE(CreatedDate)) <=3, month(DATEVALUE(CreatedDate)) >=10), "B", "A"),
|
(if(month(DATEVALUE(CreatedDate)) <= 3,
|
"FY" & text(YEAR(DATEVALUE(CreatedDate))) , "FY" & text(YEAR(DATEVALUE(CreatedDate))+1))&
|
IF(OR(month(DATEVALUE(CreatedDate)) <=3, month(DATEVALUE(CreatedDate)) >=10), " 2H’", " 1H’")
|
)
|
)
|
)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>申请No.用字符3</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>requestNoJoinStr3__c</fullName>
|
<externalId>false</externalId>
|
<formula>Case((year(DATEVALUE(CreatedDate))+
|
Case(month(DATEVALUE(CreatedDate)),
|
1,-1,
|
2,-1,
|
3,-1,0)),
|
2025,"158P",
|
2024,"157P",
|
2023,"156P",
|
2022,"155P",
|
2021,"154P",
|
2020,"153P",
|
2019,"152P",
|
2018,"151P",
|
2017,"150P",
|
2016,"149P",
|
2015,"148P",
|
2014,"147P",
|
2013,"146P",
|
2012,"145P",
|
2011,"144P",
|
2010,"143P",
|
2009,"142P",
|
2008,"141P",
|
2007,"140P",
|
2006,"139P",
|
2005,"138P",
|
2004,"137P",
|
"ERROR") &
|
CASE(month(DATEVALUE(CreatedDate))
|
,4,"A",5,"A",6,"A",7,"A",8,"A",9,"A",
|
10,"B",11,"B",12,"B",1,"B",2,"B",3,"B","")</formula>
|
<label>申请No.用字符3(Old)</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>returned_without_onStock__c</fullName>
|
<description>不包含NG项目</description>
|
<externalId>false</externalId>
|
<label>????已归还未上架数量</label>
|
<summaryFilterItems>
|
<field>Consum_Apply_Equipment_Set__c.Asset_return_time__c</field>
|
<operation>notEqual</operation>
|
<value></value>
|
</summaryFilterItems>
|
<summaryFilterItems>
|
<field>Consum_Apply_Equipment_Set__c.Received_Confirm__c</field>
|
<operation>notEqual</operation>
|
<value>NG</value>
|
</summaryFilterItems>
|
<summaryForeignKey>Consum_Apply_Equipment_Set__c.Consum_Apply__c</summaryForeignKey>
|
<summaryOperation>count</summaryOperation>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Summary</type>
|
</fields>
|
<label>耗材备品申请</label>
|
<listViews>
|
<fullName>All_Draft</fullName>
|
<columns>NAME</columns>
|
<columns>Account__c</columns>
|
<columns>demo_purpose2__c</columns>
|
<columns>Person_In_Charge__c</columns>
|
<columns>RA_Status__c</columns>
|
<columns>Demo_purpose_text__c</columns>
|
<columns>Request_shipping_day__c</columns>
|
<columns>Asset_loaner_start_date__c</columns>
|
<columns>CREATEDBY_USER</columns>
|
<columns>applyUser__c</columns>
|
<filterScope>Everything</filterScope>
|
<filters>
|
<field>RA_Status__c</field>
|
<operation>equals</operation>
|
<value>草案中</value>
|
</filters>
|
<label>02_草案中耗材备品申请</label>
|
<language>zh_CN</language>
|
</listViews>
|
<listViews>
|
<fullName>All_ReturnShipped</fullName>
|
<columns>NAME</columns>
|
<columns>RA_Status__c</columns>
|
<columns>demo_purpose2__c</columns>
|
<columns>Account__c</columns>
|
<columns>Request_shipping_day__c</columns>
|
<columns>Asset_loaner_start_date__c</columns>
|
<columns>Asset_return_time__c</columns>
|
<columns>Person_In_Charge__c</columns>
|
<columns>applyUser__c</columns>
|
<columns>Consum_Apply_Equipment_Set_Detail_Cnt__c</columns>
|
<filterScope>Everything</filterScope>
|
<filters>
|
<field>RA_Status__c</field>
|
<operation>contains</operation>
|
<value>已回寄</value>
|
</filters>
|
<label>07_已回寄的耗材备品申请</label>
|
<language>zh_CN</language>
|
</listViews>
|
<listViews>
|
<fullName>All_Returned</fullName>
|
<columns>NAME</columns>
|
<columns>RA_Status__c</columns>
|
<columns>demo_purpose2__c</columns>
|
<columns>Account__c</columns>
|
<columns>Request_shipping_day__c</columns>
|
<columns>Asset_loaner_start_date__c</columns>
|
<columns>Bollow_Date__c</columns>
|
<columns>Asset_return_day2__c</columns>
|
<columns>Person_In_Charge__c</columns>
|
<columns>applyUser__c</columns>
|
<filterScope>Everything</filterScope>
|
<filters>
|
<field>RA_Status__c</field>
|
<operation>equals</operation>
|
<value>完了,完毕</value>
|
</filters>
|
<label>08_完了的耗材备品申请</label>
|
<language>zh_CN</language>
|
</listViews>
|
<listViews>
|
<fullName>All_Sellected</fullName>
|
<columns>NAME</columns>
|
<columns>RA_Status__c</columns>
|
<columns>demo_purpose2__c</columns>
|
<columns>Account__c</columns>
|
<columns>Request_approval_day__c</columns>
|
<columns>Request_shipping_day__c</columns>
|
<columns>Asset_loaner_start_date__c</columns>
|
<columns>Person_In_Charge__c</columns>
|
<columns>applyUser__c</columns>
|
<filterScope>Everything</filterScope>
|
<filters>
|
<field>RA_Status__c</field>
|
<operation>equals</operation>
|
<value>已分配,已出库指示</value>
|
</filters>
|
<label>05_已分配的耗材备品申请</label>
|
<language>zh_CN</language>
|
</listViews>
|
<listViews>
|
<fullName>All_Shipped</fullName>
|
<columns>NAME</columns>
|
<columns>RA_Status__c</columns>
|
<columns>demo_purpose2__c</columns>
|
<columns>Product_category__c</columns>
|
<columns>Account__c</columns>
|
<columns>Request_shipping_day__c</columns>
|
<columns>Asset_loaner_start_date__c</columns>
|
<columns>Bollow_Date__c</columns>
|
<columns>Person_In_Charge__c</columns>
|
<columns>applyUser__c</columns>
|
<filterScope>Everything</filterScope>
|
<filters>
|
<field>RA_Status__c</field>
|
<operation>equals</operation>
|
<value>已出库,申请者已收货,待消耗</value>
|
</filters>
|
<label>06_已出库的耗材备品申请</label>
|
<language>zh_CN</language>
|
</listViews>
|
<listViews>
|
<fullName>All_Waiting_approved</fullName>
|
<columns>NAME</columns>
|
<columns>RA_Status__c</columns>
|
<columns>demo_purpose2__c</columns>
|
<columns>Account__c</columns>
|
<columns>Request_shipping_day__c</columns>
|
<columns>Asset_loaner_start_date__c</columns>
|
<columns>Person_In_Charge__c</columns>
|
<columns>applyUser__c</columns>
|
<columns>CREATED_DATE</columns>
|
<filterScope>Everything</filterScope>
|
<filters>
|
<field>RA_Status__c</field>
|
<operation>contains</operation>
|
<value>申请中</value>
|
</filters>
|
<label>03_申请中的耗材备品申请</label>
|
<language>zh_CN</language>
|
</listViews>
|
<listViews>
|
<fullName>All_Waiting_approved01</fullName>
|
<columns>NAME</columns>
|
<columns>Person_In_Charge__c</columns>
|
<columns>Salesdept__c</columns>
|
<columns>Owner_province__c</columns>
|
<columns>RA_Status__c</columns>
|
<columns>demo_purpose2__c</columns>
|
<columns>Account__c</columns>
|
<columns>Request_shipping_day__c</columns>
|
<columns>Asset_loaner_start_date__c</columns>
|
<columns>Bollow_Date__c</columns>
|
<columns>applyUser__c</columns>
|
<columns>CREATED_DATE</columns>
|
<columns>Consum_Apply_Equipment_Set_Detail_Cnt__c</columns>
|
<filterScope>Everything</filterScope>
|
<label>01_全部耗材备品申请</label>
|
<language>zh_CN</language>
|
</listViews>
|
<listViews>
|
<fullName>All_Waiting_approved14</fullName>
|
<columns>NAME</columns>
|
<columns>RA_Status__c</columns>
|
<columns>Person_In_Charge__c</columns>
|
<columns>demo_purpose2__c</columns>
|
<columns>Account__c</columns>
|
<columns>Request_shipping_day__c</columns>
|
<columns>Asset_loaner_start_date__c</columns>
|
<columns>applyUser__c</columns>
|
<filterScope>Everything</filterScope>
|
<filters>
|
<field>RA_Status__c</field>
|
<operation>notEqual</operation>
|
<value>草案中</value>
|
</filters>
|
<label>09_全部耗材备品申请（不含草案中的）</label>
|
<language>zh_CN</language>
|
</listViews>
|
<listViews>
|
<fullName>All_approved</fullName>
|
<columns>NAME</columns>
|
<columns>RA_Status__c</columns>
|
<columns>demo_purpose2__c</columns>
|
<columns>Account__c</columns>
|
<columns>Request_demo_day__c</columns>
|
<columns>Request_shipping_day__c</columns>
|
<columns>Asset_loaner_start_date__c</columns>
|
<columns>applyUser__c</columns>
|
<columns>Consum_Apply_Equipment_Set_Detail_Cnt__c</columns>
|
<filterScope>Everything</filterScope>
|
<filters>
|
<field>RA_Status__c</field>
|
<operation>contains</operation>
|
<value>已批准</value>
|
</filters>
|
<label>04_已批准的耗材备品申请</label>
|
<language>zh_CN</language>
|
</listViews>
|
<nameField>
|
<label>申请No.</label>
|
<trackHistory>false</trackHistory>
|
<type>Text</type>
|
</nameField>
|
<recordTypeTrackHistory>false</recordTypeTrackHistory>
|
<recordTypes>
|
<fullName>StandardRequest</fullName>
|
<active>true</active>
|
<label>耗材申请</label>
|
<picklistValues>
|
<picklist>Cancel_Reason__c</picklist>
|
<values>
|
<fullName>主动取消</fullName>
|
<default>false</default>
|
</values>
|
<values>
|
<fullName>被动取消</fullName>
|
<default>false</default>
|
</values>
|
</picklistValues>
|
<picklistValues>
|
<picklist>Product_category__c</picklist>
|
<values>
|
<fullName>DISP</fullName>
|
<default>false</default>
|
</values>
|
<values>
|
<fullName>ET</fullName>
|
<default>false</default>
|
</values>
|
</picklistValues>
|
<picklistValues>
|
<picklist>Return_Distrubutor_Method__c</picklist>
|
<values>
|
<fullName>优先达</fullName>
|
<default>false</default>
|
</values>
|
<values>
|
<fullName>普达</fullName>
|
<default>false</default>
|
</values>
|
<values>
|
<fullName>空运</fullName>
|
<default>false</default>
|
</values>
|
<values>
|
<fullName>陆运</fullName>
|
<default>false</default>
|
</values>
|
</picklistValues>
|
<picklistValues>
|
<picklist>Return_Track_Company__c</picklist>
|
<values>
|
<fullName>利讯</fullName>
|
<default>false</default>
|
</values>
|
<values>
|
<fullName>嘉里大通</fullName>
|
<default>false</default>
|
</values>
|
<values>
|
<fullName>慧通速递</fullName>
|
<default>false</default>
|
</values>
|
<values>
|
<fullName>联邦快递Fedex</fullName>
|
<default>false</default>
|
</values>
|
<values>
|
<fullName>莱比特</fullName>
|
<default>false</default>
|
</values>
|
</picklistValues>
|
<picklistValues>
|
<picklist>Split_Apply_Reason__c</picklist>
|
<values>
|
<fullName>分批发货分单</fullName>
|
<default>false</default>
|
</values>
|
<values>
|
<fullName>到货NG分单</fullName>
|
<default>false</default>
|
</values>
|
</picklistValues>
|
<picklistValues>
|
<picklist>Status__c</picklist>
|
<values>
|
<fullName>不批准</fullName>
|
<default>false</default>
|
</values>
|
<values>
|
<fullName>删除</fullName>
|
<default>false</default>
|
</values>
|
<values>
|
<fullName>取消</fullName>
|
<default>false</default>
|
</values>
|
<values>
|
<fullName>填写完毕</fullName>
|
<default>false</default>
|
</values>
|
<values>
|
<fullName>已出库指示</fullName>
|
<default>false</default>
|
</values>
|
<values>
|
<fullName>已批准</fullName>
|
<default>false</default>
|
</values>
|
<values>
|
<fullName>申请中</fullName>
|
<default>false</default>
|
</values>
|
<values>
|
<fullName>草案中</fullName>
|
<default>true</default>
|
</values>
|
</picklistValues>
|
<picklistValues>
|
<picklist>demo_purpose2__c</picklist>
|
<values>
|
<fullName>ET展箱</fullName>
|
<default>false</default>
|
</values>
|
<values>
|
<fullName>OPD试用</fullName>
|
<default>false</default>
|
</values>
|
<values>
|
<fullName>其他</fullName>
|
<default>false</default>
|
</values>
|
<values>
|
<fullName>动物实验</fullName>
|
<default>false</default>
|
</values>
|
<values>
|
<fullName>学会展会</fullName>
|
<default>false</default>
|
</values>
|
<values>
|
<fullName>索赔QIS</fullName>
|
<default>false</default>
|
</values>
|
</picklistValues>
|
<picklistValues>
|
<picklist>direct_send__c</picklist>
|
<values>
|
<fullName>上门自提</fullName>
|
<default>false</default>
|
</values>
|
<values>
|
<fullName>会场地</fullName>
|
<default>false</default>
|
</values>
|
<values>
|
<fullName>办事处</fullName>
|
<default>false</default>
|
</values>
|
<values>
|
<fullName>医疗机构</fullName>
|
<default>false</default>
|
</values>
|
<values>
|
<fullName>经销商</fullName>
|
<default>false</default>
|
</values>
|
</picklistValues>
|
<picklistValues>
|
<picklist>photoType__c</picklist>
|
<values>
|
<fullName>borrow_application</fullName>
|
<default>true</default>
|
</values>
|
</picklistValues>
|
</recordTypes>
|
<searchLayouts>
|
<customTabListAdditionalFields>RA_Status__c</customTabListAdditionalFields>
|
<customTabListAdditionalFields>demo_purpose2__c</customTabListAdditionalFields>
|
<customTabListAdditionalFields>Hospital__c</customTabListAdditionalFields>
|
<customTabListAdditionalFields>Account__c</customTabListAdditionalFields>
|
<customTabListAdditionalFields>Request_shipping_day__c</customTabListAdditionalFields>
|
<customTabListAdditionalFields>Asset_loaner_start_date__c</customTabListAdditionalFields>
|
<customTabListAdditionalFields>Person_In_Charge__c</customTabListAdditionalFields>
|
<lookupDialogsAdditionalFields>RA_Status__c</lookupDialogsAdditionalFields>
|
<lookupDialogsAdditionalFields>demo_purpose2__c</lookupDialogsAdditionalFields>
|
<lookupDialogsAdditionalFields>Hospital__c</lookupDialogsAdditionalFields>
|
<lookupDialogsAdditionalFields>Account__c</lookupDialogsAdditionalFields>
|
<lookupDialogsAdditionalFields>Request_shipping_day__c</lookupDialogsAdditionalFields>
|
<lookupDialogsAdditionalFields>Asset_loaner_start_date__c</lookupDialogsAdditionalFields>
|
<lookupDialogsAdditionalFields>Bollow_Date__c</lookupDialogsAdditionalFields>
|
<lookupDialogsAdditionalFields>Person_In_Charge__c</lookupDialogsAdditionalFields>
|
<searchResultsAdditionalFields>RA_Status__c</searchResultsAdditionalFields>
|
<searchResultsAdditionalFields>demo_purpose2__c</searchResultsAdditionalFields>
|
<searchResultsAdditionalFields>Hospital__c</searchResultsAdditionalFields>
|
<searchResultsAdditionalFields>Account__c</searchResultsAdditionalFields>
|
<searchResultsAdditionalFields>Request_shipping_day__c</searchResultsAdditionalFields>
|
<searchResultsAdditionalFields>Asset_loaner_start_date__c</searchResultsAdditionalFields>
|
<searchResultsAdditionalFields>Bollow_Date__c</searchResultsAdditionalFields>
|
<searchResultsAdditionalFields>Cancel_time__c</searchResultsAdditionalFields>
|
</searchLayouts>
|
<sharingModel>Private</sharingModel>
|
<sharingReasons>
|
<fullName>ApplyUserShare__c</fullName>
|
<label>ApplyUserShare</label>
|
</sharingReasons>
|
<validationRules>
|
<fullName>After_Approval_Can_Not_Change_Status</fullName>
|
<active>true</active>
|
<errorConditionFormula>(ISPICKVAL(Status__c,'草案中')
|
|| ISPICKVAL(Status__c,'填写完毕')
|
|| ISPICKVAL(Status__c,'申请中')
|
)
|
&&
|
(ISPICKVAL(PRIORVALUE(Status__c),'已批准')
|
|| ISPICKVAL(PRIORVALUE(Status__c),'已出库指示')
|
|| ISPICKVAL(PRIORVALUE(Status__c),'删除')
|
|| ISPICKVAL(PRIORVALUE(Status__c),'取消')
|
)</errorConditionFormula>
|
<errorDisplayField>Status__c</errorDisplayField>
|
<errorMessage>【已批准，已出库指示，删除，取消】的耗材申请状态不能变更为【草案中，填写完毕，申请中】</errorMessage>
|
</validationRules>
|
<validationRules>
|
<fullName>After_Request_approve</fullName>
|
<active>true</active>
|
<description>申请单批准后，不能编辑耗材备品借用信息</description>
|
<errorConditionFormula>((TEXT( Status__c) <> '草案中' && TEXT( Status__c) <> '填写完毕' && TEXT( Status__c) <> '申请中' ))
|
&&
|
(($User.ProfileId <>'00e10000000Y3o5')&&
|
($User.ProfileId <>'00e10000000xnoT')&&
|
($User.ProfileId <>'00e10000000xo1D')
|
)
|
&&
|
(ISCHANGED(Person_In_Charge__c) || ISCHANGED(applyUser__c) || ISCHANGED(ApplyPerson_Phone__c) || ISCHANGED(Hospital__c) || ISCHANGED(Strategic_dept__c) || ISCHANGED(Account__c) || ISCHANGED(Loaner_medical_Staff__c) || ISCHANGED(Phone_number__c) || ISCHANGED(demo_purpose2__c) || ISCHANGED(Product_category__c) || ISCHANGED(AnimalExerimentFlag__c) || ISCHANGED(Campaign__c)|| ISCHANGED(Demo_purpose_text__c) || ISCHANGED(Request_demo_detail__c) || ISCHANGED(Request_shipping_day__c) ||
|
ISCHANGED(Shipment_address__c) || ISCHANGED(Dealer__c)
|
|| ISCHANGED(Loaner_received_staff__c) || ISCHANGED(direct_shippment_address__c) || ISCHANGED(direct_send__c) || ISCHANGED(pickup_time__c) || ISCHANGED(Loaner_received_staff_phone__c) || ISCHANGED(Post_Code__c) || ISCHANGED(Is_Special_Rental__c)
|
)
|
&& NOT($User.Batch_User__c) && NOT($User.Batch_User__c) && $User.ProfileId <>'00e10000000dEQx'</errorConditionFormula>
|
<errorMessage>申请单批准后，不能编辑耗材备品借用信息</errorMessage>
|
</validationRules>
|
<validationRules>
|
<fullName>After_Sign_NG_Reason</fullName>
|
<active>true</active>
|
<errorConditionFormula>HP_received_sign_NG__c = TRUE &&
|
ISBLANK(HP_received_sign_NG_Reason__c)</errorConditionFormula>
|
<errorDisplayField>HP_received_sign_NG_Reason__c</errorDisplayField>
|
<errorMessage>签收单不合格时，必须输入不合格理由</errorMessage>
|
</validationRules>
|
<validationRules>
|
<fullName>Applicant_CancelReason_Active_Only</fullName>
|
<active>true</active>
|
<errorConditionFormula>(($User.ProfileId <>'00e10000000Y3o5')&&
|
($User.ProfileId <>'00e10000000xnoT')&&
|
(NOT(CONTAINS($Label.ProfileId_EquCenAdmin, $User.ProfileId)))&&
|
($User.ProfileId <>'00e10000000xo1D') &&
|
(NOT(CONTAINS($Label.ProfileId_EquCenCheckAndDepot, $User.ProfileId))))
|
&& Text(Cancel_Reason__c) <> '主动取消'
|
&& ISPICKVAL(Status__c, '取消') && NOT($User.Batch_User__c) && $User.ProfileId <>'00e10000000dEQx'</errorConditionFormula>
|
<errorDisplayField>Cancel_Reason__c</errorDisplayField>
|
<errorMessage>申请人只能选择主动取消。</errorMessage>
|
</validationRules>
|
<validationRules>
|
<fullName>Applicant_Check</fullName>
|
<active>false</active>
|
<errorConditionFormula>(ISNEW()|| TEXT(Status__c)='草案中')&&(
|
(
|
((TEXT(demo_purpose2__c)='学会展会' && Campaign__r.RecordTypeId =='01210000000R26P' && (TEXT(Owner:User.Job_Category__c )<>'销售服务'&& TEXT(Owner:User.Job_Category__c )<>'销售推广'&& TEXT(Owner:User.Job_Category__c )<>'销售市场'&& TEXT(Owner:User.Job_Category__c )<>'培训'))
|
)&&($User.ProfileId <>'00e10000000Y3o5')&&
|
($User.ProfileId <>'00e10000000dEQx')&&
|
($User.ProfileId <>'00e10000000xnoT')&&
|
TEXT(Owner:User.Job_Category__c )<>'支援' ||
|
((TEXT(demo_purpose2__c)='学会展会' && Campaign__r.RecordTypeId !='01210000000R26P' && TEXT(Owner:User.Job_Category__c )<>'销售推广'
|
&& TEXT(Owner:User.Job_Category__c )<>'销售市场'&& TEXT(Owner:User.Job_Category__c )<>'培训'
|
&& TEXT(Owner:User.Job_Category__c )<>'GI市场'
|
&& TEXT(Owner:User.Job_Category__c )<>'SP市场'
|
&& TEXT(Owner:User.Job_Category__c )<>'管理'
|
&& TEXT(Owner:User.Job_Category__c )<>'市场'
|
&& TEXT(Owner:User.Job_Category__c )<>'MA'
|
)
|
)&&($User.ProfileId <>'00e10000000Y3o5')&&
|
($User.ProfileId <>'00e10000000dEQx')&&
|
($User.ProfileId <>'00e10000000xnoT')&&
|
TEXT(Owner:User.Job_Category__c )<>'支援'
|
)||
|
|
(
|
(
|
TEXT(demo_purpose2__c)='试用（无询价）'||
|
TEXT(demo_purpose2__c)='试用（有询价）'||
|
TEXT(demo_purpose2__c)='已购待货'
|
|
)&&(
|
($User.ProfileId <>'00e10000000Y3o5')&&
|
($User.ProfileId <>'00e10000000dEQx')&&
|
($User.ProfileId <>'00e10000000xnoT')&&
|
($User.ProfileId <>'00e10000000xo1D')&&
|
TEXT(Owner:User.Job_Category__c )<>'支援'&&
|
TEXT(Owner:User.Job_Category__c )<>'销售推广' &&
|
TEXT(Owner:User.Job_Category__c )<>'GI市场' &&
|
TEXT(Owner:User.Job_Category__c )<>'SP市场' &&
|
TEXT(Owner:User.Job_Category__c )<>'管理' &&
|
TEXT(Owner:User.Job_Category__c )<>'市场'&&
|
TEXT(Owner:User.Job_Category__c )<>'销售市场' )
|
)||(
|
(TEXT(demo_purpose2__c)='新产品评价')
|
&&(
|
TEXT(Owner:User.Dept__c)<> '消化·呼吸内镜事业本部'&&
|
TEXT(Owner:User.Dept__c)<> '外科事业本部'&&
|
TEXT(Owner:User.Dept__c)<> '能量事业本部'
|
)
|
|
)||((TEXT(demo_purpose2__c)='一般用户'||
|
TEXT(demo_purpose2__c)='再修理'||
|
TEXT(demo_purpose2__c)='保修用户'||
|
TEXT(demo_purpose2__c)='索赔QIS'
|
|
)&&(
|
($User.ProfileId <>'00e10000000Y3o5')&&
|
($User.ProfileId <>'00e10000000xnoT')&&
|
($User.ProfileId <>'00e10000000xo1D')&&
|
TEXT(Owner:User.Job_Category__c )<>'支援'&&
|
TEXT(Owner:User.Job_Category__c )<>'销售服务'
|
)
|
)||((
|
TEXT(Demo_purpose1__c)='协议借用'
|
)&&(
|
($User.ProfileId <>'00e10000000Y3o5')&&
|
TEXT(Owner:User.Job_Category__c )<>'支援'&&
|
TEXT(Owner:User.Job_Category__c )<>'销售推广' &&
|
TEXT(Owner:User.Job_Category__c )<>'销售服务' &&
|
TEXT(Owner:User.Job_Category__c )<>'MA' &&
|
TEXT(Owner:User.Job_Category__c )<>'市场' &&
|
TEXT(Owner:User.Job_Category__c )<>'管理'
|
)
|
|
)
|
)
|
&& NOT($User.Batch_User__c) && $User.ProfileId <>'00e10000000dEQx'</errorConditionFormula>
|
<errorMessage>申请者的权限不符合该‘使用目的’的提出要求</errorMessage>
|
</validationRules>
|
<validationRules>
|
<fullName>Applicant_Set_Must_One</fullName>
|
<active>true</active>
|
<errorConditionFormula>TEXT(Status__c)='填写完毕' &&
|
Consum_Apply_Equipment_Set_Detail_Cnt__c = 0</errorConditionFormula>
|
<errorMessage>至少申请一个耗材</errorMessage>
|
</validationRules>
|
<validationRules>
|
<fullName>Before_Request_Apporve</fullName>
|
<active>true</active>
|
<description>不能编辑取消理由</description>
|
<errorConditionFormula>(RA_Status__c <> '草案中' &&
|
RA_Status__c <> '已批准'
|
&& RA_Status__c <> '已分配' )
|
&&
|
(($User.ProfileId <>'00e10000000Y3o5')&&
|
($User.ProfileId <>'00e10000000xnoT')&&
|
(NOT(CONTAINS($Label.ProfileId_EquCenCheckAndDepot, $User.ProfileId)))&&
|
($User.ProfileId <>'00e10000000xo1D')
|
)
|
&&
|
ISCHANGED(Loaner_cancel_request__c)</errorConditionFormula>
|
<errorMessage>不能编辑取消理由</errorMessage>
|
</validationRules>
|
<validationRules>
|
<fullName>Campaign_CancelStatus_Confim</fullName>
|
<active>true</active>
|
<description>学会取消状态确认</description>
|
<errorConditionFormula>AND( TEXT(demo_purpose2__c) = '学会展会',NOT($User.Batch_User__c),
|
IF( Campaign__c != null ,
|
IF( TEXT(Campaign__r.Status) = '取消' , true, false),
|
false))&&or(isnew(),text(Status__c)=='草案中')&& Not(ischanged(Loaner_cancel_request__c))</errorConditionFormula>
|
<errorMessage>学会已取消，不能保存</errorMessage>
|
</validationRules>
|
<validationRules>
|
<fullName>Campaign_CancelingStatus_Confim</fullName>
|
<active>true</active>
|
<description>学会取消申请状态确认</description>
|
<errorConditionFormula>AND( TEXT(demo_purpose2__c) = '学会展会',
|
IF( Campaign__c != null ,
|
IF( TEXT(Campaign__r.Status) = '取消申请中' , true, false),
|
false))&&or(isnew(),text(Status__c)=='草案中')&& Not(ischanged(Loaner_cancel_request__c))</errorConditionFormula>
|
<errorMessage>学会取消申请中，不能保存</errorMessage>
|
</validationRules>
|
<validationRules>
|
<fullName>Campaign_EndStatus_Confim</fullName>
|
<active>true</active>
|
<description>AND( TEXT(demo_purpose2__c) = '学会展会',
|
IF( Campaign__c != null ,
|
IF( TEXT(Campaign__r.Status) = '已结束' , true, false),
|
false))&&or(isnew(),text(Status__c)=='草案中')</description>
|
<errorConditionFormula>AND( TEXT(demo_purpose2__c) = '学会展会',
|
IF( Campaign__c != null , IF( TEXT(Campaign__r.Status) = '已结束' , true, false),
|
false))&&or(isnew(),text(Status__c)=='草案中') && Not(ischanged(Loaner_cancel_request__c)) &&
|
$User.ProfileId <>'00e10000000Y3o5'</errorConditionFormula>
|
<errorMessage>学会已结束，不能保存</errorMessage>
|
</validationRules>
|
<validationRules>
|
<fullName>Campaign_SubreportStatus_Confim</fullName>
|
<active>true</active>
|
<description>学会已提交报告状态确认</description>
|
<errorConditionFormula>AND( TEXT(demo_purpose2__c) = '学会展会',
|
IF( Campaign__c != null ,
|
IF( TEXT(Campaign__r.Status) = '已提交报告' , true, false),
|
false))&&or(isnew(),text(Status__c)=='草案中')&& Not(ischanged(Loaner_cancel_request__c))</errorConditionFormula>
|
<errorMessage>学会已提交报告，不能保存</errorMessage>
|
</validationRules>
|
<validationRules>
|
<fullName>Can_Not_Change_Status_Cao_An</fullName>
|
<active>true</active>
|
<errorConditionFormula>AND(OR(IsBlank(PRIORVALUE(Last_Assigned_Time__c)) && Not(IsBlank(Last_Assigned_Time__c)), Last_Assigned_Time__c > PRIORVALUE(Last_Assigned_Time__c)) ,
|
OR(ISPICKVAL(Status__c, '草案中')
|
, ISPICKVAL( Status__c, '填写完毕')
|
, ISPICKVAL( Status__c, '申请中')
|
, ISPICKVAL( Status__c, '不批准')
|
, ISPICKVAL( Status__c, '取消')
|
, ISPICKVAL( Status__c, '删除')
|
)
|
)</errorConditionFormula>
|
<errorDisplayField>Status__c</errorDisplayField>
|
<errorMessage>已批准后才能分配</errorMessage>
|
</validationRules>
|
<validationRules>
|
<fullName>Cannot_Cancel_When_Application</fullName>
|
<active>true</active>
|
<errorConditionFormula>ISPICKVAL(PRIORVALUE(Status__c), '申请中')
|
&& ISPICKVAL(Status__c, '取消')</errorConditionFormula>
|
<errorDisplayField>Status__c</errorDisplayField>
|
<errorMessage>需要撤回申请才能取消</errorMessage>
|
</validationRules>
|
<validationRules>
|
<fullName>Cannot_Submit_When_NOTHave_ManagerBuzhan</fullName>
|
<active>true</active>
|
<errorConditionFormula>ISPICKVAL(Status__c, '填写完毕')
|
&& ISBLANK(SalesManager__c)
|
&& ISBLANK( BuchangApprovalManagerSales__c )</errorConditionFormula>
|
<errorMessage>此批准请求需要 经理或部长 字段确定的下一个审批人。此值为空。有关详情，请与您的管理员取得联系。</errorMessage>
|
</validationRules>
|
<validationRules>
|
<fullName>Cannot_change_PIC</fullName>
|
<active>true</active>
|
<errorConditionFormula>$Profile.Id != "00e10000000Y3o5" && ISCHANGED( Person_In_Charge__c )&& RA_Status__c <> '草案中'</errorConditionFormula>
|
<errorDisplayField>Person_In_Charge__c</errorDisplayField>
|
<errorMessage>不能更改主担当</errorMessage>
|
</validationRules>
|
<validationRules>
|
<fullName>Consum_Apply_Flag_Confim</fullName>
|
<active>false</active>
|
<description>学会提前14天申请限制</description>
|
<errorConditionFormula>AND(TEXT(demo_purpose2__c) = '学会展会',
|
IF( Campaign__c <> null,if( TODAY()-Request_shipping_day__c <= 14,true,false),false))&&or(and(isnew(),isnull(Old_Consum_Apply__c)),text(Status__c)=='草案中')
|
|
|
|
&& Not(ischanged(Loaner_cancel_request__c)) && Not(ischanged(Cancel_Reason__c))
|
&& ($User.ProfileId <>'00e10000000Y3o5')</errorConditionFormula>
|
<errorMessage>申请提交必须在14天以上才可以</errorMessage>
|
</validationRules>
|
<validationRules>
|
<fullName>Detail_Cnt_Can_Not_More_Than500</fullName>
|
<active>true</active>
|
<errorConditionFormula>Yi_loaner_arranged__c = 0
|
&& Consum_Apply_Equipment_Set_Detail_Cnt__c > 500</errorConditionFormula>
|
<errorMessage>申请件数不能大于500</errorMessage>
|
</validationRules>
|
<validationRules>
|
<fullName>HP_Recieved_Required_Check</fullName>
|
<active>true</active>
|
<errorConditionFormula>and(not(isnull( HP_received_sign_day__c)),isblank( HP_received_sign_text__c),not(DataMigration_Flag__c))</errorConditionFormula>
|
<errorDisplayField>HP_received_sign_rich__c</errorDisplayField>
|
<errorMessage>请上传签收单</errorMessage>
|
</validationRules>
|
<validationRules>
|
<fullName>Must_Is_Class</fullName>
|
<active>true</active>
|
<description>必须是科室</description>
|
<errorConditionFormula>$User.ProfileId <>'00e10000000Y3o5'
|
&&
|
NOT($User.Batch_User__c)
|
&&
|
(Isnew() || Ischanged(Account__c)) && Not(Isblank(Account__c)) &&
|
OR (
|
/* 无效 ==> 报错 */
|
Account__r.Is_Active_Formula__c == "无效",
|
/* 看父记录，不是医院，不是经销商、 自己也不是医院 ==> 报错 */
|
Not(Account__r.Parent.Parent.RecordTypeId = "01210000000QemG")
|
)</errorConditionFormula>
|
<errorDisplayField>Account__c</errorDisplayField>
|
<errorMessage>科室必须是战略科室下科室</errorMessage>
|
</validationRules>
|
<validationRules>
|
<fullName>Must_Is_DeptClas</fullName>
|
<active>true</active>
|
<description>必须填写该医院下的战略科室</description>
|
<errorConditionFormula>$User.ProfileId <>'00e10000000Y3o5'
|
&&
|
NOT($User.Batch_User__c)
|
&&
|
Isnew() && OR (
|
/* 看父记录，是医院，没有选相应的战略科室 ==> 报错 */
|
AND(Account__r.Parent.Parent.RecordTypeId = "01210000000QemG",
|
Account__r.ParentId <> Strategic_dept__c
|
)
|
)</errorConditionFormula>
|
<errorDisplayField>Strategic_dept__c</errorDisplayField>
|
<errorMessage>请选择相对应的战略科室</errorMessage>
|
</validationRules>
|
<validationRules>
|
<fullName>Need_AccountInfo</fullName>
|
<active>true</active>
|
<description>必须填写医院、战略科室 和科室信息
|
|
2018/4/10之前：第二行
|
RecordTypeId <> "01210000000RHIn"</description>
|
<errorConditionFormula>(ISNEW() ||
|
TEXT(Status__c) = '草案中') &&
|
DataMigration_Flag__c <> TRUE
|
&&
|
ISBLANK(Old_Consum_Apply__c)
|
&& NOT(ISPICKVAL(demo_purpose2__c, '其他'))
|
&& NOT(ISPICKVAL(demo_purpose2__c, '动物实验'))
|
&& NOT(ISPICKVAL(demo_purpose2__c, 'ET展箱'))
|
&&
|
(ISPICKVAL(demo_purpose2__c, 'OPD试用') ||
|
ISPICKVAL(demo_purpose2__c, '索赔QIS') ||
|
(ISPICKVAL(demo_purpose2__c, '学会展会') && ISPICKVAL(direct_send__c, '医疗机构'))
|
)
|
&&
|
(ISBLANK(Hospital__c) ||
|
ISBLANK(Strategic_dept__c) ||
|
ISBLANK(Account__c)||
|
ISBLANK(Loaner_medical_Staff__c)||
|
ISBLANK(Phone_number__c)
|
)</errorConditionFormula>
|
<errorMessage>必须填写医院、战略科室 、科室、科室负责人和联系电话</errorMessage>
|
</validationRules>
|
<validationRules>
|
<fullName>Need_CampaignInfo</fullName>
|
<active>true</active>
|
<description>2016/11/18之前;
|
RecordTypeId <> "01210000000RHIn"
|
&&
|
ISBLANK(Old_Rental_ApplyConsum__c)
|
&&
|
TEXT(Demo_purpose1__c) = "学会展会"
|
&&
|
ISBLANK(Campaign__c)</description>
|
<errorConditionFormula>RecordTypeId <> "01210000000RHIn"
|
&&
|
ISBLANK(Old_Consum_Apply__c)
|
&&
|
TEXT(demo_purpose2__c) = "学会展会"
|
&&
|
ISBLANK(Campaign__c)</errorConditionFormula>
|
<errorDisplayField>Campaign__c</errorDisplayField>
|
<errorMessage>“学会展会"时，在[学会]字段必须选择学会记录</errorMessage>
|
</validationRules>
|
<validationRules>
|
<fullName>Need_QIS_input</fullName>
|
<active>true</active>
|
<errorConditionFormula>RecordTypeId <> "01210000000RHIn" &&
|
$User.ProfileId <> "00e10000000dEQx" &&
|
|
ISBLANK(Old_Consum_Apply__c) &&
|
(AND(
|
ISPICKVAL(demo_purpose2__c , "索赔QIS"),
|
|
ISBLANK(QIS_number__c)))</errorConditionFormula>
|
<errorDisplayField>QIS_number__c</errorDisplayField>
|
<errorMessage>使用目的为“索赔QIS“时，[QIS]为必填项目</errorMessage>
|
</validationRules>
|
<validationRules>
|
<fullName>New_Request_Verify</fullName>
|
<active>true</active>
|
<description>新建耗材备品申请时，不能填写回库物流信息和签字信息</description>
|
<errorConditionFormula>isnew()
|
&&
|
($User.ProfileId <>'00e10000000Y3o5')
|
&&
|
( not(ISBLANK(text(Return_Track_Company__c))) ||
|
not(ISBLANK(text(Return_Distrubutor_Method__c))) ||
|
not(ISBLANK(Return_Track_Number__c)) ||
|
not(ISBLANK(Return_Trake_Staff__c)) ||
|
not(ISBLANK(HP_received_sign_text__c))
|
|
)</errorConditionFormula>
|
<errorMessage>新建耗材备品申请时，不能填写回库物流信息和签字信息</errorMessage>
|
</validationRules>
|
<validationRules>
|
<fullName>Person_In_Charge_Not_Support</fullName>
|
<active>true</active>
|
<errorConditionFormula>(Isnew() || Text(Status__c) = '草案中') &&
|
Onwer_job_category__c = '支援' &&
|
$User.ProfileId <>'00e10000000Y3o5' &&
|
$User.ProfileId <>'00e10000000xo1D' &&
|
$User.ProfileId <>'00e10000000xnoT' &&
|
$User.ProfileId <>'00e10000000xnoY' &&
|
$User.ProfileId <>'00e100000012CwP' &&
|
$User.ProfileId <>'00e10000000xnod'&&
|
$User.ProfileId <>'00e100000012CwK'</errorConditionFormula>
|
<errorDisplayField>Person_In_Charge__c</errorDisplayField>
|
<errorMessage>助理不能做申请人。</errorMessage>
|
</validationRules>
|
<validationRules>
|
<fullName>QIS_next_action_Confim</fullName>
|
<active>true</active>
|
<description>QIS对应方法确认</description>
|
<errorConditionFormula>AND(
|
TEXT(demo_purpose2__c) = '索赔QIS',
|
TEXT(QIS_number__r.next_action__c) = '送回')&&or(isnew(),text(Status__c)=='草案中')&& Not(ischanged(Loaner_cancel_request__c)) &&
|
$User.ProfileId <>'00e10000000Y3o5'</errorConditionFormula>
|
<errorMessage>QIS的对应方法为“送回”，不可借用备品</errorMessage>
|
</validationRules>
|
<validationRules>
|
<fullName>Request_approval_day_Check</fullName>
|
<active>false</active>
|
<errorConditionFormula>TEXT(Demo_purpose1__c)<>null&& !ISPICKVAL(demo_purpose2__c, "学会展会") && (TEXT(Status__c)="填写完毕" && TODAY() < Request_shipping_day__c - 7)</errorConditionFormula>
|
<errorMessage>必须提前于希望到货日7天之内提交申请</errorMessage>
|
</validationRules>
|
<validationRules>
|
<fullName>Request_approval_day_earlier_14_day</fullName>
|
<active>false</active>
|
<errorConditionFormula>ISPICKVAL(demo_purpose2__c, "学会展会") && ( TODAY() >= Request_shipping_day__c -7)
|
&&or(and(isnew(),ISBLANK(Old_Consum_Apply__c)),text(Status__c)=='草案中',TEXT(Status__c)="填写完毕" )
|
&& Not(ischanged(Loaner_cancel_request__c)) && Not(ischanged(Cancel_Reason__c))
|
&& ($User.ProfileId <>'00e10000000Y3o5')</errorConditionFormula>
|
<errorMessage>必须提前于希望到货日7天以上提交申请</errorMessage>
|
</validationRules>
|
<validationRules>
|
<fullName>Request_cancel_reason</fullName>
|
<active>true</active>
|
<errorConditionFormula>AND( ISPICKVAL(Status__c, '取消'),
|
ISBLANK(TEXT(Cancel_Reason__c)))</errorConditionFormula>
|
<errorMessage>请输入备品申请取消理由</errorMessage>
|
</validationRules>
|
<validationRules>
|
<fullName>Request_day_need_to_bigger_than_today</fullName>
|
<active>true</active>
|
<description>DataMigration_Flag__c <> TRUE
|
&&
|
(AND( ISPICKVAL(Status__c, "草案中") ,Request_shipping_day__c < DATEVALUE(CreatedDate)) ||
|
AND(ISNEW(),Request_shipping_day__c < TODAY() ))</description>
|
<errorConditionFormula>DataMigration_Flag__c <> TRUE
|
&&
|
(AND( ISPICKVAL(Status__c, "草案中") ,Request_shipping_day__c < DATEVALUE(CreatedDate)) ||
|
AND(ISNEW(),Request_shipping_day__c < TODAY() ))
|
&&
|
AND( ISBLANK(TEXT(Split_Apply_Reason__c)), ISBLANK(Old_Consum_Apply__c) )</errorConditionFormula>
|
<errorDisplayField>Request_shipping_day__c</errorDisplayField>
|
<errorMessage>希望到货日必须未来的日期</errorMessage>
|
</validationRules>
|
<validationRules>
|
<fullName>Request_input_direct_shipping_address</fullName>
|
<active>true</active>
|
<description>AND(direct_send__c,ISBLANK(direct_shippment_address__c))</description>
|
<errorConditionFormula>(ISPICKVAL (direct_send__c,'医疗机构') || ISPICKVAL(direct_send__c,'经销商') || ISPICKVAL (direct_send__c,'会场地')) && ISBLANK(direct_shippment_address__c)</errorConditionFormula>
|
<errorDisplayField>direct_shippment_address__c</errorDisplayField>
|
<errorMessage>发送先如果是医疗机构、经销商或者会场地的话，直送地址为必须输入项目</errorMessage>
|
</validationRules>
|
<validationRules>
|
<fullName>Request_input_pick_time</fullName>
|
<active>true</active>
|
<description>ISPICKVAL(direct_send__c, '上门自提') &&ISBLANK(pickup_time__c)</description>
|
<errorConditionFormula>ISPICKVAL(direct_send__c, '上门自提') &&ISBLANK(pickup_time__c)</errorConditionFormula>
|
<errorDisplayField>pickup_time__c</errorDisplayField>
|
<errorMessage>发送先如果是上门自提的话，请输入自提时间</errorMessage>
|
</validationRules>
|
<validationRules>
|
<fullName>Send_to_shipment_check</fullName>
|
<active>true</active>
|
<description>发送给办事处时，必须填写办事处地址</description>
|
<errorConditionFormula>TEXT(direct_send__c)='办事处' && ISBLANK(Shipment_address__c)</errorConditionFormula>
|
<errorDisplayField>Shipment_address__c</errorDisplayField>
|
<errorMessage>发送给办事处时，必须填写办事处地址</errorMessage>
|
</validationRules>
|
<validationRules>
|
<fullName>System_Auto_Cannot_Modify</fullName>
|
<active>true</active>
|
<errorConditionFormula>(TEXT(demo_purpose2__c)='学会展会'
|
&& Not(ISBLANK(Campaign__c))
|
&& ISCHANGED(Campaign__c)
|
)
|
||
|
(TEXT(demo_purpose2__c)='OPD试用'
|
&& Not(ISBLANK(OPDPlan__c))
|
&& ISCHANGED(OPDPlan__c)
|
)
|
||
|
(
|
TEXT(demo_purpose2__c)='索赔QIS'
|
&& Not(ISBLANK(QIS_number__c))
|
&& ISCHANGED(QIS_number__c)
|
)</errorConditionFormula>
|
<errorMessage>系统自动带出的信息不能修改</errorMessage>
|
</validationRules>
|
<validationRules>
|
<fullName>Unform_employe_Check</fullName>
|
<active>true</active>
|
<errorConditionFormula>(isnew() || TEXT(Status__c) = '草案中')
|
&& $User.isFormal_Stuff__c ==true &&
|
ISBLANK(Old_Consum_Apply__c)</errorConditionFormula>
|
<errorMessage>试用期内，不能申请。</errorMessage>
|
</validationRules>
|
<visibility>Public</visibility>
|
<webLinks>
|
<fullName>ConsumApply_FromAccount</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-22 gwy 版本更改为51.0
|
function foo(){
|
if('{!$User.isFormal_Stuff__c}'=='true'){
|
alert('试用期内，不能申请');
|
} else {
|
var query = "Select QualifiedApiName, EntityDefinition.KeyPrefix, DurableId From FieldDefinition WHERE EntityDefinition.QualifiedApiName = 'Consum_Apply__c'";
|
var records = sforce.connection.query(query).getArray('records');
|
|
var prefix = records[0].EntityDefinition.KeyPrefix.toString();
|
var fieldmap = new Map();
|
|
for (var i=0; i< records.length; i++) {
|
var record = records[i];
|
fieldmap.set(record.QualifiedApiName,record.DurableId.toString().split('.')[1]);
|
}
|
|
var url = "{!$Site.Prefix}/" + prefix + "/e?retURL=%2F{!URLENCODE(Account.Id)}"
|
+ "&CF" + fieldmap.get('Hospital__c') + "={!URLENCODE(Account.Hospital__c)}"
|
+ "&CF" + fieldmap.get('Hospital__c') + "_lkid={!URLENCODE(Account.HospitalId__c)}"
|
+ "&CF" + fieldmap.get('Strategic_dept__c') + "={!URLENCODE(Account.Department_Class__c)}"
|
+ "&CF" + fieldmap.get('Strategic_dept__c') + "_lkid={!URLENCODE(Account.Department_ClassId__c)}"
|
+ "&CF" + fieldmap.get('Account__c') + "={!URLENCODE(Account.Name)}"
|
+ "&CF" + fieldmap.get('Account__c') + "_lkid={!URLENCODE(Account.Id)}"
|
+ "&Name={!URLENCODE('*')}"
|
+ "&" + fieldmap.get('demo_purpose2__c') + "={!URLENCODE('OPD试用')}"
|
+ "&CF" + fieldmap.get('Person_In_Charge__c') + "={!URLENCODE($User.LastName&' '&$User.FirstName)}"
|
+ "&CF" + fieldmap.get('Person_In_Charge__c') + "_lkid={!URLENCODE($User.Id)}"
|
+ "&CF" + fieldmap.get('applyUser__c') + "={!URLENCODE($User.LastName&' '&$User.FirstName)}"
|
+ "&CF" + fieldmap.get('applyUser__c') + "_lkid={!URLENCODE($User.Id)}"
|
+ "";
|
window.top.location.href=url;
|
}
|
}
|
foo();</url>
|
</webLinks>
|
<webLinks>
|
<fullName>ConsumApply_FromCampaign</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-22 gwy 版本更改为51.0
|
var foo = function(){
|
var campaignList = new Array();
|
//alert("1");
|
var up = "{!Text($User.Province__c)}";
|
var ups = up.slice(0,2);
|
var cp = "{!Campaign.Internal_in_charge_province__c}";
|
campaignList = sforce.connection.query("select Status,Rental_Apply_Flag__c from Campaign where id ='{!URLENCODE(Campaign.Id)}'");
|
// alert("2");
|
var records= campaignList.getArray("records");
|
// alert(records);
|
var campaignStatus = records[0].Status;
|
var interval = records[0].Rental_Apply_Flag__c;
|
// alert(interval);
|
if('{!$User.isFormal_Stuff__c}'=='true'){
|
alert('试用期内，不能申请');
|
}
|
else if('{!Campaign.RecordTypeId}'!='01210000000R26P'&&'{!Text($User.Job_Category__c)}'=='销售服务' ){
|
alert('FSE不能申请该学会类型备品');
|
}
|
else if(('{!Text($User.Job_Category__c)}'=='销售服务'||'{!Text($User.Job_Category__c)}'=='支援')&&'{!Campaign.RecordTypeId}'=='01210000000R26P'&& cp.indexOf(ups) == -1){
|
alert("与FSE所在省一致，才可使用备品");//
|
}
|
else if(campaignStatus == '已结束'){
|
alert("已结束，不能申请");
|
}
|
else if(campaignStatus == '已提交报告'){
|
alert("已提交报告，不能申请");
|
}
|
else if(campaignStatus == '取消申请中'){
|
alert("取消申请中，不能申请");
|
}
|
else if(campaignStatus == '取消'){
|
alert("已经取消，不能申请");
|
}
|
else{
|
var query = "Select QualifiedApiName, EntityDefinition.KeyPrefix, DurableId From FieldDefinition WHERE EntityDefinition.QualifiedApiName = 'Consum_Apply__c'";
|
var records = sforce.connection.query(query).getArray('records');
|
|
var prefix = records[0].EntityDefinition.KeyPrefix.toString();
|
var fieldmap = new Map();
|
|
for (var i=0; i< records.length; i++) {
|
var record = records[i];
|
fieldmap.set(record.QualifiedApiName,record.DurableId.toString().split('.')[1]);
|
}
|
//alert("5");
|
var url = "{!$Site.Prefix}/" + prefix + "/e?retURL=%2F{!URLENCODE(Campaign.Id)}"
|
+ "&CF" + fieldmap.get('Campaign__c') + "={!URLENCODE(Campaign.Name)}"
|
+ "&CF" + fieldmap.get('Campaign__c') + "_lkid={!URLENCODE(Campaign.Id)}"
|
+ "&Name={!URLENCODE('*')}"
|
+ "&" + fieldmap.get('demo_purpose2__c') + "={!URLENCODE('学会展会')}"
|
+ "&Name={!URLENCODE('*')}"
|
+ "&CF" + fieldmap.get('Person_In_Charge__c') + "={!URLENCODE($User.LastName&' '&$User.FirstName)}"
|
+ "&CF" + fieldmap.get('Person_In_Charge__c') + "_lkid={!URLENCODE($User.Id)}"
|
+ "&CF" + fieldmap.get('applyUser__c') + "={!URLENCODE($User.LastName&' '&$User.FirstName)}"
|
+ "&CF" + fieldmap.get('applyUser__c') + "_lkid={!URLENCODE($User.Id)}"
|
+ "";
|
window.top.location.href=url;
|
}
|
}
|
foo();</url>
|
</webLinks>
|
<webLinks>
|
<fullName>ConsumApply_FromOPDPlan</fullName>
|
<availability>online</availability>
|
<displayType>massActionButton</displayType>
|
<linkType>javascript</linkType>
|
<masterLabel>新建耗材申请(OPD计划)</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-22 gwy 版本更改为51.0
|
function foo(){
|
if('{!$User.isFormal_Stuff__c}'=='true'){
|
alert('试用期内，不能申请');
|
} else {
|
var query = "Select QualifiedApiName, EntityDefinition.KeyPrefix, DurableId From FieldDefinition WHERE EntityDefinition.QualifiedApiName = 'Consum_Apply__c'";
|
var records = sforce.connection.query(query).getArray('records');
|
|
var prefix = records[0].EntityDefinition.KeyPrefix.toString();
|
var fieldmap = new Map();
|
|
for (var i=0; i< records.length; i++) {
|
var record = records[i];
|
fieldmap.set(record.QualifiedApiName,record.DurableId.toString().split('.')[1]);
|
}
|
|
var url = "{!$Site.Prefix}/" + prefix + "/e?retURL=%2F{!URLENCODE(OPDPlan__c.Id)}"
|
+ "&CF" + fieldmap.get('OPD__c') + "={!URLENCODE(OPDPlan__c.OPDPlan_Report__c)}"
|
+ "&CF" + fieldmap.get('OPD__c') + "_lkid={!URLENCODE(OPDPlan__c.OPDPlan_ReportId__c)}"
|
+ "&CF" + fieldmap.get('OPDPlan__c') + "={!URLENCODE(OPDPlan__c.Name)}"
|
+ "&CF" + fieldmap.get('OPDPlan__c') + "_lkid={!URLENCODE(OPDPlan__c.Id)}"
|
+ "&CF" + fieldmap.get('Rental_Apply__c') + "={!URLENCODE(OPDPlan__c.Rental_Apply2__c)}"
|
+ "&CF" + fieldmap.get('Rental_Apply__c') + "_lkid={!URLENCODE(OPDPlan__c.Rental_Apply2Id__c)}"
|
+ "&CF" + fieldmap.get('Hospital__c') + "={!URLENCODE(OPDPlan__c.HospitalName__c)}"
|
+ "&CF" + fieldmap.get('Hospital__c') + "_lkid={!URLENCODE(OPDPlan__c.HospitalID__c)}"
|
+ "&CF" + fieldmap.get('Strategic_dept__c') + "={!URLENCODE(OPDPlan__c.OCM_category_Name__c)}"
|
+ "&CF" + fieldmap.get('Strategic_dept__c') + "_lkid={!URLENCODE(OPDPlan__c.OCM_category_ID__c)}"
|
+ "&CF" + fieldmap.get('Account__c') + "={!URLENCODE(OPDPlan__c.Account_Laboratory__c)}"
|
+ "&CF" + fieldmap.get('Account__c') + "_lkid={!URLENCODE(OPDPlan__c.Account_LaboratoryId__c)}"
|
+ "&Name={!URLENCODE('*')}"
|
+ "&" + fieldmap.get('demo_purpose2__c') + "={!URLENCODE('OPD试用')}"
|
+ "&CF" + fieldmap.get('Person_In_Charge__c') + "={!URLENCODE($User.LastName&' '&$User.FirstName)}"
|
+ "&CF" + fieldmap.get('Person_In_Charge__c') + "_lkid={!URLENCODE($User.Id)}"
|
+ "&CF" + fieldmap.get('applyUser__c') + "={!URLENCODE($User.LastName&' '&$User.FirstName)}"
|
+ "&CF" + fieldmap.get('applyUser__c') + "_lkid={!URLENCODE($User.Id)}"
|
+ "";
|
window.top.location.href=url;
|
}
|
}
|
foo();</url>
|
</webLinks>
|
<webLinks>
|
<fullName>ConsumApply_FromQIS</fullName>
|
<availability>online</availability>
|
<displayType>massActionButton</displayType>
|
<linkType>javascript</linkType>
|
<masterLabel>新建耗材备品申请(QIS)</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-22 gwy 版本更改为51.0
|
function foo() {
|
var result = sforce.connection.query("select Id from Consum_Apply__c where QIS_number__c='{!QIS_Report__c.Id}' and Status__c <> '取消' and Status__c <> '删除'");
|
var caList = result.getArray("records");
|
if (caList.length > 0){
|
alert("同一个QIS记录不能重复申请备品");
|
return;
|
}
|
|
var QISReportList = new Array();
|
QISReportList = sforce.connection.query("select next_action__c, QIS_Status__c from QIS_Report__c where id ='{!URLENCODE(QIS_Report__c.Id)}'");
|
var records= QISReportList.getArray("records");
|
var next_action__c = records[0].next_action__c;
|
var QIS_Status__c = records[0].QIS_Status__c;
|
if(next_action__c == '送回') {
|
alert('QIS对应方法为“送回”，不能申请');
|
return;
|
}
|
if(QIS_Status__c == '草案中') {
|
alert('QIS状态为草案中，不能申请');
|
return;
|
}
|
if(QIS_Status__c == 'FSE填写完毕') {
|
alert('QIS状态为FSE填写完毕，不能申请');
|
return;
|
}
|
if(QIS_Status__c == '取消') {
|
alert('QIS状态为取消，不能申请');
|
return;
|
}
|
if('{!$User.isFormal_Stuff__c}' == 'true') {
|
alert('试用期内，不能申请');
|
return;
|
} else {
|
var query = "Select QualifiedApiName, EntityDefinition.KeyPrefix, DurableId From FieldDefinition WHERE EntityDefinition.QualifiedApiName = 'Consum_Apply__c'";
|
var records = sforce.connection.query(query).getArray('records');
|
var prefix = records[0].EntityDefinition.KeyPrefix.toString();
|
var fieldmap = new Map();
|
|
for (var i=0; i< records.length; i++) {
|
var record = records[i];
|
fieldmap.set(record.QualifiedApiName,record.DurableId.toString().split('.')[1]);
|
}
|
|
var url = "{!$Site.Prefix}/" + prefix + "/e?retURL=%2F{!URLENCODE(QIS_Report__c.Id)}"
|
+ "&CF" + fieldmap.get('Hospital__c') + "={!URLENCODE(QIS_Report__c.Hospital__c)}"
|
+ "&CF" + fieldmap.get('Hospital__c') + "_lkid={!URLENCODE(QIS_Report__c.HospitalId__c)}"
|
+ "&CF" + fieldmap.get('Strategic_dept__c') + "={!URLENCODE(QIS_Report__c.Department_Class__c)}"
|
+ "&CF" + fieldmap.get('Strategic_dept__c') + "_lkid={!URLENCODE(QIS_Report__c.Department_ClassId__c)}"
|
+ "&CF" + fieldmap.get('Account__c') + "={!URLENCODE(QIS_Report__c.Hospital_Department__c)}"
|
+ "&CF" + fieldmap.get('Account__c') + "_lkid={!URLENCODE(QIS_Report__c.Hospital_DepartmentId__c)}"
|
+ "&Name={!URLENCODE('*')}"
|
+ "&CF" + fieldmap.get('QIS_number__c') + "={!URLENCODE(QIS_Report__c.Name)}"
|
+ "&CF" + fieldmap.get('QIS_number__c') + "_lkid={!URLENCODE(QIS_Report__c.Id)}"
|
+ "&" + fieldmap.get('demo_purpose2__c') + "={!URLENCODE('索赔QIS')}"
|
+ "&CF" + fieldmap.get('Person_In_Charge__c') + "={!URLENCODE($User.LastName&' '&$User.FirstName)}"
|
+ "&CF" + fieldmap.get('Person_In_Charge__c') + "_lkid={!URLENCODE($User.Id)}"
|
+ "&CF" + fieldmap.get('applyUser__c') + "={!URLENCODE($User.LastName&' '&$User.FirstName)}"
|
+ "&CF" + fieldmap.get('applyUser__c') + "_lkid={!URLENCODE($User.Id)}"
|
+ "";
|
window.top.location.href=url;
|
}
|
}
|
foo();</url>
|
</webLinks>
|
<webLinks>
|
<fullName>ConsumApply_FromRA</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-22 gwy 版本更改为51.0
|
function foo(){
|
if('{!$User.isFormal_Stuff__c}'=='true'){
|
alert('试用期内，不能申请');
|
} else {
|
var query = "Select QualifiedApiName, EntityDefinition.KeyPrefix, DurableId From FieldDefinition WHERE EntityDefinition.QualifiedApiName = 'Consum_Apply__c'";
|
var records = sforce.connection.query(query).getArray('records');
|
|
var prefix = records[0].EntityDefinition.KeyPrefix.toString();
|
var fieldmap = new Map();
|
|
for (var i=0; i< records.length; i++) {
|
var record = records[i];
|
fieldmap.set(record.QualifiedApiName,record.DurableId.toString().split('.')[1]);
|
}
|
var demo_purpose2__c = '{!CASE(TEXT(Rental_Apply__c.demo_purpose2__c),
|
'试用（有询价）','OPD试用',
|
'试用（无询价）','OPD试用',
|
'学会展会','学会展会',
|
'索赔QIS','索赔QIS',
|
'')}';
|
|
var url = "{!$Site.Prefix}/" + prefix + "/e?retURL=%2F{!URLENCODE(Rental_Apply__c.Id)}"
|
+ "&CF" + fieldmap.get('Rental_Apply__c') + "={!URLENCODE(Rental_Apply__c.Name)}"
|
+ "&CF" + fieldmap.get('Rental_Apply__c') + "_lkid={!URLENCODE(Rental_Apply__c.Id)}"
|
|
+ "&CF" + fieldmap.get('Campaign__c') + "={!URLENCODE(Rental_Apply__c.Campaign__c)}"
|
+ "&CF" + fieldmap.get('Campaign__c') + "_lkid={!URLENCODE(Rental_Apply__c.CampaignId__c)}"
|
|
+ "&CF" + fieldmap.get('QIS_number__c') + "={!URLENCODE(Rental_Apply__c.QIS_number__c)}"
|
+ "&CF" + fieldmap.get('QIS_number__c') + "_lkid={!URLENCODE(Rental_Apply__c.QIS_numberId__c)}"
|
|
+ "&CF" + fieldmap.get('QISRepair__c') + "={!URLENCODE(Rental_Apply__c.QISRepair__c)}"
|
+ "&CF" + fieldmap.get('QISRepair__c') + "_lkid={!URLENCODE(Rental_Apply__c.QISRepairId__c)}"
|
|
+ "&CF" + fieldmap.get('OPD__c') + "={!URLENCODE(Rental_Apply__c.OPD__c)}"
|
+ "&CF" + fieldmap.get('OPD__c') + "_lkid={!URLENCODE(Rental_Apply__c.OPDId__c)}"
|
+ "&CF" + fieldmap.get('OPDPlan__c') + "={!URLENCODE(Rental_Apply__c.OPDPlan__c)}"
|
+ "&CF" + fieldmap.get('OPDPlan__c') + "_lkid={!URLENCODE(Rental_Apply__c.OPDPlanId__c)}"
|
+ "&CF" + fieldmap.get('Hospital__c') + "={!URLENCODE(Rental_Apply__c.Hospital__c)}"
|
+ "&CF" + fieldmap.get('Hospital__c') + "_lkid={!URLENCODE(Rental_Apply__c.HospitalId__c)}"
|
+ "&CF" + fieldmap.get('Strategic_dept__c') + "={!URLENCODE(Rental_Apply__c.Strategic_dept__c)}"
|
+ "&CF" + fieldmap.get('Strategic_dept__c') + "_lkid={!URLENCODE(Rental_Apply__c.Strategic_deptId__c)}"
|
+ "&CF" + fieldmap.get('Account__c') + "={!URLENCODE(Rental_Apply__c.Account__c)}"
|
+ "&CF" + fieldmap.get('Account__c') + "_lkid={!URLENCODE(Rental_Apply__c.AccountId__c)}"
|
|
+ "&Name={!URLENCODE('*')}"
|
+ "&" + fieldmap.get('demo_purpose2__c') + "="+demo_purpose2__c
|
+ "&" + fieldmap.get('ApplyPerson_Phone__c') + "={!URLENCODE(Rental_Apply__c.ApplyPerson_Phone__c)}"
|
+ "&" + fieldmap.get('Phone_number__c') + "={!URLENCODE(Rental_Apply__c.Phone_number__c)}"
|
+ "&" + fieldmap.get('Request_shipping_day__c') + "={!Rental_Apply__c.Request_shipping_day__c}"
|
|
+ "&CF" + fieldmap.get('Loaner_medical_Staff__c') + "={!URLENCODE(Rental_Apply__c.Loaner_medical_Staff__c)}"
|
+ "&CF" + fieldmap.get('Loaner_medical_Staff__c') + "_lkid={!URLENCODE(Rental_Apply__c.Loaner_medical_StaffId__c)}"
|
+ "&CF" + fieldmap.get('Person_In_Charge__c') + "={!URLENCODE($User.LastName&' '&$User.FirstName)}"
|
+ "&CF" + fieldmap.get('Person_In_Charge__c') + "_lkid={!URLENCODE($User.Id)}"
|
+ "&CF" + fieldmap.get('applyUser__c') + "={!URLENCODE($User.LastName&' '&$User.FirstName)}"
|
+ "&CF" + fieldmap.get('applyUser__c') + "_lkid={!URLENCODE($User.Id)}"
|
//发送信息
|
|
+ "&CF" + fieldmap.get('Shipment_address__c') + "={!URLENCODE(Rental_Apply__c.Shipment_address__c)}"
|
+ "&CF" + fieldmap.get('Shipment_address__c') + "_lkid={!URLENCODE(Rental_Apply__c.Shipment_addressId__c)}"
|
+ "&CF" + fieldmap.get('Dealer__c') + "={!URLENCODE(Rental_Apply__c.Dealer__c)}"
|
+ "&CF" + fieldmap.get('Dealer__c') + "_lkid={!URLENCODE(Rental_Apply__c.DealerId__c)}"
|
+ "&" + fieldmap.get('direct_send__c') + "={!TEXT(Rental_Apply__c.direct_send__c)}"
|
+ "&" + fieldmap.get('pickup_time__c') + "={!Rental_Apply__c.pickup_time__c}"
|
+ "&" + fieldmap.get('Loaner_received_staff__c') + "={!URLENCODE(Rental_Apply__c.Loaner_received_staff__c)}"
|
+ "&" + fieldmap.get('Loaner_received_staff_phone__c') + "={!URLENCODE(Rental_Apply__c.Loaner_received_staff_phone__c)}"
|
+ "&" + fieldmap.get('Post_Code__c') + "={!URLENCODE(Rental_Apply__c.Post_Code__c)}"
|
+ "&" + fieldmap.get('direct_shippment_address__c') + "={!URLENCODE(Rental_Apply__c.direct_shippment_address__c)}"
|
|
+ "";
|
window.top.location.href=url;
|
}
|
}
|
foo();</url>
|
</webLinks>
|
<webLinks>
|
<fullName>ConsumTrialPDF</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-22 gwy 版本更改为51.0
|
var foo = function() {
|
if ('{!Consum_Apply__c.Shipment_requested_cnt__c}' > 0) {
|
window.open('/apex/ConsumTrialPDF?id={!Consum_Apply__c.Id}');
|
} else {
|
alert('当前的申请单中没有已出库指示的配套。');
|
}
|
}
|
foo();</url>
|
</webLinks>
|
<webLinks>
|
<fullName>Loaned_history</fullName>
|
<availability>online</availability>
|
<displayType>button</displayType>
|
<encodingKey>UTF-8</encodingKey>
|
<hasMenubar>true</hasMenubar>
|
<hasScrollbars>true</hasScrollbars>
|
<hasToolbar>true</hasToolbar>
|
<height>600</height>
|
<isResizable>true</isResizable>
|
<linkType>url</linkType>
|
<masterLabel>对客户耗材历史</masterLabel>
|
<openType>newWindow</openType>
|
<position>none</position>
|
<protected>false</protected>
|
<showsLocation>true</showsLocation>
|
<showsStatus>true</showsStatus>
|
<url>/00O1000000661NB?pv0={!Consum_Apply__c.Hospital_ID__c}</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-22 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 = '';
|
if('{!Consum_Apply__c.Campaign__c}' != '') {
|
var DeliveryGood = new Array();
|
DeliveryGood = sforce.connection.query("select Status, Rental_Apply_Flag__c from Campaign where id ='{!Consum_Apply__c.CampaignId__c}'");
|
var records= DeliveryGood.getArray("records");
|
|
campaignStatus = records[0].Status;
|
|
}
|
if("{!Consum_Apply__c.Wei_Assigned_Cnt__c}" > "0") {
|
alert("申请单内存在未分配的耗材，请分配或分割申请单");
|
}else if(campaignStatus == '取消'){
|
alert("学会取消，不可出库指示");
|
}else if ("{!Consum_Apply__c.Status__c}" == "已出库指示" && "{!Consum_Apply__c.Assigned_Not_Shipment__c}" == "0") {
|
alert("所有的耗材备品Set一览都进行过出库指示了");
|
} else if ("{!Consum_Apply__c.Assigned_Not_Shipment__c}" == "0") {
|
alert("没有可以出库指示的明细");
|
} else {
|
sforce.connection.sessionId = "{!GETSESSIONID()}";
|
var raid = "{!Consum_Apply__c.Id}";
|
var rs1 = sforce.apex.execute("ConsumApplyWebService", "approvalCheck", {ConsumApplyId: 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 {
|
//var rs1 = sforce.apex.execute("RentalApplyWebService", "setShipment_request", {raid : "{!Consum_Apply__c.Id}"});
|
|
sforce.apex.execute("ConsumApplyWebService", "setShipment_request", {raid: "{!Consum_Apply__c.Id}"},function(res) {
|
// if(event.status) {
|
if (res == "状态更新到已出库指示") {
|
alert("状态更新到已出库指示");
|
print();
|
setTimeout(function() {
|
location.href = "/{!Consum_Apply__c.Id}";
|
}
|
, 100
|
);
|
} else {
|
alert(res);
|
}
|
// } else {
|
// alert(event.message);
|
// }
|
});
|
|
//bp2 }
|
}
|
}
|
function print(){
|
var sql;
|
if('{!Consum_Apply__c.Bollow_Date__c}' != ''){
|
sql = "select Id from Consum_Apply_Equipment_Set__c where Consum_Apply__c = '{!Consum_Apply__c.Id}' and Shippment_loaner_time__c != null and RAES_Status__c != '已分配' and RAES_Status__c != '取消分配'";
|
}else{
|
sql = "select Id from Consum_Apply_Equipment_Set__c where Consum_Apply__c = '{!Consum_Apply__c.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/ConsumTrialPDF?id={!Consum_Apply__c.Id}');
|
//}
|
}
|
|
|
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>Lost</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-22 gwy 版本更改为51.0
|
// TODO メッセージ表示用のところ全部変更する必要がります。ここはあってます
|
var foo = function() {
|
if ("{! Consum_Apply__c.Status__c}" == "取消") {
|
alert("已经取消！");
|
return;
|
}
|
if ("{! Consum_Apply__c.Status__c}" == "删除") {
|
alert("已经删除！");
|
return;
|
}
|
if("{!Consum_Apply__c.RA_Status__c}" == "已出库" || "{!Consum_Apply__c.Yi_loaner_arranged__c}" > 0) {
|
alert("备品已经出库，不能取消！");
|
return;
|
}
|
var raid = '{!Consum_Apply__c.Id}';
|
window.open("/apex/ConsumApplyCancel?objId={!URLENCODE(Consum_Apply__c.Id)}", 'ConsumApplyCancel', 'width=500,height=250');
|
};
|
foo()</url>
|
</webLinks>
|
<webLinks>
|
<fullName>all_received_fse</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-22 gwy 版本更改为51.0
|
var raid = "{!Consum_Apply__c.Id}";
|
var rs1 = sforce.apex.execute("ConsumApplyWebService", "all_received_fse", {caId: raid});
|
alert(rs1);
|
if (rs1 == '现场已全部收货') {
|
location.href = "/{!Consum_Apply__c.Id}";
|
}</url>
|
</webLinks>
|
<webLinks>
|
<fullName>returnDeliverySlip</fullName>
|
<availability>online</availability>
|
<description>到回寄单画面</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-22 gwy 版本更改为51.0
|
function foo(){
|
var query = "SELECT Asset_Center_Confirm_F__c FROM Consum_Apply_Equipment_Set_Detail__c WHERE Cancel_Select__c = false AND Consum_Apply__c ='{!Consum_Apply__c.Id}'";
|
var records = sforce.connection.query(query).getArray('records');
|
|
for(var i = 0; i < records.length; i++){
|
if( records[i].Asset_Center_Confirm_F__c == 'OK' ) {
|
continue;
|
}
|
else{
|
alert('未完成到货确认或备品中心未确认不能上传试用表');
|
return;
|
}
|
}
|
if(records.length > 0) {
|
window.open("/apex/consumTrialConfirm?id={!Consum_Apply__c.Id}");
|
}
|
else {
|
alert('没有明细');
|
}
|
|
}
|
foo();</url>
|
</webLinks>
|
<webLinks>
|
<fullName>submit_approval_process</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-22 gwy 版本更改为51.0
|
var getConnectDMLErrorMessages = function (results) {
|
var messages = [],
|
i = 0,
|
len = results.length,
|
r;
|
for (; i < len; i++) {
|
r = results[i];
|
if (!r.getBoolean("success")) {
|
messages = messages.concat(getConnectDMLMessagesOfAResult(r));
|
}
|
}
|
return messages;
|
};
|
var getConnectDMLMessagesOfAResult = function (res) {
|
var messages = [],
|
errors = res.getArray("errors"),
|
i = 0,
|
len = errors.length,
|
e;
|
for (; i < len; i++) {
|
e = errors[i];
|
messages.push(e.message + " " + getConnectDMLErrorFields(e));
|
}
|
return messages;
|
};
|
var getConnectDMLErrorFields = function (error) {
|
var fields = error.getArray('fields');
|
if (fields.length > 0) {
|
return "[" + fields.join(",") + "]"
|
} else {
|
return "";
|
}
|
};
|
|
var foo = function() {
|
var buttons = document.getElementsByName('submit_approval_process'.toLowerCase());
|
for (var i=0; i<buttons.length; i++) {
|
buttons[i].className = "btnDisabled";
|
buttons[i].disabled = true;
|
}
|
if ('{!Consum_Apply__c.Request_Shipping_7days_Before__c }' < '{!TODAY()}') {
|
alert('此申请已不满足（希望到货日-7工作日）前完成审批的情况，请重新修改申请。');
|
return;
|
}
|
if (!confirm("一旦提交此记录以待批准，根据您的设置您可能不再能够编辑此记录或将他从批准过程中调回。是否继续？\n\n※ 需要在{!Consum_Apply__c.Request_Shipping_7days_Before__c}前完成审批，否则申请单自动取消。")) {
|
return;
|
}
|
// 希望到货日不能早于申请提交日-0418追加
|
if ('{!Consum_Apply__c.Request_shipping_day__c}' < '{!TODAY()}') {
|
alert('希望到货日不能早于申请提交日');
|
return;
|
}
|
|
if('{!Consum_Apply__c.Campaign__c}' != null && '{!Consum_Apply__c.Campaign__c}' != ''){
|
var DeliveryGood = new Array();
|
DeliveryGood = sforce.connection.query("select Status, Rental_Apply_Flag__c from Campaign where id ='{!Consum_Apply__c.CampaignId__c}'");
|
var records= DeliveryGood.getArray("records");
|
|
var interval = records[0].Status;
|
var records_Date = records[0].Rental_Apply_Flag__c;
|
if (interval == '草案中') {
|
alert('学会状态为草案中，不能提交');
|
return;
|
}
|
if (interval == '申请中') {
|
alert('学会状态为申请中，不能提交');
|
return;
|
}
|
if (interval == '已结束') {
|
alert('学会状态为已结束，不能提交');
|
return;
|
}
|
if (interval == '已提交报告') {
|
alert('学会状态为已提交报告，不能提交');
|
return;
|
}
|
if (interval == '取消申请中') {
|
alert('学会状态为取消申请中，不能提交');
|
return;
|
}
|
if (interval == '取消') {
|
alert('学会状态为取消，不能提交');
|
return;
|
}
|
}
|
if('{!Consum_Apply__c.QIS_number__c}' != null && '{!Consum_Apply__c.QIS_number__c}' != ''){
|
var DeliveryGood = new Array();
|
DeliveryGood = sforce.connection.query("select id,next_action__c from QIS_report__c where id ='{!Consum_Apply__c.QIS_ID_Line__c}'");
|
var records= DeliveryGood.getArray("records");
|
var interval = records[0].next_action__c;
|
if (interval == '送回') {
|
alert("QIS 已送回，不能再申请备品了");
|
return;
|
}
|
}
|
// share
|
var userAccess = new Array();
|
userAccess.push('{!Consum_Apply__c.applyUserId__c}_Edit');
|
userAccess.push('{!Consum_Apply__c.JingliApprovalManagerId__c}_Read');
|
userAccess.push('{!Consum_Apply__c.SalesManagerId__c}_Read');
|
userAccess.push('{!Consum_Apply__c.BuchangApprovalManagerId__c}_Read');
|
userAccess.push('{!Consum_Apply__c.BuchangApprovalManagerSalesId__c}_Read');
|
userAccess.push('{!Consum_Apply__c.ZongjianApprovalManagerId__c}_Read');
|
//userAccess.push('{!Consum_Apply__c.Status__c}_Read');
|
|
var rtn = sforce.apex.execute('ControllerUtil','setSObjectShare',{sobjectName:'Consum_Apply__Share',rowCause:'ApplyUserShare__c',parentId:'{!Consum_Apply__c.Id}',userAccess:userAccess,ownerId:'{!Consum_Apply__c.OwnerId}'});
|
if (rtn != 'OK') {
|
alert(rtn);
|
return;
|
}
|
|
//追加备品申请状态确认，已经提交过的申请，不能重复提交Status__c
|
if ('{!Consum_Apply__c.Status__c}' == '填写完毕' ||
|
'{!Consum_Apply__c.Status__c}' == '申请中' ||
|
'{!Consum_Apply__c.Status__c}' == '已批准' ||
|
//现在申请书的Status__c已经没有引当完了状态。所以这里不需要判断
|
//'{!Consum_Apply__c.Status__c}' == '引当完了' ||
|
'{!Consum_Apply__c.Status__c}' == '已出库指示' ||
|
'{!Consum_Apply__c.Status__c}' == '删除' ||
|
'{!Consum_Apply__c.Status__c}' == '取消' ) {
|
alert('请备品申请状态确认，已经提交过的申请，不能重复提交');
|
return;
|
}
|
if ('{!Consum_Apply__c.Min_Consum_Can_Request_approval_Date__c}' > '{!TODAY()}') {
|
alert('申请提交日到预计使用日必须在22个工作日以内才可以'); // 最好还是添加入力规则，填写完毕的时候Check
|
return;
|
}
|
|
// 没有明细的一览check
|
var raesList = new Array();
|
raesList = sforce.connection.query("select Id from Consum_Apply_Equipment_Set__c where RetalFSetDetail_Cnt__c = 0 AND Consum_Apply__c ='{!Consum_Apply__c.Id}'");
|
var records= raesList.getArray('records');
|
if(records.length > 0){
|
alert('有没有明细的耗材备品配套一览，不能提交');
|
return;
|
}
|
sforce.connection.sessionId = "{!GETSESSIONID()}";
|
var raid = "{!Consum_Apply__c.Id}";
|
var rs1 = sforce.apex.execute("ConsumApplyWebService", "approvalCheck", {ConsumApplyId: raid});
|
if (rs1 != '1') {
|
alert(rs1);
|
return;
|
}
|
var rac = new sforce.SObject("Consum_Apply__c");
|
rac.Id = "{!Consum_Apply__c.Id}";
|
rac.Status__c = "填写完毕";
|
var result = sforce.connection.update([rac]);
|
var messages = getConnectDMLErrorMessages(result);
|
if (messages.length > 0) {
|
alert(messages.join("\n"));
|
return;
|
}
|
window.location.href = window.location;
|
};
|
foo();</url>
|
</webLinks>
|
</CustomObject>
|
