Author: jaz
Date: Mon Mar 26 21:09:11 2007
New Revision: 522733
URL: http://svn.apache.org/viewvc?view=rev&rev=522733
Log:
updated financial account data model with new fields for replenishment
Modified:
ofbiz/trunk/applications/accounting/entitydef/entitygroup.xml
ofbiz/trunk/applications/accounting/entitydef/entitymodel.xml
Modified: ofbiz/trunk/applications/accounting/entitydef/entitygroup.xml
URL:
http://svn.apache.org/viewvc/ofbiz/trunk/applications/accounting/entitydef/entitygroup.xml?view=diff&rev=522733&r1=522732&r2=522733
==============================================================================
--- ofbiz/trunk/applications/accounting/entitydef/entitygroup.xml (original)
+++ ofbiz/trunk/applications/accounting/entitydef/entitygroup.xml Mon Mar 26
21:09:11 2007
@@ -47,6 +47,7 @@
<!-- ========================================================= -->
<entity-group group="org.ofbiz" entity="FinAccount" />
+ <entity-group group="org.ofbiz" entity="FinAccountAndRole" />
<entity-group group="org.ofbiz" entity="FinAccountAttribute" />
<entity-group group="org.ofbiz" entity="FinAccountRole" />
<entity-group group="org.ofbiz" entity="FinAccountTrans" />
Modified: ofbiz/trunk/applications/accounting/entitydef/entitymodel.xml
URL:
http://svn.apache.org/viewvc/ofbiz/trunk/applications/accounting/entitydef/entitymodel.xml?view=diff&rev=522733&r1=522732&r2=522733
==============================================================================
--- ofbiz/trunk/applications/accounting/entitydef/entitymodel.xml (original)
+++ ofbiz/trunk/applications/accounting/entitydef/entitymodel.xml Mon Mar 26
21:09:11 2007
@@ -331,12 +331,15 @@
<field name="finAccountTypeId" type="id"></field>
<field name="finAccountName" type="name"></field>
<field name="finAccountCode" type="long-varchar"
encrypt="true"></field>
+ <field name="finAccountPin" type="long-varchar" encrypt="true"></field>
<field name="currencyUomId" type="id-ne"/>
<field name="organizationPartyId" type="id"><description>The internal
organization Party that owns (or rather, is liable for) the
account.</description></field>
<field name="ownerPartyId" type="id"><description>The customer or
third party that owns the account.</description></field>
<field name="postToGlAccountId" type="id"></field>
<field name="fromDate" type="date-time"><description>Describes when
account will be valid. If null, valid immediately.</description></field>
<field name="thruDate" type="date-time"><description>Expiration date
of the account. If null, will never expire.</description></field>
+ <field name="isFrozen" type="indicator"></field>
+ <field name="replenishLevel" type="currency-amount"></field>
<field name="actualBalance"
type="currency-amount"><description>Calculated as the sum of
FinAccountTrans.amount</description></field>
<field name="availableBalance"
type="currency-amount"><description>Calculated as actualBalance minus sum of
outstanding FinAccountAuth.amount</description></field>
<prim-key field="finAccountId"/>
@@ -359,6 +362,21 @@
<key-map field-name="finAccountTypeId"/>
</relation>
</entity>
+ <view-entity entity-name="FinAccountAndRole"
+ package-name="org.ofbiz.accounting.finaccount"
+ title="Financial Account and Role View Entity">
+ <member-entity entity-alias="FA" entity-name="FinAccount"/>
+ <member-entity entity-alias="FR" entity-name="FinAccountRole"/>
+ <alias-all entity-alias="FA"/>
+ <alias name="partyId" entity-alias="FR"/>
+ <alias name="roleTypeId" entity-alias="FR"/>
+ <alias name="roleFromDate" entity-alias="FR" field="fromDate"/>
+ <alias name="roleThruDate" entity-alias="FR" field="thruDate"/>
+ <view-link entity-alias="FA" rel-entity-alias="FR">
+ <key-map field-name="finAccountId"/>
+ </view-link>
+ </view-entity>
+
<entity entity-name="FinAccountAttribute"
package-name="org.ofbiz.accounting.finaccount" title="Financial Account
Attribute Entity">
<field name="finAccountId" type="id-ne"></field>
<field name="attrName" type="id-long-ne"></field>
@@ -481,11 +499,15 @@
<entity entity-name="FinAccountType"
package-name="org.ofbiz.accounting.finaccount" title="Financial Account Type
Entity">
<field name="finAccountTypeId" type="id-ne"></field>
<field name="parentTypeId" type="id-ne"></field>
+ <field name="replenishEnumId" type="id-ne"></field>
<field name="hasTable" type="indicator"></field>
<field name="description" type="description"></field>
<prim-key field="finAccountTypeId"/>
<relation type="one" fk-name="FINACCT_TYPE_PAR" title="Parent"
rel-entity-name="FinAccountType">
<key-map field-name="parentTypeId"
rel-field-name="finAccountTypeId"/>
+ </relation>
+ <relation type="one" fk-name="FINACCT_TYPE_RENUM"
rel-entity-name="Enumeration">
+ <key-map field-name="depositEnumId" rel-field-name="enumId"/>
</relation>
</entity>
<entity entity-name="FinAccountTypeAttr"
package-name="org.ofbiz.accounting.finaccount" title="Financial Account Type
Attribute Entity">
