ad_client

2 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
ad_client_id numeric 10 null
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_field.ad_client_id fieldclient 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_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_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
cof_c_acct_ignoreelement.ad_client_id adclient_cofcacctignoreelement R
cof_c_alinea.ad_client_id adclient_cofcalinea R
cof_c_bankintegration.ad_client_id adclient_cofcbankintegration R
cof_c_bankoccurrence.ad_client_id adclient_cofcbankoccurrence R
cof_c_checkallocate.ad_client_id adclient_cofccheckallocate R
cof_c_cnabconfig.ad_client_id adclient_cofccnabconfig R
cof_c_cnabconfig_line.ad_client_id adclient_cofccnabconfigline R
cof_c_controlcheck.ad_client_id adclient_cofccontrolcheck R
cof_c_custody.ad_client_id adclient_cofccustody R
cof_contractgroup.ad_client_id cof_contractgroup_ad_client_id R
cof_csc.ad_client_id adclient_cofcsc R
cof_gruposeparacao.ad_client_id adclient_cofgruposeparacao R
cof_produtosgruposeparacao.ad_client_id adclient_cofprodutosgruposepar R
cof_retentionconfig.ad_client_id adclient_cofretentionconfig R
cof_titulo.ad_client_id adclient_coftitulo 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
lbr_docfiscal_autxml.ad_client_id adclient_lbrdocfiscalautxml R
lbr_docfiscal_cana_deduc.ad_client_id adclient_lbrdocfiscalcanadeduc R
lbr_docfiscal_cana_fordia.ad_client_id adclient_lbrdocfiscalcanafordi R
lbr_docfiscal_detpag.ad_client_id adclient_lbrdocfiscalpag R
lbr_docfiscal_line_arma.ad_client_id adclient_lbrdocfiscallinearma R
lbr_docfiscal_line_detexport.ad_client_id adclient_lbrdocfiscallinedetex R
lbr_docfiscal_line_nve.ad_client_id adclient_lbrdocfiscallinenve R
lbr_docfiscal_obscont.ad_client_id adclient_lbrdocfiscalobscont R
lbr_docfiscal_obsfisco.ad_client_id adclient_lbrdocfiscalobsfisco R
lbr_docfiscal_procref.ad_client_id adclient_lbrdocfiscalprocref 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
mp_assetmeter.ad_client_id adclient_mpassetmeter R
mp_assetmeter_log.ad_client_id adclient_mpassetmeterlog R
mp_jobstandar.ad_client_id adclient_mpjobstandar R
mp_jobstandar_resource.ad_client_id adclient_mpjobstandarresource R
mp_jobstandar_task.ad_client_id adclient_mpjobstandartask R
mp_maintain.ad_client_id adclient_mpmaintain R
mp_maintain_resource.ad_client_id adclient_mpmaintainresource R
mp_maintain_task.ad_client_id adclient_mpmaintaintask R
mp_meter.ad_client_id adclient_mpmeter R
mp_ot.ad_client_id adclient_mpot R
mp_ot_request.ad_client_id adclient_mpotrequest R
mp_ot_resource.ad_client_id adclient_mpotresource R
mp_ot_task.ad_client_id adclient_mpottask R
mp_prognosis.ad_client_id adclient_mpprognosis R
pa_dashboardcontent_access.ad_client_id adclient_padashboardcontentacc R
w_store.ad_client_id adclient_wstore R
ad_org_id numeric 10 null
isactive bpchar 1 'Y'::bpchar
created timestamp 29,6 now()
createdby numeric 10 null
updated timestamp 29,6 now()
updatedby numeric 10 null
value varchar 40 null
name varchar 60 null
description varchar 255 √ null
smtphost varchar 60 √ null
requestemail varchar 60 √ null
requestuser varchar 60 √ null
requestuserpw varchar 255 √ null
requestfolder varchar 20 √ null
ad_language varchar 6 √ null
ad_language.ad_language adlangu_adclient R
ismultilingualdocument bpchar 1 'N'::bpchar
issmtpauthorization bpchar 1 'N'::bpchar
isusebetafunctions bpchar 1 'N'::bpchar
ldapquery varchar 255 √ null
modelvalidationclasses varchar 255 √ null
autoarchive bpchar 1 'N'::bpchar
mmpolicy bpchar 1 'F'::bpchar
emailtest bpchar 1 √ null
isserveremail bpchar 1 √ null
documentdir varchar 60 √ null
ispostimmediate bpchar 1 'N'::bpchar
iscostimmediate bpchar 1 'N'::bpchar
storeattachmentsonfilesystem bpchar 1 'N'::bpchar
windowsattachmentpath varchar 255 √ null
unixattachmentpath varchar 255 √ null
storearchiveonfilesystem bpchar 1 'N'::bpchar
windowsarchivepath varchar 255 √ null
unixarchivepath varchar 255 √ null
isuseasp bpchar 1 'N'::bpchar
ad_replicationstrategy_id numeric 10 √ null
ad_replicationstrategy.ad_replicationstrategy_id adreplicationstrategy_adclient R
ad_client_uu varchar 36 √ NULL::character varying
ad_passwordrule_id numeric 10 √ NULL::numeric
ad_passwordrule.ad_passwordrule_id adpasswordrule_adclient R
issecuresmtp bpchar 1 'N'::bpchar
smtpport numeric 10 √ NULL::numeric
loginprefix varchar 40 √ NULL::character varying

Indexes

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

Check Constraints

Constraint Name Constraint
ad_client_isuseasp_check ((isuseasp = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
ad_client_issecuresmtp_check ((issecuresmtp = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
ad_client_isactive_check ((isactive = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))

Relationships

Close relationships within degrees of separation