<?xml version="1.0"?>

<report name="ProductList" pdf-renderer="ProductList.xsl">
	<title>Inventur</title>
	
	<report-parameter name="TENANT" type="integer" hidden="true">
		<preset>@TENANT_NO</preset>
	</report-parameter>
	<report-parameter name="COMPANY" type="integer" hidden="true">
		<preset>@COMPANY_NO</preset>
	</report-parameter>
		<report-parameter name="DEPARTMENT" type="integer" hidden="true">
		<preset>@DEPARTMENT_NO</preset>
	</report-parameter>



	
	<report-result report-dataset="businessunits">
	</report-result>


	
	<report-result report-dataset="supplier">
	</report-result>
	<report-result report-dataset="item_purchase_groups">
	</report-result>
	<report-result report-dataset="item_groups">
	</report-result>

	<report-transaction report-nm="item-list" report-transaction="net.spa.pos.transactions.LoadJSItems">
	</report-transaction>

	<report-dataset name="businessunits">
		<sql>
			select * from businessunits where tenant_no=@TENANT_NO and
			company_no=@COMPANY_NO and department_no=@DEPARTMENT_NO and businessunit_no=@BUSINESSUNIT_NO
		</sql>
	</report-dataset>
	
	
	<report-dataset name="supplier">
		<sql>
			select contact_no ID, first_nm, contact_nm

			from contacts 
			where tenant_no=@TENANT_NO
		</sql>
	</report-dataset>
	
	<report-dataset name="item_purchase_groups">
		<sql>
			select item_purchase_group_cd ID, item_purchase_group_nm

			from item_purchase_groups 
			where tenant_no=@TENANT_NO and company_no=@COMPANY_NO 
		</sql>
	</report-dataset>
	
	<report-dataset name="item_groups">
		<sql>
			select item_group_cd ID, item_group_nm, parent_item_group_cd

			from item_groups 
			where tenant_no=@TENANT_NO and company_no=@COMPANY_NO 
		</sql>
	</report-dataset>

	
	
</report>
