Table of Contents

Table Gen_Document_Line_Amounts

Entity

Entity: General.Documents.DocumentLineAmounts

Specifies user-defined input percentages by lines for the document amounts. Entity: Gen_Document_Line_Amounts

Owner Tables Hierarchy

Summary

Name Type Description
Document_Amount_Type_Id uniqueidentifier The type of amount for which the distribution pattern is specified.
Document_Id uniqueidentifier
Document_Line_Amount_Id uniqueidentifier PK
Document_Line_Id uniqueidentifier The line for which the distribution pattern is specified.
Line_Percent decimal(14, 6) The percent of the additional amount which should be distributed over the current line.
Product_Id uniqueidentifier The product for which the distribution is specified. It is also the product, specified in the document line, but is duplicated here for integrity purposes.
Referenced_Document_Id uniqueidentifier When not null, specifies that this distribution is specified for a referenced document (not the document for which the amount is calculated).
Row_Version timestamp

Columns

Document_Amount_Type_Id

The type of amount for which the distribution pattern is specified.

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_Document_Amount_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

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 2147483647
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

Document_Line_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 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_Line_Amount_Id - Supported Filters

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

Document_Line_Id

The line for which the distribution pattern is specified.

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

Document_Line_Id - Supported Filters

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

Line_Percent

The percent of the additional amount which should be distributed over the current line.

Property Value
Attributes IsPercent
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 decimal(14, 6)
UI Memo Editor no
UI Width Medium
User Login no
Visible yes

Product_Id

The product for which the distribution is specified. It is also the product, specified in the document line, but is duplicated here for integrity 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 -1
Order 2147483647
Ownership Reference no
Pasword no
Picture no
Primary Key no
Readonly no
Referenced Table Gen_Products
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

Product_Id - Supported Filters

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

Referenced_Document_Id

When not null, specifies that this distribution is specified for a referenced document (not the document for which the amount 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 Gen_Documents
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

Referenced_Document_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 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
Suggest improvement to this page