Table Gen_Document_Amount_Types

Entity

Entity: Systems.Documents.DocumentAmountTypes

Represents the different types of additional amounts which are calculated for the documents. Entity: Gen_Document_Amount_Types

Summary

Name	Type	Description
Access_Key_Id	`uniqueidentifier`
Add_To_Customer	`bit`	1 means that the amount will be charged to the primary customer of the document
Add_To_Line	`bit`	1 means that the resulting amount will be added to the amount of each respective line
Allowed_Directions	`int` Allowed: `-1`, `0`, `1`	Specifies condition for the sign of the allowed values for input percent or amount that can be set in the documents.
Amount_Input_Allowed	`bit`	1 when the user is allowed to input fixed amount for distribution
Amount_Type_Code	`nvarchar(16)`	A code that can be used to uniquely identify the additional amount. Can also be used for sorting purposes
Amount_Type_Name	`nvarchar(128)` `ML`	The name of the amount type.
Base_On_Lines	`bit`	1 means that the percentages will be applied over lines plus dependant amounts; 0 means only dependant amounts
Default_Percent	`decimal(7, 6)`	Default percent for amounts for which percent input is allowed; NULL otherwise
Description	`nvarchar(254)`
Distribute_By	`nvarchar(20)` Allowed: `AMOUNT`, `MEASUREMENT`, `PRODUCT DEFINITION`, `DEAL TYPE`, `LINE DISCOUNT`, `BONUS PROGRAM`, `PROMOTIONAL PACKAGE`	Determines how the amount will be distributed among the document lines.
Distribute_By_Measurement_Category_Id	`uniqueidentifier`	Specifies the measurement category to be used for distribution, when the Distribute_By = 'MEASUREMENT'
Document_Amount_Type_Id	`uniqueidentifier` `PK`
Is_Active	`bit`	1 when the amount type is active for new records; 0 - otherwise
Percent_Input_Allowed	`bit`	1 when the user is allowed to input percent of total for distribution
Round_Scale	`int`	The amounts should be rounded with the specified number of digits after the decimal point. NULL means to use the currency default
Row_Version	`timestamp`
Unit_Amount_Input_Allowed	`bit`	Specifies whether the user is allowed to input fixed unit amount for the calculation of the amount.

Columns

Access_Key_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	no
Pasword	no
Picture	no
Primary Key	no
Readonly	no
Referenced Table	Sec_Access_Keys
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

Access_Key_Id - Supported Filters

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

Add_To_Customer

1 means that the amount will be charged to the primary customer of the document

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	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	bit
UI Memo Editor	no
UI Width	100
User Login	no
Visible	yes

Add_To_Line

1 means that the resulting amount will be added to the amount of each respective line

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	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	bit
UI Memo Editor	no
UI Width	100
User Login	no
Visible	yes

Allowed_Directions

Specifies condition for the sign of the allowed values for input percent or amount that can be set in the documents.

Property	Value
Allowed Values	`-1`, `0`, `1`
Auto Complete	no
Data Filter	no
Default Value	0
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 (Allows NULL)
UI Memo Editor	no
UI Width	Medium
User Login	no
Visible	yes

Amount_Input_Allowed

1 when the user is allowed to input fixed amount for distribution

Property	Value
Auto Complete	no
Data Filter	no
Default Value	False
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	bit
UI Memo Editor	no
UI Width	100
User Login	no
Visible	yes

Amount_Input_Allowed - Supported Filters

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

Amount_Type_Code

A code that can be used to uniquely identify the additional amount. Can also be used for sorting purposes

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	16
Order	2147483647
Ownership Reference	no
Pasword	no
Picture	no
Primary Key	no
Readonly	no
RTF	no
Sortable	yes
Summary Type	None
Supports EQUALS_IN	yes
Type	nvarchar(16)
UI Memo Editor	no
UI Width	100
User Login	no
Visible	yes

Amount_Type_Code - Supported Filters

Filter Type	Default	Include Nulls	Hidden by Default
Equals	`NULL`	no	no
Like	None	no	no

Amount_Type_Name

The name of the amount 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	128
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(128) (MultiLanguage)
UI Memo Editor	no
UI Width	Long
User Login	no
Visible	yes

Amount_Type_Name - Supported Filters

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

Base_On_Lines

1 means that the percentages will be applied over lines plus dependant amounts; 0 means only dependant amounts

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	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	bit
UI Memo Editor	no
UI Width	100
User Login	no
Visible	yes

Default_Percent

Default percent for amounts for which percent input is allowed; NULL otherwise

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

Description

Property	Value
Attributes	IsLongString
Auto Complete	no
Data Filter	no
Default Value	None
Enter Stop	no
Ignore for Insert Order	no
Is Entity Name	no
Max Length	254
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(254) (Allows NULL)
UI Memo Editor	no
UI Width	100
User Login	no
Visible	yes

Distribute_By

Determines how the amount will be distributed among the document lines.

Property	Value
Allowed Values	`AMOUNT`, `MEASUREMENT`, `PRODUCT DEFINITION`, `DEAL TYPE`, `LINE DISCOUNT`, `BONUS PROGRAM`, `PROMOTIONAL PACKAGE`
Auto Complete	no
Data Filter	no
Default Value	AMOUNT
Enter Stop	yes
Ignore for Insert Order	no
Is Entity Name	no
Max Length	20
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(20)
UI Memo Editor	no
UI Width	100
User Login	no
Visible	yes

Distribute_By - Supported Filters

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

Distribute_By_Measurement_Category_Id

Specifies the measurement category to be used for distribution, when the Distribute_By = 'MEASUREMENT'

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	Gen_Measurement_Categories
RTF	no
Sortable	no
Summary Type	None
Supports EQUALS_IN	yes
Type	uniqueidentifier (Allows NULL)
UI Memo Editor	no
UI Width	100
User Login	no
Visible	yes

Distribute_By_Measurement_Category_Id - Supported Filters

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

Document_Amount_Type_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

Document_Amount_Type_Id - Supported Filters

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

Is_Active

1 when the amount type is active for new records; 0 - otherwise

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	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	bit
UI Memo Editor	no
UI Width	Medium
User Login	no
Visible	yes

Is_Active - Supported Filters

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

Percent_Input_Allowed

1 when the user is allowed to input percent of total for distribution

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	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	bit
UI Memo Editor	no
UI Width	100
User Login	no
Visible	yes

Percent_Input_Allowed - Supported Filters

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

Round_Scale

The amounts should be rounded with the specified number of digits after the decimal point. NULL means to use the currency default

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 (Allows NULL)
UI Memo Editor	no
UI Width	100
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

Unit_Amount_Input_Allowed

Specifies whether the user is allowed to input fixed unit amount for the calculation of the amount.

Property	Value
Auto Complete	no
Data Filter	no
Default Value	False
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	bit
UI Memo Editor	no
UI Width	Medium
User Login	no
Visible	yes

Unit_Amount_Input_Allowed - Supported Filters

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

Table of Contents