iDempiere 中文自動轉譯ˋ比對






update adempiere.AD_Message_Trl t set msgtext = f.msgtext
FROM newtai.AD_Message_Trl f ,newtai.AD_Message o
WHERE f.AD_Message_ID=t.AD_Message_ID
  AND f.AD_Language='zh_TW' AND t.AD_Language='zh_TW'
  AND f.AD_Message_ID=o.AD_Message_ID
  AND o.msgtext=t.msgtext

update adempiere.AD_Table_Trl t set name = f.name
FROM newtai.AD_Table_Trl f,newtai.AD_Table_Trl o
WHERE f.AD_Table_ID     =t.AD_Table_ID
  AND f.AD_Language='zh_TW' AND t.AD_Language='zh_TW'
  AND f.AD_Table_ID=o.AD_Table_ID
  AND o.name=t.name


update adempiere.PP_Order_BOM_Trl  t set name = f.name
FROM newtai.PP_Order_BOM_Trl  f ,newtai.PP_Order_BOM o
WHERE f.PP_Order_BOM_ID =t.PP_Order_BOM_ID
  AND f.AD_Language='zh_TW' AND t.AD_Language='zh_TW'
  AND f.PP_Order_BOM_ID=o.PP_Order_BOM_ID
  AND o.name=t.name

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

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

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

update adempiere.AD_Menu_Trl t set name = f.name
FROM newtai.AD_Menu_Trl f ,newtai.AD_Menu o
WHERE f.AD_Menu_ID      =t.AD_Menu_ID
  AND f.AD_Language='zh_TW' AND t.AD_Language='zh_TW'
  AND f.AD_Menu_ID      =o.AD_Menu_ID
  AND o.name=t.name

update adempiere.AD_Column_Trl t set name = f.name
FROM newtai.AD_Column_Trl f ,newtai.AD_Column o
WHERE f.AD_Column_ID    =t.AD_Column_ID
  AND f.AD_Language='zh_TW' AND t.AD_Language='zh_TW'
  AND f.AD_Column_ID      =o.AD_Column_ID
  AND o.name=t.name

update adempiere.AD_Ref_List_Trl     t set name = f.name
FROM newtai.AD_Ref_List_Trl   f ,newtai.AD_Ref_List o
WHERE f.AD_Ref_List_ID  =t.AD_Ref_List_ID
  AND f.AD_Language='zh_TW' AND t.AD_Language='zh_TW'
  AND f.AD_Ref_List_ID =o.AD_Ref_List_ID
  AND o.name=t.name

update adempiere.AD_Workbench_Trl    t set name = f.name
FROM newtai.AD_Workbench_Trl  f ,newtai.AD_Workbench o
WHERE f.AD_Workbench_ID =t.AD_Workbench_ID
  AND f.AD_Language='zh_TW' AND t.AD_Language='zh_TW'
  AND f.AD_Workbench_ID =o.AD_Workbench_ID
  AND o.name=t.name

update adempiere.AD_FieldGroup_Trl   t set name = f.name
FROM newtai.AD_FieldGroup_Trl f ,newtai.AD_FieldGroup o
WHERE f.AD_FieldGroup_ID=t.AD_FieldGroup_ID
  AND f.AD_Language='zh_TW' AND t.AD_Language='zh_TW'
  AND f.AD_FieldGroup_ID =o.AD_FieldGroup_ID
  AND o.name=t.name

update adempiere.C_ElementValue_Trl  t set name = f.name
FROM newtai.C_ElementValue_Trl f ,newtai.C_ElementValue o
WHERE f.C_ElementValue_ID  =t.C_ElementValue_ID
  AND f.AD_Language='zh_TW' AND t.AD_Language='zh_TW'
  AND f.C_ElementValue_ID =o.C_ElementValue_ID
  AND o.name=t.name

--update adempiere.GL_Category_Trl     t set name = f.name FROM newtai.GL_Category_Trl   f WHERE f.GL_Category_ID  =t.GL_Category_ID
--update adempiere.M_Product_Category_Trl     t set name = f.name FROM newtai.M_Product_Category_Trl   f WHERE f.M_Product_Category_ID  =t.M_Product_Category_ID

update adempiere.AD_Form_Trl     t set name = f.name
FROM newtai.AD_Form_Trl    f ,newtai.AD_Form o
WHERE f.AD_Form_ID  =t.AD_Form_ID
  AND f.AD_Language='zh_TW' AND t.AD_Language='zh_TW'
  AND f.AD_Form_ID =o.AD_Form_ID
  AND o.name=t.name

