t_cashflow

116 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
ad_client_id numeric 10 null
ad_org_id numeric 10 null
ad_pinstance_id numeric 10 null
ad_pinstance.ad_pinstance_id Implied Constraint R
c_acctschema_id numeric 10 √ NULL::numeric
c_activity_id numeric 10 √ NULL::numeric
c_activity.c_activity_id Implied Constraint R
cashflowsource bpchar 1 √ NULL::bpchar
cashflowtype bpchar 1 √ NULL::bpchar
c_bpartner_id numeric 10 √ NULL::numeric
c_bpartner.c_bpartner_id Implied Constraint R
c_campaign_id numeric 10 √ NULL::numeric
c_campaign.c_campaign_id Implied Constraint R
c_cashplanline_id numeric 10 √ NULL::numeric
c_cashplanline.c_cashplanline_id Implied Constraint R
c_charge_id numeric 10 √ NULL::numeric
c_charge.c_charge_id Implied Constraint R
c_elementvalue_id numeric 10 √ NULL::numeric
c_elementvalue.c_elementvalue_id Implied Constraint R
c_invoice_id numeric 10 √ NULL::numeric
c_invoice.c_invoice_id Implied Constraint R
c_order_id numeric 10 √ NULL::numeric
c_order.c_order_id Implied Constraint R
c_project_id numeric 10 √ NULL::numeric
c_project.c_project_id Implied Constraint R
created timestamp 29,6 statement_timestamp()
createdby numeric 10 null
dateto timestamp 29,6 √ null
datetrx timestamp 29,6 null
description varchar 255 √ NULL::character varying
isactive bpchar 1 'Y'::bpchar
issotrx bpchar 1 null
linetotalamt numeric 0 √ null
m_product_id numeric 10 √ NULL::numeric
m_product.m_product_id Implied Constraint R
name varchar 60 √ NULL::character varying
probability numeric 0 √ null
t_cashflow_id numeric 10 NULL::numeric
updated timestamp 29,6 statement_timestamp()
updatedby numeric 10 null
t_cashflow_uu varchar 36 √ NULL::character varying

Indexes

Constraint Name Type Sort Column(s)
t_cashflow_key Primary key Asc t_cashflow_id
t_cashflow_speed Performance Asc/Asc/Asc ad_pinstance_id + c_cashplanline_id + cashflowsource
t_cashflow_uu_idx Must be unique Asc t_cashflow_uu

Check Constraints

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

Relationships

Close relationships within degrees of separation