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 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 Depreciation Account
a_accumdepreciation_acct numeric 10 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 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 Disposal Gain Acct
a_reval_cost_offset_prior_acct numeric 10  √  NULL::numeric Reval Cost Offset Prior Acct
a_reval_cost_offset_acct numeric 10  √  NULL::numeric Reval Cost Offset Acct
a_reval_adep_offset_prior_acct numeric 10  √  NULL::numeric A_Reval_Accumdep_Offset_Prior
a_reval_adep_offset_cur_acct numeric 10  √  NULL::numeric A_Reval_Accumdep_Offset_Cur
a_disposal_revenue_acct numeric 10 Disposal Revenue Acct
a_disposal_loss_acct numeric 10 Disposal Loss Acct
a_reval_depexp_offset_acct numeric 10  √  NULL::numeric 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:45 +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

Close relationships  within of separation: