Table idempiere9.adempiere.a_depreciation_workfile
A_Depreciation_Workfile_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_workfile_id numeric 10 A_Depreciation_Workfile_ID
ad_client_id numeric 10 Client/Tenant for this installation.
ad_org_id numeric 10 Organizational entity within client
a_accumulated_depr numeric 0 (0)::numeric Accumulated Depreciation
a_asset_cost numeric 0 (0)::numeric Asset Cost
a_asset_id numeric 10
a_asset.a_asset_id aasset_adepreciationworkfile R
Asset used internally or by customers
a_asset_life_current_year numeric 0 (0)::numeric A_Asset_Life_Current_Year
a_period_forecast numeric 0  √  null A_Period_Forecast
a_prior_year_accumulated_depr numeric 0  √  null A_Prior_Year_Accumulated_Depr
postingtype bpchar 1  √  'A'::bpchar The type of posted amount for the transaction
isdepreciated bpchar 1  √  null The asset will be depreciated
isactive bpchar 1 The record is active in the system
dateacct timestamp 29,6  √  null Accounting Date
createdby numeric 10 User who created this records
created timestamp 29,6 statement_timestamp() Date this record was created
assetdepreciationdate timestamp 29,6  √  null Date of last depreciation
a_salvage_value numeric 0 (0)::numeric Asset Salvage Value
a_qty_current numeric 0 Current Qty
updatedby numeric 10 User who updated this records
updated timestamp 29,6 statement_timestamp() Date this record was updated
processing bpchar 1  √  'N'::bpchar Process Now
a_period_posted numeric 10  √  null A_Period_Posted
a_life_period numeric 10 (0)::numeric Life Periods
a_asset_life_years numeric 10 (0)::numeric Life Years
a_base_amount numeric 0  √  null A_Base_Amount
a_calc_accumulated_depr numeric 0  √  (0)::numeric A_Calc_Accumulated_Depr
a_curr_dep_exp numeric 0 (0)::numeric A_Curr_Dep_Exp
a_current_period numeric 10  √  null Current Period
a_depreciation_workfile_uu varchar 36  √  NULL::character varying A_Depreciation_Workfile_UU
a_accumulated_depr_f numeric 0 (0)::numeric Accumulated Depreciation (fiscal)
a_asset_life_years_f numeric 10 (0)::numeric Life Years (fiscal)
a_life_period_f numeric 10 (0)::numeric Life Period (fiscal)
uselifeyears numeric 10 (0)::numeric Years of the usable life of the asset
uselifemonths numeric 10 (0)::numeric Months of the usable life of the asset
uselifeyears_f numeric 10 (0)::numeric Use Life - Years (fiscal)
uselifemonths_f numeric 10 (0)::numeric Use Life - Months (fiscal)
a_asset_remaining numeric 0  √  null Remaining Amt
a_asset_remaining_f numeric 0  √  null Remaining Amt (fiscal)
a_tip_finantare bpchar 1 'P'::bpchar Financing Type
a_valoare_cofinantare numeric 0  √  null Own contribution
a_valoare_tert numeric 0  √  null Third contribution
description varchar 255  √  NULL::character varying Optional short description of the record
a_fundingmode_id numeric 10  √  NULL::numeric
a_fundingmode.a_fundingmode_id afundingmode_adepreciationwork R
Asset Funding Mode
processed bpchar 1 'N'::bpchar The document has been processed
c_acctschema_id numeric 10  √  NULL::numeric
c_acctschema.c_acctschema_id cacctschema_adepreciationworkf C
Rules for accounting

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

Indexes:
Column(s) Type Sort Constraint Name
a_depreciation_workfile_id Primary key Asc a_depreciation_workfile_key
a_depreciation_workfile_uu Must be unique Asc a_depreciation_workfile_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.