details: https://code.openbravo.com/erp/devel/pi/rev/bb5ae76ed8ee changeset: 22796:bb5ae76ed8ee user: Atul Gaware <atul.gaware <at> openbravo.com> date: Wed Mar 26 17:34:33 2014 +0530 summary: Fixes Issue 26065: Sample Data for PR14Q2
details: https://code.openbravo.com/erp/devel/pi/rev/7db94f11640b changeset: 22797:7db94f11640b user: Sandra Huguet <sandra.huguet <at> openbravo.com> date: Mon Mar 31 12:56:32 2014 +0200 summary: Related to issue 26065 Fixed reconciliations in F&B diffstat: referencedata/sampledata/F_B_International_Group/AD_ALERTRULE.xml | 8 +- referencedata/sampledata/F_B_International_Group/AD_ORG_CLOSING.xml | 150 +- referencedata/sampledata/F_B_International_Group/AD_PINSTANCE.xml | 4145 + referencedata/sampledata/F_B_International_Group/AD_PINSTANCE_PARA.xml | 3366 + referencedata/sampledata/F_B_International_Group/AD_PROCESS_ACCESS.xml | 420 + referencedata/sampledata/F_B_International_Group/AD_PROCESS_REQUEST.xml | 2180 +- referencedata/sampledata/F_B_International_Group/AD_SEQUENCE.xml | 56 +- referencedata/sampledata/F_B_International_Group/AD_TREE.xml | 16 + referencedata/sampledata/F_B_International_Group/AD_USER.xml | 48 +- referencedata/sampledata/F_B_International_Group/AD_WINDOW_ACCESS.xml | 280 + referencedata/sampledata/F_B_International_Group/A_AMORTIZATION.xml | 9 +- referencedata/sampledata/F_B_International_Group/A_ASSET.xml | 6 +- referencedata/sampledata/F_B_International_Group/C_BPARTNER.xml | 116 +- referencedata/sampledata/F_B_International_Group/C_INVOICE.xml | 2678 +- referencedata/sampledata/F_B_International_Group/C_INVOICELINE.xml | 5546 + referencedata/sampledata/F_B_International_Group/C_INVOICELINETAX.xml | 2700 + referencedata/sampledata/F_B_International_Group/C_INVOICETAX.xml | 680 + referencedata/sampledata/F_B_International_Group/C_ORDER.xml | 1464 + referencedata/sampledata/F_B_International_Group/C_ORDERLINE.xml | 4989 + referencedata/sampledata/F_B_International_Group/C_ORDERLINETAX.xml | 1870 + referencedata/sampledata/F_B_International_Group/C_ORDERTAX.xml | 384 + referencedata/sampledata/F_B_International_Group/C_ORDER_DISCOUNT.xml | 120 + referencedata/sampledata/F_B_International_Group/C_PERIOD.xml | 96 +- referencedata/sampledata/F_B_International_Group/C_PERIODCONTROL.xml | 142296 ++++---- referencedata/sampledata/F_B_International_Group/C_PERIODCONTROL_LOG.xml | 912 + referencedata/sampledata/F_B_International_Group/FACT_ACCT.xml | 159566 +++++---- referencedata/sampledata/F_B_International_Group/FIN_BANKSTATEMENT.xml | 146 + referencedata/sampledata/F_B_International_Group/FIN_BANKSTATEMENTLINE.xml | 1144 + referencedata/sampledata/F_B_International_Group/FIN_FINACC_PAYMENTMETHOD.xml | 16 + referencedata/sampledata/F_B_International_Group/FIN_FINACC_TRANSACTION.xml | 1326 +- referencedata/sampledata/F_B_International_Group/FIN_FINANCIAL_ACCOUNT.xml | 13 +- referencedata/sampledata/F_B_International_Group/FIN_PAYMENT.xml | 1480 +- referencedata/sampledata/F_B_International_Group/FIN_PAYMENT_DETAIL.xml | 672 + referencedata/sampledata/F_B_International_Group/FIN_PAYMENT_PROPOSAL.xml | 116 + referencedata/sampledata/F_B_International_Group/FIN_PAYMENT_PROP_DETAIL.xml | 375 + referencedata/sampledata/F_B_International_Group/FIN_PAYMENT_SCHEDULE.xml | 35170 +- referencedata/sampledata/F_B_International_Group/FIN_PAYMENT_SCHEDULEDETAIL.xml | 1569 +- referencedata/sampledata/F_B_International_Group/FIN_RECLINE_TEMP.xml | 83 + referencedata/sampledata/F_B_International_Group/FIN_RECONCILIATION.xml | 356 +- referencedata/sampledata/F_B_International_Group/GL_JOURNAL.xml | 70 + referencedata/sampledata/F_B_International_Group/GL_JOURNALBATCH.xml | 68 +- referencedata/sampledata/F_B_International_Group/GL_JOURNALLINE.xml | 840 + referencedata/sampledata/F_B_International_Group/M_COSTING.xml | 992 +- referencedata/sampledata/F_B_International_Group/M_INOUT.xml | 1000 + referencedata/sampledata/F_B_International_Group/M_INOUTLINE.xml | 2797 + referencedata/sampledata/F_B_International_Group/M_MATCHINV.xml | 722 + referencedata/sampledata/F_B_International_Group/M_MATCHPO.xml | 1444 + referencedata/sampledata/F_B_International_Group/M_STOCK_PROPOSED.xml | 800 + referencedata/sampledata/F_B_International_Group/M_STORAGE_DETAIL.xml | 272 +- referencedata/sampledata/F_B_International_Group/M_STORAGE_PENDING.xml | 70 +- referencedata/sampledata/F_B_International_Group/M_TRANSACTION.xml | 6590 + referencedata/sampledata/F_B_International_Group/M_TRANSACTION_COST.xml | 1890 + referencedata/sampledata/F_B_International_Group/OBUIAPP_PROCESS_ACCESS.xml | 420 + 53 files changed, 241062 insertions(+), 153480 deletions(-) diffs (truncated from 471914 to 300 lines): diff -r d0a8508115fc -r 7db94f11640b referencedata/sampledata/F_B_International_Group/AD_ALERTRULE.xml --- a/referencedata/sampledata/F_B_International_Group/AD_ALERTRULE.xml Sun Mar 30 20:47:04 2014 +0000 +++ b/referencedata/sampledata/F_B_International_Group/AD_ALERTRULE.xml Mon Mar 31 12:56:32 2014 +0200 @@ -11,8 +11,8 @@ <UPDATEDBY><![CDATA[0]]></UPDATEDBY> <NAME><![CDATA[Wrong Matched Invoice posting. Wrong account.]]></NAME> <AD_TAB_ID><![CDATA[408]]></AD_TAB_ID> - <SQL><![CDATA[SELECT DISTINCT ad_column_identifier('m_matchinv', fa.record_id, 'en_US') as record_id, fa.record_id as referencekey_id, 0 as ad_role_id, null as ad_user_id, 'This Matched Invoice need to be posted again due to wrong accounting.' as description, 'Y' as isactive, mi.ad_org_id, mi.ad_client_id, now() as created, 0 as createdBy, now() as updated, 0 as updatedBy FROM fact_acct fa JOIN m_matchinv mi ON fa.record_id = mi.m_matchinv_id WHERE fa.ad_table_id = '472' GROUP BY fa.fact_acct_group_id, mi.m_matchinv_id, mi.ad_org_id, fa.record_id, mi.ad_client_id HAVING count(*) > 3]]></SQL> - <TYPE><![CDATA[D]]></TYPE> + <SQL><![CDATA[]]></SQL> + <TYPE><![CDATA[E]]></TYPE> </AD_ALERTRULE> <AD_ALERTRULE> @@ -137,8 +137,8 @@ <UPDATEDBY><![CDATA[0]]></UPDATEDBY> <NAME><![CDATA[Wrong Matched Invoice posting. Wrong currency conversion.]]></NAME> <AD_TAB_ID><![CDATA[408]]></AD_TAB_ID> - <SQL><![CDATA[SELECT DISTINCT ad_column_identifier('m_matchinv', fa.record_id, 'en_US') as record_id, fa.record_id as referencekey_id, 0 as ad_role_id, null as ad_user_id, 'This Matched Invoice need to be posted again due to wrong accounting.' as description, 'Y' as isactive, mi.ad_org_id, mi.ad_client_id, now() as created, 0 as createdBy, now() as updated, 0 as updatedBy FROM fact_acct fa JOIN m_matchinv mi ON fa.record_id = mi.m_matchinv_id LEFT JOIN fact_acct far ON far.line_id = mi.m_inoutline_id AND far.account_id = fa.account_id LEFT JOIN fact_acct fi ON fi.line_id = mi.c_invoiceline_id AND fi.account_id = fa.account_id AND fi.ad_table_id = '318' WHERE (round((select movementqty from m_inoutline where m_inoutline_id=mi.m_inoutline_id),2) = round((select qtyinvoiced from c_invoiceline where c_invoiceline_id=mi.c_invoiceline_id),2)) AND fa.ad_table_id = '472' AND (COALESCE(far.amtacctcr + far.amtacctdr, fa.amtacctdr + fa.amtacctcr) <> (fa.amtacctdr + fa.amtacctcr) OR COALESC E(fi.amtacctcr + fi.amtacctdr, fa.amtacctdr + fa.amtacctcr) <> (fa.amtacctdr + fa.amtacctcr))]]></SQL> - <TYPE><![CDATA[D]]></TYPE> + <SQL><![CDATA[]]></SQL> + <TYPE><![CDATA[E]]></TYPE> </AD_ALERTRULE> <AD_ALERTRULE> diff -r d0a8508115fc -r 7db94f11640b referencedata/sampledata/F_B_International_Group/AD_ORG_CLOSING.xml --- a/referencedata/sampledata/F_B_International_Group/AD_ORG_CLOSING.xml Sun Mar 30 20:47:04 2014 +0000 +++ b/referencedata/sampledata/F_B_International_Group/AD_ORG_CLOSING.xml Mon Mar 31 12:56:32 2014 +0200 @@ -1,103 +1,103 @@ <?xml version='1.0' encoding='UTF-8'?> <data> <AD_ORG_CLOSING> - <AD_ORG_CLOSING_ID><![CDATA[097598EBB58B42F684138C5CF039782E]]></AD_ORG_CLOSING_ID> + <AD_ORG_CLOSING_ID><![CDATA[2B5EECA8FF644CAE93AA848D1BF1EB9B]]></AD_ORG_CLOSING_ID> <AD_CLIENT_ID><![CDATA[23C59575B9CF467C9620760EB255B389]]></AD_CLIENT_ID> <AD_ORG_ID><![CDATA[B843C30461EA4501935CB1D125C9C25A]]></AD_ORG_ID> <ISACTIVE><![CDATA[Y]]></ISACTIVE> - <CREATED><![CDATA[2013-07-04 23:45:43.684]]></CREATED> - <CREATEDBY><![CDATA[0]]></CREATEDBY> - <UPDATED><![CDATA[2013-07-04 23:45:43.684]]></UPDATED> - <UPDATEDBY><![CDATA[0]]></UPDATEDBY> - <C_YEAR_ID><![CDATA[09E6CC5F7F6D4E8FA3DE5E120F7F9505]]></C_YEAR_ID> - <AD_ORG_ACCTSCHEMA_ID><![CDATA[B6D5FF3A416C4371851ADA64EE9F0674]]></AD_ORG_ACCTSCHEMA_ID> - <REG_FACT_ACCT_GROUP_ID><![CDATA[4D736B5BE93643D9AD956953E44A5B27]]></REG_FACT_ACCT_GROUP_ID> - <CLOSE_FACT_ACCT_GROUP_ID><![CDATA[1579CFAFDC3B41A0A2B8BF5BAFC5CCFF]]></CLOSE_FACT_ACCT_GROUP_ID> - <DIVIDEUP_FACT_ACCT_GROUP_ID><![CDATA[C861C70469B7474C9A086AA156A61F81]]></DIVIDEUP_FACT_ACCT_GROUP_ID> - <OPEN_FACT_ACCT_GROUP_ID><![CDATA[A068F353AC3745A4B32BAC8CF68ABD94]]></OPEN_FACT_ACCT_GROUP_ID> + <CREATED><![CDATA[2014-03-31 12:37:57.994804]]></CREATED> + <CREATEDBY><![CDATA[100]]></CREATEDBY> + <UPDATED><![CDATA[2014-03-31 12:37:57.994804]]></UPDATED> + <UPDATEDBY><![CDATA[100]]></UPDATEDBY> + <C_YEAR_ID><![CDATA[BE903865711D408390B24C366B6C4099]]></C_YEAR_ID> + <AD_ORG_ACCTSCHEMA_ID><![CDATA[7583C0C800F14661B348A271ED276A14]]></AD_ORG_ACCTSCHEMA_ID> + <REG_FACT_ACCT_GROUP_ID><![CDATA[09B6502F26CC44F4826A75F78D379B6C]]></REG_FACT_ACCT_GROUP_ID> + <CLOSE_FACT_ACCT_GROUP_ID><![CDATA[9F604829ADC24E25BFF401DDCFFF9405]]></CLOSE_FACT_ACCT_GROUP_ID> + <OPEN_FACT_ACCT_GROUP_ID><![CDATA[8E70903187834E35B4ED732372551868]]></OPEN_FACT_ACCT_GROUP_ID> </AD_ORG_CLOSING> <AD_ORG_CLOSING> - <AD_ORG_CLOSING_ID><![CDATA[145FF7747BB543E29FB2CBBADC359469]]></AD_ORG_CLOSING_ID> + <AD_ORG_CLOSING_ID><![CDATA[5AF58E7363724C2B833A479D8C7C7D7F]]></AD_ORG_CLOSING_ID> + <AD_CLIENT_ID><![CDATA[23C59575B9CF467C9620760EB255B389]]></AD_CLIENT_ID> + <AD_ORG_ID><![CDATA[2E60544D37534C0B89E765FE29BC0B43]]></AD_ORG_ID> + <ISACTIVE><![CDATA[Y]]></ISACTIVE> + <CREATED><![CDATA[2014-03-31 12:38:38.225985]]></CREATED> + <CREATEDBY><![CDATA[100]]></CREATEDBY> + <UPDATED><![CDATA[2014-03-31 12:38:38.225985]]></UPDATED> + <UPDATEDBY><![CDATA[100]]></UPDATEDBY> + <C_YEAR_ID><![CDATA[2B584DF89D2C4628AF0E391F07177F47]]></C_YEAR_ID> + <AD_ORG_ACCTSCHEMA_ID><![CDATA[B6D5FF3A416C4371851ADA64EE9F0674]]></AD_ORG_ACCTSCHEMA_ID> + <REG_FACT_ACCT_GROUP_ID><![CDATA[62291056ADBE46D9903B6FF4F998CF25]]></REG_FACT_ACCT_GROUP_ID> + <CLOSE_FACT_ACCT_GROUP_ID><![CDATA[E76CB9D6DD1B4A8D9C08317A2AC73D8A]]></CLOSE_FACT_ACCT_GROUP_ID> + <DIVIDEUP_FACT_ACCT_GROUP_ID><![CDATA[9056E4234B23496585B1C64A5C7FCB13]]></DIVIDEUP_FACT_ACCT_GROUP_ID> + <OPEN_FACT_ACCT_GROUP_ID><![CDATA[99DD1AFEF9EE4114A6E56D2935FECBC0]]></OPEN_FACT_ACCT_GROUP_ID> +</AD_ORG_CLOSING> + +<AD_ORG_CLOSING> + <AD_ORG_CLOSING_ID><![CDATA[5D00C6B474C849BABB6E7E741346CA08]]></AD_ORG_CLOSING_ID> <AD_CLIENT_ID><![CDATA[23C59575B9CF467C9620760EB255B389]]></AD_CLIENT_ID> <AD_ORG_ID><![CDATA[B843C30461EA4501935CB1D125C9C25A]]></AD_ORG_ID> <ISACTIVE><![CDATA[Y]]></ISACTIVE> - <CREATED><![CDATA[2013-07-04 23:45:43.684]]></CREATED> - <CREATEDBY><![CDATA[0]]></CREATEDBY> - <UPDATED><![CDATA[2013-07-04 23:45:43.684]]></UPDATED> - <UPDATEDBY><![CDATA[0]]></UPDATEDBY> - <C_YEAR_ID><![CDATA[BE903865711D408390B24C366B6C4099]]></C_YEAR_ID> - <AD_ORG_ACCTSCHEMA_ID><![CDATA[B6D5FF3A416C4371851ADA64EE9F0674]]></AD_ORG_ACCTSCHEMA_ID> - <REG_FACT_ACCT_GROUP_ID><![CDATA[3F43F2FC26764DA18E77986C7176D114]]></REG_FACT_ACCT_GROUP_ID> - <CLOSE_FACT_ACCT_GROUP_ID><![CDATA[0B420CBBF2484181A0DB26ACBDB948DE]]></CLOSE_FACT_ACCT_GROUP_ID> - <DIVIDEUP_FACT_ACCT_GROUP_ID><![CDATA[00D552FFF0E149F08C798AF70AAB1F32]]></DIVIDEUP_FACT_ACCT_GROUP_ID> - <OPEN_FACT_ACCT_GROUP_ID><![CDATA[E3FE99779EE543C79EB0ACC1DA6D833C]]></OPEN_FACT_ACCT_GROUP_ID> + <CREATED><![CDATA[2014-03-31 12:38:45.51547]]></CREATED> + <CREATEDBY><![CDATA[100]]></CREATEDBY> + <UPDATED><![CDATA[2014-03-31 12:38:45.51547]]></UPDATED> + <UPDATEDBY><![CDATA[100]]></UPDATEDBY> + <C_YEAR_ID><![CDATA[09E6CC5F7F6D4E8FA3DE5E120F7F9505]]></C_YEAR_ID> + <AD_ORG_ACCTSCHEMA_ID><![CDATA[7583C0C800F14661B348A271ED276A14]]></AD_ORG_ACCTSCHEMA_ID> + <REG_FACT_ACCT_GROUP_ID><![CDATA[0C974B1B4D8648DDBA194C18908EDD39]]></REG_FACT_ACCT_GROUP_ID> + <CLOSE_FACT_ACCT_GROUP_ID><![CDATA[59852BD14C0744719CB5DA2A8EF2641A]]></CLOSE_FACT_ACCT_GROUP_ID> + <OPEN_FACT_ACCT_GROUP_ID><![CDATA[FB8013F6EDBE406A9614B69568DC8015]]></OPEN_FACT_ACCT_GROUP_ID> </AD_ORG_CLOSING> <AD_ORG_CLOSING> - <AD_ORG_CLOSING_ID><![CDATA[238907EEAAE8408D81EEF0CF08F6FB44]]></AD_ORG_CLOSING_ID> + <AD_ORG_CLOSING_ID><![CDATA[74F7FDA459494FC4A5E3AB05D9790F85]]></AD_ORG_CLOSING_ID> <AD_CLIENT_ID><![CDATA[23C59575B9CF467C9620760EB255B389]]></AD_CLIENT_ID> <AD_ORG_ID><![CDATA[B843C30461EA4501935CB1D125C9C25A]]></AD_ORG_ID> <ISACTIVE><![CDATA[Y]]></ISACTIVE> - <CREATED><![CDATA[2013-07-04 23:45:43.683]]></CREATED> - <CREATEDBY><![CDATA[0]]></CREATEDBY> - <UPDATED><![CDATA[2013-07-04 23:45:43.683]]></UPDATED> - <UPDATEDBY><![CDATA[0]]></UPDATEDBY> - <C_YEAR_ID><![CDATA[09E6CC5F7F6D4E8FA3DE5E120F7F9505]]></C_YEAR_ID> - <AD_ORG_ACCTSCHEMA_ID><![CDATA[7583C0C800F14661B348A271ED276A14]]></AD_ORG_ACCTSCHEMA_ID> - <REG_FACT_ACCT_GROUP_ID><![CDATA[EF0AB882F39D4C429E89AADFD7FA5824]]></REG_FACT_ACCT_GROUP_ID> - <CLOSE_FACT_ACCT_GROUP_ID><![CDATA[A45B9E7C00C646688F8C75E659B0DC20]]></CLOSE_FACT_ACCT_GROUP_ID> - <OPEN_FACT_ACCT_GROUP_ID><![CDATA[E81BFA4982B94B91B8E0EC3D850E2122]]></OPEN_FACT_ACCT_GROUP_ID> + <CREATED><![CDATA[2014-03-31 12:37:57.994804]]></CREATED> + <CREATEDBY><![CDATA[100]]></CREATEDBY> + <UPDATED><![CDATA[2014-03-31 12:37:57.994804]]></UPDATED> + <UPDATEDBY><![CDATA[100]]></UPDATEDBY> + <C_YEAR_ID><![CDATA[BE903865711D408390B24C366B6C4099]]></C_YEAR_ID> + <AD_ORG_ACCTSCHEMA_ID><![CDATA[B6D5FF3A416C4371851ADA64EE9F0674]]></AD_ORG_ACCTSCHEMA_ID> + <REG_FACT_ACCT_GROUP_ID><![CDATA[A0DF960945BE41B4A00278D5770D1A3A]]></REG_FACT_ACCT_GROUP_ID> + <CLOSE_FACT_ACCT_GROUP_ID><![CDATA[0CFDA8741C794C2A844183B0A011D5EC]]></CLOSE_FACT_ACCT_GROUP_ID> + <DIVIDEUP_FACT_ACCT_GROUP_ID><![CDATA[336AFFE6BC794EA99145192A5B593DA1]]></DIVIDEUP_FACT_ACCT_GROUP_ID> + <OPEN_FACT_ACCT_GROUP_ID><![CDATA[B52DB25F41D541A9B35203F8FCFE7740]]></OPEN_FACT_ACCT_GROUP_ID> </AD_ORG_CLOSING> <AD_ORG_CLOSING> - <AD_ORG_CLOSING_ID><![CDATA[2426E8E07B964CFEBE4C7376FEA0196D]]></AD_ORG_CLOSING_ID> + <AD_ORG_CLOSING_ID><![CDATA[C944E83DA84442C5937A8CF0E82907DF]]></AD_ORG_CLOSING_ID> + <AD_CLIENT_ID><![CDATA[23C59575B9CF467C9620760EB255B389]]></AD_CLIENT_ID> + <AD_ORG_ID><![CDATA[2E60544D37534C0B89E765FE29BC0B43]]></AD_ORG_ID> + <ISACTIVE><![CDATA[Y]]></ISACTIVE> + <CREATED><![CDATA[2014-03-31 12:38:16.447107]]></CREATED> + <CREATEDBY><![CDATA[100]]></CREATEDBY> + <UPDATED><![CDATA[2014-03-31 12:38:16.447107]]></UPDATED> + <UPDATEDBY><![CDATA[100]]></UPDATEDBY> + <C_YEAR_ID><![CDATA[3BAAC4D19AEC4D65AEAE90971468013F]]></C_YEAR_ID> + <AD_ORG_ACCTSCHEMA_ID><![CDATA[B6D5FF3A416C4371851ADA64EE9F0674]]></AD_ORG_ACCTSCHEMA_ID> + <REG_FACT_ACCT_GROUP_ID><![CDATA[C8760CA749594FC094CC4AB3CA3DE92E]]></REG_FACT_ACCT_GROUP_ID> + <CLOSE_FACT_ACCT_GROUP_ID><![CDATA[0BDF2890DB4844E18EB78726008F8D3E]]></CLOSE_FACT_ACCT_GROUP_ID> + <DIVIDEUP_FACT_ACCT_GROUP_ID><![CDATA[3BEB84B12ABF41C7AC2D5AC170B5C590]]></DIVIDEUP_FACT_ACCT_GROUP_ID> + <OPEN_FACT_ACCT_GROUP_ID><![CDATA[56843E4BBC4B4CDBB9DA3045AABDB099]]></OPEN_FACT_ACCT_GROUP_ID> +</AD_ORG_CLOSING> + +<AD_ORG_CLOSING> + <AD_ORG_CLOSING_ID><![CDATA[D5FDFF78A7D947DAAE877FE0F7287FAE]]></AD_ORG_CLOSING_ID> <AD_CLIENT_ID><![CDATA[23C59575B9CF467C9620760EB255B389]]></AD_CLIENT_ID> <AD_ORG_ID><![CDATA[B843C30461EA4501935CB1D125C9C25A]]></AD_ORG_ID> <ISACTIVE><![CDATA[Y]]></ISACTIVE> - <CREATED><![CDATA[2013-07-04 23:45:43.683]]></CREATED> - <CREATEDBY><![CDATA[0]]></CREATEDBY> - <UPDATED><![CDATA[2013-07-04 23:45:43.683]]></UPDATED> - <UPDATEDBY><![CDATA[0]]></UPDATEDBY> - <C_YEAR_ID><![CDATA[BE903865711D408390B24C366B6C4099]]></C_YEAR_ID> - <AD_ORG_ACCTSCHEMA_ID><![CDATA[7583C0C800F14661B348A271ED276A14]]></AD_ORG_ACCTSCHEMA_ID> - <REG_FACT_ACCT_GROUP_ID><![CDATA[AD4550692C644EA5A4414D2CC96EAF43]]></REG_FACT_ACCT_GROUP_ID> - <CLOSE_FACT_ACCT_GROUP_ID><![CDATA[A69667E35EAF45D58A903F5301E10A9D]]></CLOSE_FACT_ACCT_GROUP_ID> - <OPEN_FACT_ACCT_GROUP_ID><![CDATA[941B3439012F4F45A0EEFDACD2678129]]></OPEN_FACT_ACCT_GROUP_ID> -</AD_ORG_CLOSING> - -<AD_ORG_CLOSING> - <AD_ORG_CLOSING_ID><![CDATA[5415D96E687F4AFD9B93B5FA166136BE]]></AD_ORG_CLOSING_ID> - <AD_CLIENT_ID><![CDATA[23C59575B9CF467C9620760EB255B389]]></AD_CLIENT_ID> - <AD_ORG_ID><![CDATA[2E60544D37534C0B89E765FE29BC0B43]]></AD_ORG_ID> - <ISACTIVE><![CDATA[Y]]></ISACTIVE> - <CREATED><![CDATA[2013-07-04 23:45:43.683]]></CREATED> - <CREATEDBY><![CDATA[0]]></CREATEDBY> - <UPDATED><![CDATA[2013-07-04 23:45:43.683]]></UPDATED> - <UPDATEDBY><![CDATA[0]]></UPDATEDBY> - <C_YEAR_ID><![CDATA[3BAAC4D19AEC4D65AEAE90971468013F]]></C_YEAR_ID> + <CREATED><![CDATA[2014-03-31 12:38:45.51547]]></CREATED> + <CREATEDBY><![CDATA[100]]></CREATEDBY> + <UPDATED><![CDATA[2014-03-31 12:38:45.51547]]></UPDATED> + <UPDATEDBY><![CDATA[100]]></UPDATEDBY> + <C_YEAR_ID><![CDATA[09E6CC5F7F6D4E8FA3DE5E120F7F9505]]></C_YEAR_ID> <AD_ORG_ACCTSCHEMA_ID><![CDATA[B6D5FF3A416C4371851ADA64EE9F0674]]></AD_ORG_ACCTSCHEMA_ID> - <REG_FACT_ACCT_GROUP_ID><![CDATA[240E20D4C7524344AFA1B8F0343BA8D1]]></REG_FACT_ACCT_GROUP_ID> - <CLOSE_FACT_ACCT_GROUP_ID><![CDATA[E2B37850C2A24742AEB675FFAE730453]]></CLOSE_FACT_ACCT_GROUP_ID> - <DIVIDEUP_FACT_ACCT_GROUP_ID><![CDATA[7EE285D2EB6A40269B7BABE994CF7C98]]></DIVIDEUP_FACT_ACCT_GROUP_ID> - <OPEN_FACT_ACCT_GROUP_ID><![CDATA[25854835D79F49BF94957A096D75F9C3]]></OPEN_FACT_ACCT_GROUP_ID> -</AD_ORG_CLOSING> - -<AD_ORG_CLOSING> - <AD_ORG_CLOSING_ID><![CDATA[A129EA168C7342DA852A0F97CADBFE9E]]></AD_ORG_CLOSING_ID> - <AD_CLIENT_ID><![CDATA[23C59575B9CF467C9620760EB255B389]]></AD_CLIENT_ID> - <AD_ORG_ID><![CDATA[2E60544D37534C0B89E765FE29BC0B43]]></AD_ORG_ID> - <ISACTIVE><![CDATA[Y]]></ISACTIVE> - <CREATED><![CDATA[2013-07-04 23:45:43.683]]></CREATED> - <CREATEDBY><![CDATA[0]]></CREATEDBY> - <UPDATED><![CDATA[2013-07-04 23:45:43.683]]></UPDATED> - <UPDATEDBY><![CDATA[0]]></UPDATEDBY> - <C_YEAR_ID><![CDATA[2B584DF89D2C4628AF0E391F07177F47]]></C_YEAR_ID> - <AD_ORG_ACCTSCHEMA_ID><![CDATA[B6D5FF3A416C4371851ADA64EE9F0674]]></AD_ORG_ACCTSCHEMA_ID> - <REG_FACT_ACCT_GROUP_ID><![CDATA[B8709DD8223A4DF8A9BCBDEF00FBBB21]]></REG_FACT_ACCT_GROUP_ID> - <CLOSE_FACT_ACCT_GROUP_ID><![CDATA[5E81AA015760468DB2765543BE0E776E]]></CLOSE_FACT_ACCT_GROUP_ID> - <DIVIDEUP_FACT_ACCT_GROUP_ID><![CDATA[DC2EC5CE84A540C3A079FBC10796D3D1]]></DIVIDEUP_FACT_ACCT_GROUP_ID> - <OPEN_FACT_ACCT_GROUP_ID><![CDATA[9EF399DD2B9B4705A6CC76A110D010B2]]></OPEN_FACT_ACCT_GROUP_ID> + <REG_FACT_ACCT_GROUP_ID><![CDATA[6F66A76BBD3E435BA13F120577A2666F]]></REG_FACT_ACCT_GROUP_ID> + <CLOSE_FACT_ACCT_GROUP_ID><![CDATA[4F458E5820F24D7E88ABB4231130000B]]></CLOSE_FACT_ACCT_GROUP_ID> + <DIVIDEUP_FACT_ACCT_GROUP_ID><![CDATA[0BE14C77621E43D59D481E4EE6408FD0]]></DIVIDEUP_FACT_ACCT_GROUP_ID> + <OPEN_FACT_ACCT_GROUP_ID><![CDATA[456B13CF9B85476A9EC3FB3F9F9124B4]]></OPEN_FACT_ACCT_GROUP_ID> </AD_ORG_CLOSING> </data> diff -r d0a8508115fc -r 7db94f11640b referencedata/sampledata/F_B_International_Group/AD_PINSTANCE.xml --- a/referencedata/sampledata/F_B_International_Group/AD_PINSTANCE.xml Sun Mar 30 20:47:04 2014 +0000 +++ b/referencedata/sampledata/F_B_International_Group/AD_PINSTANCE.xml Mon Mar 31 12:56:32 2014 +0200 @@ -588,6 +588,23 @@ </AD_PINSTANCE> <AD_PINSTANCE> + <AD_PINSTANCE_ID><![CDATA[032EC8DDE44B4648A24BBC350F7928BB]]></AD_PINSTANCE_ID> + <AD_PROCESS_ID><![CDATA[111]]></AD_PROCESS_ID> + <RECORD_ID><![CDATA[7778E2C3AD084FF18C5D32D8E4E2BFCE]]></RECORD_ID> + <ISPROCESSING><![CDATA[N]]></ISPROCESSING> + <CREATED><![CDATA[2014-03-24 17:09:13.846]]></CREATED> + <AD_USER_ID><![CDATA[100]]></AD_USER_ID> + <UPDATED><![CDATA[2014-03-24 17:09:13.0]]></UPDATED> + <RESULT><![CDATA[1]]></RESULT> + <ERRORMSG><![CDATA[]]></ERRORMSG> + <AD_CLIENT_ID><![CDATA[23C59575B9CF467C9620760EB255B389]]></AD_CLIENT_ID> + <AD_ORG_ID><![CDATA[E443A31992CB4635AFCAEABE7183CE85]]></AD_ORG_ID> + <CREATEDBY><![CDATA[100]]></CREATEDBY> + <UPDATEDBY><![CDATA[100]]></UPDATEDBY> + <ISACTIVE><![CDATA[Y]]></ISACTIVE> +</AD_PINSTANCE> + +<AD_PINSTANCE> <AD_PINSTANCE_ID><![CDATA[033E4572FD0440398B98A702CB145C72]]></AD_PINSTANCE_ID> <AD_PROCESS_ID><![CDATA[111]]></AD_PROCESS_ID> <RECORD_ID><![CDATA[88CEA9900DE84232AE87444B571B8DEC]]></RECORD_ID> @@ -636,6 +653,40 @@ </AD_PINSTANCE> <AD_PINSTANCE> + <AD_PINSTANCE_ID><![CDATA[03A496EA4C74431A9E77629EA338E374]]></AD_PINSTANCE_ID> + <AD_PROCESS_ID><![CDATA[199]]></AD_PROCESS_ID> + <RECORD_ID><![CDATA[0]]></RECORD_ID> + <ISPROCESSING><![CDATA[N]]></ISPROCESSING> + <CREATED><![CDATA[2014-03-24 20:11:20.063299]]></CREATED> + <AD_USER_ID><![CDATA[100]]></AD_USER_ID> + <UPDATED><![CDATA[2014-03-24 20:11:20.0]]></UPDATED> + <RESULT><![CDATA[1]]></RESULT> + <ERRORMSG><![CDATA[@OrderDocumentno@ 1000097 @InoutDocumentno@ 1000113: @ShipmentSuccess@.<br><br><br>]]></ERRORMSG> + <AD_CLIENT_ID><![CDATA[23C59575B9CF467C9620760EB255B389]]></AD_CLIENT_ID> + <AD_ORG_ID><![CDATA[E443A31992CB4635AFCAEABE7183CE85]]></AD_ORG_ID> + <CREATEDBY><![CDATA[100]]></CREATEDBY> + <UPDATEDBY><![CDATA[100]]></UPDATEDBY> + <ISACTIVE><![CDATA[Y]]></ISACTIVE> +</AD_PINSTANCE> + +<AD_PINSTANCE> + <AD_PINSTANCE_ID><![CDATA[03E3BE8EEEA14A228953979756B397BD]]></AD_PINSTANCE_ID> + <AD_PROCESS_ID><![CDATA[111]]></AD_PROCESS_ID> + <RECORD_ID><![CDATA[501EE4FBF639428A9F48EA0C1E1790D2]]></RECORD_ID> + <ISPROCESSING><![CDATA[N]]></ISPROCESSING> + <CREATED><![CDATA[2014-03-24 22:39:48.564]]></CREATED> + <AD_USER_ID><![CDATA[100]]></AD_USER_ID> + <UPDATED><![CDATA[2014-03-24 22:39:48.0]]></UPDATED> + <RESULT><![CDATA[1]]></RESULT> + <ERRORMSG><![CDATA[]]></ERRORMSG> + <AD_CLIENT_ID><![CDATA[23C59575B9CF467C9620760EB255B389]]></AD_CLIENT_ID> + <AD_ORG_ID><![CDATA[E443A31992CB4635AFCAEABE7183CE85]]></AD_ORG_ID> + <CREATEDBY><![CDATA[100]]></CREATEDBY> + <UPDATEDBY><![CDATA[100]]></UPDATEDBY> + <ISACTIVE><![CDATA[Y]]></ISACTIVE> +</AD_PINSTANCE> + +<AD_PINSTANCE> <AD_PINSTANCE_ID><![CDATA[03E8652F857543ABBD6B048F2CC2C4F0]]></AD_PINSTANCE_ID> <AD_PROCESS_ID><![CDATA[104]]></AD_PROCESS_ID> <RECORD_ID><![CDATA[7B6DBA1A0985452F8A35F5EC9F98EBE6]]></RECORD_ID> @@ -1012,6 +1063,22 @@ </AD_PINSTANCE> <AD_PINSTANCE> + <AD_PINSTANCE_ID><![CDATA[05FDCC51D00C4714B23F50866DE615DA]]></AD_PINSTANCE_ID> + <AD_PROCESS_ID><![CDATA[109]]></AD_PROCESS_ID> + <RECORD_ID><![CDATA[88D4CF5E4595432E8945DEA844ADB1F4]]></RECORD_ID> + <ISPROCESSING><![CDATA[N]]></ISPROCESSING> + <CREATED><![CDATA[2014-03-24 20:05:16.45065]]></CREATED> + <AD_USER_ID><![CDATA[100]]></AD_USER_ID> + <UPDATED><![CDATA[2014-03-24 20:05:16.0]]></UPDATED> + <RESULT><![CDATA[1]]></RESULT> + <AD_CLIENT_ID><![CDATA[23C59575B9CF467C9620760EB255B389]]></AD_CLIENT_ID> + <AD_ORG_ID><![CDATA[E443A31992CB4635AFCAEABE7183CE85]]></AD_ORG_ID> + <CREATEDBY><![CDATA[100]]></CREATEDBY> + <UPDATEDBY><![CDATA[100]]></UPDATEDBY> + <ISACTIVE><![CDATA[Y]]></ISACTIVE> +</AD_PINSTANCE> + +<AD_PINSTANCE> <AD_PINSTANCE_ID><![CDATA[0601F2EDA8B24DA4A2AF998AA1AB909E]]></AD_PINSTANCE_ID> <AD_PROCESS_ID><![CDATA[111]]></AD_PROCESS_ID> <RECORD_ID><![CDATA[C8A838CC44EC4BD7A583D41B1443EA63]]></RECORD_ID> @@ -1275,6 +1342,23 @@ </AD_PINSTANCE> ------------------------------------------------------------------------------ _______________________________________________ Openbravo-commits mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/openbravo-commits
