123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354 |
- <?xml version="1.0" encoding="utf-8"?>
- <xs:schema id="dsFrmIndentBillOnNet" targetNamespace="http://tempuri.org/dsFrmIndentBillOnNet.xsd" xmlns:mstns="http://tempuri.org/dsFrmIndentBillOnNet.xsd" xmlns="http://tempuri.org/dsFrmIndentBillOnNet.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" GeneratorFunctionsComponentClassName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" UserFunctionsComponentName="QueriesTableAdapter" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
- <Connections>
- <Connection AppSettingsObjectName="Settings" AppSettingsPropertyName="sunroxm05_224ceecd_ce81_47a9_881d_efce7397482e_ConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="sunroxm05_224ceecd_ce81_47a9_881d_efce7397482e_ConnectionString (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.Properties.Settings.GlobalReference.Default.sunroxm05_224ceecd_ce81_47a9_881d_efce7397482e_ConnectionString" Provider="System.Data.SqlClient" />
- </Connections>
- <Tables>
- <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="IndentBillOnNetTableAdapter" GeneratorDataComponentClassName="IndentBillOnNetTableAdapter" Name="IndentBillOnNet" UserDataComponentName="IndentBillOnNetTableAdapter">
- <MainSource>
- <DbSource ConnectionRef="sunroxm05_224ceecd_ce81_47a9_881d_efce7397482e_ConnectionString (Settings)" DbObjectType="Unknown" 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="false" UserGetMethodName="GetData" UserSourceName="Fill">
- <SelectCommand>
- <DbCommand CommandType="Text" ModifiedByUser="true">
- <CommandText>
- SELECT IndentBillOnNet.*, Customer.No_Customer, Customer.Name_Customer, Customer.ShortName_Customer, Customer.Type_Customer,
- Customer.LastDiscount_Customer, Customer.PostalCode_Customer, ISNULL(b.Name_User, '') AS Name_Assessor, Customer.ID_Creator As CustomerCreator
- FROM IndentBillOnNet
- LEFT JOIN Customer ON Customer.ID_Customer = IndentBillOnNet.ID_Customer
- LEFT JOIN AppUser b ON b.ID_User = IndentBillOnNet.ID_Assessor
- WHERE No_IndentBillOnNet >= (case DataLength('IBN201904010003') When 0 Then No_IndentBillOnNet Else 'IBN201904010003' End) And No_IndentBillOnNet <= (case DataLength('IBN201904010003') When 0 Then No_IndentBillOnNet Else 'IBN201904010003' End)</CommandText>
- <Parameters />
- </DbCommand>
- </SelectCommand>
- </DbSource>
- </MainSource>
- <Mappings>
- <Mapping SourceColumn="ID_IndentBillOnNet" DataSetColumn="ID_IndentBillOnNet" />
- <Mapping SourceColumn="No_IndentBillOnNet" DataSetColumn="No_IndentBillOnNet" />
- <Mapping SourceColumn="Date_IndentBillOnNet" DataSetColumn="Date_IndentBillOnNet" />
- <Mapping SourceColumn="ID_Customer" DataSetColumn="ID_Customer" />
- <Mapping SourceColumn="GetMethod_IndentBillOnNet" DataSetColumn="GetMethod_IndentBillOnNet" />
- <Mapping SourceColumn="Name_Linkman" DataSetColumn="Name_Linkman" />
- <Mapping SourceColumn="Tel_IndentBillOnNet" DataSetColumn="Tel_IndentBillOnNet" />
- <Mapping SourceColumn="Fax_IndentBillOnNet" DataSetColumn="Fax_IndentBillOnNet" />
- <Mapping SourceColumn="SendAddr_IndentBillOnNet" DataSetColumn="SendAddr_IndentBillOnNet" />
- <Mapping SourceColumn="InvoiceAddress_Company" DataSetColumn="InvoiceAddress_Company" />
- <Mapping SourceColumn="InvoiceTitle_Company" DataSetColumn="InvoiceTitle_Company" />
- <Mapping SourceColumn="TaxCurrency_IndentBillOnNet" DataSetColumn="TaxCurrency_IndentBillOnNet" />
- <Mapping SourceColumn="Currency_IndentBillOnNet" DataSetColumn="Currency_IndentBillOnNet" />
- <Mapping SourceColumn="Disable_IndentBillOnNet" DataSetColumn="Disable_IndentBillOnNet" />
- <Mapping SourceColumn="Amount_IndentBillOnNet" DataSetColumn="Amount_IndentBillOnNet" />
- <Mapping SourceColumn="GoodsAmount_IndentBillOnNet" DataSetColumn="GoodsAmount_IndentBillOnNet" />
- <Mapping SourceColumn="TaxAmount_IndentBillOnNet" DataSetColumn="TaxAmount_IndentBillOnNet" />
- <Mapping SourceColumn="Comment_IndentBillOnNet" DataSetColumn="Comment_IndentBillOnNet" />
- <Mapping SourceColumn="CreateDate_IndentBillOnNet" DataSetColumn="CreateDate_IndentBillOnNet" />
- <Mapping SourceColumn="ID_Assessor" DataSetColumn="ID_Assessor" />
- <Mapping SourceColumn="AssessDate_IndentBillOnNet" DataSetColumn="AssessDate_IndentBillOnNet" />
- <Mapping SourceColumn="LastModUser_IndentBillOnNet" DataSetColumn="LastModUser_IndentBillOnNet" />
- <Mapping SourceColumn="LastModDate_IndentBillOnNet" DataSetColumn="LastModDate_IndentBillOnNet" />
- <Mapping SourceColumn="DeleteUser_IndentBillOnNet" DataSetColumn="DeleteUser_IndentBillOnNet" />
- <Mapping SourceColumn="DeleteDate_IndentBillOnNet" DataSetColumn="DeleteDate_IndentBillOnNet" />
- <Mapping SourceColumn="FeedbackComment_IndentBillOnNet" DataSetColumn="FeedbackComment_IndentBillOnNet" />
- <Mapping SourceColumn="Name_CustomerAccount" DataSetColumn="Name_CustomerAccount" />
- <Mapping SourceColumn="Postcode_IndentBillOnNet" DataSetColumn="Postcode_IndentBillOnNet" />
- <Mapping SourceColumn="No_Customer" DataSetColumn="No_Customer" />
- <Mapping SourceColumn="Name_Customer" DataSetColumn="Name_Customer" />
- <Mapping SourceColumn="ShortName_Customer" DataSetColumn="ShortName_Customer" />
- <Mapping SourceColumn="Type_Customer" DataSetColumn="Type_Customer" />
- <Mapping SourceColumn="LastDiscount_Customer" DataSetColumn="LastDiscount_Customer" />
- <Mapping SourceColumn="PostalCode_Customer" DataSetColumn="PostalCode_Customer" />
- <Mapping SourceColumn="Name_Assessor" DataSetColumn="Name_Assessor" />
- <Mapping SourceColumn="CustomerCreator" DataSetColumn="CustomerCreator" />
- </Mappings>
- <Sources />
- </TableAdapter>
- <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="IndentBillOnNetProductTableAdapter" GeneratorDataComponentClassName="IndentBillOnNetProductTableAdapter" Name="IndentBillOnNetProduct" UserDataComponentName="IndentBillOnNetProductTableAdapter">
- <MainSource>
- <DbSource ConnectionRef="sunroxm05_224ceecd_ce81_47a9_881d_efce7397482e_ConnectionString (Settings)" DbObjectType="Unknown" 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="false" UserGetMethodName="GetData" UserSourceName="Fill">
- <SelectCommand>
- <DbCommand CommandType="Text" ModifiedByUser="true">
- <CommandText> SELECT IndentBillOnNetProduct.*,No_IndentBillOnNet,Product.No_Product, Product.Name_Product, Product.Unit_Product,
- (IndentBillOnNetProduct.Quantity_IndentBillOnNetProduct * IndentBillOnNetProduct.UnitPrice_IndentBillOnNetProduct) AS Amount_IndentBillOnNetProduct ,No_IndentBillOnNet
- FROM IndentBillOnNetProduct
- LEFT JOIN Product ON Product.ID_Product = IndentBillOnNetProduct.ID_Product
- Left Join IndentBillOnNet On IndentBillOnNet.ID_IndentBillOnNet = IndentBillOnNetProduct.ID_IndentBillOnNet
- WHERE No_IndentBillOnNet >= (case DataLength('IBN201904010003') When 0 Then No_IndentBillOnNet Else 'IBN201904010003' End) And No_IndentBillOnNet <= (case DataLength('IBN201904010003') When 0 Then No_IndentBillOnNet Else 'IBN201904010003' End)
- </CommandText>
- <Parameters />
- </DbCommand>
- </SelectCommand>
- </DbSource>
- </MainSource>
- <Mappings>
- <Mapping SourceColumn="ID_IndentBillOnNetProduct" DataSetColumn="ID_IndentBillOnNetProduct" />
- <Mapping SourceColumn="No_IndentBillOnNetProduct" DataSetColumn="No_IndentBillOnNetProduct" />
- <Mapping SourceColumn="ID_IndentBillOnNet" DataSetColumn="ID_IndentBillOnNet" />
- <Mapping SourceColumn="ID_Product" DataSetColumn="ID_Product" />
- <Mapping SourceColumn="Quantity_IndentBillOnNetProduct" DataSetColumn="Quantity_IndentBillOnNetProduct" />
- <Mapping SourceColumn="UnitPrice_IndentBillOnNetProduct" DataSetColumn="UnitPrice_IndentBillOnNetProduct" />
- <Mapping SourceColumn="Comment_IndentBillOnNetProduct" DataSetColumn="Comment_IndentBillOnNetProduct" />
- <Mapping SourceColumn="Amount_SaleBill" DataSetColumn="Amount_SaleBill" />
- <Mapping SourceColumn="No_IndentBillOnNet" DataSetColumn="No_IndentBillOnNet" />
- <Mapping SourceColumn="No_Product" DataSetColumn="No_Product" />
- <Mapping SourceColumn="Name_Product" DataSetColumn="Name_Product" />
- <Mapping SourceColumn="Unit_Product" DataSetColumn="Unit_Product" />
- <Mapping SourceColumn="Amount_IndentBillOnNetProduct" DataSetColumn="Amount_IndentBillOnNetProduct" />
- <Mapping SourceColumn="No_IndentBillOnNet1" DataSetColumn="No_IndentBillOnNet1" />
- </Mappings>
- <Sources />
- </TableAdapter>
- </Tables>
- <Sources />
- </DataSource>
- </xs:appinfo>
- </xs:annotation>
- <xs:element name="dsFrmIndentBillOnNet" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:EnableTableAdapterManager="true" msprop:Generator_DataSetName="dsFrmIndentBillOnNet" msprop:Generator_UserDSName="dsFrmIndentBillOnNet">
- <xs:complexType>
- <xs:choice minOccurs="0" maxOccurs="unbounded">
- <xs:element name="IndentBillOnNet" msprop:Generator_TableClassName="IndentBillOnNetDataTable" msprop:Generator_TableVarName="tableIndentBillOnNet" msprop:Generator_TablePropName="IndentBillOnNet" msprop:Generator_RowDeletingName="IndentBillOnNetRowDeleting" msprop:Generator_RowChangingName="IndentBillOnNetRowChanging" msprop:Generator_RowEvHandlerName="IndentBillOnNetRowChangeEventHandler" msprop:Generator_RowDeletedName="IndentBillOnNetRowDeleted" msprop:Generator_UserTableName="IndentBillOnNet" msprop:Generator_RowChangedName="IndentBillOnNetRowChanged" msprop:Generator_RowEvArgName="IndentBillOnNetRowChangeEvent" msprop:Generator_RowClassName="IndentBillOnNetRow">
- <xs:complexType>
- <xs:sequence>
- <xs:element name="ID_IndentBillOnNet" msdata:DataType="System.Guid, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:Generator_ColumnVarNameInTable="columnID_IndentBillOnNet" msprop:Generator_ColumnPropNameInRow="ID_IndentBillOnNet" msprop:Generator_ColumnPropNameInTable="ID_IndentBillOnNetColumn" msprop:Generator_UserColumnName="ID_IndentBillOnNet" type="xs:string" />
- <xs:element name="No_IndentBillOnNet" msprop:Generator_ColumnVarNameInTable="columnNo_IndentBillOnNet" msprop:Generator_ColumnPropNameInRow="No_IndentBillOnNet" msprop:Generator_ColumnPropNameInTable="No_IndentBillOnNetColumn" msprop:Generator_UserColumnName="No_IndentBillOnNet">
- <xs:simpleType>
- <xs:restriction base="xs:string">
- <xs:maxLength value="64" />
- </xs:restriction>
- </xs:simpleType>
- </xs:element>
- <xs:element name="Date_IndentBillOnNet" msprop:Generator_ColumnVarNameInTable="columnDate_IndentBillOnNet" msprop:Generator_ColumnPropNameInRow="Date_IndentBillOnNet" msprop:Generator_ColumnPropNameInTable="Date_IndentBillOnNetColumn" msprop:Generator_UserColumnName="Date_IndentBillOnNet" type="xs:dateTime" />
- <xs:element name="ID_Customer" msdata:DataType="System.Guid, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:Generator_ColumnVarNameInTable="columnID_Customer" msprop:Generator_ColumnPropNameInRow="ID_Customer" msprop:Generator_ColumnPropNameInTable="ID_CustomerColumn" msprop:Generator_UserColumnName="ID_Customer" type="xs:string" />
- <xs:element name="GetMethod_IndentBillOnNet" msprop:Generator_ColumnVarNameInTable="columnGetMethod_IndentBillOnNet" msprop:Generator_ColumnPropNameInRow="GetMethod_IndentBillOnNet" msprop:Generator_ColumnPropNameInTable="GetMethod_IndentBillOnNetColumn" msprop:Generator_UserColumnName="GetMethod_IndentBillOnNet" minOccurs="0">
- <xs:simpleType>
- <xs:restriction base="xs:string">
- <xs:maxLength value="64" />
- </xs:restriction>
- </xs:simpleType>
- </xs:element>
- <xs:element name="Name_Linkman" msprop:Generator_ColumnVarNameInTable="columnName_Linkman" msprop:Generator_ColumnPropNameInRow="Name_Linkman" msprop:Generator_ColumnPropNameInTable="Name_LinkmanColumn" msprop:Generator_UserColumnName="Name_Linkman" minOccurs="0">
- <xs:simpleType>
- <xs:restriction base="xs:string">
- <xs:maxLength value="64" />
- </xs:restriction>
- </xs:simpleType>
- </xs:element>
- <xs:element name="Tel_IndentBillOnNet" msprop:Generator_ColumnVarNameInTable="columnTel_IndentBillOnNet" msprop:Generator_ColumnPropNameInRow="Tel_IndentBillOnNet" msprop:Generator_ColumnPropNameInTable="Tel_IndentBillOnNetColumn" msprop:Generator_UserColumnName="Tel_IndentBillOnNet" minOccurs="0">
- <xs:simpleType>
- <xs:restriction base="xs:string">
- <xs:maxLength value="128" />
- </xs:restriction>
- </xs:simpleType>
- </xs:element>
- <xs:element name="Fax_IndentBillOnNet" msprop:Generator_ColumnVarNameInTable="columnFax_IndentBillOnNet" msprop:Generator_ColumnPropNameInRow="Fax_IndentBillOnNet" msprop:Generator_ColumnPropNameInTable="Fax_IndentBillOnNetColumn" msprop:Generator_UserColumnName="Fax_IndentBillOnNet" minOccurs="0">
- <xs:simpleType>
- <xs:restriction base="xs:string">
- <xs:maxLength value="128" />
- </xs:restriction>
- </xs:simpleType>
- </xs:element>
- <xs:element name="SendAddr_IndentBillOnNet" msprop:Generator_ColumnVarNameInTable="columnSendAddr_IndentBillOnNet" msprop:Generator_ColumnPropNameInRow="SendAddr_IndentBillOnNet" msprop:Generator_ColumnPropNameInTable="SendAddr_IndentBillOnNetColumn" msprop:Generator_UserColumnName="SendAddr_IndentBillOnNet" minOccurs="0">
- <xs:simpleType>
- <xs:restriction base="xs:string">
- <xs:maxLength value="256" />
- </xs:restriction>
- </xs:simpleType>
- </xs:element>
- <xs:element name="InvoiceAddress_Company" msprop:Generator_ColumnVarNameInTable="columnInvoiceAddress_Company" msprop:Generator_ColumnPropNameInRow="InvoiceAddress_Company" msprop:Generator_ColumnPropNameInTable="InvoiceAddress_CompanyColumn" msprop:Generator_UserColumnName="InvoiceAddress_Company" minOccurs="0">
- <xs:simpleType>
- <xs:restriction base="xs:string">
- <xs:maxLength value="256" />
- </xs:restriction>
- </xs:simpleType>
- </xs:element>
- <xs:element name="InvoiceTitle_Company" msprop:Generator_ColumnVarNameInTable="columnInvoiceTitle_Company" msprop:Generator_ColumnPropNameInRow="InvoiceTitle_Company" msprop:Generator_ColumnPropNameInTable="InvoiceTitle_CompanyColumn" msprop:Generator_UserColumnName="InvoiceTitle_Company" minOccurs="0">
- <xs:simpleType>
- <xs:restriction base="xs:string">
- <xs:maxLength value="64" />
- </xs:restriction>
- </xs:simpleType>
- </xs:element>
- <xs:element name="TaxCurrency_IndentBillOnNet" msprop:Generator_ColumnVarNameInTable="columnTaxCurrency_IndentBillOnNet" msprop:Generator_ColumnPropNameInRow="TaxCurrency_IndentBillOnNet" msprop:Generator_ColumnPropNameInTable="TaxCurrency_IndentBillOnNetColumn" msprop:Generator_UserColumnName="TaxCurrency_IndentBillOnNet" minOccurs="0">
- <xs:simpleType>
- <xs:restriction base="xs:string">
- <xs:maxLength value="64" />
- </xs:restriction>
- </xs:simpleType>
- </xs:element>
- <xs:element name="Currency_IndentBillOnNet" msprop:Generator_ColumnVarNameInTable="columnCurrency_IndentBillOnNet" msprop:Generator_ColumnPropNameInRow="Currency_IndentBillOnNet" msprop:Generator_ColumnPropNameInTable="Currency_IndentBillOnNetColumn" msprop:Generator_UserColumnName="Currency_IndentBillOnNet" minOccurs="0">
- <xs:simpleType>
- <xs:restriction base="xs:string">
- <xs:maxLength value="64" />
- </xs:restriction>
- </xs:simpleType>
- </xs:element>
- <xs:element name="Disable_IndentBillOnNet" msprop:Generator_ColumnVarNameInTable="columnDisable_IndentBillOnNet" msprop:Generator_ColumnPropNameInRow="Disable_IndentBillOnNet" msprop:Generator_ColumnPropNameInTable="Disable_IndentBillOnNetColumn" msprop:Generator_UserColumnName="Disable_IndentBillOnNet" type="xs:boolean" minOccurs="0" />
- <xs:element name="Amount_IndentBillOnNet" msprop:Generator_ColumnVarNameInTable="columnAmount_IndentBillOnNet" msprop:Generator_ColumnPropNameInRow="Amount_IndentBillOnNet" msprop:Generator_ColumnPropNameInTable="Amount_IndentBillOnNetColumn" msprop:Generator_UserColumnName="Amount_IndentBillOnNet" type="xs:decimal" />
- <xs:element name="GoodsAmount_IndentBillOnNet" msprop:Generator_ColumnVarNameInTable="columnGoodsAmount_IndentBillOnNet" msprop:Generator_ColumnPropNameInRow="GoodsAmount_IndentBillOnNet" msprop:Generator_ColumnPropNameInTable="GoodsAmount_IndentBillOnNetColumn" msprop:Generator_UserColumnName="GoodsAmount_IndentBillOnNet" type="xs:decimal" />
- <xs:element name="TaxAmount_IndentBillOnNet" msprop:Generator_ColumnVarNameInTable="columnTaxAmount_IndentBillOnNet" msprop:Generator_ColumnPropNameInRow="TaxAmount_IndentBillOnNet" msprop:Generator_ColumnPropNameInTable="TaxAmount_IndentBillOnNetColumn" msprop:Generator_UserColumnName="TaxAmount_IndentBillOnNet" type="xs:decimal" />
- <xs:element name="Comment_IndentBillOnNet" msprop:Generator_ColumnVarNameInTable="columnComment_IndentBillOnNet" msprop:Generator_ColumnPropNameInRow="Comment_IndentBillOnNet" msprop:Generator_ColumnPropNameInTable="Comment_IndentBillOnNetColumn" msprop:Generator_UserColumnName="Comment_IndentBillOnNet" minOccurs="0">
- <xs:simpleType>
- <xs:restriction base="xs:string">
- <xs:maxLength value="256" />
- </xs:restriction>
- </xs:simpleType>
- </xs:element>
- <xs:element name="CreateDate_IndentBillOnNet" msprop:Generator_ColumnVarNameInTable="columnCreateDate_IndentBillOnNet" msprop:Generator_ColumnPropNameInRow="CreateDate_IndentBillOnNet" msprop:Generator_ColumnPropNameInTable="CreateDate_IndentBillOnNetColumn" msprop:Generator_UserColumnName="CreateDate_IndentBillOnNet" type="xs:dateTime" />
- <xs:element name="ID_Assessor" msdata:DataType="System.Guid, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:Generator_ColumnVarNameInTable="columnID_Assessor" msprop:Generator_ColumnPropNameInRow="ID_Assessor" msprop:Generator_ColumnPropNameInTable="ID_AssessorColumn" msprop:Generator_UserColumnName="ID_Assessor" type="xs:string" minOccurs="0" />
- <xs:element name="AssessDate_IndentBillOnNet" msprop:Generator_ColumnVarNameInTable="columnAssessDate_IndentBillOnNet" msprop:Generator_ColumnPropNameInRow="AssessDate_IndentBillOnNet" msprop:Generator_ColumnPropNameInTable="AssessDate_IndentBillOnNetColumn" msprop:Generator_UserColumnName="AssessDate_IndentBillOnNet" type="xs:dateTime" minOccurs="0" />
- <xs:element name="LastModUser_IndentBillOnNet" msdata:DataType="System.Guid, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:Generator_ColumnVarNameInTable="columnLastModUser_IndentBillOnNet" msprop:Generator_ColumnPropNameInRow="LastModUser_IndentBillOnNet" msprop:Generator_ColumnPropNameInTable="LastModUser_IndentBillOnNetColumn" msprop:Generator_UserColumnName="LastModUser_IndentBillOnNet" type="xs:string" minOccurs="0" />
- <xs:element name="LastModDate_IndentBillOnNet" msprop:Generator_ColumnVarNameInTable="columnLastModDate_IndentBillOnNet" msprop:Generator_ColumnPropNameInRow="LastModDate_IndentBillOnNet" msprop:Generator_ColumnPropNameInTable="LastModDate_IndentBillOnNetColumn" msprop:Generator_UserColumnName="LastModDate_IndentBillOnNet" type="xs:dateTime" minOccurs="0" />
- <xs:element name="DeleteUser_IndentBillOnNet" msdata:DataType="System.Guid, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:Generator_ColumnVarNameInTable="columnDeleteUser_IndentBillOnNet" msprop:Generator_ColumnPropNameInRow="DeleteUser_IndentBillOnNet" msprop:Generator_ColumnPropNameInTable="DeleteUser_IndentBillOnNetColumn" msprop:Generator_UserColumnName="DeleteUser_IndentBillOnNet" type="xs:string" minOccurs="0" />
- <xs:element name="DeleteDate_IndentBillOnNet" msprop:Generator_ColumnVarNameInTable="columnDeleteDate_IndentBillOnNet" msprop:Generator_ColumnPropNameInRow="DeleteDate_IndentBillOnNet" msprop:Generator_ColumnPropNameInTable="DeleteDate_IndentBillOnNetColumn" msprop:Generator_UserColumnName="DeleteDate_IndentBillOnNet" type="xs:dateTime" minOccurs="0" />
- <xs:element name="FeedbackComment_IndentBillOnNet" msprop:Generator_ColumnVarNameInTable="columnFeedbackComment_IndentBillOnNet" msprop:Generator_ColumnPropNameInRow="FeedbackComment_IndentBillOnNet" msprop:Generator_ColumnPropNameInTable="FeedbackComment_IndentBillOnNetColumn" msprop:Generator_UserColumnName="FeedbackComment_IndentBillOnNet" minOccurs="0">
- <xs:simpleType>
- <xs:restriction base="xs:string">
- <xs:maxLength value="256" />
- </xs:restriction>
- </xs:simpleType>
- </xs:element>
- <xs:element name="Name_CustomerAccount" msprop:Generator_ColumnVarNameInTable="columnName_CustomerAccount" msprop:Generator_ColumnPropNameInRow="Name_CustomerAccount" msprop:Generator_ColumnPropNameInTable="Name_CustomerAccountColumn" msprop:Generator_UserColumnName="Name_CustomerAccount" minOccurs="0">
- <xs:simpleType>
- <xs:restriction base="xs:string">
- <xs:maxLength value="64" />
- </xs:restriction>
- </xs:simpleType>
- </xs:element>
- <xs:element name="Postcode_IndentBillOnNet" msprop:Generator_ColumnVarNameInTable="columnPostcode_IndentBillOnNet" msprop:Generator_ColumnPropNameInRow="Postcode_IndentBillOnNet" msprop:Generator_ColumnPropNameInTable="Postcode_IndentBillOnNetColumn" msprop:Generator_UserColumnName="Postcode_IndentBillOnNet" minOccurs="0">
- <xs:simpleType>
- <xs:restriction base="xs:string">
- <xs:maxLength value="64" />
- </xs:restriction>
- </xs:simpleType>
- </xs:element>
- <xs:element name="No_Customer" msprop:Generator_ColumnVarNameInTable="columnNo_Customer" msprop:Generator_ColumnPropNameInRow="No_Customer" msprop:Generator_ColumnPropNameInTable="No_CustomerColumn" msprop:Generator_UserColumnName="No_Customer" minOccurs="0">
- <xs:simpleType>
- <xs:restriction base="xs:string">
- <xs:maxLength value="64" />
- </xs:restriction>
- </xs:simpleType>
- </xs:element>
- <xs:element name="Name_Customer" msprop:Generator_ColumnVarNameInTable="columnName_Customer" msprop:Generator_ColumnPropNameInRow="Name_Customer" msprop:Generator_ColumnPropNameInTable="Name_CustomerColumn" msprop:Generator_UserColumnName="Name_Customer" minOccurs="0">
- <xs:simpleType>
- <xs:restriction base="xs:string">
- <xs:maxLength value="64" />
- </xs:restriction>
- </xs:simpleType>
- </xs:element>
- <xs:element name="ShortName_Customer" msprop:Generator_ColumnVarNameInTable="columnShortName_Customer" msprop:Generator_ColumnPropNameInRow="ShortName_Customer" msprop:Generator_ColumnPropNameInTable="ShortName_CustomerColumn" msprop:Generator_UserColumnName="ShortName_Customer" minOccurs="0">
- <xs:simpleType>
- <xs:restriction base="xs:string">
- <xs:maxLength value="16" />
- </xs:restriction>
- </xs:simpleType>
- </xs:element>
- <xs:element name="Type_Customer" msprop:Generator_ColumnVarNameInTable="columnType_Customer" msprop:Generator_ColumnPropNameInRow="Type_Customer" msprop:Generator_ColumnPropNameInTable="Type_CustomerColumn" msprop:Generator_UserColumnName="Type_Customer" minOccurs="0">
- <xs:simpleType>
- <xs:restriction base="xs:string">
- <xs:maxLength value="64" />
- </xs:restriction>
- </xs:simpleType>
- </xs:element>
- <xs:element name="LastDiscount_Customer" msprop:Generator_ColumnVarNameInTable="columnLastDiscount_Customer" msprop:Generator_ColumnPropNameInRow="LastDiscount_Customer" msprop:Generator_ColumnPropNameInTable="LastDiscount_CustomerColumn" msprop:Generator_UserColumnName="LastDiscount_Customer" type="xs:decimal" minOccurs="0" />
- <xs:element name="PostalCode_Customer" msprop:Generator_ColumnVarNameInTable="columnPostalCode_Customer" msprop:Generator_ColumnPropNameInRow="PostalCode_Customer" msprop:Generator_ColumnPropNameInTable="PostalCode_CustomerColumn" msprop:Generator_UserColumnName="PostalCode_Customer" minOccurs="0">
- <xs:simpleType>
- <xs:restriction base="xs:string">
- <xs:maxLength value="32" />
- </xs:restriction>
- </xs:simpleType>
- </xs:element>
- <xs:element name="Name_Assessor" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnName_Assessor" msprop:Generator_ColumnPropNameInRow="Name_Assessor" msprop:Generator_ColumnPropNameInTable="Name_AssessorColumn" msprop:Generator_UserColumnName="Name_Assessor" minOccurs="0">
- <xs:simpleType>
- <xs:restriction base="xs:string">
- <xs:maxLength value="64" />
- </xs:restriction>
- </xs:simpleType>
- </xs:element>
- <xs:element name="CustomerCreator" msdata:DataType="System.Guid, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:Generator_ColumnVarNameInTable="columnCustomerCreator" msprop:Generator_ColumnPropNameInRow="CustomerCreator" msprop:Generator_ColumnPropNameInTable="CustomerCreatorColumn" msprop:Generator_UserColumnName="CustomerCreator" type="xs:string" minOccurs="0" />
- </xs:sequence>
- </xs:complexType>
- </xs:element>
- <xs:element name="IndentBillOnNetProduct" msprop:Generator_TableClassName="IndentBillOnNetProductDataTable" msprop:Generator_TableVarName="tableIndentBillOnNetProduct" msprop:Generator_TablePropName="IndentBillOnNetProduct" msprop:Generator_RowDeletingName="IndentBillOnNetProductRowDeleting" msprop:Generator_RowChangingName="IndentBillOnNetProductRowChanging" msprop:Generator_RowEvHandlerName="IndentBillOnNetProductRowChangeEventHandler" msprop:Generator_RowDeletedName="IndentBillOnNetProductRowDeleted" msprop:Generator_UserTableName="IndentBillOnNetProduct" msprop:Generator_RowChangedName="IndentBillOnNetProductRowChanged" msprop:Generator_RowEvArgName="IndentBillOnNetProductRowChangeEvent" msprop:Generator_RowClassName="IndentBillOnNetProductRow">
- <xs:complexType>
- <xs:sequence>
- <xs:element name="ID_IndentBillOnNetProduct" msdata:DataType="System.Guid, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:Generator_ColumnVarNameInTable="columnID_IndentBillOnNetProduct" msprop:Generator_ColumnPropNameInRow="ID_IndentBillOnNetProduct" msprop:Generator_ColumnPropNameInTable="ID_IndentBillOnNetProductColumn" msprop:Generator_UserColumnName="ID_IndentBillOnNetProduct" type="xs:string" />
- <xs:element name="No_IndentBillOnNetProduct" msprop:Generator_ColumnVarNameInTable="columnNo_IndentBillOnNetProduct" msprop:Generator_ColumnPropNameInRow="No_IndentBillOnNetProduct" msprop:Generator_ColumnPropNameInTable="No_IndentBillOnNetProductColumn" msprop:Generator_UserColumnName="No_IndentBillOnNetProduct">
- <xs:simpleType>
- <xs:restriction base="xs:string">
- <xs:maxLength value="64" />
- </xs:restriction>
- </xs:simpleType>
- </xs:element>
- <xs:element name="ID_IndentBillOnNet" msdata:DataType="System.Guid, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:Generator_ColumnVarNameInTable="columnID_IndentBillOnNet" msprop:Generator_ColumnPropNameInRow="ID_IndentBillOnNet" msprop:Generator_ColumnPropNameInTable="ID_IndentBillOnNetColumn" msprop:Generator_UserColumnName="ID_IndentBillOnNet" type="xs:string" />
- <xs:element name="ID_Product" msdata:DataType="System.Guid, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:Generator_ColumnVarNameInTable="columnID_Product" msprop:Generator_ColumnPropNameInRow="ID_Product" msprop:Generator_ColumnPropNameInTable="ID_ProductColumn" msprop:Generator_UserColumnName="ID_Product" type="xs:string" />
- <xs:element name="Quantity_IndentBillOnNetProduct" msprop:Generator_ColumnVarNameInTable="columnQuantity_IndentBillOnNetProduct" msprop:Generator_ColumnPropNameInRow="Quantity_IndentBillOnNetProduct" msprop:Generator_ColumnPropNameInTable="Quantity_IndentBillOnNetProductColumn" msprop:Generator_UserColumnName="Quantity_IndentBillOnNetProduct" type="xs:decimal" />
- <xs:element name="UnitPrice_IndentBillOnNetProduct" msprop:Generator_ColumnVarNameInTable="columnUnitPrice_IndentBillOnNetProduct" msprop:Generator_ColumnPropNameInRow="UnitPrice_IndentBillOnNetProduct" msprop:Generator_ColumnPropNameInTable="UnitPrice_IndentBillOnNetProductColumn" msprop:Generator_UserColumnName="UnitPrice_IndentBillOnNetProduct" type="xs:decimal" />
- <xs:element name="Comment_IndentBillOnNetProduct" msprop:Generator_ColumnVarNameInTable="columnComment_IndentBillOnNetProduct" msprop:Generator_ColumnPropNameInRow="Comment_IndentBillOnNetProduct" msprop:Generator_ColumnPropNameInTable="Comment_IndentBillOnNetProductColumn" msprop:Generator_UserColumnName="Comment_IndentBillOnNetProduct" minOccurs="0">
- <xs:simpleType>
- <xs:restriction base="xs:string">
- <xs:maxLength value="256" />
- </xs:restriction>
- </xs:simpleType>
- </xs:element>
- <xs:element name="Amount_SaleBill" msprop:Generator_ColumnVarNameInTable="columnAmount_SaleBill" msprop:Generator_ColumnPropNameInRow="Amount_SaleBill" msprop:Generator_ColumnPropNameInTable="Amount_SaleBillColumn" msprop:Generator_UserColumnName="Amount_SaleBill" type="xs:decimal" />
- <xs:element name="No_IndentBillOnNet" msprop:Generator_ColumnVarNameInTable="columnNo_IndentBillOnNet" msprop:Generator_ColumnPropNameInRow="No_IndentBillOnNet" msprop:Generator_ColumnPropNameInTable="No_IndentBillOnNetColumn" msprop:Generator_UserColumnName="No_IndentBillOnNet" minOccurs="0">
- <xs:simpleType>
- <xs:restriction base="xs:string">
- <xs:maxLength value="64" />
- </xs:restriction>
- </xs:simpleType>
- </xs:element>
- <xs:element name="No_Product" msprop:Generator_ColumnVarNameInTable="columnNo_Product" msprop:Generator_ColumnPropNameInRow="No_Product" msprop:Generator_ColumnPropNameInTable="No_ProductColumn" msprop:Generator_UserColumnName="No_Product" minOccurs="0">
- <xs:simpleType>
- <xs:restriction base="xs:string">
- <xs:maxLength value="64" />
- </xs:restriction>
- </xs:simpleType>
- </xs:element>
- <xs:element name="Name_Product" msprop:Generator_ColumnVarNameInTable="columnName_Product" msprop:Generator_ColumnPropNameInRow="Name_Product" msprop:Generator_ColumnPropNameInTable="Name_ProductColumn" msprop:Generator_UserColumnName="Name_Product" minOccurs="0">
- <xs:simpleType>
- <xs:restriction base="xs:string">
- <xs:maxLength value="64" />
- </xs:restriction>
- </xs:simpleType>
- </xs:element>
- <xs:element name="Unit_Product" msprop:Generator_ColumnVarNameInTable="columnUnit_Product" msprop:Generator_ColumnPropNameInRow="Unit_Product" msprop:Generator_ColumnPropNameInTable="Unit_ProductColumn" msprop:Generator_UserColumnName="Unit_Product" minOccurs="0">
- <xs:simpleType>
- <xs:restriction base="xs:string">
- <xs:maxLength value="64" />
- </xs:restriction>
- </xs:simpleType>
- </xs:element>
- <xs:element name="Amount_IndentBillOnNetProduct" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnAmount_IndentBillOnNetProduct" msprop:Generator_ColumnPropNameInRow="Amount_IndentBillOnNetProduct" msprop:Generator_ColumnPropNameInTable="Amount_IndentBillOnNetProductColumn" msprop:Generator_UserColumnName="Amount_IndentBillOnNetProduct" type="xs:decimal" minOccurs="0" />
- <xs:element name="No_IndentBillOnNet1" msprop:Generator_ColumnVarNameInTable="columnNo_IndentBillOnNet1" msprop:Generator_ColumnPropNameInRow="No_IndentBillOnNet1" msprop:Generator_ColumnPropNameInTable="No_IndentBillOnNet1Column" msprop:Generator_UserColumnName="No_IndentBillOnNet1" minOccurs="0">
- <xs:simpleType>
- <xs:restriction base="xs:string">
- <xs:maxLength value="64" />
- </xs:restriction>
- </xs:simpleType>
- </xs:element>
- </xs:sequence>
- </xs:complexType>
- </xs:element>
- <xs:element name="AppendInfo" msprop:Generator_TableClassName="AppendInfoDataTable" msprop:Generator_TableVarName="tableAppendInfo" msprop:Generator_TablePropName="AppendInfo" msprop:Generator_RowDeletingName="AppendInfoRowDeleting" msprop:Generator_RowChangingName="AppendInfoRowChanging" msprop:Generator_RowEvHandlerName="AppendInfoRowChangeEventHandler" msprop:Generator_RowDeletedName="AppendInfoRowDeleted" msprop:Generator_UserTableName="AppendInfo" msprop:Generator_RowChangedName="AppendInfoRowChanged" msprop:Generator_RowEvArgName="AppendInfoRowChangeEvent" msprop:Generator_RowClassName="AppendInfoRow">
- <xs:complexType>
- <xs:sequence>
- <xs:element name="CurrentCompany" msprop:Generator_ColumnVarNameInTable="columnCurrentCompany" msprop:Generator_ColumnPropNameInRow="CurrentCompany" msprop:Generator_ColumnPropNameInTable="CurrentCompanyColumn" msprop:Generator_UserColumnName="CurrentCompany" type="xs:string" minOccurs="0" />
- <xs:element name="CurrentUser" msprop:Generator_ColumnVarNameInTable="columnCurrentUser" msprop:Generator_ColumnPropNameInRow="CurrentUser" msprop:Generator_ColumnPropNameInTable="CurrentUserColumn" msprop:Generator_UserColumnName="CurrentUser" type="xs:string" minOccurs="0" />
- </xs:sequence>
- </xs:complexType>
- </xs:element>
- </xs:choice>
- </xs:complexType>
- <xs:unique name="Constraint1" msdata:PrimaryKey="true">
- <xs:selector xpath=".//mstns:IndentBillOnNet" />
- <xs:field xpath="mstns:ID_IndentBillOnNet" />
- </xs:unique>
- <xs:unique name="IndentBillOnNetProduct_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
- <xs:selector xpath=".//mstns:IndentBillOnNetProduct" />
- <xs:field xpath="mstns:ID_IndentBillOnNetProduct" />
- </xs:unique>
- </xs:element>
- </xs:schema>
|