Merged cleanup branch (r3931) with trunk
authorAsier Lostalé <asier.lostale@openbravo.com>
Mon, 05 May 2008 06:59:24 +0000
changeset 799 fef2c5e2feb7
parent 798 4994e5a604bb
child 800 1ad8094b366f
Merged cleanup branch (r3931) with trunk
src-db/database/build.xml
src-db/database/masterdata/C_CURRENCY.xml
src-db/database/masterdata/C_DOCTYPE.xml
src-db/database/model/functions/AD_APPLICATION_IMPORT.xml
src-db/database/model/functions/AD_COLUMN_FORMAT.xml
src-db/database/model/functions/AD_COLUMN_SYNC.xml
src-db/database/model/functions/AD_DEVELOPMENT_MIGRATION.xml
src-db/database/model/functions/AD_DISPLAY_LIST.xml
src-db/database/model/functions/AD_LANGUAGE_CREATE.xml
src-db/database/model/functions/AD_MESSAGE_GET2.xml
src-db/database/model/functions/AD_PARENT_TREE.xml
src-db/database/model/functions/AD_PRINTPAPER_DEFAULT.xml
src-db/database/model/functions/AD_SYNCHRONIZE.xml
src-db/database/model/functions/AD_TABLE_IMPORT.xml
src-db/database/model/functions/AD_TAB_COPY.xml
src-db/database/model/functions/AD_TAB_IMPORT.xml
src-db/database/model/functions/AD_UPDATE_SEQUENCE.xml
src-db/database/model/functions/AD_WINDOW_COPY.xml
src-db/database/model/functions/A_ASSET_CREATE.xml
src-db/database/model/functions/A_ASSET_POST.xml
src-db/database/model/functions/A_ASSET_POST0.xml
src-db/database/model/functions/CLEVER_TO_NUMBER.xml
src-db/database/model/functions/COPY_PRODUCT_TEMPLATE.xml
src-db/database/model/functions/C_BPARTNER_REMITLOCATION.xml
src-db/database/model/functions/C_COMMISSIONRUN_PROCESS.xml
src-db/database/model/functions/C_CONVERTDOCUMENTNO_TO_NUMBER.xml
src-db/database/model/functions/C_CREATE_PINVOICE_FROM_OUTS.xml
src-db/database/model/functions/C_CURRENCY_RATE.xml
src-db/database/model/functions/C_DP_MANAGEMENT_POST.xml
src-db/database/model/functions/C_INVOICE_ACCTGEN.xml
src-db/database/model/functions/C_INVOICE_CANCEL.xml
src-db/database/model/functions/C_INVOICE_CREATE.xml
src-db/database/model/functions/C_INVOICE_DISCOUNT_OLD.xml
src-db/database/model/functions/C_INVOICE_POST.xml
src-db/database/model/functions/C_INVOICE_POST0.xml
src-db/database/model/functions/C_ORDER_DRILLDOWN.xml
src-db/database/model/functions/C_ORDER_POST1.xml
src-db/database/model/functions/C_ORDER_PO_CREATE.xml
src-db/database/model/functions/C_PAYMENTTERM_DISCOUNT.xml
src-db/database/model/functions/C_PAYMENTTERM_DUEDAYS.xml
src-db/database/model/functions/C_PAYMENTTERM_NOTE.xml
src-db/database/model/functions/C_REMITTANCE_POST.xml
src-db/database/model/functions/C_SETTLEMENT_POST.xml
src-db/database/model/functions/DATE_NULO.xml
src-db/database/model/functions/DBA_CLEANUP.xml
src-db/database/model/functions/DBA_COLUMN_DEFAULT.xml
src-db/database/model/functions/DBA_COLUMN_SCRIPT.xml
src-db/database/model/functions/DBA_CONSTRAINTCMD.xml
src-db/database/model/functions/DBA_CONST_SEARCHCOND.xml
src-db/database/model/functions/DBA_DISPLAYTYPE.xml
src-db/database/model/functions/DBA_FIX_CHANGEINCHARSET.xml
src-db/database/model/functions/DBA_REPLACE_CHANGEDCHARSET.xml
src-db/database/model/functions/DBA_VIEW_BODY.xml
src-db/database/model/functions/FACT_ACCT_BALANCE_UPDATE.xml
src-db/database/model/functions/FRIE_NAME.xml
src-db/database/model/functions/FRIE_VALUE.xml
src-db/database/model/functions/FRIE_VALUE2.xml
src-db/database/model/functions/GENERATEPOFROMPROJECT.xml
src-db/database/model/functions/GENERATESOFROMPROJECT.xml
src-db/database/model/functions/GENERATESOFROMPROJECTORDER.xml
src-db/database/model/functions/GENERATESOFROMPROJECTPHASE.xml
src-db/database/model/functions/INSERTAT.xml
src-db/database/model/functions/MA_COPY_VERSION.xml
src-db/database/model/functions/MA_GLOBALUSE_DISTRIBUTE.xml
src-db/database/model/functions/MA_MAINTENANCE_SCHEDULE.xml
src-db/database/model/functions/MA_MAINT_ALL.xml
src-db/database/model/functions/MA_MEASURE_SHIFT_EXPLODE.xml
src-db/database/model/functions/MA_MEASURE_TIME_EXPLODE.xml
src-db/database/model/functions/MA_PC_CASE_CREATE.xml
src-db/database/model/functions/MA_PRODUCTIONRUN_STANDARD.xml
src-db/database/model/functions/MA_PRODUCTION_COST.xml
src-db/database/model/functions/MA_STANDARD_COST.xml
src-db/database/model/functions/MA_WORKREQUIREMENT_CLOSE.xml
src-db/database/model/functions/MA_WORKREQUIREMENT_PROCESS.xml
src-db/database/model/functions/MA_WRPHASE_CLOSE.xml
src-db/database/model/functions/MRP_RUN_INITIALIZE.xml
src-db/database/model/functions/MRP_WORKREQUIREMENT.xml
src-db/database/model/functions/M_CHECK_STOCK.xml
src-db/database/model/functions/M_DISCOUNTSCHEMA_RESEQ.xml
src-db/database/model/functions/M_INOUT_CANCEL.xml
src-db/database/model/functions/M_INOUT_CREATE.xml
src-db/database/model/functions/M_INOUT_CREATEINVOICE.xml
src-db/database/model/functions/M_INOUT_POST.xml
src-db/database/model/functions/M_INTERNAL_CONSUMPTION_POST.xml
src-db/database/model/functions/M_PRODUCT_COSTINGUPDATE.xml
src-db/database/model/functions/M_RAPPEL_INVOICE_CREATE.xml
src-db/database/model/functions/M_REQUISITION_CREATEPO.xml
src-db/database/model/functions/M_UPDATE_PARETO_PRODUCT.xml
src-db/database/model/functions/SHOW_N_FIRST_CHARS.xml
src-db/database/model/functions/TEMPLATE.xml
src-db/database/model/functions/TRANSLATE_PRODUCT_ID.xml
src-db/database/model/functions/TRANSLATE_TAXCATEGORY_ID.xml
src-db/database/model/functions/T_INVENTORYVALUE_CREATE.xml
src-db/database/model/functions/USER_CONST_SEARCHCOND.xml
src-db/database/model/functions/W_REQUEST_BPARTNER.xml
src-db/database/model/functions/XX_COLUMN_IDENTIFIER.xml
src-db/database/model/postscript-Oracle.sql
src-db/database/model/postscript-PostgreSql.sql
src-db/database/model/sequences/AD_ERROR_SEQ.xml
src-db/database/model/sequences/AD_PINSTANCE_SEQ.xml
src-db/database/model/sequences/C_ALLOCATION_SEQ.xml
src-db/database/model/sequences/DBA_ERRORLOG_SEQ.xml
src-db/database/model/sequences/T_SPOOL_SEQ.xml
src-db/database/model/sequences/W_BASKET_SEQ.xml
src-db/database/model/tables/AD_ATTRIBUTE.xml
src-db/database/model/tables/AD_ATTRIBUTE_VALUE.xml
src-db/database/model/tables/AD_CLIENT.xml
src-db/database/model/tables/AD_CLIENTINFO.xml
src-db/database/model/tables/AD_COLOR.xml
src-db/database/model/tables/AD_COLUMN.xml
src-db/database/model/tables/AD_DESKTOP.xml
src-db/database/model/tables/AD_DESKTOPWORKBENCH.xml
src-db/database/model/tables/AD_DESKTOP_TRL.xml
src-db/database/model/tables/AD_ELEMENT.xml
src-db/database/model/tables/AD_ERROR.xml
src-db/database/model/tables/AD_FIELD.xml
src-db/database/model/tables/AD_FIND.xml
src-db/database/model/tables/AD_FORM.xml
src-db/database/model/tables/AD_MENU.xml
src-db/database/model/tables/AD_MESSAGE.xml
src-db/database/model/tables/AD_MODEL_OBJECT.xml
src-db/database/model/tables/AD_ORG.xml
src-db/database/model/tables/AD_ORGINFO.xml
src-db/database/model/tables/AD_PRINTCOLOR.xml
src-db/database/model/tables/AD_PRINTFONT.xml
src-db/database/model/tables/AD_PRINTFORM.xml
src-db/database/model/tables/AD_PRINTFORMAT.xml
src-db/database/model/tables/AD_PRINTFORMATITEM.xml
src-db/database/model/tables/AD_PRINTFORMATITEM_TRL.xml
src-db/database/model/tables/AD_PRINTGRAPH.xml
src-db/database/model/tables/AD_PRINTLABEL.xml
src-db/database/model/tables/AD_PRINTLABELLINE.xml
src-db/database/model/tables/AD_PRINTLABELLINE_TRL.xml
src-db/database/model/tables/AD_PRINTPAPER.xml
src-db/database/model/tables/AD_PRINTTABLEFORMAT.xml
src-db/database/model/tables/AD_PROCESS.xml
src-db/database/model/tables/AD_PROCESS_PARA.xml
src-db/database/model/tables/AD_REFERENCE.xml
src-db/database/model/tables/AD_REF_LIST.xml
src-db/database/model/tables/AD_REF_TABLE.xml
src-db/database/model/tables/AD_REPLICATION.xml
src-db/database/model/tables/AD_REPLICATIONSTRATEGY.xml
src-db/database/model/tables/AD_REPLICATIONTABLE.xml
src-db/database/model/tables/AD_REPLICATION_LOG.xml
src-db/database/model/tables/AD_REPLICATION_RUN.xml
src-db/database/model/tables/AD_REPORTVIEW.xml
src-db/database/model/tables/AD_REPORTVIEW_COL.xml
src-db/database/model/tables/AD_SEQUENCE.xml
src-db/database/model/tables/AD_SEQUENCE_AUDIT.xml
src-db/database/model/tables/AD_SEQUENCE_NO.xml
src-db/database/model/tables/AD_SYSTEM.xml
src-db/database/model/tables/AD_TAB.xml
src-db/database/model/tables/AD_TABLE.xml
src-db/database/model/tables/AD_TASK.xml
src-db/database/model/tables/AD_TASKINSTANCE.xml
src-db/database/model/tables/AD_TRACE.xml
src-db/database/model/tables/AD_USER.xml
src-db/database/model/tables/AD_USERDEF_FIELD.xml
src-db/database/model/tables/AD_USERDEF_TAB.xml
src-db/database/model/tables/AD_USERDEF_WIN.xml
src-db/database/model/tables/AD_VAL_RULE.xml
src-db/database/model/tables/AD_WF_INSTANCE.xml
src-db/database/model/tables/AD_WF_NODE.xml
src-db/database/model/tables/AD_WINDOW.xml
src-db/database/model/tables/AD_WORKBENCH.xml
src-db/database/model/tables/AD_WORKBENCHWINDOW.xml
src-db/database/model/tables/AD_WORKBENCH_TRL.xml
src-db/database/model/tables/AD_WORKFLOW.xml
src-db/database/model/tables/A_ASSET.xml
src-db/database/model/tables/A_ASSET_CHANGE.xml
src-db/database/model/tables/A_ASSET_DELIVERY.xml
src-db/database/model/tables/A_ASSET_RETIREMENT.xml
src-db/database/model/tables/A_DEPRECIATION.xml
src-db/database/model/tables/C_APPROVAL.xml
src-db/database/model/tables/C_BANKACCOUNT.xml
src-db/database/model/tables/C_BANKACCOUNTDOC.xml
src-db/database/model/tables/C_BANKSTATEMENTLINE.xml
src-db/database/model/tables/C_BPARTNER.xml
src-db/database/model/tables/C_BPARTNER_LOCATION.xml
src-db/database/model/tables/C_BP_BANKACCOUNT.xml
src-db/database/model/tables/C_BP_EDI.xml
src-db/database/model/tables/C_COSTTYPE.xml
src-db/database/model/tables/C_CURRENCY.xml
src-db/database/model/tables/C_CYCLE.xml
src-db/database/model/tables/C_CYCLEPHASE.xml
src-db/database/model/tables/C_CYCLESTEP.xml
src-db/database/model/tables/C_DOCTYPE.xml
src-db/database/model/tables/C_DOCTYPE_COPY.xml
src-db/database/model/tables/C_DOCTYPE_COPY_TRL.xml
src-db/database/model/tables/C_DUNNING.xml
src-db/database/model/tables/C_DUNNINGLEVEL.xml
src-db/database/model/tables/C_DUNNINGLEVEL_TRL.xml
src-db/database/model/tables/C_DUNNINGRUN.xml
src-db/database/model/tables/C_DUNNINGRUNENTRY.xml
src-db/database/model/tables/C_INVOICE.xml
src-db/database/model/tables/C_INVOICELINE.xml
src-db/database/model/tables/C_INVOICEPAYSCHEDULE.xml
src-db/database/model/tables/C_ORDER.xml
src-db/database/model/tables/C_ORDERLINE.xml
src-db/database/model/tables/C_PAYMENTTERM.xml
src-db/database/model/tables/C_PAYSCHEDULE.xml
src-db/database/model/tables/C_TAX.xml
src-db/database/model/tables/C_TAXCATEGORY.xml
src-db/database/model/tables/FACT_ACCT.xml
src-db/database/model/tables/FACT_ACCT_BALANCE.xml
src-db/database/model/tables/GL_BUDGET.xml
src-db/database/model/tables/GL_JOURNAL.xml
src-db/database/model/tables/I_GLJOURNAL.xml
src-db/database/model/tables/I_ORDER.xml
src-db/database/model/tables/I_REPORTLINE.xml
src-db/database/model/tables/K_CATEGORY.xml
src-db/database/model/tables/K_CATEGORYVALUE.xml
src-db/database/model/tables/K_COMMENT.xml
src-db/database/model/tables/K_ENTRY.xml
src-db/database/model/tables/K_ENTRYCATEGORY.xml
src-db/database/model/tables/K_ENTRYRELATED.xml
src-db/database/model/tables/K_SOURCE.xml
src-db/database/model/tables/K_SYNONYM.xml
src-db/database/model/tables/K_TOPIC.xml
src-db/database/model/tables/K_TYPE.xml
src-db/database/model/tables/MA_CALCSTD.xml
src-db/database/model/tables/MA_CCP_GROUP.xml
src-db/database/model/tables/MA_CONSUMEPRODUCT.xml
src-db/database/model/tables/MA_CONSUMERM.xml
src-db/database/model/tables/MA_DEFAULTPLAN.xml
src-db/database/model/tables/MA_MEASURE_GROUP.xml
src-db/database/model/tables/MA_MEASURE_SHIFT.xml
src-db/database/model/tables/MA_PL_EMPLOYEE.xml
src-db/database/model/tables/MA_PROCESS.xml
src-db/database/model/tables/MA_PRODUCTTYPE.xml
src-db/database/model/tables/MA_SEQUENCEPRODUCT.xml
src-db/database/model/tables/MA_SEQUENCEPRODUCT_COST.xml
src-db/database/model/tables/MA_WETECHNICALSUPPORT.xml
src-db/database/model/tables/MA_WORKREQUIREMENT.xml
src-db/database/model/tables/MA_WRPHASEPRODUCT.xml
src-db/database/model/tables/MRP_RUN_PURCHASE.xml
src-db/database/model/tables/M_ATTRIBUTE.xml
src-db/database/model/tables/M_ATTRIBUTESEARCH.xml
src-db/database/model/tables/M_DISCOUNTSCHEMABREAK.xml
src-db/database/model/tables/M_EDI.xml
src-db/database/model/tables/M_EDI_INFO.xml
src-db/database/model/tables/M_INOUT.xml
src-db/database/model/tables/M_INOUTLINE.xml
src-db/database/model/tables/M_INOUTLINE_TYPE.xml
src-db/database/model/tables/M_LOCATOR.xml
src-db/database/model/tables/M_LOCATOR_RENTING.xml
src-db/database/model/tables/M_PRODUCT.xml
src-db/database/model/tables/M_PRODUCTIONLINE.xml
src-db/database/model/tables/M_PRODUCTIONPLAN.xml
src-db/database/model/tables/M_PRODUCT_COSTING.xml
src-db/database/model/tables/M_REQUISITIONLINE.xml
src-db/database/model/tables/M_SHIPPER.xml
src-db/database/model/tables/M_WAREHOUSE.xml
src-db/database/model/tables/PA_ACHIEVEMENT.xml
src-db/database/model/tables/PA_COLOR.xml
src-db/database/model/tables/PA_GOAL.xml
src-db/database/model/tables/PA_MEASURE.xml
src-db/database/model/tables/PA_MEASURECALC.xml
src-db/database/model/tables/PA_REPORT.xml
src-db/database/model/tables/PA_REPORTCOLUMN.xml
src-db/database/model/tables/PA_REPORTCOLUMNSET.xml
src-db/database/model/tables/PA_REPORTLINE.xml
src-db/database/model/tables/PA_REPORTLINESET.xml
src-db/database/model/tables/PA_REPORTSOURCE.xml
src-db/database/model/tables/R_INTERESTAREA.xml
src-db/database/model/tables/R_RESOURCEPLANCOST.xml
src-db/database/model/tables/S_TIMEEXPENSE.xml
src-db/database/model/tables/S_TRAINING.xml
src-db/database/model/tables/S_TRAINING_CLASS.xml
src-db/database/model/tables/TIRE_STORAGE.xml
src-db/database/model/tables/T_REPORT.xml
src-db/database/model/tables/W_ADVERTISEMENT.xml
src-db/database/model/tables/W_BASKET.xml
src-db/database/model/tables/W_BASKETLINE.xml
src-db/database/model/tables/W_CLICK.xml
src-db/database/model/tables/W_CLICKCOUNT.xml
src-db/database/model/tables/W_COUNTER.xml
src-db/database/model/tables/W_COUNTERCOUNT.xml
src-db/database/model/triggers/AD_CLIENT_TRG.xml
src-db/database/model/triggers/AD_DESKTOP_TRG.xml
src-db/database/model/triggers/AD_MENU_TRG.xml
src-db/database/model/triggers/AD_ORG_TRG.xml
src-db/database/model/triggers/AD_PRINTFORMATITEM_BTRG.xml
src-db/database/model/triggers/AD_PRINTFORMATITEM_TRG.xml
src-db/database/model/triggers/AD_PRINTLABELLINE_TRG.xml
src-db/database/model/triggers/AD_TABLE_TRG.xml
src-db/database/model/triggers/AD_WORKBENCH_TRG.xml
src-db/database/model/triggers/A_ASSET_GROUP_TRG.xml
src-db/database/model/triggers/A_ASSET_TRG.xml
src-db/database/model/triggers/C_COUNTRY_TRG.xml
src-db/database/model/triggers/C_CURRENCY_TRG.xml
src-db/database/model/triggers/C_DOCTYPE_COPY_TRG.xml
src-db/database/model/triggers/C_DUNNINGLEVEL_TRG.xml
src-db/database/model/triggers/C_ELEMENTVALUE_TRG.xml
src-db/database/model/triggers/C_INVOICELINE_TRG.xml
src-db/database/model/triggers/C_INVOICELINE_TRG2.xml
src-db/database/model/triggers/C_ORDERLINE_TRG.xml
src-db/database/model/triggers/C_ORDLINE_CHK_RESTRICTIONS_TRG.xml
src-db/database/model/triggers/C_VALIDCOMBINATION_TRG.xml
src-db/database/model/triggers/M_IOLINE_CHK_RESTRICTIONS_TRG.xml
src-db/database/model/triggers/M_PRODUCT_TRG.xml
src-db/database/model/triggers/M_RAPPEL_INVOICE_TRG.xml
src-db/database/model/triggers/S_EXPENSETYPE_TRG.xml
src-db/database/model/triggers/S_RESOURCE_TRG.xml
src-db/database/model/triggers/S_TIMEEXPENSELINE_TRG.xml
src-db/database/model/triggers/S_TIMEEXPENSE_TRG.xml
src-db/database/model/views/AD_FIELD_V.xml
src-db/database/model/views/AD_FIELD_VT.xml
src-db/database/model/views/AD_TABLE_POST_V.xml
src-db/database/model/views/AD_TAB_V.xml
src-db/database/model/views/AD_TAB_VT.xml
src-db/database/model/views/AD_WINDOW_VT.xml
src-db/database/model/views/C_INVOICE_HEADER_V.xml
src-db/database/model/views/C_INVOICE_HEADER_VT.xml
src-db/database/model/views/C_INVOICE_V.xml
src-db/database/model/views/M_INOUT_LINE_V.xml
src-db/database/model/views/M_INOUT_LINE_VT.xml
src-db/database/model/views/RV_ASSET_CUSTOMER.xml
src-db/database/model/views/RV_ASSET_DELIVERY.xml
src-db/database/model/views/RV_C_INVOICE.xml
src-db/database/model/views/RV_ORDER_OPEN.xml
src-db/database/model/views/RV_PRODUCT_COSTING.xml
src-db/database/model/views/RV_PROJECTCYCLE.xml
src-db/database/sampledata/AD_ATTRIBUTE.xml
src-db/database/sampledata/AD_ATTRIBUTE_VALUE.xml
src-db/database/sampledata/AD_COLOR.xml
src-db/database/sampledata/AD_DESKTOP.xml
src-db/database/sampledata/AD_DESKTOPWORKBENCH.xml
src-db/database/sampledata/AD_DESKTOP_TRL.xml
src-db/database/sampledata/AD_ERROR.xml
src-db/database/sampledata/AD_FIND.xml
src-db/database/sampledata/AD_FORM_ACCESS.xml
src-db/database/sampledata/AD_HEARTBEAT_LOG.xml
src-db/database/sampledata/AD_PRINTCOLOR.xml
src-db/database/sampledata/AD_PRINTFONT.xml
src-db/database/sampledata/AD_PRINTFORM.xml
src-db/database/sampledata/AD_PRINTFORMAT.xml
src-db/database/sampledata/AD_PRINTFORMATITEM.xml
src-db/database/sampledata/AD_PRINTFORMATITEM_TRL.xml
src-db/database/sampledata/AD_PRINTGRAPH.xml
src-db/database/sampledata/AD_PRINTLABEL.xml
src-db/database/sampledata/AD_PRINTLABELLINE.xml
src-db/database/sampledata/AD_PRINTLABELLINE_TRL.xml
src-db/database/sampledata/AD_PRINTPAPER.xml
src-db/database/sampledata/AD_PRINTTABLEFORMAT.xml
src-db/database/sampledata/AD_PROCESS_ACCESS.xml
src-db/database/sampledata/AD_REGISTRATION_INFO.xml
src-db/database/sampledata/AD_REPORTVIEW.xml
src-db/database/sampledata/AD_REPORTVIEW_COL.xml
src-db/database/sampledata/AD_SEQUENCE.xml
src-db/database/sampledata/AD_SYSTEM_INFO.xml
src-db/database/sampledata/AD_TASKINSTANCE.xml
src-db/database/sampledata/AD_TASK_ACCESS.xml
src-db/database/sampledata/AD_TRACE.xml
src-db/database/sampledata/AD_USERDEF_FIELD.xml
src-db/database/sampledata/AD_USERDEF_TAB.xml
src-db/database/sampledata/AD_USERDEF_WIN.xml
src-db/database/sampledata/AD_WF_INSTANCE.xml
src-db/database/sampledata/AD_WINDOW_ACCESS.xml
src-db/database/sampledata/AD_WORKBENCH.xml
src-db/database/sampledata/AD_WORKBENCHWINDOW.xml
src-db/database/sampledata/AD_WORKBENCH_TRL.xml
src-db/database/sampledata/AD_WORKFLOW_ACCESS.xml
src-db/database/sampledata/A_ASSET_DELIVERY.xml
src-db/database/sampledata/A_ASSET_RETIREMENT.xml
src-db/database/sampledata/A_DEPRECIATION.xml
src-db/database/sampledata/C_APPROVAL.xml
src-db/database/sampledata/C_BANKACCOUNTDOC.xml
src-db/database/sampledata/C_BANKSTATEMENTLINE.xml
src-db/database/sampledata/C_BPARTNER.xml
src-db/database/sampledata/C_BP_BANKACCOUNT.xml
src-db/database/sampledata/C_BP_EDI.xml
src-db/database/sampledata/C_BP_SALCATEGORY.xml
src-db/database/sampledata/C_COSTTYPE.xml
src-db/database/sampledata/C_CYCLE.xml
src-db/database/sampledata/C_CYCLEPHASE.xml
src-db/database/sampledata/C_CYCLESTEP.xml
src-db/database/sampledata/C_DOCTYPE.xml
src-db/database/sampledata/C_DOCTYPE_COPY.xml
src-db/database/sampledata/C_DOCTYPE_COPY_TRL.xml
src-db/database/sampledata/C_DUNNING.xml
src-db/database/sampledata/C_DUNNINGLEVEL.xml
src-db/database/sampledata/C_DUNNINGLEVEL_TRL.xml
src-db/database/sampledata/C_DUNNINGRUN.xml
src-db/database/sampledata/C_DUNNINGRUNENTRY.xml
src-db/database/sampledata/C_INVOICE.xml
src-db/database/sampledata/C_INVOICEPAYSCHEDULE.xml
src-db/database/sampledata/C_ORDER.xml
src-db/database/sampledata/C_ORDERLINE.xml
src-db/database/sampledata/C_PAYMENTTERM.xml
src-db/database/sampledata/C_PAYSCHEDULE.xml
src-db/database/sampledata/C_TAX.xml
src-db/database/sampledata/C_TAXPAYMENT.xml
src-db/database/sampledata/C_TAXREGISTER.xml
src-db/database/sampledata/C_TAXREGISTERLINE.xml
src-db/database/sampledata/C_TAXREGISTER_TYPE.xml
src-db/database/sampledata/C_TAXREGISTER_TYPE_LINES.xml
src-db/database/sampledata/FACT_ACCT_BALANCE.xml
src-db/database/sampledata/GL_BUDGET.xml
src-db/database/sampledata/I_REPORTLINE.xml
src-db/database/sampledata/K_CATEGORY.xml
src-db/database/sampledata/K_CATEGORYVALUE.xml
src-db/database/sampledata/K_COMMENT.xml
src-db/database/sampledata/K_ENTRY.xml
src-db/database/sampledata/K_ENTRYCATEGORY.xml
src-db/database/sampledata/K_ENTRYRELATED.xml
src-db/database/sampledata/K_SOURCE.xml
src-db/database/sampledata/K_SYNONYM.xml
src-db/database/sampledata/K_TOPIC.xml
src-db/database/sampledata/K_TYPE.xml
src-db/database/sampledata/MA_CALCSTD.xml
src-db/database/sampledata/MA_CONSUMEPRODUCT.xml
src-db/database/sampledata/MA_CONSUMERM.xml
src-db/database/sampledata/MA_DEFAULTPLAN.xml
src-db/database/sampledata/MA_PRODUCTTYPE.xml
src-db/database/sampledata/MA_SEQUENCEPRODUCT_COST.xml
src-db/database/sampledata/MA_WETECHNICALSUPPORT.xml
src-db/database/sampledata/M_ATTRIBUTESEARCH.xml
src-db/database/sampledata/M_DISCOUNTSCHEMABREAK.xml
src-db/database/sampledata/M_EDI.xml
src-db/database/sampledata/M_EDI_INFO.xml
src-db/database/sampledata/M_INOUT.xml
src-db/database/sampledata/M_INOUTLINE_TYPE.xml
src-db/database/sampledata/M_LOCATOR.xml
src-db/database/sampledata/M_LOCATOR_RENTING.xml
src-db/database/sampledata/M_PRODUCTIONLINE.xml
src-db/database/sampledata/M_PRODUCT_COSTING.xml
src-db/database/sampledata/M_REQUISITIONORDER.xml
src-db/database/sampledata/M_WAREHOUSE.xml
src-db/database/sampledata/PA_ACHIEVEMENT.xml
src-db/database/sampledata/PA_COLOR.xml
src-db/database/sampledata/PA_GOAL.xml
src-db/database/sampledata/PA_MEASURE.xml
src-db/database/sampledata/PA_MEASURECALC.xml
src-db/database/sampledata/PA_REPORT.xml
src-db/database/sampledata/PA_REPORTCOLUMN.xml
src-db/database/sampledata/PA_REPORTCOLUMNSET.xml
src-db/database/sampledata/PA_REPORTLINE.xml
src-db/database/sampledata/PA_REPORTLINESET.xml
src-db/database/sampledata/PA_REPORTSOURCE.xml
src-db/database/sampledata/S_TIMEEXPENSE.xml
src-db/database/sampledata/S_TRAINING.xml
src-db/database/sampledata/S_TRAINING_CLASS.xml
src-db/database/sampledata/TIRE_STORAGE.xml
src-db/database/sampledata/T_REPORT.xml
src-db/database/sampledata/W_ADVERTISEMENT.xml
src-db/database/sampledata/W_BASKET.xml
src-db/database/sampledata/W_BASKETLINE.xml
src-db/database/sampledata/W_CLICK.xml
src-db/database/sampledata/W_CLICKCOUNT.xml
src-db/database/sampledata/W_COUNTER.xml
src-db/database/sampledata/W_COUNTERCOUNT.xml
src-db/database/sourcedata/AD_AUXILIARINPUT.xml
src-db/database/sourcedata/AD_CALLOUT.xml
src-db/database/sourcedata/AD_CLIENT.xml
src-db/database/sourcedata/AD_COLUMN.xml
src-db/database/sourcedata/AD_ELEMENT.xml
src-db/database/sourcedata/AD_FIELD.xml
src-db/database/sourcedata/AD_FORM.xml
src-db/database/sourcedata/AD_IMPFORMAT.xml
src-db/database/sourcedata/AD_IMPFORMAT_ROW.xml
src-db/database/sourcedata/AD_MENU.xml
src-db/database/sourcedata/AD_MESSAGE.xml
src-db/database/sourcedata/AD_MODEL_OBJECT.xml
src-db/database/sourcedata/AD_MODEL_OBJECT_MAPPING.xml
src-db/database/sourcedata/AD_PROCESS.xml
src-db/database/sourcedata/AD_PROCESS_PARA.xml
src-db/database/sourcedata/AD_REFERENCE.xml
src-db/database/sourcedata/AD_REF_LIST.xml
src-db/database/sourcedata/AD_REF_TABLE.xml
src-db/database/sourcedata/AD_TAB.xml
src-db/database/sourcedata/AD_TABLE.xml
src-db/database/sourcedata/AD_TASK.xml
src-db/database/sourcedata/AD_TREENODE.xml
src-db/database/sourcedata/AD_VAL_RULE.xml
src-db/database/sourcedata/AD_WF_NODE.xml
src-db/database/sourcedata/AD_WF_NODENEXT.xml
src-db/database/sourcedata/AD_WINDOW.xml
src-db/database/sourcedata/AD_WORKFLOW.xml
src-wad/src/org/openbravo/wad/controls/WADList.java
src/org/openbravo/base/secureApp/ClassInfo_data.xsql
src/org/openbravo/erpCommon/ad_actionButton/ChangeProjectStatus.html
src/org/openbravo/erpCommon/ad_actionButton/CopyFromInvoice_data.xsql
src/org/openbravo/erpCommon/ad_actionButton/CreateCloseFactAcct.html
src/org/openbravo/erpCommon/ad_actionButton/CreateFromMultiple.java
src/org/openbravo/erpCommon/ad_actionButton/CreateFromMultiple_Receipt.html
src/org/openbravo/erpCommon/ad_actionButton/CreateFromMultiple_Receipt.xml
src/org/openbravo/erpCommon/ad_actionButton/CreateFromMultiple_Receipt_data.xsql
src/org/openbravo/erpCommon/ad_actionButton/CreateFromMultiple_Shipment.html
src/org/openbravo/erpCommon/ad_actionButton/CreateFromMultiple_Shipment.xml
src/org/openbravo/erpCommon/ad_actionButton/CreateFromMultiple_Shipment_data.xsql
src/org/openbravo/erpCommon/ad_actionButton/CreateFrom_Bank.html
src/org/openbravo/erpCommon/ad_actionButton/CreateFrom_Bank_data.xsql
src/org/openbravo/erpCommon/ad_actionButton/CreateFrom_CRemittance.html
src/org/openbravo/erpCommon/ad_actionButton/CreateFrom_DPManagement.html
src/org/openbravo/erpCommon/ad_actionButton/CreateFrom_Invoice.html
src/org/openbravo/erpCommon/ad_actionButton/CreateFrom_Settlement.html
src/org/openbravo/erpCommon/ad_actionButton/CreateFrom_Shipment.html
src/org/openbravo/erpCommon/ad_actionButton/DocAction.html
src/org/openbravo/erpCommon/ad_actionButton/DropCloseFactAcct.html
src/org/openbravo/erpCommon/ad_actionButton/EditCCPMeasureValues.java
src/org/openbravo/erpCommon/ad_actionButton/EditCCPMeasureValues_F1.html
src/org/openbravo/erpCommon/ad_actionButton/EditCCPMeasureValues_F1.xml
src/org/openbravo/erpCommon/ad_actionButton/EditCCPMeasureValues_data.xsql
src/org/openbravo/erpCommon/ad_actionButton/ExpenseSOrder.html
src/org/openbravo/erpCommon/ad_actionButton/ExpenseSOrder.java
src/org/openbravo/erpCommon/ad_actionButton/ExpenseSOrder_data.xsql
src/org/openbravo/erpCommon/ad_actionButton/ImportProduct.html
src/org/openbravo/erpCommon/ad_actionButton/InvoicingSchedule_data.xsql
src/org/openbravo/erpCommon/ad_actionButton/ProjectSetType.html
src/org/openbravo/erpCommon/ad_actionButton/UpdateMaintenanceScheduled_F1.html
src/org/openbravo/erpCommon/ad_background/PeriodicAcctServer.java
src/org/openbravo/erpCommon/ad_background/PeriodicAlert.java
src/org/openbravo/erpCommon/ad_callouts/SE_InOut_DocType_data.xsql
src/org/openbravo/erpCommon/ad_callouts/SE_Order_BPartner_data.xsql
src/org/openbravo/erpCommon/ad_callouts/SL_CCPMeasure_Group.java
src/org/openbravo/erpCommon/ad_callouts/SL_CCPMeasure_Group_data.xsql
src/org/openbravo/erpCommon/ad_callouts/SL_CreateFromMultiple_Warehouse.java
src/org/openbravo/erpCommon/ad_callouts/SL_Invoice_DocType.java
src/org/openbravo/erpCommon/ad_callouts/SL_Locator_Renting.java
src/org/openbravo/erpCommon/ad_callouts/SL_Locator_Renting_data.xsql
src/org/openbravo/erpCommon/ad_callouts/SL_MInOutTraceReports.java
src/org/openbravo/erpCommon/ad_callouts/SL_MInOutTraceReports_data.xsql
src/org/openbravo/erpCommon/ad_callouts/SL_Order_DocType.java
src/org/openbravo/erpCommon/ad_callouts/SL_Order_DocType_data.xsql
src/org/openbravo/erpCommon/ad_callouts/SL_Order_Lastprice.java
src/org/openbravo/erpCommon/ad_callouts/SL_Order_Product.java
src/org/openbravo/erpCommon/ad_callouts/SL_Order_Product_data.xsql
src/org/openbravo/erpCommon/ad_combos/PaymentRuleCombo_data.xsql
src/org/openbravo/erpCommon/ad_forms/AcctServer.java
src/org/openbravo/erpCommon/ad_forms/AcctServer_data.xsql
src/org/openbravo/erpCommon/ad_forms/AlertManagement.html
src/org/openbravo/erpCommon/ad_forms/BackgroundProcessList.html
src/org/openbravo/erpCommon/ad_forms/CallAcctServer.html
src/org/openbravo/erpCommon/ad_forms/DebtPaymentUnapply.html
src/org/openbravo/erpCommon/ad_forms/DocAmortization.java
src/org/openbravo/erpCommon/ad_forms/DocAmortization_data.xsql
src/org/openbravo/erpCommon/ad_forms/DocBank.java
src/org/openbravo/erpCommon/ad_forms/DocDPManagement.java
src/org/openbravo/erpCommon/ad_forms/DocDPManagement_data.xsql
src/org/openbravo/erpCommon/ad_forms/DocInOut.java
src/org/openbravo/erpCommon/ad_forms/DocInOut_data.xsql
src/org/openbravo/erpCommon/ad_forms/DocInvoice.java
src/org/openbravo/erpCommon/ad_forms/DocInvoice_data.xsql
src/org/openbravo/erpCommon/ad_forms/DocLine.java
src/org/openbravo/erpCommon/ad_forms/DocLineAmortization_data.xsql
src/org/openbravo/erpCommon/ad_forms/DocLineBank_data.xsql
src/org/openbravo/erpCommon/ad_forms/DocLineDPManagement_data.xsql
src/org/openbravo/erpCommon/ad_forms/DocLineInvoice_data.xsql
src/org/openbravo/erpCommon/ad_forms/DocLinePayment_data.xsql
src/org/openbravo/erpCommon/ad_forms/DocLine_Amortization.java
src/org/openbravo/erpCommon/ad_forms/DocLine_Bank.java
src/org/openbravo/erpCommon/ad_forms/DocLine_DPManagement.java
src/org/openbravo/erpCommon/ad_forms/DocLine_Material.java
src/org/openbravo/erpCommon/ad_forms/DocLine_Payment.java
src/org/openbravo/erpCommon/ad_forms/DocOrder.java
src/org/openbravo/erpCommon/ad_forms/DocOrder_data.xsql
src/org/openbravo/erpCommon/ad_forms/DocPayment.java
src/org/openbravo/erpCommon/ad_forms/DocPayment_data.xsql
src/org/openbravo/erpCommon/ad_forms/EdiFileImport.html
src/org/openbravo/erpCommon/ad_forms/EdiFileImport_data.xsql
src/org/openbravo/erpCommon/ad_forms/Fact.java
src/org/openbravo/erpCommon/ad_forms/FactLine.java
src/org/openbravo/erpCommon/ad_forms/FactLine_data.xsql
src/org/openbravo/erpCommon/ad_forms/FileImport.html
src/org/openbravo/erpCommon/ad_forms/GenerateInvoicesmanual.html
src/org/openbravo/erpCommon/ad_forms/GenerateShipmentsmanual.html
src/org/openbravo/erpCommon/ad_forms/InformeInOut.html
src/org/openbravo/erpCommon/ad_forms/InformeInOut_Excel.html
src/org/openbravo/erpCommon/ad_forms/InformeInOut_Excel.xml
src/org/openbravo/erpCommon/ad_forms/InformeInOut_data.xsql
src/org/openbravo/erpCommon/ad_forms/InitialClientSetup.html
src/org/openbravo/erpCommon/ad_forms/InitialClientSetup.java
src/org/openbravo/erpCommon/ad_forms/InitialClientSetup_data.xsql
src/org/openbravo/erpCommon/ad_forms/InvoiceVendorMultiline.html
src/org/openbravo/erpCommon/ad_forms/InvoiceVendorMultiline.java
src/org/openbravo/erpCommon/ad_forms/InvoiceVendorMultiline_Lines.java
src/org/openbravo/erpCommon/ad_forms/InvoiceVendorMultiline_Lines_data.xsql
src/org/openbravo/erpCommon/ad_forms/InvoiceVendorMultiline_data.xsql
src/org/openbravo/erpCommon/ad_forms/MatchingPO-Receipt-Invoice_F1.html
src/org/openbravo/erpCommon/ad_forms/MaterialReceiptPending.html
src/org/openbravo/erpCommon/ad_forms/MaterialReceiptPending.java
src/org/openbravo/erpCommon/ad_forms/MaterialReceiptPendingLines_data.xsql
src/org/openbravo/erpCommon/ad_forms/MaterialReceiptPending_data.xsql
src/org/openbravo/erpCommon/ad_forms/MaterialTransactions.html
src/org/openbravo/erpCommon/ad_forms/MaterialTransactions_F1.html
src/org/openbravo/erpCommon/ad_forms/ProductInfo.java
src/org/openbravo/erpCommon/ad_forms/ProductInfo_data.xsql
src/org/openbravo/erpCommon/ad_forms/RemittanceCancel.html
src/org/openbravo/erpCommon/ad_forms/RequisitionToOrder.html
src/org/openbravo/erpCommon/ad_forms/RequisitionToOrder.java
src/org/openbravo/erpCommon/ad_forms/RequisitionToOrder_data.xsql
src/org/openbravo/erpCommon/ad_forms/SQLExecutor.html
src/org/openbravo/erpCommon/ad_forms/ShowSessionPreferences.html
src/org/openbravo/erpCommon/ad_forms/ShowSessionVariables.html
src/org/openbravo/erpCommon/ad_forms/Translation.html
src/org/openbravo/erpCommon/ad_process/AssetDelivery_data.xsql
src/org/openbravo/erpCommon/ad_process/CashBankOperations.html
src/org/openbravo/erpCommon/ad_process/ChangeOrderOrg.html
src/org/openbravo/erpCommon/ad_process/CopyFromGLJournal.java
src/org/openbravo/erpCommon/ad_process/CopyFromGLJournal_F1.html
src/org/openbravo/erpCommon/ad_process/CopyFromGLJournal_data.xsql
src/org/openbravo/erpCommon/ad_process/CreateAccountingReport.html
src/org/openbravo/erpCommon/ad_process/CreateAccountingReport.java
src/org/openbravo/erpCommon/ad_process/CreateAccountingReport_data.xsql
src/org/openbravo/erpCommon/ad_process/CreateCashFlowStatement.html
src/org/openbravo/erpCommon/ad_process/CreateTaxReport.html
src/org/openbravo/erpCommon/ad_process/CreateTaxReport.java
src/org/openbravo/erpCommon/ad_process/CreateTaxReport_data.xsql
src/org/openbravo/erpCommon/ad_process/DeleteClient.html
src/org/openbravo/erpCommon/ad_process/ExpenseAPInvoice.html
src/org/openbravo/erpCommon/ad_process/ExpenseAPInvoice.java
src/org/openbravo/erpCommon/ad_process/ExpenseAPInvoice_data.xsql
src/org/openbravo/erpCommon/ad_process/GenerateHelp.html
src/org/openbravo/erpCommon/ad_process/ImportBudget.java
src/org/openbravo/erpCommon/ad_process/ImportBudgetServlet.java
src/org/openbravo/erpCommon/ad_process/ImportBudget_data.xsql
src/org/openbravo/erpCommon/ad_process/ImportOrder.java
src/org/openbravo/erpCommon/ad_process/ImportOrder_data.xsql
src/org/openbravo/erpCommon/ad_process/ImportTax.java
src/org/openbravo/erpCommon/ad_process/ImportTaxServlet.java
src/org/openbravo/erpCommon/ad_process/ImportTax_data.xsql
src/org/openbravo/erpCommon/ad_process/PriceListCreateAll.html
src/org/openbravo/erpCommon/ad_process/PrintInvoices.html
src/org/openbravo/erpCommon/ad_process/SendMailText.html
src/org/openbravo/erpCommon/ad_reports/ABCbPartner.html
src/org/openbravo/erpCommon/ad_reports/ABCproduct.html
src/org/openbravo/erpCommon/ad_reports/GeneralAccountingReports.html
src/org/openbravo/erpCommon/ad_reports/GenerateModel347.html
src/org/openbravo/erpCommon/ad_reports/MInOutTraceReports.html
src/org/openbravo/erpCommon/ad_reports/MInOutTraceReportsEdit.html
src/org/openbravo/erpCommon/ad_reports/ReportAccountingCountDimensionalAnalysesEdit.html
src/org/openbravo/erpCommon/ad_reports/ReportAccountingCountDimensionalAnalysesFilter.html
src/org/openbravo/erpCommon/ad_reports/ReportAgingBalance.html
src/org/openbravo/erpCommon/ad_reports/ReportAnnualCertification.html
src/org/openbravo/erpCommon/ad_reports/ReportBank.html
src/org/openbravo/erpCommon/ad_reports/ReportBankEdit.html
src/org/openbravo/erpCommon/ad_reports/ReportBankJR.html
src/org/openbravo/erpCommon/ad_reports/ReportBudgetGenerateExcel.html
src/org/openbravo/erpCommon/ad_reports/ReportCash.html
src/org/openbravo/erpCommon/ad_reports/ReportCashEdit.html
src/org/openbravo/erpCommon/ad_reports/ReportCashFlow.html
src/org/openbravo/erpCommon/ad_reports/ReportCashFlow_F1.html
src/org/openbravo/erpCommon/ad_reports/ReportCashJR.html
src/org/openbravo/erpCommon/ad_reports/ReportCashflowForecast.html
src/org/openbravo/erpCommon/ad_reports/ReportDebtPayment.html
src/org/openbravo/erpCommon/ad_reports/ReportDebtPaymentTrack.html
src/org/openbravo/erpCommon/ad_reports/ReportExpense.html
src/org/openbravo/erpCommon/ad_reports/ReportExpenseEdit.html
src/org/openbravo/erpCommon/ad_reports/ReportGeneralLedger.html
src/org/openbravo/erpCommon/ad_reports/ReportGeneralLedgerJournal.html
src/org/openbravo/erpCommon/ad_reports/ReportGeneralLedgerJournalDetail.html
src/org/openbravo/erpCommon/ad_reports/ReportGuaranteeDateJR.html
src/org/openbravo/erpCommon/ad_reports/ReportInventory.html
src/org/openbravo/erpCommon/ad_reports/ReportInventoryEdit.html
src/org/openbravo/erpCommon/ad_reports/ReportInvoiceCustomerDimensionalAnalysesFilter.html
src/org/openbravo/erpCommon/ad_reports/ReportInvoiceCustomerDimensionalAnalysesJRFilter.html
src/org/openbravo/erpCommon/ad_reports/ReportInvoiceCustomerFilter.html
src/org/openbravo/erpCommon/ad_reports/ReportInvoiceCustomerFilterJR.html
src/org/openbravo/erpCommon/ad_reports/ReportInvoiceDiscount.html
src/org/openbravo/erpCommon/ad_reports/ReportInvoiceDiscountEdit.html
src/org/openbravo/erpCommon/ad_reports/ReportInvoiceDiscountJR.html
src/org/openbravo/erpCommon/ad_reports/ReportInvoiceVendorDimensionalAnalysesFilterJR.html
src/org/openbravo/erpCommon/ad_reports/ReportInvoiceVendorFilterJR.html
src/org/openbravo/erpCommon/ad_reports/ReportInvoices.html
src/org/openbravo/erpCommon/ad_reports/ReportInvoicesEdit.html
src/org/openbravo/erpCommon/ad_reports/ReportInvoicesJR.html
src/org/openbravo/erpCommon/ad_reports/ReportMaterialDimensionalAnalysesFilterJR.html
src/org/openbravo/erpCommon/ad_reports/ReportMaterialTransactionEditionJR.html
src/org/openbravo/erpCommon/ad_reports/ReportMaterialTransactionFilter.html
src/org/openbravo/erpCommon/ad_reports/ReportNotPosted.html
src/org/openbravo/erpCommon/ad_reports/ReportOffer.html
src/org/openbravo/erpCommon/ad_reports/ReportOrderNotInvoiceFilterJR.html
src/org/openbravo/erpCommon/ad_reports/ReportParetoProduct.html
src/org/openbravo/erpCommon/ad_reports/ReportPaymentFilter.html
src/org/openbravo/erpCommon/ad_reports/ReportPendingProductionEditJr.html
src/org/openbravo/erpCommon/ad_reports/ReportPendingProductionJr.html
src/org/openbravo/erpCommon/ad_reports/ReportPricelist.html
src/org/openbravo/erpCommon/ad_reports/ReportProductMovement.html
src/org/openbravo/erpCommon/ad_reports/ReportProduction.html
src/org/openbravo/erpCommon/ad_reports/ReportProductionCost.html
src/org/openbravo/erpCommon/ad_reports/ReportProductionJR.html
src/org/openbravo/erpCommon/ad_reports/ReportProductionRunJR.html
src/org/openbravo/erpCommon/ad_reports/ReportProjectBuildingSite.html
src/org/openbravo/erpCommon/ad_reports/ReportProjectBuildingSiteJR.html
src/org/openbravo/erpCommon/ad_reports/ReportProjectProfitabilityJR.html
src/org/openbravo/erpCommon/ad_reports/ReportPurchaseDimensionalAnalysesFilterJR.html
src/org/openbravo/erpCommon/ad_reports/ReportRawMaterial_data.xsql
src/org/openbravo/erpCommon/ad_reports/ReportRefundInvoiceCustomerDimensionalAnalysesFilter.html
src/org/openbravo/erpCommon/ad_reports/ReportRefundSalesDimensionalAnalysesFilter.html
src/org/openbravo/erpCommon/ad_reports/ReportRegisterFilter.html
src/org/openbravo/erpCommon/ad_reports/ReportSalesDimensionalAnalyzeJRFilter.html
src/org/openbravo/erpCommon/ad_reports/ReportSalesOrderFilterJR.html
src/org/openbravo/erpCommon/ad_reports/ReportSalesOrderInvoicedJasper.html
src/org/openbravo/erpCommon/ad_reports/ReportSalesOrderOpenItem.html
src/org/openbravo/erpCommon/ad_reports/ReportSalesOrderOpenItemJR.html
src/org/openbravo/erpCommon/ad_reports/ReportSalesOrderProvidedJR.html
src/org/openbravo/erpCommon/ad_reports/ReportShipmentDimensionalAnalyzeJRFilter.html
src/org/openbravo/erpCommon/ad_reports/ReportShipmentFilterJR.html
src/org/openbravo/erpCommon/ad_reports/ReportShipper.html
src/org/openbravo/erpCommon/ad_reports/ReportStandardCostJRFilter.html
src/org/openbravo/erpCommon/ad_reports/ReportTaxInvoice.html
src/org/openbravo/erpCommon/ad_reports/ReportTaxInvoiceEdit.html
src/org/openbravo/erpCommon/ad_reports/ReportToInvoiceConsignment.html
src/org/openbravo/erpCommon/ad_reports/ReportToInvoiceConsignmentJR.html
src/org/openbravo/erpCommon/ad_reports/ReportTotalProductTemplate.html
src/org/openbravo/erpCommon/ad_reports/ReportTotalProductTemplateEdit.html
src/org/openbravo/erpCommon/ad_reports/ReportTrialBalance.html
src/org/openbravo/erpCommon/ad_reports/ReportTrialBalanceDetail.html
src/org/openbravo/erpCommon/ad_reports/ReportValuationStock.html
src/org/openbravo/erpCommon/ad_reports/ReportWarehouseControl.html
src/org/openbravo/erpCommon/ad_reports/ReportWarehouseDetailInventoryJR.html
src/org/openbravo/erpCommon/ad_reports/ReportWarehousePartnerJR.html
src/org/openbravo/erpCommon/ad_reports/ReportWorkRequirementDaily.html
src/org/openbravo/erpCommon/ad_reports/ReportWorkRequirementDailyEnv.html
src/org/openbravo/erpCommon/ad_reports/ReportWorkRequirementDailyEnvEdit.html
src/org/openbravo/erpCommon/ad_reports/ReportWorkRequirementJR.html
src/org/openbravo/erpCommon/ad_reports/Rpt_Etiquetas_Config.html
src/org/openbravo/erpCommon/businessUtility/Buscador.html
src/org/openbravo/erpCommon/businessUtility/Buscador.java
src/org/openbravo/erpCommon/businessUtility/WindowTabs_data.xsql
src/org/openbravo/erpCommon/info/Account.html
src/org/openbravo/erpCommon/info/AttributeSetInstance.java
src/org/openbravo/erpCommon/info/AttributeSetInstance_F1.html
src/org/openbravo/erpCommon/info/CashJournal_F1.html
src/org/openbravo/erpCommon/info/DebtPayment.html
src/org/openbravo/erpCommon/info/ImageInfo_F1.html
src/org/openbravo/erpCommon/info/Invoice.html
src/org/openbravo/erpCommon/info/Invoice.java
src/org/openbravo/erpCommon/info/Invoice_data.xsql
src/org/openbravo/erpCommon/info/Location_F1.html
src/org/openbravo/erpCommon/info/Organization_data.xsql
src/org/openbravo/erpCommon/info/Product.html
src/org/openbravo/erpCommon/info/ProductComplete.html
src/org/openbravo/erpCommon/info/ProductMultiple.html
src/org/openbravo/erpCommon/info/UserContact_F1.html
src/org/openbravo/erpCommon/security/Login_F1.html
src/org/openbravo/erpCommon/security/Login_Options_F1.html
src/org/openbravo/erpCommon/utility/DocumentNo_data.xsql
src/org/openbravo/erpCommon/utility/Menu_data.xsql
src/org/openbravo/erpCommon/utility/SetPriority.html
src/org/openbravo/erpCommon/utility/TableSQLData.java
src/org/openbravo/erpCommon/utility/TableSQLQuery_data.xsql
src/org/openbravo/erpCommon/utility/WindowTreeUtility.java
src/org/openbravo/erpCommon/utility/WindowTree_data.xsql
src/org/openbravo/erpCommon/ws/externalSales/ExternalSalesIOrder_data.xsql
src/org/openbravo/erpReports/RptC_Invoice_TaxLines.jrxml
src/org/openbravo/erpReports/RptC_Invoice_Tax_data.xsql
src/org/openbravo/erpReports/RptMA_CCP_Measures.fo
src/org/openbravo/erpReports/RptMA_CCP_Measures.xml
src/org/openbravo/erpReports/RptMA_CCP_Measures_data.xsql
src/org/openbravo/erpReports/RptMA_ProcessPlan.jrxml
src/org/openbravo/erpReports/RptMA_ProcessPlan_data.xsql
src/org/openbravo/erpReports/RptM_InoutLines.fo
src/org/openbravo/erpReports/RptM_InoutLines.xml
src/org/openbravo/erpReports/RptM_Inout_Lines_data.xsql
src/org/openbravo/erpReports/RptM_MovementLines.fo
src/org/openbravo/erpReports/RptM_MovementLines.xml
src/org/openbravo/erpReports/RptM_Movement_data.xsql
src/org/openbravo/erpReports/RptPromissoryNoteAfter_data.xsql
src/org/openbravo/erpReports/RptPromissoryNoteError_data.xsql
--- a/src-db/database/build.xml	Wed Apr 30 10:48:47 2008 +0000
+++ b/src-db/database/build.xml	Mon May 05 06:59:24 2008 +0000
@@ -442,8 +442,8 @@
         </classpath>
         <transaction>
           DELETE FROM AD_SYSTEM;
-          INSERT INTO AD_SYSTEM (AD_SYSTEM_ID, AD_CLIENT_ID, AD_ORG_ID, ISACTIVE, CREATED, CREATEDBY, UPDATED, UPDATEDBY, NAME, SUPPORTUNITS, TAD_RECORDRANGE, TAD_RECORDRANGE_INFO, TAD_LEVEL, TAD_PARENT_VERSION, TAD_TRANSACTIONALRANGE, TAD_THEME)
-          VALUES (0, 0, 0, 'Y', NOW(), 0, NOW(), 0, '?', 0, 20, 100, ${development.environment.id}, '$Rev$', 1, 'Default');
+          INSERT INTO AD_SYSTEM (AD_SYSTEM_ID, AD_CLIENT_ID, AD_ORG_ID, ISACTIVE, CREATED, CREATEDBY, UPDATED, UPDATEDBY, NAME, TAD_RECORDRANGE, TAD_RECORDRANGE_INFO, TAD_LEVEL, TAD_PARENT_VERSION, TAD_TRANSACTIONALRANGE, TAD_THEME)
+          VALUES (0, 0, 0, 'Y', NOW(), 0, NOW(), 0, '?', 20, 100, ${development.environment.id}, '$Rev$', 1, 'Default');
           CALL AD_UPDATE_SEQUENCE();
           CALL AD_UPDATE_ACCESS();
         </transaction>
@@ -465,8 +465,8 @@
         </classpath>
         <transaction>
           DELETE FROM AD_SYSTEM;
-          INSERT INTO AD_SYSTEM (AD_SYSTEM_ID, AD_CLIENT_ID, AD_ORG_ID, ISACTIVE, CREATED, CREATEDBY, UPDATED, UPDATEDBY, NAME, SUPPORTUNITS, TAD_RECORDRANGE, TAD_RECORDRANGE_INFO, TAD_LEVEL, TAD_PARENT_VERSION, TAD_TRANSACTIONALRANGE, TAD_THEME)
-          VALUES (0, 0, 0, 'Y', NOW(), 0, NOW(), 0, '?', 0, 20, 100, ${development.environment.id}, '$Rev$', 1, 'Default');
+          INSERT INTO AD_SYSTEM (AD_SYSTEM_ID, AD_CLIENT_ID, AD_ORG_ID, ISACTIVE, CREATED, CREATEDBY, UPDATED, UPDATEDBY, NAME, TAD_RECORDRANGE, TAD_RECORDRANGE_INFO, TAD_LEVEL, TAD_PARENT_VERSION, TAD_TRANSACTIONALRANGE, TAD_THEME)
+          VALUES (0, 0, 0, 'Y', NOW(), 0, NOW(), 0, '?', 20, 100, ${development.environment.id}, '$Rev$', 1, 'Default');
           SELECT AD_UPDATE_SEQUENCE();
           SELECT AD_UPDATE_ACCESS();
         </transaction>
--- a/src-db/database/masterdata/C_CURRENCY.xml	Wed Apr 30 10:48:47 2008 +0000
+++ b/src-db/database/masterdata/C_CURRENCY.xml	Mon May 05 06:59:24 2008 +0000
@@ -32,12 +32,6 @@
 <!--100-->              <STDPRECISION><![CDATA[2]]></STDPRECISION>
 <!--100 COSTINGPRECISION-->
 <!--100-->              <COSTINGPRECISION><![CDATA[4]]></COSTINGPRECISION>
-<!--100 ISEURO-->
-<!--100-->              <ISEURO><![CDATA[N]]></ISEURO>
-<!--100 ISEMUMEMBER-->
-<!--100-->              <ISEMUMEMBER><![CDATA[N]]></ISEMUMEMBER>
-<!--100 EMURATE-->
-<!--100-->              <EMURATE><![CDATA[0]]></EMURATE>
 <!--100 PRICEPRECISION-->
 <!--100-->              <PRICEPRECISION><![CDATA[0]]></PRICEPRECISION>
 <!--100**************--></C_CURRENCY>
@@ -69,12 +63,6 @@
 <!--102-->              <STDPRECISION><![CDATA[2]]></STDPRECISION>
 <!--102 COSTINGPRECISION-->
 <!--102-->              <COSTINGPRECISION><![CDATA[4]]></COSTINGPRECISION>
-<!--102 ISEURO-->
-<!--102-->              <ISEURO><![CDATA[Y]]></ISEURO>
-<!--102 ISEMUMEMBER-->
-<!--102-->              <ISEMUMEMBER><![CDATA[N]]></ISEMUMEMBER>
-<!--102 EMURATE-->
-<!--102-->              <EMURATE><![CDATA[0]]></EMURATE>
 <!--102 PRICEPRECISION-->
 <!--102-->              <PRICEPRECISION><![CDATA[4]]></PRICEPRECISION>
 <!--102**************--></C_CURRENCY>
@@ -106,14 +94,6 @@
 <!--103-->              <STDPRECISION><![CDATA[2]]></STDPRECISION>
 <!--103 COSTINGPRECISION-->
 <!--103-->              <COSTINGPRECISION><![CDATA[4]]></COSTINGPRECISION>
-<!--103 ISEURO-->
-<!--103-->              <ISEURO><![CDATA[N]]></ISEURO>
-<!--103 ISEMUMEMBER-->
-<!--103-->              <ISEMUMEMBER><![CDATA[Y]]></ISEMUMEMBER>
-<!--103 EMUENTRYDATE-->
-<!--103-->              <EMUENTRYDATE><![CDATA[1999-01-01 00:00:00.0]]></EMUENTRYDATE>
-<!--103 EMURATE-->
-<!--103-->              <EMURATE><![CDATA[1.95583]]></EMURATE>
 <!--103 PRICEPRECISION-->
 <!--103-->              <PRICEPRECISION><![CDATA[0]]></PRICEPRECISION>
 <!--103**************--></C_CURRENCY>
@@ -145,14 +125,6 @@
 <!--104-->              <STDPRECISION><![CDATA[2]]></STDPRECISION>
 <!--104 COSTINGPRECISION-->
 <!--104-->              <COSTINGPRECISION><![CDATA[4]]></COSTINGPRECISION>
-<!--104 ISEURO-->
-<!--104-->              <ISEURO><![CDATA[N]]></ISEURO>
-<!--104 ISEMUMEMBER-->
-<!--104-->              <ISEMUMEMBER><![CDATA[Y]]></ISEMUMEMBER>
-<!--104 EMUENTRYDATE-->
-<!--104-->              <EMUENTRYDATE><![CDATA[1999-01-01 00:00:00.0]]></EMUENTRYDATE>
-<!--104 EMURATE-->
-<!--104-->              <EMURATE><![CDATA[13.7603]]></EMURATE>
 <!--104 PRICEPRECISION-->
 <!--104-->              <PRICEPRECISION><![CDATA[0]]></PRICEPRECISION>
 <!--104**************--></C_CURRENCY>
@@ -184,14 +156,6 @@
 <!--105-->              <STDPRECISION><![CDATA[0]]></STDPRECISION>
 <!--105 COSTINGPRECISION-->
 <!--105-->              <COSTINGPRECISION><![CDATA[0]]></COSTINGPRECISION>
-<!--105 ISEURO-->
-<!--105-->              <ISEURO><![CDATA[N]]></ISEURO>
-<!--105 ISEMUMEMBER-->
-<!--105-->              <ISEMUMEMBER><![CDATA[Y]]></ISEMUMEMBER>
-<!--105 EMUENTRYDATE-->
-<!--105-->              <EMUENTRYDATE><![CDATA[1999-01-01 00:00:00.0]]></EMUENTRYDATE>
-<!--105 EMURATE-->
-<!--105-->              <EMURATE><![CDATA[40.3399]]></EMURATE>
 <!--105 PRICEPRECISION-->
 <!--105-->              <PRICEPRECISION><![CDATA[0]]></PRICEPRECISION>
 <!--105**************--></C_CURRENCY>
@@ -223,14 +187,6 @@
 <!--106-->              <STDPRECISION><![CDATA[2]]></STDPRECISION>
 <!--106 COSTINGPRECISION-->
 <!--106-->              <COSTINGPRECISION><![CDATA[4]]></COSTINGPRECISION>
-<!--106 ISEURO-->
-<!--106-->              <ISEURO><![CDATA[N]]></ISEURO>
-<!--106 ISEMUMEMBER-->
-<!--106-->              <ISEMUMEMBER><![CDATA[Y]]></ISEMUMEMBER>
-<!--106 EMUENTRYDATE-->
-<!--106-->              <EMUENTRYDATE><![CDATA[1999-01-01 00:00:00.0]]></EMUENTRYDATE>
-<!--106 EMURATE-->
-<!--106-->              <EMURATE><![CDATA[5.94573]]></EMURATE>
 <!--106 PRICEPRECISION-->
 <!--106-->              <PRICEPRECISION><![CDATA[0]]></PRICEPRECISION>
 <!--106**************--></C_CURRENCY>
@@ -262,14 +218,6 @@
 <!--107-->              <STDPRECISION><![CDATA[2]]></STDPRECISION>
 <!--107 COSTINGPRECISION-->
 <!--107-->              <COSTINGPRECISION><![CDATA[4]]></COSTINGPRECISION>
-<!--107 ISEURO-->
-<!--107-->              <ISEURO><![CDATA[N]]></ISEURO>
-<!--107 ISEMUMEMBER-->
-<!--107-->              <ISEMUMEMBER><![CDATA[Y]]></ISEMUMEMBER>
-<!--107 EMUENTRYDATE-->
-<!--107-->              <EMUENTRYDATE><![CDATA[1999-01-01 00:00:00.0]]></EMUENTRYDATE>
-<!--107 EMURATE-->
-<!--107-->              <EMURATE><![CDATA[0.787564]]></EMURATE>
 <!--107 PRICEPRECISION-->
 <!--107-->              <PRICEPRECISION><![CDATA[0]]></PRICEPRECISION>
 <!--107**************--></C_CURRENCY>
@@ -301,14 +249,6 @@
 <!--108-->              <STDPRECISION><![CDATA[0]]></STDPRECISION>
 <!--108 COSTINGPRECISION-->
 <!--108-->              <COSTINGPRECISION><![CDATA[0]]></COSTINGPRECISION>
-<!--108 ISEURO-->
-<!--108-->              <ISEURO><![CDATA[N]]></ISEURO>
-<!--108 ISEMUMEMBER-->
-<!--108-->              <ISEMUMEMBER><![CDATA[Y]]></ISEMUMEMBER>
-<!--108 EMUENTRYDATE-->
-<!--108-->              <EMUENTRYDATE><![CDATA[1999-01-01 00:00:00.0]]></EMUENTRYDATE>
-<!--108 EMURATE-->
-<!--108-->              <EMURATE><![CDATA[1936.27]]></EMURATE>
 <!--108 PRICEPRECISION-->
 <!--108-->              <PRICEPRECISION><![CDATA[0]]></PRICEPRECISION>
 <!--108**************--></C_CURRENCY>
@@ -340,14 +280,6 @@
 <!--109-->              <STDPRECISION><![CDATA[2]]></STDPRECISION>
 <!--109 COSTINGPRECISION-->
 <!--109-->              <COSTINGPRECISION><![CDATA[4]]></COSTINGPRECISION>
-<!--109 ISEURO-->
-<!--109-->              <ISEURO><![CDATA[N]]></ISEURO>
-<!--109 ISEMUMEMBER-->
-<!--109-->              <ISEMUMEMBER><![CDATA[Y]]></ISEMUMEMBER>
-<!--109 EMUENTRYDATE-->
-<!--109-->              <EMUENTRYDATE><![CDATA[1999-01-01 00:00:00.0]]></EMUENTRYDATE>
-<!--109 EMURATE-->
-<!--109-->              <EMURATE><![CDATA[2.20371]]></EMURATE>
 <!--109 PRICEPRECISION-->
 <!--109-->              <PRICEPRECISION><![CDATA[0]]></PRICEPRECISION>
 <!--109**************--></C_CURRENCY>
@@ -379,14 +311,6 @@
 <!--110-->              <STDPRECISION><![CDATA[0]]></STDPRECISION>
 <!--110 COSTINGPRECISION-->
 <!--110-->              <COSTINGPRECISION><![CDATA[0]]></COSTINGPRECISION>
-<!--110 ISEURO-->
-<!--110-->              <ISEURO><![CDATA[N]]></ISEURO>
-<!--110 ISEMUMEMBER-->
-<!--110-->              <ISEMUMEMBER><![CDATA[Y]]></ISEMUMEMBER>
-<!--110 EMUENTRYDATE-->
-<!--110-->              <EMUENTRYDATE><![CDATA[1999-01-01 00:00:00.0]]></EMUENTRYDATE>
-<!--110 EMURATE-->
-<!--110-->              <EMURATE><![CDATA[200.482]]></EMURATE>
 <!--110 PRICEPRECISION-->
 <!--110-->              <PRICEPRECISION><![CDATA[0]]></PRICEPRECISION>
 <!--110**************--></C_CURRENCY>
@@ -418,14 +342,6 @@
 <!--111-->              <STDPRECISION><![CDATA[0]]></STDPRECISION>
 <!--111 COSTINGPRECISION-->
 <!--111-->              <COSTINGPRECISION><![CDATA[0]]></COSTINGPRECISION>
-<!--111 ISEURO-->
-<!--111-->              <ISEURO><![CDATA[N]]></ISEURO>
-<!--111 ISEMUMEMBER-->
-<!--111-->              <ISEMUMEMBER><![CDATA[Y]]></ISEMUMEMBER>
-<!--111 EMUENTRYDATE-->
-<!--111-->              <EMUENTRYDATE><![CDATA[1999-01-01 00:00:00.0]]></EMUENTRYDATE>
-<!--111 EMURATE-->
-<!--111-->              <EMURATE><![CDATA[166.386]]></EMURATE>
 <!--111 PRICEPRECISION-->
 <!--111-->              <PRICEPRECISION><![CDATA[0]]></PRICEPRECISION>
 <!--111**************--></C_CURRENCY>
@@ -457,14 +373,6 @@
 <!--112-->              <STDPRECISION><![CDATA[2]]></STDPRECISION>
 <!--112 COSTINGPRECISION-->
 <!--112-->              <COSTINGPRECISION><![CDATA[4]]></COSTINGPRECISION>
-<!--112 ISEURO-->
-<!--112-->              <ISEURO><![CDATA[N]]></ISEURO>
-<!--112 ISEMUMEMBER-->
-<!--112-->              <ISEMUMEMBER><![CDATA[Y]]></ISEMUMEMBER>
-<!--112 EMUENTRYDATE-->
-<!--112-->              <EMUENTRYDATE><![CDATA[1999-01-01 00:00:00.0]]></EMUENTRYDATE>
-<!--112 EMURATE-->
-<!--112-->              <EMURATE><![CDATA[6.55957]]></EMURATE>
 <!--112 PRICEPRECISION-->
 <!--112-->              <PRICEPRECISION><![CDATA[0]]></PRICEPRECISION>
 <!--112**************--></C_CURRENCY>
@@ -496,12 +404,6 @@
 <!--113-->              <STDPRECISION><![CDATA[0]]></STDPRECISION>
 <!--113 COSTINGPRECISION-->
 <!--113-->              <COSTINGPRECISION><![CDATA[0]]></COSTINGPRECISION>
-<!--113 ISEURO-->
-<!--113-->              <ISEURO><![CDATA[N]]></ISEURO>
-<!--113 ISEMUMEMBER-->
-<!--113-->              <ISEMUMEMBER><![CDATA[N]]></ISEMUMEMBER>
-<!--113 EMURATE-->
-<!--113-->              <EMURATE><![CDATA[0]]></EMURATE>
 <!--113 PRICEPRECISION-->
 <!--113-->              <PRICEPRECISION><![CDATA[0]]></PRICEPRECISION>
 <!--113**************--></C_CURRENCY>
@@ -533,12 +435,6 @@
 <!--114-->              <STDPRECISION><![CDATA[2]]></STDPRECISION>
 <!--114 COSTINGPRECISION-->
 <!--114-->              <COSTINGPRECISION><![CDATA[4]]></COSTINGPRECISION>
-<!--114 ISEURO-->
-<!--114-->              <ISEURO><![CDATA[N]]></ISEURO>
-<!--114 ISEMUMEMBER-->
-<!--114-->              <ISEMUMEMBER><![CDATA[N]]></ISEMUMEMBER>
-<!--114 EMURATE-->
-<!--114-->              <EMURATE><![CDATA[0]]></EMURATE>
 <!--114 PRICEPRECISION-->
 <!--114-->              <PRICEPRECISION><![CDATA[0]]></PRICEPRECISION>
 <!--114**************--></C_CURRENCY>
@@ -570,12 +466,6 @@
 <!--115-->              <STDPRECISION><![CDATA[2]]></STDPRECISION>
 <!--115 COSTINGPRECISION-->
 <!--115-->              <COSTINGPRECISION><![CDATA[4]]></COSTINGPRECISION>
-<!--115 ISEURO-->
-<!--115-->              <ISEURO><![CDATA[N]]></ISEURO>
-<!--115 ISEMUMEMBER-->
-<!--115-->              <ISEMUMEMBER><![CDATA[N]]></ISEMUMEMBER>
-<!--115 EMURATE-->
-<!--115-->              <EMURATE><![CDATA[0]]></EMURATE>
 <!--115 PRICEPRECISION-->
 <!--115-->              <PRICEPRECISION><![CDATA[0]]></PRICEPRECISION>
 <!--115**************--></C_CURRENCY>
@@ -607,12 +497,6 @@
 <!--116-->              <STDPRECISION><![CDATA[2]]></STDPRECISION>
 <!--116 COSTINGPRECISION-->
 <!--116-->              <COSTINGPRECISION><![CDATA[4]]></COSTINGPRECISION>
-<!--116 ISEURO-->
-<!--116-->              <ISEURO><![CDATA[N]]></ISEURO>
-<!--116 ISEMUMEMBER-->
-<!--116-->              <ISEMUMEMBER><![CDATA[N]]></ISEMUMEMBER>
-<!--116 EMURATE-->
-<!--116-->              <EMURATE><![CDATA[0]]></EMURATE>
 <!--116 PRICEPRECISION-->
 <!--116-->              <PRICEPRECISION><![CDATA[0]]></PRICEPRECISION>
 <!--116**************--></C_CURRENCY>
@@ -644,10 +528,6 @@
 <!--118-->              <STDPRECISION><![CDATA[2]]></STDPRECISION>
 <!--118 COSTINGPRECISION-->
 <!--118-->              <COSTINGPRECISION><![CDATA[4]]></COSTINGPRECISION>
-<!--118 ISEURO-->
-<!--118-->              <ISEURO><![CDATA[N]]></ISEURO>
-<!--118 ISEMUMEMBER-->
-<!--118-->              <ISEMUMEMBER><![CDATA[N]]></ISEMUMEMBER>
 <!--118 PRICEPRECISION-->
 <!--118-->              <PRICEPRECISION><![CDATA[0]]></PRICEPRECISION>
 <!--118**************--></C_CURRENCY>
@@ -679,10 +559,6 @@
 <!--120-->              <STDPRECISION><![CDATA[2]]></STDPRECISION>
 <!--120 COSTINGPRECISION-->
 <!--120-->              <COSTINGPRECISION><![CDATA[4]]></COSTINGPRECISION>
-<!--120 ISEURO-->
-<!--120-->              <ISEURO><![CDATA[N]]></ISEURO>
-<!--120 ISEMUMEMBER-->
-<!--120-->              <ISEMUMEMBER><![CDATA[N]]></ISEMUMEMBER>
 <!--120 PRICEPRECISION-->
 <!--120-->              <PRICEPRECISION><![CDATA[0]]></PRICEPRECISION>
 <!--120**************--></C_CURRENCY>
@@ -714,10 +590,6 @@
 <!--121-->              <STDPRECISION><![CDATA[2]]></STDPRECISION>
 <!--121 COSTINGPRECISION-->
 <!--121-->              <COSTINGPRECISION><![CDATA[4]]></COSTINGPRECISION>
-<!--121 ISEURO-->
-<!--121-->              <ISEURO><![CDATA[N]]></ISEURO>
-<!--121 ISEMUMEMBER-->
-<!--121-->              <ISEMUMEMBER><![CDATA[N]]></ISEMUMEMBER>
 <!--121 PRICEPRECISION-->
 <!--121-->              <PRICEPRECISION><![CDATA[0]]></PRICEPRECISION>
 <!--121**************--></C_CURRENCY>
@@ -749,10 +621,6 @@
 <!--127-->              <STDPRECISION><![CDATA[2]]></STDPRECISION>
 <!--127 COSTINGPRECISION-->
 <!--127-->              <COSTINGPRECISION><![CDATA[4]]></COSTINGPRECISION>
-<!--127 ISEURO-->
-<!--127-->              <ISEURO><![CDATA[N]]></ISEURO>
-<!--127 ISEMUMEMBER-->
-<!--127-->              <ISEMUMEMBER><![CDATA[N]]></ISEMUMEMBER>
 <!--127 PRICEPRECISION-->
 <!--127-->              <PRICEPRECISION><![CDATA[0]]></PRICEPRECISION>
 <!--127**************--></C_CURRENCY>
@@ -784,10 +652,6 @@
 <!--130-->              <STDPRECISION><![CDATA[2]]></STDPRECISION>
 <!--130 COSTINGPRECISION-->
 <!--130-->              <COSTINGPRECISION><![CDATA[4]]></COSTINGPRECISION>
-<!--130 ISEURO-->
-<!--130-->              <ISEURO><![CDATA[N]]></ISEURO>
-<!--130 ISEMUMEMBER-->
-<!--130-->              <ISEMUMEMBER><![CDATA[N]]></ISEMUMEMBER>
 <!--130 PRICEPRECISION-->
 <!--130-->              <PRICEPRECISION><![CDATA[0]]></PRICEPRECISION>
 <!--130**************--></C_CURRENCY>
@@ -819,10 +683,6 @@
 <!--142-->              <STDPRECISION><![CDATA[2]]></STDPRECISION>
 <!--142 COSTINGPRECISION-->
 <!--142-->              <COSTINGPRECISION><![CDATA[4]]></COSTINGPRECISION>
-<!--142 ISEURO-->
-<!--142-->              <ISEURO><![CDATA[N]]></ISEURO>
-<!--142 ISEMUMEMBER-->
-<!--142-->              <ISEMUMEMBER><![CDATA[N]]></ISEMUMEMBER>
 <!--142 PRICEPRECISION-->
 <!--142-->              <PRICEPRECISION><![CDATA[0]]></PRICEPRECISION>
 <!--142**************--></C_CURRENCY>
@@ -852,10 +712,6 @@
 <!--143-->              <STDPRECISION><![CDATA[2]]></STDPRECISION>
 <!--143 COSTINGPRECISION-->
 <!--143-->              <COSTINGPRECISION><![CDATA[4]]></COSTINGPRECISION>
-<!--143 ISEURO-->
-<!--143-->              <ISEURO><![CDATA[N]]></ISEURO>
-<!--143 ISEMUMEMBER-->
-<!--143-->              <ISEMUMEMBER><![CDATA[N]]></ISEMUMEMBER>
 <!--143 PRICEPRECISION-->
 <!--143-->              <PRICEPRECISION><![CDATA[0]]></PRICEPRECISION>
 <!--143**************--></C_CURRENCY>
@@ -885,10 +741,6 @@
 <!--144-->              <STDPRECISION><![CDATA[2]]></STDPRECISION>
 <!--144 COSTINGPRECISION-->
 <!--144-->              <COSTINGPRECISION><![CDATA[4]]></COSTINGPRECISION>
-<!--144 ISEURO-->
-<!--144-->              <ISEURO><![CDATA[N]]></ISEURO>
-<!--144 ISEMUMEMBER-->
-<!--144-->              <ISEMUMEMBER><![CDATA[N]]></ISEMUMEMBER>
 <!--144 PRICEPRECISION-->
 <!--144-->              <PRICEPRECISION><![CDATA[0]]></PRICEPRECISION>
 <!--144**************--></C_CURRENCY>
@@ -918,10 +770,6 @@
 <!--145-->              <STDPRECISION><![CDATA[2]]></STDPRECISION>
 <!--145 COSTINGPRECISION-->
 <!--145-->              <COSTINGPRECISION><![CDATA[4]]></COSTINGPRECISION>
-<!--145 ISEURO-->
-<!--145-->              <ISEURO><![CDATA[N]]></ISEURO>
-<!--145 ISEMUMEMBER-->
-<!--145-->              <ISEMUMEMBER><![CDATA[N]]></ISEMUMEMBER>
 <!--145 PRICEPRECISION-->
 <!--145-->              <PRICEPRECISION><![CDATA[0]]></PRICEPRECISION>
 <!--145**************--></C_CURRENCY>
@@ -951,10 +799,6 @@
 <!--146-->              <STDPRECISION><![CDATA[2]]></STDPRECISION>
 <!--146 COSTINGPRECISION-->
 <!--146-->              <COSTINGPRECISION><![CDATA[4]]></COSTINGPRECISION>
-<!--146 ISEURO-->
-<!--146-->              <ISEURO><![CDATA[N]]></ISEURO>
-<!--146 ISEMUMEMBER-->
-<!--146-->              <ISEMUMEMBER><![CDATA[N]]></ISEMUMEMBER>
 <!--146 PRICEPRECISION-->
 <!--146-->              <PRICEPRECISION><![CDATA[0]]></PRICEPRECISION>
 <!--146**************--></C_CURRENCY>
@@ -984,10 +828,6 @@
 <!--147-->              <STDPRECISION><![CDATA[2]]></STDPRECISION>
 <!--147 COSTINGPRECISION-->
 <!--147-->              <COSTINGPRECISION><![CDATA[4]]></COSTINGPRECISION>
-<!--147 ISEURO-->
-<!--147-->              <ISEURO><![CDATA[N]]></ISEURO>
-<!--147 ISEMUMEMBER-->
-<!--147-->              <ISEMUMEMBER><![CDATA[N]]></ISEMUMEMBER>
 <!--147 PRICEPRECISION-->
 <!--147-->              <PRICEPRECISION><![CDATA[0]]></PRICEPRECISION>
 <!--147**************--></C_CURRENCY>
@@ -1017,10 +857,6 @@
 <!--148-->              <STDPRECISION><![CDATA[2]]></STDPRECISION>
 <!--148 COSTINGPRECISION-->
 <!--148-->              <COSTINGPRECISION><![CDATA[4]]></COSTINGPRECISION>
-<!--148 ISEURO-->
-<!--148-->              <ISEURO><![CDATA[N]]></ISEURO>
-<!--148 ISEMUMEMBER-->
-<!--148-->              <ISEMUMEMBER><![CDATA[N]]></ISEMUMEMBER>
 <!--148 PRICEPRECISION-->
 <!--148-->              <PRICEPRECISION><![CDATA[0]]></PRICEPRECISION>
 <!--148**************--></C_CURRENCY>
@@ -1050,10 +886,6 @@
 <!--149-->              <STDPRECISION><![CDATA[2]]></STDPRECISION>
 <!--149 COSTINGPRECISION-->
 <!--149-->              <COSTINGPRECISION><![CDATA[4]]></COSTINGPRECISION>
-<!--149 ISEURO-->
-<!--149-->              <ISEURO><![CDATA[N]]></ISEURO>
-<!--149 ISEMUMEMBER-->
-<!--149-->              <ISEMUMEMBER><![CDATA[N]]></ISEMUMEMBER>
 <!--149 PRICEPRECISION-->
 <!--149-->              <PRICEPRECISION><![CDATA[0]]></PRICEPRECISION>
 <!--149**************--></C_CURRENCY>
@@ -1083,10 +915,6 @@
 <!--150-->              <STDPRECISION><![CDATA[2]]></STDPRECISION>
 <!--150 COSTINGPRECISION-->
 <!--150-->              <COSTINGPRECISION><![CDATA[4]]></COSTINGPRECISION>
-<!--150 ISEURO-->
-<!--150-->              <ISEURO><![CDATA[N]]></ISEURO>
-<!--150 ISEMUMEMBER-->
-<!--150-->              <ISEMUMEMBER><![CDATA[N]]></ISEMUMEMBER>
 <!--150 PRICEPRECISION-->
 <!--150-->              <PRICEPRECISION><![CDATA[0]]></PRICEPRECISION>
 <!--150**************--></C_CURRENCY>
@@ -1116,10 +944,6 @@
 <!--151-->              <STDPRECISION><![CDATA[2]]></STDPRECISION>
 <!--151 COSTINGPRECISION-->
 <!--151-->              <COSTINGPRECISION><![CDATA[4]]></COSTINGPRECISION>
-<!--151 ISEURO-->
-<!--151-->              <ISEURO><![CDATA[N]]></ISEURO>
-<!--151 ISEMUMEMBER-->
-<!--151-->              <ISEMUMEMBER><![CDATA[N]]></ISEMUMEMBER>
 <!--151 PRICEPRECISION-->
 <!--151-->              <PRICEPRECISION><![CDATA[0]]></PRICEPRECISION>
 <!--151**************--></C_CURRENCY>
@@ -1149,10 +973,6 @@
 <!--152-->              <STDPRECISION><![CDATA[2]]></STDPRECISION>
 <!--152 COSTINGPRECISION-->
 <!--152-->              <COSTINGPRECISION><![CDATA[4]]></COSTINGPRECISION>
-<!--152 ISEURO-->
-<!--152-->              <ISEURO><![CDATA[N]]></ISEURO>
-<!--152 ISEMUMEMBER-->
-<!--152-->              <ISEMUMEMBER><![CDATA[N]]></ISEMUMEMBER>
 <!--152 PRICEPRECISION-->
 <!--152-->              <PRICEPRECISION><![CDATA[0]]></PRICEPRECISION>
 <!--152**************--></C_CURRENCY>
@@ -1182,10 +1002,6 @@
 <!--153-->              <STDPRECISION><![CDATA[2]]></STDPRECISION>
 <!--153 COSTINGPRECISION-->
 <!--153-->              <COSTINGPRECISION><![CDATA[4]]></COSTINGPRECISION>
-<!--153 ISEURO-->
-<!--153-->              <ISEURO><![CDATA[N]]></ISEURO>
-<!--153 ISEMUMEMBER-->
-<!--153-->              <ISEMUMEMBER><![CDATA[N]]></ISEMUMEMBER>
 <!--153 PRICEPRECISION-->
 <!--153-->              <PRICEPRECISION><![CDATA[0]]></PRICEPRECISION>
 <!--153**************--></C_CURRENCY>
@@ -1215,10 +1031,6 @@
 <!--154-->              <STDPRECISION><![CDATA[2]]></STDPRECISION>
 <!--154 COSTINGPRECISION-->
 <!--154-->              <COSTINGPRECISION><![CDATA[4]]></COSTINGPRECISION>
-<!--154 ISEURO-->
-<!--154-->              <ISEURO><![CDATA[N]]></ISEURO>
-<!--154 ISEMUMEMBER-->
-<!--154-->              <ISEMUMEMBER><![CDATA[N]]></ISEMUMEMBER>
 <!--154 PRICEPRECISION-->
 <!--154-->              <PRICEPRECISION><![CDATA[0]]></PRICEPRECISION>
 <!--154**************--></C_CURRENCY>
@@ -1248,10 +1060,6 @@
 <!--155-->              <STDPRECISION><![CDATA[2]]></STDPRECISION>
 <!--155 COSTINGPRECISION-->
 <!--155-->              <COSTINGPRECISION><![CDATA[4]]></COSTINGPRECISION>
-<!--155 ISEURO-->
-<!--155-->              <ISEURO><![CDATA[N]]></ISEURO>
-<!--155 ISEMUMEMBER-->
-<!--155-->              <ISEMUMEMBER><![CDATA[N]]></ISEMUMEMBER>
 <!--155 PRICEPRECISION-->
 <!--155-->              <PRICEPRECISION><![CDATA[0]]></PRICEPRECISION>
 <!--155**************--></C_CURRENCY>
@@ -1281,10 +1089,6 @@
 <!--156-->              <STDPRECISION><![CDATA[2]]></STDPRECISION>
 <!--156 COSTINGPRECISION-->
 <!--156-->              <COSTINGPRECISION><![CDATA[4]]></COSTINGPRECISION>
-<!--156 ISEURO-->
-<!--156-->              <ISEURO><![CDATA[N]]></ISEURO>
-<!--156 ISEMUMEMBER-->
-<!--156-->              <ISEMUMEMBER><![CDATA[N]]></ISEMUMEMBER>
 <!--156 PRICEPRECISION-->
 <!--156-->              <PRICEPRECISION><![CDATA[0]]></PRICEPRECISION>
 <!--156**************--></C_CURRENCY>
@@ -1314,10 +1118,6 @@
 <!--157-->              <STDPRECISION><![CDATA[2]]></STDPRECISION>
 <!--157 COSTINGPRECISION-->
 <!--157-->              <COSTINGPRECISION><![CDATA[4]]></COSTINGPRECISION>
-<!--157 ISEURO-->
-<!--157-->              <ISEURO><![CDATA[N]]></ISEURO>
-<!--157 ISEMUMEMBER-->
-<!--157-->              <ISEMUMEMBER><![CDATA[N]]></ISEMUMEMBER>
 <!--157 PRICEPRECISION-->
 <!--157-->              <PRICEPRECISION><![CDATA[0]]></PRICEPRECISION>
 <!--157**************--></C_CURRENCY>
@@ -1347,10 +1147,6 @@
 <!--158-->              <STDPRECISION><![CDATA[2]]></STDPRECISION>
 <!--158 COSTINGPRECISION-->
 <!--158-->              <COSTINGPRECISION><![CDATA[4]]></COSTINGPRECISION>
-<!--158 ISEURO-->
-<!--158-->              <ISEURO><![CDATA[N]]></ISEURO>
-<!--158 ISEMUMEMBER-->
-<!--158-->              <ISEMUMEMBER><![CDATA[N]]></ISEMUMEMBER>
 <!--158 PRICEPRECISION-->
 <!--158-->              <PRICEPRECISION><![CDATA[0]]></PRICEPRECISION>
 <!--158**************--></C_CURRENCY>
@@ -1380,10 +1176,6 @@
 <!--159-->              <STDPRECISION><![CDATA[0]]></STDPRECISION>
 <!--159 COSTINGPRECISION-->
 <!--159-->              <COSTINGPRECISION><![CDATA[2]]></COSTINGPRECISION>
-<!--159 ISEURO-->
-<!--159-->              <ISEURO><![CDATA[N]]></ISEURO>
-<!--159 ISEMUMEMBER-->
-<!--159-->              <ISEMUMEMBER><![CDATA[N]]></ISEMUMEMBER>
 <!--159 PRICEPRECISION-->
 <!--159-->              <PRICEPRECISION><![CDATA[0]]></PRICEPRECISION>
 <!--159**************--></C_CURRENCY>
@@ -1413,10 +1205,6 @@
 <!--160-->              <STDPRECISION><![CDATA[2]]></STDPRECISION>
 <!--160 COSTINGPRECISION-->
 <!--160-->              <COSTINGPRECISION><![CDATA[4]]></COSTINGPRECISION>
-<!--160 ISEURO-->
-<!--160-->              <ISEURO><![CDATA[N]]></ISEURO>
-<!--160 ISEMUMEMBER-->
-<!--160-->              <ISEMUMEMBER><![CDATA[N]]></ISEMUMEMBER>
 <!--160 PRICEPRECISION-->
 <!--160-->              <PRICEPRECISION><![CDATA[0]]></PRICEPRECISION>
 <!--160**************--></C_CURRENCY>
@@ -1446,10 +1234,6 @@
 <!--161-->              <STDPRECISION><![CDATA[2]]></STDPRECISION>
 <!--161 COSTINGPRECISION-->
 <!--161-->              <COSTINGPRECISION><![CDATA[4]]></COSTINGPRECISION>
-<!--161 ISEURO-->
-<!--161-->              <ISEURO><![CDATA[N]]></ISEURO>
-<!--161 ISEMUMEMBER-->
-<!--161-->              <ISEMUMEMBER><![CDATA[N]]></ISEMUMEMBER>
 <!--161 PRICEPRECISION-->
 <!--161-->              <PRICEPRECISION><![CDATA[0]]></PRICEPRECISION>
 <!--161**************--></C_CURRENCY>
@@ -1481,10 +1265,6 @@
 <!--163-->              <STDPRECISION><![CDATA[2]]></STDPRECISION>
 <!--163 COSTINGPRECISION-->
 <!--163-->              <COSTINGPRECISION><![CDATA[4]]></COSTINGPRECISION>
-<!--163 ISEURO-->
-<!--163-->              <ISEURO><![CDATA[N]]></ISEURO>
-<!--163 ISEMUMEMBER-->
-<!--163-->              <ISEMUMEMBER><![CDATA[N]]></ISEMUMEMBER>
 <!--163 PRICEPRECISION-->
 <!--163-->              <PRICEPRECISION><![CDATA[0]]></PRICEPRECISION>
 <!--163**************--></C_CURRENCY>
@@ -1516,10 +1296,6 @@
 <!--164-->              <STDPRECISION><![CDATA[2]]></STDPRECISION>
 <!--164 COSTINGPRECISION-->
 <!--164-->              <COSTINGPRECISION><![CDATA[4]]></COSTINGPRECISION>
-<!--164 ISEURO-->
-<!--164-->              <ISEURO><![CDATA[N]]></ISEURO>
-<!--164 ISEMUMEMBER-->
-<!--164-->              <ISEMUMEMBER><![CDATA[N]]></ISEMUMEMBER>
 <!--164 PRICEPRECISION-->
 <!--164-->              <PRICEPRECISION><![CDATA[0]]></PRICEPRECISION>
 <!--164**************--></C_CURRENCY>
@@ -1551,10 +1327,6 @@
 <!--165-->              <STDPRECISION><![CDATA[2]]></STDPRECISION>
 <!--165 COSTINGPRECISION-->
 <!--165-->              <COSTINGPRECISION><![CDATA[4]]></COSTINGPRECISION>
-<!--165 ISEURO-->
-<!--165-->              <ISEURO><![CDATA[N]]></ISEURO>
-<!--165 ISEMUMEMBER-->
-<!--165-->              <ISEMUMEMBER><![CDATA[N]]></ISEMUMEMBER>
 <!--165 PRICEPRECISION-->
 <!--165-->              <PRICEPRECISION><![CDATA[0]]></PRICEPRECISION>
 <!--165**************--></C_CURRENCY>
@@ -1586,10 +1358,6 @@
 <!--166-->              <STDPRECISION><![CDATA[2]]></STDPRECISION>
 <!--166 COSTINGPRECISION-->
 <!--166-->              <COSTINGPRECISION><![CDATA[4]]></COSTINGPRECISION>
-<!--166 ISEURO-->
-<!--166-->              <ISEURO><![CDATA[N]]></ISEURO>
-<!--166 ISEMUMEMBER-->
-<!--166-->              <ISEMUMEMBER><![CDATA[N]]></ISEMUMEMBER>
 <!--166 PRICEPRECISION-->
 <!--166-->              <PRICEPRECISION><![CDATA[0]]></PRICEPRECISION>
 <!--166**************--></C_CURRENCY>
@@ -1621,10 +1389,6 @@
 <!--167-->              <STDPRECISION><![CDATA[2]]></STDPRECISION>
 <!--167 COSTINGPRECISION-->
 <!--167-->              <COSTINGPRECISION><![CDATA[4]]></COSTINGPRECISION>
-<!--167 ISEURO-->
-<!--167-->              <ISEURO><![CDATA[N]]></ISEURO>
-<!--167 ISEMUMEMBER-->
-<!--167-->              <ISEMUMEMBER><![CDATA[N]]></ISEMUMEMBER>
 <!--167 PRICEPRECISION-->
 <!--167-->              <PRICEPRECISION><![CDATA[0]]></PRICEPRECISION>
 <!--167**************--></C_CURRENCY>
@@ -1656,10 +1420,6 @@
 <!--168-->              <STDPRECISION><![CDATA[2]]></STDPRECISION>
 <!--168 COSTINGPRECISION-->
 <!--168-->              <COSTINGPRECISION><![CDATA[4]]></COSTINGPRECISION>
-<!--168 ISEURO-->
-<!--168-->              <ISEURO><![CDATA[N]]></ISEURO>
-<!--168 ISEMUMEMBER-->
-<!--168-->              <ISEMUMEMBER><![CDATA[N]]></ISEMUMEMBER>
 <!--168 PRICEPRECISION-->
 <!--168-->              <PRICEPRECISION><![CDATA[0]]></PRICEPRECISION>
 <!--168**************--></C_CURRENCY>
@@ -1691,10 +1451,6 @@
 <!--170-->              <STDPRECISION><![CDATA[2]]></STDPRECISION>
 <!--170 COSTINGPRECISION-->
 <!--170-->              <COSTINGPRECISION><![CDATA[4]]></COSTINGPRECISION>
-<!--170 ISEURO-->
-<!--170-->              <ISEURO><![CDATA[N]]></ISEURO>
-<!--170 ISEMUMEMBER-->
-<!--170-->              <ISEMUMEMBER><![CDATA[N]]></ISEMUMEMBER>
 <!--170 PRICEPRECISION-->
 <!--170-->              <PRICEPRECISION><![CDATA[0]]></PRICEPRECISION>
 <!--170**************--></C_CURRENCY>
@@ -1726,10 +1482,6 @@
 <!--171-->              <STDPRECISION><![CDATA[2]]></STDPRECISION>
 <!--171 COSTINGPRECISION-->
 <!--171-->              <COSTINGPRECISION><![CDATA[4]]></COSTINGPRECISION>
-<!--171 ISEURO-->
-<!--171-->              <ISEURO><![CDATA[N]]></ISEURO>
-<!--171 ISEMUMEMBER-->
-<!--171-->              <ISEMUMEMBER><![CDATA[N]]></ISEMUMEMBER>
 <!--171 PRICEPRECISION-->
 <!--171-->              <PRICEPRECISION><![CDATA[0]]></PRICEPRECISION>
 <!--171**************--></C_CURRENCY>
@@ -1761,10 +1513,6 @@
 <!--195-->              <STDPRECISION><![CDATA[2]]></STDPRECISION>
 <!--195 COSTINGPRECISION-->
 <!--195-->              <COSTINGPRECISION><![CDATA[4]]></COSTINGPRECISION>
-<!--195 ISEURO-->
-<!--195-->              <ISEURO><![CDATA[N]]></ISEURO>
-<!--195 ISEMUMEMBER-->
-<!--195-->              <ISEMUMEMBER><![CDATA[N]]></ISEMUMEMBER>
 <!--195 PRICEPRECISION-->
 <!--195-->              <PRICEPRECISION><![CDATA[0]]></PRICEPRECISION>
 <!--195**************--></C_CURRENCY>
@@ -1796,10 +1544,6 @@
 <!--196-->              <STDPRECISION><![CDATA[2]]></STDPRECISION>
 <!--196 COSTINGPRECISION-->
 <!--196-->              <COSTINGPRECISION><![CDATA[4]]></COSTINGPRECISION>
-<!--196 ISEURO-->
-<!--196-->              <ISEURO><![CDATA[N]]></ISEURO>
-<!--196 ISEMUMEMBER-->
-<!--196-->              <ISEMUMEMBER><![CDATA[N]]></ISEMUMEMBER>
 <!--196 PRICEPRECISION-->
 <!--196-->              <PRICEPRECISION><![CDATA[0]]></PRICEPRECISION>
 <!--196**************--></C_CURRENCY>
@@ -1831,10 +1575,6 @@
 <!--197-->              <STDPRECISION><![CDATA[2]]></STDPRECISION>
 <!--197 COSTINGPRECISION-->
 <!--197-->              <COSTINGPRECISION><![CDATA[4]]></COSTINGPRECISION>
-<!--197 ISEURO-->
-<!--197-->              <ISEURO><![CDATA[N]]></ISEURO>
-<!--197 ISEMUMEMBER-->
-<!--197-->              <ISEMUMEMBER><![CDATA[N]]></ISEMUMEMBER>
 <!--197 PRICEPRECISION-->
 <!--197-->              <PRICEPRECISION><![CDATA[0]]></PRICEPRECISION>
 <!--197**************--></C_CURRENCY>
@@ -1866,10 +1606,6 @@
 <!--198-->              <STDPRECISION><![CDATA[2]]></STDPRECISION>
 <!--198 COSTINGPRECISION-->
 <!--198-->              <COSTINGPRECISION><![CDATA[4]]></COSTINGPRECISION>
-<!--198 ISEURO-->
-<!--198-->              <ISEURO><![CDATA[N]]></ISEURO>
-<!--198 ISEMUMEMBER-->
-<!--198-->              <ISEMUMEMBER><![CDATA[N]]></ISEMUMEMBER>
 <!--198 PRICEPRECISION-->
 <!--198-->              <PRICEPRECISION><![CDATA[0]]></PRICEPRECISION>
 <!--198**************--></C_CURRENCY>
@@ -1901,10 +1637,6 @@
 <!--199-->              <STDPRECISION><![CDATA[2]]></STDPRECISION>
 <!--199 COSTINGPRECISION-->
 <!--199-->              <COSTINGPRECISION><![CDATA[4]]></COSTINGPRECISION>
-<!--199 ISEURO-->
-<!--199-->              <ISEURO><![CDATA[N]]></ISEURO>
-<!--199 ISEMUMEMBER-->
-<!--199-->              <ISEMUMEMBER><![CDATA[N]]></ISEMUMEMBER>
 <!--199 PRICEPRECISION-->
 <!--199-->              <PRICEPRECISION><![CDATA[0]]></PRICEPRECISION>
 <!--199**************--></C_CURRENCY>
@@ -1936,10 +1668,6 @@
 <!--200-->              <STDPRECISION><![CDATA[3]]></STDPRECISION>
 <!--200 COSTINGPRECISION-->
 <!--200-->              <COSTINGPRECISION><![CDATA[5]]></COSTINGPRECISION>
-<!--200 ISEURO-->
-<!--200-->              <ISEURO><![CDATA[N]]></ISEURO>
-<!--200 ISEMUMEMBER-->
-<!--200-->              <ISEMUMEMBER><![CDATA[N]]></ISEMUMEMBER>
 <!--200 PRICEPRECISION-->
 <!--200-->              <PRICEPRECISION><![CDATA[0]]></PRICEPRECISION>
 <!--200**************--></C_CURRENCY>
@@ -1971,10 +1699,6 @@
 <!--201-->              <STDPRECISION><![CDATA[2]]></STDPRECISION>
 <!--201 COSTINGPRECISION-->
 <!--201-->              <COSTINGPRECISION><![CDATA[4]]></COSTINGPRECISION>
-<!--201 ISEURO-->
-<!--201-->              <ISEURO><![CDATA[N]]></ISEURO>
-<!--201 ISEMUMEMBER-->
-<!--201-->              <ISEMUMEMBER><![CDATA[N]]></ISEMUMEMBER>
 <!--201 PRICEPRECISION-->
 <!--201-->              <PRICEPRECISION><![CDATA[0]]></PRICEPRECISION>
 <!--201**************--></C_CURRENCY>
@@ -2006,10 +1730,6 @@
 <!--202-->              <STDPRECISION><![CDATA[2]]></STDPRECISION>
 <!--202 COSTINGPRECISION-->
 <!--202-->              <COSTINGPRECISION><![CDATA[4]]></COSTINGPRECISION>
-<!--202 ISEURO-->
-<!--202-->              <ISEURO><![CDATA[N]]></ISEURO>
-<!--202 ISEMUMEMBER-->
-<!--202-->              <ISEMUMEMBER><![CDATA[N]]></ISEMUMEMBER>
 <!--202 PRICEPRECISION-->
 <!--202-->              <PRICEPRECISION><![CDATA[0]]></PRICEPRECISION>
 <!--202**************--></C_CURRENCY>
@@ -2041,10 +1761,6 @@
 <!--203-->              <STDPRECISION><![CDATA[0]]></STDPRECISION>
 <!--203 COSTINGPRECISION-->
 <!--203-->              <COSTINGPRECISION><![CDATA[2]]></COSTINGPRECISION>
-<!--203 ISEURO-->
-<!--203-->              <ISEURO><![CDATA[N]]></ISEURO>
-<!--203 ISEMUMEMBER-->
-<!--203-->              <ISEMUMEMBER><![CDATA[N]]></ISEMUMEMBER>
 <!--203 PRICEPRECISION-->
 <!--203-->              <PRICEPRECISION><![CDATA[0]]></PRICEPRECISION>
 <!--203**************--></C_CURRENCY>
@@ -2076,10 +1792,6 @@
 <!--204-->              <STDPRECISION><![CDATA[2]]></STDPRECISION>
 <!--204 COSTINGPRECISION-->
 <!--204-->              <COSTINGPRECISION><![CDATA[4]]></COSTINGPRECISION>
-<!--204 ISEURO-->
-<!--204-->              <ISEURO><![CDATA[N]]></ISEURO>
-<!--204 ISEMUMEMBER-->
-<!--204-->              <ISEMUMEMBER><![CDATA[N]]></ISEMUMEMBER>
 <!--204 PRICEPRECISION-->
 <!--204-->              <PRICEPRECISION><![CDATA[0]]></PRICEPRECISION>
 <!--204**************--></C_CURRENCY>
@@ -2111,10 +1823,6 @@
 <!--205-->              <STDPRECISION><![CDATA[2]]></STDPRECISION>
 <!--205 COSTINGPRECISION-->
 <!--205-->              <COSTINGPRECISION><![CDATA[4]]></COSTINGPRECISION>
-<!--205 ISEURO-->
-<!--205-->              <ISEURO><![CDATA[N]]></ISEURO>
-<!--205 ISEMUMEMBER-->
-<!--205-->              <ISEMUMEMBER><![CDATA[N]]></ISEMUMEMBER>
 <!--205 PRICEPRECISION-->
 <!--205-->              <PRICEPRECISION><![CDATA[0]]></PRICEPRECISION>
 <!--205**************--></C_CURRENCY>
@@ -2146,10 +1854,6 @@
 <!--206-->              <STDPRECISION><![CDATA[2]]></STDPRECISION>
 <!--206 COSTINGPRECISION-->
 <!--206-->              <COSTINGPRECISION><![CDATA[4]]></COSTINGPRECISION>
-<!--206 ISEURO-->
-<!--206-->              <ISEURO><![CDATA[N]]></ISEURO>
-<!--206 ISEMUMEMBER-->
-<!--206-->              <ISEMUMEMBER><![CDATA[N]]></ISEMUMEMBER>
 <!--206 PRICEPRECISION-->
 <!--206-->              <PRICEPRECISION><![CDATA[0]]></PRICEPRECISION>
 <!--206**************--></C_CURRENCY>
@@ -2181,10 +1885,6 @@
 <!--207-->              <STDPRECISION><![CDATA[2]]></STDPRECISION>
 <!--207 COSTINGPRECISION-->
 <!--207-->              <COSTINGPRECISION><![CDATA[4]]></COSTINGPRECISION>
-<!--207 ISEURO-->
-<!--207-->              <ISEURO><![CDATA[N]]></ISEURO>
-<!--207 ISEMUMEMBER-->
-<!--207-->              <ISEMUMEMBER><![CDATA[N]]></ISEMUMEMBER>
 <!--207 PRICEPRECISION-->
 <!--207-->              <PRICEPRECISION><![CDATA[0]]></PRICEPRECISION>
 <!--207**************--></C_CURRENCY>
@@ -2216,10 +1916,6 @@
 <!--209-->              <STDPRECISION><![CDATA[2]]></STDPRECISION>
 <!--209 COSTINGPRECISION-->
 <!--209-->              <COSTINGPRECISION><![CDATA[4]]></COSTINGPRECISION>
-<!--209 ISEURO-->
-<!--209-->              <ISEURO><![CDATA[N]]></ISEURO>
-<!--209 ISEMUMEMBER-->
-<!--209-->              <ISEMUMEMBER><![CDATA[N]]></ISEMUMEMBER>
 <!--209 PRICEPRECISION-->
 <!--209-->              <PRICEPRECISION><![CDATA[0]]></PRICEPRECISION>
 <!--209**************--></C_CURRENCY>
@@ -2251,10 +1947,6 @@
 <!--210-->              <STDPRECISION><![CDATA[2]]></STDPRECISION>
 <!--210 COSTINGPRECISION-->
 <!--210-->              <COSTINGPRECISION><![CDATA[4]]></COSTINGPRECISION>
-<!--210 ISEURO-->
-<!--210-->              <ISEURO><![CDATA[N]]></ISEURO>
-<!--210 ISEMUMEMBER-->
-<!--210-->              <ISEMUMEMBER><![CDATA[N]]></ISEMUMEMBER>
 <!--210 PRICEPRECISION-->
 <!--210-->              <PRICEPRECISION><![CDATA[0]]></PRICEPRECISION>
 <!--210**************--></C_CURRENCY>
@@ -2286,10 +1978,6 @@
 <!--211-->              <STDPRECISION><![CDATA[0]]></STDPRECISION>
 <!--211 COSTINGPRECISION-->
 <!--211-->              <COSTINGPRECISION><![CDATA[2]]></COSTINGPRECISION>
-<!--211 ISEURO-->
-<!--211-->              <ISEURO><![CDATA[N]]></ISEURO>
-<!--211 ISEMUMEMBER-->
-<!--211-->              <ISEMUMEMBER><![CDATA[N]]></ISEMUMEMBER>
 <!--211 PRICEPRECISION-->
 <!--211-->              <PRICEPRECISION><![CDATA[0]]></PRICEPRECISION>
 <!--211**************--></C_CURRENCY>
@@ -2321,10 +2009,6 @@
 <!--212-->              <STDPRECISION><![CDATA[0]]></STDPRECISION>
 <!--212 COSTINGPRECISION-->
 <!--212-->              <COSTINGPRECISION><![CDATA[2]]></COSTINGPRECISION>
-<!--212 ISEURO-->
-<!--212-->              <ISEURO><![CDATA[N]]></ISEURO>
-<!--212 ISEMUMEMBER-->
-<!--212-->              <ISEMUMEMBER><![CDATA[N]]></ISEMUMEMBER>
 <!--212 PRICEPRECISION-->
 <!--212-->              <PRICEPRECISION><![CDATA[0]]></PRICEPRECISION>
 <!--212**************--></C_CURRENCY>
@@ -2356,10 +2040,6 @@
 <!--214-->              <STDPRECISION><![CDATA[0]]></STDPRECISION>
 <!--214 COSTINGPRECISION-->
 <!--214-->              <COSTINGPRECISION><![CDATA[2]]></COSTINGPRECISION>
-<!--214 ISEURO-->
-<!--214-->              <ISEURO><![CDATA[N]]></ISEURO>
-<!--214 ISEMUMEMBER-->
-<!--214-->              <ISEMUMEMBER><![CDATA[N]]></ISEMUMEMBER>
 <!--214 PRICEPRECISION-->
 <!--214-->              <PRICEPRECISION><![CDATA[0]]></PRICEPRECISION>
 <!--214**************--></C_CURRENCY>
@@ -2391,10 +2071,6 @@
 <!--225-->              <STDPRECISION><![CDATA[0]]></STDPRECISION>
 <!--225 COSTINGPRECISION-->
 <!--225-->              <COSTINGPRECISION><![CDATA[2]]></COSTINGPRECISION>
-<!--225 ISEURO-->
-<!--225-->              <ISEURO><![CDATA[N]]></ISEURO>
-<!--225 ISEMUMEMBER-->
-<!--225-->              <ISEMUMEMBER><![CDATA[N]]></ISEMUMEMBER>
 <!--225 PRICEPRECISION-->
 <!--225-->              <PRICEPRECISION><![CDATA[0]]></PRICEPRECISION>
 <!--225**************--></C_CURRENCY>
@@ -2426,10 +2102,6 @@
 <!--228-->              <STDPRECISION><![CDATA[0]]></STDPRECISION>
 <!--228 COSTINGPRECISION-->
 <!--228-->              <COSTINGPRECISION><![CDATA[2]]></COSTINGPRECISION>
-<!--228 ISEURO-->
-<!--228-->              <ISEURO><![CDATA[N]]></ISEURO>
-<!--228 ISEMUMEMBER-->
-<!--228-->              <ISEMUMEMBER><![CDATA[N]]></ISEMUMEMBER>
 <!--228 PRICEPRECISION-->
 <!--228-->              <PRICEPRECISION><![CDATA[0]]></PRICEPRECISION>
 <!--228**************--></C_CURRENCY>
@@ -2461,10 +2133,6 @@
 <!--229-->              <STDPRECISION><![CDATA[2]]></STDPRECISION>
 <!--229 COSTINGPRECISION-->
 <!--229-->              <COSTINGPRECISION><![CDATA[4]]></COSTINGPRECISION>
-<!--229 ISEURO-->
-<!--229-->              <ISEURO><![CDATA[N]]></ISEURO>
-<!--229 ISEMUMEMBER-->
-<!--229-->              <ISEMUMEMBER><![CDATA[N]]></ISEMUMEMBER>
 <!--229 PRICEPRECISION-->
 <!--229-->              <PRICEPRECISION><![CDATA[0]]></PRICEPRECISION>
 <!--229**************--></C_CURRENCY>
@@ -2496,10 +2164,6 @@
 <!--230-->              <STDPRECISION><![CDATA[2]]></STDPRECISION>
 <!--230 COSTINGPRECISION-->
 <!--230-->              <COSTINGPRECISION><![CDATA[4]]></COSTINGPRECISION>
-<!--230 ISEURO-->
-<!--230-->              <ISEURO><![CDATA[N]]></ISEURO>
-<!--230 ISEMUMEMBER-->
-<!--230-->              <ISEMUMEMBER><![CDATA[N]]></ISEMUMEMBER>
 <!--230 PRICEPRECISION-->
 <!--230-->              <PRICEPRECISION><![CDATA[0]]></PRICEPRECISION>
 <!--230**************--></C_CURRENCY>
@@ -2531,10 +2195,6 @@
 <!--231-->              <STDPRECISION><![CDATA[2]]></STDPRECISION>
 <!--231 COSTINGPRECISION-->
 <!--231-->              <COSTINGPRECISION><![CDATA[4]]></COSTINGPRECISION>
-<!--231 ISEURO-->
-<!--231-->              <ISEURO><![CDATA[N]]></ISEURO>
-<!--231 ISEMUMEMBER-->
-<!--231-->              <ISEMUMEMBER><![CDATA[N]]></ISEMUMEMBER>
 <!--231 PRICEPRECISION-->
 <!--231-->              <PRICEPRECISION><![CDATA[0]]></PRICEPRECISION>
 <!--231**************--></C_CURRENCY>
@@ -2566,10 +2226,6 @@
 <!--232-->              <STDPRECISION><![CDATA[2]]></STDPRECISION>
 <!--232 COSTINGPRECISION-->
 <!--232-->              <COSTINGPRECISION><![CDATA[4]]></COSTINGPRECISION>
-<!--232 ISEURO-->
-<!--232-->              <ISEURO><![CDATA[N]]></ISEURO>
-<!--232 ISEMUMEMBER-->
-<!--232-->              <ISEMUMEMBER><![CDATA[N]]></ISEMUMEMBER>
 <!--232 PRICEPRECISION-->
 <!--232-->              <PRICEPRECISION><![CDATA[0]]></PRICEPRECISION>
 <!--232**************--></C_CURRENCY>
@@ -2601,10 +2257,6 @@
 <!--233-->              <STDPRECISION><![CDATA[2]]></STDPRECISION>
 <!--233 COSTINGPRECISION-->
 <!--233-->              <COSTINGPRECISION><![CDATA[4]]></COSTINGPRECISION>
-<!--233 ISEURO-->
-<!--233-->              <ISEURO><![CDATA[N]]></ISEURO>
-<!--233 ISEMUMEMBER-->
-<!--233-->              <ISEMUMEMBER><![CDATA[N]]></ISEMUMEMBER>
 <!--233 PRICEPRECISION-->
 <!--233-->              <PRICEPRECISION><![CDATA[0]]></PRICEPRECISION>
 <!--233**************--></C_CURRENCY>
@@ -2636,10 +2288,6 @@
 <!--234-->              <STDPRECISION><![CDATA[2]]></STDPRECISION>
 <!--234 COSTINGPRECISION-->
 <!--234-->              <COSTINGPRECISION><![CDATA[4]]></COSTINGPRECISION>
-<!--234 ISEURO-->
-<!--234-->              <ISEURO><![CDATA[N]]></ISEURO>
-<!--234 ISEMUMEMBER-->
-<!--234-->              <ISEMUMEMBER><![CDATA[N]]></ISEMUMEMBER>
 <!--234 PRICEPRECISION-->
 <!--234-->              <PRICEPRECISION><![CDATA[0]]></PRICEPRECISION>
 <!--234**************--></C_CURRENCY>
@@ -2671,10 +2319,6 @@
 <!--235-->              <STDPRECISION><![CDATA[2]]></STDPRECISION>
 <!--235 COSTINGPRECISION-->
 <!--235-->              <COSTINGPRECISION><![CDATA[4]]></COSTINGPRECISION>
-<!--235 ISEURO-->
-<!--235-->              <ISEURO><![CDATA[N]]></ISEURO>
-<!--235 ISEMUMEMBER-->
-<!--235-->              <ISEMUMEMBER><![CDATA[N]]></ISEMUMEMBER>
 <!--235 PRICEPRECISION-->
 <!--235-->              <PRICEPRECISION><![CDATA[0]]></PRICEPRECISION>
 <!--235**************--></C_CURRENCY>
@@ -2706,10 +2350,6 @@
 <!--236-->              <STDPRECISION><![CDATA[2]]></STDPRECISION>
 <!--236 COSTINGPRECISION-->
 <!--236-->              <COSTINGPRECISION><![CDATA[4]]></COSTINGPRECISION>
-<!--236 ISEURO-->
-<!--236-->              <ISEURO><![CDATA[N]]></ISEURO>
-<!--236 ISEMUMEMBER-->
-<!--236-->              <ISEMUMEMBER><![CDATA[N]]></ISEMUMEMBER>
 <!--236 PRICEPRECISION-->
 <!--236-->              <PRICEPRECISION><![CDATA[0]]></PRICEPRECISION>
 <!--236**************--></C_CURRENCY>
@@ -2741,10 +2381,6 @@
 <!--237-->              <STDPRECISION><![CDATA[0]]></STDPRECISION>
 <!--237 COSTINGPRECISION-->
 <!--237-->              <COSTINGPRECISION><![CDATA[2]]></COSTINGPRECISION>
-<!--237 ISEURO-->
-<!--237-->              <ISEURO><![CDATA[N]]></ISEURO>
-<!--237 ISEMUMEMBER-->
-<!--237-->              <ISEMUMEMBER><![CDATA[N]]></ISEMUMEMBER>
 <!--237 PRICEPRECISION-->
 <!--237-->              <PRICEPRECISION><![CDATA[0]]></PRICEPRECISION>
 <!--237**************--></C_CURRENCY>
@@ -2776,10 +2412,6 @@
 <!--238-->              <STDPRECISION><![CDATA[2]]></STDPRECISION>
 <!--238 COSTINGPRECISION-->
 <!--238-->              <COSTINGPRECISION><![CDATA[4]]></COSTINGPRECISION>
-<!--238 ISEURO-->
-<!--238-->              <ISEURO><![CDATA[N]]></ISEURO>
-<!--238 ISEMUMEMBER-->
-<!--238-->              <ISEMUMEMBER><![CDATA[N]]></ISEMUMEMBER>
 <!--238 PRICEPRECISION-->
 <!--238-->              <PRICEPRECISION><![CDATA[0]]></PRICEPRECISION>
 <!--238**************--></C_CURRENCY>
@@ -2811,10 +2443,6 @@
 <!--239-->              <STDPRECISION><![CDATA[2]]></STDPRECISION>
 <!--239 COSTINGPRECISION-->
 <!--239-->              <COSTINGPRECISION><![CDATA[4]]></COSTINGPRECISION>
-<!--239 ISEURO-->
-<!--239-->              <ISEURO><![CDATA[N]]></ISEURO>
-<!--239 ISEMUMEMBER-->
-<!--239-->              <ISEMUMEMBER><![CDATA[N]]></ISEMUMEMBER>
 <!--239 PRICEPRECISION-->
 <!--239-->              <PRICEPRECISION><![CDATA[0]]></PRICEPRECISION>
 <!--239**************--></C_CURRENCY>
@@ -2846,10 +2474,6 @@
 <!--240-->              <STDPRECISION><![CDATA[2]]></STDPRECISION>
 <!--240 COSTINGPRECISION-->
 <!--240-->              <COSTINGPRECISION><![CDATA[4]]></COSTINGPRECISION>
-<!--240 ISEURO-->
-<!--240-->              <ISEURO><![CDATA[N]]></ISEURO>
-<!--240 ISEMUMEMBER-->
-<!--240-->              <ISEMUMEMBER><![CDATA[N]]></ISEMUMEMBER>
 <!--240 PRICEPRECISION-->
 <!--240-->              <PRICEPRECISION><![CDATA[0]]></PRICEPRECISION>
 <!--240**************--></C_CURRENCY>
@@ -2881,10 +2505,6 @@
 <!--241-->              <STDPRECISION><![CDATA[2]]></STDPRECISION>
 <!--241 COSTINGPRECISION-->
 <!--241-->              <COSTINGPRECISION><![CDATA[4]]></COSTINGPRECISION>
-<!--241 ISEURO-->
-<!--241-->              <ISEURO><![CDATA[N]]></ISEURO>
-<!--241 ISEMUMEMBER-->
-<!--241-->              <ISEMUMEMBER><![CDATA[N]]></ISEMUMEMBER>
 <!--241 PRICEPRECISION-->
 <!--241-->              <PRICEPRECISION><![CDATA[0]]></PRICEPRECISION>
 <!--241**************--></C_CURRENCY>
@@ -2916,10 +2536,6 @@
 <!--244-->              <STDPRECISION><![CDATA[2]]></STDPRECISION>
 <!--244 COSTINGPRECISION-->
 <!--244-->              <COSTINGPRECISION><![CDATA[4]]></COSTINGPRECISION>
-<!--244 ISEURO-->
-<!--244-->              <ISEURO><![CDATA[N]]></ISEURO>
-<!--244 ISEMUMEMBER-->
-<!--244-->              <ISEMUMEMBER><![CDATA[N]]></ISEMUMEMBER>
 <!--244 PRICEPRECISION-->
 <!--244-->              <PRICEPRECISION><![CDATA[0]]></PRICEPRECISION>
 <!--244**************--></C_CURRENCY>
@@ -2951,10 +2567,6 @@
 <!--252-->              <STDPRECISION><![CDATA[2]]></STDPRECISION>
 <!--252 COSTINGPRECISION-->
 <!--252-->              <COSTINGPRECISION><![CDATA[4]]></COSTINGPRECISION>
-<!--252 ISEURO-->
-<!--252-->              <ISEURO><![CDATA[N]]></ISEURO>
-<!--252 ISEMUMEMBER-->
-<!--252-->              <ISEMUMEMBER><![CDATA[N]]></ISEMUMEMBER>
 <!--252 PRICEPRECISION-->
 <!--252-->              <PRICEPRECISION><![CDATA[0]]></PRICEPRECISION>
 <!--252**************--></C_CURRENCY>
@@ -2986,10 +2598,6 @@
 <!--253-->              <STDPRECISION><![CDATA[0]]></STDPRECISION>
 <!--253 COSTINGPRECISION-->
 <!--253-->              <COSTINGPRECISION><![CDATA[2]]></COSTINGPRECISION>
-<!--253 ISEURO-->
-<!--253-->              <ISEURO><![CDATA[N]]></ISEURO>
-<!--253 ISEMUMEMBER-->
-<!--253-->              <ISEMUMEMBER><![CDATA[N]]></ISEMUMEMBER>
 <!--253 PRICEPRECISION-->
 <!--253-->              <PRICEPRECISION><![CDATA[0]]></PRICEPRECISION>
 <!--253**************--></C_CURRENCY>
@@ -3021,10 +2629,6 @@
 <!--254-->              <STDPRECISION><![CDATA[0]]></STDPRECISION>
 <!--254 COSTINGPRECISION-->
 <!--254-->              <COSTINGPRECISION><![CDATA[2]]></COSTINGPRECISION>
-<!--254 ISEURO-->
-<!--254-->              <ISEURO><![CDATA[N]]></ISEURO>
-<!--254 ISEMUMEMBER-->
-<!--254-->              <ISEMUMEMBER><![CDATA[N]]></ISEMUMEMBER>
 <!--254 PRICEPRECISION-->
 <!--254-->              <PRICEPRECISION><![CDATA[0]]></PRICEPRECISION>
 <!--254**************--></C_CURRENCY>
@@ -3056,10 +2660,6 @@
 <!--255-->              <STDPRECISION><![CDATA[2]]></STDPRECISION>
 <!--255 COSTINGPRECISION-->
 <!--255-->              <COSTINGPRECISION><![CDATA[4]]></COSTINGPRECISION>
-<!--255 ISEURO-->
-<!--255-->              <ISEURO><![CDATA[N]]></ISEURO>
-<!--255 ISEMUMEMBER-->
-<!--255-->              <ISEMUMEMBER><![CDATA[N]]></ISEMUMEMBER>
 <!--255 PRICEPRECISION-->
 <!--255-->              <PRICEPRECISION><![CDATA[0]]></PRICEPRECISION>
 <!--255**************--></C_CURRENCY>
@@ -3091,10 +2691,6 @@
 <!--256-->              <STDPRECISION><![CDATA[2]]></STDPRECISION>
 <!--256 COSTINGPRECISION-->
 <!--256-->              <COSTINGPRECISION><![CDATA[4]]></COSTINGPRECISION>
-<!--256 ISEURO-->
-<!--256-->              <ISEURO><![CDATA[N]]></ISEURO>
-<!--256 ISEMUMEMBER-->
-<!--256-->              <ISEMUMEMBER><![CDATA[N]]></ISEMUMEMBER>
 <!--256 PRICEPRECISION-->
 <!--256-->              <PRICEPRECISION><![CDATA[0]]></PRICEPRECISION>
 <!--256**************--></C_CURRENCY>
@@ -3126,10 +2722,6 @@
 <!--257-->              <STDPRECISION><![CDATA[2]]></STDPRECISION>
 <!--257 COSTINGPRECISION-->
 <!--257-->              <COSTINGPRECISION><![CDATA[4]]></COSTINGPRECISION>
-<!--257 ISEURO-->
-<!--257-->              <ISEURO><![CDATA[N]]></ISEURO>
-<!--257 ISEMUMEMBER-->
-<!--257-->              <ISEMUMEMBER><![CDATA[N]]></ISEMUMEMBER>
 <!--257 PRICEPRECISION-->
 <!--257-->              <PRICEPRECISION><![CDATA[0]]></PRICEPRECISION>
 <!--257**************--></C_CURRENCY>
@@ -3161,10 +2753,6 @@
 <!--258-->              <STDPRECISION><![CDATA[2]]></STDPRECISION>
 <!--258 COSTINGPRECISION-->
 <!--258-->              <COSTINGPRECISION><![CDATA[4]]></COSTINGPRECISION>
-<!--258 ISEURO-->
-<!--258-->              <ISEURO><![CDATA[N]]></ISEURO>
-<!--258 ISEMUMEMBER-->
-<!--258-->              <ISEMUMEMBER><![CDATA[N]]></ISEMUMEMBER>
 <!--258 PRICEPRECISION-->
 <!--258-->              <PRICEPRECISION><![CDATA[0]]></PRICEPRECISION>
 <!--258**************--></C_CURRENCY>
@@ -3196,10 +2784,6 @@
 <!--259-->              <STDPRECISION><![CDATA[2]]></STDPRECISION>
 <!--259 COSTINGPRECISION-->
 <!--259-->              <COSTINGPRECISION><![CDATA[4]]></COSTINGPRECISION>
-<!--259 ISEURO-->
-<!--259-->              <ISEURO><![CDATA[N]]></ISEURO>
-<!--259 ISEMUMEMBER-->
-<!--259-->              <ISEMUMEMBER><![CDATA[N]]></ISEMUMEMBER>
 <!--259 PRICEPRECISION-->
 <!--259-->              <PRICEPRECISION><![CDATA[0]]></PRICEPRECISION>
 <!--259**************--></C_CURRENCY>
@@ -3231,10 +2815,6 @@
 <!--260-->              <STDPRECISION><![CDATA[3]]></STDPRECISION>
 <!--260 COSTINGPRECISION-->
 <!--260-->              <COSTINGPRECISION><![CDATA[5]]></COSTINGPRECISION>
-<!--260 ISEURO-->
-<!--260-->              <ISEURO><![CDATA[N]]></ISEURO>
-<!--260 ISEMUMEMBER-->
-<!--260-->              <ISEMUMEMBER><![CDATA[N]]></ISEMUMEMBER>
 <!--260 PRICEPRECISION-->
 <!--260-->              <PRICEPRECISION><![CDATA[0]]></PRICEPRECISION>
 <!--260**************--></C_CURRENCY>
@@ -3266,10 +2846,6 @@
 <!--261-->              <STDPRECISION><![CDATA[2]]></STDPRECISION>
 <!--261 COSTINGPRECISION-->
 <!--261-->              <COSTINGPRECISION><![CDATA[4]]></COSTINGPRECISION>
-<!--261 ISEURO-->
-<!--261-->              <ISEURO><![CDATA[N]]></ISEURO>
-<!--261 ISEMUMEMBER-->
-<!--261-->              <ISEMUMEMBER><![CDATA[N]]></ISEMUMEMBER>
 <!--261 PRICEPRECISION-->
 <!--261-->              <PRICEPRECISION><![CDATA[0]]></PRICEPRECISION>
 <!--261**************--></C_CURRENCY>
@@ -3301,10 +2877,6 @@
 <!--262-->              <STDPRECISION><![CDATA[2]]></STDPRECISION>
 <!--262 COSTINGPRECISION-->
 <!--262-->              <COSTINGPRECISION><![CDATA[4]]></COSTINGPRECISION>
-<!--262 ISEURO-->
-<!--262-->              <ISEURO><![CDATA[N]]></ISEURO>
-<!--262 ISEMUMEMBER-->
-<!--262-->              <ISEMUMEMBER><![CDATA[N]]></ISEMUMEMBER>
 <!--262 PRICEPRECISION-->
 <!--262-->              <PRICEPRECISION><![CDATA[0]]></PRICEPRECISION>
 <!--262**************--></C_CURRENCY>
@@ -3336,10 +2908,6 @@
 <!--263-->              <STDPRECISION><![CDATA[3]]></STDPRECISION>
 <!--263 COSTINGPRECISION-->
 <!--263-->              <COSTINGPRECISION><![CDATA[5]]></COSTINGPRECISION>
-<!--263 ISEURO-->
-<!--263-->              <ISEURO><![CDATA[N]]></ISEURO>
-<!--263 ISEMUMEMBER-->
-<!--263-->              <ISEMUMEMBER><![CDATA[N]]></ISEMUMEMBER>
 <!--263 PRICEPRECISION-->
 <!--263-->              <PRICEPRECISION><![CDATA[0]]></PRICEPRECISION>
 <!--263**************--></C_CURRENCY>
@@ -3371,10 +2939,6 @@
 <!--264-->              <STDPRECISION><![CDATA[2]]></STDPRECISION>
 <!--264 COSTINGPRECISION-->
 <!--264-->              <COSTINGPRECISION><![CDATA[4]]></COSTINGPRECISION>
-<!--264 ISEURO-->
-<!--264-->              <ISEURO><![CDATA[N]]></ISEURO>
-<!--264 ISEMUMEMBER-->
-<!--264-->              <ISEMUMEMBER><![CDATA[N]]></ISEMUMEMBER>
 <!--264 PRICEPRECISION-->
 <!--264-->              <PRICEPRECISION><![CDATA[0]]></PRICEPRECISION>
 <!--264**************--></C_CURRENCY>
@@ -3406,10 +2970,6 @@
 <!--265-->              <STDPRECISION><![CDATA[2]]></STDPRECISION>
 <!--265 COSTINGPRECISION-->
 <!--265-->              <COSTINGPRECISION><![CDATA[4]]></COSTINGPRECISION>
-<!--265 ISEURO-->
-<!--265-->              <ISEURO><![CDATA[N]]></ISEURO>
-<!--265 ISEMUMEMBER-->
-<!--265-->              <ISEMUMEMBER><![CDATA[N]]></ISEMUMEMBER>
 <!--265 PRICEPRECISION-->
 <!--265-->              <PRICEPRECISION><![CDATA[0]]></PRICEPRECISION>
 <!--265**************--></C_CURRENCY>
@@ -3441,10 +3001,6 @@
 <!--266-->              <STDPRECISION><![CDATA[2]]></STDPRECISION>
 <!--266 COSTINGPRECISION-->
 <!--266-->              <COSTINGPRECISION><![CDATA[4]]></COSTINGPRECISION>
-<!--266 ISEURO-->
-<!--266-->              <ISEURO><![CDATA[N]]></ISEURO>
-<!--266 ISEMUMEMBER-->
-<!--266-->              <ISEMUMEMBER><![CDATA[N]]></ISEMUMEMBER>
 <!--266 PRICEPRECISION-->
 <!--266-->              <PRICEPRECISION><![CDATA[0]]></PRICEPRECISION>
 <!--266**************--></C_CURRENCY>
@@ -3476,10 +3032,6 @@
 <!--267-->              <STDPRECISION><![CDATA[3]]></STDPRECISION>
 <!--267 COSTINGPRECISION-->
 <!--267-->              <COSTINGPRECISION><![CDATA[5]]></COSTINGPRECISION>
-<!--267 ISEURO-->
-<!--267-->              <ISEURO><![CDATA[N]]></ISEURO>
-<!--267 ISEMUMEMBER-->
-<!--267-->              <ISEMUMEMBER><![CDATA[N]]></ISEMUMEMBER>
 <!--267 PRICEPRECISION-->
 <!--267-->              <PRICEPRECISION><![CDATA[0]]></PRICEPRECISION>
 <!--267**************--></C_CURRENCY>
@@ -3511,10 +3063,6 @@
 <!--268-->              <STDPRECISION><![CDATA[2]]></STDPRECISION>
 <!--268 COSTINGPRECISION-->
 <!--268-->              <COSTINGPRECISION><![CDATA[4]]></COSTINGPRECISION>
-<!--268 ISEURO-->
-<!--268-->              <ISEURO><![CDATA[N]]></ISEURO>
-<!--268 ISEMUMEMBER-->
-<!--268-->              <ISEMUMEMBER><![CDATA[N]]></ISEMUMEMBER>
 <!--268 PRICEPRECISION-->
 <!--268-->              <PRICEPRECISION><![CDATA[0]]></PRICEPRECISION>
 <!--268**************--></C_CURRENCY>
@@ -3546,10 +3094,6 @@
 <!--269-->              <STDPRECISION><![CDATA[2]]></STDPRECISION>
 <!--269 COSTINGPRECISION-->
 <!--269-->              <COSTINGPRECISION><![CDATA[4]]></COSTINGPRECISION>
-<!--269 ISEURO-->
-<!--269-->              <ISEURO><![CDATA[N]]></ISEURO>
-<!--269 ISEMUMEMBER-->
-<!--269-->              <ISEMUMEMBER><![CDATA[N]]></ISEMUMEMBER>
 <!--269 PRICEPRECISION-->
 <!--269-->              <PRICEPRECISION><![CDATA[0]]></PRICEPRECISION>
 <!--269**************--></C_CURRENCY>
@@ -3581,10 +3125,6 @@
 <!--270-->              <STDPRECISION><![CDATA[2]]></STDPRECISION>
 <!--270 COSTINGPRECISION-->
 <!--270-->              <COSTINGPRECISION><![CDATA[4]]></COSTINGPRECISION>
-<!--270 ISEURO-->
-<!--270-->              <ISEURO><![CDATA[N]]></ISEURO>
-<!--270 ISEMUMEMBER-->
-<!--270-->              <ISEMUMEMBER><![CDATA[N]]></ISEMUMEMBER>
 <!--270 PRICEPRECISION-->
 <!--270-->              <PRICEPRECISION><![CDATA[0]]></PRICEPRECISION>
 <!--270**************--></C_CURRENCY>
@@ -3616,10 +3156,6 @@
 <!--271-->              <STDPRECISION><![CDATA[2]]></STDPRECISION>
 <!--271 COSTINGPRECISION-->
 <!--271-->              <COSTINGPRECISION><![CDATA[4]]></COSTINGPRECISION>
-<!--271 ISEURO-->
-<!--271-->              <ISEURO><![CDATA[N]]></ISEURO>
-<!--271 ISEMUMEMBER-->
-<!--271-->              <ISEMUMEMBER><![CDATA[N]]></ISEMUMEMBER>
 <!--271 PRICEPRECISION-->
 <!--271-->              <PRICEPRECISION><![CDATA[0]]></PRICEPRECISION>
 <!--271**************--></C_CURRENCY>
@@ -3651,10 +3187,6 @@
 <!--272-->              <STDPRECISION><![CDATA[2]]></STDPRECISION>
 <!--272 COSTINGPRECISION-->
 <!--272-->              <COSTINGPRECISION><![CDATA[4]]></COSTINGPRECISION>
-<!--272 ISEURO-->
-<!--272-->              <ISEURO><![CDATA[N]]></ISEURO>
-<!--272 ISEMUMEMBER-->
-<!--272-->              <ISEMUMEMBER><![CDATA[N]]></ISEMUMEMBER>
 <!--272 PRICEPRECISION-->
 <!--272-->              <PRICEPRECISION><![CDATA[0]]></PRICEPRECISION>
 <!--272**************--></C_CURRENCY>
@@ -3686,10 +3218,6 @@
 <!--273-->              <STDPRECISION><![CDATA[2]]></STDPRECISION>
 <!--273 COSTINGPRECISION-->
 <!--273-->              <COSTINGPRECISION><![CDATA[4]]></COSTINGPRECISION>
-<!--273 ISEURO-->
-<!--273-->              <ISEURO><![CDATA[N]]></ISEURO>
-<!--273 ISEMUMEMBER-->
-<!--273-->              <ISEMUMEMBER><![CDATA[N]]></ISEMUMEMBER>
 <!--273 PRICEPRECISION-->
 <!--273-->              <PRICEPRECISION><![CDATA[0]]></PRICEPRECISION>
 <!--273**************--></C_CURRENCY>
@@ -3721,10 +3249,6 @@
 <!--274-->              <STDPRECISION><![CDATA[2]]></STDPRECISION>
 <!--274 COSTINGPRECISION-->
 <!--274-->              <COSTINGPRECISION><![CDATA[4]]></COSTINGPRECISION>
-<!--274 ISEURO-->
-<!--274-->              <ISEURO><![CDATA[N]]></ISEURO>
-<!--274 ISEMUMEMBER-->
-<!--274-->              <ISEMUMEMBER><![CDATA[N]]></ISEMUMEMBER>
 <!--274 PRICEPRECISION-->
 <!--274-->              <PRICEPRECISION><![CDATA[0]]></PRICEPRECISION>
 <!--274**************--></C_CURRENCY>
@@ -3756,10 +3280,6 @@
 <!--275-->              <STDPRECISION><![CDATA[3]]></STDPRECISION>
 <!--275 COSTINGPRECISION-->
 <!--275-->              <COSTINGPRECISION><![CDATA[5]]></COSTINGPRECISION>
-<!--275 ISEURO-->
-<!--275-->              <ISEURO><![CDATA[N]]></ISEURO>
-<!--275 ISEMUMEMBER-->
-<!--275-->              <ISEMUMEMBER><![CDATA[N]]></ISEMUMEMBER>
 <!--275 PRICEPRECISION-->
 <!--275-->              <PRICEPRECISION><![CDATA[0]]></PRICEPRECISION>
 <!--275**************--></C_CURRENCY>
@@ -3791,10 +3311,6 @@
 <!--276-->              <STDPRECISION><![CDATA[2]]></STDPRECISION>
 <!--276 COSTINGPRECISION-->
 <!--276-->              <COSTINGPRECISION><![CDATA[4]]></COSTINGPRECISION>
-<!--276 ISEURO-->
-<!--276-->              <ISEURO><![CDATA[N]]></ISEURO>
-<!--276 ISEMUMEMBER-->
-<!--276-->              <ISEMUMEMBER><![CDATA[N]]></ISEMUMEMBER>
 <!--276 PRICEPRECISION-->
 <!--276-->              <PRICEPRECISION><![CDATA[0]]></PRICEPRECISION>
 <!--276**************--></C_CURRENCY>
@@ -3826,10 +3342,6 @@
 <!--277-->              <STDPRECISION><![CDATA[2]]></STDPRECISION>
 <!--277 COSTINGPRECISION-->
 <!--277-->              <COSTINGPRECISION><![CDATA[4]]></COSTINGPRECISION>
-<!--277 ISEURO-->
-<!--277-->              <ISEURO><![CDATA[N]]></ISEURO>
-<!--277 ISEMUMEMBER-->
-<!--277-->              <ISEMUMEMBER><![CDATA[N]]></ISEMUMEMBER>
 <!--277 PRICEPRECISION-->
 <!--277-->              <PRICEPRECISION><![CDATA[0]]></PRICEPRECISION>
 <!--277**************--></C_CURRENCY>
@@ -3861,10 +3373,6 @@
 <!--278-->              <STDPRECISION><![CDATA[2]]></STDPRECISION>
 <!--278 COSTINGPRECISION-->
 <!--278-->              <COSTINGPRECISION><![CDATA[4]]></COSTINGPRECISION>
-<!--278 ISEURO-->
-<!--278-->              <ISEURO><![CDATA[N]]></ISEURO>
-<!--278 ISEMUMEMBER-->
-<!--278-->              <ISEMUMEMBER><![CDATA[N]]></ISEMUMEMBER>
 <!--278 PRICEPRECISION-->
 <!--278-->              <PRICEPRECISION><![CDATA[0]]></PRICEPRECISION>
 <!--278**************--></C_CURRENCY>
@@ -3896,10 +3404,6 @@
 <!--279-->              <STDPRECISION><![CDATA[2]]></STDPRECISION>
 <!--279 COSTINGPRECISION-->
 <!--279-->              <COSTINGPRECISION><![CDATA[4]]></COSTINGPRECISION>
-<!--279 ISEURO-->
-<!--279-->              <ISEURO><![CDATA[N]]></ISEURO>
-<!--279 ISEMUMEMBER-->
-<!--279-->              <ISEMUMEMBER><![CDATA[N]]></ISEMUMEMBER>
 <!--279 PRICEPRECISION-->
 <!--279-->              <PRICEPRECISION><![CDATA[0]]></PRICEPRECISION>
 <!--279**************--></C_CURRENCY>
@@ -3931,10 +3435,6 @@
 <!--280-->              <STDPRECISION><![CDATA[2]]></STDPRECISION>
 <!--280 COSTINGPRECISION-->
 <!--280-->              <COSTINGPRECISION><![CDATA[4]]></COSTINGPRECISION>
-<!--280 ISEURO-->
-<!--280-->              <ISEURO><![CDATA[N]]></ISEURO>
-<!--280 ISEMUMEMBER-->
-<!--280-->              <ISEMUMEMBER><![CDATA[N]]></ISEMUMEMBER>
 <!--280 PRICEPRECISION-->
 <!--280-->              <PRICEPRECISION><![CDATA[0]]></PRICEPRECISION>
 <!--280**************--></C_CURRENCY>
@@ -3966,10 +3466,6 @@
 <!--281-->              <STDPRECISION><![CDATA[2]]></STDPRECISION>
 <!--281 COSTINGPRECISION-->
 <!--281-->              <COSTINGPRECISION><![CDATA[4]]></COSTINGPRECISION>
-<!--281 ISEURO-->
-<!--281-->              <ISEURO><![CDATA[N]]></ISEURO>
-<!--281 ISEMUMEMBER-->
-<!--281-->              <ISEMUMEMBER><![CDATA[N]]></ISEMUMEMBER>
 <!--281 PRICEPRECISION-->
 <!--281-->              <PRICEPRECISION><![CDATA[0]]></PRICEPRECISION>
 <!--281**************--></C_CURRENCY>
@@ -4001,10 +3497,6 @@
 <!--282-->              <STDPRECISION><![CDATA[2]]></STDPRECISION>
 <!--282 COSTINGPRECISION-->
 <!--282-->              <COSTINGPRECISION><![CDATA[4]]></COSTINGPRECISION>
-<!--282 ISEURO-->
-<!--282-->              <ISEURO><![CDATA[N]]></ISEURO>
-<!--282 ISEMUMEMBER-->
-<!--282-->              <ISEMUMEMBER><![CDATA[N]]></ISEMUMEMBER>
 <!--282 PRICEPRECISION-->
 <!--282-->              <PRICEPRECISION><![CDATA[0]]></PRICEPRECISION>
 <!--282**************--></C_CURRENCY>
@@ -4036,10 +3528,6 @@
 <!--283-->              <STDPRECISION><![CDATA[2]]></STDPRECISION>
 <!--283 COSTINGPRECISION-->
 <!--283-->              <COSTINGPRECISION><![CDATA[4]]></COSTINGPRECISION>
-<!--283 ISEURO-->
-<!--283-->              <ISEURO><![CDATA[N]]></ISEURO>
-<!--283 ISEMUMEMBER-->
-<!--283-->              <ISEMUMEMBER><![CDATA[N]]></ISEMUMEMBER>
 <!--283 PRICEPRECISION-->
 <!--283-->              <PRICEPRECISION><![CDATA[0]]></PRICEPRECISION>
 <!--283**************--></C_CURRENCY>
@@ -4071,10 +3559,6 @@
 <!--284-->              <STDPRECISION><![CDATA[2]]></STDPRECISION>
 <!--284 COSTINGPRECISION-->
 <!--284-->              <COSTINGPRECISION><![CDATA[4]]></COSTINGPRECISION>
-<!--284 ISEURO-->
-<!--284-->              <ISEURO><![CDATA[N]]></ISEURO>
-<!--284 ISEMUMEMBER-->
-<!--284-->              <ISEMUMEMBER><![CDATA[N]]></ISEMUMEMBER>
 <!--284 PRICEPRECISION-->
 <!--284-->              <PRICEPRECISION><![CDATA[0]]></PRICEPRECISION>
 <!--284**************--></C_CURRENCY>
@@ -4106,10 +3590,6 @@
 <!--285-->              <STDPRECISION><![CDATA[2]]></STDPRECISION>
 <!--285 COSTINGPRECISION-->
 <!--285-->              <COSTINGPRECISION><![CDATA[4]]></COSTINGPRECISION>
-<!--285 ISEURO-->
-<!--285-->              <ISEURO><![CDATA[N]]></ISEURO>
-<!--285 ISEMUMEMBER-->
-<!--285-->              <ISEMUMEMBER><![CDATA[N]]></ISEMUMEMBER>
 <!--285 PRICEPRECISION-->
 <!--285-->              <PRICEPRECISION><![CDATA[0]]></PRICEPRECISION>
 <!--285**************--></C_CURRENCY>
@@ -4141,10 +3621,6 @@
 <!--286-->              <STDPRECISION><![CDATA[2]]></STDPRECISION>
 <!--286 COSTINGPRECISION-->
 <!--286-->              <COSTINGPRECISION><![CDATA[4]]></COSTINGPRECISION>
-<!--286 ISEURO-->
-<!--286-->              <ISEURO><![CDATA[N]]></ISEURO>
-<!--286 ISEMUMEMBER-->
-<!--286-->              <ISEMUMEMBER><![CDATA[N]]></ISEMUMEMBER>
 <!--286 PRICEPRECISION-->
 <!--286-->              <PRICEPRECISION><![CDATA[0]]></PRICEPRECISION>
 <!--286**************--></C_CURRENCY>
@@ -4176,10 +3652,6 @@
 <!--287-->              <STDPRECISION><![CDATA[2]]></STDPRECISION>
 <!--287 COSTINGPRECISION-->
 <!--287-->              <COSTINGPRECISION><![CDATA[4]]></COSTINGPRECISION>
-<!--287 ISEURO-->
-<!--287-->              <ISEURO><![CDATA[N]]></ISEURO>
-<!--287 ISEMUMEMBER-->
-<!--287-->              <ISEMUMEMBER><![CDATA[N]]></ISEMUMEMBER>
 <!--287 PRICEPRECISION-->
 <!--287-->              <PRICEPRECISION><![CDATA[0]]></PRICEPRECISION>
 <!--287**************--></C_CURRENCY>
@@ -4211,10 +3683,6 @@
 <!--288-->              <STDPRECISION><![CDATA[2]]></STDPRECISION>
 <!--288 COSTINGPRECISION-->
 <!--288-->              <COSTINGPRECISION><![CDATA[4]]></COSTINGPRECISION>
-<!--288 ISEURO-->
-<!--288-->              <ISEURO><![CDATA[N]]></ISEURO>
-<!--288 ISEMUMEMBER-->
-<!--288-->              <ISEMUMEMBER><![CDATA[N]]></ISEMUMEMBER>
 <!--288 PRICEPRECISION-->
 <!--288-->              <PRICEPRECISION><![CDATA[0]]></PRICEPRECISION>
 <!--288**************--></C_CURRENCY>
@@ -4246,10 +3714,6 @@
 <!--289-->              <STDPRECISION><![CDATA[2]]></STDPRECISION>
 <!--289 COSTINGPRECISION-->
 <!--289-->              <COSTINGPRECISION><![CDATA[4]]></COSTINGPRECISION>
-<!--289 ISEURO-->
-<!--289-->              <ISEURO><![CDATA[N]]></ISEURO>
-<!--289 ISEMUMEMBER-->
-<!--289-->              <ISEMUMEMBER><![CDATA[N]]></ISEMUMEMBER>
 <!--289 PRICEPRECISION-->
 <!--289-->              <PRICEPRECISION><![CDATA[0]]></PRICEPRECISION>
 <!--289**************--></C_CURRENCY>
@@ -4281,10 +3745,6 @@
 <!--290-->              <STDPRECISION><![CDATA[2]]></STDPRECISION>
 <!--290 COSTINGPRECISION-->
 <!--290-->              <COSTINGPRECISION><![CDATA[4]]></COSTINGPRECISION>
-<!--290 ISEURO-->
-<!--290-->              <ISEURO><![CDATA[N]]></ISEURO>
-<!--290 ISEMUMEMBER-->
-<!--290-->              <ISEMUMEMBER><![CDATA[N]]></ISEMUMEMBER>
 <!--290 PRICEPRECISION-->
 <!--290-->              <PRICEPRECISION><![CDATA[0]]></PRICEPRECISION>
 <!--290**************--></C_CURRENCY>
@@ -4316,10 +3776,6 @@
 <!--291-->              <STDPRECISION><![CDATA[2]]></STDPRECISION>
 <!--291 COSTINGPRECISION-->
 <!--291-->              <COSTINGPRECISION><![CDATA[4]]></COSTINGPRECISION>
-<!--291 ISEURO-->
-<!--291-->              <ISEURO><![CDATA[N]]></ISEURO>
-<!--291 ISEMUMEMBER-->
-<!--291-->              <ISEMUMEMBER><![CDATA[N]]></ISEMUMEMBER>
 <!--291 PRICEPRECISION-->
 <!--291-->              <PRICEPRECISION><![CDATA[0]]></PRICEPRECISION>
 <!--291**************--></C_CURRENCY>
@@ -4351,10 +3807,6 @@
 <!--292-->              <STDPRECISION><![CDATA[2]]></STDPRECISION>
 <!--292 COSTINGPRECISION-->
 <!--292-->              <COSTINGPRECISION><![CDATA[4]]></COSTINGPRECISION>
-<!--292 ISEURO-->
-<!--292-->              <ISEURO><![CDATA[N]]></ISEURO>
-<!--292 ISEMUMEMBER-->
-<!--292-->              <ISEMUMEMBER><![CDATA[N]]></ISEMUMEMBER>
 <!--292 PRICEPRECISION-->
 <!--292-->              <PRICEPRECISION><![CDATA[0]]></PRICEPRECISION>
 <!--292**************--></C_CURRENCY>
@@ -4386,10 +3838,6 @@
 <!--293-->              <STDPRECISION><![CDATA[2]]></STDPRECISION>
 <!--293 COSTINGPRECISION-->
 <!--293-->              <COSTINGPRECISION><![CDATA[4]]></COSTINGPRECISION>
-<!--293 ISEURO-->
-<!--293-->              <ISEURO><![CDATA[N]]></ISEURO>
-<!--293 ISEMUMEMBER-->
-<!--293-->              <ISEMUMEMBER><![CDATA[N]]></ISEMUMEMBER>
 <!--293 PRICEPRECISION-->
 <!--293-->              <PRICEPRECISION><![CDATA[0]]></PRICEPRECISION>
 <!--293**************--></C_CURRENCY>
@@ -4421,10 +3869,6 @@
 <!--294-->              <STDPRECISION><![CDATA[2]]></STDPRECISION>
 <!--294 COSTINGPRECISION-->
 <!--294-->              <COSTINGPRECISION><![CDATA[4]]></COSTINGPRECISION>
-<!--294 ISEURO-->
-<!--294-->              <ISEURO><![CDATA[N]]></ISEURO>
-<!--294 ISEMUMEMBER-->
-<!--294-->              <ISEMUMEMBER><![CDATA[N]]></ISEMUMEMBER>
 <!--294 PRICEPRECISION-->
 <!--294-->              <PRICEPRECISION><![CDATA[0]]></PRICEPRECISION>
 <!--294**************--></C_CURRENCY>
@@ -4456,10 +3900,6 @@
 <!--297-->              <STDPRECISION><![CDATA[2]]></STDPRECISION>
 <!--297 COSTINGPRECISION-->
 <!--297-->              <COSTINGPRECISION><![CDATA[4]]></COSTINGPRECISION>
-<!--297 ISEURO-->
-<!--297-->              <ISEURO><![CDATA[N]]></ISEURO>
-<!--297 ISEMUMEMBER-->
-<!--297-->              <ISEMUMEMBER><![CDATA[N]]></ISEMUMEMBER>
 <!--297 PRICEPRECISION-->
 <!--297-->              <PRICEPRECISION><![CDATA[0]]></PRICEPRECISION>
 <!--297**************--></C_CURRENCY>
@@ -4491,10 +3931,6 @@
 <!--298-->              <STDPRECISION><![CDATA[2]]></STDPRECISION>
 <!--298 COSTINGPRECISION-->
 <!--298-->              <COSTINGPRECISION><![CDATA[4]]></COSTINGPRECISION>
-<!--298 ISEURO-->
-<!--298-->              <ISEURO><![CDATA[N]]></ISEURO>
-<!--298 ISEMUMEMBER-->
-<!--298-->              <ISEMUMEMBER><![CDATA[N]]></ISEMUMEMBER>
 <!--298 PRICEPRECISION-->
 <!--298-->              <PRICEPRECISION><![CDATA[0]]></PRICEPRECISION>
 <!--298**************--></C_CURRENCY>
@@ -4526,10 +3962,6 @@
 <!--299-->              <STDPRECISION><![CDATA[2]]></STDPRECISION>
 <!--299 COSTINGPRECISION-->
 <!--299-->              <COSTINGPRECISION><![CDATA[4]]></COSTINGPRECISION>
-<!--299 ISEURO-->
-<!--299-->              <ISEURO><![CDATA[N]]></ISEURO>
-<!--299 ISEMUMEMBER-->
-<!--299-->              <ISEMUMEMBER><![CDATA[N]]></ISEMUMEMBER>
 <!--299 PRICEPRECISION-->
 <!--299-->              <PRICEPRECISION><![CDATA[0]]></PRICEPRECISION>
 <!--299**************--></C_CURRENCY>
@@ -4561,10 +3993,6 @@
 <!--300-->              <STDPRECISION><![CDATA[0]]></STDPRECISION>
 <!--300 COSTINGPRECISION-->
 <!--300-->              <COSTINGPRECISION><![CDATA[2]]></COSTINGPRECISION>
-<!--300 ISEURO-->
-<!--300-->              <ISEURO><![CDATA[N]]></ISEURO>
-<!--300 ISEMUMEMBER-->
-<!--300-->              <ISEMUMEMBER><![CDATA[N]]></ISEMUMEMBER>
 <!--300 PRICEPRECISION-->
 <!--300-->              <PRICEPRECISION><![CDATA[0]]></PRICEPRECISION>
 <!--300**************--></C_CURRENCY>
@@ -4596,10 +4024,6 @@
 <!--301-->              <STDPRECISION><![CDATA[2]]></STDPRECISION>
 <!--301 COSTINGPRECISION-->
 <!--301-->              <COSTINGPRECISION><![CDATA[4]]></COSTINGPRECISION>
-<!--301 ISEURO-->
-<!--301-->              <ISEURO><![CDATA[N]]></ISEURO>
-<!--301 ISEMUMEMBER-->
-<!--301-->              <ISEMUMEMBER><![CDATA[N]]></ISEMUMEMBER>
 <!--301 PRICEPRECISION-->
 <!--301-->              <PRICEPRECISION><![CDATA[0]]></PRICEPRECISION>
 <!--301**************--></C_CURRENCY>
@@ -4631,10 +4055,6 @@
 <!--302-->              <STDPRECISION><![CDATA[3]]></STDPRECISION>
 <!--302 COSTINGPRECISION-->
 <!--302-->              <COSTINGPRECISION><![CDATA[5]]></COSTINGPRECISION>
-<!--302 ISEURO-->
-<!--302-->              <ISEURO><![CDATA[N]]></ISEURO>
-<!--302 ISEMUMEMBER-->
-<!--302-->              <ISEMUMEMBER><![CDATA[N]]></ISEMUMEMBER>
 <!--302 PRICEPRECISION-->
 <!--302-->              <PRICEPRECISION><![CDATA[0]]></PRICEPRECISION>
 <!--302**************--></C_CURRENCY>
@@ -4666,10 +4086,6 @@
 <!--303-->              <STDPRECISION><![CDATA[2]]></STDPRECISION>
 <!--303 COSTINGPRECISION-->
 <!--303-->              <COSTINGPRECISION><![CDATA[4]]></COSTINGPRECISION>
-<!--303 ISEURO-->
-<!--303-->              <ISEURO><![CDATA[N]]></ISEURO>
-<!--303 ISEMUMEMBER-->
-<!--303-->              <ISEMUMEMBER><![CDATA[N]]></ISEMUMEMBER>
 <!--303 PRICEPRECISION-->
 <!--303-->              <PRICEPRECISION><![CDATA[0]]></PRICEPRECISION>
 <!--303**************--></C_CURRENCY>
@@ -4701,10 +4117,6 @@
 <!--304-->              <STDPRECISION><![CDATA[2]]></STDPRECISION>
 <!--304 COSTINGPRECISION-->
 <!--304-->              <COSTINGPRECISION><![CDATA[4]]></COSTINGPRECISION>
-<!--304 ISEURO-->
-<!--304-->              <ISEURO><![CDATA[N]]></ISEURO>
-<!--304 ISEMUMEMBER-->
-<!--304-->              <ISEMUMEMBER><![CDATA[N]]></ISEMUMEMBER>
 <!--304 PRICEPRECISION-->
 <!--304-->              <PRICEPRECISION><![CDATA[0]]></PRICEPRECISION>
 <!--304**************--></C_CURRENCY>
@@ -4736,10 +4148,6 @@
 <!--306-->              <STDPRECISION><![CDATA[2]]></STDPRECISION>
 <!--306 COSTINGPRECISION-->
 <!--306-->              <COSTINGPRECISION><![CDATA[4]]></COSTINGPRECISION>
-<!--306 ISEURO-->
-<!--306-->              <ISEURO><![CDATA[N]]></ISEURO>
-<!--306 ISEMUMEMBER-->
-<!--306-->              <ISEMUMEMBER><![CDATA[N]]></ISEMUMEMBER>
 <!--306 PRICEPRECISION-->
 <!--306-->              <PRICEPRECISION><![CDATA[0]]></PRICEPRECISION>
 <!--306**************--></C_CURRENCY>
@@ -4771,10 +4179,6 @@
 <!--307-->              <STDPRECISION><![CDATA[2]]></STDPRECISION>
 <!--307 COSTINGPRECISION-->
 <!--307-->              <COSTINGPRECISION><![CDATA[4]]></COSTINGPRECISION>
-<!--307 ISEURO-->
-<!--307-->              <ISEURO><![CDATA[N]]></ISEURO>
-<!--307 ISEMUMEMBER-->
-<!--307-->              <ISEMUMEMBER><![CDATA[N]]></ISEMUMEMBER>
 <!--307 PRICEPRECISION-->
 <!--307-->              <PRICEPRECISION><![CDATA[0]]></PRICEPRECISION>
 <!--307**************--></C_CURRENCY>
@@ -4806,10 +4210,6 @@
 <!--308-->              <STDPRECISION><![CDATA[2]]></STDPRECISION>
 <!--308 COSTINGPRECISION-->
 <!--308-->              <COSTINGPRECISION><![CDATA[4]]></COSTINGPRECISION>
-<!--308 ISEURO-->
-<!--308-->              <ISEURO><![CDATA[N]]></ISEURO>
-<!--308 ISEMUMEMBER-->
-<!--308-->              <ISEMUMEMBER><![CDATA[N]]></ISEMUMEMBER>
 <!--308 PRICEPRECISION-->
 <!--308-->              <PRICEPRECISION><![CDATA[0]]></PRICEPRECISION>
 <!--308**************--></C_CURRENCY>
@@ -4841,10 +4241,6 @@
 <!--309-->              <STDPRECISION><![CDATA[2]]></STDPRECISION>
 <!--309 COSTINGPRECISION-->
 <!--309-->              <COSTINGPRECISION><![CDATA[4]]></COSTINGPRECISION>
-<!--309 ISEURO-->
-<!--309-->              <ISEURO><![CDATA[N]]></ISEURO>
-<!--309 ISEMUMEMBER-->
-<!--309-->              <ISEMUMEMBER><![CDATA[N]]></ISEMUMEMBER>
 <!--309 PRICEPRECISION-->
 <!--309-->              <PRICEPRECISION><![CDATA[0]]></PRICEPRECISION>
 <!--309**************--></C_CURRENCY>
@@ -4876,10 +4272,6 @@
 <!--310-->              <STDPRECISION><![CDATA[2]]></STDPRECISION>
 <!--310 COSTINGPRECISION-->
 <!--310-->              <COSTINGPRECISION><![CDATA[4]]></COSTINGPRECISION>
-<!--310 ISEURO-->
-<!--310-->              <ISEURO><![CDATA[N]]></ISEURO>
-<!--310 ISEMUMEMBER-->
-<!--310-->              <ISEMUMEMBER><![CDATA[N]]></ISEMUMEMBER>
 <!--310 PRICEPRECISION-->
 <!--310-->              <PRICEPRECISION><![CDATA[0]]></PRICEPRECISION>
 <!--310**************--></C_CURRENCY>
@@ -4911,10 +4303,6 @@
 <!--311-->              <STDPRECISION><![CDATA[2]]></STDPRECISION>
 <!--311 COSTINGPRECISION-->
 <!--311-->              <COSTINGPRECISION><![CDATA[4]]></COSTINGPRECISION>
-<!--311 ISEURO-->
-<!--311-->              <ISEURO><![CDATA[N]]></ISEURO>
-<!--311 ISEMUMEMBER-->
-<!--311-->              <ISEMUMEMBER><![CDATA[N]]></ISEMUMEMBER>
 <!--311 PRICEPRECISION-->
 <!--311-->              <PRICEPRECISION><![CDATA[0]]></PRICEPRECISION>
 <!--311**************--></C_CURRENCY>
@@ -4946,10 +4334,6 @@
 <!--312-->              <STDPRECISION><![CDATA[2]]></STDPRECISION>
 <!--312 COSTINGPRECISION-->
 <!--312-->              <COSTINGPRECISION><![CDATA[4]]></COSTINGPRECISION>
-<!--312 ISEURO-->
-<!--312-->              <ISEURO><![CDATA[N]]></ISEURO>
-<!--312 ISEMUMEMBER-->
-<!--312-->              <ISEMUMEMBER><![CDATA[N]]></ISEMUMEMBER>
 <!--312 PRICEPRECISION-->
 <!--312-->              <PRICEPRECISION><![CDATA[0]]></PRICEPRECISION>
 <!--312**************--></C_CURRENCY>
@@ -4981,10 +4365,6 @@
 <!--313-->              <STDPRECISION><![CDATA[2]]></STDPRECISION>
 <!--313 COSTINGPRECISION-->
 <!--313-->              <COSTINGPRECISION><![CDATA[4]]></COSTINGPRECISION>
-<!--313 ISEURO-->
-<!--313-->              <ISEURO><![CDATA[N]]></ISEURO>
-<!--313 ISEMUMEMBER-->
-<!--313-->              <ISEMUMEMBER><![CDATA[N]]></ISEMUMEMBER>
 <!--313 PRICEPRECISION-->
 <!--313-->              <PRICEPRECISION><![CDATA[0]]></PRICEPRECISION>
 <!--313**************--></C_CURRENCY>
@@ -5016,10 +4396,6 @@
 <!--315-->              <STDPRECISION><![CDATA[2]]></STDPRECISION>
 <!--315 COSTINGPRECISION-->
 <!--315-->              <COSTINGPRECISION><![CDATA[4]]></COSTINGPRECISION>
-<!--315 ISEURO-->
-<!--315-->              <ISEURO><![CDATA[N]]></ISEURO>
-<!--315 ISEMUMEMBER-->
-<!--315-->              <ISEMUMEMBER><![CDATA[N]]></ISEMUMEMBER>
 <!--315 PRICEPRECISION-->
 <!--315-->              <PRICEPRECISION><![CDATA[0]]></PRICEPRECISION>
 <!--315**************--></C_CURRENCY>
@@ -5051,10 +4427,6 @@
 <!--316-->              <STDPRECISION><![CDATA[2]]></STDPRECISION>
 <!--316 COSTINGPRECISION-->
 <!--316-->              <COSTINGPRECISION><![CDATA[4]]></COSTINGPRECISION>
-<!--316 ISEURO-->
-<!--316-->              <ISEURO><![CDATA[N]]></ISEURO>
-<!--316 ISEMUMEMBER-->
-<!--316-->              <ISEMUMEMBER><![CDATA[N]]></ISEMUMEMBER>
 <!--316 PRICEPRECISION-->
 <!--316-->              <PRICEPRECISION><![CDATA[0]]></PRICEPRECISION>
 <!--316**************--></C_CURRENCY>
@@ -5086,10 +4458,6 @@
 <!--317-->              <STDPRECISION><![CDATA[2]]></STDPRECISION>
 <!--317 COSTINGPRECISION-->
 <!--317-->              <COSTINGPRECISION><![CDATA[4]]></COSTINGPRECISION>
-<!--317 ISEURO-->
-<!--317-->              <ISEURO><![CDATA[N]]></ISEURO>
-<!--317 ISEMUMEMBER-->
-<!--317-->              <ISEMUMEMBER><![CDATA[N]]></ISEMUMEMBER>
 <!--317 PRICEPRECISION-->
 <!--317-->              <PRICEPRECISION><![CDATA[0]]></PRICEPRECISION>
 <!--317**************--></C_CURRENCY>
@@ -5121,10 +4489,6 @@
 <!--318-->              <STDPRECISION><![CDATA[2]]></STDPRECISION>
 <!--318 COSTINGPRECISION-->
 <!--318-->              <COSTINGPRECISION><![CDATA[4]]></COSTINGPRECISION>
-<!--318 ISEURO-->
-<!--318-->              <ISEURO><![CDATA[N]]></ISEURO>
-<!--318 ISEMUMEMBER-->
-<!--318-->              <ISEMUMEMBER><![CDATA[N]]></ISEMUMEMBER>
 <!--318 PRICEPRECISION-->
 <!--318-->              <PRICEPRECISION><![CDATA[0]]></PRICEPRECISION>
 <!--318**************--></C_CURRENCY>
@@ -5156,10 +4520,6 @@
 <!--320-->              <STDPRECISION><![CDATA[2]]></STDPRECISION>
 <!--320 COSTINGPRECISION-->
 <!--320-->              <COSTINGPRECISION><![CDATA[4]]></COSTINGPRECISION>
-<!--320 ISEURO-->
-<!--320-->              <ISEURO><![CDATA[N]]></ISEURO>
-<!--320 ISEMUMEMBER-->
-<!--320-->              <ISEMUMEMBER><![CDATA[N]]></ISEMUMEMBER>
 <!--320 PRICEPRECISION-->
 <!--320-->              <PRICEPRECISION><![CDATA[0]]></PRICEPRECISION>
 <!--320**************--></C_CURRENCY>
@@ -5191,10 +4551,6 @@
 <!--321-->              <STDPRECISION><![CDATA[3]]></STDPRECISION>
 <!--321 COSTINGPRECISION-->
 <!--321-->              <COSTINGPRECISION><![CDATA[5]]></COSTINGPRECISION>
-<!--321 ISEURO-->
-<!--321-->              <ISEURO><![CDATA[N]]></ISEURO>
-<!--321 ISEMUMEMBER-->
-<!--321-->              <ISEMUMEMBER><![CDATA[N]]></ISEMUMEMBER>
 <!--321 PRICEPRECISION-->
 <!--321-->              <PRICEPRECISION><![CDATA[0]]></PRICEPRECISION>
 <!--321**************--></C_CURRENCY>
@@ -5226,10 +4582,6 @@
 <!--322-->              <STDPRECISION><![CDATA[2]]></STDPRECISION>
 <!--322 COSTINGPRECISION-->
 <!--322-->              <COSTINGPRECISION><![CDATA[4]]></COSTINGPRECISION>
-<!--322 ISEURO-->
-<!--322-->              <ISEURO><![CDATA[N]]></ISEURO>
-<!--322 ISEMUMEMBER-->
-<!--322-->              <ISEMUMEMBER><![CDATA[N]]></ISEMUMEMBER>
 <!--322 PRICEPRECISION-->
 <!--322-->              <PRICEPRECISION><![CDATA[0]]></PRICEPRECISION>
 <!--322**************--></C_CURRENCY>
@@ -5261,10 +4613,6 @@
 <!--323-->              <STDPRECISION><![CDATA[0]]></STDPRECISION>
 <!--323 COSTINGPRECISION-->
 <!--323-->              <COSTINGPRECISION><![CDATA[2]]></COSTINGPRECISION>
-<!--323 ISEURO-->
-<!--323-->              <ISEURO><![CDATA[N]]></ISEURO>
-<!--323 ISEMUMEMBER-->
-<!--323-->              <ISEMUMEMBER><![CDATA[N]]></ISEMUMEMBER>
 <!--323 PRICEPRECISION-->
 <!--323-->              <PRICEPRECISION><![CDATA[0]]></PRICEPRECISION>
 <!--323**************--></C_CURRENCY>
@@ -5296,10 +4644,6 @@
 <!--324-->              <STDPRECISION><![CDATA[2]]></STDPRECISION>
 <!--324 COSTINGPRECISION-->
 <!--324-->              <COSTINGPRECISION><![CDATA[4]]></COSTINGPRECISION>
-<!--324 ISEURO-->
-<!--324-->              <ISEURO><![CDATA[N]]></ISEURO>
-<!--324 ISEMUMEMBER-->
-<!--324-->              <ISEMUMEMBER><![CDATA[N]]></ISEMUMEMBER>
 <!--324 PRICEPRECISION-->
 <!--324-->              <PRICEPRECISION><![CDATA[0]]></PRICEPRECISION>
 <!--324**************--></C_CURRENCY>
@@ -5331,10 +4675,6 @@
 <!--325-->              <STDPRECISION><![CDATA[2]]></STDPRECISION>
 <!--325 COSTINGPRECISION-->
 <!--325-->              <COSTINGPRECISION><![CDATA[4]]></COSTINGPRECISION>
-<!--325 ISEURO-->
-<!--325-->              <ISEURO><![CDATA[N]]></ISEURO>
-<!--325 ISEMUMEMBER-->
-<!--325-->              <ISEMUMEMBER><![CDATA[N]]></ISEMUMEMBER>
 <!--325 PRICEPRECISION-->
 <!--325-->              <PRICEPRECISION><![CDATA[0]]></PRICEPRECISION>
 <!--325**************--></C_CURRENCY>
@@ -5366,10 +4706,6 @@
 <!--326-->              <STDPRECISION><![CDATA[2]]></STDPRECISION>
 <!--326 COSTINGPRECISION-->
 <!--326-->              <COSTINGPRECISION><![CDATA[4]]></COSTINGPRECISION>
-<!--326 ISEURO-->
-<!--326-->              <ISEURO><![CDATA[N]]></ISEURO>
-<!--326 ISEMUMEMBER-->
-<!--326-->              <ISEMUMEMBER><![CDATA[N]]></ISEMUMEMBER>
 <!--326 PRICEPRECISION-->
 <!--326-->              <PRICEPRECISION><![CDATA[0]]></PRICEPRECISION>
 <!--326**************--></C_CURRENCY>
@@ -5401,10 +4737,6 @@
 <!--327-->              <STDPRECISION><![CDATA[2]]></STDPRECISION>
 <!--327 COSTINGPRECISION-->
 <!--327-->              <COSTINGPRECISION><![CDATA[4]]></COSTINGPRECISION>
-<!--327 ISEURO-->
-<!--327-->              <ISEURO><![CDATA[N]]></ISEURO>
-<!--327 ISEMUMEMBER-->
-<!--327-->              <ISEMUMEMBER><![CDATA[N]]></ISEMUMEMBER>
 <!--327 PRICEPRECISION-->
 <!--327-->              <PRICEPRECISION><![CDATA[0]]></PRICEPRECISION>
 <!--327**************--></C_CURRENCY>
@@ -5436,10 +4768,6 @@
 <!--328-->              <STDPRECISION><![CDATA[2]]></STDPRECISION>
 <!--328 COSTINGPRECISION-->
 <!--328-->              <COSTINGPRECISION><![CDATA[4]]></COSTINGPRECISION>
-<!--328 ISEURO-->
-<!--328-->              <ISEURO><![CDATA[N]]></ISEURO>
-<!--328 ISEMUMEMBER-->
-<!--328-->              <ISEMUMEMBER><![CDATA[N]]></ISEMUMEMBER>
 <!--328 PRICEPRECISION-->
 <!--328-->              <PRICEPRECISION><![CDATA[0]]></PRICEPRECISION>
 <!--328**************--></C_CURRENCY>
@@ -5471,10 +4799,6 @@
 <!--329-->              <STDPRECISION><![CDATA[0]]></STDPRECISION>
 <!--329 COSTINGPRECISION-->
 <!--329-->              <COSTINGPRECISION><![CDATA[2]]></COSTINGPRECISION>
-<!--329 ISEURO-->
-<!--329-->              <ISEURO><![CDATA[N]]></ISEURO>
-<!--329 ISEMUMEMBER-->
-<!--329-->              <ISEMUMEMBER><![CDATA[N]]></ISEMUMEMBER>
 <!--329 PRICEPRECISION-->
 <!--329-->              <PRICEPRECISION><![CDATA[0]]></PRICEPRECISION>
 <!--329**************--></C_CURRENCY>
@@ -5506,10 +4830,6 @@
 <!--330-->              <STDPRECISION><![CDATA[0]]></STDPRECISION>
 <!--330 COSTINGPRECISION-->
 <!--330-->              <COSTINGPRECISION><![CDATA[2]]></COSTINGPRECISION>
-<!--330 ISEURO-->
-<!--330-->              <ISEURO><![CDATA[N]]></ISEURO>
-<!--330 ISEMUMEMBER-->
-<!--330-->              <ISEMUMEMBER><![CDATA[N]]></ISEMUMEMBER>
 <!--330 PRICEPRECISION-->
 <!--330-->              <PRICEPRECISION><![CDATA[0]]></PRICEPRECISION>
 <!--330**************--></C_CURRENCY>
@@ -5541,10 +4861,6 @@
 <!--331-->              <STDPRECISION><![CDATA[2]]></STDPRECISION>
 <!--331 COSTINGPRECISION-->
 <!--331-->              <COSTINGPRECISION><![CDATA[4]]></COSTINGPRECISION>
-<!--331 ISEURO-->
-<!--331-->              <ISEURO><![CDATA[N]]></ISEURO>
-<!--331 ISEMUMEMBER-->
-<!--331-->              <ISEMUMEMBER><![CDATA[N]]></ISEMUMEMBER>
 <!--331 PRICEPRECISION-->
 <!--331-->              <PRICEPRECISION><![CDATA[0]]></PRICEPRECISION>
 <!--331**************--></C_CURRENCY>
@@ -5576,10 +4892,6 @@
 <!--332-->              <STDPRECISION><![CDATA[2]]></STDPRECISION>
 <!--332 COSTINGPRECISION-->
 <!--332-->              <COSTINGPRECISION><![CDATA[4]]></COSTINGPRECISION>
-<!--332 ISEURO-->
-<!--332-->              <ISEURO><![CDATA[N]]></ISEURO>
-<!--332 ISEMUMEMBER-->
-<!--332-->              <ISEMUMEMBER><![CDATA[N]]></ISEMUMEMBER>
 <!--332 PRICEPRECISION-->
 <!--332-->              <PRICEPRECISION><![CDATA[0]]></PRICEPRECISION>
 <!--332**************--></C_CURRENCY>
@@ -5611,10 +4923,6 @@
 <!--333-->              <STDPRECISION><![CDATA[2]]></STDPRECISION>
 <!--333 COSTINGPRECISION-->
 <!--333-->              <COSTINGPRECISION><![CDATA[4]]></COSTINGPRECISION>
-<!--333 ISEURO-->
-<!--333-->              <ISEURO><![CDATA[N]]></ISEURO>
-<!--333 ISEMUMEMBER-->
-<!--333-->              <ISEMUMEMBER><![CDATA[N]]></ISEMUMEMBER>
 <!--333 PRICEPRECISION-->
 <!--333-->              <PRICEPRECISION><![CDATA[0]]></PRICEPRECISION>
 <!--333**************--></C_CURRENCY>
@@ -5646,10 +4954,6 @@
 <!--334-->              <STDPRECISION><![CDATA[2]]></STDPRECISION>
 <!--334 COSTINGPRECISION-->
 <!--334-->              <COSTINGPRECISION><![CDATA[4]]></COSTINGPRECISION>
-<!--334 ISEURO-->
-<!--334-->              <ISEURO><![CDATA[N]]></ISEURO>
-<!--334 ISEMUMEMBER-->
-<!--334-->              <ISEMUMEMBER><![CDATA[N]]></ISEMUMEMBER>
 <!--334 PRICEPRECISION-->
 <!--334-->              <PRICEPRECISION><![CDATA[0]]></PRICEPRECISION>
 <!--334**************--></C_CURRENCY>
@@ -5681,10 +4985,6 @@
 <!--335-->              <STDPRECISION><![CDATA[2]]></STDPRECISION>
 <!--335 COSTINGPRECISION-->
 <!--335-->              <COSTINGPRECISION><![CDATA[4]]></COSTINGPRECISION>
-<!--335 ISEURO-->
-<!--335-->              <ISEURO><![CDATA[N]]></ISEURO>
-<!--335 ISEMUMEMBER-->
-<!--335-->              <ISEMUMEMBER><![CDATA[N]]></ISEMUMEMBER>
 <!--335 PRICEPRECISION-->
 <!--335-->              <PRICEPRECISION><![CDATA[0]]></PRICEPRECISION>
 <!--335**************--></C_CURRENCY>
@@ -5714,10 +5014,6 @@
 <!--336-->              <STDPRECISION><![CDATA[2]]></STDPRECISION>
 <!--336 COSTINGPRECISION-->
 <!--336-->              <COSTINGPRECISION><![CDATA[4]]></COSTINGPRECISION>
-<!--336 ISEURO-->
-<!--336-->              <ISEURO><![CDATA[N]]></ISEURO>
-<!--336 ISEMUMEMBER-->
-<!--336-->              <ISEMUMEMBER><![CDATA[N]]></ISEMUMEMBER>
 <!--336 PRICEPRECISION-->
 <!--336-->              <PRICEPRECISION><![CDATA[0]]></PRICEPRECISION>
 <!--336**************--></C_CURRENCY>
@@ -5747,10 +5043,6 @@
 <!--337-->              <STDPRECISION><![CDATA[0]]></STDPRECISION>
 <!--337 COSTINGPRECISION-->
 <!--337-->              <COSTINGPRECISION><![CDATA[2]]></COSTINGPRECISION>
-<!--337 ISEURO-->
-<!--337-->              <ISEURO><![CDATA[N]]></ISEURO>
-<!--337 ISEMUMEMBER-->
-<!--337-->              <ISEMUMEMBER><![CDATA[N]]></ISEMUMEMBER>
 <!--337 PRICEPRECISION-->
 <!--337-->              <PRICEPRECISION><![CDATA[0]]></PRICEPRECISION>
 <!--337**************--></C_CURRENCY>
@@ -5780,10 +5072,6 @@
 <!--338-->              <STDPRECISION><![CDATA[2]]></STDPRECISION>
 <!--338 COSTINGPRECISION-->
 <!--338-->              <COSTINGPRECISION><![CDATA[4]]></COSTINGPRECISION>
-<!--338 ISEURO-->
-<!--338-->              <ISEURO><![CDATA[N]]></ISEURO>
-<!--338 ISEMUMEMBER-->
-<!--338-->              <ISEMUMEMBER><![CDATA[N]]></ISEMUMEMBER>
 <!--338 PRICEPRECISION-->
 <!--338-->              <PRICEPRECISION><![CDATA[0]]></PRICEPRECISION>
 <!--338**************--></C_CURRENCY>
@@ -5813,10 +5101,6 @@
 <!--339-->              <STDPRECISION><![CDATA[2]]></STDPRECISION>
 <!--339 COSTINGPRECISION-->
 <!--339-->              <COSTINGPRECISION><![CDATA[4]]></COSTINGPRECISION>
-<!--339 ISEURO-->
-<!--339-->              <ISEURO><![CDATA[N]]></ISEURO>
-<!--339 ISEMUMEMBER-->
-<!--339-->              <ISEMUMEMBER><![CDATA[N]]></ISEMUMEMBER>
 <!--339 PRICEPRECISION-->
 <!--339-->              <PRICEPRECISION><![CDATA[0]]></PRICEPRECISION>
 <!--339**************--></C_CURRENCY>
@@ -5846,10 +5130,6 @@
 <!--340-->              <STDPRECISION><![CDATA[2]]></STDPRECISION>
 <!--340 COSTINGPRECISION-->
 <!--340-->              <COSTINGPRECISION><![CDATA[4]]></COSTINGPRECISION>
-<!--340 ISEURO-->
-<!--340-->              <ISEURO><![CDATA[N]]></ISEURO>
-<!--340 ISEMUMEMBER-->
-<!--340-->              <ISEMUMEMBER><![CDATA[N]]></ISEMUMEMBER>
 <!--340 PRICEPRECISION-->
 <!--340-->              <PRICEPRECISION><![CDATA[0]]></PRICEPRECISION>
 <!--340**************--></C_CURRENCY>
@@ -5879,10 +5159,6 @@
 <!--341-->              <STDPRECISION><![CDATA[2]]></STDPRECISION>
 <!--341 COSTINGPRECISION-->
 <!--341-->              <COSTINGPRECISION><![CDATA[4]]></COSTINGPRECISION>
-<!--341 ISEURO-->
-<!--341-->              <ISEURO><![CDATA[N]]></ISEURO>
-<!--341 ISEMUMEMBER-->
-<!--341-->              <ISEMUMEMBER><![CDATA[N]]></ISEMUMEMBER>
 <!--341 PRICEPRECISION-->
 <!--341-->              <PRICEPRECISION><![CDATA[0]]></PRICEPRECISION>
 <!--341**************--></C_CURRENCY>
@@ -5912,10 +5188,6 @@
 <!--342-->              <STDPRECISION><![CDATA[2]]></STDPRECISION>
 <!--342 COSTINGPRECISION-->
 <!--342-->              <COSTINGPRECISION><![CDATA[4]]></COSTINGPRECISION>
-<!--342 ISEURO-->
-<!--342-->              <ISEURO><![CDATA[N]]></ISEURO>
-<!--342 ISEMUMEMBER-->
-<!--342-->              <ISEMUMEMBER><![CDATA[N]]></ISEMUMEMBER>
 <!--342 PRICEPRECISION-->
 <!--342-->              <PRICEPRECISION><![CDATA[0]]></PRICEPRECISION>
 <!--342**************--></C_CURRENCY>
@@ -5945,10 +5217,6 @@
 <!--343-->              <STDPRECISION><![CDATA[2]]></STDPRECISION>
 <!--343 COSTINGPRECISION-->
 <!--343-->              <COSTINGPRECISION><![CDATA[4]]></COSTINGPRECISION>
-<!--343 ISEURO-->
-<!--343-->              <ISEURO><![CDATA[N]]></ISEURO>
-<!--343 ISEMUMEMBER-->
-<!--343-->              <ISEMUMEMBER><![CDATA[N]]></ISEMUMEMBER>
 <!--343 PRICEPRECISION-->
 <!--343-->              <PRICEPRECISION><![CDATA[0]]></PRICEPRECISION>
 <!--343**************--></C_CURRENCY>
@@ -5978,10 +5246,6 @@
 <!--344-->              <STDPRECISION><![CDATA[0]]></STDPRECISION>
 <!--344 COSTINGPRECISION-->
 <!--344-->              <COSTINGPRECISION><![CDATA[2]]></COSTINGPRECISION>
-<!--344 ISEURO-->
-<!--344-->              <ISEURO><![CDATA[N]]></ISEURO>
-<!--344 ISEMUMEMBER-->
-<!--344-->              <ISEMUMEMBER><![CDATA[N]]></ISEMUMEMBER>
 <!--344 PRICEPRECISION-->
 <!--344-->              <PRICEPRECISION><![CDATA[0]]></PRICEPRECISION>
 <!--344**************--></C_CURRENCY>
@@ -6011,12 +5275,6 @@
 <!--345-->              <STDPRECISION><![CDATA[2]]></STDPRECISION>
 <!--345 COSTINGPRECISION-->
 <!--345-->              <COSTINGPRECISION><![CDATA[4]]></COSTINGPRECISION>
-<!--345 ISEURO-->
-<!--345-->              <ISEURO><![CDATA[N]]></ISEURO>
-<!--345 ISEMUMEMBER-->
-<!--345-->              <ISEMUMEMBER><![CDATA[N]]></ISEMUMEMBER>
-<!--345 EMURATE-->
-<!--345-->              <EMURATE><![CDATA[0]]></EMURATE>
 <!--345 PRICEPRECISION-->
 <!--345-->              <PRICEPRECISION><![CDATA[0]]></PRICEPRECISION>
 <!--345**************--></C_CURRENCY>
--- a/src-db/database/masterdata/C_DOCTYPE.xml	Wed Apr 30 10:48:47 2008 +0000
+++ b/src-db/database/masterdata/C_DOCTYPE.xml	Mon May 05 06:59:24 2008 +0000
@@ -30,36 +30,16 @@
 <!--0-->              <DOCBASETYPE><![CDATA[   ]]></DOCBASETYPE>
 <!--0 ISSOTRX-->
 <!--0-->              <ISSOTRX><![CDATA[Y]]></ISSOTRX>
-<!--0 HASPROFORMA-->
-<!--0-->              <HASPROFORMA><![CDATA[N]]></HASPROFORMA>
-<!--0 CREATEPICKLIST-->
-<!--0-->              <CREATEPICKLIST><![CDATA[N]]></CREATEPICKLIST>
-<!--0 ISAPPROVED-->
-<!--0-->              <ISAPPROVED><![CDATA[N]]></ISAPPROVED>
 <!--0 ISDOCNOCONTROLLED-->
 <!--0-->              <ISDOCNOCONTROLLED><![CDATA[N]]></ISDOCNOCONTROLLED>
-<!--0 ISBATCHED-->
-<!--0-->              <ISBATCHED><![CDATA[N]]></ISBATCHED>
-<!--0 ISBATCHCONTROLENFORCED-->
-<!--0-->              <ISBATCHCONTROLENFORCED><![CDATA[N]]></ISBATCHCONTROLENFORCED>
-<!--0 ISBATCHDOCNOCONTROLLED-->
-<!--0-->              <ISBATCHDOCNOCONTROLLED><![CDATA[N]]></ISBATCHDOCNOCONTROLLED>
 <!--0 GL_CATEGORY_ID-->
 <!--0-->              <GL_CATEGORY_ID><![CDATA[0]]></GL_CATEGORY_ID>
-<!--0 ISPRINTED-->
-<!--0-->              <ISPRINTED><![CDATA[Y]]></ISPRINTED>
-<!--0 ISTRANSFERRED-->
-<!--0-->              <ISTRANSFERRED><![CDATA[Y]]></ISTRANSFERRED>
-<!--0 HASCHARGES-->
-<!--0-->              <HASCHARGES><![CDATA[N]]></HASCHARGES>
 <!--0 DOCUMENTNOTE-->
 <!--0-->              <DOCUMENTNOTE><![CDATA[** NO INVOICE **]]></DOCUMENTNOTE>
 <!--0 ISDEFAULT-->
 <!--0-->              <ISDEFAULT><![CDATA[N]]></ISDEFAULT>
 <!--0 DOCUMENTCOPIES-->
 <!--0-->              <DOCUMENTCOPIES><![CDATA[1]]></DOCUMENTCOPIES>
-<!--0 ISMAXTABLE-->
-<!--0-->              <ISMAXTABLE><![CDATA[N]]></ISMAXTABLE>
 <!--0 ORGFILTERED-->
 <!--0-->              <ORGFILTERED><![CDATA[N]]></ORGFILTERED>
 <!--0**************--></C_DOCTYPE>
--- a/src-db/database/model/functions/AD_APPLICATION_IMPORT.xml	Wed Apr 30 10:48:47 2008 +0000
+++ /dev/null	Thu Jan 01 00:00:00 1970 +0000
@@ -1,581 +0,0 @@
-<?xml version="1.0"?>
-  <database name="FUNCTION AD_APPLICATION_IMPORT">
-    <function name="AD_APPLICATION_IMPORT" type="NULL">
-      <parameter name="p_tableidfrom" type="NUMERIC" mode="in">
-        <default/>
-      </parameter>
-      <parameter name="p_tableidto" type="NUMERIC" mode="in">
-        <default/>
-      </parameter>
-      <parameter name="p_windowidfrom" type="NUMERIC" mode="in">
-        <default/>
-      </parameter>
-      <parameter name="p_windowidto" type="NUMERIC" mode="in">
-        <default/>
-      </parameter>
-      <parameter name="p_referenceidfrom" type="NUMERIC" mode="in">
-        <default/>
-      </parameter>
-      <parameter name="p_referenceidto" type="NUMERIC" mode="in">
-        <default/>
-      </parameter>
-      <parameter name="p_valruleidfrom" type="NUMERIC" mode="in">
-        <default/>
-      </parameter>
-      <parameter name="p_valruleidto" type="NUMERIC" mode="in">
-        <default/>
-      </parameter>
-      <parameter name="p_elementidfrom" type="NUMERIC" mode="in">
-        <default/>
-      </parameter>
-      <parameter name="p_elementidto" type="NUMERIC" mode="in">
-        <default/>
-      </parameter>
-      <parameter name="p_menuidfrom" type="NUMERIC" mode="in">
-        <default/>
-      </parameter>
-      <parameter name="p_menuidto" type="NUMERIC" mode="in">
-        <default/>
-      </parameter>
-      <parameter name="p_sequenceidfrom" type="NUMERIC" mode="in">
-        <default/>
-      </parameter>
-      <parameter name="p_sequenceidto" type="NUMERIC" mode="in">
-        <default/>
-      </parameter>
-      <parameter name="p_baseinstalation" type="CHAR" mode="in">
-        <default/>
-      </parameter>
-      <body><![CDATA[/*************************************************************************
-* The contents of this file are subject to the Openbravo  Public  License
-* Version  1.0  (the  "License"),  being   the  Mozilla   Public  License
-* Version 1.1  with a permitted attribution clause; you may not  use this
-* file except in compliance with the License. You  may  obtain  a copy of
-* the License at http://www.openbravo.com/legal/license.html
-* Software distributed under the License  is  distributed  on  an "AS IS"
-* basis, WITHOUT WARRANTY OF ANY KIND, either express or implied. See the
-* License for the specific  language  governing  rights  and  limitations
-* under the License.
-* The Original Code is Openbravo ERP.
-* The Initial Developer of the Original Code is Openbravo SL
-* All portions are Copyright (C) 2001-2006 Openbravo SL
-* All Rights Reserved.
-* Contributor(s):  ______________________________________.
-************************************************************************/
- v_minId     NUMBER(10);
--- v_maxId     NUMBER(10);
- v_tableOffset   NUMBER(10);
- v_windowOffset   NUMBER(10);
- v_columnOffset   NUMBER(10);
- v_tabOffset    NUMBER(10);
- v_auxiliarinputOffset NUMBER(10);
- v_fieldOffset   NUMBER(10);
- v_fieldgroupOffset  NUMBER(10);
- v_referenceOffset  NUMBER(10);
- v_reftableOffset  NUMBER(10); --NOT needed because it lacks of an ID
- v_reflistOffset   NUMBER(10);
- v_valruleOffset   NUMBER(10);
- v_elementOffset   NUMBER(10);
- v_formOffset   NUMBER(10);
- v_messageOffset   NUMBER(10);
- v_menuOffset   NUMBER(10);
- v_reportviewOffset  NUMBER(10);
- v_processOffset   NUMBER(10);
- v_processparaOffset  NUMBER(10);
- v_sequenceOffset  NUMBER(10);
- v_taskOffset   NUMBER(10);
- v_treeOffset   NUMBER(10);
- v_workflowOffset  NUMBER(10);
- v_wfnodeOffset   NUMBER(10);
- v_wfnodenextOffset  NUMBER(10);
- v_nextNo    NUMBER(10);
-BEGIN
---AD_Table
- --Next sequence number (blocking for update)
- SELECT CurrentNextSys INTO v_nextNo FROM AD_Sequence
- WHERE Name='AD_Table' AND IsActive='Y' AND IsTableID='Y' AND IsAutoSequence='Y'
- FOR UPDATE OF CurrentNextSys;
- --Mininum and maximum values of ID in TAX_AUX
- SELECT MIN(AD_TABLE_ID)--, MAX(AD_TABLE_ID)
- INTO v_minId--, v_maxId
- FROM TAD_AUX.AD_TABLE WHERE AD_TABLE_ID BETWEEN p_tableIdFrom AND p_tableIdTo;
- v_tableOffset:=v_nextNo - v_minId;
-/* UPDATE AD_SEQUENCE SET CurrentNextSys=CurrentNextSys + (v_maxId-v_minId) + INCREMENTNO
- WHERE  Name='AD_Table' AND IsActive='Y' AND IsTableID='Y' AND IsAutoSequence='Y'; */
-
-
---AD_Column
- SELECT CurrentNextSys INTO v_nextNo FROM AD_Sequence
- WHERE Name='AD_Column' AND IsActive='Y' AND IsTableID='Y' AND IsAutoSequence='Y'
- FOR UPDATE OF CurrentNextSys;
- SELECT MIN(AD_COLUMN_ID)--, MAX(AD_COLUMN_ID)
- INTO v_minId--, v_maxId
- FROM TAD_AUX.AD_COLUMN WHERE AD_TABLE_ID BETWEEN p_tableIdFrom AND p_tableIdTo;
- v_columnOffset:=v_nextNo - v_minId;
-/* UPDATE AD_SEQUENCE SET CurrentNextSys=CurrentNextSys + (v_maxId-v_minId) + INCREMENTNO
- WHERE  Name='AD_Column' AND IsActive='Y' AND IsTableID='Y' AND IsAutoSequence='Y'; */
-
-
---AD_Tab
- SELECT CurrentNextSys INTO v_nextNo FROM AD_Sequence
- WHERE Name='AD_Tab' AND IsActive='Y' AND IsTableID='Y' AND IsAutoSequence='Y'
- FOR UPDATE OF CurrentNextSys;
- SELECT MIN(AD_TAB_ID)--, MAX(AD_TAB_ID)
- INTO v_minId--, v_maxId
- FROM TAD_AUX.AD_TAB WHERE AD_TABLE_ID BETWEEN p_tableIdFrom AND p_tableIdTo;
- v_tabOffset:=v_nextNo - v_minId;
-/* UPDATE AD_SEQUENCE SET CurrentNextSys=CurrentNextSys + (v_maxId-v_minId) + INCREMENTNO
- WHERE  Name='AD_Tab' AND IsActive='Y' AND IsTableID='Y' AND IsAutoSequence='Y';*/
---AD_Window
- SELECT CurrentNextSys INTO v_nextNo FROM AD_Sequence
- WHERE Name='AD_Window' AND IsActive='Y' AND IsTableID='Y' AND IsAutoSequence='Y'
- FOR UPDATE OF CurrentNextSys;
- SELECT MIN(AD_WINDOW_ID)--, MAX(AD_WINDOW_ID)
- INTO v_minId--, v_maxId
- FROM TAD_AUX.AD_WINDOW WHERE AD_WINDOW_ID IN
-   (SELECT AD_WINDOW_ID FROM TAD_AUX.AD_TAB WHERE AD_TABLE_ID BETWEEN p_tableIdFrom AND p_tableIdTo)
- AND AD_WINDOW_ID BETWEEN p_windowIdFrom AND p_windowIdTo;
- v_windowOffset:=v_nextNo - v_minId;
-/* UPDATE AD_SEQUENCE SET CurrentNextSys=CurrentNextSys + (v_maxId-v_minId) + INCREMENTNO
- WHERE  Name='AD_Window' AND IsActive='Y' AND IsTableID='Y' AND IsAutoSequence='Y';*/
---AD_Field
- SELECT CurrentNextSys INTO v_nextNo FROM AD_Sequence
- WHERE Name='AD_Field' AND IsActive='Y' AND IsTableID='Y' AND IsAutoSequence='Y'
- FOR UPDATE OF CurrentNextSys;
- SELECT MIN(AD_FIELD_ID)--, MAX(AD_FIELD_ID)
- INTO v_minId--, v_maxId
- FROM TAD_AUX.AD_FIELD WHERE AD_TAB_ID IN
-   (SELECT AD_TAB_ID FROM TAD_AUX.AD_TAB WHERE AD_TABLE_ID BETWEEN p_tableIdFrom AND p_tableIdTo);
- v_fieldOffset:=v_nextNo - v_minId;
-/* UPDATE AD_SEQUENCE SET CurrentNextSys=CurrentNextSys + (v_maxId-v_minId) + INCREMENTNO
- WHERE  Name='AD_Field' AND IsActive='Y' AND IsTableID='Y' AND IsAutoSequence='Y';*/
---AD_FieldGroup
- SELECT CurrentNextSys INTO v_nextNo FROM AD_Sequence
- WHERE Name='AD_FieldGroup' AND IsActive='Y' AND IsTableID='Y' AND IsAutoSequence='Y'
- FOR UPDATE OF CurrentNextSys;
- SELECT MIN(AD_FIELDGROUP_ID)--, MAX(AD_FIELDGROUP_ID)
- INTO v_minId--, v_maxId
- FROM TAD_AUX.AD_FIELDGROUP WHERE AD_FIELDGROUP_ID IN
-   (SELECT AD_FIELDGROUP_ID FROM TAD_AUX.AD_FIELD WHERE AD_TAB_ID IN
-      (SELECT AD_TAB_ID FROM TAD_AUX.AD_TAB WHERE AD_TABLE_ID BETWEEN p_tableIdFrom AND p_tableIdTo));
- v_fieldgroupOffset:=v_nextNo - v_minId;
-/* UPDATE AD_SEQUENCE SET CurrentNextSys=CurrentNextSys + (v_maxId-v_minId) + INCREMENTNO
- WHERE  Name='AD_FieldGroup' AND IsActive='Y' AND IsTableID='Y' AND IsAutoSequence='Y';*/
---AD_Reference
- SELECT CurrentNextSys INTO v_nextNo FROM AD_Sequence
- WHERE Name='AD_Reference' AND IsActive='Y' AND IsTableID='Y' AND IsAutoSequence='Y'
- FOR UPDATE OF CurrentNextSys;
- SELECT MIN(AD_REFERENCE_ID)--, MAX(AD_REFERENCE_ID)
- INTO v_minId--, v_maxId
- FROM TAD_AUX.AD_REFERENCE WHERE AD_REFERENCE_ID BETWEEN p_referenceIdFrom AND p_referenceIdTo;
- v_referenceOffset:=v_nextNo - v_minId;
- /*UPDATE AD_SEQUENCE SET CurrentNextSys=CurrentNextSys + (v_maxId-v_minId) + INCREMENTNO
- WHERE  Name='AD_Reference' AND IsActive='Y' AND IsTableID='Y' AND IsAutoSequence='Y';*/
---AD_Ref_List
- SELECT CurrentNextSys INTO v_nextNo FROM AD_Sequence
- WHERE Name='AD_Ref_List' AND IsActive='Y' AND IsTableID='Y' AND IsAutoSequence='Y'
- FOR UPDATE OF CurrentNextSys;
- SELECT MIN(AD_REF_LIST_ID)--, MAX(AD_REF_LIST_ID)
- INTO v_minId--, v_maxId
- FROM TAD_AUX.AD_REF_LIST WHERE AD_REFERENCE_ID BETWEEN p_referenceIdFrom AND p_referenceIdTo;
- v_reflistOffset:=v_nextNo - v_minId;
- /*UPDATE AD_SEQUENCE SET CurrentNextSys=CurrentNextSys + (v_maxId-v_minId) + INCREMENTNO
- WHERE  Name='AD_Ref_List' AND IsActive='Y' AND IsTableID='Y' AND IsAutoSequence='Y';*/
---AD_Val_Rule
- SELECT CurrentNextSys INTO v_nextNo FROM AD_Sequence
- WHERE Name='AD_Val_Rule' AND IsActive='Y' AND IsTableID='Y' AND IsAutoSequence='Y'
- FOR UPDATE OF CurrentNextSys;
- SELECT MIN(AD_VAL_RULE_ID)--, MAX(AD_VAL_RULE_ID)
- INTO v_minId--, v_maxId
- FROM TAD_AUX.AD_VAL_RULE WHERE AD_VAL_RULE_ID BETWEEN p_valruleIdFrom AND p_valruleIdTo;
- v_valruleOffset:=v_nextNo - v_minId;
- /*UPDATE AD_SEQUENCE SET CurrentNextSys=CurrentNextSys + (v_maxId-v_minId) + INCREMENTNO
- WHERE  Name='AD_Val_Rule' AND IsActive='Y' AND IsTableID='Y' AND IsAutoSequence='Y';*/
---AD_Element
- SELECT CurrentNextSys INTO v_nextNo FROM AD_Sequence
- WHERE Name='AD_Element' AND IsActive='Y' AND IsTableID='Y' AND IsAutoSequence='Y'
- FOR UPDATE OF CurrentNextSys;
- SELECT MIN(AD_ELEMENT_ID)--, MAX(AD_ELEMENT_ID)
- INTO v_minId--, v_maxId
- FROM TAD_AUX.AD_ELEMENT WHERE AD_ELEMENT_ID BETWEEN p_elementIdFrom AND p_elementIdTo;
- v_elementOffset:=v_nextNo - v_minId;
- /*UPDATE AD_SEQUENCE SET CurrentNextSys=CurrentNextSys + (v_maxId-v_minId) + INCREMENTNO
- WHERE  Name='AD_Element' AND IsActive='Y' AND IsTableID='Y' AND IsAutoSequence='Y';*/
---AD_Menu
- SELECT CurrentNextSys INTO v_nextNo FROM AD_Sequence
- WHERE Name='AD_Menu' AND IsActive='Y' AND IsTableID='Y' AND IsAutoSequence='Y'
- FOR UPDATE OF CurrentNextSys;
- SELECT MIN(AD_MENU_ID)--, MAX(AD_MENU_ID)
- INTO v_minId--, v_maxId
- FROM TAD_AUX.AD_MENU WHERE AD_MENU_ID BETWEEN p_menuIdFrom AND p_menuIdTo;
- v_menuOffset:=v_nextNo - v_minId;
- /*UPDATE AD_SEQUENCE SET CurrentNextSys=CurrentNextSys + (v_maxId-v_minId) + INCREMENTNO
- WHERE  Name='AD_Menu' AND IsActive='Y' AND IsTableID='Y' AND IsAutoSequence='Y';*/
---AD_Sequence
- SELECT CurrentNextSys INTO v_nextNo FROM AD_Sequence
- WHERE Name='AD_Sequence' AND IsActive='Y' AND IsTableID='Y' AND IsAutoSequence='Y'
- FOR UPDATE OF CurrentNextSys;
- SELECT MIN(AD_SEQUENCE_ID)--, MAX(AD_SEQUENCE_ID)
- INTO v_minId--, v_maxId
- FROM TAD_AUX.AD_SEQUENCE WHERE AD_SEQUENCE_ID BETWEEN p_sequenceIdFrom AND p_sequenceIdTo;
- v_sequenceOffset:=v_nextNo - v_minId;
-/* UPDATE AD_SEQUENCE SET CurrentNextSys=CurrentNextSys + (v_maxId-v_minId) + INCREMENTNO
- WHERE  Name='AD_Sequence' AND IsActive='Y' AND IsTableID='Y' AND IsAutoSequence='Y';
-*/
-
-
---AD_REF_TABLE doesn't need a translation because it lacks of an ID
---Por la misma razon, tampoco necesitan traslacion las tablas de traduccion (..._TRL)
-
---Comienzo de carga de datos.
---Primero, inhabilitar constraints de integridad referencial (existen referencias circulares...)
- --AD_Table. No inhabilitamos el trigger para que inserte valores en ad_sequence
- EXECUTE IMMEDIATE ('ALTER TABLE AD_TABLE DISABLE CONSTRAINT AD_WINDOW_TABLE');
- EXECUTE IMMEDIATE ('ALTER TABLE AD_TABLE DISABLE CONSTRAINT AD_VALRULE_TABLE');
- --AD_Column. No tiene trigger para insert
- EXECUTE IMMEDIATE ('ALTER TABLE AD_COLUMN DISABLE CONSTRAINT ADPROCESS_ADCOLUMN');
- EXECUTE IMMEDIATE ('ALTER TABLE AD_COLUMN DISABLE CONSTRAINT AD_ELEMENT_AD_COLUMN');
- EXECUTE IMMEDIATE ('ALTER TABLE AD_COLUMN DISABLE CONSTRAINT AD_REFERENCE_COLUMNDATATYPE');
- EXECUTE IMMEDIATE ('ALTER TABLE AD_COLUMN DISABLE CONSTRAINT AD_REFERENCE_COLUMNVALUE');
- EXECUTE IMMEDIATE ('ALTER TABLE AD_COLUMN DISABLE CONSTRAINT AD_TABLE_COLUMN');
- EXECUTE IMMEDIATE ('ALTER TABLE AD_COLUMN DISABLE CONSTRAINT AD_VALRULE_COLUMN');
- --AD_Tab. Inhabilitamos trigger para que no inserte en ad_tab_trl
- EXECUTE IMMEDIATE ('ALTER TRIGGER AD_TAB_TRG DISABLE');
- EXECUTE IMMEDIATE ('ALTER TABLE AD_TAB DISABLE CONSTRAINT ADCOLUMN_ADTABSORTORDER');
- EXECUTE IMMEDIATE ('ALTER TABLE AD_TAB DISABLE CONSTRAINT ADCOLUMN_ADTABSORTYESNO');
- EXECUTE IMMEDIATE ('ALTER TABLE AD_TAB DISABLE CONSTRAINT ADPROCESS_ADTAB');
- EXECUTE IMMEDIATE ('ALTER TABLE AD_TAB DISABLE CONSTRAINT ADTAB_INCLUDED');
- EXECUTE IMMEDIATE ('ALTER TABLE AD_TAB DISABLE CONSTRAINT AD_COLUMN_AD_TAB');
- EXECUTE IMMEDIATE ('ALTER TABLE AD_TAB DISABLE CONSTRAINT AD_TABLE_TAB');
- EXECUTE IMMEDIATE ('ALTER TABLE AD_TAB DISABLE CONSTRAINT AD_WINDOW_TAB');
- --AD_Window. Constraints no necesita. Triggers si. Habra que insertar a mano en la window_access!!!
- EXECUTE IMMEDIATE ('ALTER TRIGGER AD_WINDOW_TRG DISABLE');
- --AD_Window_Access
- EXECUTE IMMEDIATE ('ALTER TABLE AD_WINDOW_ACCESS DISABLE CONSTRAINT ADWINDOW_ADWINDOWACCESS');
- EXECUTE IMMEDIATE ('ALTER TABLE AD_WINDOW_ACCESS DISABLE CONSTRAINT ADROLE_ADWINDOWACCESS');
- --AD_Field
- EXECUTE IMMEDIATE ('ALTER TRIGGER AD_FIELD_TRG DISABLE');
- EXECUTE IMMEDIATE ('ALTER TABLE AD_FIELD DISABLE CONSTRAINT ADFIELDGROUP_ADFIELD');
- EXECUTE IMMEDIATE ('ALTER TABLE AD_FIELD DISABLE CONSTRAINT AD_COLUMN_FIELD');
- EXECUTE IMMEDIATE ('ALTER TABLE AD_FIELD DISABLE CONSTRAINT AD_TAB_FIELD');
- --AD_FieldGroup no necesita. Triggers si
- EXECUTE IMMEDIATE ('ALTER TRIGGER AD_FIELDGROUP_TRG DISABLE');
- --AD_Reference no necesita. Triggers si
- EXECUTE IMMEDIATE ('ALTER TRIGGER AD_REFERENCE_TRG DISABLE');
- --AD_Ref_List
- EXECUTE IMMEDIATE ('ALTER TRIGGER AD_REF_LIST_TRG DISABLE');
- EXECUTE IMMEDIATE ('ALTER TABLE AD_REF_LIST DISABLE CONSTRAINT AD_REFERENCE_REFLIST');
- --AD_Ref_Table
- EXECUTE IMMEDIATE ('ALTER TABLE AD_REF_TABLE DISABLE CONSTRAINT ADD_TABLE_REFTABLE');
- EXECUTE IMMEDIATE ('ALTER TABLE AD_REF_TABLE DISABLE CONSTRAINT AD_COLUMN_REFTABLE_DISPLAY');
- EXECUTE IMMEDIATE ('ALTER TABLE AD_REF_TABLE DISABLE CONSTRAINT AD_COLUMN_REFTABLE_ID');
- EXECUTE IMMEDIATE ('ALTER TABLE AD_REF_TABLE DISABLE CONSTRAINT AD_REFERENCE_REFTABLE');
- --AD_Menu
- EXECUTE IMMEDIATE ('ALTER TRIGGER AD_MENU_TRG DISABLE');
- EXECUTE IMMEDIATE ('ALTER TABLE AD_MENU DISABLE CONSTRAINT ADFORM_ADMENU');
- EXECUTE IMMEDIATE ('ALTER TABLE AD_MENU DISABLE CONSTRAINT ADPROCESS_ADMENU');
- EXECUTE IMMEDIATE ('ALTER TABLE AD_MENU DISABLE CONSTRAINT ADTASK_ADMENU');
- EXECUTE IMMEDIATE ('ALTER TABLE AD_MENU DISABLE CONSTRAINT ADWINDOW_ADMENU');
- EXECUTE IMMEDIATE ('ALTER TABLE AD_MENU DISABLE CONSTRAINT ADWORKFLOW_ADMENU');
- --AD_Treenode
- EXECUTE IMMEDIATE ('ALTER TABLE AD_TREENODE DISABLE CONSTRAINT ADTREE_ADTREENODE');
- --AD_Element
- EXECUTE IMMEDIATE ('ALTER TRIGGER AD_ELEMENT_TRG DISABLE');
- --AD_Val_Rule no necesita ni constraints ni triggers
- --AD_Tab_Trl
- EXECUTE IMMEDIATE ('ALTER TABLE AD_TAB_TRL DISABLE CONSTRAINT AD_TABTRL');
- --AD_Window_Trl
- EXECUTE IMMEDIATE ('ALTER TABLE AD_WINDOW_TRL DISABLE CONSTRAINT AD_WINDOWTRL');
- EXECUTE IMMEDIATE ('ALTER TRIGGER AD_WINDOW_TRL_TRG DISABLE');
- --AD_Field_Trl
- EXECUTE IMMEDIATE ('ALTER TABLE AD_FIELD_TRL DISABLE CONSTRAINT AD_FIELDTRL');
- --AD_FieldGroup_Trl
- EXECUTE IMMEDIATE ('ALTER TABLE AD_FIELDGROUP_TRL DISABLE CONSTRAINT ADFIELDGROUP_TRL');
- --AD_Ref_List_Trl
- EXECUTE IMMEDIATE ('ALTER TABLE AD_REF_LIST_TRL DISABLE CONSTRAINT AD_REFLISTTRL');
- --AD_Element_Trl
- EXECUTE IMMEDIATE ('ALTER TRIGGER AD_ELEMENT_TRL_TRG DISABLE');
- EXECUTE IMMEDIATE ('ALTER TABLE AD_ELEMENT_TRL DISABLE CONSTRAINT ADELEMENT_ADELEMENTTRL');
- --AD_Menu_Trl
- EXECUTE IMMEDIATE ('ALTER TABLE AD_MENU_TRL DISABLE CONSTRAINT AD_MENUTRL');
-
-
-
-
- --Insercion de valores, con traslacion de claves
- --AD_Table
- INSERT INTO AD_TABLE (AD_TABLE_ID, AD_CLIENT_ID, AD_ORG_ID, ISACTIVE, CREATED, CREATEDBY, UPDATED, UPDATEDBY,
- NAME, DESCRIPTION, HELP, TABLENAME, ISVIEW, ACCESSLEVEL, ENTITYTYPE, AD_WINDOW_ID, AD_VAL_RULE_ID,
- LOADSEQ, ISSECURITYENABLED, ISDELETEABLE, ISHIGHVOLUME, IMPORTTABLE, ISCHANGELOG, REPLICATIONTYPE,
- PO_WINDOW_ID, ISDEFAULTACCT)
- SELECT AD_TABLE_ID+v_tableOffset, 0, 0, ISACTIVE, now(), 0, now(), 0,
- NAME, DESCRIPTION, HELP, TABLENAME, ISVIEW, ACCESSLEVEL, ENTITYTYPE, CASE WHEN AD_WINDOW_ID>699999
- THEN AD_WINDOW_ID+v_windowOffset ELSE AD_WINDOW_ID END, AD_VAL_RULE_ID+v_valruleOffset,
- LOADSEQ, ISSECURITYENABLED, ISDELETEABLE, ISHIGHVOLUME, IMPORTTABLE, ISCHANGELOG, REPLICATIONTYPE,
- CASE WHEN PO_WINDOW_ID>699999 THEN PO_WINDOW_ID+v_windowOffset ELSE PO_WINDOW_ID END, ISDEFAULTACCT
- FROM TAD_AUX.AD_TABLE WHERE AD_TABLE_ID BETWEEN p_tableIdFrom AND p_tableIdTo;
-
- --AD_Column
- INSERT INTO AD_COLUMN (AD_COLUMN_ID, AD_CLIENT_ID, AD_ORG_ID, ISACTIVE, CREATED, UPDATED, CREATEDBY, UPDATEDBY,
- NAME, DESCRIPTION, HELP, VERSION, ENTITYTYPE, COLUMNNAME, AD_TABLE_ID, AD_REFERENCE_ID,
- AD_REFERENCE_VALUE_ID, AD_VAL_RULE_ID, FIELDLENGTH, DEFAULTVALUE, ISKEY, ISPARENT,
- ISMANDATORY, ISUPDATEABLE, READONLYLOGIC, ISIDENTIFIER, SEQNO, ISTRANSLATED, ISENCRYPTED,
- CALLOUT, VFORMAT, VALUEMIN, VALUEMAX, ISSELECTIONCOLUMN, AD_ELEMENT_ID, AD_PROCESS_ID,
- ISSYNCDATABASE, ISSESSIONATTR, ISSECONDARYKEY)
- SELECT AD_COLUMN_ID+v_columnOffset, 0, 0, ISACTIVE, now(), now(), 0, 0,
- NAME, DESCRIPTION, HELP, VERSION, ENTITYTYPE, COLUMNNAME, AD_TABLE_ID+v_tableOffset,
- CASE WHEN AD_REFERENCE_ID>699999 THEN AD_REFERENCE_ID+v_referenceOffset ELSE AD_REFERENCE_ID END,
- CASE WHEN AD_REFERENCE_VALUE_ID>699999 THEN AD_REFERENCE_VALUE_ID+v_referenceOffset ELSE AD_REFERENCE_VALUE_ID END,
- CASE WHEN AD_VAL_RULE_ID>699999 THEN AD_VAL_RULE_ID+v_valruleOffset ELSE AD_VAL_RULE_ID END, FIELDLENGTH, DEFAULTVALUE, ISKEY, ISPARENT,
- ISMANDATORY, ISUPDATEABLE, READONLYLOGIC, ISIDENTIFIER, SEQNO, ISTRANSLATED, ISENCRYPTED,
- CALLOUT, VFORMAT, VALUEMIN, VALUEMAX, ISSELECTIONCOLUMN, CASE WHEN AD_ELEMENT_ID>699999
- THEN AD_ELEMENT_ID+v_elementOffset ELSE AD_ELEMENT_ID END, AD_PROCESS_ID+v_processOffset,
- ISSYNCDATABASE, ISSESSIONATTR, ISSECONDARYKEY
- FROM TAD_AUX.AD_COLUMN WHERE AD_TABLE_ID BETWEEN p_tableIdFrom AND p_tableIdTo;
-
-
- --ad_tab
- INSERT INTO AD_TAB (AD_TAB_ID, AD_CLIENT_ID, AD_ORG_ID, ISACTIVE, CREATED, CREATEDBY, UPDATED,
- UPDATEDBY, NAME, DESCRIPTION, HELP, AD_TABLE_ID, AD_WINDOW_ID, SEQNO, TABLEVEL, ISSINGLEROW,
- ISINFOTAB, ISTRANSLATIONTAB, ISREADONLY, AD_COLUMN_ID, HASTREE, WHERECLAUSE, ORDERBYCLAUSE,
- COMMITWARNING, AD_PROCESS_ID, PROCESSING, AD_IMAGE_ID, IMPORTFIELDS, AD_COLUMNSORTORDER_ID,
- AD_COLUMNSORTYESNO_ID, ISSORTTAB, ENTITYTYPE, INCLUDED_TAB_ID, FILTERCLAUSE)
- SELECT AD_TAB_ID+v_tabOffset, 0, 0, ISACTIVE, now(), 0, now(),
- 0, NAME, DESCRIPTION, HELP, AD_TABLE_ID+v_tableOffset, CASE WHEN AD_WINDOW_ID>699999
- THEN AD_WINDOW_ID+v_windowOffset ELSE AD_WINDOW_ID END, SEQNO, TABLEVEL,
- ISSINGLEROW, ISINFOTAB, ISTRANSLATIONTAB, ISREADONLY, AD_COLUMN_ID+v_columnOffset, HASTREE, WHERECLAUSE,
- ORDERBYCLAUSE, COMMITWARNING, AD_PROCESS_ID+v_processOffset, PROCESSING, AD_IMAGE_ID, IMPORTFIELDS,
- AD_COLUMNSORTORDER_ID+v_columnOffset, AD_COLUMNSORTYESNO_ID+v_columnOffset, ISSORTTAB, ENTITYTYPE,
- INCLUDED_TAB_ID+v_tabOffset, FILTERCLAUSE
- FROM TAD_AUX.AD_TAB WHERE AD_TABLE_ID BETWEEN p_tableIdFrom AND p_tableIdTo;
-
- --ad_tab_trl
- INSERT INTO AD_TAB_TRL (AD_TAB_ID, AD_LANGUAGE, AD_CLIENT_ID, AD_ORG_ID, ISACTIVE, CREATED,
- CREATEDBY, UPDATED, UPDATEDBY, NAME, DESCRIPTION, HELP, COMMITWARNING, ISTRANSLATED)
- SELECT AD_TAB_ID+v_tabOffset,AD_LANGUAGE, 0, 0, ISACTIVE, now(), 0, now(),
- 0, NAME, DESCRIPTION, HELP, COMMITWARNING, ISTRANSLATED
- FROM TAD_AUX.AD_TAB_TRL WHERE AD_TAB_ID IN (
-   SELECT AD_TAB_ID FROM TAD_AUX.AD_TAB WHERE AD_TABLE_ID BETWEEN p_tableIdFrom AND p_tableIdTo);
-
- --ad_window
- INSERT INTO AD_WINDOW (AD_WINDOW_ID, AD_CLIENT_ID, AD_ORG_ID, ISACTIVE, CREATED, CREATEDBY,
- UPDATED, UPDATEDBY, NAME, DESCRIPTION, HELP, WINDOWTYPE, ISSOTRX, ENTITYTYPE, PROCESSING,
- AD_IMAGE_ID, AD_COLOR_ID, ISDEFAULT)
- SELECT AD_WINDOW_ID+v_windowOffset, 0, 0, ISACTIVE, now(), 0, now(), 0,
- NAME, DESCRIPTION, HELP, WINDOWTYPE, ISSOTRX, ENTITYTYPE, PROCESSING, AD_IMAGE_ID,
- AD_COLOR_ID, ISDEFAULT
- FROM TAD_AUX.AD_WINDOW WHERE AD_WINDOW_ID BETWEEN p_windowIdFrom AND p_windowIdTo;
-
- --ad_window_trl
- INSERT INTO AD_WINDOW_TRL (AD_WINDOW_ID, AD_LANGUAGE, AD_CLIENT_ID, AD_ORG_ID, ISACTIVE, CREATED,
- CREATEDBY, UPDATED, UPDATEDBY, NAME, DESCRIPTION, HELP, ISTRANSLATED)
- SELECT AD_WINDOW_ID+v_windowOffset, AD_LANGUAGE, 0, 0, ISACTIVE, now(), 0, now(), 0,
- NAME, DESCRIPTION, HELP, ISTRANSLATED
- FROM TAD_AUX.AD_WINDOW_TRL WHERE AD_WINDOW_ID BETWEEN p_windowIdFrom AND p_windowIdTo;
-
- --ad_window_access
- INSERT INTO AD_WINDOW_ACCESS (AD_WINDOW_ID, AD_ROLE_ID, AD_CLIENT_ID, AD_ORG_ID,
- ISACTIVE, CREATED, CREATEDBY, UPDATED, UPDATEDBY, ISREADWRITE)
- SELECT AD_WINDOW_ID+v_windowOffset, AD_ROLE_ID, 0, 0, 'Y', now(), 0, now(), 0, 'Y'
- FROM TAD_AUX.AD_WINDOW_ACCESS WHERE AD_WINDOW_ID BETWEEN p_windowIdFrom AND p_windowIdTo;
-
- --ad_auxiliarinput no esta hecho porque no hay ninguno en produccion
-
- --ad_field
- INSERT INTO AD_FIELD (AD_FIELD_ID, AD_CLIENT_ID, AD_ORG_ID, ISACTIVE, CREATED, CREATEDBY, UPDATED,
- UPDATEDBY, NAME, DESCRIPTION, HELP, ISCENTRALLYMAINTAINED, AD_TAB_ID, AD_COLUMN_ID, AD_FIELDGROUP_ID,
- ISDISPLAYED, DISPLAYLOGIC, DISPLAYLENGTH, ISREADONLY, SEQNO, SORTNO, ISSAMELINE, ISHEADING,
- ISFIELDONLY, ISENCRYPTED, ENTITYTYPE, SHOWINRELATION)
- SELECT AD_FIELD_ID+v_fieldOffset, 0, 0, ISACTIVE, now(), 0, now(), 0, NAME,
- DESCRIPTION, HELP, ISCENTRALLYMAINTAINED, AD_TAB_ID+v_tabOffset, AD_COLUMN_ID+v_columnOffset,
- AD_FIELDGROUP_ID+v_fieldgroupOffset, ISDISPLAYED, DISPLAYLOGIC, DISPLAYLENGTH, ISREADONLY,
- SEQNO, SORTNO, ISSAMELINE, ISHEADING, ISFIELDONLY, ISENCRYPTED, ENTITYTYPE, SHOWINRELATION
- FROM TAD_AUX.AD_FIELD WHERE AD_TAB_ID IN (
-   SELECT AD_TAB_ID FROM TAD_AUX.AD_TAB WHERE AD_TABLE_ID BETWEEN p_tableIdFrom AND p_tableIdTo);
-
- --ad_field_trl
- INSERT INTO AD_FIELD_TRL (AD_FIELD_ID, AD_LANGUAGE, AD_CLIENT_ID, AD_ORG_ID, ISACTIVE, CREATED,
- CREATEDBY, UPDATED, UPDATEDBY, NAME, DESCRIPTION, HELP, ISTRANSLATED)
- SELECT AD_FIELD_ID+v_fieldOffset, AD_LANGUAGE, 0, 0, ISACTIVE, now(), 0, now(), 0, NAME,
- DESCRIPTION, HELP, ISTRANSLATED
- FROM TAD_AUX.AD_FIELD_TRL WHERE AD_FIELD_ID IN (
-   SELECT AD_FIELD_ID FROM TAD_AUX.AD_FIELD
-   WHERE AD_TAB_ID IN (
-       SELECT AD_TAB_ID FROM TAD_AUX.AD_TAB WHERE AD_TABLE_ID BETWEEN p_tableIdFrom AND p_tableIdTo));
-
- --ad_fieldgroup no hay en produccion
-
- --ad_fieldgroup_trl no hay en produccion
-
- --ad_element
- INSERT INTO AD_ELEMENT (AD_ELEMENT_ID, AD_CLIENT_ID, AD_ORG_ID, ISACTIVE, CREATED, CREATEDBY,
- UPDATED, UPDATEDBY, COLUMNNAME, ENTITYTYPE, NAME, PRINTNAME, DESCRIPTION, HELP, PO_NAME,
- PO_PRINTNAME, PO_DESCRIPTION, PO_HELP)
- SELECT AD_ELEMENT_ID+v_elementOffset, 0, 0, ISACTIVE, now(), 0, now(), 0, COLUMNNAME,
- ENTITYTYPE, NAME, PRINTNAME, DESCRIPTION, HELP, PO_NAME, PO_PRINTNAME, PO_DESCRIPTION, PO_HELP
- FROM TAD_AUX.AD_ELEMENT WHERE AD_ELEMENT_ID BETWEEN p_elementIdFrom AND p_elementIdTo;
-
- --ad_element_trl
- INSERT INTO AD_ELEMENT_TRL (AD_ELEMENT_ID, AD_LANGUAGE, AD_CLIENT_ID, AD_ORG_ID, ISACTIVE, CREATED,
- CREATEDBY, UPDATED, UPDATEDBY, NAME, PRINTNAME, DESCRIPTION, HELP, PO_NAME, PO_PRINTNAME,
- PO_DESCRIPTION, PO_HELP, ISTRANSLATED)
- SELECT AD_ELEMENT_ID+v_elementOffset, AD_LANGUAGE, 0, 0, ISACTIVE, now(), 0, now(), 0,
- NAME, PRINTNAME, DESCRIPTION, HELP, PO_NAME, PO_PRINTNAME, PO_DESCRIPTION, PO_HELP, ISTRANSLATED
- FROM TAD_AUX.AD_ELEMENT_TRL WHERE AD_ELEMENT_ID BETWEEN p_elementIdFrom AND p_elementIdTo;
-
-
- --ad_reference
- INSERT INTO AD_REFERENCE (AD_REFERENCE_ID, AD_CLIENT_ID, AD_ORG_ID, ISACTIVE, CREATED, CREATEDBY,
- UPDATED, UPDATEDBY, NAME, DESCRIPTION, HELP, VALIDATIONTYPE, VFORMAT, ENTITYTYPE)
- SELECT AD_REFERENCE_ID+v_referenceOffset, 0, 0, ISACTIVE, now(), 0, now(), 0, NAME, DESCRIPTION,
- HELP, VALIDATIONTYPE, VFORMAT, ENTITYTYPE
- FROM TAD_AUX.AD_REFERENCE WHERE AD_REFERENCE_ID BETWEEN p_referenceIdFrom AND p_referenceIdTo;
-
- --ad_reference_trl
- INSERT INTO AD_REFERENCE_TRL (AD_REFERENCE_ID, AD_LANGUAGE, AD_CLIENT_ID, AD_ORG_ID, ISACTIVE,
- CREATED, CREATEDBY, UPDATED, UPDATEDBY, NAME, DESCRIPTION, HELP, ISTRANSLATED)
- SELECT AD_REFERENCE_ID+v_referenceOffset, AD_LANGUAGE, 0, 0, ISACTIVE, now(), 0, now(), 0,
- NAME, DESCRIPTION, HELP, ISTRANSLATED
- FROM TAD_AUX.AD_REFERENCE_TRL WHERE AD_REFERENCE_ID BETWEEN p_referenceIdFrom AND p_referenceIdTo;
-
- --ad_ref_table
- INSERT INTO AD_REF_TABLE (AD_REFERENCE_ID, AD_CLIENT_ID, AD_ORG_ID, ISACTIVE, CREATED, CREATEDBY,
- UPDATED, UPDATEDBY, AD_TABLE_ID, AD_KEY, AD_DISPLAY, ISVALUEDISPLAYED, WHERECLAUSE, ORDERBYCLAUSE,
- ENTITYTYPE)
- SELECT AD_REFERENCE_ID+v_referenceOffset, 0, 0, ISACTIVE, now(), 0, now(), 0,
- AD_TABLE_ID+v_tableOffset, CASE WHEN AD_KEY>699999 THEN AD_KEY+v_columnOffset ELSE AD_KEY END,
- CASE WHEN AD_DISPLAY>699999 THEN AD_DISPLAY+v_columnOffset ELSE AD_DISPLAY END,
- ISVALUEDISPLAYED, WHERECLAUSE, ORDERBYCLAUSE, ENTITYTYPE
- FROM TAD_AUX.AD_REF_TABLE WHERE AD_REFERENCE_ID BETWEEN p_referenceIdFrom AND p_referenceIdTo;
-
- --ad_ref_list
- INSERT INTO AD_REF_LIST (AD_REF_LIST_ID, AD_CLIENT_ID, AD_ORG_ID, ISACTIVE, CREATED, CREATEDBY,
- UPDATED, UPDATEDBY, VALUE, NAME, DESCRIPTION, AD_REFERENCE_ID, VALIDFROM, VALIDTO, ENTITYTYPE)
- SELECT AD_REF_LIST_ID+v_reflistOffset, 0, 0, ISACTIVE, now(), 0, now(), 0, VALUE, NAME,
- DESCRIPTION, AD_REFERENCE_ID+v_referenceOffset, VALIDFROM, VALIDTO, ENTITYTYPE
- FROM TAD_AUX.AD_REF_LIST WHERE AD_REFERENCE_ID BETWEEN p_referenceIdFrom AND p_referenceIdTo;
-
- --ad_ref_list_trl
- INSERT INTO AD_REF_LIST_TRL (AD_REF_LIST_ID, AD_LANGUAGE, AD_CLIENT_ID, AD_ORG_ID, ISACTIVE,
- CREATED, CREATEDBY, UPDATED, UPDATEDBY, NAME, DESCRIPTION, ISTRANSLATED)
- SELECT AD_REF_LIST_ID+v_reflistOffset, AD_LANGUAGE, 0, 0, ISACTIVE, now(), 0, now(), 0,
- NAME, DESCRIPTION, ISTRANSLATED
- FROM TAD_AUX.AD_REF_LIST_TRL WHERE AD_REF_LIST_ID IN (
-   SELECT AD_REF_LIST_ID FROM TAD_AUX.AD_REF_LIST
-   WHERE AD_REFERENCE_ID BETWEEN p_referenceIdFrom AND p_referenceIdTo);
-
-
- --ad_menu
- INSERT INTO AD_MENU (AD_MENU_ID, AD_CLIENT_ID, AD_ORG_ID, ISACTIVE, CREATED, CREATEDBY, UPDATED,
- NAME, UPDATEDBY, DESCRIPTION, ISSUMMARY, ISSOTRX, ISREADONLY, ACTION, AD_WINDOW_ID, AD_WORKFLOW_ID,
- AD_TASK_ID, AD_PROCESS_ID, AD_FORM_ID, AD_WORKBENCH_ID, ENTITYTYPE)
- SELECT AD_MENU_ID+v_menuOffset, 0, 0, ISACTIVE, now(), 0, now(), NAME, UPDATEDBY, DESCRIPTION,
- ISSUMMARY, ISSOTRX, ISREADONLY, ACTION, AD_WINDOW_ID+v_windowOffset, AD_WORKFLOW_ID+v_workflowOffset,
- AD_TASK_ID+v_taskOffset, AD_PROCESS_ID+v_processOffset, AD_FORM_ID+v_formOffset, AD_WORKBENCH_ID,
- ENTITYTYPE
- FROM TAD_AUX.AD_MENU WHERE AD_MENU_ID BETWEEN p_menuIdFrom AND p_menuIdTo;
-
- --ad_menu_trl
- INSERT INTO AD_MENU_TRL (AD_MENU_ID, AD_LANGUAGE, AD_CLIENT_ID, AD_ORG_ID, ISACTIVE, CREATED,
- CREATEDBY, UPDATED, UPDATEDBY, NAME, DESCRIPTION, ISTRANSLATED)
- SELECT AD_MENU_ID+v_menuOffset, AD_LANGUAGE, 0, 0, ISACTIVE, now(), 0, now(), 0, NAME,
- DESCRIPTION, ISTRANSLATED
- FROM TAD_AUX.AD_MENU_TRL WHERE AD_MENU_ID BETWEEN p_menuIdFrom AND p_menuIdTo;
-
- --ad_treenode
- INSERT INTO AD_TREENODE (AD_TREE_ID, NODE_ID, AD_CLIENT_ID, AD_ORG_ID, ISACTIVE, CREATED,
- CREATEDBY, UPDATED, UPDATEDBY, PARENT_ID, SEQNO)
- SELECT AD_TREE_ID, NODE_ID+v_menuOffset, 0, 0, ISACTIVE, now(), 0, now(), 0,
- CASE WHEN PARENT_ID>699999 THEN PARENT_ID+v_menuOffset ELSE PARENT_ID END, SEQNO
- FROM TAD_AUX.AD_TREENODE WHERE NODE_ID BETWEEN p_menuIdFrom AND p_menuIdTo;
-
- --ad_val_rule
- INSERT INTO AD_VAL_RULE (AD_VAL_RULE_ID, AD_CLIENT_ID, AD_ORG_ID, ISACTIVE, CREATED, CREATEDBY,
- UPDATED, UPDATEDBY, NAME, DESCRIPTION, TYPE, CODE, ENTITYTYPE)
- SELECT AD_VAL_RULE_ID+v_valruleOffset, 0, 0, ISACTIVE, now(), 0, now(), 0, NAME,
- DESCRIPTION, TYPE, CODE, ENTITYTYPE
- FROM TAD_AUX.AD_VAL_RULE WHERE AD_VAL_RULE_ID BETWEEN p_valruleIdFrom AND p_valruleIdTo;
-
-
-
---  por si falla lo del nulo!!!!
--- (CASE WHEN INCLUDED_TAB_ID IS  NULL THEN  NULL ELSE  INCLUDED_TAB_ID+v_tabOffset END)
-
-
-
- --AD_Table. No inhabilitamos el trigger para que inserte valores en ad_sequence
- EXECUTE IMMEDIATE ('ALTER TABLE AD_TABLE ENABLE CONSTRAINT AD_WINDOW_TABLE');
- EXECUTE IMMEDIATE ('ALTER TABLE AD_TABLE ENABLE CONSTRAINT AD_VALRULE_TABLE');
- --AD_Column. No tiene trigger para insert
- EXECUTE IMMEDIATE ('ALTER TABLE AD_COLUMN ENABLE CONSTRAINT ADPROCESS_ADCOLUMN');
- EXECUTE IMMEDIATE ('ALTER TABLE AD_COLUMN ENABLE CONSTRAINT AD_ELEMENT_AD_COLUMN');
- EXECUTE IMMEDIATE ('ALTER TABLE AD_COLUMN ENABLE CONSTRAINT AD_REFERENCE_COLUMNDATATYPE');
- EXECUTE IMMEDIATE ('ALTER TABLE AD_COLUMN ENABLE CONSTRAINT AD_REFERENCE_COLUMNVALUE');
- EXECUTE IMMEDIATE ('ALTER TABLE AD_COLUMN ENABLE CONSTRAINT AD_TABLE_COLUMN');
- EXECUTE IMMEDIATE ('ALTER TABLE AD_COLUMN ENABLE CONSTRAINT AD_VALRULE_COLUMN');
- --AD_Tab. Inhabilitamos trigger para que no inserte en ad_tab_trl
- EXECUTE IMMEDIATE ('ALTER TRIGGER AD_TAB_TRG ENABLE');
- EXECUTE IMMEDIATE ('ALTER TABLE AD_TAB ENABLE CONSTRAINT ADCOLUMN_ADTABSORTORDER');
- EXECUTE IMMEDIATE ('ALTER TABLE AD_TAB ENABLE CONSTRAINT ADCOLUMN_ADTABSORTYESNO');
- EXECUTE IMMEDIATE ('ALTER TABLE AD_TAB ENABLE CONSTRAINT ADPROCESS_ADTAB');
- EXECUTE IMMEDIATE ('ALTER TABLE AD_TAB ENABLE CONSTRAINT ADTAB_INCLUDED');
- EXECUTE IMMEDIATE ('ALTER TABLE AD_TAB ENABLE CONSTRAINT AD_COLUMN_AD_TAB');
- EXECUTE IMMEDIATE ('ALTER TABLE AD_TAB ENABLE CONSTRAINT AD_TABLE_TAB');
- EXECUTE IMMEDIATE ('ALTER TABLE AD_TAB ENABLE CONSTRAINT AD_WINDOW_TAB');
- --AD_Window. Constraints no necesita. Triggers si. Habra que insertar a mano en la window_access!!!
- EXECUTE IMMEDIATE ('ALTER TRIGGER AD_WINDOW_TRG ENABLE');
- --AD_Window_Access
- EXECUTE IMMEDIATE ('ALTER TABLE AD_WINDOW_ACCESS ENABLE CONSTRAINT ADWINDOW_ADWINDOWACCESS');
- EXECUTE IMMEDIATE ('ALTER TABLE AD_WINDOW_ACCESS ENABLE CONSTRAINT ADROLE_ADWINDOWACCESS');
- --AD_Field
- EXECUTE IMMEDIATE ('ALTER TRIGGER AD_FIELD_TRG ENABLE');
- EXECUTE IMMEDIATE ('ALTER TABLE AD_FIELD ENABLE CONSTRAINT ADFIELDGROUP_ADFIELD');
- EXECUTE IMMEDIATE ('ALTER TABLE AD_FIELD ENABLE CONSTRAINT AD_COLUMN_FIELD');
- EXECUTE IMMEDIATE ('ALTER TABLE AD_FIELD ENABLE CONSTRAINT AD_TAB_FIELD');
- --AD_FieldGroup no necesita. Triggers si
- EXECUTE IMMEDIATE ('ALTER TRIGGER AD_FIELDGROUP_TRG ENABLE');
- --AD_Reference no necesita. Triggers si
- EXECUTE IMMEDIATE ('ALTER TRIGGER AD_REFERENCE_TRG ENABLE');
- --AD_Ref_List
- EXECUTE IMMEDIATE ('ALTER TRIGGER AD_REF_LIST_TRG ENABLE');
- EXECUTE IMMEDIATE ('ALTER TABLE AD_REF_LIST ENABLE CONSTRAINT AD_REFERENCE_REFLIST');
- --AD_Ref_Table
- EXECUTE IMMEDIATE ('ALTER TABLE AD_REF_TABLE ENABLE CONSTRAINT ADD_TABLE_REFTABLE');
- EXECUTE IMMEDIATE ('ALTER TABLE AD_REF_TABLE ENABLE CONSTRAINT AD_COLUMN_REFTABLE_DISPLAY');
- EXECUTE IMMEDIATE ('ALTER TABLE AD_REF_TABLE ENABLE CONSTRAINT AD_COLUMN_REFTABLE_ID');
- EXECUTE IMMEDIATE ('ALTER TABLE AD_REF_TABLE ENABLE CONSTRAINT AD_REFERENCE_REFTABLE');
- --AD_Menu
- EXECUTE IMMEDIATE ('ALTER TRIGGER AD_MENU_TRG ENABLE');
- EXECUTE IMMEDIATE ('ALTER TABLE AD_MENU ENABLE CONSTRAINT ADFORM_ADMENU');
- EXECUTE IMMEDIATE ('ALTER TABLE AD_MENU ENABLE CONSTRAINT ADPROCESS_ADMENU');
- EXECUTE IMMEDIATE ('ALTER TABLE AD_MENU ENABLE CONSTRAINT ADTASK_ADMENU');
- EXECUTE IMMEDIATE ('ALTER TABLE AD_MENU ENABLE CONSTRAINT ADWINDOW_ADMENU');
- EXECUTE IMMEDIATE ('ALTER TABLE AD_MENU ENABLE CONSTRAINT ADWORKFLOW_ADMENU');
- --AD_Treenode
- EXECUTE IMMEDIATE ('ALTER TABLE AD_TREENODE ENABLE CONSTRAINT ADTREE_ADTREENODE');
- --AD_Element
- EXECUTE IMMEDIATE ('ALTER TRIGGER AD_ELEMENT_TRG ENABLE');
- --AD_Tab_Trl
- EXECUTE IMMEDIATE ('ALTER TABLE AD_TAB_TRL ENABLE CONSTRAINT AD_TABTRL');
- --AD_Window_Trl
- EXECUTE IMMEDIATE ('ALTER TABLE AD_WINDOW_TRL ENABLE CONSTRAINT AD_WINDOWTRL');
- EXECUTE IMMEDIATE ('ALTER TRIGGER AD_WINDOW_TRL_TRG ENABLE');
- --AD_Field_Trl
- EXECUTE IMMEDIATE ('ALTER TABLE AD_FIELD_TRL ENABLE CONSTRAINT AD_FIELDTRL');
- --AD_FieldGroup_Trl
- EXECUTE IMMEDIATE ('ALTER TABLE AD_FIELDGROUP_TRL ENABLE CONSTRAINT ADFIELDGROUP_TRL');
- --AD_Ref_List_Trl
- EXECUTE IMMEDIATE ('ALTER TABLE AD_REF_LIST_TRL ENABLE CONSTRAINT AD_REFLISTTRL');
- --AD_Element_Trl
- EXECUTE IMMEDIATE ('ALTER TRIGGER AD_ELEMENT_TRL_TRG ENABLE');
- EXECUTE IMMEDIATE ('ALTER TABLE AD_ELEMENT_TRL ENABLE CONSTRAINT ADELEMENT_ADELEMENTTRL');
- --AD_Menu_Trl
- EXECUTE IMMEDIATE ('ALTER TABLE AD_MENU_TRL ENABLE CONSTRAINT AD_MENUTRL');
-
-
- --Se ejecuta el proceso AD_UPDATE_SEQUENCE
- --AD_UPDATE_SEQUENCE(p_baseinstalation);  --mirar
-END AD_APPLICATION_IMPORT
-]]></body>
-    </function>
-  </database>
--- a/src-db/database/model/functions/AD_COLUMN_FORMAT.xml	Wed Apr 30 10:48:47 2008 +0000
+++ /dev/null	Thu Jan 01 00:00:00 1970 +0000
@@ -1,56 +0,0 @@
-<?xml version="1.0"?>
-  <database name="FUNCTION AD_COLUMN_FORMAT">
-    <function name="AD_COLUMN_FORMAT" type="VARCHAR">
-      <parameter name="p_columnname" type="VARCHAR" mode="in">
-        <default/>
-      </parameter>
-      <parameter name="p_reference_id" type="NUMERIC" mode="in">
-        <default/>
-      </parameter>
-      <parameter name="p_isdata" type="CHAR" mode="in">
-        <default/>
-      </parameter>
-      <body><![CDATA[/*************************************************************************
-* The contents of this file are subject to the Openbravo  Public  License
-* Version  1.0  (the  "License"),  being   the  Mozilla   Public  License
-* Version 1.1  with a permitted attribution clause; you may not  use this
-* file except in compliance with the License. You  may  obtain  a copy of
-* the License at http://www.openbravo.com/legal/license.html
-* Software distributed under the License  is  distributed  on  an "AS IS"
-* basis, WITHOUT WARRANTY OF ANY KIND, either express or implied. See the
-* License for the specific  language  governing  rights  and  limitations
-* under the License.
-* The Original Code is Openbravo ERP.
-* The Initial Developer of the Original Code is Openbravo SL
-* All portions are Copyright (C) 2001-2006 Openbravo SL
-* All Rights Reserved.
-* Contributor(s):  ______________________________________.
-************************************************************************/
-    v_Display VARCHAR2(4000) ;
-    v_Column  VARCHAR2(2000) ;
-  BEGIN
-    v_Column:=p_ColumnName;
-    IF p_IsData='Y' THEN
-      v_Column:='''' || v_Column || '''';
-    END IF;
-    IF p_Reference_ID=11 THEN -- INTEGERS
-      v_Display:='TRIM(TO_CHAR(' || v_Column || ', ''9999999990''))';
-    ELSIF p_Reference_ID IN(12, 22, 29, 800008, 800019) THEN -- NUMBER
-      v_Display:='TRIM(TO_CHAR(ROUND(' || v_Column || ', 2), ''9999999990.09''))';
-    ELSIF p_Reference_ID=15 THEN -- DATE
-      v_Display:='TO_CHAR(' || v_Column || ', ''DD-MM-YYYY'')';
-    ELSIF p_Reference_ID=24 THEN -- TIME
-      v_Display:='TO_CHAR(' || v_Column || ', ''HH24:MI:SS'')';
-    ELSIF p_Reference_ID=16 THEN -- DATETIME
-      v_Display:='TO_CHAR(' || v_Column || ', ''DD-MM-YYYY HH24:MI:SS'')';
-    ELSE
-      v_Display:=v_Column;
-    END IF;
-    RETURN v_Display;
-EXCEPTION
-  WHEN OTHERS THEN
-    RETURN v_Column;
-END AD_COLUMN_FORMAT
-]]></body>
-    </function>
-  </database>
--- a/src-db/database/model/functions/AD_COLUMN_SYNC.xml	Wed Apr 30 10:48:47 2008 +0000
+++ /dev/null	Thu Jan 01 00:00:00 1970 +0000
@@ -1,267 +0,0 @@
-<?xml version="1.0"?>
-  <database name="FUNCTION AD_COLUMN_SYNC">
-    <function name="AD_COLUMN_SYNC" type="NULL">
-      <parameter name="p_pinstance_id" type="NUMERIC" mode="in">
-        <default/>
-      </parameter>
-      <body><![CDATA[/*************************************************************************
-  * The contents of this file are subject to the Compiere Public
-  * License 1.1 ("License"); You may not use this file except in
-  * compliance with the License. You may obtain a copy of the License in
-  * the legal folder of your Openbravo installation.
-  * Software distributed under the License is distributed on an
-  * "AS IS" basis, WITHOUT WARRANTY OF ANY KIND, either express or
-  * implied. See the License for the specific language governing rights
-  * and limitations under the License.
-  * The Original Code is  Compiere  ERP &  Business Solution
-  * The Initial Developer of the Original Code is Jorg Janke and ComPiere, Inc.
-  * Portions created by Jorg Janke are Copyright (C) 1999-2001 Jorg Janke,
-  * parts created by ComPiere are Copyright (C) ComPiere, Inc.;
-  * All Rights Reserved.
-  * Contributor(s): Openbravo SL
-  * Contributions are Copyright (C) 2001-2008 Openbravo, S.L.
-  *
-  * Specifically, this derivative work is based upon the following Compiere
-  * file and version.
-  *************************************************************************
-  * $Id: AD_Column_Sync.sql,v 1.7 2002/12/05 05:42:26 jjanke Exp $
-  ***
-  * Title: Synchronize Column with Database
-  * Description:
-  ************************************************************************/
-  -- Logistice
-  v_ResultStr VARCHAR2(2000):='';
-  v_Message VARCHAR2(2000):='';
-  v_Result NUMBER:=1; -- 0=failure
-  v_Record_ID NUMBER;
-  v_AD_User_ID NUMBER;
-  -- Parameter
-  TYPE RECORD IS REF CURSOR;
-    Cur_Parameter RECORD;
-    -- Parameter Variables
-    -- Variables
-    v_TableName AD_Table.TableName%TYPE;
-    v_ColumnName AD_Column.ColumnName%TYPE;
-    v_AD_Reference_ID AD_Column.AD_Reference_ID%TYPE;
-    v_FieldLength AD_Column.FieldLength%TYPE;
-    v_DefaultValue AD_Column.DefaultValue%TYPE;
-    v_IsMandatory AD_Column.IsMandatory%TYPE;
-    --
-    v_DB_DataType USER_TAB_COLUMNS.DATA_TYPE%TYPE;
-    v_Cmd VARCHAR2(255):='';
-    v_DB_TableName VARCHAR(60):=NULL;
-    FINISH_PROCESS BOOLEAN:=false;
-  BEGIN
-    --  Update AD_PInstance
-    DBMS_OUTPUT.PUT_LINE('Updating PInstance - Processing ' || p_PInstance_ID) ;
-    v_ResultStr:='PInstanceNotFound';
-    AD_UPDATE_PINSTANCE(p_PInstance_ID, NULL, 'Y', NULL, NULL) ;
-  BEGIN --BODY
-    -- Get Parameters
-    v_ResultStr:='ReadingParameters';
-    FOR Cur_Parameter IN
-      (SELECT i.Record_ID, i.AD_User_ID, p.ParameterName, p.P_String, p.P_Number, p.P_Date
-      FROM AD_PInstance i
-      LEFT JOIN AD_PInstance_Para p
-        ON i.AD_PInstance_ID=p.AD_PInstance_ID
-      WHERE i.AD_PInstance_ID=p_PInstance_ID
-      ORDER BY p.SeqNo
-      )
-    LOOP
-      v_Record_ID:=Cur_Parameter.Record_ID;
-      v_AD_User_ID:=Cur_Parameter.AD_User_ID;
-    END LOOP; -- Get Parameter
-    DBMS_OUTPUT.PUT_LINE('  Record_ID=' || v_Record_ID) ;
-    -- Get Table/Column Info
-    v_ResultStr:='ReadingColumnInfo';
-    SELECT t.TableName, c.ColumnName, c.AD_Reference_ID, c.FieldLength, c.DefaultValue, c.IsMandatory
-    INTO v_TableName, v_ColumnName, v_AD_Reference_ID, v_FieldLength, v_DefaultValue, v_IsMandatory
-    FROM AD_Table t, AD_Column c
-    WHERE t.AD_Table_ID=c.AD_Table_ID  AND c.AD_Column_ID=v_Record_ID;
-    -- Check if Table exists
-    v_ResultStr:='ReadingDBTableInfo';
-  BEGIN
-    SELECT Table_Name
-    INTO v_DB_TableName
-    FROM USER_TABLES
-    WHERE Table_Name=UPPER(v_TableName) ;
-  EXCEPTION
-  WHEN OTHERS THEN
-    NULL;
-  END;
-  -- Table does not exists
-  IF(v_DB_TableName IS NULL) THEN
-    v_ResultStr:='CreateTableCommand';
-  BEGIN
-    v_CMD:='CREATE TABLE ' || SYS_CONTEXT('USERENV', 'CURRENT_USER') || '.'  || UPPER(v_TableName) || ' (XXXX CHAR(1))';
-    EXECUTE IMMEDIATE v_Cmd;
-  EXCEPTION
-  WHEN OTHERS THEN
-    v_Result:=0; -- failure
-    v_Message:='Error: ' || SQLERRM || ' - Command: ' || v_Cmd;
-    FINISH_PROCESS:=true;
-  END;
- END IF;
- IF(NOT FINISH_PROCESS) THEN
-   -- Get Data Dictionary Info
-   v_ResultStr:='ReadingDBColumnInfo';
- BEGIN
-   SELECT DATA_TYPE --, DATA_LENGTH, DATA_PRECISION, DATA_SCALE, NULLABLE, DATA_DEFAULT
-   INTO v_DB_DataType
-   FROM USER_TAB_COLUMNS
-   WHERE TABLE_NAME=UPPER(v_TableName) AND COLUMN_NAME=UPPER(v_ColumnName) ;
- EXCEPTION
- WHEN OTHERS THEN
-   NULL;
- END;
- /**
- * Create Column in Database
- */
- IF(v_DB_DataType IS NULL) THEN
-   v_ResultStr:='CreateALTERCommand';
- BEGIN
-   --  Get TableName
-   v_Cmd:='ALTER TABLE ' || v_TableName || ' ADD ' || v_ColumnName || ' ';
-   -- Map Data Type
-   IF(v_AD_Reference_ID IN(10, 14)) THEN
-     -- String, Text
-     v_Cmd:=v_Cmd || 'VARCHAR2(' || v_FieldLength || ')';
-   ELSIF(v_AD_Reference_ID IN(17, 20, 28)) THEN
-     -- List,YesNo,Button
-     v_Cmd:=v_Cmd || 'CHAR(' || v_FieldLength || ')';
-   ELSIF(v_AD_Reference_ID IN(13, 18, 19, 21, 25, 27, 30, 31)) THEN
-     -- ID,Table,TableDir,Location,Account,Color,Search,Locator
-     v_Cmd:=v_Cmd || 'NUMBER(10)';
-   ELSIF(v_AD_Reference_ID IN(11, 12, 22, 29)) THEN
-     -- Integer,Amount,Number,Quantity
-     v_Cmd:=v_Cmd || 'NUMBER';
-   ELSIF(v_AD_Reference_ID IN(15, 16)) THEN
-     -- Date,DateTime
-     v_Cmd:=v_Cmd || 'DATE';
-   ELSE -- 23-Binary, 24-Radio, 26-RowID, 32-Image
-     v_Result:=0; -- failure
-     v_Message:='DisplayType Not Supported';
-   END IF;
-   -- Default (literal)
-   IF(v_DefaultValue IS NOT NULL AND LENGTH(v_DefaultValue)<>0) THEN
-     IF(v_AD_Reference_ID IN(10, 14, 17, 20, 28)) THEN
-       v_Cmd:=v_Cmd || ' DEFAULT (''' || v_DefaultValue || ''')';
-     ELSE
-       v_Cmd:=v_Cmd || ' DEFAULT ' || v_DefaultValue;
-     END IF;
-   END IF;
-   -- Mandatory
-   IF(v_IsMandatory='Y') THEN
-     IF(v_DefaultValue IS NULL OR LENGTH(v_DefaultValue)=0) THEN
-       v_Result:=0; -- failure
-       v_Message:='Mandatory requites literal default value';
-     ELSE
-       v_Cmd:=v_Cmd || ' NOT NULL';
-     END IF;
-   END IF;
-   -- Execute it
-   IF(v_Result=1) THEN
-     EXECUTE IMMEDIATE v_Cmd;
-     v_Message:='@Created@ - ' || v_Cmd;
-   END IF;
- EXCEPTION
- WHEN OTHERS THEN
-   v_Result:=0; -- failure
-   v_Message:='Error: ' || SQLERRM || ' - Command: ' || v_Cmd;
- END;
- /**
- * Change certain Attributes
- */
- ELSE
-   v_ResultStr:='CreateALTERCommand';
- BEGIN
-   --  Get TableName
-   v_Cmd:='ALTER TABLE ' || v_TableName || ' MODIFY ' || v_ColumnName || ' ';
-   -- Map Data Type
-   IF(v_AD_Reference_ID IN(10, 14)) THEN
-     -- String, Text
-     v_Cmd:=v_Cmd || 'VARCHAR2(' || v_FieldLength || ')';
-   ELSIF(v_AD_Reference_ID IN(17, 20, 28)) THEN
-     -- List,YesNo,Button
-     v_Cmd:=v_Cmd || 'CHAR(' || v_FieldLength || ')';
-   ELSIF(v_AD_Reference_ID IN(13, 18, 19, 21, 25, 27, 30, 31)) THEN
-     -- ID,Table,TableDir,Location,Account,Color,Search,Locator
-     v_Cmd:=v_Cmd || 'NUMBER(10)';
-   ELSIF(v_AD_Reference_ID IN(11, 12, 22, 29)) THEN
-     -- Integer,Amount,Number,Quantity
-     v_Cmd:=v_Cmd || 'NUMBER';
-   ELSIF(v_AD_Reference_ID IN(15, 16)) THEN
-     -- Date,DateTime
-     v_Cmd:=v_Cmd || 'DATE';
-   ELSE -- 23-Binary, 24-Radio, 26-RowID, 32-Image
-     v_Result:=0; -- failure
-     v_Message:='DisplayType Not Supported';
-   END IF;
-   -- Default (literal)
-   IF(v_DefaultValue IS NOT NULL AND LENGTH(v_DefaultValue)<>0) THEN
-     IF(v_AD_Reference_ID IN(10, 14, 17, 20, 28)) THEN
-       v_Cmd:=v_Cmd || ' DEFAULT (''' || v_DefaultValue || ''')';
-     ELSE
-       v_Cmd:=v_Cmd || ' DEFAULT ' || v_DefaultValue;
-     END IF;
-   END IF;
-   -- Mandatory
-   IF(v_IsMandatory='Y') THEN
-     IF(v_DefaultValue IS NULL OR LENGTH(v_DefaultValue)=0) THEN
-       v_Result:=0; -- failure
-       v_Message:='Mandatory requites literal default value';
-     ELSE
-       v_Cmd:=v_Cmd || ' NOT NULL';
-     END IF;
-   END IF;
-   -- Execute it
-   IF(v_Result=1) THEN
-     EXECUTE IMMEDIATE v_Cmd;
-     v_Message:='@Updated@ - ' || v_Cmd;
-   END IF;
- EXCEPTION
- WHEN OTHERS THEN
-   v_Result:=0; -- failure
-   v_Message:='Error: ' || SQLERRM || ' - Command: ' || v_Cmd;
- END;
- END IF;
- /**
- * Delete Column
- */
- /* ELSE
- v_Cmd := 'ALTER TABLE ' || v_TableName
- || ' DROP COLUMN ' || v_ColumnName;
- -- Execute it
- EXECUTE IMMEDIATE v_Cmd;
- END IF;*/
- /**/
- -- Table did not exist - drop initial column
- IF(v_DB_TableName IS NULL) THEN
-   v_ResultStr:='CreateDropXXColumnCommand';
- BEGIN
-   v_CMD:='ALTER TABLE ' || v_TableName || ' DROP COLUMN XXXX';
-   EXECUTE IMMEDIATE v_Cmd;
- EXCEPTION
- WHEN OTHERS THEN
-   v_Result:=0; -- failure
-   v_Message:='Error: ' || SQLERRM || ' - Command: ' || v_Cmd;
- END;
- END IF;
- END IF; --FINISH_PROCESS
- --<<FINISH_PROCESS>>
- --  Update AD_PInstance
- DBMS_OUTPUT.PUT_LINE('Updating PInstance - Finished ' || v_Message) ;
- AD_UPDATE_PINSTANCE(p_PInstance_ID, NULL, 'N', v_Result, v_Message) ;
- RETURN;
- END; --BODY
-EXCEPTION
-WHEN OTHERS THEN
-  v_ResultStr:= '@ERROR=' || SQLERRM;
-  DBMS_OUTPUT.PUT_LINE(v_ResultStr) ;
-  ROLLBACK;
-  AD_UPDATE_PINSTANCE(p_PInstance_ID, NULL, 'N', 0, v_ResultStr) ;
-  RETURN;
-END AD_COLUMN_SYNC
-]]></body>
-    </function>
-  </database>
--- a/src-db/database/model/functions/AD_DEVELOPMENT_MIGRATION.xml	Wed Apr 30 10:48:47 2008 +0000
+++ /dev/null	Thu Jan 01 00:00:00 1970 +0000
@@ -1,261 +0,0 @@
-<?xml version="1.0"?>
-  <database name="FUNCTION AD_DEVELOPMENT_MIGRATION">
-    <function name="AD_DEVELOPMENT_MIGRATION" type="NULL">
-      <parameter name="p_pinstance_id" type="NUMERIC" mode="in">
-        <default/>
-      </parameter>
-      <body><![CDATA[/*************************************************************************
-* The contents of this file are subject to the Openbravo  Public  License
-* Version  1.0  (the  "License"),  being   the  Mozilla   Public  License
-* Version 1.1  with a permitted attribution clause; you may not  use this
-* file except in compliance with the License. You  may  obtain  a copy of
-* the License at http://www.openbravo.com/legal/license.html
-* Software distributed under the License  is  distributed  on  an "AS IS"
-* basis, WITHOUT WARRANTY OF ANY KIND, either express or implied. See the
-* License for the specific  language  governing  rights  and  limitations
-* under the License.
-* The Original Code is Openbravo ERP.
-* The Initial Developer of the Original Code is Openbravo SL
-* All portions are Copyright (C) 2001-2006 Openbravo SL
-* All Rights Reserved.
-* Contributor(s):  ______________________________________.
-************************************************************************/
-  /*************************************************************************
-  * Title: Development Migration
-  * Description:
-  *      Migrate a development
-  ************************************************************************/
-  --  Logistice
-  v_ResultStr VARCHAR2(2000):='';
-  v_Message VARCHAR2(2000):='';
-  v_Result NUMBER:=1; -- 0=failure
-  --  Parameter
-  TYPE RECORD IS REF CURSOR;
-    Cur_Parameter RECORD;
-    Cur_Triggers RECORD;
-    Cur_Constraints RECORD;
-    Cur_ConstraintsEnable RECORD;
-    Cur_Tables RECORD;
-    Cur_TranslateData RECORD;
-    Cur_Script RECORD;
-    --
-    v_seqNo NUMBER:=0;
-    v_count NUMBER:=0;
-    v_minID NUMBER(10) ;
-    v_maxID NUMBER(10) ;
-    v_nextID NUMBER(10) ;
-    --v_strTemp   VARCHAR2(4000) := '';
-    v_strSql VARCHAR2(4000):='';
-    v_offset NUMBER;
-    v_min NUMBER;
-    v_max NUMBER;
-  BEGIN
-    IF(p_PInstance_ID IS NOT NULL) THEN
-      --  Update AD_PInstance
-      DBMS_OUTPUT.PUT_LINE('Updating PInstance - Processing ' || p_PInstance_ID) ;
-      v_ResultStr:='PInstanceNotFound';
-      AD_UPDATE_PINSTANCE(p_PInstance_ID, NULL, 'Y', NULL, NULL) ;
-      --  Get Parameters
-      v_ResultStr:='ReadingParameters';
-      FOR Cur_Parameter IN
-        (SELECT p.ParameterName, p.P_String, p.P_Number
-        FROM AD_PInstance i
-        LEFT JOIN AD_PInstance_Para p
-          ON i.AD_PInstance_ID=p.AD_PInstance_ID
-        WHERE i.AD_PInstance_ID=p_PInstance_ID
-        ORDER BY p.SeqNo
-        )
-      LOOP
-        IF(Cur_Parameter.ParameterName='Min') THEN
-          v_min:=Cur_Parameter.P_Number;
-          DBMS_OUTPUT.PUT_LINE('  Min=' || v_min) ;
-        ELSIF(Cur_Parameter.ParameterName='Max') THEN
-          v_max:=Cur_Parameter.p_Number;
-          DBMS_OUTPUT.PUT_LINE('  Max=' || v_max) ;
-        ELSE
-          DBMS_OUTPUT.PUT_LINE('*** Unknown Parameter=' || Cur_Parameter.ParameterName) ;
-        END IF;
-      END LOOP; --  Get Parameter
-    ELSE
-      v_min:=100000;
-      v_max:=199999;
-      --v_Message := '@ADPinstanceIsNull@';
-      --GOTO END_PROCESS;
-    END IF;
-  BEGIN --BODY
-    -- Update tad_level
-    UPDATE AD_System  SET tad_level=8;
-    -- Update sequence values
-    v_ResultStr:='Updating sequences';
-    AD_UPDATE_SEQUENCE() ;
-    v_ResultStr:='Deleting old data';
-    DELETE FROM AD_SCRIPT_SQL;
-    DELETE FROM AD_ID_TRANSLATION;
-    AD_DEPENDENCIES_CREATE() ;
-    v_ResultStr:='Disabling triggers';
-    FOR Cur_Triggers IN
-      (SELECT OBJECT_NAME AS NAME
-      FROM USER_OBJECTS
-      WHERE OBJECT_TYPE='TRIGGER'
-      ORDER BY OBJECT_NAME
-      )
-    LOOP
-      v_seqNo:=v_seqNo + 1;
-      INSERT
-      INTO AD_SCRIPT_SQL VALUES
-        (v_seqNo, 'ALTER TRIGGER '||Cur_Triggers.NAME||' DISABLE') ;
-    END LOOP;
-    v_ResultStr:='Disabling constraints';
-    FOR Cur_Constraints IN
-      (SELECT TABLE_NAME, CONSTRAINT_NAME
-    FROM USER_CONSTRAINTS C1
-    WHERE CONSTRAINT_TYPE IN('P', 'U', 'R')
-    ORDER BY(CASE CONSTRAINT_TYPE WHEN 'R' THEN 1 WHEN 'U' THEN 2 WHEN 'P' THEN 3
-      END
-      ), TABLE_NAME, CONSTRAINT_NAME)
-    LOOP
-      v_seqNo:=v_seqNo + 1;
-      INSERT
-      INTO AD_SCRIPT_SQL VALUES
-        (v_seqNo, 'ALTER TABLE '||Cur_Constraints.TABLE_NAME||' DISABLE CONSTRAINT '||Cur_Constraints.CONSTRAINT_NAME) ;
-    END LOOP;
-    v_ResultStr:='Insert into AD_ID_Translation, update table id';
-    FOR Cur_Tables IN
-      (SELECT AD_Table_ID, UPPER(TableName) AS NAME, UPPER(TableName) || '_ID' AS COL_ID
-    FROM AD_Table
-    WHERE IsView='N'  AND UPPER(TableName) LIKE 'AD_%'  AND UPPER(TableName) NOT LIKE 'AD_%_Trl'  AND UPPER(TableName) NOT LIKE 'AD_%_Access'  AND EXISTS
-      (SELECT 1
-      FROM AD_Column
-      WHERE UPPER(AD_Column.Columnname)=UPPER(AD_Table.Tablename) || '_ID'  AND AD_Column.AD_REFERENCE_ID=13
-      )
-    ORDER BY TableName)
-    LOOP
-      EXECUTE IMMEDIATE 'SELECT COUNT(*) FROM '||Cur_Tables.NAME||' WHERE '||Cur_Tables.COL_ID||' BETWEEN '||v_min||' AND ' ||v_max INTO v_count;
-      IF(v_count>0) THEN
-        EXECUTE IMMEDIATE 'SELECT MIN('||Cur_Tables.COL_ID||') FROM '||Cur_Tables.NAME||' WHERE '||Cur_Tables.COL_ID||' BETWEEN '||v_min||' AND ' ||v_max INTO v_minID;
-        SELECT CurrentNextSys
-        INTO v_nextID
-        FROM AD_Sequence
-        WHERE UPPER(Name)=Cur_Tables.NAME  AND IsActive='Y'  AND IsTableID='Y'  AND IsAutoSequence='Y';
-        v_Offset:=v_nextID-v_minID;
-        INSERT
-        INTO AD_ID_TRANSLATION
-          (
-            AD_TABLE, AD_COLUMN, AD_CLIENT_OLD, AD_CLIENT_NEW, "OFFSET"
-          )
-          VALUES
-          (Cur_Tables.NAME, Cur_Tables.COL_ID, v_MinID, v_NextID, v_Offset) ;
-        --UPDATE Cur_Tables.COL_ID
-        v_strSql:='UPDATE ' || Cur_Tables.NAME || ' SET ' || Cur_Tables.COL_ID || ' = ' || Cur_Tables.COL_ID || ' + ' || v_Offset;
-        v_strSql:=v_strSql || 'WHERE ' || Cur_Tables.COL_ID || ' BETWEEN ' ||v_min||' AND ' ||v_max;
-        v_seqNo:=v_seqNo + 1;
-        INSERT INTO AD_SCRIPT_SQL VALUES(v_seqNo, v_strSql) ;
-      END IF;
-    END LOOP;
-    v_ResultStr:='Updating tables';
-    FOR Cur_TranslateData IN
-      (SELECT AD_DEPENDENCIES.TABLENAME, AD_DEPENDENCIES.COLUMNNAME, AD_DEPENDENCIES.DEPENDS_ON_TABLENAME, AD_DEPENDENCIES.DEPENDS_ON_COLUMNNAME, AD_ID_TRANSLATION."OFFSET"
-    FROM AD_DEPENDENCIES, AD_ID_TRANSLATION
-    WHERE AD_DEPENDENCIES.DEPENDS_ON_TABLENAME=AD_ID_TRANSLATION.AD_TABLE  AND AD_DEPENDENCIES.DEPENDS_ON_COLUMNNAME=AD_ID_TRANSLATION.AD_COLUMN
-    ORDER BY AD_DEPENDENCIES.TABLENAME, AD_DEPENDENCIES.COLUMNNAME)
-    LOOP
-      EXECUTE IMMEDIATE 'SELECT count(*) FROM ' || Cur_TranslateData.TABLENAME || ' WHERE ' || Cur_TranslateData.COLUMNNAME || ' BETWEEN ' || v_min || ' AND ' || v_max INTO v_count;
-      IF(v_count>0) THEN
-        v_strSql:='UPDATE ' || Cur_TranslateData.TABLENAME || ' SET ' || Cur_TranslateData.COLUMNNAME || ' = ' || Cur_TranslateData.COLUMNNAME || ' + ' || Cur_TranslateData."OFFSET";
-        v_strSql:=v_strSql || 'WHERE ' || Cur_TranslateData.COLUMNNAME || ' BETWEEN ' ||v_min||' AND ' ||v_max;
-        v_seqNo:=v_seqNo + 1;
-        INSERT INTO AD_SCRIPT_SQL VALUES(v_seqNo, v_strSql) ;
-      END IF;
-    END LOOP;
-    v_ResultStr:='Updating AD_TreeNode';
-    SELECT count(*)
-    INTO v_count
-    FROM AD_Treenode
-    WHERE Node_ID BETWEEN v_min AND v_max;
-    IF(v_count>0) THEN
-      SELECT max("OFFSET")
-      INTO v_Offset
-      FROM AD_ID_TRANSLATION
-      WHERE UPPER(ad_table)='AD_MENU';
-      v_strSql:='UPDATE AD_Treenode SET Node_ID = Node_ID + ' || v_Offset;
-      v_strSql:=v_strSql || 'WHERE Node_ID BETWEEN ' ||v_min||' AND ' ||v_max;
-      v_seqNo:=v_seqNo + 1;
-      INSERT INTO AD_SCRIPT_SQL VALUES(v_seqNo, v_strSql) ;
-    END IF;
-    SELECT count(*)
-    INTO v_count
-    FROM AD_Treenode
-    WHERE Parent_ID BETWEEN v_min AND v_max;
-    IF(v_count>0) THEN
-      SELECT max("OFFSET")
-      INTO v_Offset
-      FROM AD_ID_TRANSLATION
-      WHERE UPPER(ad_table)='AD_MENU';
-      v_strSql:='UPDATE AD_Treenode SET Parent_ID = Parent_ID + ' || v_Offset;
-      v_strSql:=v_strSql || 'WHERE Parent_ID BETWEEN ' ||v_min||' AND ' ||v_max;
-      v_seqNo:=v_seqNo + 1;
-      INSERT INTO AD_SCRIPT_SQL VALUES(v_seqNo, v_strSql) ;
-    END IF;
-    v_ResultStr:='Enabling  constraints';
-    FOR Cur_ConstraintsEnable IN
-      (SELECT TABLE_NAME, CONSTRAINT_NAME
-    FROM USER_CONSTRAINTS C1
-    WHERE CONSTRAINT_TYPE IN('P', 'U', 'R')
-    ORDER BY(CASE CONSTRAINT_TYPE WHEN 'R' THEN 3 WHEN 'U' THEN 2 WHEN 'P' THEN 1
-      END
-      ), TABLE_NAME, CONSTRAINT_NAME)
-    LOOP
-      v_seqNo:=v_seqNo + 1;
-      INSERT
-      INTO AD_SCRIPT_SQL VALUES
-        (v_seqNo, 'ALTER TABLE '||Cur_ConstraintsEnable.TABLE_NAME||' ENABLE CONSTRAINT '||Cur_ConstraintsEnable.CONSTRAINT_NAME) ;
-    END LOOP;
-    v_ResultStr:='Enabling triggers';
-    FOR Cur_Triggers IN
-      (SELECT OBJECT_NAME AS NAME
-    FROM USER_OBJECTS
-    WHERE OBJECT_TYPE='TRIGGER'
-    ORDER BY OBJECT_NAME)
-    LOOP
-      v_seqNo:=v_seqNo + 1;
-      INSERT
-      INTO AD_SCRIPT_SQL VALUES
-        (v_seqNo, 'ALTER TRIGGER '||Cur_Triggers.NAME||' ENABLE') ;
-    END LOOP;
-    -- Update sequence values
-    v_ResultStr:='Updating sequences';
-    AD_UPDATE_SEQUENCE_GENERATE() ;
-    FOR Cur_Script IN
-      (SELECT STRSQL, SEQNO FROM AD_SCRIPT_SQL ORDER BY SEQNO)
-    LOOP
-    BEGIN
-      EXECUTE IMMEDIATE(Cur_Script.STRSQL) ;
-    EXCEPTION
-    WHEN OTHERS THEN
-      v_ResultStr:=v_ResultStr || ': ' || SQLERRM || ' - ' || v_Message;
-      DBMS_OUTPUT.PUT_LINE(Cur_Script.SEQNO || ' - ' || v_ResultStr) ;
-    END;
-  END LOOP;
-  --<<END_PROCESS>>
-  IF(p_PInstance_ID IS NOT NULL) THEN
-    --  Update AD_PInstance
-    DBMS_OUTPUT.PUT_LINE('Updating PInstance - Finished ' || v_Message) ;
-    AD_UPDATE_PINSTANCE(p_PInstance_ID, NULL, 'N', v_Result, v_Message) ;
-  ELSE
-    DBMS_OUTPUT.PUT_LINE('Finished ' || v_Message) ;
-  END IF;
-  -- Commented by cromero 19102006 COMMIT;
-  RETURN;
-END; --BODY
-EXCEPTION
-WHEN OTHERS THEN
-  v_ResultStr:= '@ERROR=' || SQLERRM;
-  DBMS_OUTPUT.PUT_LINE(v_ResultStr) ;
-  ROLLBACK;
-  IF(p_PInstance_ID IS NOT NULL) THEN
-    AD_UPDATE_PINSTANCE(p_PInstance_ID, NULL, 'N', 0, v_ResultStr) ;
-  END IF;
-END AD_DEVELOPMENT_MIGRATION
-]]></body>
-    </function>
-  </database>
--- a/src-db/database/model/functions/AD_DISPLAY_LIST.xml	Wed Apr 30 10:48:47 2008 +0000
+++ /dev/null	Thu Jan 01 00:00:00 1970 +0000
@@ -1,55 +0,0 @@
-<?xml version="1.0"?>
-  <database name="FUNCTION AD_DISPLAY_LIST">
-    <function name="AD_DISPLAY_LIST" type="NVARCHAR">
-      <parameter name="p_referencevalue_id" type="NUMERIC" mode="in">
-        <default/>
-      </parameter>
-      <parameter name="p_value" type="NVARCHAR" mode="in">
-        <default/>
-      </parameter>
-      <parameter name="p_ad_language" type="VARCHAR" mode="in">
-        <default/>
-      </parameter>
-      <body><![CDATA[/*************************************************************************
-* The contents of this file are subject to the Openbravo  Public  License
-* Version  1.0  (the  "License"),  being   the  Mozilla   Public  License
-* Version 1.1  with a permitted attribution clause; you may not  use this
-* file except in compliance with the License. You  may  obtain  a copy of
-* the License at http://www.openbravo.com/legal/license.html
-* Software distributed under the License  is  distributed  on  an "AS IS"
-* basis, WITHOUT WARRANTY OF ANY KIND, either express or implied. See the
-* License for the specific  language  governing  rights  and  limitations
-* under the License.
-* The Original Code is Openbravo ERP.
-* The Initial Developer of the Original Code is Openbravo SL
-* All portions are Copyright (C) 2001-2006 Openbravo SL
-* All Rights Reserved.
-* Contributor(s):  ______________________________________.
-* Title: Get RefList Name translated
-************************************************************************/
-  v_Display NVARCHAR2(120) ;
-BEGIN
-  IF(p_AD_Language='en_US') THEN
-    SELECT RL.NAME
-    INTO v_Display
-    FROM AD_REF_LIST RL
-    WHERE RL.AD_REFERENCE_ID=p_ReferenceValue_ID
-      AND RL.VALUE=p_Value;
-  ELSE
-    SELECT RLT.NAME
-    INTO v_Display
-    FROM AD_REF_LIST RL,
-      AD_REF_LIST_TRL RLT
-    WHERE RL.AD_REF_LIST_ID=RLT.AD_REF_LIST_ID
-      AND RLT.AD_LANGUAGE=p_AD_Language
-      AND RL.AD_REFERENCE_ID=p_ReferenceValue_ID
-      AND RL.VALUE=p_Value;
-  END IF;
-  RETURN v_Display;
-EXCEPTION
-WHEN OTHERS THEN
-  RETURN 'Not found!!!';
-END AD_DISPLAY_LIST
-]]></body>
-    </function>
-  </database>
--- a/src-db/database/model/functions/AD_LANGUAGE_CREATE.xml	Wed Apr 30 10:48:47 2008 +0000
+++ b/src-db/database/model/functions/AD_LANGUAGE_CREATE.xml	Mon May 05 06:59:24 2008 +0000
@@ -81,22 +81,7 @@
     FROM AD_Language
     WHERE IsActive='Y'  AND IsSystemLanguage='Y';
     DBMS_OUTPUT.PUT_LINE('Number of active Languages=' || v_Languages) ;
-    -- Desktop
-    INSERT
-    INTO AD_Desktop_Trl
-      (
-        AD_Desktop_ID, AD_Language, Name, Description,
-        Help, IsTranslated, Createdby, UpdatedBy,
-        AD_Client_ID, AD_Org_ID
-      )
-    SELECT AD_Desktop_ID, AD_Language, AD_Desktop.Name, AD_Desktop.Description, AD_Desktop.Help, 'N', 0, 0, 0, 0
-    FROM AD_Desktop, AD_Language
-    WHERE AD_Language.IsActive='Y'  AND AD_Language.IsSystemLanguage='Y'  AND(AD_Desktop_ID, AD_Language) NOT IN
-      (SELECT AD_Desktop_ID, AD_Language FROM AD_Desktop_Trl)
-      ;
-    v_rowcount:=SQL%ROWCOUNT;
-    v_Created:=v_Created + v_rowcount;
-    DBMS_OUTPUT.PUT_LINE('- AD_Desktop ' || v_rowcount) ;
+    
     -- Element
     INSERT
     INTO AD_Element_Trl
@@ -188,20 +173,7 @@
     v_rowcount:=SQL%ROWCOUNT;
     v_Created:=v_Created + v_rowcount;
     DBMS_OUTPUT.PUT_LINE('- AD_Message ' || v_rowcount) ;
-    -- PrintFormatItem
-    INSERT
-    INTO AD_PrintFormatItem_Trl
-      (
-        AD_PrintFormatItem_ID, AD_Language, PrintName, PrintNameSuffix, IsTranslated, Createdby, UpdatedBy, AD_Client_ID, AD_Org_ID
-      )
-    SELECT AD_PrintFormatItem_ID, AD_Language, PrintName, PrintNameSuffix, 'N', 0, 0, 0, 0
-    FROM AD_PrintFormatItem, AD_Language
-    WHERE AD_Language.IsActive='Y'  AND AD_Language.IsSystemLanguage='Y'  AND(AD_PrintFormatItem_ID, AD_Language) NOT IN
-      (SELECT AD_PrintFormatItem_ID, AD_Language FROM AD_PrintFormatItem_Trl)
-      ;
-    v_rowcount:=SQL%ROWCOUNT;
-    v_Created:=v_Created + v_rowcount;
-    DBMS_OUTPUT.PUT_LINE('- AD_PrintFormatItem ' || v_rowcount) ;
+   
     -- Process
     INSERT
     INTO AD_Process_Trl
@@ -339,21 +311,7 @@
     v_rowcount:=SQL%ROWCOUNT;
     v_Created:=v_Created + v_rowcount;
     DBMS_OUTPUT.PUT_LINE('- AD_Window ' || v_rowcount) ;
-    INSERT
-    INTO AD_Workbench_Trl
-      (
-        AD_Workbench_ID, AD_Language, Name, Description,
-        Help, IsTranslated, Createdby, UpdatedBy,
-        AD_Client_ID, AD_Org_ID
-      )
-    SELECT AD_Workbench_ID, AD_Language, AD_Workbench.Name, AD_Workbench.Description, AD_Workbench.Help, 'N', 0, 0, 0, 0
-    FROM AD_Workbench, AD_Language
-    WHERE AD_Language.IsActive='Y'  AND AD_Language.IsSystemLanguage='Y'  AND(AD_Workbench_ID, AD_Language) NOT IN
-      (SELECT AD_Workbench_ID, AD_Language FROM AD_Workbench_Trl)
-      ;
-    v_rowcount:=SQL%ROWCOUNT;
-    v_Created:=v_Created + v_rowcount;
-    DBMS_OUTPUT.PUT_LINE('- AD_Workbench ' || v_rowcount) ;
+    
     INSERT
     INTO C_Country_Trl
       (
@@ -401,19 +359,7 @@
     v_rowcount:=SQL%ROWCOUNT;
     v_Created:=v_Created + v_rowcount;
     DBMS_OUTPUT.PUT_LINE('- C_DocType ' || v_rowcount) ;
-    INSERT
-    INTO C_DunningLevel_Trl
-      (
-        C_DunningLevel_ID, AD_Language, PrintName, Note, IsTranslated, Createdby, UpdatedBy, AD_Client_ID, AD_Org_ID
-      )
-    SELECT C_DunningLevel_ID, AD_Language, C_DunningLevel.PrintName, C_DunningLevel.Note, 'N', 0, 0, C_DunningLevel.AD_Client_ID, C_DunningLevel.AD_Org_ID
-    FROM C_DunningLevel, AD_Language
-    WHERE AD_Language.IsActive='Y'  AND AD_Language.IsSystemLanguage='Y'  AND(C_DunningLevel_ID, AD_Language) NOT IN
-      (SELECT C_DunningLevel_ID, AD_Language FROM C_DunningLevel_Trl)
-      ;
-    v_rowcount:=SQL%ROWCOUNT;
-    v_Created:=v_Created + v_rowcount;
-    DBMS_OUTPUT.PUT_LINE('- C_DunningLevel ' || v_rowcount) ;
+    
     INSERT
     INTO C_ElementValue_Trl
       (
--- a/src-db/database/model/functions/AD_MESSAGE_GET2.xml	Wed Apr 30 10:48:47 2008 +0000
+++ b/src-db/database/model/functions/AD_MESSAGE_GET2.xml	Mon May 05 06:59:24 2008 +0000
@@ -7,20 +7,22 @@
       <parameter name="p_ad_language" type="VARCHAR" mode="in">
         <default/>
       </parameter>
-      <body><![CDATA[/******************************************************************************
-* The contents of this file are subject to the   Compiere License  Version 1.1
-* ("License"); You may not use this file except in compliance with the License
-* You may obtain a copy of the License at http://www.compiere.org/license.html
-* Software distributed under the License is distributed on an  "AS IS"  basis,
-* WITHOUT WARRANTY OF ANY KIND, either express or implied. See the License for
-* the specific language governing rights and limitations under the License.
-* The Original Code is                  Compiere  ERP &  Business Solution
-* The Initial Developer of the Original Code is Jorg Janke  and ComPiere, Inc.
-* Portions created by Jorg Janke are Copyright (C) 1999-2001 Jorg Janke, parts
-* created by ComPiere are Copyright (C) ComPiere, Inc.;   All Rights Reserved.
-* Contributor(s): Openbravo SL
-* Contributions are Copyright (C) 2001-2006 Openbravo S.L.
-******************************************************************************/
+      <body><![CDATA[/*************************************************************************
+* The contents of this file are subject to the Openbravo  Public  License
+* Version  1.0  (the  "License"),  being   the  Mozilla   Public  License
+* Version 1.1  with a permitted attribution clause; you may not  use this
+* file except in compliance with the License. You  may  obtain  a copy of
+* the License at http://www.openbravo.com/legal/license.html
+* Software distributed under the License  is  distributed  on  an "AS IS"
+* basis, WITHOUT WARRANTY OF ANY KIND, either express or implied. See the
+* License for the specific  language  governing  rights  and  limitations
+* under the License.
+* The Original Code is Openbravo ERP.
+* The Initial Developer of the Original Code is Openbravo SL
+* All portions are Copyright (C) 2001-2008 Openbravo SL
+* All Rights Reserved.
+* Contributor(s):  ______________________________________.
+************************************************************************/
   v_RetValue AD_Message.MsgText%TYPE;
 BEGIN
 BEGIN
--- a/src-db/database/model/functions/AD_PARENT_TREE.xml	Wed Apr 30 10:48:47 2008 +0000
+++ b/src-db/database/model/functions/AD_PARENT_TREE.xml	Mon May 05 06:59:24 2008 +0000
@@ -7,7 +7,23 @@
       <parameter name="p_node_id" type="NUMERIC" mode="in">
         <default/>
       </parameter>
-      <body><![CDATA[p VARCHAR2(32767);
+      <body><![CDATA[/*************************************************************************
+* The contents of this file are subject to the Openbravo  Public  License
+* Version  1.0  (the  "License"),  being   the  Mozilla   Public  License
+* Version 1.1  with a permitted attribution clause; you may not  use this
+* file except in compliance with the License. You  may  obtain  a copy of
+* the License at http://www.openbravo.com/legal/license.html
+* Software distributed under the License  is  distributed  on  an "AS IS"
+* basis, WITHOUT WARRANTY OF ANY KIND, either express or implied. See the
+* License for the specific  language  governing  rights  and  limitations
+* under the License.
+* The Original Code is Openbravo ERP.
+* The Initial Developer of the Original Code is Openbravo SL
+* All portions are Copyright (C) 2001-2008 Openbravo SL
+* All Rights Reserved.
+* Contributor(s):  ______________________________________.
+************************************************************************/
+p VARCHAR2(32767);
   vp NUMBER(10);
 BEGIN
 
--- a/src-db/database/model/functions/AD_PRINTPAPER_DEFAULT.xml	Wed Apr 30 10:48:47 2008 +0000
+++ /dev/null	Thu Jan 01 00:00:00 1970 +0000
@@ -1,95 +0,0 @@
-<?xml version="1.0"?>
-  <database name="FUNCTION AD_PRINTPAPER_DEFAULT">
-    <function name="AD_PRINTPAPER_DEFAULT" type="NULL">
-      <parameter name="p_ad_pinstance_id" type="NUMERIC" mode="in">
-        <default/>
-      </parameter>
-      <body><![CDATA[/*************************************************************************
-  * The contents of this file are subject to the Compiere Public
-  * License 1.1 ("License"); You may not use this file except in
-  * compliance with the License. You may obtain a copy of the License in
-  * the legal folder of your Openbravo installation.
-  * Software distributed under the License is distributed on an
-  * "AS IS" basis, WITHOUT WARRANTY OF ANY KIND, either express or
-  * implied. See the License for the specific language governing rights
-  * and limitations under the License.
-  * The Original Code is  Compiere  ERP &  Business Solution
-  * The Initial Developer of the Original Code is Jorg Janke and ComPiere, Inc.
-  * Portions created by Jorg Janke are Copyright (C) 1999-2001 Jorg Janke,
-  * parts created by ComPiere are Copyright (C) ComPiere, Inc.;
-  * All Rights Reserved.
-  * Contributor(s): Openbravo SL
-  * Contributions are Copyright (C) 2001-2008 Openbravo, S.L.
-  *
-  * Specifically, this derivative work is based upon the following Compiere
-  * file and version.
-  *************************************************************************
-  * $Id: AD_PrintPaper_Default.sql,v 1.1 2002/09/15 01:06:47 jjanke Exp $
-  ***
-  * Title: Set Current Format as Default
-  * Description:
-  ************************************************************************/
-  -- Logistice
-  v_ResultStr VARCHAR2(2000):='';
-  v_Message VARCHAR2(2000):='';
-  v_Record_ID NUMBER;
-  -- Parameter
-  TYPE RECORD IS REF CURSOR;
-    Cur_Parameter RECORD;
-    -- Parameter Variables
-    p_AD_Client_ID NUMBER:=NULL;
-    rowcount NUMBER;
-  BEGIN
-    --  Update AD_PInstance
-    DBMS_OUTPUT.PUT_LINE('Updating PInstance - Processing ' || p_AD_PInstance_ID) ;
-    v_ResultStr:='PInstanceNotFound';
-    AD_UPDATE_PINSTANCE(p_AD_PInstance_ID, NULL, 'Y', NULL, NULL) ;
-  BEGIN --BODY
-    -- Get Parameters
-    v_ResultStr:='ReadingParameters';
-    FOR Cur_Parameter IN
-      (SELECT i.Record_ID, p.ParameterName, p.P_String, p.P_Number, p.P_Date
-      FROM AD_PInstance i
-      LEFT JOIN AD_PInstance_Para p
-        ON i.AD_PInstance_ID=p.AD_PInstance_ID
-      WHERE i.AD_PInstance_ID=p_AD_PInstance_ID
-      ORDER BY p.SeqNo
-      )
-    LOOP
-      v_Record_ID:=Cur_Parameter.Record_ID;
-      IF(Cur_Parameter.ParameterName='AD_Client_ID') THEN
-        p_AD_Client_ID:=Cur_Parameter.P_Number;
-        DBMS_OUTPUT.PUT_LINE('  AD_Client_ID=' || p_AD_Client_ID) ;
-      ELSE
-        DBMS_OUTPUT.PUT_LINE('*** Unknown Parameter=' || Cur_Parameter.ParameterName) ;
-      END IF;
-    END LOOP; -- Get Parameter
-    DBMS_OUTPUT.PUT_LINE('  Record_ID=' || v_Record_ID) ;
-    v_ResultStr:='Updating';
-    UPDATE AD_PrintFormat
-      SET AD_PrintPaper_ID=v_Record_ID
-    WHERE(AD_Client_ID=p_AD_Client_ID OR p_AD_Client_ID IS NULL) AND EXISTS
-      (SELECT *
-      FROM AD_PrintPaper pp
-      WHERE AD_PrintFormat.AD_PrintPaper_ID=pp.AD_PrintPaper_ID  AND IsLandscape=
-        (SELECT IsLandscape FROM AD_PrintPaper  WHERE AD_PrintPaper_ID=v_Record_ID)
-      )
-      ;
-    rowcount:=SQL%ROWCOUNT;
-    v_Message:='@Copied@=' || rowcount;
-    --<<FINISH_PROCESS>>
-    --  Update AD_PInstance
-    DBMS_OUTPUT.PUT_LINE('Updating PInstance - Finished ' || v_Message) ;
-    AD_UPDATE_PINSTANCE(p_AD_PInstance_ID, NULL, 'N', 1, v_Message) ;
-    RETURN;
-  END; --BODY
-EXCEPTION
-WHEN OTHERS THEN
-  v_ResultStr:= '@ERROR=' || SQLERRM;
-  DBMS_OUTPUT.PUT_LINE(v_ResultStr) ;
-  AD_UPDATE_PINSTANCE(p_AD_PInstance_ID, NULL, 'N', 0, v_ResultStr) ;
-  RETURN;
-END AD_PRINTPAPER_DEFAULT
-]]></body>
-    </function>
-  </database>
--- a/src-db/database/model/functions/AD_SYNCHRONIZE.xml	Wed Apr 30 10:48:47 2008 +0000
+++ b/src-db/database/model/functions/AD_SYNCHRONIZE.xml	Mon May 05 06:59:24 2008 +0000
@@ -634,115 +634,7 @@
       ;
     v_rowcount:=SQL%ROWCOUNT;
     DBMS_OUTPUT.PUT_LINE('  rows updated: ' || v_rowcount) ;
-    DBMS_OUTPUT.PUT_LINE('Synchronize PrintFormatItem Name from Element') ;
-    UPDATE AD_PRINTFORMATITEM
-      SET NAME=
-      (SELECT e.NAME
-      FROM AD_ELEMENT e, AD_COLUMN c
-      WHERE e.AD_Element_ID=c.AD_Element_ID  AND c.AD_Column_ID=AD_PRINTFORMATITEM.AD_Column_ID
-      )
-    WHERE EXISTS
-      (SELECT *
-      FROM AD_ELEMENT e, AD_COLUMN c
-      WHERE e.AD_Element_ID=c.AD_Element_ID  AND c.AD_Column_ID=AD_PRINTFORMATITEM.AD_Column_ID
-      AND e.NAME<>AD_PRINTFORMATITEM.NAME
-      )
-      AND EXISTS
-      (SELECT *
-      FROM AD_CLIENT
-      WHERE AD_Client_ID=AD_PRINTFORMATITEM.AD_Client_ID AND IsMultiLingualDocument='Y'
-      )
-      ;
-    v_rowcount:=SQL%ROWCOUNT;
-    DBMS_OUTPUT.PUT_LINE('  rows updated: ' || v_rowcount) ;
-    DBMS_OUTPUT.PUT_LINE('Synchronize PrintFormatItem PrintName from Element') ;
-    UPDATE AD_PRINTFORMATITEM
-      SET PrintName=
-      (SELECT e.PrintName
-      FROM AD_ELEMENT e, AD_COLUMN c
-      WHERE e.AD_Element_ID=c.AD_Element_ID  AND c.AD_Column_ID=AD_PRINTFORMATITEM.AD_Column_ID
-      )
-    WHERE EXISTS
-      (SELECT *
-      FROM AD_ELEMENT e, AD_COLUMN c, AD_PRINTFORMAT pf
-      WHERE e.AD_Element_ID=c.AD_Element_ID  AND c.AD_Column_ID=AD_PRINTFORMATITEM.AD_Column_ID
-      AND LENGTH(AD_PRINTFORMATITEM.PrintName)>0  AND e.PrintName<>AD_PRINTFORMATITEM.PrintName
-      AND pf.AD_PrintFormat_ID=AD_PRINTFORMATITEM.AD_PrintFormat_ID  AND pf.IsForm='N' AND IsTableBased='Y'
-      )
-      AND EXISTS
-      (SELECT *
-      FROM AD_CLIENT
-      WHERE AD_Client_ID=AD_PRINTFORMATITEM.AD_Client_ID AND IsMultiLingualDocument='Y'
-      )
-      ;
-    v_rowcount:=SQL%ROWCOUNT;
-    DBMS_OUTPUT.PUT_LINE('  rows updated: ' || v_rowcount) ;
-    DBMS_OUTPUT.PUT_LINE('Synchronize PrintFormatItem Trl from Element Trl (Multi-Lingual)') ;
-    UPDATE AD_PRINTFORMATITEM_TRL
-      SET PrintName=
-      (SELECT e.PrintName
-      FROM AD_ELEMENT_TRL e, AD_COLUMN c, AD_PRINTFORMATITEM pfi
-      WHERE e.AD_LANGUAGE=AD_PRINTFORMATITEM_TRL.AD_LANGUAGE  AND e.AD_Element_ID=c.AD_Element_ID
-      AND c.AD_Column_ID=pfi.AD_Column_ID  AND pfi.AD_PrintFormatItem_ID=AD_PRINTFORMATITEM_TRL.AD_PrintFormatItem_ID
-      )
-    WHERE EXISTS
-      (SELECT *
-      FROM AD_ELEMENT_TRL e, AD_COLUMN c, AD_PRINTFORMATITEM pfi, AD_PRINTFORMAT pf
-      WHERE e.AD_LANGUAGE=AD_PRINTFORMATITEM_TRL.AD_LANGUAGE  AND e.AD_Element_ID=c.AD_Element_ID
-      AND c.AD_Column_ID=pfi.AD_Column_ID  AND pfi.AD_PrintFormatItem_ID=AD_PRINTFORMATITEM_TRL.AD_PrintFormatItem_ID
-      AND LENGTH(pfi.PrintName)>0  AND(e.PrintName<>AD_PRINTFORMATITEM_TRL.PrintName OR AD_PRINTFORMATITEM_TRL.PrintName IS NULL)
-      AND pf.AD_PrintFormat_ID=pfi.AD_PrintFormat_ID  AND pf.IsForm='N' AND IsTableBased='Y'
-      )
-      AND EXISTS
-      (SELECT *
-      FROM AD_CLIENT
-      WHERE AD_Client_ID=AD_PRINTFORMATITEM_TRL.AD_Client_ID AND IsMultiLingualDocument='Y'
-      )
-      ;
-    v_rowcount:=SQL%ROWCOUNT;
-    DBMS_OUTPUT.PUT_LINE('  rows updated: ' || v_rowcount) ;
-    DBMS_OUTPUT.PUT_LINE('Synchronize PrintFormatItem Trl (Not Multi-Lingual)') ;
-    UPDATE AD_PRINTFORMATITEM_TRL
-      SET PrintName=
-      (SELECT pfi.PrintName
-      FROM AD_PRINTFORMATITEM pfi
-      WHERE pfi.AD_PrintFormatItem_ID=AD_PRINTFORMATITEM_TRL.AD_PrintFormatItem_ID
-      )
-    WHERE EXISTS
-      (SELECT *
-      FROM AD_PRINTFORMATITEM pfi, AD_PRINTFORMAT pf
-      WHERE pfi.AD_PrintFormatItem_ID=AD_PRINTFORMATITEM_TRL.AD_PrintFormatItem_ID
-      AND LENGTH(pfi.PrintName)>0  AND pfi.PrintName<>AD_PRINTFORMATITEM_TRL.PrintName
-      AND pf.AD_PrintFormat_ID=pfi.AD_PrintFormat_ID  AND pf.IsForm='N' AND pf.IsTableBased='Y'
-      )
-      AND EXISTS
-      (SELECT *
-      FROM AD_CLIENT
-      WHERE AD_Client_ID=AD_PRINTFORMATITEM_TRL.AD_Client_ID AND IsMultiLingualDocument='N'
-      )
-      ;
-    v_rowcount:=SQL%ROWCOUNT;
-    DBMS_OUTPUT.PUT_LINE('  rows updated: ' || v_rowcount) ;
-    DBMS_OUTPUT.PUT_LINE('Reset PrintFormatItem Trl where not used in base table') ;
-    UPDATE AD_PRINTFORMATITEM_TRL
-      SET PrintName=NULL
-    WHERE PrintName IS NOT NULL  AND EXISTS
-      (SELECT *
-      FROM AD_PRINTFORMATITEM pfi
-      WHERE pfi.AD_PrintFormatItem_ID=AD_PRINTFORMATITEM_TRL.AD_PrintFormatItem_ID
-      AND(LENGTH(pfi.PrintName)=0 OR pfi.PrintName IS NULL)
-      )
-      ;
-    v_rowcount:=SQL%ROWCOUNT;
-    DBMS_OUTPUT.PUT_LINE('  rows updated: ' || v_rowcount) ;
-    /**
-    SELECT  e.PrintName "Element", pfi.PrintName "FormatItem", trl.AD_Language, trl.PrintName "Trl"
-    FROM  AD_Element e
-    INNER JOIN AD_Column c ON (e.AD_Element_ID=c.AD_Element_ID)
-    INNER JOIN AD_PrintFormatItem pfi ON (c.AD_Column_ID=pfi.AD_Column_ID)
-    INNER JOIN AD_PrintFormatItem_Trl trl ON (pfi.AD_PrintFormatItem_ID=trl.AD_PrintFormatItem_ID)
-    WHERE pfi.AD_PrintFormatItem_ID=:1
-    **/
+    
     -- Sync Names - Window
     DBMS_OUTPUT.PUT_LINE('Synchronizing Menu with Window') ;
     UPDATE AD_MENU
--- a/src-db/database/model/functions/AD_TABLE_IMPORT.xml	Wed Apr 30 10:48:47 2008 +0000
+++ b/src-db/database/model/functions/AD_TABLE_IMPORT.xml	Mon May 05 06:59:24 2008 +0000
@@ -63,6 +63,8 @@
     v_LastColumnName VARCHAR2(40) ;
     v_varchar2 VARCHAR2(32767) ;
     v_FieldLength NUMBER(10) ;
+    v_PInstance_Log_ID NUMBER;
+    v_Client_ID NUMBER;
   BEGIN
     IF(p_PInstance_ID IS NOT NULL) THEN
       --  Update AD_PInstance
@@ -72,7 +74,7 @@
       -- Get Parameters
       v_ResultStr:='ReadingParameters';
       FOR Cur_Parameter IN
-        (SELECT i.Record_ID, i.AD_User_ID, p.ParameterName, p.P_String, p.P_Number, p.P_Date
+        (SELECT i.Record_ID, i.AD_User_ID, p.ParameterName, p.P_String, p.P_Number, p.P_Date, p.AD_CLIENT_ID
         FROM AD_PInstance i
         LEFT JOIN AD_PInstance_Para p
           ON i.AD_PInstance_ID=p.AD_PInstance_ID
@@ -82,6 +84,7 @@
       LOOP
         v_Record_ID:=Cur_Parameter.Record_ID;
         v_AD_User_ID:=Cur_Parameter.AD_User_ID;
+        v_Client_ID:=Cur_Parameter.AD_CLIENT_ID;
       END LOOP; -- Get Parameter
     ELSE
       v_Record_ID:=p_AD_Table_ID;
@@ -98,7 +101,7 @@
     END IF;
     FOR Cur_Column IN
       (SELECT Column_Name, Data_Type, Data_Length, Nullable, AD_Table_ID, -- added by Ismael Ciordia
-        uc.DATA_PRECISION, uc.DATA_SCALE, DATA_DEFAULT, Table_Name, t.EntityType
+        uc.DATA_PRECISION, uc.DATA_SCALE, DATA_DEFAULT, Table_Name
       FROM User_Tab_Columns uc, AD_Table t
       WHERE uc.Table_Name=UPPER(t.TableName) AND NOT EXISTS
         (SELECT *
@@ -216,19 +219,19 @@
         (
           AD_COLUMN_ID, AD_CLIENT_ID, AD_ORG_ID, ISACTIVE,
           CREATED, CREATEDBY, UPDATED, UPDATEDBY,
-          NAME, VERSION, COLUMNNAME, AD_TABLE_ID,
+          NAME, COLUMNNAME, AD_TABLE_ID,
           AD_REFERENCE_ID, FIELDLENGTH, ISKEY, ISPARENT,
           ISMANDATORY, ISIDENTIFIER, SEQNO, ISTRANSLATED,
-          ISENCRYPTED, EntityType, ISUPDATEABLE, AD_REFERENCE_VALUE_ID,
+          ISENCRYPTED, ISUPDATEABLE, AD_REFERENCE_VALUE_ID,
           AD_VAL_RULE_ID, DEFAULTVALUE, ISSESSIONATTR
         )
         VALUES
         (v_NextNo, 0, 0, 'Y',
         now(), 0, now(), 0,
-        v_columnName, 1, v_columnName, Cur_Column.AD_Table_ID,
+        v_columnName, v_columnName, Cur_Column.AD_Table_ID,
         v_AD_Reference_ID, v_FieldLength, v_IsKey, v_IsParent,
        (CASE Cur_Column.Nullable WHEN 'Y' THEN 'N' ELSE 'Y' END),
-        v_IsIdentifier, v_SeqNo, 'N', 'N', Cur_Column.EntityType, v_IsUpdateable, v_AD_Reference_Value_ID, v_AD_Val_Rule_ID, v_DefaultValue, v_IsSessionAttr) ;
+        v_IsIdentifier, v_SeqNo, 'N', 'N', v_IsUpdateable, v_AD_Reference_Value_ID, v_AD_Val_Rule_ID, v_DefaultValue, v_IsSessionAttr) ;
       --
       v_count:=v_count + 1;
       -- Added by Ismael Ciordia
@@ -236,13 +239,14 @@
       v_LastColumnName:=Cur_Column.Column_Name;
       -- Falta: insert de AD_Element
       IF(p_PInstance_ID IS NOT NULL) THEN
+        AD_SEQUENCE_NEXT('AD_PInstance_Log', v_Client_ID, v_PInstance_Log_ID);
         INSERT
         INTO AD_PInstance_Log
           (
             AD_PInstance_ID, Log_ID, P_Msg
           )
           VALUES
-          (p_PInstance_ID, AD_PInstance_Seq.NextVal, '@Created@ @AD_Column_ID@ ' || InitCap(Cur_Column.Table_Name) || '.' || InitCap(Cur_Column.Column_Name)) ;
+          (p_PInstance_ID, v_PInstance_Log_ID, '@Created@ @AD_Column_ID@ ' || InitCap(Cur_Column.Table_Name) || '.' || InitCap(Cur_Column.Column_Name)) ;
       ELSE
         DBMS_OUTPUT.PUT_LINE('adding Table ' || InitCap(Cur_Column.Table_Name) || ' Column ' || InitCap(Cur_Column.Column_Name)) ;
       END IF;
--- a/src-db/database/model/functions/AD_TAB_COPY.xml	Wed Apr 30 10:48:47 2008 +0000
+++ b/src-db/database/model/functions/AD_TAB_COPY.xml	Mon May 05 06:59:24 2008 +0000
@@ -70,7 +70,7 @@
     END LOOP; -- Get Parameter
     DBMS_OUTPUT.PUT_LINE('  Record_ID=' || v_Record_ID) ;
     v_ResultStr:='GetEntityType';
-    SELECT EntityType  INTO v_EntityType  FROM AD_Tab  WHERE AD_Tab_ID=v_Record_ID;
+    
     -- Record_ID is the Tab_ID to copy to
     v_ResultStr:='Copying';
     FOR Cur_Fields IN
@@ -87,8 +87,8 @@
           UpdatedBy, Name, Description, Help,
           IsCentrallyMaintained, AD_Column_ID, AD_FieldGroup_ID, ISDISPLAYED,
           DISPLAYLOGIC, DISPLAYLENGTH, ISREADONLY,
-          SEQNO, SORTNO, ISSAMELINE, ISHEADING,
-          ISFIELDONLY, ISENCRYPTED, EntityType
+          SEQNO, SORTNO, ISSAMELINE,
+          ISFIELDONLY, ISENCRYPTED
         )
         VALUES
         (v_NextNo, v_Record_ID, Cur_Fields.AD_Client_ID, Cur_Fields.AD_Org_ID,
@@ -96,8 +96,8 @@
         0, Cur_Fields.Name, Cur_Fields.Description, Cur_Fields.Help,
         Cur_Fields.IsCentrallyMaintained, Cur_Fields.AD_Column_ID, Cur_Fields.AD_FieldGroup_ID, Cur_Fields.ISDISPLAYED,
         Cur_Fields.DISPLAYLOGIC, Cur_Fields.DISPLAYLENGTH, Cur_Fields.ISREADONLY,
-        Cur_Fields.SEQNO, Cur_Fields.SORTNO, Cur_Fields.ISSAMELINE, Cur_Fields.ISHEADING,
-        Cur_Fields.ISFIELDONLY, Cur_Fields.ISENCRYPTED, v_EntityType) ;
+        Cur_Fields.SEQNO, Cur_Fields.SORTNO, Cur_Fields.ISSAMELINE, 
+        Cur_Fields.ISFIELDONLY, Cur_Fields.ISENCRYPTED) ;
       -- update translation
       UPDATE AD_Field_Trl
         SET Name=
--- a/src-db/database/model/functions/AD_TAB_IMPORT.xml	Wed Apr 30 10:48:47 2008 +0000
+++ b/src-db/database/model/functions/AD_TAB_IMPORT.xml	Mon May 05 06:59:24 2008 +0000
@@ -59,6 +59,8 @@
     v_columnName VARCHAR2(40) ;
     v_LastColumnName VARCHAR2(40) ;
     v_DisplayLength NUMBER(10) ;
+    v_PInstance_Log_ID NUMBER;
+    v_Client_ID NUMBER;
   BEGIN
     IF(p_PInstance_ID IS NOT NULL) THEN
       --  Update AD_PInstance
@@ -68,7 +70,7 @@
       -- Get Parameters
       v_ResultStr:='ReadingParameters';
       FOR Cur_Parameter IN
-        (SELECT i.Record_ID, i.AD_User_ID, p.ParameterName, p.P_String, p.P_Number, p.P_Date
+        (SELECT i.Record_ID, i.AD_User_ID, p.ParameterName, p.P_String, p.P_Number, p.P_Date, p.AD_CLIENT_ID
         FROM AD_PInstance i
         LEFT JOIN AD_PInstance_Para p
           ON i.AD_PInstance_ID=p.AD_PInstance_ID
@@ -78,6 +80,7 @@
       LOOP
         v_Record_ID:=Cur_Parameter.Record_ID;
         v_AD_User_ID:=Cur_Parameter.AD_User_ID;
+        v_Client_ID:=Cur_Parameter.AD_CLIENT_ID;
       END LOOP; -- Get Parameter
     ELSE
       v_Record_ID:=p_AD_Tab_ID;
@@ -89,7 +92,7 @@
     FROM AD_Tab
     WHERE AD_Tab_ID=v_Record_ID  AND AD_Table_ID!=291; -- C_BPartner (multiple tabs)
     FOR Cur_Column IN(-- added by Pablo Sarobe
-    SELECT c.Columnname, c.Name, c.Description, c.AD_Column_ID, c.FieldLength, c.EntityType, t.tablename
+    SELECT c.Columnname, c.Name, c.Description, c.AD_Column_ID, c.FieldLength, t.tablename
     FROM AD_Column c, AD_Table t
     WHERE NOT EXISTS
       (SELECT *
@@ -140,14 +143,14 @@
           ad_field_id, ad_client_id, ad_org_id, isactive,
           created, createdby, updated, updatedby,
           name, description, seqno, AD_Tab_ID,
-          AD_Column_ID, DisplayLength, IsCentrallyMaintained, EntityType,
+          AD_Column_ID, DisplayLength, IsCentrallyMaintained,
           isdisplayed, isreadonly, sortno, issameline, showinrelation
         )
         VALUES
         (v_NextNo, 0, 0, 'Y',
         now(), 0, now(), 0,
         Cur_Column.Name, Cur_Column.Description, v_SeqNo, v_Record_ID,
-        Cur_Column.AD_Column_ID, v_DisplayLength, 'Y', Cur_Column.EntityType,
+        Cur_Column.AD_Column_ID, v_DisplayLength, 'Y', 
         v_isDisplayed, v_isReadOnly, v_sortNo, v_sameLine, v_showInRelation) ;
       --
       v_count:=v_count + 1;
@@ -160,7 +163,7 @@
             AD_PInstance_ID, Log_ID, P_Msg
           )
           VALUES
-          (p_PInstance_ID, AD_PInstance_Seq.NextVal, '@Created@ @AD_Field_ID@ ' || Cur_Column.Name) ;
+          (p_PInstance_ID, v_PInstance_Log_ID, '@Created@ @AD_Field_ID@ ' || Cur_Column.Name) ;
       ELSE
         DBMS_OUTPUT.PUT_LINE(' adding ' || Cur_Column.Name) ;
       END IF;
--- a/src-db/database/model/functions/AD_UPDATE_SEQUENCE.xml	Wed Apr 30 10:48:47 2008 +0000
+++ b/src-db/database/model/functions/AD_UPDATE_SEQUENCE.xml	Mon May 05 06:59:24 2008 +0000
@@ -36,13 +36,13 @@
         IsActive, Created, CreatedBy, Updated, UpdatedBy,
         Name, Description,
         IsAutoSequence, StartNo, IncrementNo, CurrentNextSys, CurrentNext,
-        IsAudited, IsTableID, StartNewYear)
+        IsTableID, StartNewYear)
      VALUES
         (1, 0, 0,
         'Y', now(), 0, now(), 0,
         'AD_Sequence', 'AD_Sequence',
         'Y', 1000000, 1, 2, 0,
-        'N', 'Y', 'N');
+        'Y', 'N');
 
     end if;
 
@@ -88,7 +88,7 @@
         Name, Description,
         IsAutoSequence, IncrementNo, StartNo,
         CurrentNextSys, CurrentNext,
-        IsAudited, IsTableID, StartNewYear)
+        IsTableID, StartNewYear)
      VALUES
         (v_NextNo, 0, 0,
         'Y', now(), 0, now(), 0,
@@ -111,7 +111,7 @@
                  END) AS SEQUENCE
          FROM AD_SEQUENCE
         WHERE UPPER(NAME) = 'AD_SEQUENCE'),
-        'N', 'Y', 'N');
+        'Y', 'N');
     end if;
 
      FOR Cur_Tables IN (
@@ -131,13 +131,13 @@
         IsActive, Created, CreatedBy, Updated, UpdatedBy,
         Name, Description,
         IsAutoSequence, StartNo, IncrementNo, CurrentNextSys, CurrentNext,
-        IsAudited, IsTableID, StartNewYear)
+        IsTableID, StartNewYear)
      VALUES
         (v_NextNo, 0, 0,
         'Y', now(), 0, now(), 0,
         Cur_Tables.TABLENAME, Cur_Tables.TABLENAME,
         'Y', 1000000, 1, 0, 0,
-        'N', 'Y', 'N');
+        'Y', 'N');
    END LOOP;                DELETE FROM AD_SCRIPT_SQL;
    AD_UPDATE_SEQUENCE_GENERATE() ;
    FOR Cur_Script IN
--- a/src-db/database/model/functions/AD_WINDOW_COPY.xml	Wed Apr 30 10:48:47 2008 +0000
+++ b/src-db/database/model/functions/AD_WINDOW_COPY.xml	Mon May 05 06:59:24 2008 +0000
@@ -42,7 +42,6 @@
     v_NextNo_F NUMBER;
     v_NoOfTabs NUMBER:=0;
     v_NoOfFields NUMBER:=0;
-    v_EntityType CHAR(1) ;
     Cur_Tabs RECORD;
     Cur_Fields RECORD;
   BEGIN
@@ -76,10 +75,7 @@
     END LOOP; -- Get Parameter
     DBMS_OUTPUT.PUT_LINE('  Record_ID=' || v_Record_ID) ;
     v_ResultStr:='GetEntityType';
-    SELECT EntityType
-    INTO v_EntityType
-    FROM AD_Window
-    WHERE AD_Window_ID=v_Record_ID;
+    
     -- Record_ID is the Window_ID to copy to
     FOR Cur_Tabs IN
       (SELECT *  FROM AD_Tab  WHERE AD_Window_ID=v_AD_Window_ID)
@@ -95,7 +91,7 @@
           NAME, DESCRIPTION, HELP, AD_TABLE_ID, TabLevel,
           SEQNO, ISSINGLEROW, ISINFOTAB, ISTRANSLATIONTAB, ISREADONLY,
           AD_COLUMN_ID, HASTREE, WHERECLAUSE, ORDERBYCLAUSE, COMMITWARNING,
-          EntityType, AD_PROCESS_ID, PROCESSING
+          AD_PROCESS_ID, PROCESSING
         )
         VALUES
         (
@@ -104,7 +100,7 @@
           Cur_Tabs.NAME, Cur_Tabs.DESCRIPTION, Cur_Tabs.HELP, Cur_Tabs.AD_TABLE_ID, Cur_Tabs.TabLevel,
           Cur_Tabs.SEQNO, Cur_Tabs.ISSINGLEROW, Cur_Tabs.ISINFOTAB, Cur_Tabs.ISTRANSLATIONTAB, Cur_Tabs.ISREADONLY,
           Cur_Tabs.AD_COLUMN_ID, Cur_Tabs.HASTREE, Cur_Tabs.WHERECLAUSE, Cur_Tabs.ORDERBYCLAUSE, Cur_Tabs.COMMITWARNING,
-          v_EntityType, Cur_Tabs.AD_PROCESS_ID, Cur_Tabs.PROCESSING
+          Cur_Tabs.AD_PROCESS_ID, Cur_Tabs.PROCESSING
         )
         ;
       --  Translate
@@ -144,7 +140,7 @@
             AD_Client_ID, AD_Org_ID, IsActive, Created, CreatedBy, Updated, UpdatedBy,
             Name, Description, Help, IsCentrallyMaintained, AD_Column_ID, AD_FieldGroup_ID,
             ISDISPLAYED, DISPLAYLOGIC, DISPLAYLENGTH, ISREADONLY, SEQNO, SORTNO,
-            ISSAMELINE, ISHEADING, ISFIELDONLY, ISENCRYPTED, EntityType
+            ISSAMELINE, ISFIELDONLY, ISENCRYPTED
           )
           VALUES
           (
@@ -152,7 +148,7 @@
             Cur_Fields.AD_Client_ID, Cur_Fields.AD_Org_ID, Cur_Fields.IsActive, now(), 0, now(), 0,
             Cur_Fields.Name, Cur_Fields.Description, Cur_Fields.Help, Cur_Fields.IsCentrallyMaintained, Cur_Fields.AD_Column_ID, Cur_Fields.AD_FieldGroup_ID,
             Cur_Fields.ISDISPLAYED, Cur_Fields.DISPLAYLOGIC, Cur_Fields.DISPLAYLENGTH, Cur_Fields.ISREADONLY, Cur_Fields.SEQNO, Cur_Fields.SORTNO,
-            Cur_Fields.ISSAMELINE, Cur_Fields.ISHEADING, Cur_Fields.ISFIELDONLY, Cur_Fields.ISENCRYPTED, v_EntityType
+            Cur_Fields.ISSAMELINE, Cur_Fields.ISFIELDONLY, Cur_Fields.ISENCRYPTED
           )
           ;
         -- update translation
--- a/src-db/database/model/functions/A_ASSET_CREATE.xml	Wed Apr 30 10:48:47 2008 +0000
+++ b/src-db/database/model/functions/A_ASSET_CREATE.xml	Mon May 05 06:59:24 2008 +0000
@@ -87,7 +87,7 @@
     IF(p_InOutLine_ID IS NOT NULL) THEN
       FOR Cur_ShipLine IN
         (SELECT s.AD_Client_ID, s.AD_Org_ID, s.DocumentNo, s.MovementDate, s.C_BPartner_ID, s.C_BPartner_Location_ID, s.AD_User_ID, bp.Value AS BP_Value, bp.Name AS BP_Name, p.Value, p.Name, p.Description, p.Help, p.VersionNo, pc.A_Asset_Group_ID, CASE WHEN p.GuaranteeDays IS NOT NULL THEN s.MovementDate+p.GuaranteeDays ELSE NULL
-          END AS GuaranteeDate, sl.M_Product_ID, sl.SerNo, sl.Lot, sl.Description AS LineDescription, sl.MovementQty
+          END AS GuaranteeDate, sl.M_Product_ID, sl.Description AS LineDescription, sl.MovementQty
         FROM M_InOut s
         INNER JOIN M_InOutLine sl
           ON(s.M_InOut_ID=sl.M_InOut_ID)
@@ -115,27 +115,15 @@
           INTO A_Asset
             (
               A_Asset_ID, AD_Client_ID, AD_Org_ID, IsActive, Created, CreatedBy, Updated, UpdatedBy,
-              Value, Name, Description, Help, A_Asset_Group_ID, M_Product_ID, SerNo, Lot, VersionNo,
+              Value, Name, Description, Help, A_Asset_Group_ID, M_Product_ID, VersionNo,
               GuaranteeDate, AssetServiceDate, IsOwned, IsDepreciated, AssetDepreciationDate, IsInPosession,
               LocationComment, C_BPartner_ID, C_BPartner_Location_ID, AD_User_ID
             )
             VALUES
             (v_A_Asset_ID, Cur_Shipline.AD_Client_ID, Cur_Shipline.AD_Org_ID, 'Y', now(), 0, now(), 0, SUBSTR(Cur_Shipline.BP_Value, 1, 40-LENGTH(v_Value)) || v_Value, SUBSTR(Cur_Shipline.BP_Name, 1,
             60-LENGTH(v_Name)) || v_Name, SUBSTR(Cur_Shipline.Description || ' ' || Cur_Shipline.LineDescription, 1, 255), Cur_Shipline.Help, Cur_Shipline.A_Asset_Group_ID, Cur_Shipline.M_Product_ID,
-            Cur_Shipline.SerNo, Cur_Shipline.Lot, Cur_Shipline.VersionNo, Cur_Shipline.GuaranteeDate, Cur_Shipline.MovementDate, 'N', 'N', null, 'N', v_DocumentNo, Cur_Shipline.C_BPartner_ID, Cur_Shipline.C_BPartner_Location_ID, Cur_Shipline.AD_User_ID) ;
+            Cur_Shipline.VersionNo, Cur_Shipline.GuaranteeDate, Cur_Shipline.MovementDate, 'N', 'N', null, 'N', v_DocumentNo, Cur_Shipline.C_BPartner_ID, Cur_Shipline.C_BPartner_Location_ID, Cur_Shipline.AD_User_ID) ;
             DBMS_OUTPUT.PUT_LINE('A_Asset_ID=' || v_A_Asset_ID || ' - ' || Cur_Shipline.Value||v_DocumentNo) ;
-          ----
-          v_ResultStr:='InsertingAssetDelivery';
-          AD_Sequence_Next('A_Asset_Delivery', Cur_Shipline.AD_Client_ID, v_A_Asset_Delivery_ID) ;
-          --
-          INSERT
-          INTO A_Asset_Delivery
-            (
-              A_Asset_Delivery_ID, A_Asset_ID, AD_Client_ID, AD_Org_ID, IsActive, Created, CreatedBy, Updated, UpdatedBy, MovementDate, SerNo, Lot, VersionNo, M_InOutLine_ID, AD_User_ID
-            )
-            VALUES
-            (v_A_Asset_Delivery_ID, v_A_Asset_ID, Cur_Shipline.AD_Client_ID, Cur_Shipline.AD_Org_ID, 'Y', now(), 0, now(), 0, Cur_Shipline.MovementDate, Cur_Shipline.SerNo, Cur_Shipline.Lot, Cur_Shipline.VersionNo, p_InOutLine_ID, Cur_Shipline.AD_User_ID) ;
-          DBMS_OUTPUT.PUT_LINE('  Delivery_ID=' || v_A_Asset_Delivery_ID) ;
         END LOOP;
         v_count:=v_count + 1;
 		v_Message:='@Created@: ' || v_count;
--- a/src-db/database/model/functions/A_ASSET_POST.xml	Wed Apr 30 10:48:47 2008 +0000
+++ b/src-db/database/model/functions/A_ASSET_POST.xml	Mon May 05 06:59:24 2008 +0000
@@ -84,6 +84,7 @@
     v_Currency_Pre NUMBER:= 0;
     v_Inserted NUMBER:= 0;
     finish boolean;
+    v_DBA_ErrorLog_ID NUMBER;
   BEGIN
     IF(p_PInstance_ID IS NOT NULL) THEN
       --  Update AD_PInstance
@@ -409,13 +410,14 @@
     DECLARE
       v_Code NUMBER:=SQLCODE;
     BEGIN
+      AD_SEQUENCE_NEXT('DBA_ERRORLOG', v_AD_CLIENT_ID, v_DBA_ErrorLog_ID);
       INSERT
       INTO DBA_ERRORLOG
         (
           DBA_ErrorLog_ID, Created, Code, Msg, Info
         )
         VALUES
-        (DBA_ErrorLog_Seq.NEXTVAL, now(), v_Code, v_ResultStr, 'A_Asset_Post') ;
+        (v_DBA_ErrorLog_ID, now(), v_Code, v_ResultStr, 'A_Asset_Post') ;
     END;
     RAISE;
   END IF;
--- a/src-db/database/model/functions/A_ASSET_POST0.xml	Wed Apr 30 10:48:47 2008 +0000
+++ b/src-db/database/model/functions/A_ASSET_POST0.xml	Mon May 05 06:59:24 2008 +0000
@@ -5,16 +5,21 @@
         <default/>
       </parameter>
       <body><![CDATA[/*************************************************************************
- * The contents of this file are subject to the Compiere License.  You may
- * obtain a copy of the License at    http://www.compiere.org/license.html
- * Software is on an  "AS IS" basis,  WITHOUT WARRANTY OF ANY KIND, either
- * express or implied. See the License for details. Code: Compiere ERP+CPM
- * Copyright (C) 1999-2001 Jorg Janke, ComPiere, Inc. All Rights Reserved.
- *************************************************************************
- * $Id: A_Asset_Post0.sql,v 1.2 2002/10/21 04:49:46 jjanke Exp $
- ***
- * Title:  Post single Invoice
- *************************************************************************/
+* The contents of this file are subject to the Openbravo  Public  License
+* Version  1.0  (the  "License"),  being   the  Mozilla   Public  License
+* Version 1.1  with a permitted attribution clause; you may not  use this
+* file except in compliance with the License. You  may  obtain  a copy of
+* the License at http://www.openbravo.com/legal/license.html
+* Software distributed under the License  is  distributed  on  an "AS IS"
+* basis, WITHOUT WARRANTY OF ANY KIND, either express or implied. See the
+* License for the specific  language  governing  rights  and  limitations
+* under the License.
+* The Original Code is Openbravo ERP.
+* The Initial Developer of the Original Code is Openbravo SL
+* All portions are Copyright (C) 2001-2008 Openbravo SL
+* All Rights Reserved.
+* Contributor(s):  ______________________________________.
+************************************************************************/
 BEGIN
  A_ASSET_POST(p_PInstance_ID, NULL);
 END A_ASSET_POST0
--- a/src-db/database/model/functions/CLEVER_TO_NUMBER.xml	Wed Apr 30 10:48:47 2008 +0000
+++ /dev/null	Thu Jan 01 00:00:00 1970 +0000
@@ -1,33 +0,0 @@
-<?xml version="1.0"?>
-  <database name="FUNCTION CLEVER_TO_NUMBER">
-    <function name="CLEVER_TO_NUMBER" type="NUMERIC">
-      <parameter name="p_text" type="VARCHAR" mode="in">
-        <default/>
-      </parameter>
-      <body><![CDATA[/*************************************************************************
-* The contents of this file are subject to the Openbravo  Public  License
-* Version  1.0  (the  "License"),  being   the  Mozilla   Public  License
-* Version 1.1  with a permitted attribution clause; you may not  use this
-* file except in compliance with the License. You  may  obtain  a copy of
-* the License at http://www.openbravo.com/legal/license.html
-* Software distributed under the License  is  distributed  on  an "AS IS"
-* basis, WITHOUT WARRANTY OF ANY KIND, either express or implied. See the
-* License for the specific  language  governing  rights  and  limitations
-* under the License.
-* The Original Code is Openbravo ERP.
-* The Initial Developer of the Original Code is Openbravo SL
-* All portions are Copyright (C) 2001-2006 Openbravo SL
-* All Rights Reserved.
-* Contributor(s):  ______________________________________.
-************************************************************************/
-  v_number NUMBER;
-BEGIN
-  v_number:=TO_NUMBER(p_text) ;
-  RETURN v_number;
-EXCEPTION
-WHEN OTHERS THEN
-  RETURN NULL;
-END CLEVER_TO_NUMBER
-]]></body>
-    </function>
-  </database>
--- a/src-db/database/model/functions/COPY_PRODUCT_TEMPLATE.xml	Wed Apr 30 10:48:47 2008 +0000
+++ b/src-db/database/model/functions/COPY_PRODUCT_TEMPLATE.xml	Mon May 05 06:59:24 2008 +0000
@@ -141,7 +141,7 @@
           QTYINVOICED, M_SHIPPER_ID, C_CURRENCY_ID, PRICELIST,
           PRICEACTUAL, PRICELIMIT, LINENETAMT, DISCOUNT,
           FREIGHTAMT, C_CHARGE_ID, CHARGEAMT, C_TAX_ID,
-          LOT, SERNO, S_RESOURCEASSIGNMENT_ID, REF_ORDERLINE_ID,
+          S_RESOURCEASSIGNMENT_ID, REF_ORDERLINE_ID,
           M_ATTRIBUTESETINSTANCE_ID, ISDESCRIPTION, QUANTITYORDER, M_PRODUCT_UOM_ID,
           PriceStd
         )
@@ -156,7 +156,7 @@
           0, NULL, v_Currency, v_Pricelist,
           M_Get_Offers_Price(now(), v_Bpartner, Cur_ProductTemplate.M_Product_ID, v_Pricestd, Cur_ProductTemplate.QTY, v_Mpricelist), v_Pricelimit, v_Linenetamount, v_Discount,
           0, NULL, 0, v_tax,
-          NULL, NULL, NULL, NULL,
+          NULL, NULL,
           NULL, 'N', NULL, NULL,
           v_Pricestd
         )
--- a/src-db/database/model/functions/C_BPARTNER_REMITLOCATION.xml	Wed Apr 30 10:48:47 2008 +0000
+++ /dev/null	Thu Jan 01 00:00:00 1970 +0000
@@ -1,53 +0,0 @@
-<?xml version="1.0"?>
-  <database name="FUNCTION C_BPARTNER_REMITLOCATION">
-    <function name="C_BPARTNER_REMITLOCATION" type="NUMERIC">
-      <parameter name="p_c_bpartner_id" type="NUMERIC" mode="in">
-        <default/>
-      </parameter>
-      <body><![CDATA[/*************************************************************************
-* The contents of this file are subject to the Compiere Public
-* License 1.1 ("License"); You may not use this file except in
-* compliance with the License. You may obtain a copy of the License in
-* the legal folder of your Openbravo installation.
-* Software distributed under the License is distributed on an
-* "AS IS" basis, WITHOUT WARRANTY OF ANY KIND, either express or
-* implied. See the License for the specific language governing rights
-* and limitations under the License.
-* The Original Code is  Compiere  ERP &  Business Solution
-* The Initial Developer of the Original Code is Jorg Janke and ComPiere, Inc.
-* Portions created by Jorg Janke are Copyright (C) 1999-2001 Jorg Janke,
-* parts created by ComPiere are Copyright (C) ComPiere, Inc.;
-* All Rights Reserved.
-* Contributor(s): Openbravo SL
-* Contributions are Copyright (C) 2001-2008 Openbravo, S.L.
-*
-* Specifically, this derivative work is based upon the following Compiere
-* file and version.
-*************************************************************************
-* $Id: C_BPartner_RemitLocation.SQL,v 1.2 2003/02/20 06:42:12 jjanke Exp $
-***
-* Title:   Return the first RemitTo C_Location_ID of a Business Partner
-* Description:
-*
-************************************************************************/
-  v_C_Location_ID NUMBER:=NULL;
-  TYPE RECORD IS REF CURSOR;
-    CUR_BPLoc RECORD;
-BEGIN
-    FOR CUR_BPLoc IN
-      (SELECT IsRemitTo,
-        C_Location_ID
-      FROM C_BPartner_Location
-      WHERE C_BPartner_ID=p_C_BPartner_ID
-      ORDER BY IsRemitTo DESC
-      )
-    LOOP
-      IF(v_C_Location_ID IS NULL) THEN
-        v_C_Location_ID:=CUR_BPLoc.C_Location_ID;
-      END IF;
-    END LOOP;
-    RETURN v_C_Location_ID;
-END C_BPARTNER_REMITLOCATION
-]]></body>
-    </function>
-  </database>
--- a/src-db/database/model/functions/C_COMMISSIONRUN_PROCESS.xml	Wed Apr 30 10:48:47 2008 +0000
+++ b/src-db/database/model/functions/C_COMMISSIONRUN_PROCESS.xml	Mon May 05 06:59:24 2008 +0000
@@ -31,7 +31,6 @@
   CUR_ComRun RECORD;
  --
  v_C_DocType_ID     NUMBER;
- v_Approved      CHAR(1);
  v_C_Invoice_ID     NUMBER;
  v_NextNo      NUMBER;
  v_DocumentNo     VARCHAR2(40);
@@ -81,11 +80,6 @@
    */
    v_ResultStr := 'GetDocTypeInfo';
   v_C_DocType_ID := Ad_Get_DocType(CUR_ComRun.AD_Client_ID,CUR_ComRun.AD_Org_ID, 'API');
-  SELECT (CASE IsApproved WHEN 'Y' THEN 'N' ELSE 'Y' END)
-    INTO v_Approved
-  FROM C_DOCTYPE
-  WHERE C_DocType_ID = v_C_DocType_ID;
-  --
 
     DECLARE
       Cur_Data RECORD;
@@ -148,7 +142,7 @@
    AD_Client_ID, AD_Org_ID, IsActive, Created, CreatedBy, Updated, UpdatedBy,
    IsSOTrx, DocumentNo, DocStatus, DocAction, Processing, Processed,
    C_DocType_ID, C_DocTypeTarget_ID, Description,
-   IsApproved, IsTransferred, SalesRep_ID,
+   SalesRep_ID,
    DateInvoiced, DatePrinted, IsPrinted, DateAcct,
    C_PaymentTerm_ID, C_BPartner_ID, C_BPartner_Location_ID, AD_User_ID,
    POReference, DateOrdered, IsDiscountPrinted,
@@ -160,7 +154,7 @@
    CUR_ComRun.AD_Client_ID, CUR_ComRun.AD_Org_ID, 'Y', now(), 0, now(), 0,
    'N', v_Docume