高章伟
2022-02-24 2aa8da8af66aa8ae00f25831aed6bb0364176e7b
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
<?xml version="1.0" encoding="UTF-8"?>
<CustomObject xmlns="http://soap.sforce.com/2006/04/metadata">
    <actionOverrides>
        <actionName>Accept</actionName>
        <type>Default</type>
    </actionOverrides>
    <actionOverrides>
        <actionName>CancelEdit</actionName>
        <type>Default</type>
    </actionOverrides>
    <actionOverrides>
        <actionName>Clone</actionName>
        <type>Default</type>
    </actionOverrides>
    <actionOverrides>
        <actionName>Delete</actionName>
        <type>Default</type>
    </actionOverrides>
    <actionOverrides>
        <actionName>Edit</actionName>
        <type>Default</type>
    </actionOverrides>
    <actionOverrides>
        <actionName>List</actionName>
        <type>Default</type>
    </actionOverrides>
    <actionOverrides>
        <actionName>New</actionName>
        <type>Default</type>
    </actionOverrides>
    <actionOverrides>
        <actionName>SaveEdit</actionName>
        <type>Default</type>
    </actionOverrides>
    <actionOverrides>
        <actionName>Tab</actionName>
        <type>Default</type>
    </actionOverrides>
    <actionOverrides>
        <actionName>View</actionName>
        <type>Default</type>
    </actionOverrides>
    <allowInChatterGroups>false</allowInChatterGroups>
    <compactLayoutAssignment>SYSTEM</compactLayoutAssignment>
    <deploymentStatus>Deployed</deploymentStatus>
    <enableActivities>false</enableActivities>
    <enableBulkApi>false</enableBulkApi>
    <enableChangeDataCapture>false</enableChangeDataCapture>
    <enableFeeds>false</enableFeeds>
    <enableHistory>false</enableHistory>
    <enableReports>true</enableReports>
    <enableSearch>true</enableSearch>
    <enableSharing>false</enableSharing>
    <enableStreamingApi>false</enableStreamingApi>
    <externalSharingModel>Private</externalSharingModel>
    <fields>
        <fullName>Accurancy_ratio__c</fullName>
        <externalId>false</externalId>
        <label>月初预测订货询价成交率(%</label>
        <precision>18</precision>
        <required>false</required>
        <scale>1</scale>
        <trackTrending>false</trackTrending>
        <type>Percent</type>
    </fields>
    <fields>
        <fullName>Caluculated_start_day__c</fullName>
        <externalId>false</externalId>
        <formula>IF(  Evaluation_date__c  &gt;= DATE(YEAR(today())-1,MONTH(Today())+1,01),1,0)</formula>
        <formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
        <label>统计开始日(1年前)</label>
        <precision>18</precision>
        <required>false</required>
        <scale>0</scale>
        <trackTrending>false</trackTrending>
        <type>Number</type>
        <unique>false</unique>
    </fields>
    <fields>
        <fullName>Created_Date_Text__c</fullName>
        <description>用户 手动修改  snapshot 数据的  时间</description>
        <externalId>false</externalId>
        <label>Created Date Text</label>
        <required>false</required>
        <trackTrending>false</trackTrending>
        <type>DateTime</type>
    </fields>
    <fields>
        <fullName>Date__c</fullName>
        <externalId>false</externalId>
        <formula>DATEVALUE( CreatedDate )</formula>
        <formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
        <label>日期</label>
        <required>false</required>
        <trackTrending>false</trackTrending>
        <type>Date</type>
    </fields>
    <fields>
        <fullName>Evaluation_date__c</fullName>
        <externalId>false</externalId>
        <formula>IF(ISNULL(Created_Date_Text__c), DATEVALUE( CreatedDate )-3, 
DATEVALUE(Created_Date_Text__c)-1)</formula>
        <formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
        <label>考核月</label>
        <required>false</required>
        <trackTrending>false</trackTrending>
        <type>Date</type>
    </fields>
    <fields>
        <fullName>Forecast_order_PCL_number__c</fullName>
        <externalId>false</externalId>
        <label>本月预测内订货询价条数</label>
        <precision>18</precision>
        <required>false</required>
        <scale>0</scale>
        <trackTrending>false</trackTrending>
        <type>Number</type>
        <unique>false</unique>
    </fields>
    <fields>
        <fullName>Inquiry_Number__c</fullName>
        <externalId>false</externalId>
        <label>询价编码</label>
        <length>28</length>
        <required>false</required>
        <trackTrending>false</trackTrending>
        <type>Text</type>
        <unique>false</unique>
    </fields>
    <fields>
        <fullName>Month__c</fullName>
        <externalId>false</externalId>
        <formula>text(month(Date__c)-1) &amp; &quot;月&quot;</formula>
        <formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
        <label>日期(月)</label>
        <required>false</required>
        <trackTrending>false</trackTrending>
        <type>Text</type>
        <unique>false</unique>
    </fields>
    <fields>
        <fullName>Number_of_PCL__c</fullName>
        <externalId>false</externalId>
        <label>成交询价条数</label>
        <precision>18</precision>
        <required>false</required>
        <scale>0</scale>
        <trackTrending>false</trackTrending>
        <type>Number</type>
        <unique>false</unique>
    </fields>
    <fields>
        <fullName>Owner_ID__c</fullName>
        <externalId>false</externalId>
        <formula>OwnerId</formula>
        <formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
        <label>所有人ID</label>
        <required>false</required>
        <trackTrending>false</trackTrending>
        <type>Text</type>
        <unique>false</unique>
    </fields>
    <fields>
        <fullName>Person_in_charge__c</fullName>
        <externalId>false</externalId>
        <label>询价担当人</label>
        <length>250</length>
        <required>false</required>
        <trackTrending>false</trackTrending>
        <type>Text</type>
        <unique>false</unique>
    </fields>
    <fields>
        <fullName>Province_SAP__c</fullName>
        <externalId>false</externalId>
        <formula>Case(Province__c, 
&quot;安徽省&quot;,&quot;安徽&quot;, 
&quot;北京市&quot;,&quot;北京&quot;, 
&quot;福建省&quot;,&quot;福建&quot;, 
&quot;甘肃省&quot;,&quot;甘肃&quot;, 
&quot;广东省&quot;,&quot;广东&quot;, 
&quot;广西自治区&quot;,&quot;广西&quot;, 
&quot;贵州省&quot;,&quot;贵州&quot;, 
&quot;海南省&quot;,&quot;广东&quot;, 
&quot;河北省&quot;,&quot;河北&quot;, 
&quot;河南省&quot;,&quot;河南&quot;, 
&quot;黑龙江省&quot;,&quot;黑龙江&quot;, 
&quot;湖北省&quot;,&quot;湖北&quot;, 
&quot;湖南省&quot;,&quot;湖南&quot;, 
&quot;吉林省&quot;,&quot;吉林&quot;, 
&quot;江苏省&quot;,&quot;江苏&quot;, 
&quot;江西省&quot;,&quot;江西&quot;, 
&quot;辽宁省&quot;,&quot;辽宁&quot;, 
&quot;大连市&quot;,&quot;辽宁&quot;, 
&quot;内蒙古&quot;,&quot;内蒙古&quot;, 
&quot;宁夏自治区&quot;,&quot;宁夏&quot;, 
&quot;青海省&quot;,&quot;青海&quot;, 
&quot;山东省&quot;,&quot;山东&quot;, 
&quot;青岛市&quot;,&quot;山东&quot;, 
&quot;山西省&quot;,&quot;山西&quot;, 
&quot;陕西省&quot;,&quot;陕西&quot;, 
&quot;上海市&quot;,&quot;上海&quot;, 
&quot;四川省&quot;,&quot;四川&quot;, 
&quot;天津市&quot;,&quot;天津&quot;, 
&quot;西藏自治区&quot;,&quot;四川&quot;, 
&quot;新疆自治区&quot;,&quot;新疆&quot;, 
&quot;云南省&quot;,&quot;云南&quot;, 
&quot;浙江省&quot;,&quot;浙江&quot;, 
&quot;重庆市&quot;,&quot;重庆&quot;,&quot;&quot;)</formula>
        <formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
        <label>省(SAP) &amp; MB</label>
        <required>false</required>
        <trackTrending>false</trackTrending>
        <type>Text</type>
        <unique>false</unique>
    </fields>
    <fields>
        <fullName>Province__c</fullName>
        <externalId>false</externalId>
        <label>省(所有人)</label>
        <length>250</length>
        <required>false</required>
        <trackTrending>false</trackTrending>
        <type>Text</type>
        <unique>false</unique>
    </fields>
    <fields>
        <fullName>Province_formula__c</fullName>
        <externalId>false</externalId>
        <formula>text(Owner:User.Province__c)</formula>
        <formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
        <label>省(公式)</label>
        <required>false</required>
        <trackTrending>false</trackTrending>
        <type>Text</type>
        <unique>false</unique>
    </fields>
    <fields>
        <fullName>SalesDept__c</fullName>
        <externalId>false</externalId>
        <label>销售本部(所有人)</label>
        <length>250</length>
        <required>false</required>
        <trackTrending>false</trackTrending>
        <type>Text</type>
        <unique>false</unique>
    </fields>
    <fields>
        <fullName>Salesdept_formula__c</fullName>
        <externalId>false</externalId>
        <formula>Owner:User.Salesdepartment__c</formula>
        <formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
        <label>销售本部(公式)</label>
        <required>false</required>
        <trackTrending>false</trackTrending>
        <type>Text</type>
        <unique>false</unique>
    </fields>
    <fields>
        <fullName>out_from_target__c</fullName>
        <externalId>false</externalId>
        <formula>IF(Number_of_PCL__c - Forecast_order_PCL_number__c &gt; 0,Number_of_PCL__c - Forecast_order_PCL_number__c,0)</formula>
        <formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
        <label>预测外成交询价</label>
        <precision>18</precision>
        <required>false</required>
        <scale>0</scale>
        <trackTrending>false</trackTrending>
        <type>Number</type>
        <unique>false</unique>
    </fields>
    <fields>
        <fullName>owner_formula__c</fullName>
        <externalId>false</externalId>
        <formula>Owner:User.Alias__c</formula>
        <formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
        <label>询价担当人(公式)</label>
        <required>false</required>
        <trackTrending>false</trackTrending>
        <type>Text</type>
        <unique>false</unique>
    </fields>
    <label>SS_询价单月预测订货准确率</label>
    <nameField>
        <displayFormat>SSPCL1-{YYYY}{MM}-{0000}</displayFormat>
        <label>SS询价单月预测订货准确率</label>
        <type>AutoNumber</type>
    </nameField>
    <searchLayouts/>
    <sharingModel>Private</sharingModel>
    <visibility>Public</visibility>
</CustomObject>