details: https://code.openbravo.com/erp/stable/2.50/rev/7bb02ce6de6b changeset: 9665:7bb02ce6de6b user: Mikel Irurita <mikel.irurita <at> openbravo.com> date: Wed Sep 21 12:45:26 2011 +0200 summary: Fixes issue 18576: Transaction of GL Item cannot be posted due to a NPE error
details: https://code.openbravo.com/erp/stable/2.50/rev/51d71cdef581 changeset: 9666:51d71cdef581 user: Mikel Irurita <mikel.irurita <at> openbravo.com> date: Tue Sep 20 16:21:44 2011 +0200 summary: Fixes issue 18568: Posting financial invoice - Process Failed during execution. It was not raised before, because it happens only if the client has more than one accounting schema. details: https://code.openbravo.com/erp/stable/2.50/rev/cdd318fcfcc9 changeset: 9667:cdd318fcfcc9 user: Mikel Irurita <mikel.irurita <at> openbravo.com> date: Tue Sep 20 19:55:22 2011 +0200 summary: Related to issue 18568: improve message to InvalidAccount details: https://code.openbravo.com/erp/stable/2.50/rev/ff191193ed8a changeset: 9668:ff191193ed8a user: Jon AlegrÃa <jon.alegria <at> openbravo.com> date: Thu Sep 22 12:34:47 2011 +0200 summary: Fixes issue 0018589: Amortizations can not be posted details: https://code.openbravo.com/erp/stable/2.50/rev/296d9b0ddb4a changeset: 9669:296d9b0ddb4a user: RM packaging bot <staff.rm <at> openbravo.com> date: Wed Sep 28 07:30:42 2011 +0000 summary: Update AD_MODULE version to 2.50MP33.1 details: https://code.openbravo.com/erp/stable/2.50/rev/20fe8cfa9a24 changeset: 9670:20fe8cfa9a24 user: RM packaging bot <staff.rm <at> openbravo.com> date: Wed Sep 28 07:30:43 2011 +0000 summary: Added tag 2.50MP33.1 for changeset 296d9b0ddb4a details: https://code.openbravo.com/erp/stable/2.50/rev/51ff7f741d17 changeset: 9671:51ff7f741d17 user: RM packaging bot <staff.rm <at> openbravo.com> date: Wed Sep 28 07:30:44 2011 +0000 summary: Added signature for changeset 20fe8cfa9a24 details: https://code.openbravo.com/erp/stable/2.50/rev/cafacaed4992 changeset: 9672:cafacaed4992 user: RM packaging bot <staff.rm <at> openbravo.com> date: Fri Sep 30 09:31:30 2011 +0000 summary: Merge temporary head for 2.50MP33.1 diffstat: .hgsigs | 2 + .hgtags | 2 + src-db/database/model/functions/AD_LANGUAGE_CREATE.xml | 41 + src-db/database/model/functions/C_BANKSTATEMENT_POST.xml | 2 +- src-db/database/model/functions/C_GETTAX.xml | 17 +- src-db/database/model/functions/M_GENERATE_AVERAGE_COSTS.xml | 16 +- src-db/database/model/functions/M_INVENTORY_LISTCREATE.xml | 5 +- src-db/database/model/tables/AD_ORG.xml | 4 + src-db/database/model/tables/FIN_PAYMENT_SCHEDULEDETAIL.xml | 42 + src-db/database/model/views/FIN_PAYMENT_DETAIL_V.xml | 2 +- src-db/database/sourcedata/AD_CALLOUT.xml | 11 + src-db/database/sourcedata/AD_COLUMN.xml | 434 ++++++++++ src-db/database/sourcedata/AD_ELEMENT.xml | 13 + src-db/database/sourcedata/AD_FIELD.xml | 343 +++++++- src-db/database/sourcedata/AD_MODEL_OBJECT.xml | 12 + src-db/database/sourcedata/AD_MODEL_OBJECT_MAPPING.xml | 10 + src-db/database/sourcedata/AD_VAL_RULE.xml | 2 +- src-db/database/sourcedata/referencedData/GL_CATEGORY.xml | 2 +- src/org/openbravo/erpCommon/ad_actionButton/CreateFrom.java | 22 +- src/org/openbravo/erpCommon/ad_actionButton/CreateFrom_Invoice_data.xsql | 40 +- src/org/openbravo/erpCommon/ad_actionButton/CreateFrom_Shipment_data.xsql | 43 +- src/org/openbravo/erpCommon/ad_callouts/SL_Product_Type.java | 82 + src/org/openbravo/erpCommon/ad_forms/AcctServer.java | 3 +- src/org/openbravo/erpCommon/ad_forms/DocFINFinAccTransaction.java | 28 +- src/org/openbravo/erpCommon/ad_forms/DocFINPayment.java | 25 +- src/org/openbravo/erpCommon/ad_forms/DocFINReconciliation.java | 29 +- src/org/openbravo/erpCommon/ad_forms/DocInvoice.java | 27 +- src/org/openbravo/erpCommon/ad_forms/DocInvoice_data.xsql | 21 +- src/org/openbravo/erpCommon/ad_process/PaymentMonitor.java | 57 +- src/org/openbravo/erpCommon/info/PriceListVersionCombo_data.xsql | 3 + src/org/openbravo/erpCommon/info/Product.java | 9 +- src/org/openbravo/erpCommon/utility/TableSQLData.java | 31 +- src/org/openbravo/service/system/DatabaseValidator.java | 1 + web/js/utils.js | 15 + 34 files changed, 1271 insertions(+), 125 deletions(-) diffs (truncated from 2499 to 300 lines): diff -r e93ba1aedda5 -r cafacaed4992 .hgsigs --- a/.hgsigs Tue Aug 23 11:39:32 2011 +0000 +++ b/.hgsigs Fri Sep 30 09:31:30 2011 +0000 @@ -37,3 +37,5 @@ 2cfa03023503ef72a8c4838cdb763e2cbd707893 0 iEYEABECAAYFAk3c2n4ACgkQCX/oGf+2qkO6GACg7qrg2WS8mGIH5hebESW1aoOmHMcAoP7wTmjIzUxn7w3ZRihDuh5xQLzK 9b6869b8aa4b3b9dbe9d6a855f0e491e793cbf65 0 iEYEABECAAYFAk4JrfQACgkQCX/oGf+2qkOXNgCgjKVRMwPIH8rNg+RhUOfOIVeXVqAAoPrpGfR5GWFTQYdS1GLiKHzwrast 7a39f190aa71c8a85f7169168d4aa0e801098552 0 iEYEABECAAYFAk4nC6sACgkQCX/oGf+2qkP2ZQCgr0q0gYORA+jaHs9NkN2WjTQaPggAoOEdeIag9ShKvgefCFS2sJDY8QE6 +3a53c020c489f275786cd4165e75ddd19733586c 0 iEYEABECAAYFAk5TkXUACgkQCX/oGf+2qkPy+ACg92VQoXKkAYKwPFwG2Bl8BB1gdFIAoIWQdXv0GpuWFuCU+f9WYuzfXmJu +20fe8cfa9a24b93dd34f911a7fdd33d3842baab0 0 iEYEABECAAYFAk6CzSMACgkQCX/oGf+2qkOenwCePCfELHUfdP+u+MO39s+Go/Kc0zoAn3HOxpgf/+FSX9G31IBRp6gyijTP diff -r e93ba1aedda5 -r cafacaed4992 .hgtags --- a/.hgtags Tue Aug 23 11:39:32 2011 +0000 +++ b/.hgtags Fri Sep 30 09:31:30 2011 +0000 @@ -48,3 +48,5 @@ d467781fb9a6174eece3684b52c186bbf0c2651e 2.50MP30 845811ab032b0e0039533be91c1e31f33d848364 2.50MP31 b0b55f934a82d1bf3e0ad93100f622dbfa489fcb 2.50MP32 +e93ba1aedda500859c1647b79b4e0065bebc0bb4 2.50MP33 +296d9b0ddb4a0a3b0f7b5c9fab7968b631b1ce19 2.50MP33.1 diff -r e93ba1aedda5 -r cafacaed4992 src-db/database/model/functions/AD_LANGUAGE_CREATE.xml --- a/src-db/database/model/functions/AD_LANGUAGE_CREATE.xml Tue Aug 23 11:39:32 2011 +0000 +++ b/src-db/database/model/functions/AD_LANGUAGE_CREATE.xml Fri Sep 30 09:31:30 2011 +0000 @@ -125,6 +125,47 @@ v_Created:=v_Created + v_rowcount; DBMS_OUTPUT.PUT_LINE('- AD_FieldGroup ' || v_rowcount) ; -- Field + -- First field_trls are created from the element_trls + INSERT + INTO AD_Field_Trl + ( + AD_Field_Trl_ID, AD_Field_ID, AD_Language, Name, Description, Help, IsTranslated, Createdby, UpdatedBy, AD_Client_ID, AD_Org_ID + ) + SELECT get_uuid(), AD_Field_ID, AD_Language.AD_Language, trl.Name, trl.Description, trl.Help, 'N', '0', '0', '0','0' + FROM AD_Field, AD_Language, AD_Module M, ad_column c + left join ad_element_trl trl + on trl.ad_element_id=c.ad_element_id + WHERE AD_Language.IsActive='Y' + and AD_Field.iscentrallymaintained='Y' + AND AD_Field.AD_Module_ID = M.AD_Module_ID + AND M.AD_Language != AD_Language.AD_Language + AND AD_Language.IsSystemLanguage='Y' + and c.ad_column_id=AD_Field.ad_column_id + and trl.ad_language=AD_Language.AD_Language + AND NOT EXISTS (SELECT 1 FROM AD_Field_TRL + WHERE AD_Field_ID = AD_Field.AD_Field_ID + AND AD_LANGUAGE = AD_Language.AD_Language); + -- If there weren't element_trls, field_trls are created from elements + INSERT + INTO AD_Field_Trl + ( + AD_Field_Trl_ID, AD_Field_ID, AD_Language, Name, Description, Help, IsTranslated, Createdby, UpdatedBy, AD_Client_ID, AD_Org_ID + ) + SELECT get_uuid(), AD_Field_ID, AD_Language.AD_Language, e.Name, e.Description, e.Help, 'N', '0', '0', '0','0' + FROM AD_Field, AD_Language, AD_Module M, ad_column c,ad_element e, ad_module modEl + WHERE AD_Language.IsActive='Y' + and AD_Field.iscentrallymaintained='Y' + AND AD_Field.AD_Module_ID = M.AD_Module_ID + AND M.AD_Language != AD_Language.AD_Language + AND AD_Language.IsSystemLanguage='Y' + and c.ad_element_id=e.ad_element_id + and c.ad_column_id=AD_Field.ad_column_id + and modEl.ad_module_id=e.ad_module_id + and modEl.ad_language!=m.ad_language + AND NOT EXISTS (SELECT 1 FROM AD_Field_TRL + WHERE AD_Field_ID = AD_Field.AD_Field_ID + AND AD_LANGUAGE = AD_Language.AD_Language); + -- If there were no elements, or element_trls, data is copied from the ad_field itself INSERT INTO AD_Field_Trl ( diff -r e93ba1aedda5 -r cafacaed4992 src-db/database/model/functions/C_BANKSTATEMENT_POST.xml --- a/src-db/database/model/functions/C_BANKSTATEMENT_POST.xml Tue Aug 23 11:39:32 2011 +0000 +++ b/src-db/database/model/functions/C_BANKSTATEMENT_POST.xml Fri Sep 30 09:31:30 2011 +0000 @@ -407,7 +407,7 @@ C_Currency_Round(C_Currency_Convert( (CASE dp.IsReceipt WHEN 'Y' THEN -- If IsReceipt = N, amount*-1 (dp.Amount-coalesce(dp.WriteOffAmt,0)) ELSE(coalesce(dp.WriteOffAmt,0)-dp.Amount) - END), dp.C_Currency_ID, bsl.C_Currency_ID, bs.StatementDate, NULL, bs.AD_Client_ID, bs.AD_Org_ID),bsl.C_Currency_ID, null) + END), dp.C_Currency_ID, bsl.C_Currency_ID, bsl.ValutaDate, NULL, bs.AD_Client_ID, bs.AD_Org_ID),bsl.C_Currency_ID, null) <> C_Currency_Round(bsl.TrxAmt, bsl.C_Currency_ID, null); IF v_count>0 THEN RAISE_APPLICATION_ERROR(-20000, '@Inline@'||v_line||' '||'@DebtAmountsDifferentMoneyNoMatch@') ; diff -r e93ba1aedda5 -r cafacaed4992 src-db/database/model/functions/C_GETTAX.xml --- a/src-db/database/model/functions/C_GETTAX.xml Tue Aug 23 11:39:32 2011 +0000 +++ b/src-db/database/model/functions/C_GETTAX.xml Fri Sep 30 09:31:30 2011 +0000 @@ -171,13 +171,13 @@ (SELECT t.C_Tax_ID, '' AS billToC_Location_ID, '' AS IsTaxExempt FROM (SELECT C_Tax_ID, C_Country_ID, C_Region_ID, To_Country_Id, To_Region_ID, ValidFrom, C_TaxCategory_ID, - Parent_Tax_ID, C_BP_TaxCategory_ID, SoPoType + Parent_Tax_ID, C_BP_TaxCategory_ID, SoPoType, c_Tax.ad_org_id,c_Tax.ad_client_id FROM c_Tax WHERE c_Tax.isActive = 'Y' UNION SELECT tz.C_Tax_ID, tz.From_Country_ID, tz.From_Region_ID, tz.To_Country_ID, tz.To_Region_ID, ValidFrom, C_TaxCategory_ID, - Parent_Tax_Id, C_BP_TaxCategory_ID, ct.SoPoType + Parent_Tax_Id, C_BP_TaxCategory_ID, ct.SoPoType, ct.ad_org_id,ct.ad_client_id FROM c_Tax_Zone tz, c_Tax ct WHERE tz.C_Tax_ID = ct.C_Tax_ID @@ -194,10 +194,11 @@ AND(t.To_Country_ID = lt.C_Country_ID OR(t.To_Country_ID IS NULL)) AND(t.To_Region_ID = lt.C_Region_ID OR(t.To_Region_ID IS NULL)) AND t.ValidFrom <= p_shipDate + AND ad_isorgincluded(p_org_id, t.ad_org_id,t.ad_client_id) <> -1 -- AND ((t.C_BP_TaxCategory_ID = v_BPTaxCategory) OR (v_BPTaxCategory IS NULL)) AND ((t.C_BP_TaxCategory_ID IS NOT NULL AND t.C_BP_TaxCategory_ID = v_BPTaxCategory) OR (t.C_BP_TaxCategory_ID IS NULL)) AND (SoPoType = 'B' OR (SoPoType =(case when p_IsSOTrx='Y' then 'S' else 'P' end))) - ORDER BY t.C_BP_TaxCategory_ID, t.C_Country_ID, t.To_Country_ID, t.C_Region_ID, t.To_Region_ID, t.ValidFrom DESC + ORDER BY ad_isorgincluded(p_org_id, t.ad_org_id,t.ad_client_id),t.C_BP_TaxCategory_ID, t.C_Country_ID, t.To_Country_ID, t.C_Region_ID, t.To_Region_ID, t.ValidFrom DESC ) LOOP v_TaxID := SEL1.C_Tax_ID; @@ -209,13 +210,13 @@ FROM (SELECT C_Tax_ID, C_Country_ID, C_Region_ID, To_Country_Id, To_Region_ID, ValidFrom, C_TaxCategory_ID, - Parent_Tax_ID, C_BP_TaxCategory_ID, SoPoType + Parent_Tax_ID, C_BP_TaxCategory_ID, SoPoType, c_Tax.ad_org_id,c_Tax.ad_client_id FROM c_Tax WHERE c_Tax.isActive = 'Y' UNION SELECT tz.C_Tax_ID, tz.From_Country_ID, tz.From_Region_ID, tz.To_Country_ID, tz.To_Region_ID, ValidFrom, C_TaxCategory_ID, - Parent_Tax_Id, C_BP_TaxCategory_ID, SoPoType + Parent_Tax_Id, C_BP_TaxCategory_ID, SoPoType, ct.ad_org_id, ct.ad_client_id FROM c_Tax_Zone tz, c_Tax ct WHERE tz.C_Tax_ID = ct.C_Tax_ID @@ -233,10 +234,11 @@ AND t.To_Country_ID IS NULL AND t.To_Region_ID IS NULL AND t.ValidFrom <= p_shipDate + AND ad_isorgincluded(p_org_id, t.ad_org_id,t.ad_client_id) <> -1 --AND ((t.C_BP_TaxCategory_ID = v_BPTaxCategory) OR (v_BPTaxCategory IS NULL)) AND ((t.C_BP_TaxCategory_ID IS NOT NULL AND t.C_BP_TaxCategory_ID = v_BPTaxCategory) OR (t.C_BP_TaxCategory_ID IS NULL)) AND (SoPoType = 'B' OR (SoPoType =(case when p_IsSOTrx='Y' then 'S' else 'P' end))) - ORDER BY t.C_BP_TaxCategory_ID,t.C_Country_ID, t.C_Region_ID, t.ValidFrom DESC + ORDER BY ad_isorgincluded(p_org_id, t.ad_org_id,t.ad_client_id),t.C_BP_TaxCategory_ID,t.C_Country_ID, t.C_Region_ID, t.ValidFrom DESC ) LOOP v_TaxID := SEL2.C_Tax_ID; @@ -256,7 +258,8 @@ AND ((t.C_BP_TaxCategory_ID IS NOT NULL AND t.C_BP_TaxCategory_ID = v_BPTaxCategory) OR (t.C_BP_TaxCategory_ID IS NULL)) AND (SoPoType = 'B' OR (SoPoType =(case when p_IsSOTrx='Y' then 'S' else 'P' end))) AND t.isActive = 'Y' - ORDER BY t.C_BP_TaxCategory_ID, t.ValidFrom DESC + AND ad_isorgincluded(p_org_id, t.ad_org_id,t.ad_client_id) <> -1 + ORDER BY ad_isorgincluded(p_org_id, t.ad_org_id,t.ad_client_id),t.C_BP_TaxCategory_ID, t.ValidFrom DESC ) LOOP v_TaxID := SEL3.C_Tax_ID; diff -r e93ba1aedda5 -r cafacaed4992 src-db/database/model/functions/M_GENERATE_AVERAGE_COSTS.xml --- a/src-db/database/model/functions/M_GENERATE_AVERAGE_COSTS.xml Tue Aug 23 11:39:32 2011 +0000 +++ b/src-db/database/model/functions/M_GENERATE_AVERAGE_COSTS.xml Fri Sep 30 09:31:30 2011 +0000 @@ -114,7 +114,7 @@ SELECT DISTINCT DOCUMENTNO FROM M_MOVEMENT WHERE AD_CLIENT_ID=v_Client AND POSTED='Y' - AND MOVEMENTDATE > TO_DATE(v_MinDateCosting) + AND MOVEMENTDATE >= TO_DATE(v_MinDateCosting) ORDER BY DOCUMENTNO ) LOOP @@ -139,7 +139,7 @@ FROM M_INVENTORY I, M_WAREHOUSE W WHERE I.M_WAREHOUSE_ID = W.M_WAREHOUSE_ID AND I.AD_CLIENT_ID=v_Client AND I.POSTED='Y' - AND I.MOVEMENTDATE > TO_DATE(v_MinDateCosting) + AND I.MOVEMENTDATE >= TO_DATE(v_MinDateCosting) ORDER BY I.NAME, W.NAME ) LOOP @@ -163,7 +163,7 @@ SELECT DISTINCT DOCUMENTNO FROM M_PRODUCTION WHERE AD_CLIENT_ID=v_Client AND POSTED='Y' - AND MOVEMENTDATE > TO_DATE(v_MinDateCosting) + AND MOVEMENTDATE >= TO_DATE(v_MinDateCosting) ORDER BY DOCUMENTNO ) LOOP @@ -188,7 +188,7 @@ FROM M_INOUT WHERE ISSOTRX='N' AND AD_CLIENT_ID=v_Client AND POSTED='Y' - AND DATEACCT > TO_DATE(v_MinDateCosting) + AND DATEACCT >= TO_DATE(v_MinDateCosting) ORDER BY DOCUMENTNO ) LOOP @@ -211,14 +211,14 @@ v_CheckResultStr:=v_CheckResultStr || '@Oneormore@ @MatchedInvoices@ @PostedUsingCost@ @Date@ '; FOR Cur_Docs IN ( - SELECT DISTINCT IO.DATEORDERED, I.DOCUMENTNO + SELECT DISTINCT I.DATEINVOICED, I.DOCUMENTNO FROM M_MATCHINV M, M_INOUTLINE IOL, M_INOUT IO, C_INVOICE I, C_INVOICELINE IL WHERE M.AD_CLIENT_ID=v_Client AND M.POSTED='Y' AND IL.C_INVOICELINE_ID = M.C_INVOICELINE_ID AND I.C_INVOICE_ID = IL.C_INVOICE_ID AND IOL.M_INOUTLINE_ID = M.M_INOUTLINE_ID AND IO.M_INOUT_ID = IOL.M_INOUT_ID - AND IO.DATEACCT > TO_DATE(v_MinDateCosting) - ORDER BY IO.DATEORDERED, I.DOCUMENTNO + AND IO.DATEACCT >= TO_DATE(v_MinDateCosting) + ORDER BY I.DATEINVOICED, I.DOCUMENTNO ) LOOP IF (v_FirstIteration) THEN @@ -226,7 +226,7 @@ ELSE v_CheckResultStr := v_CheckResultStr || ', '; END IF; - v_CheckResultStr := v_CheckResultStr || Cur_Docs.DATEORDERED || ' (' || '@Invoice@ @SOS_DOCUMENTNO@' || Cur_Docs.DOCUMENTNO || ')'; + v_CheckResultStr := v_CheckResultStr || Cur_Docs.DATEINVOICED || ' (' || '@Invoice@ @SOS_DOCUMENTNO@' || Cur_Docs.DOCUMENTNO || ')'; END LOOP; v_CheckResultStr:=v_CheckResultStr || '.'; END IF; diff -r e93ba1aedda5 -r cafacaed4992 src-db/database/model/functions/M_INVENTORY_LISTCREATE.xml --- a/src-db/database/model/functions/M_INVENTORY_LISTCREATE.xml Tue Aug 23 11:39:32 2011 +0000 +++ b/src-db/database/model/functions/M_INVENTORY_LISTCREATE.xml Fri Sep 30 09:31:30 2011 +0000 @@ -215,15 +215,12 @@ FROM M_Product p INNER JOIN M_Storage_Detail s ON(s.M_Product_ID=p.M_Product_ID) - LEFT JOIN M_Product_org o - ON(o.M_Product_ID=p.M_Product_ID) WHERE p.AD_Client_ID=v_Client_ID -- only .. AND(v_ProductValue IS NULL OR UPPER(p.Value) LIKE v_ProductValue) AND(v_Locator_ID IS NULL OR s.M_Locator_ID=v_Locator_ID) - AND(v_ABC IS NULL - OR o.ABC=v_ABC) + AND(v_ABC IS NULL OR v_ABC in (select abc from m_product_org po where po.m_product_id = s.m_product_id )) AND(v_Warehouse_ID IS NULL OR s.M_Locator_ID IN (SELECT M_Locator_ID FROM M_Locator WHERE M_Warehouse_ID=v_Warehouse_ID)) diff -r e93ba1aedda5 -r cafacaed4992 src-db/database/model/tables/AD_ORG.xml --- a/src-db/database/model/tables/AD_ORG.xml Tue Aug 23 11:39:32 2011 +0000 +++ b/src-db/database/model/tables/AD_ORG.xml Fri Sep 30 09:31:30 2011 +0000 @@ -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 e93ba1aedda5 -r cafacaed4992 src-db/database/model/tables/FIN_PAYMENT_SCHEDULEDETAIL.xml --- a/src-db/database/model/tables/FIN_PAYMENT_SCHEDULEDETAIL.xml Tue Aug 23 11:39:32 2011 +0000 +++ b/src-db/database/model/tables/FIN_PAYMENT_SCHEDULEDETAIL.xml Fri Sep 30 09:31:30 2011 +0000 @@ -57,6 +57,30 @@ <default><![CDATA[N]]></default> <onCreateDefault><![CDATA['N']]></onCreateDefault> </column> + <column name="C_BPARTNER_ID" primaryKey="false" required="false" type="VARCHAR" size="32" autoIncrement="false"> + <default/> + <onCreateDefault/> + </column> + <column name="C_ACTIVITY_ID" primaryKey="false" required="false" type="VARCHAR" size="32" autoIncrement="false"> + <default/> + <onCreateDefault/> + </column> + <column name="M_PRODUCT_ID" primaryKey="false" required="false" type="VARCHAR" size="32" autoIncrement="false"> + <default/> + <onCreateDefault/> + </column> + <column name="C_CAMPAIGN_ID" primaryKey="false" required="false" type="VARCHAR" size="32" autoIncrement="false"> + <default/> + <onCreateDefault/> + </column> + <column name="C_PROJECT_ID" primaryKey="false" required="false" type="VARCHAR" size="32" autoIncrement="false"> + <default/> + <onCreateDefault/> + </column> + <column name="C_SALESREGION_ID" primaryKey="false" required="false" type="VARCHAR" size="32" autoIncrement="false"> + <default/> + <onCreateDefault/> + </column> <foreign-key foreignTable="AD_CLIENT" name="FIN_AD_CLIENT_SCHEDULEDETAIL"> <reference local="AD_CLIENT_ID" foreign="AD_CLIENT_ID"/> </foreign-key> @@ -72,6 +96,24 @@ <foreign-key foreignTable="FIN_PAYMENT_SCHEDULE" name="FIN_PAYMENT_SCHORD_SCHDETAIL"> <reference local="FIN_PAYMENT_SCHEDULE_ORDER" foreign="FIN_PAYMENT_SCHEDULE_ID"/> </foreign-key> + <foreign-key foreignTable="C_ACTIVITY" name="FIN_SCHEDULEDETAIL_C_ACTIVITY"> + <reference local="C_ACTIVITY_ID" foreign="C_ACTIVITY_ID"/> + </foreign-key> + <foreign-key foreignTable="C_BPARTNER" name="FIN_SCHEDULEDETAIL_C_BPARTNER"> + <reference local="C_BPARTNER_ID" foreign="C_BPARTNER_ID"/> + </foreign-key> + <foreign-key foreignTable="C_CAMPAIGN" name="FIN_SCHEDULEDETAIL_C_CAMPAIGN"> + <reference local="C_CAMPAIGN_ID" foreign="C_CAMPAIGN_ID"/> + </foreign-key> + <foreign-key foreignTable="C_PROJECT" name="FIN_SCHEDULEDETAIL_C_PROJECT"> ------------------------------------------------------------------------------ All of the data generated in your IT infrastructure is seriously valuable. Why? It contains a definitive record of application performance, security threats, fraudulent activity, and more. Splunk takes this data and makes sense of it. IT sense. And common sense. http://p.sf.net/sfu/splunk-d2dcopy2 _______________________________________________ Openbravo-commits mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/openbravo-commits
