<?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>true</enableHistory>
|
<enableReports>true</enableReports>
|
<enableSearch>true</enableSearch>
|
<enableSharing>true</enableSharing>
|
<enableStreamingApi>true</enableStreamingApi>
|
<externalSharingModel>Private</externalSharingModel>
|
<fields>
|
<fullName>Account_province_txt__c</fullName>
|
<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>AgencyName_text__c</fullName>
|
<externalId>false</externalId>
|
<label>出货元名称(文本)</label>
|
<length>255</length>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Agency_Transfer__c</fullName>
|
<defaultValue>false</defaultValue>
|
<externalId>false</externalId>
|
<label>经销商借调</label>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Checkbox</type>
|
</fields>
|
<fields>
|
<fullName>Agency_input__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(NOT(ISBLANK(Consumable_Sale_order__c)),Consumable_Sale_order__r.Order_ForDealerText__c,
|
IF(NOT(ISBLANK(Consumable_Shipment_order__c)),Consumable_Shipment_order__r.Order_ForDealerText__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>Agencyinfo_fromSAP__c</fullName>
|
<externalId>false</externalId>
|
<label>SAP发货经销商</label>
|
<length>100</length>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>ApplySalsesTeam_F2__c</fullName>
|
<externalId>false</externalId>
|
<formula>TEXT(Owner:User.Work_Location__c )</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>申请销售课(公式)</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>ApplySalsesTeam__c</fullName>
|
<externalId>false</externalId>
|
<label>申请销售课</label>
|
<length>40</length>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Arrive_Owner_Work_Location__c</fullName>
|
<externalId>false</externalId>
|
<formula>TEXT(Consumable_Arrived_order__r.Owner:User.Work_Location__c)</formula>
|
<label>到货单所有人工作地</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Arrive_Owner__c</fullName>
|
<externalId>false</externalId>
|
<formula>Consumable_Arrived_order__r.Owner:User.Name__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>到货单所有人</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Arrive_date__c</fullName>
|
<externalId>false</externalId>
|
<label>到货日期</label>
|
<required>false</required>
|
<trackHistory>true</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Date</type>
|
</fields>
|
<fields>
|
<fullName>Asset_Model_No__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>AutoShipment_formula__c</fullName>
|
<externalId>false</externalId>
|
<formula>Consumable_Shipment_order__r.AutoShipment__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>自动出库</label>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Checkbox</type>
|
</fields>
|
<fields>
|
<fullName>Bar_Code__c</fullName>
|
<externalId>false</externalId>
|
<label>BarCode</label>
|
<length>225</length>
|
<required>false</required>
|
<trackHistory>true</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Bar_Code_search__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF( TEXT(Box_Piece__c) = '盒' , Bar_Code__c & TEXT(1), Bar_Code__c & TEXT(RemoveBox_No__c) )</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>barcode盘点用</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Box_Piece__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>true</default>
|
<label>盒</label>
|
</value>
|
<value>
|
<fullName>个</fullName>
|
<default>false</default>
|
<label>个</label>
|
</value>
|
</valueSetDefinition>
|
</valueSet>
|
</fields>
|
<fields>
|
<fullName>CFDA_Status__c</fullName>
|
<externalId>false</externalId>
|
<formula>Consumable_product__r.SFDA_Status__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>CFDA状态</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Cancellation_Date__c</fullName>
|
<externalId>false</externalId>
|
<label>取消日期</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Date</type>
|
</fields>
|
<fields>
|
<fullName>Cancellation_Flag__c</fullName>
|
<defaultValue>false</defaultValue>
|
<externalId>false</externalId>
|
<label>取消</label>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Checkbox</type>
|
</fields>
|
<fields>
|
<fullName>Category1__c</fullName>
|
<externalId>false</externalId>
|
<formula>Consumable_product__r.Category1__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>Category2__c</fullName>
|
<externalId>false</externalId>
|
<formula>Consumable_product__r.Category2__c</formula>
|
<label>第二分类</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Category3__c</fullName>
|
<externalId>false</externalId>
|
<formula>Consumable_product__r.Category3__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>Category4__c</fullName>
|
<externalId>false</externalId>
|
<formula>Consumable_product__r.Category4__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>Category5__c</fullName>
|
<externalId>false</externalId>
|
<formula>Consumable_product__r.Category5__c</formula>
|
<label>第五分类</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>City_Maste__c</fullName>
|
<description>Dealer_Info_IF__r.City_Master__r.Name</description>
|
<externalId>false</externalId>
|
<formula>IF(not(isblank(Consumable_Sale_order__c)),Consumable_Sale_order__r.Order_ForHospital__r.City_Master__r.Name ,
|
IF(not(isblank(Consumable_Shipment_order__c)),Consumable_Shipment_order__r.Order_ForHospital__r.City_Master__r.Name,
|
""))</formula>
|
<label>医院所在市</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Consumable_Arrived_order__c</fullName>
|
<deleteConstraint>SetNull</deleteConstraint>
|
<externalId>false</externalId>
|
<label>到货单</label>
|
<referenceTo>Consumable_order__c</referenceTo>
|
<relationshipLabel>消耗品明细2 (到货订单)</relationshipLabel>
|
<relationshipName>Consumable_Arrived_order2</relationshipName>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Lookup</type>
|
</fields>
|
<fields>
|
<fullName>Consumable_Inventory_order__c</fullName>
|
<deleteConstraint>SetNull</deleteConstraint>
|
<externalId>false</externalId>
|
<label>盘点单</label>
|
<referenceTo>Consumable_order__c</referenceTo>
|
<relationshipLabel>消耗品明细2 (盘点订单)</relationshipLabel>
|
<relationshipName>Consumable_Inventory_order2</relationshipName>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Lookup</type>
|
</fields>
|
<fields>
|
<fullName>Consumable_Return_order__c</fullName>
|
<deleteConstraint>SetNull</deleteConstraint>
|
<externalId>false</externalId>
|
<label>返品单</label>
|
<referenceTo>Consumable_order__c</referenceTo>
|
<relationshipLabel>消耗品明细2 (返品订单)</relationshipLabel>
|
<relationshipName>Consumable_Return_order2</relationshipName>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Lookup</type>
|
</fields>
|
<fields>
|
<fullName>Consumable_Sale_order__c</fullName>
|
<deleteConstraint>SetNull</deleteConstraint>
|
<externalId>false</externalId>
|
<label>销售订单</label>
|
<referenceTo>Consumable_order__c</referenceTo>
|
<relationshipName>Consumable_Sale_order2</relationshipName>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Lookup</type>
|
</fields>
|
<fields>
|
<fullName>Consumable_Shipment_order__c</fullName>
|
<deleteConstraint>SetNull</deleteConstraint>
|
<externalId>false</externalId>
|
<label>出库单</label>
|
<referenceTo>Consumable_order__c</referenceTo>
|
<relationshipLabel>消耗品明细2 (出库订单)</relationshipLabel>
|
<relationshipName>Consumable_Shipment_order2</relationshipName>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Lookup</type>
|
</fields>
|
<fields>
|
<fullName>Consumable_Tax_Intra_F__c</fullName>
|
<description>20190326前
|
IF( Deliver_date__c < Datevalue( $Label.Tax_Date ),1.17, 1.16)</description>
|
<externalId>false</externalId>
|
<formula>if( Deliver_date__c < Datevalue( $Label.Tax_Date ),1.17,
|
if(And(Deliver_date__c >= Datevalue( $Label.Tax_Date ),Deliver_date__c < Datevalue( $Label.Tax_Date_13 )),1.16,
|
1.13))</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>Consumable_ZS_order__c</fullName>
|
<deleteConstraint>SetNull</deleteConstraint>
|
<externalId>false</externalId>
|
<label>指示单</label>
|
<referenceTo>Consumable_order__c</referenceTo>
|
<relationshipName>Consumable_ZS2_order</relationshipName>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Lookup</type>
|
</fields>
|
<fields>
|
<fullName>Consumable_order_minor__c</fullName>
|
<deleteConstraint>SetNull</deleteConstraint>
|
<externalId>false</externalId>
|
<label>消耗品订单</label>
|
<referenceTo>Consumable_order__c</referenceTo>
|
<relationshipName>Consumable_order_minor2</relationshipName>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Lookup</type>
|
</fields>
|
<fields>
|
<fullName>Consumable_product__c</fullName>
|
<deleteConstraint>SetNull</deleteConstraint>
|
<externalId>false</externalId>
|
<label>消耗品名称</label>
|
<referenceTo>Product2__c</referenceTo>
|
<relationshipName>Consumable_product2</relationshipName>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Lookup</type>
|
</fields>
|
<fields>
|
<fullName>ContractNo__c</fullName>
|
<externalId>false</externalId>
|
<formula>if( ISBLANK(Consumable_order_minor__r.Order_ForCustomerText__c),Consumable_order_minor__r.Order_ForCustomerText__c,Consumable_order_minor__r.Order_ForCustomerText__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>ContractNo_text__c</fullName>
|
<externalId>false</externalId>
|
<label>sap合同号(文本)</label>
|
<length>131072</length>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>LongTextArea</type>
|
<visibleLines>3</visibleLines>
|
</fields>
|
<fields>
|
<fullName>DealerReturn_Amount__c</fullName>
|
<externalId>false</externalId>
|
<formula>if(AND(Dealer_Returned__c,not(Cancellation_Flag__c)),Detail_Count__c,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>Dealer_Arrive_Amount__c</fullName>
|
<externalId>false</externalId>
|
<formula>if(AND(Dealer_Arrive__c,not(Cancellation_Flag__c)),Detail_Count__c,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>Dealer_Arrive__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF( ISBLANK(Arrive_date__c), false, true)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>经销商到货</label>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Checkbox</type>
|
</fields>
|
<fields>
|
<fullName>Dealer_Info_ID__c</fullName>
|
<externalId>false</externalId>
|
<formula>CASESAFEID(BLANKVALUE(Consumable_order_minor__r.Dealer_Info__c,
|
BLANKVALUE(Consumable_Arrived_order__r.Dealer_Info__c, Dealer_Info_IF__c)))</formula>
|
<label>出货元ID</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Dealer_Info_IF__c</fullName>
|
<deleteConstraint>SetNull</deleteConstraint>
|
<externalId>false</externalId>
|
<label>出货元（接口）</label>
|
<referenceTo>Account</referenceTo>
|
<relationshipName>Dealer_Info_IF</relationshipName>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Lookup</type>
|
</fields>
|
<fields>
|
<fullName>Dealer_Info_text__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(NOT(ISBLANK(Consumable_order_minor__r.Dealer_Info__r.Name)), Consumable_order_minor__r.Dealer_Info__r.Name , if(ISBLANK(Consumable_Arrived_order__r.Dealer_Info__r.Name), Dealer_Info_IF__r.Name ,Consumable_Arrived_order__r.Dealer_Info__r.Name))</formula>
|
<label>出货元</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Dealer_Returned__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF( ISBLANK(Return_date__c) , false, true)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>经销商返品</label>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Checkbox</type>
|
</fields>
|
<fields>
|
<fullName>Dealer_Saled__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF( ISBLANK(Used_date__c),false,true)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>经销商销售</label>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Checkbox</type>
|
</fields>
|
<fields>
|
<fullName>Dealer_Shipment__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF( ISBLANK(Send_Date__c),false,true)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>经销商出库</label>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Checkbox</type>
|
</fields>
|
<fields>
|
<fullName>Deliver_date__c</fullName>
|
<externalId>false</externalId>
|
<label>发货日期</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Date</type>
|
</fields>
|
<fields>
|
<fullName>DeliveryNote__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>Delivery_List_RMB__c</fullName>
|
<externalId>false</externalId>
|
<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>Detail_Count__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF( TEXT(Box_Piece__c) = '盒', 1 , 1 / ProductPacking_list_manual__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>DirectSalesAmount__c</fullName>
|
<description>报表使用</description>
|
<externalId>false</externalId>
|
<formula>if(AND(SalesChannel__c="直销",not(Cancellation_Flag__c)),Detail_Count__c,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>Direct_Arrive_Product__c</fullName>
|
<defaultValue>false</defaultValue>
|
<externalId>false</externalId>
|
<label>直接入库</label>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Checkbox</type>
|
</fields>
|
<fields>
|
<fullName>EachOther_Amount__c</fullName>
|
<description>报表使用</description>
|
<externalId>false</externalId>
|
<formula>if(AND(SummonsForDirction_det__c="互相调货",not(Cancellation_Flag__c)),Detail_Count__c,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>Frist_Storage_Agency_F__c</fullName>
|
<externalId>false</externalId>
|
<formula>Consumable_Arrived_order__r.Dealer_Info__r.Name</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>Frist_Storage_Agency_F</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Frist_Storage_Agency__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>Frist_Transfer_Agency__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>Guarantee_period_for_products__c</fullName>
|
<description>课题号 CHAN-AXN4KV</description>
|
<externalId>false</externalId>
|
<label>使用期限(不用)</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Date</type>
|
</fields>
|
<fields>
|
<fullName>HospItal_Classification__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(not(isblank(Consumable_Sale_order__c)),Consumable_Sale_order__r.HospItal_Classification__c,
|
IF(not(isblank(Consumable_Shipment_order__c)),Consumable_Shipment_order__r.HospItal_Classification__c,
|
""))</formula>
|
<label>医院分级信息</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>HospItal_Code__c</fullName>
|
<description>Consumable_Shipment_order__r.HospItal_Code__c</description>
|
<externalId>false</externalId>
|
<formula>IF(not(isblank(Consumable_Sale_order__c)),Consumable_Sale_order__r.HospItal_Code__c,
|
IF(not(isblank(Consumable_Shipment_order__c)),Consumable_Shipment_order__r.HospItal_Code__c,
|
""))</formula>
|
<label>医院编码</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>HospItal_Name__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(not(isblank(Consumable_Sale_order__c)),Consumable_Sale_order__r.Order_ForHospital__r.Name,
|
IF(not(isblank(Consumable_Shipment_order__c)),Consumable_Shipment_order__r.Order_ForHospital__r.Name,
|
""))</formula>
|
<label>医院名称</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Hospital_ID__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(not(isblank(Consumable_Sale_order__c)),CASESAFEID(Consumable_Sale_order__r.Order_ForHospital__c),
|
IF(not(isblank(Consumable_Shipment_order__c)),CASESAFEID(Consumable_Shipment_order__r.Order_ForHospital__c),
|
""))</formula>
|
<label>医院ID</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Hospital_Province__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(not(isblank(Consumable_Sale_order__c)),Consumable_Sale_order__r.Order_ForHospital__r.OCM_province_HP__c ,
|
IF(not(isblank(Consumable_Shipment_order__c)),Consumable_Shipment_order__r.Order_ForHospital__r.OCM_province_HP__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_Information_From__c</fullName>
|
<defaultValue>false</defaultValue>
|
<externalId>false</externalId>
|
<label>IF情報元</label>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Checkbox</type>
|
</fields>
|
<fields>
|
<fullName>Importent_Pro__c</fullName>
|
<externalId>false</externalId>
|
<formula>Consumable_product__r.Important_product__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>是否重点产品</label>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Checkbox</type>
|
</fields>
|
<fields>
|
<fullName>Intra_Trade_List_RMB__c</fullName>
|
<defaultValue>0</defaultValue>
|
<externalId>false</externalId>
|
<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>Intra_Trade_Without_Tax__c</fullName>
|
<description>2020/4/22改名：实际采购单价(不含税)=>采购单价(不含税)</description>
|
<externalId>false</externalId>
|
<formula>Intra_Trade_List_RMB__c / Consumable_Tax_Intra_F__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>InventoryChange_Amount__c</fullName>
|
<description>报表使用</description>
|
<externalId>false</externalId>
|
<formula>if(AND(Lose_Flag__c,not(Cancellation_Flag__c)) , -1 * Detail_Count__c , 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>Inventory_Status__c</fullName>
|
<description>CHAN-BW7CUB
|
“库存状态”建议修改为“产品状态”或“追溯状态”</description>
|
<externalId>false</externalId>
|
<formula>if(SummonsForDirction_det__c="直接销售给医院","直销到医院",
|
if(SummonsForDirction_det__c="医院试用","给医院试用",
|
if(SummonsForDirction_det__c="销售给二级经销商","给二级到医院",
|
if(SummonsForDirction_det__c="互相调货","互相调货",
|
if(Lose_Flag__c=True,"丢失",
|
if(Dealer_Arrive__c=False,"未到经销商",
|
if(Dealer_Arrive__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>Inventory_date__c</fullName>
|
<externalId>false</externalId>
|
<label>盘点日期</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Date</type>
|
</fields>
|
<fields>
|
<fullName>Invoice_Date__c</fullName>
|
<externalId>false</externalId>
|
<label>开票日期</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Date</type>
|
</fields>
|
<fields>
|
<fullName>Is_ET_APP__c</fullName>
|
<externalId>false</externalId>
|
<formula>Consumable_product__r.Product2__r.Is_ET_APP__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>ET_APP专用_ET对象</label>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Checkbox</type>
|
</fields>
|
<fields>
|
<fullName>Isoverdue__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(Sterilization_limit__c < today(), 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>Key_product__c</fullName>
|
<externalId>false</externalId>
|
<formula>Consumable_product__r.Product2__r.Key_product_147P__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>LastConsumer__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(not(isblank(Consumable_Sale_order__c)),Consumable_Sale_order__r.Report_Acc_Dep__c,IF(not(isblank(Consumable_Shipment_order__c)), Consumable_Shipment_order__r.Report_Acc_Dep__c ,""))</formula>
|
<label>最终用户</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Lose_Flag__c</fullName>
|
<defaultValue>false</defaultValue>
|
<externalId>false</externalId>
|
<label>是否丢失</label>
|
<trackHistory>true</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Checkbox</type>
|
</fields>
|
<fields>
|
<fullName>Lose_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>More_than_seven_days_tag__c</fullName>
|
<externalId>false</externalId>
|
<formula>if(Dealer_Shipment__c == false && Dealer_Arrive__c == false && Dealer_Saled__c == false && (TODAY()>(Deliver_date__c + 7)),true,false)</formula>
|
<label>发货七天还未到货标识</label>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Checkbox</type>
|
</fields>
|
<fields>
|
<fullName>NotShow_data__c</fullName>
|
<defaultValue>false</defaultValue>
|
<description>报表用（北京中通恒信152P前数据不显示）</description>
|
<externalId>false</externalId>
|
<label>取消显示</label>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Checkbox</type>
|
</fields>
|
<fields>
|
<fullName>OCM_Category__c</fullName>
|
<description>TEXT(Consumable_Shipment_order__r.Order_ForHospital__r.OCM_Category__c )</description>
|
<externalId>false</externalId>
|
<formula>IF(not(isblank(Consumable_Sale_order__c)),TEXT(Consumable_Sale_order__r.Order_ForHospital__r.OCM_Category__c ),
|
IF(not(isblank(Consumable_Shipment_order__c)),TEXT(Consumable_Shipment_order__r.Order_ForHospital__r.OCM_Category__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__c</fullName>
|
<description>20200821 修改前
|
IF(not(isblank(Consumable_Sale_order__c))&& not(isblank( HospItal_Name__c )),Consumable_Sale_order__r.Order_ForHospital__r.OCM_man_province_txt__c,
|
IF(Used_Account_Type__c = "契約", Account_province_txt__c ,IF(Used_Account_Type__c = "販売店",
|
CASE(TEXT(Owner:User.Work_Location__c),</description>
|
<externalId>false</externalId>
|
<formula>IF(not(isblank(Consumable_Sale_order__c))&& not(isblank( HospItal_Name__c )),Consumable_Sale_order__r.Order_ForHospital__r.OCM_man_province_txt__c,
|
|
IF(not(isblank(Consumable_Shipment_order__c))&& not(isblank(HospItal_Name__c)),Consumable_Shipment_order__r.Order_ForHospital__r.OCM_man_province_txt__c,
|
|
IF(Used_Account_Type__c = "契約", Account_province_txt__c ,IF(Used_Account_Type__c = "販売店",
|
|
CASE(TEXT(Owner:User.Work_Location__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>OT_Code__c</fullName>
|
<externalId>false</externalId>
|
<formula>Consumable_product__r.OT_CODE__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>OT Code</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Opportunity_No__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>Order_Dealer_Info__c</fullName>
|
<description>返品页面经销商(二级经销商或者手动录入的)</description>
|
<externalId>false</externalId>
|
<formula>IF(NOT(ISBLANK(Consumable_Sale_order__c)),Consumable_Sale_order__r.Order_Dealer_Info__c,
|
IF(NOT(ISBLANK(Consumable_Shipment_order__c)),Consumable_Shipment_order__r.Order_Dealer_Info__c,
|
""))</formula>
|
<label>二级经销商</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Order_ForCustomerText__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(not(isblank(Consumable_Sale_order__c)),Consumable_Sale_order__r.Order_ForCustomerText__c,
|
IF(not(isblank(Consumable_Shipment_order__c)),Consumable_Shipment_order__r.Order_ForCustomerText__c,
|
""))</formula>
|
<label>科室</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Order_ProType_det2__c</fullName>
|
<externalId>false</externalId>
|
<label>订单产品分类</label>
|
<length>75</length>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Order_ProType_det2_formula__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(not(isblank( Consumable_order_minor__c )),TEXT(Consumable_order_minor__r.Order_ProType__c),
|
IF(not(isblank( Consumable_Arrived_order__c )),TEXT(Consumable_Arrived_order__r.Order_ProType__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>Order_date__c</fullName>
|
<externalId>false</externalId>
|
<formula>Consumable_order_minor__r.Order_date__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>订单日期</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Date</type>
|
</fields>
|
<fields>
|
<fullName>ProductPacking_list_manual__c</fullName>
|
<externalId>false</externalId>
|
<formula>Consumable_product__r.Product2__r.Packing_list_manual__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>Product_Date__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF( BEGINS( Bar_Code__c , '241'),
|
IF(MID(Bar_Code__c ,4,7)= OT_Code__c && MID(Bar_Code__c ,11,2)= '11' ,
|
DATEVALUE('20'&MID( Bar_Code__c , 13, 2)&"-"&MID( Bar_Code__c , 15, 2)&"-"&if(MID(Bar_Code__c , 17, 2)= '00','01',MID(Bar_Code__c , 17, 2))),
|
IF(MID(Bar_Code__c ,4,6)= OT_Code__c && MID(Bar_Code__c ,10,2)= '11' ,
|
DATEVALUE('20'&MID( Bar_Code__c , 12, 2)&"-"&MID( Bar_Code__c , 14, 2)&"-"&if(MID(Bar_Code__c , 16, 2)= '00','01',MID(Bar_Code__c , 16, 2))),
|
IF(MID(Bar_Code__c ,4,8)= OT_Code__c && MID(Bar_Code__c ,12,2)= '11' ,
|
DATEVALUE('20'&MID( Bar_Code__c , 14, 2)&"-"&MID( Bar_Code__c , 16, 2)&"-"&if(MID(Bar_Code__c , 18, 2)= '00','01',MID(Bar_Code__c , 18, 2))),
|
IF(MID(Bar_Code__c ,4,9)= OT_Code__c && MID(Bar_Code__c ,13,2)= '11',
|
DATEVALUE('20'&MID( Bar_Code__c , 15, 2)&"-"&MID( Bar_Code__c , 17, 2)&"-"&if(MID(Bar_Code__c , 19, 2)= '00','01',MID(Bar_Code__c , 19, 2))), null)))),
|
if(MID(Bar_Code__c ,17,2)= '11',DATEVALUE('20'&MID( Bar_Code__c , 19, 2)&"-"&MID( Bar_Code__c , 21, 2)&"-"&if(MID(Bar_Code__c , 23, 2)= '00','01',MID(Bar_Code__c , 23, 2))),null))</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>生产日期</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Date</type>
|
</fields>
|
<fields>
|
<fullName>Product_ListPrice__c</fullName>
|
<externalId>false</externalId>
|
<formula>Consumable_product__r.Intra_Trade_List_RMB__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>Product_OutDate__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF( ISNULL(Send_Date__c)=true,Used_date__c,Send_Date__c)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>出库日</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Date</type>
|
</fields>
|
<fields>
|
<fullName>Product_Pattern__c</fullName>
|
<externalId>false</externalId>
|
<formula>Consumable_product__c & IF(hospitalSpecialOffer__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>Product_Type__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF( ISBLANK( Consumable_order_minor__c ) , IF(ISBLANK( Consumable_Arrived_order__c ), IF( Consumable_product__r.Pro2_Dealer_Object__c , 'ET', '') & IF( Consumable_product__r.Pro2_Dealer_ENG__c , 'ENG', ''), text(Consumable_Arrived_order__r.Order_ProType__c)) , text(Consumable_order_minor__r.Order_ProType__c) )</formula>
|
<label>产品分类</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Product_fullname__c</fullName>
|
<externalId>false</externalId>
|
<formula>Consumable_product__r.Name_Text__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>产品全称</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Product_name__c</fullName>
|
<externalId>false</externalId>
|
<formula>RIGHT(Consumable_product__r.Name__c,(LEN(Consumable_product__r.Name__c)-FIND(":",Consumable_product__r.Name__c)))</formula>
|
<label>产品名称</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Purchase_Unitprice_From__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>true</default>
|
<label>标准</label>
|
</value>
|
<value>
|
<fullName>促销</fullName>
|
<default>false</default>
|
<label>促销</label>
|
</value>
|
</valueSetDefinition>
|
</valueSet>
|
</fields>
|
<fields>
|
<fullName>Real_Purchase_Unitprice__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(TEXT( Box_Piece__c ) = '盒', Intra_Trade_List_RMB__c , Intra_Trade_List_RMB__c / ProductPacking_list_manual__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>RemoveBox_No__c</fullName>
|
<externalId>false</externalId>
|
<label>拆盒番号(数字)</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>RemoveBox_Num__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(RemoveBox_No__c > 0 , LPAD(text(RemoveBox_No__c),3,'0') , '')</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>序列号</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>RemoveBox_date__c</fullName>
|
<externalId>false</externalId>
|
<label>拆盒日期</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Date</type>
|
</fields>
|
<fields>
|
<fullName>Report_Product_Approbation__c</fullName>
|
<externalId>false</externalId>
|
<formula>Consumable_product__r.SFDA_Approbation_No__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>Report_Product_Expiration__c</fullName>
|
<externalId>false</externalId>
|
<formula>Consumable_product__r.SFDA_Expiration_Date__c</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>注册证效期</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Date</type>
|
</fields>
|
<fields>
|
<fullName>ReturnGoods_unitPrice__c</fullName>
|
<externalId>false</externalId>
|
<formula>Delivery_List_RMB__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>ReturnGs_Uploader_ID__c</fullName>
|
<deleteConstraint>SetNull</deleteConstraint>
|
<externalId>false</externalId>
|
<label>返品登录人</label>
|
<referenceTo>User</referenceTo>
|
<relationshipName>ReturnGs_Uploader_ID2</relationshipName>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Lookup</type>
|
</fields>
|
<fields>
|
<fullName>Return_date__c</fullName>
|
<externalId>false</externalId>
|
<label>返品日期</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Date</type>
|
</fields>
|
<fields>
|
<fullName>Return_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>Rrturn_count__c</fullName>
|
<description>返品数量仅用于返品错误信息显示用
|
（单位:个的时候，返品画面里用户需要输入）</description>
|
<externalId>false</externalId>
|
<label>返品数量</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>SAP_ShipAmount__c</fullName>
|
<description>分析报表使用
|
if(AND(NOT(ISNULL(Deliver_date__c)),NOT(Cancellation_Flag__c) ),Detail_Count__c,0)</description>
|
<externalId>false</externalId>
|
<formula>if(AND(NOT(ISNULL(Deliver_date__c)),NOT(Cancellation_Flag__c),NOT( Direct_Arrive_Product__c ), OR(OwnerId <> CreatedById,OwnerId = $Label.User_OlympusSystem ) ),Detail_Count__c,0)</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>Sale_orderName__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF( ISBLANK( Consumable_Shipment_order__c ) , Consumable_Sale_order__r.Name , Consumable_Shipment_order__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>Sale_unitPrice__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF( Unitprice_To_agency__c = 0, Delivery_List_RMB__c , Unitprice_To_agency__c) * if(text(Box_Piece__c) = '盒',1,Consumable_product__r.Packing_list_manual__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>SalesChannel__c</fullName>
|
<description>For Report</description>
|
<externalId>false</externalId>
|
<formula>if(SummonsForDirction_det__c="直接销售给医院","直销",
|
if(SummonsForDirction_det__c="医院试用","试用",
|
if(SummonsForDirction_det__c="销售给二级经销商","二级", "")))</formula>
|
<label>渠道</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>SalesDepartment_Dealer__c</fullName>
|
<description>IF( OwnerId = $Label.User_OlympusSystem , Consumable_order_minor__r.SalesDepartment_Dealer__c, Owner:User.Salesdepartment_text__c )</description>
|
<externalId>false</externalId>
|
<formula>IF( OwnerId = $Label.User_OlympusSystem , Consumable_order_minor__r.SalesDepartment_Dealer__c, Owner:User.Salesdepartment_text__c )</formula>
|
<label>销售本部(经销商)</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>SalesDiscount__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF( Product_ListPrice__c <> 0, Sale_unitPrice__c / Product_ListPrice__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>Sales_Promotion__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF( OwnerId = $Label.User_OlympusSystem , Consumable_order_minor__r.ApplySalsesTeam_F__c , TEXT(Owner:User.Work_Location__c) )</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>销售推广课</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>SellDealer_Amount__c</fullName>
|
<externalId>false</externalId>
|
<formula>if(AND(SalesChannel__c="二级",not(Cancellation_Flag__c)),Detail_Count__c,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>Send_Date__c</fullName>
|
<externalId>false</externalId>
|
<label>出库日期</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Date</type>
|
</fields>
|
<fields>
|
<fullName>SerialLotNo__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>ShipORReceiveDate__c</fullName>
|
<description>报表使用</description>
|
<externalId>false</externalId>
|
<formula>if(isblank(Deliver_date__c),Arrive_date__c,Deliver_date__c)</formula>
|
<label>发货或入库日期</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Date</type>
|
</fields>
|
<fields>
|
<fullName>ShipmentAccount__c</fullName>
|
<description>For Report
|
2017/10/25之前
|
Consumable_Shipment_order__r.ShipmentAccount__c</description>
|
<externalId>false</externalId>
|
<formula>if(not(ISBLANK(Consumable_Sale_order__c)),Consumable_Sale_order__r.ShipmentAccount__c,
|
if(not(ISBLANK(Consumable_Shipment_order__c)),Consumable_Shipment_order__r.ShipmentAccount__c,
|
""))</formula>
|
<label>借调借入方</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Shipment_Account__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(Consumable_Shipment_order__r.ShipmentAccount__c = null, Consumable_Sale_order__r.ShipmentAccount__c, Consumable_Shipment_order__r.ShipmentAccount__c)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>最終出荷先</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Shipment_Creater_formula__c</fullName>
|
<externalId>false</externalId>
|
<formula>TEXT(Consumable_Shipment_order__r.CreatedBy.Work_Location__c)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>出库单创建人工作地</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Shipment_afterTransfer__c</fullName>
|
<externalId>false</externalId>
|
<formula>if( AND(Transfer_Time__c > 0,AND(SummonsForDirction_det__c <> '互相调货', NOT(ISBLANK(SummonsForDirction_det__c)))),true,false)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>借调后出库</label>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Checkbox</type>
|
</fields>
|
<fields>
|
<fullName>ShippTotal_Amount__c</fullName>
|
<description>报表使用</description>
|
<externalId>false</externalId>
|
<formula>DirectSalesAmount__c + SellDealer_Amount__c + TrialHospial_Amount__c + EachOther_Amount__c - DealerReturn_Amount__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>State_Master__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF( OwnerId = $Label.User_OlympusSystem , Consumable_order_minor__r.State_Master__c , TEXT(Owner:User.Province__c) )</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>省份</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Sterilization_OneYearlimit__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF( AND(Sterilization_limit__c > TODAY() ,DATE((year( Sterilization_limit__c )-1),floor(month(Sterilization_limit__c )),floor(DAY(Sterilization_limit__c ))) < TODAY()) , true, false)</formula>
|
<label>滅菌有効期限小于1年</label>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Checkbox</type>
|
</fields>
|
<fields>
|
<fullName>Sterilization_limit__c</fullName>
|
<description>课题 CHAN-AXN4KV 修改名称</description>
|
<externalId>false</externalId>
|
<label>使用期限</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Date</type>
|
</fields>
|
<fields>
|
<fullName>SummonsForDirction_det__c</fullName>
|
<description>if(not(ISNULL(Consumable_Sale_order__c)),TEXT(Consumable_Sale_order__r.SummonsForDirction__c),
|
if(not(ISNULL(Consumable_Shipment_order__c)),TEXT(Consumable_Shipment_order__r.SummonsForDirction__c),
|
""))</description>
|
<externalId>false</externalId>
|
<formula>TEXT(Consumable_Sale_order__r.SummonsForDirction__c) &
|
TEXT(Consumable_Shipment_order__r.SummonsForDirction__c)</formula>
|
<label>出库目的</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>TextName__c</fullName>
|
<externalId>false</externalId>
|
<label>TextName</label>
|
<length>255</length>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>ToDueDateDays__c</fullName>
|
<description>For Report</description>
|
<externalId>false</externalId>
|
<formula>if(isnull(Sterilization_limit__c),9999, Sterilization_limit__c-TODAY())</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>TracingCode__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>Transfer_Time__c</fullName>
|
<externalId>false</externalId>
|
<label>借调次数</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>TrialHospial_Amount__c</fullName>
|
<externalId>false</externalId>
|
<formula>if(AND(SalesChannel__c="试用",not(Cancellation_Flag__c)),Detail_Count__c,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>Unitprice_To_agency__c</fullName>
|
<externalId>false</externalId>
|
<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>Used_Account_Type__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>Used_account__c</fullName>
|
<deleteConstraint>SetNull</deleteConstraint>
|
<externalId>false</externalId>
|
<label>借调借出方</label>
|
<referenceTo>Account</referenceTo>
|
<relationshipLabel>消耗品明细2 (使用客户)</relationshipLabel>
|
<relationshipName>Used_account2</relationshipName>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Lookup</type>
|
</fields>
|
<fields>
|
<fullName>Used_date__c</fullName>
|
<externalId>false</externalId>
|
<label>消费日期</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Date</type>
|
</fields>
|
<fields>
|
<fullName>exchangeOutPattern__c</fullName>
|
<defaultValue>false</defaultValue>
|
<description>该字段用于入库,出库 入库时,根据barcode查询当前明细2是否存在于其他经销商,如果存在 判断是否为特价产品,后赋值给该字段 出库时,根据该字段判断,如果该产品为医院特价产品并且出库的接入方没有维护该产品的医院特价 则无法出库</description>
|
<externalId>false</externalId>
|
<label>互相调货_医院特价</label>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Checkbox</type>
|
</fields>
|
<fields>
|
<fullName>hospitalSpecialOffer__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(exchangeOutPattern__c == false,IF(TEXT(Consumable_order_minor__r.orderPattern__c) == 'hospitalorder' ,TRUE,FALSE),TRUE)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>医院特价</label>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Checkbox</type>
|
</fields>
|
<fields>
|
<fullName>isTriggerprocess__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(OR(Order_ProType_det2__c != Order_ProType_det2_formula__c,AgencyName_text__c != Dealer_Info_text__c,ApplySalsesTeam__c != ApplySalsesTeam_F2__c),true,false)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>是否触发明细2经销商名称和销售课文本化流</label>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Checkbox</type>
|
</fields>
|
<fields>
|
<fullName>loseInventory__c</fullName>
|
<defaultValue>false</defaultValue>
|
<externalId>false</externalId>
|
<label>是否是丢失返品</label>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Checkbox</type>
|
</fields>
|
<fields>
|
<fullName>promotionorder__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(TEXT(Consumable_order_minor__r.orderPattern__c) = 'promotionorder' ,TRUE,FALSE)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>促销订货</label>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Checkbox</type>
|
</fields>
|
<fields>
|
<fullName>sNo__c</fullName>
|
<externalId>false</externalId>
|
<formula>SerialLotNo__c + '(' + TracingCode__c + ')'</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>机身编码</label>
|
<required>false</required>
|
<trackHistory>false</trackHistory>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<label>消耗品明细2</label>
|
<nameField>
|
<label>消耗品明细2名称</label>
|
<trackHistory>true</trackHistory>
|
<type>Text</type>
|
</nameField>
|
<recordTypeTrackHistory>false</recordTypeTrackHistory>
|
<recordTypes>
|
<fullName>Detail2_Delivery</fullName>
|
<active>true</active>
|
<label>发货</label>
|
<picklistValues>
|
<picklist>Box_Piece__c</picklist>
|
<values>
|
<fullName>个</fullName>
|
<default>false</default>
|
</values>
|
<values>
|
<fullName>盒</fullName>
|
<default>true</default>
|
</values>
|
</picklistValues>
|
</recordTypes>
|
<recordTypes>
|
<fullName>Detail2_ReturnGoods</fullName>
|
<active>true</active>
|
<label>返品</label>
|
<picklistValues>
|
<picklist>Box_Piece__c</picklist>
|
<values>
|
<fullName>个</fullName>
|
<default>false</default>
|
</values>
|
<values>
|
<fullName>盒</fullName>
|
<default>true</default>
|
</values>
|
</picklistValues>
|
</recordTypes>
|
<searchLayouts/>
|
<sharingModel>Private</sharingModel>
|
<visibility>Public</visibility>
|
</CustomObject>
|
