<?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>
|
<description>快照表,每个月从明细2中快照一次数据(当月收货,当月发货,当月出库)到该表</description>
|
<enableActivities>false</enableActivities>
|
<enableBulkApi>true</enableBulkApi>
|
<enableChangeDataCapture>false</enableChangeDataCapture>
|
<enableFeeds>false</enableFeeds>
|
<enableHistory>false</enableHistory>
|
<enableReports>true</enableReports>
|
<enableSearch>false</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>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Arrive_date__c</fullName>
|
<externalId>false</externalId>
|
<label>到货日期</label>
|
<required>false</required>
|
<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>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Bar_Code__c</fullName>
|
<externalId>false</externalId>
|
<label>BarCode</label>
|
<length>225</length>
|
<required>false</required>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Box_Piece__c</fullName>
|
<externalId>false</externalId>
|
<label>单位</label>
|
<required>false</required>
|
<trackTrending>false</trackTrending>
|
<type>Picklist</type>
|
<valueSet>
|
<restricted>true</restricted>
|
<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>Cancellation_Date__c</fullName>
|
<externalId>false</externalId>
|
<label>取消日期</label>
|
<required>false</required>
|
<trackTrending>false</trackTrending>
|
<type>Date</type>
|
</fields>
|
<fields>
|
<fullName>Cancellation_Flag__c</fullName>
|
<defaultValue>false</defaultValue>
|
<externalId>false</externalId>
|
<label>取消</label>
|
<trackTrending>false</trackTrending>
|
<type>Checkbox</type>
|
</fields>
|
<fields>
|
<fullName>Consumable_Arrived_order__c</fullName>
|
<deleteConstraint>SetNull</deleteConstraint>
|
<externalId>false</externalId>
|
<label>到货单</label>
|
<referenceTo>Consumable_order__c</referenceTo>
|
<relationshipLabel>SS_明细2每个月收发货出库清单 (到货单)</relationshipLabel>
|
<relationshipName>SS_2Consumable_Arrived_order</relationshipName>
|
<required>false</required>
|
<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>SS_明细2每个月收发货出库清单 (盘点单)</relationshipLabel>
|
<relationshipName>SS_2Consumable_Inventory_order</relationshipName>
|
<required>false</required>
|
<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>SS_明细2每个月收发货出库清单 (返品单)</relationshipLabel>
|
<relationshipName>SS_2Consumable_Return_order</relationshipName>
|
<required>false</required>
|
<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>
|
<relationshipLabel>SS_明细2每个月收发货出库清单 (销售订单)</relationshipLabel>
|
<relationshipName>SS_2Consumable_Sale_order</relationshipName>
|
<required>false</required>
|
<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>SS_明细2每个月收发货出库清单 (出库单)</relationshipLabel>
|
<relationshipName>SS_2Consumable_Shipment_order</relationshipName>
|
<required>false</required>
|
<trackTrending>false</trackTrending>
|
<type>Lookup</type>
|
</fields>
|
<fields>
|
<fullName>Consumable_Tax_Intra_F__c</fullName>
|
<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>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Consumable_order_minor__c</fullName>
|
<deleteConstraint>SetNull</deleteConstraint>
|
<externalId>false</externalId>
|
<label>消耗品订单</label>
|
<referenceTo>Consumable_order__c</referenceTo>
|
<relationshipLabel>SS_明细2每个月收发货出库清单</relationshipLabel>
|
<relationshipName>SS_2Consumable_order_minor</relationshipName>
|
<required>false</required>
|
<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>
|
<relationshipLabel>SS_明细2每个月收发货出库清单</relationshipLabel>
|
<relationshipName>Consumable_product</relationshipName>
|
<required>false</required>
|
<trackTrending>false</trackTrending>
|
<type>Lookup</type>
|
</fields>
|
<fields>
|
<fullName>Dealer_Arrive__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF( ISBLANK(Arrive_date__c), false, true)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>经销商到货</label>
|
<trackTrending>false</trackTrending>
|
<type>Checkbox</type>
|
</fields>
|
<fields>
|
<fullName>Dealer_Info_IF__c</fullName>
|
<deleteConstraint>SetNull</deleteConstraint>
|
<externalId>false</externalId>
|
<label>出货元（接口）</label>
|
<referenceTo>Account</referenceTo>
|
<relationshipLabel>SS_明细2每个月收发货出库清单</relationshipLabel>
|
<relationshipName>SS_2Dealer_Info_IF</relationshipName>
|
<required>false</required>
|
<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>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>出货元</label>
|
<required>false</required>
|
<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>
|
<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>
|
<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>
|
<trackTrending>false</trackTrending>
|
<type>Checkbox</type>
|
</fields>
|
<fields>
|
<fullName>Deliver_date__c</fullName>
|
<externalId>false</externalId>
|
<label>发货日期</label>
|
<required>false</required>
|
<trackTrending>false</trackTrending>
|
<type>Date</type>
|
</fields>
|
<fields>
|
<fullName>Delivery_List_RMB__c</fullName>
|
<externalId>false</externalId>
|
<label>出货单价</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>2</scale>
|
<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>
|
<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>
|
<trackTrending>false</trackTrending>
|
<type>Checkbox</type>
|
</fields>
|
<fields>
|
<fullName>Evaluation_date__c</fullName>
|
<externalId>false</externalId>
|
<formula>DATEVALUE(CreatedDate)-15</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>考核月</label>
|
<required>false</required>
|
<trackTrending>false</trackTrending>
|
<type>Date</type>
|
</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>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>医院名称</label>
|
<required>false</required>
|
<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>
|
<trackTrending>false</trackTrending>
|
<type>Checkbox</type>
|
</fields>
|
<fields>
|
<fullName>Intra_Trade_List_RMB__c</fullName>
|
<externalId>false</externalId>
|
<label>采购单价</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>2</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Intra_Trade_Without_Tax__c</fullName>
|
<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>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Inventory_Status__c</fullName>
|
<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>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Inventory_date__c</fullName>
|
<externalId>false</externalId>
|
<label>盘点日期</label>
|
<required>false</required>
|
<trackTrending>false</trackTrending>
|
<type>Date</type>
|
</fields>
|
<fields>
|
<fullName>Lose_Flag__c</fullName>
|
<defaultValue>false</defaultValue>
|
<externalId>false</externalId>
|
<label>是否丢失</label>
|
<trackTrending>false</trackTrending>
|
<type>Checkbox</type>
|
</fields>
|
<fields>
|
<fullName>Lose_reason__c</fullName>
|
<externalId>false</externalId>
|
<label>丢失原因</label>
|
<length>255</length>
|
<required>false</required>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Name__c</fullName>
|
<externalId>false</externalId>
|
<label>明细2名称</label>
|
<length>255</length>
|
<required>false</required>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>OCM_man_province__c</fullName>
|
<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>
|
<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>
|
<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>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>科室</label>
|
<required>false</required>
|
<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>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</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>2</scale>
|
<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>
|
<trackTrending>false</trackTrending>
|
<type>Date</type>
|
</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>
|
<trackTrending>false</trackTrending>
|
<type>Date</type>
|
</fields>
|
<fields>
|
<fullName>Purchase_Unitprice_From__c</fullName>
|
<externalId>false</externalId>
|
<label>采购单价来源</label>
|
<required>false</required>
|
<trackTrending>false</trackTrending>
|
<type>Picklist</type>
|
<valueSet>
|
<restricted>true</restricted>
|
<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>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>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Return_date__c</fullName>
|
<externalId>false</externalId>
|
<label>返品日期</label>
|
<required>false</required>
|
<trackTrending>false</trackTrending>
|
<type>Date</type>
|
</fields>
|
<fields>
|
<fullName>Return_reason__c</fullName>
|
<externalId>false</externalId>
|
<label>返品原因</label>
|
<length>255</length>
|
<required>false</required>
|
<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>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Send_Date__c</fullName>
|
<externalId>false</externalId>
|
<label>出库日期</label>
|
<required>false</required>
|
<trackTrending>false</trackTrending>
|
<type>Date</type>
|
</fields>
|
<fields>
|
<fullName>SerialLotNo__c</fullName>
|
<externalId>false</externalId>
|
<label>批次号</label>
|
<length>255</length>
|
<required>false</required>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>ShipmentAccount__c</fullName>
|
<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>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>借调借入方</label>
|
<required>false</required>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>Sterilization_limit__c</fullName>
|
<externalId>false</externalId>
|
<label>使用期限</label>
|
<required>false</required>
|
<trackTrending>false</trackTrending>
|
<type>Date</type>
|
</fields>
|
<fields>
|
<fullName>SummonsForDirction_det__c</fullName>
|
<externalId>false</externalId>
|
<formula>TEXT(Consumable_Sale_order__r.SummonsForDirction__c) &
|
TEXT(Consumable_Shipment_order__r.SummonsForDirction__c)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>出库目的</label>
|
<required>false</required>
|
<trackTrending>false</trackTrending>
|
<type>Text</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>TracingCode__c</fullName>
|
<externalId>false</externalId>
|
<label>管理编号</label>
|
<length>255</length>
|
<required>false</required>
|
<trackTrending>false</trackTrending>
|
<type>Text</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>
|
<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>
|
<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>SS_明细2每个月收发货出库清单 (借调借出方)</relationshipLabel>
|
<relationshipName>SS_2Used_account</relationshipName>
|
<required>false</required>
|
<trackTrending>false</trackTrending>
|
<type>Lookup</type>
|
</fields>
|
<fields>
|
<fullName>Used_date__c</fullName>
|
<externalId>false</externalId>
|
<label>消费日期</label>
|
<required>false</required>
|
<trackTrending>false</trackTrending>
|
<type>Date</type>
|
</fields>
|
<fields>
|
<fullName>idProductOut__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(ISNULL(Product_OutDate__c ) , 0 ,
|
IF(MONTH(Product_OutDate__c) +1 < 10,
|
IF(BEGINS(Name, TEXT(YEAR(Product_OutDate__c)) & '0' & TEXT(MONTH(Product_OutDate__c) +1)) , 1, 0),
|
IF(BEGINS(Name, TEXT(YEAR(Product_OutDate__c)) & TEXT(MONTH(Product_OutDate__c) +1) ) , 1, 0) )
|
)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>出库数量</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>isArrive__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(ISNULL(Arrive_date__c ) , 0 ,
|
IF(MONTH(Arrive_date__c) +1 < 10,
|
IF(BEGINS(Name, TEXT(YEAR(Arrive_date__c)) & '0' & TEXT(MONTH(Arrive_date__c) +1)) , 1, 0),
|
IF(BEGINS(Name, TEXT(YEAR(Arrive_date__c)) & TEXT(MONTH(Arrive_date__c) +1) ) , 1, 0) )
|
)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>到货数量</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<fields>
|
<fullName>isDeliver__c</fullName>
|
<externalId>false</externalId>
|
<formula>IF(ISNULL(Deliver_date__c ) , 0 ,
|
IF(MONTH(Deliver_date__c) +1 < 10,
|
IF(BEGINS(Name, TEXT(YEAR(Deliver_date__c)) & '0' & TEXT(MONTH(Deliver_date__c) +1)) , 1, 0),
|
IF(BEGINS(Name, TEXT(YEAR(Deliver_date__c)) & TEXT(MONTH(Deliver_date__c) +1) ) , 1, 0) )
|
)</formula>
|
<formulaTreatBlanksAs>BlankAsZero</formulaTreatBlanksAs>
|
<label>发货数量</label>
|
<precision>18</precision>
|
<required>false</required>
|
<scale>0</scale>
|
<trackTrending>false</trackTrending>
|
<type>Number</type>
|
<unique>false</unique>
|
</fields>
|
<label>SS_明细2每个月收发货出库清单</label>
|
<nameField>
|
<displayFormat>{YYYY}{MM}-{00000}</displayFormat>
|
<label>SS每个月明细2名称</label>
|
<type>AutoNumber</type>
|
</nameField>
|
<searchLayouts/>
|
<sharingModel>ReadWrite</sharingModel>
|
<visibility>Public</visibility>
|
</CustomObject>
|
