Table idempiere9.adempiere.a_asset_group_acct
Asset Group Accounting

Generated by
Quality Systems & Solutions
Legend:
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
a_asset_group_id numeric 10
a_asset_group.a_asset_group_id aassetgroup_aassetgroupacct C
Group of Assets
c_acctschema_id numeric 10
c_acctschema.c_acctschema_id cacctschema_aassetgroupacct R
Rules for accounting
ad_client_id numeric 10 Client/Tenant for this installation.
ad_org_id numeric 10 Organizational entity within client
isactive bpchar 1  √  null The record is active in the system
created timestamp 29,6 statement_timestamp() Date this record was created
createdby numeric 10  √  null User who created this records
updated timestamp 29,6 statement_timestamp() Date this record was updated
updatedby numeric 10  √  null User who updated this records
a_asset_acct numeric 10
c_validcombination.c_validcombination_id aasset_aassetgroupacct R
Asset Acct
a_depreciation_acct numeric 10
c_validcombination.c_validcombination_id adepreciationvc_aassetgroupacc R
Depreciation Account
a_accumdepreciation_acct numeric 10
c_validcombination.c_validcombination_id aaccumdepreciation_aassetgroup R
Accumulated Depreciation Account
a_disposal_loss varchar 22  √  null Loss on Disposal
a_disposal_gain varchar 10  √  null Disposal Gain
a_depreciation_id numeric 10
a_depreciation.a_depreciation_id adepreciation_aassetgroupacct R
Depreciation
a_asset_group_acct_id numeric 10 Asset Group Accounting
a_depreciation_manual_period varchar 2  √  null A_Depreciation_Manual_Period
a_depreciation_variable_perc numeric 0  √  null Variable Percent
a_split_percent numeric 0 (1)::numeric Split Percent
a_reval_depexp_offset varchar 22  √  null Revaluation Expense Offs
a_reval_cost_offset_prior varchar 22  √  null Revaluation Cost Offset for Prior Year
a_reval_cost_offset varchar 22  √  null Revaluation Cost Offset for Current Year
a_reval_cal_method varchar 22  √  null A_Reval_Cal_Method
a_reval_accumdep_offset_prior varchar 22  √  null Revaluation Accumulated Depreciation Offset for Prior Year
a_reval_accumdep_offset_cur varchar 22  √  null Revaluation Accumulated Depreciation Offset for Current Year
a_disposal_revenue varchar 22  √  null Disposal Revenue
uselifeyears numeric 10  √  null Years of the usable life of the asset
uselifemonths numeric 10  √  (0)::numeric Months of the usable life of the asset
processing bpchar 1  √  null Process Now
postingtype bpchar 1 'A'::bpchar The type of posted amount for the transaction
depreciationtype varchar 10  √  null DepreciationType
conventiontype varchar 10  √  null ConventionType
a_depreciation_table_header_id numeric 10  √  null
a_depreciation_table_header.a_depreciation_table_header_id adepreciationtableheader_aass3 R
A_Depreciation_Table_Header_ID
a_depreciation_manual_amount numeric 0  √  null A_Depreciation_Manual_Amount
a_depreciation_calc_type varchar 10  √  null Calculation Type
a_asset_spread_type varchar 10  √  null Spread Type
a_reval_depexp_offset_acct numeric 10  √  NULL::numeric
c_validcombination.c_validcombination_id arevaldepexpoffset_aassetgroup R
Reval Depexp Offset Acct
a_reval_cost_offset_prior_acct numeric 10  √  NULL::numeric
c_validcombination.c_validcombination_id arevalcostoffsetprior_aassetgr R
Reval Cost Offset Prior Acct
a_reval_cost_offset_acct numeric 10  √  NULL::numeric
c_validcombination.c_validcombination_id arevalcostoffset_aassetgroupac R
Reval Cost Offset Acct
a_reval_adep_offset_prior_acct numeric 10  √  NULL::numeric
c_validcombination.c_validcombination_id arevaladepoffsetprior_aassetgr R
A_Reval_Accumdep_Offset_Prior
a_reval_adep_offset_cur_acct numeric 10  √  NULL::numeric
c_validcombination.c_validcombination_id arevaladepoffsetcur_aassetgrou R
A_Reval_Accumdep_Offset_Cur
a_disposal_gain_acct numeric 10  √  NULL::numeric
c_validcombination.c_validcombination_id adisposalgain_aassetgroupacct R
Disposal Gain Acct
a_depreciation_method_id numeric 10  √  null
a_depreciation_method.a_depreciation_method_id adepreciationmethod_aassetgrou R
Depreciation Method
a_depreciation_conv_f_id numeric 10  √  null
a_depreciation_convention.a_depreciation_convention_id adepreciationconvf_aassetgroup R
Depreciation Convention (fiscal)
a_depreciation_conv_id numeric 10  √  null
a_depreciation_convention.a_depreciation_convention_id adepreciationconv_aassetgroupa R
Convention Type
a_depreciation_method_f_id numeric 10  √  null
a_depreciation_method.a_depreciation_method_id adepreciationmethodf_aassetgro R
Depreciation Method (fiscal)
a_depreciation_variable_perc_f numeric 0  √  null Variable Percent (fiscal)
a_depreciation_f_id numeric 10
a_depreciation.a_depreciation_id adepreciationf_aassetgroupacct R
Depreciation (fiscal)
uselifeyears_f numeric 10 (0)::numeric Use Life - Years (fiscal)
uselifemonths_f numeric 10 (0)::numeric Use Life - Months (fiscal)
a_disposal_revenue_acct numeric 10  √  NULL::numeric
c_validcombination.c_validcombination_id adisposalrevenue_aassetgroupac R
Disposal Revenue Acct
a_disposal_loss_acct numeric 10  √  NULL::numeric
c_validcombination.c_validcombination_id adisposalloss_aassetgroupacct R
Disposal Loss Acct
a_asset_group_acct_uu varchar 36  √  NULL::character varying A_Asset_Group_Acct_UU

Table contained 6 rows at 2021-12-25 14:43 +0100

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


SchemaSpy was unable to generate a diagram of table relationships.
SchemaSpy requires Graphviz version 2.2.1 or versions greater than 2.4 from www.graphviz.org.