gl_journalbatch

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
gl_journalbatch_id numeric 10 null
a_asset_addition.gl_journalbatch_id gljournalbatch_aassetaddition R
c_recurring.gl_journalbatch_id gljournalbatch_crecurring R
c_recurring_run.gl_journalbatch_id gljournalbatch_crecurringrun R
gl_journal.gl_journalbatch_id gljournalbatch_gljournal C
gl_journalbatch.reversal_id reversal_gljournalbatch R
i_fajournal.gl_journalbatch_id gljournalbatch_ifajournal R
i_gljournal.gl_journalbatch_id gljournalbatch_igljournal N
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
documentno varchar 30 null
description varchar 255 null
postingtype bpchar 1 null
gl_category_id numeric 10 √ null
gl_category.gl_category_id glcategory_gljournalbatch R
datedoc timestamp 29,6 √ null
dateacct timestamp 29,6 √ null
c_period_id numeric 10 √ null
c_period.c_period_id c_period_journalbatch R
c_currency_id numeric 10 √ null
c_currency.c_currency_id ccurrency_gljournalbatch R
totaldr numeric 0 0
totalcr numeric 0 0
controlamt numeric 0 √ 0
processing bpchar 1 'N'::bpchar
processed bpchar 1 'N'::bpchar
copyfrom bpchar 1 √ null
c_doctype_id numeric 10 null
c_doctype.c_doctype_id cdoctype_gljournalbatch R
docstatus bpchar 2 null
docaction bpchar 2 null
isapproved bpchar 1 √ null
reversal_id numeric 10 √ null
gl_journalbatch.gl_journalbatch_id reversal_gljournalbatch R
gl_journalbatch_uu varchar 36 √ NULL::character varying

Indexes

Constraint Name Type Sort Column(s)
gl_journalbatch_pkey Primary key Asc gl_journalbatch_id
gl_journalbatch_docno Must be unique Asc/Asc/Asc ad_org_id + c_period_id + documentno
gl_journalbatch_uu_idx Must be unique Asc gl_journalbatch_uu

Check Constraints

Constraint Name Constraint
gl_journalbatch_processed_check ((processed = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
gl_journalbatch_isactive_check ((isactive = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
gl_journalbatch_processing_check ((processing = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))

Relationships

Close relationships within degrees of separation