Table idempiere9.adempiere.a_asset_acct
A_Asset_Acct_ID

 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_id numeric 10
a_asset.a_asset_id aasset_aassetacct C
Asset used internally or by customers
c_acctschema_id numeric 10
c_acctschema.c_acctschema_id cacctschema_aassetacct 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 The record is active in the system
created timestamp 29,6 statement_timestamp() Date this record was created
createdby numeric 10 User who created this records
updated timestamp 29,6 statement_timestamp() Date this record was updated
updatedby numeric 10 User who updated this records
a_depreciation_id numeric 10
a_depreciation.a_depreciation_id adepreciation_aassetacct R
Depreciation
a_depreciation_acct numeric 10
c_validcombination.c_validcombination_id adepreciationvc_aassetacct R
Depreciation Account
a_accumdepreciation_acct numeric 10
c_validcombination.c_validcombination_id aaccumdepreciation_aassetacct R
Accumulated Depreciation Account
a_disposal_loss varchar 40  √  null Loss on Disposal
a_disposal_gain varchar 10  √  null Disposal Gain
a_asset_acct numeric 10
c_validcombination.c_validcombination_id aassetvc_aassetacct R
Asset Acct
a_asset_acct_id numeric 10 A_Asset_Acct_ID
a_depreciation_manual_period varchar 2  √  null A_Depreciation_Manual_Period
a_depreciation_table_header_id numeric 10  √  null
a_depreciation_table_header.a_depreciation_table_header_id adepreciationtableheader_aasse R
A_Depreciation_Table_Header_ID
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 3  √  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_period_start numeric 10 A_Period_Start
a_period_end numeric 10 A_Period_End
a_disposal_revenue varchar 40  √  null Disposal Revenue
processing bpchar 1  √  'Y'::bpchar Process Now
postingtype bpchar 1 'A'::bpchar The type of posted amount for the transaction
a_split_percent numeric 0 (1)::numeric Split Percent
a_salvage_value numeric 0  √  (0)::numeric Asset Salvage Value
a_reval_depexp_offset varchar 22  √  null Revaluation Expense Offs
a_depreciation_variable_perc numeric 0  √  null Variable Percent
a_depreciation_method_id numeric 10  √  null
a_depreciation_method.a_depreciation_method_id adepreciationmethod_aassetacct R
Depreciation Method
a_depreciation_manual_amount numeric 0  √  null A_Depreciation_Manual_Amount
a_depreciation_conv_id numeric 10  √  null
a_depreciation_convention.a_depreciation_convention_id adepreciationconv_aassetacct R
Convention Type
a_asset_spread_id numeric 10  √  null
a_asset_spread.a_asset_spread_id aassetspread_aassetacct R
A_Asset_Spread_ID
a_disposal_gain_acct numeric 10  √  NULL::numeric
c_validcombination.c_validcombination_id adisposalgain_aassetacct R
Disposal Gain Acct
a_reval_cost_offset_prior_acct numeric 10  √  NULL::numeric
c_validcombination.c_validcombination_id arevalcostoffsetprior_aassetac R
Reval Cost Offset Prior Acct
a_reval_cost_offset_acct numeric 10  √  NULL::numeric
c_validcombination.c_validcombination_id arevalcostoffset_aassetacct R
Reval Cost Offset Acct
a_reval_adep_offset_prior_acct numeric 10  √  NULL::numeric
c_validcombination.c_validcombination_id arevaladepoffsetprior_aassetac R
A_Reval_Accumdep_Offset_Prior
a_reval_adep_offset_cur_acct numeric 10  √  NULL::numeric
c_validcombination.c_validcombination_id arevaladepoffsetcur_aassetacct R
A_Reval_Accumdep_Offset_Cur
a_disposal_revenue_acct numeric 10
c_validcombination.c_validcombination_id adisposalrevenue_aassetacct R
Disposal Revenue Acct
a_disposal_loss_acct numeric 10
c_validcombination.c_validcombination_id adisposalloss_aassetacct R
Disposal Loss Acct
a_reval_depexp_offset_acct numeric 10  √  NULL::numeric
c_validcombination.c_validcombination_id arevaldepexpoffset_aassetacct R
Reval Depexp Offset Acct
a_depreciation_method_f_id numeric 10  √  null
a_depreciation_method.a_depreciation_method_id adepreciationmethodf_aassetacc R
Depreciation Method (fiscal)
a_depreciation_f_id numeric 10
a_depreciation.a_depreciation_id adepreciationf_aassetacct R
Depreciation (fiscal)
a_depreciation_conv_f_id numeric 10  √  null
a_depreciation_convention.a_depreciation_convention_id adepreciationconvf_aassetacct R
Depreciation Convention (fiscal)
a_depreciation_variable_perc_f numeric 0  √  null Variable Percent (fiscal)
validfrom timestamp 29,6  √  null Valid from including this date (first day)
a_asset_acct_uu varchar 36  √  NULL::character varying A_Asset_Acct_UU

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

Indexes:
Column(s) Type Sort Constraint Name
a_asset_acct_id Primary key Asc a_asset_acct_pkey
a_asset_acct_uu Must be unique Asc a_asset_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.