gl_budget

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
gl_budget_id numeric 10 null
fact_acct.gl_budget_id glbudget_factacct R
fact_acct_balance.gl_budget_id Implied Constraint R
fact_acct_summary.gl_budget_id glbudget_factacctsummary R
gl_budgetcontrol.gl_budget_id glbudget_glbudgetcontrol R
gl_journal.gl_budget_id glbudget_gljournal R
i_fajournal.gl_budget_id glbudget_ifajournal R
i_gljournal.gl_budget_id glbudget_igljournal N
pa_reportcolumn.gl_budget_id glbudget_pareportcolumn R
pa_reportline.gl_budget_id glbudget_pareportline R
rv_fact_acct.gl_budget_id Implied Constraint R
rv_fact_acct_day.gl_budget_id Implied Constraint R
rv_fact_acct_period.gl_budget_id Implied Constraint R
t_invoicegl_v.gl_budget_id Implied Constraint R
t_rv_reconciliation.gl_budget_id Implied Constraint R
t_trialbalance.gl_budget_id Implied Constraint 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
name varchar 60 null
description varchar 255 √ null
isprimary bpchar 1 'Y'::bpchar
budgetstatus bpchar 1 √ null
gl_budget_uu varchar 36 √ NULL::character varying

Indexes

Constraint Name Type Sort Column(s)
gl_budget_pkey Primary key Asc gl_budget_id
gl_budget_name Must be unique Asc/Asc ad_client_id + name
gl_budget_uu_idx Must be unique Asc gl_budget_uu

Check Constraints

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

Relationships

Close relationships within degrees of separation