<?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>
|
<enableEnhancedLookup>true</enableEnhancedLookup>
|
<enableFeeds>false</enableFeeds>
|
<enableHistory>true</enableHistory>
|
<enableReports>true</enableReports>
|
<enableSearch>true</enableSearch>
|
<enableSharing>true</enableSharing>
|
<enableStreamingApi>true</enableStreamingApi>
|
<externalSharingModel>ControlledByParent</externalSharingModel>
|
<fields>
|
<fullName>Actual_Installation_Day__c</fullName>
|
<externalId>false</externalId>
|
<label>实际安装日</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Date</type>
|
</fields>
|
<fields>
|
<fullName>AdjustnetWorthNoProviston_DN__c</fullName>
|
<externalId>false</externalId>
|
<label>调整已发货金额(不含税,不含计提)</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>2</scale>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Currency</type>
|
</fields>
|
<fields>
|
<fullName>After_win_collect_endouser_contract__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(End_User_contract__c = "已提交",
|
Collect_endoUser_contract_date__c -FirstApproveDate__c
|
,
|
Today()-FirstApproveDate__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>Agency1_Name_F__c</fullName>
|
<description>Opportunity__r.Agency1__c</description>
|
<externalId>false</externalId>
|
<formula>Opportunity__r.Agency1_Name_F__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>经销商名称</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Amount_Without_Tax__c</fullName>
|
<externalId>false</externalId>
|
<formula>Opportunity__r.Amount_Without_Tax__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>OCSM预测成交金额(不含税)_元</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>2</scale>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Currency</type>
|
</fields>
|
<fields>
|
<fullName>AssignmentStatus__c</fullName>
|
<externalId>false</externalId>
|
<inlineHelpText>显示的预计交货期可能会发生变化。因厂家交货期根据生产入库情况，会更新交货期的。</inlineHelpText>
|
<label>分配状态</label>
|
<length>80</length>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>AssignmentStatus_for_MB__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(isblank(AssignmentStatus__c),"确认中",AssignmentStatus__c)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>分配状態(MB)</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>AuthorizationNo__c</fullName>
|
<externalId>false</externalId>
|
<label>授权编码(SAP)</label>
|
<length>80</length>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Average_past_time_bw_bo_collect__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(ISBLANK(FirstApproveDate__c),NULL,
|
IF(ISBLANK(Deposit_In_Full_Day__c),today()-FirstApproveDate__c,Deposit_In_Full_Day__c-FirstApproveDate__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>Avrege_BO_past_day__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(ISBLANK(DeliveryDate__c),NULL, DeliveryDate__c - FirstApproveDate__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>BC_Wave__c</fullName>
|
<externalId>false</externalId>
|
<formula>Opportunity__r.BC_Wave__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>部 Wave</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Backorder_Comment__c</fullName>
|
<externalId>false</externalId>
|
<formula>HYPERLINK(
|
"/a05/e?CF00N10000002ESJY="
|
&Name &
|
"&CF00N10000002CZd2_lkid="
|
& Id &
|
"&retURL=%2"
|
&Id
|
,"■")</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>Backorder_complete_average__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(ISBLANK(Backorder_complete_day__c),
|
today()-FirstApproveDate__c,Backorder_complete_day__c-FirstApproveDate__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>Backorder_complete_day__c</fullName>
|
<externalId>false</externalId>
|
<label>全发货完毕日</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Date</type>
|
</fields>
|
<fields>
|
<fullName>Backup_order_number__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(AND(OverviewStatus__c <> "无效合同",FALSE_Order__c = "FALSE"),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>Book_stock__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(AND(OverviewStatus__c <> "无效合同",FALSE_Order__c = "FALSE"),"备货","")</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>是否备货</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>ChangeWarrantyReason__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>ChangeWarranty__c</fullName>
|
<defaultValue>false</defaultValue>
|
<externalId>false</externalId>
|
<label>变更保修期</label>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Checkbox</type>
|
</fields>
|
<fields>
|
<fullName>Collect_endoUser_contract_date__c</fullName>
|
<externalId>false</externalId>
|
<label>最终用户合同收到日</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Date</type>
|
</fields>
|
<fields>
|
<fullName>Collection_Day_Invoice__c</fullName>
|
<externalId>false</externalId>
|
<label>22.安装确认书登录日</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Date</type>
|
</fields>
|
<fields>
|
<fullName>Comment__c</fullName>
|
<externalId>false</externalId>
|
<label>备注</label>
|
<length>32768</length>
|
<trackHistory>true</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>LongTextArea</type>
|
<visibleLines>10</visibleLines>
|
</fields>
|
<fields>
|
<fullName>ContractAmountNoGurantee_F__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(Opportunity__r.SAP_Send_OK__c && (Opportunity__r.Agency1__r.Special__c || Opportunity__r.Agency2__r.Special__c || Opportunity__r.Account.Parent.Special__c) && $User.ViewSpecialAgencyAmout__c == False, null,
|
ContractAmountNoGurantee__c
|
)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>合同金额(不含税,不含计提)</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>2</scale>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Currency</type>
|
</fields>
|
<fields>
|
<fullName>ContractAmountNoGurantee__c</fullName>
|
<externalId>false</externalId>
|
<label>/合同金额(不含税,不含计提)</label>
|
<precision>15</precision>
|
<required>false</required>
|
<scale>2</scale>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Currency</type>
|
</fields>
|
<fields>
|
<fullName>ContractAmount_F__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(Opportunity__r.SAP_Send_OK__c && (Opportunity__r.Agency1__r.Special__c || Opportunity__r.Agency2__r.Special__c || Opportunity__r.Account.Parent.Special__c) && $User.ViewSpecialAgencyAmout__c == False, null,
|
ContractAmount__c
|
)</formula>
|
<label>合同金额</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>2</scale>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Currency</type>
|
</fields>
|
<fields>
|
<fullName>ContractAmount_Sum__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(Opportunity__r.SAP_Send_OK__c && (Opportunity__r.Agency1__r.Special__c || Opportunity__r.Agency2__r.Special__c || Opportunity__r.Account.Parent.Special__c) && $User.ViewSpecialAgencyAmout__c == False, null,
|
ContractAmount__c
|
)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>合同金额</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>2</scale>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>ContractAmount__c</fullName>
|
<externalId>false</externalId>
|
<label>/合同金额</label>
|
<precision>15</precision>
|
<required>false</required>
|
<scale>2</scale>
|
<trackHistory>true</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Currency</type>
|
</fields>
|
<fields>
|
<fullName>ContractAmount_without_tax__c</fullName>
|
<description>Case( Opportunity__r.Trade__c,
|
"内貿",ContractAmount_F__c / 1.17,
|
"外貿",ContractAmount_F__c * Opportunity__r.Today_Rate__c,0)</description>
|
<externalId>false</externalId>
|
<formula>Case( Opportunity__r.Trade__c,
|
"内貿",ContractAmount_F__c / Opportunity__r.Tax_Intra_F_Copy__c ,
|
"外貿",ContractAmount_F__c * Opportunity__r.Today_Rate__c,0)</formula>
|
<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>ContractApplicationNo__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>ContractNO__c</fullName>
|
<externalId>true</externalId>
|
<label>合同编号</label>
|
<length>80</length>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>ContractNO_link__c</fullName>
|
<externalId>false</externalId>
|
<formula>HYPERLINK("/"& Id , ContractNO__c, 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>ContractReceivedDate__c</fullName>
|
<externalId>false</externalId>
|
<label>14.收到合同日</label>
|
<required>false</required>
|
<trackHistory>true</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Date</type>
|
</fields>
|
<fields>
|
<fullName>Contract_Invalid_Date__c</fullName>
|
<description>WF【注残 合同无效】にて設定</description>
|
<externalId>false</externalId>
|
<label>合同无效日</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Date</type>
|
</fields>
|
<fields>
|
<fullName>Create_Activity__c</fullName>
|
<description>HYPERLINK
|
("/00T/e?&what_id="
|
& Id
|
& "&retURL=%2F&"
|
& Id, "■")</description>
|
<externalId>false</externalId>
|
<formula>HYPERLINK
|
("/00U/e?retURL=%2Fapex%2FVFClosePage&accid="& Opportunity__r.AccountId &"&oid="&Opportunity__r.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>Create_task__c</fullName>
|
<externalId>false</externalId>
|
<formula>HYPERLINK
|
("/00T/e?&what_id="
|
& Id
|
& "&retURL=%2F&"
|
& 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>Created_Day__c</fullName>
|
<externalId>false</externalId>
|
<formula>DATEVALUE( CreatedDate )</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>创建日期.</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Date</type>
|
</fields>
|
<fields>
|
<fullName>Current_shipping_date__c</fullName>
|
<externalId>false</externalId>
|
<formula>DeliveryDate__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>最新发货日</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Date</type>
|
</fields>
|
<fields>
|
<fullName>Current_status__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(ReturnFlag__c=True,"",
|
IF(DeliveryStatus__c="已完全交付","",
|
CASE(OverviewStatus__c,
|
'无效合同', "",
|
'冻结', "",
|
|
|
Case(text( Opportunity__r.Purchase_Type__c),
|
"ET24時間販売",
|
IF(AssignmentStatus__c="全部分配","8 货齐,待发货",
|
IF(OR(OverviewStatus__c = "初审通过",OverviewStatus__c = "终审1通过"),"2 待付款",
|
IF(AssignmentStatus__c<>"全部分配","4 备货中",""))),
|
|
|
IF(AND(Paid_Amount_Rate__c >= 100,End_User_contract__c = '已提交' ,AssignmentStatus__c="全部分配"),"8 货齐,待发货",
|
IF(AND(Paid_Amount_Rate__c < 100,End_User_contract__c = '已提交',AssignmentStatus__c="全部分配"),"7 货齐,未付款",
|
IF(AND(Paid_Amount_Rate__c >= 100,End_User_contract__c = '还没提交' ,AssignmentStatus__c="全部分配"),"6 货齐,已付款,无用户合同",
|
IF(AND(Paid_Amount_Rate__c < 100,End_User_contract__c = '还没提交' ,AssignmentStatus__c="全部分配"),"5 货齐,未付款,无用户合同",
|
IF(AND(Paid_Amount_Rate__c >= 100,End_User_contract__c = '已提交',AssignmentStatus__c <> "全部分配"),"4 备货中",
|
IF(AND(Paid_Amount_Rate__c >= 100,End_User_contract__c = '还没提交' ,AssignmentStatus__c <> "全部分配"),"3 已付款,无用户合同",
|
IF(AND(Paid_Amount_Rate__c < 100,End_User_contract__c = '已提交',AssignmentStatus__c <> "全部分配"),"2 待付款",
|
IF(AND(Paid_Amount_Rate__c < 100,End_User_contract__c = '还没提交' ,AssignmentStatus__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>DB_Authorized_DB__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(Opportunity__r.Authorized_DB_No__c = AuthorizationNo__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>DNUnshippedAmount_DN_A__c</fullName>
|
<externalId>false</externalId>
|
<formula>UnshippedAmount_DN__c - ShippedAmount_ZM__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>/未发货金额(含税DN).</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>DeliveryDate__c</fullName>
|
<externalId>false</externalId>
|
<label>20.发货日</label>
|
<required>false</required>
|
<trackHistory>true</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Date</type>
|
</fields>
|
<fields>
|
<fullName>DeliveryDate_backup__c</fullName>
|
<externalId>false</externalId>
|
<label>20.发货日_每3个工作日</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Date</type>
|
</fields>
|
<fields>
|
<fullName>DeliveryDate_less_ThisMonthSS__c</fullName>
|
<externalId>false</externalId>
|
<formula>DeliveryDate_backup__c <= Opportunity__r.Owner.This_Month_SS_day__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>发货日<=第三个工作日</label>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Checkbox</type>
|
</fields>
|
<fields>
|
<fullName>DeliveryStatus__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>Delivery_Confirmation_Date__c</fullName>
|
<externalId>false</externalId>
|
<label>不使用 : 安装确认书回收日</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Date</type>
|
</fields>
|
<fields>
|
<fullName>Delivery_Scheduled_Date__c</fullName>
|
<externalId>false</externalId>
|
<label>预测安装日</label>
|
<required>false</required>
|
<trackHistory>true</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Date</type>
|
</fields>
|
<fields>
|
<fullName>Department_Snapshot__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF( ISBLANK(Department_lastmonth__c),Department__c,Department_lastmonth__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>Department__c</fullName>
|
<externalId>false</externalId>
|
<formula>Opportunity__r.Department__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>Department_lastmonth__c</fullName>
|
<externalId>false</externalId>
|
<label>销售部（预测上月）</label>
|
<length>100</length>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Department_segmenation__c</fullName>
|
<externalId>false</externalId>
|
<formula>Opportunity__r.OCM_department_seg__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>Deposit_In_First_Day__c</fullName>
|
<externalId>false</externalId>
|
<label>不使用 : 第一次付款日</label>
|
<required>false</required>
|
<trackHistory>true</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Date</type>
|
</fields>
|
<fields>
|
<fullName>Deposit_In_Full_Day__c</fullName>
|
<externalId>false</externalId>
|
<label>18.付全款日期</label>
|
<required>false</required>
|
<trackHistory>true</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Date</type>
|
</fields>
|
<fields>
|
<fullName>Distributor_InCharge_opp__c</fullName>
|
<externalId>false</externalId>
|
<formula>Opportunity__r.Distributor_InCharge_opp__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>经销商管理课负责的询价</label>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Checkbox</type>
|
</fields>
|
<fields>
|
<fullName>ET_SP_Consumption__c</fullName>
|
<defaultValue>false</defaultValue>
|
<externalId>false</externalId>
|
<label>耗材订单</label>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Checkbox</type>
|
</fields>
|
<fields>
|
<fullName>ET_order__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(mid(ContractNO__c,4,2)="ET","ET订单","")</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>ET订单</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Elapesd_day_after_ship__c</fullName>
|
<description>最近的一次发货后的天数</description>
|
<externalId>false</externalId>
|
<formula>today() - DeliveryDate__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>Elapsed_day_backorder__c</fullName>
|
<externalId>false</externalId>
|
<formula>Today()-FirstApproveDate__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>Elapsed_day_backorder_category__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(Elapsed_day_backorder__c <= 7,"1周内",
|
IF(Elapsed_day_backorder__c <= 14,"2周内",
|
IF(Elapsed_day_backorder__c <= 31,"1个月内",
|
IF(Elapsed_day_backorder__c <= 90,"3个月内",
|
IF(Elapsed_day_backorder__c <= 180,"半年内","超过半年"
|
)
|
)
|
)
|
)
|
)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>注残过去天数分类</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Elapsed_day_each_status__c</fullName>
|
<description>6月3日
|
契約書未回収の状態であれば、引合のSFDC最終処理日をみるように変更。変更部分
|
IF( ISBLANK(opportunity__r.SFDCLast_Process_Date__c) , null,
|
IF( ISBLANK(ContractReceivedDate__c) , (today() - opportunity__r.SFDCLast_Process_Date__c),
|
|
|
2/8のレポートダッシュボードデモのために追加。
|
|
if(ISNULL(LastApproveDate__c)
|
,null,LastApproveDate__c -
|
if(AND(ISNULL(ContractReceivedDate__c),ISNULL(FirstApproveDate__c)),null,
|
if(ISNULL(ContractReceivedDate__c),
|
if(ISNULL(FirstApproveDate__c),null,FirstApproveDate__c
|
),ContractReceivedDate__c
|
)
|
)
|
)</description>
|
<externalId>false</externalId>
|
<formula>IF( ISBLANK(Opportunity__r.SFDCLast_Process_Date__c) , null,
|
IF( ISBLANK(ContractReceivedDate__c) , (today() - Opportunity__r.SFDCLast_Process_Date__c),
|
IF( ISBLANK(FirstApproveDate__c) , (today() - ContractReceivedDate__c) ,
|
IF( ISBLANK(LastApproveDate__c) , (today() - FirstApproveDate__c) ,
|
IF( ISBLANK(X30_Deposit_Day__c) , (today() - LastApproveDate__c) ,
|
IF( ISBLANK(Deposit_In_Full_Day__c) , (today() - X30_Deposit_Day__c) ,
|
IF( ISBLANK(DeliveryDate__c) , (today() - Deposit_In_Full_Day__c) , null
|
)
|
)
|
)
|
)
|
)
|
)
|
)</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>EndUser_contract_submit_day__c</fullName>
|
<externalId>false</externalId>
|
<label>预计最终用户合同提交日</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Date</type>
|
</fields>
|
<fields>
|
<fullName>End_User_contract__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(End_User_price__c > 0 || InstallStatus__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>End_User_price__c</fullName>
|
<description>只系统管理员查看(为了判断是否进行最终用户的合同)</description>
|
<externalId>false</externalId>
|
<label>经销商-医院合同金额</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>2</scale>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Currency</type>
|
</fields>
|
<fields>
|
<fullName>Expire__c</fullName>
|
<defaultValue>false</defaultValue>
|
<externalId>false</externalId>
|
<label>过期注残</label>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Checkbox</type>
|
</fields>
|
<fields>
|
<fullName>FALSE_Order__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(mid(ContractNO__c,1,5) = "false","FALSE",
|
|
IF(mid(ContractNO__c,3,2) = "HK",
|
IF(mid(ContractNO__c,6,5) = "FALSE",mid(ContractNO__c,6,5),
|
IF(
|
OR(
|
mid(ContractNO__c,6,2) = "GI",mid(ContractNO__c,6,2) = "ET",mid(ContractNO__c,6,2) = "BF",mid(ContractNO__c,6,2) = "GS"),
|
|
IF(mid(ContractNO__c,9,5)="FALSE","FALSE",""),
|
IF(mid(ContractNO__c,10,5)="FALSE","FALSE","")
|
|
|
)),
|
|
IF(mid(ContractNO__c,4,5) = "FALSE",mid(ContractNO__c,4,5),
|
IF(
|
OR(
|
mid(ContractNO__c,4,2) = "GI",mid(ContractNO__c,4,2) = "ET",mid(ContractNO__c,4,2) = "BF",mid(ContractNO__c,4,2) = "GS"),
|
|
IF(mid(ContractNO__c,7,5)="FALSE","FALSE",""),
|
IF(mid(ContractNO__c,8,5)="FALSE","FALSE","")
|
|
|
))))</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>FALSE订单</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>FALSE_order_text__c</fullName>
|
<externalId>false</externalId>
|
<label>是否FALSE订单(文本)</label>
|
<length>10</length>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>FSE_GI_LeaderID__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(Opportunity__r.OCM_man_province__c !='能量',Opportunity__r.Hospital__r.FSE_GI_Main_Leader__c,null)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>FSE-GI主担当ID</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>FSE_GI_Leader__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(Opportunity__r.OCM_man_province__c !='能量',Opportunity__r.Hospital__r.FSE_GI_Main_Leader__r.Name__c,null)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>FSE-GI主担当</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>FSE_SP_Leader__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(Opportunity__r.OCM_man_province__c !='能量',Opportunity__r.Hospital__r.FSE_SP_Main_Leader__r.Name__c,null)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>FSE-SP主担当</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>FSE_SP_Leader_id__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(Opportunity__r.OCM_man_province__c !='能量',Opportunity__r.Hospital__r.FSE_SP_Main_Leader__c,null)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>FSE-SP主担当ID</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>FalseMinusBackup__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(FALSE_Order__c = 'FALSE', 1, 0) - Backup_order_number__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>False减Backup</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>False__c</fullName>
|
<defaultValue>false</defaultValue>
|
<externalId>false</externalId>
|
<label>未选取(后台用)</label>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Checkbox</type>
|
</fields>
|
<fields>
|
<fullName>FirstApproveDate__c</fullName>
|
<description>订货日</description>
|
<externalId>false</externalId>
|
<label>15.初审日期(订货日)</label>
|
<required>false</required>
|
<trackHistory>true</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Date</type>
|
</fields>
|
<fields>
|
<fullName>First_DeliveryDate__c</fullName>
|
<externalId>false</externalId>
|
<label>第一次发货日</label>
|
<summarizedField>Statu_Achievements_Journal__c.DeliveryDate__c</summarizedField>
|
<summaryFilterItems>
|
<field>Statu_Achievements_Journal__c.ShippedAmount__c</field>
|
<operation>greaterThan</operation>
|
<value>0</value>
|
</summaryFilterItems>
|
<summaryForeignKey>Statu_Achievements_Journal__c.Statu_Achievements__c</summaryForeignKey>
|
<summaryOperation>min</summaryOperation>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Summary</type>
|
</fields>
|
<fields>
|
<fullName>Fiscal_Year_New__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(ISNULL(DeliveryDate__c), null,
|
if((YEAR(DeliveryDate__c)<=2021 && MONTH(DeliveryDate__c)<=3),text(YEAR(DeliveryDate__c)-1868),
|
if((YEAR(DeliveryDate__c)<2021 && MONTH(DeliveryDate__c)>3),text(YEAR(DeliveryDate__c)-1867),
|
if((YEAR(DeliveryDate__c)>=2021 && MONTH(DeliveryDate__c)>3),'FY' & text(YEAR(DeliveryDate__c)+1),'FY' & text(YEAR(DeliveryDate__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>Fiscal_Year__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(ISNULL(DeliveryDate__c), null,
|
IF(MONTH(DeliveryDate__c) <= 3,
|
YEAR(DeliveryDate__c) - 1- 1867,
|
YEAR(DeliveryDate__c) - 1867
|
)
|
)</formula>
|
<label>发货年度(Old)</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>Follow_Cargo_Receipt__c</fullName>
|
<defaultValue>false</defaultValue>
|
<externalId>false</externalId>
|
<label>随货同行单</label>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Checkbox</type>
|
</fields>
|
<fields>
|
<fullName>Follow_up_comment__c</fullName>
|
<description>文本最长256字母</description>
|
<externalId>false</externalId>
|
<label>跟进情况</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>TextArea</type>
|
</fields>
|
<fields>
|
<fullName>ForecastAccuracyObject__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(AND(ET_SP_Consumption__c = false && Text(Opportunity__r.Opp_order_Type__c) != 'ENG') && Opportunity__r.Equipment_Order_Flg__c = false
|
&& Valid_Statu_Achievements__c = 1 && NoForcastTarget__c = false
|
&& TEXT(Opportunity__r.Purchase_Type__c) <> 'SI（手術室案件）'&&!Opportunity__r.Is_Corrosion__c , true, false)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>预测精度对象(注残)</label>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Checkbox</type>
|
</fields>
|
<fields>
|
<fullName>Forecast_Amount_F__c</fullName>
|
<externalId>false</externalId>
|
<formula>/* 有效注残的时候有注残金额，不然当0看 */
|
IF(Opportunity__r.SAP_Send_OK__c && (Opportunity__r.Agency1__r.Special__c || Opportunity__r.Agency2__r.Special__c || Opportunity__r.Account.Parent.Special__c) && $User.ViewSpecialAgencyAmout__c == False, null,
|
IF(Valid_Statu_Achievements__c == 1, UnshippedAmount_F__c, 0)
|
)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>注残金额（含税）</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Currency</type>
|
</fields>
|
<fields>
|
<fullName>Forecast_Amount_without_tax__c</fullName>
|
<externalId>false</externalId>
|
<formula>Case( Opportunity__r.Trade__c,
|
"内貿",Forecast_Amount_F__c / Opportunity__r.Tax_Intra_F_Copy__c,
|
"外貿",Forecast_Amount_F__c * Opportunity__r.Today_Rate__c,0)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>注残金额（不含税）</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Currency</type>
|
</fields>
|
<fields>
|
<fullName>Forecast_Amount_without_tax_forecast__c</fullName>
|
<externalId>false</externalId>
|
<label>预测对象 : 注残金额（不含税）</label>
|
<precision>16</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Currency</type>
|
</fields>
|
<fields>
|
<fullName>Forecast_Collection_Date__c</fullName>
|
<externalId>false</externalId>
|
<label>XX预测全款日</label>
|
<required>false</required>
|
<trackHistory>true</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Date</type>
|
</fields>
|
<fields>
|
<fullName>Forecast_Equal__c</fullName>
|
<defaultValue>false</defaultValue>
|
<description>由验证规则负责更新</description>
|
<externalId>false</externalId>
|
<label>本月预测注残是否一致</label>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Checkbox</type>
|
</fields>
|
<fields>
|
<fullName>Forecast_ship_monthly_mannual__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>Gap_after_complete_stock__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(Stock_arrangement_complete__c < Deposit_In_Full_Day__c,0,
|
Stock_arrangement_complete__c - Deposit_In_Full_Day__c)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>全收款-货期</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Grade__c</fullName>
|
<externalId>false</externalId>
|
<formula>Opportunity__r.Grade__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>Group_purchase_PCL__c</fullName>
|
<externalId>false</externalId>
|
<formula>Opportunity__r.Group_purchase_PCL__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>集中采购课负责的询价</label>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Checkbox</type>
|
</fields>
|
<fields>
|
<fullName>HP_OCM_Category_From_Class__c</fullName>
|
<externalId>false</externalId>
|
<formula>Opportunity__r.HP_OCM_Category_From_Class__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>Hospital_Notarize_Receipt__c</fullName>
|
<defaultValue>false</defaultValue>
|
<externalId>false</externalId>
|
<label>医院确认单</label>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Checkbox</type>
|
</fields>
|
<fields>
|
<fullName>Hospital_link__c</fullName>
|
<externalId>false</externalId>
|
<formula>HYPERLINK(Opportunity__r.Strategic_Department_Class_Id__c, Opp_Hospital__c, Opportunity__r.Strategic_Department_Class_Id__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>If_UploadT1Detailed__c</fullName>
|
<defaultValue>false</defaultValue>
|
<externalId>false</externalId>
|
<label>是否上传T1清单</label>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Checkbox</type>
|
</fields>
|
<fields>
|
<fullName>Inspection_explanation_day__c</fullName>
|
<externalId>false</externalId>
|
<label>23.安装说明确认书收到日</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Date</type>
|
</fields>
|
<fields>
|
<fullName>InstallDate__c</fullName>
|
<externalId>false</externalId>
|
<label>21.安装日期</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Date</type>
|
</fields>
|
<fields>
|
<fullName>InstallStatus__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>Install_Notarize_Book__c</fullName>
|
<defaultValue>false</defaultValue>
|
<externalId>false</externalId>
|
<label>安装确认书</label>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Checkbox</type>
|
</fields>
|
<fields>
|
<fullName>Installation_Day__c</fullName>
|
<externalId>false</externalId>
|
<label>安装日期</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Date</type>
|
</fields>
|
<fields>
|
<fullName>IsEqStatus_Text__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(Status_1__c = Status_1_text__c , true, false)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>状态1文本公式是否一致</label>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Checkbox</type>
|
</fields>
|
<fields>
|
<fullName>Key_imfo_monthly_update__c</fullName>
|
<externalId>false</externalId>
|
<formula>If(Update_situation__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>Key_topic_last_update_date__c</fullName>
|
<externalId>false</externalId>
|
<label>最后更新日-重要字段更新日</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Date</type>
|
</fields>
|
<fields>
|
<fullName>LastApproveDate__c</fullName>
|
<description>有退货Flag的时候，退货判断日</description>
|
<externalId>false</externalId>
|
<label>16.终审日期</label>
|
<required>false</required>
|
<trackHistory>true</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Date</type>
|
</fields>
|
<fields>
|
<fullName>LastDay_of_MonthDelivery__c</fullName>
|
<defaultValue>false</defaultValue>
|
<externalId>false</externalId>
|
<label>最后一天发货</label>
|
<trackHistory>true</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Checkbox</type>
|
</fields>
|
<fields>
|
<fullName>LastMonthly_Forecast_in__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(
|
AND(
|
OR(NOT(ISBLANK(text(Monthly_forecast_shipping__c))),
|
text(Opportunity__r.Forecast_this_month__c) ="本月订发货预测"),
|
NOT(ISBLANK(DeliveryDate__c)),
|
AND(YEAR(DeliveryDate__c)=IF(MONTH(today())=1,YEAR(today())-1,YEAR(today())),MONTH(DeliveryDate__c)=IF(MONTH(today())=1,12,MONTH(today())-1)
|
)
|
),1,0)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>上月预测内发货条数</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>2</scale>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Last_Batch_Day__c</fullName>
|
<externalId>false</externalId>
|
<label>上次batch执行日</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Date</type>
|
</fields>
|
<fields>
|
<fullName>Last_month_forecast_shipping__c</fullName>
|
<externalId>false</externalId>
|
<label>是否上月预测注残</label>
|
<length>200</length>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Last_update_AssignmentStatus__c</fullName>
|
<externalId>false</externalId>
|
<label>最后更新日-分配状态</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Date</type>
|
</fields>
|
<fields>
|
<fullName>Last_update_EndUser_contract_submit_day__c</fullName>
|
<externalId>false</externalId>
|
<label>最后更新日-预计最终用户合同提交日</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Date</type>
|
</fields>
|
<fields>
|
<fullName>Last_update_OverviewStatus__c</fullName>
|
<externalId>false</externalId>
|
<label>最后更新日-总览状态</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Date</type>
|
</fields>
|
<fields>
|
<fullName>Last_update_PaymentStatus__c</fullName>
|
<externalId>false</externalId>
|
<label>最后更新日-付款状态</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Date</type>
|
</fields>
|
<fields>
|
<fullName>Last_update_Payment_All_Scheduled_Date__c</fullName>
|
<externalId>false</externalId>
|
<label>最后更新日-预测100%付款日</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Date</type>
|
</fields>
|
<fields>
|
<fullName>Last_update_Payment_Scheduled_Date__c</fullName>
|
<externalId>false</externalId>
|
<label>最后更新日-预测30%付款日</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Date</type>
|
</fields>
|
<fields>
|
<fullName>Last_update_Reason_not_collect_money__c</fullName>
|
<externalId>false</externalId>
|
<label>最后更新日-未付款原因</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Date</type>
|
</fields>
|
<fields>
|
<fullName>Last_update_Reason_not_ship__c</fullName>
|
<externalId>false</externalId>
|
<label>最后更新日-未发货原因</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Date</type>
|
</fields>
|
<fields>
|
<fullName>Last_update_UnshippedAmount_without_tax__c</fullName>
|
<externalId>false</externalId>
|
<label>最后更新日-未发货金额(不含税)</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Date</type>
|
</fields>
|
<fields>
|
<fullName>Last_update_followup_situation__c</fullName>
|
<externalId>false</externalId>
|
<label>最后更新日-跟进情况</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Date</type>
|
</fields>
|
<fields>
|
<fullName>Last_update_forecast_shipping_date__c</fullName>
|
<externalId>false</externalId>
|
<label>最后更新日-预测发货日</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Date</type>
|
</fields>
|
<fields>
|
<fullName>Last_update_manager_feedback__c</fullName>
|
<externalId>false</externalId>
|
<label>最后更新日-经理反馈</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Date</type>
|
</fields>
|
<fields>
|
<fullName>Last_update_shipping_status__c</fullName>
|
<externalId>false</externalId>
|
<label>最后更新日-发货状态</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Date</type>
|
</fields>
|
<fields>
|
<fullName>Last_week__c</fullName>
|
<externalId>false</externalId>
|
<label>1周前</label>
|
<length>250</length>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Manager_feedback__c</fullName>
|
<externalId>false</externalId>
|
<label>经理反馈</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>TextArea</type>
|
</fields>
|
<fields>
|
<fullName>Monthly3_ship_target__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(AND(
|
OR(DeliveryStatus__c="部分交货",DeliveryStatus__c="未交付",DeliveryStatus__c="部分交付"),
|
OverviewStatus__c <> "无效合同")
|
,True,False)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>预测对象 : 3个月发货预测(公式)</label>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Checkbox</type>
|
</fields>
|
<fields>
|
<fullName>Monthly3_ship_target_formula__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(Monthly3_ship_target__c=TRUE,"3个月内发货预测","")</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>是否3个月预测注残(公式)</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Monthly3_ship_target_text__c</fullName>
|
<externalId>false</externalId>
|
<label>是否3个月预测注残</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Picklist</type>
|
<valueSet>
|
<valueSetDefinition>
|
<sorted>false</sorted>
|
<value>
|
<fullName>3个月内发货预测</fullName>
|
<default>false</default>
|
<label>3个月内发货预测</label>
|
</value>
|
</valueSetDefinition>
|
</valueSet>
|
</fields>
|
<fields>
|
<fullName>Monthly_Forecast_in__c</fullName>
|
<description>2016/7/5以前
|
IF(
|
AND(
|
OR(NOT(ISBLANK(text(Monthly_forecast_shipping__c))),
|
text(Opportunity__r.Forecast_this_month__c) ="本月订发货预测")
|
|
|
,
|
NOT(ISBLANK(DeliveryDate__c))),1,0)</description>
|
<externalId>false</externalId>
|
<formula>IF(
|
AND(
|
OR(NOT(ISBLANK(text(Monthly_forecast_shipping__c))),
|
text(Opportunity__r.Forecast_this_month__c) ="本月订发货预测"),
|
NOT(ISBLANK(DeliveryDate__c)),
|
AND(YEAR(DeliveryDate__c)=YEAR(today()),MONTH(DeliveryDate__c)=MONTH(today())
|
)
|
),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>Monthly_forecast_shipping__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>本月发货预测(可备货)</fullName>
|
<default>false</default>
|
<label>本月发货预测(可备货)</label>
|
</value>
|
</valueSetDefinition>
|
</valueSet>
|
</fields>
|
<fields>
|
<fullName>Monthly_forecast_shipping_formula__c</fullName>
|
<description>**2016/6/3之前
|
IF(Monthly_ship_target_stock__c=TRUE,"本月发货预测(可备货)",
|
IF(Monthly_ship_target__c=TRUE,"本月发货预测",""))
|
**2017/12/5
|
Distributor_InCharge_opp__c = false && Group_purchase_PCL__c = false
|
&& Opportunity__r.ET_SP_Consumption__c = false ====> 预测精度对象(注残) = true</description>
|
<externalId>false</externalId>
|
<formula>IF(Monthly_ship_target__c=TRUE && Status_1_text__c <> '取消' && Status_1_text__c <> '失单'
|
&& ForecastAccuracyObject__c = true,"本月发货预测","")</formula>
|
<label>是否本月预测注残(公式)</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Monthly_ship_target__c</fullName>
|
<description>DATE(YEAR(today()),MONTH(Today())+1,01)-1
|
のところを修正</description>
|
<externalId>false</externalId>
|
<formula>IF(AND(
|
Valid_Statu_Achievements__c = 1,
|
OR(DeliveryStatus__c="部分交货",DeliveryStatus__c="未交付",DeliveryStatus__c="部分交付"),
|
IF(ISBLANK(Shipping_Scheduled_Date__c),
|
Opportunity__r.CloseDate <=
|
IF( MONTH(today()) = 12,
|
DATE(YEAR(today()), 12, 31),
|
DATE(YEAR(today()), MONTH(today()) + 1, 1) - 1
|
)
|
,
|
Shipping_Scheduled_Date__c <=
|
IF( MONTH(today()) = 12,
|
DATE(YEAR(today()), 12, 31),
|
DATE(YEAR(today()), MONTH(today()) + 1, 1) - 1
|
)
|
|
)
|
)
|
,True,False)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>预测对象 : 单月发货预测(公式)</label>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Checkbox</type>
|
</fields>
|
<fields>
|
<fullName>Monthly_ship_target_stock__c</fullName>
|
<description>DATE(YEAR(today()),MONTH(Today())+1,01)-1
|
のところを修正</description>
|
<externalId>false</externalId>
|
<formula>IF(AND(
|
OR(DeliveryStatus__c="部分交货",DeliveryStatus__c="未交付",DeliveryStatus__c="部分交付"),
|
OverviewStatus__c <> "无效合同",
|
|
OR(EndUser_contract_submit_day__c <= IF(
|
MONTH(today()) = 12,
|
DATE(YEAR(today()), 12, 31),
|
DATE(YEAR(today()), MONTH(today()) + 1, 1) - 1
|
),
|
End_User_contract__c = "已提交"),
|
|
OR(Payment_All_Scheduled_Date__c <= IF(
|
MONTH(today()) = 12,
|
DATE(YEAR(today()), 12, 31),
|
DATE(YEAR(today()), MONTH(today()) + 1, 1) - 1
|
),
|
OR(PaymentStatus__c = "100%预付完成",PaymentStatus__c = "不需付款",PaymentStatus__c = "尾款完成")),
|
|
Shipping_Scheduled_Date__c <= IF(
|
MONTH(today()) = 12,
|
DATE(YEAR(today()), 12, 31),
|
DATE(YEAR(today()), MONTH(today()) + 1, 1) - 1
|
)
|
)
|
,True,False)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>预测对象 : 单月发货预测 可备货(公式)</label>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Checkbox</type>
|
</fields>
|
<fields>
|
<fullName>NM_forecast_onemonth_before__c</fullName>
|
<externalId>false</externalId>
|
<label>注残上月预测</label>
|
<length>225</length>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>NM_forecast_shipping__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>
|
</valueSetDefinition>
|
</valueSet>
|
</fields>
|
<fields>
|
<fullName>NM_forecast_shipping_formula__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(NextMonthly_ship_target__c=TRUE && Status_1_text__c <> '取消' && Status_1_text__c <> '失单'
|
&& ForecastAccuracyObject__c = true,"次月发货预测","")</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>是否次月预测注残(公式)</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>NM_forecast_twomonth_before__c</fullName>
|
<externalId>false</externalId>
|
<label>注残上上月预测</label>
|
<length>225</length>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>NOT_PaymentAmount_F__c</fullName>
|
<externalId>false</externalId>
|
<formula>ContractAmount_F__c - PaymentAmount_F__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>OCSM未收款金额</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>2</scale>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Currency</type>
|
</fields>
|
<fields>
|
<fullName>NetWorthNoProviston_DN_A__c</fullName>
|
<externalId>false</externalId>
|
<formula>NetWorthNoProviston_DN__c + AdjustnetWorthNoProviston_DN__c +
|
|
if( ShippedAmount_ZM__c > 0,ContractAmountNoGurantee__c , if(ShippedAmount_ZM__c < 0,- ContractAmountNoGurantee__c,0 ))</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>/已发货金额(不含税,不含计提),</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>2</scale>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>NetWorthNoProviston_DN_F__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(Opportunity__r.SAP_Send_OK__c && (Opportunity__r.Agency1__r.Special__c || Opportunity__r.Agency2__r.Special__c || Opportunity__r.Account.Parent.Special__c) && $User.ViewSpecialAgencyAmout__c == False, null,
|
AdjustnetWorthNoProviston_DN__c + NetWorthNoProviston_DN__c +Case( Opportunity__r.Trade__c,
|
"内貿",ShippedAmount_ZM__c/ Opportunity__r.Tax_Intra_F_Copy__c ,
|
"外貿",ShippedAmount_ZM__c* Opportunity__r.Tax_Foreign_F_Copy__c,
|
ShippedAmount_ZM__c)
|
)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>已发货金额(不含税,不含计提)</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>2</scale>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Currency</type>
|
</fields>
|
<fields>
|
<fullName>NetWorthNoProviston_DN__c</fullName>
|
<externalId>false</externalId>
|
<label>/已发货金额(不含税,不含计提)</label>
|
<summarizedField>Statu_Achievements_DN__c.NetWorthNoProviston__c</summarizedField>
|
<summaryForeignKey>Statu_Achievements_DN__c.Statu_Achievements__c</summaryForeignKey>
|
<summaryOperation>sum</summaryOperation>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Summary</type>
|
</fields>
|
<fields>
|
<fullName>NextMonthly_Forecast_in__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(
|
AND(
|
OR(NOT(ISBLANK(NM_forecast_onemonth_before__c)),
|
CONTAINS(Opportunity__r.NM_Forecast_onemonth_before__c,"发货预测")),
|
NOT(ISBLANK(DeliveryDate__c)),
|
AND(YEAR(DeliveryDate__c)=YEAR(today()),MONTH(DeliveryDate__c)=MONTH(today())
|
)
|
),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>NextMonthly_Forecast_in_thismonth__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(
|
AND(
|
OR(NOT(ISBLANK(NM_forecast_onemonth_before__c)),
|
CONTAINS(Opportunity__r.NM_Forecast_onemonth_before__c,"发货预测")),
|
NOT(ISBLANK(DeliveryDate__c)),
|
AND(YEAR(DeliveryDate__c)=IF(MONTH(today())=1,YEAR(today())-1,YEAR(today())),MONTH(DeliveryDate__c)=IF(MONTH(today())=1,12,MONTH(today())-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>NextMonthly_ship_target__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(AND(
|
Valid_Statu_Achievements__c = 1,
|
OR(DeliveryStatus__c="部分交货",DeliveryStatus__c="未交付",DeliveryStatus__c="部分交付"),
|
IF(ISBLANK(Shipping_Scheduled_Date__c),
|
AND(Opportunity__r.CloseDate > IF(
|
MONTH(today()) = 12,
|
DATE(YEAR(today()), 12, 31),
|
DATE(YEAR(today()), MONTH(today()) + 1, 1) - 1 ),
|
Opportunity__r.CloseDate <= IF(
|
MONTH( today() ) = 11,
|
DATE( YEAR( today() ), 12, 31 ),IF(
|
MONTH( today() ) = 12,
|
DATE( YEAR( today() ) + 1, 01, 31 ),
|
DATE( YEAR( today() ), MONTH ( today() ) + 2, 1 ) - 1 )) )
|
,
|
AND(
|
Shipping_Scheduled_Date__c > IF(
|
MONTH(today()) = 12,
|
DATE(YEAR(today()), 12, 31),
|
DATE(YEAR(today()), MONTH(today()) + 1, 1) - 1 ),
|
Shipping_Scheduled_Date__c <= IF(
|
MONTH( today() ) = 11,
|
DATE( YEAR( today() ), 12, 31 ),IF(
|
MONTH( today() ) = 12,
|
DATE( YEAR( today() ) + 1, 01, 31 ),
|
DATE( YEAR( today() ), MONTH ( today() ) + 2, 1 ) - 1 )))
|
|
)
|
)
|
,True,False)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>预测对象 : 次月发货预测(公式)</label>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Checkbox</type>
|
</fields>
|
<fields>
|
<fullName>NoForcastTarget__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF( RIGHT(ContractNO__c, 2) = '-A' || RIGHT(ContractNO__c, 2) = '-B' || RIGHT(ContractNO__c, 2) = '-C' || RIGHT(ContractNO__c, 2) = '-D' || RIGHT(ContractNO__c, 2) = '-E' || RIGHT(ContractNO__c, 2) = '-F' || RIGHT(ContractNO__c, 2) = '-G' || RIGHT(ContractNO__c, 2) = '-H' || RIGHT(ContractNO__c, 2) = '-I' || RIGHT(ContractNO__c, 2) = '-J' || RIGHT(ContractNO__c, 2) = '-T', true, false)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>NoForcastTarget</label>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Checkbox</type>
|
</fields>
|
<fields>
|
<fullName>Not_allocated_order__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(AssignmentStatus__c="全部分配",0,1)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>货不齐订单数</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Not_collect_money__c</fullName>
|
<externalId>false</externalId>
|
<formula>Case(text( Opportunity__r.Purchase_Type__c),
|
"ET24時間販売",0,
|
IF(Paid_Amount_Rate__c >= 100,0,1))</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>未付全款数</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Not_received_endo_user_contract__c</fullName>
|
<externalId>false</externalId>
|
<formula>Case(text( Opportunity__r.Purchase_Type__c),
|
"ET24時間販売",0,IF(End_User_price__c > 0,0,1))</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>无用户合同数</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Null__c</fullName>
|
<externalId>false</externalId>
|
<label>空值（后台用）</label>
|
<length>5</length>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Number_of_FALSE_order__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(mid(ContractNO__c,1,5) = "false",1,
|
|
IF(mid(ContractNO__c,3,2) = "HK",
|
IF(mid(ContractNO__c,6,5) = "FALSE",1,
|
IF(
|
OR(
|
mid(ContractNO__c,6,2) = "GI",mid(ContractNO__c,6,2) = "ET",mid(ContractNO__c,6,2) = "BF",mid(ContractNO__c,6,2) = "GS"),
|
|
IF(mid(ContractNO__c,9,5)="FALSE",1,0),
|
IF(mid(ContractNO__c,10,5)="FALSE",1,0)
|
|
|
)),
|
|
IF(mid(ContractNO__c,4,5) = "FALSE",1,
|
IF(
|
OR(
|
mid(ContractNO__c,4,2) = "GI",mid(ContractNO__c,4,2) = "ET",mid(ContractNO__c,4,2) = "BF",mid(ContractNO__c,4,2) = "GS"),
|
|
IF(mid(ContractNO__c,7,5)="FALSE",1,0),
|
IF(mid(ContractNO__c,8,5)="FALSE",1,0)
|
|
|
))))</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>FALSE订单数</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Number_of_FALSE_order_text__c</fullName>
|
<externalId>false</externalId>
|
<label>FALSE订单数(文本)</label>
|
<length>20</length>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>OCM_man_province_Snapshot__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF( ISBLANK(OCM_man_province_lastmonth__c) ,OCM_man_province__c,OCM_man_province_lastmonth__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_man_province__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF( Distributor_InCharge_opp__c = TRUE || Group_purchase_PCL__c = TRUE, '经销商管理本部',
|
IF(TEXT(Opportunity__r.Owner.Dept__c) == '能量事业本部','能量',
|
IF(TEXT(Opportunity__r.Owner.Dept__c) == '外科事业本部','外科本部',
|
IF( Opportunity__r.Account.RecordType.Id
|
<> '01210000000QjCN',Opportunity__r.Hospital__r.OCM_man_province_txt__c,
|
Opportunity__r.Account.OCM_man_province_txt__c )
|
)
|
)
|
)</formula>
|
<label>OCSM管理省(预测用)</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>OCM_man_province_cus__c</fullName>
|
<externalId>false</externalId>
|
<formula>Opportunity__r.OCM_man_province_cus__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_man_province_lastmonth__c</fullName>
|
<externalId>false</externalId>
|
<label>OCSM管理省(上月)</label>
|
<length>100</length>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>OCM_man_province_no_dealer__c</fullName>
|
<externalId>false</externalId>
|
<formula>Opportunity__r.OCM_man_province_no_dealer__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_man_province_txt__c</fullName>
|
<description>拷贝公式字段OCM_管理省的值</description>
|
<externalId>false</externalId>
|
<label>OCSM管理省(文本)</label>
|
<length>255</length>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Open_Quotation__c</fullName>
|
<externalId>false</externalId>
|
<formula>HYPERLINK
|
("/00O10000002jviu?pv0=" + Opportunity__r.Id, Opportunity__r.Estimation_No__c, "Rp_" & Opportunity__r.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>OperationDep__c</fullName>
|
<externalId>false</externalId>
|
<formula>CASE(OCM_man_province_txt__c,
|
'大连', '东北二部',
|
'沈阳', '东北二部',
|
'黑龙江', '东北一部',
|
'吉林', '东北一部',
|
'河北', '华北二部',
|
'内蒙古', '华北二部',
|
'天津', '华北二部',
|
'山东', '华北三部',
|
'北京', '华北一部',
|
'福建', '华东二部',
|
'江苏', '华东二部',
|
'江西', '华东二部',
|
'安徽', '华东三部',
|
'浙江', '华东三部',
|
'上海', '华东一部',
|
'河南', '西北二部',
|
'宁夏', '西北二部',
|
'青海', '西北二部',
|
'甘肃', '西北三部',
|
'新疆', '西北三部',
|
'山西', '西北一部',
|
'陕西', '西北一部',
|
'贵州', '西南二部',
|
'云南', '西南二部',
|
'四川/西藏', '西南一部',
|
'重庆', '西南一部',
|
'广东', '华南一部',
|
'广西', '华南二部',
|
'海南', '华南二部',
|
'湖北', '华南三部',
|
'湖南', '华南三部',
|
'经销商管理', '经销商管理',
|
'能量', '能量',
|
'深圳', '华南二部',
|
'')</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>营业部</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>OppPromise_Class__c</fullName>
|
<externalId>false</externalId>
|
<formula>TEXT(Opportunity__r.Promise_Class__c)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>合同分类</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Opp_Amount_Without_Tax__c</fullName>
|
<externalId>false</externalId>
|
<formula>Opportunity__r.Amount_Without_Tax_F__c</formula>
|
<label>OCSM预测成交金额(不含税)</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>2</scale>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Currency</type>
|
</fields>
|
<fields>
|
<fullName>Opp_ClassName__c</fullName>
|
<externalId>false</externalId>
|
<formula>Opportunity__r.Account.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>Opp_Class_Id__c</fullName>
|
<externalId>false</externalId>
|
<formula>Opportunity__r.Account.Id</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>科室Id</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Opp_CloseDate__c</fullName>
|
<externalId>false</externalId>
|
<formula>BlankValue(Shipping_Scheduled_Date__c, Opportunity__r.CloseDate)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>Opp_CloseDate</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Date</type>
|
</fields>
|
<fields>
|
<fullName>Opp_Department_Name__c</fullName>
|
<externalId>false</externalId>
|
<formula>Opportunity__r.Department_Name__c</formula>
|
<label>科室名</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Opp_DeptClass_Id__c</fullName>
|
<externalId>false</externalId>
|
<formula>Opportunity__r.Department_Class__r.Id</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>询价战略科室Id</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Opp_DeptClass__c</fullName>
|
<externalId>false</externalId>
|
<formula>Opportunity__r.Department_Class__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>Opp_Estimation_List_Price__c</fullName>
|
<externalId>false</externalId>
|
<formula>Opportunity__r.Estimation_List_Price_Without_Tax__c</formula>
|
<label>报价总金额(不含税)</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>2</scale>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Currency</type>
|
</fields>
|
<fields>
|
<fullName>Opp_Hospital_Id__c</fullName>
|
<externalId>false</externalId>
|
<formula>Opportunity__r.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>Opp_Hospital__c</fullName>
|
<externalId>false</externalId>
|
<formula>Opportunity__r.HP_Name__c</formula>
|
<label>医院</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Opp_Hospitalo__c</fullName>
|
<externalId>false</externalId>
|
<formula>Opportunity__r.Hospital__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>Opp_Num_Of_Past_Days__c</fullName>
|
<externalId>false</externalId>
|
<formula>TEXT(Opportunity__r.Num_Of_Past_Days__c)</formula>
|
<label>最终跟进过去日期</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Opp_Number_Text__c</fullName>
|
<externalId>false</externalId>
|
<label>询价编码（文本）</label>
|
<length>50</length>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Opp_Number__c</fullName>
|
<externalId>false</externalId>
|
<formula>Opportunity__r.Opportunity_No__c</formula>
|
<label>询价编码</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Opp_OCM__c</fullName>
|
<externalId>false</externalId>
|
<formula>Opportunity__r.OCM__c</formula>
|
<label>OCSM分类</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Opportunity_Category__c</fullName>
|
<externalId>false</externalId>
|
<formula>text(Opportunity__r.Opportunity_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>Opportunity_Name__c</fullName>
|
<externalId>false</externalId>
|
<formula>Opportunity__r.Name</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>Opportunity_Name</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Opportunity_Salesdepartment_SAP__c</fullName>
|
<externalId>false</externalId>
|
<formula>Opportunity__r.Salesdepartment_SAP__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>销售本部(SAP)</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Opportunity__c</fullName>
|
<externalId>false</externalId>
|
<label>询价名称</label>
|
<referenceTo>Opportunity</referenceTo>
|
<relationshipLabel>注残</relationshipLabel>
|
<relationshipName>Status_Opportunity</relationshipName>
|
<relationshipOrder>0</relationshipOrder>
|
<reparentableMasterDetail>false</reparentableMasterDetail>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>MasterDetail</type>
|
<writeRequiresMasterRead>false</writeRequiresMasterRead>
|
</fields>
|
<fields>
|
<fullName>Order_no_without_0__c</fullName>
|
<externalId>false</externalId>
|
<formula>mid(Name,3,10)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>销售凭证号</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Order_number__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>OverviewStatus_SS_IsEqual__c</fullName>
|
<externalId>false</externalId>
|
<formula>OverviewStatus__c = SS_backorderID__r.OverviewStatus__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>OverviewStatus_SS_IsEqual</label>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Checkbox</type>
|
</fields>
|
<fields>
|
<fullName>OverviewStatus__c</fullName>
|
<externalId>false</externalId>
|
<label>总览状态</label>
|
<length>80</length>
|
<required>false</required>
|
<trackHistory>true</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>OwnerId__c</fullName>
|
<externalId>false</externalId>
|
<formula>Opportunity__r.OwnerId</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>Owner_ID__c</fullName>
|
<externalId>false</externalId>
|
<formula>CASESAFEID(Opportunity__r.OwnerId)</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>Owner_Province__c</fullName>
|
<externalId>false</externalId>
|
<formula>Opportunity__r.State_Owner__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_Snapshot__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF( ISBLANK(Owner_lastmonth__c) , Owner__c ,Owner_lastmonth__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__c</fullName>
|
<externalId>false</externalId>
|
<formula>Opportunity__r.Owner_System__r.Alias</formula>
|
<label>所有人</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Owner_lastmonth__c</fullName>
|
<externalId>false</externalId>
|
<label>所有人（上月）</label>
|
<length>100</length>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Pacial_shipment__c</fullName>
|
<externalId>false</externalId>
|
<label>分批发货次数</label>
|
<summaryForeignKey>Statu_Achievements_Journal__c.Statu_Achievements__c</summaryForeignKey>
|
<summaryOperation>count</summaryOperation>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Summary</type>
|
</fields>
|
<fields>
|
<fullName>Paid_Amount_Rate_F__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(Opportunity__r.SAP_Send_OK__c && (Opportunity__r.Agency1__r.Special__c || Opportunity__r.Agency2__r.Special__c || Opportunity__r.Account.Parent.Special__c) && $User.ViewSpecialAgencyAmout__c == False, null,
|
Paid_Amount_Rate__c
|
)</formula>
|
<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>Paid_Amount_Rate__c</fullName>
|
<externalId>false</externalId>
|
<formula>VALUE(LEFT(PaymentRate__c,(LEN(PaymentRate__c)-1) ))</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>/累计付款比率</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>2</scale>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Parcial_ship_link__c</fullName>
|
<externalId>false</externalId>
|
<formula>HYPERLINK("/00O10000003rBBC?pv0=" +Id , DeliveryStatus__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>Past_1month_after_BO__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(Elapsed_day_backorder__c > 90,1,0)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>注残过去天数超过3个月</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Past_day_after_bo__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(ISBLANK(FirstApproveDate__c),NULL,today()-FirstApproveDate__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>PaymentAmount_F__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(Opportunity__r.SAP_Send_OK__c && (Opportunity__r.Agency1__r.Special__c || Opportunity__r.Agency2__r.Special__c || Opportunity__r.Account.Parent.Special__c) && $User.ViewSpecialAgencyAmout__c == False, null,
|
PaymentAmount__c
|
)</formula>
|
<label>OCSM收款金额</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>2</scale>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Currency</type>
|
</fields>
|
<fields>
|
<fullName>PaymentAmount__c</fullName>
|
<externalId>false</externalId>
|
<label>/OCSM收款金额</label>
|
<precision>15</precision>
|
<required>false</required>
|
<scale>2</scale>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Currency</type>
|
</fields>
|
<fields>
|
<fullName>PaymentJudge__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF( ISNULL( Deposit_In_Full_Day__c ) , X30_Deposit_Day__c , Deposit_In_Full_Day__c )</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>月末判断付全款判断条件</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Date</type>
|
</fields>
|
<fields>
|
<fullName>PaymentRate_F__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(Opportunity__r.SAP_Send_OK__c && (Opportunity__r.Agency1__r.Special__c || Opportunity__r.Agency2__r.Special__c || Opportunity__r.Account.Parent.Special__c) && $User.ViewSpecialAgencyAmout__c == False, null,
|
PaymentRate__c
|
)</formula>
|
<label>累计付款比率</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>PaymentRate__c</fullName>
|
<externalId>false</externalId>
|
<label>/累计付款比率IF</label>
|
<length>50</length>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>PaymentStatus_MB__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(ISBLANK(PaymentStatus__c),"确认中",PaymentStatus__c)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>付款状态(MB)</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>PaymentStatus__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>PaymentStatus_for_MB__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(ISBLANK(OverviewStatus__c),"确认中",OverviewStatus__c)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>总览状态(MB)</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>PaymentTerms_F__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(Opportunity__r.SAP_Send_OK__c && (Opportunity__r.Agency1__r.Special__c || Opportunity__r.Agency2__r.Special__c || Opportunity__r.Account.Parent.Special__c) && $User.ViewSpecialAgencyAmout__c == False, null,
|
PaymentTerms__c
|
)</formula>
|
<label>付款条件</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>PaymentTerms__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>Payment_All_Scheduled_Date__c</fullName>
|
<externalId>false</externalId>
|
<label>预测100%付款日</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Date</type>
|
</fields>
|
<fields>
|
<fullName>Payment_Scheduled_Date__c</fullName>
|
<externalId>false</externalId>
|
<label>预测30%付款日</label>
|
<required>false</required>
|
<trackHistory>true</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Date</type>
|
</fields>
|
<fields>
|
<fullName>Payment_contract_OK__c</fullName>
|
<description>IF(
|
AND(
|
OR(PaymentStatus__c="不需付款",PaymentStatus__c="100%预付完成",PaymentStatus__c="尾款完成"),End_User_contract__c="已提交"),1,0)</description>
|
<externalId>false</externalId>
|
<formula>IF(ET_order__c="ET订单",1,
|
IF(AND(
|
OR(PaymentStatus__c="不需付款",PaymentStatus__c="100%预付完成",PaymentStatus__c="尾款完成"),End_User_contract__c="已提交"),1,0))</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>ET订单或付款和最终用户合同已完毕订单数</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>Province_BA__c</fullName>
|
<externalId>false</externalId>
|
<formula>Opportunity__r.Province_BA__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>省(BA)</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Province_BO__c</fullName>
|
<externalId>false</externalId>
|
<formula>Opportunity__r.State__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>Purchase_Type__c</fullName>
|
<externalId>false</externalId>
|
<formula>TEXT(Opportunity__r.Purchase_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>QuotationCode__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>Rating__c</fullName>
|
<externalId>false</externalId>
|
<formula>mid( Status_2_Formula__c ,1,2)& Text( Opportunity__r.Competitor__c )</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>Rating</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Reason_for_uncollect_install_document__c</fullName>
|
<externalId>false</externalId>
|
<inlineHelpText>请输入安装确认书还没回收的原因</inlineHelpText>
|
<label>未回收原因(安装确认书)</label>
|
<length>255</length>
|
<required>false</required>
|
<trackHistory>true</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Reason_not_collect_money__c</fullName>
|
<externalId>false</externalId>
|
<label>未付款原因</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>TextArea</type>
|
</fields>
|
<fields>
|
<fullName>Reason_not_ship__c</fullName>
|
<externalId>false</externalId>
|
<label>未发货原因</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>TextArea</type>
|
</fields>
|
<fields>
|
<fullName>ReturnFlag__c</fullName>
|
<defaultValue>false</defaultValue>
|
<externalId>false</externalId>
|
<label>是否退货</label>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Checkbox</type>
|
</fields>
|
<fields>
|
<fullName>SAP_Transfer_past_day__c</fullName>
|
<externalId>false</externalId>
|
<formula>Today()-Opportunity__r.SFDCLast_Process_Date__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>SAP上传后过去天数</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>SAP_WIN__c</fullName>
|
<externalId>false</externalId>
|
<formula>Opportunity__r.SAP_Send_OK__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>询价SAP上传(WIN) 询价</label>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Checkbox</type>
|
</fields>
|
<fields>
|
<fullName>SS_backorderID__c</fullName>
|
<deleteConstraint>SetNull</deleteConstraint>
|
<externalId>false</externalId>
|
<label>SS_每月3个工作日注残清单</label>
|
<referenceTo>SS_backorder_list__c</referenceTo>
|
<relationshipLabel>注残</relationshipLabel>
|
<relationshipName>N3oS</relationshipName>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Lookup</type>
|
</fields>
|
<fields>
|
<fullName>SaleProvince_SAP__c</fullName>
|
<externalId>false</externalId>
|
<formula>Opportunity__r.SaleProvince_SAP__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>省(SAP业绩)</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>SalesChannel__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>OCM直接販売</fullName>
|
<default>false</default>
|
<label>OCSM直接销售</label>
|
</value>
|
<value>
|
<fullName>販売店</fullName>
|
<default>false</default>
|
<label>販売店</label>
|
</value>
|
</valueSetDefinition>
|
</valueSet>
|
</fields>
|
<fields>
|
<fullName>SalesdepartmentForecast_Snapshot__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF( ISBLANK(SalesdepartmentForecast_lastmonth__c) ,SalesdepartmentForecast__c,SalesdepartmentForecast_lastmonth__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>SalesdepartmentForecast__c</fullName>
|
<externalId>false</externalId>
|
<formula>Opportunity__r.SalesdepartmentForecast__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>SalesdepartmentForecast_lastmonth__c</fullName>
|
<externalId>false</externalId>
|
<label>销售本部（预测上月）</label>
|
<length>100</length>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Salesdepartment_Owner_Snapshot__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF( ISBLANK(Salesdepartment_Owner_lastmonth__c) ,Salesdepartment_Owner__c,Salesdepartment_Owner_lastmonth__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>Salesdepartment_Owner__c</fullName>
|
<externalId>false</externalId>
|
<formula>Opportunity__r.Salesdepartment_Owner_Snapshot__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>Salesdepartment_Owner_lastmonth__c</fullName>
|
<externalId>false</externalId>
|
<label>销售本部（所有人上月）</label>
|
<length>100</length>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Set_Target_DC_wave__c</fullName>
|
<externalId>false</externalId>
|
<formula>Opportunity__r.Account.Parent.Set_Target_DC_wave__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>是否设定客户（战略科室）</label>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Checkbox</type>
|
</fields>
|
<fields>
|
<fullName>ShippedAmount152P_DN__c</fullName>
|
<description>20210426 李旺修改 字段名称和过滤条件</description>
|
<externalId>false</externalId>
|
<label>FY2022发货金额_元（含税）(DN)</label>
|
<summarizedField>Statu_Achievements_DN__c.ShippedAmount__c</summarizedField>
|
<summaryFilterItems>
|
<field>Statu_Achievements_DN__c.Fiscal_Year__c</field>
|
<operation>equals</operation>
|
<value>154</value>
|
</summaryFilterItems>
|
<summaryForeignKey>Statu_Achievements_DN__c.Statu_Achievements__c</summaryForeignKey>
|
<summaryOperation>sum</summaryOperation>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Summary</type>
|
</fields>
|
<fields>
|
<fullName>ShippedAmount153P_DN_A__c</fullName>
|
<externalId>false</externalId>
|
<formula>ShippedAmount152P_DN__c + ShippedAmount_ZM_153P__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>153P发货金额_元（含税）(DN).</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>ShippedAmount_151P_Sum__c</fullName>
|
<externalId>false</externalId>
|
<label>已发货金额(含税)(151P)_Sum</label>
|
<summarizedField>Statu_Achievements_Journal__c.ShippedAmount_Sum__c</summarizedField>
|
<summaryFilterItems>
|
<field>Statu_Achievements_Journal__c.Fiscal_Year__c</field>
|
<operation>equals</operation>
|
<value>151</value>
|
</summaryFilterItems>
|
<summaryForeignKey>Statu_Achievements_Journal__c.Statu_Achievements__c</summaryForeignKey>
|
<summaryOperation>sum</summaryOperation>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Summary</type>
|
</fields>
|
<fields>
|
<fullName>ShippedAmount_152P_SumAndZM__c</fullName>
|
<externalId>false</externalId>
|
<formula>ShippedAmount_152P_Sum__c + ShippedAmount_ZM_153P__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>已发货金额(含税)(153P)_Sum（公式）</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>2</scale>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Currency</type>
|
</fields>
|
<fields>
|
<fullName>ShippedAmount_152P_Sum__c</fullName>
|
<externalId>false</externalId>
|
<label>已发货金额(含税)(153P)_Sum</label>
|
<summarizedField>Statu_Achievements_Journal__c.ShippedAmount_Sum__c</summarizedField>
|
<summaryFilterItems>
|
<field>Statu_Achievements_Journal__c.Fiscal_Year__c</field>
|
<operation>equals</operation>
|
<value>153</value>
|
</summaryFilterItems>
|
<summaryForeignKey>Statu_Achievements_Journal__c.Statu_Achievements__c</summaryForeignKey>
|
<summaryOperation>sum</summaryOperation>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Summary</type>
|
</fields>
|
<fields>
|
<fullName>ShippedAmount_All_Sum__c</fullName>
|
<description>2018/4/19 修改前
|
无条件汇总</description>
|
<externalId>false</externalId>
|
<label>已发货金额(含税)_元_Sum</label>
|
<summarizedField>Statu_Achievements_Journal__c.ShippedAmount_Sum__c</summarizedField>
|
<summaryForeignKey>Statu_Achievements_Journal__c.Statu_Achievements__c</summaryForeignKey>
|
<summaryOperation>sum</summaryOperation>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Summary</type>
|
</fields>
|
<fields>
|
<fullName>ShippedAmount_All__c</fullName>
|
<externalId>false</externalId>
|
<label>已发货金额(含税)_元</label>
|
<summarizedField>Statu_Achievements_Journal__c.ShippedAmount__c</summarizedField>
|
<summaryForeignKey>Statu_Achievements_Journal__c.Statu_Achievements__c</summaryForeignKey>
|
<summaryOperation>sum</summaryOperation>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Summary</type>
|
</fields>
|
<fields>
|
<fullName>ShippedAmount_DN_All__c</fullName>
|
<externalId>false</externalId>
|
<formula>ShippedAmount_DN__c + adjustShippedAmount_DN__c + ShippedAmount_ZM__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>/已发货金额(含税DN).</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>ShippedAmount_DN_F__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(Opportunity__r.SAP_Send_OK__c && (Opportunity__r.Agency1__r.Special__c || Opportunity__r.Agency2__r.Special__c || Opportunity__r.Account.Parent.Special__c) && $User.ViewSpecialAgencyAmout__c == False, null,
|
ShippedAmount_DN__c + ShippedAmount_ZM__c + adjustShippedAmount_DN__c
|
)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>已发货金额(含税DN)</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>2</scale>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Currency</type>
|
</fields>
|
<fields>
|
<fullName>ShippedAmount_DN__c</fullName>
|
<externalId>false</externalId>
|
<label>/已发货金额(含税DN)</label>
|
<summarizedField>Statu_Achievements_DN__c.ShippedAmount__c</summarizedField>
|
<summaryForeignKey>Statu_Achievements_DN__c.Statu_Achievements__c</summaryForeignKey>
|
<summaryOperation>sum</summaryOperation>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Summary</type>
|
</fields>
|
<fields>
|
<fullName>ShippedAmount_F__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(Opportunity__r.SAP_Send_OK__c && (Opportunity__r.Agency1__r.Special__c || Opportunity__r.Agency2__r.Special__c || Opportunity__r.Account.Parent.Special__c) && $User.ViewSpecialAgencyAmout__c == False, null,
|
ShippedAmount_All__c
|
)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>已发货金额(含税)（不使用）</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>2</scale>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Currency</type>
|
</fields>
|
<fields>
|
<fullName>ShippedAmount_SSMonth__c</fullName>
|
<externalId>false</externalId>
|
<formula>ShippedAmount_All__c - SS_backorderID__r.ShippedAmount_All__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>已发货金额(含税)_SSMonth</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>2</scale>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Currency</type>
|
</fields>
|
<fields>
|
<fullName>ShippedAmount_Sum__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(Opportunity__r.SAP_Send_OK__c && (Opportunity__r.Agency1__r.Special__c || Opportunity__r.Agency2__r.Special__c || Opportunity__r.Account.Parent.Special__c) && $User.ViewSpecialAgencyAmout__c == False, null,
|
ShippedAmount_All__c
|
)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>已发货金额(含税)_Sum</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>ShippedAmount_ThisYear_PA_F__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(Opportunity__r.SAP_Send_OK__c && (Opportunity__r.Agency1__r.Special__c || Opportunity__r.Agency2__r.Special__c || Opportunity__r.Account.Parent.Special__c) && $User.ViewSpecialAgencyAmout__c == False, null,
|
ShippedAmount_ThisYear_PA__c
|
)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>已发货金额(含税)(148PA)</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>2</scale>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Currency</type>
|
</fields>
|
<fields>
|
<fullName>ShippedAmount_ThisYear_PA_Sum__c</fullName>
|
<externalId>false</externalId>
|
<label>已发货金额(含税)(148PA)_Sum</label>
|
<summarizedField>Statu_Achievements_Journal__c.ShippedAmount_Sum__c</summarizedField>
|
<summaryFilterItems>
|
<field>Statu_Achievements_Journal__c.Fiscal_Year__c</field>
|
<operation>equals</operation>
|
<value>148</value>
|
</summaryFilterItems>
|
<summaryFilterItems>
|
<field>Statu_Achievements_Journal__c.Fiscal_Half__c</field>
|
<operation>equals</operation>
|
<value>PA</value>
|
</summaryFilterItems>
|
<summaryForeignKey>Statu_Achievements_Journal__c.Statu_Achievements__c</summaryForeignKey>
|
<summaryOperation>min</summaryOperation>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Summary</type>
|
</fields>
|
<fields>
|
<fullName>ShippedAmount_ThisYear_PA__c</fullName>
|
<externalId>false</externalId>
|
<label>已发货金额(含税)(148PA)_元</label>
|
<summarizedField>Statu_Achievements_Journal__c.ShippedAmount__c</summarizedField>
|
<summaryFilterItems>
|
<field>Statu_Achievements_Journal__c.Fiscal_Year__c</field>
|
<operation>equals</operation>
|
<value>148</value>
|
</summaryFilterItems>
|
<summaryFilterItems>
|
<field>Statu_Achievements_Journal__c.Fiscal_Half__c</field>
|
<operation>equals</operation>
|
<value>PA</value>
|
</summaryFilterItems>
|
<summaryForeignKey>Statu_Achievements_Journal__c.Statu_Achievements__c</summaryForeignKey>
|
<summaryOperation>sum</summaryOperation>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Summary</type>
|
</fields>
|
<fields>
|
<fullName>ShippedAmount_ThisYear_PB_F__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(Opportunity__r.SAP_Send_OK__c && (Opportunity__r.Agency1__r.Special__c || Opportunity__r.Agency2__r.Special__c || Opportunity__r.Account.Parent.Special__c) && $User.ViewSpecialAgencyAmout__c == False, null,
|
ShippedAmount_ThisYear_PB__c
|
)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>已发货金额(含税)(148PB)</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>2</scale>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Currency</type>
|
</fields>
|
<fields>
|
<fullName>ShippedAmount_ThisYear_PB_Sum__c</fullName>
|
<externalId>false</externalId>
|
<label>已发货金额(含税)(148PB)_Sum</label>
|
<summarizedField>Statu_Achievements_Journal__c.ShippedAmount_Sum__c</summarizedField>
|
<summaryFilterItems>
|
<field>Statu_Achievements_Journal__c.Fiscal_Year__c</field>
|
<operation>equals</operation>
|
<value>148</value>
|
</summaryFilterItems>
|
<summaryFilterItems>
|
<field>Statu_Achievements_Journal__c.Fiscal_Half__c</field>
|
<operation>equals</operation>
|
<value>PB</value>
|
</summaryFilterItems>
|
<summaryForeignKey>Statu_Achievements_Journal__c.Statu_Achievements__c</summaryForeignKey>
|
<summaryOperation>min</summaryOperation>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Summary</type>
|
</fields>
|
<fields>
|
<fullName>ShippedAmount_ThisYear_PB__c</fullName>
|
<externalId>false</externalId>
|
<label>已发货金额(含税)(148PB)_元</label>
|
<summarizedField>Statu_Achievements_Journal__c.ShippedAmount__c</summarizedField>
|
<summaryFilterItems>
|
<field>Statu_Achievements_Journal__c.Fiscal_Year__c</field>
|
<operation>equals</operation>
|
<value>148</value>
|
</summaryFilterItems>
|
<summaryFilterItems>
|
<field>Statu_Achievements_Journal__c.Fiscal_Half__c</field>
|
<operation>equals</operation>
|
<value>PB</value>
|
</summaryFilterItems>
|
<summaryForeignKey>Statu_Achievements_Journal__c.Statu_Achievements__c</summaryForeignKey>
|
<summaryOperation>sum</summaryOperation>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Summary</type>
|
</fields>
|
<fields>
|
<fullName>ShippedAmount_ThisYear_withoutax_PA_F__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(Opportunity__r.SAP_Send_OK__c && (Opportunity__r.Agency1__r.Special__c || Opportunity__r.Agency2__r.Special__c || Opportunity__r.Account.Parent.Special__c) && $User.ViewSpecialAgencyAmout__c == False, null,
|
ShippedAmount_ThisYear_withoutax_PA__c
|
)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>已发货金额(不含税)(148PA)</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>2</scale>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Currency</type>
|
</fields>
|
<fields>
|
<fullName>ShippedAmount_ThisYear_withoutax_PA__c</fullName>
|
<externalId>false</externalId>
|
<label>已发货金额(不含税)(148PA)_元</label>
|
<summarizedField>Statu_Achievements_Journal__c.ShippedAmount_without_tax__c</summarizedField>
|
<summaryFilterItems>
|
<field>Statu_Achievements_Journal__c.Fiscal_Year__c</field>
|
<operation>equals</operation>
|
<value>150</value>
|
</summaryFilterItems>
|
<summaryFilterItems>
|
<field>Statu_Achievements_Journal__c.Fiscal_Half__c</field>
|
<operation>equals</operation>
|
<value>PA</value>
|
</summaryFilterItems>
|
<summaryForeignKey>Statu_Achievements_Journal__c.Statu_Achievements__c</summaryForeignKey>
|
<summaryOperation>sum</summaryOperation>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Summary</type>
|
</fields>
|
<fields>
|
<fullName>ShippedAmount_ThisYear_withoutax_PB_F__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(Opportunity__r.SAP_Send_OK__c && (Opportunity__r.Agency1__r.Special__c || Opportunity__r.Agency2__r.Special__c || Opportunity__r.Account.Parent.Special__c) && $User.ViewSpecialAgencyAmout__c == False, null,
|
ShippedAmount_ThisYear_withoutax_PB__c
|
)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>已发货金额(不含税)(148PB)</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>2</scale>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Currency</type>
|
</fields>
|
<fields>
|
<fullName>ShippedAmount_ThisYear_withoutax_PB__c</fullName>
|
<externalId>false</externalId>
|
<label>已发货金额(不含税)(148PB)_元</label>
|
<summarizedField>Statu_Achievements_Journal__c.ShippedAmount_without_tax__c</summarizedField>
|
<summaryFilterItems>
|
<field>Statu_Achievements_Journal__c.Fiscal_Year__c</field>
|
<operation>equals</operation>
|
<value>150</value>
|
</summaryFilterItems>
|
<summaryFilterItems>
|
<field>Statu_Achievements_Journal__c.Fiscal_Half__c</field>
|
<operation>equals</operation>
|
<value>PB</value>
|
</summaryFilterItems>
|
<summaryForeignKey>Statu_Achievements_Journal__c.Statu_Achievements__c</summaryForeignKey>
|
<summaryOperation>sum</summaryOperation>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Summary</type>
|
</fields>
|
<fields>
|
<fullName>ShippedAmount_ZM_153P__c</fullName>
|
<description>20210426 李旺修改 字段名称和过滤条件</description>
|
<externalId>false</externalId>
|
<label>发货金额_元（含税）（ZM）（FY2022）</label>
|
<summarizedField>Statu_Achievements_DN__c.ShippedAmount_ZM__c</summarizedField>
|
<summaryFilterItems>
|
<field>Statu_Achievements_DN__c.Fiscal_Year__c</field>
|
<operation>equals</operation>
|
<value>154</value>
|
</summaryFilterItems>
|
<summaryForeignKey>Statu_Achievements_DN__c.Statu_Achievements__c</summaryForeignKey>
|
<summaryOperation>sum</summaryOperation>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Summary</type>
|
</fields>
|
<fields>
|
<fullName>ShippedAmount_ZM_WithoutTax_152P__c</fullName>
|
<description>20210426 李旺修改 字段名称</description>
|
<externalId>false</externalId>
|
<formula>Case( Opportunity__r.Trade__c,
|
"内貿",ShippedAmount_ZM_153P__c/ Opportunity__r.Tax_Intra_F_Copy__c ,
|
"外貿",ShippedAmount_ZM_153P__c* Opportunity__r.Tax_Foreign_F_Copy__c,
|
ShippedAmount_ZM_153P__c)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>发货金额_元（不含税）（ZM）（FY2022）</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>2</scale>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Currency</type>
|
</fields>
|
<fields>
|
<fullName>ShippedAmount_ZM__c</fullName>
|
<externalId>false</externalId>
|
<label>发货金额_元（含税）（ZM）</label>
|
<summarizedField>Statu_Achievements_DN__c.ShippedAmount_ZM__c</summarizedField>
|
<summaryForeignKey>Statu_Achievements_DN__c.Statu_Achievements__c</summaryForeignKey>
|
<summaryOperation>sum</summaryOperation>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Summary</type>
|
</fields>
|
<fields>
|
<fullName>ShippedAmount_without_tax_DN__c</fullName>
|
<description>20210426 李旺修改 字段名称和过滤条件</description>
|
<externalId>false</externalId>
|
<label>FY2022发货金额_元（不含税）(DN)</label>
|
<summarizedField>Statu_Achievements_DN__c.ShippedAmount_without_tax__c</summarizedField>
|
<summaryFilterItems>
|
<field>Statu_Achievements_DN__c.Fiscal_Year__c</field>
|
<operation>equals</operation>
|
<value>154</value>
|
</summaryFilterItems>
|
<summaryForeignKey>Statu_Achievements_DN__c.Statu_Achievements__c</summaryForeignKey>
|
<summaryOperation>sum</summaryOperation>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Summary</type>
|
</fields>
|
<fields>
|
<fullName>ShippedAmount_without_tax_F__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(Opportunity__r.SAP_Send_OK__c && (Opportunity__r.Agency1__r.Special__c || Opportunity__r.Agency2__r.Special__c || Opportunity__r.Account.Parent.Special__c) && $User.ViewSpecialAgencyAmout__c == False, null,
|
ShippedAmount_without_tax__c
|
)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>已发货金额(不含税)</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>2</scale>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Currency</type>
|
</fields>
|
<fields>
|
<fullName>ShippedAmount_without_tax__c</fullName>
|
<externalId>false</externalId>
|
<label>已发货金额(不含税)_元</label>
|
<summarizedField>Statu_Achievements_Journal__c.ShippedAmount_without_tax__c</summarizedField>
|
<summaryForeignKey>Statu_Achievements_Journal__c.Statu_Achievements__c</summaryForeignKey>
|
<summaryOperation>sum</summaryOperation>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Summary</type>
|
</fields>
|
<fields>
|
<fullName>Shipping_Scheduled_Date_For_Report__c</fullName>
|
<description>为了避免报表中只显示注残预测发货日在下月月底之前的订单，而不显示没有填写注残预测发货日的记录，设定此字段</description>
|
<externalId>false</externalId>
|
<formula>IF(isnull(Shipping_Scheduled_Date__c),Opportunity__r.CloseDate,Shipping_Scheduled_Date__c)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>报表用注残预测发货日</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Date</type>
|
</fields>
|
<fields>
|
<fullName>Shipping_Scheduled_Date__c</fullName>
|
<externalId>false</externalId>
|
<label>注残预测发货日</label>
|
<required>false</required>
|
<trackHistory>true</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Date</type>
|
</fields>
|
<fields>
|
<fullName>SoLatestDeliveryDate__c</fullName>
|
<externalId>false</externalId>
|
<label>19.预测最晚交货期</label>
|
<required>false</required>
|
<trackHistory>true</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Date</type>
|
</fields>
|
<fields>
|
<fullName>SpecialApplyMemo__c</fullName>
|
<externalId>false</externalId>
|
<label>特殊对应栏</label>
|
<length>255</length>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>SpecialApply__c</fullName>
|
<deleteConstraint>SetNull</deleteConstraint>
|
<externalId>false</externalId>
|
<label>最新特殊对应</label>
|
<referenceTo>OpportunitySpecialApply__c</referenceTo>
|
<relationshipLabel>注残</relationshipLabel>
|
<relationshipName>SpecialApplyNew1</relationshipName>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Lookup</type>
|
</fields>
|
<fields>
|
<fullName>Special_Apply_Content__c</fullName>
|
<externalId>false</externalId>
|
<label>最新特殊对应-本月申请</label>
|
<length>255</length>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Special_Apply_Reason__c</fullName>
|
<externalId>false</externalId>
|
<label>最新特殊对应-理由</label>
|
<length>255</length>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Special_Approval_Date__c</fullName>
|
<externalId>false</externalId>
|
<label>最新特殊对应-批准日</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Date</type>
|
</fields>
|
<fields>
|
<fullName>Special_NMApply_Content__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>StageName__c</fullName>
|
<externalId>false</externalId>
|
<formula>Opportunity__r.StageName__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>询价状态1</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>State_Owner_Snapshot__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF( ISBLANK(State_Owner_lastmonth__c) ,State_Owner__c,State_Owner_lastmonth__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>State_Owner__c</fullName>
|
<externalId>false</externalId>
|
<formula>Opportunity__r.State_Owner__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>State_Owner_lastmonth__c</fullName>
|
<externalId>false</externalId>
|
<label>OCSM管理省(所有人上月)</label>
|
<length>100</length>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Statu_AchievementsDelForecastMonth__c</fullName>
|
<externalId>false</externalId>
|
<formula>MONTH(Shipping_Scheduled_Date_For_Report__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>Statu_Achievements_Ext__c</fullName>
|
<caseSensitive>true</caseSensitive>
|
<externalId>true</externalId>
|
<label>询价号+销售凭证号</label>
|
<length>255</length>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>true</unique>
|
</fields>
|
<fields>
|
<fullName>Statu_effective__c</fullName>
|
<externalId>false</externalId>
|
<label>最新发货日汇总对象</label>
|
<precision>1</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Statu_effective_formula__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(
|
OR(
|
ET_SP_Consumption__c = true , Text(Opportunity__r.Opp_order_Type__c) = 'ENG'
|
,ForecastAccuracyObject__c, AND( Opportunity__r.RecordType.DeveloperName = 'SI_Oppor' ,
|
!CONTAINS(ContractNO__c, '-A')
|
)
|
),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>Status_1__c</fullName>
|
<externalId>false</externalId>
|
<formula>CASE(OverviewStatus__c,
|
'无效合同', '无效',
|
'冻结', '冻结',
|
IF(ReturnFlag__c,
|
IF(Not(OR(ISNULL(LastApproveDate__c), LastApproveDate__c = DATEVALUE('1900-1-1'))), '退货',
|
'冻结'
|
),
|
IF(OverviewStatus__c = '订单完成',
|
"结束",
|
IF(Not(OR(ISNULL( InstallDate__c ), InstallDate__c = DATEVALUE('1900-1-1'))),
|
"发货",
|
IF(Not(OR(ISNULL( DeliveryDate__c ), DeliveryDate__c = DATEVALUE('1900-1-1'))),
|
"发货",
|
CASE(Opportunity__r.StageName,
|
"引合", IF(Not(OR(ISNULL( FirstApproveDate__c ), FirstApproveDate__c = DATEVALUE('1900-1-1'))),
|
"注残",
|
"询价"
|
),
|
"注残","注残",
|
"出荷","发货",
|
"完了","完毕",
|
"削除","取消",
|
"敗戦","失单",
|
Text(Opportunity__r.StageName)
|
)
|
))))
|
)</formula>
|
<label>注残状态1</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Status_1_text__c</fullName>
|
<externalId>false</externalId>
|
<label>注残状态1(文本)</label>
|
<length>255</length>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Status_2_Formula__c</fullName>
|
<description>15 已安装/修改到已部分安装
|
IF(Not(OR(ISNULL(Collection_Day_Invoice__c), Collection_Day_Invoice__c = DATEVALUE('1900-1-1'))) ,"15 已部分安装",</description>
|
<externalId>false</externalId>
|
<formula>CASE(OverviewStatus__c,
|
'无效合同', '无效',
|
'冻结', '冻结',
|
IF(ReturnFlag__c,
|
IF(Not(OR(ISNULL(LastApproveDate__c), LastApproveDate__c = DATEVALUE('1900-1-1'))), '退货',
|
'冻结'
|
),
|
IF(OverviewStatus__c = '订单完成',
|
"16 已结束",
|
IF(Not(OR(ISNULL(Collection_Day_Invoice__c), Collection_Day_Invoice__c = DATEVALUE('1900-1-1'))) ,"15 已部分安装",
|
(IF(Not(OR(ISNULL( InstallDate__c ), InstallDate__c = DATEVALUE('1900-1-1'))) ,"15 已安装",
|
(IF(Not(OR(ISNULL( DeliveryDate__c ), DeliveryDate__c = DATEVALUE('1900-1-1'))) ,"14 已发货",
|
(IF(Not(OR(ISNULL( SoLatestDeliveryDate__c ), SoLatestDeliveryDate__c = DATEVALUE('1900-1-1'))) ,"13 待发货",
|
(IF(Not(OR(ISNULL( Deposit_In_Full_Day__c ), Deposit_In_Full_Day__c = DATEVALUE('1900-1-1'))) ,"12 已订货・付全款",
|
(IF(Not(OR(ISNULL( X30_Deposit_Day__c ), X30_Deposit_Day__c = DATEVALUE('1900-1-1'))) ,"11 已订货・付订金",
|
(IF(Not(OR(ISNULL( LastApproveDate__c ), LastApproveDate__c = DATEVALUE('1900-1-1'))) ,"10 库存已预留・未付款",
|
(IF(Not(OR(ISNULL( FirstApproveDate__c ), FirstApproveDate__c = DATEVALUE('1900-1-1'))) ,"09 已录入订单未付款",
|
(IF(Not(OR(ISNULL( ContractReceivedDate__c ), ContractReceivedDate__c = DATEVALUE('1900-1-1'))) ,"09 已录入订单未付款",
|
(IF(Not(OR(ISNULL( Opportunity__r.SAP_Send_OK_Date__c ), DATEVALUE(Opportunity__r.SAP_Send_OK_Date__c) = DATEVALUE('1900-1-1'))) ,"08 已签约",
|
(IF(Not(OR(ISNULL( Opportunity__r.Sales_Shop_Hospital_Contract__c ), Opportunity__r.Sales_Shop_Hospital_Contract__c = DATEVALUE('1900-1-1'))) ,"07 用户已签约",
|
(IF(Not(OR(ISNULL( Opportunity__r.Agency_Contract_Date1__c ), Opportunity__r.Agency_Contract_Date1__c = DATEVALUE('1900-1-1'))) ,"06 用户未签约",
|
(IF(Not(OR(ISNULL( Opportunity__r.Assistant_Applied_Date__c ), Opportunity__r.Assistant_Applied_Date__c = DATEVALUE('1900-1-1'))) ,"05 价格申请中",
|
(IF(Not(OR(ISNULL( Opportunity__r.Closing_Bid_Date__c ), Opportunity__r.Closing_Bid_Date__c = DATEVALUE('1900-1-1'))) ,"04 已中标",
|
(IF(Not(ISNULL( Opportunity__r.Bidding_No__c )) ,"03 已授权",
|
(IF(Not(OR(ISNULL( Opportunity__r.Autholization_Activated_Date__c ), Opportunity__r.Autholization_Activated_Date__c = DATEVALUE('1900-1-1'))) ,"03 已授权",
|
(IF(Not(OR(ISNULL( Opportunity__r.Authorized_Date__c ), Opportunity__r.Authorized_Date__c = DATEVALUE('1900-1-1'))) ,"03 已授权",
|
(IF(Not(OR(ISNULL( Opportunity__r.Last_Follow_Up_Date__c ), Opportunity__r.Last_Follow_Up_Date__c = DATEVALUE('1900-1-1'))) ,"02 跟进中",
|
"00 还没跟进"
|
))
|
))
|
))
|
))
|
))
|
))
|
))
|
))
|
))
|
))
|
))
|
))
|
))
|
))
|
))
|
))
|
))
|
)
|
))
|
)</formula>
|
<label>注残状态2</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Stock_arrangement_complete__c</fullName>
|
<externalId>false</externalId>
|
<label>已货期日</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Date</type>
|
</fields>
|
<fields>
|
<fullName>Stop_donjie_1week_past__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(AND(OverviewStatus__c="冻结",SAP_Transfer_past_day__c >= 7),1,0)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>冻结状态数量(超过一周)</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>2</scale>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Stop_order_number__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(OverviewStatus__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>Task__c</fullName>
|
<externalId>false</externalId>
|
<formula>HYPERLINK("/OFSTaskCreate?subject="+ Name +"&dt=" + Substitute(Text(TODAY()), "-", "/")+"&whatId="+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>Team__c</fullName>
|
<externalId>false</externalId>
|
<formula>Opportunity__r.Owner.Group__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>TimeLimit__c</fullName>
|
<description>I/Fで登録されるが使用しない。</description>
|
<externalId>false</externalId>
|
<label>预测全款日(IF)</label>
|
<required>false</required>
|
<trackHistory>true</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Date</type>
|
</fields>
|
<fields>
|
<fullName>Today__c</fullName>
|
<externalId>false</externalId>
|
<formula>DATE(2016,12,23)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>今天</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Date</type>
|
</fields>
|
<fields>
|
<fullName>Town__c</fullName>
|
<externalId>false</externalId>
|
<formula>Opportunity__r.Town__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>Uncollect_Money_F__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF ((Opportunity__r.Agency1__r.Special__c || Opportunity__r.Agency2__r.Special__c || Opportunity__r.Account.Parent.Special__c) && $User.ViewSpecialAgencyAmout__c == False, null,
|
Uncollect_Money__c
|
)</formula>
|
<label>欠款</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>2</scale>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Currency</type>
|
</fields>
|
<fields>
|
<fullName>Uncollect_Money__c</fullName>
|
<externalId>false</externalId>
|
<formula>ContractAmount__c - PaymentAmount__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>/欠款</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>2</scale>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Currency</type>
|
</fields>
|
<fields>
|
<fullName>UnshippedAmount_DN_F__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(Opportunity__r.SAP_Send_OK__c && (Opportunity__r.Agency1__r.Special__c || Opportunity__r.Agency2__r.Special__c || Opportunity__r.Account.Parent.Special__c) && $User.ViewSpecialAgencyAmout__c == False, null,
|
UnshippedAmount_DN__c - ABS( ShippedAmount_ZM__c)
|
)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>未发货金额(含税DN)</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>2</scale>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Currency</type>
|
</fields>
|
<fields>
|
<fullName>UnshippedAmount_DN__c</fullName>
|
<externalId>false</externalId>
|
<formula>ContractAmount__c - ABS(ShippedAmount_DN__c)- ABS(adjustShippedAmount_DN__c)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>/未发货金额(含税DN)</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>2</scale>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Currency</type>
|
</fields>
|
<fields>
|
<fullName>UnshippedAmount_F__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(Opportunity__r.SAP_Send_OK__c && (Opportunity__r.Agency1__r.Special__c || Opportunity__r.Agency2__r.Special__c || Opportunity__r.Account.Parent.Special__c) && $User.ViewSpecialAgencyAmout__c == False, null,
|
UnshippedAmount__c
|
)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>未发货金额(含税)（不使用）</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>2</scale>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Currency</type>
|
</fields>
|
<fields>
|
<fullName>UnshippedAmount_Sum__c</fullName>
|
<externalId>false</externalId>
|
<formula>UnshippedAmount__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>未发货金额(含税)_Sum</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>UnshippedAmount__c</fullName>
|
<externalId>false</externalId>
|
<label>未发货金额(含税)_元</label>
|
<precision>15</precision>
|
<required>false</required>
|
<scale>2</scale>
|
<trackHistory>true</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Currency</type>
|
</fields>
|
<fields>
|
<fullName>UnshippedAmount_without_tax_A__c</fullName>
|
<description>20210910 wql SWAG-C6Q5ZJ 【委托】 [询价今年字段]请修改询价页面的今年发货和今年注残金额字段逻辑</description>
|
<externalId>false</externalId>
|
<formula>ContractAmountNoGurantee__c- ABS(NetWorthNoProviston_DN__c)- if(NetWorthNoProviston_DN__c!=0,0,ABS(AdjustnetWorthNoProviston_DN__c)) - if(
|
!isblank(Text(orderType__c)), ContractAmountNoGurantee__c,0)+if(ISBLANK(DeliveryDate__c) ,X153PNetWorthNoProviston_A__c ,0)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>/未发货金额(不含税除计提DN).</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>UnshippedAmount_without_tax_F__c</fullName>
|
<description>最新换币
|
Case( Opportunity__r.Trade__c,
|
"内貿",UnshippedAmount_F__c / 1.17,
|
"外貿",UnshippedAmount_F__c * 6.8,0)</description>
|
<externalId>false</externalId>
|
<formula>Case( Opportunity__r.Trade__c,
|
"内貿",UnshippedAmount_F__c / Opportunity__r.Tax_Intra_F_Copy__c ,
|
"外貿",UnshippedAmount_F__c * Opportunity__r.Tax_Foreign_F_Copy__c,0)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>未发货金额(不含税)</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>2</scale>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>UnshippedAmount_without_tax_Thousand_DN__c</fullName>
|
<externalId>false</externalId>
|
<formula>(ContractAmountNoGurantee__c- ABS(NetWorthNoProviston_DN__c)- ABS(AdjustnetWorthNoProviston_DN__c) - ABS(Case( Opportunity__r.Trade__c,
|
"内貿",ShippedAmount_ZM__c/ Opportunity__r.Tax_Intra_F_Copy__c ,
|
"外貿",ShippedAmount_ZM__c* Opportunity__r.Tax_Foreign_F_Copy__c,
|
ShippedAmount_ZM_153P__c))
|
) * IF( text(Opportunity__r.Trade__c)='内貿',1/ 1000 ,Opportunity__r.Tax_Foreign_F_Copy__c/ 1000)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>注残金额(除计提，千元RMB）</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>2</scale>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>UnshippedAmount_without_tax_Thousand_F__c</fullName>
|
<description>/*0.128205是公司简档中货币中设定的换算率，不会变*/
|
IF( text(Opportunity__r.Trade__c)='内貿',Forecast_Amount_F__c/ 1000 ,Forecast_Amount_F__c*(Opportunity__r.Today_Rate__c/0.128205)/ 1000)
|
20810424
|
IF( text(Opportunity__r.Trade__c)='内貿',UnshippedAmount_F__c/1.17/ 1000 ,UnshippedAmount_F__c*6.8/ 1000)</description>
|
<externalId>false</externalId>
|
<formula>IF( text(Opportunity__r.Trade__c)='内貿',UnshippedAmount_F__c/ Opportunity__r.Tax_Intra_F_Copy__c / 1000 ,UnshippedAmount_F__c*Opportunity__r.Tax_Foreign_F_Copy__c/ 1000)</formula>
|
<label>注残金额（千元RMB，不含税）(不使用）</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>2</scale>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Update_situation__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(
|
text(Year(Created_Day__c)) & text(Month(Created_Day__c)) =
|
text(Year(today())) & text(Month(today())),"本月创建",
|
|
IF(ISBLANK(Key_topic_last_update_date__c),"还没更新",
|
|
IF(
|
text(Year(Key_topic_last_update_date__c)) & text(Month(Key_topic_last_update_date__c)) =
|
text(Year(today())) & text(Month(today())),"本月更新",
|
|
IF(
|
text(Year(Key_topic_last_update_date__c)) & text(Month(Key_topic_last_update_date__c)) =
|
text(Year(today())) & text(Month(today())-1),"上个月更新",
|
|
"最近2个月没更新")
|
|
)
|
)
|
)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>更新情况</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Valid_Statu_Achievements1__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(OR(OverviewStatus__c = '冻结', OverviewStatus__c = '无效合同', Number_of_FALSE_order_text__c = '1'), 0, 1)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>有效注残Flg（含退货）</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>Valid_Statu_Achievements__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(OR(OverviewStatus__c = '冻结', OverviewStatus__c = '无效合同', ReturnFlag__c = True, Number_of_FALSE_order_text__c = '1'), 0, 1)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>有效注残Flg</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>X152PNetWorthNoProviston__c</fullName>
|
<description>20210426 李旺修改 字段名称和过滤条件</description>
|
<externalId>false</externalId>
|
<label>FY2022发货金额_元（不含税不含计提）(DN)</label>
|
<summarizedField>Statu_Achievements_DN__c.NetWorthNoProviston__c</summarizedField>
|
<summaryFilterItems>
|
<field>Statu_Achievements_DN__c.Fiscal_Year__c</field>
|
<operation>equals</operation>
|
<value>154</value>
|
</summaryFilterItems>
|
<summaryForeignKey>Statu_Achievements_DN__c.Statu_Achievements__c</summaryForeignKey>
|
<summaryOperation>sum</summaryOperation>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Summary</type>
|
</fields>
|
<fields>
|
<fullName>X152P_152P_DN__c</fullName>
|
<externalId>false</externalId>
|
<formula>ABS(ContractAmount__c - ABS(ShippedAmount_152P_SumAndZM__c))</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>发货金额 合同金额绝对值差值</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>2</scale>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>X152PshipmentAmount__c</fullName>
|
<externalId>false</externalId>
|
<formula>ABS(ShippedAmount_152P_Sum__c - ShippedAmount152P_DN__c)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>152P发货金额绝对值差值</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>X153PNetWorthNoProviston_A__c</fullName>
|
<externalId>false</externalId>
|
<formula>X152PNetWorthNoProviston__c +
|
if( ShippedAmount_ZM_153P__c > 0,ContractAmountNoGurantee__c , if(ShippedAmount_ZM_153P__c < 0,- ContractAmountNoGurantee__c,0 ))</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>153P发货金额_元（不含税不含计提）(DN).</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>X24_FollowCargoReceipt_Data__c</fullName>
|
<externalId>false</externalId>
|
<label>24.随货通行单回收日</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Date</type>
|
</fields>
|
<fields>
|
<fullName>X25_HospitalNotarizeReceipt_Data__c</fullName>
|
<externalId>false</externalId>
|
<label>25.医院签收单回收日</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Date</type>
|
</fields>
|
<fields>
|
<fullName>X26_InstallNotarizeReceipt_Data__c</fullName>
|
<externalId>false</externalId>
|
<label>26.安装确认书回收日</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Date</type>
|
</fields>
|
<fields>
|
<fullName>X2weeks_ago__c</fullName>
|
<externalId>false</externalId>
|
<label>2周前</label>
|
<length>250</length>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>X30_Deposit_Day__c</fullName>
|
<externalId>false</externalId>
|
<label>17.预付款日期</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Date</type>
|
</fields>
|
<fields>
|
<fullName>X3Weeks_ago__c</fullName>
|
<externalId>false</externalId>
|
<label>3周前</label>
|
<length>250</length>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>X4weeks_ago__c</fullName>
|
<externalId>false</externalId>
|
<label>4周前</label>
|
<length>250</length>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>X5weeks_ago__c</fullName>
|
<externalId>false</externalId>
|
<label>5周前</label>
|
<length>250</length>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>adjustShippedAmount_DN__c</fullName>
|
<externalId>false</externalId>
|
<label>调整已发货金额(含税DN)</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>2</scale>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Currency</type>
|
</fields>
|
<fields>
|
<fullName>in_wave__c</fullName>
|
<externalId>false</externalId>
|
<formula>"in"</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>in_wave</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>isManualApprove__c</fullName>
|
<defaultValue>false</defaultValue>
|
<externalId>false</externalId>
|
<label>是否手动创建特殊对应对象审批</label>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Checkbox</type>
|
</fields>
|
<fields>
|
<fullName>orderType__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>ZM17</fullName>
|
<default>false</default>
|
<label>ZM17</label>
|
</value>
|
<value>
|
<fullName>ZM18</fullName>
|
<default>false</default>
|
<label>ZM18</label>
|
</value>
|
<value>
|
<fullName>ZM16</fullName>
|
<default>false</default>
|
<label>ZM16</label>
|
</value>
|
</valueSetDefinition>
|
</valueSet>
|
</fields>
|
<fields>
|
<fullName>plan__c</fullName>
|
<externalId>false</externalId>
|
<formula>HYPERLINK("/apex/OFSCalendar?sub="+ Opportunity__r.Account.Name +"&accid="+ Opportunity__r.AccountId +"&oid="+ Opportunity__r.ID_18__c +"&wv=1&w=90&h=90", "■")</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>+计划</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>test11__c</fullName>
|
<externalId>false</externalId>
|
<formula>if(abs(abs(ContractAmountNoGurantee__c) - abs(NetWorthNoProviston_DN__c)) > 1, true,false)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>test11</label>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Checkbox</type>
|
</fields>
|
<fields>
|
<fullName>test__c</fullName>
|
<externalId>false</externalId>
|
<label>test</label>
|
<summaryForeignKey>Statu_Achievements_DN__c.Statu_Achievements__c</summaryForeignKey>
|
<summaryOperation>count</summaryOperation>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Summary</type>
|
</fields>
|
<label>注残</label>
|
<listViews>
|
<fullName>All_Backorder_FirstApprovalunship</fullName>
|
<columns>NAME</columns>
|
<columns>ContractNO__c</columns>
|
<columns>Opp_Hospital__c</columns>
|
<columns>Opp_Department_Name__c</columns>
|
<columns>Current_status__c</columns>
|
<columns>ContractAmount_without_tax__c</columns>
|
<columns>UnshippedAmount_without_tax_F__c</columns>
|
<columns>Agency1_Name_F__c</columns>
|
<columns>PaymentRate_F__c</columns>
|
<columns>PaymentStatus__c</columns>
|
<columns>End_User_contract__c</columns>
|
<columns>SoLatestDeliveryDate__c</columns>
|
<columns>Shipping_Scheduled_Date__c</columns>
|
<columns>Payment_Scheduled_Date__c</columns>
|
<columns>Payment_All_Scheduled_Date__c</columns>
|
<filterScope>Everything</filterScope>
|
<filters>
|
<field>Status_1__c</field>
|
<operation>notEqual</operation>
|
<value>结束,取消</value>
|
</filters>
|
<filters>
|
<field>DeliveryStatus__c</field>
|
<operation>notEqual</operation>
|
<value>已完全交付</value>
|
</filters>
|
<filters>
|
<field>Status_2_Formula__c</field>
|
<operation>notEqual</operation>
|
<value>无效,退货,冻结</value>
|
</filters>
|
<label>01. 注残-未完成发货(更新预测用)</label>
|
<language>ja</language>
|
<sharedTo>
|
<group>Assistant_Huadong</group>
|
<group>Assistant_Xibei</group>
|
<group>X00_Assistant_N</group>
|
<group>X00_Assistant_NE</group>
|
<group>X00_Assistant_S</group>
|
<group>X00_Assistant_SW</group>
|
<group>X3_sales_Prospect_assistant</group>
|
</sharedTo>
|
</listViews>
|
<listViews>
|
<fullName>All_Backorder_FirstApprovalunship1</fullName>
|
<booleanFilter>1 AND 2 AND 3 AND (4 OR 5) AND 6</booleanFilter>
|
<columns>NAME</columns>
|
<columns>Opp_Hospital__c</columns>
|
<columns>Opp_Department_Name__c</columns>
|
<columns>Current_status__c</columns>
|
<columns>PaymentRate_F__c</columns>
|
<columns>End_User_contract__c</columns>
|
<columns>SoLatestDeliveryDate__c</columns>
|
<columns>Shipping_Scheduled_Date__c</columns>
|
<columns>Opp_Number__c</columns>
|
<columns>Agency1_Name_F__c</columns>
|
<filterScope>Everything</filterScope>
|
<filters>
|
<field>Status_1__c</field>
|
<operation>notEqual</operation>
|
<value>结束,取消</value>
|
</filters>
|
<filters>
|
<field>DeliveryStatus__c</field>
|
<operation>notEqual</operation>
|
<value>已完全交付</value>
|
</filters>
|
<filters>
|
<field>Status_2_Formula__c</field>
|
<operation>notEqual</operation>
|
<value>无效,退货,冻结</value>
|
</filters>
|
<filters>
|
<field>Shipping_Scheduled_Date__c</field>
|
<operation>equals</operation>
|
</filters>
|
<filters>
|
<field>Shipping_Scheduled_Date__c</field>
|
<operation>lessThan</operation>
|
<value>TODAY</value>
|
</filters>
|
<filters>
|
<field>Status_1__c</field>
|
<operation>equals</operation>
|
<value>注残</value>
|
</filters>
|
<label>01-1. 需要更新预测发货日(助理更新用)</label>
|
<language>ja</language>
|
</listViews>
|
<listViews>
|
<fullName>All_Backorder_FirstApprovalunshipAGENT</fullName>
|
<columns>NAME</columns>
|
<columns>Opp_Hospital__c</columns>
|
<columns>Opp_Department_Name__c</columns>
|
<columns>Agency1_Name_F__c</columns>
|
<columns>Current_status__c</columns>
|
<columns>SoLatestDeliveryDate__c</columns>
|
<columns>Shipping_Scheduled_Date__c</columns>
|
<columns>Payment_Scheduled_Date__c</columns>
|
<columns>Payment_All_Scheduled_Date__c</columns>
|
<columns>EndUser_contract_submit_day__c</columns>
|
<filterScope>Everything</filterScope>
|
<filters>
|
<field>Status_1__c</field>
|
<operation>equals</operation>
|
<value>注残</value>
|
</filters>
|
<filters>
|
<field>OverviewStatus__c</field>
|
<operation>notContain</operation>
|
<value>完毕</value>
|
</filters>
|
<filters>
|
<field>Distributor_InCharge_opp__c</field>
|
<operation>equals</operation>
|
<value>1</value>
|
</filters>
|
<label>70. 注残-未发货 经销商管理课</label>
|
<language>ja</language>
|
<sharedTo>
|
<group>Te2am_member</group>
|
<group>X9_Agent_management</group>
|
</sharedTo>
|
</listViews>
|
<listViews>
|
<fullName>All_Backorder_FirstApprovalunshipJIZHONG</fullName>
|
<columns>NAME</columns>
|
<columns>Opp_Hospital__c</columns>
|
<columns>Opp_Department_Name__c</columns>
|
<columns>Agency1_Name_F__c</columns>
|
<columns>Current_status__c</columns>
|
<columns>SoLatestDeliveryDate__c</columns>
|
<columns>Shipping_Scheduled_Date__c</columns>
|
<columns>Payment_Scheduled_Date__c</columns>
|
<columns>Payment_All_Scheduled_Date__c</columns>
|
<columns>EndUser_contract_submit_day__c</columns>
|
<filterScope>Everything</filterScope>
|
<filters>
|
<field>Status_1__c</field>
|
<operation>equals</operation>
|
<value>注残</value>
|
</filters>
|
<filters>
|
<field>OverviewStatus__c</field>
|
<operation>notContain</operation>
|
<value>完毕</value>
|
</filters>
|
<filters>
|
<field>Group_purchase_PCL__c</field>
|
<operation>equals</operation>
|
<value>1</value>
|
</filters>
|
<label>70. 注残-未发货 集中采购课</label>
|
<language>ja</language>
|
<sharedTo>
|
<group>Te2am_member</group>
|
<group>X9_Agent_management</group>
|
</sharedTo>
|
</listViews>
|
<listViews>
|
<fullName>All_Backorder_FirstApprovalunshipTHISMONTH</fullName>
|
<booleanFilter>1 AND 2 AND 3 AND 4 AND 5 AND 6</booleanFilter>
|
<columns>NAME</columns>
|
<columns>Opp_Hospital__c</columns>
|
<columns>Current_status__c</columns>
|
<columns>Shipping_Scheduled_Date__c</columns>
|
<columns>X30_Deposit_Day__c</columns>
|
<columns>Deposit_In_Full_Day__c</columns>
|
<columns>DeliveryDate__c</columns>
|
<columns>SoLatestDeliveryDate__c</columns>
|
<filterScope>Everything</filterScope>
|
<filters>
|
<field>Status_1__c</field>
|
<operation>notEqual</operation>
|
<value>结束,取消</value>
|
</filters>
|
<filters>
|
<field>DeliveryStatus__c</field>
|
<operation>notEqual</operation>
|
<value>已完全交付</value>
|
</filters>
|
<filters>
|
<field>Status_2_Formula__c</field>
|
<operation>notEqual</operation>
|
<value>无效,退货,冻结</value>
|
</filters>
|
<filters>
|
<field>Monthly_forecast_shipping__c</field>
|
<operation>equals</operation>
|
<value>本月发货预测,本月发货预测(可备货)</value>
|
</filters>
|
<filters>
|
<field>PaymentStatus__c</field>
|
<operation>contains</operation>
|
<value>尾款,全款</value>
|
</filters>
|
<filters>
|
<field>CREATED_DATE</field>
|
<operation>lessThan</operation>
|
<value>THIS_MONTH</value>
|
</filters>
|
<label>01. 注残-本月预测已付款确认交期</label>
|
<language>ja</language>
|
<sharedTo>
|
<group>Assistant_Huadong</group>
|
<group>Assistant_Xibei</group>
|
<group>X00_Assistant_N</group>
|
<group>X00_Assistant_NE</group>
|
<group>X00_Assistant_S</group>
|
<group>X00_Assistant_SW</group>
|
<group>X3_sales_Prospect_assistant</group>
|
</sharedTo>
|
</listViews>
|
<listViews>
|
<fullName>All_Backorder_OrderCompleted</fullName>
|
<columns>NAME</columns>
|
<columns>Opp_Hospital__c</columns>
|
<columns>Opp_Department_Name__c</columns>
|
<columns>Opportunity__c</columns>
|
<columns>Agency1_Name_F__c</columns>
|
<columns>DeliveryDate__c</columns>
|
<columns>ContractAmount_F__c</columns>
|
<columns>Owner__c</columns>
|
<filterScope>Everything</filterScope>
|
<filters>
|
<field>Status_1__c</field>
|
<operation>contains</operation>
|
<value>完成,结束,完毕</value>
|
</filters>
|
<label>03. 注残-订单完成</label>
|
<language>ja</language>
|
</listViews>
|
<listViews>
|
<fullName>All_Backorder_stop</fullName>
|
<columns>Opp_Number__c</columns>
|
<columns>NAME</columns>
|
<columns>Opportunity__c</columns>
|
<columns>Opp_Hospital__c</columns>
|
<columns>Opp_Department_Name__c</columns>
|
<columns>SAP_Transfer_past_day__c</columns>
|
<columns>Agency1_Name_F__c</columns>
|
<columns>Owner__c</columns>
|
<filterScope>Everything</filterScope>
|
<filters>
|
<field>OverviewStatus__c</field>
|
<operation>equals</operation>
|
<value>冻结</value>
|
</filters>
|
<label>00. 注残-冻结(确认合同)</label>
|
<language>ja</language>
|
<sharedTo>
|
<group>X3_sales_Prospect_assistant</group>
|
</sharedTo>
|
</listViews>
|
<listViews>
|
<fullName>All_ShipwithoutanzhuaAAAA</fullName>
|
<columns>NAME</columns>
|
<columns>Opp_Hospital__c</columns>
|
<columns>Opp_Department_Name__c</columns>
|
<columns>DeliveryDate__c</columns>
|
<columns>ContractNO_link__c</columns>
|
<columns>InstallStatus__c</columns>
|
<filterScope>Everything</filterScope>
|
<filters>
|
<field>Status_1__c</field>
|
<operation>equals</operation>
|
<value>发货</value>
|
</filters>
|
<filters>
|
<field>InstallDate__c</field>
|
<operation>equals</operation>
|
</filters>
|
<filters>
|
<field>InstallStatus__c</field>
|
<operation>equals</operation>
|
</filters>
|
<label>Confirm：安装状态空</label>
|
<language>ja</language>
|
</listViews>
|
<listViews>
|
<fullName>All_Shipwithoutanzhuangbaogao</fullName>
|
<columns>ContractNO_link__c</columns>
|
<columns>Opp_Hospital__c</columns>
|
<columns>Opp_Department_Name__c</columns>
|
<columns>Agency1_Name_F__c</columns>
|
<columns>DeliveryDate__c</columns>
|
<columns>Elapesd_day_after_ship__c</columns>
|
<columns>Delivery_Scheduled_Date__c</columns>
|
<columns>Actual_Installation_Day__c</columns>
|
<columns>Reason_for_uncollect_install_document__c</columns>
|
<columns>FSE_GI_Leader__c</columns>
|
<columns>FSE_SP_Leader__c</columns>
|
<filterScope>Everything</filterScope>
|
<filters>
|
<field>Status_1__c</field>
|
<operation>equals</operation>
|
<value>发货</value>
|
</filters>
|
<filters>
|
<field>InstallDate__c</field>
|
<operation>equals</operation>
|
</filters>
|
<filters>
|
<field>InstallStatus__c</field>
|
<operation>notContain</operation>
|
<value>不安装</value>
|
</filters>
|
<filters>
|
<field>ET_SP_Consumption__c</field>
|
<operation>equals</operation>
|
<value>0</value>
|
</filters>
|
<label>02-1.已发货未安装</label>
|
<language>ja</language>
|
</listViews>
|
<listViews>
|
<fullName>All_Shipwithoutpay</fullName>
|
<columns>NAME</columns>
|
<columns>ContractNO__c</columns>
|
<columns>Opp_Hospital__c</columns>
|
<columns>Opp_Department_Name__c</columns>
|
<columns>DeliveryDate__c</columns>
|
<columns>Agency1_Name_F__c</columns>
|
<columns>ContractAmount_F__c</columns>
|
<columns>Uncollect_Money__c</columns>
|
<columns>Payment_Scheduled_Date__c</columns>
|
<columns>Payment_All_Scheduled_Date__c</columns>
|
<columns>Follow_up_comment__c</columns>
|
<columns>Owner__c</columns>
|
<columns>InstallDate__c</columns>
|
<filterScope>Everything</filterScope>
|
<filters>
|
<field>Status_1__c</field>
|
<operation>contains</operation>
|
<value>发货</value>
|
</filters>
|
<filters>
|
<field>Uncollect_Money__c</field>
|
<operation>greaterThan</operation>
|
<value>CNY 1</value>
|
</filters>
|
<filters>
|
<field>PaymentStatus__c</field>
|
<operation>notContain</operation>
|
<value>不需付款</value>
|
</filters>
|
<label>02-2. 已发货未收款</label>
|
<language>ja</language>
|
</listViews>
|
<nameField>
|
<label>凭证号码</label>
|
<trackHistory>true</trackHistory>
|
<type>Text</type>
|
</nameField>
|
<searchLayouts>
|
<customTabListAdditionalFields>ContractNO__c</customTabListAdditionalFields>
|
<customTabListAdditionalFields>Status_1__c</customTabListAdditionalFields>
|
<customTabListAdditionalFields>Status_2_Formula__c</customTabListAdditionalFields>
|
<customTabListAdditionalFields>OverviewStatus__c</customTabListAdditionalFields>
|
<customTabListAdditionalFields>Opp_Hospital__c</customTabListAdditionalFields>
|
<customTabListAdditionalFields>ContractAmount__c</customTabListAdditionalFields>
|
<customTabListAdditionalFields>PaymentAmount__c</customTabListAdditionalFields>
|
<customTabListAdditionalFields>TimeLimit__c</customTabListAdditionalFields>
|
<customTabListAdditionalFields>Opportunity__c</customTabListAdditionalFields>
|
<lookupDialogsAdditionalFields>ContractNO__c</lookupDialogsAdditionalFields>
|
<searchResultsAdditionalFields>ContractNO__c</searchResultsAdditionalFields>
|
<searchResultsAdditionalFields>Status_1__c</searchResultsAdditionalFields>
|
<searchResultsAdditionalFields>Status_2_Formula__c</searchResultsAdditionalFields>
|
<searchResultsAdditionalFields>OverviewStatus__c</searchResultsAdditionalFields>
|
<searchResultsAdditionalFields>Opp_Hospital__c</searchResultsAdditionalFields>
|
<searchResultsAdditionalFields>Opportunity__c</searchResultsAdditionalFields>
|
<searchResultsAdditionalFields>DeliveryDate__c</searchResultsAdditionalFields>
|
</searchLayouts>
|
<sharingModel>ControlledByParent</sharingModel>
|
<validationRules>
|
<fullName>ShippingScheduleDateNeedGreatethantoday</fullName>
|
<active>true</active>
|
<description>预测发货日修改时要大于今日</description>
|
<errorConditionFormula>ISCHANGED(Shipping_Scheduled_Date__c) &&
|
NOT(ISBLANK(Shipping_Scheduled_Date__c)) &&
|
Shipping_Scheduled_Date__c <= TODAY()</errorConditionFormula>
|
<errorDisplayField>Shipping_Scheduled_Date__c</errorDisplayField>
|
<errorMessage>预测发货日修改时要大于今日</errorMessage>
|
</validationRules>
|
<visibility>Public</visibility>
|
</CustomObject>
|
