Skip to content

Instantly share code, notes, and snippets.

@bonbizin

bonbizin/bbz-abc-ofbiz-entitydef-xquery.adoc

Last active October 4, 2015 11:06
Show Gist options
  • Star 1 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save bonbizin/1004adc565d468a8eb8c to your computer and use it in GitHub Desktop.
Save bonbizin/1004adc565d468a8eb8c to your computer and use it in GitHub Desktop.
Download ZIP
XQuery Transformation example with Apache Ofbiz entity definition
Raw
bbz-abc-ofbiz-entitydef-xquery.adoc

Transforming the Product Entity Definition using XQuery

We used BaseX xquery verion 3.1 to transform the product entity definition of OfBiz v13x.

The xml file used is can be found at $install/apache-ofbiz-13.07.02/applications/product/entitydef/entitymodel.xml, it’s also uploaded.

  1. The XQuery

let $seq := distinct-values( //entity/@package-name)
let $m := map:merge(
 for $i in (1 to count($seq) )
    return map:entry($seq[$i],concat("ns",$i))
)
for $x in //entity
let $ent-name := $x/@entity-name
let $pkg := $x/@package-name
order by $pkg, $ent-name
let $pfix := map:get($m,$pkg)
return element {$ent-name} { namespace { $pfix }  {$pkg}, for $f in $x/field return element {$f/@name}{ attribute type {$f/@type}}}

The output is also attached with the gist.

Raw
mk-ele.xq
let $seq := distinct-values( //entity/@package-name)
let $m := map:merge(
for $i in (1 to count($seq) )
return map:entry($seq[$i],concat("ns",$i))
)
for $x in //entity
let $ent-name := $x/@entity-name
let $pkg := $x/@package-name
order by $pkg, $ent-name
let $pfix := map:get($m,$pkg)
return element {$ent-name} { namespace { $pfix } {$pkg}, for $f in $x/field return element {$f/@name}{ attribute type {$f/@type}}}
Raw
ofbiz-product-entitydef.xml
<!--
Licensed to the Apache Software Foundation (ASF) under one
or more contributor license agreements. See the NOTICE file
distributed with this work for additional information
regarding copyright ownership. The ASF licenses this file
to you under the Apache License, Version 2.0 (the
"License"); you may not use this file except in compliance
with the License. You may obtain a copy of the License at
http://www.apache.org/licenses/LICENSE-2.0
Unless required by applicable law or agreed to in writing,
software distributed under the License is distributed on an
"AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
KIND, either express or implied. See the License for the
specific language governing permissions and limitations
under the License.
-->
<entitymodel xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:noNamespaceSchemaLocation="http://ofbiz.apache.org/dtds/entitymodel.xsd">
<!-- ========================================================= -->
<!-- ======================== Defaults ======================= -->
<!-- ========================================================= -->
<title>Entity of an Open For Business Project Component</title>
<description>None</description>
<version>1.0</version>
<default-resource-name>ProductEntityLabels</default-resource-name>
<!-- ========================================================= -->
<!-- ======================== Data Model ===================== -->
<!-- The modules in this file are as follows: -->
<!-- - org.ofbiz.product.catalog -->
<!-- - org.ofbiz.product.category -->
<!-- - org.ofbiz.product.config -->
<!-- - org.ofbiz.product.cost -->
<!-- - org.ofbiz.product.facility -->
<!-- - org.ofbiz.product.feature -->
<!-- - org.ofbiz.product.inventory -->
<!-- - org.ofbiz.product.price -->
<!-- - org.ofbiz.product.product -->
<!-- - org.ofbiz.product.promo -->
<!-- - org.ofbiz.product.store -->
<!-- - org.ofbiz.product.subscription -->
<!-- - org.ofbiz.product.supplier -->
<!-- ========================================================= -->
<!-- ========================================================= -->
<!-- org.ofbiz.product.catalog -->
<!-- ========================================================= -->
<entity entity-name="ProdCatalog"
package-name="org.ofbiz.product.catalog"
title="Catalog Entity" default-resource-name="ProductEntityLabels">
<field name="prodCatalogId" type="id-ne"></field>
<field name="catalogName" type="name"></field>
<field name="useQuickAdd" type="indicator"></field>
<field name="styleSheet" type="url"></field>
<field name="headerLogo" type="url"></field>
<field name="contentPathPrefix" type="long-varchar"></field>
<field name="templatePathPrefix" type="long-varchar"></field>
<field name="viewAllowPermReqd" type="indicator"></field>
<field name="purchaseAllowPermReqd" type="indicator"></field>
<prim-key field="prodCatalogId"/>
</entity>
<entity entity-name="ProdCatalogCategory"
package-name="org.ofbiz.product.catalog"
default-resource-name="ProductEntityLabels"
title="Catalog Category Association Entity">
<field name="prodCatalogId" type="id-ne"></field>
<field name="productCategoryId" type="id-ne"></field>
<field name="prodCatalogCategoryTypeId" type="id"></field>
<field name="fromDate" type="date-time"></field>
<field name="thruDate" type="date-time"></field>
<field name="sequenceNum" type="numeric"></field>
<prim-key field="prodCatalogId"/>
<prim-key field="productCategoryId"/>
<prim-key field="prodCatalogCategoryTypeId"/>
<prim-key field="fromDate"/>
<relation type="one" fk-name="PROD_CC_CATALOG" rel-entity-name="ProdCatalog">
<key-map field-name="prodCatalogId"/>
</relation>
<relation type="one" fk-name="PROD_CC_CATEGORY" rel-entity-name="ProductCategory">
<key-map field-name="productCategoryId"/>
</relation>
<relation type="one" fk-name="PROD_CC_TYPE" rel-entity-name="ProdCatalogCategoryType">
<key-map field-name="prodCatalogCategoryTypeId"/>
</relation>
</entity>
<entity entity-name="ProdCatalogCategoryType"
package-name="org.ofbiz.product.catalog"
default-resource-name="ProductEntityLabels"
title="Catalog Category Association Type Entity">
<field name="prodCatalogCategoryTypeId" type="id-ne"></field>
<field name="parentTypeId" type="id"></field>
<field name="description" type="description"></field>
<prim-key field="prodCatalogCategoryTypeId"/>
<relation type="one" fk-name="PROD_PCCT_TYPEPAR" title="Parent" rel-entity-name="ProdCatalogCategoryType">
<key-map field-name="parentTypeId" rel-field-name="prodCatalogCategoryTypeId"/>
</relation>
</entity>
<entity entity-name="ProdCatalogInvFacility"
package-name="org.ofbiz.product.catalog"
title="Product Catalog Inventory Facility Applicability Entity">
<field name="prodCatalogId" type="id-ne"></field>
<field name="facilityId" type="id-ne"></field>
<field name="fromDate" type="date-time"></field>
<field name="thruDate" type="date-time"></field>
<field name="sequenceNum" type="numeric"></field>
<prim-key field="prodCatalogId"/>
<prim-key field="facilityId"/>
<prim-key field="fromDate"/>
<relation type="one" fk-name="PROD_CIF_CATALOG" rel-entity-name="ProdCatalog">
<key-map field-name="prodCatalogId"/>
</relation>
<relation type="one" fk-name="PROD_CIF_FACILITY" rel-entity-name="Facility">
<key-map field-name="facilityId"/>
</relation>
</entity>
<entity entity-name="ProdCatalogRole"
package-name="org.ofbiz.product.catalog"
title="ProdCatalog Role Association Entity">
<field name="partyId" type="id-ne"></field>
<field name="roleTypeId" type="id-ne"></field>
<field name="prodCatalogId" type="id-ne"></field>
<field name="fromDate" type="date-time"></field>
<field name="thruDate" type="date-time"></field>
<field name="sequenceNum" type="numeric"></field>
<prim-key field="partyId"/>
<prim-key field="roleTypeId"/>
<prim-key field="prodCatalogId"/>
<prim-key field="fromDate"/>
<relation type="one-nofk" rel-entity-name="Party">
<key-map field-name="partyId"/>
</relation>
<relation type="one-nofk" rel-entity-name="RoleType">
<key-map field-name="roleTypeId"/>
</relation>
<relation type="one-nofk" rel-entity-name="Person">
<key-map field-name="partyId"/>
</relation>
<relation type="one-nofk" rel-entity-name="PartyGroup">
<key-map field-name="partyId"/>
</relation>
<relation type="one" fk-name="PCATRLE_PTYRLE" rel-entity-name="PartyRole">
<key-map field-name="partyId"/>
<key-map field-name="roleTypeId"/>
</relation>
<relation type="one" fk-name="PCATRLE_CATALOG" rel-entity-name="ProdCatalog">
<key-map field-name="prodCatalogId"/>
</relation>
</entity>
<!-- ========================================================= -->
<!-- org.ofbiz.product.category -->
<!-- ========================================================= -->
<view-entity entity-name="ProductAndCategoryMember"
package-name="org.ofbiz.product.category"
title="Product And ProductCategoryMember View Entity">
<member-entity entity-alias="PROD" entity-name="Product"/>
<member-entity entity-alias="PCM" entity-name="ProductCategoryMember"/>
<alias-all entity-alias="PROD"/>
<alias-all entity-alias="PCM">
<exclude field="comments"/>
</alias-all>
<alias name="memberComments" entity-alias="PCM" field="comments"/>
<view-link entity-alias="PROD" rel-entity-alias="PCM">
<key-map field-name="productId"/>
</view-link>
<relation type="one-nofk" rel-entity-name="ProductCategoryMember">
<key-map field-name="productCategoryId"/>
<key-map field-name="productId"/>
<key-map field-name="fromDate"/>
</relation>
<relation type="one-nofk" rel-entity-name="Product">
<key-map field-name="productId"/>
</relation>
</view-entity>
<entity entity-name="ProductCategory"
package-name="org.ofbiz.product.category"
title="Product Category Entity">
<field name="productCategoryId" type="id-ne"></field>
<field name="productCategoryTypeId" type="id"></field>
<field name="primaryParentCategoryId" type="id"></field>
<field name="categoryName" type="name"></field>
<field name="description" type="description"></field>
<field name="longDescription" type="very-long"></field>
<field name="categoryImageUrl" type="url"></field>
<field name="linkOneImageUrl" type="url"></field>
<field name="linkTwoImageUrl" type="url"></field>
<field name="detailScreen" type="long-varchar"></field>
<field name="showInSelect" type="indicator"></field>
<prim-key field="productCategoryId"/>
<relation type="one" fk-name="PROD_CTGRY_TYPE" rel-entity-name="ProductCategoryType">
<key-map field-name="productCategoryTypeId"/>
</relation>
<relation type="many" rel-entity-name="ProductCategoryTypeAttr">
<key-map field-name="productCategoryTypeId"/>
</relation>
<relation type="one" fk-name="PROD_CTGRY_PARENT" title="PrimaryParent" rel-entity-name="ProductCategory">
<key-map field-name="primaryParentCategoryId" rel-field-name="productCategoryId"/>
</relation>
<relation type="many" title="PrimaryChild" rel-entity-name="ProductCategory">
<key-map field-name="productCategoryId" rel-field-name="primaryParentCategoryId"/>
</relation>
</entity>
<view-entity entity-name="ProductCategoryAndMember"
package-name="org.ofbiz.product.category"
title="ProductCategory And ProductCategoryMember View Entity">
<member-entity entity-alias="PC" entity-name="ProductCategory"/>
<member-entity entity-alias="PCM" entity-name="ProductCategoryMember"/>
<alias-all entity-alias="PC"/>
<alias-all entity-alias="PCM"/>
<view-link entity-alias="PC" rel-entity-alias="PCM">
<key-map field-name="productCategoryId"/>
</view-link>
<relation type="one-nofk" rel-entity-name="ProductCategoryMember">
<key-map field-name="productCategoryId"/>
<key-map field-name="productId"/>
<key-map field-name="fromDate"/>
</relation>
<relation type="one-nofk" rel-entity-name="ProductCategory">
<key-map field-name="productCategoryId"/>
</relation>
<relation type="one-nofk" rel-entity-name="Product">
<key-map field-name="productId"/>
</relation>
</view-entity>
<entity entity-name="ProductCategoryAttribute"
package-name="org.ofbiz.product.category"
title="Product Category Attribute Entity">
<field name="productCategoryId" type="id-ne"></field>
<field name="attrName" type="id-long-ne"></field>
<field name="attrValue" type="value"></field>
<prim-key field="productCategoryId"/>
<prim-key field="attrName"/>
<relation type="one" fk-name="PROD_CTGRY_ATTR" rel-entity-name="ProductCategory">
<key-map field-name="productCategoryId"/>
</relation>
<relation type="many" rel-entity-name="ProductCategoryTypeAttr">
<key-map field-name="attrName"/>
</relation>
</entity>
<entity entity-name="ProductCategoryContent"
package-name="org.ofbiz.product.category"
title="Product Category Data Object Entity">
<field name="productCategoryId" type="id-ne"></field>
<field name="contentId" type="id-ne"></field>
<field name="prodCatContentTypeId" type="id-ne"></field>
<field name="fromDate" type="date-time"></field>
<field name="thruDate" type="date-time"></field>
<field name="purchaseFromDate" type="date-time"></field>
<field name="purchaseThruDate" type="date-time"></field>
<field name="useCountLimit" type="numeric"></field>
<field name="useDaysLimit" type="fixed-point"></field>
<prim-key field="productCategoryId"/>
<prim-key field="contentId"/>
<prim-key field="prodCatContentTypeId"/>
<prim-key field="fromDate"/>
<relation type="one" fk-name="PRDCAT_CNT_PRDCAT" rel-entity-name="ProductCategory">
<key-map field-name="productCategoryId"/>
</relation>
<relation type="one" fk-name="PRDCAT_CNT_CNT" rel-entity-name="Content">
<key-map field-name="contentId"/>
</relation>
<relation type="one" fk-name="PRDCAT_CNT_TYPE" rel-entity-name="ProductCategoryContentType">
<key-map field-name="prodCatContentTypeId"/>
</relation>
<index name="PRDCAT_CNT_CTTP">
<index-field name="productCategoryId"/>
<index-field name="prodCatContentTypeId"/>
</index>
</entity>
<view-entity entity-name="ProductCategoryContentAndInfo"
package-name="org.ofbiz.product.category"
title="ProductCategoryContent, Content and DataResource View Entity">
<member-entity entity-alias="PCC" entity-name="ProductCategoryContent"/>
<member-entity entity-alias="CO" entity-name="Content"/>
<member-entity entity-alias="DR" entity-name="DataResource"/>
<alias-all entity-alias="PCC"/>
<alias-all entity-alias="CO"/>
<alias-all entity-alias="DR" prefix="dr"/>
<view-link entity-alias="PCC" rel-entity-alias="CO">
<key-map field-name="contentId"/>
</view-link>
<view-link entity-alias="CO" rel-entity-alias="DR">
<key-map field-name="dataResourceId"/>
</view-link>
<relation type="one-nofk" rel-entity-name="ElectronicText">
<key-map field-name="dataResourceId"/>
</relation>
<relation type="one-nofk" rel-entity-name="ImageDataResource">
<key-map field-name="dataResourceId"/>
</relation>
<relation type="one-nofk" rel-entity-name="OtherDataResource">
<key-map field-name="dataResourceId"/>
</relation>
<relation type="many" rel-entity-name="ContentAssocDataResourceViewFrom">
<key-map field-name="contentId" rel-field-name="contentIdStart"/>
</relation>
<relation type="many" rel-entity-name="ContentAssocDataResourceViewTo">
<key-map field-name="contentId" rel-field-name="contentIdStart"/>
</relation>
</view-entity>
<entity entity-name="ProductCategoryContentType"
package-name="org.ofbiz.product.category"
default-resource-name="ProductEntityLabels"
title="Product Category Content Type Entity">
<field name="prodCatContentTypeId" type="id-ne"></field>
<field name="parentTypeId" type="id"></field>
<field name="hasTable" type="indicator"></field>
<field name="description" type="description"></field>
<prim-key field="prodCatContentTypeId"/>
<relation type="one" fk-name="PRDCATCNT_TYP_PAR" title="Parent" rel-entity-name="ProductCategoryContentType">
<key-map field-name="parentTypeId" rel-field-name="prodCatContentTypeId"/>
</relation>
</entity>
<entity entity-name="ProductCategoryGlAccount" package-name="org.ofbiz.product.category" title="Product Category GlAccount Entity">
<field name="productCategoryId" type="id-ne"></field>
<field name="organizationPartyId" type="id-ne"></field>
<field name="glAccountTypeId" type="id-ne"></field>
<field name="glAccountId" type="id-ne"></field>
<prim-key field="productCategoryId"/>
<prim-key field="organizationPartyId"/>
<prim-key field="glAccountTypeId"/>
<relation type="one" fk-name="PRD_CT_GLACT_PCAT" rel-entity-name="ProductCategory">
<key-map field-name="productCategoryId"/>
</relation>
<relation type="one" fk-name="PRD_CT_GLACT_PRTY" rel-entity-name="Party">
<key-map field-name="organizationPartyId" rel-field-name="partyId"/>
</relation>
<relation type="one" fk-name="PRD_CT_GLACT_TYPE" rel-entity-name="GlAccountType">
<key-map field-name="glAccountTypeId"/>
</relation>
<relation type="one" fk-name="PRD_CT_GLACT_GLACT" rel-entity-name="GlAccount">
<key-map field-name="glAccountId"/>
</relation>
</entity>
<entity entity-name="ProductCategoryLink"
package-name="org.ofbiz.product.category"
title="Product Category Link Entity">
<field name="productCategoryId" type="id-ne"></field>
<field name="linkSeqId" type="id-ne"></field>
<field name="fromDate" type="date-time"></field>
<field name="thruDate" type="date-time"></field>
<field name="comments" type="comment"><description>Internal comments, not for public display.</description></field>
<field name="sequenceNum" type="numeric"><description>This field is used to sort the links. The linkSeqId field is not used because it is part of the primary key and cannot be changed.</description></field>
<field name="titleText" type="description"></field>
<field name="detailText" type="very-long"></field>
<field name="imageUrl" type="url"></field>
<field name="imageTwoUrl" type="url"></field>
<field name="linkTypeEnumId" type="id"></field>
<field name="linkInfo" type="long-varchar"></field>
<field name="detailSubScreen" type="long-varchar"><description>This is optional. If not specified a default should be used by the category detail template.</description></field>
<prim-key field="productCategoryId"/>
<prim-key field="linkSeqId"/>
<prim-key field="fromDate"/>
<relation type="one" fk-name="PROD_CLNK_CATEGORY" rel-entity-name="ProductCategory">
<key-map field-name="productCategoryId"/>
</relation>
<relation type="one" fk-name="PROD_CLNK_LKTPENM" title="LinkType" rel-entity-name="Enumeration">
<key-map field-name="linkTypeEnumId" rel-field-name="enumId"/>
</relation>
</entity>
<entity entity-name="ProductCategoryMember"
package-name="org.ofbiz.product.category"
title="Product Category Member Entity">
<field name="productCategoryId" type="id-ne"></field>
<field name="productId" type="id-ne"></field>
<field name="fromDate" type="date-time"></field>
<field name="thruDate" type="date-time"></field>
<field name="comments" type="comment"></field>
<field name="sequenceNum" type="numeric"></field>
<field name="quantity" type="fixed-point"></field>
<prim-key field="productCategoryId"/>
<prim-key field="productId"/>
<prim-key field="fromDate"/>
<relation type="one" fk-name="PROD_CMBR_PRODUCT" rel-entity-name="Product">
<key-map field-name="productId"/>
</relation>
<relation type="one" fk-name="PROD_CMBR_CATEGORY" rel-entity-name="ProductCategory">
<key-map field-name="productCategoryId"/>
</relation>
<index name="PRD_CMBR_PCT">
<index-field name="productCategoryId"/>
</index>
</entity>
<view-entity entity-name="ProductCategoryMemberAndRole"
package-name="org.ofbiz.product.category"
title="ProductCategoryMember And ProductCategoryRole View Entity">
<member-entity entity-alias="PCM" entity-name="ProductCategoryMember"/>
<member-entity entity-alias="PCR" entity-name="ProductCategoryRole"/>
<alias entity-alias="PCM" name="productId"/>
<alias entity-alias="PCM" name="productCategoryId"/>
<alias entity-alias="PCM" name="fromDate"/>
<alias entity-alias="PCM" name="thruDate"/>
<alias entity-alias="PCM" name="comments"/>
<alias entity-alias="PCM" name="sequenceNum"/>
<alias entity-alias="PCM" name="quantity"/>
<alias entity-alias="PCR" name="partyId"/>
<alias entity-alias="PCR" name="roleTypeId"/>
<alias entity-alias="PCR" name="roleFromDate" field="fromDate"/>
<alias entity-alias="PCR" name="roleThruDate" field="thruDate"/>
<alias entity-alias="PCR" name="roleComments" field="comments"/>
<view-link entity-alias="PCM" rel-entity-alias="PCR">
<key-map field-name="productCategoryId"/>
</view-link>
<relation type="one-nofk" rel-entity-name="ProductCategoryMember">
<key-map field-name="productCategoryId"/>
<key-map field-name="productId"/>
<key-map field-name="fromDate"/>
</relation>
<relation type="one-nofk" rel-entity-name="ProductCategoryRole">
<key-map field-name="productCategoryId"/>
<key-map field-name="partyId"/>
<key-map field-name="roleTypeId"/>
<key-map field-name="roleFromDate" rel-field-name="fromDate"/>
</relation>
<relation type="one-nofk" rel-entity-name="ProductCategory">
<key-map field-name="productCategoryId"/>
</relation>
<relation type="one-nofk" rel-entity-name="Product">
<key-map field-name="productId"/>
</relation>
</view-entity>
<entity entity-name="ProductCategoryRole"
package-name="org.ofbiz.product.category"
title="Product Category Role Entity">
<field name="productCategoryId" type="id-ne"></field>
<field name="partyId" type="id-ne"></field>
<field name="roleTypeId" type="id-ne"></field>
<field name="fromDate" type="date-time"></field>
<field name="thruDate" type="date-time"></field>
<field name="comments" type="comment"></field>
<prim-key field="productCategoryId"/>
<prim-key field="partyId"/>
<prim-key field="roleTypeId"/>
<prim-key field="fromDate"/>
<relation type="one-nofk" rel-entity-name="Party">
<key-map field-name="partyId"/>
</relation>
<relation type="one-nofk" rel-entity-name="RoleType">
<key-map field-name="roleTypeId"/>
</relation>
<relation type="one" fk-name="PROD_CRLE_PTYRLE" rel-entity-name="PartyRole">
<key-map field-name="partyId"/>
<key-map field-name="roleTypeId"/>
</relation>
<relation type="one" fk-name="PROD_CRLE_CATEGORY" rel-entity-name="ProductCategory">
<key-map field-name="productCategoryId"/>
</relation>
</entity>
<entity entity-name="ProductCategoryRollup"
package-name="org.ofbiz.product.category"
title="Product Category Rollup Entity">
<field name="productCategoryId" type="id-ne"></field>
<field name="parentProductCategoryId" type="id-ne"><description>The parent category; it should be one of productCategoryId already setup in ProductCategory or ProductCategoryRollup</description></field>
<field name="fromDate" type="date-time"></field>
<field name="thruDate" type="date-time"></field>
<field name="sequenceNum" type="numeric"></field>
<prim-key field="productCategoryId"/>
<prim-key field="parentProductCategoryId"/>
<prim-key field="fromDate"/>
<relation type="one" fk-name="PROD_CRLP_CURRENT" title="Current" rel-entity-name="ProductCategory">
<key-map field-name="productCategoryId"/>
</relation>
<relation type="one" fk-name="PROD_CRLP_PARENT" title="Parent" rel-entity-name="ProductCategory">
<key-map field-name="parentProductCategoryId" rel-field-name="productCategoryId"/>
</relation>
<relation type="many" title="Child" rel-entity-name="ProductCategoryRollup">
<key-map field-name="productCategoryId" rel-field-name="parentProductCategoryId"/>
</relation>
<relation type="many" title="Parent" rel-entity-name="ProductCategoryRollup">
<key-map field-name="parentProductCategoryId" rel-field-name="productCategoryId"/>
</relation>
<relation type="many" title="Sibling" rel-entity-name="ProductCategoryRollup">
<key-map field-name="parentProductCategoryId"/>
</relation>
<index name="PRDCR_PARPC">
<index-field name="parentProductCategoryId"/>
</index>
</entity>
<view-entity entity-name="ProductCategoryRollupAndChild" package-name="org.ofbiz.product.category">
<member-entity entity-alias="PCR" entity-name="ProductCategoryRollup"/>
<member-entity entity-alias="CPC" entity-name="ProductCategory"/>
<alias-all entity-alias="CPC"/>
<alias entity-alias="PCR" name="parentProductCategoryId"/>
<alias entity-alias="PCR" name="fromDate"/>
<alias entity-alias="PCR" name="thruDate"/>
<alias entity-alias="PCR" name="sequenceNum"/>
<view-link entity-alias="PCR" rel-entity-alias="CPC">
<key-map field-name="productCategoryId"/>
</view-link>
</view-entity>
<view-entity entity-name="ProductCategoryRollupAndRole"
package-name="org.ofbiz.product.category"
title="ProductCategoryRollup And ProductCategoryRole View Entity">
<description>Allow the lookup of a category that is in another category that a party/role is related to. So, the party/role is related to the parent category.</description>
<member-entity entity-alias="PCRLP" entity-name="ProductCategoryRollup"/>
<member-entity entity-alias="PCR" entity-name="ProductCategoryRole"/>
<alias entity-alias="PCRLP" name="productCategoryId"/>
<alias entity-alias="PCRLP" name="parentProductCategoryId"/>
<alias entity-alias="PCRLP" name="fromDate"/>
<alias entity-alias="PCRLP" name="thruDate"/>
<alias entity-alias="PCRLP" name="sequenceNum"/>
<alias entity-alias="PCR" name="partyId"/>
<alias entity-alias="PCR" name="roleTypeId"/>
<alias entity-alias="PCR" name="roleFromDate" field="fromDate"/>
<alias entity-alias="PCR" name="roleThruDate" field="thruDate"/>
<alias entity-alias="PCR" name="roleComments" field="comments"/>
<view-link entity-alias="PCRLP" rel-entity-alias="PCR">
<key-map field-name="parentProductCategoryId" rel-field-name="productCategoryId"/>
</view-link>
<relation type="one-nofk" rel-entity-name="ProductCategoryRollup">
<key-map field-name="productCategoryId"/>
<key-map field-name="parentProductCategoryId"/>
<key-map field-name="fromDate"/>
</relation>
<relation type="one-nofk" rel-entity-name="ProductCategoryRole">
<key-map field-name="parentProductCategoryId" rel-field-name="productCategoryId"/>
<key-map field-name="partyId"/>
<key-map field-name="roleTypeId"/>
<key-map field-name="roleFromDate" rel-field-name="fromDate"/>
</relation>
<relation type="one-nofk" rel-entity-name="ProductCategory">
<key-map field-name="productCategoryId"/>
</relation>
<relation type="one-nofk" title="Parent" rel-entity-name="ProductCategory">
<key-map field-name="parentProductCategoryId" rel-field-name="productCategoryId"/>
</relation>
</view-entity>
<entity entity-name="ProductCategoryType"
package-name="org.ofbiz.product.category"
default-resource-name="ProductEntityLabels"
title="Product Category Type Entity">
<field name="productCategoryTypeId" type="id-ne"></field>
<field name="parentTypeId" type="id"></field>
<field name="hasTable" type="indicator"></field>
<field name="description" type="description"></field>
<prim-key field="productCategoryTypeId"/>
<relation type="one" fk-name="PROD_CTGRY_TYPEPAR" title="Parent" rel-entity-name="ProductCategoryType">
<key-map field-name="parentTypeId" rel-field-name="productCategoryTypeId"/>
</relation>
</entity>
<entity entity-name="ProductCategoryTypeAttr"
package-name="org.ofbiz.product.category"
title="Product Category Type Attribute Entity">
<field name="productCategoryTypeId" type="id-ne"></field>
<field name="attrName" type="id-long-ne"></field>
<prim-key field="productCategoryTypeId"/>
<prim-key field="attrName"/>
<relation type="one" fk-name="PROD_CTGRY_TATTR" rel-entity-name="ProductCategoryType">
<key-map field-name="productCategoryTypeId"/>
</relation>
<relation type="many" rel-entity-name="ProductCategoryAttribute">
<key-map field-name="attrName"/>
</relation>
<relation type="many" rel-entity-name="ProductCategory">
<key-map field-name="productCategoryTypeId"/>
</relation>
</entity>
<!-- ========================================================= -->
<!-- org.ofbiz.product.config -->
<!-- ========================================================= -->
<entity entity-name="ProductConfig"
package-name="org.ofbiz.product.config"
title="Product Configuration Templates Entity">
<field name="productId" type="id-ne"></field>
<field name="configItemId" type="id-ne"></field>
<field name="sequenceNum" type="numeric"></field>
<field name="fromDate" type="date-time"></field>
<field name="description" type="description"></field>
<field name="longDescription" type="very-long"></field>
<field name="configTypeId" type="id"></field>
<field name="defaultConfigOptionId" type="id"></field>
<field name="thruDate" type="date-time"></field>
<field name="isMandatory" type="indicator"></field>
<prim-key field="productId"/>
<prim-key field="configItemId"/>
<prim-key field="sequenceNum"/>
<prim-key field="fromDate"/>
<relation type="one" fk-name="PROD_CONF_PROD" title="Product" rel-entity-name="Product">
<key-map field-name="productId"/>
</relation>
<relation type="one" fk-name="PROD_CONF_ITEM" title="ConfigItem" rel-entity-name="ProductConfigItem">
<key-map field-name="configItemId"/>
</relation>
</entity>
<view-entity entity-name="ProductConfigAndProduct"
package-name="org.ofbiz.product.config"
title="Product Config And Product View Entity, to be able to see which products use a certain configuration item">
<member-entity entity-alias="PDC" entity-name="ProductConfig"/>
<member-entity entity-alias="PD" entity-name="Product"/>
<alias-all entity-alias="PDC">
<exclude field="description"/>
<exclude field="longDescription"/>
</alias-all>
<alias-all entity-alias="PD"/>
<view-link entity-alias="PDC" rel-entity-alias="PD">
<key-map field-name="productId"/>
</view-link>
</view-entity>
<entity entity-name="ProductConfigItem"
package-name="org.ofbiz.product.config"
title="Product Configuration Question Entity">
<field name="configItemId" type="id-ne"></field>
<field name="configItemTypeId" type="id"></field>
<field name="configItemName" type="name"></field>
<field name="description" type="description"></field>
<field name="longDescription" type="very-long"></field>
<field name="imageUrl" type="url"></field>
<prim-key field="configItemId"/>
</entity>
<entity entity-name="ProdConfItemContent"
package-name="org.ofbiz.product.config"
title="Product Configuration Question Data Object Entity">
<field name="configItemId" type="id-ne"></field>
<field name="contentId" type="id-ne"></field>
<field name="confItemContentTypeId" type="id-ne"></field>
<field name="fromDate" type="date-time"></field>
<field name="thruDate" type="date-time"></field>
<prim-key field="configItemId"/>
<prim-key field="contentId"/>
<prim-key field="confItemContentTypeId"/>
<prim-key field="fromDate"/>
<relation type="one" fk-name="CIMT_CNT_PCIT" rel-entity-name="ProductConfigItem">
<key-map field-name="configItemId"/>
</relation>
<relation type="one" fk-name="CIMT_CNT_CNT" rel-entity-name="Content">
<key-map field-name="contentId"/>
</relation>
<relation type="one" fk-name="CIMT_CNT_TYPE" rel-entity-name="ProdConfItemContentType">
<key-map field-name="confItemContentTypeId"/>
</relation>
</entity>
<entity entity-name="ProdConfItemContentType"
package-name="org.ofbiz.product.config"
title="Product Content Type Entity"
default-resource-name="ProductEntityLabels">
<field name="confItemContentTypeId" type="id-ne"></field>
<field name="parentTypeId" type="id"></field>
<field name="hasTable" type="indicator"></field>
<field name="description" type="description"></field>
<prim-key field="confItemContentTypeId"/>
<relation type="one" fk-name="PCICT_TYP_PARENT" title="Parent" rel-entity-name="ProdConfItemContentType">
<key-map field-name="parentTypeId" rel-field-name="confItemContentTypeId"/>
</relation>
</entity>
<entity entity-name="ProductConfigOption"
package-name="org.ofbiz.product.config"
title="Product Configuration Options Entity">
<field name="configItemId" type="id-ne"></field>
<field name="configOptionId" type="id-ne"></field>
<field name="configOptionName" type="name"></field>
<field name="description" type="description"></field>
<field name="sequenceNum" type="numeric"></field>
<prim-key field="configItemId"/>
<prim-key field="configOptionId"/>
<relation type="one" fk-name="PROD_OPTN_ITEM" title="ConfigItem" rel-entity-name="ProductConfigItem">
<key-map field-name="configItemId"/>
</relation>
</entity>
<entity entity-name="ProductConfigOptionIactn"
package-name="org.ofbiz.product.config"
title="Product Configuration Options Entity">
<field name="configItemId" type="id-ne"></field>
<field name="configOptionId" type="id-ne"></field>
<field name="configItemIdTo" type="id-ne"></field>
<field name="configOptionIdTo" type="id-ne"></field>
<field name="sequenceNum" type="numeric"></field>
<field name="configIactnTypeId" type="id"><description>INCOMPATIBLE, etc...</description></field>
<field name="description" type="description"></field>
<prim-key field="configItemId"/>
<prim-key field="configOptionId"/>
<prim-key field="configItemIdTo"/>
<prim-key field="configOptionIdTo"/>
<prim-key field="sequenceNum"/> <!-- OPTIONAL -->
<relation type="one" fk-name="PROD_OPTIA_ITEM" title="ConfigItem" rel-entity-name="ProductConfigItem">
<key-map field-name="configItemId"/>
</relation>
<relation type="one" fk-name="PROD_OPTIA_OPTN" title="ConfigOption" rel-entity-name="ProductConfigOption">
<key-map field-name="configItemId"/>
<key-map field-name="configOptionId"/>
</relation>
<relation type="one" fk-name="PROD_OPTIA_ITMT" title="ConfigItemTo" rel-entity-name="ProductConfigItem">
<key-map field-name="configItemIdTo" rel-field-name="configItemId"/>
</relation>
<relation type="one" fk-name="PROD_OPTIA_OPTT" title="ConfigOptionTo" rel-entity-name="ProductConfigOption">
<key-map field-name="configItemIdTo" rel-field-name="configItemId"/>
<key-map field-name="configOptionIdTo" rel-field-name="configOptionId"/>
</relation>
</entity>
<entity entity-name="ProductConfigProduct"
package-name="org.ofbiz.product.config"
title="Product Configuration Option to Products Entity">
<field name="configItemId" type="id-ne"></field>
<field name="configOptionId" type="id-ne"></field>
<field name="productId" type="id-ne"></field>
<field name="quantity" type="fixed-point"></field>
<field name="sequenceNum" type="numeric"></field>
<prim-key field="configItemId"/>
<prim-key field="configOptionId"/>
<prim-key field="productId"/>
<relation type="one" fk-name="PROD_CONFP_ITEM" title="ConfigItem" rel-entity-name="ProductConfigItem">
<key-map field-name="configItemId"/>
</relation>
<relation type="one" fk-name="PROD_CONFP_OPTN" title="ConfigOption" rel-entity-name="ProductConfigOption">
<key-map field-name="configItemId"/>
<key-map field-name="configOptionId"/>
</relation>
<relation type="one" fk-name="PROD_CONFP_PROD" title="Product" rel-entity-name="Product">
<key-map field-name="productId"/>
</relation>
</entity>
<entity entity-name="ProductConfigConfig"
package-name="org.ofbiz.product.config"
title="Existing Product Configurations Entity">
<field name="configId" type="id-ne"></field>
<field name="configItemId" type="id-ne"></field>
<field name="sequenceNum" type="numeric"></field>
<field name="configOptionId" type="id-ne"></field>
<field name="description" type="description"></field>
<prim-key field="configId"/>
<prim-key field="configItemId"/>
<prim-key field="configOptionId"/>
<prim-key field="sequenceNum"/>
<relation type="one" fk-name="PROD_CONFC_ITEM" title="ConfigItem" rel-entity-name="ProductConfigItem">
<key-map field-name="configItemId"/>
</relation>
<relation type="one" fk-name="PROD_CONFC_OPTN" title="ConfigOption" rel-entity-name="ProductConfigOption">
<key-map field-name="configItemId"/>
<key-map field-name="configOptionId"/>
</relation>
</entity>
<entity entity-name="ProductConfigStats"
package-name="org.ofbiz.product.config"
title="Product Configurations Stats Entity">
<field name="configId" type="id-ne"></field>
<field name="productId" type="id-ne"></field>
<field name="numOfConfs" type="numeric"></field>
<field name="configTypeId" type="id"><description>HIDDEN, TEMPLATE, etc...</description></field>
<prim-key field="configId"/>
<prim-key field="productId"/>
<relation type="one" fk-name="PROD_CONFS_PROD" title="Product" rel-entity-name="Product">
<key-map field-name="productId"/>
</relation>
</entity>
<entity entity-name="ConfigOptionProductOption"
package-name="org.ofbiz.product.config"
title="Config Option Product Options Entity">
<field name="configId" type="id-ne"></field>
<field name="configItemId" type="id-ne"></field>
<field name="sequenceNum" type="numeric"></field>
<field name="configOptionId" type="id-ne"></field>
<field name="productId" type="id-ne"></field>
<field name="productOptionId" type="id-ne"></field>
<field name="description" type="description"></field>
<prim-key field="configId"/>
<prim-key field="configItemId"/>
<prim-key field="configOptionId"/>
<prim-key field="sequenceNum"/>
<prim-key field="productId"/>
<relation type="one" fk-name="PROD_OPTN_CONF" title="Config" rel-entity-name="ProductConfigConfig">
<key-map field-name="configId"/>
<key-map field-name="configItemId"/>
<key-map field-name="configOptionId"/>
<key-map field-name="sequenceNum"/>
</relation>
<relation type="one" fk-name="PROD_OPTN_PROD" title="Product" rel-entity-name="ProductConfigProduct">
<key-map field-name="configItemId"/>
<key-map field-name="configOptionId"/>
<key-map field-name="productId"/>
</relation>
</entity>
<!-- ========================================================= -->
<!-- org.ofbiz.product.cost -->
<!-- ========================================================= -->
<entity entity-name="CostComponent"
package-name="org.ofbiz.product.cost"
default-resource-name="ProductEntityLabels"
title="Cost Component Entity">
<field name="costComponentId" type="id-ne"></field>
<field name="costComponentTypeId" type="id"></field>
<field name="productId" type="id"></field>
<field name="productFeatureId" type="id"></field>
<field name="partyId" type="id"></field>
<field name="geoId" type="id"></field>
<field name="workEffortId" type="id"></field>
<field name="fixedAssetId" type="id"></field>
<field name="costComponentCalcId" type="id"></field>
<field name="fromDate" type="date-time"></field>
<field name="thruDate" type="date-time"></field>
<field name="cost" type="fixed-point"><description>Higher precision in case it is a calculated number</description></field>
<field name="costUomId" type="id"></field>
<prim-key field="costComponentId"/>
<relation type="one" fk-name="COST_COMP_TYPE" rel-entity-name="CostComponentType">
<key-map field-name="costComponentTypeId"/>
</relation>
<relation type="many" rel-entity-name="CostComponentTypeAttr">
<key-map field-name="costComponentTypeId"/>
</relation>
<relation type="one" fk-name="COST_COMP_PRODUCT" rel-entity-name="Product">
<key-map field-name="productId"/>
</relation>
<relation type="one" fk-name="COST_COMP_PRODFEAT" rel-entity-name="ProductFeature">
<key-map field-name="productFeatureId"/>
</relation>
<relation type="one" fk-name="COST_COMP_PARTY" rel-entity-name="Party">
<key-map field-name="partyId"/>
</relation>
<relation type="one" fk-name="COST_COMP_GEO" rel-entity-name="Geo">
<key-map field-name="geoId"/>
</relation>
<relation type="one" fk-name="COST_COMP_WEFF" rel-entity-name="WorkEffort">
<key-map field-name="workEffortId"/>
</relation>
<relation type="one" fk-name="COST_COMP_FXADSST" rel-entity-name="FixedAsset">
<key-map field-name="fixedAssetId"/>
</relation>
<relation type="one" fk-name="COST_COMP_CALC" rel-entity-name="CostComponentCalc">
<key-map field-name="costComponentCalcId"/>
</relation>
<relation type="one" fk-name="COST_COMP_CUOM" title="Currency" rel-entity-name="Uom">
<key-map field-name="costUomId" rel-field-name="uomId"/>
</relation>
</entity>
<entity entity-name="CostComponentAttribute"
package-name="org.ofbiz.product.cost"
title="Cost Component Attribute Entity">
<field name="costComponentId" type="id-ne"></field>
<field name="attrName" type="id-long-ne"></field>
<field name="attrValue" type="value"></field>
<prim-key field="costComponentId"/>
<prim-key field="attrName"/>
<relation type="one" fk-name="COST_COMP_ATTR" rel-entity-name="CostComponent">
<key-map field-name="costComponentId"/>
</relation>
<relation type="many" rel-entity-name="CostComponentTypeAttr">
<key-map field-name="attrName"/>
</relation>
</entity>
<entity entity-name="CostComponentType"
package-name="org.ofbiz.product.cost"
default-resource-name="ProductEntityLabels"
title="Cost Component Type Entity">
<field name="costComponentTypeId" type="id-ne"></field>
<field name="parentTypeId" type="id-ne"></field>
<field name="hasTable" type="indicator"></field>
<field name="description" type="description"></field>
<prim-key field="costComponentTypeId"/>
<relation type="one" fk-name="COST_COMP_TYPE_PAR" title="Parent" rel-entity-name="CostComponentType">
<key-map field-name="parentTypeId" rel-field-name="costComponentTypeId"/>
</relation>
</entity>
<entity entity-name="CostComponentTypeAttr"
package-name="org.ofbiz.product.cost"
title="Cost Component Type Attribute Entity">
<field name="costComponentTypeId" type="id-ne"></field>
<field name="attrName" type="id-long-ne"></field>
<prim-key field="costComponentTypeId"/>
<prim-key field="attrName"/>
<relation type="one" fk-name="COST_COMP_TATTR" rel-entity-name="CostComponentType">
<key-map field-name="costComponentTypeId"/>
</relation>
<relation type="many" rel-entity-name="CostComponentAttribute">
<key-map field-name="attrName"/>
</relation>
<relation type="many" rel-entity-name="CostComponent">
<key-map field-name="costComponentTypeId"/>
</relation>
</entity>
<entity entity-name="CostComponentCalc"
package-name="org.ofbiz.product.cost"
title="Cost Component Calculation Entity">
<field name="costComponentCalcId" type="id-ne"></field>
<field name="description" type="description"></field>
<field name="costGlAccountTypeId" type="id"></field>
<field name="offsettingGlAccountTypeId" type="id"></field>
<field name="fixedCost" type="currency-amount"></field>
<field name="variableCost" type="currency-amount"></field>
<field name="perMilliSecond" type="numeric"></field>
<field name="currencyUomId" type="id"></field>
<field name="costCustomMethodId" type="id"></field>
<prim-key field="costComponentCalcId"/>
<relation type="one" fk-name="COST_COM_CGLAT" title="Cost" rel-entity-name="GlAccountType">
<key-map field-name="costGlAccountTypeId" rel-field-name="glAccountTypeId"/>
</relation>
<relation type="one" fk-name="COST_COM_OGLAT" title="Offsetting" rel-entity-name="GlAccountType">
<key-map field-name="offsettingGlAccountTypeId" rel-field-name="glAccountTypeId"/>
</relation>
<relation type="one" fk-name="COST_COM_CUOM" rel-entity-name="Uom">
<key-map field-name="currencyUomId" rel-field-name="uomId"/>
</relation>
<relation type="one" fk-name="COST_COM_CMET" rel-entity-name="CustomMethod">
<key-map field-name="costCustomMethodId" rel-field-name="customMethodId"/>
</relation>
</entity>
<entity entity-name="ProductCostComponentCalc"
package-name="org.ofbiz.product.cost"
title="Product Cost Calculation Entity">
<field name="productId" type="id-ne"></field>
<field name="costComponentTypeId" type="id-ne"></field>
<field name="costComponentCalcId" type="id-ne"></field>
<field name="fromDate" type="date-time"></field>
<field name="sequenceNum" type="numeric"></field>
<field name="thruDate" type="date-time"></field>
<prim-key field="productId"/>
<prim-key field="costComponentTypeId"/>
<prim-key field="fromDate"/>
<relation type="one" fk-name="PR_COS_COMPCALC" rel-entity-name="Product">
<key-map field-name="productId"/>
</relation>
<relation type="one" fk-name="PR_COS_CCT" rel-entity-name="CostComponentType">
<key-map field-name="costComponentTypeId"/>
</relation>
<relation type="one" fk-name="PR_COS_CCC" rel-entity-name="CostComponentCalc">
<key-map field-name="costComponentCalcId"/>
</relation>
</entity>
<!-- ========================================================= -->
<!-- org.ofbiz.product.facility -->
<!-- ========================================================= -->
<entity entity-name="Container" package-name="org.ofbiz.product.facility" title="Container Entity">
<field name="containerId" type="id-ne"></field>
<field name="containerTypeId" type="id"></field>
<field name="facilityId" type="id"></field>
<field name="description" type="description"></field>
<prim-key field="containerId"/>
<relation type="one" fk-name="CONTAINER_CTTYP" rel-entity-name="ContainerType">
<key-map field-name="containerTypeId"/>
</relation>
<relation type="one" fk-name="CONTAINER_FACILITY" rel-entity-name="Facility">
<key-map field-name="facilityId"/>
</relation>
</entity>
<entity entity-name="ContainerType" package-name="org.ofbiz.product.facility" title="Container Type Entity">
<field name="containerTypeId" type="id-ne"></field>
<field name="description" type="description"></field>
<prim-key field="containerTypeId"/>
</entity>
<entity entity-name="ContainerGeoPoint" package-name="org.ofbiz.product.facility" title="Container Geo Location with history">
<field name="containerId" type="id-ne"></field>
<field name="geoPointId" type="id-ne"></field>
<field name="fromDate" type="date-time"></field>
<field name="thruDate" type="date-time"></field>
<prim-key field="containerId"/>
<prim-key field="geoPointId"/>
<prim-key field="fromDate"/>
<relation type="one" fk-name="CONTNRGEOPT_CONTNR" rel-entity-name="Container">
<key-map field-name="containerId"/>
</relation>
<relation type="one" fk-name="CONTNRGEOPT_GEOPT" rel-entity-name="GeoPoint">
<key-map field-name="geoPointId"/>
</relation>
</entity>
<view-entity entity-name="ContainerAndGeoPoint" package-name="org.ofbiz.product.facility" title="Container and Geo Point View Entity">
<member-entity entity-alias="CT" entity-name="Container"/>
<member-entity entity-alias="CTGPT" entity-name="ContainerGeoPoint"/>
<member-entity entity-alias="GPT" entity-name="GeoPoint"/>
<alias-all entity-alias="GPT"/>
<alias entity-alias="CT" name="containerId"/>
<alias entity-alias="CTGPT" name="fromDate"/>
<alias entity-alias="CTGPT" name="thruDate"/>
<view-link entity-alias="CT" rel-entity-alias="CTGPT">
<key-map field-name="containerId"/>
</view-link>
<view-link entity-alias="CTGPT" rel-entity-alias="GPT">
<key-map field-name="geoPointId"/>
</view-link>
<relation type="many" rel-entity-name="ContainerGeoPoint">
<key-map field-name="containerId"/>
<key-map field-name="geoPointId"/>
</relation>
<relation type="one-nofk" rel-entity-name="Container">
<key-map field-name="containerId"/>
</relation>
<relation type="one-nofk" rel-entity-name="GeoPoint">
<key-map field-name="geoPointId"/>
</relation>
</view-entity>
<entity entity-name="Facility" package-name="org.ofbiz.product.facility" title="Facility Entity">
<field name="facilityId" type="id-ne"></field>
<field name="facilityTypeId" type="id"></field>
<field name="parentFacilityId" type="id"></field>
<field name="ownerPartyId" type="id-ne"/>
<field name="defaultInventoryItemTypeId" type="id"></field>
<field name="facilityName" type="name"></field>
<field name="primaryFacilityGroupId" type="id"></field>
<field name="oldSquareFootage" type="numeric" col-name="SQUARE_FOOTAGE"></field>
<field name="facilitySize" type="fixed-point"></field>
<field name="facilitySizeUomId" type="id"></field>
<field name="productStoreId" type="id"></field>
<field name="defaultDaysToShip" type="numeric"><description>In the absence of a product specific days to ship in ProductFacility, this will be used</description></field>
<field name="openedDate" type="date-time"></field>
<field name="closedDate" type="date-time"></field>
<field name="description" type="description"></field>
<field name="defaultDimensionUomId" type="id"><description>This field store the unit of measurement of dimension (length, width and height)</description></field>
<field name="defaultWeightUomId" type="id"></field>
<field name="geoPointId" type="id"></field>
<prim-key field="facilityId"/>
<relation type="one" fk-name="FACILITY_FCTYP" rel-entity-name="FacilityType">
<key-map field-name="facilityTypeId"/>
</relation>
<relation type="one" fk-name="FACILITY_PARENT" title="Parent" rel-entity-name="Facility">
<key-map field-name="parentFacilityId" rel-field-name="facilityId"/>
</relation>
<relation type="one" fk-name="FACILITY_PGRP" rel-entity-name="FacilityGroup">
<key-map field-name="primaryFacilityGroupId" rel-field-name="facilityGroupId"/>
</relation>
<relation type="one" fk-name="FACILITY_OWNER" title="Owner" rel-entity-name="Party">
<key-map field-name="ownerPartyId" rel-field-name="partyId"/>
</relation>
<relation type="one" fk-name="FAC_INVITM_TYPE" title="Default" rel-entity-name="InventoryItemType">
<key-map field-name="defaultInventoryItemTypeId" rel-field-name="inventoryItemTypeId"/>
</relation>
<relation type="one" fk-name="FAC_DEF_DUOM" title="Dimension" rel-entity-name="Uom">
<key-map field-name="defaultDimensionUomId" rel-field-name="uomId"/>
</relation>
<relation type="one" fk-name="FAC_DEF_WUOM" title="Weight" rel-entity-name="Uom">
<key-map field-name="defaultWeightUomId" rel-field-name="uomId"/>
</relation>
<relation type="one-nofk" rel-entity-name="ProductStore">
<description>this was changed from the FK to better handle syncronization; this may be set back to be a FK in the future</description>
<key-map field-name="productStoreId"/>
</relation>
<relation type="many" rel-entity-name="FacilityTypeAttr">
<key-map field-name="facilityTypeId"/>
</relation>
<relation type="one" fk-name="FACILITY_GEOPT" rel-entity-name="GeoPoint">
<key-map field-name="geoPointId"/>
</relation>
<relation type="one" fk-name="FACILITY_SUOM" title="FacilitySize" rel-entity-name="Uom">
<key-map field-name="facilitySizeUomId" rel-field-name="uomId"/>
</relation>
</entity>
<view-entity entity-name="FacilityAndContactMech" package-name="org.ofbiz.product.facility" title="Facility and Contact Mech View Entity">
<member-entity entity-alias="FA" entity-name="Facility"/>
<member-entity entity-alias="CM" entity-name="FacilityContactMech"/>
<member-entity entity-alias="MC" entity-name="ContactMech"/>
<alias-all entity-alias="FA"/>
<alias-all entity-alias="CM"/>
<alias-all entity-alias="MC"/>
<view-link entity-alias="FA" rel-entity-alias="CM">
<key-map field-name="facilityId"/>
</view-link>
<view-link entity-alias="CM" rel-entity-alias="MC">
<key-map field-name="contactMechId"/>
</view-link>
</view-entity>
<entity entity-name="FacilityAttribute" package-name="org.ofbiz.product.facility" title="Facility Attribute Entity">
<field name="facilityId" type="id-ne"></field>
<field name="attrName" type="id-long-ne"></field>
<field name="attrValue" type="value"></field>
<prim-key field="facilityId"/>
<prim-key field="attrName"/>
<relation type="one" fk-name="FACILITY_ATTR" rel-entity-name="Facility">
<key-map field-name="facilityId"/>
</relation>
<relation type="many" rel-entity-name="FacilityTypeAttr">
<key-map field-name="attrName"/>
</relation>
</entity>
<entity entity-name="FacilityCarrierShipment" package-name="org.ofbiz.product.facility" title="Facility Role Type Entity">
<field name="facilityId" type="id-ne"></field>
<field name="partyId" type="id-ne"></field>
<field name="roleTypeId" type="id-ne"></field>
<field name="shipmentMethodTypeId" type="id-ne"></field>
<prim-key field="facilityId"/>
<prim-key field="partyId"/>
<prim-key field="roleTypeId"/>
<prim-key field="shipmentMethodTypeId"/>
<relation type="one" fk-name="FACILITY_CSH_PTY" rel-entity-name="Party">
<key-map field-name="partyId"/>
</relation>
<relation type="one" fk-name="FACILITY_CSH_FAC" rel-entity-name="Facility">
<key-map field-name="facilityId"/>
</relation>
<relation type="one" fk-name="FACILITY_CSH_STP" rel-entity-name="ShipmentMethodType">
<key-map field-name="shipmentMethodTypeId"/>
</relation>
<relation type="one" fk-name="FACILITY_CSH_CSM" rel-entity-name="CarrierShipmentMethod">
<key-map field-name="shipmentMethodTypeId"/>
<key-map field-name="partyId"/>
<key-map field-name="roleTypeId"/>
</relation>
</entity>
<entity entity-name="FacilityContactMech" package-name="org.ofbiz.product.facility" title="Facility Contact Mechanism Entity">
<field name="facilityId" type="id-ne"></field>
<field name="contactMechId" type="id-ne"></field>
<field name="fromDate" type="date-time"></field>
<field name="thruDate" type="date-time"></field>
<field name="extension" type="very-short"></field>
<field name="comments" type="comment"></field>
<prim-key field="facilityId"/>
<prim-key field="contactMechId"/>
<prim-key field="fromDate"/>
<relation type="one" fk-name="FACIL_CMECH_FACIL" rel-entity-name="Facility">
<key-map field-name="facilityId"/>
</relation>
<relation type="one" fk-name="FACIL_CMECH_CMECH" rel-entity-name="ContactMech">
<key-map field-name="contactMechId"/>
</relation>
<relation type="one-nofk" rel-entity-name="TelecomNumber">
<key-map field-name="contactMechId"/>
</relation>
<relation type="many" rel-entity-name="FacilityContactMechPurpose">
<key-map field-name="facilityId"/>
<key-map field-name="contactMechId"/>
</relation>
</entity>
<entity entity-name="FacilityContactMechPurpose" package-name="org.ofbiz.product.facility" title="Facility Contact Mechanism Purpose Entity">
<field name="facilityId" type="id-ne"></field>
<field name="contactMechId" type="id-ne"></field>
<field name="contactMechPurposeTypeId" type="id-ne"></field>
<field name="fromDate" type="date-time"></field>
<field name="thruDate" type="date-time"></field>
<prim-key field="facilityId"/>
<prim-key field="contactMechId"/>
<prim-key field="contactMechPurposeTypeId"/>
<prim-key field="fromDate"/>
<relation type="many" rel-entity-name="FacilityContactMech">
<key-map field-name="facilityId"/>
<key-map field-name="contactMechId"/>
</relation>
<relation type="one" fk-name="FACIL_CMPRP_TYPE" rel-entity-name="ContactMechPurposeType">
<key-map field-name="contactMechPurposeTypeId"/>
</relation>
<relation type="one" fk-name="FACIL_CMPRP_FACIL" rel-entity-name="Facility">
<key-map field-name="facilityId"/>
</relation>
<relation type="one" fk-name="FACIL_CMPRP_CMECH" rel-entity-name="ContactMech">
<key-map field-name="contactMechId"/>
</relation>
</entity>
<entity entity-name="FacilityGroup" package-name="org.ofbiz.product.facility" title="Facility Group Entity">
<field name="facilityGroupId" type="id-ne"></field>
<field name="facilityGroupTypeId" type="id"></field>
<field name="primaryParentGroupId" type="id"></field>
<field name="facilityGroupName" type="name"></field>
<field name="description" type="description"></field>
<prim-key field="facilityGroupId"/>
<relation type="one" fk-name="FACILITY_GP_TYPE" rel-entity-name="FacilityGroupType">
<key-map field-name="facilityGroupTypeId"/>
</relation>
<relation type="one" fk-name="FACILITY_GP_PGRP" title="PrimaryParent" rel-entity-name="FacilityGroup">
<key-map field-name="primaryParentGroupId" rel-field-name="facilityGroupId"/>
</relation>
</entity>
<entity entity-name="FacilityGroupMember" package-name="org.ofbiz.product.facility" title="Facility Group Entity">
<field name="facilityId" type="id-ne"></field>
<field name="facilityGroupId" type="id-ne"></field>
<field name="fromDate" type="date-time"></field>
<field name="thruDate" type="date-time"></field>
<field name="sequenceNum" type="numeric"></field>
<prim-key field="facilityId"/>
<prim-key field="facilityGroupId"/>
<prim-key field="fromDate"/>
<relation type="one" fk-name="FACILITY_MEM_FAC" rel-entity-name="Facility">
<key-map field-name="facilityId"/>
</relation>
<relation type="one" fk-name="FACILITY_MEM_FGRP" rel-entity-name="FacilityGroup">
<key-map field-name="facilityGroupId"/>
</relation>
</entity>
<entity entity-name="FacilityGroupRole" package-name="org.ofbiz.product.facility" title="Facility Group Role Entity">
<field name="facilityGroupId" type="id-ne"></field>
<field name="partyId" type="id"></field>
<field name="roleTypeId" type="id"></field>
<prim-key field="facilityGroupId"/>
<prim-key field="partyId"/>
<prim-key field="roleTypeId"/>
<relation type="one" fk-name="FGROUP_RLE_FGRP" rel-entity-name="FacilityGroup">
<key-map field-name="facilityGroupId"/>
</relation>
<relation type="one" fk-name="FGROUP_RLE_PTRLE" rel-entity-name="PartyRole">
<key-map field-name="partyId"/>
<key-map field-name="roleTypeId"/>
</relation>
<relation type="one-nofk" rel-entity-name="Party">
<key-map field-name="partyId"/>
</relation>
<relation type="one-nofk" rel-entity-name="RoleType">
<key-map field-name="roleTypeId"/>
</relation>
</entity>
<entity entity-name="FacilityGroupRollup" package-name="org.ofbiz.product.facility" title="Facility Group Rollup Entity">
<field name="facilityGroupId" type="id-ne"></field>
<field name="parentFacilityGroupId" type="id-ne"></field>
<field name="fromDate" type="date-time"></field>
<field name="thruDate" type="date-time"></field>
<field name="sequenceNum" type="numeric"></field>
<prim-key field="facilityGroupId"/>
<prim-key field="parentFacilityGroupId"/>
<prim-key field="fromDate"/>
<relation type="one" fk-name="FGRP_FRLP_CURRENT" title="Current" rel-entity-name="FacilityGroup">
<key-map field-name="facilityGroupId"/>
</relation>
<relation type="one" fk-name="FGRP_FRLP_PARENT" title="Parent" rel-entity-name="FacilityGroup">
<key-map field-name="parentFacilityGroupId" rel-field-name="facilityGroupId"/>
</relation>
<relation type="many" title="Child" rel-entity-name="FacilityGroupRollup">
<key-map field-name="facilityGroupId" rel-field-name="parentFacilityGroupId"/>
</relation>
<relation type="many" title="Parent" rel-entity-name="FacilityGroupRollup">
<key-map field-name="parentFacilityGroupId" rel-field-name="facilityGroupId"/>
</relation>
<relation type="many" title="Sibling" rel-entity-name="FacilityGroupRollup">
<key-map field-name="parentFacilityGroupId"/>
</relation>
</entity>
<entity entity-name="FacilityGroupType" package-name="org.ofbiz.product.facility" title="Facility Group Type Entity"
default-resource-name="ProductEntityLabels">
<field name="facilityGroupTypeId" type="id-ne"></field>
<field name="description" type="description"></field>
<prim-key field="facilityGroupTypeId"/>
</entity>
<entity entity-name="FacilityLocation" package-name="org.ofbiz.product.facility" title="Facility Location Entity">
<field name="facilityId" type="id-ne"></field>
<field name="locationSeqId" type="id-ne"></field>
<field name="locationTypeEnumId" type="id-ne"></field>
<field name="areaId" type="id"></field>
<field name="aisleId" type="id"></field>
<field name="sectionId" type="id"></field>
<field name="levelId" type="id"></field>
<field name="positionId" type="id"></field>
<prim-key field="facilityId"/>
<prim-key field="locationSeqId"/>
<relation type="one" fk-name="FACILITY_LOC_FAC" rel-entity-name="Facility">
<key-map field-name="facilityId"/>
</relation>
<relation type="one" fk-name="FACILITY_LOC_TENM" title="Type" rel-entity-name="Enumeration">
<key-map field-name="locationTypeEnumId" rel-field-name="enumId"/>
</relation>
</entity>
<entity entity-name="FacilityLocationGeoPoint" package-name="org.ofbiz.product.facility" title="Facility Location Geo Location with history">
<field name="facilityId" type="id-ne"></field>
<field name="locationSeqId" type="id-ne"></field>
<field name="geoPointId" type="id-ne"></field>
<field name="fromDate" type="date-time"></field>
<field name="thruDate" type="date-time"></field>
<prim-key field="facilityId"/>
<prim-key field="locationSeqId"/>
<prim-key field="geoPointId"/>
<prim-key field="fromDate"/>
<relation type="one" fk-name="FACLOCGEOPT_FACLOC" rel-entity-name="FacilityLocation">
<key-map field-name="facilityId"/>
<key-map field-name="locationSeqId"/>
</relation>
<relation type="one" fk-name="FACLOCGEOPT_GEOPT" rel-entity-name="GeoPoint">
<key-map field-name="geoPointId"/>
</relation>
</entity>
<view-entity entity-name="FacilityLocationAndGeoPoint" package-name="org.ofbiz.product.facility" title="Facility Location and Geo Point View Entity">
<member-entity entity-alias="FL" entity-name="FacilityLocation"/>
<member-entity entity-alias="FLGPT" entity-name="FacilityLocationGeoPoint"/>
<member-entity entity-alias="GPT" entity-name="GeoPoint"/>
<alias-all entity-alias="GPT"/>
<alias entity-alias="FL" name="facilityId"/>
<alias entity-alias="FL" name="locationSeqId"/>
<alias entity-alias="FLGPT" name="fromDate"/>
<alias entity-alias="FLGPT" name="thruDate"/>
<view-link entity-alias="FL" rel-entity-alias="FLGPT">
<key-map field-name="facilityId"/>
<key-map field-name="locationSeqId"/>
</view-link>
<view-link entity-alias="FLGPT" rel-entity-alias="GPT">
<key-map field-name="geoPointId"/>
</view-link>
<relation type="many" rel-entity-name="FacilityLocationGeoPoint">
<key-map field-name="facilityId"/>
<key-map field-name="locationSeqId"/>
<key-map field-name="geoPointId"/>
</relation>
<relation type="one-nofk" rel-entity-name="FacilityLocation">
<key-map field-name="facilityId"/>
<key-map field-name="locationSeqId"/>
</relation>
<relation type="one-nofk" rel-entity-name="GeoPoint">
<key-map field-name="geoPointId"/>
</relation>
</view-entity>
<entity entity-name="FacilityParty" package-name="org.ofbiz.product.facility" title="Facility Party Entity">
<field name="facilityId" type="id"></field>
<field name="partyId" type="id"></field>
<field name="roleTypeId" type="id"></field>
<field name="fromDate" type="date-time"></field>
<field name="thruDate" type="date-time"></field>
<prim-key field="facilityId"/>
<prim-key field="partyId"/>
<prim-key field="roleTypeId"/>
<prim-key field="fromDate"/>
<relation type="one" fk-name="FACILITY_RLE_FACI" rel-entity-name="Facility">
<key-map field-name="facilityId"/>
</relation>
<relation type="one" fk-name="FACILITY_RLE_PRT" rel-entity-name="Party">
<key-map field-name="partyId"/>
</relation>
<relation type="one" fk-name="FACILITY_RLE_ROL" rel-entity-name="RoleType">
<key-map field-name="roleTypeId"/>
</relation>
<relation type="one" fk-name="FACILITY_PRTY_ROLE" rel-entity-name="PartyRole">
<key-map field-name="partyId"/>
<key-map field-name="roleTypeId"/>
</relation>
</entity>
<entity entity-name="FacilityContent" package-name="org.ofbiz.product.facility" title="Facility Content Entity">
<field name="facilityId" type="id-ne"></field>
<field name="contentId" type="id-ne"></field>
<field name="fromDate" type="date-time"></field>
<field name="thruDate" type="date-time"></field>
<prim-key field="facilityId"/>
<prim-key field="contentId"/>
<prim-key field="fromDate"/>
<relation type="one" fk-name="FAC_CNT_FAC" rel-entity-name="Facility">
<key-map field-name="facilityId"/>
</relation>
<relation type="one" fk-name="FAC_CNT_CNT" rel-entity-name="Content">
<key-map field-name="contentId"/>
</relation>
</entity>
<view-entity entity-name="FacilityContentDetail" package-name="org.ofbiz.product.facility" title="Facility Content Detail View Entity">
<member-entity entity-alias="FCT" entity-name="FacilityContent"/>
<member-entity entity-alias="CNT" entity-name="Content"/>
<alias-all entity-alias="FCT"/>
<alias-all entity-alias="CNT"/>
<view-link entity-alias="FCT" rel-entity-alias="CNT">
<key-map field-name="contentId"/>
</view-link>
<relation type="one-nofk" rel-entity-name="DataResource">
<key-map field-name="dataResourceId"/>
</relation>
<relation type="one-nofk" rel-entity-name="ContentType">
<key-map field-name="contentTypeId"/>
</relation>
</view-entity>
<entity entity-name="FacilityType" package-name="org.ofbiz.product.facility" default-resource-name="ProductEntityLabels"
title="Facility Type Entity">
<field name="facilityTypeId" type="id-ne"></field>
<field name="parentTypeId" type="id-ne"></field>
<field name="hasTable" type="indicator"></field>
<field name="description" type="description"></field>
<prim-key field="facilityTypeId"/>
<relation type="one" fk-name="FACILITY_TYPEPAR" title="Parent" rel-entity-name="FacilityType">
<key-map field-name="parentTypeId" rel-field-name="facilityTypeId"/>
</relation>
</entity>
<entity entity-name="FacilityTypeAttr" package-name="org.ofbiz.product.facility" title="Facility Type Attribute Entity">
<field name="facilityTypeId" type="id-ne"></field>
<field name="attrName" type="id-long-ne"></field>
<prim-key field="facilityTypeId"/>
<prim-key field="attrName"/>
<relation type="one" fk-name="FACILITY_TPAT_FT" rel-entity-name="FacilityType">
<key-map field-name="facilityTypeId"/>
</relation>
<relation type="many" rel-entity-name="FacilityAttribute">
<key-map field-name="attrName"/>
</relation>
<relation type="many" rel-entity-name="Facility">
<key-map field-name="facilityTypeId"/>
</relation>
</entity>
<entity entity-name="ProductFacility" package-name="org.ofbiz.product.facility" title="Product Facility Entity">
<field name="productId" type="id-ne"></field>
<field name="facilityId" type="id-ne"></field>
<field name="minimumStock" type="fixed-point"></field>
<field name="reorderQuantity" type="fixed-point"></field>
<field name="daysToShip" type="numeric"></field>
<field name="lastInventoryCount" type="fixed-point"><description>This field represents availableToPromiseTotal of a product at a certain point of time and is being updated regularly by a schedule service every hour</description></field>
<prim-key field="productId"/>
<prim-key field="facilityId"/>
<relation type="one" fk-name="PROD_FAC_PROD" rel-entity-name="Product">
<key-map field-name="productId"/>
</relation>
<relation type="one" fk-name="PROD_FAC_FAC" rel-entity-name="Facility">
<key-map field-name="facilityId"/>
</relation>
</entity>
<view-entity entity-name="ProductFacilityAndPostalAddress"
package-name="org.ofbiz.product.facility"
title="Product Facility And Contactmech And Postal Address View Entity, to be able to list products by geographic location">
<member-entity entity-alias="PDFT" entity-name="ProductFacility"/>
<member-entity entity-alias="FTCT" entity-name="FacilityContactMech"/>
<member-entity entity-alias="CT" entity-name="ContactMech"/>
<member-entity entity-alias="PTA" entity-name="PostalAddress"/>
<alias-all entity-alias="PDFT"/>
<alias-all entity-alias="FTCT"/>
<alias-all entity-alias="CT"/>
<alias-all entity-alias="PTA"/>
<view-link entity-alias="PDFT" rel-entity-alias="FTCT">
<key-map field-name="facilityId"/>
</view-link>
<view-link entity-alias="FTCT" rel-entity-alias="CT">
<key-map field-name="contactMechId"/>
</view-link>
<view-link entity-alias="CT" rel-entity-alias="PTA">
<key-map field-name="contactMechId"/>
</view-link>
</view-entity>
<entity entity-name="ProductFacilityLocation" package-name="org.ofbiz.product.facility" title="Product Facility Entity">
<field name="productId" type="id-ne"></field>
<field name="facilityId" type="id-ne"></field>
<field name="locationSeqId" type="id-ne"></field>
<field name="minimumStock" type="fixed-point"></field>
<field name="moveQuantity" type="fixed-point"></field>
<prim-key field="productId"/>
<prim-key field="facilityId"/>
<prim-key field="locationSeqId"/>
<relation type="one" fk-name="PROD_FCL_PROD" rel-entity-name="Product">
<key-map field-name="productId"/>
</relation>
<relation type="one-nofk" rel-entity-name="Facility">
<key-map field-name="facilityId"/>
</relation>
<relation type="one" fk-name="PROD_FCL_FCL" rel-entity-name="FacilityLocation">
<key-map field-name="facilityId"/>
<key-map field-name="locationSeqId"/>
</relation>
</entity>
<view-entity entity-name="ProductFacilityLocationQuantityTest" package-name="org.ofbiz.product.facility" title="ProductFacilityLocation Quantity Test View Entity">
<member-entity entity-alias="PFL" entity-name="ProductFacilityLocation"/>
<member-entity entity-alias="FL" entity-name="FacilityLocation"/>
<member-entity entity-alias="II" entity-name="InventoryItem"/>
<alias entity-alias="PFL" name="productId" group-by="true"/>
<alias entity-alias="PFL" name="facilityId" group-by="true"/>
<alias entity-alias="PFL" name="locationSeqId" group-by="true"/>
<alias entity-alias="PFL" name="minimumStock" group-by="true"/>
<alias entity-alias="PFL" name="moveQuantity" group-by="true"/>
<alias entity-alias="FL" name="locationTypeEnumId" group-by="true"/>
<alias entity-alias="II" name="availableToPromiseTotal" function="sum"/>
<alias entity-alias="II" name="quantityOnHandTotal" function="sum"/>
<view-link entity-alias="PFL" rel-entity-alias="FL">
<key-map field-name="facilityId"/>
<key-map field-name="locationSeqId"/>
</view-link>
<view-link entity-alias="PFL" rel-entity-alias="II">
<key-map field-name="productId"/>
<key-map field-name="facilityId"/>
<key-map field-name="locationSeqId"/>
</view-link>
<relation type="one-nofk" rel-entity-name="Product">
<key-map field-name="productId"/>
</relation>
<relation type="one-nofk" rel-entity-name="FacilityLocation">
<key-map field-name="facilityId"/>
<key-map field-name="locationSeqId"/>
</relation>
<relation type="one-nofk" rel-entity-name="ProductFacilityLocation">
<key-map field-name="productId"/>
<key-map field-name="facilityId"/>
<key-map field-name="locationSeqId"/>
</relation>
</view-entity>
<view-entity entity-name="ProductFacilityLocationView" package-name="org.ofbiz.product.facility" title="ProductFacilityLocation And FacilityLocation View Entity">
<member-entity entity-alias="PFL" entity-name="ProductFacilityLocation"/>
<member-entity entity-alias="FL" entity-name="FacilityLocation"/>
<alias-all entity-alias="PFL"/>
<alias-all entity-alias="FL"/>
<view-link entity-alias="PFL" rel-entity-alias="FL">
<key-map field-name="facilityId"/>
<key-map field-name="locationSeqId"/>
</view-link>
<relation type="one-nofk" rel-entity-name="FacilityLocation">
<key-map field-name="facilityId"/>
<key-map field-name="locationSeqId"/>
</relation>
<relation type="one-nofk" rel-entity-name="ProductFacilityLocation">
<key-map field-name="productId"/>
<key-map field-name="facilityId"/>
<key-map field-name="locationSeqId"/>
</relation>
<relation type="many" rel-entity-name="InventoryItem">
<key-map field-name="productId"/>
<key-map field-name="facilityId"/>
<key-map field-name="locationSeqId"/>
</relation>
</view-entity>
<!-- ========================================================= -->
<!-- org.ofbiz.product.feature -->
<!-- ========================================================= -->
<entity entity-name="ProductFeature"
package-name="org.ofbiz.product.feature"
default-resource-name="ProductEntityLabels"
title="Product Feature Entity">
<field name="productFeatureId" type="id-ne"></field>
<field name="productFeatureTypeId" type="id-ne"></field>
<field name="productFeatureCategoryId" type="id"></field>
<field name="description" type="description"></field>
<field name="uomId" type="id"></field>
<field name="numberSpecified" type="fixed-point"></field>
<field name="defaultAmount" type="currency-amount"></field>
<field name="defaultSequenceNum" type="numeric"></field>
<field name="abbrev" type="id"></field>
<field name="idCode" type="id-long"></field>
<prim-key field="productFeatureId"/>
<relation type="one" fk-name="PROD_FEAT_CATEGORY" rel-entity-name="ProductFeatureCategory">
<key-map field-name="productFeatureCategoryId"/>
</relation>
<relation type="one" fk-name="PROD_FEAT_TYPE" rel-entity-name="ProductFeatureType">
<key-map field-name="productFeatureTypeId"/>
</relation>
<relation type="one" fk-name="PROD_FEAT_UOM" rel-entity-name="Uom">
<key-map field-name="uomId"/>
</relation>
</entity>
<view-entity entity-name="ProductFeatureAndAppl"
package-name="org.ofbiz.product.feature"
title="ProductFeature And ProductFeatureAppl View Entity">
<member-entity entity-alias="PF" entity-name="ProductFeature"/>
<member-entity entity-alias="PFA" entity-name="ProductFeatureAppl"/>
<alias entity-alias="PF" name="productFeatureId"/>
<alias entity-alias="PF" name="productFeatureTypeId"/>
<alias entity-alias="PF" name="productFeatureCategoryId"/>
<alias entity-alias="PF" name="description"/>
<alias entity-alias="PF" name="uomId"/>
<alias entity-alias="PF" name="numberSpecified"/>
<alias entity-alias="PF" name="defaultAmount"/>
<alias entity-alias="PF" name="defaultSequenceNum"/>
<alias entity-alias="PF" name="abbrev"/>
<alias entity-alias="PF" name="idCode"/>
<alias entity-alias="PFA" name="productId"/>
<alias entity-alias="PFA" name="productFeatureApplTypeId"/>
<alias entity-alias="PFA" name="fromDate"/>
<alias entity-alias="PFA" name="thruDate"/>
<alias entity-alias="PFA" name="sequenceNum"/>
<alias entity-alias="PFA" name="amount"/>
<alias entity-alias="PFA" name="recurringAmount"/>
<view-link entity-alias="PF" rel-entity-alias="PFA">
<key-map field-name="productFeatureId"/>
</view-link>
<relation type="one-nofk" rel-entity-name="ProductFeature">
<key-map field-name="productFeatureId"/>
</relation>
<relation type="one-nofk" rel-entity-name="ProductFeatureAppl">
<key-map field-name="productId"/>
<key-map field-name="productFeatureId"/>
<key-map field-name="fromDate"/>
</relation>
<relation type="one-nofk" rel-entity-name="ProductFeatureType">
<key-map field-name="productFeatureTypeId"/>
</relation>
<relation type="one-nofk" rel-entity-name="ProductFeatureApplType">
<key-map field-name="productFeatureApplTypeId"/>
</relation>
<relation type="one-nofk" rel-entity-name="ProductFeatureCategory">
<key-map field-name="productFeatureCategoryId"/>
</relation>
<relation type="many" rel-entity-name="SupplierProductFeature">
<key-map field-name="productFeatureId"/>
</relation>
</view-entity>
<entity entity-name="ProductFeatureAppl"
package-name="org.ofbiz.product.feature"
title="Product Feature Applicability Entity">
<field name="productId" type="id-ne"></field>
<field name="productFeatureId" type="id-ne"></field>
<field name="productFeatureApplTypeId" type="id"></field>
<field name="fromDate" type="date-time"></field>
<field name="thruDate" type="date-time"></field>
<field name="sequenceNum" type="numeric"></field>
<field name="amount" type="currency-amount"></field>
<field name="recurringAmount" type="currency-amount"></field>
<prim-key field="productId"/>
<prim-key field="productFeatureId"/>
<prim-key field="fromDate"/>
<relation type="one" fk-name="PROD_FAPPL_TYPE" rel-entity-name="ProductFeatureApplType">
<key-map field-name="productFeatureApplTypeId"/>
</relation>
<relation type="one" fk-name="PROD_FAPPL_PRODUCT" rel-entity-name="Product">
<key-map field-name="productId"/>
</relation>
<relation type="one" fk-name="PROD_FAPPL_FEATURE" rel-entity-name="ProductFeature">
<key-map field-name="productFeatureId"/>
</relation>
</entity>
<entity entity-name="ProductFeatureApplType"
package-name="org.ofbiz.product.feature"
default-resource-name="ProductEntityLabels"
title="Product Feature Applicability Type Entity">
<field name="productFeatureApplTypeId" type="id-ne"></field>
<field name="parentTypeId" type="id"></field>
<field name="hasTable" type="indicator"></field>
<field name="description" type="description"></field>
<prim-key field="productFeatureApplTypeId"/>
<relation type="one" fk-name="PROD_FAPPL_TYPPAR" title="Parent" rel-entity-name="ProductFeatureApplType">
<key-map field-name="parentTypeId" rel-field-name="productFeatureApplTypeId"/>
</relation>
</entity>
<entity entity-name="ProductFeatureApplAttr"
package-name="org.ofbiz.product.feature"
title="Product Feature Applicability Attribute Entity">
<field name="productId" type="id-ne"></field>
<field name="productFeatureId" type="id-ne"></field>
<field name="fromDate" type="date-time"></field>
<field name="attrName" type="id-long-ne"></field>
<field name="attrValue" type="value"></field>
<prim-key field="productId"/>
<prim-key field="productFeatureId"/>
<prim-key field="fromDate"/>
<prim-key field="attrName"/>
<relation type="one" fk-name="PROD_FAPPA_PRODUCT" rel-entity-name="Product">
<key-map field-name="productId"/>
</relation>
<relation type="one" fk-name="PROD_FAPPA_FEATURE" rel-entity-name="ProductFeature">
<key-map field-name="productFeatureId"/>
</relation>
<relation type="one" fk-name="PROD_FAPPA_FEATAPP" rel-entity-name="ProductFeatureAppl">
<key-map field-name="productId"/>
<key-map field-name="productFeatureId"/>
<key-map field-name="fromDate"/>
</relation>
</entity>
<entity entity-name="ProductFeatureCategory"
package-name="org.ofbiz.product.feature"
default-resource-name="ProductEntityLabels"
title="Product Feature Category Entity">
<field name="productFeatureCategoryId" type="id-ne"></field>
<field name="parentCategoryId" type="id"></field>
<field name="description" type="description"></field>
<prim-key field="productFeatureCategoryId"/>
<relation type="one" fk-name="PROD_FEAT_CAT_PAR" title="Parent" rel-entity-name="ProductFeatureCategory">
<key-map field-name="parentCategoryId" rel-field-name="productFeatureCategoryId"/>
</relation>
</entity>
<entity entity-name="ProductFeatureCategoryAppl"
package-name="org.ofbiz.product.feature"
title="Product Feature Category Application Entity">
<field name="productCategoryId" type="id-ne"></field>
<field name="productFeatureCategoryId" type="id-ne"></field>
<field name="fromDate" type="date-time"></field>
<field name="thruDate" type="date-time"></field>
<prim-key field="productCategoryId"/>
<prim-key field="productFeatureCategoryId"/>
<prim-key field="fromDate"/>
<relation type="one" fk-name="PROD_FCAPPL_CAT" rel-entity-name="ProductCategory">
<key-map field-name="productCategoryId"/>
</relation>
<relation type="one" fk-name="PROD_FCAPPL_FCAT" rel-entity-name="ProductFeatureCategory">
<key-map field-name="productFeatureCategoryId"/>
</relation>
</entity>
<entity entity-name="ProductFeatureCatGrpAppl"
package-name="org.ofbiz.product.feature"
title="Product Category Feature Group Application Entity">
<field name="productCategoryId" type="id-ne"></field>
<field name="productFeatureGroupId" type="id-ne"></field>
<field name="fromDate" type="date-time"></field>
<field name="thruDate" type="date-time"></field>
<prim-key field="productCategoryId"/>
<prim-key field="productFeatureGroupId"/>
<prim-key field="fromDate"/>
<relation type="one" fk-name="PROD_FCGAPL_CAT" rel-entity-name="ProductCategory">
<key-map field-name="productCategoryId"/>
</relation>
<relation type="one" fk-name="PROD_FCGAPL_FGRP" rel-entity-name="ProductFeatureGroup">
<key-map field-name="productFeatureGroupId"/>
</relation>
</entity>
<entity entity-name="ProductFeatureDataResource"
package-name="org.ofbiz.product.feature"
title="Product Feature Data Resource Entity">
<field name="dataResourceId" type="id-ne"></field>
<field name="productFeatureId" type="id-ne"></field>
<prim-key field="dataResourceId"/>
<prim-key field="productFeatureId"/>
<relation type="one" fk-name="PFEAT_DR_DATRES" rel-entity-name="DataResource">
<key-map field-name="dataResourceId"/>
</relation>
<relation type="one" fk-name="PFEAT_DR_FEATURE" rel-entity-name="ProductFeature">
<key-map field-name="productFeatureId"/>
</relation>
</entity>
<entity entity-name="ProductFeatureGroup"
package-name="org.ofbiz.product.feature"
title="Product Feature Group Entity">
<field name="productFeatureGroupId" type="id-ne"></field>
<field name="description" type="description"></field>
<prim-key field="productFeatureGroupId"/>
</entity>
<view-entity entity-name="ProductFeatureGroupAndAppl"
package-name="org.ofbiz.product.feature"
title="Product Feature Group And Applicability View Entity">
<member-entity entity-alias="PFGA" entity-name="ProductFeatureGroupAppl"/>
<member-entity entity-alias="PF" entity-name="ProductFeature"/>
<alias-all entity-alias="PFGA"/>
<alias-all entity-alias="PF"/>
<view-link entity-alias="PFGA" rel-entity-alias="PF">
<key-map field-name="productFeatureId"/>
</view-link>
</view-entity>
<view-entity entity-name="ProdFeaGrpAppAndProdFeaApp"
package-name="org.ofbiz.product.feature"
title="ProductFeatureGroupAppl And ProductFeatureAppl View Entity">
<member-entity entity-alias="PFGA" entity-name="ProductFeatureGroupAppl"/>
<member-entity entity-alias="PFA" entity-name="ProductFeatureAppl"/>
<alias entity-alias="PFGA" name="productFeatureGroupId"/>
<alias entity-alias="PFGA" name="productFeatureId"/>
<alias entity-alias="PFA" name="groupFromDate" field="fromDate"/>
<alias entity-alias="PFA" name="groupThruDate" field="thruDate"/>
<alias entity-alias="PFA" name="productId"/>
<alias entity-alias="PFA" name="productFeatureApplTypeId"/>
<alias entity-alias="PFA" name="fromDate"/>
<alias entity-alias="PFA" name="thruDate"/>
<alias entity-alias="PFA" name="sequenceNum"/>
<alias entity-alias="PFA" name="amount"/>
<alias entity-alias="PFA" name="recurringAmount"/>
<view-link entity-alias="PFGA" rel-entity-alias="PFA">
<key-map field-name="productFeatureId"/>
</view-link>
</view-entity>
<entity entity-name="ProductFeatureGroupAppl"
package-name="org.ofbiz.product.feature"
title="Product Feature Group Applicability Entity">
<field name="productFeatureGroupId" type="id-ne"></field>
<field name="productFeatureId" type="id-ne"></field>
<field name="fromDate" type="date-time"></field>
<field name="thruDate" type="date-time"></field>
<field name="sequenceNum" type="numeric"></field>
<prim-key field="productFeatureGroupId"/>
<prim-key field="productFeatureId"/>
<prim-key field="fromDate"/>
<relation type="one" fk-name="PROD_FGAPP_PRODUCT" rel-entity-name="ProductFeatureGroup">
<key-map field-name="productFeatureGroupId"/>
</relation>
<relation type="one" fk-name="PROD_FGAPP_FEATURE" rel-entity-name="ProductFeature">
<key-map field-name="productFeatureId"/>
</relation>
</entity>
<entity entity-name="ProductFeatureIactn"
package-name="org.ofbiz.product.feature"
title="Product Feature Interaction Entity">
<field name="productFeatureId" type="id-ne"></field>
<field name="productFeatureIdTo" type="id-ne"></field>
<field name="productFeatureIactnTypeId" type="id"></field>
<field name="productId" type="id"></field>
<prim-key field="productFeatureId"/>
<prim-key field="productFeatureIdTo"/>
<relation type="one" fk-name="PROD_FICTN_TYPE" rel-entity-name="ProductFeatureIactnType">
<key-map field-name="productFeatureIactnTypeId"/>
</relation>
<relation type="one" fk-name="PROD_FICTN_MFEAT" title="Main" rel-entity-name="ProductFeature">
<key-map field-name="productFeatureId"/>
</relation>
<relation type="one" fk-name="PROD_FICTN_AFEAT" title="Assoc" rel-entity-name="ProductFeature">
<key-map field-name="productFeatureIdTo" rel-field-name="productFeatureId"/>
</relation>
</entity>
<entity entity-name="ProductFeatureIactnType"
package-name="org.ofbiz.product.feature"
title="Product Feature Interaction Type Entity">
<field name="productFeatureIactnTypeId" type="id-ne"></field>
<field name="parentTypeId" type="id"></field>
<field name="hasTable" type="indicator"></field>
<field name="description" type="description"></field>
<prim-key field="productFeatureIactnTypeId"/>
<relation type="one" fk-name="PROD_FICTN_TYPPAR" title="Parent" rel-entity-name="ProductFeatureIactnType">
<key-map field-name="parentTypeId" rel-field-name="productFeatureIactnTypeId"/>
</relation>
</entity>
<entity entity-name="ProductFeatureType"
package-name="org.ofbiz.product.feature"
default-resource-name="ProductEntityLabels"
title="Product Feature Type Entity">
<field name="productFeatureTypeId" type="id-ne"></field>
<field name="parentTypeId" type="id"></field>
<field name="hasTable" type="indicator"></field>
<field name="description" type="description"></field>
<prim-key field="productFeatureTypeId"/>
<relation type="one" fk-name="PROD_FEAT_TYPPAR" title="Parent" rel-entity-name="ProductFeatureType">
<key-map field-name="parentTypeId" rel-field-name="productFeatureTypeId"/>
</relation>
</entity>
<entity entity-name="ProductFeaturePrice"
package-name="org.ofbiz.product.price"
title="Product Feature Price Entity">
<field name="productFeatureId" type="id-ne"></field>
<field name="productPriceTypeId" type="id-ne"></field>
<field name="currencyUomId" type="id"></field>
<field name="fromDate" type="date-time"></field>
<field name="thruDate" type="date-time"></field>
<field name="price" type="currency-precise"></field>
<field name="createdDate" type="date-time"></field>
<field name="createdByUserLogin" type="id-vlong"></field>
<field name="lastModifiedDate" type="date-time"></field>
<field name="lastModifiedByUserLogin" type="id-vlong"></field>
<prim-key field="productFeatureId"/>
<prim-key field="productPriceTypeId"/>
<prim-key field="currencyUomId"/>
<prim-key field="fromDate"/>
<relation type="one" fk-name="PROD_F_PRICE_TYPE" rel-entity-name="ProductPriceType">
<key-map field-name="productPriceTypeId"/>
</relation>
<relation type="one" fk-name="PROD_F_PRICE_CUOM" title="Currency" rel-entity-name="Uom">
<key-map field-name="currencyUomId" rel-field-name="uomId"/>
</relation>
<relation type="one" fk-name="PROD_F_PRICE_CBUL" title="CreatedBy" rel-entity-name="UserLogin">
<key-map field-name="createdByUserLogin" rel-field-name="userLoginId"/>
</relation>
<relation type="one" fk-name="PROD_F_PRICE_LMBUL" title="LastModifiedBy" rel-entity-name="UserLogin">
<key-map field-name="lastModifiedByUserLogin" rel-field-name="userLoginId"/>
</relation>
<index name="PRD_FT_PRC_GENLKP">
<index-field name="productFeatureId"/>
<index-field name="currencyUomId"/>
</index>
</entity>
<!-- ========================================================= -->
<!-- org.ofbiz.product.inventory -->
<!-- ========================================================= -->
<view-entity entity-name="BalanceInventoryItemsView"
package-name="org.ofbiz.product.inventory"
title="Balance Inventory Items View Entity">
<member-entity entity-alias="INV" entity-name="InventoryItem"/>
<member-entity entity-alias="RES" entity-name="OrderItemShipGrpInvRes"/>
<alias entity-alias="INV" name="inventoryItemId"/>
<alias entity-alias="INV" name="productId"/>
<alias entity-alias="INV" name="facilityId"/>
<alias entity-alias="INV" name="inventoryItemTypeId"/>
<alias entity-alias="INV" name="availableToPromiseTotal"/>
<alias entity-alias="INV" name="quantityOnHandTotal"/>
<alias entity-alias="RES" name="orderId"/>
<alias entity-alias="RES" name="shipGroupSeqId"/>
<alias entity-alias="RES" name="orderItemSeqId"/>
<alias entity-alias="RES" name="quantity"/>
<alias entity-alias="RES" name="quantityNotAvailable"/>
<alias entity-alias="RES" name="reserveOrderEnumId"/>
<alias entity-alias="RES" name="reservedDatetime"/>
<alias entity-alias="RES" name="sequenceId"/>
<view-link entity-alias="INV" rel-entity-alias="RES">
<key-map field-name="inventoryItemId"/>
</view-link>
</view-entity>
<entity entity-name="InventoryItem"
package-name="org.ofbiz.product.inventory"
title="Inventory Item Entity">
<field name="inventoryItemId" type="id-ne"></field>
<field name="inventoryItemTypeId" type="id"></field>
<field name="productId" type="id"></field>
<field name="partyId" type="id"></field>
<field name="ownerPartyId" type="id"><description>The owner of the inventory item.</description></field>
<field name="statusId" type="id"></field>
<field name="datetimeReceived" type="date-time"></field>
<field name="datetimeManufactured" type="date-time"></field>
<field name="expireDate" type="date-time"></field>
<field name="facilityId" type="id"></field>
<field name="containerId" type="id"></field>
<field name="lotId" type="id"></field>
<field name="uomId" type="id"></field>
<field name="binNumber" type="id"></field>
<field name="locationSeqId" type="id"></field>
<field name="comments" type="comment"></field>
<field name="quantityOnHandTotal" type="fixed-point"></field>
<field name="availableToPromiseTotal" type="fixed-point"></field>
<field name="accountingQuantityTotal" type="fixed-point"></field>
<field name="oldQuantityOnHand" col-name="QUANTITY_ON_HAND" type="fixed-point"></field>
<field name="oldAvailableToPromise" col-name="AVAILABLE_TO_PROMISE" type="fixed-point"></field>
<field name="serialNumber" type="value"></field>
<field name="softIdentifier" type="value"></field>
<field name="activationNumber" type="value"></field>
<field name="activationValidThru" type="date-time"></field>
<field name="unitCost" type="fixed-point"><description>Higher precision in case it is a calculated number</description></field>
<field name="currencyUomId" type="id"><description>The currency Uom of the unit cost.</description></field>
<prim-key field="inventoryItemId"/>
<relation type="one" fk-name="INV_ITEM_TYPE" rel-entity-name="InventoryItemType">
<key-map field-name="inventoryItemTypeId"/>
</relation>
<relation type="many" rel-entity-name="InventoryItemTypeAttr">
<key-map field-name="inventoryItemTypeId"/>
</relation>
<relation type="one" fk-name="INV_ITEM_PRODUCT" rel-entity-name="Product">
<key-map field-name="productId"/>
</relation>
<relation type="one" fk-name="INV_ITEM_PARTY" rel-entity-name="Party">
<key-map field-name="partyId"/>
</relation>
<relation type="one" fk-name="INV_ITEM_OWNPARTY" title="Owner" rel-entity-name="Party">
<key-map field-name="ownerPartyId" rel-field-name="partyId"/>
</relation>
<relation type="one" fk-name="INV_ITEM_STTSITM" rel-entity-name="StatusItem">
<key-map field-name="statusId"/>
</relation>
<relation type="one" fk-name="INV_ITEM_FACILITY" rel-entity-name="Facility">
<key-map field-name="facilityId"/>
</relation>
<relation type="one" fk-name="INV_ITEM_CONTAINER" rel-entity-name="Container">
<key-map field-name="containerId"/>
</relation>
<relation type="one" fk-name="INV_ITEM_LOT" rel-entity-name="Lot">
<key-map field-name="lotId"/>
</relation>
<relation type="one-nofk" rel-entity-name="ProductFacility">
<key-map field-name="productId"/>
<key-map field-name="facilityId"/>
</relation>
<relation type="one-nofk" rel-entity-name="FacilityLocation">
<key-map field-name="facilityId"/>
<key-map field-name="locationSeqId"/>
</relation>
<relation type="one-nofk" rel-entity-name="ProductFacilityLocation">
<key-map field-name="productId"/>
<key-map field-name="facilityId"/>
<key-map field-name="locationSeqId"/>
</relation>
<relation type="one" fk-name="INV_ITEM_UOM" rel-entity-name="Uom">
<key-map field-name="uomId"/>
</relation>
<relation type="one" fk-name="INV_ITEM_CUOM" title="Currency" rel-entity-name="Uom">
<key-map field-name="currencyUomId" rel-field-name="uomId"/>
</relation>
<index name="INVITEM_SOFID" unique="true">
<index-field name="softIdentifier"/>
</index>
<index name="INVITEM_ACTNM" unique="true">
<index-field name="activationNumber"/>
</index>
<index name="INV_ITEM_SN">
<index-field name="serialNumber"/>
</index>
</entity>
<view-entity entity-name="InventoryItemAndLocation"
package-name="org.ofbiz.product.inventory"
title="InventoryItem And FacilityLocation View Entity">
<member-entity entity-alias="II" entity-name="InventoryItem"/>
<member-entity entity-alias="PR" entity-name="Product"/>
<member-entity entity-alias="FL" entity-name="FacilityLocation"/>
<alias-all entity-alias="II">
<exclude field="comments"/>
</alias-all>
<alias-all entity-alias="PR">
<exclude field="facilityId"/>
</alias-all>
<alias-all entity-alias="FL"/>
<view-link entity-alias="II" rel-entity-alias="FL" rel-optional="true">
<key-map field-name="facilityId"/>
<key-map field-name="locationSeqId"/>
</view-link>
<view-link entity-alias="II" rel-entity-alias="PR" rel-optional="true">
<key-map field-name="productId"/>
</view-link>
<relation type="one-nofk" rel-entity-name="ProductFacilityLocation">
<key-map field-name="productId"/>
<key-map field-name="facilityId"/>
<key-map field-name="locationSeqId"/>
</relation>
<relation type="one-nofk" rel-entity-name="FacilityLocation">
<key-map field-name="facilityId"/>
<key-map field-name="locationSeqId"/>
</relation>
<relation type="one-nofk" rel-entity-name="InventoryItem">
<key-map field-name="inventoryItemId"/>
</relation>
</view-entity>
<entity entity-name="InventoryItemAttribute"
package-name="org.ofbiz.product.inventory"
title="Inventory Item Attribute Entity">
<field name="inventoryItemId" type="id-ne"></field>
<field name="attrName" type="id-long-ne"></field>
<field name="attrValue" type="value"></field>
<prim-key field="inventoryItemId"/>
<prim-key field="attrName"/>
<relation type="one" fk-name="INV_ITEM_ATTR" rel-entity-name="InventoryItem">
<key-map field-name="inventoryItemId"/>
</relation>
<relation type="many" rel-entity-name="InventoryItemTypeAttr">
<key-map field-name="attrName"/>
</relation>
</entity>
<view-entity entity-name="InventoryItemAndDetail" package-name="org.ofbiz.product.inventory">
<member-entity entity-alias="II" entity-name="InventoryItem"/>
<member-entity entity-alias="IID" entity-name="InventoryItemDetail"/>
<alias-all entity-alias="IID"/>
<alias entity-alias="II" name="inventoryItemId"/>
<alias entity-alias="II" name="inventoryItemTypeId"/>
<alias entity-alias="II" name="productId"/>
<alias entity-alias="II" name="partyId"/>
<alias entity-alias="II" name="ownerPartyId"/>
<alias entity-alias="II" name="statusId"/>
<alias entity-alias="II" name="datetimeReceived"/>
<alias entity-alias="II" name="datetimeManufactured"/>
<alias entity-alias="II" name="expireDate"/>
<alias entity-alias="II" name="facilityId"/>
<alias entity-alias="II" name="containerId"/>
<alias entity-alias="II" name="lotId"/>
<alias entity-alias="II" name="uomId"/>
<alias entity-alias="II" name="binNumber"/>
<alias entity-alias="II" name="locationSeqId"/>
<alias entity-alias="II" name="comments"/>
<alias entity-alias="II" name="quantityOnHandTotal"/>
<alias entity-alias="II" name="availableToPromiseTotal"/>
<alias entity-alias="II" name="accountingQuantityTotal"/>
<alias entity-alias="II" name="oldQuantityOnHand"/>
<alias entity-alias="II" name="oldAvailableToPromise"/>
<alias entity-alias="II" name="serialNumber"/>
<alias entity-alias="II" name="softIdentifier"/>
<alias entity-alias="II" name="activationNumber"/>
<alias entity-alias="II" name="activationValidThru"/>
<alias entity-alias="II" name="currencyUomId"/>
<alias entity-alias="II" name="inventoryItemFixedAssetId" field="fixedAssetId"/>
<view-link entity-alias="II" rel-entity-alias="IID">
<key-map field-name="inventoryItemId"/>
</view-link>
</view-entity>
<entity entity-name="InventoryItemDetail"
package-name="org.ofbiz.product.inventory"
title="Inventory Item Detail Entity">
<field name="inventoryItemId" type="id-ne"></field>
<field name="inventoryItemDetailSeqId" type="id-ne"></field>
<field name="effectiveDate" type="date-time"></field>
<field name="quantityOnHandDiff" type="fixed-point"></field>
<field name="availableToPromiseDiff" type="fixed-point"></field>
<field name="accountingQuantityDiff" type="fixed-point"></field>
<field name="unitCost" type="fixed-point"></field>
<field name="orderId" type="id"></field>
<field name="orderItemSeqId" type="id"></field>
<field name="shipGroupSeqId" type="id"></field>
<field name="shipmentId" type="id"></field>
<field name="shipmentItemSeqId" type="id"></field>
<field name="returnId" type="id"></field>
<field name="returnItemSeqId" type="id"></field>
<field name="workEffortId" type="id"></field>
<field name="fixedAssetId" type="id"></field>
<field name="maintHistSeqId" type="id"></field>
<field name="itemIssuanceId" type="id"></field>
<field name="receiptId" type="id"></field>
<field name="physicalInventoryId" type="id"></field>
<field name="reasonEnumId" type="id"></field>
<field name="description" type="description"></field>
<prim-key field="inventoryItemId"/>
<prim-key field="inventoryItemDetailSeqId"/>
<relation type="one" fk-name="INV_ITDTL_INVIT" rel-entity-name="InventoryItem">
<key-map field-name="inventoryItemId"/>
</relation>
<relation type="one" fk-name="INV_ITDTL_WEFF" rel-entity-name="WorkEffort">
<key-map field-name="workEffortId"/>
</relation>
<relation type="one-nofk" rel-entity-name="OrderItemShipGrpInvRes">
<key-map field-name="orderId"/>
<key-map field-name="orderItemSeqId"/>
<key-map field-name="shipGroupSeqId"/>
<key-map field-name="inventoryItemId"/>
</relation>
<relation type="one" fk-name="INV_ITDTL_FAMNT" rel-entity-name="FixedAssetMaint">
<key-map field-name="fixedAssetId"/>
<key-map field-name="maintHistSeqId"/>
</relation>
<relation type="one" fk-name="INV_ITDTL_ITMIS" rel-entity-name="ItemIssuance">
<key-map field-name="itemIssuanceId"/>
</relation>
<relation type="one-nofk" rel-entity-name="WorkEffortInventoryAssign">
<key-map field-name="workEffortId"/>
<key-map field-name="inventoryItemId"/>
</relation>
<relation type="one-nofk" rel-entity-name="WorkEffortInventoryProduced">
<key-map field-name="workEffortId"/>
<key-map field-name="inventoryItemId"/>
</relation>
<relation type="one" fk-name="INV_ITDTL_SHRCT" rel-entity-name="ShipmentReceipt">
<key-map field-name="receiptId"/>
</relation>
<relation type="one" fk-name="INV_ITDTL_PHINV" rel-entity-name="PhysicalInventory">
<key-map field-name="physicalInventoryId"/>
</relation>
<relation title="Reason" fk-name="INV_ITDTL_REAS" rel-entity-name="Enumeration" type="one">
<key-map field-name="reasonEnumId" rel-field-name="enumId"/>
</relation>
<relation type="one-nofk" rel-entity-name="InventoryItemVariance">
<key-map field-name="inventoryItemId"/>
<key-map field-name="physicalInventoryId"/>
</relation>
</entity>
<view-entity entity-name="InventoryItemDetailSummary"
package-name="org.ofbiz.product.inventory"
title="Inventory Item Detail Summary View Entity">
<member-entity entity-alias="IID" entity-name="InventoryItemDetail"/>
<alias entity-alias="IID" name="inventoryItemId" group-by="true"/>
<alias entity-alias="IID" name="availableToPromiseTotal" field="availableToPromiseDiff" function="sum"/>
<alias entity-alias="IID" name="quantityOnHandTotal" field="quantityOnHandDiff" function="sum"/>
<alias entity-alias="IID" name="accountingQuantityTotal" field="accountingQuantityDiff" function="sum"/>
</view-entity>
<view-entity entity-name="InventoryItemDetailForSum" package-name="org.ofbiz.product.inventory"
title="Inventory Item And Inventory Item Detail for Summation View Entity">
<member-entity entity-alias="II" entity-name="InventoryItem"/>
<member-entity entity-alias="IID" entity-name="InventoryItemDetail"/>
<alias entity-alias="IID" name="quantityOnHandSum" field="quantityOnHandDiff" function="sum"/>
<alias entity-alias="IID" name="accountingQuantitySum" field="accountingQuantityDiff" function="sum"/>
<alias entity-alias="II" name="inventoryItemTypeId" group-by="true"></alias>
<alias entity-alias="II" name="facilityId" group-by="true"></alias>
<alias entity-alias="II" name="productId" group-by="true"></alias>
<alias entity-alias="II" name="unitCost" group-by="true"></alias>
<alias entity-alias="II" name="currencyUomId" group-by="true"></alias>
<alias entity-alias="IID" name="effectiveDate"><description>For query only, not in fields to select.</description></alias>
<alias entity-alias="IID" name="orderId"><description>For query only, not in fields to select.</description></alias>
<alias entity-alias="II" name="ownerPartyId"><description>For query only, not in fields to select.</description></alias>
<alias entity-alias="IID" name="quantityOnHandDiff"><description>For query only, not in fields to select.</description></alias>
<alias entity-alias="IID" name="accountingQuantityDiff"><description>For query only, not in fields to select.</description></alias>
<view-link entity-alias="II" rel-entity-alias="IID">
<key-map field-name="inventoryItemId"/>
</view-link>
</view-entity>
<entity entity-name="InventoryItemStatus"
package-name="org.ofbiz.product.inventory"
title="Inventory Item Status History Entity">
<field name="inventoryItemId" type="id-ne"></field>
<field name="statusId" type="id-ne"></field>
<field name="statusDatetime" type="date-time"></field>
<field name="statusEndDatetime" type="date-time"></field>
<field name="ownerPartyId" type="id"><description>Used to track a changed (new) ownerPartyId as a status changes.</description></field>
<field name="productId" type="id"><description>Used to track a changed (new) productId as a status changes. In other words over time the item may be represented by a different Product (like new versus refurbished).</description></field>
<prim-key field="inventoryItemId"/>
<prim-key field="statusId"/>
<prim-key field="statusDatetime"/>
<relation type="one" fk-name="INV_ITEM_STTS_II" rel-entity-name="InventoryItem">
<key-map field-name="inventoryItemId"/>
</relation>
<relation type="one" fk-name="INV_ITEM_STTS_SI" rel-entity-name="StatusItem">
<key-map field-name="statusId"/>
</relation>
</entity>
<view-entity entity-name="InventoryItemStatusForCount" package-name="org.ofbiz.product.inventory">
<description>This view-entity is for querying a count (findCountByCondition) of InventoryItems that were in a certain status at a certain point in time.</description>
<member-entity entity-alias="IIS" entity-name="InventoryItemStatus"/>
<member-entity entity-alias="II" entity-name="InventoryItem"/>
<alias name="facilityId" entity-alias="II"/>
<alias name="inventoryItemTypeId" entity-alias="II"/>
<alias name="inventoryItemId" entity-alias="IIS"/>
<alias name="productId" entity-alias="IIS"><description>Note that this is from the status entity because it may change over time.</description></alias>
<alias name="statusId" entity-alias="IIS"/>
<alias name="statusDatetime" entity-alias="IIS"/>
<alias name="statusEndDatetime" entity-alias="IIS"/>
<view-link entity-alias="IIS" rel-entity-alias="II">
<key-map field-name="inventoryItemId"/>
</view-link>
</view-entity>
<entity entity-name="InventoryItemTempRes"
package-name="org.ofbiz.product.inventory"
title="Inventory Item Temporary Reservation Entity">
<field name="visitId" type="id-ne"></field>
<field name="productId" type="id-ne"></field>
<field name="productStoreId" type="id-ne"></field>
<field name="quantity" type="fixed-point"></field>
<field name="reservedDate" type="date-time"></field>
<prim-key field="visitId"/>
<prim-key field="productId"/>
<prim-key field="productStoreId"/>
<relation type="one" fk-name="INV_ITEM_TR_VIS" rel-entity-name="Visit">
<key-map field-name="visitId"/>
</relation>
<relation type="one" fk-name="INV_ITEM_TR_PROD" rel-entity-name="Product">
<key-map field-name="productId"/>
</relation>
<relation type="one" fk-name="INV_ITEM_TR_PRDS" rel-entity-name="ProductStore">
<key-map field-name="productStoreId"/>
</relation>
</entity>
<entity entity-name="InventoryItemType"
package-name="org.ofbiz.product.inventory"
default-resource-name="ProductEntityLabels"
title="Inventory Item Type Entity">
<field name="inventoryItemTypeId" type="id-ne"></field>
<field name="parentTypeId" type="id-ne"></field>
<field name="hasTable" type="indicator"></field>
<field name="description" type="description"></field>
<prim-key field="inventoryItemTypeId"/>
<relation type="one" fk-name="INV_ITEM_TYPPAR" title="Parent" rel-entity-name="InventoryItemType">
<key-map field-name="parentTypeId" rel-field-name="inventoryItemTypeId"/>
</relation>
</entity>
<entity entity-name="InventoryItemTypeAttr"
package-name="org.ofbiz.product.inventory"
title="Inventory Item Type Attribute Entity">
<field name="inventoryItemTypeId" type="id-ne"></field>
<field name="attrName" type="id-long-ne"></field>
<prim-key field="inventoryItemTypeId"/>
<prim-key field="attrName"/>
<relation type="one" fk-name="INV_ITEM_TYP_ATTR" rel-entity-name="InventoryItemType">
<key-map field-name="inventoryItemTypeId"/>
</relation>
<relation type="many" rel-entity-name="InventoryItemAttribute">
<key-map field-name="attrName"/>
</relation>
<relation type="many" rel-entity-name="InventoryItem">
<key-map field-name="inventoryItemTypeId"/>
</relation>
</entity>
<entity entity-name="InventoryItemVariance"
package-name="org.ofbiz.product.inventory"
title="Inventory Item Variance Entity">
<field name="inventoryItemId" type="id-ne"></field>
<field name="physicalInventoryId" type="id-ne"></field>
<field name="varianceReasonId" type="id"></field>
<field name="availableToPromiseVar" type="fixed-point"></field>
<field name="quantityOnHandVar" type="fixed-point"></field>
<field name="comments" type="comment"></field>
<prim-key field="inventoryItemId"/>
<prim-key field="physicalInventoryId"/>
<relation type="one" fk-name="INV_ITEM_VAR_PINV" rel-entity-name="PhysicalInventory">
<key-map field-name="physicalInventoryId"/>
</relation>
<relation type="one" fk-name="INV_ITEM_VAR_RSN" rel-entity-name="VarianceReason">
<key-map field-name="varianceReasonId"/>
</relation>
<relation type="one" fk-name="INV_ITEM_VAR_ITEM" rel-entity-name="InventoryItem">
<key-map field-name="inventoryItemId"/>
</relation>
</entity>
<entity entity-name="InventoryItemLabelType"
package-name="org.ofbiz.product.inventory"
title="Inventory Item Label Type Entity">
<field name="inventoryItemLabelTypeId" type="id-ne"></field>
<field name="parentTypeId" type="id"></field>
<field name="hasTable" type="indicator"></field>
<field name="description" type="description"></field>
<prim-key field="inventoryItemLabelTypeId"/>
<relation type="one" fk-name="INV_ITLT_TYPPAR" title="Parent" rel-entity-name="InventoryItemLabelType">
<key-map field-name="parentTypeId" rel-field-name="inventoryItemLabelTypeId"/>
</relation>
</entity>
<entity entity-name="InventoryItemLabel"
package-name="org.ofbiz.product.inventory"
title="Inventory Item Label Entity">
<field name="inventoryItemLabelId" type="id-ne"></field>
<field name="inventoryItemLabelTypeId" type="id-ne"></field>
<field name="description" type="description"></field>
<prim-key field="inventoryItemLabelId"/>
<relation type="one" fk-name="INV_ITLA_TYPE" rel-entity-name="InventoryItemLabelType">
<key-map field-name="inventoryItemLabelTypeId"/>
</relation>
</entity>
<entity entity-name="InventoryItemLabelAppl"
package-name="org.ofbiz.product.inventory"
title="Inventory Item Label Applicability Entity">
<field name="inventoryItemId" type="id-ne"></field>
<field name="inventoryItemLabelTypeId" type="id-ne"></field>
<field name="inventoryItemLabelId" type="id-ne"></field>
<field name="sequenceNum" type="numeric"></field>
<prim-key field="inventoryItemId"/>
<prim-key field="inventoryItemLabelTypeId"/>
<relation type="one" fk-name="INV_ITLAP_ITEM" rel-entity-name="InventoryItem">
<key-map field-name="inventoryItemId"/>
</relation>
<relation type="one" fk-name="INV_ITLAP_TYPE" rel-entity-name="InventoryItemLabelType">
<key-map field-name="inventoryItemLabelTypeId"/>
</relation>
<relation type="one" fk-name="INV_ITLAP_LAB" rel-entity-name="InventoryItemLabel">
<key-map field-name="inventoryItemLabelId"/>
</relation>
</entity>
<entity entity-name="InventoryTransfer"
package-name="org.ofbiz.product.inventory"
title="Inventory Transfer Entity">
<field name="inventoryTransferId" type="id-ne"></field>
<field name="statusId" type="id-ne"></field>
<field name="inventoryItemId" type="id-ne"></field>
<field name="facilityId" type="id"></field>
<field name="locationSeqId" type="id"></field>
<field name="containerId" type="id"></field>
<field name="facilityIdTo" type="id"></field>
<field name="locationSeqIdTo" type="id"></field>
<field name="containerIdTo" type="id"></field>
<field name="itemIssuanceId" type="id"></field>
<field name="sendDate" type="date-time"></field>
<field name="receiveDate" type="date-time"></field>
<field name="comments" type="comment"></field>
<prim-key field="inventoryTransferId"/>
<relation type="one" fk-name="INV_XFER_ITEM" rel-entity-name="InventoryItem">
<key-map field-name="inventoryItemId"/>
</relation>
<relation type="one" fk-name="INV_XFER_STTS" rel-entity-name="StatusItem">
<key-map field-name="statusId"/>
</relation>
<relation type="one" fk-name="INV_XFER_FAC" rel-entity-name="Facility">
<key-map field-name="facilityId"/>
</relation>
<relation type="one-nofk" rel-entity-name="FacilityLocation">
<key-map field-name="facilityId"/>
<key-map field-name="locationSeqId"/>
</relation>
<relation type="one" fk-name="INV_XFER_CONT" rel-entity-name="Container">
<key-map field-name="containerId"/>
</relation>
<relation type="one" fk-name="INV_XFER_TFAC" title="To" rel-entity-name="Facility">
<key-map field-name="facilityIdTo" rel-field-name="facilityId"/>
</relation>
<relation type="one-nofk" title="To" rel-entity-name="FacilityLocation">
<key-map field-name="facilityIdTo" rel-field-name="facilityId"/>
<key-map field-name="locationSeqIdTo" rel-field-name="locationSeqId"/>
</relation>
<relation type="one" fk-name="INV_XFER_TCNT" title="To" rel-entity-name="Container">
<key-map field-name="containerIdTo" rel-field-name="containerId"/>
</relation>
<relation type="one" fk-name="INV_XFER_ISSU" rel-entity-name="ItemIssuance">
<key-map field-name="itemIssuanceId"/>
</relation>
</entity>
<entity entity-name="Lot"
package-name="org.ofbiz.product.inventory"
title="Lot Entity">
<field name="lotId" type="id-ne"></field>
<field name="creationDate" type="date-time"></field>
<field name="quantity" type="fixed-point"></field>
<field name="expirationDate" type="date-time"></field>
<prim-key field="lotId"/>
</entity>
<entity entity-name="PhysicalInventory"
package-name="org.ofbiz.product.inventory"
title="Physical Inventory Entity">
<field name="physicalInventoryId" type="id-ne"></field>
<field name="physicalInventoryDate" type="date-time"></field>
<field name="partyId" type="id"></field>
<field name="generalComments" type="comment"></field>
<prim-key field="physicalInventoryId"/>
</entity>
<view-entity entity-name="PhysicalInventoryAndVariance"
package-name="org.ofbiz.product.inventory"
title="PhysicalInventory and InventoryItemVariance View Entity">
<member-entity entity-alias="PHINV" entity-name="PhysicalInventory"/>
<member-entity entity-alias="IIV" entity-name="InventoryItemVariance"/>
<alias entity-alias="PHINV" name="physicalInventoryId"/>
<alias entity-alias="PHINV" name="physicalInventoryDate"/>
<alias entity-alias="PHINV" name="partyId"/>
<alias entity-alias="PHINV" name="generalComments"/>
<alias entity-alias="IIV" name="inventoryItemId"/>
<alias entity-alias="IIV" name="varianceReasonId"/>
<alias entity-alias="IIV" name="availableToPromiseVar"/>
<alias entity-alias="IIV" name="quantityOnHandVar"/>
<alias entity-alias="IIV" name="comments"/>
<view-link entity-alias="PHINV" rel-entity-alias="IIV">
<key-map field-name="physicalInventoryId"/>
</view-link>
<relation type="one-nofk" rel-entity-name="VarianceReason">
<key-map field-name="varianceReasonId"/>
</relation>
<relation type="one-nofk" rel-entity-name="InventoryItem">
<key-map field-name="inventoryItemId"/>
</relation>
<relation type="one-nofk" rel-entity-name="Party">
<key-map field-name="partyId"/>
</relation>
<relation type="one-nofk" rel-entity-name="Person">
<key-map field-name="partyId"/>
</relation>
<relation type="one-nofk" rel-entity-name="PartyGroup">
<key-map field-name="partyId"/>
</relation>
</view-entity>
<entity entity-name="VarianceReason"
package-name="org.ofbiz.product.inventory"
default-resource-name="ProductEntityLabels"
title="Variance Reason Entity">
<field name="varianceReasonId" type="id-ne"></field>
<field name="description" type="description"></field>
<prim-key field="varianceReasonId"/>
</entity>
<!-- ========================================================= -->
<!-- org.ofbiz.product.price -->
<!-- ========================================================= -->
<entity entity-name="ProductPaymentMethodType"
package-name="org.ofbiz.product.price"
title="Product PaymentMethodType Entity">
<field name="productId" type="id-ne"></field>
<field name="paymentMethodTypeId" type="id-ne"></field>
<field name="productPricePurposeId" type="id-ne"></field>
<field name="fromDate" type="date-time"></field>
<field name="thruDate" type="date-time"></field>
<field name="sequenceNum" type="numeric"></field>
<prim-key field="productId"/>
<prim-key field="paymentMethodTypeId"/>
<prim-key field="productPricePurposeId"/>
<prim-key field="fromDate"/>
<relation type="one" fk-name="PROD_PMT_PROD" rel-entity-name="Product">
<key-map field-name="productId"/>
</relation>
<relation type="one" fk-name="PROD_PMT_PMT" rel-entity-name="PaymentMethodType">
<key-map field-name="paymentMethodTypeId"/>
</relation>
<relation type="one" fk-name="PROD_PMT_PPRP" rel-entity-name="ProductPricePurpose">
<key-map field-name="productPricePurposeId"/>
</relation>
</entity>
<entity entity-name="ProductPrice"
package-name="org.ofbiz.product.price"
title="Product Price Entity">
<field name="productId" type="id-ne"></field>
<field name="productPriceTypeId" type="id-ne"></field>
<field name="productPricePurposeId" type="id-ne"></field>
<field name="currencyUomId" type="id"></field>
<field name="productStoreGroupId" type="id"></field>
<field name="fromDate" type="date-time"></field>
<field name="thruDate" type="date-time"></field>
<field name="price" type="currency-precise"></field>
<field name="termUomId" type="id"><description>Mainly used for recurring and usage prices to specify a time/freq measure, or a usage unit measure (bits, minutes, etc)</description></field>
<field name="customPriceCalcService" type="id"><description>Points to a CustomMethod used to specify a service for the calculation of the unit price of the product (NOTE: a better name for this field might be priceCalcCustomMethodId)</description></field>
<field name="priceWithoutTax" type="currency-precise"><description>Always without tax if populated, regardless of if price does or does not include tax.</description></field>
<field name="priceWithTax" type="currency-precise"><description>Always with tax if populated, regardless of if price does or does not include tax.</description></field>
<field name="taxAmount" type="currency-precise"/>
<field name="taxPercentage" type="fixed-point"/>
<field name="taxAuthPartyId" type="id-ne"/>
<field name="taxAuthGeoId" type="id-ne"/>
<field name="taxInPrice" type="indicator"><description>If Y the price field has tax included for the given taxAuthPartyId/taxAuthGeoId at the taxPercentage.</description></field>
<field name="createdDate" type="date-time"></field>
<field name="createdByUserLogin" type="id-vlong"></field>
<field name="lastModifiedDate" type="date-time"></field>
<field name="lastModifiedByUserLogin" type="id-vlong"></field>
<prim-key field="productId"/>
<prim-key field="productPriceTypeId"/>
<prim-key field="productPricePurposeId"/>
<prim-key field="currencyUomId"/>
<prim-key field="productStoreGroupId"/>
<prim-key field="fromDate"/>
<relation type="one" fk-name="PROD_PRICE_PROD" rel-entity-name="Product">
<key-map field-name="productId"/>
</relation>
<relation type="one" fk-name="PROD_PRICE_TYPE" rel-entity-name="ProductPriceType">
<key-map field-name="productPriceTypeId"/>
</relation>
<relation type="one" fk-name="PROD_PRICE_PURP" rel-entity-name="ProductPricePurpose">
<key-map field-name="productPricePurposeId"/>
</relation>
<relation type="one" fk-name="PROD_PRICE_CUOM" title="Currency" rel-entity-name="Uom">
<key-map field-name="currencyUomId" rel-field-name="uomId"/>
</relation>
<relation type="one" fk-name="PROD_PRICE_TUOM" title="Term" rel-entity-name="Uom">
<key-map field-name="termUomId" rel-field-name="uomId"/>
</relation>
<relation type="one" fk-name="PROD_PRICE_PSTG" rel-entity-name="ProductStoreGroup">
<key-map field-name="productStoreGroupId"/>
</relation>
<relation type="one" fk-name="PROD_PRICE_CMET" rel-entity-name="CustomMethod">
<key-map field-name="customPriceCalcService" rel-field-name="customMethodId"/>
</relation>
<relation type="one" fk-name="PROD_PRC_TAXPTY" title="TaxAuthority" rel-entity-name="Party">
<key-map field-name="taxAuthPartyId" rel-field-name="partyId"/>
</relation>
<relation type="one" fk-name="PROD_PRC_TAXGEO" title="TaxAuthority" rel-entity-name="Geo">
<key-map field-name="taxAuthGeoId" rel-field-name="geoId"/>
</relation>
<relation type="one" fk-name="PROD_PRICE_CBUL" title="CreatedBy" rel-entity-name="UserLogin">
<key-map field-name="createdByUserLogin" rel-field-name="userLoginId"/>
</relation>
<relation type="one" fk-name="PROD_PRICE_LMBUL" title="LastModifiedBy" rel-entity-name="UserLogin">
<key-map field-name="lastModifiedByUserLogin" rel-field-name="userLoginId"/>
</relation>
<index name="PRD_PRC_GENLKP">
<index-field name="productId"/>
<index-field name="productPricePurposeId"/>
<index-field name="currencyUomId"/>
<index-field name="productStoreGroupId"/>
</index>
</entity>
<entity entity-name="ProductPriceAction"
package-name="org.ofbiz.product.price"
title="Product Price Action Entity">
<field name="productPriceRuleId" type="id-ne"></field>
<field name="productPriceActionSeqId" type="id-ne"></field>
<field name="productPriceActionTypeId" type="id-ne"></field>
<field name="amount" type="fixed-point"></field>
<field name="rateCode" type="short-varchar"></field>
<prim-key field="productPriceRuleId"/>
<prim-key field="productPriceActionSeqId"/>
<relation type="one" fk-name="PROD_PCACT_TYPE" rel-entity-name="ProductPriceActionType">
<key-map field-name="productPriceActionTypeId"/>
</relation>
<relation type="one" fk-name="PROD_PCACT_RL" rel-entity-name="ProductPriceRule">
<key-map field-name="productPriceRuleId"/>
</relation>
</entity>
<entity entity-name="ProductPriceActionType"
package-name="org.ofbiz.product.price"
default-resource-name="ProductEntityLabels"
title="Product Price Type Entity">
<field name="productPriceActionTypeId" type="id-ne"></field>
<field name="description" type="description"></field>
<prim-key field="productPriceActionTypeId"/>
</entity>
<entity entity-name="ProductPriceAutoNotice"
package-name="org.ofbiz.product.price"
title="Product Price Automatic Notice History Entity">
<field name="productPriceNoticeId" type="id-ne"></field>
<field name="facilityId" type="id"></field>
<field name="runDate" type="date-time"></field>
<field name="fromDate" type="date-time"></field>
<field name="thruDate" type="date-time"></field>
<prim-key field="productPriceNoticeId"/>
</entity>
<entity entity-name="ProductPriceChange"
package-name="org.ofbiz.product.price"
title="Product Price Change History Entity">
<field name="productPriceChangeId" type="id-ne"></field>
<field name="productId" type="id-ne"></field>
<field name="productPriceTypeId" type="id-ne"></field>
<field name="productPricePurposeId" type="id-ne"></field>
<field name="currencyUomId" type="id"></field>
<field name="productStoreGroupId" type="id"></field>
<field name="fromDate" type="date-time"></field>
<field name="thruDate" type="date-time"></field>
<field name="price" type="currency-amount"></field>
<field name="oldPrice" type="currency-amount"></field>
<field name="changedDate" type="date-time"></field>
<field name="changedByUserLogin" type="id-vlong"></field>
<prim-key field="productPriceChangeId"/>
<relation type="one-nofk" rel-entity-name="ProductPrice">
<key-map field-name="productId"/>
<key-map field-name="productPriceTypeId"/>
<key-map field-name="productPricePurposeId"/>
<key-map field-name="currencyUomId"/>
<key-map field-name="productStoreGroupId"/>
<key-map field-name="fromDate"/>
</relation>
<relation type="one" fk-name="PROD_PRCHNG_CHUL" title="ChangedBy" rel-entity-name="UserLogin">
<key-map field-name="changedByUserLogin" rel-field-name="userLoginId"/>
</relation>
</entity>
<entity entity-name="ProductPriceCond"
package-name="org.ofbiz.product.price"
title="Product Price Condition Entity">
<field name="productPriceRuleId" type="id-ne"></field>
<field name="productPriceCondSeqId" type="id-ne"></field>
<field name="inputParamEnumId" type="id"></field>
<field name="operatorEnumId" type="id"></field>
<field name="condValue" type="long-varchar"></field>
<prim-key field="productPriceRuleId"/>
<prim-key field="productPriceCondSeqId"/>
<relation type="one" fk-name="PROD_PCCOND_RULE" rel-entity-name="ProductPriceRule">
<key-map field-name="productPriceRuleId"/>
</relation>
<relation type="one" fk-name="PROD_PCCOND_INENUM" title="InputParam" rel-entity-name="Enumeration">
<key-map field-name="inputParamEnumId" rel-field-name="enumId"/>
</relation>
<relation type="one" fk-name="PROD_PCCOND_OPENUM" title="Operator" rel-entity-name="Enumeration">
<key-map field-name="operatorEnumId" rel-field-name="enumId"/>
</relation>
</entity>
<entity entity-name="ProductPricePurpose"
package-name="org.ofbiz.product.price"
default-resource-name="ProductEntityLabels"
title="Product Price Purpose Entity">
<field name="productPricePurposeId" type="id-ne"></field>
<field name="description" type="description"></field>
<prim-key field="productPricePurposeId"/>
</entity>
<entity entity-name="ProductPriceRule"
package-name="org.ofbiz.product.price"
title="Product Pice Rule Entity">
<field name="productPriceRuleId" type="id-ne"></field>
<field name="ruleName" type="name"></field>
<field name="description" type="description"></field>
<field name="isSale" type="indicator"></field>
<field name="fromDate" type="date-time"></field>
<field name="thruDate" type="date-time"></field>
<prim-key field="productPriceRuleId"/>
</entity>
<entity entity-name="ProductPriceType"
package-name="org.ofbiz.product.price"
default-resource-name="ProductEntityLabels"
title="Product Price Type Entity">
<field name="productPriceTypeId" type="id-ne"></field>
<field name="description" type="description"></field>
<prim-key field="productPriceTypeId"/>
</entity>
<entity entity-name="QuantityBreak"
package-name="org.ofbiz.product.price"
title="Quantity Break Entity">
<field name="quantityBreakId" type="id-ne"></field>
<field name="quantityBreakTypeId" type="id"></field>
<field name="fromQuantity" type="fixed-point"></field>
<field name="thruQuantity" type="fixed-point"></field>
<prim-key field="quantityBreakId"/>
<relation type="one" fk-name="QUANT_BRK_TYPE" rel-entity-name="QuantityBreakType">
<key-map field-name="quantityBreakTypeId"/>
</relation>
</entity>
<entity entity-name="QuantityBreakType"
package-name="org.ofbiz.product.price"
default-resource-name="ProductEntityLabels"
title="Quantity Break Type Entity">
<field name="quantityBreakTypeId" type="id-ne"></field>
<field name="description" type="description"></field>
<prim-key field="quantityBreakTypeId"/>
</entity>
<entity entity-name="SaleType"
package-name="org.ofbiz.product.price"
title="Sale Type Entity">
<field name="saleTypeId" type="id-ne"></field>
<field name="description" type="description"></field>
<prim-key field="saleTypeId"/>
</entity>
<!-- ========================================================= -->
<!-- org.ofbiz.product.product -->
<!-- ========================================================= -->
<entity entity-name="GoodIdentification"
package-name="org.ofbiz.product.product"
title="Good Identification Entity">
<field name="goodIdentificationTypeId" type="id-ne"></field>
<field name="productId" type="id-ne"></field>
<field name="idValue" type="id-long"></field>
<prim-key field="goodIdentificationTypeId"/>
<prim-key field="productId"/>
<relation type="one" fk-name="GOOD_ID_TYPE" rel-entity-name="GoodIdentificationType">
<key-map field-name="goodIdentificationTypeId"/>
</relation>
<relation type="one" fk-name="GOOD_ID_PRODICT" rel-entity-name="Product">
<key-map field-name="productId"/>
</relation>
<index name="GOOD_ID_VALIDX" unique="false">
<index-field name="idValue"/>
</index>
</entity>
<view-entity entity-name="GoodIdentificationAndProduct"
package-name="org.ofbiz.product.product"
title="GoodIdentification and Product View Entity">
<member-entity entity-alias="GI" entity-name="GoodIdentification"/>
<member-entity entity-alias="PR" entity-name="Product"/>
<alias-all entity-alias="GI"/>
<alias-all entity-alias="PR"/>
<view-link entity-alias="GI" rel-entity-alias="PR">
<key-map field-name="productId"/>
</view-link>
<relation type="one-nofk" rel-entity-name="ProductType">
<key-map field-name="productTypeId"/>
</relation>
<relation type="one-nofk" title="Primary" rel-entity-name="ProductCategory">
<key-map field-name="primaryProductCategoryId" rel-field-name="productCategoryId"/>
</relation>
<relation type="one-nofk" rel-entity-name="Facility">
<key-map field-name="facilityId"/>
</relation>
<relation type="one-nofk" title="Manufacturer" rel-entity-name="Party">
<key-map field-name="manufacturerPartyId" rel-field-name="partyId"/>
</relation>
<relation type="one-nofk" title="Quantity" rel-entity-name="Uom">
<key-map field-name="quantityUomId" rel-field-name="uomId"/>
</relation>
<relation type="one-nofk" title="Amount" rel-entity-name="UomType">
<key-map field-name="amountUomTypeId" rel-field-name="uomTypeId"/>
</relation>
<relation type="one-nofk" title="Weight" rel-entity-name="Uom">
<key-map field-name="weightUomId" rel-field-name="uomId"/>
</relation>
<relation type="one-nofk" title="Height" rel-entity-name="Uom">
<key-map field-name="heightUomId" rel-field-name="uomId"/>
</relation>
<relation type="one-nofk" title="Width" rel-entity-name="Uom">
<key-map field-name="widthUomId" rel-field-name="uomId"/>
</relation>
<relation type="one-nofk" title="Depth" rel-entity-name="Uom">
<key-map field-name="depthUomId" rel-field-name="uomId"/>
</relation>
<relation type="one-nofk" rel-entity-name="Enumeration">
<key-map field-name="ratingTypeEnum" rel-field-name="enumId"/>
</relation>
<relation type="one-nofk" title="CreatedBy" rel-entity-name="UserLogin">
<key-map field-name="createdByUserLogin" rel-field-name="userLoginId"/>
</relation>
<relation type="one-nofk" title="LastModifiedBy" rel-entity-name="UserLogin">
<key-map field-name="lastModifiedByUserLogin" rel-field-name="userLoginId"/>
</relation>
<relation type="one" rel-entity-name="Product">
<key-map field-name="productId"/>
</relation>
</view-entity>
<entity entity-name="GoodIdentificationType"
package-name="org.ofbiz.product.product"
default-resource-name="ProductEntityLabels"
title="Good Identification Type Entity">
<field name="goodIdentificationTypeId" type="id-ne"></field>
<field name="parentTypeId" type="id"></field>
<field name="hasTable" type="indicator"></field>
<field name="description" type="description"></field>
<prim-key field="goodIdentificationTypeId"/>
<relation type="one" fk-name="GOOD_ID_TYPE_PAR" title="Parent" rel-entity-name="GoodIdentificationType">
<key-map field-name="parentTypeId" rel-field-name="goodIdentificationTypeId"/>
</relation>
</entity>
<entity entity-name="Product"
package-name="org.ofbiz.product.product"
title="Product Entity">
<field name="productId" type="id-ne"></field>
<field name="productTypeId" type="id"></field>
<field name="primaryProductCategoryId" type="id"><description>The primary category ; it should be one of the productCategoryId already setup in ProductCategoryMember</description></field>
<field name="manufacturerPartyId" type="id"></field>
<field name="facilityId" type="id"></field>
<field name="introductionDate" type="date-time"></field>
<field name="releaseDate" type="date-time"></field>
<field name="supportDiscontinuationDate" type="date-time"></field>
<field name="salesDiscontinuationDate" type="date-time"></field>
<field name="salesDiscWhenNotAvail" type="indicator"></field>
<field name="internalName" type="description"></field>
<field name="brandName" type="name"></field>
<field name="comments" type="comment"></field>
<field name="productName" type="name"></field>
<field name="description" type="description"></field>
<field name="longDescription" type="very-long"></field>
<field name="priceDetailText" type="description"></field>
<field name="smallImageUrl" type="url"></field>
<field name="mediumImageUrl" type="url"></field>
<field name="largeImageUrl" type="url"></field>
<field name="detailImageUrl" type="url"></field>
<field name="originalImageUrl" type="url"></field>
<field name="detailScreen" type="long-varchar"></field>
<field name="inventoryMessage" type="description"></field>
<field name="requireInventory" type="indicator"></field>
<field name="quantityUomId" type="id"></field>
<field name="quantityIncluded" type="fixed-point"><description>If you have a six-pack of 12oz soda cans you would have quantityIncluded=12, quantityUomId=oz, piecesIncluded=6.</description></field>
<field name="piecesIncluded" type="numeric"></field>
<field name="requireAmount" type="indicator"></field>
<field name="fixedAmount" type="currency-amount"><description>Use this for products which are sold in fixed denominations, such as gift certificates or calling cards.</description></field>
<field name="amountUomTypeId" type="id"></field>
<field name="weightUomId" type="id"></field>
<field name="weight" type="fixed-point"><description>The shipping weight of the product.</description></field>
<field name="productWeight" type="fixed-point"></field>
<field name="heightUomId" type="id"></field>
<field name="productHeight" type="fixed-point"></field>
<field name="shippingHeight" type="fixed-point"></field>
<field name="widthUomId" type="id"></field>
<field name="productWidth" type="fixed-point"></field>
<field name="shippingWidth" type="fixed-point"></field>
<field name="depthUomId" type="id"></field>
<field name="productDepth" type="fixed-point"></field>
<field name="shippingDepth" type="fixed-point"></field>
<field name="diameterUomId" type="id"></field>
<field name="productDiameter" type="fixed-point"></field>
<field name="productRating" type="fixed-point"></field>
<field name="ratingTypeEnum" type="id"></field>
<field name="returnable" type="indicator"></field>
<field name="taxable" type="indicator"></field>
<field name="chargeShipping" type="indicator"></field>
<field name="autoCreateKeywords" type="indicator"></field>
<field name="includeInPromotions" type="indicator"></field>
<field name="isVirtual" type="indicator"></field>
<field name="isVariant" type="indicator"></field>
<field name="virtualVariantMethodEnum" type="id"><description>This field defines the method of selecting a variant from the selectable features on the virtual product. Either as a variant explosion which will work to about 200 variants or as feature explosion which almost has no limits</description></field>
<field name="originGeoId" type="id"></field>
<field name="requirementMethodEnumId" type="id"></field>
<field name="billOfMaterialLevel" type="numeric"></field>
<field name="reservMaxPersons" type="fixed-point"><description>maximum number of persons who can rent this asset at the same time</description></field>
<field name="reserv2ndPPPerc" type="fixed-point"><description>percentage of the end price for the 2nd person renting this asset connected to this product</description></field>
<field name="reservNthPPPerc" type="fixed-point"><description>percentage of the end price for the Nth person renting this asset connected to this product</description></field>
<field name="configId" type="id"><description>Used to safe the persisted configuration Id for AGGREGATED products.</description></field>
<field name="createdDate" type="date-time"></field>
<field name="createdByUserLogin" type="id-vlong"></field>
<field name="lastModifiedDate" type="date-time"></field>
<field name="lastModifiedByUserLogin" type="id-vlong"></field>
<field name="inShippingBox" type="indicator"></field>
<field name="defaultShipmentBoxTypeId" type="id"></field>
<field name="lotIdFilledIn" type="long-varchar"><description>Indicate if the lotId must be informed</description></field>
<field name="orderDecimalQuantity" type="indicator"><description>use to indicate if decimal quantity can be ordered for this product. Default value is Y</description></field>
<prim-key field="productId"/>
<relation type="one" fk-name="PROD_TYPE" rel-entity-name="ProductType">
<key-map field-name="productTypeId"/>
</relation>
<relation type="many" rel-entity-name="ProductTypeAttr">
<key-map field-name="productTypeId"/>
</relation>
<relation type="one" fk-name="PROD_PRIMARY_CAT" title="Primary" rel-entity-name="ProductCategory">
<key-map field-name="primaryProductCategoryId" rel-field-name="productCategoryId"/>
</relation>
<relation type="one" fk-name="PROD_FACILITY" rel-entity-name="Facility">
<key-map field-name="facilityId"/>
</relation>
<relation type="one" fk-name="PROD_MFG_PARTY" title="Manufacturer" rel-entity-name="Party">
<key-map field-name="manufacturerPartyId" rel-field-name="partyId"/>
</relation>
<relation type="one" fk-name="PROD_QUANT_UOM" title="Quantity" rel-entity-name="Uom">
<key-map field-name="quantityUomId" rel-field-name="uomId"/>
</relation>
<relation type="one" fk-name="PROD_AMOUNT_UOMT" title="Amount" rel-entity-name="UomType">
<key-map field-name="amountUomTypeId" rel-field-name="uomTypeId"/>
</relation>
<relation type="one" fk-name="PROD_WEIGHT_UOM" title="Weight" rel-entity-name="Uom">
<key-map field-name="weightUomId" rel-field-name="uomId"/>
</relation>
<relation type="one" fk-name="PROD_HEIGHT_UOM" title="Height" rel-entity-name="Uom">
<key-map field-name="heightUomId" rel-field-name="uomId"/>
</relation>
<relation type="one" fk-name="PROD_WIDTH_UOM" title="Width" rel-entity-name="Uom">
<key-map field-name="widthUomId" rel-field-name="uomId"/>
</relation>
<relation type="one" fk-name="PROD_DEPTH_UOM" title="Depth" rel-entity-name="Uom">
<key-map field-name="depthUomId" rel-field-name="uomId"/>
</relation>
<relation type="one" fk-name="PROD_DIAMTR_UOM" title="Diameter" rel-entity-name="Uom">
<key-map field-name="diameterUomId" rel-field-name="uomId"/>
</relation>
<relation type="one" fk-name="PROD_VVMETHOD_ENUM" title="VirtualVariantMethod" rel-entity-name="Enumeration">
<key-map field-name="virtualVariantMethodEnum" rel-field-name="enumId"/>
</relation>
<relation type="one" fk-name="PROD_RATE_ENUM" title="Rating" rel-entity-name="Enumeration">
<key-map field-name="ratingTypeEnum" rel-field-name="enumId"/>
</relation>
<relation type="one" fk-name="PROD_RQMT_ENUM" title="RequirementMethod" rel-entity-name="Enumeration">
<key-map field-name="requirementMethodEnumId" rel-field-name="enumId"/>
</relation>
<relation type="one" fk-name="PROD_ORG_GEO" title="Origin" rel-entity-name="Geo">
<key-map field-name="originGeoId" rel-field-name="geoId"/>
</relation>
<relation type="one" fk-name="PROD_CB_USERLOGIN" title="CreatedBy" rel-entity-name="UserLogin">
<key-map field-name="createdByUserLogin" rel-field-name="userLoginId"/>
</relation>
<relation type="one" fk-name="PROD_LMB_USERLOGIN" title="LastModifiedBy" rel-entity-name="UserLogin">
<key-map field-name="lastModifiedByUserLogin" rel-field-name="userLoginId"/>
</relation>
<relation type="many" rel-entity-name="ProductFeatureAndAppl">
<key-map field-name="productId"/>
</relation>
<relation type="one" fk-name="PROD_SHBX_TYPE" title="Default" rel-entity-name="ShipmentBoxType">
<key-map field-name="defaultShipmentBoxTypeId" rel-field-name="shipmentBoxTypeId"/>
</relation>
</entity>
<entity entity-name="ProductAssoc"
package-name="org.ofbiz.product.product"
title="Product Association Entity">
<field name="productId" type="id-ne"></field>
<field name="productIdTo" type="id-ne"></field>
<field name="productAssocTypeId" type="id-ne"></field>
<field name="fromDate" type="date-time"></field>
<field name="thruDate" type="date-time"></field>
<field name="sequenceNum" type="numeric"></field>
<field name="reason" type="long-varchar"></field>
<field name="quantity" type="fixed-point"></field>
<field name="scrapFactor" type="fixed-point"></field>
<field name="instruction" type="long-varchar"></field>
<field name="routingWorkEffortId" type="id"></field>
<field name="estimateCalcMethod" type="id"></field>
<field name="recurrenceInfoId" type="id"></field>
<prim-key field="productId"/>
<prim-key field="productIdTo"/>
<prim-key field="productAssocTypeId"/>
<prim-key field="fromDate"/>
<relation type="one" fk-name="PROD_ASSOC_TYPE" rel-entity-name="ProductAssocType">
<key-map field-name="productAssocTypeId"/>
</relation>
<relation type="one" fk-name="PROD_ASSOC_MPROD" title="Main" rel-entity-name="Product">
<key-map field-name="productId"/>
</relation>
<relation type="one" fk-name="PROD_ASSOC_APROD" title="Assoc" rel-entity-name="Product">
<key-map field-name="productIdTo" rel-field-name="productId"/>
</relation>
<relation type="one" fk-name="PROD_ASSOC_RTWE" title="Routing" rel-entity-name="WorkEffort">
<key-map field-name="routingWorkEffortId" rel-field-name="workEffortId"/>
</relation>
<relation type="one" fk-name="PROD_ASSOC_CUSM" rel-entity-name="CustomMethod">
<key-map field-name="estimateCalcMethod" rel-field-name="customMethodId"/>
</relation>
<relation type="one" fk-name="PROD_ASSOC_RECINFO" rel-entity-name="RecurrenceInfo">
<key-map field-name="recurrenceInfoId"/>
</relation>
</entity>
<view-entity entity-name="ProductAndAssoc"
package-name="org.ofbiz.product.product"
title="Product and ProductAssoc View Entity">
<member-entity entity-alias="PD" entity-name="Product"/>
<member-entity entity-alias="PDA" entity-name="ProductAssoc"/>
<alias name="productId" entity-alias="PD" field="productId"/>
<alias name="internalName" entity-alias="PD" field="internalName"/>
<alias name="productIdTo" entity-alias="PDA" field="productIdTo"/>
<alias name="productAssocTypeId" entity-alias="PDA" field="productAssocTypeId"/>
<alias name="quantity" entity-alias="PDA" field="quantity"/>
<alias name="fromDate" entity-alias="PDA" field="fromDate"/>
<view-link entity-alias="PD" rel-entity-alias="PDA">
<key-map field-name="productId"/>
</view-link>
</view-entity>
<entity entity-name="ProductAssocType"
package-name="org.ofbiz.product.product"
default-resource-name="ProductEntityLabels"
title="Product Association Type Entity">
<field name="productAssocTypeId" type="id-ne"></field>
<field name="parentTypeId" type="id"></field>
<field name="hasTable" type="indicator"></field>
<field name="description" type="description"></field>
<prim-key field="productAssocTypeId"/>
<relation type="one" fk-name="PROD_ASSOC_TYPEPAR" title="Parent" rel-entity-name="ProductAssocType">
<key-map field-name="parentTypeId" rel-field-name="productAssocTypeId"/>
</relation>
</entity>
<entity entity-name="ProductRole"
package-name="org.ofbiz.product.product"
title="Product Role Entity">
<field name="productId" type="id-ne"></field>
<field name="partyId" type="id-ne"></field>
<field name="roleTypeId" type="id-ne"></field>
<field name="fromDate" type="date-time"></field>
<field name="thruDate" type="date-time"></field>
<field name="sequenceNum" type="numeric"><description>a product may have several parties associated to it with the same role; this field can be used to define the order of parties associated to the product in that role</description></field>
<field name="comments" type="comment"></field>
<prim-key field="productId"/>
<prim-key field="partyId"/>
<prim-key field="roleTypeId"/>
<prim-key field="fromDate"/>
<relation type="one-nofk" rel-entity-name="Party">
<key-map field-name="partyId"/>
</relation>
<relation type="one-nofk" rel-entity-name="RoleType">
<key-map field-name="roleTypeId"/>
</relation>
<relation type="one" fk-name="PROD_RLE_PTYRLE" rel-entity-name="PartyRole">
<key-map field-name="partyId"/>
<key-map field-name="roleTypeId"/>
</relation>
<relation type="one" fk-name="PROD_RLE_PRODUCT" rel-entity-name="Product">
<key-map field-name="productId"/>
</relation>
</entity>
<entity entity-name="ProductAttribute"
package-name="org.ofbiz.product.product"
title="Product Attribute Entity">
<field name="productId" type="id-ne"></field>
<field name="attrName" type="id-long-ne"></field>
<field name="attrValue" type="value"></field>
<field name="attrType" type="value"></field>
<prim-key field="productId"/>
<prim-key field="attrName"/>
<relation type="one" fk-name="PROD_ATTR" rel-entity-name="Product">
<key-map field-name="productId"/>
</relation>
<relation type="many" rel-entity-name="ProductTypeAttr">
<key-map field-name="attrName"/>
</relation>
</entity>
<entity entity-name="ProductCalculatedInfo"
package-name="org.ofbiz.product.product"
title="Product Calculated Info Entity">
<field name="productId" type="id-ne"></field>
<field name="totalQuantityOrdered" type="fixed-point"></field>
<field name="totalTimesViewed" type="numeric"></field>
<field name="averageCustomerRating" type="fixed-point"></field>
<prim-key field="productId"/>
<relation type="one" fk-name="PRODCI_PROD" rel-entity-name="Product">
<key-map field-name="productId"/>
</relation>
</entity>
<entity entity-name="ProductContent"
package-name="org.ofbiz.product.product"
title="Product Data Object Entity">
<field name="productId" type="id-ne"></field>
<field name="contentId" type="id-ne"></field>
<field name="productContentTypeId" type="id-ne"></field>
<field name="fromDate" type="date-time"></field>
<field name="thruDate" type="date-time"></field>
<field name="purchaseFromDate" type="date-time"></field>
<field name="purchaseThruDate" type="date-time"></field>
<field name="useCountLimit" type="numeric"></field>
<field name="useTime" type="numeric"></field>
<field name="useTimeUomId" type="id"></field>
<field name="useRoleTypeId" type="id"></field>
<field name="sequenceNum" type="numeric"></field>
<prim-key field="productId"/>
<prim-key field="contentId"/>
<prim-key field="productContentTypeId"/>
<prim-key field="fromDate"/>
<relation type="one" fk-name="PROD_CNT_PROD" rel-entity-name="Product">
<key-map field-name="productId"/>
</relation>
<relation type="one" fk-name="PROD_CNT_CNT" rel-entity-name="Content">
<key-map field-name="contentId"/>
</relation>
<relation type="one" fk-name="PROD_CNT_TYPE" rel-entity-name="ProductContentType">
<key-map field-name="productContentTypeId"/>
</relation>
<relation type="one" fk-name="PROD_CNT_URT" title="Use" rel-entity-name="RoleType">
<key-map field-name="useRoleTypeId" rel-field-name="roleTypeId"/>
</relation>
<relation type="one" fk-name="PROD_CNT_UTU" title="UseTime" rel-entity-name="Uom">
<key-map field-name="useTimeUomId" rel-field-name="uomId"/>
</relation>
</entity>
<view-entity entity-name="ProductContentAndInfo"
package-name="org.ofbiz.product.product"
title="ProductContent, Content and DataResource View Entity">
<member-entity entity-alias="PC" entity-name="ProductContent"/>
<member-entity entity-alias="CO" entity-name="Content"/>
<member-entity entity-alias="DR" entity-name="DataResource"/>
<alias-all entity-alias="PC"/>
<alias-all entity-alias="CO"/>
<alias-all entity-alias="DR" prefix="dr"/>
<view-link entity-alias="PC" rel-entity-alias="CO">
<key-map field-name="contentId"/>
</view-link>
<view-link entity-alias="CO" rel-entity-alias="DR">
<key-map field-name="dataResourceId"/>
</view-link>
<relation type="one-nofk" rel-entity-name="ElectronicText">
<key-map field-name="dataResourceId"/>
</relation>
<relation type="one-nofk" rel-entity-name="ImageDataResource">
<key-map field-name="dataResourceId"/>
</relation>
<relation type="one-nofk" rel-entity-name="OtherDataResource">
<key-map field-name="dataResourceId"/>
</relation>
<relation type="many" rel-entity-name="ContentAssocDataResourceViewFrom">
<key-map field-name="contentId" rel-field-name="contentIdStart"/>
</relation>
<relation type="many" rel-entity-name="ContentAssocDataResourceViewTo">
<key-map field-name="contentId" rel-field-name="contentIdStart"/>
</relation>
</view-entity>
<entity entity-name="ProductContentType"
package-name="org.ofbiz.product.product"
default-resource-name="ProductEntityLabels"
title="Product Content Type Entity">
<field name="productContentTypeId" type="id-ne"></field>
<field name="parentTypeId" type="id"></field>
<field name="hasTable" type="indicator"></field>
<field name="description" type="description"></field>
<prim-key field="productContentTypeId"/>
<relation type="one" fk-name="PRDCT_TYP_PARENT" title="Parent" rel-entity-name="ProductContentType">
<key-map field-name="parentTypeId" rel-field-name="productContentTypeId"/>
</relation>
</entity>
<entity entity-name="ProductGeo"
package-name="org.ofbiz.product.product"
default-resource-name="ProductEntityLabels"
title="Product Geo Entity">
<field name="productId" type="id-ne"></field>
<field name="geoId" type="id"></field>
<field name="productGeoEnumId" type="id"></field>
<field name="description" type="description"></field>
<prim-key field="productId"/>
<prim-key field="geoId"/>
<relation type="one" fk-name="PRDGEO_PRODUCT" rel-entity-name="Product">
<key-map field-name="productId"/>
</relation>
<relation type="one" fk-name="PRDGEO_GEO" rel-entity-name="Geo">
<key-map field-name="geoId"/>
</relation>
<relation type="one" fk-name="PRDGEO_ENUM" rel-entity-name="Enumeration">
<key-map field-name="productGeoEnumId" rel-field-name="enumId"/>
</relation>
</entity>
<entity entity-name="ProductGlAccount"
package-name="org.ofbiz.product.product"
title="Product GlAccount Entity">
<field name="productId" type="id-ne"></field>
<field name="organizationPartyId" type="id-ne"></field>
<field name="glAccountTypeId" type="id-ne"></field>
<field name="glAccountId" type="id-ne"></field>
<prim-key field="productId"/>
<prim-key field="organizationPartyId"/>
<prim-key field="glAccountTypeId"/>
<relation type="one" fk-name="PROD_GLACT_PROD" rel-entity-name="Product">
<key-map field-name="productId"/>
</relation>
<relation type="one" fk-name="PROD_GLACT_PARTY" rel-entity-name="Party">
<key-map field-name="organizationPartyId" rel-field-name="partyId"/>
</relation>
<relation type="one" fk-name="PROD_GLACT_TYPE" rel-entity-name="GlAccountType">
<key-map field-name="glAccountTypeId"/>
</relation>
<relation type="one" fk-name="PROD_GLACT_GLACT" rel-entity-name="GlAccount">
<key-map field-name="glAccountId"/>
</relation>
</entity>
<view-entity entity-name="ProductInventoryItem"
package-name="org.ofbiz.product.product"
title="View entity joining Product and InventoryItem to allow queries for InventoryItem based on product attributes">
<member-entity entity-alias="PR" entity-name="Product"/>
<member-entity entity-alias="II" entity-name="InventoryItem"/>
<alias-all entity-alias="PR">
<exclude field="facilityId"/>
</alias-all>
<alias-all entity-alias="II">
<exclude field="comments"/>
</alias-all>
<alias entity-alias="PR" name="productFacilityId" field="facilityId"/>
<alias entity-alias="II" name="inventoryComments" field="comments"/>
<view-link entity-alias="PR" rel-entity-alias="II">
<key-map field-name="productId"/>
</view-link>
</view-entity>
<entity entity-name="ProductKeyword" table-name="PRODUCT_KEYWORD_NEW"
package-name="org.ofbiz.product.product" title="Product Keyword Entity" never-cache="true">
<field name="productId" type="id-ne"></field>
<field name="keyword" type="short-varchar"></field>
<field name="keywordTypeId" type="id-ne"></field>
<field name="relevancyWeight" type="numeric"></field>
<field name="statusId" type="id-ne"></field>
<prim-key field="productId"/>
<prim-key field="keyword"/>
<prim-key field="keywordTypeId"/>
<relation type="one" fk-name="PROD_KWD_PROD_NEW" rel-entity-name="Product">
<key-map field-name="productId"/>
</relation>
<relation type="one" fk-name="PROD_KWD_TYPE" rel-entity-name="Enumeration">
<key-map field-name="keywordTypeId" rel-field-name="enumId"/>
</relation>
<relation type="one" fk-name="PROD_KWD_STTS" rel-entity-name="StatusItem">
<key-map field-name="statusId"/>
</relation>
<index name="PROD_KWD_KWD_NEW">
<index-field name="keyword"/>
</index>
</entity>
<entity entity-name="ProductMeter" package-name="org.ofbiz.product.product" title="Product Meter Entity">
<field name="productId" type="id-ne"></field>
<field name="productMeterTypeId" type="id-ne"><description>Part of the primary key as different meters on a machine should have distinct types</description></field>
<field name="meterUomId" type="id"><description>Is on this entity instead of the ProductMeterType entity for more flexibility; for example being able to find all speedometers regardless of their primary unit</description></field>
<field name="meterName" type="name"></field>
<prim-key field="productId"/>
<prim-key field="productMeterTypeId"/>
<relation type="one" fk-name="PRODMTR_PROD" rel-entity-name="Product">
<key-map field-name="productId"/>
</relation>
<relation type="one" fk-name="PRODMTR_MTRTYP" rel-entity-name="ProductMeterType">
<key-map field-name="productMeterTypeId"/>
</relation>
<relation type="one" fk-name="PRODMTR_MTRUOM" title="Meter" rel-entity-name="Uom">
<key-map field-name="meterUomId" rel-field-name="uomId"/>
</relation>
</entity>
<entity entity-name="ProductMeterType"
package-name="org.ofbiz.product.product"
default-resource-name="ProductEntityLabels"
title="Product Meter Type Entity">
<field name="productMeterTypeId" type="id-ne"></field>
<field name="description" type="description"></field>
<field name="defaultUomId" type="id"><description>This is optional and if applicable can describe the meter better</description></field>
<prim-key field="productMeterTypeId"/>
<relation type="one" fk-name="PRODMTRTP_DUOM" title="Default" rel-entity-name="Uom">
<key-map field-name="defaultUomId" rel-field-name="uomId"/>
</relation>
</entity>
<entity entity-name="ProductMaint" package-name="org.ofbiz.product.product" title="Product Maintenance Entity">
<description>This is used to specify the details for scheduled maintenance.</description>
<field name="productId" type="id-ne"></field>
<field name="productMaintSeqId" type="id-ne"></field>
<field name="productMaintTypeId" type="id"></field>
<field name="maintName" type="name"></field>
<field name="maintTemplateWorkEffortId" type="id"><description>Template of Maintenance Plan. WorkEffort may have WorkEffortAssocs for tasks/breakdown detailes</description></field>
<field name="intervalQuantity" type="fixed-point"></field>
<field name="intervalUomId" type="id"><description>UOM for intervalQuantity; if used intervalMeterTypeId is generally not used (ie one or the other)</description></field>
<field name="intervalMeterTypeId" type="id"><description>Meter Type for intervalQuantity; if used intervalUomId is generally not used (ie one or the other)</description></field>
<field name="repeatCount" type="numeric"><description>If 0 or null means no limit to repeat count; can be used with multiple ProductMaint records for a single ProductMaintType in cases where maintenance intervals are not evenly distributed, or only need to be done once like a break-in period</description></field>
<prim-key field="productId"/>
<prim-key field="productMaintSeqId"/>
<relation type="one" fk-name="PRODMNT_PROD" rel-entity-name="Product">
<key-map field-name="productId"/>
</relation>
<relation type="one" fk-name="PRODMNT_MNTTYP" rel-entity-name="ProductMaintType">
<key-map field-name="productMaintTypeId"/>
</relation>
<relation type="one" fk-name="PRODMNT_TPLHWE" title="MaintTemplate" rel-entity-name="WorkEffort">
<key-map field-name="maintTemplateWorkEffortId" rel-field-name="workEffortId"/>
</relation>
<relation type="one" fk-name="PRODMNT_INTUOM" title="Interval" rel-entity-name="Uom">
<key-map field-name="intervalUomId" rel-field-name="uomId"/>
</relation>
<relation type="one" fk-name="PRODMNT_PDMTTYP" title="Interval" rel-entity-name="ProductMeterType">
<key-map field-name="intervalMeterTypeId" rel-field-name="productMeterTypeId"/>
</relation>
<relation type="one-nofk" title="Interval" rel-entity-name="ProductMeter">
<description>This can't have a foreign key because the intervalMeterTypeId field is optional, but the productId field is not</description>
<key-map field-name="productId"/>
<key-map field-name="intervalMeterTypeId" rel-field-name="productMeterTypeId"/>
</relation>
</entity>
<entity entity-name="ProductMaintType"
package-name="org.ofbiz.product.product"
default-resource-name="ProductEntityLabels"
title="Product Maintenance Type Entity">
<description>This is for both scheduled and unscheduled maintenance; use ProductMaint to track details for scheduled maintenance</description>
<field name="productMaintTypeId" type="id-ne"></field>
<field name="description" type="description"></field>
<field name="parentTypeId" type="id"></field>
<prim-key field="productMaintTypeId"/>
<relation type="one" fk-name="PRODMNT_TYPE_PAR" title="Parent" rel-entity-name="ProductMaintType">
<key-map field-name="parentTypeId" rel-field-name="productMaintTypeId"/>
</relation>
</entity>
<entity entity-name="ProductReview"
package-name="org.ofbiz.product.product"
title="Product Review Entity">
<field name="productReviewId" type="id-ne"></field>
<field name="productStoreId" type="id-ne"></field>
<field name="productId" type="id-ne"></field>
<field name="userLoginId" type="id-vlong-ne"></field>
<field name="statusId" type="id"></field>
<field name="postedAnonymous" type="indicator"></field>
<field name="postedDateTime" type="date-time"></field>
<field name="productRating" type="fixed-point"></field>
<field name="productReview" type="very-long"></field>
<prim-key field="productReviewId"/>
<relation type="one" fk-name="PROD_REVIEW_PRDSTR" rel-entity-name="ProductStore">
<key-map field-name="productStoreId"/>
</relation>
<relation type="one" fk-name="PROD_REVIEW_PROD" rel-entity-name="Product">
<key-map field-name="productId"/>
</relation>
<relation type="one" fk-name="PROD_REVIEW_ULH" rel-entity-name="UserLogin">
<key-map field-name="userLoginId" rel-field-name="userLoginId"/>
</relation>
<relation type="one" fk-name="PROD_REVIEW_STTS" rel-entity-name="StatusItem">
<key-map field-name="statusId"/>
</relation>
</entity>
<entity entity-name="ProductSearchConstraint" package-name="org.ofbiz.product.product" never-cache="true" title="Product Search Result Constraint Entity">
<field name="productSearchResultId" type="id-ne"></field>
<field name="constraintSeqId" type="id-ne"></field>
<field name="constraintName" type="long-varchar"></field>
<field name="infoString" type="long-varchar"></field>
<field name="includeSubCategories" type="indicator"></field>
<field name="isAnd" type="indicator"></field>
<field name="anyPrefix" type="indicator"></field>
<field name="anySuffix" type="indicator"></field>
<field name="removeStems" type="indicator"></field>
<field name="lowValue" type="short-varchar"></field>
<field name="highValue" type="short-varchar"></field>
<prim-key field="productSearchResultId"/>
<prim-key field="constraintSeqId"/>
<relation type="one" fk-name="PROD_SCHRSI_RES" rel-entity-name="ProductSearchResult">
<key-map field-name="productSearchResultId"/>
</relation>
</entity>
<entity entity-name="ProductSearchResult"
package-name="org.ofbiz.product.product"
never-cache="true"
title="Product Search Result Entity">
<field name="productSearchResultId" type="id-ne"></field>
<field name="visitId" type="id"></field>
<field name="orderByName" type="long-varchar"></field>
<field name="isAscending" type="indicator"></field>
<field name="numResults" type="numeric"></field>
<field name="secondsTotal" type="floating-point"></field>
<field name="searchDate" type="date-time"></field>
<prim-key field="productSearchResultId"/>
<relation type="one" fk-name="PROD_SCHRES_VST" rel-entity-name="Visit">
<key-map field-name="visitId"/>
</relation>
</entity>
<entity entity-name="ProductType"
package-name="org.ofbiz.product.product"
default-resource-name="ProductEntityLabels"
title="Product Type Entity">
<field name="productTypeId" type="id-ne"></field>
<field name="parentTypeId" type="id"></field>
<field name="isPhysical" type="indicator"></field>
<field name="isDigital" type="indicator"></field>
<field name="hasTable" type="indicator"></field>
<field name="description" type="description"></field>
<prim-key field="productTypeId"/>
<relation type="one" fk-name="PROD_TYPE_PARENT" title="Parent" rel-entity-name="ProductType">
<key-map field-name="parentTypeId" rel-field-name="productTypeId"/>
</relation>
</entity>
<entity entity-name="ProductTypeAttr"
package-name="org.ofbiz.product.product"
title="Product Type Attribute Entity">
<field name="productTypeId" type="id-ne"></field>
<field name="attrName" type="id-long-ne"></field>
<prim-key field="productTypeId"/>
<prim-key field="attrName"/>
<relation type="one" fk-name="PROD_TYPE_ATTR" rel-entity-name="ProductType">
<key-map field-name="productTypeId"/>
</relation>
<relation type="many" rel-entity-name="ProductAttribute">
<key-map field-name="attrName"/>
</relation>
<relation type="many" rel-entity-name="Product">
<key-map field-name="productTypeId"/>
</relation>
</entity>
<view-entity entity-name="ProductVirtualAndAssocPrices"
package-name="org.ofbiz.product.product"
title="Virtual and Associated Product Prices View Entity">
<description>When using this to get an associated product price summary the only columns you should request are: productId, productName, assocProductCount, assocMinPrice, assocMaxPrice. The rest of the field aliases should only be used for specifying constraints since they will break the grouping.</description>
<member-entity entity-alias="PVIRT" entity-name="Product"/>
<member-entity entity-alias="PA" entity-name="ProductAssoc"/>
<member-entity entity-alias="PASC" entity-name="Product"/>
<member-entity entity-alias="PASCPRC" entity-name="ProductPrice"/>
<alias entity-alias="PVIRT" name="productId"/>
<alias entity-alias="PVIRT" name="internalName"/>
<alias entity-alias="PVIRT" name="productName"/>
<alias entity-alias="PA" name="productAssocTypeId"/>
<alias entity-alias="PA" name="fromDate"/>
<alias entity-alias="PA" name="thruDate"/>
<alias entity-alias="PASC" name="assocProductId" field="productId"/>
<alias entity-alias="PASC" name="assocProductCount" field="productId" function="count-distinct"/>
<alias entity-alias="PASCPRC" name="assocPriceTypeId" field="productPriceTypeId"/>
<alias entity-alias="PASCPRC" name="assocCurrencyUomId" field="currencyUomId"/>
<alias entity-alias="PASCPRC" name="assocProductStoreGroupId" field="productStoreGroupId"/>
<alias entity-alias="PASCPRC" name="assocPriceFromDate" field="fromDate"/>
<alias entity-alias="PASCPRC" name="assocPriceThruDate" field="thruDate"/>
<alias entity-alias="PASCPRC" name="assocMinPrice" field="price" function="min"/>
<alias entity-alias="PASCPRC" name="assocMaxPrice" field="price" function="max"/>
<view-link entity-alias="PVIRT" rel-entity-alias="PA">
<key-map field-name="productId"/>
</view-link>
<view-link entity-alias="PA" rel-entity-alias="PASC">
<key-map field-name="productIdTo" rel-field-name="productId"/>
</view-link>
<view-link entity-alias="PASC" rel-entity-alias="PASCPRC">
<key-map field-name="productId"/>
</view-link>
</view-entity>
<view-entity entity-name="ProductVirtualAndVariantInfo"
package-name="org.ofbiz.product.product"
title="Virtual and Variant Product View Entity">
<member-entity entity-alias="PVIRT" entity-name="Product"/>
<member-entity entity-alias="PVA" entity-name="ProductAssoc"/>
<member-entity entity-alias="PVAR" entity-name="Product"/>
<member-entity entity-alias="PVARFA" entity-name="ProductFeatureAppl"/>
<member-entity entity-alias="PVARF" entity-name="ProductFeature"/>
<member-entity entity-alias="PVARPRC" entity-name="ProductPrice"/>
<alias entity-alias="PVIRT" name="productId"/>
<alias entity-alias="PVIRT" name="productName"/>
<alias entity-alias="PVIRT" name="internalName"/>
<alias entity-alias="PVA" name="productAssocTypeId"/>
<alias entity-alias="PVA" name="fromDate"/>
<alias entity-alias="PVA" name="thruDate"/>
<alias entity-alias="PVAR" name="variantProductId" field="productId"/>
<alias entity-alias="PVARFA" name="productFeatureApplTypeId"/>
<alias entity-alias="PVARFA" name="variantFeatureApplFromDate" field="fromDate"/>
<alias entity-alias="PVARFA" name="variantFeatureApplThruDate" field="thruDate"/>
<alias entity-alias="PVARF" name="productFeatureId"/>
<alias entity-alias="PVARF" name="productFeatureTypeId"/>
<alias entity-alias="PVARF" name="productFeatureCategoryId"/>
<alias entity-alias="PVARF" name="description"/>
<alias entity-alias="PVARPRC" name="variantPriceTypeId" field="productPriceTypeId"/>
<alias entity-alias="PVARPRC" name="variantCurrencyUomId" field="currencyUomId"/>
<alias entity-alias="PVARPRC" name="variantProductStoreGroupId" field="productStoreGroupId"/>
<alias entity-alias="PVARPRC" name="variantPriceFromDate" field="fromDate"/>
<alias entity-alias="PVARPRC" name="variantPriceThruDate" field="thruDate"/>
<alias entity-alias="PVARPRC" name="variantPrice" field="price"/>
<view-link entity-alias="PVIRT" rel-entity-alias="PVA">
<key-map field-name="productId"/>
</view-link>
<view-link entity-alias="PVA" rel-entity-alias="PVAR">
<key-map field-name="productIdTo" rel-field-name="productId"/>
</view-link>
<view-link entity-alias="PVAR" rel-entity-alias="PVARFA" rel-optional="true">
<key-map field-name="productId"/>
</view-link>
<view-link entity-alias="PVARFA" rel-entity-alias="PVARF">
<key-map field-name="productFeatureId"/>
</view-link>
<view-link entity-alias="PVAR" rel-entity-alias="PVARPRC">
<key-map field-name="productId"/>
</view-link>
</view-entity>
<view-entity entity-name="ProductAndPriceView"
package-name="org.ofbiz.product.product"
title="Product And Price View">
<member-entity entity-alias="PR" entity-name="Product"/>
<member-entity entity-alias="PP" entity-name="ProductPrice"/>
<alias entity-alias="PR" name="productId"/>
<alias entity-alias="PR" name="productTypeId"/>
<alias entity-alias="PR" name="productName"/>
<alias entity-alias="PR" name="internalName"/>
<alias entity-alias="PR" name="description"/>
<alias entity-alias="PR" name="primaryProductCategoryId"/>
<alias entity-alias="PR" name="isVirtual"/>
<alias entity-alias="PP" name="productPriceTypeId"/>
<alias entity-alias="PP" name="productPricePurposeId"/>
<alias entity-alias="PP" name="currencyUomId"/>
<alias entity-alias="PP" name="fromDate"/>
<alias entity-alias="PP" name="thruDate"/>
<alias entity-alias="PP" name="price"/>
<view-link entity-alias="PR" rel-entity-alias="PP">
<key-map field-name="productId"/>
</view-link>
</view-entity>
<entity entity-name="VendorProduct" package-name="org.ofbiz.product.product">
<description>For information related to a specific vendor and product, especially for multi-vendor stores. The ProductStoreGroup is to be used much like in ProductPrice.</description>
<field name="productId" type="id-ne"></field>
<field name="vendorPartyId" type="id-ne"></field>
<field name="productStoreGroupId" type="id-ne"></field>
<prim-key field="productId"/>
<prim-key field="vendorPartyId"/>
<prim-key field="productStoreGroupId"/>
<relation type="one" fk-name="VENDPROD_PROD" rel-entity-name="Product">
<key-map field-name="productId"/>
</relation>
<relation type="one" fk-name="VENDPROD_VPTY" title="Vendor" rel-entity-name="Party">
<key-map field-name="vendorPartyId" rel-field-name="partyId"/>
</relation>
<relation type="one" fk-name="VENDPROD_PSGRP" rel-entity-name="ProductStoreGroup">
<key-map field-name="productStoreGroupId"/>
</relation>
</entity>
<!-- ========================================================= -->
<!-- org.ofbiz.product.promo -->
<!-- ========================================================= -->
<entity entity-name="ProductPromo"
package-name="org.ofbiz.product.promo"
title="Product Promotion Entity">
<field name="productPromoId" type="id-ne"></field>
<field name="promoName" type="name"></field>
<field name="promoText" type="description"></field>
<field name="userEntered" type="indicator"></field>
<field name="showToCustomer" type="indicator"></field>
<field name="requireCode" type="indicator"></field>
<field name="useLimitPerOrder" type="numeric"></field>
<field name="useLimitPerCustomer" type="numeric"></field>
<field name="useLimitPerPromotion" type="numeric"></field>
<field name="billbackFactor" type="fixed-point"></field>
<field name="overrideOrgPartyId" type="id"></field>
<field name="createdDate" type="date-time"></field>
<field name="createdByUserLogin" type="id-vlong"></field>
<field name="lastModifiedDate" type="date-time"></field>
<field name="lastModifiedByUserLogin" type="id-vlong"></field>
<prim-key field="productPromoId"/>
<relation type="one" fk-name="PROD_PRMO_OPA" rel-entity-name="Party">
<key-map field-name="overrideOrgPartyId" rel-field-name="partyId"/>
</relation>
<relation type="one" fk-name="PROD_PRMO_CUL" title="CreatedBy" rel-entity-name="UserLogin">
<key-map field-name="createdByUserLogin" rel-field-name="userLoginId"/>
</relation>
<relation type="one" fk-name="PROD_PRMO_LMCUL" title="LastModifiedBy" rel-entity-name="UserLogin">
<key-map field-name="lastModifiedByUserLogin" rel-field-name="userLoginId"/>
</relation>
</entity>
<entity entity-name="ProductPromoAction"
package-name="org.ofbiz.product.promo"
title="Product Promotion Action Entity">
<field name="productPromoId" type="id-ne"></field>
<field name="productPromoRuleId" type="id-ne"></field>
<field name="productPromoActionSeqId" type="id-ne"></field>
<field name="productPromoActionEnumId" type="id-ne"></field>
<field name="orderAdjustmentTypeId" type="id"></field>
<field name="serviceName" type="long-varchar"></field>
<field name="quantity" type="fixed-point"></field>
<field name="amount" type="fixed-point"></field>
<field name="productId" type="id"></field>
<field name="partyId" type="id"></field>
<field name="useCartQuantity" type="indicator"></field>
<prim-key field="productPromoId"/>
<prim-key field="productPromoRuleId"/>
<prim-key field="productPromoActionSeqId"/>
<relation type="one" fk-name="PROD_PRACT_ENUM" title="Action" rel-entity-name="Enumeration">
<key-map field-name="productPromoActionEnumId" rel-field-name="enumId"/>
</relation>
<relation type="one" fk-name="PROD_PRACT_PR" rel-entity-name="ProductPromo">
<key-map field-name="productPromoId"/>
</relation>
<relation type="one" fk-name="PROD_PRACT_RL" rel-entity-name="ProductPromoRule">
<key-map field-name="productPromoId"/>
<key-map field-name="productPromoRuleId"/>
</relation>
<relation type="one" fk-name="PROD_PRACT_OATYPE" rel-entity-name="OrderAdjustmentType">
<key-map field-name="orderAdjustmentTypeId"/>
</relation>
<relation type="many" rel-entity-name="ProductPromoCategory">
<key-map field-name="productPromoId"/>
<key-map field-name="productPromoRuleId"/>
<key-map field-name="productPromoActionSeqId"/>
</relation>
<relation type="many" rel-entity-name="ProductPromoProduct">
<key-map field-name="productPromoId"/>
<key-map field-name="productPromoRuleId"/>
<key-map field-name="productPromoActionSeqId"/>
</relation>
</entity>
<entity entity-name="ProductPromoCategory"
package-name="org.ofbiz.product.promo"
title="Product Promotion Category Entity">
<field name="productPromoId" type="id-ne"></field>
<field name="productPromoRuleId" type="id-ne"></field>
<field name="productPromoActionSeqId" type="id-ne"></field>
<field name="productPromoCondSeqId" type="id-ne"></field>
<field name="productCategoryId" type="id-ne"></field>
<field name="andGroupId" type="id"></field>
<field name="productPromoApplEnumId" type="id-ne"></field>
<field name="includeSubCategories" type="indicator"></field>
<prim-key field="productPromoId"/>
<prim-key field="productPromoRuleId"/>
<prim-key field="productPromoActionSeqId"/>
<prim-key field="productPromoCondSeqId"/>
<prim-key field="productCategoryId"/>
<prim-key field="andGroupId"/>
<relation type="one" fk-name="PROD_PRCAT_PROMO" rel-entity-name="ProductPromo">
<key-map field-name="productPromoId"/>
</relation>
<relation type="one" fk-name="PROD_PRCAT_PRCAT" rel-entity-name="ProductCategory">
<key-map field-name="productCategoryId"/>
</relation>
<relation type="one" fk-name="PROD_PRCAT_ENUM" title="Appl" rel-entity-name="Enumeration">
<key-map field-name="productPromoApplEnumId" rel-field-name="enumId"/>
</relation>
</entity>
<entity entity-name="ProductPromoCode"
package-name="org.ofbiz.product.promo"
title="Product Promotion Entity">
<field name="productPromoCodeId" type="id-ne"></field>
<field name="productPromoId" type="id-ne"></field>
<field name="userEntered" type="indicator"></field>
<field name="requireEmailOrParty" type="indicator"></field>
<field name="useLimitPerCode" type="numeric"></field>
<field name="useLimitPerCustomer" type="numeric"></field>
<field name="fromDate" type="date-time"></field>
<field name="thruDate" type="date-time"></field>
<field name="createdDate" type="date-time"></field>
<field name="createdByUserLogin" type="id-vlong"></field>
<field name="lastModifiedDate" type="date-time"></field>
<field name="lastModifiedByUserLogin" type="id-vlong"></field>
<prim-key field="productPromoCodeId"/>
<relation type="one" fk-name="PROD_PRCOD_PROMO" rel-entity-name="ProductPromo">
<key-map field-name="productPromoId"/>
</relation>
<relation type="one" fk-name="PROD_PRCOD_CUL" title="CreatedBy" rel-entity-name="UserLogin">
<key-map field-name="createdByUserLogin" rel-field-name="userLoginId"/>
</relation>
<relation type="one" fk-name="PROD_PRCOD_LMCUL" title="LastModifiedBy" rel-entity-name="UserLogin">
<key-map field-name="lastModifiedByUserLogin" rel-field-name="userLoginId"/>
</relation>
</entity>
<entity entity-name="ProductPromoCodeEmail"
package-name="org.ofbiz.product.promo"
title="Product Promotion Email Entity">
<field name="productPromoCodeId" type="id-ne"></field>
<field name="emailAddress" type="email"></field>
<prim-key field="productPromoCodeId"/>
<prim-key field="emailAddress"/>
<relation type="one" fk-name="PROD_PRCDE_PCD" rel-entity-name="ProductPromoCode">
<key-map field-name="productPromoCodeId"/>
</relation>
</entity>
<view-entity entity-name="ProductPromoCodeEmailParty"
package-name="org.ofbiz.product.promo"
title="Product Promotion Email and Party View Entity">
<member-entity entity-alias="PPCE" entity-name="ProductPromoCodeEmail"/>
<member-entity entity-alias="CM" entity-name="ContactMech"/>
<member-entity entity-alias="PCM" entity-name="PartyContactMech"/>
<alias entity-alias="PPCE" name="productPromoCodeId"/>
<alias entity-alias="CM" name="infoString"/>
<alias entity-alias="PCM" name="partyId"/>
<alias entity-alias="PCM" name="fromDate"/>
<alias entity-alias="PCM" name="thruDate"/>
<view-link entity-alias="PPCE" rel-entity-alias="CM">
<key-map field-name="emailAddress" rel-field-name="infoString"/>
</view-link>
<view-link entity-alias="CM" rel-entity-alias="PCM">
<key-map field-name="contactMechId"/>
</view-link>
</view-entity>
<entity entity-name="ProductPromoCodeParty"
package-name="org.ofbiz.product.promo"
title="Product Promotion Party Entity">
<field name="productPromoCodeId" type="id-ne"></field>
<field name="partyId" type="id-ne"></field>
<prim-key field="productPromoCodeId"/>
<prim-key field="partyId"/>
<relation type="one" fk-name="PROD_PRCDP_PCD" rel-entity-name="ProductPromoCode">
<key-map field-name="productPromoCodeId"/>
</relation>
<relation type="one" fk-name="PROD_PRCDP_PRTY" rel-entity-name="Party">
<key-map field-name="partyId"/>
</relation>
</entity>
<entity entity-name="ProductPromoCond"
package-name="org.ofbiz.product.promo"
title="Product Promotion Condition Entity">
<field name="productPromoId" type="id-ne"></field>
<field name="productPromoRuleId" type="id-ne"></field>
<field name="productPromoCondSeqId" type="id-ne"></field>
<field name="inputParamEnumId" type="id"></field>
<field name="operatorEnumId" type="id"></field>
<field name="condValue" type="long-varchar"></field>
<field name="otherValue" type="long-varchar"></field>
<prim-key field="productPromoId"/>
<prim-key field="productPromoRuleId"/>
<prim-key field="productPromoCondSeqId"/>
<relation type="one" fk-name="PROD_PRCOND_PROMO" rel-entity-name="ProductPromo">
<key-map field-name="productPromoId"/>
</relation>
<relation type="one" fk-name="PROD_PRCOND_RULE" rel-entity-name="ProductPromoRule">
<key-map field-name="productPromoId"/>
<key-map field-name="productPromoRuleId"/>
</relation>
<relation type="one" fk-name="PROD_PRCOND_INENUM" title="InputParam" rel-entity-name="Enumeration">
<key-map field-name="inputParamEnumId" rel-field-name="enumId"/>
</relation>
<relation type="one" fk-name="PROD_PRCOND_OPENUM" title="Operator" rel-entity-name="Enumeration">
<key-map field-name="operatorEnumId" rel-field-name="enumId"/>
</relation>
<relation type="many" rel-entity-name="ProductPromoCategory">
<key-map field-name="productPromoId"/>
<key-map field-name="productPromoRuleId"/>
<key-map field-name="productPromoCondSeqId"/>
</relation>
<relation type="many" rel-entity-name="ProductPromoProduct">
<key-map field-name="productPromoId"/>
<key-map field-name="productPromoRuleId"/>
<key-map field-name="productPromoCondSeqId"/>
</relation>
</entity>
<entity entity-name="ProductPromoProduct"
package-name="org.ofbiz.product.promo"
title="Product Promotion Category Entity">
<field name="productPromoId" type="id-ne"></field>
<field name="productPromoRuleId" type="id-ne"></field>
<field name="productPromoActionSeqId" type="id-ne"></field>
<field name="productPromoCondSeqId" type="id-ne"></field>
<field name="productId" type="id-ne"></field>
<field name="productPromoApplEnumId" type="id-ne"></field>
<prim-key field="productPromoId"/>
<prim-key field="productPromoRuleId"/>
<prim-key field="productPromoActionSeqId"/>
<prim-key field="productPromoCondSeqId"/>
<prim-key field="productId"/>
<relation type="one" fk-name="PROD_PRPRD_PROMO" rel-entity-name="ProductPromo">
<key-map field-name="productPromoId"/>
</relation>
<relation type="one" fk-name="PROD_PRPRD_PROD" rel-entity-name="Product">
<key-map field-name="productId"/>
</relation>
<relation type="one" fk-name="PROD_PRPRD_ENUM" title="Appl" rel-entity-name="Enumeration">
<key-map field-name="productPromoApplEnumId" rel-field-name="enumId"/>
</relation>
</entity>
<entity entity-name="ProductPromoRule"
package-name="org.ofbiz.product.promo"
title="Product Promotion Rule Entity">
<field name="productPromoId" type="id-ne"></field>
<field name="productPromoRuleId" type="id-ne"></field>
<field name="ruleName" type="name"></field>
<prim-key field="productPromoId"/>
<prim-key field="productPromoRuleId"/>
<relation type="one" fk-name="PROD_PRRLE_PROMO" rel-entity-name="ProductPromo">
<key-map field-name="productPromoId"/>
</relation>
</entity>
<entity entity-name="ProductPromoUse"
package-name="org.ofbiz.product.promo"
title="Product Promotion Use Entity">
<field name="orderId" type="id-ne"></field>
<field name="promoSequenceId" type="id-ne"></field>
<field name="productPromoId" type="id-ne"></field>
<field name="productPromoCodeId" type="id-ne"></field>
<field name="partyId" type="id-ne"></field>
<field name="totalDiscountAmount" type="currency-amount"></field>
<field name="quantityLeftInActions" type="fixed-point"></field>
<prim-key field="orderId"/>
<prim-key field="promoSequenceId"/>
<relation type="one" fk-name="PROD_PRUSE_PROMO" rel-entity-name="ProductPromo">
<key-map field-name="productPromoId"/>
</relation>
<relation type="one" fk-name="PROD_PRUSE_CODE" rel-entity-name="ProductPromoCode">
<key-map field-name="productPromoCodeId"/>
</relation>
<relation type="one" fk-name="PROD_PRUSE_ORDR" rel-entity-name="OrderHeader">
<key-map field-name="orderId"/>
</relation>
<relation type="one" fk-name="PROD_PRUSE_PTY" rel-entity-name="Party">
<key-map field-name="partyId"/>
</relation>
<index name="PRODPRUSE_PRMPTY" unique="false">
<index-field name="productPromoId"/>
<index-field name="partyId"/>
</index>
<index name="PRODPRUSE_PCDPTY" unique="false">
<index-field name="productPromoCodeId"/>
<index-field name="partyId"/>
</index>
</entity>
<view-entity entity-name="ProductPromoUseCheck"
package-name="org.ofbiz.product.promo"
title="Product Promotion Use Check View Entity">
<member-entity entity-alias="PPU" entity-name="ProductPromoUse"/>
<member-entity entity-alias="OH" entity-name="OrderHeader"/>
<alias-all entity-alias="PPU"/>
<alias entity-alias="OH" name="statusId"/>
<view-link entity-alias="PPU" rel-entity-alias="OH">
<key-map field-name="orderId"/>
</view-link>
</view-entity>
<!-- ========================================================= -->
<!-- org.ofbiz.product.store -->
<!-- ========================================================= -->
<entity entity-name="ProductStore"
package-name="org.ofbiz.product.store"
title="Product Store Entity"
default-resource-name="ProductEntityLabels">
<field name="productStoreId" type="id-ne"></field>
<field name="primaryStoreGroupId" type="id"></field>
<field name="storeName" type="name"></field>
<field name="companyName" type="name"></field>
<field name="title" type="name"></field>
<field name="subtitle" type="description"></field>
<field name="payToPartyId" type="id">
<description>Note that this corresponds with the organizationPartyId that GL transactions will be posted to.</description>
</field>
<field name="daysToCancelNonPay" type="numeric"></field>
<field name="manualAuthIsCapture" type="indicator"></field>
<field name="prorateShipping" type="indicator"></field>
<field name="prorateTaxes" type="indicator"></field>
<field name="viewCartOnAdd" type="indicator"></field>
<field name="autoSaveCart" type="indicator"></field>
<field name="autoApproveReviews" type="indicator"></field>
<field name="isDemoStore" type="indicator"></field>
<field name="isImmediatelyFulfilled" type="indicator">
<description>If immediately fulfilled (for physical stores, etc): don't send email notices, don't reserve inventory, and IFF inventory info isn't found on the server then don't issue inventory right away</description>
</field>
<field name="inventoryFacilityId" type="id"></field>
<field name="oneInventoryFacility" type="indicator"></field>
<field name="checkInventory" type="indicator"></field>
<field name="reserveInventory" type="indicator"></field>
<field name="reserveOrderEnumId" type="id"></field>
<field name="requireInventory" type="indicator"></field>
<field name="balanceResOnOrderCreation" type="indicator">
<description>If set to Y, when a new sales order is created with backordered items, then reservations on the facility/product are reassigned according to the priority given by the shipBeforeDate field.</description>
</field>
<field name="requirementMethodEnumId" type="id"></field>
<field name="orderNumberPrefix" type="id-long"></field>
<field name="defaultLocaleString" type="very-short"></field>
<field name="defaultCurrencyUomId" type="id"></field>
<field name="defaultSalesChannelEnumId" type="id"></field>
<field name="allowPassword" type="indicator"></field>
<field name="defaultPassword" type="long-varchar"></field>
<field name="explodeOrderItems" type="indicator"></field>
<field name="checkGcBalance" type="indicator"></field>
<field name="retryFailedAuths" type="indicator"></field>
<field name="headerApprovedStatus" type="id"></field>
<field name="itemApprovedStatus" type="id"></field>
<field name="digitalItemApprovedStatus" type="id"></field>
<field name="headerDeclinedStatus" type="id"></field>
<field name="itemDeclinedStatus" type="id"></field>
<field name="headerCancelStatus" type="id"></field>
<field name="itemCancelStatus" type="id"></field>
<field name="authDeclinedMessage" type="long-varchar"></field>
<field name="authFraudMessage" type="long-varchar"></field>
<field name="authErrorMessage" type="long-varchar"></field>
<field name="visualThemeId" type="id"></field>
<field name="storeCreditAccountEnumId" type="id">
<description>Specify the type (Billing Account or Financial Account) of Store Credit Account used for refund return. Default to Financial Account.
This field is override by ReturnHeader.billingAccountId or ReturnHeader.finAccountId, whichever is specified but if only finAccountId is specified explicitly then system will first
try to locate any billing account with -ve amount. If found, then amount is credit to this billing account else the amount will be credit to the financial account of the user.
</description>
</field>
<field name="usePrimaryEmailUsername" type="indicator"></field>
<field name="requireCustomerRole" type="indicator"></field>
<field name="autoInvoiceDigitalItems" type="indicator"><description>Default Y. Invoice digital items when order is placed rather than waiting for completing order items (though shipment/fulfillment).</description></field>
<field name="reqShipAddrForDigItems" type="indicator"><description>Default Y. Require Shipping Address for Digital Items? Note this only has an effect if there are ONLY digital goods in the cart.</description></field>
<field name="showCheckoutGiftOptions" type="indicator"></field>
<field name="selectPaymentTypePerItem" type="indicator"></field>
<field name="showPricesWithVatTax" type="indicator"></field>
<field name="showTaxIsExempt" type="indicator"><description>default Y; if set to N do not show isExempt checkbox for PartyTaxAuthInfo, always force to N</description></field>
<field name="vatTaxAuthGeoId" type="id"></field>
<field name="vatTaxAuthPartyId" type="id"></field>
<field name="enableAutoSuggestionList" type="indicator"><description>The auto-suggestion list is a special ShoppingList that the addSuggestionsToShoppingList service will maintain for cross-sells of ordered items.</description></field>
<field name="enableDigProdUpload" type="indicator"></field>
<field name="prodSearchExcludeVariants" type="indicator"><description>default Y; if set to Y an additional constraint will of isVariant!=Y will be added to all product searches for the store</description></field>
<field name="digProdUploadCategoryId" type="id"></field>
<field name="autoOrderCcTryExp" type="indicator"><description>For auto-orders try other Credit Card expiration dates (if date is wrong or general failure where type not known)?</description></field>
<field name="autoOrderCcTryOtherCards" type="indicator"><description>For auto-orders try other Credit Cards for the customer?</description></field>
<field name="autoOrderCcTryLaterNsf" type="indicator"><description>For auto-orders if Credit Cards fails for NSF (Not Sufficient Funds) try again later?</description></field>
<field name="autoOrderCcTryLaterMax" type="numeric"><description>For auto-orders if Credit Cards fails for NSF try again how many times?</description></field>
<field name="storeCreditValidDays" type="numeric"><description>How many days that store credit is valid for. Null value implies no expiration.</description></field>
<field name="autoApproveInvoice" type="indicator"><description>If Y or empty, sales invoices created from orders will be marked ready.</description></field>
<field name="autoApproveOrder" type="indicator"><description>If N, orders will not be automatically approved when payment is authorized.</description></field>
<field name="shipIfCaptureFails" type="indicator"><description>If N, the captureOrderPayments will cause a service error if credit card capture fails.</description></field>
<field name="setOwnerUponIssuance" type="indicator"><description>If Y or empty, set the inventory item owner upon issuance.</description></field>
<field name="reqReturnInventoryReceive" type="indicator"><description>Default N. This is the default value for the ReturnHeader.needsInventoryReceive field. If set to Y return will automatically go to the Received status when Accepted instead of waiting for actual receipt of the return.</description></field>
<field name="addToCartRemoveIncompat" type="indicator"><description>Default N. If Y then on add to cart remove all products in cart with a ProductAssoc record related to or from the product and with the PRODUCT_INCOMPATABLE type.</description></field>
<field name="addToCartReplaceUpsell" type="indicator"><description>Default N. If Y then on add to cart remove all products in cart with a ProductAssoc record related from the product and with the PRODUCT_UPGRADE type.</description></field>
<field name="splitPayPrefPerShpGrp" type="indicator"><description>Default N. If Y then before the order is stored the OrderPaymentPreference record will be split, one for each OrderItemShipGroup.</description></field>
<field name="managedByLot" type="indicator"><description>If Y, the preparator can choose the InventoryItem by this lotId when he makes the picklist.</description></field>
<field name="showOutOfStockProducts" type="indicator"><description>Default Y. If N then out of stock products will not be displayed on site</description></field>
<field name="orderDecimalQuantity" type="indicator"><description>use to indicate if decimal quantity can be ordered for this producStore. Default value is Y</description></field>
<!-- old fields, deprecated -->
<field name="oldStyleSheet" col-name="STYLE_SHEET" type="url"></field>
<field name="oldHeaderLogo" col-name="HEADER_LOGO" type="url"></field>
<field name="oldHeaderMiddleBackground" col-name="HEADER_MIDDLE_BACKGROUND" type="url"></field>
<field name="oldHeaderRightBackground" col-name="HEADER_RIGHT_BACKGROUND" type="url"></field>
<prim-key field="productStoreId"/>
<relation type="one" fk-name="PROD_STR_PRSTRGP" title="Primary" rel-entity-name="ProductStoreGroup">
<key-map field-name="primaryStoreGroupId" rel-field-name="productStoreGroupId"/>
</relation>
<relation type="one" fk-name="PROD_STR_FACILITY" rel-entity-name="Facility">
<key-map field-name="inventoryFacilityId" rel-field-name="facilityId"/>
</relation>
<relation type="one" fk-name="PROD_STR_RORDENUM" title="ReserveOrder" rel-entity-name="Enumeration">
<key-map field-name="reserveOrderEnumId" rel-field-name="enumId"/>
</relation>
<relation type="one" fk-name="PROD_STR_RQMTENUM" title="RequirementMethod" rel-entity-name="Enumeration">
<key-map field-name="requirementMethodEnumId" rel-field-name="enumId"/>
</relation>
<relation type="one" fk-name="PROD_STR_PAYTOPTY" rel-entity-name="Party">
<key-map field-name="payToPartyId" rel-field-name="partyId"/>
</relation>
<relation type="one" fk-name="PROD_STR_CURUOM" rel-entity-name="Uom">
<key-map field-name="defaultCurrencyUomId" rel-field-name="uomId"/>
</relation>
<relation type="one" fk-name="PROD_STR_SALECHN" title="DefaultSalesChannel" rel-entity-name="Enumeration">
<key-map field-name="defaultSalesChannelEnumId" rel-field-name="enumId"/>
</relation>
<relation type="one" fk-name="PROD_STR_HAPSTS" title="HeaderApproved" rel-entity-name="StatusItem">
<key-map field-name="headerApprovedStatus" rel-field-name="statusId"/>
</relation>
<relation type="one" fk-name="PROD_STR_IAPSTS" title="ItemApproved" rel-entity-name="StatusItem">
<key-map field-name="itemApprovedStatus" rel-field-name="statusId"/>
</relation>
<relation type="one" fk-name="PROD_STR_DIAPSTS" title="DigitalItemApproved" rel-entity-name="StatusItem">
<key-map field-name="digitalItemApprovedStatus" rel-field-name="statusId"/>
</relation>
<relation type="one" fk-name="PROD_STR_HDCSTS" title="HeaderDeclined" rel-entity-name="StatusItem">
<key-map field-name="headerDeclinedStatus" rel-field-name="statusId"/>
</relation>
<relation type="one" fk-name="PROD_STR_IDCSTS" title="ItemDeclined" rel-entity-name="StatusItem">
<key-map field-name="itemDeclinedStatus" rel-field-name="statusId"/>
</relation>
<relation type="one" fk-name="PROD_STR_HCNSTS" title="HeaderCancel" rel-entity-name="StatusItem">
<key-map field-name="headerCancelStatus" rel-field-name="statusId"/>
</relation>
<relation type="one" fk-name="PROD_STR_ICNSTS" title="ItemCancel" rel-entity-name="StatusItem">
<key-map field-name="itemCancelStatus" rel-field-name="statusId"/>
</relation>
<relation type="one" fk-name="PROD_STR_VATTXA" title="Vat" rel-entity-name="TaxAuthority">
<key-map field-name="vatTaxAuthGeoId" rel-field-name="taxAuthGeoId"/>
<key-map field-name="vatTaxAuthPartyId" rel-field-name="taxAuthPartyId"/>
</relation>
<relation type="one" fk-name="PROD_STR_STRCRDACT" title="StoreCreditAccount" rel-entity-name="Enumeration">
<key-map field-name="storeCreditAccountEnumId" rel-field-name="enumId"/>
</relation>
</entity>
<entity entity-name="ProductStoreCatalog"
package-name="org.ofbiz.product.store"
title="Product Store Catalog Association Entity">
<field name="productStoreId" type="id-ne"></field>
<field name="prodCatalogId" type="id-ne"></field>
<field name="fromDate" type="date-time"></field>
<field name="thruDate" type="date-time"></field>
<field name="sequenceNum" type="numeric"></field>
<prim-key field="productStoreId"/>
<prim-key field="prodCatalogId"/>
<prim-key field="fromDate"/>
<relation type="one" fk-name="PS_CAT_PRDSTR" rel-entity-name="ProductStore">
<key-map field-name="productStoreId"/>
</relation>
<relation type="one" fk-name="PS_CAT_CATALOG" rel-entity-name="ProdCatalog">
<key-map field-name="prodCatalogId"/>
</relation>
</entity>
<entity entity-name="ProductStoreEmailSetting"
package-name="org.ofbiz.product.store"
title="Product Store Email Settings Entity">
<field name="productStoreId" type="id-ne"></field>
<field name="emailType" type="id-ne"></field>
<field name="bodyScreenLocation" type="long-varchar"><description>if empty defaults to a screen based on the emailType</description></field>
<field name="xslfoAttachScreenLocation" type="long-varchar"><description>if specified is used to generate XSL:FO that is transformed to a PDF via Apache FOP and attached to the email</description></field>
<field name="fromAddress" type="email"></field>
<field name="ccAddress" type="email"></field>
<field name="bccAddress" type="email"></field>
<field name="subject" type="comment"></field>
<field name="contentType" type="long-varchar"></field>
<prim-key field="productStoreId"/>
<prim-key field="emailType"/>
<relation type="one" fk-name="PRDSTREM_PRDS" rel-entity-name="ProductStore">
<key-map field-name="productStoreId"/>
</relation>
<relation type="one" fk-name="PRDSTREM_ENUM" rel-entity-name="Enumeration">
<key-map field-name="emailType" rel-field-name="enumId"/>
</relation>
</entity>
<entity entity-name="ProductStoreFinActSetting"
package-name="org.ofbiz.product.store"
title="Allows financial account, such as gift certificate or calling cards, to be configured at store level">
<field name="productStoreId" type="id-ne"/>
<field name="finAccountTypeId" type="id-ne"/>
<field name="requirePinCode" type="indicator"/>
<field name="validateGCFinAcct" type="indicator">
<description>determines whether the store should validate gift card numbers against the gift certificate codes stored in FinAccount.
Set to N if using external gift card provider.</description>
</field>
<field name="accountCodeLength" type="numeric">
<description>length of auto-generated account code</description>
</field>
<field name="pinCodeLength" type="numeric">
<description>length of auto-generated pin code, if it is required</description>
</field>
<field name="accountValidDays" type="numeric">
<description>number of days an account of this type would be valid for</description>
</field>
<field name="authValidDays" type="numeric">
<description>number of days an authorization of this type would be valid for</description>
</field>
<field name="purchaseSurveyId" type="id">
<description>This survey is typically used to collect information such as name of buyer, recipient, email, message, etc. and is quite flexible</description>
</field>
<field name="purchSurveySendTo" type="id">
<description>Field name on the purchase survey with the send to email address</description>
</field>
<field name="purchSurveyCopyMe" type="id">
<description>Whether the BCC on ProductStoreEmailSetting should be copied for email notifications</description>
</field>
<field name="allowAuthToNegative" type="indicator"></field>
<field name="minBalance" type="currency-amount"></field>
<field name="replenishThreshold" type="currency-amount"></field>
<field name="replenishMethodEnumId" type="id">
<description>Replenish Method for Replenish Account. Can be FARP_TOP_OFF or FARP_REPLENISH_LEVEL. Default FARP_TOP_OFF.</description>
</field>
<prim-key field="productStoreId"/>
<prim-key field="finAccountTypeId"/>
<relation rel-entity-name="ProductStore" type="one" fk-name="PRSTFNAC_PRDS">
<key-map field-name="productStoreId"/>
</relation>
<relation rel-entity-name="FinAccountType" type="one" fk-name="PRSTFNAC_FNACTP">
<key-map field-name="finAccountTypeId"/>
</relation>
<relation rel-entity-name="Survey" type="one" fk-name="PRSTFNAC_SRVY">
<key-map field-name="purchaseSurveyId" rel-field-name="surveyId"/>
</relation>
<relation type="one" fk-name="PRSTFNAC_FARPMTD" title="ReplenishMethod" rel-entity-name="Enumeration">
<key-map field-name="replenishMethodEnumId" rel-field-name="enumId"/>
</relation>
</entity>
<entity entity-name="ProductStoreFacility"
package-name="org.ofbiz.product.store"
title="Product Store Inventory Facility Applicability Entity">
<field name="productStoreId" type="id-ne"></field>
<field name="facilityId" type="id-ne"></field>
<field name="fromDate" type="date-time"></field>
<field name="thruDate" type="date-time"></field>
<field name="sequenceNum" type="numeric"></field>
<prim-key field="productStoreId"/>
<prim-key field="facilityId"/>
<prim-key field="fromDate"/>
<relation type="one" fk-name="PRDSTRFAC_PRDS" rel-entity-name="ProductStore">
<key-map field-name="productStoreId"/>
</relation>
<relation type="one" fk-name="PRDSTRFAC_FAC" rel-entity-name="Facility">
<key-map field-name="facilityId"/>
</relation>
</entity>
<view-entity entity-name="ProductStoreFacilityByOrder"
package-name="org.ofbiz.product.store"
title="Product Store Facility By Order">
<member-entity entity-alias="ORH" entity-name="OrderHeader"/>
<member-entity entity-alias="PSF" entity-name="ProductStoreFacility"/>
<member-entity entity-alias="PDS" entity-name="ProductStore"/>
<member-entity entity-alias="FAC" entity-name="Facility"/>
<alias entity-alias="ORH" name="orderId"/>
<alias entity-alias="PSF" name="productStoreId"/>
<alias entity-alias="PSF" name="facilityId"/>
<alias entity-alias="PSF" name="fromDate"/>
<alias entity-alias="PSF" name="thruDate"/>
<alias entity-alias="PSF" name="sequenceNum"/>
<alias entity-alias="PDS" name="storeName"/>
<alias entity-alias="FAC" name="facilityName"/>
<alias entity-alias="FAC" name="facilityTypeId"/>
<view-link entity-alias="ORH" rel-entity-alias="PSF">
<key-map field-name="productStoreId"/>
</view-link>
<view-link entity-alias="PSF" rel-entity-alias="PDS">
<key-map field-name="productStoreId"/>
</view-link>
<view-link entity-alias="PSF" rel-entity-alias="FAC">
<key-map field-name="facilityId"/>
</view-link>
</view-entity>
<entity entity-name="ProductStoreGroup"
package-name="org.ofbiz.product.store"
default-resource-name="ProductEntityLabels"
title="ProductStore Group Entity">
<field name="productStoreGroupId" type="id-ne"></field>
<field name="productStoreGroupTypeId" type="id"></field>
<field name="primaryParentGroupId" type="id"></field>
<field name="productStoreGroupName" type="name"></field>
<field name="description" type="description"></field>
<prim-key field="productStoreGroupId"/>
<relation type="one" fk-name="PRDSTR_GP_TYPE" rel-entity-name="ProductStoreGroupType">
<key-map field-name="productStoreGroupTypeId"/>
</relation>
<relation type="one" fk-name="PRDSTR_GP_PGRP" title="PrimaryParent" rel-entity-name="ProductStoreGroup">
<key-map field-name="primaryParentGroupId" rel-field-name="productStoreGroupId"/>
</relation>
</entity>
<entity entity-name="ProductStoreGroupMember"
package-name="org.ofbiz.product.store"
title="ProductStore Group Member Entity">
<field name="productStoreId" type="id-ne"></field>
<field name="productStoreGroupId" type="id-ne"></field>
<field name="fromDate" type="date-time"></field>
<field name="thruDate" type="date-time"></field>
<field name="sequenceNum" type="numeric"></field>
<prim-key field="productStoreId"/>
<prim-key field="productStoreGroupId"/>
<prim-key field="fromDate"/>
<relation type="one" fk-name="PRDSTR_MEM_PRDSTR" rel-entity-name="ProductStore">
<key-map field-name="productStoreId"/>
</relation>
<relation type="one" fk-name="PRDSTR_MEM_PSGRP" rel-entity-name="ProductStoreGroup">
<key-map field-name="productStoreGroupId"/>
</relation>
</entity>
<entity entity-name="ProductStoreGroupRole"
package-name="org.ofbiz.product.store"
title="ProductStore Group Role Entity">
<field name="productStoreGroupId" type="id-ne"></field>
<field name="partyId" type="id"></field>
<field name="roleTypeId" type="id"></field>
<prim-key field="productStoreGroupId"/>
<prim-key field="partyId"/>
<prim-key field="roleTypeId"/>
<relation type="one" fk-name="PSGRP_RLE_PSGP" rel-entity-name="ProductStoreGroup">
<key-map field-name="productStoreGroupId"/>
</relation>
<relation type="one" fk-name="PSGRP_RLE_PTRLE" rel-entity-name="PartyRole">
<key-map field-name="partyId"/>
<key-map field-name="roleTypeId"/>
</relation>
<relation type="one-nofk" rel-entity-name="Party">
<key-map field-name="partyId"/>
</relation>
<relation type="one-nofk" rel-entity-name="RoleType">
<key-map field-name="roleTypeId"/>
</relation>
</entity>
<entity entity-name="ProductStoreGroupRollup"
package-name="org.ofbiz.product.store"
title="ProductStore Group Rollup Entity">
<field name="productStoreGroupId" type="id-ne"></field>
<field name="parentGroupId" type="id-ne"></field>
<field name="fromDate" type="date-time"></field>
<field name="thruDate" type="date-time"></field>
<field name="sequenceNum" type="numeric"></field>
<prim-key field="productStoreGroupId"/>
<prim-key field="parentGroupId"/>
<prim-key field="fromDate"/>
<relation type="one" fk-name="PSGRP_RLP_CURRENT" title="Current" rel-entity-name="ProductStoreGroup">
<key-map field-name="productStoreGroupId"/>
</relation>
<relation type="one" fk-name="PSGRP_RLP_PARENT" title="Parent" rel-entity-name="ProductStoreGroup">
<key-map field-name="parentGroupId" rel-field-name="productStoreGroupId"/>
</relation>
<relation type="many" title="Child" rel-entity-name="ProductStoreGroupRollup">
<key-map field-name="productStoreGroupId" rel-field-name="parentGroupId"/>
</relation>
<relation type="many" title="Parent" rel-entity-name="ProductStoreGroupRollup">
<key-map field-name="parentGroupId" rel-field-name="productStoreGroupId"/>
</relation>
<relation type="many" title="Sibling" rel-entity-name="ProductStoreGroupRollup">
<key-map field-name="parentGroupId"/>
</relation>
</entity>
<entity entity-name="ProductStoreGroupType"
package-name="org.ofbiz.product.store"
title="ProductStore Group Type Entity">
<field name="productStoreGroupTypeId" type="id-ne"></field>
<field name="description" type="description"></field>
<prim-key field="productStoreGroupTypeId"/>
</entity>
<entity entity-name="ProductStoreKeywordOvrd"
package-name="org.ofbiz.product.store"
title="Product Store Inventory Facility Applicability Entity">
<field name="productStoreId" type="id-ne"></field>
<field name="keyword" type="short-varchar"></field>
<field name="fromDate" type="date-time"></field>
<field name="thruDate" type="date-time"></field>
<field name="target" type="long-varchar"></field>
<field name="targetTypeEnumId" type="id"></field>
<prim-key field="productStoreId"/>
<prim-key field="keyword"/>
<prim-key field="fromDate"/>
<relation type="one" fk-name="PRDSTRKWO_PRDS" rel-entity-name="ProductStore">
<key-map field-name="productStoreId"/>
</relation>
<relation type="one" fk-name="PRDSTRKWO_ENM" rel-entity-name="Enumeration">
<key-map field-name="targetTypeEnumId" rel-field-name="enumId"/>
</relation>
</entity>
<entity entity-name="ProductStorePaymentSetting"
package-name="org.ofbiz.product.store"
title="Product Store Payment Settings Entity">
<field name="productStoreId" type="id-ne"></field>
<field name="paymentMethodTypeId" type="id-ne"></field>
<field name="paymentServiceTypeEnumId" type="id-ne"></field>
<field name="paymentService" type="value"></field>
<field name="paymentCustomMethodId" type="id"></field>
<field name="paymentGatewayConfigId" type="id"></field>
<field name="paymentPropertiesPath" type="value"></field>
<field name="applyToAllProducts" type="indicator"></field>
<prim-key field="productStoreId"/>
<prim-key field="paymentMethodTypeId"/>
<prim-key field="paymentServiceTypeEnumId"/>
<relation type="one" fk-name="PRDS_PS_PRDS" rel-entity-name="ProductStore">
<key-map field-name="productStoreId"/>
</relation>
<relation type="one" fk-name="PRDS_PS_PMNTTP" rel-entity-name="PaymentMethodType">
<key-map field-name="paymentMethodTypeId"/>
</relation>
<relation type="one" fk-name="PRDS_PS_ENUM" rel-entity-name="Enumeration">
<key-map field-name="paymentServiceTypeEnumId" rel-field-name="enumId"/>
</relation>
<relation type="one" fk-name="PRDS_PS_PGC" rel-entity-name="PaymentGatewayConfig">
<key-map field-name="paymentGatewayConfigId"/>
</relation>
<relation type="one" fk-name="PRDS_PS_CUS_MET" rel-entity-name="CustomMethod">
<key-map field-name="paymentCustomMethodId" rel-field-name="customMethodId"/>
</relation>
</entity>
<view-entity entity-name="ProductStorePromoAndAppl"
package-name="org.ofbiz.product.store"
title="Product Store Promotion and Applicability View Entity">
<member-entity entity-alias="PSPA" entity-name="ProductStorePromoAppl"/>
<member-entity entity-alias="PP" entity-name="ProductPromo"/>
<alias-all entity-alias="PSPA"/>
<alias entity-alias="PP" name="promoName"/>
<alias entity-alias="PP" name="userEntered"/>
<view-link entity-alias="PSPA" rel-entity-alias="PP">
<key-map field-name="productPromoId"/>
</view-link>
</view-entity>
<entity entity-name="ProductStorePromoAppl"
package-name="org.ofbiz.product.store"
title="Product Store Promotion Applicability Entity">
<field name="productStoreId" type="id-ne"></field>
<field name="productPromoId" type="id-ne"></field>
<field name="fromDate" type="date-time"></field>
<field name="thruDate" type="date-time"></field>
<field name="sequenceNum" type="numeric"></field>
<field name="manualOnly" type="indicator">
<description>
If set to Y then the promotion is not automatically evaluated, but only if it
is manually added to the cart.
</description>
</field>
<prim-key field="productStoreId"/>
<prim-key field="productPromoId"/>
<prim-key field="fromDate"/>
<relation type="one" fk-name="PRDSTRPRMO_PRDS" rel-entity-name="ProductStore">
<key-map field-name="productStoreId"/>
</relation>
<relation type="one" fk-name="PRDSTRPRMO_PRMO" rel-entity-name="ProductPromo">
<key-map field-name="productPromoId"/>
</relation>
</entity>
<entity entity-name="ProductStoreRole"
package-name="org.ofbiz.product.store"
title="Product Store Role Association Entity">
<field name="partyId" type="id-ne"></field>
<field name="roleTypeId" type="id-ne"></field>
<field name="productStoreId" type="id-ne"></field>
<field name="fromDate" type="date-time"></field>
<field name="thruDate" type="date-time"></field>
<field name="sequenceNum" type="numeric"></field>
<prim-key field="partyId"/>
<prim-key field="roleTypeId"/>
<prim-key field="productStoreId"/>
<prim-key field="fromDate"/>
<relation type="one-nofk" rel-entity-name="Party">
<key-map field-name="partyId"/>
</relation>
<relation type="one-nofk" rel-entity-name="RoleType">
<key-map field-name="roleTypeId"/>
</relation>
<relation type="one-nofk" rel-entity-name="Person">
<key-map field-name="partyId"/>
</relation>
<relation type="one-nofk" rel-entity-name="PartyGroup">
<key-map field-name="partyId"/>
</relation>
<relation type="one" fk-name="PRDSTRRLE_PRLE" rel-entity-name="PartyRole">
<key-map field-name="partyId"/>
<key-map field-name="roleTypeId"/>
</relation>
<relation type="one" fk-name="PRDSTRRLE_PRDS" rel-entity-name="ProductStore">
<key-map field-name="productStoreId"/>
</relation>
</entity>
<entity entity-name="ProductStoreShipmentMeth"
package-name="org.ofbiz.product.store"
title="Product Store Carrier Shipment Method Entity">
<field name="productStoreShipMethId" type="id-ne"></field>
<field name="productStoreId" type="id-ne"></field>
<field name="shipmentMethodTypeId" type="id-ne"></field>
<field name="partyId" type="id-ne"></field>
<field name="roleTypeId" type="id-ne"></field>
<field name="companyPartyId" type="id"></field>
<field name="minWeight" type="fixed-point"></field>
<field name="maxWeight" type="fixed-point"></field>
<field name="minSize" type="fixed-point"></field>
<field name="maxSize" type="fixed-point"></field>
<field name="minTotal" type="currency-amount"></field>
<field name="maxTotal" type="currency-amount"></field>
<field name="allowUspsAddr" type="indicator"></field>
<field name="requireUspsAddr" type="indicator"></field>
<field name="allowCompanyAddr" type="indicator"></field>
<field name="requireCompanyAddr" type="indicator"></field>
<field name="includeNoChargeItems" type="indicator"></field>
<field name="includeFeatureGroup" type="id"></field>
<field name="excludeFeatureGroup" type="id"></field>
<field name="includeGeoId" type="id"></field>
<field name="excludeGeoId" type="id"></field>
<field name="serviceName" type="long-varchar"></field>
<field name="configProps" type="long-varchar"></field>
<field name="shipmentCustomMethodId" type="id"></field>
<field name="shipmentGatewayConfigId" type="id"></field>
<field name="sequenceNumber" type="numeric"></field>
<prim-key field="productStoreShipMethId"/>
<relation type="one-nofk" rel-entity-name="Party">
<key-map field-name="companyPartyId" rel-field-name="partyId"/>
</relation>
<relation type="one" rel-entity-name="ShipmentMethodType">
<key-map field-name="shipmentMethodTypeId"/>
</relation>
<relation type="one-nofk" title="Include" rel-entity-name="Geo">
<key-map field-name="includeGeoId" rel-field-name="geoId"/>
</relation>
<relation type="one-nofk" title="Exclude" rel-entity-name="Geo">
<key-map field-name="excludeGeoId" rel-field-name="geoId"/>
</relation>
<relation type="one" fk-name="PRDS_SM_SGC" rel-entity-name="ShipmentGatewayConfig">
<key-map field-name="shipmentGatewayConfigId"/>
</relation>
<relation type="one" fk-name="PRDS_SM_CUS_MET" rel-entity-name="CustomMethod">
<key-map field-name="shipmentCustomMethodId" rel-field-name="customMethodId"/>
</relation>
</entity>
<view-entity entity-name="ProductStoreShipmentMethView"
package-name="org.ofbiz.product.store"
title="Product Store Carrier And Shipment Method Type View Entity">
<member-entity entity-alias="PSSM" entity-name="ProductStoreShipmentMeth"/>
<member-entity entity-alias="SM" entity-name="ShipmentMethodType"/>
<alias entity-alias="PSSM" name="productStoreShipMethId"/>
<alias entity-alias="PSSM" name="productStoreId"/>
<alias entity-alias="PSSM" name="shipmentMethodTypeId"/>
<alias entity-alias="PSSM" name="partyId"/>
<alias entity-alias="PSSM" name="roleTypeId"/>
<alias entity-alias="PSSM" name="companyPartyId"/>
<alias entity-alias="PSSM" name="minSize"/>
<alias entity-alias="PSSM" name="maxSize"/>
<alias entity-alias="PSSM" name="minTotal"/>
<alias entity-alias="PSSM" name="maxTotal"/>
<alias entity-alias="PSSM" name="minWeight"/>
<alias entity-alias="PSSM" name="maxWeight"/>
<alias entity-alias="PSSM" name="allowUspsAddr"/>
<alias entity-alias="PSSM" name="requireUspsAddr"/>
<alias entity-alias="PSSM" name="allowCompanyAddr"/>
<alias entity-alias="PSSM" name="requireCompanyAddr"/>
<alias entity-alias="PSSM" name="includeNoChargeItems"/>
<alias entity-alias="PSSM" name="includeGeoId"/>
<alias entity-alias="PSSM" name="excludeGeoId"/>
<alias entity-alias="PSSM" name="includeFeatureGroup"/>
<alias entity-alias="PSSM" name="excludeFeatureGroup"/>
<alias entity-alias="PSSM" name="serviceName"/>
<alias entity-alias="PSSM" name="configProps"/>
<alias entity-alias="PSSM" name="shipmentCustomMethodId"/>
<alias entity-alias="PSSM" name="shipmentGatewayConfigId"/>
<alias entity-alias="PSSM" name="sequenceNumber"/>
<alias entity-alias="SM" name="description"/>
<view-link entity-alias="PSSM" rel-entity-alias="SM">
<key-map field-name="shipmentMethodTypeId"/>
</view-link>
<relation type="one-nofk" rel-entity-name="Party">
<key-map field-name="companyPartyId" rel-field-name="partyId"/>
</relation>
<relation type="one-nofk" title="Include" rel-entity-name="Geo">
<key-map field-name="includeGeoId" rel-field-name="geoId"/>
</relation>
<relation type="one-nofk" title="Exclude" rel-entity-name="Geo">
<key-map field-name="excludeGeoId" rel-field-name="geoId"/>
</relation>
<relation type="one-nofk" rel-entity-name="PartyGroup">
<key-map field-name="partyId"/>
</relation>
<relation type="one-nofk" rel-entity-name="ShipmentMethodType">
<key-map field-name="shipmentMethodTypeId"/>
</relation>
</view-entity>
<entity entity-name="ProductStoreSurveyAppl"
package-name="org.ofbiz.product.store"
title="Product Store Survey Application Entity">
<field name="productStoreSurveyId" type="id-ne"></field>
<field name="productStoreId" type="id-ne"></field>
<field name="surveyApplTypeId" type="id-ne"></field>
<field name="groupName" type="name"></field>
<field name="surveyId" type="id-ne"></field>
<field name="productId" type="id"></field>
<field name="productCategoryId" type="id"></field>
<field name="fromDate" type="date-time"></field>
<field name="thruDate" type="date-time"></field>
<field name="surveyTemplate" type="long-varchar"></field>
<field name="resultTemplate" type="long-varchar"></field>
<field name="sequenceNum" type="numeric"></field>
<prim-key field="productStoreSurveyId"/>
<relation type="one" fk-name="PRDSTRSVY_PRDS" rel-entity-name="ProductStore">
<key-map field-name="productStoreId"/>
</relation>
<relation type="one" fk-name="PRDSTRSVY_SRVY" rel-entity-name="Survey">
<key-map field-name="surveyId"/>
</relation>
<relation type="one" fk-name="PRDSTRSVY_SATP" rel-entity-name="SurveyApplType">
<key-map field-name="surveyApplTypeId"/>
</relation>
<relation type="one-nofk" rel-entity-name="Product">
<key-map field-name="productId"/>
</relation>
<relation type="one-nofk" rel-entity-name="ProductCategory">
<key-map field-name="productCategoryId"/>
</relation>
</entity>
<entity entity-name="ProductStoreVendorPayment" package-name="org.ofbiz.product.store" title="Product Store Vendor Payment Entity">
<description>Used to define payments that a vendor related to the store will accept (for multi-vendor stores)</description>
<field name="productStoreId" type="id-ne"/>
<field name="vendorPartyId" type="id-ne"/>
<field name="paymentMethodTypeId" type="id-ne"/>
<field name="creditCardEnumId" type="id-ne"><description>If not applicable for the paymentMethodTypeId, use "_NA_"</description></field>
<prim-key field="productStoreId"/>
<prim-key field="vendorPartyId"/>
<prim-key field="paymentMethodTypeId"/>
<prim-key field="creditCardEnumId"/>
<relation type="one" fk-name="PRDSTRVPM_PRDS" rel-entity-name="ProductStore">
<key-map field-name="productStoreId"/>
</relation>
<relation type="one" fk-name="PRDSTRVPM_VPTY" title="Vendor" rel-entity-name="Party">
<key-map field-name="vendorPartyId" rel-field-name="partyId"/>
</relation>
<relation type="one" fk-name="PRDSTRVPM_PMMT" rel-entity-name="PaymentMethodType">
<key-map field-name="paymentMethodTypeId"/>
</relation>
<relation type="one" fk-name="PRDSTRVPM_CCEN" title="CreditCard" rel-entity-name="Enumeration">
<key-map field-name="creditCardEnumId" rel-field-name="enumId"/>
</relation>
</entity>
<entity entity-name="ProductStoreVendorShipment" package-name="org.ofbiz.product.store" title="Product Store Vendor Shipment Entity">
<description>Used to define Carrier-ShipmentMethod combinations that a vendor related to the store will accept (for multi-vendor stores)</description>
<field name="productStoreId" type="id-ne"/>
<field name="vendorPartyId" type="id-ne"/>
<field name="shipmentMethodTypeId" type="id-ne"/>
<field name="carrierPartyId" type="id-ne"/>
<prim-key field="productStoreId"/>
<prim-key field="vendorPartyId"/>
<prim-key field="shipmentMethodTypeId"/>
<prim-key field="carrierPartyId"/>
<relation type="one" fk-name="PRDSTRVSH_PRDS" rel-entity-name="ProductStore">
<key-map field-name="productStoreId"/>
</relation>
<relation type="one" fk-name="PRDSTRVSH_VPTY" title="Vendor" rel-entity-name="Party">
<key-map field-name="vendorPartyId" rel-field-name="partyId"/>
</relation>
<relation type="one" fk-name="PRDSTRVSH_SHMT" rel-entity-name="ShipmentMethodType">
<key-map field-name="shipmentMethodTypeId"/>
</relation>
<relation type="one" fk-name="PRDSTRVSH_CPTY" title="Carrier" rel-entity-name="Party">
<key-map field-name="carrierPartyId" rel-field-name="partyId"/>
</relation>
</entity>
<extend-entity entity-name="WebSite">
<field name="productStoreId" type="id"></field>
<field name="allowProductStoreChange" type="indicator"><description>Allow change of ProductStore for this WebSite (webapp). Defaults to N (no).</description></field>
<relation type="one" fk-name="WEB_SITE_PRDS" rel-entity-name="ProductStore">
<key-map field-name="productStoreId"/>
</relation>
</extend-entity>
<!-- ========================================================= -->
<!-- org.ofbiz.product.subscription -->
<!-- ========================================================= -->
<entity entity-name="ProductSubscriptionResource"
package-name="org.ofbiz.product.subscription"
title="Product Subscription Resource Entity">
<field name="productId" type="id-ne"></field>
<field name="subscriptionResourceId" type="id-ne"></field>
<field name="fromDate" type="date-time"></field>
<field name="thruDate" type="date-time"></field>
<field name="purchaseFromDate" type="date-time"></field>
<field name="purchaseThruDate" type="date-time"></field>
<field name="maxLifeTime" type="numeric"><description>The length in time of the subscription</description></field>
<field name="maxLifeTimeUomId" type="id"></field>
<field name="availableTime" type="numeric"></field>
<field name="availableTimeUomId" type="id"></field>
<field name="useCountLimit" type="numeric"></field>
<field name="useTime" type="numeric"><description>The length of time this subscription can be used</description></field>
<field name="useTimeUomId" type="id"></field>
<field name="useRoleTypeId" type="id"></field>
<field name="automaticExtend" type="indicator"><description>If this subscription is automatically extended with the same period as the initial period.</description></field>
<field name="canclAutmExtTime" type="numeric"><description>The time period (before the end of the thruDate) after which the automatic extension of the subscription will be executed.</description></field>
<field name="canclAutmExtTimeUomId" type="id"><description>Unit Of Measure used for the automatic extension of the subscription.</description></field>
<prim-key field="productId"/>
<prim-key field="subscriptionResourceId"/>
<prim-key field="fromDate"/>
<relation type="one" fk-name="PROD_SBRS_PROD" rel-entity-name="Product">
<key-map field-name="productId"/>
</relation>
<relation type="one" fk-name="PROD_SBRS_SBRS" rel-entity-name="SubscriptionResource">
<key-map field-name="subscriptionResourceId"/>
</relation>
<relation type="one" fk-name="PROD_SBRS_URT" title="Use" rel-entity-name="RoleType">
<key-map field-name="useRoleTypeId" rel-field-name="roleTypeId"/>
</relation>
<relation type="one" fk-name="PROD_SBRS_UTU" title="UseTime" rel-entity-name="Uom">
<key-map field-name="useTimeUomId" rel-field-name="uomId"/>
</relation>
<relation type="one" fk-name="PROD_SBRS_CTU" title="CancelTime" rel-entity-name="Uom">
<key-map field-name="canclAutmExtTimeUomId" rel-field-name="uomId"/>
</relation>
<relation type="one" fk-name="PROD_SBRS_ATU" title="AvailableTime" rel-entity-name="Uom">
<key-map field-name="availableTimeUomId" rel-field-name="uomId"/>
</relation>
<relation type="one" fk-name="PROD_SBRS_MTU" title="MaxLifeTime" rel-entity-name="Uom">
<key-map field-name="maxLifeTimeUomId" rel-field-name="uomId"/>
</relation>
</entity>
<entity entity-name="Subscription"
package-name="org.ofbiz.product.subscription"
title="Subscription Entity">
<field name="subscriptionId" type="id-ne"></field>
<field name="description" type="description"></field>
<field name="subscriptionResourceId" type="id"></field>
<field name="communicationEventId" type="id"><description>now replaced by entity: SubscriptionCommEvent</description></field>
<field name="contactMechId" type="id"></field>
<field name="originatedFromPartyId" type="id"></field>
<field name="originatedFromRoleTypeId" type="id"></field>
<field name="partyId" type="id"></field>
<field name="roleTypeId" type="id"></field>
<field name="partyNeedId" type="id"></field>
<field name="needTypeId" type="id"></field>
<field name="orderId" type="id"></field>
<field name="orderItemSeqId" type="id"></field>
<field name="productId" type="id"></field>
<field name="productCategoryId" type="id"></field>
<field name="inventoryItemId" type="id"></field>
<field name="subscriptionTypeId" type="id"></field>
<field name="externalSubscriptionId" type="id"></field>
<field name="fromDate" type="date-time"></field>
<field name="thruDate" type="date-time"></field>
<!-- this subscription instance resource values -->
<field name="purchaseFromDate" type="date-time"></field>
<field name="purchaseThruDate" type="date-time"></field>
<field name="maxLifeTime" type="numeric"><description>The length in time of the (extended) subscription</description></field>
<field name="maxLifeTimeUomId" type="id"></field>
<field name="availableTime" type="numeric"></field>
<field name="availableTimeUomId" type="id"></field>
<field name="useCountLimit" type="numeric"></field>
<field name="useTime" type="numeric"></field>
<field name="useTimeUomId" type="id"></field>
<field name="automaticExtend" type="indicator"><description>If this subscription is automatically extended with the same period as the initial period.</description></field>
<field name="canclAutmExtTime" type="numeric"><description>The time period (before the end of the thruDate) after which the automatic extension of the subscription will be executed.</description></field>
<field name="canclAutmExtTimeUomId" type="id"><description>Unit Of Measure used for the automatic extension of the subscription.</description></field>
<prim-key field="subscriptionId"/>
<relation type="one" fk-name="SUBSC_SRESRC" rel-entity-name="SubscriptionResource">
<key-map field-name="subscriptionResourceId"/>
</relation>
<relation type="one" fk-name="SUBSC_CONT_MECH" rel-entity-name="ContactMech">
<key-map field-name="contactMechId"/>
</relation>
<relation type="one" fk-name="SUBSC_PARTY" rel-entity-name="Party">
<key-map field-name="partyId"/>
</relation>
<relation type="one" fk-name="SUBSC_UTU" title="UseTime" rel-entity-name="Uom">
<key-map field-name="useTimeUomId" rel-field-name="uomId"/>
</relation>
<relation type="one" fk-name="SUBSC_CTU" title="CancelTime" rel-entity-name="Uom">
<key-map field-name="canclAutmExtTimeUomId" rel-field-name="uomId"/>
</relation>
<relation type="one" fk-name="SUBSC_ATU" title="AvailableTime" rel-entity-name="Uom">
<key-map field-name="availableTimeUomId" rel-field-name="uomId"/>
</relation>
<relation type="one" fk-name="SUBSC_MTU" title="MaxLifeTime" rel-entity-name="Uom">
<key-map field-name="maxLifeTimeUomId" rel-field-name="uomId"/>
</relation>
<relation type="one" fk-name="SUBSC_ROLE_TYPE" rel-entity-name="RoleType">
<key-map field-name="roleTypeId"/>
</relation>
<relation type="one-nofk" rel-entity-name="PartyRole">
<key-map field-name="partyId"/>
<key-map field-name="roleTypeId"/>
</relation>
<relation type="one" fk-name="SUBSC_OPARTY" title="OriginatedFrom" rel-entity-name="Party">
<key-map field-name="originatedFromPartyId" rel-field-name="partyId"/>
</relation>
<relation type="one" fk-name="SUBSC_OROLE_TYPE" title="OriginatedFrom" rel-entity-name="RoleType">
<key-map field-name="originatedFromRoleTypeId" rel-field-name="roleTypeId"/>
</relation>
<relation type="one-nofk" title="OriginatedFrom" rel-entity-name="PartyRole">
<key-map field-name="originatedFromPartyId" rel-field-name="partyId"/>
<key-map field-name="originatedFromRoleTypeId" rel-field-name="roleTypeId"/>
</relation>
<relation type="one-nofk" rel-entity-name="PartyNeed">
<description>No foreign key because we want to optionally be able to have a partyId without the other fields.</description>
<key-map field-name="partyNeedId"/>
<key-map field-name="partyId"/>
<key-map field-name="roleTypeId"/>
</relation>
<relation type="one" fk-name="SUBSC_NEED_TYPE" rel-entity-name="NeedType">
<key-map field-name="needTypeId"/>
</relation>
<relation type="one-nofk" rel-entity-name="OrderHeader">
<description>Note that foreign key not needed because there is an fk for OrderItem.</description>
<key-map field-name="orderId"/>
</relation>
<relation type="one" fk-name="SUBSC_ORDERITM" rel-entity-name="OrderItem">
<key-map field-name="orderId"/>
<key-map field-name="orderItemSeqId"/>
</relation>
<relation type="one" fk-name="SUBSC_PRODUCT" rel-entity-name="Product">
<key-map field-name="productId"/>
</relation>
<relation type="one" fk-name="SUBSC_PROD_CAT" rel-entity-name="ProductCategory">
<key-map field-name="productCategoryId"/>
</relation>
<relation type="one" fk-name="SUBSC_INV_ITM" rel-entity-name="InventoryItem">
<key-map field-name="inventoryItemId"/>
</relation>
<relation type="one" fk-name="SUBSC_TO_TYPE" rel-entity-name="SubscriptionType">
<key-map field-name="subscriptionTypeId"/>
</relation>
<relation type="many" rel-entity-name="SubscriptionTypeAttr">
<key-map field-name="subscriptionTypeId"/>
</relation>
</entity>
<entity entity-name="SubscriptionActivity" package-name="org.ofbiz.product.subscription" title="Subscription Activity Entity">
<field name="subscriptionActivityId" type="id-ne"></field>
<field name="comments" type="comment"></field>
<field name="dateSent" type="date-time"></field>
<prim-key field="subscriptionActivityId"/>
</entity>
<entity entity-name="SubscriptionAttribute" package-name="org.ofbiz.product.subscription" title="Subscription Attribute Entity">
<field name="subscriptionId" type="id-ne"></field>
<field name="attrName" type="id-long-ne"></field>
<field name="attrValue" type="value"></field>
<prim-key field="subscriptionId"/>
<prim-key field="attrName"/>
<relation type="one" fk-name="SUBSC_ATTR" rel-entity-name="Subscription">
<key-map field-name="subscriptionId"/>
</relation>
<relation type="many" rel-entity-name="SubscriptionTypeAttr">
<key-map field-name="attrName"/>
</relation>
</entity>
<entity entity-name="SubscriptionFulfillmentPiece"
package-name="org.ofbiz.product.subscription"
title="Subscription Fulfillment Piece Entity">
<field name="subscriptionActivityId" type="id-ne"></field>
<field name="subscriptionId" type="id-ne"></field>
<prim-key field="subscriptionActivityId"/>
<prim-key field="subscriptionId"/>
<relation type="one" fk-name="SUBSC_FP" rel-entity-name="Subscription">
<key-map field-name="subscriptionId"/>
</relation>
<relation type="one" fk-name="SUBSC_FP_ACT" rel-entity-name="SubscriptionActivity">
<key-map field-name="subscriptionActivityId"/>
</relation>
</entity>
<entity entity-name="SubscriptionResource"
package-name="org.ofbiz.product.subscription"
title="Subscription Resource Entity">
<field name="subscriptionResourceId" type="id-ne"></field>
<field name="parentResourceId" type="id"></field>
<field name="description" type="description"></field>
<field name="contentId" type="id"><description>Optional (use if applicable) ID of a Content record that this would represent a subscription to.</description></field>
<field name="webSiteId" type="id"><description>Optional (use if applicable) ID of a WebSite record that this would represent a subscription to.</description></field>
<prim-key field="subscriptionResourceId"/>
<relation type="one" fk-name="SUBSC_RES_PARENT" title="Parent" rel-entity-name="SubscriptionResource">
<key-map field-name="parentResourceId" rel-field-name="subscriptionResourceId"/>
</relation>
<relation type="one" fk-name="SUBSC_RES_CNTNT" rel-entity-name="Content">
<key-map field-name="contentId"/>
</relation>
<relation type="one" fk-name="SUBSC_RES_WBSITE" rel-entity-name="WebSite">
<key-map field-name="webSiteId"/>
</relation>
</entity>
<entity entity-name="SubscriptionType"
package-name="org.ofbiz.product.subscription"
default-resource-name="ProductEntityLabels"
title="Subscription Type Entity">
<field name="subscriptionTypeId" type="id-ne"></field>
<field name="parentTypeId" type="id"></field>
<field name="hasTable" type="indicator"></field>
<field name="description" type="description"></field>
<prim-key field="subscriptionTypeId"/>
<relation type="one" fk-name="SUBSC_TYPE_PARENT" title="Parent" rel-entity-name="SubscriptionType">
<key-map field-name="parentTypeId" rel-field-name="subscriptionTypeId"/>
</relation>
</entity>
<entity entity-name="SubscriptionTypeAttr"
package-name="org.ofbiz.product.subscription"
title="Subscription Type Attribute Entity">
<field name="subscriptionTypeId" type="id-ne"></field>
<field name="attrName" type="id-long-ne"></field>
<prim-key field="subscriptionTypeId"/>
<prim-key field="attrName"/>
<relation type="one" fk-name="SUBSC_TYPE_ATTR" rel-entity-name="SubscriptionType">
<key-map field-name="subscriptionTypeId"/>
</relation>
<relation type="many" rel-entity-name="SubscriptionAttribute">
<key-map field-name="attrName"/>
</relation>
<relation type="many" rel-entity-name="Subscription">
<key-map field-name="subscriptionTypeId"/>
</relation>
</entity>
<entity entity-name="SubscriptionCommEvent"
package-name="org.ofbiz.product.subscription"
title="Subscription Communication Event Entity">
<field name="subscriptionId" type="id-ne"></field>
<field name="communicationEventId" type="id-ne"></field>
<prim-key field="subscriptionId"/>
<prim-key field="communicationEventId"/>
<relation type="one" fk-name="SUBSC_COM_EVENT" rel-entity-name="CommunicationEvent">
<key-map field-name="communicationEventId"/>
</relation>
<relation type="one" fk-name="SUBSC_SUBSC" rel-entity-name="Subscription">
<key-map field-name="subscriptionId"/>
</relation>
</entity>
<view-entity entity-name="SubscriptionAndCommEvent"
package-name="org.ofbiz.product.subscription"
title="Subscription And Communication Event View Entity">
<member-entity entity-alias="SC" entity-name="SubscriptionCommEvent"/>
<member-entity entity-alias="CE" entity-name="CommunicationEvent"/>
<alias-all entity-alias="SC"/>
<alias-all entity-alias="CE"/>
<view-link entity-alias="SC" rel-entity-alias="CE">
<key-map field-name="communicationEventId"/>
</view-link>
</view-entity>
<!-- ========================================================= -->
<!-- org.ofbiz.product.supplier -->
<!-- ========================================================= -->
<entity entity-name="MarketInterest"
package-name="org.ofbiz.product.supplier"
title="Market Interest Entity">
<field name="productCategoryId" type="id-ne"></field>
<field name="partyClassificationGroupId" type="id-ne"></field>
<field name="fromDate" type="date-time"></field>
<field name="thruDate" type="date-time"></field>
<prim-key field="productCategoryId"/>
<prim-key field="partyClassificationGroupId"/>
<prim-key field="fromDate"/>
<relation type="one" fk-name="MARKET_INT_PCAT" rel-entity-name="ProductCategory">
<key-map field-name="productCategoryId"/>
</relation>
<relation type="one" fk-name="MARKET_INT_PCGRP" rel-entity-name="PartyClassificationGroup">
<key-map field-name="partyClassificationGroupId"/>
</relation>
</entity>
<entity entity-name="ReorderGuideline"
package-name="org.ofbiz.product.supplier"
title="Reorder Guideline Entity">
<field name="reorderGuidelineId" type="id-ne"></field>
<field name="productId" type="id-ne"></field>
<field name="partyId" type="id"></field>
<field name="roleTypeId" type="id"></field>
<field name="facilityId" type="id"></field>
<field name="geoId" type="id"></field>
<field name="fromDate" type="date-time"></field>
<field name="thruDate" type="date-time"></field>
<field name="reorderQuantity" type="fixed-point"></field>
<field name="reorderLevel" type="fixed-point"></field>
<prim-key field="reorderGuidelineId"/>
<relation type="one" fk-name="REORDER_GD_PROD" rel-entity-name="Product">
<key-map field-name="productId"/>
</relation>
<relation type="one" fk-name="REORDER_GD_PARTY" rel-entity-name="Party">
<key-map field-name="partyId"/>
</relation>
<relation type="one" fk-name="REORDER_GD_FAC" rel-entity-name="Facility">
<key-map field-name="facilityId"/>
</relation>
<relation type="one" fk-name="REORDER_GD_GEO" rel-entity-name="Geo">
<key-map field-name="geoId"/>
</relation>
</entity>
<entity entity-name="SupplierPrefOrder"
package-name="org.ofbiz.product.supplier"
title="Preference Type Entity">
<field name="supplierPrefOrderId" type="id-ne"></field>
<field name="description" type="description"></field>
<prim-key field="supplierPrefOrderId"/>
</entity>
<entity entity-name="SupplierProduct"
package-name="org.ofbiz.product.supplier"
title="Supplier Product Entity">
<field name="productId" type="id-ne"></field>
<field name="partyId" type="id-ne"></field>
<field name="availableFromDate" type="date-time"></field>
<field name="availableThruDate" type="date-time"></field>
<field name="supplierPrefOrderId" type="id"></field>
<field name="supplierRatingTypeId" type="id"></field>
<field name="standardLeadTimeDays" type="fixed-point"></field>
<field name="minimumOrderQuantity" type="fixed-point"></field>
<field name="orderQtyIncrements" type="fixed-point"></field>
<field name="unitsIncluded" type="fixed-point"></field>
<field name="quantityUomId" type="id"></field>
<field name="agreementId" type="id"></field>
<field name="agreementItemSeqId" type="id"></field>
<field name="lastPrice" type="currency-precise"></field>
<field name="shippingPrice" type="currency-precise"></field>
<field name="currencyUomId" type="id"></field>
<field name="supplierProductName" type="name"></field>
<field name="supplierProductId" type="id"></field>
<field name="canDropShip" type="indicator"></field>
<!-- field name="supplierCommissionPerc" type="fixed-point"><description>Unused field, better use commission run using agreements in accounting</description></field-->
<field name="comments" type="comment"></field>
<prim-key field="productId"/>
<prim-key field="partyId"/>
<prim-key field="currencyUomId"/>
<prim-key field="minimumOrderQuantity"/>
<prim-key field="availableFromDate"/>
<relation type="one" fk-name="SUPPL_PROD_PROD" rel-entity-name="Product">
<key-map field-name="productId"/>
</relation>
<relation type="one" fk-name="SUPPL_PROD_PARTY" rel-entity-name="Party">
<key-map field-name="partyId"/>
</relation>
<relation type="one" fk-name="SUPPL_PROD_SPORD" rel-entity-name="SupplierPrefOrder">
<key-map field-name="supplierPrefOrderId"/>
</relation>
<relation type="one" fk-name="SUPPL_PROD_SRTPE" rel-entity-name="SupplierRatingType">
<key-map field-name="supplierRatingTypeId"/>
</relation>
<relation type="one" fk-name="SUPPL_PROD_CUOM" title="Currency" rel-entity-name="Uom">
<key-map field-name="currencyUomId" rel-field-name="uomId"/>
</relation>
<relation type="one" fk-name="SUPPL_PROD_QUOM" title="Quantity" rel-entity-name="Uom">
<key-map field-name="quantityUomId" rel-field-name="uomId"/>
</relation>
<relation type="one" fk-name="SUPPL_PROD_AGRIT" rel-entity-name="AgreementItem">
<key-map field-name="agreementId"/>
<key-map field-name="agreementItemSeqId"/>
</relation>
</entity>
<view-entity entity-name="SupplierProductAndProduct"
package-name="org.ofbiz.product.supplier"
title="Supplier-product and product antityview for purchase order entry">
<member-entity entity-alias="SP" entity-name="SupplierProduct"/>
<member-entity entity-alias="PR" entity-name="Product"/>
<alias-all entity-alias="SP"/>
<alias-all entity-alias="PR">
<exclude field="productId"/>
<exclude field="comments"/>
<exclude field="quantityUomId"/>
</alias-all>
<view-link entity-alias="SP" rel-entity-alias="PR">
<key-map field-name="productId"/>
</view-link>
</view-entity>
<entity entity-name="SupplierProductFeature"
package-name="org.ofbiz.product.supplier"
title="Supplier-specific product feature information">
<field name="partyId" type="id-ne"/>
<field name="productFeatureId" type="id-ne"/>
<field name="description" type="name"/>
<field name="uomId" type="id"/>
<field name="idCode" type="id"/>
<prim-key field="partyId"/>
<prim-key field="productFeatureId"/>
<relation rel-entity-name="Party" type="one" fk-name="SUPPL_FEAT_PARTY">
<key-map field-name="partyId"/>
</relation>
<relation rel-entity-name="ProductFeature" type="one" fk-name="SUPPL_FEAT_FEAT">
<key-map field-name="productFeatureId"/>
</relation>
<relation rel-entity-name="Uom" type="one" fk-name="SUPPL_FEAT_UOM">
<key-map field-name="uomId"/>
</relation>
</entity>
<entity entity-name="SupplierRatingType"
package-name="org.ofbiz.product.supplier"
title="Supplier Rating Type Entity">
<field name="supplierRatingTypeId" type="id-ne"></field>
<field name="description" type="description"></field>
<prim-key field="supplierRatingTypeId"/>
</entity>
<entity entity-name="ProductPromoContent"
package-name="org.ofbiz.product.promo"
title="Product Promo Content Entity">
<field name="productPromoId" type="id-ne"/>
<field name="contentId" type="id-ne"/>
<field name="productPromoContentTypeId" type="id-ne"/>
<field name="fromDate" type="date-time"/>
<field name="thruDate" type="date-time"/>
<prim-key field="productPromoId"/>
<prim-key field="contentId"/>
<prim-key field="productPromoContentTypeId"/>
<prim-key field="fromDate"/>
<relation type="one" fk-name="PRODPR_CNT_PROD_PR" rel-entity-name="ProductPromo">
<key-map field-name="productPromoId"/>
</relation>
<relation type="one" fk-name="PRODPR_CNT_CNT" rel-entity-name="Content">
<key-map field-name="contentId"/>
</relation>
<relation type="one" fk-name="PRODPR_CNT_TYPE" rel-entity-name="ProductContentType">
<key-map field-name="productPromoContentTypeId" rel-field-name="productContentTypeId"/>
</relation>
</entity>
<entity entity-name="ProductGroupOrder"
package-name="org.ofbiz.product.product"
title="Product Group Order Entity">
<field name="groupOrderId" type="id-ne"></field>
<field name="productId" type="id-ne"></field>
<field name="fromDate" type="date-time"></field>
<field name="thruDate" type="date-time"></field>
<field name="statusId" type="id-ne"></field>
<field name="reqOrderQty" type="fixed-point"></field>
<field name="soldOrderQty" type="fixed-point"></field>
<field name="jobId" type="id-ne"></field>
<prim-key field="groupOrderId"/>
<relation type="one" fk-name="PROD_GROUP_ORDER" rel-entity-name="Product">
<key-map field-name="productId"/>
</relation>
<relation type="one" fk-name="GROUP_ORDER_STATUS" rel-entity-name="StatusItem">
<key-map field-name="statusId"/>
</relation>
<relation type="one" fk-name="GROUP_ORDER_JOB" rel-entity-name="JobSandbox">
<key-map field-name="jobId"/>
</relation>
</entity>
</entitymodel>
Raw
transformation-output.xml
<ProdCatalog xmlns:ns1="org.ofbiz.product.catalog">
<prodCatalogId type="id-ne"/>
<catalogName type="name"/>
<useQuickAdd type="indicator"/>
<styleSheet type="url"/>
<headerLogo type="url"/>
<contentPathPrefix type="long-varchar"/>
<templatePathPrefix type="long-varchar"/>
<viewAllowPermReqd type="indicator"/>
<purchaseAllowPermReqd type="indicator"/>
</ProdCatalog>
<ProdCatalogCategory xmlns:ns1="org.ofbiz.product.catalog">
<prodCatalogId type="id-ne"/>
<productCategoryId type="id-ne"/>
<prodCatalogCategoryTypeId type="id"/>
<fromDate type="date-time"/>
<thruDate type="date-time"/>
<sequenceNum type="numeric"/>
</ProdCatalogCategory>
<ProdCatalogCategoryType xmlns:ns1="org.ofbiz.product.catalog">
<prodCatalogCategoryTypeId type="id-ne"/>
<parentTypeId type="id"/>
<description type="description"/>
</ProdCatalogCategoryType>
<ProdCatalogInvFacility xmlns:ns1="org.ofbiz.product.catalog">
<prodCatalogId type="id-ne"/>
<facilityId type="id-ne"/>
<fromDate type="date-time"/>
<thruDate type="date-time"/>
<sequenceNum type="numeric"/>
</ProdCatalogInvFacility>
<ProdCatalogRole xmlns:ns1="org.ofbiz.product.catalog">
<partyId type="id-ne"/>
<roleTypeId type="id-ne"/>
<prodCatalogId type="id-ne"/>
<fromDate type="date-time"/>
<thruDate type="date-time"/>
<sequenceNum type="numeric"/>
</ProdCatalogRole>
<ProductCategory xmlns:ns2="org.ofbiz.product.category">
<productCategoryId type="id-ne"/>
<productCategoryTypeId type="id"/>
<primaryParentCategoryId type="id"/>
<categoryName type="name"/>
<description type="description"/>
<longDescription type="very-long"/>
<categoryImageUrl type="url"/>
<linkOneImageUrl type="url"/>
<linkTwoImageUrl type="url"/>
<detailScreen type="long-varchar"/>
<showInSelect type="indicator"/>
</ProductCategory>
<ProductCategoryAttribute xmlns:ns2="org.ofbiz.product.category">
<productCategoryId type="id-ne"/>
<attrName type="id-long-ne"/>
<attrValue type="value"/>
</ProductCategoryAttribute>
<ProductCategoryContent xmlns:ns2="org.ofbiz.product.category">
<productCategoryId type="id-ne"/>
<contentId type="id-ne"/>
<prodCatContentTypeId type="id-ne"/>
<fromDate type="date-time"/>
<thruDate type="date-time"/>
<purchaseFromDate type="date-time"/>
<purchaseThruDate type="date-time"/>
<useCountLimit type="numeric"/>
<useDaysLimit type="fixed-point"/>
</ProductCategoryContent>
<ProductCategoryContentType xmlns:ns2="org.ofbiz.product.category">
<prodCatContentTypeId type="id-ne"/>
<parentTypeId type="id"/>
<hasTable type="indicator"/>
<description type="description"/>
</ProductCategoryContentType>
<ProductCategoryGlAccount xmlns:ns2="org.ofbiz.product.category">
<productCategoryId type="id-ne"/>
<organizationPartyId type="id-ne"/>
<glAccountTypeId type="id-ne"/>
<glAccountId type="id-ne"/>
</ProductCategoryGlAccount>
<ProductCategoryLink xmlns:ns2="org.ofbiz.product.category">
<productCategoryId type="id-ne"/>
<linkSeqId type="id-ne"/>
<fromDate type="date-time"/>
<thruDate type="date-time"/>
<comments type="comment"/>
<sequenceNum type="numeric"/>
<titleText type="description"/>
<detailText type="very-long"/>
<imageUrl type="url"/>
<imageTwoUrl type="url"/>
<linkTypeEnumId type="id"/>
<linkInfo type="long-varchar"/>
<detailSubScreen type="long-varchar"/>
</ProductCategoryLink>
<ProductCategoryMember xmlns:ns2="org.ofbiz.product.category">
<productCategoryId type="id-ne"/>
<productId type="id-ne"/>
<fromDate type="date-time"/>
<thruDate type="date-time"/>
<comments type="comment"/>
<sequenceNum type="numeric"/>
<quantity type="fixed-point"/>
</ProductCategoryMember>
<ProductCategoryRole xmlns:ns2="org.ofbiz.product.category">
<productCategoryId type="id-ne"/>
<partyId type="id-ne"/>
<roleTypeId type="id-ne"/>
<fromDate type="date-time"/>
<thruDate type="date-time"/>
<comments type="comment"/>
</ProductCategoryRole>
<ProductCategoryRollup xmlns:ns2="org.ofbiz.product.category">
<productCategoryId type="id-ne"/>
<parentProductCategoryId type="id-ne"/>
<fromDate type="date-time"/>
<thruDate type="date-time"/>
<sequenceNum type="numeric"/>
</ProductCategoryRollup>
<ProductCategoryType xmlns:ns2="org.ofbiz.product.category">
<productCategoryTypeId type="id-ne"/>
<parentTypeId type="id"/>
<hasTable type="indicator"/>
<description type="description"/>
</ProductCategoryType>
<ProductCategoryTypeAttr xmlns:ns2="org.ofbiz.product.category">
<productCategoryTypeId type="id-ne"/>
<attrName type="id-long-ne"/>
</ProductCategoryTypeAttr>
<ConfigOptionProductOption xmlns:ns3="org.ofbiz.product.config">
<configId type="id-ne"/>
<configItemId type="id-ne"/>
<sequenceNum type="numeric"/>
<configOptionId type="id-ne"/>
<productId type="id-ne"/>
<productOptionId type="id-ne"/>
<description type="description"/>
</ConfigOptionProductOption>
<ProdConfItemContent xmlns:ns3="org.ofbiz.product.config">
<configItemId type="id-ne"/>
<contentId type="id-ne"/>
<confItemContentTypeId type="id-ne"/>
<fromDate type="date-time"/>
<thruDate type="date-time"/>
</ProdConfItemContent>
<ProdConfItemContentType xmlns:ns3="org.ofbiz.product.config">
<confItemContentTypeId type="id-ne"/>
<parentTypeId type="id"/>
<hasTable type="indicator"/>
<description type="description"/>
</ProdConfItemContentType>
<ProductConfig xmlns:ns3="org.ofbiz.product.config">
<productId type="id-ne"/>
<configItemId type="id-ne"/>
<sequenceNum type="numeric"/>
<fromDate type="date-time"/>
<description type="description"/>
<longDescription type="very-long"/>
<configTypeId type="id"/>
<defaultConfigOptionId type="id"/>
<thruDate type="date-time"/>
<isMandatory type="indicator"/>
</ProductConfig>
<ProductConfigConfig xmlns:ns3="org.ofbiz.product.config">
<configId type="id-ne"/>
<configItemId type="id-ne"/>
<sequenceNum type="numeric"/>
<configOptionId type="id-ne"/>
<description type="description"/>
</ProductConfigConfig>
<ProductConfigItem xmlns:ns3="org.ofbiz.product.config">
<configItemId type="id-ne"/>
<configItemTypeId type="id"/>
<configItemName type="name"/>
<description type="description"/>
<longDescription type="very-long"/>
<imageUrl type="url"/>
</ProductConfigItem>
<ProductConfigOption xmlns:ns3="org.ofbiz.product.config">
<configItemId type="id-ne"/>
<configOptionId type="id-ne"/>
<configOptionName type="name"/>
<description type="description"/>
<sequenceNum type="numeric"/>
</ProductConfigOption>
<ProductConfigOptionIactn xmlns:ns3="org.ofbiz.product.config">
<configItemId type="id-ne"/>
<configOptionId type="id-ne"/>
<configItemIdTo type="id-ne"/>
<configOptionIdTo type="id-ne"/>
<sequenceNum type="numeric"/>
<configIactnTypeId type="id"/>
<description type="description"/>
</ProductConfigOptionIactn>
<ProductConfigProduct xmlns:ns3="org.ofbiz.product.config">
<configItemId type="id-ne"/>
<configOptionId type="id-ne"/>
<productId type="id-ne"/>
<quantity type="fixed-point"/>
<sequenceNum type="numeric"/>
</ProductConfigProduct>
<ProductConfigStats xmlns:ns3="org.ofbiz.product.config">
<configId type="id-ne"/>
<productId type="id-ne"/>
<numOfConfs type="numeric"/>
<configTypeId type="id"/>
</ProductConfigStats>
<CostComponent xmlns:ns4="org.ofbiz.product.cost">
<costComponentId type="id-ne"/>
<costComponentTypeId type="id"/>
<productId type="id"/>
<productFeatureId type="id"/>
<partyId type="id"/>
<geoId type="id"/>
<workEffortId type="id"/>
<fixedAssetId type="id"/>
<costComponentCalcId type="id"/>
<fromDate type="date-time"/>
<thruDate type="date-time"/>
<cost type="fixed-point"/>
<costUomId type="id"/>
</CostComponent>
<CostComponentAttribute xmlns:ns4="org.ofbiz.product.cost">
<costComponentId type="id-ne"/>
<attrName type="id-long-ne"/>
<attrValue type="value"/>
</CostComponentAttribute>
<CostComponentCalc xmlns:ns4="org.ofbiz.product.cost">
<costComponentCalcId type="id-ne"/>
<description type="description"/>
<costGlAccountTypeId type="id"/>
<offsettingGlAccountTypeId type="id"/>
<fixedCost type="currency-amount"/>
<variableCost type="currency-amount"/>
<perMilliSecond type="numeric"/>
<currencyUomId type="id"/>
<costCustomMethodId type="id"/>
</CostComponentCalc>
<CostComponentType xmlns:ns4="org.ofbiz.product.cost">
<costComponentTypeId type="id-ne"/>
<parentTypeId type="id-ne"/>
<hasTable type="indicator"/>
<description type="description"/>
</CostComponentType>
<CostComponentTypeAttr xmlns:ns4="org.ofbiz.product.cost">
<costComponentTypeId type="id-ne"/>
<attrName type="id-long-ne"/>
</CostComponentTypeAttr>
<ProductCostComponentCalc xmlns:ns4="org.ofbiz.product.cost">
<productId type="id-ne"/>
<costComponentTypeId type="id-ne"/>
<costComponentCalcId type="id-ne"/>
<fromDate type="date-time"/>
<sequenceNum type="numeric"/>
<thruDate type="date-time"/>
</ProductCostComponentCalc>
<Container xmlns:ns5="org.ofbiz.product.facility">
<containerId type="id-ne"/>
<containerTypeId type="id"/>
<facilityId type="id"/>
<description type="description"/>
</Container>
<ContainerGeoPoint xmlns:ns5="org.ofbiz.product.facility">
<containerId type="id-ne"/>
<geoPointId type="id-ne"/>
<fromDate type="date-time"/>
<thruDate type="date-time"/>
</ContainerGeoPoint>
<ContainerType xmlns:ns5="org.ofbiz.product.facility">
<containerTypeId type="id-ne"/>
<description type="description"/>
</ContainerType>
<Facility xmlns:ns5="org.ofbiz.product.facility">
<facilityId type="id-ne"/>
<facilityTypeId type="id"/>
<parentFacilityId type="id"/>
<ownerPartyId type="id-ne"/>
<defaultInventoryItemTypeId type="id"/>
<facilityName type="name"/>
<primaryFacilityGroupId type="id"/>
<oldSquareFootage type="numeric"/>
<facilitySize type="fixed-point"/>
<facilitySizeUomId type="id"/>
<productStoreId type="id"/>
<defaultDaysToShip type="numeric"/>
<openedDate type="date-time"/>
<closedDate type="date-time"/>
<description type="description"/>
<defaultDimensionUomId type="id"/>
<defaultWeightUomId type="id"/>
<geoPointId type="id"/>
</Facility>
<FacilityAttribute xmlns:ns5="org.ofbiz.product.facility">
<facilityId type="id-ne"/>
<attrName type="id-long-ne"/>
<attrValue type="value"/>
</FacilityAttribute>
<FacilityCarrierShipment xmlns:ns5="org.ofbiz.product.facility">
<facilityId type="id-ne"/>
<partyId type="id-ne"/>
<roleTypeId type="id-ne"/>
<shipmentMethodTypeId type="id-ne"/>
</FacilityCarrierShipment>
<FacilityContactMech xmlns:ns5="org.ofbiz.product.facility">
<facilityId type="id-ne"/>
<contactMechId type="id-ne"/>
<fromDate type="date-time"/>
<thruDate type="date-time"/>
<extension type="very-short"/>
<comments type="comment"/>
</FacilityContactMech>
<FacilityContactMechPurpose xmlns:ns5="org.ofbiz.product.facility">
<facilityId type="id-ne"/>
<contactMechId type="id-ne"/>
<contactMechPurposeTypeId type="id-ne"/>
<fromDate type="date-time"/>
<thruDate type="date-time"/>
</FacilityContactMechPurpose>
<FacilityContent xmlns:ns5="org.ofbiz.product.facility">
<facilityId type="id-ne"/>
<contentId type="id-ne"/>
<fromDate type="date-time"/>
<thruDate type="date-time"/>
</FacilityContent>
<FacilityGroup xmlns:ns5="org.ofbiz.product.facility">
<facilityGroupId type="id-ne"/>
<facilityGroupTypeId type="id"/>
<primaryParentGroupId type="id"/>
<facilityGroupName type="name"/>
<description type="description"/>
</FacilityGroup>
<FacilityGroupMember xmlns:ns5="org.ofbiz.product.facility">
<facilityId type="id-ne"/>
<facilityGroupId type="id-ne"/>
<fromDate type="date-time"/>
<thruDate type="date-time"/>
<sequenceNum type="numeric"/>
</FacilityGroupMember>
<FacilityGroupRole xmlns:ns5="org.ofbiz.product.facility">
<facilityGroupId type="id-ne"/>
<partyId type="id"/>
<roleTypeId type="id"/>
</FacilityGroupRole>
<FacilityGroupRollup xmlns:ns5="org.ofbiz.product.facility">
<facilityGroupId type="id-ne"/>
<parentFacilityGroupId type="id-ne"/>
<fromDate type="date-time"/>
<thruDate type="date-time"/>
<sequenceNum type="numeric"/>
</FacilityGroupRollup>
<FacilityGroupType xmlns:ns5="org.ofbiz.product.facility">
<facilityGroupTypeId type="id-ne"/>
<description type="description"/>
</FacilityGroupType>
<FacilityLocation xmlns:ns5="org.ofbiz.product.facility">
<facilityId type="id-ne"/>
<locationSeqId type="id-ne"/>
<locationTypeEnumId type="id-ne"/>
<areaId type="id"/>
<aisleId type="id"/>
<sectionId type="id"/>
<levelId type="id"/>
<positionId type="id"/>
</FacilityLocation>
<FacilityLocationGeoPoint xmlns:ns5="org.ofbiz.product.facility">
<facilityId type="id-ne"/>
<locationSeqId type="id-ne"/>
<geoPointId type="id-ne"/>
<fromDate type="date-time"/>
<thruDate type="date-time"/>
</FacilityLocationGeoPoint>
<FacilityParty xmlns:ns5="org.ofbiz.product.facility">
<facilityId type="id"/>
<partyId type="id"/>
<roleTypeId type="id"/>
<fromDate type="date-time"/>
<thruDate type="date-time"/>
</FacilityParty>
<FacilityType xmlns:ns5="org.ofbiz.product.facility">
<facilityTypeId type="id-ne"/>
<parentTypeId type="id-ne"/>
<hasTable type="indicator"/>
<description type="description"/>
</FacilityType>
<FacilityTypeAttr xmlns:ns5="org.ofbiz.product.facility">
<facilityTypeId type="id-ne"/>
<attrName type="id-long-ne"/>
</FacilityTypeAttr>
<ProductFacility xmlns:ns5="org.ofbiz.product.facility">
<productId type="id-ne"/>
<facilityId type="id-ne"/>
<minimumStock type="fixed-point"/>
<reorderQuantity type="fixed-point"/>
<daysToShip type="numeric"/>
<lastInventoryCount type="fixed-point"/>
</ProductFacility>
<ProductFacilityLocation xmlns:ns5="org.ofbiz.product.facility">
<productId type="id-ne"/>
<facilityId type="id-ne"/>
<locationSeqId type="id-ne"/>
<minimumStock type="fixed-point"/>
<moveQuantity type="fixed-point"/>
</ProductFacilityLocation>
<ProductFeature xmlns:ns6="org.ofbiz.product.feature">
<productFeatureId type="id-ne"/>
<productFeatureTypeId type="id-ne"/>
<productFeatureCategoryId type="id"/>
<description type="description"/>
<uomId type="id"/>
<numberSpecified type="fixed-point"/>
<defaultAmount type="currency-amount"/>
<defaultSequenceNum type="numeric"/>
<abbrev type="id"/>
<idCode type="id-long"/>
</ProductFeature>
<ProductFeatureAppl xmlns:ns6="org.ofbiz.product.feature">
<productId type="id-ne"/>
<productFeatureId type="id-ne"/>
<productFeatureApplTypeId type="id"/>
<fromDate type="date-time"/>
<thruDate type="date-time"/>
<sequenceNum type="numeric"/>
<amount type="currency-amount"/>
<recurringAmount type="currency-amount"/>
</ProductFeatureAppl>
<ProductFeatureApplAttr xmlns:ns6="org.ofbiz.product.feature">
<productId type="id-ne"/>
<productFeatureId type="id-ne"/>
<fromDate type="date-time"/>
<attrName type="id-long-ne"/>
<attrValue type="value"/>
</ProductFeatureApplAttr>
<ProductFeatureApplType xmlns:ns6="org.ofbiz.product.feature">
<productFeatureApplTypeId type="id-ne"/>
<parentTypeId type="id"/>
<hasTable type="indicator"/>
<description type="description"/>
</ProductFeatureApplType>
<ProductFeatureCatGrpAppl xmlns:ns6="org.ofbiz.product.feature">
<productCategoryId type="id-ne"/>
<productFeatureGroupId type="id-ne"/>
<fromDate type="date-time"/>
<thruDate type="date-time"/>
</ProductFeatureCatGrpAppl>
<ProductFeatureCategory xmlns:ns6="org.ofbiz.product.feature">
<productFeatureCategoryId type="id-ne"/>
<parentCategoryId type="id"/>
<description type="description"/>
</ProductFeatureCategory>
<ProductFeatureCategoryAppl xmlns:ns6="org.ofbiz.product.feature">
<productCategoryId type="id-ne"/>
<productFeatureCategoryId type="id-ne"/>
<fromDate type="date-time"/>
<thruDate type="date-time"/>
</ProductFeatureCategoryAppl>
<ProductFeatureDataResource xmlns:ns6="org.ofbiz.product.feature">
<dataResourceId type="id-ne"/>
<productFeatureId type="id-ne"/>
</ProductFeatureDataResource>
<ProductFeatureGroup xmlns:ns6="org.ofbiz.product.feature">
<productFeatureGroupId type="id-ne"/>
<description type="description"/>
</ProductFeatureGroup>
<ProductFeatureGroupAppl xmlns:ns6="org.ofbiz.product.feature">
<productFeatureGroupId type="id-ne"/>
<productFeatureId type="id-ne"/>
<fromDate type="date-time"/>
<thruDate type="date-time"/>
<sequenceNum type="numeric"/>
</ProductFeatureGroupAppl>
<ProductFeatureIactn xmlns:ns6="org.ofbiz.product.feature">
<productFeatureId type="id-ne"/>
<productFeatureIdTo type="id-ne"/>
<productFeatureIactnTypeId type="id"/>
<productId type="id"/>
</ProductFeatureIactn>
<ProductFeatureIactnType xmlns:ns6="org.ofbiz.product.feature">
<productFeatureIactnTypeId type="id-ne"/>
<parentTypeId type="id"/>
<hasTable type="indicator"/>
<description type="description"/>
</ProductFeatureIactnType>
<ProductFeatureType xmlns:ns6="org.ofbiz.product.feature">
<productFeatureTypeId type="id-ne"/>
<parentTypeId type="id"/>
<hasTable type="indicator"/>
<description type="description"/>
</ProductFeatureType>
<InventoryItem xmlns:ns8="org.ofbiz.product.inventory">
<inventoryItemId type="id-ne"/>
<inventoryItemTypeId type="id"/>
<productId type="id"/>
<partyId type="id"/>
<ownerPartyId type="id"/>
<statusId type="id"/>
<datetimeReceived type="date-time"/>
<datetimeManufactured type="date-time"/>
<expireDate type="date-time"/>
<facilityId type="id"/>
<containerId type="id"/>
<lotId type="id"/>
<uomId type="id"/>
<binNumber type="id"/>
<locationSeqId type="id"/>
<comments type="comment"/>
<quantityOnHandTotal type="fixed-point"/>
<availableToPromiseTotal type="fixed-point"/>
<accountingQuantityTotal type="fixed-point"/>
<oldQuantityOnHand type="fixed-point"/>
<oldAvailableToPromise type="fixed-point"/>
<serialNumber type="value"/>
<softIdentifier type="value"/>
<activationNumber type="value"/>
<activationValidThru type="date-time"/>
<unitCost type="fixed-point"/>
<currencyUomId type="id"/>
</InventoryItem>
<InventoryItemAttribute xmlns:ns8="org.ofbiz.product.inventory">
<inventoryItemId type="id-ne"/>
<attrName type="id-long-ne"/>
<attrValue type="value"/>
</InventoryItemAttribute>
<InventoryItemDetail xmlns:ns8="org.ofbiz.product.inventory">
<inventoryItemId type="id-ne"/>
<inventoryItemDetailSeqId type="id-ne"/>
<effectiveDate type="date-time"/>
<quantityOnHandDiff type="fixed-point"/>
<availableToPromiseDiff type="fixed-point"/>
<accountingQuantityDiff type="fixed-point"/>
<unitCost type="fixed-point"/>
<orderId type="id"/>
<orderItemSeqId type="id"/>
<shipGroupSeqId type="id"/>
<shipmentId type="id"/>
<shipmentItemSeqId type="id"/>
<returnId type="id"/>
<returnItemSeqId type="id"/>
<workEffortId type="id"/>
<fixedAssetId type="id"/>
<maintHistSeqId type="id"/>
<itemIssuanceId type="id"/>
<receiptId type="id"/>
<physicalInventoryId type="id"/>
<reasonEnumId type="id"/>
<description type="description"/>
</InventoryItemDetail>
<InventoryItemLabel xmlns:ns8="org.ofbiz.product.inventory">
<inventoryItemLabelId type="id-ne"/>
<inventoryItemLabelTypeId type="id-ne"/>
<description type="description"/>
</InventoryItemLabel>
<InventoryItemLabelAppl xmlns:ns8="org.ofbiz.product.inventory">
<inventoryItemId type="id-ne"/>
<inventoryItemLabelTypeId type="id-ne"/>
<inventoryItemLabelId type="id-ne"/>
<sequenceNum type="numeric"/>
</InventoryItemLabelAppl>
<InventoryItemLabelType xmlns:ns8="org.ofbiz.product.inventory">
<inventoryItemLabelTypeId type="id-ne"/>
<parentTypeId type="id"/>
<hasTable type="indicator"/>
<description type="description"/>
</InventoryItemLabelType>
<InventoryItemStatus xmlns:ns8="org.ofbiz.product.inventory">
<inventoryItemId type="id-ne"/>
<statusId type="id-ne"/>
<statusDatetime type="date-time"/>
<statusEndDatetime type="date-time"/>
<ownerPartyId type="id"/>
<productId type="id"/>
</InventoryItemStatus>
<InventoryItemTempRes xmlns:ns8="org.ofbiz.product.inventory">
<visitId type="id-ne"/>
<productId type="id-ne"/>
<productStoreId type="id-ne"/>
<quantity type="fixed-point"/>
<reservedDate type="date-time"/>
</InventoryItemTempRes>
<InventoryItemType xmlns:ns8="org.ofbiz.product.inventory">
<inventoryItemTypeId type="id-ne"/>
<parentTypeId type="id-ne"/>
<hasTable type="indicator"/>
<description type="description"/>
</InventoryItemType>
<InventoryItemTypeAttr xmlns:ns8="org.ofbiz.product.inventory">
<inventoryItemTypeId type="id-ne"/>
<attrName type="id-long-ne"/>
</InventoryItemTypeAttr>
<InventoryItemVariance xmlns:ns8="org.ofbiz.product.inventory">
<inventoryItemId type="id-ne"/>
<physicalInventoryId type="id-ne"/>
<varianceReasonId type="id"/>
<availableToPromiseVar type="fixed-point"/>
<quantityOnHandVar type="fixed-point"/>
<comments type="comment"/>
</InventoryItemVariance>
<InventoryTransfer xmlns:ns8="org.ofbiz.product.inventory">
<inventoryTransferId type="id-ne"/>
<statusId type="id-ne"/>
<inventoryItemId type="id-ne"/>
<facilityId type="id"/>
<locationSeqId type="id"/>
<containerId type="id"/>
<facilityIdTo type="id"/>
<locationSeqIdTo type="id"/>
<containerIdTo type="id"/>
<itemIssuanceId type="id"/>
<sendDate type="date-time"/>
<receiveDate type="date-time"/>
<comments type="comment"/>
</InventoryTransfer>
<Lot xmlns:ns8="org.ofbiz.product.inventory">
<lotId type="id-ne"/>
<creationDate type="date-time"/>
<quantity type="fixed-point"/>
<expirationDate type="date-time"/>
</Lot>
<PhysicalInventory xmlns:ns8="org.ofbiz.product.inventory">
<physicalInventoryId type="id-ne"/>
<physicalInventoryDate type="date-time"/>
<partyId type="id"/>
<generalComments type="comment"/>
</PhysicalInventory>
<VarianceReason xmlns:ns8="org.ofbiz.product.inventory">
<varianceReasonId type="id-ne"/>
<description type="description"/>
</VarianceReason>
<ProductFeaturePrice xmlns:ns7="org.ofbiz.product.price">
<productFeatureId type="id-ne"/>
<productPriceTypeId type="id-ne"/>
<currencyUomId type="id"/>
<fromDate type="date-time"/>
<thruDate type="date-time"/>
<price type="currency-precise"/>
<createdDate type="date-time"/>
<createdByUserLogin type="id-vlong"/>
<lastModifiedDate type="date-time"/>
<lastModifiedByUserLogin type="id-vlong"/>
</ProductFeaturePrice>
<ProductPaymentMethodType xmlns:ns7="org.ofbiz.product.price">
<productId type="id-ne"/>
<paymentMethodTypeId type="id-ne"/>
<productPricePurposeId type="id-ne"/>
<fromDate type="date-time"/>
<thruDate type="date-time"/>
<sequenceNum type="numeric"/>
</ProductPaymentMethodType>
<ProductPrice xmlns:ns7="org.ofbiz.product.price">
<productId type="id-ne"/>
<productPriceTypeId type="id-ne"/>
<productPricePurposeId type="id-ne"/>
<currencyUomId type="id"/>
<productStoreGroupId type="id"/>
<fromDate type="date-time"/>
<thruDate type="date-time"/>
<price type="currency-precise"/>
<termUomId type="id"/>
<customPriceCalcService type="id"/>
<priceWithoutTax type="currency-precise"/>
<priceWithTax type="currency-precise"/>
<taxAmount type="currency-precise"/>
<taxPercentage type="fixed-point"/>
<taxAuthPartyId type="id-ne"/>
<taxAuthGeoId type="id-ne"/>
<taxInPrice type="indicator"/>
<createdDate type="date-time"/>
<createdByUserLogin type="id-vlong"/>
<lastModifiedDate type="date-time"/>
<lastModifiedByUserLogin type="id-vlong"/>
</ProductPrice>
<ProductPriceAction xmlns:ns7="org.ofbiz.product.price">
<productPriceRuleId type="id-ne"/>
<productPriceActionSeqId type="id-ne"/>
<productPriceActionTypeId type="id-ne"/>
<amount type="fixed-point"/>
<rateCode type="short-varchar"/>
</ProductPriceAction>
<ProductPriceActionType xmlns:ns7="org.ofbiz.product.price">
<productPriceActionTypeId type="id-ne"/>
<description type="description"/>
</ProductPriceActionType>
<ProductPriceAutoNotice xmlns:ns7="org.ofbiz.product.price">
<productPriceNoticeId type="id-ne"/>
<facilityId type="id"/>
<runDate type="date-time"/>
<fromDate type="date-time"/>
<thruDate type="date-time"/>
</ProductPriceAutoNotice>
<ProductPriceChange xmlns:ns7="org.ofbiz.product.price">
<productPriceChangeId type="id-ne"/>
<productId type="id-ne"/>
<productPriceTypeId type="id-ne"/>
<productPricePurposeId type="id-ne"/>
<currencyUomId type="id"/>
<productStoreGroupId type="id"/>
<fromDate type="date-time"/>
<thruDate type="date-time"/>
<price type="currency-amount"/>
<oldPrice type="currency-amount"/>
<changedDate type="date-time"/>
<changedByUserLogin type="id-vlong"/>
</ProductPriceChange>
<ProductPriceCond xmlns:ns7="org.ofbiz.product.price">
<productPriceRuleId type="id-ne"/>
<productPriceCondSeqId type="id-ne"/>
<inputParamEnumId type="id"/>
<operatorEnumId type="id"/>
<condValue type="long-varchar"/>
</ProductPriceCond>
<ProductPricePurpose xmlns:ns7="org.ofbiz.product.price">
<productPricePurposeId type="id-ne"/>
<description type="description"/>
</ProductPricePurpose>
<ProductPriceRule xmlns:ns7="org.ofbiz.product.price">
<productPriceRuleId type="id-ne"/>
<ruleName type="name"/>
<description type="description"/>
<isSale type="indicator"/>
<fromDate type="date-time"/>
<thruDate type="date-time"/>
</ProductPriceRule>
<ProductPriceType xmlns:ns7="org.ofbiz.product.price">
<productPriceTypeId type="id-ne"/>
<description type="description"/>
</ProductPriceType>
<QuantityBreak xmlns:ns7="org.ofbiz.product.price">
<quantityBreakId type="id-ne"/>
<quantityBreakTypeId type="id"/>
<fromQuantity type="fixed-point"/>
<thruQuantity type="fixed-point"/>
</QuantityBreak>
<QuantityBreakType xmlns:ns7="org.ofbiz.product.price">
<quantityBreakTypeId type="id-ne"/>
<description type="description"/>
</QuantityBreakType>
<SaleType xmlns:ns7="org.ofbiz.product.price">
<saleTypeId type="id-ne"/>
<description type="description"/>
</SaleType>
<GoodIdentification xmlns:ns9="org.ofbiz.product.product">
<goodIdentificationTypeId type="id-ne"/>
<productId type="id-ne"/>
<idValue type="id-long"/>
</GoodIdentification>
<GoodIdentificationType xmlns:ns9="org.ofbiz.product.product">
<goodIdentificationTypeId type="id-ne"/>
<parentTypeId type="id"/>
<hasTable type="indicator"/>
<description type="description"/>
</GoodIdentificationType>
<Product xmlns:ns9="org.ofbiz.product.product">
<productId type="id-ne"/>
<productTypeId type="id"/>
<primaryProductCategoryId type="id"/>
<manufacturerPartyId type="id"/>
<facilityId type="id"/>
<introductionDate type="date-time"/>
<releaseDate type="date-time"/>
<supportDiscontinuationDate type="date-time"/>
<salesDiscontinuationDate type="date-time"/>
<salesDiscWhenNotAvail type="indicator"/>
<internalName type="description"/>
<brandName type="name"/>
<comments type="comment"/>
<productName type="name"/>
<description type="description"/>
<longDescription type="very-long"/>
<priceDetailText type="description"/>
<smallImageUrl type="url"/>
<mediumImageUrl type="url"/>
<largeImageUrl type="url"/>
<detailImageUrl type="url"/>
<originalImageUrl type="url"/>
<detailScreen type="long-varchar"/>
<inventoryMessage type="description"/>
<requireInventory type="indicator"/>
<quantityUomId type="id"/>
<quantityIncluded type="fixed-point"/>
<piecesIncluded type="numeric"/>
<requireAmount type="indicator"/>
<fixedAmount type="currency-amount"/>
<amountUomTypeId type="id"/>
<weightUomId type="id"/>
<weight type="fixed-point"/>
<productWeight type="fixed-point"/>
<heightUomId type="id"/>
<productHeight type="fixed-point"/>
<shippingHeight type="fixed-point"/>
<widthUomId type="id"/>
<productWidth type="fixed-point"/>
<shippingWidth type="fixed-point"/>
<depthUomId type="id"/>
<productDepth type="fixed-point"/>
<shippingDepth type="fixed-point"/>
<diameterUomId type="id"/>
<productDiameter type="fixed-point"/>
<productRating type="fixed-point"/>
<ratingTypeEnum type="id"/>
<returnable type="indicator"/>
<taxable type="indicator"/>
<chargeShipping type="indicator"/>
<autoCreateKeywords type="indicator"/>
<includeInPromotions type="indicator"/>
<isVirtual type="indicator"/>
<isVariant type="indicator"/>
<virtualVariantMethodEnum type="id"/>
<originGeoId type="id"/>
<requirementMethodEnumId type="id"/>
<billOfMaterialLevel type="numeric"/>
<reservMaxPersons type="fixed-point"/>
<reserv2ndPPPerc type="fixed-point"/>
<reservNthPPPerc type="fixed-point"/>
<configId type="id"/>
<createdDate type="date-time"/>
<createdByUserLogin type="id-vlong"/>
<lastModifiedDate type="date-time"/>
<lastModifiedByUserLogin type="id-vlong"/>
<inShippingBox type="indicator"/>
<defaultShipmentBoxTypeId type="id"/>
<lotIdFilledIn type="long-varchar"/>
<orderDecimalQuantity type="indicator"/>
</Product>
<ProductAssoc xmlns:ns9="org.ofbiz.product.product">
<productId type="id-ne"/>
<productIdTo type="id-ne"/>
<productAssocTypeId type="id-ne"/>
<fromDate type="date-time"/>
<thruDate type="date-time"/>
<sequenceNum type="numeric"/>
<reason type="long-varchar"/>
<quantity type="fixed-point"/>
<scrapFactor type="fixed-point"/>
<instruction type="long-varchar"/>
<routingWorkEffortId type="id"/>
<estimateCalcMethod type="id"/>
<recurrenceInfoId type="id"/>
</ProductAssoc>
<ProductAssocType xmlns:ns9="org.ofbiz.product.product">
<productAssocTypeId type="id-ne"/>
<parentTypeId type="id"/>
<hasTable type="indicator"/>
<description type="description"/>
</ProductAssocType>
<ProductAttribute xmlns:ns9="org.ofbiz.product.product">
<productId type="id-ne"/>
<attrName type="id-long-ne"/>
<attrValue type="value"/>
<attrType type="value"/>
</ProductAttribute>
<ProductCalculatedInfo xmlns:ns9="org.ofbiz.product.product">
<productId type="id-ne"/>
<totalQuantityOrdered type="fixed-point"/>
<totalTimesViewed type="numeric"/>
<averageCustomerRating type="fixed-point"/>
</ProductCalculatedInfo>
<ProductContent xmlns:ns9="org.ofbiz.product.product">
<productId type="id-ne"/>
<contentId type="id-ne"/>
<productContentTypeId type="id-ne"/>
<fromDate type="date-time"/>
<thruDate type="date-time"/>
<purchaseFromDate type="date-time"/>
<purchaseThruDate type="date-time"/>
<useCountLimit type="numeric"/>
<useTime type="numeric"/>
<useTimeUomId type="id"/>
<useRoleTypeId type="id"/>
<sequenceNum type="numeric"/>
</ProductContent>
<ProductContentType xmlns:ns9="org.ofbiz.product.product">
<productContentTypeId type="id-ne"/>
<parentTypeId type="id"/>
<hasTable type="indicator"/>
<description type="description"/>
</ProductContentType>
<ProductGeo xmlns:ns9="org.ofbiz.product.product">
<productId type="id-ne"/>
<geoId type="id"/>
<productGeoEnumId type="id"/>
<description type="description"/>
</ProductGeo>
<ProductGlAccount xmlns:ns9="org.ofbiz.product.product">
<productId type="id-ne"/>
<organizationPartyId type="id-ne"/>
<glAccountTypeId type="id-ne"/>
<glAccountId type="id-ne"/>
</ProductGlAccount>
<ProductGroupOrder xmlns:ns9="org.ofbiz.product.product">
<groupOrderId type="id-ne"/>
<productId type="id-ne"/>
<fromDate type="date-time"/>
<thruDate type="date-time"/>
<statusId type="id-ne"/>
<reqOrderQty type="fixed-point"/>
<soldOrderQty type="fixed-point"/>
<jobId type="id-ne"/>
</ProductGroupOrder>
<ProductKeyword xmlns:ns9="org.ofbiz.product.product">
<productId type="id-ne"/>
<keyword type="short-varchar"/>
<keywordTypeId type="id-ne"/>
<relevancyWeight type="numeric"/>
<statusId type="id-ne"/>
</ProductKeyword>
<ProductMaint xmlns:ns9="org.ofbiz.product.product">
<productId type="id-ne"/>
<productMaintSeqId type="id-ne"/>
<productMaintTypeId type="id"/>
<maintName type="name"/>
<maintTemplateWorkEffortId type="id"/>
<intervalQuantity type="fixed-point"/>
<intervalUomId type="id"/>
<intervalMeterTypeId type="id"/>
<repeatCount type="numeric"/>
</ProductMaint>
<ProductMaintType xmlns:ns9="org.ofbiz.product.product">
<productMaintTypeId type="id-ne"/>
<description type="description"/>
<parentTypeId type="id"/>
</ProductMaintType>
<ProductMeter xmlns:ns9="org.ofbiz.product.product">
<productId type="id-ne"/>
<productMeterTypeId type="id-ne"/>
<meterUomId type="id"/>
<meterName type="name"/>
</ProductMeter>
<ProductMeterType xmlns:ns9="org.ofbiz.product.product">
<productMeterTypeId type="id-ne"/>
<description type="description"/>
<defaultUomId type="id"/>
</ProductMeterType>
<ProductReview xmlns:ns9="org.ofbiz.product.product">
<productReviewId type="id-ne"/>
<productStoreId type="id-ne"/>
<productId type="id-ne"/>
<userLoginId type="id-vlong-ne"/>
<statusId type="id"/>
<postedAnonymous type="indicator"/>
<postedDateTime type="date-time"/>
<productRating type="fixed-point"/>
<productReview type="very-long"/>
</ProductReview>
<ProductRole xmlns:ns9="org.ofbiz.product.product">
<productId type="id-ne"/>
<partyId type="id-ne"/>
<roleTypeId type="id-ne"/>
<fromDate type="date-time"/>
<thruDate type="date-time"/>
<sequenceNum type="numeric"/>
<comments type="comment"/>
</ProductRole>
<ProductSearchConstraint xmlns:ns9="org.ofbiz.product.product">
<productSearchResultId type="id-ne"/>
<constraintSeqId type="id-ne"/>
<constraintName type="long-varchar"/>
<infoString type="long-varchar"/>
<includeSubCategories type="indicator"/>
<isAnd type="indicator"/>
<anyPrefix type="indicator"/>
<anySuffix type="indicator"/>
<removeStems type="indicator"/>
<lowValue type="short-varchar"/>
<highValue type="short-varchar"/>
</ProductSearchConstraint>
<ProductSearchResult xmlns:ns9="org.ofbiz.product.product">
<productSearchResultId type="id-ne"/>
<visitId type="id"/>
<orderByName type="long-varchar"/>
<isAscending type="indicator"/>
<numResults type="numeric"/>
<secondsTotal type="floating-point"/>
<searchDate type="date-time"/>
</ProductSearchResult>
<ProductType xmlns:ns9="org.ofbiz.product.product">
<productTypeId type="id-ne"/>
<parentTypeId type="id"/>
<isPhysical type="indicator"/>
<isDigital type="indicator"/>
<hasTable type="indicator"/>
<description type="description"/>
</ProductType>
<ProductTypeAttr xmlns:ns9="org.ofbiz.product.product">
<productTypeId type="id-ne"/>
<attrName type="id-long-ne"/>
</ProductTypeAttr>
<VendorProduct xmlns:ns9="org.ofbiz.product.product">
<productId type="id-ne"/>
<vendorPartyId type="id-ne"/>
<productStoreGroupId type="id-ne"/>
</VendorProduct>
<ProductPromo xmlns:ns10="org.ofbiz.product.promo">
<productPromoId type="id-ne"/>
<promoName type="name"/>
<promoText type="description"/>
<userEntered type="indicator"/>
<showToCustomer type="indicator"/>
<requireCode type="indicator"/>
<useLimitPerOrder type="numeric"/>
<useLimitPerCustomer type="numeric"/>
<useLimitPerPromotion type="numeric"/>
<billbackFactor type="fixed-point"/>
<overrideOrgPartyId type="id"/>
<createdDate type="date-time"/>
<createdByUserLogin type="id-vlong"/>
<lastModifiedDate type="date-time"/>
<lastModifiedByUserLogin type="id-vlong"/>
</ProductPromo>
<ProductPromoAction xmlns:ns10="org.ofbiz.product.promo">
<productPromoId type="id-ne"/>
<productPromoRuleId type="id-ne"/>
<productPromoActionSeqId type="id-ne"/>
<productPromoActionEnumId type="id-ne"/>
<orderAdjustmentTypeId type="id"/>
<serviceName type="long-varchar"/>
<quantity type="fixed-point"/>
<amount type="fixed-point"/>
<productId type="id"/>
<partyId type="id"/>
<useCartQuantity type="indicator"/>
</ProductPromoAction>
<ProductPromoCategory xmlns:ns10="org.ofbiz.product.promo">
<productPromoId type="id-ne"/>
<productPromoRuleId type="id-ne"/>
<productPromoActionSeqId type="id-ne"/>
<productPromoCondSeqId type="id-ne"/>
<productCategoryId type="id-ne"/>
<andGroupId type="id"/>
<productPromoApplEnumId type="id-ne"/>
<includeSubCategories type="indicator"/>
</ProductPromoCategory>
<ProductPromoCode xmlns:ns10="org.ofbiz.product.promo">
<productPromoCodeId type="id-ne"/>
<productPromoId type="id-ne"/>
<userEntered type="indicator"/>
<requireEmailOrParty type="indicator"/>
<useLimitPerCode type="numeric"/>
<useLimitPerCustomer type="numeric"/>
<fromDate type="date-time"/>
<thruDate type="date-time"/>
<createdDate type="date-time"/>
<createdByUserLogin type="id-vlong"/>
<lastModifiedDate type="date-time"/>
<lastModifiedByUserLogin type="id-vlong"/>
</ProductPromoCode>
<ProductPromoCodeEmail xmlns:ns10="org.ofbiz.product.promo">
<productPromoCodeId type="id-ne"/>
<emailAddress type="email"/>
</ProductPromoCodeEmail>
<ProductPromoCodeParty xmlns:ns10="org.ofbiz.product.promo">
<productPromoCodeId type="id-ne"/>
<partyId type="id-ne"/>
</ProductPromoCodeParty>
<ProductPromoCond xmlns:ns10="org.ofbiz.product.promo">
<productPromoId type="id-ne"/>
<productPromoRuleId type="id-ne"/>
<productPromoCondSeqId type="id-ne"/>
<inputParamEnumId type="id"/>
<operatorEnumId type="id"/>
<condValue type="long-varchar"/>
<otherValue type="long-varchar"/>
</ProductPromoCond>
<ProductPromoContent xmlns:ns10="org.ofbiz.product.promo">
<productPromoId type="id-ne"/>
<contentId type="id-ne"/>
<productPromoContentTypeId type="id-ne"/>
<fromDate type="date-time"/>
<thruDate type="date-time"/>
</ProductPromoContent>
<ProductPromoProduct xmlns:ns10="org.ofbiz.product.promo">
<productPromoId type="id-ne"/>
<productPromoRuleId type="id-ne"/>
<productPromoActionSeqId type="id-ne"/>
<productPromoCondSeqId type="id-ne"/>
<productId type="id-ne"/>
<productPromoApplEnumId type="id-ne"/>
</ProductPromoProduct>
<ProductPromoRule xmlns:ns10="org.ofbiz.product.promo">
<productPromoId type="id-ne"/>
<productPromoRuleId type="id-ne"/>
<ruleName type="name"/>
</ProductPromoRule>
<ProductPromoUse xmlns:ns10="org.ofbiz.product.promo">
<orderId type="id-ne"/>
<promoSequenceId type="id-ne"/>
<productPromoId type="id-ne"/>
<productPromoCodeId type="id-ne"/>
<partyId type="id-ne"/>
<totalDiscountAmount type="currency-amount"/>
<quantityLeftInActions type="fixed-point"/>
</ProductPromoUse>
<ProductStore xmlns:ns11="org.ofbiz.product.store">
<productStoreId type="id-ne"/>
<primaryStoreGroupId type="id"/>
<storeName type="name"/>
<companyName type="name"/>
<title type="name"/>
<subtitle type="description"/>
<payToPartyId type="id"/>
<daysToCancelNonPay type="numeric"/>
<manualAuthIsCapture type="indicator"/>
<prorateShipping type="indicator"/>
<prorateTaxes type="indicator"/>
<viewCartOnAdd type="indicator"/>
<autoSaveCart type="indicator"/>
<autoApproveReviews type="indicator"/>
<isDemoStore type="indicator"/>
<isImmediatelyFulfilled type="indicator"/>
<inventoryFacilityId type="id"/>
<oneInventoryFacility type="indicator"/>
<checkInventory type="indicator"/>
<reserveInventory type="indicator"/>
<reserveOrderEnumId type="id"/>
<requireInventory type="indicator"/>
<balanceResOnOrderCreation type="indicator"/>
<requirementMethodEnumId type="id"/>
<orderNumberPrefix type="id-long"/>
<defaultLocaleString type="very-short"/>
<defaultCurrencyUomId type="id"/>
<defaultSalesChannelEnumId type="id"/>
<allowPassword type="indicator"/>
<defaultPassword type="long-varchar"/>
<explodeOrderItems type="indicator"/>
<checkGcBalance type="indicator"/>
<retryFailedAuths type="indicator"/>
<headerApprovedStatus type="id"/>
<itemApprovedStatus type="id"/>
<digitalItemApprovedStatus type="id"/>
<headerDeclinedStatus type="id"/>
<itemDeclinedStatus type="id"/>
<headerCancelStatus type="id"/>
<itemCancelStatus type="id"/>
<authDeclinedMessage type="long-varchar"/>
<authFraudMessage type="long-varchar"/>
<authErrorMessage type="long-varchar"/>
<visualThemeId type="id"/>
<storeCreditAccountEnumId type="id"/>
<usePrimaryEmailUsername type="indicator"/>
<requireCustomerRole type="indicator"/>
<autoInvoiceDigitalItems type="indicator"/>
<reqShipAddrForDigItems type="indicator"/>
<showCheckoutGiftOptions type="indicator"/>
<selectPaymentTypePerItem type="indicator"/>
<showPricesWithVatTax type="indicator"/>
<showTaxIsExempt type="indicator"/>
<vatTaxAuthGeoId type="id"/>
<vatTaxAuthPartyId type="id"/>
<enableAutoSuggestionList type="indicator"/>
<enableDigProdUpload type="indicator"/>
<prodSearchExcludeVariants type="indicator"/>
<digProdUploadCategoryId type="id"/>
<autoOrderCcTryExp type="indicator"/>
<autoOrderCcTryOtherCards type="indicator"/>
<autoOrderCcTryLaterNsf type="indicator"/>
<autoOrderCcTryLaterMax type="numeric"/>
<storeCreditValidDays type="numeric"/>
<autoApproveInvoice type="indicator"/>
<autoApproveOrder type="indicator"/>
<shipIfCaptureFails type="indicator"/>
<setOwnerUponIssuance type="indicator"/>
<reqReturnInventoryReceive type="indicator"/>
<addToCartRemoveIncompat type="indicator"/>
<addToCartReplaceUpsell type="indicator"/>
<splitPayPrefPerShpGrp type="indicator"/>
<managedByLot type="indicator"/>
<showOutOfStockProducts type="indicator"/>
<orderDecimalQuantity type="indicator"/>
<oldStyleSheet type="url"/>
<oldHeaderLogo type="url"/>
<oldHeaderMiddleBackground type="url"/>
<oldHeaderRightBackground type="url"/>
</ProductStore>
<ProductStoreCatalog xmlns:ns11="org.ofbiz.product.store">
<productStoreId type="id-ne"/>
<prodCatalogId type="id-ne"/>
<fromDate type="date-time"/>
<thruDate type="date-time"/>
<sequenceNum type="numeric"/>
</ProductStoreCatalog>
<ProductStoreEmailSetting xmlns:ns11="org.ofbiz.product.store">
<productStoreId type="id-ne"/>
<emailType type="id-ne"/>
<bodyScreenLocation type="long-varchar"/>
<xslfoAttachScreenLocation type="long-varchar"/>
<fromAddress type="email"/>
<ccAddress type="email"/>
<bccAddress type="email"/>
<subject type="comment"/>
<contentType type="long-varchar"/>
</ProductStoreEmailSetting>
<ProductStoreFacility xmlns:ns11="org.ofbiz.product.store">
<productStoreId type="id-ne"/>
<facilityId type="id-ne"/>
<fromDate type="date-time"/>
<thruDate type="date-time"/>
<sequenceNum type="numeric"/>
</ProductStoreFacility>
<ProductStoreFinActSetting xmlns:ns11="org.ofbiz.product.store">
<productStoreId type="id-ne"/>
<finAccountTypeId type="id-ne"/>
<requirePinCode type="indicator"/>
<validateGCFinAcct type="indicator"/>
<accountCodeLength type="numeric"/>
<pinCodeLength type="numeric"/>
<accountValidDays type="numeric"/>
<authValidDays type="numeric"/>
<purchaseSurveyId type="id"/>
<purchSurveySendTo type="id"/>
<purchSurveyCopyMe type="id"/>
<allowAuthToNegative type="indicator"/>
<minBalance type="currency-amount"/>
<replenishThreshold type="currency-amount"/>
<replenishMethodEnumId type="id"/>
</ProductStoreFinActSetting>
<ProductStoreGroup xmlns:ns11="org.ofbiz.product.store">
<productStoreGroupId type="id-ne"/>
<productStoreGroupTypeId type="id"/>
<primaryParentGroupId type="id"/>
<productStoreGroupName type="name"/>
<description type="description"/>
</ProductStoreGroup>
<ProductStoreGroupMember xmlns:ns11="org.ofbiz.product.store">
<productStoreId type="id-ne"/>
<productStoreGroupId type="id-ne"/>
<fromDate type="date-time"/>
<thruDate type="date-time"/>
<sequenceNum type="numeric"/>
</ProductStoreGroupMember>
<ProductStoreGroupRole xmlns:ns11="org.ofbiz.product.store">
<productStoreGroupId type="id-ne"/>
<partyId type="id"/>
<roleTypeId type="id"/>
</ProductStoreGroupRole>
<ProductStoreGroupRollup xmlns:ns11="org.ofbiz.product.store">
<productStoreGroupId type="id-ne"/>
<parentGroupId type="id-ne"/>
<fromDate type="date-time"/>
<thruDate type="date-time"/>
<sequenceNum type="numeric"/>
</ProductStoreGroupRollup>
<ProductStoreGroupType xmlns:ns11="org.ofbiz.product.store">
<productStoreGroupTypeId type="id-ne"/>
<description type="description"/>
</ProductStoreGroupType>
<ProductStoreKeywordOvrd xmlns:ns11="org.ofbiz.product.store">
<productStoreId type="id-ne"/>
<keyword type="short-varchar"/>
<fromDate type="date-time"/>
<thruDate type="date-time"/>
<target type="long-varchar"/>
<targetTypeEnumId type="id"/>
</ProductStoreKeywordOvrd>
<ProductStorePaymentSetting xmlns:ns11="org.ofbiz.product.store">
<productStoreId type="id-ne"/>
<paymentMethodTypeId type="id-ne"/>
<paymentServiceTypeEnumId type="id-ne"/>
<paymentService type="value"/>
<paymentCustomMethodId type="id"/>
<paymentGatewayConfigId type="id"/>
<paymentPropertiesPath type="value"/>
<applyToAllProducts type="indicator"/>
</ProductStorePaymentSetting>
<ProductStorePromoAppl xmlns:ns11="org.ofbiz.product.store">
<productStoreId type="id-ne"/>
<productPromoId type="id-ne"/>
<fromDate type="date-time"/>
<thruDate type="date-time"/>
<sequenceNum type="numeric"/>
<manualOnly type="indicator"/>
</ProductStorePromoAppl>
<ProductStoreRole xmlns:ns11="org.ofbiz.product.store">
<partyId type="id-ne"/>
<roleTypeId type="id-ne"/>
<productStoreId type="id-ne"/>
<fromDate type="date-time"/>
<thruDate type="date-time"/>
<sequenceNum type="numeric"/>
</ProductStoreRole>
<ProductStoreShipmentMeth xmlns:ns11="org.ofbiz.product.store">
<productStoreShipMethId type="id-ne"/>
<productStoreId type="id-ne"/>
<shipmentMethodTypeId type="id-ne"/>
<partyId type="id-ne"/>
<roleTypeId type="id-ne"/>
<companyPartyId type="id"/>
<minWeight type="fixed-point"/>
<maxWeight type="fixed-point"/>
<minSize type="fixed-point"/>
<maxSize type="fixed-point"/>
<minTotal type="currency-amount"/>
<maxTotal type="currency-amount"/>
<allowUspsAddr type="indicator"/>
<requireUspsAddr type="indicator"/>
<allowCompanyAddr type="indicator"/>
<requireCompanyAddr type="indicator"/>
<includeNoChargeItems type="indicator"/>
<includeFeatureGroup type="id"/>
<excludeFeatureGroup type="id"/>
<includeGeoId type="id"/>
<excludeGeoId type="id"/>
<serviceName type="long-varchar"/>
<configProps type="long-varchar"/>
<shipmentCustomMethodId type="id"/>
<shipmentGatewayConfigId type="id"/>
<sequenceNumber type="numeric"/>
</ProductStoreShipmentMeth>
<ProductStoreSurveyAppl xmlns:ns11="org.ofbiz.product.store">
<productStoreSurveyId type="id-ne"/>
<productStoreId type="id-ne"/>
<surveyApplTypeId type="id-ne"/>
<groupName type="name"/>
<surveyId type="id-ne"/>
<productId type="id"/>
<productCategoryId type="id"/>
<fromDate type="date-time"/>
<thruDate type="date-time"/>
<surveyTemplate type="long-varchar"/>
<resultTemplate type="long-varchar"/>
<sequenceNum type="numeric"/>
</ProductStoreSurveyAppl>
<ProductStoreVendorPayment xmlns:ns11="org.ofbiz.product.store">
<productStoreId type="id-ne"/>
<vendorPartyId type="id-ne"/>
<paymentMethodTypeId type="id-ne"/>
<creditCardEnumId type="id-ne"/>
</ProductStoreVendorPayment>
<ProductStoreVendorShipment xmlns:ns11="org.ofbiz.product.store">
<productStoreId type="id-ne"/>
<vendorPartyId type="id-ne"/>
<shipmentMethodTypeId type="id-ne"/>
<carrierPartyId type="id-ne"/>
</ProductStoreVendorShipment>
<ProductSubscriptionResource xmlns:ns12="org.ofbiz.product.subscription">
<productId type="id-ne"/>
<subscriptionResourceId type="id-ne"/>
<fromDate type="date-time"/>
<thruDate type="date-time"/>
<purchaseFromDate type="date-time"/>
<purchaseThruDate type="date-time"/>
<maxLifeTime type="numeric"/>
<maxLifeTimeUomId type="id"/>
<availableTime type="numeric"/>
<availableTimeUomId type="id"/>
<useCountLimit type="numeric"/>
<useTime type="numeric"/>
<useTimeUomId type="id"/>
<useRoleTypeId type="id"/>
<automaticExtend type="indicator"/>
<canclAutmExtTime type="numeric"/>
<canclAutmExtTimeUomId type="id"/>
</ProductSubscriptionResource>
<Subscription xmlns:ns12="org.ofbiz.product.subscription">
<subscriptionId type="id-ne"/>
<description type="description"/>
<subscriptionResourceId type="id"/>
<communicationEventId type="id"/>
<contactMechId type="id"/>
<originatedFromPartyId type="id"/>
<originatedFromRoleTypeId type="id"/>
<partyId type="id"/>
<roleTypeId type="id"/>
<partyNeedId type="id"/>
<needTypeId type="id"/>
<orderId type="id"/>
<orderItemSeqId type="id"/>
<productId type="id"/>
<productCategoryId type="id"/>
<inventoryItemId type="id"/>
<subscriptionTypeId type="id"/>
<externalSubscriptionId type="id"/>
<fromDate type="date-time"/>
<thruDate type="date-time"/>
<purchaseFromDate type="date-time"/>
<purchaseThruDate type="date-time"/>
<maxLifeTime type="numeric"/>
<maxLifeTimeUomId type="id"/>
<availableTime type="numeric"/>
<availableTimeUomId type="id"/>
<useCountLimit type="numeric"/>
<useTime type="numeric"/>
<useTimeUomId type="id"/>
<automaticExtend type="indicator"/>
<canclAutmExtTime type="numeric"/>
<canclAutmExtTimeUomId type="id"/>
</Subscription>
<SubscriptionActivity xmlns:ns12="org.ofbiz.product.subscription">
<subscriptionActivityId type="id-ne"/>
<comments type="comment"/>
<dateSent type="date-time"/>
</SubscriptionActivity>
<SubscriptionAttribute xmlns:ns12="org.ofbiz.product.subscription">
<subscriptionId type="id-ne"/>
<attrName type="id-long-ne"/>
<attrValue type="value"/>
</SubscriptionAttribute>
<SubscriptionCommEvent xmlns:ns12="org.ofbiz.product.subscription">
<subscriptionId type="id-ne"/>
<communicationEventId type="id-ne"/>
</SubscriptionCommEvent>
<SubscriptionFulfillmentPiece xmlns:ns12="org.ofbiz.product.subscription">
<subscriptionActivityId type="id-ne"/>
<subscriptionId type="id-ne"/>
</SubscriptionFulfillmentPiece>
<SubscriptionResource xmlns:ns12="org.ofbiz.product.subscription">
<subscriptionResourceId type="id-ne"/>
<parentResourceId type="id"/>
<description type="description"/>
<contentId type="id"/>
<webSiteId type="id"/>
</SubscriptionResource>
<SubscriptionType xmlns:ns12="org.ofbiz.product.subscription">
<subscriptionTypeId type="id-ne"/>
<parentTypeId type="id"/>
<hasTable type="indicator"/>
<description type="description"/>
</SubscriptionType>
<SubscriptionTypeAttr xmlns:ns12="org.ofbiz.product.subscription">
<subscriptionTypeId type="id-ne"/>
<attrName type="id-long-ne"/>
</SubscriptionTypeAttr>
<MarketInterest xmlns:ns13="org.ofbiz.product.supplier">
<productCategoryId type="id-ne"/>
<partyClassificationGroupId type="id-ne"/>
<fromDate type="date-time"/>
<thruDate type="date-time"/>
</MarketInterest>
<ReorderGuideline xmlns:ns13="org.ofbiz.product.supplier">
<reorderGuidelineId type="id-ne"/>
<productId type="id-ne"/>
<partyId type="id"/>
<roleTypeId type="id"/>
<facilityId type="id"/>
<geoId type="id"/>
<fromDate type="date-time"/>
<thruDate type="date-time"/>
<reorderQuantity type="fixed-point"/>
<reorderLevel type="fixed-point"/>
</ReorderGuideline>
<SupplierPrefOrder xmlns:ns13="org.ofbiz.product.supplier">
<supplierPrefOrderId type="id-ne"/>
<description type="description"/>
</SupplierPrefOrder>
<SupplierProduct xmlns:ns13="org.ofbiz.product.supplier">
<productId type="id-ne"/>
<partyId type="id-ne"/>
<availableFromDate type="date-time"/>
<availableThruDate type="date-time"/>
<supplierPrefOrderId type="id"/>
<supplierRatingTypeId type="id"/>
<standardLeadTimeDays type="fixed-point"/>
<minimumOrderQuantity type="fixed-point"/>
<orderQtyIncrements type="fixed-point"/>
<unitsIncluded type="fixed-point"/>
<quantityUomId type="id"/>
<agreementId type="id"/>
<agreementItemSeqId type="id"/>
<lastPrice type="currency-precise"/>
<shippingPrice type="currency-precise"/>
<currencyUomId type="id"/>
<supplierProductName type="name"/>
<supplierProductId type="id"/>
<canDropShip type="indicator"/>
<comments type="comment"/>
</SupplierProduct>
<SupplierProductFeature xmlns:ns13="org.ofbiz.product.supplier">
<partyId type="id-ne"/>
<productFeatureId type="id-ne"/>
<description type="name"/>
<uomId type="id"/>
<idCode type="id"/>
</SupplierProductFeature>
<SupplierRatingType xmlns:ns13="org.ofbiz.product.supplier">
<supplierRatingTypeId type="id-ne"/>
<description type="description"/>
</SupplierRatingType>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment