pa_reportcolumn

12 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
pa_reportcolumn_id numeric 10 null
pa_reportcolumn.oper_1_id pareportcolumn_oper1 N
pa_reportcolumn.oper_2_id pareportcolumn_oper2 N
pa_reportcolumn_trl.pa_reportcolumn_id pareportcolumn_pareportcolumnt R
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
pa_reportcolumnset_id numeric 10 null
pa_reportcolumnset.pa_reportcolumnset_id pareportcolumnset_column C
name varchar 255 null
seqno numeric 10 null
description varchar 255 √ null
isprinted bpchar 1 'Y'::bpchar
postingtype bpchar 1 null
gl_budget_id numeric 10 √ null
gl_budget.gl_budget_id glbudget_pareportcolumn R
columntype bpchar 1 null
relativeperiod numeric 10 √ null
currencytype bpchar 1 √ null
calculationtype bpchar 1 √ null
amounttype bpchar 2 √ null
c_currency_id numeric 10 √ null
c_currency.c_currency_id ccurrency_pareportcolumn R
isadhocconversion bpchar 1 √ 'N'::bpchar
oper_1_id numeric 10 √ null
pa_reportcolumn.pa_reportcolumn_id pareportcolumn_oper1 N
oper_2_id numeric 10 √ null
pa_reportcolumn.pa_reportcolumn_id pareportcolumn_oper2 N
elementtype bpchar 2 √ null
org_id numeric 10 √ null
ad_org.ad_org_id adorg_pareportcolumn R
c_elementvalue_id numeric 10 √ null
c_elementvalue.c_elementvalue_id celementvalue_pareportcolumn R
c_project_id numeric 10 √ null
c_project.c_project_id cproject_pareportcolumn R
c_bpartner_id numeric 10 √ null
c_bpartner.c_bpartner_id cbpartner_pareportcolumn R
m_product_id numeric 10 √ null
m_product.m_product_id mproduct_pareportcolumn R
c_campaign_id numeric 10 √ null
c_campaign.c_campaign_id ccampaign_pareportcolumn R
c_location_id numeric 10 √ null
c_location.c_location_id clocation_pareportcolumn R
c_salesregion_id numeric 10 √ null
c_salesregion.c_salesregion_id csalesregion_pareportcolumn R
c_activity_id numeric 10 √ null
c_activity.c_activity_id cactivity_pareportcolumn R
userelement1_id numeric 10 √ null
userelement2_id numeric 10 √ null
isincludenullsorg bpchar 1 'N'::bpchar
isincludenullselementvalue bpchar 1 'N'::bpchar
isincludenullsbpartner bpchar 1 'N'::bpchar
isincludenullsproduct bpchar 1 'N'::bpchar
isincludenullslocation bpchar 1 'N'::bpchar
isincludenullsproject bpchar 1 'N'::bpchar
isincludenullssalesregion bpchar 1 'N'::bpchar
isincludenullsactivity bpchar 1 'N'::bpchar
isincludenullscampaign bpchar 1 'N'::bpchar
isincludenullsuserelement1 bpchar 1 'N'::bpchar
isincludenullsuserelement2 bpchar 1 'N'::bpchar
factor bpchar 1 √ null
formatpattern varchar 22 √ null
isincludenullsorgtrx bpchar 1 'N'::bpchar
ad_orgtrx_id numeric 10 √ null
ad_org.ad_org_id adorgtrx_pareportcolumn R
paperiodtype bpchar 1 √ 'P'::bpchar
paamounttype bpchar 1 √ 'B'::bpchar
pa_reportcolumn_uu varchar 36 √ NULL::character varying
oper_2_linename varchar 512 √ NULL::character varying
isallowoppositesign bpchar 1 √ 'N'::bpchar
relativeperiodto numeric 0 √ null
roundfactor numeric 10 √ NULL::numeric
multiplier numeric 0 √ null

Indexes

Constraint Name Type Sort Column(s)
pa_reportcolumn_pkey Primary key Asc pa_reportcolumn_id
pa_reportcolumn_uu_idx Must be unique Asc pa_reportcolumn_uu

Check Constraints

Constraint Name Constraint
pa_reportcolumn_isincludenullsactivity_check ((isincludenullsactivity = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
pa_reportcolumn_isincludenullsorg_check ((isincludenullsorg = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
pa_reportcolumn_isincludenullsuserelement2_check ((isincludenullsuserelement2 = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
pa_reportcolumn_isadhocconversion_check ((isadhocconversion = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
pa_reportcolumn_isincludenullsproject_check ((isincludenullsproject = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
pa_reportcolumn_isincludenullssalesregion_check ((isincludenullssalesregion = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
pa_reportcolumn_isincludenullslocation_check ((isincludenullslocation = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
pa_reportcolumn_isactive_check ((isactive = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
pa_reportcolumn_isallowoppositesign_check ((isallowoppositesign = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
pa_reportcolumn_isincludenullsproduct_check ((isincludenullsproduct = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
pa_reportcolumn_isincludenullsuserelement1_check ((isincludenullsuserelement1 = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
pa_reportcolumn_isincludenullscampaign_check ((isincludenullscampaign = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
pa_reportcolumn_isprinted_check ((isprinted = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
pa_reportcolumn_isincludenullsorgtrx_check ((isincludenullsorgtrx = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
pa_reportcolumn_isincludenullselementvalue_check ((isincludenullselementvalue = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
pa_reportcolumn_isincludenullsbpartner_check ((isincludenullsbpartner = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))

Relationships

Close relationships within degrees of separation