374 lines
34 KiB
XML
374 lines
34 KiB
XML
|
<?xml version="1.0" encoding="utf-8"?>
|
|||
|
|
<xs:schema id="随货同行5" targetNamespace="http://tempuri.org/随货同行5.xsd" xmlns:mstns="http://tempuri.org/随货同行5.xsd" xmlns="http://tempuri.org/随货同行5.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_stockOutRequestPickTableAdapter" GeneratorDataComponentClassName="v_stockOutRequestPickTableAdapter" Name="v_stockOutRequestPick" UserDataComponentName="v_stockOutRequestPickTableAdapter">
|
|||
|
|
<MainSource>
|
|||
|
|
<DbSource ConnectionRef="deiniuWMSConnectionString1 (Settings)" DbObjectName="deiniuWMS.dbo.v_stockOutRequestPick" 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 pickOrderNo, waveOrder, pickOrderState, id, transNo, customerId, customerName, custAddress, desk, bulkBox, bulkBag, sumBoxCnt, tranLocationId, volume, weight, orderBulkPickState, orderBatchPickState, orderDate, pickedBy, pickedTime, waveStart, waveEnd, priority, seedsPickNo, invoicedBy, invoiceNo, docNo, invoicedByName, checkedByName, salesperson, checkedBy, goodsId, goodsName, goodsPickState, batch, count, bulkCount, batch1Count, batch2Count, boxcnt, productDate, validDate, manufacturer, spec, regeditCode, unit, type, barCode, goodsType, goodsTypeName, bulkPickState, batchPickState, bigCount, skuId, skuCode, ownerName, description, price, phone1, phone2, approvedBy, sumPrice, orderDesc, lineName, invoicePrintCnt FROM dbo.v_stockOutRequestPick</CommandText>
|
|||
|
|
<Parameters />
|
|||
|
|
</DbCommand>
|
|||
|
|
</SelectCommand>
|
|||
|
|
</DbSource>
|
|||
|
|
</MainSource>
|
|||
|
|
<Mappings>
|
|||
|
|
<Mapping SourceColumn="pickOrderNo" DataSetColumn="pickOrderNo" />
|
|||
|
|
<Mapping SourceColumn="waveOrder" DataSetColumn="waveOrder" />
|
|||
|
|
<Mapping SourceColumn="pickOrderState" DataSetColumn="pickOrderState" />
|
|||
|
|
<Mapping SourceColumn="id" DataSetColumn="id" />
|
|||
|
|
<Mapping SourceColumn="transNo" DataSetColumn="transNo" />
|
|||
|
|
<Mapping SourceColumn="customerId" DataSetColumn="customerId" />
|
|||
|
|
<Mapping SourceColumn="customerName" DataSetColumn="customerName" />
|
|||
|
|
<Mapping SourceColumn="custAddress" DataSetColumn="custAddress" />
|
|||
|
|
<Mapping SourceColumn="desk" DataSetColumn="desk" />
|
|||
|
|
<Mapping SourceColumn="bulkBox" DataSetColumn="bulkBox" />
|
|||
|
|
<Mapping SourceColumn="bulkBag" DataSetColumn="bulkBag" />
|
|||
|
|
<Mapping SourceColumn="sumBoxCnt" DataSetColumn="sumBoxCnt" />
|
|||
|
|
<Mapping SourceColumn="tranLocationId" DataSetColumn="tranLocationId" />
|
|||
|
|
<Mapping SourceColumn="volume" DataSetColumn="volume" />
|
|||
|
|
<Mapping SourceColumn="weight" DataSetColumn="weight" />
|
|||
|
|
<Mapping SourceColumn="orderBulkPickState" DataSetColumn="orderBulkPickState" />
|
|||
|
|
<Mapping SourceColumn="orderBatchPickState" DataSetColumn="orderBatchPickState" />
|
|||
|
|
<Mapping SourceColumn="orderDate" DataSetColumn="orderDate" />
|
|||
|
|
<Mapping SourceColumn="pickedBy" DataSetColumn="pickedBy" />
|
|||
|
|
<Mapping SourceColumn="pickedTime" DataSetColumn="pickedTime" />
|
|||
|
|
<Mapping SourceColumn="waveStart" DataSetColumn="waveStart" />
|
|||
|
|
<Mapping SourceColumn="waveEnd" DataSetColumn="waveEnd" />
|
|||
|
|
<Mapping SourceColumn="priority" DataSetColumn="priority" />
|
|||
|
|
<Mapping SourceColumn="seedsPickNo" DataSetColumn="seedsPickNo" />
|
|||
|
|
<Mapping SourceColumn="invoicedBy" DataSetColumn="invoicedBy" />
|
|||
|
|
<Mapping SourceColumn="invoiceNo" DataSetColumn="invoiceNo" />
|
|||
|
|
<Mapping SourceColumn="docNo" DataSetColumn="docNo" />
|
|||
|
|
<Mapping SourceColumn="invoicedByName" DataSetColumn="invoicedByName" />
|
|||
|
|
<Mapping SourceColumn="checkedByName" DataSetColumn="checkedByName" />
|
|||
|
|
<Mapping SourceColumn="salesperson" DataSetColumn="salesperson" />
|
|||
|
|
<Mapping SourceColumn="checkedBy" DataSetColumn="checkedBy" />
|
|||
|
|
<Mapping SourceColumn="goodsId" DataSetColumn="goodsId" />
|
|||
|
|
<Mapping SourceColumn="goodsName" DataSetColumn="goodsName" />
|
|||
|
|
<Mapping SourceColumn="goodsPickState" DataSetColumn="goodsPickState" />
|
|||
|
|
<Mapping SourceColumn="batch" DataSetColumn="batch" />
|
|||
|
|
<Mapping SourceColumn="count" DataSetColumn="count" />
|
|||
|
|
<Mapping SourceColumn="bulkCount" DataSetColumn="bulkCount" />
|
|||
|
|
<Mapping SourceColumn="batch1Count" DataSetColumn="batch1Count" />
|
|||
|
|
<Mapping SourceColumn="batch2Count" DataSetColumn="batch2Count" />
|
|||
|
|
<Mapping SourceColumn="boxcnt" DataSetColumn="boxcnt" />
|
|||
|
|
<Mapping SourceColumn="productDate" DataSetColumn="productDate" />
|
|||
|
|
<Mapping SourceColumn="validDate" DataSetColumn="validDate" />
|
|||
|
|
<Mapping SourceColumn="manufacturer" DataSetColumn="manufacturer" />
|
|||
|
|
<Mapping SourceColumn="spec" DataSetColumn="spec" />
|
|||
|
|
<Mapping SourceColumn="regeditCode" DataSetColumn="regeditCode" />
|
|||
|
|
<Mapping SourceColumn="unit" DataSetColumn="unit" />
|
|||
|
|
<Mapping SourceColumn="type" DataSetColumn="type" />
|
|||
|
|
<Mapping SourceColumn="barCode" DataSetColumn="barCode" />
|
|||
|
|
<Mapping SourceColumn="goodsType" DataSetColumn="goodsType" />
|
|||
|
|
<Mapping SourceColumn="goodsTypeName" DataSetColumn="goodsTypeName" />
|
|||
|
|
<Mapping SourceColumn="bulkPickState" DataSetColumn="bulkPickState" />
|
|||
|
|
<Mapping SourceColumn="batchPickState" DataSetColumn="batchPickState" />
|
|||
|
|
<Mapping SourceColumn="bigCount" DataSetColumn="bigCount" />
|
|||
|
|
<Mapping SourceColumn="skuId" DataSetColumn="skuId" />
|
|||
|
|
<Mapping SourceColumn="skuCode" DataSetColumn="skuCode" />
|
|||
|
|
<Mapping SourceColumn="ownerName" DataSetColumn="ownerName" />
|
|||
|
|
<Mapping SourceColumn="description" DataSetColumn="description" />
|
|||
|
|
<Mapping SourceColumn="price" DataSetColumn="price" />
|
|||
|
|
<Mapping SourceColumn="phone1" DataSetColumn="phone1" />
|
|||
|
|
<Mapping SourceColumn="phone2" DataSetColumn="phone2" />
|
|||
|
|
<Mapping SourceColumn="approvedBy" DataSetColumn="approvedBy" />
|
|||
|
|
<Mapping SourceColumn="sumPrice" DataSetColumn="sumPrice" />
|
|||
|
|
<Mapping SourceColumn="orderDesc" DataSetColumn="orderDesc" />
|
|||
|
|
<Mapping SourceColumn="lineName" DataSetColumn="lineName" />
|
|||
|
|
<Mapping SourceColumn="invoicePrintCnt" DataSetColumn="invoicePrintCnt" />
|
|||
|
|
</Mappings>
|
|||
|
|
<Sources />
|
|||
|
|
</TableAdapter>
|
|||
|
|
</Tables>
|
|||
|
|
<Sources />
|
|||
|
|
</DataSource>
|
|||
|
|
</xs:appinfo>
|
|||
|
|
</xs:annotation>
|
|||
|
|
<xs:element name="随货同行5" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:EnableTableAdapterManager="True" msprop:Generator_DataSetName="随货同行5" msprop:Generator_UserDSName="随货同行5">
|
|||
|
|
<xs:complexType>
|
|||
|
|
<xs:choice minOccurs="0" maxOccurs="unbounded">
|
|||
|
|
<xs:element name="v_stockOutRequestPick" msprop:Generator_TableClassName="v_stockOutRequestPickDataTable" msprop:Generator_TableVarName="tablev_stockOutRequestPick" msprop:Generator_TablePropName="v_stockOutRequestPick" msprop:Generator_RowDeletingName="v_stockOutRequestPickRowDeleting" msprop:Generator_RowChangingName="v_stockOutRequestPickRowChanging" msprop:Generator_RowEvHandlerName="v_stockOutRequestPickRowChangeEventHandler" msprop:Generator_RowDeletedName="v_stockOutRequestPickRowDeleted" msprop:Generator_UserTableName="v_stockOutRequestPick" msprop:Generator_RowChangedName="v_stockOutRequestPickRowChanged" msprop:Generator_RowEvArgName="v_stockOutRequestPickRowChangeEvent" msprop:Generator_RowClassName="v_stockOutRequestPickRow">
|
|||
|
|
<xs:complexType>
|
|||
|
|
<xs:sequence>
|
|||
|
|
<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="pickOrderState" msprop:Generator_ColumnVarNameInTable="columnpickOrderState" msprop:Generator_ColumnPropNameInRow="pickOrderState" msprop:Generator_ColumnPropNameInTable="pickOrderStateColumn" msprop:Generator_UserColumnName="pickOrderState" type="xs:int" minOccurs="0" />
|
|||
|
|
<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="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="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="sumBoxCnt" msprop:Generator_ColumnVarNameInTable="columnsumBoxCnt" msprop:Generator_ColumnPropNameInRow="sumBoxCnt" msprop:Generator_ColumnPropNameInTable="sumBoxCntColumn" msprop:Generator_UserColumnName="sumBoxCnt" 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="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="orderBulkPickState" msprop:Generator_ColumnVarNameInTable="columnorderBulkPickState" msprop:Generator_ColumnPropNameInRow="orderBulkPickState" msprop:Generator_ColumnPropNameInTable="orderBulkPickStateColumn" msprop:Generator_UserColumnName="orderBulkPickState" type="xs:int" minOccurs="0" />
|
|||
|
|
<xs:element name="orderBatchPickState" msprop:Generator_ColumnVarNameInTable="columnorderBatchPickState" msprop:Generator_ColumnPropNameInRow="orderBatchPickState" msprop:Generator_ColumnPropNameInTable="orderBatchPickStateColumn" msprop:Generator_UserColumnName="orderBatchPickState" 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="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="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="seedsPickNo" msprop:Generator_ColumnVarNameInTable="columnseedsPickNo" msprop:Generator_ColumnPropNameInRow="seedsPickNo" msprop:Generator_ColumnPropNameInTable="seedsPickNoColumn" msprop:Generator_UserColumnName="seedsPickNo" 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="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="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="invoicedByName" msprop:Generator_ColumnVarNameInTable="columninvoicedByName" msprop:Generator_ColumnPropNameInRow="invoicedByName" msprop:Generator_ColumnPropNameInTable="invoicedByNameColumn" msprop:Generator_UserColumnName="invoicedByName" minOccurs="0">
|
|||
|
|
<xs:simpleType>
|
|||
|
|
<xs:restriction base="xs:string">
|
|||
|
|
<xs:maxLength value="10" />
|
|||
|
|
</xs:restriction>
|
|||
|
|
</xs:simpleType>
|
|||
|
|
</xs:element>
|
|||
|
|
<xs:element name="checkedByName" msprop:Generator_ColumnVarNameInTable="columncheckedByName" msprop:Generator_ColumnPropNameInRow="checkedByName" msprop:Generator_ColumnPropNameInTable="checkedByNameColumn" msprop:Generator_UserColumnName="checkedByName" minOccurs="0">
|
|||
|
|
<xs:simpleType>
|
|||
|
|
<xs:restriction base="xs:string">
|
|||
|
|
<xs:maxLength value="10" />
|
|||
|
|
</xs:restriction>
|
|||
|
|
</xs:simpleType>
|
|||
|
|
</xs:element>
|
|||
|
|
<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="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="goodsId" msprop:Generator_ColumnVarNameInTable="columngoodsId" msprop:Generator_ColumnPropNameInRow="goodsId" msprop:Generator_ColumnPropNameInTable="goodsIdColumn" msprop:Generator_UserColumnName="goodsId" minOccurs="0">
|
|||
|
|
<xs:simpleType>
|
|||
|
|
<xs:restriction base="xs:string">
|
|||
|
|
<xs:maxLength value="50" />
|
|||
|
|
</xs:restriction>
|
|||
|
|
</xs:simpleType>
|
|||
|
|
</xs:element>
|
|||
|
|
<xs:element name="goodsName" msprop:Generator_ColumnVarNameInTable="columngoodsName" msprop:Generator_ColumnPropNameInRow="goodsName" msprop:Generator_ColumnPropNameInTable="goodsNameColumn" msprop:Generator_UserColumnName="goodsName" minOccurs="0">
|
|||
|
|
<xs:simpleType>
|
|||
|
|
<xs:restriction base="xs:string">
|
|||
|
|
<xs:maxLength value="120" />
|
|||
|
|
</xs:restriction>
|
|||
|
|
</xs:simpleType>
|
|||
|
|
</xs:element>
|
|||
|
|
<xs:element name="goodsPickState" msprop:Generator_ColumnVarNameInTable="columngoodsPickState" msprop:Generator_ColumnPropNameInRow="goodsPickState" msprop:Generator_ColumnPropNameInTable="goodsPickStateColumn" msprop:Generator_UserColumnName="goodsPickState" type="xs:int" minOccurs="0" />
|
|||
|
|
<xs:element name="batch" msprop:Generator_ColumnVarNameInTable="columnbatch" msprop:Generator_ColumnPropNameInRow="batch" msprop:Generator_ColumnPropNameInTable="batchColumn" msprop:Generator_UserColumnName="batch" minOccurs="0">
|
|||
|
|
<xs:simpleType>
|
|||
|
|
<xs:restriction base="xs:string">
|
|||
|
|
<xs:maxLength value="50" />
|
|||
|
|
</xs:restriction>
|
|||
|
|
</xs:simpleType>
|
|||
|
|
</xs:element>
|
|||
|
|
<xs:element name="count" msprop:Generator_ColumnVarNameInTable="columncount" msprop:Generator_ColumnPropNameInRow="count" msprop:Generator_ColumnPropNameInTable="countColumn" msprop:Generator_UserColumnName="count" type="xs:decimal" minOccurs="0" />
|
|||
|
|
<xs:element name="bulkCount" msprop:Generator_ColumnVarNameInTable="columnbulkCount" msprop:Generator_ColumnPropNameInRow="bulkCount" msprop:Generator_ColumnPropNameInTable="bulkCountColumn" msprop:Generator_UserColumnName="bulkCount" type="xs:decimal" minOccurs="0" />
|
|||
|
|
<xs:element name="batch1Count" msprop:Generator_ColumnVarNameInTable="columnbatch1Count" msprop:Generator_ColumnPropNameInRow="batch1Count" msprop:Generator_ColumnPropNameInTable="batch1CountColumn" msprop:Generator_UserColumnName="batch1Count" type="xs:decimal" minOccurs="0" />
|
|||
|
|
<xs:element name="batch2Count" msprop:Generator_ColumnVarNameInTable="columnbatch2Count" msprop:Generator_ColumnPropNameInRow="batch2Count" msprop:Generator_ColumnPropNameInTable="batch2CountColumn" msprop:Generator_UserColumnName="batch2Count" type="xs:decimal" minOccurs="0" />
|
|||
|
|
<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="productDate" msprop:Generator_ColumnVarNameInTable="columnproductDate" msprop:Generator_ColumnPropNameInRow="productDate" msprop:Generator_ColumnPropNameInTable="productDateColumn" msprop:Generator_UserColumnName="productDate" minOccurs="0">
|
|||
|
|
<xs:simpleType>
|
|||
|
|
<xs:restriction base="xs:string">
|
|||
|
|
<xs:maxLength value="50" />
|
|||
|
|
</xs:restriction>
|
|||
|
|
</xs:simpleType>
|
|||
|
|
</xs:element>
|
|||
|
|
<xs:element name="validDate" msprop:Generator_ColumnVarNameInTable="columnvalidDate" msprop:Generator_ColumnPropNameInRow="validDate" msprop:Generator_ColumnPropNameInTable="validDateColumn" msprop:Generator_UserColumnName="validDate" minOccurs="0">
|
|||
|
|
<xs:simpleType>
|
|||
|
|
<xs:restriction base="xs:string">
|
|||
|
|
<xs:maxLength value="50" />
|
|||
|
|
</xs:restriction>
|
|||
|
|
</xs:simpleType>
|
|||
|
|
</xs:element>
|
|||
|
|
<xs:element name="manufacturer" msprop:Generator_ColumnVarNameInTable="columnmanufacturer" msprop:Generator_ColumnPropNameInRow="manufacturer" msprop:Generator_ColumnPropNameInTable="manufacturerColumn" msprop:Generator_UserColumnName="manufacturer" minOccurs="0">
|
|||
|
|
<xs:simpleType>
|
|||
|
|
<xs:restriction base="xs:string">
|
|||
|
|
<xs:maxLength value="256" />
|
|||
|
|
</xs:restriction>
|
|||
|
|
</xs:simpleType>
|
|||
|
|
</xs:element>
|
|||
|
|
<xs:element name="spec" msprop:Generator_ColumnVarNameInTable="columnspec" msprop:Generator_ColumnPropNameInRow="spec" msprop:Generator_ColumnPropNameInTable="specColumn" msprop:Generator_UserColumnName="spec" minOccurs="0">
|
|||
|
|
<xs:simpleType>
|
|||
|
|
<xs:restriction base="xs:string">
|
|||
|
|
<xs:maxLength value="100" />
|
|||
|
|
</xs:restriction>
|
|||
|
|
</xs:simpleType>
|
|||
|
|
</xs:element>
|
|||
|
|
<xs:element name="regeditCode" msprop:Generator_ColumnVarNameInTable="columnregeditCode" msprop:Generator_ColumnPropNameInRow="regeditCode" msprop:Generator_ColumnPropNameInTable="regeditCodeColumn" msprop:Generator_UserColumnName="regeditCode" minOccurs="0">
|
|||
|
|
<xs:simpleType>
|
|||
|
|
<xs:restriction base="xs:string">
|
|||
|
|
<xs:maxLength value="72" />
|
|||
|
|
</xs:restriction>
|
|||
|
|
</xs:simpleType>
|
|||
|
|
</xs:element>
|
|||
|
|
<xs:element name="unit" msprop:Generator_ColumnVarNameInTable="columnunit" msprop:Generator_ColumnPropNameInRow="unit" msprop:Generator_ColumnPropNameInTable="unitColumn" msprop:Generator_UserColumnName="unit" minOccurs="0">
|
|||
|
|
<xs:simpleType>
|
|||
|
|
<xs:restriction base="xs:string">
|
|||
|
|
<xs:maxLength value="20" />
|
|||
|
|
</xs:restriction>
|
|||
|
|
</xs:simpleType>
|
|||
|
|
</xs:element>
|
|||
|
|
<xs:element name="type" msprop:Generator_ColumnVarNameInTable="columntype" msprop:Generator_ColumnPropNameInRow="type" msprop:Generator_ColumnPropNameInTable="typeColumn" msprop:Generator_UserColumnName="type" minOccurs="0">
|
|||
|
|
<xs:simpleType>
|
|||
|
|
<xs:restriction base="xs:string">
|
|||
|
|
<xs:maxLength value="30" />
|
|||
|
|
</xs:restriction>
|
|||
|
|
</xs:simpleType>
|
|||
|
|
</xs:element>
|
|||
|
|
<xs:element name="barCode" msprop:Generator_ColumnVarNameInTable="columnbarCode" msprop:Generator_ColumnPropNameInRow="barCode" msprop:Generator_ColumnPropNameInTable="barCodeColumn" msprop:Generator_UserColumnName="barCode" minOccurs="0">
|
|||
|
|
<xs:simpleType>
|
|||
|
|
<xs:restriction base="xs:string">
|
|||
|
|
<xs:maxLength value="30" />
|
|||
|
|
</xs:restriction>
|
|||
|
|
</xs:simpleType>
|
|||
|
|
</xs:element>
|
|||
|
|
<xs:element name="goodsType" msprop:Generator_ColumnVarNameInTable="columngoodsType" msprop:Generator_ColumnPropNameInRow="goodsType" msprop:Generator_ColumnPropNameInTable="goodsTypeColumn" msprop:Generator_UserColumnName="goodsType" type="xs:int" minOccurs="0" />
|
|||
|
|
<xs:element name="goodsTypeName" msprop:Generator_ColumnVarNameInTable="columngoodsTypeName" msprop:Generator_ColumnPropNameInRow="goodsTypeName" msprop:Generator_ColumnPropNameInTable="goodsTypeNameColumn" msprop:Generator_UserColumnName="goodsTypeName" minOccurs="0">
|
|||
|
|
<xs:simpleType>
|
|||
|
|
<xs:restriction base="xs:string">
|
|||
|
|
<xs:maxLength value="50" />
|
|||
|
|
</xs:restriction>
|
|||
|
|
</xs:simpleType>
|
|||
|
|
</xs:element>
|
|||
|
|
<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="bigCount" msprop:Generator_ColumnVarNameInTable="columnbigCount" msprop:Generator_ColumnPropNameInRow="bigCount" msprop:Generator_ColumnPropNameInTable="bigCountColumn" msprop:Generator_UserColumnName="bigCount" type="xs:int" minOccurs="0" />
|
|||
|
|
<xs:element name="skuId" msprop:Generator_ColumnVarNameInTable="columnskuId" msprop:Generator_ColumnPropNameInRow="skuId" msprop:Generator_ColumnPropNameInTable="skuIdColumn" msprop:Generator_UserColumnName="skuId" type="xs:int" minOccurs="0" />
|
|||
|
|
<xs:element name="skuCode" msprop:Generator_ColumnVarNameInTable="columnskuCode" msprop:Generator_ColumnPropNameInRow="skuCode" msprop:Generator_ColumnPropNameInTable="skuCodeColumn" msprop:Generator_UserColumnName="skuCode" minOccurs="0">
|
|||
|
|
<xs:simpleType>
|
|||
|
|
<xs:restriction base="xs:string">
|
|||
|
|
<xs:maxLength value="250" />
|
|||
|
|
</xs:restriction>
|
|||
|
|
</xs:simpleType>
|
|||
|
|
</xs:element>
|
|||
|
|
<xs:element name="ownerName" msprop:Generator_ColumnVarNameInTable="columnownerName" msprop:Generator_ColumnPropNameInRow="ownerName" msprop:Generator_ColumnPropNameInTable="ownerNameColumn" msprop:Generator_UserColumnName="ownerName" minOccurs="0">
|
|||
|
|
<xs:simpleType>
|
|||
|
|
<xs:restriction base="xs:string">
|
|||
|
|
<xs:maxLength value="128" />
|
|||
|
|
</xs:restriction>
|
|||
|
|
</xs:simpleType>
|
|||
|
|
</xs:element>
|
|||
|
|
<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="price" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnprice" msprop:Generator_ColumnPropNameInRow="price" msprop:Generator_ColumnPropNameInTable="priceColumn" msprop:Generator_UserColumnName="price" type="xs:decimal" 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="approvedBy" msprop:Generator_ColumnVarNameInTable="columnapprovedBy" msprop:Generator_ColumnPropNameInRow="approvedBy" msprop:Generator_ColumnPropNameInTable="approvedByColumn" msprop:Generator_UserColumnName="approvedBy" minOccurs="0">
|
|||
|
|
<xs:simpleType>
|
|||
|
|
<xs:restriction base="xs:string">
|
|||
|
|
<xs:maxLength value="200" />
|
|||
|
|
</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="orderDesc" msprop:Generator_ColumnVarNameInTable="columnorderDesc" msprop:Generator_ColumnPropNameInRow="orderDesc" msprop:Generator_ColumnPropNameInTable="orderDescColumn" msprop:Generator_UserColumnName="orderDesc" minOccurs="0">
|
|||
|
|
<xs:simpleType>
|
|||
|
|
<xs:restriction base="xs:string">
|
|||
|
|
<xs:maxLength value="250" />
|
|||
|
|
</xs:restriction>
|
|||
|
|
</xs:simpleType>
|
|||
|
|
</xs:element>
|
|||
|
|
<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="invoicePrintCnt" msprop:Generator_ColumnVarNameInTable="columninvoicePrintCnt" msprop:Generator_ColumnPropNameInRow="invoicePrintCnt" msprop:Generator_ColumnPropNameInTable="invoicePrintCntColumn" msprop:Generator_UserColumnName="invoicePrintCnt" type="xs:int" minOccurs="0" />
|
|||
|
|
</xs:sequence>
|
|||
|
|
</xs:complexType>
|
|||
|
|
</xs:element>
|
|||
|
|
</xs:choice>
|
|||
|
|
</xs:complexType>
|
|||
|
|
<xs:unique name="Constraint1" msdata:PrimaryKey="true">
|
|||
|
|
<xs:selector xpath=".//mstns:v_stockOutRequestPick" />
|
|||
|
|
<xs:field xpath="mstns:pickOrderNo" />
|
|||
|
|
</xs:unique>
|
|||
|
|
</xs:element>
|
|||
|
|
</xs:schema>
|