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_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_requiredplugin.ad_client_id adclient_adrequiredplugin 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_tablevalrule.ad_client_id adclient_adtablevalrule 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_userdef_theme.ad_client_id adclient_aduserdeftheme R
ad_userdef_theme_detail.ad_client_id adclient_aduserdefthemedetail 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
cof_acaodossiefinanceiro.ad_client_id adclient_cofacaodossiefinanceiro R
cof_apontamentotempoordemproducao.ad_client_id adclient_cofapontamentotempoordemproducao R
cof_apuracaooutra.ad_client_id adclient_cofapuracaooutra 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_calcnivelminmax.ad_client_id adclient_cofcalcnivelminmax R
cof_calculociap.ad_client_id adclient_cofcalculociap R
cof_calculociaplinha.ad_client_id adclient_cofcalculociaplinha R
cof_calculociaplinhanfe.ad_client_id adclient_cofcalculociaplinhanfe R
cof_calculociapoutroscred.ad_client_id adclient_cofcalculociapoutroscred R
cof_cobranca_pix.ad_client_id adclient_cofcobrancapix R
cof_codclasstrib.ad_client_id adclient_cofcodclasstrib R
cof_codigooperacao.ad_client_id adclient_cofcodigooperacao R
cof_combustivel.ad_client_id adclient_cofcombustivel R
cof_configuracaociap.ad_client_id adclient_cofconfiguracaociap R
cof_configuracaofiscal.ad_client_id adclient_cofconfiguracaofiscal R
cof_configuracaometa.ad_client_id adclient_cofconfiguracaometa R
cof_confrontoofx.ad_client_id adclient_cofconfrontoofx R
cof_contractgroup.ad_client_id cof_contractgroup_ad_client_id R
cof_controleabastecimento.ad_client_id adclient_cofcontroleabastecime R
cof_controleciap.ad_client_id adclient_cofcontroleciap R
cof_controleciap_entrada.ad_client_id adclient_cofcontroleciapentrada R
cof_controleciap_saida.ad_client_id adclient_cofcontroleciapsaida R
cof_controleciapoutroscred.ad_client_id adclient_cofcontroleciapoutroscred R
cof_controleestoqueetiqueta.ad_client_id adclient_cofcontroleestoqueetiqueta R
cof_controleestoqueetiquetaline.ad_client_id adclient_coflinhacontroleestoqueetiqueta R
cof_controlemulta.ad_client_id adclient_cofcontrolemulta R
cof_csc.ad_client_id adclient_cofcsc R
cof_dda.ad_client_id adclient_cofdda R
cof_formacaopreco.ad_client_id adclient_cofformacaopreco R
cof_formacaoprecolista.ad_client_id adclient_cofformacaoprecolista R
cof_gruponcm.ad_client_id adclient_cofgruponcm R
cof_gruponcmlinha.ad_client_id adclient_cofgruponcmlinha R
cof_gruposeparacao.ad_client_id adclient_cofgruposeparacao R
cof_historicoconsultas.ad_client_id adclient_cofhistoricoconsultas R
cof_imagenslinhaov.ad_client_id adclient_cofimagenslinhaov R
cof_invoicededucaomateriais.ad_client_id adclient_cofinvoicededucaomateriais R
cof_linhacalculo.ad_client_id adclient_coflinhacalculo R
cof_linharecuperacaoimposto.ad_client_id adclient_coflinharecuperacaoimposto R
cof_linhareposicao.ad_client_id adclient_coflinhareposicao R
cof_mdfe.ad_client_id adclient_cofmdfe R
cof_mdfe_condutor.ad_client_id adclient_cofmdfecondutor R
cof_mdfe_documentofiscal.ad_client_id adclient_cofmdfedocumentofisca R
cof_mdfe_muncarregamento.ad_client_id adclient_cofmdfemuncarregament R
cof_mdfe_mundescarregamento.ad_client_id adclient_cofmdfemundescarregam R
cof_mdfe_percurso.ad_client_id adclient_cofmdfepercurso R
cof_mdfe_reboque.ad_client_id adclient_cofmdfereboque R
cof_metadevendas.ad_client_id adclient_cofmetadevendas R
cof_orderdeducaomateriais.ad_client_id adclient_coforderdeducaomateriais R
cof_parametroavancadobusca.ad_client_id adclient_cofparametroavancadobusca R
cof_paramformacaopreco.ad_client_id adclient_cofparamformacaopreco R
cof_pontoremessa.ad_client_id adclient_cofpontoremessa R
cof_pontoremessa_trl.ad_client_id adclient_cofpontoremessatrl R
cof_produtolocalizadorconfig.ad_client_id adclient_cofprodutolocalizadorconfig R
cof_recuperacaoimposto.ad_client_id adclient_cofrecuperacaoimposto R
cof_reposicaoestoquefilial.ad_client_id adclient_cofreposicaoestoquefilial R
cof_retentionconfig.ad_client_id adclient_cofretentionconfig R
cof_terminalcfe.ad_client_id adclient_cofterminalcfe R
cof_titulo.ad_client_id adclient_coftitulo R
cof_webhookevent.ad_client_id adclient_cofwebhookevent R
cof_wpp_configwhatsapp.ad_client_id adclient_zwppconfigwhatsapp R
cte_infctecomp.ad_client_id adclient_cteinfctecomp 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_attributeinstanceline.ad_client_id adclient_mattributeinstancelin 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
pivot_configuration.ad_client_id adclient_pivotconfiguration R
pivot_field.ad_client_id adclient_pivotfield 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
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
authenticationtype varchar 10 'AAS'::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_issecuresmtp_check ((issecuresmtp = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
ad_client_isuseasp_check ((isuseasp = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
ad_client_isactive_check ((isactive = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))

Relationships

Close relationships within degrees of separation