c_location

16 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
c_location_id numeric 10 null
a_asset.c_location_id clocation_aasset R
a_asset_change.c_location_id clocation_aassetchange R
ad_orginfo.c_location_id c_location_ad_orginfo R
ad_registration.c_location_id clocation_adregistration R
ad_user.bp_location_id bplocation_aduser R
ad_user.c_location_id clocation_aduser R
c_acctschema_element.c_location_id clocation_caschemaelement R
c_addresstransaction.c_location_id clocation_caddresstransaction R
c_bank.c_location_id clocation_cbank R
c_bpartner_location.c_location_id clocation_cbplocation R
c_validcombination.c_locfrom_id mlocationfrom_vc R
c_validcombination.c_locto_id mlocationto_vc R
cof_c_acct_ignoreelement.c_location_id clocation_cofcacctignoreelemen R
cof_entregaavulsa.c_location_id clocation_cofentregaavulsa R
cof_member.c_location_id clocation_cofmember R
cof_orcamentoconfig.cof_locationfrom_id coflocationfrom_coforcamentoco R
cof_orcamentoconfig.cof_locationto_id coflocationto_coforcamentoconf R
cof_ordemservico.c_location_id clocation_cofordemservico R
cof_rps.org_location_id orglocation_cofrps R
cof_titulo.org_location_id orglocation_coftitulo R
fact_acct.c_locfrom_id c_locationfrom_fact_acct R
fact_acct.c_locto_id c_locationto_fact_acct R
fact_acct_summary.c_locfrom_id clocfrom_factacctsummary R
fact_acct_summary.c_locto_id clocto_factacctsummary R
gl_distribution.c_locfrom_id clocfrom_gldist R
gl_distribution.c_locto_id clocto_gldist R
gl_distributionline.c_locfrom_id clocfrom_gldistline R
gl_distributionline.c_locto_id clocto_gldistline R
gl_journalline.c_locfrom_id clocfrom_gljournalline R
gl_journalline.c_locto_id clocto_gljournalline R
i_asset.c_location_id clocation_iasset R
i_fajournal.c_locfrom_id clocfrom_ifajournal R
i_fajournal.c_locto_id clocto_ifajournal R
i_gljournal.c_locfrom_id clocfrom_igljournal N
i_gljournal.c_locto_id clocto_igljournal N
i_invoice.c_location_id clocation_iinvoice N
i_order.c_location_id clocation_iorder N
m_warehouse.c_location_id c_location_warehouse R
pa_reportcolumn.c_location_id clocation_pareportcolumn R
pa_reportsource.c_location_id clocation_pareportsource R
ad_client_id numeric 10 null
ad_client.ad_client_id adclient_clocation R
ad_org_id numeric 10 null
ad_org.ad_org_id adorg_clocation R
isactive bpchar 1 'Y'::bpchar
created timestamp 29,6 now()
createdby numeric 10 null
updated timestamp 29,6 now()
updatedby numeric 10 null
address1 varchar 60 √ null
address2 varchar 60 √ null
city varchar 60 √ null
postal varchar 10 √ null
postal_add varchar 10 √ null
c_country_id numeric 10 null
c_country.c_country_id c_country_location R
c_region_id numeric 10 √ null
c_region.c_region_id c_region_location R
c_city_id numeric 10 √ null
c_city.c_city_id ccity_clocation R
regionname varchar 40 √ null
address3 varchar 60 √ null
address4 varchar 60 √ null
c_location_uu varchar 36 √ NULL::character varying
validateaddress bpchar 1 √ NULL::bpchar
result varchar 2000 √ NULL::character varying
isvalid bpchar 1 √ 'N'::bpchar
c_addressvalidation_id numeric 10 √ NULL::numeric
c_addressvalidation.c_addressvalidation_id caddressvalidation_clocation R
address5 varchar 60 √ NULL::character varying
comments varchar 2000 √ NULL::character varying
cof_latitude varchar 15 √ NULL::character varying
cof_longitude varchar 15 √ NULL::character varying
place_id text 2147483647 √ null

Indexes

Constraint Name Type Sort Column(s)
c_location_pkey Primary key Asc c_location_id
c_location_uu_idx Must be unique Asc c_location_uu

Check Constraints

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

Relationships

Close relationships within degrees of separation