ad_org

3 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
ad_org_id numeric 10 null
a_asset_group_trl.ad_org_id adorg_aassetgrouptrl R
ad_broadcastmessage_trl.ad_org_id adorg_adbroadcastmessagetrl R
ad_chart_trl.ad_org_id adorg_adcharttrl R
ad_clientshare.ad_org_id adorg_adclientshare R
ad_color_trl.ad_org_id adorg_adcolortrl R
ad_column.ad_org_id columnorg R
ad_field.ad_org_id fieldorg R
ad_importtemplate.ad_org_id adorg_adimporttemplate R
ad_importtemplateaccess.ad_org_id adorg_adimporttemplateaccess R
ad_inforelated.ad_org_id adorg_adinforelated R
ad_label_trl.ad_org_id adorg_adlabeltrl R
ad_labelcategory_trl.ad_org_id adorg_adlabelcategorytrl R
ad_language.ad_org_id languageorg R
ad_menu.ad_org_id ad_menu_org R
ad_message.ad_org_id messageorg R
ad_orginfo.ad_org_id adorg_adorginfo C
ad_orginfo.parent_org_id adorgparent_adorginfo N
ad_password_history.ad_org_id adorg_adpasswordhistory R
ad_postit.ad_org_id adorg_adpostit R
ad_preference.ad_org_id ad_preference_org R
ad_printcolor_trl.ad_org_id adorg_adprintcolortrl R
ad_process_access.ad_org_id ad_processtaccess_org R
ad_ref_list.ad_org_id ad_reflist_org R
ad_ref_table.ad_org_id ref_tableorg R
ad_reference.ad_org_id referenceorg R
ad_replication.remote_org_id remoteorg_adreplication R
ad_reportview_column.ad_org_id adorg_adreportviewcolumn R
ad_role.ad_org_id ad_roleorg R
ad_role_orgaccess.ad_org_id adorg_adroleorgaccess C
ad_sequence.ad_org_id sequenceorg R
ad_sequence_audit.ad_org_id sequence_auditorg R
ad_sequence_no.ad_org_id sequence_noorg R
ad_statusline.ad_org_id adorg_adstatusline R
ad_statuslineusedin.ad_org_id adorg_adstatuslineusedin R
ad_tab.ad_org_id taborg R
ad_table.ad_org_id tableorg R
ad_table_access.ad_org_id ad_dataaccessorg R
ad_task.ad_org_id taskorg R
ad_task_access.ad_org_id ad_taskaccess_org R
ad_taskinstance.ad_org_id taskinstanceorg R
ad_user.ad_org_id ad_user_org R
ad_user.ad_orgtrx_id adorgtrx_aduser R
ad_user_orgaccess.ad_org_id adorg_aduserorgaccess R
ad_user_roles.ad_org_id ad_userrolesorg R
ad_userpreference.ad_org_id adorg_aduserpreference R
ad_val_rule.ad_org_id val_ruleorg R
ad_verifymigration.ad_org_id adorg_adverifymigration R
ad_wf_node.ad_org_id wf_nodeorg R
ad_wf_nodenext.ad_org_id wf_nodenextorg R
ad_wf_process.ad_org_id wf_instanceorg R
ad_wf_responsible.ad_org_id adorg_adwfresponsible R
ad_window.ad_org_id windoworg R
ad_window_access.ad_org_id ad_functaccessorg R
ad_workflow.ad_org_id workfloworg R
ad_workflow_access.ad_org_id ad_workflowaccess_org R
c_acctschema.ad_org_id ad_org_c_acctschema R
c_acctschema.ad_orgonly_id adorgonly_cacctschema R
c_acctschema_element.ad_org_id adorgid_c_aschemaelement R
c_acctschema_element.org_id adorg_caschemaelement R
c_activity_trl.ad_org_id adorg_cactivitytrl R
c_addresstransaction.ad_org_id adorg_caddresstransaction R
c_addressvalidation.ad_org_id adorg_caddressvalidation R
c_addressvalidationcfg.ad_org_id adorg_caddressvalidationcfg R
c_banktransfer.from_ad_org_id fromadorg_cbanktransfer R
c_banktransfer.to_ad_org_id toadorg_cbanktransfer R
c_bpartner.ad_org_id adorg_cbpartner R
c_bpartner.ad_orgbp_id adorg_cbpartnerorg R
c_bpartner_location.ad_org_id c_buspartner_locationorg R
c_calendar.ad_org_id c_calendarorg R
c_campaign_trl.ad_org_id adorg_ccampaigntrl R
c_cash.ad_org_id adorg_ccash R
c_cash.ad_orgtrx_id adorgtrx_ccash R
c_cashplan.ad_orgtrx_id adorgtrx_ccashplan R
c_cashplanline.ad_orgtrx_id adorgtrx_ccashplanline R
c_city.ad_org_id c_cityorg R
c_commissionline.org_id adorgtrx_ccommissionline R
c_conversion_rate.ad_org_id c_conversion_rateorg R
c_country.ad_org_id c_countryorg R
c_countrygroup.ad_org_id adorg_ccountrygroup R
c_countrygroup_trl.ad_org_id adorg_ccountrygrouptrl R
c_countrygroupcountry.ad_org_id adorg_ccountrygroupcountry R
c_currency.ad_org_id c_currencyorg R
c_element.ad_org_id c_elementorg R
c_elementvalue.ad_org_id adorg_celementvalue R
c_interorg_acct.ad_org_id adorg_cinterorgacct C
c_interorg_acct.ad_orgto_id adorgto_cinterorgacct C
c_invoice.ad_org_id adorg_cinvoice R
c_invoice.ad_orgtrx_id adorgtrx_cinvoice R
c_invoicebatchline.ad_org_id adorg_cinvoicebatchline R
c_invoicebatchline.ad_orgtrx_id adorgtrx_cinvoicebatchline R
c_invoiceline.ad_org_id adorg_cinvoiceline R
c_invoiceline.ad_orgtrx_id adorgtrx_cinvoiceline R
c_location.ad_org_id adorg_clocation R
c_nonbusinessday.ad_org_id c_nonbusinesdaysorg R
c_order.ad_org_id adorg_corder R
c_order.ad_orgtrx_id adorgtrx_corder R
c_orderline.ad_org_id adorg_corderline R
c_orderline.ad_orgtrx_id adorgtrx_corderline R
c_ordersource.ad_org_id adorg_cordersource R
c_orgassignment.ad_org_id adorg_corgassignment R
c_payment.ad_org_id adorg_cpayment R
c_payment.ad_orgtrx_id adorgtrx_cpayment R
c_paymenttransaction.ad_orgtrx_id adorgtrx_cpaymenttransaction R
c_period.ad_org_id c_periodorg R
c_project.ad_org_id adorg_cproject R
c_project.ad_orgtrx_id adorgtrx_cproject R
c_recurringgroup.ad_org_id adorg_crecurringgroup R
c_region.ad_org_id c_regionorg R
c_region_trl.ad_org_id adorg_cregiontrl R
c_revenuerecog_service.ad_org_id adorg_crevenuerecogservice R
c_salesregion_trl.ad_org_id adorg_csalesregiontrl R
c_salesstage_trl.ad_org_id adorg_csalesstagetrl R
c_taxprovider.ad_org_id adorg_ctaxprovider R
c_taxprovidercfg.ad_org_id adorg_adtaxprovider R
c_uom.ad_org_id c_uomorg R
c_uom_conversion.ad_org_id c_uom_conversionorg R
c_validcombination.ad_org_id adorg_vc R
c_validcombination.ad_orgtrx_id adorgtrx_vc R
c_year.ad_org_id c_yearorg R
cof_c_acct_ignoreelement.ad_org_id adorg_cofcacctignoreelement R
cof_c_acct_ignoreelement.org_id org_cofcacctignoreelement R
cof_c_alinea.ad_org_id adorg_cofcalinea R
cof_c_bankintegration.ad_org_id adorg_cofcbankintegration R
cof_c_bankoccurrence.ad_org_id adorg_cofcbankoccurrence R
cof_c_checkallocate.ad_org_id adorg_cofccheckallocate R
cof_c_cnabconfig.ad_org_id adorg_cofccnabconfig R
cof_c_cnabconfig_line.ad_org_id adorg_cofccnabconfigline R
cof_c_controlcheck.ad_org_id adorg_cofccontrolcheck R
cof_c_custody.ad_org_id adorg_cofccustody R
cof_contractgroup.ad_org_id cof_contractgroup_ad_org_id R
cof_csc.ad_org_id adorg_cofcsc R
cof_gruposeparacao.ad_org_id adorg_cofgruposeparacao R
cof_orcamentoorgs.cof_orgorcamento_id coforgorcamento_coforcamentoor C
cof_orgst.ad_org_id adorg_coforgst R
cof_produtosgruposeparacao.ad_org_id adorg_cofprodutosgruposeparaca R
cof_restricaoacesso.ad_org_id adorg_cofrestricaoacesso R
cof_restricaoacesso.cof_restricaoacesso_org_id cofrestricaoacessoorg_cofrestr R
cof_retentionconfig.ad_org_id adorg_cofretentionconfig R
cof_rps.ad_org_id adorg_cofrps R
cof_titulo.ad_org_id adorg_coftitulo R
cof_titulo.cof_cedente_bpartner_id cofcedentebpartner_coftitulo R
dd_order.ad_orgtrx_id adorgtrx_ddorder R
dd_orderline.ad_orgtrx_id adorgtrx_ddorderline R
fact_acct.ad_org_id ad_org_fact_acct R
fact_acct.ad_orgtrx_id ad_orgtrx_fact_acct R
fact_acct_summary.ad_orgtrx_id adorgtrx_factacctsummary R
gl_category_trl.ad_org_id adorg_glcategorytrl R
gl_distribution.ad_org_id adorg_gldist R
gl_distribution.ad_orgtrx_id adorgtrx_gldist R
gl_distribution.org_id adorgorg_gldist R
gl_distributionline.ad_org_id adorg_gldistline R
gl_distributionline.ad_orgtrx_id adorgtrx_gldistline R
gl_distributionline.org_id adorgorg_gldistline R
gl_journalline.ad_org_id adorg_gljournalline R
gl_journalline.ad_orgtrx_id adorgtrx_gljournalline R
hr_movement.ad_orgtrx_id adorgtrx_hrmovement R
i_fajournal.ad_orgdoc_id adorgdoc_ifajournal R
i_fajournal.ad_orgtrx_id adorgtrx_ifajournal R
i_gljournal.ad_org_id adorg_igljournal N
i_gljournal.ad_orgdoc_id adorgdoc_igljournal N
i_gljournal.ad_orgtrx_id adorgtrx_igljournal N
i_invoice.ad_org_id adorg_iinvoice N
i_invoice.ad_orgtrx_id adorgtrx_iinvoice N
i_movement.ad_orgtrx_id adorgtrx_imovement R
i_order.ad_org_id adorg_iorder N
i_order.ad_orgtrx_id adorgtrx_iorder N
lbr_docfiscal_autxml.ad_org_id adorg_lbrdocfiscalautxml R
lbr_docfiscal_cana_deduc.ad_org_id adorg_lbrdocfiscalcanadeduc R
lbr_docfiscal_cana_fordia.ad_org_id adorg_lbrdocfiscalcanafordia R
lbr_docfiscal_detpag.ad_org_id adorg_lbrdocfiscalpag R
lbr_docfiscal_line_arma.ad_org_id adorg_lbrdocfiscallinearma R
lbr_docfiscal_line_detexport.ad_org_id adorg_lbrdocfiscallinedetexpor R
lbr_docfiscal_line_nve.ad_org_id adorg_lbrdocfiscallinenve R
lbr_docfiscal_obscont.ad_org_id adorg_lbrdocfiscalobscont R
lbr_docfiscal_obsfisco.ad_org_id adorg_lbrdocfiscalobsfisco R
lbr_docfiscal_procref.ad_org_id adorg_lbrdocfiscalprocref R
m_cost.ad_org_id adorg_m_cost R
m_costdetail.ad_org_id adorg_mcostdetail R
m_inout.ad_org_id adorg_minout R
m_inout.ad_orgtrx_id adorgtrx_minout R
m_inoutline.ad_org_id adorg_minoutline R
m_inoutline.ad_orgtrx_id adorgtrx_minoutline R
m_inventory.ad_org_id adorg_minventory R
m_inventory.ad_orgtrx_id adorgtrx_minventory R
m_locator.ad_org_id m_wh_locator_org R
m_locatortype.ad_org_id adorg_mlocatortype R
m_movement.ad_org_id adorg_mmovement R
m_movement.ad_orgtrx_id adorgtrx_mmovement R
m_movement.cof_orgto_id coforgto_mmovement C
m_pricelist_trl.ad_org_id adorg_mpricelisttrl R
m_pricelist_version_trl.ad_org_id adorg_mpricelistversiontrl R
m_product.ad_org_id ad_org_mproduct R
m_product_category_trl.ad_org_id adorg_mproductcategorytrl R
m_product_po.ad_org_id m_productpo_org R
m_production.ad_org_id adorg_mproduction R
m_production.ad_orgtrx_id adorgtrx_mproduction R
m_storagereservationlog.ad_org_id adorg_mstoragereservationlog R
m_substitute.ad_org_id m_substitute_org R
m_warehouse.ad_org_id m_warehouse_org R
mp_assetmeter.ad_org_id adorg_mpassetmeter R
mp_assetmeter_log.ad_org_id adorg_mpassetmeterlog R
mp_jobstandar.ad_org_id adorg_mpjobstandar R
mp_jobstandar_resource.ad_org_id adorg_mpjobstandarresource R
mp_jobstandar_task.ad_org_id adorg_mpjobstandartask R
mp_maintain.ad_org_id adorg_mpmaintain R
mp_maintain_resource.ad_org_id adorg_mpmaintainresource R
mp_maintain_task.ad_org_id adorg_mpmaintaintask R
mp_meter.ad_org_id adorg_mpmeter R
mp_ot.ad_org_id adorg_mpot R
mp_ot_request.ad_org_id adorg_mpotrequest R
mp_ot_resource.ad_org_id adorg_mpotresource R
mp_ot_task.ad_org_id adorg_mpottask R
mp_prognosis.ad_org_id adorg_mpprognosis R
pa_dashboardcontent_access.ad_org_id adorg_padashboardcontentaccess R
pa_goalrestriction.ad_org_id adorg_pagoalrestriction R
pa_goalrestriction.org_id adorg2_pagoalrestriction R
pa_report.ad_org_id adorg_pareport C
pa_reportcolumn.ad_orgtrx_id adorgtrx_pareportcolumn R
pa_reportcolumn.org_id adorg_pareportcolumn R
pa_reportsource.ad_orgtrx_id adorgtrx_pareportsource R
pa_reportsource.org_id adorg_pareportsource R
pp_cost_collector.ad_orgtrx_id adorgtrx_ppcostcollector R
pp_order.ad_orgtrx_id adorgtrx_pporder R
t_bom_indented.cof_organizacaocusto_id coforganizacaocusto_tbomindent R
ad_client_id numeric 10 null
ad_client.ad_client_id adclient_adorg R
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
issummary bpchar 1 'N'::bpchar
ad_replicationstrategy_id numeric 0 √ null
ad_replicationstrategy.ad_replicationstrategy_id ad_org__ad_repli_ad_replica R
ad_org_uu varchar 36 √ NULL::character varying
cof_c_snrange_id numeric 10 √ NULL::numeric
cof_c_snrange.cof_c_snrange_id cofcsnrange_adorg R
cof_tokenportal varchar 255 √ NULL::character varying

Indexes

Constraint Name Type Sort Column(s)
ad_org_pkey Primary key Asc ad_org_id
ad_org_uu_idx Must be unique Asc ad_org_uu
ad_org_value Must be unique Asc/Asc ad_client_id + value

Check Constraints

Constraint Name Constraint
ad_org_isactive_check ((isactive = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))

Relationships

Close relationships within degrees of separation