Table Cost_Distribution_Results
Entity
Entity: Finance.Cost.DistributionResults
Contains the results of a cost distribution calculation. Entity: Cost_Distribution_Results
Owner Tables Hierarchy
Summary
| Name |
Type |
Description |
| Cost_Distribution_Id |
uniqueidentifier |
|
| Cost_Distribution_Result_Id |
uniqueidentifier PK |
|
| Cost_Type_Id |
uniqueidentifier |
The cost type for which the current distribution is calculated. |
| Distributed_Amount_Base |
decimal(14, 5) |
The amount (in base currency) of the distributed cost. The amount is calculated for the combination of output and cost type. |
| Line_No |
int |
Consecutive line number (within the cost distribution document) of the result. |
| Output_Line_No |
int |
The line number (within the document) of the output over which the cost is distributed. |
Columns
Cost_Distribution_Id
| 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 |
yes |
| Pasword |
no |
| Picture |
no |
| Primary Key |
no |
| Readonly |
no |
| Referenced Table |
Cost_Distributions |
| 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 |
Cost_Distribution_Id - Supported Filters
| Filter Type |
Default |
Include Nulls |
Hidden by Default |
| Equals |
NULL |
no |
no |
Cost_Distribution_Result_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 |
Cost_Distribution_Result_Id - Supported Filters
| Filter Type |
Default |
Include Nulls |
Hidden by Default |
| Equals |
NULL |
no |
no |
Cost_Type_Id
The cost type for which the current distribution is calculated.
| 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 |
Cost_Types |
| 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 |
Cost_Type_Id - Supported Filters
| Filter Type |
Default |
Include Nulls |
Hidden by Default |
| Equals |
NULL |
no |
no |
Distributed_Amount_Base
The amount (in base currency) of the distributed cost. The amount is calculated for the combination of output and cost type.
| 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 |
decimal(14, 5) |
| UI Memo Editor |
no |
| UI Width |
Medium |
| User Login |
no |
| Visible |
yes |
Line_No
Consecutive line number (within the cost distribution document) of the result.
| Property |
Value |
| Auto Complete |
no |
| Autoincrement |
10 |
| 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 |
| UI Memo Editor |
no |
| UI Width |
Medium |
| User Login |
no |
| Visible |
yes |
Output_Line_No
The line number (within the document) of the output over which the cost is distributed.
| 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 |
| UI Memo Editor |
no |
| UI Width |
Medium |
| User Login |
no |
| Visible |
yes |