details: https://code.openbravo.com/erp/stable/2.50/rev/bf5d6a964570
changeset: 9649:bf5d6a964570
user: Javier Etxarri <javier.echarri <at> openbravo.com>
date: Mon Sep 05 16:57:37 2011 +0200
summary: Fixes issue 18413: There should be a social name in organization
window to use it in financial reports
diffstat:
src-db/database/model/tables/AD_ORG.xml | 4 +++
src-db/database/sourcedata/AD_COLUMN.xml | 33 +++++++++++++++++++++++++++++++
src-db/database/sourcedata/AD_ELEMENT.xml | 13 ++++++++++++
src-db/database/sourcedata/AD_FIELD.xml | 29 ++++++++++++++++++++++++--
4 files changed, 76 insertions(+), 3 deletions(-)
diffs (140 lines):
diff -r 84ea12989539 -r bf5d6a964570 src-db/database/model/tables/AD_ORG.xml
--- a/src-db/database/model/tables/AD_ORG.xml Fri Sep 02 12:10:51 2011 +0200
+++ b/src-db/database/model/tables/AD_ORG.xml Mon Sep 05 16:57:37 2011 +0200
@@ -61,6 +61,10 @@
<default><![CDATA[N]]></default>
<onCreateDefault><![CDATA['N']]></onCreateDefault>
</column>
+ <column name="SOCIAL_NAME" primaryKey="false" required="false"
type="VARCHAR" size="60" autoIncrement="false">
+ <default/>
+ <onCreateDefault/>
+ </column>
<foreign-key foreignTable="AD_CLIENT" name="AD_ORG_AD_CLIENT">
<reference local="AD_CLIENT_ID" foreign="AD_CLIENT_ID"/>
</foreign-key>
diff -r 84ea12989539 -r bf5d6a964570 src-db/database/sourcedata/AD_COLUMN.xml
--- a/src-db/database/sourcedata/AD_COLUMN.xml Fri Sep 02 12:10:51 2011 +0200
+++ b/src-db/database/sourcedata/AD_COLUMN.xml Mon Sep 05 16:57:37 2011 +0200
@@ -282430,6 +282430,39 @@
<!--5E7C48B7AB0F46AEB4EDA3EA73871315-->
<VALIDATEONNEW><![CDATA[Y]]></VALIDATEONNEW>
<!--5E7C48B7AB0F46AEB4EDA3EA73871315--></AD_COLUMN>
+<!--5F6E51F7E4B348A7A49955F778B1495F--><AD_COLUMN>
+<!--5F6E51F7E4B348A7A49955F778B1495F-->
<AD_COLUMN_ID><![CDATA[5F6E51F7E4B348A7A49955F778B1495F]]></AD_COLUMN_ID>
+<!--5F6E51F7E4B348A7A49955F778B1495F-->
<AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--5F6E51F7E4B348A7A49955F778B1495F--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--5F6E51F7E4B348A7A49955F778B1495F--> <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--5F6E51F7E4B348A7A49955F778B1495F--> <NAME><![CDATA[Social_Name]]></NAME>
+<!--5F6E51F7E4B348A7A49955F778B1495F--> <DESCRIPTION><![CDATA[The social name
of the organization]]></DESCRIPTION>
+<!--5F6E51F7E4B348A7A49955F778B1495F--> <HELP><![CDATA[This column refer to
the social name of the organization.]]></HELP>
+<!--5F6E51F7E4B348A7A49955F778B1495F-->
<COLUMNNAME><![CDATA[Social_Name]]></COLUMNNAME>
+<!--5F6E51F7E4B348A7A49955F778B1495F-->
<AD_TABLE_ID><![CDATA[155]]></AD_TABLE_ID>
+<!--5F6E51F7E4B348A7A49955F778B1495F-->
<AD_REFERENCE_ID><![CDATA[10]]></AD_REFERENCE_ID>
+<!--5F6E51F7E4B348A7A49955F778B1495F-->
<FIELDLENGTH><![CDATA[60]]></FIELDLENGTH>
+<!--5F6E51F7E4B348A7A49955F778B1495F--> <ISKEY><![CDATA[N]]></ISKEY>
+<!--5F6E51F7E4B348A7A49955F778B1495F--> <ISPARENT><![CDATA[N]]></ISPARENT>
+<!--5F6E51F7E4B348A7A49955F778B1495F-->
<ISMANDATORY><![CDATA[N]]></ISMANDATORY>
+<!--5F6E51F7E4B348A7A49955F778B1495F-->
<ISUPDATEABLE><![CDATA[Y]]></ISUPDATEABLE>
+<!--5F6E51F7E4B348A7A49955F778B1495F-->
<ISIDENTIFIER><![CDATA[N]]></ISIDENTIFIER>
+<!--5F6E51F7E4B348A7A49955F778B1495F--> <SEQNO><![CDATA[51]]></SEQNO>
+<!--5F6E51F7E4B348A7A49955F778B1495F-->
<ISTRANSLATED><![CDATA[N]]></ISTRANSLATED>
+<!--5F6E51F7E4B348A7A49955F778B1495F-->
<ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
+<!--5F6E51F7E4B348A7A49955F778B1495F-->
<ISSELECTIONCOLUMN><![CDATA[N]]></ISSELECTIONCOLUMN>
+<!--5F6E51F7E4B348A7A49955F778B1495F-->
<AD_ELEMENT_ID><![CDATA[923B13146C2349BC8BF34E8AA3E2F9DB]]></AD_ELEMENT_ID>
+<!--5F6E51F7E4B348A7A49955F778B1495F-->
<ISSESSIONATTR><![CDATA[N]]></ISSESSIONATTR>
+<!--5F6E51F7E4B348A7A49955F778B1495F-->
<ISSECONDARYKEY><![CDATA[N]]></ISSECONDARYKEY>
+<!--5F6E51F7E4B348A7A49955F778B1495F-->
<ISDESENCRYPTABLE><![CDATA[N]]></ISDESENCRYPTABLE>
+<!--5F6E51F7E4B348A7A49955F778B1495F-->
<DEVELOPMENTSTATUS><![CDATA[RE]]></DEVELOPMENTSTATUS>
+<!--5F6E51F7E4B348A7A49955F778B1495F-->
<AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
+<!--5F6E51F7E4B348A7A49955F778B1495F--> <POSITION><![CDATA[16]]></POSITION>
+<!--5F6E51F7E4B348A7A49955F778B1495F-->
<ISTRANSIENT><![CDATA[N]]></ISTRANSIENT>
+<!--5F6E51F7E4B348A7A49955F778B1495F--> <ISAUTOSAVE><![CDATA[Y]]></ISAUTOSAVE>
+<!--5F6E51F7E4B348A7A49955F778B1495F-->
<VALIDATEONNEW><![CDATA[Y]]></VALIDATEONNEW>
+<!--5F6E51F7E4B348A7A49955F778B1495F--></AD_COLUMN>
+
<!--5FDFFDE441A642B1955E95CB06196501--><AD_COLUMN>
<!--5FDFFDE441A642B1955E95CB06196501-->
<AD_COLUMN_ID><![CDATA[5FDFFDE441A642B1955E95CB06196501]]></AD_COLUMN_ID>
<!--5FDFFDE441A642B1955E95CB06196501-->
<AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
diff -r 84ea12989539 -r bf5d6a964570 src-db/database/sourcedata/AD_ELEMENT.xml
--- a/src-db/database/sourcedata/AD_ELEMENT.xml Fri Sep 02 12:10:51 2011 +0200
+++ b/src-db/database/sourcedata/AD_ELEMENT.xml Mon Sep 05 16:57:37 2011 +0200
@@ -27482,6 +27482,19 @@
<!--921BC5DDB6EFD1ABE040007F01005E94-->
<AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
<!--921BC5DDB6EFD1ABE040007F01005E94--></AD_ELEMENT>
+<!--923B13146C2349BC8BF34E8AA3E2F9DB--><AD_ELEMENT>
+<!--923B13146C2349BC8BF34E8AA3E2F9DB-->
<AD_ELEMENT_ID><![CDATA[923B13146C2349BC8BF34E8AA3E2F9DB]]></AD_ELEMENT_ID>
+<!--923B13146C2349BC8BF34E8AA3E2F9DB-->
<AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--923B13146C2349BC8BF34E8AA3E2F9DB--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--923B13146C2349BC8BF34E8AA3E2F9DB--> <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--923B13146C2349BC8BF34E8AA3E2F9DB-->
<COLUMNNAME><![CDATA[Social_Name]]></COLUMNNAME>
+<!--923B13146C2349BC8BF34E8AA3E2F9DB--> <NAME><![CDATA[Social_Name]]></NAME>
+<!--923B13146C2349BC8BF34E8AA3E2F9DB--> <PRINTNAME><![CDATA[Social
Name]]></PRINTNAME>
+<!--923B13146C2349BC8BF34E8AA3E2F9DB--> <DESCRIPTION><![CDATA[The social name
of the organization]]></DESCRIPTION>
+<!--923B13146C2349BC8BF34E8AA3E2F9DB--> <HELP><![CDATA[This column refer to
the social name of the organization.]]></HELP>
+<!--923B13146C2349BC8BF34E8AA3E2F9DB-->
<AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
+<!--923B13146C2349BC8BF34E8AA3E2F9DB--></AD_ELEMENT>
+
<!--92960702F3C3E1DAE040007F010046D0--><AD_ELEMENT>
<!--92960702F3C3E1DAE040007F010046D0-->
<AD_ELEMENT_ID><![CDATA[92960702F3C3E1DAE040007F010046D0]]></AD_ELEMENT_ID>
<!--92960702F3C3E1DAE040007F010046D0-->
<AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
diff -r 84ea12989539 -r bf5d6a964570 src-db/database/sourcedata/AD_FIELD.xml
--- a/src-db/database/sourcedata/AD_FIELD.xml Fri Sep 02 12:10:51 2011 +0200
+++ b/src-db/database/sourcedata/AD_FIELD.xml Mon Sep 05 16:57:37 2011 +0200
@@ -6174,7 +6174,7 @@
<!--442--> <ISDISPLAYED><![CDATA[Y]]></ISDISPLAYED>
<!--442--> <DISPLAYLENGTH><![CDATA[60]]></DISPLAYLENGTH>
<!--442--> <ISREADONLY><![CDATA[N]]></ISREADONLY>
-<!--442--> <SEQNO><![CDATA[60]]></SEQNO>
+<!--442--> <SEQNO><![CDATA[70]]></SEQNO>
<!--442--> <ISSAMELINE><![CDATA[N]]></ISSAMELINE>
<!--442--> <ISFIELDONLY><![CDATA[N]]></ISFIELDONLY>
<!--442--> <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
@@ -190000,7 +190000,7 @@
<!--583187DBFDF151F5E040007F010101E2-->
<DISPLAYLOGIC><![CDATA[@ISPERIODCONTROLALLOWED_AUX@='Y']]></DISPLAYLOGIC>
<!--583187DBFDF151F5E040007F010101E2-->
<DISPLAYLENGTH><![CDATA[1]]></DISPLAYLENGTH>
<!--583187DBFDF151F5E040007F010101E2--> <ISREADONLY><![CDATA[N]]></ISREADONLY>
-<!--583187DBFDF151F5E040007F010101E2--> <SEQNO><![CDATA[90]]></SEQNO>
+<!--583187DBFDF151F5E040007F010101E2--> <SEQNO><![CDATA[110]]></SEQNO>
<!--583187DBFDF151F5E040007F010101E2--> <ISSAMELINE><![CDATA[Y]]></ISSAMELINE>
<!--583187DBFDF151F5E040007F010101E2-->
<ISFIELDONLY><![CDATA[N]]></ISFIELDONLY>
<!--583187DBFDF151F5E040007F010101E2-->
<ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
@@ -193778,7 +193778,7 @@
<!--65C8733280D611DD9C3207FB58CC79D6-->
<ISDISPLAYED><![CDATA[Y]]></ISDISPLAYED>
<!--65C8733280D611DD9C3207FB58CC79D6-->
<DISPLAYLENGTH><![CDATA[32]]></DISPLAYLENGTH>
<!--65C8733280D611DD9C3207FB58CC79D6--> <ISREADONLY><![CDATA[N]]></ISREADONLY>
-<!--65C8733280D611DD9C3207FB58CC79D6--> <SEQNO><![CDATA[70]]></SEQNO>
+<!--65C8733280D611DD9C3207FB58CC79D6--> <SEQNO><![CDATA[90]]></SEQNO>
<!--65C8733280D611DD9C3207FB58CC79D6--> <ISSAMELINE><![CDATA[N]]></ISSAMELINE>
<!--65C8733280D611DD9C3207FB58CC79D6-->
<ISFIELDONLY><![CDATA[N]]></ISFIELDONLY>
<!--65C8733280D611DD9C3207FB58CC79D6-->
<ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
@@ -207776,6 +207776,29 @@
<!--FC53D4705CB44A4789E7E827341BC584-->
<GRID_SEQNO><![CDATA[10]]></GRID_SEQNO>
<!--FC53D4705CB44A4789E7E827341BC584--></AD_FIELD>
+<!--FCB3CA79979643A7A84C5EAF2F8E6C4F--><AD_FIELD>
+<!--FCB3CA79979643A7A84C5EAF2F8E6C4F-->
<AD_FIELD_ID><![CDATA[FCB3CA79979643A7A84C5EAF2F8E6C4F]]></AD_FIELD_ID>
+<!--FCB3CA79979643A7A84C5EAF2F8E6C4F-->
<AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--FCB3CA79979643A7A84C5EAF2F8E6C4F--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--FCB3CA79979643A7A84C5EAF2F8E6C4F--> <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--FCB3CA79979643A7A84C5EAF2F8E6C4F--> <NAME><![CDATA[Social Name]]></NAME>
+<!--FCB3CA79979643A7A84C5EAF2F8E6C4F--> <DESCRIPTION><![CDATA[The social name
of the organization]]></DESCRIPTION>
+<!--FCB3CA79979643A7A84C5EAF2F8E6C4F--> <HELP><![CDATA[This column refer to
the social name of the organization.]]></HELP>
+<!--FCB3CA79979643A7A84C5EAF2F8E6C4F-->
<ISCENTRALLYMAINTAINED><![CDATA[Y]]></ISCENTRALLYMAINTAINED>
+<!--FCB3CA79979643A7A84C5EAF2F8E6C4F--> <AD_TAB_ID><![CDATA[143]]></AD_TAB_ID>
+<!--FCB3CA79979643A7A84C5EAF2F8E6C4F-->
<AD_COLUMN_ID><![CDATA[5F6E51F7E4B348A7A49955F778B1495F]]></AD_COLUMN_ID>
+<!--FCB3CA79979643A7A84C5EAF2F8E6C4F-->
<ISDISPLAYED><![CDATA[Y]]></ISDISPLAYED>
+<!--FCB3CA79979643A7A84C5EAF2F8E6C4F-->
<DISPLAYLENGTH><![CDATA[60]]></DISPLAYLENGTH>
+<!--FCB3CA79979643A7A84C5EAF2F8E6C4F--> <ISREADONLY><![CDATA[N]]></ISREADONLY>
+<!--FCB3CA79979643A7A84C5EAF2F8E6C4F--> <SEQNO><![CDATA[60]]></SEQNO>
+<!--FCB3CA79979643A7A84C5EAF2F8E6C4F--> <ISSAMELINE><![CDATA[N]]></ISSAMELINE>
+<!--FCB3CA79979643A7A84C5EAF2F8E6C4F-->
<ISFIELDONLY><![CDATA[N]]></ISFIELDONLY>
+<!--FCB3CA79979643A7A84C5EAF2F8E6C4F-->
<ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
+<!--FCB3CA79979643A7A84C5EAF2F8E6C4F-->
<SHOWINRELATION><![CDATA[Y]]></SHOWINRELATION>
+<!--FCB3CA79979643A7A84C5EAF2F8E6C4F-->
<ISFIRSTFOCUSEDFIELD><![CDATA[N]]></ISFIRSTFOCUSEDFIELD>
+<!--FCB3CA79979643A7A84C5EAF2F8E6C4F-->
<AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
+<!--FCB3CA79979643A7A84C5EAF2F8E6C4F--></AD_FIELD>
+
<!--FF6017DC061144718EB362D7DE06A614--><AD_FIELD>
<!--FF6017DC061144718EB362D7DE06A614-->
<AD_FIELD_ID><![CDATA[FF6017DC061144718EB362D7DE06A614]]></AD_FIELD_ID>
<!--FF6017DC061144718EB362D7DE06A614-->
<AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
------------------------------------------------------------------------------
Special Offer -- Download ArcSight Logger for FREE!
Finally, a world-class log management solution at an even better
price-free! And you'll get a free "Love Thy Logs" t-shirt when you
download Logger. Secure your free ArcSight Logger TODAY!
http://p.sf.net/sfu/arcsisghtdev2dev
_______________________________________________
Openbravo-commits mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/openbravo-commits
