c_campaign

1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
c_campaign_id numeric 10 null
ad_user.c_campaign_id ccampaign_aduser R
c_acctschema_element.c_campaign_id socampaign_caschemaelement R
c_campaign_trl.c_campaign_id ccampaign_ccampaigntrl C
c_cash.c_campaign_id ccampaign_ccash R
c_cashplan.c_campaign_id ccampaign_ccashplan R
c_cashplanline.c_campaign_id ccampaign_ccashplanline R
c_invoice.c_campaign_id ccampaign_cinvoice R
c_invoiceline.c_campaign_id ccampaign_cinvoiceline R
c_opportunity.c_campaign_id ccampaign_copportunity R
c_order.c_campaign_id ccampaign_corder R
c_orderline.c_campaign_id ccampaign_corderline R
c_payment.c_campaign_id ccampaign_cpayment R
c_paymenttransaction.c_campaign_id ccampaign_cpaymenttransaction R
c_project.c_campaign_id ccampaign_cproject R
c_validcombination.c_campaign_id socampaign_vc R
cof_c_acct_ignoreelement.c_campaign_id ccampaign_cofcacctignoreelemen R
cof_conciliacaocartao.c_campaign_id ccampaign_cofconciliacaocartao R
cof_configrateiolinha.c_campaign_id ccampaign_cofconfigrateiolinha R
cof_orcamentoconfig.c_campaign_id ccampaign_coforcamentoconfig R
cof_ordemservico.c_campaign_id ccampaign_cofordemservico R
cof_pp_planomestreprod.c_campaign_id ccampaign_cofppplanomestreprod R
cof_preferenciaxml.c_campaign_id ccampaign_cofpreferenciaxml R
dd_order.c_campaign_id ccampaign_ddorder R
dd_orderline.c_campaign_id ccampaign_ddorderline R
fact_acct.c_campaign_id so_campaign_fact_acct R
fact_acct_summary.c_campaign_id ccampaign_factacctsummary R
gl_distribution.c_campaign_id ccampaign_gldist R
gl_distributionline.c_campaign_id ccampaign_gldistline R
gl_journalline.c_campaign_id ccampaign_gljournalline R
hr_contract.c_campaign_id ccampaign_hrcontract R
hr_movement.c_campaign_id ccampaign_hrmovement R
i_fajournal.c_campaign_id ccampaign_ifajournal R
i_gljournal.c_campaign_id ccampaign_igljournal N
i_invoice.c_campaign_id ccampaign_iinvoice N
i_movement.c_campaign_id ccampaign_imovement R
i_order.c_campaign_id ccampaign_iorder N
m_inout.c_campaign_id ccampaign_minout R
m_inoutline.c_campaign_id ccampaign_minoutline R
m_inventory.c_campaign_id ccampaign_minventory R
m_movement.c_campaign_id ccampaign_mmovement R
m_production.c_campaign_id ccampaign_mproduction R
m_productionline.c_campaign_id ccampaign_mproductionline R
m_promotion.c_campaign_id ccampaign_mpromotion R
pa_reportcolumn.c_campaign_id ccampaign_pareportcolumn R
pa_reportsource.c_campaign_id ccampaign_pareportsource R
pp_cost_collector.c_campaign_id ccampaign_ppcostcollector R
pp_order.c_campaign_id ccampaign_pporder R
r_request.c_campaign_id ccampaign_rrequest R
s_timeexpenseline.c_campaign_id ccampaign_stimeexpenseline R
t_aging.c_campaign_id ccampaign_taging C
ad_client_id numeric 10 null
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
c_channel_id numeric 10 √ null
c_channel.c_channel_id cchannel_ccampaign R
startdate timestamp 29,6 √ null
enddate timestamp 29,6 √ null
costs numeric 0 0
issummary bpchar 1 'N'::bpchar
c_campaign_uu varchar 36 √ NULL::character varying

Indexes

Constraint Name Type Sort Column(s)
c_campaign_pkey Primary key Asc c_campaign_id
c_campaign_uu_idx Must be unique Asc c_campaign_uu
c_campaign_value Must be unique Asc/Asc ad_client_id + value

Check Constraints

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

Relationships

Close relationships within degrees of separation