70 lines
9.2 KiB
XML
70 lines
9.2 KiB
XML
<?xml version="1.0" encoding="utf-8"?>
|
|
<xs:schema id="NewDataSet" xmlns="" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop">
|
|
<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>
|
|
</Connections>
|
|
<Tables>
|
|
</Tables>
|
|
<Sources>
|
|
</Sources>
|
|
</DataSource>
|
|
</xs:appinfo>
|
|
</xs:annotation>
|
|
<xs:element name="NewDataSet" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:Generator_UserDSName="NewDataSet" msprop:Generator_DataSetName="NewDataSet">
|
|
<xs:complexType>
|
|
<xs:choice minOccurs="0" maxOccurs="unbounded">
|
|
<xs:element name="Inventory" msprop:Generator_UserTableName="Inventory" msprop:Generator_RowDeletedName="InventoryRowDeleted" msprop:Generator_RowChangedName="InventoryRowChanged" msprop:Generator_RowClassName="InventoryRow" msprop:Generator_RowChangingName="InventoryRowChanging" msprop:Generator_RowEvArgName="InventoryRowChangeEvent" msprop:Generator_RowEvHandlerName="InventoryRowChangeEventHandler" msprop:Generator_TableClassName="InventoryDataTable" msprop:Generator_TableVarName="tableInventory" msprop:Generator_RowDeletingName="InventoryRowDeleting" msprop:Generator_TablePropName="Inventory">
|
|
<xs:complexType>
|
|
<xs:sequence>
|
|
<xs:element name="LT_O_PartWarehouse" msprop:Generator_UserColumnName="LT_O_PartWarehouse" msprop:Generator_ColumnVarNameInTable="columnLT_O_PartWarehouse" msprop:Generator_ColumnPropNameInRow="LT_O_PartWarehouse" msprop:Generator_ColumnPropNameInTable="LT_O_PartWarehouseColumn" type="xs:string" minOccurs="0" />
|
|
<xs:element name="LT_PartByWarehouseInventory_Label_MinStockLevel" msprop:Generator_UserColumnName="LT_PartByWarehouseInventory_Label_MinStockLevel" msprop:Generator_ColumnVarNameInTable="columnLT_PartByWarehouseInventory_Label_MinStockLevel" msprop:Generator_ColumnPropNameInRow="LT_PartByWarehouseInventory_Label_MinStockLevel" msprop:Generator_ColumnPropNameInTable="LT_PartByWarehouseInventory_Label_MinStockLevelColumn" type="xs:decimal" minOccurs="0" />
|
|
<xs:element name="LT_PartByWarehouseInventory_Label_ReorderQuantity" msprop:Generator_UserColumnName="LT_PartByWarehouseInventory_Label_ReorderQuantity" msprop:Generator_ColumnVarNameInTable="columnLT_PartByWarehouseInventory_Label_ReorderQuantity" msprop:Generator_ColumnPropNameInRow="LT_PartByWarehouseInventory_Label_ReorderQuantity" msprop:Generator_ColumnPropNameInTable="LT_PartByWarehouseInventory_Label_ReorderQuantityColumn" type="xs:decimal" minOccurs="0" />
|
|
<xs:element name="LT_O_Part" msprop:Generator_UserColumnName="LT_O_Part" msprop:Generator_ColumnVarNameInTable="columnLT_O_Part" msprop:Generator_ColumnPropNameInRow="LT_O_Part" msprop:Generator_ColumnPropNameInTable="LT_O_PartColumn" type="xs:string" minOccurs="0" />
|
|
<xs:element name="ID" msdata:DataType="System.Guid, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:Generator_UserColumnName="ID" msprop:Generator_ColumnVarNameInTable="columnID" msprop:Generator_ColumnPropNameInRow="ID" msprop:Generator_ColumnPropNameInTable="IDColumn" type="xs:string" />
|
|
<xs:element name="LT_O_PartAssembly" msprop:Generator_UserColumnName="LT_O_PartAssembly" msprop:Generator_ColumnVarNameInTable="columnLT_O_PartAssembly" msprop:Generator_ColumnPropNameInRow="LT_O_PartAssembly" msprop:Generator_ColumnPropNameInTable="LT_O_PartAssemblyColumn" type="xs:string" minOccurs="0" />
|
|
<xs:element name="LT_PartByWarehouseInventory_Label_QuantityOnHand" msprop:Generator_UserColumnName="LT_PartByWarehouseInventory_Label_QuantityOnHand" msprop:Generator_ColumnVarNameInTable="columnLT_PartByWarehouseInventory_Label_QuantityOnHand" msprop:Generator_ColumnPropNameInRow="LT_PartByWarehouseInventory_Label_QuantityOnHand" msprop:Generator_ColumnPropNameInTable="LT_PartByWarehouseInventory_Label_QuantityOnHandColumn" type="xs:decimal" minOccurs="0" />
|
|
<xs:element name="LT_O_PartCategory" msprop:Generator_UserColumnName="LT_O_PartCategory" msprop:Generator_ColumnVarNameInTable="columnLT_O_PartCategory" msprop:Generator_ColumnPropNameInRow="LT_O_PartCategory" msprop:Generator_ColumnPropNameInTable="LT_O_PartCategoryColumn" type="xs:string" minOccurs="0" />
|
|
<xs:element name="LT_Part_Label_Cost" msdata:Caption="LT_PartByWarehouseInventory_Label_QuantityOnHand" msprop:Generator_UserColumnName="LT_Part_Label_Cost" msprop:Generator_ColumnPropNameInRow="LT_Part_Label_Cost" msprop:Generator_ColumnVarNameInTable="columnLT_Part_Label_Cost" msprop:Generator_ColumnPropNameInTable="LT_Part_Label_CostColumn" type="xs:decimal" minOccurs="0" />
|
|
<xs:element name="LT_Part_Label_Retail" msdata:Caption="LT_PartByWarehouseInventory_Label_QuantityOnHand" msprop:Generator_UserColumnName="LT_Part_Label_Retail" msprop:Generator_ColumnPropNameInRow="LT_Part_Label_Retail" msprop:Generator_ColumnVarNameInTable="columnLT_Part_Label_Retail" msprop:Generator_ColumnPropNameInTable="LT_Part_Label_RetailColumn" type="xs:decimal" minOccurs="0" />
|
|
<xs:element name="LT_PartByWarehouseInventory_Label_QuantityOnOrder" msprop:Generator_UserColumnName="LT_PartByWarehouseInventory_Label_QuantityOnOrder" msprop:Generator_ColumnVarNameInTable="columnLT_PartByWarehouseInventory_Label_QuantityOnOrder" msprop:Generator_ColumnPropNameInRow="LT_PartByWarehouseInventory_Label_QuantityOnOrder" msprop:Generator_ColumnPropNameInTable="LT_PartByWarehouseInventory_Label_QuantityOnOrderColumn" type="xs:decimal" minOccurs="0" />
|
|
<xs:element name="LT_Part_Label_WholesalerID"
|
|
msprop:Generator_UserColumnName="LT_Part_Label_WholesalerID"
|
|
msprop:Generator_ColumnVarNameInTable="columnLT_Part_Label_WholesalerID"
|
|
msprop:Generator_ColumnPropNameInRow="LT_Part_Label_WholesalerID"
|
|
msprop:Generator_ColumnPropNameInTable="LT_Part_Label_WholesalerIDColumn"
|
|
type="xs:string"
|
|
minOccurs="0" />
|
|
<xs:element name="LT_Part_Label_AlternativeWholesalerID"
|
|
msprop:Generator_UserColumnName="LT_Part_Label_AlternativeWholesalerID"
|
|
msprop:Generator_ColumnVarNameInTable="columnLT_Part_Label_AlternativeWholesalerID"
|
|
msprop:Generator_ColumnPropNameInRow="LT_Part_Label_AlternativeWholesalerID"
|
|
msprop:Generator_ColumnPropNameInTable="LT_Part_Label_AlternativeWholesalerIDColumn"
|
|
type="xs:string"
|
|
minOccurs="0" />
|
|
|
|
</xs:sequence>
|
|
</xs:complexType>
|
|
</xs:element>
|
|
<xs:element name="SN" msprop:Generator_UserTableName="SN" msprop:Generator_RowDeletedName="SNRowDeleted" msprop:Generator_RowChangedName="SNRowChanged" msprop:Generator_RowClassName="SNRow" msprop:Generator_RowChangingName="SNRowChanging" msprop:Generator_RowEvArgName="SNRowChangeEvent" msprop:Generator_RowEvHandlerName="SNRowChangeEventHandler" msprop:Generator_TableClassName="SNDataTable" msprop:Generator_TableVarName="tableSN" msprop:Generator_RowDeletingName="SNRowDeleting" msprop:Generator_TablePropName="SN">
|
|
<xs:complexType>
|
|
<xs:sequence>
|
|
<xs:element name="PartByWarehouseInventoryID" msdata:DataType="System.Guid, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:Generator_UserColumnName="PartByWarehouseInventoryID" msprop:Generator_ColumnVarNameInTable="columnPartByWarehouseInventoryID" msprop:Generator_ColumnPropNameInRow="PartByWarehouseInventoryID" msprop:Generator_ColumnPropNameInTable="PartByWarehouseInventoryIDColumn" type="xs:string" />
|
|
<xs:element name="LT_Common_Label_SerialNumber" msprop:Generator_UserColumnName="LT_Common_Label_SerialNumber" msprop:Generator_ColumnVarNameInTable="columnLT_Common_Label_SerialNumber" msprop:Generator_ColumnPropNameInRow="LT_Common_Label_SerialNumber" msprop:Generator_ColumnPropNameInTable="LT_Common_Label_SerialNumberColumn" type="xs:string" minOccurs="0" />
|
|
</xs:sequence>
|
|
</xs:complexType>
|
|
</xs:element>
|
|
</xs:choice>
|
|
</xs:complexType>
|
|
<xs:unique name="InventKey" msdata:PrimaryKey="true">
|
|
<xs:selector xpath=".//Inventory" />
|
|
<xs:field xpath="ID" />
|
|
</xs:unique>
|
|
</xs:element>
|
|
<xs:annotation>
|
|
<xs:appinfo>
|
|
<msdata:Relationship name="InventorySN" msdata:parent="Inventory" msdata:child="SN" msdata:parentkey="ID" msdata:childkey="PartByWarehouseInventoryID" msprop:Generator_UserRelationName="InventorySN" msprop:Generator_RelationVarName="relationInventorySN" msprop:Generator_UserChildTable="SN" msprop:Generator_UserParentTable="Inventory" msprop:Generator_ParentPropName="InventoryRow" msprop:Generator_ChildPropName="GetSNRows" />
|
|
</xs:appinfo>
|
|
</xs:annotation>
|
|
</xs:schema> |