Projects:Code Cleanup/Technical Documentation

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:

1. Tables
   1. DB System Catalog
      1. Foreign keys to deprecated tables from non-deprecated ones. Note that columns involved in these keys should ALL be deprecated.
      2. Dependant PL objects. Depending on the case the object will be removed or redone avoiding the usage of the table.
      3. Tables
      4. Other unused PL: AD_COLUMN_SYNC, AD_APPLICATION_IMPORT, XX_COLUMNIDENTIFIER, INSERTAT, DBA_COLUMN_DEFAULT, DBA_COLUMN_SCRIPT, DBA_VIEW_BODY
   2. Openbravo's Application Dictionary
      1. Fields for deprecated tabs
      2. Tabs for deprecated tables.
      3. Columns for deprecated fields.
      4. Tables.
      5. Menu entries for windows which only contained deprecated tabs.
      6. Windows that only contained deprecated tables.
      7. Processes of PL type which are pointing to dependent PL code that has been decided to be removed.
2. Columns in non-deprecated tables
   1. DB System Catalog
      1. Look in the PL code where these columns are used (how?) and redo the avoiding its usage.
      2. Remove columns
   2. Openbravo's Application Dictionary
      1. Fields
      2. Columns
      3. Non used references
      4. Elements ?
      5. Check in dynamic SQL clauses (execute immediate) for the usage of deprecated elements.
3. Non-DB code
   1. Type ahead combo
   2. 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).
   3. Remove callouts used only in removed tabs or by removed columns.
   4. 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