SchemaSpy Analysis of idempiere11.adempiere - ColumnsPerformance Analysis Generated by
Quality Systems & Solutions
Generated on 2024-01-03 13:53 +0100
Legend:
Primary key columns
Columns with indexes
 

idempiere11.adempiere contains 1005 columns - click on heading to sort:
Table Column Type Size Nulls Auto Default
m_product_category a_asset_group_id numeric 10  √  null Group of Assets
ad_table accesslevel bpchar 1 Access Level required
pa_ratioelement account_id numeric 10  √  null Account used
c_elementvalue accountsign bpchar 1 Indicates the Natural Sign of the Account as a Debit or Credit
c_elementvalue accounttype bpchar 1 Indicates the type of account
pa_benchmark accumulationtype bpchar 1 How to accumulate data on time axis
c_bpartner acqusitioncost numeric 0  √  0 The cost of gaining the prospect as a customer
c_bpartner actuallifetimevalue numeric 0  √  0 Actual Life Time Revenue
ad_alert ad_alert_id numeric 10 iDempiere Alert
ad_alertrecipient ad_alert_id numeric 10 iDempiere Alert
ad_alertrule ad_alert_id numeric 10 iDempiere Alert
ad_alert ad_alert_uu varchar 36  √  NULL::character varying AD_Alert_UU
ad_alert ad_alertprocessor_id numeric 10  √  null Alert Processor/Server Parameter
ad_alertrecipient ad_alertrecipient_id numeric 10 Recipient of the Alert Notification
ad_alertrecipient ad_alertrecipient_uu varchar 36  √  NULL::character varying AD_AlertRecipient_UU
ad_alertrule ad_alertrule_id numeric 10 Definition of the alert element
ad_alertrule ad_alertrule_uu varchar 36  √  NULL::character varying AD_AlertRule_UU
ad_chart ad_chart_id numeric 10 Chart
ad_chartdatasource ad_chart_id numeric 10 Chart
pa_dashboardcontent ad_chart_id numeric 10  √  NULL::numeric Chart
ad_chart ad_chart_uu varchar 36  √  NULL::character varying AD_Chart_UU
ad_chartdatasource ad_chartdatasource_id numeric 10 Chart Datasource
ad_chartdatasource_trl ad_chartdatasource_id numeric 10 Chart Datasource
ad_chartdatasource_trl ad_chartdatasource_trl_uu varchar 36  √  NULL::character varying AD_ChartDatasource_Trl_UU
ad_chartdatasource ad_chartdatasource_uu varchar 36  √  NULL::character varying AD_ChartDatasource_UU
ad_alert ad_client_id numeric 10 Tenant for this installation.
ad_alertrecipient ad_client_id numeric 10 Tenant for this installation.
ad_alertrule ad_client_id numeric 10 Tenant for this installation.
ad_chart ad_client_id numeric 10 Tenant for this installation.
ad_chartdatasource ad_client_id numeric 10 Tenant for this installation.
ad_chartdatasource_trl ad_client_id numeric 10 Tenant for this installation.
ad_org ad_client_id numeric 10 Tenant for this installation.
ad_printcolor ad_client_id numeric 10 Tenant for this installation.
ad_role ad_client_id numeric 10 Tenant for this installation.
ad_table ad_client_id numeric 10 Tenant for this installation.
ad_user ad_client_id numeric 10 Tenant for this installation.
c_acctschema ad_client_id numeric 10 Tenant for this installation.
c_bp_group ad_client_id numeric 10 Tenant for this installation.
c_bpartner ad_client_id numeric 10 Tenant for this installation.
c_elementvalue ad_client_id numeric 10 Tenant for this installation.
c_phase ad_client_id numeric 10 Tenant for this installation.
c_projecttype ad_client_id numeric 10 Tenant for this installation.
m_product ad_client_id numeric 10 Tenant for this installation.
m_product_category ad_client_id numeric 10 Tenant for this installation.
pa_achievement ad_client_id numeric 10 Tenant for this installation.
pa_benchmark ad_client_id numeric 10 Tenant for this installation.
pa_benchmarkdata ad_client_id numeric 10 Tenant for this installation.
pa_colorschema ad_client_id numeric 10 Tenant for this installation.
pa_dashboardcontent ad_client_id numeric 10 Tenant for this installation.
pa_dashboardcontent_access ad_client_id numeric 10  √  NULL::numeric Tenant for this installation.
pa_dashboardpreference ad_client_id numeric 10 Tenant for this installation.
pa_documentstatus ad_client_id numeric 10 Tenant for this installation.
pa_documentstatusaccess ad_client_id numeric 10 Tenant for this installation.
pa_goal ad_client_id numeric 10 Tenant for this installation.
pa_goalrestriction ad_client_id numeric 10 Tenant for this installation.
pa_hierarchy ad_client_id numeric 10 Tenant for this installation.
pa_measure ad_client_id numeric 10 Tenant for this installation.
pa_measurecalc ad_client_id numeric 10 Tenant for this installation.
pa_ratio ad_client_id numeric 10 Tenant for this installation.
pa_ratioelement ad_client_id numeric 10 Tenant for this installation.
pa_reportcube ad_client_id numeric 10 Tenant for this installation.
pa_sla_criteria ad_client_id numeric 10 Tenant for this installation.
pa_sla_goal ad_client_id numeric 10 Tenant for this installation.
pa_sla_measure ad_client_id numeric 10 Tenant for this installation.
r_requesttype ad_client_id numeric 10 Tenant for this installation.
r_status ad_client_id numeric 10 Tenant for this installation.
pa_documentstatus ad_form_id numeric 10  √  null Special Form
ad_user ad_image_id numeric 10  √  NULL::numeric Image or Icon
ad_chartdatasource_trl ad_language varchar 6 Language for this entity
c_bpartner ad_language varchar 6  √  null Language for this entity
ad_alert ad_org_id numeric 10 Organizational entity within tenant
ad_alertrecipient ad_org_id numeric 10 Organizational entity within tenant
ad_alertrule ad_org_id numeric 10 Organizational entity within tenant
ad_chart ad_org_id numeric 10 Organizational entity within tenant
ad_chartdatasource ad_org_id numeric 10 Organizational entity within tenant
ad_chartdatasource_trl ad_org_id numeric 10 Organizational entity within tenant
ad_org ad_org_id numeric 10 Organizational entity within tenant
ad_printcolor ad_org_id numeric 10 Organizational entity within tenant
ad_role ad_org_id numeric 10 Organizational entity within tenant
ad_table ad_org_id numeric 10 Organizational entity within tenant
ad_user ad_org_id numeric 10 Organizational entity within tenant
c_acctschema ad_org_id numeric 10 Organizational entity within tenant
c_bp_group ad_org_id numeric 10 Organizational entity within tenant
c_bpartner ad_org_id numeric 10 Organizational entity within tenant
c_elementvalue ad_org_id numeric 10 Organizational entity within tenant
c_phase ad_org_id numeric 10 Organizational entity within tenant
c_projecttype ad_org_id numeric 10 Organizational entity within tenant
m_product ad_org_id numeric 10 Organizational entity within tenant
m_product_category ad_org_id numeric 10 Organizational entity within tenant
pa_achievement ad_org_id numeric 10 Organizational entity within tenant
pa_benchmark ad_org_id numeric 10 Organizational entity within tenant
pa_benchmarkdata ad_org_id numeric 10 Organizational entity within tenant
pa_colorschema ad_org_id numeric 10 Organizational entity within tenant
pa_dashboardcontent ad_org_id numeric 10 Organizational entity within tenant
pa_dashboardcontent_access ad_org_id numeric 10  √  NULL::numeric Organizational entity within tenant
pa_dashboardpreference ad_org_id numeric 10 Organizational entity within tenant
pa_documentstatus ad_org_id numeric 10 Organizational entity within tenant
pa_documentstatusaccess ad_org_id numeric 10 Organizational entity within tenant
pa_goal ad_org_id numeric 10 Organizational entity within tenant
pa_goalrestriction ad_org_id numeric 10 Organizational entity within tenant
pa_hierarchy ad_org_id numeric 10 Organizational entity within tenant
pa_measure ad_org_id numeric 10 Organizational entity within tenant
pa_measurecalc ad_org_id numeric 10 Organizational entity within tenant
pa_ratio ad_org_id numeric 10 Organizational entity within tenant
pa_ratioelement ad_org_id numeric 10 Organizational entity within tenant
pa_reportcube ad_org_id numeric 10 Organizational entity within tenant
pa_sla_criteria ad_org_id numeric 10 Organizational entity within tenant
pa_sla_goal ad_org_id numeric 10 Organizational entity within tenant
pa_sla_measure ad_org_id numeric 10 Organizational entity within tenant
r_requesttype ad_org_id numeric 10 Organizational entity within tenant
r_status ad_org_id numeric 10 Organizational entity within tenant
ad_org ad_org_uu varchar 36  √  NULL::character varying AD_Org_UU
c_bpartner ad_orgbp_id numeric 10  √  null The Business Partner is another Organization for explicit Inter-Org transactions
c_acctschema ad_orgonly_id numeric 10  √  null Create posting entries only for this organization
ad_user ad_orgtrx_id numeric 10  √  null Performing or initiating organization
pa_colorschema ad_printcolor1_id numeric 10 First color used
pa_colorschema ad_printcolor2_id numeric 10 Second color used
pa_colorschema ad_printcolor3_id numeric 10  √  null Third color used
pa_colorschema ad_printcolor4_id numeric 10  √  null Forth color used
ad_printcolor ad_printcolor_id numeric 10 Color used for printing and display
c_bp_group ad_printcolor_id numeric 10  √  null Color used for printing and display
m_product_category ad_printcolor_id numeric 10  √  null Color used for printing and display
ad_printcolor ad_printcolor_uu varchar 36  √  NULL::character varying AD_PrintColor_UU
pa_dashboardcontent ad_printformat_id numeric 10  √  NULL::numeric Data Print Format
pa_dashboardcontent ad_process_id numeric 10  √  NULL::numeric Process or Report
ad_org ad_replicationstrategy_id numeric 0  √  null Data Replication Strategy
ad_alertrecipient ad_role_id numeric 10  √  null Responsibility Role
ad_role ad_role_id numeric 10 Responsibility Role
pa_dashboardcontent ad_role_id numeric 10  √  0 Responsibility Role
pa_dashboardcontent_access ad_role_id numeric 10  √  NULL::numeric Responsibility Role
pa_dashboardpreference ad_role_id numeric 10 0 Responsibility Role
pa_documentstatus ad_role_id numeric 10  √  null Responsibility Role
pa_documentstatusaccess ad_role_id numeric 10  √  NULL::numeric Responsibility Role
pa_goal ad_role_id numeric 10  √  null Responsibility Role
ad_role ad_role_uu varchar 36  √  NULL::character varying AD_Role_UU
pa_dashboardcontent ad_statusline_id numeric 10  √  NULL::numeric Status Line
ad_alertrule ad_table_id numeric 10  √  null Database Table information
ad_chartdatasource ad_table_id numeric 10  √  null Database Table information
ad_table ad_table_id numeric 10 Database Table information
pa_documentstatus ad_table_id numeric 10 Database Table information
pa_measurecalc ad_table_id numeric 10 Database Table information
pa_sla_measure ad_table_id numeric 10  √  null Database Table information
ad_table ad_table_uu varchar 36  √  NULL::character varying AD_Table_UU
pa_hierarchy ad_tree_account_id numeric 10 Tree for Natural Account Tree
pa_hierarchy ad_tree_activity_id numeric 10 Trees are used for (financial) reporting
pa_hierarchy ad_tree_bpartner_id numeric 10 Trees are used for (financial) reporting
pa_hierarchy ad_tree_campaign_id numeric 10 Trees are used for (financial) reporting
ad_role ad_tree_menu_id numeric 10  √  null Tree of the menu
ad_role ad_tree_org_id numeric 10  √  null Trees are used for (financial) reporting and security access (via role)
pa_hierarchy ad_tree_org_id numeric 10 Trees are used for (financial) reporting and security access (via role)
pa_hierarchy ad_tree_product_id numeric 10 Trees are used for (financial) reporting
pa_hierarchy ad_tree_project_id numeric 10 Trees are used for (financial) reporting
pa_hierarchy ad_tree_salesregion_id numeric 10 Trees are used for (financial) reporting
ad_alertrecipient ad_user_id numeric 10  √  null User within the system - Internal or Business Partner Contact
ad_user ad_user_id numeric 10 User within the system - Internal or Business Partner Contact
pa_dashboardcontent ad_user_id numeric 10  √  0 User within the system - Internal or Business Partner Contact
pa_dashboardcontent_access ad_user_id numeric 10  √  NULL::numeric User within the system - Internal or Business Partner Contact
pa_dashboardpreference ad_user_id numeric 10 0 User within the system - Internal or Business Partner Contact
pa_documentstatus ad_user_id numeric 10  √  null User within the system - Internal or Business Partner Contact
pa_documentstatusaccess ad_user_id numeric 10  √  NULL::numeric User within the system - Internal or Business Partner Contact
pa_goal ad_user_id numeric 10  √  null User within the system - Internal or Business Partner Contact
ad_user ad_user_uu varchar 36  √  NULL::character varying AD_User_UU
ad_table ad_val_rule_id numeric 10  √  null Dynamic Validation Rule
ad_table ad_window_id numeric 10  √  null Data entry or display window
pa_dashboardcontent ad_window_id numeric 10  √  null Data entry or display window
pa_documentstatus ad_window_id numeric 10  √  null Data entry or display window
ad_alert alertmessage varchar 2000 Message of the Alert
ad_alert alertsubject varchar 255 Subject of the Alert
ad_role allow_info_account bpchar 1 'Y'::bpchar Allow Info Account
ad_role allow_info_asset bpchar 1 'Y'::bpchar Allow Info Asset
ad_role allow_info_bpartner bpchar 1 'Y'::bpchar Allow Info BPartner
ad_role allow_info_cashjournal bpchar 1 'N'::bpchar Allow Info Cash Journal
ad_role allow_info_crp bpchar 1 'N'::bpchar Allow Info CRP
ad_role allow_info_inout bpchar 1 'Y'::bpchar Allow Info InOut
ad_role allow_info_invoice bpchar 1 'Y'::bpchar Allow Info Invoice
ad_role allow_info_mrp bpchar 1 'N'::bpchar Allow Info MRP
ad_role allow_info_order bpchar 1 'Y'::bpchar Allow Info Order
ad_role allow_info_payment bpchar 1 'Y'::bpchar Allow Info Payment
ad_role allow_info_product bpchar 1 'Y'::bpchar Allow Info Product
ad_role allow_info_resource bpchar 1 'Y'::bpchar Allow Info Resource
ad_role allow_info_schedule bpchar 1 'Y'::bpchar Allow Info Schedule
ad_role amtapproval numeric 0  √  0 The approval amount limit for this role
ad_role amtapprovalaccum numeric 0  √  null The approval amount limit for this role accumulated on a period
ad_user answer varchar 1024  √  NULL::character varying Answer
ad_user authenticationtype varchar 10  √  NULL::character varying Authentication Type
r_requesttype autoduedatedays numeric 10  √  null Automatic Due Date Days
c_acctschema autoperiodcontrol bpchar 1 'N'::bpchar If selected, the periods are automatically opened and closed
pa_benchmarkdata benchmarkdate timestamp 29,6 Benchmark Date
pa_benchmarkdata benchmarkvalue numeric 0 Benchmark Value
ad_user birthday timestamp 29,6  √  null Birthday or Anniversary day
ad_user bp_location_id numeric 10  √  NULL::numeric Address of the Business Partner
c_bpartner bpartner_parent_id numeric 10  √  null Business Partner Parent
pa_measurecalc bpartnercolumn varchar 60  √  null Fully qualified Business Partner key column (C_BPartner_ID)
c_elementvalue bpartnertype bpchar 1  √  NULL::bpchar Business Partner Type
ad_user bpname varchar 60  √  NULL::character varying BP Name
c_acctschema c_acctschema_id numeric 10 Rules for accounting
pa_ratio c_acctschema_id numeric 10 Rules for accounting
c_acctschema c_acctschema_uu varchar 36  √  NULL::character varying C_AcctSchema_UU
c_elementvalue c_bankaccount_id numeric 10  √  null Account at the Bank
c_bp_group c_bp_group_id numeric 10 Business Partner Group
c_bpartner c_bp_group_id numeric 10 Business Partner Group
pa_goalrestriction c_bp_group_id numeric 10  √  null Business Partner Group
c_bp_group c_bp_group_uu varchar 36  √  NULL::character varying C_BP_Group_UU
ad_user c_bpartner_id numeric 10  √  null Identifies a Business Partner
c_bpartner c_bpartner_id numeric 10 Identifies a Business Partner
pa_goalrestriction c_bpartner_id numeric 10  √  null Identifies a Business Partner
pa_sla_goal c_bpartner_id numeric 10 Identifies a Business Partner
ad_user c_bpartner_location_id numeric 10  √  null Identifies the (ship to) address for this Business Partner
c_bpartner c_bpartner_uu varchar 36  √  NULL::character varying C_BPartner_UU
pa_reportcube c_calendar_id numeric 10 Accounting Calendar Name
ad_user c_campaign_id numeric 10  √  NULL::numeric Marketing Campaign
ad_role c_currency_id numeric 10  √  null The Currency for this record
c_acctschema c_currency_id numeric 10 The Currency for this record
c_elementvalue c_currency_id numeric 10  √  null The Currency for this record
c_bp_group c_dunning_id numeric 10  √  null Dunning Rules for overdue invoices
c_bpartner c_dunning_id numeric 10  √  null Dunning Rules for overdue invoices
c_elementvalue c_element_id numeric 10 Accounting Element
c_elementvalue c_elementvalue_id numeric 10 Account Element
c_elementvalue c_elementvalue_uu varchar 36  √  NULL::character varying C_ElementValue_UU
ad_user c_greeting_id numeric 10  √  null Greeting to print on correspondence
c_bpartner c_greeting_id numeric 10  √  null Greeting to print on correspondence
c_bpartner c_invoiceschedule_id numeric 10  √  null Schedule for generating Invoices
ad_user c_job_id numeric 10  √  null Job Position
ad_user c_location_id numeric 10  √  NULL::numeric Location or Address
c_bpartner c_paymentterm_id numeric 10  √  null The terms of Payment (timing, discount)
c_acctschema c_period_id numeric 10  √  null Period of the Calendar
c_phase c_phase_id numeric 10 Standard Phase of the Project Type
c_phase c_phase_uu varchar 36  √  NULL::character varying C_Phase_UU
pa_documentstatus c_project_id numeric 10  √  null Financial Project
c_phase c_projecttype_id numeric 10 Type of the project
c_projecttype c_projecttype_id numeric 10 Type of the project
pa_measure c_projecttype_id numeric 10  √  null Type of the project
c_projecttype c_projecttype_uu varchar 36  √  NULL::character varying C_ProjectType_UU
m_product c_revenuerecognition_id numeric 10  √  null Method for recording revenue
m_product c_subscriptiontype_id numeric 10  √  null Type of subscription
m_product c_taxcategory_id numeric 10 Tax Category
c_bpartner c_taxgroup_id numeric 10  √  null Tax Group
m_product c_uom_id numeric 10 Unit of Measure
pa_measure calculationclass varchar 60  √  null Java Class for calculation, implementing Interface Measure
ad_chartdatasource categorycolumn varchar 60  √  null Fully qualified data category column
ad_chart chartorientation bpchar 1 'V'::bpchar The orientation of the chart.
ad_chart charttype varchar 2 Type of chart to render
pa_goal charttype varchar 2 'BC'::character varying Type of chart to render
m_product classification varchar 12  √  null Classification for grouping
pa_sla_criteria classname varchar 60  √  null Java Classname
ad_printcolor code varchar 2000 Validation Code
pa_dashboardcontent columnno numeric 10  √  (1)::numeric Dashboard content column number
pa_dashboardpreference columnno numeric 10  √  1 Dashboard content column number
ad_user comments varchar 2000  √  null Comments or additional information
c_acctschema commitmenttype bpchar 1 'N'::bpchar Create Commitment and/or Reservations for Budget Control
r_requesttype confidentialtype bpchar 1 'C'::bpchar Type of Confidentiality
ad_role confirmqueryrecords numeric 10 0 Require Confirmation if more records will be returned by the query (If not defined 500)
ad_role connectionprofile bpchar 1  √  null How a Java Tenant connects to the server(s)
ad_user connectionprofile bpchar 1  √  null How a Java Tenant connects to the server(s)
pa_ratioelement constantvalue numeric 0  √  null Constant value
r_requesttype contentcolor varchar 7  √  NULL::character varying Content color of calendar dashlet
ad_table copycolumnsfromtable varchar 1  √  null Copy Columns From Table
ad_table copycomponentsfromview bpchar 1  √  NULL::bpchar Copy Components From View
m_product copyfrom bpchar 1  √  NULL::bpchar Copy From Record
c_acctschema costinglevel bpchar 1 'C'::bpchar The lowest level to accumulate Costing Information
c_acctschema costingmethod bpchar 1 Indicates how Costs will be calculated
ad_alert created timestamp 29,6 now() Date this record was created
ad_alertrecipient created timestamp 29,6 now() Date this record was created
ad_alertrule created timestamp 29,6 now() Date this record was created
ad_chart created timestamp 29,6 statement_timestamp() Date this record was created
ad_chartdatasource created timestamp 29,6 statement_timestamp() Date this record was created
ad_chartdatasource_trl created timestamp 29,6 statement_timestamp() Date this record was created
ad_org created timestamp 29,6 now() Date this record was created
ad_printcolor created timestamp 29,6 now() Date this record was created
ad_role created timestamp 29,6 now() Date this record was created
ad_table created timestamp 29,6 now() Date this record was created
ad_user created timestamp 29,6 now() Date this record was created
c_acctschema created timestamp 29,6 now() Date this record was created
c_bp_group created timestamp 29,6 now() Date this record was created
c_bpartner created timestamp 29,6 now() Date this record was created
c_elementvalue created timestamp 29,6 now() Date this record was created
c_phase created timestamp 29,6 now() Date this record was created
c_projecttype created timestamp 29,6 now() Date this record was created
m_product created timestamp 29,6 now() Date this record was created
m_product_category created timestamp 29,6 now() Date this record was created
pa_achievement created timestamp 29,6 now() Date this record was created
pa_benchmark created timestamp 29,6 now() Date this record was created
pa_benchmarkdata created timestamp 29,6 now() Date this record was created
pa_colorschema created timestamp 29,6 now() Date this record was created
pa_dashboardcontent created timestamp 29,6 statement_timestamp() Date this record was created
pa_dashboardcontent_access created timestamp 29,6 statement_timestamp() Date this record was created
pa_dashboardpreference created timestamp 29,6 statement_timestamp() Date this record was created
pa_documentstatus created timestamp 29,6 Date this record was created
pa_documentstatusaccess created timestamp 29,6 statement_timestamp() Date this record was created
pa_goal created timestamp 29,6 now() Date this record was created
pa_goalrestriction created timestamp 29,6 now() Date this record was created
pa_hierarchy created timestamp 29,6 now() Date this record was created
pa_measure created timestamp 29,6 now() Date this record was created
pa_measurecalc created timestamp 29,6 now() Date this record was created
pa_ratio created timestamp 29,6 now() Date this record was created
pa_ratioelement created timestamp 29,6 now() Date this record was created
pa_reportcube created timestamp 29,6 statement_timestamp() Date this record was created
pa_sla_criteria created timestamp 29,6 now() Date this record was created
pa_sla_goal created timestamp 29,6 now() Date this record was created
pa_sla_measure created timestamp 29,6 now() Date this record was created
r_requesttype created timestamp 29,6 now() Date this record was created
r_status created timestamp 29,6 now() Date this record was created
ad_alert createdby numeric 10 User who created this records
ad_alertrecipient createdby numeric 10 User who created this records
ad_alertrule createdby numeric 10 User who created this records
ad_chart createdby numeric 10 User who created this records
ad_chartdatasource createdby numeric 10 User who created this records
ad_chartdatasource_trl createdby numeric 10 User who created this records
ad_org createdby numeric 10 User who created this records
ad_printcolor createdby numeric 10 User who created this records
ad_role createdby numeric 10 User who created this records
ad_table createdby numeric 10 User who created this records
ad_user createdby numeric 10 User who created this records
c_acctschema createdby numeric 10 User who created this records
c_bp_group createdby numeric 10 User who created this records
c_bpartner createdby numeric 10 User who created this records
c_elementvalue createdby numeric 10 User who created this records
c_phase createdby numeric 10 User who created this records
c_projecttype createdby numeric 10 User who created this records
m_product createdby numeric 10 User who created this records
m_product_category createdby numeric 10 User who created this records
pa_achievement createdby numeric 10 User who created this records
pa_benchmark createdby numeric 10 User who created this records
pa_benchmarkdata createdby numeric 10 User who created this records
pa_colorschema createdby numeric 10 User who created this records
pa_dashboardcontent createdby numeric 10 User who created this records
pa_dashboardcontent_access createdby numeric 10  √  NULL::numeric User who created this records
pa_dashboardpreference createdby numeric 10 User who created this records
pa_documentstatus createdby numeric 10 User who created this records
pa_documentstatusaccess createdby numeric 10 User who created this records
pa_goal createdby numeric 10 User who created this records
pa_goalrestriction createdby numeric 10 User who created this records
pa_hierarchy createdby numeric 10 User who created this records
pa_measure createdby numeric 10 User who created this records
pa_measurecalc createdby numeric 10 User who created this records
pa_ratio createdby numeric 10 User who created this records
pa_ratioelement createdby numeric 10 User who created this records
pa_reportcube createdby numeric 10 User who created this records
pa_sla_criteria createdby numeric 10 User who created this records
pa_sla_goal createdby numeric 10 User who created this records
pa_sla_measure createdby numeric 10 User who created this records
r_requesttype createdby numeric 10 User who created this records
r_status createdby numeric 10 User who created this records
ad_table createpartition bpchar 1  √  NULL::bpchar Process which create or update table partitions based on the table and column records
ad_table createwindowfromtable bpchar 1  √  NULL::bpchar Create Window From Table
c_bp_group creditwatchpercent numeric 0  √  null Credit Watch - Percent of Credit Limit when OK switches to Watch
c_bpartner customerprofileid varchar 60  √  NULL::character varying Customer Profile ID
m_product customstariffnumber varchar 20  √  null Customs Tariff Number, usually the HS-Code
ad_table databaseviewdrop bpchar 1  √  NULL::bpchar Drop view
ad_user dateaccountlocked timestamp 29,6  √  null Date Account Locked
ad_chartdatasource datecolumn varchar 60  √  NULL::character varying Fully qualified date column
pa_measurecalc datecolumn varchar 60 Fully qualified date column
pa_achievement datedoc timestamp 29,6  √  null Date of the Document
pa_goal datefrom timestamp 29,6  √  null Starting date for a range
ad_user datelastlogin timestamp 29,6  √  null Date Last Login
pa_goal datelastrun timestamp 29,6  √  null Date the process was last run.
pa_sla_goal datelastrun timestamp 29,6  √  null Date the process was last run.
ad_user datepasswordchanged timestamp 29,6  √  null Date Password Changed
pa_goal dateto timestamp 29,6  √  null End date of a date range
pa_sla_measure datetrx timestamp 29,6 Transaction Date
ad_role daysapprovalaccum numeric 10  √  null The days approval indicates the days to take into account to verify the accumulated approval amount.
c_bpartner default1099box_id numeric 10  √  NULL::numeric Default 1099 Box
c_bpartner deliveryrule bpchar 1  √  null Defines the timing of Delivery
c_bpartner deliveryviarule bpchar 1  √  null How the order will be delivered
ad_alert description varchar 255  √  null Optional short description of the record
ad_chart description varchar 255  √  NULL::character varying Optional short description of the record
ad_chartdatasource description varchar 255  √  NULL::character varying Optional short description of the record
ad_org description varchar 255  √  null Optional short description of the record
ad_role description varchar 255  √  null Optional short description of the record
ad_table description varchar 255  √  null Optional short description of the record
ad_user description varchar 255  √  null Optional short description of the record
c_acctschema description varchar 255  √  null Optional short description of the record
c_bp_group description varchar 255  √  null Optional short description of the record
c_bpartner description varchar 255  √  null Optional short description of the record
c_elementvalue description varchar 255  √  null Optional short description of the record
c_phase description varchar 255  √  null Optional short description of the record
c_projecttype description varchar 255  √  null Optional short description of the record
m_product description varchar 255  √  null Optional short description of the record
m_product_category description varchar 255  √  null Optional short description of the record
pa_achievement description varchar 255  √  null Optional short description of the record
pa_benchmark description varchar 255  √  null Optional short description of the record
pa_benchmarkdata description varchar 255  √  null Optional short description of the record
pa_colorschema description varchar 255  √  null Optional short description of the record
pa_dashboardcontent description varchar 255  √  null Optional short description of the record
pa_documentstatus description varchar 255  √  null Optional short description of the record
pa_goal description varchar 255  √  null Optional short description of the record
pa_hierarchy description varchar 255  √  null Optional short description of the record
pa_measure description varchar 255  √  null Optional short description of the record
pa_measurecalc description varchar 255  √  null Optional short description of the record
pa_ratio description varchar 255  √  null Optional short description of the record
pa_ratioelement description varchar 255  √  null Optional short description of the record
pa_reportcube description varchar 255  √  NULL::character varying Optional short description of the record
pa_sla_criteria description varchar 255  √  null Optional short description of the record
pa_sla_goal description varchar 255  √  null Optional short description of the record
pa_sla_measure description varchar 255  √  null Optional short description of the record
r_requesttype description varchar 255  √  null Optional short description of the record
r_status description varchar 255  √  null Optional short description of the record
m_product descriptionurl varchar 120  √  null URL for the description
m_product discontinued bpchar 1  √  'N'::bpchar This product is no longer available
m_product discontinuedat timestamp 29,6  √  null Discontinued At indicates Date when product was discontinued
m_product discontinuedby timestamp 29,6  √  null
c_bpartner documentcopies numeric 10  √  null Number of copies to be printed
m_product documentnote varchar 2000  √  null Additional information for a Document
ad_chart domainlabel varchar 60  √  NULL::character varying Label for the domain axis.
m_product downloadurl varchar 120  √  null
r_requesttype duedatetolerance numeric 10 7 Tolerance in days between the Date Next Action and the date the request is regarded as overdue
c_bpartner dunninggrace timestamp 29,6  √  null Dunning Grace Date
c_bpartner duns varchar 11  √  null Dun & Bradstreet Number
ad_user email varchar 60  √  null Electronic Mail Address
ad_user emailuser varchar 60  √  null User Name (ID) in the Mail System
ad_user emailuserpw varchar 255  √  null Password of your email user id
ad_user emailverify varchar 40  √  null Verification information of EMail Address
ad_user emailverifydate timestamp 29,6  √  null Date Email was verified
ad_alert enforceclientsecurity bpchar 1 'Y'::bpchar Send alerts to recipient only if the tenant security rules of the role allows
ad_alert enforcerolesecurity bpchar 1 'Y'::bpchar Send alerts to recipient only if the data security rules of the role allows
ad_chart entitytype varchar 40 'U'::character varying Dictionary Entity Type; Determines ownership and synchronization
ad_chartdatasource entitytype varchar 40 'U'::character varying Dictionary Entity Type; Determines ownership and synchronization
ad_table entitytype varchar 40 'D'::character varying Dictionary Entity Type; Determines ownership and synchronization
pa_colorschema entitytype varchar 40 Dictionary Entity Type; Determines ownership and synchronization
pa_documentstatus entitytype varchar 40 'U'::character varying Dictionary Entity Type; Determines ownership and synchronization
pa_measurecalc entitytype varchar 40 Dictionary Entity Type; Determines ownership and synchronization
ad_alertrule errormsg varchar 2000  √  null Error Msg
ad_user failedlogincount numeric 10 (0)::numeric Failed Login Count
ad_user fax varchar 40  √  null Facsimile number
c_bpartner firstsale timestamp 29,6  √  null Date of First Sale
c_bpartner flatdiscount numeric 0  √  null Flat discount percentage
pa_dashboardpreference flexgrow numeric 10 '1'::numeric This defines the ability for a flex item to grow if necessary. It accepts a unitless value that serves as a proportion. It dictates what amount of the available space inside the flex container the item should take up.
c_bpartner freightcostrule bpchar 1  √  null Method for charging Freight
ad_alertrule fromclause varchar 2000 SQL FROM clause
ad_chartdatasource fromclause varchar 2000 SQL FROM clause
c_acctschema gaap bpchar 2 Generally Accepted Accounting Principles
pa_dashboardcontent goaldisplay bpchar 1  √  'T'::bpchar Type of goal display on dashboard
pa_goal goalperformance numeric 0  √  null Target achievement from 0..1
pa_goalrestriction goalrestrictiontype bpchar 1 Goal Restriction Type
m_product group1 varchar 255  √  null Group1
m_product group2 varchar 255  √  null Group2
m_product guaranteedays numeric 10  √  null Number of days the product is guaranteed or available
m_product guaranteedaysmin numeric 10  √  null Minimum number of guarantee days
c_acctschema hasalias bpchar 1 'Y'::bpchar Ability to select (partial) account combinations by an Alias
c_acctschema hascombination bpchar 1 'Y'::bpchar Combination of account elements are checked
r_requesttype headercolor varchar 7  √  NULL::character varying Header color of calendar dashlet
ad_alert help varchar 2000  √  null Comment or Hint
ad_table help varchar 2000  √  null Comment or Hint
c_phase help varchar 2000  √  null Comment or Hint
c_projecttype help varchar 2000  √  null Comment or Hint
m_product help varchar 2000  √  null Comment or Hint
pa_benchmark help varchar 2000  √  null Comment or Hint
pa_hierarchy help varchar 2000  √  null Comment or Hint
pa_ratio help varchar 2000  √  null Comment or Hint
pa_sla_criteria help varchar 2000  √  null Comment or Hint
pa_sla_goal help varchar 2000  √  null Comment or Hint
r_status help varchar 2000  √  null Comment or Hint
pa_dashboardcontent html text 2147483647  √  null HTML
m_product imageurl varchar 120  √  null URL of image
ad_table importtable bpchar 1  √  null Import Table Columns from Database
c_bpartner invoice_printformat_id numeric 10  √  null Print Format for printing Invoices
c_bpartner invoicerule bpchar 1  √  null Frequency and method of invoicing
c_bpartner is1099vendor bpchar 1 'N'::bpchar 1099 Vendor
ad_role isaccessadvanced bpchar 1  √  'N'::bpchar Access Advanced
ad_role isaccessallorgs bpchar 1 'N'::bpchar Access all Organizations (no org access control) of the tenant
c_acctschema isaccrual bpchar 1 'Y'::bpchar Indicates if Accrual or Cash Based accounting will be used
pa_achievement isachieved bpchar 1 The goal is achieved
ad_alert isactive bpchar 1 'Y'::bpchar The record is active in the system
ad_alertrecipient isactive bpchar 1 'Y'::bpchar The record is active in the system
ad_alertrule isactive bpchar 1 'Y'::bpchar The record is active in the system
ad_chart isactive bpchar 1  √  NULL::bpchar The record is active in the system
ad_chartdatasource isactive bpchar 1 'Y'::bpchar The record is active in the system
ad_chartdatasource_trl isactive bpchar 1 'Y'::bpchar The record is active in the system
ad_org isactive bpchar 1 'Y'::bpchar The record is active in the system
ad_printcolor isactive bpchar 1 'Y'::bpchar The record is active in the system
ad_role isactive bpchar 1 'Y'::bpchar The record is active in the system
ad_table isactive bpchar 1 'Y'::bpchar The record is active in the system
ad_user isactive bpchar 1 'Y'::bpchar The record is active in the system
c_acctschema isactive bpchar 1 'Y'::bpchar The record is active in the system
c_bp_group isactive bpchar 1 'Y'::bpchar The record is active in the system
c_bpartner isactive bpchar 1 'Y'::bpchar The record is active in the system
c_elementvalue isactive bpchar 1 'Y'::bpchar The record is active in the system
c_phase isactive bpchar 1 'Y'::bpchar The record is active in the system
c_projecttype isactive bpchar 1 'Y'::bpchar The record is active in the system
m_product isactive bpchar 1 'Y'::bpchar The record is active in the system
m_product_category isactive bpchar 1 'Y'::bpchar The record is active in the system
pa_achievement isactive bpchar 1 'Y'::bpchar The record is active in the system
pa_benchmark isactive bpchar 1 'Y'::bpchar The record is active in the system
pa_benchmarkdata isactive bpchar 1 'Y'::bpchar The record is active in the system
pa_colorschema isactive bpchar 1 'Y'::bpchar The record is active in the system
pa_dashboardcontent isactive bpchar 1 The record is active in the system
pa_dashboardcontent_access isactive bpchar 1  √  'Y'::bpchar The record is active in the system
pa_dashboardpreference isactive bpchar 1 The record is active in the system
pa_documentstatus isactive bpchar 1 'Y'::bpchar The record is active in the system
pa_documentstatusaccess isactive bpchar 1 'Y'::bpchar The record is active in the system
pa_goal isactive bpchar 1 'Y'::bpchar The record is active in the system
pa_goalrestriction isactive bpchar 1 'Y'::bpchar The record is active in the system
pa_hierarchy isactive bpchar 1 'Y'::bpchar The record is active in the system
pa_measure isactive bpchar 1 'Y'::bpchar The record is active in the system
pa_measurecalc isactive bpchar 1 'Y'::bpchar The record is active in the system
pa_ratio isactive bpchar 1 'Y'::bpchar The record is active in the system
pa_ratioelement isactive bpchar 1 'Y'::bpchar The record is active in the system
pa_reportcube isactive bpchar 1  √  NULL::bpchar The record is active in the system
pa_sla_criteria isactive bpchar 1 'Y'::bpchar The record is active in the system
pa_sla_goal isactive bpchar 1 'Y'::bpchar The record is active in the system
pa_sla_measure isactive bpchar 1 'Y'::bpchar The record is active in the system
r_requesttype isactive bpchar 1 'Y'::bpchar The record is active in the system
r_status isactive bpchar 1 'Y'::bpchar The record is active in the system
pa_reportcube isactivitydim bpchar 1  √  NULL::bpchar Include Activity as a cube dimension
ad_user isaddmailtextautomatically bpchar 1 'N'::bpchar The selected mail template will be automatically inserted when creating an email
c_acctschema isadjustcogs bpchar 1 'N'::bpchar Adjust Cost of Good Sold
c_acctschema isallownegativeposting bpchar 1  √  'Y'::bpchar Allow to post negative accounting values
r_requesttype isautochangerequest bpchar 1 'N'::bpchar Automatically create BOM (Engineering) Change Request
m_product isautoproduce bpchar 1 'N'::bpchar Auto create production to fulfill shipment
c_elementvalue isbankaccount bpchar 1  √  'N'::bpchar Indicates if this is the Bank Account
ad_user isbillto bpchar 1 'N'::bpchar Business Partner Invoice/Bill Address
m_product isbom bpchar 1 'N'::bpchar Bill of Materials
pa_reportcube isbpartnerdim bpchar 1  √  NULL::bpchar Include Business Partner as a cube dimension
pa_reportcube iscampaigndim bpchar 1  √  NULL::bpchar Include Campaign as a cube dimension
ad_role iscanapproveowndoc bpchar 1 'Y'::bpchar Users with this role can approve their own documents
ad_role iscanexport bpchar 1 'Y'::bpchar Users with this role can export data
ad_role iscanreport bpchar 1 'Y'::bpchar Users with this role can create reports
ad_table iscentrallymaintained bpchar 1  √  'Y'::bpchar Information maintained in System Element table
ad_role ischangelog bpchar 1 'N'::bpchar Maintain a log of changes
ad_table ischangelog bpchar 1 'N'::bpchar Maintain a log of changes
ad_role isclientadministrator bpchar 1 'N'::bpchar This role is a tenant administrator
r_status isclosed bpchar 1 'N'::bpchar The status is closed
pa_dashboardcontent iscollapsedbydefault bpchar 1 'N'::bpchar Flag to set the initial state of collapsible field group.
pa_dashboardpreference iscollapsedbydefault bpchar 1 'N'::bpchar Flag to set the initial state of collapsible field group.
pa_dashboardcontent iscollapsible bpchar 1 'Y'::bpchar Flag to indicate the state of the dashboard panel
c_bp_group isconfidentialinfo bpchar 1 'N'::bpchar Can enter confidential information
r_requesttype isconfidentialinfo bpchar 1 'N'::bpchar Can enter confidential information
c_bpartner iscustomer bpchar 1 'Y'::bpchar Indicates if this Business Partner is a Customer
ad_printcolor isdefault bpchar 1 'N'::bpchar Default value
c_bp_group isdefault bpchar 1 'N'::bpchar Default value
m_product_category isdefault bpchar 1 'N'::bpchar Default value
r_requesttype isdefault bpchar 1 'N'::bpchar Default value
r_status isdefault bpchar 1 'N'::bpchar Default value
ad_table isdeleteable bpchar 1 'Y'::bpchar Indicates if records can be deleted from the database
c_elementvalue isdetailbpartner bpchar 1 'N'::bpchar Manage Business Partners
c_elementvalue isdetailproduct bpchar 1 'N'::bpchar Manage Products
ad_role isdiscountallowedontotal bpchar 1 'N'::bpchar Is Discount Allowed On Total
c_acctschema isdiscountcorrectstax bpchar 1 'N'::bpchar Correct the tax for payment discount and charges
c_bpartner isdiscountprinted bpchar 1  √  'Y'::bpchar Print Discount on Invoice and Order
ad_role isdiscountuptolimitprice bpchar 1 'N'::bpchar Is Discount Up to Limit Price
ad_chart isdisplaylegend bpchar 1 'Y'::bpchar Display chart legend
c_elementvalue isdoccontrolled bpchar 1  √  'N'::bpchar Control account - If an account is controlled by a document, you cannot post manually to it
m_product isdropship bpchar 1 'N'::bpchar Drop Shipments are sent directly to the Drop Shipment Location
r_requesttype isemailwhendue bpchar 1 'N'::bpchar Send EMail when Request becomes due
r_requesttype isemailwhenoverdue bpchar 1 'N'::bpchar Send EMail when Request becomes overdue
pa_dashboardcontent isembedreportcontent bpchar 1 'N'::bpchar Embed report content into dashboard
c_bpartner isemployee bpchar 1 'N'::bpchar Indicates if this Business Partner is an employee
m_product isexcludeautodelivery bpchar 1 'N'::bpchar Exclude from automatic Delivery
ad_user isexpired bpchar 1 'N'::bpchar Expired
c_acctschema isexplicitcostadjustment bpchar 1 'N'::bpchar Post the cost adjustment explicitly
r_status isfinalclose bpchar 1 'N'::bpchar Entries with Final Close cannot be re-opened
c_elementvalue isforeigncurrency bpchar 1  √  'N'::bpchar Balances in foreign currency accounts are held in the nominated currency
ad_user isfullbpaccess bpchar 1 'Y'::bpchar The user/contact has full access to Business Partner information and resources
pa_reportcube isglbudgetdim bpchar 1  √  NULL::bpchar Include GL Budget as a cube dimension
ad_table ishighvolume bpchar 1 'N'::bpchar Use Search instead of Pick list
r_requesttype isindexed bpchar 1 'Y'::bpchar Index the document for the internal search engine
ad_user isinpayroll bpchar 1 'N'::bpchar Defined if any User Contact will be used for Calculate Payroll
r_requesttype isinvoiced bpchar 1  √  null Is this invoiced?
m_product isinvoiceprintdetails bpchar 1 'N'::bpchar Print detail BOM elements on the invoice
m_product iskanban bpchar 1 'N'::bpchar This part is Kanban controlled
pa_reportcube islocfromdim bpchar 1  √  NULL::bpchar Include Location From as a cube dimension
ad_user islocked bpchar 1 'N'::bpchar Locked
pa_reportcube isloctodim bpchar 1  √  NULL::bpchar Include Location To as a cube dimension
ad_role ismanual bpchar 1 'Y'::bpchar This is a manual process
pa_sla_criteria ismanual bpchar 1 'Y'::bpchar This is a manual process
m_product ismanufactured bpchar 1 'N'::bpchar This product is manufactured
c_bpartner ismanufacturer bpchar 1  √  'N'::bpchar Indicate role of this Business partner as Manufacturer
ad_role ismasterrole bpchar 1 'N'::bpchar A master role cannot be assigned to users, it is intended to define access to menu option and documents and inherit to other roles
pa_dashboardcontent ismaximizable bpchar 1 'Y'::bpchar Maximizable
ad_role ismenuautoexpand bpchar 1 'N'::bpchar If ticked, the menu is automatically expanded
ad_user ismenuautoexpand bpchar 1  √  null If ticked, the menu is automatically expanded
ad_user isnoexpire bpchar 1 'N'::bpchar No Expire
ad_user isnopasswordreset bpchar 1 'N'::bpchar No Password Reset
c_bpartner isonetime bpchar 1 'N'::bpchar One time transaction
r_status isopen bpchar 1 'N'::bpchar The status is closed
pa_reportcube isorgtrxdim bpchar 1  √  NULL::bpchar Include OrgTrx as a cube dimension
m_product isownbox bpchar 1 'N'::bpchar Own Box
ad_table ispartition bpchar 1 'N'::bpchar This is a partitioned table
ad_role ispersonalaccess bpchar 1 'N'::bpchar Allow access to all personal records
ad_role ispersonallock bpchar 1 'N'::bpchar Allow users with role to lock access to personal records
m_product isphantom bpchar 1  √  'N'::bpchar Phantom Component
m_product ispicklistprintdetails bpchar 1 'N'::bpchar Print detail BOM elements on the pick list
c_acctschema ispostifclearingequal bpchar 1  √  'Y'::bpchar This flag controls if Adempiere must post when clearing (transit) and final accounts are the same
c_acctschema ispostservices bpchar 1 'N'::bpchar Differentiate between Services and Product Receivable/Payables
c_bpartner ispotaxexempt bpchar 1 'N'::bpchar Business partner is exempt from tax on purchases
pa_reportcube isproductdim bpchar 1  √  NULL::bpchar Include Product as a cube dimension
pa_reportcube isprojectdim bpchar 1  √  NULL::bpchar Include Project as a cube dimension
pa_reportcube isprojectphasedim bpchar 1  √  NULL::bpchar Include Project Phase as a cube dimension
pa_reportcube isprojecttaskdim bpchar 1  √  NULL::bpchar Include Project Task as a cube dimension
c_bpartner isprospect bpchar 1 'N'::bpchar Indicates this is a Prospect
m_product ispurchased bpchar 1 'Y'::bpchar Organization purchases this product
ad_user issaleslead bpchar 1 'N'::bpchar This contact is a sales lead
pa_reportcube issalesregiondim bpchar 1  √  NULL::bpchar Include Sales Region as a cube dimension
c_bpartner issalesrep bpchar 1 'N'::bpchar Indicates if the business partner is a sales representative or company agent
ad_table issecurityenabled bpchar 1 'N'::bpchar If security is enabled, user access to data can be restricted via Roles
m_product isselfservice bpchar 1 'Y'::bpchar This is a Self-Service entry or this entry can be changed via Self-Service
m_product_category isselfservice bpchar 1 'Y'::bpchar This is a Self-Service entry or this entry can be changed via Self-Service
r_requesttype isselfservice bpchar 1 'Y'::bpchar This is a Self-Service entry or this entry can be changed via Self-Service
ad_user isshipto bpchar 1 'N'::bpchar Business Partner Shipment Address
ad_role isshowacct bpchar 1 'Y'::bpchar Users with this role can see accounting information
pa_dashboardcontent isshowindashboard bpchar 1 'Y'::bpchar Show the dashlet in the dashboard
pa_dashboardpreference isshowindashboard bpchar 1 'Y'::bpchar Show the dashlet in the dashboard
ad_table isshowindrilloptions bpchar 1  √  'Y'::bpchar This parameter enables the table to be displayed in Drill Assistant - Table tab
pa_dashboardcontent isshowinlogin bpchar 1  √  'Y'::bpchar Show on Login
pa_dashboardcontent isshowtitle bpchar 1 'Y'::bpchar Show Title
m_product issold bpchar 1 'Y'::bpchar Organization sells this product
m_product isstocked bpchar 1 'Y'::bpchar Organization stocks this product
pa_reportcube issubacctdim bpchar 1  √  NULL::bpchar Include Sub Acct as a cube dimension
ad_org issummary bpchar 1 'N'::bpchar This is a summary entity
c_bpartner issummary bpchar 1 'N'::bpchar This is a summary entity
c_elementvalue issummary bpchar 1 'N'::bpchar This is a summary entity
m_product issummary bpchar 1 'N'::bpchar This is a summary entity
pa_goal issummary bpchar 1 'N'::bpchar This is a summary entity
ad_user issupportuser bpchar 1 'N'::bpchar Support User
c_bpartner istaxexempt bpchar 1  √  'N'::bpchar Business partner is exempt from tax on sales
ad_chart istimeseries bpchar 1 'N'::bpchar The domain data for the chart is organised by time.
m_product istoformule bpchar 1  √  null
c_acctschema istradediscountposted bpchar 1 'N'::bpchar Generate postings for trade discounts
ad_chartdatasource_trl istranslated bpchar 1 This column is translated
pa_reportcube isuser1dim bpchar 1  √  NULL::bpchar Include User Element List 1 as a cube dimension
pa_reportcube isuser2dim bpchar 1  √  NULL::bpchar Include User Element List 2 as a cube dimension
pa_reportcube isuserelement1dim bpchar 1  √  NULL::bpchar Include User Element 1 as a cube dimension
pa_reportcube isuserelement2dim bpchar 1  √  NULL::bpchar Include User Element 2 as a cube dimension
ad_role isuseuserorgaccess bpchar 1 'N'::bpchar Use Org Access defined by user instead of Role Org Access
ad_alert isvalid bpchar 1 'Y'::bpchar Element is valid
ad_alertrule isvalid bpchar 1 'Y'::bpchar Element is valid
c_bpartner isvendor bpchar 1 'N'::bpchar Indicates if this Business Partner is a Vendor
ad_user isvendorlead bpchar 1 'N'::bpchar This contact is a vendor lead
m_product isverified bpchar 1 'N'::bpchar The BOM configuration has been verified
ad_table isview bpchar 1 'N'::bpchar This is a view
r_status iswebcanupdate bpchar 1 'Y'::bpchar Entry can be updated from the Web
m_product iswebstorefeatured bpchar 1 'N'::bpchar If selected, the product is displayed in the initial or any empty search
ad_chartdatasource keycolumn varchar 60  √  null Key Column for Table
pa_measurecalc keycolumn varchar 60 Key Column for Table
ad_user lastcontact timestamp 29,6  √  null Date this individual was last contacted
pa_reportcube lastrecalculated timestamp 29,6  √  null The time last recalculated.
ad_user lastresult varchar 255  √  null Result of last contact
ad_user ldapuser varchar 60  √  null User Name used for authorization via LDAP (directory) services
ad_user leadsource varchar 10  √  NULL::character varying The source of this lead/opportunity
ad_user leadsourcedescription varchar 255  √  NULL::character varying Additional information on the source of this lead/opportunity
ad_user leadstatus varchar 10  √  NULL::character varying The status of this lead/opportunity in the sales cycle
ad_user leadstatusdescription varchar 255  √  NULL::character varying Additional information on the status of this lead/opportunity
pa_dashboardcontent line numeric 0  √  null Unique line for this document
pa_dashboardpreference line numeric 0  √  null Unique line for this document
ad_table loadseq numeric 10  √  null Sequence
c_bpartner logo_id numeric 10  √  NULL::numeric Logo
m_product lowlevel numeric 10 (0)::numeric The Low Level is used to calculate the material plan and determines if a net requirement should be exploited
m_product m_attributeset_id numeric 10  √  null Product Attribute Set
m_product m_attributesetinstance_id numeric 10  √  0 Product Attribute Set Instance
c_acctschema m_costtype_id numeric 10  √  null Type of Cost (e.g. Current, Plan, Future)
c_bp_group m_discountschema_id numeric 10  √  null Schema to calculate the trade discount percentage
c_bpartner m_discountschema_id numeric 10  √  null Schema to calculate the trade discount percentage
m_product m_freightcategory_id numeric 10  √  null Category of the Freight
m_product m_locator_id numeric 10  √  null Warehouse Locator
m_product m_parttype_id numeric 10  √  NULL::numeric Part Type
c_bp_group m_pricelist_id numeric 10  √  null Unique identifier of a Price List
c_bpartner m_pricelist_id numeric 10  √  null Unique identifier of a Price List
m_product m_product_category_id numeric 10 Category of a Product
m_product_category m_product_category_id numeric 10 Category of a Product
pa_goalrestriction m_product_category_id numeric 10  √  null Category of a Product
m_product_category m_product_category_parent_id numeric 10  √  null Parent Product Category
m_product_category m_product_category_uu varchar 36  √  NULL::character varying M_Product_Category_UU
c_phase m_product_id numeric 10  √  null Product, Service, Item
m_product m_product_id numeric 10 Product, Service, Item
pa_goalrestriction m_product_id numeric 10  √  null Product, Service, Item
m_product m_product_uu varchar 36  √  NULL::character varying M_Product_UU
pa_achievement manualactual numeric 0 0 Manually entered actual value
pa_measure manualactual numeric 0  √  null Manually entered actual value
pa_measure manualnote varchar 2000  √  null Note for manual entry
pa_colorschema mark1percent numeric 10 0 Percentage up to this color is used
pa_colorschema mark2percent numeric 10 0 Percentage up to this color is used
pa_colorschema mark3percent numeric 10  √  0 Percentage up to this color is used
pa_colorschema mark4percent numeric 10  √  0 Percentage up to this color is used
ad_role maxqueryrecords numeric 10 0 If defined, you cannot query more records as defined - the query criteria needs to be changed to query less records
pa_goal measureactual numeric 0  √  0 Actual value that has been measured.
pa_sla_goal measureactual numeric 0 0 Actual value that has been measured.
pa_sla_measure measureactual numeric 0 0 Actual value that has been measured.
pa_measure measuredatatype bpchar 1 Type of data - Status or in Time
pa_goal measuredisplay bpchar 1  √  null Measure Scope initially displayed
pa_goal measurescope bpchar 1 Performance Measure Scope
pa_goal measuretarget numeric 0 0 Target value for measure
pa_sla_goal measuretarget numeric 0 0 Target value for measure
pa_measure measuretype bpchar 1 Determines how the actual performance is derived
m_product_category mmpolicy bpchar 1 'F'::bpchar Material Movement Policy
c_bpartner naics varchar 6  √  null Standard Industry Code or its successor NAIC - http://www.osha.gov/oshstats/sicser.html
ad_alert name varchar 60 Alphanumeric identifier of the entity
ad_alertrule name varchar 60 Alphanumeric identifier of the entity
ad_chart name varchar 60 Alphanumeric identifier of the entity
ad_chartdatasource name varchar 60 Alphanumeric identifier of the entity
ad_chartdatasource_trl name varchar 60 Alphanumeric identifier of the entity
ad_org name varchar 60 Alphanumeric identifier of the entity
ad_printcolor name varchar 60 Alphanumeric identifier of the entity
ad_role name varchar 60 Alphanumeric identifier of the entity
ad_table name varchar 60 Alphanumeric identifier of the entity
ad_user name varchar 60 Alphanumeric identifier of the entity
c_acctschema name varchar 60 Alphanumeric identifier of the entity
c_bp_group name varchar 60 Alphanumeric identifier of the entity
c_bpartner name varchar 120 Alphanumeric identifier of the entity
c_elementvalue name varchar 120 Alphanumeric identifier of the entity
c_phase name varchar 60 Alphanumeric identifier of the entity
c_projecttype name varchar 60 Alphanumeric identifier of the entity
m_product name varchar 255 Alphanumeric identifier of the entity
m_product_category name varchar 60 Alphanumeric identifier of the entity
pa_achievement name varchar 60 Alphanumeric identifier of the entity
pa_benchmark name varchar 60 Alphanumeric identifier of the entity
pa_benchmarkdata name varchar 60 Alphanumeric identifier of the entity
pa_colorschema name varchar 60 Alphanumeric identifier of the entity
pa_dashboardcontent name varchar 120 Alphanumeric identifier of the entity
pa_documentstatus name varchar 60 Alphanumeric identifier of the entity
pa_goal name varchar 60 Alphanumeric identifier of the entity
pa_goalrestriction name varchar 60 Alphanumeric identifier of the entity
pa_hierarchy name varchar 60 Alphanumeric identifier of the entity
pa_measure name varchar 60 Alphanumeric identifier of the entity
pa_measurecalc name varchar 60 Alphanumeric identifier of the entity
pa_ratio name varchar 60 Alphanumeric identifier of the entity
pa_ratioelement name varchar 60 Alphanumeric identifier of the entity
pa_reportcube name varchar 60 Alphanumeric identifier of the entity
pa_sla_criteria name varchar 60 Alphanumeric identifier of the entity
pa_sla_goal name varchar 60 Alphanumeric identifier of the entity
r_requesttype name varchar 60 Alphanumeric identifier of the entity
r_status name varchar 60 Alphanumeric identifier of the entity
c_bpartner name2 varchar 60  √  null Additional Name
pa_documentstatus name_printcolor_id numeric 10  √  null Print Color for Name
pa_documentstatus name_printfont_id numeric 10  √  null Print Font for Name
r_status next_status_id numeric 10  √  null Move to next status automatically after timeout
pa_achievement note varchar 2000  √  null Optional additional user defined information
pa_goal note varchar 2000  √  null Optional additional user defined information
ad_user notificationtype bpchar 1 'X'::bpchar Type of Notifications
pa_documentstatus number_printcolor_id numeric 10  √  null Print Color for Number
pa_documentstatus number_printfont_id numeric 10  √  null Print Font for Number
c_bpartner numberemployees numeric 10  √  null Number of employees
pa_goalrestriction org_id numeric 10  √  null Organizational entity within tenant
pa_measurecalc orgcolumn varchar 60  √  null Fully qualified Organization column (AD_Org_ID)
ad_alertrule otherclause varchar 2000  √  null Other SQL Clause
ad_role overwritepricelimit bpchar 1 'N'::bpchar Overwrite Price Limit if the Price List enforces the Price Limit
pa_achievement pa_achievement_id numeric 10 Performance Achievement
pa_achievement pa_achievement_uu varchar 36  √  NULL::character varying PA_Achievement_UU
pa_benchmark pa_benchmark_id numeric 10 Performance Benchmark
pa_benchmarkdata pa_benchmark_id numeric 10 Performance Benchmark
pa_measure pa_benchmark_id numeric 10  √  null Performance Benchmark
pa_benchmark pa_benchmark_uu varchar 36  √  NULL::character varying PA_Benchmark_UU
pa_benchmarkdata pa_benchmarkdata_id numeric 10 Performance Benchmark Data Point
pa_benchmarkdata pa_benchmarkdata_uu varchar 36  √  NULL::character varying PA_BenchmarkData_UU
pa_colorschema pa_colorschema_id numeric 10 Performance Color Schema
pa_goal pa_colorschema_id numeric 10 Performance Color Schema
pa_colorschema pa_colorschema_uu varchar 36  √  NULL::character varying PA_ColorSchema_UU
pa_dashboardcontent_access pa_dashboardcontent_access_id numeric 10 PA_DashboardContent_Access_ID
pa_dashboardcontent_access pa_dashboardcontent_access_uu varchar 36  √  NULL::character varying PA_DashboardContent_Access_UU
pa_dashboardcontent pa_dashboardcontent_id numeric 10 Dashboard Content
pa_dashboardcontent_access pa_dashboardcontent_id numeric 10  √  NULL::numeric Dashboard Content
pa_dashboardpreference pa_dashboardcontent_id numeric 10 Dashboard Content
pa_dashboardcontent pa_dashboardcontent_uu varchar 36  √  NULL::character varying PA_DashboardContent_UU
pa_dashboardpreference pa_dashboardpreference_id numeric 10 Dashboard Preference
pa_dashboardpreference pa_dashboardpreference_uu varchar 36  √  NULL::character varying PA_DashboardPreference_UU
pa_documentstatus pa_documentstatus_id numeric 10 Document Status
pa_documentstatusaccess pa_documentstatus_id numeric 10  √  NULL::numeric Document Status
pa_documentstatus pa_documentstatus_uu varchar 36  √  NULL::character varying PA_DocumentStatus_UU
pa_documentstatusaccess pa_documentstatusaccess_id numeric 10 Document Status Access
pa_documentstatusaccess pa_documentstatusaccess_uu varchar 36  √  NULL::character varying PA_DocumentStatusAccess_UU
pa_dashboardcontent pa_goal_id numeric 10  √  null Performance Goal
pa_goal pa_goal_id numeric 10 Performance Goal
pa_goalrestriction pa_goal_id numeric 10 Performance Goal
pa_goal pa_goal_uu varchar 36  √  NULL::character varying PA_Goal_UU
pa_goal pa_goalparent_id numeric 10  √  null Parent Goal
pa_goalrestriction pa_goalrestriction_id numeric 10 Performance Goal Restriction
pa_goalrestriction pa_goalrestriction_uu varchar 36  √  NULL::character varying PA_GoalRestriction_UU
pa_hierarchy pa_hierarchy_id numeric 10 Optional Reporting Hierarchy - If not selected the default hierarchy trees are used.
pa_measure pa_hierarchy_id numeric 10  √  null Optional Reporting Hierarchy - If not selected the default hierarchy trees are used.
pa_hierarchy pa_hierarchy_uu varchar 36  √  NULL::character varying PA_Hierarchy_UU
pa_achievement pa_measure_id numeric 10 Concrete Performance Measurement
pa_goal pa_measure_id numeric 10  √  null Concrete Performance Measurement
pa_measure pa_measure_id numeric 10 Concrete Performance Measurement
pa_measure pa_measure_uu varchar 36  √  NULL::character varying PA_Measure_UU
pa_measure pa_measurecalc_id numeric 10  √  null Calculation method for measuring performance
pa_measurecalc pa_measurecalc_id numeric 10 Calculation method for measuring performance
pa_ratioelement pa_measurecalc_id numeric 10  √  null Calculation method for measuring performance
pa_measurecalc pa_measurecalc_uu varchar 36  √  NULL::character varying PA_MeasureCalc_UU
pa_measure pa_ratio_id numeric 10  √  null Performance Ratio
pa_ratio pa_ratio_id numeric 10 Performance Ratio
pa_ratioelement pa_ratio_id numeric 10 Performance Ratio
pa_ratio pa_ratio_uu varchar 36  √  NULL::character varying PA_Ratio_UU
pa_ratioelement pa_ratioelement_id numeric 10 Performance Ratio Element
pa_ratioelement pa_ratioelement_uu varchar 36  √  NULL::character varying PA_RatioElement_UU
pa_ratioelement pa_ratioused_id numeric 10  √  null Performance Ratio Used
pa_reportcube pa_reportcube_id numeric 10 Define reporting cube for pre-calculation of summary accounting data.
pa_reportcube pa_reportcube_uu varchar 36  √  NULL::character varying PA_ReportCube_UU
pa_sla_criteria pa_sla_criteria_id numeric 10 Service Level Agreement Criteria
pa_sla_goal pa_sla_criteria_id numeric 10 Service Level Agreement Criteria
pa_sla_criteria pa_sla_criteria_uu varchar 36  √  NULL::character varying PA_SLA_Criteria_UU
pa_sla_goal pa_sla_goal_id numeric 10 Service Level Agreement Goal
pa_sla_measure pa_sla_goal_id numeric 10 Service Level Agreement Goal
pa_sla_goal pa_sla_goal_uu varchar 36  √  NULL::character varying PA_SLA_Goal_UU
pa_sla_measure pa_sla_measure_id numeric 10 Service Level Agreement Measure
pa_sla_measure pa_sla_measure_uu varchar 36  √  NULL::character varying PA_SLA_Measure_UU
ad_user password varchar 1024  √  null Password of any length (case sensitive)
c_bpartner paymentrule bpchar 1  √  null How you pay the invoice
c_bpartner paymentrulepo bpchar 1  √  null Purchase payment option
c_acctschema period_openfuture numeric 10  √  null Number of days to be able to post to a future date (based on system date)
c_acctschema period_openhistory numeric 10  √  null Number of days to be able to post in the past (based on system date)
ad_user phone varchar 40  √  null Identifies a telephone number
ad_user phone2 varchar 40  √  null Identifies an alternate telephone number.
m_product_category plannedmargin numeric 0 Project's planned margin as a percentage
c_bp_group po_discountschema_id numeric 10  √  null Schema to calculate the purchase trade discount percentage
c_bpartner po_discountschema_id numeric 10  √  null Schema to calculate the purchase trade discount percentage
c_bpartner po_paymentterm_id numeric 10  √  null Payment rules for a purchase order
c_bp_group po_pricelist_id numeric 10  √  null Price List used by this Business Partner
c_bpartner po_pricelist_id numeric 10  √  null Price List used by this Business Partner
ad_table po_window_id numeric 10  √  null Purchase Order Window
c_bpartner poreference varchar 20  √  null Transaction Reference Number (Sales Order, Purchase Order) of your Business Partner
c_elementvalue postactual bpchar 1 'Y'::bpchar Actual Values can be posted
c_elementvalue postbudget bpchar 1 'Y'::bpchar Budget values can be posted
c_elementvalue postencumbrance bpchar 1 'Y'::bpchar Post commitments to this account
pa_ratioelement postingtype bpchar 1  √  null The type of posted amount for the transaction
ad_alertrule postprocessing varchar 2000  √  null Process SQL after executing the query
c_elementvalue poststatistical bpchar 1 'Y'::bpchar Post statistical quantities to this account?
c_bpartner potentiallifetimevalue numeric 0  √  0 Total Revenue expected
ad_role predefinedcontextvariables varchar 4000  √  NULL::character varying Predefined context variables to inject when opening a menu entry or a window
ad_role preferencetype bpchar 1 'C'::bpchar Determines what preferences the user can set
ad_alertrule preprocessing varchar 2000  √  null Process SQL before executing the query
c_bp_group pricematchtolerance numeric 0  √  null PO-Invoice Match Price Tolerance in percent of the purchase price
c_bp_group prioritybase bpchar 1  √  null Base of Priority
pa_sla_goal processed bpchar 1 'N'::bpchar The document has been processed
pa_sla_measure processed bpchar 1 'N'::bpchar The document has been processed
ad_table processing bpchar 1  √  NULL::bpchar Process Now
ad_user processing bpchar 1  √  null Process Now
c_acctschema processing bpchar 1  √  null Process Now
m_product processing bpchar 1  √  null Process Now
pa_reportcube processing bpchar 1 'N'::bpchar Process Now
pa_sla_goal processing bpchar 1  √  null Process Now
pa_sla_measure processing bpchar 1  √  null Process Now
pa_dashboardcontent processparameters varchar 2000  √  NULL::character varying Comma separated process parameter list
pa_measurecalc productcolumn varchar 60  √  null Fully qualified Product column (M_Product_ID)
m_product producttype bpchar 1 'I'::bpchar Type of product
c_projecttype projectcategory bpchar 1 'N'::bpchar Project Category
ad_user r_defaultmailtext_id numeric 10  √  NULL::numeric Default mail template
m_product r_mailtext_id numeric 10  √  null Text templates for mailings
pa_measure r_requesttype_id numeric 10  √  null Type of request (e.g. Inquiry, Complaint, ..)
r_requesttype r_requesttype_id numeric 10 Type of request (e.g. Inquiry, Complaint, ..)
r_requesttype r_requesttype_uu varchar 36  √  NULL::character varying R_RequestType_UU
r_status r_status_id numeric 10 Request Status
r_status r_status_uu varchar 36  √  NULL::character varying R_Status_UU
r_requesttype r_statuscategory_id numeric 10 Request Status Category
r_status r_statuscategory_id numeric 10 Request Status Category
ad_chart rangelabel varchar 60  √  NULL::character varying Label for the range axis.
c_bpartner rating bpchar 1  √  null Classification or Importance
pa_ratioelement ratioelementtype bpchar 1 Ratio Element Type
pa_ratioelement ratiooperand bpchar 1 Ratio Operand
pa_sla_measure record_id numeric 10  √  null Direct internal record ID
c_bpartner referenceno varchar 40  √  null Your customer or vendor number at the Business Partner's site
pa_goal relativeweight numeric 0  √  null Relative weight of this step (0 = ignored)
ad_table replicationtype bpchar 1 'L'::bpchar Type of Data Replication
ad_role roletype varchar 2  √  NULL::character varying Role Type
m_product s_expensetype_id numeric 10  √  null Expense report type
m_product s_resource_id numeric 10  √  null Resource
ad_user salesrep_id numeric 10  √  NULL::numeric Sales Representative or Company Agent
c_bpartner salesrep_id numeric 10  √  null Sales Representative or Company Agent
m_product salesrep_id numeric 10  √  null Sales Representative or Company Agent
c_bpartner salesvolume numeric 10  √  null Total Volume of Sales in Thousands of Currency
ad_user salt varchar 16  √  NULL::character varying Random data added to improve password hash effectiveness
ad_user securityquestion varchar 1024  √  null Security Question
ad_alertrule selectclause varchar 2000 SQL SELECT clause
pa_measurecalc selectclause varchar 2000 SQL SELECT clause
c_bpartner sendemail bpchar 1 'N'::bpchar Enable sending Document EMail
c_acctschema separator bpchar 1 Element Separator
c_phase seqno numeric 10 Method of ordering records; lowest number comes first
pa_achievement seqno numeric 10 0 Method of ordering records; lowest number comes first
pa_documentstatus seqno numeric 10 Method of ordering records; lowest number comes first
pa_goal seqno numeric 10 0 Method of ordering records; lowest number comes first
pa_ratioelement seqno numeric 10 Method of ordering records; lowest number comes first
r_status seqno numeric 10 0 Method of ordering records; lowest number comes first
ad_chartdatasource seriescolumn varchar 60  √  NULL::character varying Series Column
c_bpartner shareofcustomer numeric 10  √  null Share of Customer's business as a percentage
m_product shelfdepth numeric 10  √  null Shelf depth required
m_product shelfheight numeric 0  √  null Shelf height required
c_bpartner shelflifeminpct numeric 10  √  null Minimum Shelf Life in percent based on Product Instance Guarantee Date
m_product shelfwidth numeric 10  √  null Shelf width required
m_product sku varchar 30  √  null Stock Keeping Unit
c_bpartner so_creditlimit numeric 0  √  0 Total outstanding invoice amounts allowed
c_bpartner so_creditused numeric 0  √  0 Current open balance
c_bpartner so_description varchar 255  √  null Description to be used on orders
c_bpartner socreditstatus bpchar 1  √  'O'::bpchar Business Partner Credit Status
c_phase standardqty numeric 0 0 Standard Quantity
ad_role supervisor_id numeric 10  √  null Supervisor for this user/organization - used for escalation and approval
ad_user supervisor_id numeric 10  √  null Supervisor for this user/organization - used for escalation and approval
ad_table tablename varchar 40 Name of the table in the database
c_acctschema taxcorrectiontype bpchar 1  √  null Type of Tax Correction
c_bpartner taxid varchar 20  √  null Tax Identification
ad_chartdatasource timeoffset numeric 10  √  null Number of time units to offset displayed chart data from the current date.
r_status timeoutdays numeric 10  √  null Timeout in Days to change Status automatically
ad_chart timescope numeric 10  √  null The number of time units to include the chart result.
ad_chart timeunit bpchar 1  √  NULL::bpchar The unit of time for grouping chart data.
ad_user title varchar 40  √  null Name this entity is referred to as
c_bpartner totalopenbalance numeric 0  √  null Total Open Balance Amount in primary Accounting Currency
m_product unitsperpack numeric 10 1 The Units Per Pack indicates the no of units of a product packed together.
m_product unitsperpallet numeric 0  √  null Units Per Pallet
m_product upc varchar 30  √  null Bar Code (Universal Product Code or its superset European Article Number)
r_status update_status_id numeric 10  √  null Automatically change the status after entry from web
ad_alert updated timestamp 29,6 now() Date this record was updated
ad_alertrecipient updated timestamp 29,6 now() Date this record was updated
ad_alertrule updated timestamp 29,6 now() Date this record was updated
ad_chart updated timestamp 29,6 statement_timestamp() Date this record was updated
ad_chartdatasource updated timestamp 29,6 statement_timestamp() Date this record was updated
ad_chartdatasource_trl updated timestamp 29,6 statement_timestamp() Date this record was updated
ad_org updated timestamp 29,6 now() Date this record was updated
ad_printcolor updated timestamp 29,6 now() Date this record was updated
ad_role updated timestamp 29,6 now() Date this record was updated
ad_table updated timestamp 29,6 now() Date this record was updated
ad_user updated timestamp 29,6 now() Date this record was updated
c_acctschema updated timestamp 29,6 now() Date this record was updated
c_bp_group updated timestamp 29,6 now() Date this record was updated
c_bpartner updated timestamp 29,6 now() Date this record was updated
c_elementvalue updated timestamp 29,6 now() Date this record was updated
c_phase updated timestamp 29,6 now() Date this record was updated
c_projecttype updated timestamp 29,6 now() Date this record was updated
m_product updated timestamp 29,6 now() Date this record was updated
m_product_category updated timestamp 29,6 now() Date this record was updated
pa_achievement updated timestamp 29,6 now() Date this record was updated
pa_benchmark updated timestamp 29,6 now() Date this record was updated
pa_benchmarkdata updated timestamp 29,6 now() Date this record was updated
pa_colorschema updated timestamp 29,6 now() Date this record was updated
pa_dashboardcontent updated timestamp 29,6 statement_timestamp() Date this record was updated
pa_dashboardcontent_access updated timestamp 29,6 statement_timestamp() Date this record was updated
pa_dashboardpreference updated timestamp 29,6 statement_timestamp() Date this record was updated
pa_documentstatus updated timestamp 29,6 Date this record was updated
pa_documentstatusaccess updated timestamp 29,6 statement_timestamp() Date this record was updated
pa_goal updated timestamp 29,6 now() Date this record was updated
pa_goalrestriction updated timestamp 29,6 now() Date this record was updated
pa_hierarchy updated timestamp 29,6 now() Date this record was updated
pa_measure updated timestamp 29,6 now() Date this record was updated
pa_measurecalc updated timestamp 29,6 now() Date this record was updated
pa_ratio updated timestamp 29,6 now() Date this record was updated
pa_ratioelement updated timestamp 29,6 now() Date this record was updated
pa_reportcube updated timestamp 29,6 statement_timestamp() Date this record was updated
pa_sla_criteria updated timestamp 29,6 now() Date this record was updated
pa_sla_goal updated timestamp 29,6 now() Date this record was updated
pa_sla_measure updated timestamp 29,6 now() Date this record was updated
r_requesttype updated timestamp 29,6 now() Date this record was updated
r_status updated timestamp 29,6 now() Date this record was updated
ad_alert updatedby numeric 10 User who updated this records
ad_alertrecipient updatedby numeric 10 User who updated this records
ad_alertrule updatedby numeric 10 User who updated this records
ad_chart updatedby numeric 10 User who updated this records
ad_chartdatasource updatedby numeric 10 User who updated this records
ad_chartdatasource_trl updatedby numeric 10 User who updated this records
ad_org updatedby numeric 10 User who updated this records
ad_printcolor updatedby numeric 10 User who updated this records
ad_role updatedby numeric 10 User who updated this records
ad_table updatedby numeric 10 User who updated this records
ad_user updatedby numeric 10 User who updated this records
c_acctschema updatedby numeric 10 User who updated this records
c_bp_group updatedby numeric 10 User who updated this records
c_bpartner updatedby numeric 10 User who updated this records
c_elementvalue updatedby numeric 10 User who updated this records
c_phase updatedby numeric 10 User who updated this records
c_projecttype updatedby numeric 10 User who updated this records
m_product updatedby numeric 10 User who updated this records
m_product_category updatedby numeric 10 User who updated this records
pa_achievement updatedby numeric 10 User who updated this records
pa_benchmark updatedby numeric 10 User who updated this records
pa_benchmarkdata updatedby numeric 10 User who updated this records
pa_colorschema updatedby numeric 10 User who updated this records
pa_dashboardcontent updatedby numeric 10 User who updated this records
pa_dashboardcontent_access updatedby numeric 10  √  NULL::numeric User who updated this records
pa_dashboardpreference updatedby numeric 10 User who updated this records
pa_documentstatus updatedby numeric 10 User who updated this records
pa_documentstatusaccess updatedby numeric 10 User who updated this records
pa_goal updatedby numeric 10 User who updated this records
pa_goalrestriction updatedby numeric 10 User who updated this records
pa_hierarchy updatedby numeric 10 User who updated this records
pa_measure updatedby numeric 10 User who updated this records
pa_measurecalc updatedby numeric 10 User who updated this records
pa_ratio updatedby numeric 10 User who updated this records
pa_ratioelement updatedby numeric 10 User who updated this records
pa_reportcube updatedby numeric 10 User who updated this records
pa_sla_criteria updatedby numeric 10 User who updated this records
pa_sla_goal updatedby numeric 10 User who updated this records
pa_sla_measure updatedby numeric 10 User who updated this records
r_requesttype updatedby numeric 10 User who updated this records
r_status updatedby numeric 10 User who updated this records
c_bpartner url varchar 120  √  null Full URL address - e.g. http://www.idempiere.org
ad_role userdiscount numeric 22,2  √  null User Discount
ad_role userlevel bpchar 3 ' O'::bpchar System Tenant Organization
ad_user userpin varchar 20  √  null User PIN
c_elementvalue validfrom timestamp 29,6  √  null Valid from including this date (first day)
pa_sla_goal validfrom timestamp 29,6  √  null Valid from including this date (first day)
c_elementvalue validto timestamp 29,6  √  null Valid to including this date (last day)
pa_sla_goal validto timestamp 29,6  √  null Valid to including this date (last day)
ad_org value varchar 40 Search key for the record in the format required - must be unique
ad_user value varchar 40  √  null Search key for the record in the format required - must be unique
c_bp_group value varchar 40 Search key for the record in the format required - must be unique
c_bpartner value varchar 40 Search key for the record in the format required - must be unique
c_elementvalue value varchar 40 Search key for the record in the format required - must be unique
m_product value varchar 510 Search key for the record in the format required - must be unique
m_product_category value varchar 40 Search key for the record in the format required - must be unique
r_status value varchar 40 Search key for the record in the format required - must be unique
ad_chartdatasource valuecolumn varchar 60 Fully qualified data value column
m_product versionno varchar 20  √  null Version Number
m_product volume numeric 0  √  0 Volume of a product
m_product weight numeric 0  √  0 Weight of a product
ad_alertrule whereclause varchar 2000  √  null Fully qualified SQL WHERE clause
ad_chartdatasource whereclause varchar 2000  √  null Fully qualified SQL WHERE clause
pa_documentstatus whereclause varchar 2000  √  null Fully qualified SQL WHERE clause
pa_measurecalc whereclause varchar 2000 Fully qualified SQL WHERE clause
ad_chart winheight numeric 10  √  NULL::numeric Window Height
pa_dashboardcontent zulfilepath varchar 255  √  null URI for Dashboard Gadget