ERP/2.50/Developers Guide/Database Model/org.openbravo.model.financialmgmt.assetmgmt/A Asset Amortization

Contents 1 A_Asset_Amortization 1.1 Columns 1.1.1 Client 1.1.2 Organization 1.1.3 Asset 1.1.4 Amortization 1.1.5 Starting Date 1.1.6 Ending Date 1.1.7 Amortization Percentage 1.1.8 Amortization Amount

A_Asset_Amortization

• Name:FinancialMgmtAssetAmortization
• Classname:AssetAmortization

This table contains the following columns:

Name	Nullable	Data Type	Description
AD_Client_ID	N	VARCHAR2(32)	Client for this installation.
AD_Org_ID	N	VARCHAR2(32)	Organizational entity within client
A_Asset_ID	N	VARCHAR2(32)	An item which is owned and exchangeable for cash.
A_Amortization_ID	N	VARCHAR2(32)	The depreciation or reduction of a product value over time.
StartDate	Y	DATE	A parameter stating when a specified request will begin.
EndDate	Y	DATE	A parameter stating when a specified request will end.
Amortization_Percentage	Y	NUMBER	Amortization Percentage
Amortizationamt	Y	NUMBER	Amortization Amount

Columns

Client

• Physical column name: AD_Client_ID
• Property Name: client
• Reference: TableDir
• Default value: @AD_CLIENT_ID@

Foreign key column to AD_Client table, (column: AD_Client_ID)

top

Organization

• Physical column name: AD_Org_ID
• Property Name: organization
• Reference: TableDir
• Default value: @AD_ORG_ID@

Foreign key column to AD_Org table, (column: AD_Org_ID)

top

Asset

• Physical column name: A_Asset_ID
• Property Name: asset
• Reference: TableDir
• This column is a child for a buisiness object (is Parent)

Foreign key column to A_Asset table, (column: A_Asset_ID)

top

Amortization

• Physical column name: A_Amortization_ID
• Property Name: amortization
• Reference: TableDir
• This column is part of the table's identifier

Foreign key column to A_Amortization table, (column: A_Amortization_ID)

top

Starting Date

A parameter stating when a specified request will begin.

• Physical column name: StartDate
• Property Name: startingDate
• Reference: Date

top

Ending Date

The End Date indicates the last date in this range.

• Physical column name: EndDate
• Property Name: endingDate
• Reference: Date

top

Amortization Percentage

Amortization Percentage

• Physical column name: Amortization_Percentage
• Property Name: amortizationPercentage
• Reference: Number

top

Amortization Amount

Amortization Amount

• Physical column name: Amortizationamt
• Property Name: amortizationAmount
• Reference: Amount

top