details: https://code.openbravo.com/erp/devel/pi/rev/7a7adf930de6 changeset: 26142:7a7adf930de6 user: Reinaldo Guerra <reinaldo.guerra <at> peoplewalking.com> date: Fri Nov 07 23:24:39 2014 -0500 summary: Fixed bug 27313: D-U-N-S number should not be mandatory
D-U-N-S number column in organization's information table was changed to non mandatory. Now when introducing data in organization's information tab it is not necessary to fill D-U-N-S number as it is something that is not used in all the goberments/companies. details: https://code.openbravo.com/erp/devel/pi/rev/17996ec1f87f changeset: 26143:17996ec1f87f user: Alvaro Ferraz <alvaro.ferraz <at> openbravo.com> date: Tue Mar 03 18:19:16 2015 +0100 summary: Related to bug 27313: Duns field in AD_ORGINFO will not be filled automatically AD_ORG_TRG trigger has been modified in order not to set automatically '?' value to duns column in AD_ORGINFO table diffstat: src-db/database/model/tables/AD_ORGINFO.xml | 2 +- src-db/database/model/triggers/AD_ORG_TRG.xml | 4 ++-- src-db/database/sourcedata/AD_COLUMN.xml | 2 +- 3 files changed, 4 insertions(+), 4 deletions(-) diffs (45 lines): diff -r b9fc7e8e60ae -r 17996ec1f87f src-db/database/model/tables/AD_ORGINFO.xml --- a/src-db/database/model/tables/AD_ORGINFO.xml Fri Mar 06 17:03:04 2015 +0100 +++ b/src-db/database/model/tables/AD_ORGINFO.xml Tue Mar 03 18:19:16 2015 +0100 @@ -33,7 +33,7 @@ <default/> <onCreateDefault/> </column> - <column name="DUNS" primaryKey="false" required="true" type="CHAR" size="11" autoIncrement="false"> + <column name="DUNS" primaryKey="false" required="false" type="CHAR" size="11" autoIncrement="false"> <default/> <onCreateDefault/> </column> diff -r b9fc7e8e60ae -r 17996ec1f87f src-db/database/model/triggers/AD_ORG_TRG.xml --- a/src-db/database/model/triggers/AD_ORG_TRG.xml Fri Mar 06 17:03:04 2015 +0100 +++ b/src-db/database/model/triggers/AD_ORG_TRG.xml Tue Mar 03 18:19:16 2015 +0100 @@ -17,7 +17,7 @@ * parts created by ComPiere are Copyright (C) ComPiere, Inc.; * All Rights Reserved. * Contributor(s): Openbravo SLU - * Contributions are Copyright (C) 2001-2014 Openbravo, S.L.U. + * Contributions are Copyright (C) 2001-2015 Openbravo, S.L.U. * * Specifically, this derivative work is based upon the following Compiere * file and version. @@ -112,7 +112,7 @@ ( :new.AD_Org_ID, :new.AD_Client_ID, 'Y', now(), :new.CreatedBy, now(), - :new.CreatedBy, NULL, '?', + :new.CreatedBy, NULL, NULL, '?' ) ; diff -r b9fc7e8e60ae -r 17996ec1f87f src-db/database/sourcedata/AD_COLUMN.xml --- a/src-db/database/sourcedata/AD_COLUMN.xml Fri Mar 06 17:03:04 2015 +0100 +++ b/src-db/database/sourcedata/AD_COLUMN.xml Tue Mar 03 18:19:16 2015 +0100 @@ -32984,7 +32984,7 @@ <!--2352--> <FIELDLENGTH><![CDATA[11]]></FIELDLENGTH> <!--2352--> <ISKEY><![CDATA[N]]></ISKEY> <!--2352--> <ISPARENT><![CDATA[N]]></ISPARENT> -<!--2352--> <ISMANDATORY><![CDATA[Y]]></ISMANDATORY> +<!--2352--> <ISMANDATORY><![CDATA[N]]></ISMANDATORY> <!--2352--> <ISUPDATEABLE><![CDATA[Y]]></ISUPDATEABLE> <!--2352--> <ISIDENTIFIER><![CDATA[N]]></ISIDENTIFIER> <!--2352--> <ISTRANSLATED><![CDATA[N]]></ISTRANSLATED> ------------------------------------------------------------------------------ Dive into the World of Parallel Programming The Go Parallel Website, sponsored by Intel and developed in partnership with Slashdot Media, is your hub for all things parallel software development, from weekly thought leadership blogs to news, videos, case studies, tutorials and more. Take a look and join the conversation now. http://goparallel.sourceforge.net/ _______________________________________________ Openbravo-commits mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/openbravo-commits
