2014年6月7日 星期六

iDempiere 中文對照返回

update adempiere.AD_Message_Trl t set msgtext = f.msgtext FROM adempiere.AD_Message f WHERE f.AD_Message_ID=t.AD_Message_ID

update adempiere.AD_Table_Trl      t set name = f.name FROM adempiere.AD_Table f WHERE f.AD_Table_ID     =t.AD_Table_ID

update adempiere.PP_Order_BOM_Trl  t set name = f.name FROM adempiere.PP_Order_BOM f WHERE f.PP_Order_BOM_ID =t.PP_Order_BOM_ID

--update adempiere.AD_PrintColor_Trl t set name = f.name FROM adempiere.AD_PrintColor f WHERE f.AD_PrintColor_ID=t.AD_PrintColor_ID

--update adempiere.C_Region_Trl      t set name = f.name FROM adempiere.C_Region f WHERE f.C_Region_ID     =t.C_Region_ID

--update adempiere.M_PriceList_Trl   t set name = f.name FROM adempiere.M_PriceList f WHERE f.M_PriceList_ID  =t.M_PriceList_ID

update adempiere.AD_Menu_Trl         t set name = f.name FROM adempiere.AD_Menu f WHERE f.AD_Menu_ID      =t.AD_Menu_ID

update adempiere.AD_Column_Trl       t set name = f.name FROM adempiere.AD_Column f WHERE f.AD_Column_ID    =t.AD_Column_ID

update adempiere.AD_Ref_List_Trl     t set name = f.name FROM adempiere.AD_Ref_List f WHERE f.AD_Ref_List_ID  =t.AD_Ref_List_ID

update adempiere.AD_Workbench_Trl    t set name = f.name FROM adempiere.AD_Workbench f WHERE f.AD_Workbench_ID =t.AD_Workbench_ID

update adempiere.AD_FieldGroup_Trl   t set name = f.name FROM adempiere.AD_FieldGroup f WHERE f.AD_FieldGroup_ID=t.AD_FieldGroup_ID

update adempiere.C_ElementValue_Trl  t set name = f.name FROM adempiere.C_ElementValue f WHERE f.C_ElementValue_ID  =t.C_ElementValue_ID

--update adempiere.GL_Category_Trl     t set name = f.name FROM adempiere.GL_Category f WHERE f.GL_Category_ID  =t.GL_Category_ID

--update adempiere.M_Product_Category_Trl     t set name = f.name FROM adempiere.M_Product_Category f WHERE f.M_Product_Category_ID  =t.M_Product_Category_ID

update adempiere.AD_Form_Trl     t set name = f.name FROM adempiere.AD_Form f WHERE f.AD_Form_ID  =t.AD_Form_ID

update adempiere.C_Tax_Trl       t set name = f.name FROM adempiere.C_Tax f WHERE f.C_Tax_ID    =t.C_Tax_ID

update adempiere.AD_Desktop_Trl  t set name = f.name FROM adempiere.AD_Desktop f WHERE f.AD_Desktop_ID  =t.AD_Desktop_ID

--update adempiere.AD_Color_Trl     t set name = f.name FROM adempiere.AD_Color f WHERE f.AD_Color_ID  =t.AD_Color_ID

--update adempiere.AD_PrintLabelLine_Trl     t set name = f.name FROM adempiere.AD_PrintLabelLine f WHERE f.AD_PrintLabelLine_ID  =t.AD_PrintLabelLine_ID

update adempiere.C_Country_Trl     t set name = f.name FROM adempiere.C_Country f WHERE f.C_Country_ID  =t.C_Country_ID

update adempiere.AD_Field_Trl      t set name = f.name FROM adempiere.AD_Field f WHERE f.AD_Field_ID  =t.AD_Field_ID

update adempiere.CM_CStage_Trl      t set name = f.name FROM adempiere.CM_CStage f WHERE f.CM_CStage_ID  =t.CM_CStage_ID

--update adempiere.W_Store_Trl      t set name = f.name FROM adempiere.W_Store f WHERE f.W_Store_ID  =t.W_Store_ID

update adempiere.CM_Container_Element_Trl  t set name = f.name FROM adempiere.CM_Container_Element f WHERE f.CM_Container_Element_ID  =t.CM_Container_Element_ID

