Table idempiere11.adempiere.ad_client
Tenant for this installation.

 Generated by
Quality Systems & Solutions
Legend:
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
ad_client_id numeric 10
a_asset_group_trl.ad_client_id adclient_aassetgrouptrl R
ad_broadcastmessage.notification_client_id notificationclient_adbroadcast R
ad_broadcastmessage_trl.ad_client_id adclient_adbroadcastmessagetrl R
ad_chart_trl.ad_client_id adclient_adcharttrl R
ad_clientinfo.ad_client_id adclient_adclientinfo C
ad_clientshare.ad_client_id adclient_adclientshare R
ad_color_trl.ad_client_id adclient_adcolortrl R
ad_column.ad_client_id columnclient R
ad_ctxhelpsuggestion.ad_userclient_id aduserclient_adctxhelpsuggesti R
ad_field.ad_client_id fieldclient R
ad_fieldsuggestion.ad_userclient_id aduserclient_adfieldsuggestion R
ad_importtemplate.ad_client_id adclient_adimporttemplate R
ad_importtemplateaccess.ad_client_id adclient_adimporttemplateacces R
ad_inforelated.ad_client_id adclient_adinforelated R
ad_label_trl.ad_client_id adclient_adlabeltrl R
ad_labelcategory_trl.ad_client_id adclient_adlabelcategorytrl R
ad_language.ad_client_id languageclient R
ad_menu.ad_client_id adclient_admenu R
ad_message.ad_client_id messageclient R
ad_modelgeneratortemplate.ad_client_id adclient_admodelgeneratortempl R
ad_org.ad_client_id adclient_adorg R
ad_password_history.ad_client_id adclient_adpasswordhistory R
ad_postit.ad_client_id adclient_adpostit R
ad_preference.ad_client_id ad_preference_client R
ad_printcolor_trl.ad_client_id adclient_adprintcolortrl R
ad_printform.ad_client_id adclient_adprintform R
ad_process_access.ad_client_id ad_processaccess_client R
ad_ref_list.ad_client_id ad_reflist_client R
ad_ref_table.ad_client_id ref_tableclient R
ad_reference.ad_client_id referenceclient R
ad_replication.remote_client_id remoteclient_adreplication R
ad_reportview_column.ad_client_id adclient_adreportviewcolumn R
ad_role.ad_client_id ad_roleclient R
ad_sequence.ad_client_id sequenceclient R
ad_sequence_audit.ad_client_id sequence_auditclient R
ad_sequence_no.ad_client_id sequence_noclient R
ad_statusline.ad_client_id adclient_adstatusline R
ad_statuslineusedin.ad_client_id adclient_adstatuslineusedin R
ad_tab.ad_client_id tabclient R
ad_table.ad_client_id tableclient R
ad_table_access.ad_client_id ad_dataaccessclient R
ad_task.ad_client_id taskclient R
ad_task_access.ad_client_id ad_taskaccess_client R
ad_taskinstance.ad_client_id taskinstanceclient R
ad_user.ad_client_id ad_user_client R
ad_user_roles.ad_client_id ad_userrolesclient R
ad_userpreference.ad_client_id adclient_aduserpreference R
ad_val_rule.ad_client_id val_ruleclient R
ad_verifymigration.ad_client_id adclient_adverifymigration R
ad_wf_node.ad_client_id wf_nodeclient R
ad_wf_nodenext.ad_client_id wf_nodenextclient R
ad_wf_process.ad_client_id wf_instanceclient R
ad_window.ad_client_id windowclient R
ad_window_access.ad_client_id ad_functaccess_client R
ad_workflow.ad_client_id workflowclient R
ad_workflow_access.ad_client_id ad_workflowaccess_client R
c_acctschema.ad_client_id ad_client_c_acctschema R
c_acctschema_element.ad_client_id adclient_caschemaelement R
c_activity_trl.ad_client_id adclient_cactivitytrl R
c_addresstransaction.ad_client_id adclient_caddresstransaction R
c_addressvalidation.ad_client_id adclient_caddressvalidation R
c_addressvalidationcfg.ad_client_id adclient_caddressvalidationcfg R
c_bpartner.ad_client_id adclient_cbpartner R
c_bpartner_location.ad_client_id c_buspartner_locationclient R
c_calendar.ad_client_id c_calendarclient R
c_campaign_trl.ad_client_id adclient_ccampaigntrl R
c_city.ad_client_id c_cityclient R
c_conversion_rate.ad_client_id c_conversion_rateclient R
c_country.ad_client_id c_countryclient R
c_countrygroup.ad_client_id adclient_ccountrygroup R
c_countrygroup_trl.ad_client_id adclient_ccountrygrouptrl R
c_countrygroupcountry.ad_client_id adclient_ccountrygroupcountry R
c_currency.ad_client_id c_currencyclient R
c_docbasegroup.ad_client_id adclient_cperioddocgroup R
c_docbasegroupline.ad_client_id adclient_cperioddocgroupline R
c_element.ad_client_id adclient_celement R
c_elementvalue.ad_client_id adclient_celementvalue R
c_location.ad_client_id adclient_clocation R
c_nonbusinessday.ad_client_id c_nonbusinesdaysclient R
c_ordersource.ad_client_id adclient_cordersource R
c_period.ad_client_id c_periodclient R
c_project.ad_client_id adclient_cproject R
c_recurringgroup.ad_client_id adclient_crecurringgroup R
c_region.ad_client_id c_regionclient R
c_region_trl.ad_client_id adclient_cregiontrl R
c_revenuerecog_service.ad_client_id adclient_crevenuerecogservice R
c_salesregion_trl.ad_client_id adclient_csalesregiontrl R
c_salesstage_trl.ad_client_id adclient_csalesstagetrl R
c_taxprovider.ad_client_id adclient_ctaxprovider R
c_taxprovidercfg.ad_client_id adclient_adtaxprovider R
c_uom.ad_client_id c_uomclient R
c_uom_conversion.ad_client_id c_uom_conversionclient R
c_validcombination.ad_client_id adclient_vc R
c_year.ad_client_id c_yearclient R
fact_acct.ad_client_id ac_client_fact_acct R
gl_category_trl.ad_client_id adclient_glcategorytrl R
gl_journalline.ad_client_id adclient_gljournalline R
m_cost.ad_client_id adclient_mcost R
m_costdetail.ad_client_id adclient_mcostdetail R
m_locator.ad_client_id m_wh_locator_client R
m_locatortype.ad_client_id adclient_mlocatortype R
m_pricelist_trl.ad_client_id adclient_mpricelisttrl R
m_pricelist_version_trl.ad_client_id adclient_mpricelistversiontrl R
m_product.ad_client_id adclient_mproduct R
m_product_category_trl.ad_client_id adclient_mproductcategorytrl R
m_product_po.ad_client_id m_productpo_client R
m_storagereservationlog.ad_client_id adclient_mstoragereservationlo R
m_substitute.ad_client_id m_substitute_client R
m_warehouse.ad_client_id m_warehouse_client R
pa_dashboardcontent_access.ad_client_id adclient_padashboardcontentacc R
testuu.ad_client_id adclient_testuu R
testuu_trl.ad_client_id adclient_testuutrl R
testuudet.ad_client_id adclient_testuudet R
w_store.ad_client_id adclient_wstore R
Tenant for this installation.
ad_org_id numeric 10 Organizational entity within tenant
isactive bpchar 1 'Y'::bpchar The record is active in the system
created timestamp 29,6 now() Date this record was created
createdby numeric 10 User who created this records
updated timestamp 29,6 now() Date this record was updated
updatedby numeric 10 User who updated this records
value varchar 40 Search key for the record in the format required - must be unique
name varchar 60 Alphanumeric identifier of the entity
description varchar 255  √  null Optional short description of the record
smtphost varchar 60  √  null Hostname of Mail Server for SMTP and IMAP
requestemail varchar 60  √  null EMail address to send automated mails from or receive mails for automated processing (fully qualified)
requestuser varchar 60  √  null User Name (ID) of the email owner
requestuserpw varchar 255  √  null Password of the user name (ID) for mail processing
requestfolder varchar 20  √  null EMail folder to process incoming emails; if empty INBOX is used
ad_language varchar 6  √  null
ad_language.ad_language adlangu_adclient R
Language for this entity
ismultilingualdocument bpchar 1 'N'::bpchar Documents are Multi Lingual
issmtpauthorization bpchar 1 'N'::bpchar Your mail server requires Authentication
isusebetafunctions bpchar 1 'N'::bpchar Enable the use of Beta Functionality
ldapquery varchar 255  √  null
modelvalidationclasses varchar 255  √  null List of data model validation classes separated by ;
autoarchive bpchar 1 'N'::bpchar Enable and level of automatic Archive of documents
mmpolicy bpchar 1 'F'::bpchar Material Movement Policy
emailtest bpchar 1  √  null Test EMail
isserveremail bpchar 1  √  null Send EMail from Server
documentdir varchar 60  √  null Directory for documents from the application server
ispostimmediate bpchar 1 'N'::bpchar Post the accounting immediately for testing (Deprecated)
iscostimmediate bpchar 1 'N'::bpchar Update Costs immediately for testing
storeattachmentsonfilesystem bpchar 1 'N'::bpchar Store Attachments On File System
windowsattachmentpath varchar 255  √  null Windows Attachment Path
unixattachmentpath varchar 255  √  null Unix Attachment Path
storearchiveonfilesystem bpchar 1 'N'::bpchar Store Archive On File System
windowsarchivepath varchar 255  √  null Windows Archive Path
unixarchivepath varchar 255  √  null Unix Archive Path
isuseasp bpchar 1 'N'::bpchar Is Use ASP
ad_replicationstrategy_id numeric 10  √  null
ad_replicationstrategy.ad_replicationstrategy_id adreplicationstrategy_adclient R
Data Replication Strategy
ad_client_uu varchar 36  √  NULL::character varying AD_Client_UU
ad_passwordrule_id numeric 10  √  NULL::numeric
ad_passwordrule.ad_passwordrule_id adpasswordrule_adclient R
Password Policies
issecuresmtp bpchar 1 'N'::bpchar Use SSL/TLS for SMTP
smtpport numeric 10  √  NULL::numeric SMTP Port Number
loginprefix varchar 40  √  NULL::character varying Login Prefix
authenticationtype varchar 10 'AAS'::character varying Authentication Type

Table contained 2 rows at 2024-01-03 13:44 +0100

Indexes:
Column(s) Type Sort Constraint Name
ad_client_id Primary key Asc ad_client_pkey
loginprefix Must be unique Asc ad_client_loginprefix
ad_client_uu Must be unique Asc ad_client_uu_idx
value Must be unique Asc ad_client_value


SchemaSpy was unable to generate a diagram of table relationships.
SchemaSpy requires Graphviz version 2.2.1 or versions greater than 2.4 from www.graphviz.org.