gl_category

47 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
gl_category_id numeric 10 null
a_asset_reval_entry.gl_category_id glcategory_aassetrevalentry R
a_depreciation_entry.gl_category_id glcategory_adepreciationentry R
c_doctype.gl_category_id glcategory_cdoctype R
cof_configexportcontabexcecoes.gl_category_id glcategory_cofconfigexportcont R
fact_acct.gl_category_id glcategory_factacct R
gl_category_trl.gl_category_id glcategory_glcategorytrl C
gl_journal.gl_category_id glcategory_gljournal R
gl_journalbatch.gl_category_id glcategory_gljournalbatch R
gl_journalgenerator.gl_category_id glcategory_qssjournalgenerator R
gl_journalgeneratorsource.gl_category_id glcategory_gljournalgenerators R
i_fajournal.gl_category_id glcategory_ifajournal R
i_gljournal.gl_category_id glcategory_igljournal N
rv_fact_acct.gl_category_id Implied Constraint R
rv_fact_acct_day.gl_category_id Implied Constraint R
rv_fact_acct_period.gl_category_id Implied Constraint R
t_invoicegl_v.gl_category_id Implied Constraint R
t_rv_reconciliation.gl_category_id Implied Constraint R
t_trialbalance.gl_category_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
categorytype bpchar 1 null
isdefault bpchar 1 'N'::bpchar
docbasetype bpchar 3 √ null
gl_category_uu varchar 36 √ NULL::character varying
value varchar 60 NULL::character varying
printname varchar 60 √ NULL::character varying

Indexes

Constraint Name Type Sort Column(s)
gl_category_pkey Primary key Asc gl_category_id
gl_category_name Must be unique Asc/Asc ad_client_id + name
gl_category_uu_idx Must be unique Asc gl_category_uu
gl_category_value Must be unique Asc/Asc ad_client_id + value

Check Constraints

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

Relationships

Close relationships within degrees of separation