ActionField967

Beschrijving: Create InternalCharges with selection on InvoiceGroup,ServiceContract,Lessor,RenterCustomer,RenterDepartment,ContractLineType and Year (via Dialog) and start the projected yields excel report ordered by InvoiceGroup. Custom: Nee

XMLbewerken

<Workflow Name="ActionField967" Version="2025.07.28" WorkflowType="Standard" xmlns="urn:Ultimo.Framework.Workflow-mapping">
	<Security EditLevel="10" ViewLevel="20" UserContentLevel="30" />
	<Description>Create InternalCharges with selection on InvoiceGroup,ServiceContract,Lessor,RenterCustomer,RenterDepartment,ContractLineType and Year (via Dialog) and start the projected yields excel report ordered by InvoiceGroup.</Description>
	<Properties>
		<Property	Name="ContractLineType"	Type="ContractLineType"	Accessor="Internal" />
		<Property	Name="FileName"			Type="UltimoString"		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">
			<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" />

				<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_ExcelExportYieldsForRentsPerInvoiceGroup" CommandName="InternalChargeCreate_ExcelExportYieldsForRentsPerInvoiceGroup">
				<Parameter	Name="ContractLineType"	Direction="In"		Value="${ContractLineType}" />
				<Parameter	Name="FileName"			Direction="In"		Value="${FileName}" />
				<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>