update adempiere.AD_InfoColumn_Trl         t set name = f.name FROM adempiere.AD_InfoColumn f WHERE f.AD_InfoColumn_ID  =t.AD_InfoColumn_ID

update adempiere.R_MailText_Trl            t set name = f.name FROM adempiere.R_MailText f WHERE f.R_MailText_ID  =t.R_MailText_ID

update adempiere.PP_Order_Workflow_Trl

--update adempiere.C_SalesRegion_Trl  t set name = f.name FROM adempiere.C_SalesRegion f WHERE f.C_SalesRegion_ID  =t.C_SalesRegion_ID

update adempiere.C_PaymentTerm_Trl  t set name = f.name FROM adempiere.C_PaymentTerm f WHERE f.C_PaymentTerm_ID  =t.C_PaymentTerm_ID

update adempiere.C_Greeting_Trl     t set name = f.name FROM adempiere.C_Greeting f WHERE f.C_Greeting_ID     =t.C_Greeting_ID

update adempiere.C_Charge_Trl       t set name = f.name FROM adempiere.C_Charge f WHERE f.C_Charge_ID       =t.C_Charge_ID

update adempiere.PP_Product_BOMLine_Trl

update adempiere.PP_Product_BOM_Trl

update adempiere.PP_Order_BOMLine_Trl

"PP_Order_Node_Trl"

"AD_Workflow_Trl"

"PA_DashboardContent_Trl"

"C_Campaign_Trl"

"M_Product_Trl"

update adempiere.C_DocType_Trl          t set name = f.name FROM adempiere.C_DocType f WHERE f.C_DocType_ID       =t.C_DocType_ID

update adempiere.AD_Task_Trl            t set name = f.name FROM adempiere.AD_Task f WHERE f.AD_Task_ID       =t.AD_Task_ID

update adempiere.AD_Process_Para_Trl    t set name = f.name FROM adempiere.AD_Process_Para f WHERE f.AD_Process_Para_ID       =t.AD_Process_Para_ID

update adempiere.AD_WF_Node_Trl         t set name = f.name FROM adempiere.AD_WF_Node f WHERE f.AD_WF_Node_ID       =t.AD_WF_Node_ID

update adempiere.AD_Window_Trl         t set name = f.name FROM adempiere.AD_Window f WHERE f.AD_Window_ID       =t.AD_Window_ID

"M_PriceList_Version_Trl"

update adempiere.AD_Tab_Trl    t set name = f.name FROM adempiere.AD_Tab f WHERE f.AD_Tab_ID       =t.AD_Tab_ID

update adempiere.AD_PrintFormatItem_Trl  t set name = f.name FROM adempiere.AD_PrintFormatItem f WHERE f.AD_PrintFormatItem_ID       =t.AD_PrintFormatItem_ID

update adempiere.C_TaxCategory_Trl    t set name = f.name FROM adempiere.C_TaxCategory f WHERE f.C_TaxCategory_ID       =t.C_TaxCategory_ID

--update adempiere.C_DunningLevel_Trl    t set name = f.name FROM adempiere.C_DunningLevel f WHERE f.C_DunningLevel_ID       =t.C_DunningLevel_ID

update adempiere.AD_Reference_Trl  t set name = f.name FROM adempiere.AD_Reference f WHERE f.AD_Reference_ID       =t.AD_Reference_ID

update adempiere.AD_Process_Trl    t set name = f.name FROM adempiere.AD_Process f WHERE f.AD_Process_ID       =t.AD_Process_ID

update adempiere.AD_Element_Trl    t set name = f.name FROM adempiere.AD_Element f WHERE f.AD_Element_ID       =t.AD_Element_ID

"CM_CStage_Element_Trl"

"AD_InfoWindow_Trl"

"CM_Container_Trl"

"W_MailMsg_Trl"

"C_Activity_Trl"

"A_Asset_Group_Trl"

--update adempiere.C_Currency_Trl t set name = f.name FROM adempiere.C_Currency f WHERE f.C_Currency_ID  =t.C_Currency_ID

"C_UOM_Trl"

"AD_BroadcastMessage_Trl"

"AD_CtxHelpMsg_Trl"

"AD_Chart_Trl"

"C_SalesStage_Trl"

沒有留言:

張貼留言