Hi Everyone,
The purpose of this post is to offer a quick tip to generate a uuid for iDempiere’s UUID columns.
Use the iDempiere function generate_uuid() to create your values when inserting records. Use this function to populte any of the below columns.
Example using a simple table:
Insert into c_calendar
Values (1000001, 11, 0, ‘Y’, now(), 100, now(), 100, ‘Chucks Calendar’, ‘No Desc’, generate_uuid());
List of UUID Columns:
a_asset_uu
a_asset_acct_uu
a_asset_addition_uu
a_asset_change_uu
a_asset_class_uu
a_asset_delivery_uu
a_asset_disposed_uu
a_asset_group_uu
a_asset_group_acct_uu
a_asset_info_fin_uu
a_asset_info_ins_uu
a_asset_info_lic_uu
a_asset_info_tax_uu
a_asset_product_uu
a_asset_retirement_uu
a_asset_reval_uu
a_asset_reval_entry_uu
a_asset_reval_index_uu
a_asset_split_uu
a_asset_spread_uu
a_asset_transfer_uu
a_asset_type_uu
a_asset_use_uu
ad_accesslog_uu
ad_alert_uu
ad_alertprocessor_uu
ad_alertprocessorlog_uu
ad_alertrecipient_uu
ad_alertrule_uu
ad_archive_uu
ad_attachment_uu
ad_attachmentnote_uu
ad_attribute_uu
ad_broadcastmessage_uu
ad_client_uu
ad_clientshare_uu
ad_color_uu
ad_column_uu
ad_ctxhelp_uu
ad_ctxhelpmsg_uu
ad_desktop_uu
ad_desktopworkbench_uu
ad_element_uu
ad_entitytype_uu
a_depreciation_uu
a_depreciation_build_uu
a_depreciation_convention_uu
a_depreciation_entry_uu
a_depreciation_exp_uu
a_depreciation_forecast_uu
a_depreciation_method_uu
a_depreciation_table_detail_uu
a_depreciation_table_header_uu
a_depreciation_workfile_uu
ad_error_uu
ad_field_uu
ad_fieldgroup_uu
ad_find_uu
ad_form_uu
ad_housekeeping_uu
ad_image_uu
ad_impformat_uu
ad_impformat_row_uu
ad_infocolumn_uu
ad_infowindow_uu
ad_issue_uu
ad_labelprinter_uu
ad_labelprinterfunction_uu
ad_language_uu
ad_ldapaccess_uu
ad_ldapprocessor_uu
ad_ldapprocessorlog_uu
ad_menu_uu
ad_message_uu
ad_migrationscript_uu
ad_modelvalidator_uu
ad_modification_uu
ad_note_uu
ad_org_uu
ad_orgtype_uu
ad_package_exp_uu
ad_package_exp_common_uu
ad_package_exp_detail_uu
ad_package_imp_uu
ad_package_imp_backup_uu
ad_package_imp_detail_uu
ad_package_imp_inst_uu
ad_package_imp_proc_uu
ad_passwordrule_uu
ad_pinstance_uu
ad_pinstance_log_uu
ad_preference_uu
ad_printcolor_uu
ad_printfont_uu
ad_printform_uu
ad_printformat_uu
ad_printformatitem_uu
ad_printgraph_uu
ad_printlabel_uu
ad_printlabelline_uu
ad_printpaper_uu
ad_printtableformat_uu
ad_process_uu
ad_process_para_uu
ad_recentitem_uu
ad_reference_uu
ad_ref_list_uu
ad_registration_uu
ad_relationtype_uu
ad_replication_uu
ad_replicationdocument_uu
ad_replication_log_uu
ad_replication_run_uu
ad_replicationstrategy_uu
ad_replicationtable_uu
ad_reportview_uu
ad_reportview_col_uu
ad_role_uu
ad_rule_uu
ad_schedule_uu
ad_scheduler_uu
ad_schedulerlog_uu
ad_schedulerrecipient_uu
ad_searchdefinition_uu
ad_sequence_uu
ad_session_uu
ad_sessioninfo_v_uu
ad_storageprovider_uu
ad_sysconfig_uu
ad_system_uu
ad_tab_uu
ad_tab_customization_uu
ad_table_uu
ad_table_scriptvalidator_uu
ad_task_uu
ad_taskinstance_uu
ad_toolbarbutton_uu
ad_toolbarbuttonrestrict_uu
ad_tree_uu
ad_user_uu
ad_userbpaccess_uu
ad_userdef_field_uu
ad_userdef_tab_uu
ad_userdef_win_uu
ad_usermail_uu
ad_userquery_uu
ad_user_substitute_uu
ad_val_rule_uu
ad_wf_activity_uu
ad_wf_activityresult_uu
ad_wf_block_uu
ad_wf_eventaudit_uu
ad_wf_nextcondition_uu
ad_wf_node_uu
ad_wf_nodenext_uu
ad_wf_node_para_uu
ad_wf_process_uu
ad_wf_processdata_uu
ad_wf_responsible_uu
ad_window_uu
ad_wizardprocess_uu
ad_workbench_uu
ad_workbenchwindow_uu
ad_workflow_uu
ad_workflowprocessor_uu
ad_workflowprocessorlog_uu
a_fundingmode_uu
a_registration_uu
a_registrationattribute_uu
asp_clientexception_uu
asp_clientlevel_uu
asp_field_uu
asp_form_uu
asp_level_uu
asp_module_uu
asp_process_uu
asp_process_para_uu
asp_ref_list_uu
asp_tab_uu
asp_task_uu
asp_window_uu
asp_workflow_uu
b_bid_uu
b_bidcomment_uu
b_buyerfunds_uu
b_offer_uu
b_sellerfunds_uu
b_topic_uu
b_topiccategory_uu
b_topictype_uu
c_1099box_uu
c_acctprocessor_uu
c_acctprocessorlog_uu
c_acctschema_uu
c_acctschema_element_uu
c_activity_uu
c_allocationhdr_uu
c_allocationline_uu
c_bank_uu
c_bankaccount_uu
c_bankaccountdoc_uu
c_bankstatement_uu
c_bankstatementline_uu
c_bankstatementloader_uu
c_bankstatementmatcher_uu
c_bpartner_uu
c_bpartner_location_uu
c_bp_bankaccount_uu
c_bp_edi_uu
c_bp_group_uu
c_bp_relation_uu
c_bp_shippingacct_uu
c_calendar_uu
c_campaign_uu
c_cash_uu
c_cashbook_uu
c_cashline_uu
c_cashplan_uu
c_cashplanline_uu
c_channel_uu
c_charge_uu
c_chargetype_uu
c_city_uu
c_commission_uu
c_commissionamt_uu
c_commissiondetail_uu
c_commissionline_uu
c_commissionrun_uu
c_conversion_rate_uu
c_conversiontype_uu
c_country_uu
c_currency_uu
c_cycle_uu
c_cyclestep_uu
c_depositbatch_uu
c_depositbatchline_uu
c_doctype_uu
c_doctypecounter_uu
c_dunning_uu
c_dunning_header_v_uu
c_dunninglevel_uu
c_dunning_line_v_uu
c_dunningrun_uu
c_dunningrunentry_uu
c_dunningrunline_uu
c_element_uu
c_elementvalue_uu
c_greeting_uu
chuck_orderline1_v_uu
c_invoice_uu
c_invoicebatch_uu
c_invoicebatchline_uu
c_invoiceline_uu
c_invoice_linetax_v_uu
c_invoicepayschedule_uu
c_invoiceschedule_uu
c_job_uu
c_jobassignment_uu
c_jobcategory_uu
c_jobremuneration_uu
c_landedcost_uu
c_landedcostallocation_uu
c_location_uu
cm_accessprofile_uu
cm_ad_uu
cm_ad_cat_uu
cm_broadcastserver_uu
cm_chat_uu
cm_chatentry_uu
cm_chattype_uu
cm_container_uu
cm_container_element_uu
cm_containerttable_uu
cm_container_url_uu
cm_cstage_uu
cm_cstage_element_uu
cm_cstagettable_uu
cm_media_uu
cm_mediadeploy_uu
cm_media_server_uu
cm_newschannel_uu
cm_newsitem_uu
cm_template_uu
cm_templatetable_uu
cm_webaccesslog_uu
cm_webproject_uu
cm_webproject_domain_uu
cm_wikitoken_uu
c_nonbusinessday_uu
c_onlinetrxhistory_uu
c_order_uu
c_order_header_v_uu
c_orderline_uu
c_order_linetax_v_uu
c_orderpayschedule_uu
c_ordersource_uu
c_orgassignment_uu
c_payment_uu
c_paymentallocate_uu
c_paymentbatch_uu
c_paymentprocessor_uu
c_paymentterm_uu
c_paymenttransaction_uu
c_payschedule_uu
c_payselection_uu
c_payselectioncheck_uu
c_payselection_check_v_uu
c_payselectionline_uu
c_payselection_remittance_v_uu
c_period_uu
c_periodcontrol_uu
c_phase_uu
c_pos_uu
c_poskey_uu
c_poskeylayout_uu
c_pospayment_uu
c_postendertype_uu
c_project_uu
c_project_details_v_uu
c_project_header_v_uu
c_projectissue_uu
c_projectline_uu
c_projectphase_uu
c_projecttask_uu
c_projecttype_uu
c_recurring_uu
c_recurring_run_uu
c_region_uu
c_remuneration_uu
c_revenuerecognition_uu
c_revenuerecognition_plan_uu
c_revenuerecognition_run_uu
c_rfq_uu
c_rfqline_uu
c_rfqlineqty_uu
c_rfqresponse_uu
c_rfqresponseline_uu
c_rfqresponselineqty_uu
c_rfqresponselineqty_v_uu
c_rfqresponseline_v_uu
c_rfqresponse_v_uu
c_rfq_topic_uu
c_rfq_topicsubscriber_uu
c_rfq_topicsubscriberonly_uu
c_salesregion_uu
c_servicelevel_uu
c_servicelevelline_uu
c_subacct_uu
c_subscription_uu
c_subscription_delivery_uu
c_subscriptiontype_uu
c_task_uu
c_tax_uu
c_taxbase_uu
c_taxcategory_uu
c_taxdeclaration_uu
c_taxdeclarationacct_uu
c_taxdeclarationline_uu
c_taxdefinition_uu
c_taxgroup_uu
c_taxpostal_uu
c_taxtype_uu
c_uom_uu
c_uom_conversion_uu
c_userremuneration_uu
c_validcombination_uu
c_withholding_uu
c_year_uu
dd_networkdistribution_uu
dd_networkdistributionline_uu
dd_order_uu
dd_orderline_uu
exp_format_uu
exp_formatline_uu
exp_processor_uu
exp_processorparameter_uu
exp_processor_type_uu
fact_acct_uu
fact_reconciliation_uu
gl_budget_uu
gl_budgetcontrol_uu
gl_category_uu
gl_distribution_uu
gl_distributionline_uu
gl_fund_uu
gl_fundrestriction_uu
gl_journal_uu
gl_journalbatch_uu
gl_journalgenerator_uu
gl_journalgeneratorline_uu
gl_journalgeneratorsource_uu
gl_journalline_uu
hr_attribute_uu
hr_concept_uu
hr_concept_acct_uu
hr_concept_category_uu
hr_contract_uu
hr_department_uu
hr_employee_uu
hr_job_uu
hr_list_uu
hr_listline_uu
hr_listtype_uu
hr_listversion_uu
hr_movement_uu
hr_payroll_uu
hr_payrollconcept_uu
hr_period_uu
hr_process_uu
hr_year_uu
i_asset_uu
i_bankstatement_uu
i_bpartner_uu
i_conversion_rate_uu
i_elementvalue_uu
i_fajournal_uu
i_fixedasset_uu
i_gljournal_uu
i_hr_movement_uu
i_inoutlineconfirm_uu
i_inventory_uu
i_invoice_uu
i_movement_uu
imp_processor_uu
imp_processorlog_uu
imp_processorparameter_uu
imp_processor_type_uu
i_order_uu
i_payment_uu
i_pricelist_uu
i_product_uu
i_productplanning_uu
i_reportline_uu
k_category_uu
k_categoryvalue_uu
k_comment_uu
k_entry_uu
k_entryrelated_uu
k_index_uu
k_indexlog_uu
k_indexstop_uu
k_source_uu
k_synonym_uu
k_topic_uu
k_type_uu
m_attribute_uu
m_attributesearch_uu
m_attributeset_uu
m_attributesetexclude_uu
m_attributesetinstance_uu
m_attributevalue_uu
m_bom_uu
m_bomalternative_uu
m_bomproduct_uu
m_changenotice_uu
m_changerequest_uu
m_commodityshipment_uu
m_costdetail_uu
m_costelement_uu
m_costhistory_uu
m_costqueue_uu
m_costtype_uu
m_demand_uu
m_demanddetail_uu
m_demandline_uu
m_discountschema_uu
m_discountschemabreak_uu
m_discountschemaline_uu
m_distributionlist_uu
m_distributionlistline_uu
m_distributionrun_uu
m_distributionrunline_uu
m_edi_uu
m_edi_info_uu
m_forecast_uu
m_forecastline_uu
m_freight_uu
m_freightcategory_uu
m_inout_uu
m_inoutconfirm_uu
m_inoutconfirm_v_uu
m_inoutline_uu
m_inoutlineconfirm_uu
m_inout_line_v_uu
m_inventory_uu
m_inventoryline_uu
m_locator_uu
m_lot_uu
m_lotctl_uu
m_lotctlexclude_uu
m_matchinv_uu
m_matchpo_uu
m_movement_uu
m_movementconfirm_uu
m_movementline_uu
m_movementlineconfirm_uu
m_operationresource_uu
m_package_uu
m_packageline_uu
m_packagemps_uu
m_parttype_uu
m_perpetualinv_uu
m_pricelist_uu
m_pricelist_version_uu
m_product_uu
m_product_bom_uu
m_product_category_uu
m_productdownload_uu
m_production_uu
m_productionline_uu
m_productionplan_uu
m_productoperation_uu
m_productpricevendorbreak_uu
m_product_qualitytest_uu
m_promotion_uu
m_promotiondistribution_uu
m_promotiongroup_uu
m_promotiongroupline_uu
m_promotionline_uu
m_promotionprecondition_uu
m_promotionreward_uu
m_qualitytest_uu
m_qualitytestresult_uu
m_requisition_uu
m_requisitionline_uu
m_rma_uu
m_rmaline_uu
m_rmatype_uu
m_sernoctl_uu
m_sernoctlexclude_uu
m_shipper_uu
m_shippercfg_uu
m_shipperlabels_uu
m_shipperlabelscfg_uu
m_shipperpackaging_uu
m_shipperpackagingcfg_uu
m_shipperpickuptypes_uu
m_shipperpickuptypescfg_uu
m_shippingprocessor_uu
m_shippingprocessorcfg_uu
m_shippingtransaction_uu
m_shippingtransactionline_uu
m_transaction_uu
m_transaction_v_uu
m_warehouse_uu
pa_achievement_uu
pa_benchmark_uu
pa_benchmarkdata_uu
pa_colorschema_uu
pa_dashboardcontent_uu
pa_dashboardpreference_uu
pa_goal_uu
pa_goalrestriction_uu
pa_hierarchy_uu
pa_measure_uu
pa_measurecalc_uu
pa_ratio_uu
pa_ratioelement_uu
pa_report_uu
pa_reportcolumn_uu
pa_reportcolumnset_uu
pa_reportcube_uu
pa_reportline_uu
pa_reportlineset_uu
pa_reportsource_uu
pa_sla_criteria_uu
pa_sla_goal_uu
pa_sla_measure_uu
pp_cost_collector_uu
pp_cost_collectorma_uu
pp_mrp_uu
pp_order_uu
pp_order_bom_uu
pp_order_bomline_uu
pp_order_cost_uu
pp_order_node_uu
pp_order_node_asset_uu
pp_order_nodenext_uu
pp_order_node_product_uu
pp_order_workflow_uu
pp_product_bom_uu
pp_product_bomline_uu
pp_product_planning_uu
pp_wf_node_asset_uu
pp_wf_node_product_uu
qm_specification_uu
qm_specificationline_uu
r_category_uu
r_group_uu
r_interestarea_uu
r_issueknown_uu
r_issueproject_uu
r_issuerecommendation_uu
r_issuestatus_uu
r_issuesystem_uu
r_issueuser_uu
r_mailtext_uu
r_request_uu
r_requestaction_uu
r_requestprocessor_uu
r_requestprocessorlog_uu
r_requestprocessor_route_uu
r_requesttype_uu
r_requestupdate_uu
r_resolution_uu
r_standardresponse_uu
r_status_uu
r_statuscategory_uu
s_expensetype_uu
s_resource_uu
s_resourceassignment_uu
s_resourcetype_uu
s_resourceunavailable_uu
s_timeexpense_uu
s_timeexpenseline_uu
s_timetype_uu
s_training_uu
s_training_class_uu
u_blacklistcheque_uu
u_posterminal_uu
u_rolemenu_uu
u_webmenu_uu
u_web_properties_uu
w_advertisement_uu
w_basket_uu
w_basketline_uu
w_click_uu
w_clickcount_uu
w_counter_uu
w_countercount_uu
w_mailmsg_uu
w_store_uu
ws_webservice_uu
ws_webservicefieldinput_uu
ws_webservicefieldoutput_uu
ws_webservicemethod_uu
ws_webservice_para_uu
ws_webservicetype_uu