Projects:Code Cleanup/Technical Documentation
Contents |
Scope
The purpose of this project is to remove from the application unused code. The code to be removed is:
- TypeAheadCombo javascript code.
- Deprecated DB elements Including the deprecated tables and columns and all their related objects.
- Custom Code DB elements These elements will be treated as deprecated ones, from now on these elements will be maintained in each customization using them.
Code removal
Type Ahead Combo
DB elements
There are 108 deprecated tables which are going to be removed. Within non-deprecated tables there are 161 columns to be removed.
Removal planning
Deprecated DB elements are going to be completely removed from Database System Catalog, Openbravo's Application Dictionary and Non DB code following this planning step by step:
- Tables
- DB System Catalog
- Foreign keys to deprecated tables from non-deprecated ones. Note that columns involved in these keys should ALL be deprecated.
- Dependant PL objects. Depending on the case the object will be removed or redone avoiding the usage of the table.
- Tables
- Other unused PL: AD_COLUMN_SYNC, AD_APPLICATION_IMPORT, XX_COLUMNIDENTIFIER, INSERTAT, DBA_COLUMN_DEFAULT, DBA_COLUMN_SCRIPT, DBA_VIEW_BODY
- Openbravo's Application Dictionary
- Fields for deprecated tabs
- Tabs for deprecated tables.
- Columns for deprecated fields.
- Tables.
- Menu entries for windows which only contained deprecated tabs.
- Windows that only contained deprecated tables.
- Processes of PL type which are pointing to dependent PL code that has been decided to be removed.
- DB System Catalog
- Columns in non-deprecated tables
- DB System Catalog
- Look in the PL code where these columns are used (how?) and redo the avoiding its usage.
- Remove columns
- Openbravo's Application Dictionary
- Fields
- Columns
- Non used references
- Elements ?
- Check in dynamic SQL clauses (execute immediate) for the usage of deprecated elements.
- DB System Catalog
- Non-DB code
- Type ahead combo
- Look for ad_forms, ad_process... for code that was made for deprecated elements management, in this case it should be removed (also from the menu).
- Remove callouts used only in removed tabs or by removed columns.
- Redo xsql using removed elements
Appendixes
Deprecated tables
This is the list of the 108 deprecated tables.
AD_Attribute AD_Attribute_Value AD_Color AD_Desktop AD_DesktopWorkbench AD_Desktop_Trl AD_Error AD_Find AD_PrintColor AD_PrintFont AD_PrintForm AD_PrintFormat AD_PrintFormatItem AD_PrintFormatItem_Trl AD_PrintGraph AD_PrintLabel AD_PrintLabelLine AD_PrintLabelLine_Trl AD_PrintPaper AD_PrintTableFormat AD_Replication AD_ReplicationStrategy AD_ReplicationTable AD_Replication_Log AD_Replication_Run AD_ReportView AD_ReportView_Col AD_Sequence_Audit AD_Sequence_No AD_TaskInstance AD_Trace AD_UserDef_Field AD_UserDef_Tab AD_UserDef_Win AD_WF_Instance AD_Workbench AD_WorkbenchWindow AD_Workbench_Trl A_Asset_Delivery A_Asset_Retirement A_Depreciation C_Approval C_BP_EDI C_BP_Withholding C_BankAccountDoc C_CostType C_Cycle C_CyclePhase C_CycleStep C_DocType_Copy C_DocType_Copy_Trl C_Dunning C_DunningLevel C_DunningLevel_Trl C_DunningRun C_DunningRunEntry C_InvoicePaySchedule C_PaySchedule C_Withholding C_Withholding_Acct Fact_Acct_Balance GL_Budget I_ReportLine K_Category K_CategoryValue K_Comment K_Entry K_EntryCategory K_EntryRelated K_Source K_Synonym K_Topic K_Type MA_CalcStd MA_ConsumeProduct MA_ConsumeRM MA_DefaultPlan MA_ProductType MA_SequenceProduct_Cost MA_WETechnicalSupport M_AttributeSearch M_DiscountSchemaBreak M_EDI M_EDI_Info M_InOutLine_Type M_Locator_Renting M_Product_Costing PA_Achievement PA_Color PA_Goal PA_Measure PA_MeasureCalc PA_Report PA_ReportColumn PA_ReportColumnSet PA_ReportLine PA_ReportLineSet PA_ReportSource S_Training S_Training_Class TIRE_Storage W_Advertisement W_Basket W_BasketLine W_Click W_ClickCount W_Counter W_CounterCount
Deprecated columns
Additionally to all the columns included in the deprecated tables, there are 161 columns which belong to non-deprecated tables but are deprecated.
AD_Client.DocumentDir AD_Client.WebDir AD_Client.WebInfo AD_Client.WebOrderEMail AD_Client.WebParam1 AD_Client.WebParam2 AD_Client.WebParam3 AD_Client.WebParam4 AD_Client.WebParam5 AD_Client.WebParam6 AD_ClientInfo.PA_Goal_ID AD_Column.EntityType AD_Column.Version AD_Element.EntityType AD_Field.EntityType AD_Field.IsHeading AD_Form.EntityType AD_Menu.AD_Workbench_ID AD_Menu.EntityType AD_Menu.IsReadOnly AD_Menu.IsSOTrx AD_Message.EntityType AD_Model_Object.AD_Workbench_ID AD_Org.UPC AD_OrgInfo.PA_Goal_ID AD_Process.AD_PrintFormat_ID AD_Process.AD_ReportView_ID AD_Process.Classname AD_Process.EntityType AD_Process.Statistic_Count AD_Process.Statistic_Seconds AD_Process_Para.EntityType AD_Ref_List.EntityType AD_Ref_Table.EntityType AD_Reference.EntityType AD_Sequence.IsAudited AD_System.IDRangeEnd AD_System.IDRangeStart AD_System.Password AD_System.ReplicationType AD_System.SupportUnits AD_System.UserName AD_Tab.EntityType AD_Table.AD_Val_Rule_ID AD_Table.EntityType AD_Table.LoadSeq AD_Table.ReplicationType AD_Task.EntityType AD_User.PA_GoalPrivate_ID AD_User.PA_Goal_ID AD_Val_Rule.EntityType AD_WF_Node.EntityType AD_Window.AD_Color_ID AD_Window.EntityType AD_Workflow.EntityType A_Asset.Cause C_BP_BankAccount.C_Bank_ID C_BP_BankAccount.CreditCardVV C_BP_BankAccount.IsACH C_BP_BankAccount.R_AvsAddr C_BPartner.C_Dunning_ID C_BPartner.FreightCostRule C_BPartner.Invoice_PrintFormat_ID C_BPartner.Ismanager C_BPartner.M_DiscountSchema_ID C_BPartner.M_WH_Schedule_ID C_BPartner.Managers C_BPartner.PO_DiscountSchema_ID C_BPartner.STORAGEPAYMENTRULE C_BPartner.SendEMail C_BPartner_Location.ISDN C_BPartner_Location.UPC C_BankAccount.AccountNo C_BankAccount.StmtProcessorClass C_BankStatementLine.IsReversal C_Currency.EMUEntryDate C_Currency.EMURate C_Currency.IsEMUMember C_Currency.IsEuro C_DocType.AD_PrintFormat_ID C_DocType.BatchNoSequence_ID C_DocType.C_Approval_ID C_DocType.C_DocTypeProforma_ID C_DocType.CreatePicklist C_DocType.HasCharges C_DocType.HasProforma C_DocType.IsApproved C_DocType.IsBatchControlEnforced C_DocType.IsBatchDocNoControlled C_DocType.IsBatched C_DocType.IsPrinted C_DocType.IsTransferred C_DocType.Ismaxtable C_Invoice.IsApproved C_Invoice.IsPaid C_Invoice.IsTransferred C_Invoice.SendEMail C_InvoiceLine.A_Asset_ID C_Order.IsApproved C_Order.IsCreditApproved C_Order.IsTransferred C_Order.SendEMail C_OrderLine.Lastpriceso C_OrderLine.Lot C_OrderLine.SerNo C_PaymentTerm.AfterDelivery C_PaymentTerm.Discount C_PaymentTerm.Discount2 C_PaymentTerm.DiscountDays C_PaymentTerm.DiscountDays2 C_PaymentTerm.FixMonthCutoff C_PaymentTerm.GraceDays C_Tax.IsDocumentLevel C_Tax.Isprinttax C_Tax.RequiresTaxCertificate C_TaxCategory.CommodityCode Fact_Acct.GL_Budget_ID GL_Journal.GL_Budget_ID I_Order.FreightAmt MA_CCP_Group.Hassecproduct MA_Measure_Group.Hassecproduct MA_Measure_Group.Product MA_Measure_Shift.Lot MA_Measure_Shift.Product MA_Measure_Shift.Sellbydate MA_PL_Employee.Costuom MA_Process.MA_Cc_Idprep MA_Process.MA_Cc_Idwork MA_SequenceProduct.Consumerm MA_SequenceProduct.Decreaseind MA_SequenceProduct.Rminput MA_WRPhaseProduct.Consumerm MA_WRPhaseProduct.Decreaseind MA_WorkRequirement.WrType MRP_Run_Purchase.Recalculatestock M_Attribute.M_AttributeSearch_ID M_InOut.SendEMail M_InOutLine.Lot M_InOutLine.M_Inoutline_Type_ID M_InOutLine.SerNo M_Locator.Invoicingtype M_Locator.M_Locator_Type_ID M_Locator.SizeMultiplier M_Product.Bundle_Uom M_Product.C_RevenueRecognition_ID M_Product.Greenpoint_Uom M_Product.MA_Producttype_ID M_Product.R_MailText_ID M_Product.Upc2 M_ProductionLine.PrintLabel M_ProductionLine.Secquality M_ProductionPlan.Realcost M_RequisitionLine.C_Order_ID M_RequisitionLine.Dateplanned M_Shipper.TrackingURL M_Warehouse.LocatorUnitsPerPallet M_Warehouse.Warehouse_Size RV_Asset_Delivery.A_Asset_Delivery_ID R_InterestArea.IsSelfService S_TimeExpense.IsApproved T_Report.PA_ReportLine_ID