<?xml version="1.0" encoding="UTF-8"?>
|
<CustomObject xmlns="http://soap.sforce.com/2006/04/metadata">
|
<actionOverrides>
|
<actionName>Accept</actionName>
|
<type>Default</type>
|
</actionOverrides>
|
<actionOverrides>
|
<actionName>CancelEdit</actionName>
|
<type>Default</type>
|
</actionOverrides>
|
<actionOverrides>
|
<actionName>Clone</actionName>
|
<type>Default</type>
|
</actionOverrides>
|
<actionOverrides>
|
<actionName>Delete</actionName>
|
<type>Default</type>
|
</actionOverrides>
|
<actionOverrides>
|
<actionName>Edit</actionName>
|
<type>Default</type>
|
</actionOverrides>
|
<actionOverrides>
|
<actionName>List</actionName>
|
<type>Default</type>
|
</actionOverrides>
|
<actionOverrides>
|
<actionName>New</actionName>
|
<type>Default</type>
|
</actionOverrides>
|
<actionOverrides>
|
<actionName>SaveEdit</actionName>
|
<type>Default</type>
|
</actionOverrides>
|
<actionOverrides>
|
<actionName>Tab</actionName>
|
<type>Default</type>
|
</actionOverrides>
|
<actionOverrides>
|
<actionName>View</actionName>
|
<type>Default</type>
|
</actionOverrides>
|
<allowInChatterGroups>false</allowInChatterGroups>
|
<compactLayoutAssignment>SYSTEM</compactLayoutAssignment>
|
<deploymentStatus>Deployed</deploymentStatus>
|
<enableActivities>false</enableActivities>
|
<enableBulkApi>true</enableBulkApi>
|
<enableChangeDataCapture>false</enableChangeDataCapture>
|
<enableFeeds>false</enableFeeds>
|
<enableHistory>false</enableHistory>
|
<enableReports>true</enableReports>
|
<enableSearch>true</enableSearch>
|
<enableSharing>true</enableSharing>
|
<enableStreamingApi>true</enableStreamingApi>
|
<externalSharingModel>ControlledByParent</externalSharingModel>
|
<fields>
|
<fullName>Agency1_Name_F__c</fullName>
|
<externalId>false</externalId>
|
<formula>Statu_Achievements__r.Opportunity__r.Agency1_Name_F__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>第1经销商</label>
|
<required>false</required>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>AssignmentStatus__c</fullName>
|
<externalId>false</externalId>
|
<formula>Statu_Achievements__r.AssignmentStatus__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>分配状態</label>
|
<required>false</required>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>ContractNO__c</fullName>
|
<externalId>false</externalId>
|
<formula>Statu_Achievements__r.ContractNO__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>合同编号</label>
|
<required>false</required>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>DeliveryAmount_1000RMB__c</fullName>
|
<externalId>false</externalId>
|
<formula>ShippedAmount_without_tax_F__c / 1000</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>发货金额(千元RMB,不含税)</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>2</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>DeliveryDate__c</fullName>
|
<description>SAP会把一天的发货金额汇总在一起发过来。</description>
|
<externalId>false</externalId>
|
<label>发货日</label>
|
<required>true</required>
|
<trackTrending>false</trackTrending>
|
<type>Date</type>
|
</fields>
|
<fields>
|
<fullName>DeliveryStatus__c</fullName>
|
<externalId>false</externalId>
|
<formula>Statu_Achievements__r.DeliveryStatus__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>发货状态</label>
|
<required>false</required>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>EndoUser_contract_submit_day__c</fullName>
|
<externalId>false</externalId>
|
<label>预计最终用户合同提交日</label>
|
<required>false</required>
|
<trackTrending>false</trackTrending>
|
<type>Date</type>
|
</fields>
|
<fields>
|
<fullName>FirstApproveDate__c</fullName>
|
<externalId>false</externalId>
|
<formula>Statu_Achievements__r.FirstApproveDate__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>初审日期</label>
|
<required>false</required>
|
<trackTrending>false</trackTrending>
|
<type>Date</type>
|
</fields>
|
<fields>
|
<fullName>Fiscal_Half__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(4 <= MONTH(DeliveryDate__c) && MONTH(DeliveryDate__c) <= 9,
|
'PA',
|
'PB'
|
)</formula>
|
<label>PA/PB</label>
|
<required>false</required>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Fiscal_Year_New__c</fullName>
|
<externalId>false</externalId>
|
<formula>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>OCSM期</label>
|
<required>false</required>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Fiscal_Year__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(MONTH(DeliveryDate__c) <= 3,
|
YEAR(DeliveryDate__c) - 1- 1867,
|
YEAR(DeliveryDate__c) - 1867
|
)</formula>
|
<label>OCSM期(Old)</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>HP__c</fullName>
|
<externalId>false</externalId>
|
<formula>Statu_Achievements__r.Opp_Hospital__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>医院</label>
|
<required>false</required>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Hospital_ID__c</fullName>
|
<externalId>false</externalId>
|
<formula>Statu_Achievements__r.Opportunity__r.HP_ID__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>医院ID</label>
|
<required>false</required>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>IF_LastModifiedDateTime__c</fullName>
|
<externalId>false</externalId>
|
<label>I/F同期日时</label>
|
<required>false</required>
|
<trackTrending>false</trackTrending>
|
<type>DateTime</type>
|
</fields>
|
<fields>
|
<fullName>IF_LastModifiedDate__c</fullName>
|
<externalId>false</externalId>
|
<formula>DATEVALUE(IF_LastModifiedDateTime__c)</formula>
|
<label>I/F同期日</label>
|
<required>false</required>
|
<trackTrending>false</trackTrending>
|
<type>Date</type>
|
</fields>
|
<fields>
|
<fullName>OCM_Category__c</fullName>
|
<externalId>false</externalId>
|
<formula>Statu_Achievements__r.Opportunity__r.OCM__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>OCSM分类</label>
|
<required>false</required>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>OCM_Strategic_dept__c</fullName>
|
<externalId>false</externalId>
|
<formula>Text(Statu_Achievements__r.Opportunity__r.Opportunity_Category__c)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>询价科室分类</label>
|
<required>false</required>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Opp_Department_Name__c</fullName>
|
<externalId>false</externalId>
|
<formula>Statu_Achievements__r.Opportunity__r.Department_Name__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>科室名</label>
|
<required>false</required>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Opp_Number__c</fullName>
|
<description>引合番号</description>
|
<externalId>false</externalId>
|
<formula>Statu_Achievements__r.Opp_Number__c</formula>
|
<label>询价编号</label>
|
<required>false</required>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Opp_Trade__c</fullName>
|
<externalId>false</externalId>
|
<formula>Text(Statu_Achievements__r.Opportunity__r.Trade__c)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>内貿/外貿</label>
|
<required>false</required>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>OverviewStatus__c</fullName>
|
<externalId>false</externalId>
|
<formula>Statu_Achievements__r.OverviewStatus__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>总览状态</label>
|
<required>false</required>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Owner__c</fullName>
|
<externalId>false</externalId>
|
<formula>Statu_Achievements__r.Opportunity__r.Owner_System__r.Alias</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>所有人</label>
|
<required>false</required>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Paid_Amount_Rate_F__c</fullName>
|
<externalId>false</externalId>
|
<formula>Statu_Achievements__r.Paid_Amount_Rate_F__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>累计付款比率</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>2</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>PaymentStatus__c</fullName>
|
<externalId>false</externalId>
|
<formula>Statu_Achievements__r.PaymentStatus__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>付款状态</label>
|
<required>false</required>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Payment_All_Scheduled_Date__c</fullName>
|
<externalId>false</externalId>
|
<label>预测付全款日期</label>
|
<required>false</required>
|
<trackTrending>false</trackTrending>
|
<type>Date</type>
|
</fields>
|
<fields>
|
<fullName>Payment_Scheduled_Date__c</fullName>
|
<externalId>false</externalId>
|
<label>预测付款日</label>
|
<required>false</required>
|
<trackTrending>false</trackTrending>
|
<type>Date</type>
|
</fields>
|
<fields>
|
<fullName>Province_SAP__c</fullName>
|
<externalId>false</externalId>
|
<formula>TExt(Statu_Achievements__r.Opportunity__r.SAP_Province__c )</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>省(业绩)</label>
|
<required>false</required>
|
<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>
|
<trackTrending>false</trackTrending>
|
<type>TextArea</type>
|
</fields>
|
<fields>
|
<fullName>Reason_not_ship__c</fullName>
|
<externalId>false</externalId>
|
<label>未发货原因</label>
|
<required>false</required>
|
<trackTrending>false</trackTrending>
|
<type>TextArea</type>
|
</fields>
|
<fields>
|
<fullName>ReturnFlag__c</fullName>
|
<externalId>false</externalId>
|
<formula>Statu_Achievements__r.ReturnFlag__c</formula>
|
<label>是否退货</label>
|
<trackTrending>false</trackTrending>
|
<type>Checkbox</type>
|
</fields>
|
<fields>
|
<fullName>SO_NO_without_0__c</fullName>
|
<externalId>false</externalId>
|
<formula>mid(SoNo__c,3,10)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>凭证号码(无0)</label>
|
<required>false</required>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>ShippedAmount_F__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF((Statu_Achievements__r.Opportunity__r.Agency1__r.Special__c || Statu_Achievements__r.Opportunity__r.Agency2__r.Special__c || Statu_Achievements__r.Opportunity__r.Account.Parent.Special__c) && $User.ViewSpecialAgencyAmout__c == False, null,
|
ShippedAmount__c
|
)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>发货金額(含税)</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>2</scale>
|
<trackTrending>false</trackTrending>
|
<type>Currency</type>
|
</fields>
|
<fields>
|
<fullName>ShippedAmount_Sum__c</fullName>
|
<externalId>false</externalId>
|
<formula>ShippedAmount__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>/发货金額_元(含税)_Sum</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>2</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>ShippedAmount__c</fullName>
|
<externalId>false</externalId>
|
<label>/发货金額_元(含税)</label>
|
<precision>15</precision>
|
<required>false</required>
|
<scale>2</scale>
|
<trackTrending>false</trackTrending>
|
<type>Currency</type>
|
</fields>
|
<fields>
|
<fullName>ShippedAmount_no_tax_F__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF((Statu_Achievements__r.Opportunity__r.Agency1__r.Special__c || Statu_Achievements__r.Opportunity__r.Agency2__r.Special__c || Statu_Achievements__r.Opportunity__r.Account.Parent.Special__c) && $User.ViewSpecialAgencyAmout__c == False, null,
|
ShippedAmount_without_tax_F__c
|
)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>发货金額(不含税)</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>2</scale>
|
<trackTrending>false</trackTrending>
|
<type>Currency</type>
|
</fields>
|
<fields>
|
<fullName>ShippedAmount_without_tax_F__c</fullName>
|
<externalId>false</externalId>
|
<formula>Case( Statu_Achievements__r.Opportunity__r.Trade__c,
|
"内貿", ShippedAmount__c /IF(Statu_Achievements__r.Opportunity__r.Tax_Intra_F_Copy__c = 0, Statu_Achievements__r.Opportunity__r.Tax_Intra_F__c, Statu_Achievements__r.Opportunity__r.Tax_Intra_F_Copy__c),
|
"外貿",
|
IF(DeliveryDate__c < Datevalue("2012-10-01") ,
|
ShippedAmount__c * 6.6,
|
IF(DeliveryDate__c < Datevalue("2016-07-01") ,
|
ShippedAmount__c * 6.3,
|
IF(DeliveryDate__c < Datevalue("2016-12-01") ,
|
ShippedAmount__c * 6.5,
|
IF(DeliveryDate__c < Datevalue("2018-05-01") ,
|
ShippedAmount__c * 6.8,
|
IF(DeliveryDate__c < Datevalue($Label.Tax_Foreign_Date) ,
|
ShippedAmount__c * 6.3,ShippedAmount__c * 6.8
|
)
|
)
|
)
|
)
|
),
|
ShippedAmount__c * 1
|
)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>/发货金額_元(不含税) 公式</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>6</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>ShippedAmount_without_tax_Float__c</fullName>
|
<externalId>false</externalId>
|
<formula>ShippedAmount_without_tax_F__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>/发货金額_元(不含税) 数值</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>6</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>ShippedAmount_without_tax__c</fullName>
|
<externalId>false</externalId>
|
<label>/发货金額_元(不含税)</label>
|
<precision>15</precision>
|
<required>false</required>
|
<scale>2</scale>
|
<trackTrending>false</trackTrending>
|
<type>Currency</type>
|
</fields>
|
<fields>
|
<fullName>Shipping_Scheduled_Date__c</fullName>
|
<externalId>false</externalId>
|
<label>预测发货日</label>
|
<required>false</required>
|
<trackTrending>false</trackTrending>
|
<type>Date</type>
|
</fields>
|
<fields>
|
<fullName>SoLatestDeliveryDate__c</fullName>
|
<externalId>false</externalId>
|
<formula>Statu_Achievements__r.SoLatestDeliveryDate__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>最晚交货期</label>
|
<required>false</required>
|
<trackTrending>false</trackTrending>
|
<type>Date</type>
|
</fields>
|
<fields>
|
<fullName>SoNo_DeliveryDate_Text__c</fullName>
|
<caseSensitive>true</caseSensitive>
|
<description>SoNo+":" + 发货日(YYYYMMDD)</description>
|
<externalId>true</externalId>
|
<label>注残出纳Key(文本)</label>
|
<length>80</length>
|
<required>false</required>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>true</unique>
|
</fields>
|
<fields>
|
<fullName>SoNo__c</fullName>
|
<externalId>false</externalId>
|
<formula>Statu_Achievements__r.Name</formula>
|
<label>凭证号码</label>
|
<required>false</required>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Statu_Achievements__c</fullName>
|
<externalId>false</externalId>
|
<label>注残</label>
|
<referenceTo>Statu_Achievements__c</referenceTo>
|
<relationshipLabel>注残出纳表</relationshipLabel>
|
<relationshipName>Statu_Achievements_Journal</relationshipName>
|
<relationshipOrder>0</relationshipOrder>
|
<reparentableMasterDetail>true</reparentableMasterDetail>
|
<trackTrending>false</trackTrending>
|
<type>MasterDetail</type>
|
<writeRequiresMasterRead>false</writeRequiresMasterRead>
|
</fields>
|
<fields>
|
<fullName>Status_1__c</fullName>
|
<externalId>false</externalId>
|
<formula>Statu_Achievements__r.Status_1__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>注残状态1</label>
|
<required>false</required>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Status_2_Formula__c</fullName>
|
<externalId>false</externalId>
|
<formula>Statu_Achievements__r.Status_2_Formula__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>注残状态2</label>
|
<required>false</required>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<label>注残出纳表</label>
|
<nameField>
|
<displayFormat>SoJ-{YYYYMMDD}-{0000000}</displayFormat>
|
<label>注残出纳No</label>
|
<type>AutoNumber</type>
|
</nameField>
|
<searchLayouts/>
|
<sharingModel>ControlledByParent</sharingModel>
|
<visibility>Public</visibility>
|
</CustomObject>
|