Table idempiere9.adempiere.a_depreciation_exp
A_Depreciation_Exp_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_depreciation_exp_id numeric 10 A_Depreciation_Exp_ID
ad_client_id numeric 10 Client/Tenant for this installation.
ad_org_id numeric 10 Organizational entity within client
a_entry_type varchar 3 Entry Type
created timestamp 29,6 statement_timestamp() Date this record was created
dateacct timestamp 29,6  √  null Accounting Date
expense numeric 0 (0)::numeric Expense
isdepreciated bpchar 1 The asset will be depreciated
processed bpchar 1 The document has been processed
updatedby numeric 10 User who updated this records
updated timestamp 29,6 statement_timestamp() Date this record was updated
postingtype bpchar 1  √  'A'::bpchar The type of posted amount for the transaction
isactive bpchar 1 The record is active in the system
description varchar 255 Optional short description of the record
createdby numeric 10 User who created this records
a_period numeric 10 Asset Period
a_asset_id numeric 10
a_asset.a_asset_id aasset_adepreciationexp R
Asset used internally or by customers
a_depreciation_exp_uu varchar 36  √  NULL::character varying A_Depreciation_Exp_UU
dr_account_id numeric 10  √  NULL::numeric
c_validcombination.c_validcombination_id draccou_adepreciationexp R
Account used
cr_account_id numeric 10  √  NULL::numeric
c_validcombination.c_validcombination_id craccou_adepreciationexp R
Account used
expense_f numeric 0 (0)::numeric Expense (fiscal)
processing bpchar 1  √  NULL::bpchar Process Now
help varchar 2000  √  NULL::character varying Comment or Hint
a_asset_cost numeric 0  √  null Asset Cost
a_accumulated_depr numeric 0  √  null Accumulated Depreciation
a_accumulated_depr_f numeric 0  √  null Accumulated Depreciation (fiscal)
uselifemonths numeric 10  √  NULL::numeric Months of the usable life of the asset
uselifemonths_f numeric 10  √  NULL::numeric Use Life - Months (fiscal)
a_asset_remaining numeric 0  √  null Remaining Amt
a_asset_remaining_f numeric 0  √  null Remaining Amt (fiscal)
a_asset_cost_delta numeric 0 (0)::numeric Delta Asset Cost
a_accumulated_depr_delta numeric 0 (0)::numeric Accumulated Depreciation (delta)
a_accumulated_depr_f_delta numeric 0 (0)::numeric Accumulated Depreciation - fiscal (delta)
a_asset_addition_id numeric 10  √  NULL::numeric
a_asset_addition.a_asset_addition_id aassetaddition_adepreciationex R
Asset Addition
a_asset_disposed_id numeric 10  √  NULL::numeric
a_asset_disposed.a_asset_disposed_id aassetdisposed_adepreciationex R
Asset Disposed
a_depreciation_entry_id numeric 10  √  NULL::numeric
a_depreciation_entry.a_depreciation_entry_id adepreciationentry_adepreciati R
Depreciation Entry
a_account_number_acct numeric 10  √  NULL::numeric
c_validcombination.c_validcombination_id aaccountnumber_adepreciationex R
A_Account_Number_Acct
c_acctschema_id numeric 10  √  NULL::numeric
c_acctschema.c_acctschema_id cacctschema_adepreciationexp C
Rules for accounting

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

Indexes:
Column(s) Type Sort Constraint Name
a_depreciation_exp_id Primary key Asc a_depreciation_exp_key
a_depreciation_exp_uu Must be unique Asc a_depreciation_exp_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.