Table Ast_Depreciation_Methods
Entity
Entity: Finance.Assets.DepreciationMethods
Depreciation methods. Contains both system-defined and user-defined methods. Entity: Ast_Depreciation_Methods
Summary
Name |
Type |
Description |
Depreciation_Function |
nvarchar(3) Allowed: FAC , STL , SYD , TAB |
Basic mathematical depreciation function used to calculate asset depreciation. STL=Straight Line, SYD=Sum of Years Digits, FAC=Depreciation change by factor, TAB=User defined with table |
Depreciation_Method_Id |
uniqueidentifier PK |
|
Depreciation_Method_Name |
nvarchar(254) ML |
Multilanguage string |
Factor |
decimal(5, 3) |
Factor used in factor depreciation function. Factor < 1 means declining depreciation; >1 - increasing. The depreciation is multiplied for each period by the factor |
Is_System |
bit Readonly |
Is_System is True for those depreciation methods that are managed by the system via update procedures and cannot be edited by the user. |
Months_In_A_Period |
int |
Number of equal valued months calculated with single application of the function |
Period_Determination_Method |
nvarchar(2) Allowed: NM , CM , BD |
Determines when the depreciation starts and when it ends. NM=Next_Month, CM=Current_Month, BD=By_Days |
Row_Version |
timestamp |
|
Start_From_Next_Month |
bit |
When true, denotes that the depreciation starts from the month, following the month of deployment. When false, the depreciation starts from the same month. |
Columns
Depreciation_Function
Basic mathematical depreciation function used to calculate asset depreciation. STL=Straight Line, SYD=Sum of Years Digits, FAC=Depreciation change by factor, TAB=User defined with table
Property |
Value |
Allowed Values |
FAC , STL , SYD , TAB |
Auto Complete |
no |
Data Filter |
no |
Default Value |
STL |
Enter Stop |
yes |
Ignore for Insert Order |
no |
Is Entity Name |
no |
Max Length |
3 |
Order |
3 |
Ownership Reference |
no |
Pasword |
no |
Picture |
no |
Primary Key |
no |
Readonly |
no |
RTF |
no |
Sortable |
no |
Summary Type |
None |
Supports EQUALS_IN |
no |
Type |
nvarchar(3) |
UI Memo Editor |
no |
UI Width |
Medium |
User Login |
no |
Visible |
yes |
Depreciation_Method_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 |
1 |
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_Method_Id - Supported Filters
Filter Type |
Default |
Include Nulls |
Hidden by Default |
Equals |
NULL |
no |
no |
Depreciation_Method_Name
Multilanguage string
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 |
254 |
Order |
2 |
Ownership Reference |
no |
Pasword |
no |
Picture |
no |
Primary Key |
no |
Readonly |
no |
RTF |
no |
Sortable |
no |
Summary Type |
None |
Supports EQUALS_IN |
no |
Type |
nvarchar(254) (MultiLanguage) |
UI Memo Editor |
no |
UI Width |
Long |
User Login |
no |
Visible |
yes |
Depreciation_Method_Name - Supported Filters
Filter Type |
Default |
Include Nulls |
Hidden by Default |
Like |
None |
no |
no |
Factor
Factor used in factor depreciation function. Factor < 1 means declining depreciation; >1 - increasing. The depreciation is multiplied for each period by the factor
Property |
Value |
Auto Complete |
no |
Data Filter |
no |
Default Value |
1 |
Enter Stop |
yes |
Format |
N3 |
Ignore for Insert Order |
no |
Is Entity Name |
no |
Max Length |
-1 |
Order |
4 |
Ownership Reference |
no |
Pasword |
no |
Picture |
no |
Primary Key |
no |
Readonly |
no |
RTF |
no |
Sortable |
no |
Summary Type |
None |
Supports EQUALS_IN |
no |
Type |
decimal(5, 3) |
UI Memo Editor |
no |
UI Width |
Short |
User Login |
no |
Visible |
yes |
Is_System
Is_System is True for those depreciation methods that are managed by the system via update procedures and cannot be edited by the user.
Property |
Value |
Auto Complete |
no |
Data Filter |
no |
Default Value |
False |
Enter Stop |
no |
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 |
yes |
RTF |
no |
Sortable |
no |
Summary Type |
None |
Supports EQUALS_IN |
no |
Type |
bit |
UI Memo Editor |
no |
UI Width |
Short |
User Login |
no |
Visible |
yes |
Is_System - Supported Filters
Filter Type |
Default |
Include Nulls |
Hidden by Default |
Equals |
NULL |
no |
no |
Months_In_A_Period
Number of equal valued months calculated with single application of the function
Property |
Value |
Auto Complete |
no |
Data Filter |
no |
Default Value |
12 |
Enter Stop |
yes |
Ignore for Insert Order |
no |
Is Entity Name |
no |
Max Length |
-1 |
Order |
5 |
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 |
UI Memo Editor |
no |
UI Width |
Short |
User Login |
no |
Visible |
yes |
Period_Determination_Method
Determines when the depreciation starts and when it ends. NM=Next_Month, CM=Current_Month, BD=By_Days
Property |
Value |
Allowed Values |
NM , CM , BD |
Auto Complete |
no |
Data Filter |
no |
Default Value |
None |
Enter Stop |
yes |
Ignore for Insert Order |
no |
Is Entity Name |
no |
Max Length |
2 |
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 |
nvarchar(2) |
UI Memo Editor |
no |
UI Width |
Medium |
User Login |
no |
Visible |
yes |
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 |
Start_From_Next_Month
When true, denotes that the depreciation starts from the month, following the month of deployment. When false, the depreciation starts from the same month.
Property |
Value |
Auto Complete |
no |
Data Filter |
no |
Default Value |
True |
Enter Stop |
yes |
Ignore for Insert Order |
no |
Is Entity Name |
no |
Max Length |
-1 |
Order |
6 |
Ownership Reference |
no |
Pasword |
no |
Picture |
no |
Primary Key |
no |
Readonly |
no |
RTF |
no |
Sortable |
no |
Summary Type |
None |
Supports EQUALS_IN |
no |
Type |
bit |
UI Memo Editor |
no |
UI Width |
Medium |
User Login |
no |
Visible |
no |