a_asset_group_acct

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
a_asset_group_id numeric 10 null
a_asset_group.a_asset_group_id aassetgroup_aassetgroupacct C
c_acctschema_id numeric 10 null
c_acctschema.c_acctschema_id cacctschema_aassetgroupacct R
ad_client_id numeric 10 null
ad_org_id numeric 10 null
isactive bpchar 1 √ null
created timestamp 29,6 statement_timestamp()
createdby numeric 10 √ null
updated timestamp 29,6 statement_timestamp()
updatedby numeric 10 √ null
a_asset_acct numeric 10 null
c_validcombination.c_validcombination_id aasset_aassetgroupacct R
a_depreciation_acct numeric 10 null
c_validcombination.c_validcombination_id adepreciationvc_aassetgroupacc R
a_accumdepreciation_acct numeric 10 null
c_validcombination.c_validcombination_id aaccumdepreciation_aassetgroup R
a_disposal_loss varchar 22 √ null
a_disposal_gain varchar 10 √ null
a_depreciation_id numeric 10 null
a_depreciation.a_depreciation_id adepreciation_aassetgroupacct R
a_asset_group_acct_id numeric 10 null
a_depreciation_manual_period varchar 2 √ null
a_depreciation_variable_perc numeric 0 √ null
a_split_percent numeric 0 (1)::numeric
a_reval_depexp_offset varchar 22 √ null
a_reval_cost_offset_prior varchar 22 √ null
a_reval_cost_offset varchar 22 √ null
a_reval_cal_method varchar 22 √ null
a_reval_accumdep_offset_prior varchar 22 √ null
a_reval_accumdep_offset_cur varchar 22 √ null
a_disposal_revenue varchar 22 √ null
uselifeyears numeric 0 √ null
uselifemonths numeric 10 √ (0)::numeric
processing bpchar 1 √ null
postingtype bpchar 1 'A'::bpchar
depreciationtype varchar 10 √ null
conventiontype varchar 10 √ null
a_depreciation_table_header_id numeric 10 √ null
a_depreciation_table_header.a_depreciation_table_header_id adepreciationtableheader_aass3 R
a_depreciation_manual_amount numeric 0 √ null
a_depreciation_calc_type varchar 10 √ null
a_asset_spread_type varchar 10 √ null
a_reval_depexp_offset_acct numeric 10 √ NULL::numeric
c_validcombination.c_validcombination_id arevaldepexpoffset_aassetgroup R
a_reval_cost_offset_prior_acct numeric 10 √ NULL::numeric
c_validcombination.c_validcombination_id arevalcostoffsetprior_aassetgr R
a_reval_cost_offset_acct numeric 10 √ NULL::numeric
c_validcombination.c_validcombination_id arevalcostoffset_aassetgroupac R
a_reval_adep_offset_prior_acct numeric 10 √ NULL::numeric
c_validcombination.c_validcombination_id arevaladepoffsetprior_aassetgr R
a_reval_adep_offset_cur_acct numeric 10 √ NULL::numeric
c_validcombination.c_validcombination_id arevaladepoffsetcur_aassetgrou R
a_disposal_gain_acct numeric 10 √ NULL::numeric
c_validcombination.c_validcombination_id adisposalgain_aassetgroupacct R
a_depreciation_method_id numeric 10 √ null
a_depreciation_method.a_depreciation_method_id adepreciationmethod_aassetgrou R
a_depreciation_conv_f_id numeric 10 √ null
a_depreciation_convention.a_depreciation_convention_id adepreciationconvf_aassetgroup R
a_depreciation_conv_id numeric 10 √ null
a_depreciation_convention.a_depreciation_convention_id adepreciationconv_aassetgroupa R
a_depreciation_method_f_id numeric 10 √ null
a_depreciation_method.a_depreciation_method_id adepreciationmethodf_aassetgro R
a_depreciation_variable_perc_f numeric 0 √ null
a_depreciation_f_id numeric 10 null
a_depreciation.a_depreciation_id adepreciationf_aassetgroupacct R
uselifeyears_f numeric 0 '0'::numeric
uselifemonths_f numeric 10 (0)::numeric
a_disposal_revenue_acct numeric 10 √ NULL::numeric
c_validcombination.c_validcombination_id adisposalrevenue_aassetgroupac R
a_disposal_loss_acct numeric 10 √ NULL::numeric
c_validcombination.c_validcombination_id adisposalloss_aassetgroupacct R
a_asset_group_acct_uu varchar 36 √ NULL::character varying

Indexes

Constraint Name Type Sort Column(s)
a_asset_group_acct_key Primary key Asc a_asset_group_acct_id
a_asset_group_acct_uu_idx Must be unique Asc a_asset_group_acct_uu

Check Constraints

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

Relationships

Close relationships within degrees of separation