dsap110.xsd

通用进销存-visual basic编写

<?xml version="1.0" standalone="yes" ?>
<xs:schema id="dsAP110" targetNamespace="http://www.tempuri.org/dsAP110.xsd" xmlns:mstns="http://www.tempuri.org/dsAP110.xsd" xmlns="http://www.tempuri.org/dsAP110.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" attributeFormDefault="qualified" elementFormDefault="qualified">
	<xs:element name="dsAP110" msdata:IsDataSet="true" msdata:Locale="zh-TW">
		<xs:complexType>
			<xs:choice maxOccurs="unbounded">
				<xs:element name="AccountPayableDetail">
					<xs:complexType>
						<xs:sequence>
							<xs:element name="PaymentID" type="xs:string" />
							<xs:element name="PurchaseID" type="xs:string" />
							<xs:element name="Balance" type="xs:decimal" />
						</xs:sequence>
					</xs:complexType>
				</xs:element>
				<xs:element name="AccountPayableMaster">
					<xs:complexType>
						<xs:sequence>
							<xs:element name="PaymentID" type="xs:string" />
							<xs:element name="PayDate" type="xs:dateTime" />
							<xs:element name="SupplierID" type="xs:string" />
							<xs:element name="PayCash" type="xs:decimal" />
							<xs:element name="PayCheck" type="xs:decimal" />
							<xs:element name="NoteNo" type="xs:string" minOccurs="0" />
							<xs:element name="DueDate" type="xs:dateTime" minOccurs="0" />
							<xs:element name="BankID" type="xs:string" />
							<xs:element name="AccountNo" type="xs:string" minOccurs="0" />
							<xs:element name="Discount" type="xs:decimal" />
							<xs:element name="Remittance" type="xs:decimal" />
							<xs:element name="Prepaid" type="xs:decimal" />
							<xs:element name="Others" type="xs:decimal" />
							<xs:element name="PayAmount" type="xs:decimal" />
							<xs:element name="TotalBalance" type="xs:decimal" />
						</xs:sequence>
					</xs:complexType>
				</xs:element>
				<xs:element name="Bank">
					<xs:complexType>
						<xs:sequence>
							<xs:element name="BankID" type="xs:string" />
							<xs:element name="BankAttribName" type="xs:string" />
						</xs:sequence>
					</xs:complexType>
				</xs:element>
				<xs:element name="Supplier">
					<xs:complexType>
						<xs:sequence>
							<xs:element name="SupplierID" type="xs:string" />
							<xs:element name="SupplierAttribName" type="xs:string" />
						</xs:sequence>
					</xs:complexType>
				</xs:element>
			</xs:choice>
		</xs:complexType>
		<xs:unique name="Constraint1" msdata:PrimaryKey="true">
			<xs:selector xpath=".//mstns:AccountPayableDetail" />
			<xs:field xpath="mstns:PaymentID" />
			<xs:field xpath="mstns:PurchaseID" />
		</xs:unique>
		<xs:unique name="AccountPayableMaster_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
			<xs:selector xpath=".//mstns:AccountPayableMaster" />
			<xs:field xpath="mstns:PaymentID" />
		</xs:unique>
		<xs:unique name="Bank_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
			<xs:selector xpath=".//mstns:Bank" />
			<xs:field xpath="mstns:BankID" />
		</xs:unique>
		<xs:unique name="Supplier_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
			<xs:selector xpath=".//mstns:Supplier" />
			<xs:field xpath="mstns:SupplierID" />
		</xs:unique>
		<xs:keyref name="AccountPayableMasterAccountPayableDetail" refer="mstns:AccountPayableMaster_Constraint1" msdata:DeleteRule="Cascade" msdata:UpdateRule="Cascade">
			<xs:selector xpath=".//mstns:AccountPayableDetail" />
			<xs:field xpath="mstns:PaymentID" />
		</xs:keyref>
	</xs:element>
</xs:schema>