Table Ast_Depreciation_Plan_Templates
Entity
Entity: Finance.Assets.DepreciationPlanTemplates
Specifies the default depreciation methods for the asset categories. Different methods can be specified for each valuation model. Entity: Ast_Depreciation_Plan_Templates
Owner Tables Hierarchy
Summary
Name |
Type |
Description |
Asset_Category_Id |
uniqueidentifier |
Asset category for which this template is defined |
Asset_Life |
int |
Asset life in months by default for the depreciation plans created by this template. NULL means that the asset is booked for this valuation model but is not depreciated in it (i.e. no depreciation plan is created). |
Depreciation_Method_Id |
uniqueidentifier |
Depreciation method by default for the depreciation plans created by this template |
Depreciation_Plan_Template_Id |
uniqueidentifier PK |
|
Row_Version |
timestamp |
|
Valuation_Model_Id |
uniqueidentifier |
Valuation model for which this template is defined |
Columns
Asset_Category_Id
Asset category for which this template is defined
Property |
Value |
Auto Complete |
no |
Data Filter |
no |
Default Value |
None |
Enter Stop |
no |
Ignore for Insert Order |
no |
Is Entity Name |
no |
Max Length |
-1 |
Order |
2147483647 |
Ownership Reference |
yes |
Pasword |
no |
Picture |
no |
Primary Key |
no |
Readonly |
no |
Referenced Table |
Ast_Asset_Categories |
RTF |
no |
Sortable |
no |
Summary Type |
None |
Supports EQUALS_IN |
yes |
Type |
uniqueidentifier |
UI Memo Editor |
no |
UI Width |
100 |
User Login |
no |
Visible |
yes |
Asset_Category_Id - Supported Filters
Filter Type |
Default |
Include Nulls |
Hidden by Default |
Equals |
NULL |
no |
no |
Asset_Life
Asset life in months by default for the depreciation plans created by this template. NULL means that the asset is booked for this valuation model but is not depreciated in it (i.e. no depreciation plan is created).
Property |
Value |
Auto Complete |
no |
Data Filter |
no |
Default Value |
None |
Enter Stop |
yes |
Ignore for Insert Order |
no |
Is Entity Name |
no |
Max Length |
-1 |
Order |
2147483647 |
Ownership Reference |
no |
Pasword |
no |
Picture |
no |
Primary Key |
no |
Readonly |
no |
RTF |
no |
Sortable |
no |
Summary Type |
None |
Supports EQUALS_IN |
no |
Type |
int (Allows NULL) |
UI Memo Editor |
no |
UI Width |
Short |
User Login |
no |
Visible |
yes |
Depreciation_Method_Id
Depreciation method by default for the depreciation plans created by this template
Property |
Value |
Auto Complete |
no |
Data Filter |
no |
Default Value |
None |
Enter Stop |
yes |
Ignore for Insert Order |
no |
Is Entity Name |
no |
Max Length |
-1 |
Order |
2147483647 |
Ownership Reference |
no |
Pasword |
no |
Picture |
no |
Primary Key |
no |
Readonly |
no |
Referenced Table |
Ast_Depreciation_Methods |
RTF |
no |
Sortable |
no |
Summary Type |
None |
Supports EQUALS_IN |
yes |
Type |
uniqueidentifier |
UI Memo Editor |
no |
UI Width |
Medium |
User Login |
no |
Visible |
yes |
Depreciation_Method_Id - Supported Filters
Filter Type |
Default |
Include Nulls |
Hidden by Default |
Equals |
NULL |
no |
no |
Depreciation_Plan_Template_Id
Property |
Value |
Auto Complete |
no |
Data Filter |
no |
Default Value |
NewGuid |
Enter Stop |
yes |
Ignore for Insert Order |
no |
Is Entity Name |
no |
Max Length |
-1 |
Order |
2147483647 |
Ownership Reference |
no |
Pasword |
no |
Picture |
no |
Primary Key |
yes (order: 1) |
Readonly |
no |
RTF |
no |
Sortable |
no |
Summary Type |
None |
Supports EQUALS_IN |
yes |
Type |
uniqueidentifier |
UI Memo Editor |
no |
UI Width |
Medium |
User Login |
no |
Visible |
no |
Depreciation_Plan_Template_Id - Supported Filters
Filter Type |
Default |
Include Nulls |
Hidden by Default |
Equals |
NULL |
no |
no |
Row_Version
Property |
Value |
Auto Complete |
no |
Data Filter |
no |
Default Value |
None |
Enter Stop |
yes |
Ignore for Insert Order |
no |
Is Entity Name |
no |
Max Length |
-1 |
Order |
2147483647 |
Ownership Reference |
no |
Pasword |
no |
Picture |
no |
Primary Key |
no |
Readonly |
no |
RTF |
no |
Sortable |
no |
Summary Type |
None |
Supports EQUALS_IN |
no |
Type |
timestamp |
UI Memo Editor |
no |
UI Width |
Medium |
User Login |
no |
Visible |
no |
Valuation_Model_Id
Valuation model for which this template is defined
Property |
Value |
Auto Complete |
no |
Data Filter |
no |
Default Value |
None |
Enter Stop |
yes |
Ignore for Insert Order |
no |
Is Entity Name |
no |
Max Length |
-1 |
Order |
2147483647 |
Ownership Reference |
no |
Pasword |
no |
Picture |
no |
Primary Key |
no |
Readonly |
no |
Referenced Table |
Ast_Valuation_Models |
RTF |
no |
Sortable |
no |
Summary Type |
None |
Supports EQUALS_IN |
yes |
Type |
uniqueidentifier |
UI Memo Editor |
no |
UI Width |
Medium |
User Login |
no |
Visible |
yes |
Valuation_Model_Id - Supported Filters
Filter Type |
Default |
Include Nulls |
Hidden by Default |
Equals |
NULL |
no |
no |