Product Catalog Service XML Draft

service.xml

<?xml version="1.0"?>
<!DOCTYPE service-builder PUBLIC "-//Liferay//DTD Service Builder 6.2.0//EN" "http://www.liferay.com/dtd/liferay-service-builder_6_2_0.dtd">

<service-builder package-path="com.liferay.commerce" auto-namespace-tables="false">
	<author>Eduardo Lundgren</author>
	<namespace>Product</namespace>
	<entity name="Product" uuid="true" local-service="true" remote-service="false">

		<!-- PK fields -->

		<column name="productId" type="long" primary="true" />

		<!-- Group instance -->

		<column name="groupId" type="long" />

		<!-- Audit fields -->

		<column name="companyId" type="long" />
		<column name="userId" type="long" />
		<column name="userName" type="String" />
		<column name="createDate" type="Date" />
		<column name="modifiedDate" type="Date" />

		<!-- Permission fields -->

		<column name="resourceBlockId" type="long" />

		<!-- Other fields -->

		<column name="sku" type="String" />
		<column name="name" type="String" localized="true" />

		<!-- Order -->

		<order by="asc">
			<order-column name="name" />
		</order>

		<!-- Finder methods -->

		<finder name="G_S" return-type="Collection" unique="true">
			<finder-column name="groupId" />
			<finder-column name="sku" />
		</finder>
	</entity>
	<entity name="PriceBook" uuid="true" local-service="true" remote-service="false">

		<!-- PK fields -->

		<column name="priceBookId" type="long" primary="true" />

		<!-- Group instance -->

		<column name="groupId" type="long" />

		<!-- Audit fields -->

		<column name="companyId" type="long" />
		<column name="userId" type="long" />
		<column name="userName" type="String" />
		<column name="createDate" type="Date" />
		<column name="modifiedDate" type="Date" />

		<!-- Permission fields -->

		<column name="resourceBlockId" type="long" />

		<!-- Other fields -->

		<column name="name" type="String" localized="true" />
		<column name="description" type="String" localized="true" />
		<column name="parentPriceBookId" type="long" />
		<column name="startDate" type="long" />
		<column name="endDate" type="long" />

		<!-- Order -->

		<order by="asc">
			<order-column name="name" />
		</order>

		<!-- Finder methods -->

		<finder name="ParentPriceBookId" return-type="PriceBook" unique="true">
			<finder-column name="parentPriceBookId" />
		</finder>
	</entity>

	<entity name="Price" uuid="true" local-service="true" remote-service="false">

		<!-- PK fields -->

		<column name="priceId" type="long" primary="true" />

		<!-- Group instance -->

		<column name="groupId" type="long" />

		<!-- Audit fields -->

		<column name="companyId" type="long" />
		<column name="userId" type="long" />
		<column name="userName" type="String" />
		<column name="createDate" type="Date" />
		<column name="modifiedDate" type="Date" />

		<!-- Permission fields -->

		<column name="resourceBlockId" type="long" />

		<!-- Other fields -->

		<column name="amount" type="long" />
		<column name="priceBookId" type="long" />
		<column name="productId" type="long" />
		<column name="currency" type="String" />
		<column name="unity" type="String" />
		<column name="quantity" type="int" />

		<!-- Order -->

		<order by="asc">
			<order-column name="name" />
		</order>

		<!-- Finder methods -->

		<finder name="productId" return-type="Collection">
			<finder-column name="productId" />
		</finder>
		<finder name="priceBookId" return-type="Collection">
			<finder-column name="priceBookId" />
		</finder>
	</entity>
</service-builder>