Table Gen_Document_Fulfillments

Entity

Entity: General.Documents.DocumentFulfillments

Fulfillment ledger for documents. Entity: Gen_Document_Fulfillments (Introduced in version 20.1)

Owner Tables Hierarchy

Gen_Documents

Summary

Name	Type	Description
Creation_Time_Utc	`datetime`	The exact time in UTC, when the fulfillment was created in the system.
Creation_User_Id	`uniqueidentifier`	The user, who created the record.
Destination_Entity_Name	`nvarchar(64)`	The name of the entity which fulfills the line. Used to differentiate between different fulfillment types. For example, sales order line can be fulfilled, for different purposes, by store order line and invoice order line.
Document_Fulfillment_Id	`uniqueidentifier` `PK`
Document_Id	`uniqueidentifier`	The Document, which is fulfilled.
Document_Line_Id	`uniqueidentifier`	The Id of the fulfilled line within the document. The attribute contains the Id and is not a reference, because it references different entities depending on document entity type and line type.
Fulfillment_Type	`nvarchar(1)` Allowed: `P`, `C`	Type of fulfillment: P=Planned; C=Completed.
Is_Final	`bit`	Specifies whether this fulfillment finalizes the line, regardless of any remaining quantities.
Line_No	`int`	Line number. Used for human-readability of the fulfillment. NULL if the lines do not support line numbers or the line number is unknown.
Line_Type	`nvarchar(1)`	Detail (line) type, for example materials, services, etc. L=Line. Other values are defined by the document entity type.
Lot_Id	`uniqueidentifier`	The lot, which was fulfilled. NULL when the fulfillment was not for a specific lot.
Parent_Fulfillment_Id	`uniqueidentifier`	The parent document fulfillment. Used when the information of the current fulfillment is inherited by another document fulfillment, usually created by another module.
Product_Id	`uniqueidentifier`	The product, which is fulfilled.
Product_Variant_Id	`uniqueidentifier`	The product variant, which was fulfilled. NULL when the fulfillment was not for a product variant.
Quantity_Base	`decimal(12, 3)`	Fulfilled quantity in the base measurement unit of the product.
Row_Version	`timestamp`
Serial_Number_Id	`uniqueidentifier`	The serial number, which was fulfilled. NULL when the fulfillment was not for a specific serial number.
Standard_Quantity	`decimal(12, 3)`	The theoretical quantity according to the current measurement dimensions for the product. Used to measure the execution.

Columns

Creation_Time_Utc

The exact time in UTC, when the fulfillment was created in the system.

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

Creation_Time_Utc - Supported Filters

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

Creation_User_Id

The user, who created the record.

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

Creation_User_Id - Supported Filters

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

Destination_Entity_Name

The name of the entity which fulfills the line. Used to differentiate between different fulfillment types. For example, sales order line can be fulfilled, for different purposes, by store order line and invoice order line.

Property	Value
Auto Complete	no
Data Filter	no
Enter Stop	yes
Ignore for Insert Order	no
Is Entity Name	no
Max Length	64
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(64)
UI Memo Editor	no
UI Width	Medium
User Login	no
Visible	yes

Destination_Entity_Name - Supported Filters

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

Document_Fulfillment_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_Fulfillment_Id - Supported Filters

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

Document_Id

The Document, which is fulfilled.

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_Id

The Id of the fulfilled line within the document. The attribute contains the Id and is not a reference, because it references different entities depending on document entity type and line 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	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

Fulfillment_Type

Type of fulfillment: P=Planned; C=Completed.

Property	Value
Allowed Values	`P`, `C`
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	nvarchar(1)
UI Memo Editor	no
UI Width	Medium
User Login	no
Visible	yes

Fulfillment_Type - Supported Filters

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

Is_Final

Specifies whether this fulfillment finalizes the line, regardless of any remaining quantities.

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

Is_Final - Supported Filters

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

Line_No

Line number. Used for human-readability of the fulfillment. NULL if the lines do not support line numbers or the line number is unknown.

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

Line_No - Supported Filters

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

Line_Type

Detail (line) type, for example materials, services, etc. L=Line. Other values are defined by the document entity type.

Property	Value
Auto Complete	no
Data Filter	no
Default Value	L
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	nvarchar(1)
UI Memo Editor	no
UI Width	Medium
User Login	no
Visible	yes

Line_Type - Supported Filters

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

Lot_Id

The lot, which was fulfilled. NULL when the fulfillment was not for a specific lot.

Property	Value
Auto Complete	no
Data Filter	no
Default Value	None
Depends On	Product_Id
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	Inv_Lots
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

Lot_Id - Supported Filters

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

Parent_Fulfillment_Id

The parent document fulfillment. Used when the information of the current fulfillment is inherited by another document fulfillment, usually created by another module.

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

Parent_Fulfillment_Id - Supported Filters

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

Product_Id

The product, which is fulfilled.

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 (Allows NULL)
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`	yes	no

Product_Variant_Id

The product variant, which was fulfilled. NULL when the fulfillment was not for a product variant.

Property	Value
Auto Complete	no
Data Filter	no
Default Value	None
Depends On	Product_Id
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_Product_Variants
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

Product_Variant_Id - Supported Filters

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

Quantity_Base

Fulfilled quantity in the base measurement unit of the product.

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	decimal(12, 3)
UI Memo Editor	no
UI Width	Medium
User Login	no
Visible	yes

Quantity_Base - Supported Filters

Filter Type	Default	Include Nulls	Hidden by Default
Equals	`NULL`	no	no
GreaterThanOrLessThan	None	no	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

Serial_Number_Id

The serial number, which was fulfilled. NULL when the fulfillment was not for a specific serial number.

Property	Value
Auto Complete	no
Data Filter	no
Default Value	None
Depends On	Product_Id
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	Inv_Serial_Numbers
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

Serial_Number_Id - Supported Filters

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

Standard_Quantity

The theoretical quantity according to the current measurement dimensions for the product. Used to measure the execution.

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(12, 3)
UI Memo Editor	no
UI Width	Medium
User Login	no
Visible	yes

Table of Contents