update adempiere.C_Tax_Trl       t set name = f.name
FROM newtai.C_Tax_Trl f ,newtai.C_Tax o
WHERE f.C_Tax_ID    =t.C_Tax_ID
  AND f.AD_Language='zh_TW' AND t.AD_Language='zh_TW'
  AND f.C_Tax_ID =o.C_Tax_ID
  AND o.name=t.name

update adempiere.AD_Desktop_Trl  t set name = f.name
FROM newtai.AD_Desktop_Trl f ,newtai.AD_Desktop o
WHERE f.AD_Desktop_ID  =t.AD_Desktop_ID
  AND f.AD_Language='zh_TW' AND t.AD_Language='zh_TW'
  AND f.AD_Desktop_ID =o.AD_Desktop_ID
  AND o.name=t.name

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

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

update adempiere.C_Country_Trl     t set name = f.name
FROM newtai.C_Country_Trl   f ,newtai.C_Country o
WHERE f.C_Country_ID  =t.C_Country_ID
  AND f.AD_Language='zh_TW' AND t.AD_Language='zh_TW'
  AND f.C_Country_ID =o.C_Country_ID
  AND o.name=t.name

update adempiere.AD_Field_Trl      t set name = f.name
FROM newtai.AD_Field_Trl   f ,newtai.AD_Field o
WHERE f.AD_Field_ID  =t.AD_Field_ID
  AND f.AD_Language='zh_TW' AND t.AD_Language='zh_TW'
  AND f.AD_Field_ID =o.AD_Field_ID
  AND o.name=t.name

update adempiere.CM_CStage_Trl      t set name = f.name
FROM newtai.CM_CStage_Trl   f ,newtai.CM_CStage o
WHERE f.CM_CStage_ID  =t.CM_CStage_ID
  AND f.AD_Language='zh_TW' AND t.AD_Language='zh_TW'
  AND f.CM_CStage_ID =o.CM_CStage_ID
  AND o.name=t.name

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

update adempiere.CM_Container_Element_Trl  t set name = f.name
FROM newtai.CM_Container_Element_Trl   f ,newtai.CM_Container_Element o
WHERE f.CM_Container_Element_ID  =t.CM_Container_Element_ID
  AND f.AD_Language='zh_TW' AND t.AD_Language='zh_TW'
  AND f.CM_Container_Element_ID =o.CM_Container_Element_ID
  AND o.name=t.name

update adempiere.AD_InfoColumn_Trl         t set name = f.name
FROM newtai.AD_InfoColumn_Trl   f ,newtai.AD_InfoColumn o
WHERE f.AD_InfoColumn_ID  =t.AD_InfoColumn_ID
  AND f.AD_Language='zh_TW' AND t.AD_Language='zh_TW'
  AND f.AD_InfoColumn_ID =o.AD_InfoColumn_ID
  AND o.name=t.name

update adempiere.R_MailText_Trl            t set name = f.name
FROM newtai.R_MailText_Trl      f ,newtai.R_MailText o
WHERE f.R_MailText_ID  =t.R_MailText_ID
  AND f.AD_Language='zh_TW' AND t.AD_Language='zh_TW'
  AND f.R_MailText_ID =o.R_MailText_ID
  AND o.name=t.name

update adempiere.PP_Order_Workflow_Trl

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

update adempiere.C_PaymentTerm_Trl  t set name = f.name
FROM newtai.C_PaymentTerm_Trl   f ,newtai.C_PaymentTerm o
WHERE f.C_PaymentTerm_ID  =t.C_PaymentTerm_ID
  AND f.AD_Language='zh_TW' AND t.AD_Language='zh_TW'
  AND f.C_PaymentTerm_ID =o.C_PaymentTerm_ID
  AND o.name=t.name

update adempiere.C_Greeting_Trl     t set name = f.name
FROM newtai.C_Greeting_Trl      f ,newtai.C_Greeting o
WHERE f.C_Greeting_ID     =t.C_Greeting_ID
  AND f.AD_Language='zh_TW' AND t.AD_Language='zh_TW'
  AND f.C_Greeting_ID =o.C_Greeting_ID
  AND o.name=t.name

update adempiere.C_Charge_Trl       t set name = f.name
FROM newtai.C_Charge_Trl        f ,newtai.C_Charge o
WHERE f.C_Charge_ID       =t.C_Charge_ID
  AND f.AD_Language='zh_TW' AND t.AD_Language='zh_TW'
  AND f.C_Charge_ID =o.C_Charge_ID
  AND o.name=t.name

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 newtai.C_DocType_Trl        f ,newtai.C_DocType o
WHERE f.C_DocType_ID       =t.C_DocType_ID
  AND f.AD_Language='zh_TW' AND t.AD_Language='zh_TW'
  AND f.C_DocType_ID =o.C_DocType_ID
  AND o.name=t.name

