ActionField1215

Beschrijving: Export Cost records from Ultimo to Excel. Custom: Nee

XMLbewerken

<Workflow Name="ActionField1215" Version="2025.07.28" WorkflowType="Standard" xmlns="urn:Ultimo.Framework.Workflow-mapping">
	<Security EditLevel="10" ViewLevel="20" UserContentLevel="30" />
	<Description>Export Cost records from Ultimo to Excel.</Description>
	<Properties>
		<Property	Name="Account"			Type="Account"			Accessor="Internal" />
		<Property	Name="ContinueWhile"	Type="Boolean"			Accessor="Internal"						Default="False" />
		<Property	Name="CostCenter"		Type="CostCenter"		Accessor="Internal" />
		<Property	Name="Customer"			Type="Customer"			Accessor="Internal" />
		<Property	Name="Department"		Type="Department"		Accessor="Internal" />
		<Property	Name="DomainGlobals"	Type="DomainGlobals"	Accessor="Internal"						Default="#{UltimoSettings.Id}" />
		<Property	Name="EndDate"			Type="Date"				Accessor="Internal"						Default="=#adddays(#addyears(${DomainGlobals.StartDateFinanceYear}, 1), -1)" />
		<Property	Name="Equipment"		Type="Equipment"		Accessor="Internal" />
		<Property	Name="ExcelDocument"	Type="Document"			Accessor="Internal" />
		<Property	Name="ProcessFunction"	Type="ProcessFunction"	Accessor="Internal" />
		<Property	Name="StartDate"		Type="Date"				Accessor="Internal"						Default="${DomainGlobals.StartDateFinanceYear}" />
	</Properties>
	<Execution>
		<UserContent Name="Pre" />

		<Dialog Name="DialogForExport" TitleCode="EXPORTCOSTTOEXCEL">
			<Container>
				<Date Name="StartDate" Value="${StartDate}" OutputProperty="${StartDate}" Required="True" LabelCode="STARTDATE" />

				<Date Name="EndDate" Value="${EndDate}" OutputProperty="${EndDate}" Required="True" LabelCode="ENDDATE" />

				<SelectionList Name="CostCenter" OutputProperty="${CostCenter}" ColumnName="CcrId" ViewfieldConfiguration="Default" />

				<SelectionList Name="Account" OutputProperty="${Account}" ColumnName="AccId" ViewfieldConfiguration="Default" />

				<SelectionList Name="Department" OutputProperty="${Department}" ColumnName="DepId" ViewfieldConfiguration="Default" />

				<SelectionList Name="ProcessFunction" OutputProperty="${ProcessFunction}" ColumnName="PrfId" ViewfieldConfiguration="Default" />

				<SelectionList Name="Equipment" OutputProperty="${Equipment}" ColumnName="EqmId" ViewfieldConfiguration="Default" />

				<SelectionList Name="Customer" OutputProperty="${Customer}" ColumnName="CusId" ViewfieldConfiguration="Default" />
			</Container>
		</Dialog>

		<Transaction>
			<CreateDocument Name="UltimoExport" DocumentType="Excel" FileName="Export_Cost.xls" ConvertHtmlToPlainText="True">
				<DocumentGridPage Name="Export Cost" PageTitle="Cost" Type="Cost" ViewfieldConfiguration="default">
					<Joins>
						<Join	Name="Account"								Alias="account"					Type="LeftOuterJoin" />
						<Join	Name="BudgetPeriod"							Alias="budgetperiod"			Type="LeftOuterJoin" />
						<Join	Name="Job"									Alias="job"						Type="LeftOuterJoin" />
						<Join	Name="WarehouseServeOut"					Alias="warehouseserveout"		Type="LeftOuterJoin" />
						<Join	Name="JobExternal"							Alias="jobexternal"				Type="LeftOuterJoin" />
						<Join	Name="JobTool"								Alias="jobtool"					Type="LeftOuterJoin" />
						<Join	Name="JobWeekLabour"						Alias="jobweeklabour"			Type="LeftOuterJoin" />
						<Join	Name="jobweeklabour.Id.JobWeek"				Alias="jobweek"					Type="LeftOuterJoin" />
						<Join	Name="PurchaseLine"							Alias="purchaseline"			Type="LeftOuterJoin" />
						<Join	Name="purchaseline.Id.Purchase"				Alias="purchase"				Type="LeftOuterJoin" />
						<Join	Name="InvoiceLine"							Alias="invoiceline"				Type="LeftOuterJoin" />
						<Join	Name="invoiceline.Id.Invoice"				Alias="invoice"					Type="LeftOuterJoin" />
						<Join	Name="MemorandumBookLine"					Alias="memorandumbookline"		Type="LeftOuterJoin" />
						<Join	Name="memorandumbookline.Id.MemorandumBook"	Alias="memorandumbook"			Type="LeftOuterJoin" />
						<Join	Name="Department"							Alias="department"				Type="LeftOuterJoin" />
						<Join	Name="ProcessFunction"						Alias="processfunction"			Type="LeftOuterJoin" />
						<Join	Name="Equipment"							Alias="equipment"				Type="LeftOuterJoin" />
						<Join	Name="CostCenter"							Alias="costcenter"				Type="LeftOuterJoin" />
						<Join	Name="CostType"								Alias="costtype"				Type="LeftOuterJoin" />
						<Join	Name="Customer"								Alias="customer"				Type="LeftOuterJoin" />
						<Join	Name="SkillCategory"						Alias="skillcategory"			Type="LeftOuterJoin" />
						<Join	Name="Project"								Alias="project"					Type="LeftOuterJoin" />
						<Join	Name="ServiceContract"						Alias="servicecontract"			Type="LeftOuterJoin" />
						<Join	Name="Site"									Alias="site"					Type="LeftOuterJoin" />
						<Join	Name="StatusActiveEmployee"					Alias="statusactiveemployee"	Type="LeftOuterJoin" />
						<Join	Name="StatusCreatedEmployee"				Alias="statuscreatedemployee"	Type="LeftOuterJoin" />
						<Join	Name="StatusExpiredEmployee"				Alias="statusexpiredemployee"	Type="LeftOuterJoin" />
					</Joins>
					<Filters>
						<CombinedFilter FilterOperator="And">
							<BetweenFilter PropertyName="BookDate" LowValue="${StartDate}" HighValue="${EndDate}" Comment="Search full days" />
							<WhenFilter Condition="${CostCenter} != Empty">
								<PropertyFilter	PropertyName="CostCenter"	Operator="="		PropertyValue="${CostCenter}" />
							</WhenFilter>
							<WhenFilter Condition="${Account} != Empty">
								<PropertyFilter	PropertyName="Account"		Operator="="		PropertyValue="${Account}" />
							</WhenFilter>
							<WhenFilter Condition="${Department} != Empty">
								<PropertyFilter	PropertyName="Department"	Operator="="		PropertyValue="${Department}" />
							</WhenFilter>
							<WhenFilter Condition="${ProcessFunction} != Empty">
								<PropertyFilter	PropertyName="ProcessFunction"	Operator="="		PropertyValue="${ProcessFunction}" />
							</WhenFilter>
							<WhenFilter Condition="${Equipment} != Empty">
								<PropertyFilter	PropertyName="Equipment"	Operator="="		PropertyValue="${Equipment}" />
							</WhenFilter>
							<WhenFilter Condition="${Customer} != Empty">
								<PropertyFilter	PropertyName="Customer"		Operator="="		PropertyValue="${Customer}" />
							</WhenFilter>
						</CombinedFilter>
					</Filters>
					<Properties>
						<Property Name="Id" Alias="CostId" Type="Property" />
						<Property Name="Context" Alias="Context" Type="Property" />
						<Property Name="Status" Alias="Status" Type="Property" />
						<Property Name="RecordCreateDate" Alias="RecordCreateDate" Type="Property" />
						<Property Name="Date" Alias="Date" Type="Property" />
						<Property Name="BookDate" Alias="BookDate" Type="Property" />
						<Property Name="CalculatedCost" Alias="Cost" Type="Property" />
						<Property Name="Job.Id" Alias="JobId" Type="Property" />
						<Property Name="warehouseserveout.Id" Alias="WarehouseServeOutId" Type="Property" />
						<Property Name="WarehouseServeOutCost" Alias="WarehouseServeOutCost" Type="Property" />
						<Property Name="jobexternal.Id.LineId" Alias="JobExternalLineId" Type="Property" />
						<Property Name="ExternalCost" Alias="ExternalCost" Type="Property" />
						<Property Name="jobtool.Id.LineId" Alias="JobToolLineId" Type="Property" />
						<Property Name="ToolsCost" Alias="ToolsCost" Type="Property" />
						<Property Name="jobweek.Id.Week" Alias="JobWeekLabourWeek" Type="Property" />
						<Property Name="jobweeklabour.Id.LineId" Alias="JobWeekLabourLineId" Type="Property" />
						<Property Name="Hours" Alias="LabourHours" Type="Property" />
						<Property Name="LabourCost" Alias="LabourCost" Type="Property" />
						<Property Name="purchase.Id" Alias="PurchaseId" Type="Property" />
						<Property Name="purchaseline.Id.LineId" Alias="PurchaseLineId" Type="Property" />
						<Property Name="PurchaseCost" Alias="PurchaseLineCost" Type="Property" />
						<Property Name="invoice.Id" Alias="InvoiceId" Type="Property" />
						<Property Name="invoiceline.Id.LineId" Alias="InvoiceLineId" Type="Property" />
						<Property Name="InvoiceCost" Alias="InvoiceCost" Type="Property" />
						<Property Name="memorandumbook.Id" Alias="MemorandumBookId" Type="Property" />
						<Property Name="memorandumbookline.Id.LineId" Alias="MemorandumBoolLineId" Type="Property" />
						<Property Name="MemorandumCost" Alias="MemorandumCost" Type="Property" />
						<Property Name="department.Id" Alias="DepartmentId" Type="Property" />
						<Property Name="department.Description" Alias="DepartmentDescription" Type="Property" />
						<Property Name="processfunction.Id" Alias="ProcessFunctionId" Type="Property" />
						<Property Name="processfunction.Description" Alias="ProcessFunctionDescription" Type="Property" />
						<Property Name="equipment.Id" Alias="EquipmentId" Type="Property" />
						<Property Name="equipment.Description" Alias="EquipmentDescription" Type="Property" />
						<Property Name="costcenter.Id" Alias="CostCenterId" Type="Property" />
						<Property Name="costcenter.Description" Alias="CostCenterDescription" Type="Property" />
						<Property Name="costtype.Id" Alias="costtypeId" Type="Property" />
						<Property Name="costtype.Description" Alias="costtypeDescription" Type="Property" />
						<Property Name="account.Id" Alias="AccountId" Type="Property" />
						<Property Name="account.Description" Alias="AccountDescription" Type="Property" />
						<Property Name="customer.Id" Alias="CustomerId" Type="Property" />
						<Property Name="customer.Description" Alias="CustomerDescription" Type="Property" />
						<Property Name="skillcategory.Id" Alias="SkillCategoryId" Type="Property" />
						<Property Name="skillcategory.Description" Alias="SkillCategoryDescription" Type="Property" />
						<Property Name="project.Id" Alias="ProjectId" Type="Property" />
						<Property Name="project.Description" Alias="ProjectDescription" Type="Property" />
						<Property Name="servicecontract.Id" Alias="ServiceContractId" Type="Property" />
						<Property Name="servicecontract.Description" Alias="ServiceContractDescription" Type="Property" />
						<Property Name="site.Id" Alias="SiteId" Type="Property" />
						<Property Name="site.Description" Alias="SiteDescription" Type="Property" />
						<Property Name="statusactiveemployee.Id" Alias="StatusActiveEmployeeId" Type="Property" />
						<Property Name="statusactiveemployee.Description" Alias="StatusActiveEmployeeDescription" Type="Property" />
						<Property Name="statuscreatedemployee.Id" Alias="StatusCreatedEmployeeId" Type="Property" />
						<Property Name="statuscreatedemployee.Description" Alias="StatusCreatedEmployeeDescription" Type="Property" />
						<Property Name="statusexpiredemployee.Id" Alias="StatusExpiredEmployeeId" Type="Property" />
						<Property Name="statusexpiredemployee.Description" Alias="StatusExpiredEmployeeDescription" Type="Property" />
						<Property Name="budgetperiod.Id" Alias="BudgetPeriodId" Type="Property" />
						<Property Name="budgetperiod.Period" Alias="BudgetPeriod" Type="Property" />
					</Properties>
				</DocumentGridPage>
			</CreateDocument>
		</Transaction>

		<Download Name="DownloadDocument" FileName="Export_Cost.xls" />

		<UserContent Name="Post" />
	</Execution>
</Workflow>