414 lines
36 KiB
XML
414 lines
36 KiB
XML
<?xml version="1.0" encoding="utf-8"?>
|
|
<xs:schema id="MyDataset" targetNamespace="http://tempuri.org/MyDataset.xsd" xmlns:mstns="http://tempuri.org/MyDataset.xsd" xmlns="http://tempuri.org/MyDataset.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="MySettings" AppSettingsPropertyName="MySSConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="MySSConnectionString (MySettings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.WISAG_PM_REPORT.My.MySettings.GlobalReference.Default.MySSConnectionString" Provider="System.Data.SqlClient" />
|
|
</Connections>
|
|
<Tables>
|
|
<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="VWCUST_RPTPM_UNIONTableAdapter" GeneratorDataComponentClassName="VWCUST_RPTPM_UNIONTableAdapter" Name="VWCUST_RPTPM_UNION" UserDataComponentName="VWCUST_RPTPM_UNIONTableAdapter">
|
|
<MainSource>
|
|
<DbSource ConnectionRef="MySSConnectionString (MySettings)" DbObjectName="DD_ECM_TEST.dbo.VWCUST_RPTPM_UNION" 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 GroupTypeID, GroupType, DOC_ID, KreditorNummer, KreditorName_Lang, KreditorName, RechnungNr, Referenz, Nettobetrag, Bruttobetrag, Zahlungsziel, Mandant, [Mandant Name], Kostenstelle, [Erhalten wann], Belegdatum,
|
|
FG_Email, FG_Freigabe, FG_Wann, WHO, [WHEN], DELEGATION
|
|
FROM VWCUST_RPTPM_UNION
|
|
WHERE (DOC_ID = @DocID) AND (LEN(RechnungNr) > 0)</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="true" AutogeneratedName="DocID" ColumnName="DOC_ID" DataSourceName="DD_ECM_TEST.dbo.VWCUST_RPTPM_UNION" DataTypeServer="bigint" DbType="Int64" Direction="Input" ParameterName="@DocID" Precision="0" ProviderType="BigInt" Scale="0" Size="8" SourceColumn="DOC_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
</MainSource>
|
|
<Mappings>
|
|
<Mapping SourceColumn="GroupTypeID" DataSetColumn="GroupTypeID" />
|
|
<Mapping SourceColumn="GroupType" DataSetColumn="GroupType" />
|
|
<Mapping SourceColumn="DOC_ID" DataSetColumn="DOC_ID" />
|
|
<Mapping SourceColumn="KreditorNummer" DataSetColumn="KreditorNummer" />
|
|
<Mapping SourceColumn="KreditorName_Lang" DataSetColumn="KreditorName_Lang" />
|
|
<Mapping SourceColumn="KreditorName" DataSetColumn="KreditorName" />
|
|
<Mapping SourceColumn="RechnungNr" DataSetColumn="RechnungNr" />
|
|
<Mapping SourceColumn="Referenz" DataSetColumn="Referenz" />
|
|
<Mapping SourceColumn="Nettobetrag" DataSetColumn="Nettobetrag" />
|
|
<Mapping SourceColumn="Bruttobetrag" DataSetColumn="Bruttobetrag" />
|
|
<Mapping SourceColumn="Zahlungsziel" DataSetColumn="Zahlungsziel" />
|
|
<Mapping SourceColumn="Mandant" DataSetColumn="Mandant" />
|
|
<Mapping SourceColumn="Mandant Name" DataSetColumn="Mandant Name" />
|
|
<Mapping SourceColumn="Kostenstelle" DataSetColumn="Kostenstelle" />
|
|
<Mapping SourceColumn="Erhalten wann" DataSetColumn="Erhalten wann" />
|
|
<Mapping SourceColumn="Belegdatum" DataSetColumn="Belegdatum" />
|
|
<Mapping SourceColumn="FG_Email" DataSetColumn="FG_Email" />
|
|
<Mapping SourceColumn="FG_Freigabe" DataSetColumn="FG_Freigabe" />
|
|
<Mapping SourceColumn="FG_Wann" DataSetColumn="FG_Wann" />
|
|
<Mapping SourceColumn="WHO" DataSetColumn="WHO" />
|
|
<Mapping SourceColumn="WHEN" DataSetColumn="WHEN" />
|
|
<Mapping SourceColumn="DELEGATION" DataSetColumn="DELEGATION" />
|
|
</Mappings>
|
|
<Sources />
|
|
</TableAdapter>
|
|
<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="VWCUST_RPTPM_UNION1TableAdapter" GeneratorDataComponentClassName="VWCUST_RPTPM_UNION1TableAdapter" Name="VWCUST_RPTPM_UNION1" UserDataComponentName="VWCUST_RPTPM_UNION1TableAdapter">
|
|
<MainSource>
|
|
<DbSource ConnectionRef="MySSConnectionString (MySettings)" DbObjectName="DD_ECM_TEST.dbo.VWCUST_STAMP" 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 FG_TYP, DocID, Email, Freigabe, Wann
|
|
FROM VWCUST_STAMP
|
|
WHERE (DocID = @DocID)</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="true" AutogeneratedName="DocID" ColumnName="DocID" DataSourceName="DD_ECM_TEST.dbo.VWCUST_STAMP" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@DocID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="DocID" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
</MainSource>
|
|
<Mappings>
|
|
<Mapping SourceColumn="FG_TYP" DataSetColumn="FG_TYP" />
|
|
<Mapping SourceColumn="DocID" DataSetColumn="DocID" />
|
|
<Mapping SourceColumn="Email" DataSetColumn="Email" />
|
|
<Mapping SourceColumn="Freigabe" DataSetColumn="Freigabe" />
|
|
<Mapping SourceColumn="Wann" DataSetColumn="Wann" />
|
|
</Mappings>
|
|
<Sources />
|
|
</TableAdapter>
|
|
<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="VWCUST_RPTPM_INV_RPT_STAMPTableAdapter" GeneratorDataComponentClassName="VWCUST_RPTPM_INV_RPT_STAMPTableAdapter" Name="VWCUST_RPTPM_INV_RPT_STAMP" UserDataComponentName="VWCUST_RPTPM_INV_RPT_STAMPTableAdapter">
|
|
<MainSource>
|
|
<DbSource ConnectionRef="MySSConnectionString (MySettings)" DbObjectName="DD_ECM_TEST.dbo.FNCUST_PM_GET_RPT_STAMP_FOR_DocID" DbObjectType="Function" 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 DocID, STATE, WHO, CREATED_WHEN
|
|
FROM dbo.FNCUST_PM_GET_RPT_STAMP_FOR_DocID(@DocID) AS FNCUST_PM_GET_RPT_STAMP_FOR_DocID_1</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="false" AutogeneratedName="DocID" ColumnName="" DataSourceName="" DataTypeServer="bigint" DbType="Int64" Direction="Input" ParameterName="@DocID" Precision="0" Scale="0" Size="0" SourceColumn="" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
</MainSource>
|
|
<Mappings>
|
|
<Mapping SourceColumn="STATE" DataSetColumn="STATE" />
|
|
<Mapping SourceColumn="WHO" DataSetColumn="WHO" />
|
|
<Mapping SourceColumn="DocID" DataSetColumn="DocID" />
|
|
<Mapping SourceColumn="CREATED_WHEN" DataSetColumn="CREATED_WHEN" />
|
|
</Mappings>
|
|
<Sources />
|
|
</TableAdapter>
|
|
<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="VWCUST_STAMPTableAdapter" GeneratorDataComponentClassName="VWCUST_STAMPTableAdapter" Name="VWCUST_STAMP" UserDataComponentName="VWCUST_STAMPTableAdapter">
|
|
<MainSource>
|
|
<DbSource ConnectionRef="MySSConnectionString (MySettings)" DbObjectName="DD_ECM_TEST.dbo.VWCUST_STAMP" 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="true">
|
|
<CommandText>SELECT FG_TYP, DocID, Email, Freigabe, Wann
|
|
FROM VWCUST_STAMP
|
|
WHERE (DocID = @DocID)</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="false" AutogeneratedName="DocID" ColumnName="DocID" DataSourceName="DD_ECM_TEST.dbo.VWCUST_STAMP" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@DocID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="DocID" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
</MainSource>
|
|
<Mappings>
|
|
<Mapping SourceColumn="FG_TYP" DataSetColumn="FG_TYP" />
|
|
<Mapping SourceColumn="DocID" DataSetColumn="DocID" />
|
|
<Mapping SourceColumn="Email" DataSetColumn="Email" />
|
|
<Mapping SourceColumn="Freigabe" DataSetColumn="Freigabe" />
|
|
<Mapping SourceColumn="Wann" DataSetColumn="Wann" />
|
|
</Mappings>
|
|
<Sources />
|
|
</TableAdapter>
|
|
<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="FNCUST_PM_GET_RPT_STAMP_FOR_DocIDTableAdapter" GeneratorDataComponentClassName="FNCUST_PM_GET_RPT_STAMP_FOR_DocIDTableAdapter" Name="FNCUST_PM_GET_RPT_STAMP_FOR_DocID" UserDataComponentName="FNCUST_PM_GET_RPT_STAMP_FOR_DocIDTableAdapter">
|
|
<MainSource>
|
|
<DbSource ConnectionRef="MySSConnectionString (MySettings)" DbObjectName="DD_ECM_TEST.dbo.FNCUST_PM_GET_RPT_STAMP_FOR_DocID" DbObjectType="Function" 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="true">
|
|
<CommandText>SELECT * FROM [dbo].FNCUST_PM_GET_RPT_STAMP_FOR_DocID (@DocID)</CommandText>
|
|
<Parameters>
|
|
<Parameter AllowDbNull="false" AutogeneratedName="DocID" ColumnName="" DataSourceName="" DataTypeServer="bigint" DbType="Int64" Direction="Input" ParameterName="@DocID" Precision="0" Scale="0" Size="0" SourceColumn="" SourceColumnNullMapping="false" SourceVersion="Current" />
|
|
</Parameters>
|
|
</DbCommand>
|
|
</SelectCommand>
|
|
</DbSource>
|
|
</MainSource>
|
|
<Mappings>
|
|
<Mapping SourceColumn="DocID" DataSetColumn="DocID" />
|
|
<Mapping SourceColumn="STATE" DataSetColumn="STATE" />
|
|
<Mapping SourceColumn="WHO" DataSetColumn="WHO" />
|
|
<Mapping SourceColumn="CREATED_WHEN" DataSetColumn="CREATED_WHEN" />
|
|
<Mapping SourceColumn="COMMENT" DataSetColumn="COMMENT" />
|
|
<Mapping SourceColumn="SequentialOrder" DataSetColumn="SequentialOrder" />
|
|
</Mappings>
|
|
<Sources />
|
|
</TableAdapter>
|
|
</Tables>
|
|
<Sources />
|
|
</DataSource>
|
|
</xs:appinfo>
|
|
</xs:annotation>
|
|
<xs:element name="MyDataset" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:EnableTableAdapterManager="true" msprop:Generator_DataSetName="MyDataset" msprop:Generator_UserDSName="MyDataset">
|
|
<xs:complexType>
|
|
<xs:choice minOccurs="0" maxOccurs="unbounded">
|
|
<xs:element name="VWCUST_RPTPM_UNION" msprop:Generator_TableClassName="VWCUST_RPTPM_UNIONDataTable" msprop:Generator_TableVarName="tableVWCUST_RPTPM_UNION" msprop:Generator_TablePropName="VWCUST_RPTPM_UNION" msprop:Generator_RowDeletingName="VWCUST_RPTPM_UNIONRowDeleting" msprop:Generator_RowChangingName="VWCUST_RPTPM_UNIONRowChanging" msprop:Generator_RowEvHandlerName="VWCUST_RPTPM_UNIONRowChangeEventHandler" msprop:Generator_RowDeletedName="VWCUST_RPTPM_UNIONRowDeleted" msprop:Generator_UserTableName="VWCUST_RPTPM_UNION" msprop:Generator_RowChangedName="VWCUST_RPTPM_UNIONRowChanged" msprop:Generator_RowEvArgName="VWCUST_RPTPM_UNIONRowChangeEvent" msprop:Generator_RowClassName="VWCUST_RPTPM_UNIONRow">
|
|
<xs:complexType>
|
|
<xs:sequence>
|
|
<xs:element name="GroupTypeID" msprop:Generator_ColumnVarNameInTable="columnGroupTypeID" msprop:Generator_ColumnPropNameInRow="GroupTypeID" msprop:Generator_ColumnPropNameInTable="GroupTypeIDColumn" msprop:Generator_UserColumnName="GroupTypeID" type="xs:int" />
|
|
<xs:element name="GroupType" msprop:Generator_ColumnVarNameInTable="columnGroupType" msprop:Generator_ColumnPropNameInRow="GroupType" msprop:Generator_ColumnPropNameInTable="GroupTypeColumn" msprop:Generator_UserColumnName="GroupType">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="250" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="DOC_ID" msprop:Generator_ColumnVarNameInTable="columnDOC_ID" msprop:Generator_ColumnPropNameInRow="DOC_ID" msprop:Generator_ColumnPropNameInTable="DOC_IDColumn" msprop:Generator_UserColumnName="DOC_ID" type="xs:long" minOccurs="0" />
|
|
<xs:element name="KreditorNummer" msprop:Generator_ColumnVarNameInTable="columnKreditorNummer" msprop:Generator_ColumnPropNameInRow="KreditorNummer" msprop:Generator_ColumnPropNameInTable="KreditorNummerColumn" msprop:Generator_UserColumnName="KreditorNummer" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="255" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="KreditorName_Lang" msprop:Generator_ColumnVarNameInTable="columnKreditorName_Lang" msprop:Generator_ColumnPropNameInRow="KreditorName_Lang" msprop:Generator_ColumnPropNameInTable="KreditorName_LangColumn" msprop:Generator_UserColumnName="KreditorName_Lang" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="255" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="KreditorName" msprop:Generator_ColumnVarNameInTable="columnKreditorName" msprop:Generator_ColumnPropNameInRow="KreditorName" msprop:Generator_ColumnPropNameInTable="KreditorNameColumn" msprop:Generator_UserColumnName="KreditorName" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="255" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="RechnungNr" msprop:Generator_ColumnVarNameInTable="columnRechnungNr" msprop:Generator_ColumnPropNameInRow="RechnungNr" msprop:Generator_ColumnPropNameInTable="RechnungNrColumn" msprop:Generator_UserColumnName="RechnungNr" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="128" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Referenz" msprop:Generator_ColumnVarNameInTable="columnReferenz" msprop:Generator_ColumnPropNameInRow="Referenz" msprop:Generator_ColumnPropNameInTable="ReferenzColumn" msprop:Generator_UserColumnName="Referenz" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="512" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Nettobetrag" msprop:Generator_ColumnVarNameInTable="columnNettobetrag" msprop:Generator_ColumnPropNameInRow="Nettobetrag" msprop:Generator_ColumnPropNameInTable="NettobetragColumn" msprop:Generator_UserColumnName="Nettobetrag" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="30" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Bruttobetrag" msprop:Generator_ColumnVarNameInTable="columnBruttobetrag" msprop:Generator_ColumnPropNameInRow="Bruttobetrag" msprop:Generator_ColumnPropNameInTable="BruttobetragColumn" msprop:Generator_UserColumnName="Bruttobetrag" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="30" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Zahlungsziel" msprop:Generator_ColumnVarNameInTable="columnZahlungsziel" msprop:Generator_ColumnPropNameInRow="Zahlungsziel" msprop:Generator_ColumnPropNameInTable="ZahlungszielColumn" msprop:Generator_UserColumnName="Zahlungsziel" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="30" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Mandant" msprop:Generator_ColumnVarNameInTable="columnMandant" msprop:Generator_ColumnPropNameInRow="Mandant" msprop:Generator_ColumnPropNameInTable="MandantColumn" msprop:Generator_UserColumnName="Mandant" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="128" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Mandant_x0020_Name" msprop:Generator_ColumnVarNameInTable="columnMandant_Name" msprop:Generator_ColumnPropNameInRow="Mandant_Name" msprop:Generator_ColumnPropNameInTable="Mandant_NameColumn" msprop:Generator_UserColumnName="Mandant Name" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="64" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Kostenstelle" msprop:Generator_ColumnVarNameInTable="columnKostenstelle" msprop:Generator_ColumnPropNameInRow="Kostenstelle" msprop:Generator_ColumnPropNameInTable="KostenstelleColumn" msprop:Generator_UserColumnName="Kostenstelle" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="128" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Erhalten_x0020_wann" msprop:Generator_ColumnVarNameInTable="columnErhalten_wann" msprop:Generator_ColumnPropNameInRow="Erhalten_wann" msprop:Generator_ColumnPropNameInTable="Erhalten_wannColumn" msprop:Generator_UserColumnName="Erhalten wann" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="30" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Belegdatum" msprop:Generator_ColumnVarNameInTable="columnBelegdatum" msprop:Generator_ColumnPropNameInRow="Belegdatum" msprop:Generator_ColumnPropNameInTable="BelegdatumColumn" msprop:Generator_UserColumnName="Belegdatum" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="30" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="FG_Email" msprop:Generator_ColumnVarNameInTable="columnFG_Email" msprop:Generator_ColumnPropNameInRow="FG_Email" msprop:Generator_ColumnPropNameInTable="FG_EmailColumn" msprop:Generator_UserColumnName="FG_Email" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="2147483647" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="FG_Freigabe" msprop:Generator_ColumnVarNameInTable="columnFG_Freigabe" msprop:Generator_ColumnPropNameInRow="FG_Freigabe" msprop:Generator_ColumnPropNameInTable="FG_FreigabeColumn" msprop:Generator_UserColumnName="FG_Freigabe" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="2147483647" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="FG_Wann" msprop:Generator_ColumnVarNameInTable="columnFG_Wann" msprop:Generator_ColumnPropNameInRow="FG_Wann" msprop:Generator_ColumnPropNameInTable="FG_WannColumn" msprop:Generator_UserColumnName="FG_Wann" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="2147483647" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="WHO" msprop:Generator_ColumnVarNameInTable="columnWHO" msprop:Generator_ColumnPropNameInRow="WHO" msprop:Generator_ColumnPropNameInTable="WHOColumn" msprop:Generator_UserColumnName="WHO">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="100" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="WHEN" msprop:Generator_ColumnVarNameInTable="columnWHEN" msprop:Generator_ColumnPropNameInRow="_WHEN" msprop:Generator_ColumnPropNameInTable="WHENColumn" msprop:Generator_UserColumnName="WHEN">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="19" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="DELEGATION" msprop:Generator_ColumnVarNameInTable="columnDELEGATION" msprop:Generator_ColumnPropNameInRow="DELEGATION" msprop:Generator_ColumnPropNameInTable="DELEGATIONColumn" msprop:Generator_UserColumnName="DELEGATION">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="250" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
</xs:sequence>
|
|
</xs:complexType>
|
|
</xs:element>
|
|
<xs:element name="VWCUST_RPTPM_UNION1" msprop:Generator_TableClassName="VWCUST_RPTPM_UNION1DataTable" msprop:Generator_TableVarName="tableVWCUST_RPTPM_UNION1" msprop:Generator_RowChangedName="VWCUST_RPTPM_UNION1RowChanged" msprop:Generator_TablePropName="VWCUST_RPTPM_UNION1" msprop:Generator_RowDeletingName="VWCUST_RPTPM_UNION1RowDeleting" msprop:Generator_RowChangingName="VWCUST_RPTPM_UNION1RowChanging" msprop:Generator_RowEvHandlerName="VWCUST_RPTPM_UNION1RowChangeEventHandler" msprop:Generator_RowDeletedName="VWCUST_RPTPM_UNION1RowDeleted" msprop:Generator_RowClassName="VWCUST_RPTPM_UNION1Row" msprop:Generator_UserTableName="VWCUST_RPTPM_UNION1" msprop:Generator_RowEvArgName="VWCUST_RPTPM_UNION1RowChangeEvent">
|
|
<xs:complexType>
|
|
<xs:sequence>
|
|
<xs:element name="FG_TYP" msprop:Generator_ColumnVarNameInTable="columnFG_TYP" msprop:Generator_ColumnPropNameInRow="FG_TYP" msprop:Generator_ColumnPropNameInTable="FG_TYPColumn" msprop:Generator_UserColumnName="FG_TYP" default="">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="2" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="DocID" msprop:Generator_ColumnVarNameInTable="columnDocID" msprop:Generator_ColumnPropNameInRow="DocID" msprop:Generator_ColumnPropNameInTable="DocIDColumn" msprop:Generator_UserColumnName="DocID" type="xs:int" minOccurs="0" />
|
|
<xs:element name="Email" msprop:Generator_ColumnVarNameInTable="columnEmail" msprop:Generator_ColumnPropNameInRow="Email" msprop:Generator_ColumnPropNameInTable="EmailColumn" msprop:Generator_UserColumnName="Email" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="26" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Freigabe" msprop:Generator_ColumnVarNameInTable="columnFreigabe" msprop:Generator_ColumnPropNameInRow="Freigabe" msprop:Generator_ColumnPropNameInTable="FreigabeColumn" msprop:Generator_UserColumnName="Freigabe" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="2" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Wann" msprop:Generator_ColumnVarNameInTable="columnWann" msprop:Generator_ColumnPropNameInRow="Wann" msprop:Generator_ColumnPropNameInTable="WannColumn" msprop:Generator_UserColumnName="Wann" type="xs:dateTime" minOccurs="0" />
|
|
</xs:sequence>
|
|
</xs:complexType>
|
|
</xs:element>
|
|
<xs:element name="VWCUST_RPTPM_INV_RPT_STAMP" msprop:Generator_TableClassName="VWCUST_RPTPM_INV_RPT_STAMPDataTable" msprop:Generator_TableVarName="tableVWCUST_RPTPM_INV_RPT_STAMP" msprop:Generator_TablePropName="VWCUST_RPTPM_INV_RPT_STAMP" msprop:Generator_RowDeletingName="VWCUST_RPTPM_INV_RPT_STAMPRowDeleting" msprop:Generator_RowChangingName="VWCUST_RPTPM_INV_RPT_STAMPRowChanging" msprop:Generator_RowEvHandlerName="VWCUST_RPTPM_INV_RPT_STAMPRowChangeEventHandler" msprop:Generator_RowDeletedName="VWCUST_RPTPM_INV_RPT_STAMPRowDeleted" msprop:Generator_UserTableName="VWCUST_RPTPM_INV_RPT_STAMP" msprop:Generator_RowChangedName="VWCUST_RPTPM_INV_RPT_STAMPRowChanged" msprop:Generator_RowEvArgName="VWCUST_RPTPM_INV_RPT_STAMPRowChangeEvent" msprop:Generator_RowClassName="VWCUST_RPTPM_INV_RPT_STAMPRow">
|
|
<xs:complexType>
|
|
<xs:sequence>
|
|
<xs:element name="STATE" msprop:Generator_ColumnVarNameInTable="columnSTATE" msprop:Generator_ColumnPropNameInRow="STATE" msprop:Generator_ColumnPropNameInTable="STATEColumn" msprop:Generator_UserColumnName="STATE" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="20" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="WHO" msprop:Generator_ColumnVarNameInTable="columnWHO" msprop:Generator_ColumnPropNameInRow="WHO" msprop:Generator_ColumnPropNameInTable="WHOColumn" msprop:Generator_UserColumnName="WHO" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="100" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="DocID" msprop:Generator_ColumnVarNameInTable="columnDocID" msprop:Generator_ColumnPropNameInRow="DocID" msprop:Generator_ColumnPropNameInTable="DocIDColumn" msprop:Generator_UserColumnName="DocID" type="xs:long" minOccurs="0" />
|
|
<xs:element name="CREATED_WHEN" msprop:Generator_ColumnVarNameInTable="columnCREATED_WHEN" msprop:Generator_ColumnPropNameInRow="CREATED_WHEN" msprop:Generator_ColumnPropNameInTable="CREATED_WHENColumn" msprop:Generator_UserColumnName="CREATED_WHEN" type="xs:dateTime" minOccurs="0" />
|
|
</xs:sequence>
|
|
</xs:complexType>
|
|
</xs:element>
|
|
<xs:element name="VWCUST_STAMP" msprop:Generator_TableClassName="VWCUST_STAMPDataTable" msprop:Generator_TableVarName="tableVWCUST_STAMP" msprop:Generator_TablePropName="VWCUST_STAMP" msprop:Generator_RowDeletingName="VWCUST_STAMPRowDeleting" msprop:Generator_RowChangingName="VWCUST_STAMPRowChanging" msprop:Generator_RowEvHandlerName="VWCUST_STAMPRowChangeEventHandler" msprop:Generator_RowDeletedName="VWCUST_STAMPRowDeleted" msprop:Generator_UserTableName="VWCUST_STAMP" msprop:Generator_RowChangedName="VWCUST_STAMPRowChanged" msprop:Generator_RowEvArgName="VWCUST_STAMPRowChangeEvent" msprop:Generator_RowClassName="VWCUST_STAMPRow">
|
|
<xs:complexType>
|
|
<xs:sequence>
|
|
<xs:element name="FG_TYP" msprop:Generator_ColumnVarNameInTable="columnFG_TYP" msprop:Generator_ColumnPropNameInRow="FG_TYP" msprop:Generator_ColumnPropNameInTable="FG_TYPColumn" msprop:Generator_UserColumnName="FG_TYP">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="2" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="DocID" msprop:Generator_ColumnVarNameInTable="columnDocID" msprop:Generator_ColumnPropNameInRow="DocID" msprop:Generator_ColumnPropNameInTable="DocIDColumn" msprop:Generator_UserColumnName="DocID" type="xs:int" />
|
|
<xs:element name="Email" msprop:Generator_ColumnVarNameInTable="columnEmail" msprop:Generator_ColumnPropNameInRow="Email" msprop:Generator_ColumnPropNameInTable="EmailColumn" msprop:Generator_UserColumnName="Email">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="26" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Freigabe" msprop:Generator_ColumnVarNameInTable="columnFreigabe" msprop:Generator_ColumnPropNameInRow="Freigabe" msprop:Generator_ColumnPropNameInTable="FreigabeColumn" msprop:Generator_UserColumnName="Freigabe" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="2" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="Wann" msprop:Generator_ColumnVarNameInTable="columnWann" msprop:Generator_ColumnPropNameInRow="Wann" msprop:Generator_ColumnPropNameInTable="WannColumn" msprop:Generator_UserColumnName="Wann" type="xs:dateTime" minOccurs="0" />
|
|
</xs:sequence>
|
|
</xs:complexType>
|
|
</xs:element>
|
|
<xs:element name="FNCUST_PM_GET_RPT_STAMP_FOR_DocID" msprop:Generator_TableClassName="FNCUST_PM_GET_RPT_STAMP_FOR_DocIDDataTable" msprop:Generator_TableVarName="tableFNCUST_PM_GET_RPT_STAMP_FOR_DocID" msprop:Generator_TablePropName="FNCUST_PM_GET_RPT_STAMP_FOR_DocID" msprop:Generator_RowDeletingName="FNCUST_PM_GET_RPT_STAMP_FOR_DocIDRowDeleting" msprop:Generator_RowChangingName="FNCUST_PM_GET_RPT_STAMP_FOR_DocIDRowChanging" msprop:Generator_RowEvHandlerName="FNCUST_PM_GET_RPT_STAMP_FOR_DocIDRowChangeEventHandler" msprop:Generator_RowDeletedName="FNCUST_PM_GET_RPT_STAMP_FOR_DocIDRowDeleted" msprop:Generator_UserTableName="FNCUST_PM_GET_RPT_STAMP_FOR_DocID" msprop:Generator_RowChangedName="FNCUST_PM_GET_RPT_STAMP_FOR_DocIDRowChanged" msprop:Generator_RowEvArgName="FNCUST_PM_GET_RPT_STAMP_FOR_DocIDRowChangeEvent" msprop:Generator_RowClassName="FNCUST_PM_GET_RPT_STAMP_FOR_DocIDRow">
|
|
<xs:complexType>
|
|
<xs:sequence>
|
|
<xs:element name="DocID" msprop:Generator_ColumnVarNameInTable="columnDocID" msprop:Generator_ColumnPropNameInRow="DocID" msprop:Generator_ColumnPropNameInTable="DocIDColumn" msprop:Generator_UserColumnName="DocID" type="xs:long" minOccurs="0" />
|
|
<xs:element name="STATE" msprop:Generator_ColumnVarNameInTable="columnSTATE" msprop:Generator_ColumnPropNameInRow="STATE" msprop:Generator_ColumnPropNameInTable="STATEColumn" msprop:Generator_UserColumnName="STATE" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="20" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="WHO" msprop:Generator_ColumnVarNameInTable="columnWHO" msprop:Generator_ColumnPropNameInRow="WHO" msprop:Generator_ColumnPropNameInTable="WHOColumn" msprop:Generator_UserColumnName="WHO" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="100" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="CREATED_WHEN" msprop:Generator_ColumnVarNameInTable="columnCREATED_WHEN" msprop:Generator_ColumnPropNameInRow="CREATED_WHEN" msprop:Generator_ColumnPropNameInTable="CREATED_WHENColumn" msprop:Generator_UserColumnName="CREATED_WHEN" type="xs:dateTime" minOccurs="0" />
|
|
<xs:element name="COMMENT" msprop:Generator_ColumnVarNameInTable="columnCOMMENT" msprop:Generator_ColumnPropNameInRow="COMMENT" msprop:Generator_ColumnPropNameInTable="COMMENTColumn" msprop:Generator_UserColumnName="COMMENT" minOccurs="0">
|
|
<xs:simpleType>
|
|
<xs:restriction base="xs:string">
|
|
<xs:maxLength value="500" />
|
|
</xs:restriction>
|
|
</xs:simpleType>
|
|
</xs:element>
|
|
<xs:element name="SequentialOrder" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnSequentialOrder" msprop:Generator_ColumnPropNameInRow="SequentialOrder" msprop:Generator_ColumnPropNameInTable="SequentialOrderColumn" msprop:Generator_UserColumnName="SequentialOrder" type="xs:int" />
|
|
</xs:sequence>
|
|
</xs:complexType>
|
|
</xs:element>
|
|
</xs:choice>
|
|
</xs:complexType>
|
|
</xs:element>
|
|
</xs:schema> |