Table of Contents

Table Gen_Document_Amounts

Entity

Entity: General.Documents.DocumentAmounts

Contains a specific instance of an additional amount for a specific document. Entity: Gen_Document_Amounts

Owner Tables Hierarchy

Summary

Name Type Description
Base_Amount decimal(14, 2) Readonly The calculated base amount (in documents currency) from the last document amount recalculation. The base amount is the base, over which the additional amounts are calculated. Null if the amount is not distributed yet.
Document_Amount_Id uniqueidentifier PK
Document_Amount_Type_Id uniqueidentifier The type of the amount.
Document_Id uniqueidentifier
Input_Amount decimal(14, 2) When not null, specifies directly the amount of the additional amount.
Input_Amount_Currency_Id uniqueidentifier When specifying the amount directly in Input Amount, this contains the currency of the amount. Used and required when Input Amount is not null.
Input_Percent decimal(7, 6) When not null, specifies that the amount for this document will be calculated as percent of the base amounts (which are defined in the amount type).
Input_Unit_Amount decimal(14, 5) Input unit amount for the calculation of the current amount.
Input_Unit_Id uniqueidentifier Measurement unit of the input unit amount.
Row_Version timestamp
Total_Distributed_Amount decimal(14, 2) Readonly The total amount (in documents currency) which was distributed to the documents lines. Null if the amount is not distributed yet.
User_Can_Change_Input bit 1 if the user, entering the document is allowed to change the default input percent

Columns

Base_Amount

The calculated base amount (in documents currency) from the last document amount recalculation. The base amount is the base, over which the additional amounts are calculated. Null if the amount is not distributed yet.

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 5
Ownership Reference no
Pasword no
Picture no
Primary Key no
Readonly yes
RTF no
Sortable no
Summary Type None
Supports EQUALS_IN no
Type decimal(14, 2) (Allows NULL)
UI Memo Editor no
UI Width Medium
User Login no
Visible yes

Document_Amount_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 0
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

Document_Amount_Id - Supported Filters

Filter Type Default Include Nulls Hidden by Default
Equals NULL no no

Document_Amount_Type_Id

The type of the amount.

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 2
Ownership Reference no
Pasword no
Picture no
Primary Key no
Readonly no
Referenced Table Gen_Document_Amount_Types
RTF no
Sortable no
Summary Type None
Supports EQUALS_IN yes
Type uniqueidentifier
UI Memo Editor no
UI Width Long
User Login no
Visible yes

Document_Amount_Type_Id - Supported Filters

Filter Type Default Include Nulls Hidden by Default
Equals NULL no no

Document_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 1
Ownership Reference yes
Pasword no
Picture no
Primary Key no
Readonly no
Referenced Table Gen_Documents
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

Document_Id - Supported Filters

Filter Type Default Include Nulls Hidden by Default
Equals NULL no no

Input_Amount

When not null, specifies directly the amount of the additional amount.

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 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) (Allows NULL)
UI Memo Editor no
UI Width Short
User Login no
Visible yes

Input_Amount - Supported Filters

Filter Type Default Include Nulls Hidden by Default
GreaterThanOrLessThan None no no

Input_Amount_Currency_Id

When specifying the amount directly in Input Amount, this contains the currency of the amount. Used and required when Input Amount is not null.

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 7
Ownership Reference no
Pasword no
Picture no
Primary Key no
Readonly no
Referenced Table Gen_Currencies
RTF no
Sortable no
Summary Type None
Supports EQUALS_IN yes
Type uniqueidentifier (Allows NULL)
UI Memo Editor no
UI Width Medium
User Login no
Visible yes

Input_Amount_Currency_Id - Supported Filters

Filter Type Default Include Nulls Hidden by Default
Equals NULL yes yes

Input_Percent

When not null, specifies that the amount for this document will be calculated as percent of the base amounts (which are defined in the amount type).

Property Value
Attributes IsPercent
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
RTF no
Sortable no
Summary Type None
Supports EQUALS_IN no
Type decimal(7, 6) (Allows NULL)
UI Memo Editor no
UI Width Short
User Login no
Visible yes

Input_Percent - Supported Filters

Filter Type Default Include Nulls Hidden by Default
GreaterThanOrLessThan None no no

Input_Unit_Amount

Input unit amount for the calculation of the current amount.

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 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, 5) (Allows NULL)
UI Memo Editor no
UI Width Medium
User Login no
Visible no

Input_Unit_Amount - Supported Filters

Filter Type Default Include Nulls Hidden by Default
Equals NULL yes no
GreaterThanOrLessThan None no no

Input_Unit_Id

Measurement unit of the input unit amount.

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 10
Ownership Reference no
Pasword no
Picture no
Primary Key no
Readonly no
Referenced Table Gen_Measurement_Units
RTF no
Sortable no
Summary Type None
Supports EQUALS_IN yes
Type uniqueidentifier (Allows NULL)
UI Memo Editor no
UI Width Medium
User Login no
Visible no

Input_Unit_Id - Supported Filters

Filter Type Default Include Nulls Hidden by Default
Equals NULL yes 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 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 timestamp
UI Memo Editor no
UI Width Medium
User Login no
Visible no

Total_Distributed_Amount

The total amount (in documents currency) which was distributed to the documents lines. Null if the amount is not distributed yet.

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 6
Ownership Reference no
Pasword no
Picture no
Primary Key no
Readonly yes
RTF no
Sortable no
Summary Type None
Supports EQUALS_IN no
Type decimal(14, 2) (Allows NULL)
UI Memo Editor no
UI Width Medium
User Login no
Visible yes

User_Can_Change_Input

1 if the user, entering the document is allowed to change the default input percent

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 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 bit
UI Memo Editor no
UI Width Medium
User Login no
Visible no
Suggest improvement to this page