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
ad_sequence_no calendaryearmonth varchar 6 '0000'::character varying YYYYMM
ad_ref_table entitytype varchar 40 'D'::character varying Dictionary Entity Type; Determines ownership and synchronization
ad_wf_nodenext entitytype varchar 40 'D'::character varying Dictionary Entity Type; Determines ownership and synchronization
ad_table_access accesstyperule bpchar 1 'G'::bpchar The type of access for this rule
m_product_po discontinued bpchar 1  √  'N'::bpchar This product is no longer available
ad_clientinfo isconfirmondocclose bpchar 1 'N'::bpchar Show Confirmation On Document Action Close
ad_clientinfo isconfirmondocvoid bpchar 1 'N'::bpchar Show Confirmation On Document Action Void
ad_table_access isreadonly bpchar 1 'N'::bpchar Field is read only
ad_wf_nodenext isstduserworkflow bpchar 1 'N'::bpchar Standard Manual User Approval Workflow
ad_ref_table isvaluedisplayed bpchar 1 'N'::bpchar Displays Value column with the Display column
ad_pinstance_para isactive bpchar 1  √  'Y'::bpchar The record is active in the system
ad_clientinfo isactive bpchar 1 'Y'::bpchar The record is active in the system
ad_orginfo isactive bpchar 1 'Y'::bpchar The record is active in the system
ad_process_access isactive bpchar 1 'Y'::bpchar The record is active in the system
ad_ref_table isactive bpchar 1 'Y'::bpchar The record is active in the system
ad_sequence_audit isactive bpchar 1 'Y'::bpchar The record is active in the system
ad_sequence_no isactive bpchar 1 'Y'::bpchar The record is active in the system
ad_table_access isactive bpchar 1 'Y'::bpchar The record is active in the system
ad_task_access isactive bpchar 1 'Y'::bpchar The record is active in the system
ad_user_roles isactive bpchar 1 'Y'::bpchar The record is active in the system
ad_wf_nodenext isactive bpchar 1 'Y'::bpchar The record is active in the system
ad_window_access isactive bpchar 1 'Y'::bpchar The record is active in the system
ad_workflow_access isactive bpchar 1 'Y'::bpchar The record is active in the system
c_conversion_rate isactive bpchar 1 'Y'::bpchar The record is active in the system
m_product_po isactive bpchar 1 'Y'::bpchar The record is active in the system
m_replenish isactive bpchar 1 'Y'::bpchar The record is active in the system
ad_table_access iscanexport bpchar 1 'Y'::bpchar Users with this role can export data
ad_table_access iscanreport bpchar 1 'Y'::bpchar Users with this role can create reports
m_product_po iscurrentvendor bpchar 1 'Y'::bpchar Use this Vendor for pricing and stock replenishment
ad_clientinfo isdiscountlineamt bpchar 1 'Y'::bpchar Payment Discount calculation does not include Taxes and Charges
ad_table_access isexclude bpchar 1 'Y'::bpchar Exclude access to the data - if not selected Include access to the data
ad_process_access isreadwrite bpchar 1 'Y'::bpchar Field is read / write
ad_task_access isreadwrite bpchar 1 'Y'::bpchar Field is read / write
ad_window_access isreadwrite bpchar 1 'Y'::bpchar Field is read / write
ad_workflow_access isreadwrite bpchar 1 'Y'::bpchar Field is read / write
m_product_po costperorder numeric 0  √  0 Fixed Cost Per Order
m_product_po order_min numeric 0  √  0 Minimum order quantity in UOM
m_product_po order_pack numeric 0  √  0 Package order size in UOM (e.g. order set of 5 units)
m_product_po pricelastinv numeric 0  √  0 Price of the last invoice for the product
m_product_po pricelastpo numeric 0  √  0 Price of the last purchase order for the product
m_product_po pricelist numeric 0  √  0 List Price
m_product_po pricepo numeric 0  √  0 Price based on a purchase order
m_product_po royaltyamt numeric 0  √  0 (Included) Amount for copyright, etc.
c_conversion_rate dividerate numeric 0 0 To convert Source number to Target number, the Source is divided
m_replenish level_max numeric 0 0 Maximum Inventory level for this product
m_replenish level_min numeric 0 0 Minimum Inventory level for this product
c_conversion_rate multiplyrate numeric 0 0 Rate to multiple the source by to calculate the target.
ad_clientinfo created timestamp 29,6 now() Date this record was created
ad_orginfo created timestamp 29,6 now() Date this record was created
ad_process_access created timestamp 29,6 now() Date this record was created
ad_ref_table created timestamp 29,6 now() Date this record was created
ad_sequence_audit created timestamp 29,6 now() Date this record was created
ad_sequence_no created timestamp 29,6 now() Date this record was created
ad_table_access created timestamp 29,6 now() Date this record was created
ad_task_access created timestamp 29,6 now() Date this record was created
ad_user_roles created timestamp 29,6 now() Date this record was created
ad_wf_nodenext created timestamp 29,6 now() Date this record was created
ad_window_access created timestamp 29,6 now() Date this record was created
ad_workflow_access created timestamp 29,6 now() Date this record was created
c_conversion_rate created timestamp 29,6 now() Date this record was created
m_product_po created timestamp 29,6 now() Date this record was created
m_replenish created timestamp 29,6 now() Date this record was created
ad_clientinfo updated timestamp 29,6 now() Date this record was updated
ad_orginfo updated timestamp 29,6 now() Date this record was updated
ad_process_access updated timestamp 29,6 now() Date this record was updated
ad_ref_table updated timestamp 29,6 now() Date this record was updated
ad_sequence_audit updated timestamp 29,6 now() Date this record was updated
ad_sequence_no updated timestamp 29,6 now() Date this record was updated
ad_table_access updated timestamp 29,6 now() Date this record was updated
ad_task_access updated timestamp 29,6 now() Date this record was updated
ad_user_roles updated timestamp 29,6 now() Date this record was updated
ad_wf_nodenext updated timestamp 29,6 now() Date this record was updated
ad_window_access updated timestamp 29,6 now() Date this record was updated
ad_workflow_access updated timestamp 29,6 now() Date this record was updated
c_conversion_rate updated timestamp 29,6 now() Date this record was updated
m_product_po updated timestamp 29,6 now() Date this record was updated
m_replenish updated timestamp 29,6 now() Date this record was updated
ad_pinstance_para ad_client_id numeric 10  √  null Client/Tenant for this installation.
ad_pinstance_para ad_org_id numeric 10  √  null Organizational entity within client
ad_orginfo ad_orgtype_id numeric 10  √  null Organization Type
ad_clientinfo ad_tree_activity_id numeric 10  √  null Trees are used for (financial) reporting
ad_clientinfo ad_tree_bpartner_id numeric 10  √  null Trees are used for (financial) reporting
ad_clientinfo ad_tree_campaign_id numeric 10  √  null Trees are used for (financial) reporting
ad_clientinfo ad_tree_menu_id numeric 10  √  null Tree of the menu
ad_clientinfo ad_tree_org_id numeric 10  √  null Trees are used for (financial) reporting and security access (via role)
ad_clientinfo ad_tree_product_id numeric 10  √  null Trees are used for (financial) reporting
ad_clientinfo ad_tree_project_id numeric 10  √  null Trees are used for (financial) reporting
ad_clientinfo ad_tree_salesregion_id numeric 10  √  null Trees are used for (financial) reporting
ad_ref_table ad_window_id numeric 10  √  null Data entry or display window
ad_clientinfo c_acctschema1_id numeric 10  √  null Primary rules for accounting
ad_clientinfo c_bpartnercashtrx_id numeric 10  √  null Business Partner used for creating new Business Partners on the fly
ad_clientinfo c_calendar_id numeric 10  √  null Accounting Calendar Name
ad_orginfo c_calendar_id numeric 10  √  null Accounting Calendar Name
m_product_po c_currency_id numeric 10  √  null The Currency for this record
ad_orginfo c_location_id numeric 10  √  null Location or Address
m_product_po c_uom_id numeric 10  √  null Unit of Measure
ad_clientinfo c_uom_length_id numeric 10  √  null Standard Unit of Measure for Length
ad_clientinfo c_uom_time_id numeric 10  √  null Standard Unit of Measure for Time
ad_clientinfo c_uom_volume_id numeric 10  √  null Standard Unit of Measure for Volume
ad_clientinfo c_uom_weight_id numeric 10  √  null Standard Unit of Measure for Weight
ad_pinstance_para createdby numeric 10  √  null User who created this records
m_product_po deliverytime_actual numeric 10  √  null Actual days between order and delivery
m_product_po deliverytime_promised numeric 10  √  null Promised days between order and delivery
ad_wf_nodenext description varchar 255  √  null Optional short description of the record
m_product_po discontinuedat timestamp 29,6  √  null Discontinued At indicates Date when product was discontinued
m_product_po discontinuedby timestamp 29,6  √  null
ad_orginfo dropship_warehouse_id numeric 10  √  null The (logical) warehouse to use for recording drop ship receipts and shipments.
ad_clientinfo fy_startdate timestamp 29,6  √  null Financial Year Start Date
ad_pinstance_para info varchar 4000  √  null Information
ad_pinstance_para info_to varchar 4000  √  null Info To
ad_clientinfo keeplogdays numeric 10  √  null Number of days to keep the log entries
m_replenish m_locator_id numeric 10  √  null Warehouse Locator
ad_clientinfo m_productfreight_id numeric 10  √  null Product for Freight
ad_orginfo m_warehouse_id numeric 10  √  null Storage Warehouse and Service Point
m_replenish m_warehousesource_id numeric 10  √  null Optional Warehouse to replenish from
m_product_po manufacturer varchar 30  √  null Manufacturer of the Product
ad_ref_table orderbyclause varchar 2000  √  null Fully qualified ORDER BY clause
ad_pinstance_para p_date timestamp 29,6  √  null Process Parameter
ad_pinstance_para p_date_to timestamp 29,6  √  null Process Parameter
ad_pinstance_para p_number numeric 0  √  null Process Parameter
ad_pinstance_para p_number_to numeric 0  √  null Process Parameter
ad_pinstance_para p_string varchar 4000  √  null Process Parameter
ad_pinstance_para p_string_to varchar 4000  √  null Process Parameter
ad_orginfo pa_goal_id numeric 10  √  null
ad_pinstance_para parametername varchar 60  √  null Parameter Name
ad_orginfo parent_org_id numeric 10  √  null Parent (superior) Organization
m_product_po priceeffective timestamp 29,6  √  null Effective Date of Price
m_replenish qtybatchsize numeric 0  √  null Qty Batch Size
m_product_po qualityrating numeric 0  √  null Method for rating vendors
ad_orginfo receiptfootermsg varchar 1023  √  null This message will be displayed at the bottom of a receipt when doing a sales or purchase
ad_orginfo supervisor_id numeric 10  √  null Supervisor for this user/organization - used for escalation and approval
ad_orginfo transferbank_id numeric 0  √  null Bank account depending on currency will be used from this bank for doing transfers
ad_orginfo transfercashbook_id numeric 0  √  null CashBook for transfers
ad_wf_nodenext transitioncode varchar 2000  √  null Code resulting in TRUE of FALSE
m_product_po upc varchar 20  √  null Bar Code (Universal Product Code or its superset European Article Number)
ad_pinstance_para updatedby numeric 10  √  null User who updated this records
c_conversion_rate validto timestamp 29,6  √  null Valid to including this date (last day)
m_product_po vendorcategory varchar 30  √  null Product Category of the Business Partner
ad_ref_table whereclause varchar 2000  √  null Fully qualified SQL WHERE clause
ad_clientinfo ad_client_id numeric 10 Client/Tenant for this installation.
ad_orginfo ad_client_id numeric 10 Client/Tenant for this installation.
ad_process_access ad_client_id numeric 10 Client/Tenant for this installation.
ad_ref_table ad_client_id numeric 10 Client/Tenant for this installation.
ad_sequence_audit ad_client_id numeric 10 Client/Tenant for this installation.
ad_sequence_no ad_client_id numeric 10 Client/Tenant for this installation.
ad_table_access ad_client_id numeric 10 Client/Tenant for this installation.
ad_task_access ad_client_id numeric 10 Client/Tenant for this installation.
ad_user_roles ad_client_id numeric 10 Client/Tenant for this installation.
ad_wf_nodenext ad_client_id numeric 10 Client/Tenant for this installation.
ad_window_access ad_client_id numeric 10 Client/Tenant for this installation.
ad_workflow_access ad_client_id numeric 10 Client/Tenant for this installation.
c_conversion_rate ad_client_id numeric 10 Client/Tenant for this installation.
m_product_po ad_client_id numeric 10 Client/Tenant for this installation.
m_replenish ad_client_id numeric 10 Client/Tenant for this installation.
ad_ref_table ad_display numeric 10 Column that will display
ad_ref_table ad_key numeric 10 Unique identifier of a record
ad_clientinfo ad_org_id numeric 10 Organizational entity within client
ad_orginfo ad_org_id numeric 10 Organizational entity within client
ad_process_access ad_org_id numeric 10 Organizational entity within client
ad_ref_table ad_org_id numeric 10 Organizational entity within client
ad_sequence_audit ad_org_id numeric 10 Organizational entity within client
ad_sequence_no ad_org_id numeric 10 Organizational entity within client
ad_table_access ad_org_id numeric 10 Organizational entity within client
ad_task_access ad_org_id numeric 10 Organizational entity within client
ad_user_roles ad_org_id numeric 10 Organizational entity within client
ad_wf_nodenext ad_org_id numeric 10 Organizational entity within client
ad_window_access ad_org_id numeric 10 Organizational entity within client
ad_workflow_access ad_org_id numeric 10 Organizational entity within client
c_conversion_rate ad_org_id numeric 10 Organizational entity within client
m_product_po ad_org_id numeric 10 Organizational entity within client
m_replenish ad_org_id numeric 10 Organizational entity within client
ad_pinstance_para ad_pinstance_id numeric 10 Instance of the process
ad_process_access ad_process_id numeric 10 Process or Report
ad_ref_table ad_reference_id numeric 10 System Reference and Validation
ad_process_access ad_role_id numeric 10 Responsibility Role
ad_table_access ad_role_id numeric 10 Responsibility Role
ad_task_access ad_role_id numeric 10 Responsibility Role
ad_user_roles ad_role_id numeric 10 Responsibility Role
ad_window_access ad_role_id numeric 10 Responsibility Role
ad_workflow_access ad_role_id numeric 10 Responsibility Role
ad_sequence_audit ad_sequence_id numeric 10 Document Sequence
ad_sequence_no ad_sequence_id numeric 10 Document Sequence
ad_ref_table ad_table_id numeric 10 Database Table information
ad_sequence_audit ad_table_id numeric 10 Database Table information
ad_table_access ad_table_id numeric 10 Database Table information
ad_task_access ad_task_id numeric 10 Operation System Task
ad_user_roles ad_user_id numeric 10 User within the system - Internal or Business Partner Contact
ad_wf_nodenext ad_wf_next_id numeric 10 Next Node in workflow
ad_wf_nodenext ad_wf_node_id numeric 10 Workflow Node (activity), step or process
ad_wf_nodenext ad_wf_nodenext_id numeric 10 Workflow Node Transition
ad_window_access ad_window_id numeric 10 Data entry or display window
ad_workflow_access ad_workflow_id numeric 10 Workflow or combination of tasks
m_product_po c_bpartner_id numeric 10 Identifies a Business Partner
c_conversion_rate c_conversion_rate_id numeric 10 Rate used for converting currencies
c_conversion_rate c_conversiontype_id numeric 10 Currency Conversion Rate Type
c_conversion_rate c_currency_id numeric 10 The Currency for this record
c_conversion_rate c_currency_id_to numeric 10 Target currency
ad_clientinfo createdby numeric 10 User who created this records
ad_orginfo createdby numeric 10 User who created this records
ad_process_access createdby numeric 10 User who created this records
ad_ref_table createdby numeric 10 User who created this records
ad_sequence_audit createdby numeric 10 User who created this records
ad_sequence_no createdby numeric 10 User who created this records
ad_table_access createdby numeric 10 User who created this records
ad_task_access createdby numeric 10 User who created this records
ad_user_roles createdby numeric 10 User who created this records
ad_wf_nodenext createdby numeric 10 User who created this records
ad_window_access createdby numeric 10 User who created this records
ad_workflow_access createdby numeric 10 User who created this records
c_conversion_rate createdby numeric 10 User who created this records
m_product_po createdby numeric 10 User who created this records
m_replenish createdby numeric 10 User who created this records
ad_sequence_no currentnext numeric 10 The next number to be used
ad_sequence_audit documentno varchar 30 Document sequence number of the document
ad_orginfo duns varchar 11 Dun & Bradstreet Number
m_product_po m_product_id numeric 10 Product, Service, Item
m_replenish m_product_id numeric 10 Product, Service, Item
m_replenish m_warehouse_id numeric 10 Storage Warehouse and Service Point
ad_sequence_audit record_id numeric 10 Direct internal record ID
m_replenish replenishtype bpchar 1 Method for re-ordering a product
ad_pinstance_para seqno numeric 10 Method of ordering records; lowest number comes first
ad_wf_nodenext seqno numeric 10 Method of ordering records; lowest number comes first
ad_orginfo taxid varchar 20 Tax Identification
ad_clientinfo updatedby numeric 10 User who updated this records
ad_orginfo updatedby numeric 10 User who updated this records
ad_process_access updatedby numeric 10 User who updated this records
ad_ref_table updatedby numeric 10 User who updated this records
ad_sequence_audit updatedby numeric 10 User who updated this records
ad_sequence_no updatedby numeric 10 User who updated this records
ad_table_access updatedby numeric 10 User who updated this records
ad_task_access updatedby numeric 10 User who updated this records
ad_user_roles updatedby numeric 10 User who updated this records
ad_wf_nodenext updatedby numeric 10 User who updated this records
ad_window_access updatedby numeric 10 User who updated this records
ad_workflow_access updatedby numeric 10 User who updated this records
c_conversion_rate updatedby numeric 10 User who updated this records
m_product_po updatedby numeric 10 User who updated this records
m_replenish updatedby numeric 10 User who updated this records
c_conversion_rate validfrom timestamp 29,6 Valid from including this date (first day)
m_product_po vendorproductno varchar 40 Product Key of the Business Partner
ad_clientinfo ad_clientinfo_uu varchar 36  √  NULL::character varying AD_ClientInfo_UU
ad_orginfo ad_orginfo_uu varchar 36  √  NULL::character varying AD_OrgInfo_UU
ad_pinstance_para ad_pinstance_para_uu varchar 36  √  NULL::character varying AD_PInstance_Para_UU
ad_process_access ad_process_access_uu varchar 36  √  NULL::character varying AD_Process_Access_UU
ad_ref_table ad_ref_table_uu varchar 36  √  NULL::character varying AD_Ref_Table_UU
ad_sequence_audit ad_sequence_audit_uu varchar 36  √  NULL::character varying AD_Sequence_Audit_UU
ad_sequence_no ad_sequence_no_uu varchar 36  √  NULL::character varying AD_Sequence_No_UU
ad_table_access ad_table_access_uu varchar 36  √  NULL::character varying AD_Table_Access_UU
ad_task_access ad_task_access_uu varchar 36  √  NULL::character varying AD_Task_Access_UU
ad_user_roles ad_user_roles_uu varchar 36  √  NULL::character varying AD_User_Roles_UU
ad_wf_nodenext ad_wf_nodenext_uu varchar 36  √  NULL::character varying AD_WF_NodeNext_UU
ad_window_access ad_window_access_uu varchar 36  √  NULL::character varying AD_Window_Access_UU
ad_workflow_access ad_workflow_access_uu varchar 36  √  NULL::character varying AD_Workflow_Access_UU
c_conversion_rate c_conversion_rate_uu varchar 36  √  NULL::character varying C_Conversion_Rate_UU
ad_orginfo email varchar 60  √  NULL::character varying Electronic Mail Address
ad_orginfo fax varchar 40  √  NULL::character varying Facsimile number
m_product_po m_product_po_uu varchar 36  √  NULL::character varying M_Product_PO_UU
m_replenish m_replenish_uu varchar 36  √  NULL::character varying M_Replenish_UU
ad_orginfo phone varchar 40  √  NULL::character varying Identifies a telephone number
ad_orginfo phone2 varchar 40  √  NULL::character varying Identifies an alternate telephone number.
ad_ref_table ad_infowindow_id numeric 10  √  NULL::numeric Info and search/select Window
ad_clientinfo ad_storageprovider_id numeric 10  √  NULL::numeric Storage Provider
ad_clientinfo c_chargefreight_id numeric 10  √  NULL::numeric Charge for Freight
ad_clientinfo logo_id numeric 10  √  NULL::numeric Logo
ad_orginfo logo_id numeric 10  √  NULL::numeric Logo
ad_clientinfo logoreport_id numeric 10  √  NULL::numeric Logo Report
ad_clientinfo logoweb_id numeric 10  √  NULL::numeric Logo Web
ad_clientinfo storagearchive_id numeric 10  √  NULL::numeric Archive Store
ad_clientinfo storageimage_id numeric 10  √  NULL::numeric Storage provider for Image
ad_pinstance_para created timestamp 29,6 statement_timestamp() Date this record was created
ad_pinstance_para updated timestamp 29,6 statement_timestamp() Date this record was updated