254 lines
26 KiB
XML
254 lines
26 KiB
XML
|
<?xml version="1.0" encoding="utf-8"?>
|
|||
|
|
<xs:schema id="deiniuWMSDataSet2" targetNamespace="http://tempuri.org/deiniuWMSDataSet22.xsd" xmlns:mstns="http://tempuri.org/deiniuWMSDataSet22.xsd" xmlns="http://tempuri.org/deiniuWMSDataSet22.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
|
|||
|
|
<xs:annotation>
|
|||
|
|
<xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
|
|||
|
|
<DataSource DefaultConnectionIndex="0" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
|
|||
|
|
<Connections>
|
|||
|
|
<Connection AppSettingsObjectName="Settings" AppSettingsPropertyName="deiniuWMSConnectionString1" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="deiniuWMSConnectionString1 (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.DeiNiu.wms.win.Properties.Settings.GlobalReference.Default.deiniuWMSConnectionString1" Provider="System.Data.SqlClient" />
|
|||
|
|
</Connections>
|
|||
|
|
<Tables>
|
|||
|
|
<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="v_tmsPickRequestTableAdapter" GeneratorDataComponentClassName="v_tmsPickRequestTableAdapter" Name="v_tmsPickRequest" UserDataComponentName="v_tmsPickRequestTableAdapter">
|
|||
|
|
<MainSource>
|
|||
|
|
<DbSource ConnectionRef="deiniuWMSConnectionString1 (Settings)" DbObjectName="deiniuWMS.dbo.v_tmsPickRequest" DbObjectType="View" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
|
|||
|
|
<SelectCommand>
|
|||
|
|
<DbCommand CommandType="Text" ModifiedByUser="false">
|
|||
|
|
<CommandText>SELECT id, transNo, pickOrderNo, waveOrder, orderType, orderTypeName, customerId, customerName, custAddress, desk, boxCnt, bulkCnt, volume, weight, state, bulkPickState, batchPickState, orderDate, description, pickedBy, pickedTime, checkedBy, checkedTime, waveStart, waveEnd, priority, operater, dr, createtime, lastmodified, lineId, lineOrder, lineName, lineDesc, sumVol, sumWeight, bulkBox, bulkBag, tranLocationId, dueDate, outStoreType, phone1, phone2, owner, invoiceNo, invoicedBy, salesperson, sumPrice, docNo, 复核人 FROM dbo.v_tmsPickRequest</CommandText>
|
|||
|
|
<Parameters />
|
|||
|
|
</DbCommand>
|
|||
|
|
</SelectCommand>
|
|||
|
|
</DbSource>
|
|||
|
|
</MainSource>
|
|||
|
|
<Mappings>
|
|||
|
|
<Mapping SourceColumn="id" DataSetColumn="id" />
|
|||
|
|
<Mapping SourceColumn="transNo" DataSetColumn="transNo" />
|
|||
|
|
<Mapping SourceColumn="pickOrderNo" DataSetColumn="pickOrderNo" />
|
|||
|
|
<Mapping SourceColumn="waveOrder" DataSetColumn="waveOrder" />
|
|||
|
|
<Mapping SourceColumn="orderType" DataSetColumn="orderType" />
|
|||
|
|
<Mapping SourceColumn="orderTypeName" DataSetColumn="orderTypeName" />
|
|||
|
|
<Mapping SourceColumn="customerId" DataSetColumn="customerId" />
|
|||
|
|
<Mapping SourceColumn="customerName" DataSetColumn="customerName" />
|
|||
|
|
<Mapping SourceColumn="custAddress" DataSetColumn="custAddress" />
|
|||
|
|
<Mapping SourceColumn="desk" DataSetColumn="desk" />
|
|||
|
|
<Mapping SourceColumn="boxCnt" DataSetColumn="boxCnt" />
|
|||
|
|
<Mapping SourceColumn="bulkCnt" DataSetColumn="bulkCnt" />
|
|||
|
|
<Mapping SourceColumn="volume" DataSetColumn="volume" />
|
|||
|
|
<Mapping SourceColumn="weight" DataSetColumn="weight" />
|
|||
|
|
<Mapping SourceColumn="state" DataSetColumn="state" />
|
|||
|
|
<Mapping SourceColumn="bulkPickState" DataSetColumn="bulkPickState" />
|
|||
|
|
<Mapping SourceColumn="batchPickState" DataSetColumn="batchPickState" />
|
|||
|
|
<Mapping SourceColumn="orderDate" DataSetColumn="orderDate" />
|
|||
|
|
<Mapping SourceColumn="description" DataSetColumn="description" />
|
|||
|
|
<Mapping SourceColumn="pickedBy" DataSetColumn="pickedBy" />
|
|||
|
|
<Mapping SourceColumn="pickedTime" DataSetColumn="pickedTime" />
|
|||
|
|
<Mapping SourceColumn="checkedBy" DataSetColumn="checkedBy" />
|
|||
|
|
<Mapping SourceColumn="checkedTime" DataSetColumn="checkedTime" />
|
|||
|
|
<Mapping SourceColumn="waveStart" DataSetColumn="waveStart" />
|
|||
|
|
<Mapping SourceColumn="waveEnd" DataSetColumn="waveEnd" />
|
|||
|
|
<Mapping SourceColumn="priority" DataSetColumn="priority" />
|
|||
|
|
<Mapping SourceColumn="operater" DataSetColumn="operater" />
|
|||
|
|
<Mapping SourceColumn="dr" DataSetColumn="dr" />
|
|||
|
|
<Mapping SourceColumn="createtime" DataSetColumn="createtime" />
|
|||
|
|
<Mapping SourceColumn="lastmodified" DataSetColumn="lastmodified" />
|
|||
|
|
<Mapping SourceColumn="lineId" DataSetColumn="lineId" />
|
|||
|
|
<Mapping SourceColumn="lineOrder" DataSetColumn="lineOrder" />
|
|||
|
|
<Mapping SourceColumn="lineName" DataSetColumn="lineName" />
|
|||
|
|
<Mapping SourceColumn="lineDesc" DataSetColumn="lineDesc" />
|
|||
|
|
<Mapping SourceColumn="sumVol" DataSetColumn="sumVol" />
|
|||
|
|
<Mapping SourceColumn="sumWeight" DataSetColumn="sumWeight" />
|
|||
|
|
<Mapping SourceColumn="bulkBox" DataSetColumn="bulkBox" />
|
|||
|
|
<Mapping SourceColumn="bulkBag" DataSetColumn="bulkBag" />
|
|||
|
|
<Mapping SourceColumn="tranLocationId" DataSetColumn="tranLocationId" />
|
|||
|
|
<Mapping SourceColumn="dueDate" DataSetColumn="dueDate" />
|
|||
|
|
<Mapping SourceColumn="outStoreType" DataSetColumn="outStoreType" />
|
|||
|
|
<Mapping SourceColumn="phone1" DataSetColumn="phone1" />
|
|||
|
|
<Mapping SourceColumn="phone2" DataSetColumn="phone2" />
|
|||
|
|
<Mapping SourceColumn="owner" DataSetColumn="owner" />
|
|||
|
|
<Mapping SourceColumn="invoiceNo" DataSetColumn="invoiceNo" />
|
|||
|
|
<Mapping SourceColumn="invoicedBy" DataSetColumn="invoicedBy" />
|
|||
|
|
<Mapping SourceColumn="salesperson" DataSetColumn="salesperson" />
|
|||
|
|
<Mapping SourceColumn="sumPrice" DataSetColumn="sumPrice" />
|
|||
|
|
<Mapping SourceColumn="docNo" DataSetColumn="docNo" />
|
|||
|
|
<Mapping SourceColumn="复核人" DataSetColumn="复核人" />
|
|||
|
|
</Mappings>
|
|||
|
|
<Sources />
|
|||
|
|
</TableAdapter>
|
|||
|
|
</Tables>
|
|||
|
|
<Sources />
|
|||
|
|
</DataSource>
|
|||
|
|
</xs:appinfo>
|
|||
|
|
</xs:annotation>
|
|||
|
|
<xs:element name="deiniuWMSDataSet2" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:EnableTableAdapterManager="True" msprop:Generator_DataSetName="deiniuWMSDataSet2" msprop:Generator_UserDSName="deiniuWMSDataSet2">
|
|||
|
|
<xs:complexType>
|
|||
|
|
<xs:choice minOccurs="0" maxOccurs="unbounded">
|
|||
|
|
<xs:element name="v_tmsPickRequest" msprop:Generator_TableClassName="v_tmsPickRequestDataTable" msprop:Generator_TableVarName="tablev_tmsPickRequest" msprop:Generator_TablePropName="v_tmsPickRequest" msprop:Generator_RowDeletingName="v_tmsPickRequestRowDeleting" msprop:Generator_RowChangingName="v_tmsPickRequestRowChanging" msprop:Generator_RowEvHandlerName="v_tmsPickRequestRowChangeEventHandler" msprop:Generator_RowDeletedName="v_tmsPickRequestRowDeleted" msprop:Generator_UserTableName="v_tmsPickRequest" msprop:Generator_RowChangedName="v_tmsPickRequestRowChanged" msprop:Generator_RowEvArgName="v_tmsPickRequestRowChangeEvent" msprop:Generator_RowClassName="v_tmsPickRequestRow">
|
|||
|
|
<xs:complexType>
|
|||
|
|
<xs:sequence>
|
|||
|
|
<xs:element name="id" msprop:Generator_ColumnVarNameInTable="columnid" msprop:Generator_ColumnPropNameInRow="id" msprop:Generator_ColumnPropNameInTable="idColumn" msprop:Generator_UserColumnName="id" type="xs:int" />
|
|||
|
|
<xs:element name="transNo" msprop:Generator_ColumnVarNameInTable="columntransNo" msprop:Generator_ColumnPropNameInRow="transNo" msprop:Generator_ColumnPropNameInTable="transNoColumn" msprop:Generator_UserColumnName="transNo" minOccurs="0">
|
|||
|
|
<xs:simpleType>
|
|||
|
|
<xs:restriction base="xs:string">
|
|||
|
|
<xs:maxLength value="50" />
|
|||
|
|
</xs:restriction>
|
|||
|
|
</xs:simpleType>
|
|||
|
|
</xs:element>
|
|||
|
|
<xs:element name="pickOrderNo" msprop:Generator_ColumnVarNameInTable="columnpickOrderNo" msprop:Generator_ColumnPropNameInRow="pickOrderNo" msprop:Generator_ColumnPropNameInTable="pickOrderNoColumn" msprop:Generator_UserColumnName="pickOrderNo">
|
|||
|
|
<xs:simpleType>
|
|||
|
|
<xs:restriction base="xs:string">
|
|||
|
|
<xs:maxLength value="50" />
|
|||
|
|
</xs:restriction>
|
|||
|
|
</xs:simpleType>
|
|||
|
|
</xs:element>
|
|||
|
|
<xs:element name="waveOrder" msprop:Generator_ColumnVarNameInTable="columnwaveOrder" msprop:Generator_ColumnPropNameInRow="waveOrder" msprop:Generator_ColumnPropNameInTable="waveOrderColumn" msprop:Generator_UserColumnName="waveOrder" minOccurs="0">
|
|||
|
|
<xs:simpleType>
|
|||
|
|
<xs:restriction base="xs:string">
|
|||
|
|
<xs:maxLength value="50" />
|
|||
|
|
</xs:restriction>
|
|||
|
|
</xs:simpleType>
|
|||
|
|
</xs:element>
|
|||
|
|
<xs:element name="orderType" msprop:Generator_ColumnVarNameInTable="columnorderType" msprop:Generator_ColumnPropNameInRow="orderType" msprop:Generator_ColumnPropNameInTable="orderTypeColumn" msprop:Generator_UserColumnName="orderType" type="xs:int" minOccurs="0" />
|
|||
|
|
<xs:element name="orderTypeName" msprop:Generator_ColumnVarNameInTable="columnorderTypeName" msprop:Generator_ColumnPropNameInRow="orderTypeName" msprop:Generator_ColumnPropNameInTable="orderTypeNameColumn" msprop:Generator_UserColumnName="orderTypeName" minOccurs="0">
|
|||
|
|
<xs:simpleType>
|
|||
|
|
<xs:restriction base="xs:string">
|
|||
|
|
<xs:maxLength value="50" />
|
|||
|
|
</xs:restriction>
|
|||
|
|
</xs:simpleType>
|
|||
|
|
</xs:element>
|
|||
|
|
<xs:element name="customerId" msprop:Generator_ColumnVarNameInTable="columncustomerId" msprop:Generator_ColumnPropNameInRow="customerId" msprop:Generator_ColumnPropNameInTable="customerIdColumn" msprop:Generator_UserColumnName="customerId" minOccurs="0">
|
|||
|
|
<xs:simpleType>
|
|||
|
|
<xs:restriction base="xs:string">
|
|||
|
|
<xs:maxLength value="50" />
|
|||
|
|
</xs:restriction>
|
|||
|
|
</xs:simpleType>
|
|||
|
|
</xs:element>
|
|||
|
|
<xs:element name="customerName" msprop:Generator_ColumnVarNameInTable="columncustomerName" msprop:Generator_ColumnPropNameInRow="customerName" msprop:Generator_ColumnPropNameInTable="customerNameColumn" msprop:Generator_UserColumnName="customerName" minOccurs="0">
|
|||
|
|
<xs:simpleType>
|
|||
|
|
<xs:restriction base="xs:string">
|
|||
|
|
<xs:maxLength value="250" />
|
|||
|
|
</xs:restriction>
|
|||
|
|
</xs:simpleType>
|
|||
|
|
</xs:element>
|
|||
|
|
<xs:element name="custAddress" msprop:Generator_ColumnVarNameInTable="columncustAddress" msprop:Generator_ColumnPropNameInRow="custAddress" msprop:Generator_ColumnPropNameInTable="custAddressColumn" msprop:Generator_UserColumnName="custAddress" minOccurs="0">
|
|||
|
|
<xs:simpleType>
|
|||
|
|
<xs:restriction base="xs:string">
|
|||
|
|
<xs:maxLength value="250" />
|
|||
|
|
</xs:restriction>
|
|||
|
|
</xs:simpleType>
|
|||
|
|
</xs:element>
|
|||
|
|
<xs:element name="desk" msprop:Generator_ColumnVarNameInTable="columndesk" msprop:Generator_ColumnPropNameInRow="desk" msprop:Generator_ColumnPropNameInTable="deskColumn" msprop:Generator_UserColumnName="desk" type="xs:int" />
|
|||
|
|
<xs:element name="boxCnt" msprop:Generator_ColumnVarNameInTable="columnboxCnt" msprop:Generator_ColumnPropNameInRow="boxCnt" msprop:Generator_ColumnPropNameInTable="boxCntColumn" msprop:Generator_UserColumnName="boxCnt" type="xs:int" minOccurs="0" />
|
|||
|
|
<xs:element name="bulkCnt" msprop:Generator_ColumnVarNameInTable="columnbulkCnt" msprop:Generator_ColumnPropNameInRow="bulkCnt" msprop:Generator_ColumnPropNameInTable="bulkCntColumn" msprop:Generator_UserColumnName="bulkCnt" type="xs:decimal" minOccurs="0" />
|
|||
|
|
<xs:element name="volume" msprop:Generator_ColumnVarNameInTable="columnvolume" msprop:Generator_ColumnPropNameInRow="volume" msprop:Generator_ColumnPropNameInTable="volumeColumn" msprop:Generator_UserColumnName="volume" type="xs:decimal" minOccurs="0" />
|
|||
|
|
<xs:element name="weight" msprop:Generator_ColumnVarNameInTable="columnweight" msprop:Generator_ColumnPropNameInRow="weight" msprop:Generator_ColumnPropNameInTable="weightColumn" msprop:Generator_UserColumnName="weight" type="xs:decimal" minOccurs="0" />
|
|||
|
|
<xs:element name="state" msprop:Generator_ColumnVarNameInTable="columnstate" msprop:Generator_ColumnPropNameInRow="state" msprop:Generator_ColumnPropNameInTable="stateColumn" msprop:Generator_UserColumnName="state" type="xs:int" minOccurs="0" />
|
|||
|
|
<xs:element name="bulkPickState" msprop:Generator_ColumnVarNameInTable="columnbulkPickState" msprop:Generator_ColumnPropNameInRow="bulkPickState" msprop:Generator_ColumnPropNameInTable="bulkPickStateColumn" msprop:Generator_UserColumnName="bulkPickState" type="xs:int" minOccurs="0" />
|
|||
|
|
<xs:element name="batchPickState" msprop:Generator_ColumnVarNameInTable="columnbatchPickState" msprop:Generator_ColumnPropNameInRow="batchPickState" msprop:Generator_ColumnPropNameInTable="batchPickStateColumn" msprop:Generator_UserColumnName="batchPickState" type="xs:int" minOccurs="0" />
|
|||
|
|
<xs:element name="orderDate" msprop:Generator_ColumnVarNameInTable="columnorderDate" msprop:Generator_ColumnPropNameInRow="orderDate" msprop:Generator_ColumnPropNameInTable="orderDateColumn" msprop:Generator_UserColumnName="orderDate" type="xs:dateTime" minOccurs="0" />
|
|||
|
|
<xs:element name="description" msprop:Generator_ColumnVarNameInTable="columndescription" msprop:Generator_ColumnPropNameInRow="description" msprop:Generator_ColumnPropNameInTable="descriptionColumn" msprop:Generator_UserColumnName="description" minOccurs="0">
|
|||
|
|
<xs:simpleType>
|
|||
|
|
<xs:restriction base="xs:string">
|
|||
|
|
<xs:maxLength value="250" />
|
|||
|
|
</xs:restriction>
|
|||
|
|
</xs:simpleType>
|
|||
|
|
</xs:element>
|
|||
|
|
<xs:element name="pickedBy" msprop:Generator_ColumnVarNameInTable="columnpickedBy" msprop:Generator_ColumnPropNameInRow="pickedBy" msprop:Generator_ColumnPropNameInTable="pickedByColumn" msprop:Generator_UserColumnName="pickedBy" type="xs:int" minOccurs="0" />
|
|||
|
|
<xs:element name="pickedTime" msprop:Generator_ColumnVarNameInTable="columnpickedTime" msprop:Generator_ColumnPropNameInRow="pickedTime" msprop:Generator_ColumnPropNameInTable="pickedTimeColumn" msprop:Generator_UserColumnName="pickedTime" type="xs:dateTime" minOccurs="0" />
|
|||
|
|
<xs:element name="checkedBy" msprop:Generator_ColumnVarNameInTable="columncheckedBy" msprop:Generator_ColumnPropNameInRow="checkedBy" msprop:Generator_ColumnPropNameInTable="checkedByColumn" msprop:Generator_UserColumnName="checkedBy" type="xs:int" minOccurs="0" />
|
|||
|
|
<xs:element name="checkedTime" msprop:Generator_ColumnVarNameInTable="columncheckedTime" msprop:Generator_ColumnPropNameInRow="checkedTime" msprop:Generator_ColumnPropNameInTable="checkedTimeColumn" msprop:Generator_UserColumnName="checkedTime" type="xs:dateTime" minOccurs="0" />
|
|||
|
|
<xs:element name="waveStart" msprop:Generator_ColumnVarNameInTable="columnwaveStart" msprop:Generator_ColumnPropNameInRow="waveStart" msprop:Generator_ColumnPropNameInTable="waveStartColumn" msprop:Generator_UserColumnName="waveStart" type="xs:dateTime" minOccurs="0" />
|
|||
|
|
<xs:element name="waveEnd" msprop:Generator_ColumnVarNameInTable="columnwaveEnd" msprop:Generator_ColumnPropNameInRow="waveEnd" msprop:Generator_ColumnPropNameInTable="waveEndColumn" msprop:Generator_UserColumnName="waveEnd" type="xs:dateTime" minOccurs="0" />
|
|||
|
|
<xs:element name="priority" msprop:Generator_ColumnVarNameInTable="columnpriority" msprop:Generator_ColumnPropNameInRow="priority" msprop:Generator_ColumnPropNameInTable="priorityColumn" msprop:Generator_UserColumnName="priority" type="xs:int" minOccurs="0" />
|
|||
|
|
<xs:element name="operater" msprop:Generator_ColumnVarNameInTable="columnoperater" msprop:Generator_ColumnPropNameInRow="operater" msprop:Generator_ColumnPropNameInTable="operaterColumn" msprop:Generator_UserColumnName="operater" type="xs:int" minOccurs="0" />
|
|||
|
|
<xs:element name="dr" msprop:Generator_ColumnVarNameInTable="columndr" msprop:Generator_ColumnPropNameInRow="dr" msprop:Generator_ColumnPropNameInTable="drColumn" msprop:Generator_UserColumnName="dr" type="xs:boolean" minOccurs="0" />
|
|||
|
|
<xs:element name="createtime" msprop:Generator_ColumnVarNameInTable="columncreatetime" msprop:Generator_ColumnPropNameInRow="createtime" msprop:Generator_ColumnPropNameInTable="createtimeColumn" msprop:Generator_UserColumnName="createtime" type="xs:dateTime" minOccurs="0" />
|
|||
|
|
<xs:element name="lastmodified" msprop:Generator_ColumnVarNameInTable="columnlastmodified" msprop:Generator_ColumnPropNameInRow="lastmodified" msprop:Generator_ColumnPropNameInTable="lastmodifiedColumn" msprop:Generator_UserColumnName="lastmodified" type="xs:dateTime" minOccurs="0" />
|
|||
|
|
<xs:element name="lineId" msprop:Generator_ColumnVarNameInTable="columnlineId" msprop:Generator_ColumnPropNameInRow="lineId" msprop:Generator_ColumnPropNameInTable="lineIdColumn" msprop:Generator_UserColumnName="lineId" type="xs:int" minOccurs="0" />
|
|||
|
|
<xs:element name="lineOrder" msprop:Generator_ColumnVarNameInTable="columnlineOrder" msprop:Generator_ColumnPropNameInRow="lineOrder" msprop:Generator_ColumnPropNameInTable="lineOrderColumn" msprop:Generator_UserColumnName="lineOrder" type="xs:int" minOccurs="0" />
|
|||
|
|
<xs:element name="lineName" msprop:Generator_ColumnVarNameInTable="columnlineName" msprop:Generator_ColumnPropNameInRow="lineName" msprop:Generator_ColumnPropNameInTable="lineNameColumn" msprop:Generator_UserColumnName="lineName" minOccurs="0">
|
|||
|
|
<xs:simpleType>
|
|||
|
|
<xs:restriction base="xs:string">
|
|||
|
|
<xs:maxLength value="50" />
|
|||
|
|
</xs:restriction>
|
|||
|
|
</xs:simpleType>
|
|||
|
|
</xs:element>
|
|||
|
|
<xs:element name="lineDesc" msprop:Generator_ColumnVarNameInTable="columnlineDesc" msprop:Generator_ColumnPropNameInRow="lineDesc" msprop:Generator_ColumnPropNameInTable="lineDescColumn" msprop:Generator_UserColumnName="lineDesc" minOccurs="0">
|
|||
|
|
<xs:simpleType>
|
|||
|
|
<xs:restriction base="xs:string">
|
|||
|
|
<xs:maxLength value="250" />
|
|||
|
|
</xs:restriction>
|
|||
|
|
</xs:simpleType>
|
|||
|
|
</xs:element>
|
|||
|
|
<xs:element name="sumVol" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnsumVol" msprop:Generator_ColumnPropNameInRow="sumVol" msprop:Generator_ColumnPropNameInTable="sumVolColumn" msprop:Generator_UserColumnName="sumVol" type="xs:decimal" minOccurs="0" />
|
|||
|
|
<xs:element name="sumWeight" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnsumWeight" msprop:Generator_ColumnPropNameInRow="sumWeight" msprop:Generator_ColumnPropNameInTable="sumWeightColumn" msprop:Generator_UserColumnName="sumWeight" type="xs:decimal" minOccurs="0" />
|
|||
|
|
<xs:element name="bulkBox" msprop:Generator_ColumnVarNameInTable="columnbulkBox" msprop:Generator_ColumnPropNameInRow="bulkBox" msprop:Generator_ColumnPropNameInTable="bulkBoxColumn" msprop:Generator_UserColumnName="bulkBox" type="xs:int" minOccurs="0" />
|
|||
|
|
<xs:element name="bulkBag" msprop:Generator_ColumnVarNameInTable="columnbulkBag" msprop:Generator_ColumnPropNameInRow="bulkBag" msprop:Generator_ColumnPropNameInTable="bulkBagColumn" msprop:Generator_UserColumnName="bulkBag" type="xs:int" minOccurs="0" />
|
|||
|
|
<xs:element name="tranLocationId" msprop:Generator_ColumnVarNameInTable="columntranLocationId" msprop:Generator_ColumnPropNameInRow="tranLocationId" msprop:Generator_ColumnPropNameInTable="tranLocationIdColumn" msprop:Generator_UserColumnName="tranLocationId" minOccurs="0">
|
|||
|
|
<xs:simpleType>
|
|||
|
|
<xs:restriction base="xs:string">
|
|||
|
|
<xs:maxLength value="50" />
|
|||
|
|
</xs:restriction>
|
|||
|
|
</xs:simpleType>
|
|||
|
|
</xs:element>
|
|||
|
|
<xs:element name="dueDate" msprop:Generator_ColumnVarNameInTable="columndueDate" msprop:Generator_ColumnPropNameInRow="dueDate" msprop:Generator_ColumnPropNameInTable="dueDateColumn" msprop:Generator_UserColumnName="dueDate" type="xs:dateTime" minOccurs="0" />
|
|||
|
|
<xs:element name="outStoreType" msprop:Generator_ColumnVarNameInTable="columnoutStoreType" msprop:Generator_ColumnPropNameInRow="outStoreType" msprop:Generator_ColumnPropNameInTable="outStoreTypeColumn" msprop:Generator_UserColumnName="outStoreType" type="xs:int" minOccurs="0" />
|
|||
|
|
<xs:element name="phone1" msprop:Generator_ColumnVarNameInTable="columnphone1" msprop:Generator_ColumnPropNameInRow="phone1" msprop:Generator_ColumnPropNameInTable="phone1Column" msprop:Generator_UserColumnName="phone1" minOccurs="0">
|
|||
|
|
<xs:simpleType>
|
|||
|
|
<xs:restriction base="xs:string">
|
|||
|
|
<xs:maxLength value="50" />
|
|||
|
|
</xs:restriction>
|
|||
|
|
</xs:simpleType>
|
|||
|
|
</xs:element>
|
|||
|
|
<xs:element name="phone2" msprop:Generator_ColumnVarNameInTable="columnphone2" msprop:Generator_ColumnPropNameInRow="phone2" msprop:Generator_ColumnPropNameInTable="phone2Column" msprop:Generator_UserColumnName="phone2" minOccurs="0">
|
|||
|
|
<xs:simpleType>
|
|||
|
|
<xs:restriction base="xs:string">
|
|||
|
|
<xs:maxLength value="50" />
|
|||
|
|
</xs:restriction>
|
|||
|
|
</xs:simpleType>
|
|||
|
|
</xs:element>
|
|||
|
|
<xs:element name="owner" msprop:Generator_ColumnVarNameInTable="columnowner" msprop:Generator_ColumnPropNameInRow="owner" msprop:Generator_ColumnPropNameInTable="ownerColumn" msprop:Generator_UserColumnName="owner" minOccurs="0">
|
|||
|
|
<xs:simpleType>
|
|||
|
|
<xs:restriction base="xs:string">
|
|||
|
|
<xs:maxLength value="250" />
|
|||
|
|
</xs:restriction>
|
|||
|
|
</xs:simpleType>
|
|||
|
|
</xs:element>
|
|||
|
|
<xs:element name="invoiceNo" msprop:Generator_ColumnVarNameInTable="columninvoiceNo" msprop:Generator_ColumnPropNameInRow="invoiceNo" msprop:Generator_ColumnPropNameInTable="invoiceNoColumn" msprop:Generator_UserColumnName="invoiceNo" minOccurs="0">
|
|||
|
|
<xs:simpleType>
|
|||
|
|
<xs:restriction base="xs:string">
|
|||
|
|
<xs:maxLength value="50" />
|
|||
|
|
</xs:restriction>
|
|||
|
|
</xs:simpleType>
|
|||
|
|
</xs:element>
|
|||
|
|
<xs:element name="invoicedBy" msprop:Generator_ColumnVarNameInTable="columninvoicedBy" msprop:Generator_ColumnPropNameInRow="invoicedBy" msprop:Generator_ColumnPropNameInTable="invoicedByColumn" msprop:Generator_UserColumnName="invoicedBy" type="xs:int" minOccurs="0" />
|
|||
|
|
<xs:element name="salesperson" msprop:Generator_ColumnVarNameInTable="columnsalesperson" msprop:Generator_ColumnPropNameInRow="salesperson" msprop:Generator_ColumnPropNameInTable="salespersonColumn" msprop:Generator_UserColumnName="salesperson" minOccurs="0">
|
|||
|
|
<xs:simpleType>
|
|||
|
|
<xs:restriction base="xs:string">
|
|||
|
|
<xs:maxLength value="50" />
|
|||
|
|
</xs:restriction>
|
|||
|
|
</xs:simpleType>
|
|||
|
|
</xs:element>
|
|||
|
|
<xs:element name="sumPrice" msprop:Generator_ColumnVarNameInTable="columnsumPrice" msprop:Generator_ColumnPropNameInRow="sumPrice" msprop:Generator_ColumnPropNameInTable="sumPriceColumn" msprop:Generator_UserColumnName="sumPrice" type="xs:decimal" minOccurs="0" />
|
|||
|
|
<xs:element name="docNo" msprop:Generator_ColumnVarNameInTable="columndocNo" msprop:Generator_ColumnPropNameInRow="docNo" msprop:Generator_ColumnPropNameInTable="docNoColumn" msprop:Generator_UserColumnName="docNo" minOccurs="0">
|
|||
|
|
<xs:simpleType>
|
|||
|
|
<xs:restriction base="xs:string">
|
|||
|
|
<xs:maxLength value="50" />
|
|||
|
|
</xs:restriction>
|
|||
|
|
</xs:simpleType>
|
|||
|
|
</xs:element>
|
|||
|
|
<xs:element name="复核人" msprop:Generator_ColumnVarNameInTable="column复核人" msprop:Generator_ColumnPropNameInRow="复核人" msprop:Generator_ColumnPropNameInTable="复核人Column" msprop:Generator_UserColumnName="复核人" minOccurs="0">
|
|||
|
|
<xs:simpleType>
|
|||
|
|
<xs:restriction base="xs:string">
|
|||
|
|
<xs:maxLength value="10" />
|
|||
|
|
</xs:restriction>
|
|||
|
|
</xs:simpleType>
|
|||
|
|
</xs:element>
|
|||
|
|
</xs:sequence>
|
|||
|
|
</xs:complexType>
|
|||
|
|
</xs:element>
|
|||
|
|
</xs:choice>
|
|||
|
|
</xs:complexType>
|
|||
|
|
<xs:unique name="Constraint1" msdata:PrimaryKey="true">
|
|||
|
|
<xs:selector xpath=".//mstns:v_tmsPickRequest" />
|
|||
|
|
<xs:field xpath="mstns:pickOrderNo" />
|
|||
|
|
</xs:unique>
|
|||
|
|
</xs:element>
|
|||
|
|
</xs:schema>
|