ad_language

109 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
ad_language varchar 6 null
a_asset_group_trl.ad_language adlanguage_aassetgrouptrl R
ad_allclients_v.ad_language Implied Constraint R
ad_broadcastmessage_trl.ad_language adlanguage_adbroadcastmessaget R
ad_chart_trl.ad_language adlanguage_adcharttrl R
ad_chartdatasource_trl.ad_language adlanguage_adchartdatasourcetr R
ad_client.ad_language adlangu_adclient R
ad_color_trl.ad_language adlanguage_adcolortrl R
ad_column_trl.ad_language adlanguage_adcolumntrl R
ad_ctxhelpmsg_trl.ad_language adlangu_adctxhelpmsgtrl R
ad_ctxhelpsuggestion.ad_language adlanguage_adctxhelpsuggestion R
ad_desktop_trl.ad_language adlanguage_addesktoptrl R
ad_element_trl.ad_language ad_language_ad_element_trl R
ad_error.ad_language adlangu_aderror R
ad_field_trl.ad_language ad_language_fieldtrl R
ad_field_vt.ad_language Implied Constraint R
ad_fieldgroup_trl.ad_language adlanguage_adfieldgrouptrl R
ad_fieldsuggestion.ad_language adlanguage_adfieldsuggestion R
ad_form_trl.ad_language adlanguage_adformtrl R
ad_infocolumn_trl.ad_language adlanguage_adinfocolumntrl C
ad_infowindow_trl.ad_language adlanguage_adinfowindowtrl C
ad_label_trl.ad_language adlanguage_adlabeltrl R
ad_labelcategory_trl.ad_language adlanguage_adlabelcategorytrl R
ad_menu_trl.ad_language ad_language_menutrl R
ad_message_trl.ad_language ad_language_messagetrl R
ad_printcolor_trl.ad_language adlanguage_adprintcolortrl R
ad_printformat_trl.ad_language adlanguage_adprintformtrl R
ad_printformatitem_trl.ad_language adlanguage_adprintformitemtrl R
ad_printlabelline_trl.ad_language adlanguage_adplabellinetrl R
ad_process_drillrule_trl.ad_language adlanguage_adprocessdrillrulet R
ad_process_para_trl.ad_language adlanguage_adprocessparatrl R
ad_process_trl.ad_language ad_language_ad_process_trl R
ad_ref_list_trl.ad_language ad_language_reflisttrl R
ad_reference_trl.ad_language ad_language_referencetrl R
ad_tab_trl.ad_language ad_language_tabtrl R
ad_tab_vt.ad_language Implied Constraint R
ad_table_trl.ad_language adlanguage_adtabletrl R
ad_task_trl.ad_language ad_language_tasktrl R
ad_userdef_info.ad_language adlangu_aduserdefinfo R
ad_userdef_proc.ad_language adlanguage_aduserdefproc R
ad_userdef_win.ad_language adlangu_aduserdefwin R
ad_wf_node_trl.ad_language ad_language_wfnodetrl R
ad_window_trl.ad_language ad_language_windowtrl R
ad_window_vt.ad_language Implied Constraint R
ad_workbench_trl.ad_language adlanguage_adworkbenchtrl R
ad_workflow_trl.ad_language ad_language_workflowtrl R
c_activity_trl.ad_language adlanguage_cactivitytrl R
c_bpartner.ad_language ad_language_c_buspartner R
c_campaign_trl.ad_language adlanguage_ccampaigntrl R
c_charge_trl.ad_language adlangu_cchargetrl R
c_country.ad_language adlanguage_ccountry R
c_country_trl.ad_language adlanguage_ccountrytrl C
c_countrygroup_trl.ad_language adlanguage_ccountrygrouptrl R
c_currency_trl.ad_language adlanguage_ccurrencytrl C
c_doctype_trl.ad_language adlanguage_cdoctypetrl R
c_dunning_header_v.c_bpartner_ad_language Implied Constraint R
c_dunning_header_v.salesrep_bpartner_ad_language Implied Constraint R
c_dunning_header_vt.ad_language Implied Constraint R
c_dunning_header_vt.c_bpartner_ad_language Implied Constraint R
c_dunning_header_vt.salesrep_bpartner_ad_language Implied Constraint R
c_dunning_line_vt.ad_language Implied Constraint R
c_dunninglevel_trl.ad_language adlanguage_cdunninglevel R
c_elementvalue_trl.ad_language adlanguage_celementvaluetrl R
c_greeting_trl.ad_language adlanguage_cgreetingtrl R
c_invoice_header_v.bp_ad_language Implied Constraint R
c_invoice_header_v.bpartner_ad_language Implied Constraint R
c_invoice_header_vt.ad_language Implied Constraint R
c_invoice_header_vt.bp_ad_language Implied Constraint R
c_invoice_header_vt.bpartner_ad_language Implied Constraint R
c_invoice_linetax_vt.ad_language Implied Constraint R
c_order_header_v.bill_bp_ad_language Implied Constraint R
c_order_header_v.bp_ad_language Implied Constraint R
c_order_header_v.salesrep_bp_ad_language Implied Constraint R
c_order_header_vt.ad_language Implied Constraint R
c_order_header_vt.bill_bp_ad_language Implied Constraint R
c_order_header_vt.bp_ad_language Implied Constraint R
c_order_header_vt.salesrep_bp_ad_language Implied Constraint R
c_order_linetax_vt.ad_language Implied Constraint R
c_paymentterm_trl.ad_language adlanguage_cpaymenttermtrl R
c_payselection_check_v.c_bp_ad_language Implied Constraint R
c_payselection_check_vt.ad_language Implied Constraint R
c_payselection_check_vt.c_bp_ad_language Implied Constraint R
c_payselection_remittance_vt.ad_language Implied Constraint R
c_project_details_vt.ad_language Implied Constraint R
c_project_header_v.c_bp_ad_language Implied Constraint R
c_project_header_v.salesrep_bp_ad_language Implied Constraint R
c_project_header_vt.ad_language Implied Constraint R
c_project_header_vt.c_bp_ad_language Implied Constraint R
c_project_header_vt.salesrep_bp_ad_language Implied Constraint R
c_region_trl.ad_language adlanguage_cregiontrl R
c_rfqresponse_vt.ad_language Implied Constraint R
c_rfqresponseline_vt.ad_language Implied Constraint R
c_rfqresponselineqty_vt.ad_language Implied Constraint R
c_salesregion_trl.ad_language adlanguage_csalesregiontrl R
c_salesstage_trl.ad_language adlanguage_csalesstagetrl R
c_tax_trl.ad_language adlanguage_ctaxtrl C
c_taxcategory_trl.ad_language adlanguage_ctaxcategorytrl R
c_uom_trl.ad_language adlanguage_cuomtrl C
cm_container_element_trl.ad_language adlanguage_cmcontainereletrl C
cm_container_trl.ad_language adlanguage_cmcontainertrl C
cm_cstage_element_trl.ad_language adlanguage_cmcstageeletrl C
cm_cstage_trl.ad_language adlanguage_cmcstagetrl C
cm_newschannel.ad_language adlangu_cmnewschannel R
cof_rv_customization.ad_language Implied Constraint R
cof_rv_detalheslocalizacao.ad_language Implied Constraint R
dd_order_header_vt.ad_language Implied Constraint R
gl_category_trl.ad_language adlanguage_glcategorytrl R
i_bpartner.ad_language adlanguage_ibpartner R
k_synonym.ad_language adlangu_ksynonym R
m_inout_header_v.c_bp_ad_language Implied Constraint R
m_inout_header_vt.ad_language Implied Constraint R
m_inout_header_vt.c_bp_ad_language Implied Constraint R
m_inout_line_vt.ad_language Implied Constraint R
m_inout_lineconfirm_vt.ad_language Implied Constraint R
m_inoutconfirm_vt.ad_language Implied Constraint R
m_pricelist_trl.ad_language adlanguage_mpricelisttrl R
m_pricelist_version_trl.ad_language adlanguage_mpricelistversiontr R
m_product_category_trl.ad_language adlanguage_mproductcategorytrl R
m_product_trl.ad_language adlanguage_mproducttrl R
pa_dashboardcontent_trl.ad_language adlangu_padashboardcontenttrl R
pa_documentstatus_trl.ad_language adlanguage_padocumentstatustrl R
pa_reportcolumn_trl.ad_language adlanguage_pareportcolumntrl R
pa_reportline_trl.ad_language adlanguage_pareportlinetrl R
pp_order_bom_header_vt.ad_language Implied Constraint R
pp_order_bom_trl.ad_language adlangu_pporderbomtrl R
pp_order_bomline_trl.ad_language adlangu_pporderbomlinetrl R
pp_order_bomline_vt.ad_language Implied Constraint R
pp_order_header_vt.ad_language Implied Constraint R
pp_order_node_trl.ad_language adlangu_ppordernodetrl R
pp_order_node_vt.ad_language Implied Constraint R
pp_order_workflow_header_vt.ad_language Implied Constraint R
pp_order_workflow_trl.ad_language adlangu_pporderworkflowtrl R
pp_product_bom_trl.ad_language adlangu_ppproductbomtrl R
pp_product_bomline_trl.ad_language adlangu_ppproductbomlinetrl R
pp_product_bomline_vt.ad_language Implied Constraint R
r_mailtext_trl.ad_language adlanguage_rmailtexttrl R
rv_bpartner.ad_language Implied Constraint R
rv_bpartner.c_country_ad_language Implied Constraint R
rv_c_invoice.c_bp_ad_language Implied Constraint R
rv_c_invoicetax.c_bp_ad_language Implied Constraint R
rv_fact_acct.c_bp_ad_language Implied Constraint R
t_rv_reconciliation.c_bp_ad_language Implied Constraint R
w_mailmsg_trl.ad_language adlanguage_wmailmsgtrl C
w_store_trl.ad_language wstoretrl_adlangauge C
ad_client_id numeric 10 null
ad_client.ad_client_id languageclient R
ad_org_id numeric 10 null
ad_org.ad_org_id languageorg R
isactive bpchar 1 'N'::bpchar
created timestamp 29,6 now()
createdby numeric 10 null
updated timestamp 29,6 now()
updatedby numeric 10 null
name varchar 60 null
languageiso bpchar 2 √ null
countrycode bpchar 2 √ null
isbaselanguage bpchar 1 'N'::bpchar
issystemlanguage bpchar 1 'N'::bpchar
processing bpchar 1 √ null
ad_language_id numeric 10 null
ad_pinstance.ad_language_id adlanguage_adpinstance R
isdecimalpoint bpchar 1 √ null
datepattern varchar 20 √ null
timepattern varchar 20 √ null
ad_language_uu varchar 36 √ NULL::character varying
isloginlocale bpchar 1 √ 'N'::bpchar
ad_printpaper_id numeric 10 √ NULL::numeric
ad_printpaper.ad_printpaper_id adprintpaper_adlanguage R
printname varchar 60 NULL::character varying

Indexes

Constraint Name Type Sort Column(s)
ad_language_pkey Primary key Asc ad_language
ad_language_id_idx Must be unique Asc ad_language_id
ad_language_uu_idx Must be unique Asc ad_language_uu

Check Constraints

Constraint Name Constraint
ad_language_isloginlocale_check ((isloginlocale = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
ad_language_issystemlanguage_check ((issystemlanguage = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
ad_language_isbaselanguage_check ((isbaselanguage = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
ad_language_isactive_check ((isactive = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))

Relationships

Close relationships within degrees of separation