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