details: /erp/devel/pi/rev/dd36bbbe2f92
changeset: 10792:dd36bbbe2f92
user: Gorka Ion Damián <gorkaion.damian <at> openbravo.com>
date: Fri Feb 18 15:21:15 2011 +0100
summary: [OBUISEL] Fixed issue building the HQL clauses of default
expressions.
details: /erp/devel/pi/rev/3dc860c5a80f
changeset: 10793:3dc860c5a80f
user: Gorka Ion Damián <gorkaion.damian <at> openbravo.com>
date: Fri Feb 18 15:25:25 2011 +0100
summary: Added m_product_stock_v view.
details: /erp/devel/pi/rev/389366b95f4f
changeset: 10794:389366b95f4f
user: Gorka Ion Damián <gorkaion.damian <at> openbravo.com>
date: Fri Feb 18 15:26:10 2011 +0100
summary: Refactored Product Complete selector using new view. Fixed issue on
BP Selector default expressions.
diffstat:
modules/org.openbravo.userinterface.selector/src/org/openbravo/userinterface/selector/SelectorDataSourceFilter.java
| 16 +-
src-db/database/model/views/M_PRODUCT_STOCK_V.xml
| 15 +
src-db/database/sourcedata/AD_COLUMN.xml
| 562 ++++++++++
src-db/database/sourcedata/AD_ELEMENT.xml
| 11 +
src-db/database/sourcedata/AD_TABLE.xml
| 21 +
src-db/database/sourcedata/OBUISEL_SELECTOR.xml
| 51 +-
src-db/database/sourcedata/OBUISEL_SELECTOR_FIELD.xml
| 136 +-
7 files changed, 682 insertions(+), 130 deletions(-)
diffs (truncated from 1140 to 300 lines):
diff -r dc49b4d27136 -r 389366b95f4f
modules/org.openbravo.userinterface.selector/src/org/openbravo/userinterface/selector/SelectorDataSourceFilter.java
---
a/modules/org.openbravo.userinterface.selector/src/org/openbravo/userinterface/selector/SelectorDataSourceFilter.java
Fri Feb 18 15:09:15 2011 +0100
+++
b/modules/org.openbravo.userinterface.selector/src/org/openbravo/userinterface/selector/SelectorDataSourceFilter.java
Fri Feb 18 15:26:10 2011 +0100
@@ -209,16 +209,16 @@
sb.append("e." + sf.getProperty() + ".id = '" + result.toString() +
"'");
} else if (String.class == property.getPrimitiveObjectType()) {
if (textMatching == TextMatching.exact) {
- sb.append(sf.getProperty() + " = '" + result.toString() + "'");
+ sb.append("e." + sf.getProperty() + " = '" + result.toString() +
"'");
} else if (textMatching == TextMatching.startsWith) {
- sb.append("upper(" + sf.getProperty() + ") like '" +
result.toString().toUpperCase()
- + "%'");
+ sb.append("upper(" + "e." + sf.getProperty() + ") like '"
+ + result.toString().toUpperCase() + "%'");
} else {
- sb.append("upper(" + sf.getProperty() + ") like '%"
+ sb.append("upper(" + "e." + sf.getProperty() + ") like '%"
+ result.toString().toUpperCase().replaceAll(" ", "%") + "%'");
}
} else if (Boolean.class == property.getPrimitiveObjectType() ||
property.isNumericType()) {
- sb.append(sf.getProperty() + " = " + result.toString());
+ sb.append("e." + sf.getProperty() + " = " + result.toString());
} else if
(Date.class.isAssignableFrom(property.getPrimitiveObjectType())) {
if (dateFormat == null || systemDateFormat == null) {
@@ -229,9 +229,9 @@
try {
final Calendar cal = Calendar.getInstance();
cal.setTime(systemDateFormat.parse(result.toString()));
- sb.append("(day(" + sf.getProperty() + ") = " +
cal.get(Calendar.DATE) + " and month("
- + sf.getProperty() + ") = " + (cal.get(Calendar.MONTH) + 1) +
" and year("
- + sf.getProperty() + ") = " + cal.get(Calendar.YEAR) + ")");
+ sb.append("(day(" + "e." + sf.getProperty() + ") = " +
cal.get(Calendar.DATE)
+ + " and month(" + "e." + sf.getProperty() + ") = " +
(cal.get(Calendar.MONTH) + 1)
+ + " and year(" + "e." + sf.getProperty() + ") = " +
cal.get(Calendar.YEAR) + ")");
} catch (Exception e) {
log.error("Error trying to parse date for property " +
sf.getProperty(), e);
}
diff -r dc49b4d27136 -r 389366b95f4f
src-db/database/model/views/M_PRODUCT_STOCK_V.xml
--- /dev/null Thu Jan 01 00:00:00 1970 +0000
+++ b/src-db/database/model/views/M_PRODUCT_STOCK_V.xml Fri Feb 18 15:26:10
2011 +0100
@@ -0,0 +1,15 @@
+<?xml version="1.0"?>
+ <database name="VIEW M_PRODUCT_STOCK_V">
+ <view name="M_PRODUCT_STOCK_V"><![CDATA[SELECT p.m_product_id ||
sd.m_storage_detail_id AS m_product_stock_v_id, l.ad_client_id, l.ad_org_id,
l.isactive, sd.created, sd.createdby, sd.updated, sd.updatedby,
sd.m_product_id, sd.qtyonhand, sd.qtyorderonhand, sd.preqtyonhand,
sd.preqtyorderonhand, sd.c_uom_id, sd.m_product_uom_id,
sd.m_attributesetinstance_id, sd.m_locator_id
+FROM m_storage_detail sd
+JOIN m_locator l ON sd.m_locator_id = l.m_locator_id
+JOIN m_product p ON sd.m_product_id = p.m_product_id AND p.isactive = 'Y'
+WHERE sd.qtyonhand <> 0 OR COALESCE(sd.qtyorderonhand, 0) <> 0
+UNION
+SELECT p.m_product_id AS m_product_stock_v_id, p.ad_client_id, p.ad_org_id,
p.isactive, p.created, p.createdby, p.updated, p.updatedby, p.m_product_id, 0
AS qtyonhand, NULL AS qtyorderonhand, 0 AS preqtyonhand, NULL AS
preqtyorderonhand, p.c_uom_id, NULL AS m_product_uom_id,
+CASE p.attrsetvaluetype
+WHEN 'D' THEN p.m_attributesetinstance_id
+ELSE NULL
+END AS m_attributesetinstance_id, NULL AS m_locator_id
+FROM m_product p]]></view>
+ </database>
diff -r dc49b4d27136 -r 389366b95f4f src-db/database/sourcedata/AD_COLUMN.xml
--- a/src-db/database/sourcedata/AD_COLUMN.xml Fri Feb 18 15:09:15 2011 +0100
+++ b/src-db/database/sourcedata/AD_COLUMN.xml Fri Feb 18 15:26:10 2011 +0100
@@ -311600,6 +311600,568 @@
<!--9C56850497CE409C9C48FBB4C2A0F7C1-->
<VALIDATEONNEW><![CDATA[Y]]></VALIDATEONNEW>
<!--9C56850497CE409C9C48FBB4C2A0F7C1--></AD_COLUMN>
+<!--9C8C523F49E2BD9DE040007F0100646F--><AD_COLUMN>
+<!--9C8C523F49E2BD9DE040007F0100646F-->
<AD_COLUMN_ID><![CDATA[9C8C523F49E2BD9DE040007F0100646F]]></AD_COLUMN_ID>
+<!--9C8C523F49E2BD9DE040007F0100646F-->
<AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--9C8C523F49E2BD9DE040007F0100646F--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--9C8C523F49E2BD9DE040007F0100646F--> <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--9C8C523F49E2BD9DE040007F0100646F-->
<NAME><![CDATA[M_Product_Stock_V_ID]]></NAME>
+<!--9C8C523F49E2BD9DE040007F0100646F-->
<COLUMNNAME><![CDATA[M_Product_Stock_V_ID]]></COLUMNNAME>
+<!--9C8C523F49E2BD9DE040007F0100646F-->
<AD_TABLE_ID><![CDATA[FF8080812E381D1E012E3898C5DD0010]]></AD_TABLE_ID>
+<!--9C8C523F49E2BD9DE040007F0100646F-->
<AD_REFERENCE_ID><![CDATA[13]]></AD_REFERENCE_ID>
+<!--9C8C523F49E2BD9DE040007F0100646F-->
<FIELDLENGTH><![CDATA[64]]></FIELDLENGTH>
+<!--9C8C523F49E2BD9DE040007F0100646F--> <ISKEY><![CDATA[Y]]></ISKEY>
+<!--9C8C523F49E2BD9DE040007F0100646F--> <ISPARENT><![CDATA[N]]></ISPARENT>
+<!--9C8C523F49E2BD9DE040007F0100646F-->
<ISMANDATORY><![CDATA[N]]></ISMANDATORY>
+<!--9C8C523F49E2BD9DE040007F0100646F-->
<ISUPDATEABLE><![CDATA[N]]></ISUPDATEABLE>
+<!--9C8C523F49E2BD9DE040007F0100646F-->
<ISIDENTIFIER><![CDATA[N]]></ISIDENTIFIER>
+<!--9C8C523F49E2BD9DE040007F0100646F--> <SEQNO><![CDATA[10]]></SEQNO>
+<!--9C8C523F49E2BD9DE040007F0100646F-->
<ISTRANSLATED><![CDATA[N]]></ISTRANSLATED>
+<!--9C8C523F49E2BD9DE040007F0100646F-->
<ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
+<!--9C8C523F49E2BD9DE040007F0100646F-->
<ISSELECTIONCOLUMN><![CDATA[N]]></ISSELECTIONCOLUMN>
+<!--9C8C523F49E2BD9DE040007F0100646F-->
<AD_ELEMENT_ID><![CDATA[9C8C523F49F4BD9DE040007F0100646F]]></AD_ELEMENT_ID>
+<!--9C8C523F49E2BD9DE040007F0100646F-->
<ISSESSIONATTR><![CDATA[N]]></ISSESSIONATTR>
+<!--9C8C523F49E2BD9DE040007F0100646F-->
<ISSECONDARYKEY><![CDATA[N]]></ISSECONDARYKEY>
+<!--9C8C523F49E2BD9DE040007F0100646F-->
<ISDESENCRYPTABLE><![CDATA[N]]></ISDESENCRYPTABLE>
+<!--9C8C523F49E2BD9DE040007F0100646F-->
<DEVELOPMENTSTATUS><![CDATA[RE]]></DEVELOPMENTSTATUS>
+<!--9C8C523F49E2BD9DE040007F0100646F-->
<AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
+<!--9C8C523F49E2BD9DE040007F0100646F--> <POSITION><![CDATA[1]]></POSITION>
+<!--9C8C523F49E2BD9DE040007F0100646F-->
<ISTRANSIENT><![CDATA[N]]></ISTRANSIENT>
+<!--9C8C523F49E2BD9DE040007F0100646F--> <ISAUTOSAVE><![CDATA[Y]]></ISAUTOSAVE>
+<!--9C8C523F49E2BD9DE040007F0100646F-->
<VALIDATEONNEW><![CDATA[Y]]></VALIDATEONNEW>
+<!--9C8C523F49E2BD9DE040007F0100646F--></AD_COLUMN>
+
+<!--9C8C523F49E3BD9DE040007F0100646F--><AD_COLUMN>
+<!--9C8C523F49E3BD9DE040007F0100646F-->
<AD_COLUMN_ID><![CDATA[9C8C523F49E3BD9DE040007F0100646F]]></AD_COLUMN_ID>
+<!--9C8C523F49E3BD9DE040007F0100646F-->
<AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--9C8C523F49E3BD9DE040007F0100646F--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--9C8C523F49E3BD9DE040007F0100646F--> <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--9C8C523F49E3BD9DE040007F0100646F--> <NAME><![CDATA[Client]]></NAME>
+<!--9C8C523F49E3BD9DE040007F0100646F--> <DESCRIPTION><![CDATA[Client for this
installation.]]></DESCRIPTION>
+<!--9C8C523F49E3BD9DE040007F0100646F--> <HELP><![CDATA[A Client is a company
or a legal entity. You cannot share data between Clients.]]></HELP>
+<!--9C8C523F49E3BD9DE040007F0100646F-->
<COLUMNNAME><![CDATA[AD_Client_ID]]></COLUMNNAME>
+<!--9C8C523F49E3BD9DE040007F0100646F-->
<AD_TABLE_ID><![CDATA[FF8080812E381D1E012E3898C5DD0010]]></AD_TABLE_ID>
+<!--9C8C523F49E3BD9DE040007F0100646F-->
<AD_REFERENCE_ID><![CDATA[19]]></AD_REFERENCE_ID>
+<!--9C8C523F49E3BD9DE040007F0100646F-->
<FIELDLENGTH><![CDATA[32]]></FIELDLENGTH>
+<!--9C8C523F49E3BD9DE040007F0100646F-->
<DEFAULTVALUE><![CDATA[@AD_CLIENT_ID@]]></DEFAULTVALUE>
+<!--9C8C523F49E3BD9DE040007F0100646F--> <ISKEY><![CDATA[N]]></ISKEY>
+<!--9C8C523F49E3BD9DE040007F0100646F--> <ISPARENT><![CDATA[N]]></ISPARENT>
+<!--9C8C523F49E3BD9DE040007F0100646F-->
<ISMANDATORY><![CDATA[N]]></ISMANDATORY>
+<!--9C8C523F49E3BD9DE040007F0100646F-->
<ISUPDATEABLE><![CDATA[N]]></ISUPDATEABLE>
+<!--9C8C523F49E3BD9DE040007F0100646F-->
<ISIDENTIFIER><![CDATA[N]]></ISIDENTIFIER>
+<!--9C8C523F49E3BD9DE040007F0100646F--> <SEQNO><![CDATA[20]]></SEQNO>
+<!--9C8C523F49E3BD9DE040007F0100646F-->
<ISTRANSLATED><![CDATA[N]]></ISTRANSLATED>
+<!--9C8C523F49E3BD9DE040007F0100646F-->
<ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
+<!--9C8C523F49E3BD9DE040007F0100646F-->
<ISSELECTIONCOLUMN><![CDATA[N]]></ISSELECTIONCOLUMN>
+<!--9C8C523F49E3BD9DE040007F0100646F-->
<AD_ELEMENT_ID><![CDATA[102]]></AD_ELEMENT_ID>
+<!--9C8C523F49E3BD9DE040007F0100646F-->
<ISSESSIONATTR><![CDATA[Y]]></ISSESSIONATTR>
+<!--9C8C523F49E3BD9DE040007F0100646F-->
<ISSECONDARYKEY><![CDATA[N]]></ISSECONDARYKEY>
+<!--9C8C523F49E3BD9DE040007F0100646F-->
<ISDESENCRYPTABLE><![CDATA[N]]></ISDESENCRYPTABLE>
+<!--9C8C523F49E3BD9DE040007F0100646F-->
<DEVELOPMENTSTATUS><![CDATA[RE]]></DEVELOPMENTSTATUS>
+<!--9C8C523F49E3BD9DE040007F0100646F-->
<AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
+<!--9C8C523F49E3BD9DE040007F0100646F--> <POSITION><![CDATA[2]]></POSITION>
+<!--9C8C523F49E3BD9DE040007F0100646F-->
<ISTRANSIENT><![CDATA[N]]></ISTRANSIENT>
+<!--9C8C523F49E3BD9DE040007F0100646F--> <ISAUTOSAVE><![CDATA[Y]]></ISAUTOSAVE>
+<!--9C8C523F49E3BD9DE040007F0100646F-->
<VALIDATEONNEW><![CDATA[Y]]></VALIDATEONNEW>
+<!--9C8C523F49E3BD9DE040007F0100646F--></AD_COLUMN>
+
+<!--9C8C523F49E4BD9DE040007F0100646F--><AD_COLUMN>
+<!--9C8C523F49E4BD9DE040007F0100646F-->
<AD_COLUMN_ID><![CDATA[9C8C523F49E4BD9DE040007F0100646F]]></AD_COLUMN_ID>
+<!--9C8C523F49E4BD9DE040007F0100646F-->
<AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--9C8C523F49E4BD9DE040007F0100646F--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--9C8C523F49E4BD9DE040007F0100646F--> <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--9C8C523F49E4BD9DE040007F0100646F--> <NAME><![CDATA[Organization]]></NAME>
+<!--9C8C523F49E4BD9DE040007F0100646F--> <DESCRIPTION><![CDATA[Organizational
entity within client]]></DESCRIPTION>
+<!--9C8C523F49E4BD9DE040007F0100646F--> <HELP><![CDATA[An organization is a
unit of your client or legal entity - examples are store, department. You can
share data between organizations.]]></HELP>
+<!--9C8C523F49E4BD9DE040007F0100646F-->
<COLUMNNAME><![CDATA[AD_Org_ID]]></COLUMNNAME>
+<!--9C8C523F49E4BD9DE040007F0100646F-->
<AD_TABLE_ID><![CDATA[FF8080812E381D1E012E3898C5DD0010]]></AD_TABLE_ID>
+<!--9C8C523F49E4BD9DE040007F0100646F-->
<AD_REFERENCE_ID><![CDATA[19]]></AD_REFERENCE_ID>
+<!--9C8C523F49E4BD9DE040007F0100646F-->
<FIELDLENGTH><![CDATA[32]]></FIELDLENGTH>
+<!--9C8C523F49E4BD9DE040007F0100646F-->
<DEFAULTVALUE><![CDATA[@AD_ORG_ID@]]></DEFAULTVALUE>
+<!--9C8C523F49E4BD9DE040007F0100646F--> <ISKEY><![CDATA[N]]></ISKEY>
+<!--9C8C523F49E4BD9DE040007F0100646F--> <ISPARENT><![CDATA[N]]></ISPARENT>
+<!--9C8C523F49E4BD9DE040007F0100646F-->
<ISMANDATORY><![CDATA[N]]></ISMANDATORY>
+<!--9C8C523F49E4BD9DE040007F0100646F-->
<ISUPDATEABLE><![CDATA[N]]></ISUPDATEABLE>
+<!--9C8C523F49E4BD9DE040007F0100646F-->
<ISIDENTIFIER><![CDATA[N]]></ISIDENTIFIER>
+<!--9C8C523F49E4BD9DE040007F0100646F--> <SEQNO><![CDATA[30]]></SEQNO>
+<!--9C8C523F49E4BD9DE040007F0100646F-->
<ISTRANSLATED><![CDATA[N]]></ISTRANSLATED>
+<!--9C8C523F49E4BD9DE040007F0100646F-->
<ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
+<!--9C8C523F49E4BD9DE040007F0100646F-->
<ISSELECTIONCOLUMN><![CDATA[N]]></ISSELECTIONCOLUMN>
+<!--9C8C523F49E4BD9DE040007F0100646F-->
<AD_ELEMENT_ID><![CDATA[113]]></AD_ELEMENT_ID>
+<!--9C8C523F49E4BD9DE040007F0100646F-->
<ISSESSIONATTR><![CDATA[Y]]></ISSESSIONATTR>
+<!--9C8C523F49E4BD9DE040007F0100646F-->
<ISSECONDARYKEY><![CDATA[N]]></ISSECONDARYKEY>
+<!--9C8C523F49E4BD9DE040007F0100646F-->
<ISDESENCRYPTABLE><![CDATA[N]]></ISDESENCRYPTABLE>
+<!--9C8C523F49E4BD9DE040007F0100646F-->
<DEVELOPMENTSTATUS><![CDATA[RE]]></DEVELOPMENTSTATUS>
+<!--9C8C523F49E4BD9DE040007F0100646F-->
<AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
+<!--9C8C523F49E4BD9DE040007F0100646F--> <POSITION><![CDATA[3]]></POSITION>
+<!--9C8C523F49E4BD9DE040007F0100646F-->
<ISTRANSIENT><![CDATA[N]]></ISTRANSIENT>
+<!--9C8C523F49E4BD9DE040007F0100646F--> <ISAUTOSAVE><![CDATA[Y]]></ISAUTOSAVE>
+<!--9C8C523F49E4BD9DE040007F0100646F-->
<VALIDATEONNEW><![CDATA[Y]]></VALIDATEONNEW>
+<!--9C8C523F49E4BD9DE040007F0100646F--></AD_COLUMN>
+
+<!--9C8C523F49E5BD9DE040007F0100646F--><AD_COLUMN>
+<!--9C8C523F49E5BD9DE040007F0100646F-->
<AD_COLUMN_ID><![CDATA[9C8C523F49E5BD9DE040007F0100646F]]></AD_COLUMN_ID>
+<!--9C8C523F49E5BD9DE040007F0100646F-->
<AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--9C8C523F49E5BD9DE040007F0100646F--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--9C8C523F49E5BD9DE040007F0100646F--> <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--9C8C523F49E5BD9DE040007F0100646F--> <NAME><![CDATA[Active]]></NAME>
+<!--9C8C523F49E5BD9DE040007F0100646F--> <DESCRIPTION><![CDATA[A flag
indicating whether this record is available for use or
de-activated.]]></DESCRIPTION>
+<!--9C8C523F49E5BD9DE040007F0100646F--> <HELP><![CDATA[There are two methods
of making records unavailable in the system: One is to delete the record, the
other is to de-activate the record. A de-activated record is not available for
selection, but available for reporting. There are two reasons for de-activating
and not deleting records:
+(1) The system requires the record for auditing purposes.
+(2) The record is referenced by other records. E.g., you cannot delete a
Business Partner, if there are existing invoices for it. By de-activating the
Business Partner you prevent it from being used in future
transactions.]]></HELP>
+<!--9C8C523F49E5BD9DE040007F0100646F-->
<COLUMNNAME><![CDATA[Isactive]]></COLUMNNAME>
+<!--9C8C523F49E5BD9DE040007F0100646F-->
<AD_TABLE_ID><![CDATA[FF8080812E381D1E012E3898C5DD0010]]></AD_TABLE_ID>
+<!--9C8C523F49E5BD9DE040007F0100646F-->
<AD_REFERENCE_ID><![CDATA[20]]></AD_REFERENCE_ID>
+<!--9C8C523F49E5BD9DE040007F0100646F-->
<FIELDLENGTH><![CDATA[1]]></FIELDLENGTH>
+<!--9C8C523F49E5BD9DE040007F0100646F--> <ISKEY><![CDATA[N]]></ISKEY>
+<!--9C8C523F49E5BD9DE040007F0100646F--> <ISPARENT><![CDATA[N]]></ISPARENT>
+<!--9C8C523F49E5BD9DE040007F0100646F-->
<ISMANDATORY><![CDATA[N]]></ISMANDATORY>
+<!--9C8C523F49E5BD9DE040007F0100646F-->
<ISUPDATEABLE><![CDATA[Y]]></ISUPDATEABLE>
+<!--9C8C523F49E5BD9DE040007F0100646F-->
<ISIDENTIFIER><![CDATA[N]]></ISIDENTIFIER>
+<!--9C8C523F49E5BD9DE040007F0100646F--> <SEQNO><![CDATA[40]]></SEQNO>
+<!--9C8C523F49E5BD9DE040007F0100646F-->
<ISTRANSLATED><![CDATA[N]]></ISTRANSLATED>
+<!--9C8C523F49E5BD9DE040007F0100646F-->
<ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
+<!--9C8C523F49E5BD9DE040007F0100646F-->
<ISSELECTIONCOLUMN><![CDATA[N]]></ISSELECTIONCOLUMN>
+<!--9C8C523F49E5BD9DE040007F0100646F-->
<AD_ELEMENT_ID><![CDATA[348]]></AD_ELEMENT_ID>
+<!--9C8C523F49E5BD9DE040007F0100646F-->
<ISSESSIONATTR><![CDATA[N]]></ISSESSIONATTR>
+<!--9C8C523F49E5BD9DE040007F0100646F-->
<ISSECONDARYKEY><![CDATA[N]]></ISSECONDARYKEY>
+<!--9C8C523F49E5BD9DE040007F0100646F-->
<ISDESENCRYPTABLE><![CDATA[N]]></ISDESENCRYPTABLE>
+<!--9C8C523F49E5BD9DE040007F0100646F-->
<DEVELOPMENTSTATUS><![CDATA[RE]]></DEVELOPMENTSTATUS>
+<!--9C8C523F49E5BD9DE040007F0100646F-->
<AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
+<!--9C8C523F49E5BD9DE040007F0100646F--> <POSITION><![CDATA[4]]></POSITION>
+<!--9C8C523F49E5BD9DE040007F0100646F-->
<ISTRANSIENT><![CDATA[N]]></ISTRANSIENT>
+<!--9C8C523F49E5BD9DE040007F0100646F--> <ISAUTOSAVE><![CDATA[Y]]></ISAUTOSAVE>
+<!--9C8C523F49E5BD9DE040007F0100646F-->
<VALIDATEONNEW><![CDATA[Y]]></VALIDATEONNEW>
+<!--9C8C523F49E5BD9DE040007F0100646F--></AD_COLUMN>
+
+<!--9C8C523F49E6BD9DE040007F0100646F--><AD_COLUMN>
+<!--9C8C523F49E6BD9DE040007F0100646F-->
<AD_COLUMN_ID><![CDATA[9C8C523F49E6BD9DE040007F0100646F]]></AD_COLUMN_ID>
+<!--9C8C523F49E6BD9DE040007F0100646F-->
<AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--9C8C523F49E6BD9DE040007F0100646F--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--9C8C523F49E6BD9DE040007F0100646F--> <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--9C8C523F49E6BD9DE040007F0100646F--> <NAME><![CDATA[Creation Date]]></NAME>
+<!--9C8C523F49E6BD9DE040007F0100646F--> <DESCRIPTION><![CDATA[The date that
this record is completed.]]></DESCRIPTION>
+<!--9C8C523F49E6BD9DE040007F0100646F--> <HELP><![CDATA[The Created field
indicates the date that this record was created.]]></HELP>
+<!--9C8C523F49E6BD9DE040007F0100646F-->
<COLUMNNAME><![CDATA[Created]]></COLUMNNAME>
+<!--9C8C523F49E6BD9DE040007F0100646F-->
<AD_TABLE_ID><![CDATA[FF8080812E381D1E012E3898C5DD0010]]></AD_TABLE_ID>
+<!--9C8C523F49E6BD9DE040007F0100646F-->
<AD_REFERENCE_ID><![CDATA[16]]></AD_REFERENCE_ID>
+<!--9C8C523F49E6BD9DE040007F0100646F-->
<FIELDLENGTH><![CDATA[19]]></FIELDLENGTH>
+<!--9C8C523F49E6BD9DE040007F0100646F--> <ISKEY><![CDATA[N]]></ISKEY>
+<!--9C8C523F49E6BD9DE040007F0100646F--> <ISPARENT><![CDATA[N]]></ISPARENT>
+<!--9C8C523F49E6BD9DE040007F0100646F-->
<ISMANDATORY><![CDATA[N]]></ISMANDATORY>
+<!--9C8C523F49E6BD9DE040007F0100646F-->
<ISUPDATEABLE><![CDATA[N]]></ISUPDATEABLE>
+<!--9C8C523F49E6BD9DE040007F0100646F-->
<ISIDENTIFIER><![CDATA[N]]></ISIDENTIFIER>
+<!--9C8C523F49E6BD9DE040007F0100646F--> <SEQNO><![CDATA[50]]></SEQNO>
+<!--9C8C523F49E6BD9DE040007F0100646F-->
<ISTRANSLATED><![CDATA[N]]></ISTRANSLATED>
+<!--9C8C523F49E6BD9DE040007F0100646F-->
<ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
+<!--9C8C523F49E6BD9DE040007F0100646F-->
<ISSELECTIONCOLUMN><![CDATA[N]]></ISSELECTIONCOLUMN>
+<!--9C8C523F49E6BD9DE040007F0100646F-->
<AD_ELEMENT_ID><![CDATA[245]]></AD_ELEMENT_ID>
+<!--9C8C523F49E6BD9DE040007F0100646F-->
<ISSESSIONATTR><![CDATA[N]]></ISSESSIONATTR>
+<!--9C8C523F49E6BD9DE040007F0100646F-->
<ISSECONDARYKEY><![CDATA[N]]></ISSECONDARYKEY>
+<!--9C8C523F49E6BD9DE040007F0100646F-->
<ISDESENCRYPTABLE><![CDATA[N]]></ISDESENCRYPTABLE>
+<!--9C8C523F49E6BD9DE040007F0100646F-->
<DEVELOPMENTSTATUS><![CDATA[RE]]></DEVELOPMENTSTATUS>
+<!--9C8C523F49E6BD9DE040007F0100646F-->
<AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
+<!--9C8C523F49E6BD9DE040007F0100646F--> <POSITION><![CDATA[5]]></POSITION>
+<!--9C8C523F49E6BD9DE040007F0100646F-->
<ISTRANSIENT><![CDATA[N]]></ISTRANSIENT>
+<!--9C8C523F49E6BD9DE040007F0100646F--> <ISAUTOSAVE><![CDATA[Y]]></ISAUTOSAVE>
+<!--9C8C523F49E6BD9DE040007F0100646F-->
<VALIDATEONNEW><![CDATA[Y]]></VALIDATEONNEW>
+<!--9C8C523F49E6BD9DE040007F0100646F--></AD_COLUMN>
+
+<!--9C8C523F49E7BD9DE040007F0100646F--><AD_COLUMN>
+<!--9C8C523F49E7BD9DE040007F0100646F-->
<AD_COLUMN_ID><![CDATA[9C8C523F49E7BD9DE040007F0100646F]]></AD_COLUMN_ID>
+<!--9C8C523F49E7BD9DE040007F0100646F-->
<AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--9C8C523F49E7BD9DE040007F0100646F--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--9C8C523F49E7BD9DE040007F0100646F--> <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--9C8C523F49E7BD9DE040007F0100646F--> <NAME><![CDATA[Created By]]></NAME>
+<!--9C8C523F49E7BD9DE040007F0100646F--> <DESCRIPTION><![CDATA[User who
created this records]]></DESCRIPTION>
+<!--9C8C523F49E7BD9DE040007F0100646F--> <HELP><![CDATA[The Created By field
indicates the user who created this record.]]></HELP>
+<!--9C8C523F49E7BD9DE040007F0100646F-->
<COLUMNNAME><![CDATA[Createdby]]></COLUMNNAME>
+<!--9C8C523F49E7BD9DE040007F0100646F-->
<AD_TABLE_ID><![CDATA[FF8080812E381D1E012E3898C5DD0010]]></AD_TABLE_ID>
+<!--9C8C523F49E7BD9DE040007F0100646F-->
<AD_REFERENCE_ID><![CDATA[30]]></AD_REFERENCE_ID>
+<!--9C8C523F49E7BD9DE040007F0100646F-->
<FIELDLENGTH><![CDATA[32]]></FIELDLENGTH>
+<!--9C8C523F49E7BD9DE040007F0100646F--> <ISKEY><![CDATA[N]]></ISKEY>
+<!--9C8C523F49E7BD9DE040007F0100646F--> <ISPARENT><![CDATA[N]]></ISPARENT>
+<!--9C8C523F49E7BD9DE040007F0100646F-->
<ISMANDATORY><![CDATA[N]]></ISMANDATORY>
+<!--9C8C523F49E7BD9DE040007F0100646F-->
<ISUPDATEABLE><![CDATA[N]]></ISUPDATEABLE>
+<!--9C8C523F49E7BD9DE040007F0100646F-->
<ISIDENTIFIER><![CDATA[N]]></ISIDENTIFIER>
+<!--9C8C523F49E7BD9DE040007F0100646F--> <SEQNO><![CDATA[60]]></SEQNO>
+<!--9C8C523F49E7BD9DE040007F0100646F-->
<ISTRANSLATED><![CDATA[N]]></ISTRANSLATED>
+<!--9C8C523F49E7BD9DE040007F0100646F-->
<ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
+<!--9C8C523F49E7BD9DE040007F0100646F-->
<ISSELECTIONCOLUMN><![CDATA[N]]></ISSELECTIONCOLUMN>
+<!--9C8C523F49E7BD9DE040007F0100646F-->
<AD_ELEMENT_ID><![CDATA[246]]></AD_ELEMENT_ID>
+<!--9C8C523F49E7BD9DE040007F0100646F-->
<ISSESSIONATTR><![CDATA[N]]></ISSESSIONATTR>
+<!--9C8C523F49E7BD9DE040007F0100646F-->
<ISSECONDARYKEY><![CDATA[N]]></ISSECONDARYKEY>
+<!--9C8C523F49E7BD9DE040007F0100646F-->
<ISDESENCRYPTABLE><![CDATA[N]]></ISDESENCRYPTABLE>
+<!--9C8C523F49E7BD9DE040007F0100646F-->
<DEVELOPMENTSTATUS><![CDATA[RE]]></DEVELOPMENTSTATUS>
+<!--9C8C523F49E7BD9DE040007F0100646F-->
<AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
+<!--9C8C523F49E7BD9DE040007F0100646F--> <POSITION><![CDATA[6]]></POSITION>
+<!--9C8C523F49E7BD9DE040007F0100646F-->
<ISTRANSIENT><![CDATA[N]]></ISTRANSIENT>
+<!--9C8C523F49E7BD9DE040007F0100646F--> <ISAUTOSAVE><![CDATA[Y]]></ISAUTOSAVE>
+<!--9C8C523F49E7BD9DE040007F0100646F-->
<VALIDATEONNEW><![CDATA[Y]]></VALIDATEONNEW>
+<!--9C8C523F49E7BD9DE040007F0100646F--></AD_COLUMN>
+
+<!--9C8C523F49E8BD9DE040007F0100646F--><AD_COLUMN>
+<!--9C8C523F49E8BD9DE040007F0100646F-->
<AD_COLUMN_ID><![CDATA[9C8C523F49E8BD9DE040007F0100646F]]></AD_COLUMN_ID>
+<!--9C8C523F49E8BD9DE040007F0100646F-->
<AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--9C8C523F49E8BD9DE040007F0100646F--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--9C8C523F49E8BD9DE040007F0100646F--> <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--9C8C523F49E8BD9DE040007F0100646F--> <NAME><![CDATA[Updated]]></NAME>
+<!--9C8C523F49E8BD9DE040007F0100646F--> <DESCRIPTION><![CDATA[x not
implemented]]></DESCRIPTION>
+<!--9C8C523F49E8BD9DE040007F0100646F--> <HELP><![CDATA[The Updated field
indicates the date that this record was updated.]]></HELP>
+<!--9C8C523F49E8BD9DE040007F0100646F-->
<COLUMNNAME><![CDATA[Updated]]></COLUMNNAME>
+<!--9C8C523F49E8BD9DE040007F0100646F-->
<AD_TABLE_ID><![CDATA[FF8080812E381D1E012E3898C5DD0010]]></AD_TABLE_ID>
+<!--9C8C523F49E8BD9DE040007F0100646F-->
<AD_REFERENCE_ID><![CDATA[16]]></AD_REFERENCE_ID>
+<!--9C8C523F49E8BD9DE040007F0100646F-->
<FIELDLENGTH><![CDATA[19]]></FIELDLENGTH>
+<!--9C8C523F49E8BD9DE040007F0100646F--> <ISKEY><![CDATA[N]]></ISKEY>
+<!--9C8C523F49E8BD9DE040007F0100646F--> <ISPARENT><![CDATA[N]]></ISPARENT>
+<!--9C8C523F49E8BD9DE040007F0100646F-->
<ISMANDATORY><![CDATA[N]]></ISMANDATORY>
+<!--9C8C523F49E8BD9DE040007F0100646F-->
<ISUPDATEABLE><![CDATA[N]]></ISUPDATEABLE>
+<!--9C8C523F49E8BD9DE040007F0100646F-->
<ISIDENTIFIER><![CDATA[N]]></ISIDENTIFIER>
+<!--9C8C523F49E8BD9DE040007F0100646F--> <SEQNO><![CDATA[70]]></SEQNO>
+<!--9C8C523F49E8BD9DE040007F0100646F-->
<ISTRANSLATED><![CDATA[N]]></ISTRANSLATED>
+<!--9C8C523F49E8BD9DE040007F0100646F-->
<ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
+<!--9C8C523F49E8BD9DE040007F0100646F-->
<ISSELECTIONCOLUMN><![CDATA[N]]></ISSELECTIONCOLUMN>
+<!--9C8C523F49E8BD9DE040007F0100646F-->
<AD_ELEMENT_ID><![CDATA[607]]></AD_ELEMENT_ID>
+<!--9C8C523F49E8BD9DE040007F0100646F-->
<ISSESSIONATTR><![CDATA[N]]></ISSESSIONATTR>
+<!--9C8C523F49E8BD9DE040007F0100646F-->
<ISSECONDARYKEY><![CDATA[N]]></ISSECONDARYKEY>
+<!--9C8C523F49E8BD9DE040007F0100646F-->
<ISDESENCRYPTABLE><![CDATA[N]]></ISDESENCRYPTABLE>
+<!--9C8C523F49E8BD9DE040007F0100646F-->
<DEVELOPMENTSTATUS><![CDATA[RE]]></DEVELOPMENTSTATUS>
+<!--9C8C523F49E8BD9DE040007F0100646F-->
<AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
+<!--9C8C523F49E8BD9DE040007F0100646F--> <POSITION><![CDATA[7]]></POSITION>
+<!--9C8C523F49E8BD9DE040007F0100646F-->
<ISTRANSIENT><![CDATA[N]]></ISTRANSIENT>
+<!--9C8C523F49E8BD9DE040007F0100646F--> <ISAUTOSAVE><![CDATA[Y]]></ISAUTOSAVE>
+<!--9C8C523F49E8BD9DE040007F0100646F-->
<VALIDATEONNEW><![CDATA[Y]]></VALIDATEONNEW>
+<!--9C8C523F49E8BD9DE040007F0100646F--></AD_COLUMN>
+
+<!--9C8C523F49E9BD9DE040007F0100646F--><AD_COLUMN>
+<!--9C8C523F49E9BD9DE040007F0100646F-->
<AD_COLUMN_ID><![CDATA[9C8C523F49E9BD9DE040007F0100646F]]></AD_COLUMN_ID>
+<!--9C8C523F49E9BD9DE040007F0100646F-->
<AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
------------------------------------------------------------------------------
The ultimate all-in-one performance toolkit: Intel(R) Parallel Studio XE:
Pinpoint memory and threading errors before they happen.
Find and fix more than 250 security defects in the development cycle.
Locate bottlenecks in serial and parallel code that limit performance.
http://p.sf.net/sfu/intel-dev2devfeb
_______________________________________________
Openbravo-commits mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/openbravo-commits
