SchemaSpy Analysis of idempiere9.adempiere - ColumnsX-Associations Generated by
Quality Systems & Solutions
Generated on 2021-12-25 14:57 +0100
Legend:
Primary key columns
Columns with indexes
 

idempiere9.adempiere contains 271 columns - click on heading to sort:
Table Column Type Size Nulls Auto Default
m_product_po costperorder numeric 0  √  0
c_conversion_rate dividerate numeric 0 0
m_replenish level_max numeric 0 0
m_replenish level_min numeric 0 0
c_conversion_rate multiplyrate numeric 0 0
m_product_po order_min numeric 0  √  0
m_product_po order_pack numeric 0  √  0
ad_pinstance_para p_number numeric 0  √  null
ad_pinstance_para p_number_to numeric 0  √  null
m_product_po pricelastinv numeric 0  √  0
m_product_po pricelastpo numeric 0  √  0
m_product_po pricelist numeric 0  √  0
m_product_po pricepo numeric 0  √  0
m_replenish qtybatchsize numeric 0  √  null
m_product_po qualityrating numeric 0  √  null
m_product_po royaltyamt numeric 0  √  0
ad_orginfo transferbank_id numeric 0  √  null
ad_orginfo transfercashbook_id numeric 0  √  null
ad_table_access accesstyperule bpchar 1 'G'::bpchar
m_product_po discontinued bpchar 1  √  'N'::bpchar
ad_clientinfo isactive bpchar 1 'Y'::bpchar
ad_orginfo isactive bpchar 1 'Y'::bpchar
ad_pinstance_para isactive bpchar 1  √  'Y'::bpchar
ad_process_access isactive bpchar 1 'Y'::bpchar
ad_ref_table isactive bpchar 1 'Y'::bpchar
ad_sequence_audit isactive bpchar 1 'Y'::bpchar
ad_sequence_no isactive bpchar 1 'Y'::bpchar
ad_table_access isactive bpchar 1 'Y'::bpchar
ad_task_access isactive bpchar 1 'Y'::bpchar
ad_user_roles isactive bpchar 1 'Y'::bpchar
ad_wf_nodenext isactive bpchar 1 'Y'::bpchar
ad_window_access isactive bpchar 1 'Y'::bpchar
ad_workflow_access isactive bpchar 1 'Y'::bpchar
c_conversion_rate isactive bpchar 1 'Y'::bpchar
m_product_po isactive bpchar 1 'Y'::bpchar
m_replenish isactive bpchar 1 'Y'::bpchar
ad_table_access iscanexport bpchar 1 'Y'::bpchar
ad_table_access iscanreport bpchar 1 'Y'::bpchar
ad_clientinfo isconfirmondocclose bpchar 1 'N'::bpchar
ad_clientinfo isconfirmondocvoid bpchar 1 'N'::bpchar
m_product_po iscurrentvendor bpchar 1 'Y'::bpchar
ad_clientinfo isdiscountlineamt bpchar 1 'Y'::bpchar
ad_table_access isexclude bpchar 1 'Y'::bpchar
ad_table_access isreadonly bpchar 1 'N'::bpchar
ad_process_access isreadwrite bpchar 1 'Y'::bpchar
ad_task_access isreadwrite bpchar 1 'Y'::bpchar
ad_window_access isreadwrite bpchar 1 'Y'::bpchar
ad_workflow_access isreadwrite bpchar 1 'Y'::bpchar
ad_wf_nodenext isstduserworkflow bpchar 1 'N'::bpchar
ad_ref_table isvaluedisplayed bpchar 1 'N'::bpchar
m_replenish replenishtype bpchar 1
ad_sequence_no calendaryearmonth varchar 6 '0000'::character varying
ad_clientinfo ad_client_id numeric 10
ad_orginfo ad_client_id numeric 10
ad_pinstance_para ad_client_id numeric 10  √  null
ad_process_access ad_client_id numeric 10
ad_ref_table ad_client_id numeric 10
ad_sequence_audit ad_client_id numeric 10
ad_sequence_no ad_client_id numeric 10
ad_table_access ad_client_id numeric 10
ad_task_access ad_client_id numeric 10
ad_user_roles ad_client_id numeric 10
ad_wf_nodenext ad_client_id numeric 10
ad_window_access ad_client_id numeric 10
ad_workflow_access ad_client_id numeric 10
c_conversion_rate ad_client_id numeric 10
m_product_po ad_client_id numeric 10
m_replenish ad_client_id numeric 10
ad_ref_table ad_display numeric 10
ad_ref_table ad_infowindow_id numeric 10  √  NULL::numeric
ad_ref_table ad_key numeric 10
ad_clientinfo ad_org_id numeric 10
ad_orginfo ad_org_id numeric 10
ad_pinstance_para ad_org_id numeric 10  √  null
ad_process_access ad_org_id numeric 10
ad_ref_table ad_org_id numeric 10
ad_sequence_audit ad_org_id numeric 10
ad_sequence_no ad_org_id numeric 10
ad_table_access ad_org_id numeric 10
ad_task_access ad_org_id numeric 10
ad_user_roles ad_org_id numeric 10
ad_wf_nodenext ad_org_id numeric 10
ad_window_access ad_org_id numeric 10
ad_workflow_access ad_org_id numeric 10
c_conversion_rate ad_org_id numeric 10
m_product_po ad_org_id numeric 10
m_replenish ad_org_id numeric 10
ad_orginfo ad_orgtype_id numeric 10  √  null
ad_pinstance_para ad_pinstance_id numeric 10
ad_process_access ad_process_id numeric 10
ad_ref_table ad_reference_id numeric 10
ad_process_access ad_role_id numeric 10
ad_table_access ad_role_id numeric 10
ad_task_access ad_role_id numeric 10
ad_user_roles ad_role_id numeric 10
ad_window_access ad_role_id numeric 10
ad_workflow_access ad_role_id numeric 10
ad_sequence_audit ad_sequence_id numeric 10
ad_sequence_no ad_sequence_id numeric 10
ad_clientinfo ad_storageprovider_id numeric 10  √  NULL::numeric
ad_ref_table ad_table_id numeric 10
ad_sequence_audit ad_table_id numeric 10
ad_table_access ad_table_id numeric 10
ad_task_access ad_task_id numeric 10
ad_clientinfo ad_tree_activity_id numeric 10  √  null
ad_clientinfo ad_tree_bpartner_id numeric 10  √  null
ad_clientinfo ad_tree_campaign_id numeric 10  √  null
ad_clientinfo ad_tree_menu_id numeric 10  √  null
ad_clientinfo ad_tree_org_id numeric 10  √  null
ad_clientinfo ad_tree_product_id numeric 10  √  null
ad_clientinfo ad_tree_project_id numeric 10  √  null
ad_clientinfo ad_tree_salesregion_id numeric 10  √  null
ad_user_roles ad_user_id numeric 10
ad_wf_nodenext ad_wf_next_id numeric 10
ad_wf_nodenext ad_wf_node_id numeric 10
ad_wf_nodenext ad_wf_nodenext_id numeric 10
ad_ref_table ad_window_id numeric 10  √  null
ad_window_access ad_window_id numeric 10
ad_workflow_access ad_workflow_id numeric 10
ad_clientinfo c_acctschema1_id numeric 10  √  null
m_product_po c_bpartner_id numeric 10
ad_clientinfo c_bpartnercashtrx_id numeric 10  √  null
ad_clientinfo c_calendar_id numeric 10  √  null
ad_orginfo c_calendar_id numeric 10  √  null
ad_clientinfo c_chargefreight_id numeric 10  √  NULL::numeric
c_conversion_rate c_conversion_rate_id numeric 10
c_conversion_rate c_conversiontype_id numeric 10
c_conversion_rate c_currency_id numeric 10
m_product_po c_currency_id numeric 10  √  null
c_conversion_rate c_currency_id_to numeric 10
ad_orginfo c_location_id numeric 10  √  null
m_product_po c_uom_id numeric 10  √  null
ad_clientinfo c_uom_length_id numeric 10  √  null
ad_clientinfo c_uom_time_id numeric 10  √  null
ad_clientinfo c_uom_volume_id numeric 10  √  null
ad_clientinfo c_uom_weight_id numeric 10  √  null
ad_clientinfo createdby numeric 10
ad_orginfo createdby numeric 10
ad_pinstance_para createdby numeric 10  √  null
ad_process_access createdby numeric 10
ad_ref_table createdby numeric 10
ad_sequence_audit createdby numeric 10
ad_sequence_no createdby numeric 10
ad_table_access createdby numeric 10
ad_task_access createdby numeric 10
ad_user_roles createdby numeric 10
ad_wf_nodenext createdby numeric 10
ad_window_access createdby numeric 10
ad_workflow_access createdby numeric 10
c_conversion_rate createdby numeric 10
m_product_po createdby numeric 10
m_replenish createdby numeric 10
ad_sequence_no currentnext numeric 10
m_product_po deliverytime_actual numeric 10  √  null
m_product_po deliverytime_promised numeric 10  √  null
ad_orginfo dropship_warehouse_id numeric 10  √  null
ad_clientinfo keeplogdays numeric 10  √  null
ad_clientinfo logo_id numeric 10  √  NULL::numeric
ad_orginfo logo_id numeric 10  √  NULL::numeric
ad_clientinfo logoreport_id numeric 10  √  NULL::numeric
ad_clientinfo logoweb_id numeric 10  √  NULL::numeric
m_replenish m_locator_id numeric 10  √  null
m_product_po m_product_id numeric 10
m_replenish m_product_id numeric 10
ad_clientinfo m_productfreight_id numeric 10  √  null
ad_orginfo m_warehouse_id numeric 10  √  null
m_replenish m_warehouse_id numeric 10
m_replenish m_warehousesource_id numeric 10  √  null
ad_orginfo pa_goal_id numeric 10  √  null
ad_orginfo parent_org_id numeric 10  √  null
ad_sequence_audit record_id numeric 10
ad_pinstance_para seqno numeric 10
ad_wf_nodenext seqno numeric 10
ad_clientinfo storagearchive_id numeric 10  √  NULL::numeric
ad_clientinfo storageimage_id numeric 10  √  NULL::numeric
ad_orginfo supervisor_id numeric 10  √  null
ad_clientinfo updatedby numeric 10
ad_orginfo updatedby numeric 10
ad_pinstance_para updatedby numeric 10  √  null
ad_process_access updatedby numeric 10
ad_ref_table updatedby numeric 10
ad_sequence_audit updatedby numeric 10
ad_sequence_no updatedby numeric 10
ad_table_access updatedby numeric 10
ad_task_access updatedby numeric 10
ad_user_roles updatedby numeric 10
ad_wf_nodenext updatedby numeric 10
ad_window_access updatedby numeric 10
ad_workflow_access updatedby numeric 10
c_conversion_rate updatedby numeric 10
m_product_po updatedby numeric 10
m_replenish updatedby numeric 10
ad_orginfo duns varchar 11
ad_orginfo taxid varchar 20
m_product_po upc varchar 20  √  null
ad_clientinfo created timestamp 29,6 now()
ad_orginfo created timestamp 29,6 now()
ad_pinstance_para created timestamp 29,6 statement_timestamp()
ad_process_access created timestamp 29,6 now()
ad_ref_table created timestamp 29,6 now()
ad_sequence_audit created timestamp 29,6 now()
ad_sequence_no created timestamp 29,6 now()
ad_table_access created timestamp 29,6 now()
ad_task_access created timestamp 29,6 now()
ad_user_roles created timestamp 29,6 now()
ad_wf_nodenext created timestamp 29,6 now()
ad_window_access created timestamp 29,6 now()
ad_workflow_access created timestamp 29,6 now()
c_conversion_rate created timestamp 29,6 now()
m_product_po created timestamp 29,6 now()
m_replenish created timestamp 29,6 now()
m_product_po discontinuedat timestamp 29,6  √  null
m_product_po discontinuedby timestamp 29,6  √  null
ad_clientinfo fy_startdate timestamp 29,6  √  null
ad_pinstance_para p_date timestamp 29,6  √  null
ad_pinstance_para p_date_to timestamp 29,6  √  null
m_product_po priceeffective timestamp 29,6  √  null
ad_clientinfo updated timestamp 29,6 now()
ad_orginfo updated timestamp 29,6 now()
ad_pinstance_para updated timestamp 29,6 statement_timestamp()
ad_process_access updated timestamp 29,6 now()
ad_ref_table updated timestamp 29,6 now()
ad_sequence_audit updated timestamp 29,6 now()
ad_sequence_no updated timestamp 29,6 now()
ad_table_access updated timestamp 29,6 now()
ad_task_access updated timestamp 29,6 now()
ad_user_roles updated timestamp 29,6 now()
ad_wf_nodenext updated timestamp 29,6 now()
ad_window_access updated timestamp 29,6 now()
ad_workflow_access updated timestamp 29,6 now()
c_conversion_rate updated timestamp 29,6 now()
m_product_po updated timestamp 29,6 now()
m_replenish updated timestamp 29,6 now()
c_conversion_rate validfrom timestamp 29,6
c_conversion_rate validto timestamp 29,6  √  null
ad_sequence_audit documentno varchar 30
m_product_po manufacturer varchar 30  √  null
m_product_po vendorcategory varchar 30  √  null
ad_clientinfo ad_clientinfo_uu varchar 36  √  NULL::character varying
ad_orginfo ad_orginfo_uu varchar 36  √  NULL::character varying
ad_pinstance_para ad_pinstance_para_uu varchar 36  √  NULL::character varying
ad_process_access ad_process_access_uu varchar 36  √  NULL::character varying
ad_ref_table ad_ref_table_uu varchar 36  √  NULL::character varying
ad_sequence_audit ad_sequence_audit_uu varchar 36  √  NULL::character varying
ad_sequence_no ad_sequence_no_uu varchar 36  √  NULL::character varying
ad_table_access ad_table_access_uu varchar 36  √  NULL::character varying
ad_task_access ad_task_access_uu varchar 36  √  NULL::character varying
ad_user_roles ad_user_roles_uu varchar 36  √  NULL::character varying
ad_wf_nodenext ad_wf_nodenext_uu varchar 36  √  NULL::character varying
ad_window_access ad_window_access_uu varchar 36  √  NULL::character varying
ad_workflow_access ad_workflow_access_uu varchar 36  √  NULL::character varying
c_conversion_rate c_conversion_rate_uu varchar 36  √  NULL::character varying
m_product_po m_product_po_uu varchar 36  √  NULL::character varying
m_replenish m_replenish_uu varchar 36  √  NULL::character varying
ad_ref_table entitytype varchar 40 'D'::character varying
ad_wf_nodenext entitytype varchar 40 'D'::character varying
ad_orginfo fax varchar 40  √  NULL::character varying
ad_orginfo phone varchar 40  √  NULL::character varying
ad_orginfo phone2 varchar 40  √  NULL::character varying
m_product_po vendorproductno varchar 40
ad_orginfo email varchar 60  √  NULL::character varying
ad_pinstance_para parametername varchar 60  √  null
ad_wf_nodenext description varchar 255  √  null
ad_orginfo receiptfootermsg varchar 1023  √  null
ad_ref_table orderbyclause varchar 2000  √  null
ad_wf_nodenext transitioncode varchar 2000  √  null
ad_ref_table whereclause varchar 2000  √  null
ad_pinstance_para info varchar 4000  √  null
ad_pinstance_para info_to varchar 4000  √  null
ad_pinstance_para p_string varchar 4000  √  null
ad_pinstance_para p_string_to varchar 4000  √  null