ActionField1114

Beschrijving: Start the projected yields excel raw report. Custom: Nee

XMLbewerken

<Workflow Name="ActionField1114" Version="2025.07.28" WorkflowType="Standard" xmlns="urn:Ultimo.Framework.Workflow-mapping">
	<Security EditLevel="10" ViewLevel="20" UserContentLevel="30" />
	<Description>Start the projected yields excel raw report.</Description>
	<Properties>
		<Property	Name="ContractLineType"			Type="ContractLineType"	Accessor="Internal" />
		<Property	Name="DialogLabelWidth"			Type="Int32"			Accessor="Internal"						Default="220" />
		<Property	Name="FileName"					Type="UltimoString"		Accessor="Internal" />
		<Property	Name="IncludeConceptContracts"	Type="Boolean"			Accessor="Internal" />
		<Property	Name="InvoiceGroup"				Type="InvoiceGroup"		Accessor="Internal" />
		<Property	Name="Lessor"					Type="Vendor"			Accessor="Internal" />
		<Property	Name="RenterCustomer"			Type="Customer"			Accessor="Internal" />
		<Property	Name="RenterDepartment"			Type="Department"		Accessor="Internal" />
		<Property	Name="ServiceContract"			Type="ServiceContract"	Accessor="Internal" />
		<Property	Name="Year"						Type="Int32"			Accessor="Internal" />
	</Properties>
	<Execution>
		<UserContent Name="Pre" />

		<Dialog Name="Select data for excel report" TitleCode="COLLECTESTATES" LabelWidth="${DialogLabelWidth}">
			<Container>
				<SelectionList Name="InvoiceGroup" OutputProperty="${InvoiceGroup}" ColumnName="InvgId" />

				<SelectionList Name="ServiceContract" OutputProperty="${ServiceContract}" ColumnName="SvcId" ViewfieldConfiguration="HUURCONTRACT" SqlWhereClause="SvcContext = 16" />

				<SelectionList Name="Lessor" OutputProperty="${Lessor}" ColumnName="VdrId" ViewfieldConfiguration="VERHUURDER" SqlWhereClause="VdrContext = 2" />

				<SelectionList Name="RenterCustomer" OutputProperty="${RenterCustomer}" ColumnName="CusId" ViewfieldConfiguration="Verhuur" SqlWhereClause="CusContext=1" />

				<SelectionList Name="RenterDepartment" OutputProperty="${RenterDepartment}" ColumnName="DepId" ViewfieldConfiguration="Verhuur" />

				<SelectionList Name="ContractLineType" OutputProperty="${ContractLineType}" ColumnName="ConltId" />

				<CheckBox Name="IncludeConceptContracts" OutputProperty="${IncludeConceptContracts}" Required="False" LabelCode="INCLUDECONCEPTCONTRACTS" />

				<Number Name="Year" OutputProperty="${Year}" Required="True" LabelCode="YEAR" MinValue="1950" MaxValue="3000" DecimalPrecision="0" />
			</Container>
		</Dialog>

		<Transaction>
			<Assign Name="construct a filename" Property="${FileName}" Value="ExportDataPerInvoiceGroup_${Year}.xls" />

			<Command Name="InternalChargeCreate_ExcelExportYieldsForRentsFlat" CommandName="InternalChargeCreate_ExcelExportYieldsForRentsFlat">
				<Parameter	Name="ContractLineType"			Direction="In"		Value="${ContractLineType}" />
				<Parameter	Name="FileName"					Direction="In"		Value="${FileName}" />
				<Parameter	Name="IncludeConceptContracts"	Direction="In"		Value="${IncludeConceptContracts}" />
				<Parameter	Name="InvoiceGroup"				Direction="In"		Value="${InvoiceGroup}" />
				<Parameter	Name="Lessor"					Direction="In"		Value="${Lessor}" />
				<Parameter	Name="RenterCustomer"			Direction="In"		Value="${RenterCustomer}" />
				<Parameter	Name="RenterDepartment"			Direction="In"		Value="${RenterDepartment}" />
				<Parameter	Name="ServiceContract"			Direction="In"		Value="${ServiceContract}" />
				<Parameter	Name="Year"						Direction="In"		Value="${Year}" />
			</Command>
		</Transaction>

		<UserContent Name="Post" />

		<View Name="View document" ViewName="ExternalDocumentViewer">
			<Parameter	Name="FileName"	Direction="In"		Value="EXPORT\${FileName}" />
		</View>
	</Execution>
</Workflow>