update adempiere.AD_Task_Trl            t set name = f.name
FROM newtai.AD_Task_Trl        f ,newtai.AD_Task o
WHERE f.AD_Task_ID       =t.AD_Task_ID
  AND f.AD_Language='zh_TW' AND t.AD_Language='zh_TW'
  AND f.AD_Task_ID =o.AD_Task_ID
  AND o.name=t.name

update adempiere.AD_Process_Para_Trl    t set name = f.name
FROM newtai.AD_Process_Para_Trl        f , newtai.AD_Process_Para o
WHERE f.AD_Process_Para_ID       =t.AD_Process_Para_ID
  AND f.AD_Language='zh_TW' AND t.AD_Language='zh_TW'
  AND f.AD_Process_Para_ID =o.AD_Process_Para_ID
  AND o.name=t.name

update adempiere.AD_WF_Node_Trl         t set name = f.name
FROM newtai.AD_WF_Node_Trl        f ,newtai.AD_WF_Node o
WHERE f.AD_WF_Node_ID       =t.AD_WF_Node_ID
  AND f.AD_Language='zh_TW' AND t.AD_Language='zh_TW'
  AND f.AD_WF_Node_ID =o.AD_WF_Node_ID
  AND o.name=t.name

update adempiere.AD_Window_Trl         t set name = f.name
FROM newtai.AD_Window_Trl        f ,newtai.AD_Window o
WHERE f.AD_Window_ID       =t.AD_Window_ID
  AND f.AD_Language='zh_TW' AND t.AD_Language='zh_TW'
  AND f.AD_Window_ID =o.AD_Window_ID
  AND o.name=t.name

"M_PriceList_Version_Trl"

update adempiere.AD_Tab_Trl    t set name = f.name
FROM newtai.AD_Tab_Trl        f ,newtai.AD_Tab o
WHERE f.AD_Tab_ID       =t.AD_Tab_ID
  AND f.AD_Language='zh_TW' AND t.AD_Language='zh_TW'
  AND f.AD_Tab_ID =o.AD_Tab_ID
  AND o.name=t.name

update adempiere.AD_PrintFormatItem_Trl  t set name = f.name
FROM newtai.AD_PrintFormatItem_Trl        f ,newtai.AD_PrintFormatItem o
WHERE f.AD_PrintFormatItem_ID       =t.AD_PrintFormatItem_ID
  AND f.AD_Language='zh_TW' AND t.AD_Language='zh_TW'
  AND f.AD_PrintFormatItem_ID =o.AD_PrintFormatItem_ID
  AND o.name=t.name

update adempiere.C_TaxCategory_Trl    t set name = f.name
FROM newtai.C_TaxCategory_Trl        f ,newtai.C_TaxCategory o
WHERE f.C_TaxCategory_ID       =t.C_TaxCategory_ID
  AND f.AD_Language='zh_TW' AND t.AD_Language='zh_TW'
  AND f.C_TaxCategory_ID =o.C_TaxCategory_ID
  AND o.name=t.name

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

update adempiere.AD_Reference_Trl  t set name = f.name
FROM newtai.AD_Reference_Trl        f ,newtai.AD_Reference o
WHERE f.AD_Reference_ID       =t.AD_Reference_ID
  AND f.AD_Language='zh_TW' AND t.AD_Language='zh_TW'
  AND f.AD_Reference_ID =o.AD_Reference_ID
  AND o.name=t.name

update adempiere.AD_Process_Trl    t set name = f.name
FROM newtai.AD_Process_Trl        f ,newtai.AD_Process o
WHERE f.AD_Process_ID       =t.AD_Process_ID
  AND f.AD_Language='zh_TW' AND t.AD_Language='zh_TW'
  AND f.AD_Process_ID =o.AD_Process_ID
  AND o.name=t.name

update adempiere.AD_Element_Trl    t set name = f.name
FROM newtai.AD_Element_Trl        f ,newtai.AD_Element o
WHERE f.AD_Element_ID       =t.AD_Element_ID
  AND f.AD_Language='zh_TW' AND t.AD_Language='zh_TW'
  AND f.AD_Element_ID =o.AD_Element_ID
  AND o.name=t.name

"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 newtai.C_Currency_Trl   f WHERE f.C_Currency_ID  =t.C_Currency_ID AND f.AD_Language='zh_TW' AND t.AD_Language='zh_TW'

"C_UOM_Trl"

"AD_BroadcastMessage_Trl"

"AD_CtxHelpMsg_Trl"

"AD_Chart_Trl"

"C_SalesStage_Trl"