a_depreciation_entry

3 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
a_depreciation_entry_id numeric 10 null
a_depreciation_exp.a_depreciation_entry_id adepreciationentry_adepreciati R
ad_client_id numeric 10 null
a_entry_type varchar 3 √ null
c_currency_id numeric 10 null
c_currency.c_currency_id ccurrency_adepreciationentry R
c_period_id numeric 10 null
c_period.c_period_id cperiod_adepreciationentry R
createdby numeric 10 null
datedoc timestamp 29,6 null
documentno varchar 60 null
isactive bpchar 1 'Y'::bpchar
updatedby numeric 10 null
updated timestamp 29,6 statement_timestamp()
processing bpchar 1 null
processed bpchar 1 'N'::bpchar
postingtype bpchar 1 'A'::bpchar
gl_category_id numeric 10 √ null
gl_category.gl_category_id glcategory_adepreciationentry R
description varchar 510 √ null
dateacct timestamp 29,6 null
created timestamp 29,6 statement_timestamp()
c_doctype_id numeric 10 null
c_doctype.c_doctype_id cdoctype_adepreciationentry R
c_acctschema_id numeric 10 null
c_acctschema.c_acctschema_id cacctschema_adepreciationentry R
ad_org_id numeric 10 null
a_depreciation_entry_uu varchar 36 √ NULL::character varying
docstatus varchar 2 'DR'::character varying
docaction bpchar 2 'CO'::bpchar
isapproved bpchar 1 null
posted bpchar 1 'N'::bpchar
processedon numeric 0 √ null
isreversal bpchar 1 'N'::bpchar

Indexes

Constraint Name Type Sort Column(s)
a_depreciation_entry_key Primary key Asc a_depreciation_entry_id
a_depreciation_entry_uu_idx Must be unique Asc a_depreciation_entry_uu

Check Constraints

Constraint Name Constraint
a_depreciation_entry_isreversal_check ((isreversal = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
a_depreciation_entry_isapproved_check ((isapproved = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
a_depreciation_entry_isactive_check ((isactive = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))

Relationships

Close relationships within degrees of separation