Table idempiere9.adempiere.a_asset_change
A_Asset_Change_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_change_id numeric 10
a_asset_change_amt.a_asset_change_id aassetchange_aassetchangeamt R
A_Asset_Change_ID
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_asset_id numeric 10
a_asset.a_asset_id aasset_aassetchange R
Asset used internally or by customers
changetype varchar 3 ChangeType
changedate timestamp 29,6  √  null ChangeDate
changeamt numeric 0  √  null ChangeAmt
uselifeyears numeric 10  √  null Years of the usable life of the asset
uselifemonths numeric 10  √  null Months of the usable life of the asset
lifeuseunits numeric 10  √  null Units of use until the asset is not usable anymore
assetdepreciationdate timestamp 29,6  √  null Date of last depreciation
a_asset_retirement_id numeric 10  √  null
a_asset_retirement.a_asset_retirement_id aaretirement_aachange R
Internally used asset is not longer used.
a_asset_addition_id numeric 10  √  null
a_asset_addition.a_asset_addition_id aaaddition_aachange R
Asset Addition
serno varchar 40  √  null Product Serial Number
lot varchar 40  √  null Lot number (alphanumeric)
versionno varchar 40  √  null Version Number
a_accumdepreciation_acct numeric 10  √  null
c_validcombination.c_validcombination_id aaccumdepreciation_aassetchang R
Accumulated Depreciation Account
a_asset_createdate timestamp 29,6  √  null Create Date
a_asset_spread_type varchar 10  √  null Spread Type
a_depreciation_calc_type varchar 10  √  null Calculation Type
a_depreciation_manual_period varchar 2  √  null A_Depreciation_Manual_Period
a_qty_original numeric 0  √  null A_QTY_Original
a_qty_current numeric 0  √  null Current Qty
a_period_start numeric 10  √  null A_Period_Start
a_period_end numeric 10  √  null A_Period_End
a_parent_asset_id numeric 10  √  null
a_asset.a_asset_id aparentasset_aassetchange R
Parent Asset
a_disposal_revenue varchar 22  √  null Disposal Revenue
a_disposal_loss varchar 22  √  null Loss on Disposal
a_depreciation_variable_perc numeric 0  √  null Variable Percent
a_depreciation_table_header_id numeric 10  √  null
a_depreciation_table_header.a_depreciation_table_header_id adepreciationtableheader_aass2 R
A_Depreciation_Table_Header_ID
c_acctschema_id numeric 10  √  null
c_acctschema.c_acctschema_id cacctschema_aassetchange R
Rules for accounting
assetvalueamt numeric 0 (0)::numeric Book Value of the asset
assetservicedate timestamp 29,6  √  null Date when Asset was put into service
assetmarketvalueamt numeric 0  √  null Market value of the asset
assetdisposaldate timestamp 29,6  √  null Date when the asset is/was disposed
assetbookvalueamt numeric 0  √  null AssetBookValueAmt
assetaccumdepreciationamt numeric 0  √  null AssetAccumDepreciationAmt
ad_user_id numeric 10  √  null
ad_user.ad_user_id aduser_aassetchange R
User within the system - Internal or Business Partner Contact
isinposession bpchar 1  √  null The asset is in the possession of the organization
isfullydepreciated bpchar 1  √  null The asset is fully depreciated
isdisposed bpchar 1  √  null The asset is disposed
isdepreciated bpchar 1  √  null The asset will be depreciated
depreciationtype varchar 10  √  null DepreciationType
dateacct timestamp 29,6  √  null Accounting Date
useunits numeric 10  √  null Currently used units of the assets
textdetails varchar 60 Details
postingtype varchar 10  √  'A'::character varying The type of posted amount for the transaction
isowned bpchar 1  √  null The asset is owned by the organization
conventiontype varchar 10  √  null ConventionType
c_validcombination_id numeric 10  √  null
c_validcombination.c_validcombination_id cvalidcombinati_aassetchange R
Valid Account Combination
c_location_id numeric 10  √  null
c_location.c_location_id clocation_aassetchange R
Location or Address
c_bpartner_location_id numeric 10  √  null
c_bpartner_location.c_bpartner_location_id cbpartnerlocation_aassetchange R
Identifies the (ship to) address for this Business Partner
c_bpartner_id numeric 10  √  null
c_bpartner.c_bpartner_id cbpartner_aassetchange R
Identifies a Business Partner
a_split_percent numeric 0  √  (1)::numeric Split Percent
a_salvage_value numeric 0  √  null Asset Salvage Value
a_reval_depexp_offset numeric 10  √  null Revaluation Expense Offs
a_reval_cost_offset_prior numeric 10  √  null Revaluation Cost Offset for Prior Year
a_reval_cost_offset numeric 10  √  null Revaluation Cost Offset for Current Year
a_reval_cal_method varchar 3  √  null A_Reval_Cal_Method
a_reval_accumdep_offset_prior numeric 10  √  null Revaluation Accumulated Depreciation Offset for Prior Year
a_reval_accumdep_offset_cur numeric 10  √  null Revaluation Accumulated Depreciation Offset for Current Year
a_depreciation_manual_amount numeric 0  √  null A_Depreciation_Manual_Amount
a_depreciation_acct numeric 10  √  null
c_validcombination.c_validcombination_id adepreciation_aassetchange R
Depreciation Account
a_asset_revaldate timestamp 29,6  √  null Revaluation Date
a_asset_acct numeric 10  √  null
c_validcombination.c_validcombination_id aassetvc_aassetchange R
Asset Acct
a_asset_acct_id numeric 10  √  null A_Asset_Acct_ID
a_asset_change_uu varchar 36  √  NULL::character varying A_Asset_Change_UU
a_disposal_revenue_acct numeric 10  √  NULL::numeric
c_validcombination.c_validcombination_id adisposalrevenue_aassetchange R
Disposal Revenue Acct
a_disposal_loss_acct numeric 10  √  NULL::numeric
c_validcombination.c_validcombination_id adisposalloss_aassetchange R
Disposal Loss Acct
a_reval_depexp_offset_acct numeric 10  √  NULL::numeric Reval Depexp Offset 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

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

Indexes:
Column(s) Type Sort Constraint Name
a_asset_change_id Primary key Asc a_asset_change_pkey
a_asset_change_uu Must be unique Asc a_asset_change_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.