ERP/2.50/Developers Guide/Database Model/org.openbravo.model.financialmgmt.assetmgmt/A Asset Amortization
Contents |
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)
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)
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)
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)
Starting Date
A parameter stating when a specified request will begin.
- Physical column name: StartDate
- Property Name: startingDate
- Reference: Date
Ending Date
The End Date indicates the last date in this range.
- Physical column name: EndDate
- Property Name: endingDate
- Reference: Date
Amortization Percentage
Amortization Percentage
- Physical column name: Amortization_Percentage
- Property Name: amortizationPercentage
- Reference: Number
Amortization Amount
Amortization Amount
- Physical column name: Amortizationamt
- Property Name: amortizationAmount
- Reference: Amount