Table Ast_Asset_Transaction_Lines
Entity
Entity: Finance.Assets.AssetTransactionLines
Asset value transaction lines. Each line changes the values of one asset in one valuation model. Entity: Ast_Asset_Transaction_Lines
Owner Tables Hierarchy
Summary
| Name |
Type |
Description |
| Asset_Id |
uniqueidentifier |
Asset for which changes in values have occurred. |
| Asset_Transaction_Id |
uniqueidentifier |
|
| Asset_Transaction_Line_Id |
uniqueidentifier PK |
Unique identification of the asset transaction line. |
| Depreciation_Value |
decimal(14, 2) |
Change in the depreciation value of the asset (in the currency of the asset). |
| Depreciation_Value_Base |
decimal(14, 2) |
Change in the depreciation value of the asset (in the currency of the enterprise company). |
| Negative_Reserve_Value |
decimal(14, 2) |
Change in the value of the negative reserve after asset valuations (in the currency of the asset). |
| Negative_Reserve_Value_Base |
decimal(14, 2) |
Change in the value of the negative reserve after asset valuations (in the currency of the enterprise company). |
| Operation_Type |
nvarchar(3) Allowed: ADJ, DEP, PUR, SLS, REV |
Type of the current asset operation: PUR = Purchase, SLS = Sale, DEP = Depreciation, ADJ = Adjustment, REV = Reevaluation |
| Positive_Reserve_Value |
decimal(14, 2) |
Change in the value of the positive reserve after asset valuations (in the currency of the asset). |
| Positive_Reserve_Value_Base |
decimal(14, 2) |
Change in the value of the positive reserve after asset valuations (in the currency of the enterprise company). |
| Purchase_Value |
decimal(14, 2) |
Change in the purchase value of the asset (in the currency of the asset). |
| Purchase_Value_Base |
decimal(14, 2) |
Change in the purchase value of the asset (in the currency of the enterprise company). |
| Row_Version |
timestamp |
|
| Salvage_Value |
decimal(14, 2) |
Change in the salvage value of the asset (in the currency of the asset). |
| Salvage_Value_Base |
decimal(14, 2) |
Change in the salvage value of the asset (in the currency of the enterprise company). |
| Valuation_Model_Id |
uniqueidentifier |
Valuation model in which the changes of the asset values have occurred (Taxation model or Accounting model or other). |
Columns
Asset_Id
Asset for which changes in values have occurred.
| 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 |
1 |
| Ownership Reference |
no |
| Pasword |
no |
| Picture |
no |
| Primary Key |
no |
| Readonly |
no |
| Referenced Table |
Ast_Assets |
| 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 |
Asset_Id - Supported Filters
| Filter Type |
Default |
Include Nulls |
Hidden by Default |
| Equals |
NULL |
no |
no |
Asset_Transaction_Id
| 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_Transactions |
| 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_Transaction_Id - Supported Filters
| Filter Type |
Default |
Include Nulls |
Hidden by Default |
| Equals |
NULL |
no |
yes |
Asset_Transaction_Line_Id
Unique identification of the asset transaction line.
| 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 |
Asset_Transaction_Line_Id - Supported Filters
| Filter Type |
Default |
Include Nulls |
Hidden by Default |
| Equals |
NULL |
no |
yes |
Depreciation_Value
Change in the depreciation value of the asset (in the currency of the asset).
| Property |
Value |
| Auto Complete |
no |
| Data Filter |
no |
| Default Value |
0 |
| Enter Stop |
yes |
| Format |
N2 |
| 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 |
decimal(14, 2) |
| UI Memo Editor |
no |
| UI Width |
Medium |
| User Login |
no |
| Visible |
yes |
Depreciation_Value_Base
Change in the depreciation value of the asset (in the currency of the enterprise company).
| Property |
Value |
| Auto Complete |
no |
| Data Filter |
no |
| Default Value |
0 |
| Enter Stop |
yes |
| Format |
N2 |
| Ignore for Insert Order |
no |
| Is Entity Name |
no |
| Max Length |
-1 |
| Order |
7 |
| 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(14, 2) |
| UI Memo Editor |
no |
| UI Width |
Medium |
| User Login |
no |
| Visible |
yes |
Negative_Reserve_Value
Change in the value of the negative reserve after asset valuations (in the currency of the asset).
| Property |
Value |
| Auto Complete |
no |
| Data Filter |
no |
| Default Value |
0 |
| Enter Stop |
yes |
| Format |
N2 |
| Ignore for Insert Order |
no |
| Is Entity Name |
no |
| Max Length |
-1 |
| Order |
12 |
| 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(14, 2) |
| UI Memo Editor |
no |
| UI Width |
Medium |
| User Login |
no |
| Visible |
yes |
Negative_Reserve_Value_Base
Change in the value of the negative reserve after asset valuations (in the currency of the enterprise company).
| Property |
Value |
| Auto Complete |
no |
| Data Filter |
no |
| Default Value |
0 |
| Enter Stop |
yes |
| Format |
N2 |
| Ignore for Insert Order |
no |
| Is Entity Name |
no |
| Max Length |
-1 |
| Order |
13 |
| 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(14, 2) |
| UI Memo Editor |
no |
| UI Width |
Medium |
| User Login |
no |
| Visible |
yes |
Operation_Type
Type of the current asset operation: PUR = Purchase, SLS = Sale, DEP = Depreciation, ADJ = Adjustment, REV = Reevaluation
| Property |
Value |
| Allowed Values |
ADJ, DEP, PUR, SLS, REV |
| Auto Complete |
no |
| Data Filter |
no |
| Default Value |
ADJ |
| Enter Stop |
no |
| Ignore for Insert Order |
no |
| Is Entity Name |
no |
| Max Length |
3 |
| Order |
2147483647 |
| Ownership Reference |
no |
| Pasword |
no |
| Picture |
no |
| Primary Key |
no |
| Readonly |
no |
| RTF |
no |
| Sortable |
no |
| Summary Type |
None |
| Supports EQUALS_IN |
yes |
| Type |
nvarchar(3) |
| UI Memo Editor |
no |
| UI Width |
Medium |
| User Login |
no |
| Visible |
yes |
Operation_Type - Supported Filters
| Filter Type |
Default |
Include Nulls |
Hidden by Default |
| Equals |
NULL |
no |
no |
Positive_Reserve_Value
Change in the value of the positive reserve after asset valuations (in the currency of the asset).
| Property |
Value |
| Auto Complete |
no |
| Data Filter |
no |
| Default Value |
0 |
| Enter Stop |
yes |
| Format |
N2 |
| Ignore for Insert Order |
no |
| Is Entity Name |
no |
| Max Length |
-1 |
| Order |
10 |
| 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(14, 2) |
| UI Memo Editor |
no |
| UI Width |
Medium |
| User Login |
no |
| Visible |
yes |
Positive_Reserve_Value_Base
Change in the value of the positive reserve after asset valuations (in the currency of the enterprise company).
| Property |
Value |
| Auto Complete |
no |
| Data Filter |
no |
| Default Value |
0 |
| Enter Stop |
yes |
| Format |
N2 |
| Ignore for Insert Order |
no |
| Is Entity Name |
no |
| Max Length |
-1 |
| Order |
11 |
| 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(14, 2) |
| UI Memo Editor |
no |
| UI Width |
Medium |
| User Login |
no |
| Visible |
yes |
Purchase_Value
Change in the purchase value of the asset (in the currency of the asset).
| Property |
Value |
| Auto Complete |
no |
| Data Filter |
no |
| Default Value |
0 |
| Enter Stop |
yes |
| Format |
N2 |
| 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(14, 2) |
| UI Memo Editor |
no |
| UI Width |
Medium |
| User Login |
no |
| Visible |
yes |
Purchase_Value_Base
Change in the purchase value of the asset (in the currency of the enterprise company).
| Property |
Value |
| Auto Complete |
no |
| Data Filter |
no |
| Default Value |
0 |
| Enter Stop |
yes |
| Format |
N2 |
| 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 |
decimal(14, 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 |
Salvage_Value
Change in the salvage value of the asset (in the currency of the asset).
| Property |
Value |
| Auto Complete |
no |
| Data Filter |
no |
| Default Value |
0 |
| Enter Stop |
yes |
| Format |
N2 |
| Ignore for Insert Order |
no |
| Is Entity Name |
no |
| Max Length |
-1 |
| Order |
8 |
| 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(14, 2) |
| UI Memo Editor |
no |
| UI Width |
Medium |
| User Login |
no |
| Visible |
yes |
Salvage_Value_Base
Change in the salvage value of the asset (in the currency of the enterprise company).
| Property |
Value |
| Auto Complete |
no |
| Data Filter |
no |
| Default Value |
0 |
| Enter Stop |
yes |
| Format |
N2 |
| Ignore for Insert Order |
no |
| Is Entity Name |
no |
| Max Length |
-1 |
| Order |
9 |
| 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(14, 2) |
| UI Memo Editor |
no |
| UI Width |
Medium |
| User Login |
no |
| Visible |
yes |
Valuation_Model_Id
Valuation model in which the changes of the asset values have occurred (Taxation model or Accounting model or other).
| 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 |
3 |
| 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 |