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
ad_clientinfo.ad_client_id adclient_adclientinfo C
ad_language.ad_client_id languageclient R
ad_user.ad_client_id ad_user_client R
c_bpartner.ad_client_id adclient_cbpartner R
m_product.ad_client_id adclient_mproduct R
m_warehouse.ad_client_id m_warehouse_client 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 Data Replication Strategy
ad_client_uu varchar 36  √  NULL::character varying AD_Client_UU
ad_passwordrule_id numeric 10  √  NULL::numeric 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:57 +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

Close relationships  within of separation: