c_activity

1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
c_activity_id numeric 10 null
a_asset.c_activity_id cactivity_aasset R
c_acctschema_element.c_activity_id cactivity_cacctschemaelement R
c_activity_trl.c_activity_id cactivity_cactivitytrl C
c_cash.c_activity_id cactivity_ccash R
c_cashplan.c_activity_id cactivity_ccashplan R
c_cashplanline.c_activity_id cactivity_ccashplanline R
c_doctype.c_activity_id cactivity_cdoctype R
c_invoice.c_activity_id cactivity_cinvoice R
c_invoicebatchline.c_activity_id cactivity_cinvoicebatchline R
c_invoiceline.c_activity_id cactivity_cinvoiceline R
c_order.c_activity_id cactivity_corder R
c_orderline.c_activity_id cactivity_corderline R
c_payment.c_activity_id cactivity_cpayment R
c_paymenttransaction.c_activity_id cactivity_cpaymenttransaction R
c_project.c_activity_id cactivity_cproject R
c_validcombination.c_activity_id cactivity_cvalidcombination R
cof_c_acct_ignoreelement.c_activity_id cactivity_cofcacctignoreelemen R
cof_conciliacaocartao.c_activity_id cactivity_cofconciliacaocartao R
cof_configrateiolinha.c_activity_id cactivity_cofconfigrateiolinha R
cof_contract.c_activity_id cactivity_cofcontract R
cof_orcamentoconfig.c_activity_id cactivity_coforcamentoconfig R
cof_ordemservico.c_activity_id cactivity_cofordemservico R
cof_pp_planomestreprod.c_activity_id cactivity_cofppplanomestreprod R
cof_preferenciaxml.c_activity_id cactivity_cofpreferenciaxml R
dd_order.c_activity_id cactivity_ddorder R
dd_orderline.c_activity_id cactivity_ddorderline R
fact_acct.c_activity_id cactivity_factacct R
fact_acct_summary.c_activity_id cactivity_factacctsummary R
gl_distribution.c_activity_id cactivity_gldist R
gl_distributionline.c_activity_id cactivity_gldistline R
gl_journalline.c_activity_id cactivity_gljournalline R
hr_department.c_activity_id activity_hrdepartment R
hr_employee.c_activity_id cactivity_hremployee R
hr_movement.c_activity_id cactivity_hrmovement R
i_fajournal.c_activity_id cactivity_ifajournal R
i_gljournal.c_activity_id cactivity_gljournal N
i_invoice.c_activity_id cactivity_iinvoice N
i_order.c_activity_id cactivity_iorder N
m_inout.c_activity_id cactivity_minout R
m_inoutline.c_activity_id cactivity_minoutline R
m_inventory.c_activity_id cactivity_minventory R
m_movement.c_activity_id cactivity_mmovement R
m_production.c_activity_id cactivity_mproduction R
m_productionline.c_activity_id cactivity_mproductionline R
m_promotionprecondition.c_activity_id cactivity_mpromotionpreconditi R
pa_reportcolumn.c_activity_id cactivity_pareportcolumn R
pa_reportsource.c_activity_id cactivity_pareportsource R
pp_cost_collector.c_activity_id cactivity_ppcostcollector R
pp_order.c_activity_id cactivity_pporder R
r_request.c_activity_id cactivity_rrequest R
r_requestaction.c_activity_id cactivity_rrequestaction R
s_timeexpenseline.c_activity_id cactivity_stimeexpenseline R
t_aging.c_activity_id cactivity_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
issummary bpchar 1 'N'::bpchar
help varchar 2000 √ null
c_activity_uu varchar 36 √ NULL::character varying

Indexes

Constraint Name Type Sort Column(s)
c_activity_pkey Primary key Asc c_activity_id
c_activity_uu_idx Must be unique Asc c_activity_uu
c_activity_value Must be unique Asc/Asc ad_client_id + value

Check Constraints

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

Relationships

Close relationships within degrees of separation