a_depreciation_exp

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
a_depreciation_exp_id numeric 10 null
ad_client_id numeric 10 null
ad_org_id numeric 10 null
a_entry_type varchar 3 null
created timestamp 29,6 statement_timestamp()
dateacct timestamp 29,6 √ null
expense numeric 0 (0)::numeric
isdepreciated bpchar 1 null
processed bpchar 1 null
updatedby numeric 10 null
updated timestamp 29,6 statement_timestamp()
postingtype bpchar 1 √ 'A'::bpchar
isactive bpchar 1 null
description varchar 255 null
createdby numeric 10 null
a_period numeric 10 null
a_asset_id numeric 10 null
a_asset.a_asset_id aasset_adepreciationexp R
a_depreciation_exp_uu varchar 36 √ NULL::character varying
dr_account_id numeric 10 √ NULL::numeric
c_validcombination.c_validcombination_id draccou_adepreciationexp R
cr_account_id numeric 10 √ NULL::numeric
c_validcombination.c_validcombination_id craccou_adepreciationexp R
expense_f numeric 0 (0)::numeric
processing bpchar 1 √ NULL::bpchar
help varchar 2000 √ NULL::character varying
a_asset_cost numeric 0 √ null
a_accumulated_depr numeric 0 √ null
a_accumulated_depr_f numeric 0 √ null
uselifemonths numeric 10 √ NULL::numeric
uselifemonths_f numeric 10 √ NULL::numeric
a_asset_remaining numeric 0 √ null
a_asset_remaining_f numeric 0 √ null
a_asset_cost_delta numeric 0 (0)::numeric
a_accumulated_depr_delta numeric 0 (0)::numeric
a_accumulated_depr_f_delta numeric 0 (0)::numeric
a_asset_addition_id numeric 10 √ NULL::numeric
a_asset_addition.a_asset_addition_id aassetaddition_adepreciationex R
a_asset_disposed_id numeric 10 √ NULL::numeric
a_asset_disposed.a_asset_disposed_id aassetdisposed_adepreciationex R
a_depreciation_entry_id numeric 10 √ NULL::numeric
a_depreciation_entry.a_depreciation_entry_id adepreciationentry_adepreciati R
a_account_number_acct numeric 10 √ NULL::numeric
c_validcombination.c_validcombination_id aaccountnumber_adepreciationex R
c_acctschema_id numeric 10 √ NULL::numeric
c_acctschema.c_acctschema_id cacctschema_adepreciationexp C

Indexes

Constraint Name Type Sort Column(s)
a_depreciation_exp_key Primary key Asc a_depreciation_exp_id
a_depreciation_exp_uu_idx Must be unique Asc a_depreciation_exp_uu

Check Constraints

Constraint Name Constraint
a_depreciation_exp_isdepreciated_check ((isdepreciated = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
a_depreciation_exp_processed_check ((processed = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
a_depreciation_exp_isactive_check ((isactive = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))

Relationships

Close relationships within degrees of separation