<?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>
|
<content>XinDailyReport</content>
|
<skipRecordTypeSelect>false</skipRecordTypeSelect>
|
<type>Visualforce</type>
|
</actionOverrides>
|
<actionOverrides>
|
<actionName>List</actionName>
|
<type>Default</type>
|
</actionOverrides>
|
<actionOverrides>
|
<actionName>New</actionName>
|
<content>XinDailyReport</content>
|
<skipRecordTypeSelect>false</skipRecordTypeSelect>
|
<type>Visualforce</type>
|
</actionOverrides>
|
<actionOverrides>
|
<actionName>SaveEdit</actionName>
|
<type>Default</type>
|
</actionOverrides>
|
<actionOverrides>
|
<actionName>Tab</actionName>
|
<type>Default</type>
|
</actionOverrides>
|
<actionOverrides>
|
<actionName>View</actionName>
|
<content>XinDailyReport</content>
|
<skipRecordTypeSelect>false</skipRecordTypeSelect>
|
<type>Visualforce</type>
|
</actionOverrides>
|
<actionOverrides>
|
<actionName>View</actionName>
|
<comment>Action override created by Lightning App Builder during activation.</comment>
|
<content>test</content>
|
<formFactor>Large</formFactor>
|
<skipRecordTypeSelect>false</skipRecordTypeSelect>
|
<type>Flexipage</type>
|
</actionOverrides>
|
<actionOverrides>
|
<actionName>View</actionName>
|
<comment>Action override created by Lightning App Builder during activation.</comment>
|
<content>test</content>
|
<formFactor>Small</formFactor>
|
<skipRecordTypeSelect>false</skipRecordTypeSelect>
|
<type>Flexipage</type>
|
</actionOverrides>
|
<allowInChatterGroups>false</allowInChatterGroups>
|
<compactLayoutAssignment>SYSTEM</compactLayoutAssignment>
|
<deploymentStatus>Deployed</deploymentStatus>
|
<enableActivities>true</enableActivities>
|
<enableBulkApi>true</enableBulkApi>
|
<enableChangeDataCapture>false</enableChangeDataCapture>
|
<enableEnhancedLookup>false</enableEnhancedLookup>
|
<enableFeeds>false</enableFeeds>
|
<enableHistory>true</enableHistory>
|
<enableReports>true</enableReports>
|
<enableSearch>true</enableSearch>
|
<enableSharing>true</enableSharing>
|
<enableStreamingApi>true</enableStreamingApi>
|
<externalSharingModel>Private</externalSharingModel>
|
<fields>
|
<fullName>Active_user__c</fullName>
|
<externalId>false</externalId>
|
<formula>Owner:User.IsActive</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>有效用户</label>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Checkbox</type>
|
</fields>
|
<fields>
|
<fullName>ActivityDate__c</fullName>
|
<externalId>false</externalId>
|
<label>活动日（汇总）</label>
|
<summarizedField>Event__c.visited_date__c</summarizedField>
|
<summaryForeignKey>Event__c.Daily_Report__c</summaryForeignKey>
|
<summaryOperation>min</summaryOperation>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Summary</type>
|
</fields>
|
<fields>
|
<fullName>Activity_ID__c</fullName>
|
<externalId>false</externalId>
|
<label>活動ID(内部処理用)</label>
|
<length>18</length>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Applicant_Count__c</fullName>
|
<description>报表用</description>
|
<externalId>false</externalId>
|
<formula>If (Status_With_Check__c = '申请中', 1, 0)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>还没批准件数</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>ApplyTimes__c</fullName>
|
<externalId>false</externalId>
|
<formula>1</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>提交件数</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Apply_Report__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(Reporter__r.ManagerId = $User.Id , "是","否")</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>是否需要批准的日报</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Approval_Elapsed_Time__c</fullName>
|
<externalId>false</externalId>
|
<label>批准后经过的时间*删除*</label>
|
<precision>8</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Approval_time__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(ISBLANK(Approved_DateTime__c),Min_Minister_Checktime__c,
|
IF(Approved_DateTime__c > Min_Minister_Checktime__c,Min_Minister_Checktime__c,Approved_DateTime__c))</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>批准时间(统计用)</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>DateTime</type>
|
</fields>
|
<fields>
|
<fullName>Approved_DateTime_With_Check__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(Text(Status__c) = '申請中' || Text(Status__c) = '承認',
|
IF(ISNULL(Min_Checktime__c) || Approved_DateTime__c < Min_Checktime__c,
|
Approved_DateTime__c,
|
Min_Checktime__c
|
),
|
null
|
)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>批准时间(含代理)</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>DateTime</type>
|
</fields>
|
<fields>
|
<fullName>Approved_DateTime__c</fullName>
|
<externalId>false</externalId>
|
<label>批准时间</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>DateTime</type>
|
</fields>
|
<fields>
|
<fullName>Approved_Date_With_Check__c</fullName>
|
<externalId>false</externalId>
|
<formula>/* TODO １回非承認を考量したら、部長、経理の承認チェックを外すべき、あるいは代理承認後、承認しか選べない入力規則を追加 */
|
IF(Text(Status__c) = '申請中' || Text(Status__c) = '承認',
|
IF(ISNULL(Min_Checktime__c) || Approved_Date__c < Datevalue(Min_Checktime__c),
|
Approved_Date__c,
|
Datevalue(Min_Checktime__c)
|
),
|
null
|
)</formula>
|
<label>批准日(含代理)</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Date</type>
|
</fields>
|
<fields>
|
<fullName>Approved_Date__c</fullName>
|
<externalId>false</externalId>
|
<label>批准日</label>
|
<required>false</required>
|
<trackHistory>true</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Date</type>
|
</fields>
|
<fields>
|
<fullName>Business_Trip__c</fullName>
|
<defaultValue>false</defaultValue>
|
<externalId>false</externalId>
|
<label>出差</label>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Checkbox</type>
|
</fields>
|
<fields>
|
<fullName>Caluculated_start_day__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(
|
MONTH(Today())=12,
|
IF(
|
Reported_Date__c >= DATE(YEAR(today()),01,01),
|
1,
|
0
|
),
|
IF( Reported_Date__c >= DATE(YEAR(today())-1,MONTH(Today())+1,01),
|
1,
|
0
|
)
|
)</formula>
|
<label>统计开始日(1年前)</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>Closest_Confirm_Work_Day__c</fullName>
|
<externalId>false</externalId>
|
<label>提交最近工作日</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Date</type>
|
</fields>
|
<fields>
|
<fullName>Closest_Work_Day__c</fullName>
|
<description>如果日报出现在节假日，则要推迟到最近的工作日作为限制日期</description>
|
<externalId>false</externalId>
|
<label>最近工作日</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Date</type>
|
</fields>
|
<fields>
|
<fullName>Confirm_Count_Within_Limit__c</fullName>
|
<description>SWAG-BD28RR 2019-6-21变更前
|
if (
|
Or(Status_With_Check__c = '批准', Status_With_Check__c = '批准(代理)'),
|
if (
|
Approved_Date_With_Check__c <= Confirm_Limit_Date__c,
|
1,
|
0
|
),
|
0
|
)</description>
|
<externalId>false</externalId>
|
<formula>if (
|
Or(Status_With_Check__c = '批准', Status_With_Check__c = '批准(代理)'),
|
if (
|
Approved_DateTime_With_Check__c <= Confirm_Limit_Date__c,
|
1,
|
0
|
),
|
0
|
)</formula>
|
<label>准时批准次数</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Confirm_Limit_Date__c</fullName>
|
<description>SWAG-BD28RR 2019-6-21变更前（公式返回值是日期）
|
if (
|
isblank(Submit_Date_Latest__c),
|
null,
|
case(
|
MOD( Submit_Date_Latest__c - DATE( 1900, 1, 7), 7 ) ,
|
5, datetimevalue( text(year(Submit_Date_Latest__c)) & '-' & text(month(Submit_Date_Latest__c)) & '-' & text(day(Submit_Date_Latest__c)) & ' 04:00:00') + 3,
|
6, datetimevalue( text(year(Submit_Date_Latest__c)) & '-' & text(month(Submit_Date_Latest__c)) & '-' & text(day(Submit_Date_Latest__c)) & ' 04:00:00') + 2,
|
datetimevalue( text(year(Submit_Date_Latest__c)) & '-' & text(month(Submit_Date_Latest__c)) & '-' & text(day(Submit_Date_Latest__c)) & ' 04:00:00') + 1
|
)
|
)
|
|
2021-06-11 变更 参考课题：SWAG-C3U9QU</description>
|
<externalId>false</externalId>
|
<formula>IF(!ISNULL(Closest_Confirm_Work_Day__c),datetimevalue( text(year(Closest_Confirm_Work_Day__c)) & '-' & text(month(Closest_Confirm_Work_Day__c)) & '-' & text(day(Closest_Confirm_Work_Day__c)) & ' 16:00:00'), null)</formula>
|
<label>准时批准期限</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>DateTime</type>
|
</fields>
|
<fields>
|
<fullName>Confirmed_Count__c</fullName>
|
<externalId>false</externalId>
|
<formula>if (Or(Status_With_Check__c = '批准', Status_With_Check__c = '批准(代理)'), 1, 0)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>批准件数</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Confirmed_Person__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF( Status_With_Check__c = "批准" || Status_With_Check__c = "批准(代理)" , LastModifiedBy.Alias, "")</formula>
|
<label>批准人</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Count_Kyuka_of_Event__c</fullName>
|
<description>配下の活動Cの、「休暇なら1」を積み上げます。</description>
|
<externalId>false</externalId>
|
<label>休暇なら1積み上げ</label>
|
<summarizedField>Event__c.if_kyuka__c</summarizedField>
|
<summaryForeignKey>Event__c.Daily_Report__c</summaryForeignKey>
|
<summaryOperation>sum</summaryOperation>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Summary</type>
|
</fields>
|
<fields>
|
<fullName>Count_Managercheck_of_Event__c</fullName>
|
<externalId>false</externalId>
|
<label>经理已经确认报告次数</label>
|
<summarizedField>Event__c.if_managercheck__c</summarizedField>
|
<summaryForeignKey>Event__c.Daily_Report__c</summaryForeignKey>
|
<summaryOperation>sum</summaryOperation>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Summary</type>
|
</fields>
|
<fields>
|
<fullName>Count_Ministercheck_of_Event__c</fullName>
|
<externalId>false</externalId>
|
<label>部长已经确认报告次数</label>
|
<summarizedField>Event__c.if_ministercheck__c</summarizedField>
|
<summaryForeignKey>Event__c.Daily_Report__c</summaryForeignKey>
|
<summaryOperation>sum</summaryOperation>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Summary</type>
|
</fields>
|
<fields>
|
<fullName>Count_of_Event_All__c</fullName>
|
<externalId>false</externalId>
|
<label>活动件数（所有）</label>
|
<summaryForeignKey>Event__c.Daily_Report__c</summaryForeignKey>
|
<summaryOperation>count</summaryOperation>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Summary</type>
|
</fields>
|
<fields>
|
<fullName>Count_of_Event__c</fullName>
|
<externalId>false</externalId>
|
<label>活动件数</label>
|
<summaryFilterItems>
|
<field>Event__c.eventStatus__c</field>
|
<operation>equals</operation>
|
<value></value>
|
</summaryFilterItems>
|
<summaryForeignKey>Event__c.Daily_Report__c</summaryForeignKey>
|
<summaryOperation>count</summaryOperation>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Summary</type>
|
</fields>
|
<fields>
|
<fullName>Creation_Date__c</fullName>
|
<externalId>false</externalId>
|
<label>创建日</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Date</type>
|
</fields>
|
<fields>
|
<fullName>Current_Daily_Report_Sum__c</fullName>
|
<externalId>false</externalId>
|
<formula>Reporter__r.Current_Daily_Report_Sum__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>Daily_Report_Data_Type__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>
|
</valueSetDefinition>
|
</valueSet>
|
</fields>
|
<fields>
|
<fullName>Daily_Report_Key__c</fullName>
|
<caseSensitive>true</caseSensitive>
|
<description>報告者と報告日の複合キー</description>
|
<externalId>true</externalId>
|
<label>Daily_Report_Key</label>
|
<length>255</length>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>true</unique>
|
</fields>
|
<fields>
|
<fullName>Feed_Back_From_Manager__c</fullName>
|
<externalId>false</externalId>
|
<label>反馈内容</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>TextArea</type>
|
</fields>
|
<fields>
|
<fullName>FeedbackManager__c</fullName>
|
<deleteConstraint>SetNull</deleteConstraint>
|
<externalId>false</externalId>
|
<label>反馈者</label>
|
<referenceTo>User</referenceTo>
|
<relationshipName>FeedbackManager</relationshipName>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Lookup</type>
|
</fields>
|
<fields>
|
<fullName>Fiscal_Worddays__c</fullName>
|
<externalId>false</externalId>
|
<formula>Reporter__r.Fiscal_Workdays__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>Fiscal_Workdays_yeasterday__c</fullName>
|
<externalId>false</externalId>
|
<formula>Reporter__r.Fiscal_Workdays_yeasterday__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>ID_18__c</fullName>
|
<externalId>false</externalId>
|
<formula>CASESAFEID(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>IsWorkDay__c</fullName>
|
<externalId>false</externalId>
|
<formula>OlympusCalendar__r.IsWorkDay__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>IsWorkDay</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>LastUpdateTime__c</fullName>
|
<externalId>false</externalId>
|
<formula>LastModifiedDate</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>最終更新時間</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>DateTime</type>
|
</fields>
|
<fields>
|
<fullName>Latest_Event_Time__c</fullName>
|
<externalId>false</externalId>
|
<label>最终活动结束时间</label>
|
<summarizedField>Event__c.EndDateTime__c</summarizedField>
|
<summaryForeignKey>Event__c.Daily_Report__c</summaryForeignKey>
|
<summaryOperation>max</summaryOperation>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Summary</type>
|
</fields>
|
<fields>
|
<fullName>Mail_Send_Check__c</fullName>
|
<defaultValue>false</defaultValue>
|
<externalId>false</externalId>
|
<label>点击：发送邮件</label>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Checkbox</type>
|
</fields>
|
<fields>
|
<fullName>Manager_Mail__c</fullName>
|
<externalId>false</externalId>
|
<label>经理的E-mail</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Email</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Min_Checktime__c</fullName>
|
<externalId>false</externalId>
|
<formula>if(isnull(Min_Minister_Checktime__c) || Min_Manager_Checktime__c < Min_Minister_Checktime__c,
|
Min_Manager_Checktime__c,
|
Min_Minister_Checktime__c
|
)</formula>
|
<label>最早代理确认日时</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>DateTime</type>
|
</fields>
|
<fields>
|
<fullName>Min_Manager_Checktime__c</fullName>
|
<externalId>false</externalId>
|
<label>经理代理确认日时</label>
|
<summarizedField>Event__c.Manager_Check_Time__c</summarizedField>
|
<summaryForeignKey>Event__c.Daily_Report__c</summaryForeignKey>
|
<summaryOperation>min</summaryOperation>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Summary</type>
|
</fields>
|
<fields>
|
<fullName>Min_Minister_Checktime__c</fullName>
|
<externalId>false</externalId>
|
<label>部长・总监代理确认日时</label>
|
<summarizedField>Event__c.Minister_Check_Time__c</summarizedField>
|
<summaryForeignKey>Event__c.Daily_Report__c</summaryForeignKey>
|
<summaryOperation>min</summaryOperation>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Summary</type>
|
</fields>
|
<fields>
|
<fullName>Monthly_workshop_day__c</fullName>
|
<description>在个人仪表板的日报提交率(%)使用</description>
|
<externalId>false</externalId>
|
<formula>CASE(Year_month_txt__c,
|
"20161",20,
|
"20162",17,
|
"20163",23,
|
"20164",20,
|
"20165",20,
|
"20166",20,
|
"20167",21,
|
"20168",23,
|
"20169",20,
|
"201610",17,
|
"201611",22,
|
"201612",22,
|
"20171",19,
|
"20172",17,
|
"20173",23,
|
"20174",18,
|
"20175",20,
|
"20176",22,
|
"20177",21,
|
"20178",23,
|
"20179",21,
|
"201710",17,
|
"201711",22,
|
"201712",21,
|
"20181",22,
|
"20182",16,
|
"20183",22,
|
"20184",18,
|
"20185",22,
|
"20186",20,
|
"20187",22,
|
"20188",23,
|
"20189",20,
|
"201810",18,
|
"201811",22,
|
"201812",19,
|
"20191",22,
|
"20192",16,
|
"20193",21,
|
"20194",20,
|
"20195",22,
|
"20196",19,
|
"20197",23,
|
"20198",22,
|
"20199",21,
|
"201910",18,
|
"201911",21,
|
"201912",21,
|
0)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>每月工作日</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Nickname_LINK_to_Daily_Report__c</fullName>
|
<externalId>false</externalId>
|
<formula>Reporter__r.Nickname_LINK_to_Daily_Report__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>Num_Of_Report__c</fullName>
|
<externalId>false</externalId>
|
<formula>1</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>日报记数</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Num_Workday_Submit__c</fullName>
|
<externalId>false</externalId>
|
<formula>if(Youbi__c = '工作日' && Num_of_Submit_Report__c = 1, 1, 0)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>工作日提交件数</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Num_of_Submit_Report__c</fullName>
|
<externalId>false</externalId>
|
<formula>Case( Status__c ,
|
"申請中",1,
|
"承認",1,
|
0)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>日报提出</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>OCM_man_province__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(TEXT(Reporter__r.Dept__c) == "能量事业本部",
|
"能量",
|
IF(TEXT(Reporter__r.Dept__c) == "特约经销商管理支援本部",
|
"经销商管理",
|
IF(TEXT(Reporter__r.Dept__c) == "消化·呼吸内镜事业本部",
|
"GIR本部",
|
IF(TEXT(Reporter__r.Dept__c) == "外科事业本部",
|
"SP本部",
|
CASE(TEXT(Reporter__r.Work_Location__c),
|
"北京", "北京",
|
"成都", "四川",
|
"大连", "大连",
|
"福州", "福建",
|
"广州", "广东",
|
"贵阳", "贵州",
|
"哈尔滨", "黑龙江",
|
"杭州", "浙江",
|
"合肥", "安徽",
|
"呼和浩特", "内蒙古",
|
"济南", "山东",
|
"昆明", "云南",
|
"兰州", "甘肃",
|
"南昌", "江西",
|
"南京", "江苏",
|
"南宁", "广西",
|
"青岛", "山东",
|
"上海", "上海",
|
"深圳", "深圳",
|
"沈阳", "沈阳",
|
"石家庄", "河北",
|
"太原", "山西",
|
"天津", "天津",
|
"乌鲁木齐", "新疆",
|
"武汉", "湖北",
|
"西安", "西安",
|
"西宁", "青海",
|
"银川", "宁夏",
|
"长春", "吉林",
|
"长沙", "湖南",
|
"郑州", "河南",
|
"重庆", "重庆",
|
"其他"
|
)
|
)
|
)
|
)
|
)</formula>
|
<label>OCSM管理省</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>OlympusCalendar__c</fullName>
|
<deleteConstraint>SetNull</deleteConstraint>
|
<externalId>false</externalId>
|
<label>Olympus日历</label>
|
<referenceTo>OlympusCalendar__c</referenceTo>
|
<relationshipName>OlympusCalendarS3sN</relationshipName>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Lookup</type>
|
</fields>
|
<fields>
|
<fullName>Over_Submit_Time_Count__c</fullName>
|
<description>提出時間を経過した際に1を表示</description>
|
<externalId>false</externalId>
|
<formula>IF(Submission_Elapsed_Hour__c > 0, 1, 0)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>规定时间外提交</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Owner_Ismatch__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(Reporter__c = OwnerId, "1", Reporter__c + "," + OwnerId)</formula>
|
<label>Owner_Ismatch</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Planning_Time__c</fullName>
|
<externalId>false</externalId>
|
<label>计划作成时间</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>DateTime</type>
|
</fields>
|
<fields>
|
<fullName>Position__c</fullName>
|
<externalId>false</externalId>
|
<formula>Text(Reporter__r.Post__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>Profile__c</fullName>
|
<externalId>false</externalId>
|
<formula>Reporter__r.Profile.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>Report_Deadline__c</fullName>
|
<description>2014年3月1日，提出时间修改到12点
|
02:30:00 改到 04:00:00
|
|
IF(ISPICKVAL(Reporter__r.Province__c , "新疆自治区"),
|
|
if (
|
isblank( Reported_Date__c),
|
null,
|
case(
|
MOD( Reported_Date__c - DATE( 1900, 1, 7), 7 ) ,
|
5, datetimevalue( text(year(Reported_Date__c)) & '-' & text(month(Reported_Date__c)) & '-' & text(day(Reported_Date__c)) & ' 02:30:00') + 3,
|
6, datetimevalue( text(year(Reported_Date__c)) & '-' & text(month(Reported_Date__c)) & '-' & text(day(Reported_Date__c)) & ' 02:30:00') + 2,
|
datetimevalue( text(year(Reported_Date__c)) & '-' & text(month(Reported_Date__c)) & '-' & text(day(Reported_Date__c)) & ' 02:30:00') + 1
|
)
|
)</description>
|
<externalId>false</externalId>
|
<formula>IF(ISPICKVAL(Reporter__r.Province__c , "新疆自治区"),
|
IF(!ISNULL(Closest_Work_Day__c),datetimevalue( text(year(Closest_Work_Day__c)) & '-' & text(month(Closest_Work_Day__c)) & '-' & text(day(Closest_Work_Day__c)) & ' 6:00:00'), null),
|
IF(!ISNULL(Closest_Work_Day__c),datetimevalue( text(year(Closest_Work_Day__c)) & '-' & text(month(Closest_Work_Day__c)) & '-' & text(day(Closest_Work_Day__c)) & ' 4:00:00'), null))</formula>
|
<label>提出期限</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>DateTime</type>
|
</fields>
|
<fields>
|
<fullName>Report_From_Sales__c</fullName>
|
<externalId>false</externalId>
|
<label>活动报告</label>
|
<length>32768</length>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>LongTextArea</type>
|
<visibleLines>7</visibleLines>
|
</fields>
|
<fields>
|
<fullName>Reported_Date__c</fullName>
|
<externalId>false</externalId>
|
<label>報告日</label>
|
<required>true</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Date</type>
|
</fields>
|
<fields>
|
<fullName>ReporterId__c</fullName>
|
<externalId>false</externalId>
|
<formula>Reporter__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>报告者Id</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Reporter_Job_Category__c</fullName>
|
<description>共有ルールに使う</description>
|
<externalId>false</externalId>
|
<label>报告者-职种</label>
|
<length>255</length>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Reporter_Province_F__c</fullName>
|
<externalId>false</externalId>
|
<formula>Text(Reporter__r.Province__c)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>Reporter_Province_F</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Reporter_Salesdepartment__c</fullName>
|
<externalId>false</externalId>
|
<label>報告者-本部</label>
|
<length>80</length>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Reporter_State__c</fullName>
|
<externalId>false</externalId>
|
<label>報告者-省</label>
|
<length>80</length>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Reporter__c</fullName>
|
<deleteConstraint>SetNull</deleteConstraint>
|
<externalId>false</externalId>
|
<label>報告者</label>
|
<referenceTo>User</referenceTo>
|
<relationshipName>ReportergCR4</relationshipName>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Lookup</type>
|
</fields>
|
<fields>
|
<fullName>Reporter_incharge_product__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>Responsible_for_Products_Concurrently__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>Status_With_Check__c</fullName>
|
<description>删除批准代理的条件 2014年3月18日
|
|
Case(Status__c
|
,"作成中", "草案中"
|
,"申請中", IF(And(Count_of_Event__c > 0, Count_of_Event__c = Count_Ministercheck_of_Event__c + Count_Managercheck_of_Event__c), "批准(代理)", "申请中")
|
,"非承認", "不批准"
|
,"承認","批准"
|
,Text(Status__c)
|
)</description>
|
<externalId>false</externalId>
|
<formula>Case(Status__c
|
,"作成中", "草案中"
|
,"申請中", IF(And(Count_of_Event_All__c> 0, Count_of_Event_All__c = Count_Ministercheck_of_Event__c + Count_Managercheck_of_Event__c), "批准", "申请中")
|
,"非承認", "不批准"
|
,"承認","批准"
|
,Text(Status__c)
|
)</formula>
|
<label>日报状态(含代理)</label>
|
<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>true</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>
|
</valueSetDefinition>
|
</valueSet>
|
</fields>
|
<fields>
|
<fullName>Submission_Elapsed_Hour__c</fullName>
|
<description>20130626修正前:
|
IF( Reported_Date__c >= Submit_Date_New__c,
|
0,
|
(Submit_Date_New__c - (Reported_Date__c + 1)) * 24 + VALUE(MID(TEXT(Submit_DateTime_New__c + (8 - 9)/ 24), 12, 2))
|
)</description>
|
<externalId>false</externalId>
|
<formula>IF(Submit_DateTime_New__c < (Report_Deadline__c + 1/24/60),
|
0,
|
(Submit_DateTime_New__c - Report_Deadline__c) * 24
|
)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<inlineHelpText>提出期限よりの経過時間</inlineHelpText>
|
<label>超过提出期限的时间</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>2</scale>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Submit_DateTime_Latest__c</fullName>
|
<externalId>false</externalId>
|
<label>最后提出时间</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>DateTime</type>
|
</fields>
|
<fields>
|
<fullName>Submit_DateTime_New__c</fullName>
|
<externalId>false</externalId>
|
<label>初次提出时间</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>DateTime</type>
|
</fields>
|
<fields>
|
<fullName>Submit_Date_Latest__c</fullName>
|
<externalId>false</externalId>
|
<label>最終提出日</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Date</type>
|
</fields>
|
<fields>
|
<fullName>Submit_Date_New__c</fullName>
|
<externalId>false</externalId>
|
<label>初次提出日</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Date</type>
|
</fields>
|
<fields>
|
<fullName>Submit_OnTime_Count__c</fullName>
|
<description>2013/06/15 変更前
|
提前提交的不算按时提交
|
IF (
|
Isblank( Submit_Date_New__c),
|
0,
|
IF (
|
Reported_Date__c <= Submit_Date_New__c,
|
IF (
|
Submit_DateTime_New__c < Report_Deadline__c,
|
1,
|
0
|
),
|
0
|
)
|
)</description>
|
<externalId>false</externalId>
|
<formula>IF (
|
Isblank( Submit_Date_New__c),
|
0,
|
IF (
|
Submit_DateTime_New__c < (Report_Deadline__c + 1/24/60),
|
1,
|
0
|
)
|
)</formula>
|
<label>规定时间内提交</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Working_Time_From__c</fullName>
|
<externalId>false</externalId>
|
<label>开始日期</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>DateTime</type>
|
</fields>
|
<fields>
|
<fullName>Working_Time_To__c</fullName>
|
<externalId>false</externalId>
|
<label>结束日期</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>DateTime</type>
|
</fields>
|
<fields>
|
<fullName>Year_month__c</fullName>
|
<externalId>false</externalId>
|
<formula>text(year(Reported_Date__c))&text(month(Reported_Date__c))</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>年月</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Year_month_txt__c</fullName>
|
<externalId>false</externalId>
|
<label>年月(文本)</label>
|
<length>50</length>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Youbi2__c</fullName>
|
<externalId>false</externalId>
|
<formula>CASE(MOD( Reported_Date__c - DATE(1900, 1, 7), 7),
|
0, "Sun",
|
1, "Mon",
|
2, "Tue",
|
3, "Wed",
|
4, "Thu",
|
5, "Fri",
|
6, "Sat",
|
"#Error#")</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>星期</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Youbi__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(OlympusCalendar__r.IsWorkDay__c = 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>shengchek__c</fullName>
|
<externalId>false</externalId>
|
<formula>if( Reporter_State__c <> text(Reporter__r.Province__c) , 1000, 0
|
)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>省チェック</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<label>日报一览</label>
|
<listViews>
|
<fullName>EditingStatusReport</fullName>
|
<columns>NAME</columns>
|
<columns>Status_With_Check__c</columns>
|
<columns>Reported_Date__c</columns>
|
<columns>Reporter__c</columns>
|
<columns>Count_of_Event__c</columns>
|
<filterScope>Everything</filterScope>
|
<filters>
|
<field>Status__c</field>
|
<operation>equals</operation>
|
<value>作成中,草案中</value>
|
</filters>
|
<filters>
|
<field>Reported_Date__c</field>
|
<operation>greaterOrEqual</operation>
|
<value>THIS_FISCAL_YEAR</value>
|
</filters>
|
<filters>
|
<field>Active_user__c</field>
|
<operation>equals</operation>
|
<value>1</value>
|
</filters>
|
<label>10.草案中的日报</label>
|
<language>ja</language>
|
</listViews>
|
<listViews>
|
<fullName>MyEditingStatusReport</fullName>
|
<columns>NAME</columns>
|
<columns>Status_With_Check__c</columns>
|
<columns>Reported_Date__c</columns>
|
<columns>Reporter__c</columns>
|
<columns>CREATEDBY_USER.ALIAS</columns>
|
<columns>Count_of_Event__c</columns>
|
<columns>Report_From_Sales__c</columns>
|
<filterScope>Mine</filterScope>
|
<filters>
|
<field>Status_With_Check__c</field>
|
<operation>equals</operation>
|
<value>草案中</value>
|
</filters>
|
<label>01.我的草案中的日报</label>
|
<language>ja</language>
|
</listViews>
|
<listViews>
|
<fullName>MyNotApprovedReport</fullName>
|
<columns>NAME</columns>
|
<columns>Status_With_Check__c</columns>
|
<columns>Reported_Date__c</columns>
|
<columns>Reporter__c</columns>
|
<columns>CREATEDBY_USER.ALIAS</columns>
|
<columns>Report_From_Sales__c</columns>
|
<columns>Count_of_Event__c</columns>
|
<columns>FeedbackManager__c</columns>
|
<columns>Mail_Send_Check__c</columns>
|
<filterScope>Mine</filterScope>
|
<filters>
|
<field>Status_With_Check__c</field>
|
<operation>equals</operation>
|
<value>申请中</value>
|
</filters>
|
<label>02.我的申請中的日报</label>
|
<language>ja</language>
|
</listViews>
|
<listViews>
|
<fullName>MyRejectReport</fullName>
|
<columns>NAME</columns>
|
<columns>Status_With_Check__c</columns>
|
<columns>Reported_Date__c</columns>
|
<columns>Reporter__c</columns>
|
<columns>CREATEDBY_USER.ALIAS</columns>
|
<columns>Report_From_Sales__c</columns>
|
<columns>Count_of_Event__c</columns>
|
<columns>FeedbackManager__c</columns>
|
<filterScope>Mine</filterScope>
|
<filters>
|
<field>Status_With_Check__c</field>
|
<operation>equals</operation>
|
<value>不批准</value>
|
</filters>
|
<label>03.我的驳回中的日报</label>
|
<language>ja</language>
|
</listViews>
|
<listViews>
|
<fullName>MyRejectReport_ALLOWED</fullName>
|
<columns>NAME</columns>
|
<columns>Status_With_Check__c</columns>
|
<columns>Reported_Date__c</columns>
|
<columns>Reporter__c</columns>
|
<columns>CREATEDBY_USER.ALIAS</columns>
|
<columns>Report_From_Sales__c</columns>
|
<columns>Count_of_Event__c</columns>
|
<columns>FeedbackManager__c</columns>
|
<filterScope>Mine</filterScope>
|
<filters>
|
<field>Status_With_Check__c</field>
|
<operation>equals</operation>
|
<value>批准</value>
|
</filters>
|
<label>04.我的已批准的日报</label>
|
<language>ja</language>
|
</listViews>
|
<listViews>
|
<fullName>MyThisMonthReport</fullName>
|
<columns>NAME</columns>
|
<columns>Status_With_Check__c</columns>
|
<columns>Reported_Date__c</columns>
|
<columns>Reporter__c</columns>
|
<columns>Submit_DateTime_New__c</columns>
|
<columns>Report_Deadline__c</columns>
|
<columns>Count_of_Event__c</columns>
|
<columns>Report_From_Sales__c</columns>
|
<columns>CREATEDBY_USER.ALIAS</columns>
|
<filterScope>Mine</filterScope>
|
<filters>
|
<field>Reported_Date__c</field>
|
<operation>equals</operation>
|
<value>THIS_MONTH</value>
|
</filters>
|
<label>00.我的本月的日报</label>
|
<language>ja</language>
|
</listViews>
|
<listViews>
|
<fullName>NotApprovedReport</fullName>
|
<columns>NAME</columns>
|
<columns>Status__c</columns>
|
<columns>Status_With_Check__c</columns>
|
<columns>Reported_Date__c</columns>
|
<columns>Reporter__c</columns>
|
<columns>CREATEDBY_USER.ALIAS</columns>
|
<columns>Report_From_Sales__c</columns>
|
<columns>Count_of_Event__c</columns>
|
<columns>Mail_Send_Check__c</columns>
|
<columns>FeedbackManager__c</columns>
|
<columns>Count_Managercheck_of_Event__c</columns>
|
<columns>Approved_DateTime_With_Check__c</columns>
|
<filterScope>Everything</filterScope>
|
<filters>
|
<field>Status__c</field>
|
<operation>equals</operation>
|
<value>申請中</value>
|
</filters>
|
<filters>
|
<field>Apply_Report__c</field>
|
<operation>equals</operation>
|
<value>是</value>
|
</filters>
|
<filters>
|
<field>Reported_Date__c</field>
|
<operation>greaterOrEqual</operation>
|
<value>4/1/2020</value>
|
</filters>
|
<filters>
|
<field>Daily_Report_Data_Type__c</field>
|
<operation>equals</operation>
|
<value>,通常,一日休假,全天培训</value>
|
</filters>
|
<filters>
|
<field>Approved_DateTime_With_Check__c</field>
|
<operation>equals</operation>
|
</filters>
|
<label>14.申请中需要自己审批的日报</label>
|
<language>ja</language>
|
</listViews>
|
<listViews>
|
<fullName>NotApprovedReport1</fullName>
|
<columns>NAME</columns>
|
<columns>Status_With_Check__c</columns>
|
<columns>Reported_Date__c</columns>
|
<columns>Reporter__c</columns>
|
<columns>Count_of_Event__c</columns>
|
<filterScope>Everything</filterScope>
|
<filters>
|
<field>Status_With_Check__c</field>
|
<operation>equals</operation>
|
<value>申请中</value>
|
</filters>
|
<filters>
|
<field>Reported_Date__c</field>
|
<operation>greaterOrEqual</operation>
|
<value>THIS_FISCAL_YEAR</value>
|
</filters>
|
<filters>
|
<field>Active_user__c</field>
|
<operation>equals</operation>
|
<value>1</value>
|
</filters>
|
<label>11.申请中的日报</label>
|
<language>ja</language>
|
</listViews>
|
<listViews>
|
<fullName>NotApprovedReport2</fullName>
|
<columns>NAME</columns>
|
<columns>Status_With_Check__c</columns>
|
<columns>Reported_Date__c</columns>
|
<columns>Reporter__c</columns>
|
<columns>Count_of_Event__c</columns>
|
<filterScope>Everything</filterScope>
|
<filters>
|
<field>Status_With_Check__c</field>
|
<operation>contains</operation>
|
<value>批准</value>
|
</filters>
|
<filters>
|
<field>Reported_Date__c</field>
|
<operation>greaterOrEqual</operation>
|
<value>THIS_FISCAL_YEAR</value>
|
</filters>
|
<filters>
|
<field>Active_user__c</field>
|
<operation>equals</operation>
|
<value>1</value>
|
</filters>
|
<label>12.已批准的日报</label>
|
<language>ja</language>
|
</listViews>
|
<listViews>
|
<fullName>NotApprovedReport_new</fullName>
|
<columns>NAME</columns>
|
<columns>Status__c</columns>
|
<columns>Status_With_Check__c</columns>
|
<columns>Reported_Date__c</columns>
|
<columns>Reporter__c</columns>
|
<columns>CREATEDBY_USER.ALIAS</columns>
|
<columns>Report_From_Sales__c</columns>
|
<columns>Count_of_Event__c</columns>
|
<columns>Mail_Send_Check__c</columns>
|
<columns>FeedbackManager__c</columns>
|
<columns>Count_Managercheck_of_Event__c</columns>
|
<columns>Approved_DateTime_With_Check__c</columns>
|
<filterScope>Everything</filterScope>
|
<filters>
|
<field>Status__c</field>
|
<operation>equals</operation>
|
<value>申請中</value>
|
</filters>
|
<filters>
|
<field>Approved_DateTime_With_Check__c</field>
|
<operation>equals</operation>
|
</filters>
|
<filters>
|
<field>Reported_Date__c</field>
|
<operation>greaterOrEqual</operation>
|
<value>4/1/2020</value>
|
</filters>
|
<filters>
|
<field>Daily_Report_Data_Type__c</field>
|
<operation>equals</operation>
|
<value>通常,一日休假,BTC/ATC/ETC,全天培训</value>
|
</filters>
|
<filters>
|
<field>Apply_Report__c</field>
|
<operation>equals</operation>
|
<value>是</value>
|
</filters>
|
<label>15.申请中需要自己审批的日报-仅自己</label>
|
<language>ja</language>
|
</listViews>
|
<listViews>
|
<fullName>RejectReport</fullName>
|
<columns>NAME</columns>
|
<columns>Status_With_Check__c</columns>
|
<columns>Reported_Date__c</columns>
|
<columns>Reporter__c</columns>
|
<columns>Count_of_Event__c</columns>
|
<columns>FeedbackManager__c</columns>
|
<filterScope>Everything</filterScope>
|
<filters>
|
<field>Status__c</field>
|
<operation>equals</operation>
|
<value>非承認</value>
|
</filters>
|
<filters>
|
<field>Reported_Date__c</field>
|
<operation>equals</operation>
|
<value>THIS_FISCAL_YEAR</value>
|
</filters>
|
<filters>
|
<field>Active_user__c</field>
|
<operation>equals</operation>
|
<value>1</value>
|
</filters>
|
<label>13.驳回的日报</label>
|
<language>ja</language>
|
</listViews>
|
<nameField>
|
<displayFormat>{YYYY}{MM}-{0000000}</displayFormat>
|
<label>日报NO.</label>
|
<trackHistory>false</trackHistory>
|
<type>AutoNumber</type>
|
</nameField>
|
<searchLayouts>
|
<customTabListAdditionalFields>Status__c</customTabListAdditionalFields>
|
<customTabListAdditionalFields>Reporter__c</customTabListAdditionalFields>
|
<customTabListAdditionalFields>Working_Time_From__c</customTabListAdditionalFields>
|
<customTabListAdditionalFields>Working_Time_To__c</customTabListAdditionalFields>
|
<customTabListAdditionalFields>Submit_DateTime_New__c</customTabListAdditionalFields>
|
<customTabListAdditionalFields>Report_Deadline__c</customTabListAdditionalFields>
|
<customTabListAdditionalFields>Approved_DateTime__c</customTabListAdditionalFields>
|
<customTabListAdditionalFields>CREATEDBY_USER.ALIAS</customTabListAdditionalFields>
|
<customTabListAdditionalFields>CREATEDBY_USER</customTabListAdditionalFields>
|
<excludedStandardButtons>New</excludedStandardButtons>
|
<excludedStandardButtons>ChangeOwner</excludedStandardButtons>
|
<excludedStandardButtons>Accept</excludedStandardButtons>
|
<lookupDialogsAdditionalFields>Reporter__c</lookupDialogsAdditionalFields>
|
<lookupDialogsAdditionalFields>Reported_Date__c</lookupDialogsAdditionalFields>
|
<lookupDialogsAdditionalFields>Reporter_Job_Category__c</lookupDialogsAdditionalFields>
|
<lookupDialogsAdditionalFields>Position__c</lookupDialogsAdditionalFields>
|
<lookupDialogsAdditionalFields>Reporter_State__c</lookupDialogsAdditionalFields>
|
<searchFilterFields>NAME</searchFilterFields>
|
<searchFilterFields>Reported_Date__c</searchFilterFields>
|
<searchFilterFields>Reporter__c</searchFilterFields>
|
<searchFilterFields>Reporter_State__c</searchFilterFields>
|
<searchFilterFields>Reporter_Job_Category__c</searchFilterFields>
|
<searchResultsAdditionalFields>Reported_Date__c</searchResultsAdditionalFields>
|
<searchResultsAdditionalFields>Reporter__c</searchResultsAdditionalFields>
|
<searchResultsAdditionalFields>Reporter_State__c</searchResultsAdditionalFields>
|
<searchResultsAdditionalFields>Reporter_Job_Category__c</searchResultsAdditionalFields>
|
<searchResultsAdditionalFields>Position__c</searchResultsAdditionalFields>
|
</searchLayouts>
|
<sharingModel>Private</sharingModel>
|
<validationRules>
|
<fullName>Not_submit_before_endding</fullName>
|
<active>true</active>
|
<errorConditionFormula>AND(
|
ISPICKVAL(Daily_Report_Data_Type__c, "通常"),
|
Text(Status__c) != '作成中',
|
Latest_Event_Time__c > NOW() ) && $User.Id != '00510000005sEEM' && $User.Batch_User__c = true</errorConditionFormula>
|
<errorMessage>请在今天最终事件结束之后再提交报告</errorMessage>
|
</validationRules>
|
<validationRules>
|
<fullName>Not_submit_furture_report</fullName>
|
<active>true</active>
|
<errorConditionFormula>AND(
|
ISPICKVAL(Daily_Report_Data_Type__c, "通常"),
|
Text(Status__c) != '作成中',
|
Reported_Date__c > today()) && $User.Id != '00510000005sEEM'</errorConditionFormula>
|
<errorMessage>除了休假和培训以外，不可以提交未来的报告</errorMessage>
|
</validationRules>
|
<validationRules>
|
<fullName>StatusCheck_IsManager</fullName>
|
<active>true</active>
|
<description>Error_Message4のエラーと同じロジック</description>
|
<errorConditionFormula>($User.ProfileId != '00e10000000Y3o5' || $User.Batch_User__c != True)
|
&& Text(Status__c) == '承認'
|
&& Reporter__r.ManagerId != $User.Id
|
&& Reporter__r.BuchangApprovalManager__c != $User.Id
|
&& Reporter__r.BuchangApprovalManagerSales__c != $User.Id</errorConditionFormula>
|
<errorDisplayField>Status__c</errorDisplayField>
|
<errorMessage>上司才可以选择。</errorMessage>
|
</validationRules>
|
<validationRules>
|
<fullName>must_input_Reporter</fullName>
|
<active>true</active>
|
<description>OLY_OCM-196</description>
|
<errorConditionFormula>(ISNEW() || ISCHANGED(Reporter__c)) && ISBLANK(Reporter__c)</errorConditionFormula>
|
<errorDisplayField>Reporter__c</errorDisplayField>
|
<errorMessage>必须输入报告者</errorMessage>
|
</validationRules>
|
<visibility>Public</visibility>
|
<webLinks>
|
<fullName>Daily_report</fullName>
|
<availability>online</availability>
|
<displayType>massActionButton</displayType>
|
<encodingKey>UTF-8</encodingKey>
|
<height>600</height>
|
<linkType>url</linkType>
|
<masterLabel>日報イメージ</masterLabel>
|
<openType>noSidebar</openType>
|
<protected>false</protected>
|
<requireRowSelection>false</requireRowSelection>
|
<url>/servlet/servlet.FileDownload?file=015100000013CI9</url>
|
</webLinks>
|
<webLinks>
|
<fullName>NTC</fullName>
|
<availability>online</availability>
|
<displayType>button</displayType>
|
<encodingKey>UTF-8</encodingKey>
|
<hasMenubar>false</hasMenubar>
|
<hasScrollbars>true</hasScrollbars>
|
<hasToolbar>false</hasToolbar>
|
<height>600</height>
|
<isResizable>true</isResizable>
|
<linkType>url</linkType>
|
<masterLabel>NTC</masterLabel>
|
<openType>newWindow</openType>
|
<position>none</position>
|
<protected>false</protected>
|
<showsLocation>false</showsLocation>
|
<showsStatus>false</showsStatus>
|
<url>/a0B/e?CF00N10000002CWvR=201208-0000001
|
&CF00N10000002CWvR_lkid={!Daily_Report__c.Id}
|
&retURL=%2F{!Daily_Report__c.Id}
|
&RecordType=01210000000Qeko</url>
|
</webLinks>
|
<webLinks>
|
<fullName>OPD</fullName>
|
<availability>online</availability>
|
<description>最後：&ent=01I10000000SWfe</description>
|
<displayType>button</displayType>
|
<encodingKey>UTF-8</encodingKey>
|
<hasMenubar>false</hasMenubar>
|
<hasScrollbars>true</hasScrollbars>
|
<hasToolbar>false</hasToolbar>
|
<height>600</height>
|
<isResizable>true</isResizable>
|
<linkType>url</linkType>
|
<masterLabel>OPD</masterLabel>
|
<openType>newWindow</openType>
|
<position>none</position>
|
<protected>false</protected>
|
<showsLocation>false</showsLocation>
|
<showsStatus>false</showsStatus>
|
<url>/a0B/e?CF00N10000002CWvR=201208-0000001
|
&CF00N10000002CWvR_lkid={!Daily_Report__c.Id}
|
&retURL=%2F{!Daily_Report__c.Id}
|
&RecordType=01210000000Qekj</url>
|
</webLinks>
|
<webLinks>
|
<fullName>OnCall</fullName>
|
<availability>online</availability>
|
<displayType>button</displayType>
|
<encodingKey>UTF-8</encodingKey>
|
<hasMenubar>false</hasMenubar>
|
<hasScrollbars>true</hasScrollbars>
|
<hasToolbar>false</hasToolbar>
|
<height>600</height>
|
<isResizable>true</isResizable>
|
<linkType>url</linkType>
|
<masterLabel>OnCall</masterLabel>
|
<openType>newWindow</openType>
|
<position>none</position>
|
<protected>false</protected>
|
<showsLocation>false</showsLocation>
|
<showsStatus>false</showsStatus>
|
<url>/a0B/e?CF00N10000002CWvR=201208-0000001
|
&CF00N10000002CWvR_lkid={!Daily_Report__c.Id}
|
&retURL=%2F{!Daily_Report__c.Id}
|
&RecordType=01210000000Qekt</url>
|
</webLinks>
|
</CustomObject>
|
