details: https://code.openbravo.com/erp/stable/2.50/rev/d11f2f07dc53 changeset: 9657:d11f2f07dc53 user: Víctor Martínez Romanos <victor.martinez <at> openbravo.com> date: Tue Sep 20 11:11:06 2011 +0200 summary: Issue 18554: Added accounting dimensions to GL Items created through a payment - Modified UI: * Payment In/Out | Add Details popup. When selecting GL Item, the configured by the user Accounting Dimensions are shown. When adding a GL Item, the associatted acct. dimension will be shown in the table * Payment In/Out | Lines. The accounting dimensions related to the GL Items are shown
- The accounting for Payments, Transactions and Reconciliations has been updated to take into account the acct. dimensions for GL Items details: https://code.openbravo.com/erp/stable/2.50/rev/53340ebbc635 changeset: 9658:53340ebbc635 user: Víctor Martínez Romanos <victor.martinez <at> openbravo.com> date: Tue Sep 20 11:13:01 2011 +0200 summary: merge diffstat: .hgsigs | 1 + .hgtags | 1 + src-db/database/model/functions/C_BANKSTATEMENT_POST.xml | 2 +- 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/DocFINFinAccTransaction.java | 22 +- src/org/openbravo/erpCommon/ad_forms/DocFINPayment.java | 25 +- src/org/openbravo/erpCommon/ad_forms/DocFINReconciliation.java | 29 +- 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 + 29 files changed, 1183 insertions(+), 96 deletions(-) diffs (truncated from 2266 to 300 lines): diff -r e93ba1aedda5 -r 53340ebbc635 .hgsigs --- a/.hgsigs Tue Aug 23 11:39:32 2011 +0000 +++ b/.hgsigs Tue Sep 20 11:13:01 2011 +0200 @@ -37,3 +37,4 @@ 2cfa03023503ef72a8c4838cdb763e2cbd707893 0 iEYEABECAAYFAk3c2n4ACgkQCX/oGf+2qkO6GACg7qrg2WS8mGIH5hebESW1aoOmHMcAoP7wTmjIzUxn7w3ZRihDuh5xQLzK 9b6869b8aa4b3b9dbe9d6a855f0e491e793cbf65 0 iEYEABECAAYFAk4JrfQACgkQCX/oGf+2qkOXNgCgjKVRMwPIH8rNg+RhUOfOIVeXVqAAoPrpGfR5GWFTQYdS1GLiKHzwrast 7a39f190aa71c8a85f7169168d4aa0e801098552 0 iEYEABECAAYFAk4nC6sACgkQCX/oGf+2qkP2ZQCgr0q0gYORA+jaHs9NkN2WjTQaPggAoOEdeIag9ShKvgefCFS2sJDY8QE6 +3a53c020c489f275786cd4165e75ddd19733586c 0 iEYEABECAAYFAk5TkXUACgkQCX/oGf+2qkPy+ACg92VQoXKkAYKwPFwG2Bl8BB1gdFIAoIWQdXv0GpuWFuCU+f9WYuzfXmJu diff -r e93ba1aedda5 -r 53340ebbc635 .hgtags --- a/.hgtags Tue Aug 23 11:39:32 2011 +0000 +++ b/.hgtags Tue Sep 20 11:13:01 2011 +0200 @@ -48,3 +48,4 @@ d467781fb9a6174eece3684b52c186bbf0c2651e 2.50MP30 845811ab032b0e0039533be91c1e31f33d848364 2.50MP31 b0b55f934a82d1bf3e0ad93100f622dbfa489fcb 2.50MP32 +e93ba1aedda500859c1647b79b4e0065bebc0bb4 2.50MP33 diff -r e93ba1aedda5 -r 53340ebbc635 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 Tue Sep 20 11:13:01 2011 +0200 @@ -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 53340ebbc635 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 Tue Sep 20 11:13:01 2011 +0200 @@ -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 53340ebbc635 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 Tue Sep 20 11:13:01 2011 +0200 @@ -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 53340ebbc635 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 Tue Sep 20 11:13:01 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 e93ba1aedda5 -r 53340ebbc635 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 Tue Sep 20 11:13:01 2011 +0200 @@ -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"> + <reference local="C_PROJECT_ID" foreign="C_PROJECT_ID"/> + </foreign-key> + <foreign-key foreignTable="C_SALESREGION" name="FIN_SCHEDULEDETAIL_C_SREGION"> + <reference local="C_SALESREGION_ID" foreign="C_SALESREGION_ID"/> + </foreign-key> + <foreign-key foreignTable="M_PRODUCT" name="FIN_SCHEDULEDETAIL_M_PRODUCT"> + <reference local="M_PRODUCT_ID" foreign="M_PRODUCT_ID"/> + </foreign-key> <check name="FIN_PAY_SCHE_DETAIL_ISCANC_CHK"><![CDATA[ISCANCELED IN ('Y', 'N')]]></check> </table> </database> diff -r e93ba1aedda5 -r 53340ebbc635 src-db/database/model/views/FIN_PAYMENT_DETAIL_V.xml --- a/src-db/database/model/views/FIN_PAYMENT_DETAIL_V.xml Tue Aug 23 11:39:32 2011 +0000 +++ b/src-db/database/model/views/FIN_PAYMENT_DETAIL_V.xml Tue Sep 20 11:13:01 2011 +0200 @@ -1,6 +1,6 @@ <?xml version="1.0"?> <database name="VIEW FIN_PAYMENT_DETAIL_V"> - <view name="FIN_PAYMENT_DETAIL_V"><![CDATA[SELECT psd.fin_payment_scheduledetail_id AS fin_payment_detail_v_id, psd.ad_client_id, psd.ad_org_id, psd.isactive, psd.created, psd.createdby, psd.updated, psd.updatedby, psi.fin_payment_schedule_id AS fin_payment_sched_inv_v_id, pso.fin_payment_schedule_id AS fin_payment_sched_ord_v_id, i.documentno AS invoiceno, o.documentno AS orderno, p.documentno AS paymentno, pd.fin_payment_id, COALESCE(psi.duedate, pso.duedate) AS duedate, COALESCE(i.grandtotal, o.grandtotal) AS invoicedamt, COALESCE(psi.amount, pso.amount) AS expected, psd.amount AS paidamt, p.c_bpartner_id, p.fin_paymentmethod_id, p.fin_financial_account_id, p.c_currency_id, p.paymentdate, gli.name AS glitemname, pd.writeoffamt, psd.iscanceled + <view name="FIN_PAYMENT_DETAIL_V"><![CDATA[SELECT psd.fin_payment_scheduledetail_id AS fin_payment_detail_v_id, psd.ad_client_id, psd.ad_org_id, psd.isactive, psd.created, psd.createdby, psd.updated, psd.updatedby, psi.fin_payment_schedule_id AS fin_payment_sched_inv_v_id, pso.fin_payment_schedule_id AS fin_payment_sched_ord_v_id, i.documentno AS invoiceno, o.documentno AS orderno, p.documentno AS paymentno, pd.fin_payment_id, COALESCE(psi.duedate, pso.duedate) AS duedate, COALESCE(i.grandtotal, o.grandtotal) AS invoicedamt, COALESCE(psi.amount, pso.amount) AS expected, psd.amount AS paidamt, p.c_bpartner_id, p.fin_paymentmethod_id, p.fin_financial_account_id, p.c_currency_id, p.paymentdate, gli.name AS glitemname, pd.writeoffamt, psd.iscanceled, psd.c_bpartner_id AS c_bpartner_id_dim, psd.c_activity_id, psd.m_product_id, psd.c_campaign_id, psd.c_project_id, psd.c_salesregion_id FROM fin_payment p, fin_payment_detail pd JOIN fin_payment_scheduledetail psd ON pd.fin_payment_detail_id = psd.fin_payment_detail_id LEFT JOIN fin_payment_schedule psi ON psd.fin_payment_schedule_invoice = psi.fin_payment_schedule_id diff -r e93ba1aedda5 -r 53340ebbc635 src-db/database/sourcedata/AD_CALLOUT.xml --- a/src-db/database/sourcedata/AD_CALLOUT.xml Tue Aug 23 11:39:32 2011 +0000 +++ b/src-db/database/sourcedata/AD_CALLOUT.xml Tue Sep 20 11:13:01 2011 +0200 @@ -983,4 +983,15 @@ <!--F6E343E77DA249559AEF8651D595E880--> <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID> <!--F6E343E77DA249559AEF8651D595E880--></AD_CALLOUT> +<!--FF808181320551FD01320576AAAF0008--><AD_CALLOUT> +<!--FF808181320551FD01320576AAAF0008--> <AD_CALLOUT_ID><![CDATA[FF808181320551FD01320576AAAF0008]]></AD_CALLOUT_ID> +<!--FF808181320551FD01320576AAAF0008--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> +<!--FF808181320551FD01320576AAAF0008--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID> +<!--FF808181320551FD01320576AAAF0008--> <ISACTIVE><![CDATA[Y]]></ISACTIVE> +<!--FF808181320551FD01320576AAAF0008--> <NAME><![CDATA[SL_Product_Type]]></NAME> +<!--FF808181320551FD01320576AAAF0008--> <DESCRIPTION><![CDATA[This callout changes the value of the stocked field if the product type is Service. +]]></DESCRIPTION> +<!--FF808181320551FD01320576AAAF0008--> <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID> +<!--FF808181320551FD01320576AAAF0008--></AD_CALLOUT> + </data> diff -r e93ba1aedda5 -r 53340ebbc635 src-db/database/sourcedata/AD_COLUMN.xml --- a/src-db/database/sourcedata/AD_COLUMN.xml Tue Aug 23 11:39:32 2011 +0000 +++ b/src-db/database/sourcedata/AD_COLUMN.xml Tue Sep 20 11:13:01 2011 +0200 @@ -122434,6 +122434,7 @@ <!--7795--> <ISSESSIONATTR><![CDATA[N]]></ISSESSIONATTR> <!--7795--> <ISSECONDARYKEY><![CDATA[N]]></ISSECONDARYKEY> <!--7795--> <ISDESENCRYPTABLE><![CDATA[N]]></ISDESENCRYPTABLE> +<!--7795--> <AD_CALLOUT_ID><![CDATA[FF808181320551FD01320576AAAF0008]]></AD_CALLOUT_ID> <!--7795--> <DEVELOPMENTSTATUS><![CDATA[RE]]></DEVELOPMENTSTATUS> <!--7795--> <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID> <!--7795--> <POSITION><![CDATA[40]]></POSITION> @@ -264624,6 +264625,39 @@ <!--1B1EC3E0DE05493E9815E38124AA620F--> <VALIDATEONNEW><![CDATA[Y]]></VALIDATEONNEW> <!--1B1EC3E0DE05493E9815E38124AA620F--></AD_COLUMN> +<!--1C30BBC88DEA4E40831C616E1D34973B--><AD_COLUMN> +<!--1C30BBC88DEA4E40831C616E1D34973B--> <AD_COLUMN_ID><![CDATA[1C30BBC88DEA4E40831C616E1D34973B]]></AD_COLUMN_ID> +<!--1C30BBC88DEA4E40831C616E1D34973B--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> +<!--1C30BBC88DEA4E40831C616E1D34973B--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID> +<!--1C30BBC88DEA4E40831C616E1D34973B--> <ISACTIVE><![CDATA[Y]]></ISACTIVE> +<!--1C30BBC88DEA4E40831C616E1D34973B--> <NAME><![CDATA[Project]]></NAME> +<!--1C30BBC88DEA4E40831C616E1D34973B--> <DESCRIPTION><![CDATA[Identifier of a project defined within the Project & Service Management module.]]></DESCRIPTION> +<!--1C30BBC88DEA4E40831C616E1D34973B--> <HELP><![CDATA[Identifier of a project defined within the Project & Service Management module.]]></HELP> +<!--1C30BBC88DEA4E40831C616E1D34973B--> <COLUMNNAME><![CDATA[C_Project_ID]]></COLUMNNAME> +<!--1C30BBC88DEA4E40831C616E1D34973B--> <AD_TABLE_ID><![CDATA[DC63963AB3F1489BAAB5A9A7EFD1B407]]></AD_TABLE_ID> +<!--1C30BBC88DEA4E40831C616E1D34973B--> <AD_REFERENCE_ID><![CDATA[19]]></AD_REFERENCE_ID> +<!--1C30BBC88DEA4E40831C616E1D34973B--> <FIELDLENGTH><![CDATA[32]]></FIELDLENGTH> +<!--1C30BBC88DEA4E40831C616E1D34973B--> <ISKEY><![CDATA[N]]></ISKEY> +<!--1C30BBC88DEA4E40831C616E1D34973B--> <ISPARENT><![CDATA[N]]></ISPARENT> +<!--1C30BBC88DEA4E40831C616E1D34973B--> <ISMANDATORY><![CDATA[N]]></ISMANDATORY> +<!--1C30BBC88DEA4E40831C616E1D34973B--> <ISUPDATEABLE><![CDATA[Y]]></ISUPDATEABLE> +<!--1C30BBC88DEA4E40831C616E1D34973B--> <ISIDENTIFIER><![CDATA[N]]></ISIDENTIFIER> +<!--1C30BBC88DEA4E40831C616E1D34973B--> <SEQNO><![CDATA[410]]></SEQNO> +<!--1C30BBC88DEA4E40831C616E1D34973B--> <ISTRANSLATED><![CDATA[N]]></ISTRANSLATED> +<!--1C30BBC88DEA4E40831C616E1D34973B--> <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED> +<!--1C30BBC88DEA4E40831C616E1D34973B--> <ISSELECTIONCOLUMN><![CDATA[N]]></ISSELECTIONCOLUMN> +<!--1C30BBC88DEA4E40831C616E1D34973B--> <AD_ELEMENT_ID><![CDATA[208]]></AD_ELEMENT_ID> +<!--1C30BBC88DEA4E40831C616E1D34973B--> <ISSESSIONATTR><![CDATA[N]]></ISSESSIONATTR> +<!--1C30BBC88DEA4E40831C616E1D34973B--> <ISSECONDARYKEY><![CDATA[N]]></ISSECONDARYKEY> +<!--1C30BBC88DEA4E40831C616E1D34973B--> <ISDESENCRYPTABLE><![CDATA[N]]></ISDESENCRYPTABLE> +<!--1C30BBC88DEA4E40831C616E1D34973B--> <DEVELOPMENTSTATUS><![CDATA[RE]]></DEVELOPMENTSTATUS> +<!--1C30BBC88DEA4E40831C616E1D34973B--> <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID> +<!--1C30BBC88DEA4E40831C616E1D34973B--> <POSITION><![CDATA[35]]></POSITION> +<!--1C30BBC88DEA4E40831C616E1D34973B--> <ISTRANSIENT><![CDATA[N]]></ISTRANSIENT> +<!--1C30BBC88DEA4E40831C616E1D34973B--> <ISAUTOSAVE><![CDATA[Y]]></ISAUTOSAVE> +<!--1C30BBC88DEA4E40831C616E1D34973B--> <VALIDATEONNEW><![CDATA[Y]]></VALIDATEONNEW> +<!--1C30BBC88DEA4E40831C616E1D34973B--></AD_COLUMN> + <!--1DD4E1DE19554DF3920C7F5301943B60--><AD_COLUMN> <!--1DD4E1DE19554DF3920C7F5301943B60--> <AD_COLUMN_ID><![CDATA[1DD4E1DE19554DF3920C7F5301943B60]]></AD_COLUMN_ID> <!--1DD4E1DE19554DF3920C7F5301943B60--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> @@ -265230,6 +265264,40 @@ <!--1F9C02B7A18448368C4E137F971747BF--> <VALIDATEONNEW><![CDATA[Y]]></VALIDATEONNEW> <!--1F9C02B7A18448368C4E137F971747BF--></AD_COLUMN> +<!--20217D869BFD41938E250F7F7528E06F--><AD_COLUMN> +<!--20217D869BFD41938E250F7F7528E06F--> <AD_COLUMN_ID><![CDATA[20217D869BFD41938E250F7F7528E06F]]></AD_COLUMN_ID> +<!--20217D869BFD41938E250F7F7528E06F--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> +<!--20217D869BFD41938E250F7F7528E06F--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID> +<!--20217D869BFD41938E250F7F7528E06F--> <ISACTIVE><![CDATA[Y]]></ISACTIVE> +<!--20217D869BFD41938E250F7F7528E06F--> <NAME><![CDATA[Business Partner (dim)]]></NAME> +<!--20217D869BFD41938E250F7F7528E06F--> <DESCRIPTION><![CDATA[Anyone who takes part in daily business operations by acting as a customer, employee, etc.]]></DESCRIPTION> +<!--20217D869BFD41938E250F7F7528E06F--> <HELP><![CDATA[A Business Partner is anyone with whom you transact. This can include a customer, vendor, employee or any combination of these.]]></HELP> +<!--20217D869BFD41938E250F7F7528E06F--> <COLUMNNAME><![CDATA[C_Bpartner_Id_Dim]]></COLUMNNAME> +<!--20217D869BFD41938E250F7F7528E06F--> <AD_TABLE_ID><![CDATA[DC63963AB3F1489BAAB5A9A7EFD1B407]]></AD_TABLE_ID> +<!--20217D869BFD41938E250F7F7528E06F--> <AD_REFERENCE_ID><![CDATA[18]]></AD_REFERENCE_ID> +<!--20217D869BFD41938E250F7F7528E06F--> <AD_REFERENCE_VALUE_ID><![CDATA[138]]></AD_REFERENCE_VALUE_ID> +<!--20217D869BFD41938E250F7F7528E06F--> <FIELDLENGTH><![CDATA[32]]></FIELDLENGTH> +<!--20217D869BFD41938E250F7F7528E06F--> <ISKEY><![CDATA[N]]></ISKEY> +<!--20217D869BFD41938E250F7F7528E06F--> <ISPARENT><![CDATA[N]]></ISPARENT> +<!--20217D869BFD41938E250F7F7528E06F--> <ISMANDATORY><![CDATA[N]]></ISMANDATORY> +<!--20217D869BFD41938E250F7F7528E06F--> <ISUPDATEABLE><![CDATA[Y]]></ISUPDATEABLE> +<!--20217D869BFD41938E250F7F7528E06F--> <ISIDENTIFIER><![CDATA[N]]></ISIDENTIFIER> +<!--20217D869BFD41938E250F7F7528E06F--> <SEQNO><![CDATA[370]]></SEQNO> +<!--20217D869BFD41938E250F7F7528E06F--> <ISTRANSLATED><![CDATA[N]]></ISTRANSLATED> +<!--20217D869BFD41938E250F7F7528E06F--> <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED> +<!--20217D869BFD41938E250F7F7528E06F--> <ISSELECTIONCOLUMN><![CDATA[N]]></ISSELECTIONCOLUMN> +<!--20217D869BFD41938E250F7F7528E06F--> <AD_ELEMENT_ID><![CDATA[187]]></AD_ELEMENT_ID> +<!--20217D869BFD41938E250F7F7528E06F--> <ISSESSIONATTR><![CDATA[N]]></ISSESSIONATTR> +<!--20217D869BFD41938E250F7F7528E06F--> <ISSECONDARYKEY><![CDATA[N]]></ISSECONDARYKEY> +<!--20217D869BFD41938E250F7F7528E06F--> <ISDESENCRYPTABLE><![CDATA[N]]></ISDESENCRYPTABLE> +<!--20217D869BFD41938E250F7F7528E06F--> <DEVELOPMENTSTATUS><![CDATA[RE]]></DEVELOPMENTSTATUS> +<!--20217D869BFD41938E250F7F7528E06F--> <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID> ------------------------------------------------------------------------------ All the data continuously generated in your IT infrastructure contains a definitive record of customers, application performance, security threats, fraudulent activity and more. Splunk takes this data and makes sense of it. Business sense. IT sense. Common sense. http://p.sf.net/sfu/splunk-d2dcopy1 _______________________________________________ Openbravo-commits mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/openbravo-commits
