Table Crm_Sales_Order_Lines

Entity

Sales Orders detail records. Entity: Crm_Sales_Order_Lines

Owner Tables Hierarchy

Summary

Name	Type	Description
Bonus_Program_Id	`uniqueidentifier`	The bonus program, based on which the line was automatically added. NULL when the line was not added for bonus program.
Delivery_Terms_Code	`nvarchar(3)` Allowed: `EXW`, `FCA`, `FAS`, `FOB`, `CFR`, `CIF`, `CPT`, `CIP`, `DAP`, `DAT`, `DDP`, `DPU`	Mode of delivery, like CIF, FOB, etc. Used also in Intrastat reporting
Guarantee_Period_Days	`int`	Guarantee period in days for the offered product. NULL for non-serviced products
Historical_Data_Json	`nvarchar(max)`	Used only for lines, which are returns. It is a JSON-formatted string, containing data from the original sale.
Historical_Unit_Cost	`decimal(14, 5)`	Used for returning of goods that are sold before the exploitation of the system
Intrastat_Apply_Date	`datetime`	Specifies in which period for Intrastat declaration must be included the current operation. Used only when the invoice is issued in different period than the one, that the operation must be included. If not set the document date is used.
Intrastat_Transaction_Nature_Code	`nvarchar(2)` Allowed: `11`, `12`, `13`, `14`, `19`, `21`, `22`, `23`, `29`, `60`, `70`, `80`, `91`, `99`, `30`, `41`, `42`, `51`, `52`	Transaction nature; used for Intrastat reporting
Intrastat_Transport_Country_Id	`uniqueidentifier`	Country of origin of the transport company; used for Intrastat reporting
Intrastat_Transport_Mode_Code	`nvarchar(1)` Allowed: `1`, `2`, `3`, `4`, `5`, `7`, `8`, `9`	Transport mode; used for Intrastat reporting
Level1_Discount_Id	`uniqueidentifier`	Indicates the level 1 discount.
Level1_Discount_Percent	`decimal(7, 6)` Readonly	The percent of the level 1 discount.
Level2_Discount_Id	`uniqueidentifier`	Indicates the level 2 discount.
Level2_Discount_Percent	`decimal(7, 6)` Readonly	The percent of the level 2 discount.
Level3_Discount_Id	`uniqueidentifier`	Indicates the level 3 discount.
Level3_Discount_Percent	`decimal(7, 6)` Readonly	The percent of the level 3 discount.
Line_Amount	`decimal(14, 2)`	The total amount for the line. Equals to Quantity * Unit_Price, less the discounts
Line_Custom_Discount_Percent	`decimal(7, 6)`	User-defined discount for the line
Line_Deal_Type_Id	`uniqueidentifier`	Deal type to be passed to the invoice line. If deal type in entered then the invoice creates VAT entry for this deal type.
Line_Discount_Id	`uniqueidentifier` Readonly	The line discount type used to form the Line_Standard_Discount_Percent
Line_End_Customer_Party_Id	`uniqueidentifier`	The end customer is the customer of the dealer. It is stored for information purposes only. The end customer may not have customer definition, just party.
Line_From_Date	`date`	When selling a service valid only for a period, denotes the beginning of the period. NULL means that it is unknown or N/A.
Line_No	`int`	Consecutive number of the line within the sales order
Line_Standard_Discount_Percent	`decimal(7, 6)` Readonly	Standard discount percent for the line. It is calculated by accumulating in cascade the line discounts at all levels.
Line_Store_Id	`uniqueidentifier`	The store which should be used to issue the goods for the line. NULL means to use the store from the header
Line_To_Date	`date`	When selling a service valid only for a period, denotes the end of the period. NULL means that it is unknown or N/A.
Lot_Id	`uniqueidentifier`	Specifies the lot from which the goods should be issued. NULL means that the lot will be specified at a later stage (store order, etc.)
Notes	`nvarchar(max)`
Parent_Document_Id	`uniqueidentifier`	The document, which the current line executes. NULL when the current line does not execute another line.
Parent_Line_No	`int`	The number of the line within the parent document, which the current line executes. NULL when the current line does not execute parent line.
Persist_Lot	`bit`	If checked specifies that the lot in the line cannot be changed in the sub-documents created by the current document.
Product_Code_Id	`uniqueidentifier`	Used to set the Product_Id thru the coding systems
Product_Description	`nvarchar(254)` `ML`	The name of the sold product at the time the sale was made
Product_Id	`uniqueidentifier`	The product sold
Product_Price_Id	`uniqueidentifier`	Not NULL when the price has been selected from the list of valid standard prices
Product_Variant_Id	`uniqueidentifier`	If specified determines which product variant of the current product in this line is used.
Promotional_Package_Id	`uniqueidentifier` Readonly	The promotional package, based on which the line was added. NULL when the line was not added as part of a promotional package
Quantity	`decimal(12, 3)`	The quantity sold
Quantity_Base	`decimal(12, 3)`	The equivalent of Quantity in the base measurement category of the product
Quantity_Unit_Id	`uniqueidentifier`	The measurement unit of Quantity
Requested_Quantity	`decimal(12, 3)`	Quantity requested by customer
Required_Delivery_Date	`date`	The required (contracted) delivery date for the line
Return_For_Invoice_Line_Id	`uniqueidentifier`	When specified, indicates that the current line is a return for products, invoiced with the specified invoice line.
Return_For_Sales_Order_Line_Id	`uniqueidentifier`	When specified indicates that the goods sold in Return_For_Sales_Order_Line_Id are returned with the current line
Row_Version	`timestamp`
Sales_Order_Id	`uniqueidentifier`
Sales_Order_Line_Id	`uniqueidentifier` `PK`
Serial_Number_Id	`uniqueidentifier`	Which serial number to receive/issue. NULL means that serial number is unknown or not applicable
Standard_Quantity_Base	`decimal(12, 3)` Readonly	The theoretical quantity in base measurement unit according to the current measurement dimensions for the product. Used to measure the execution.
Standard_Unit_Price	`decimal(14, 5)` Readonly	Standard unit price of the product during the creation of the sales order line
Store_Bin_Id	`uniqueidentifier`	The bin from which the goods should be withdrawn. NULL means that the bin will be specified at a later stage (store order, etc.)
Unit_Price	`decimal(14, 5)`	Unit price of the product in the currency of the sales order and in the unit of measure, as specified by QuantityUnitId

Columns

Bonus_Program_Id

The bonus program, based on which the line was automatically added. NULL when the line was not added for bonus program.

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	16
Ownership Reference	no
Pasword	no
Picture	no
Primary Key	no
Readonly	no
Referenced Table	Crm_Bonus_Programs
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	no

Bonus_Program_Id - Supported Filters

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

Delivery_Terms_Code

Mode of delivery, like CIF, FOB, etc. Used also in Intrastat reporting

Property	Value
Allowed Values	`EXW`, `FCA`, `FAS`, `FOB`, `CFR`, `CIF`, `CPT`, `CIP`, `DAP`, `DAT`, `DDP`, `DPU`
Auto Complete	no
Data Filter	no
Default Value	None
Enter Stop	yes
Ignore for Insert Order	no
Is Entity Name	no
Max Length	3
Order	31
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(3) (Allows NULL)
UI Memo Editor	no
UI Width	Medium
User Login	no
Visible	no

Guarantee_Period_Days

Guarantee period in days for the offered product. NULL for non-serviced products

Property	Value
Auto Complete	no
Data Filter	no
Default Value	None
Enter Stop	no
Ignore for Insert Order	no
Is Entity Name	no
Max Length	-1
Order	15
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	no

Historical_Data_Json

Used only for lines, which are returns. It is a JSON-formatted string, containing data from the original sale.

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

Historical_Unit_Cost

Used for returning of goods that are sold before the exploitation of the system

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

Historical_Unit_Cost - Supported Filters

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

Intrastat_Apply_Date

Specifies in which period for Intrastat declaration must be included the current operation. Used only when the invoice is issued in different period than the one, that the operation must be included. If not set the document date is used.

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

Intrastat_Apply_Date - Supported Filters

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

Intrastat_Transaction_Nature_Code

Transaction nature; used for Intrastat reporting

Property	Value
Allowed Values	`11`, `12`, `13`, `14`, `19`, `21`, `22`, `23`, `29`, `60`, `70`, `80`, `91`, `99`, `30`, `41`, `42`, `51`, `52`
Auto Complete	no
Data Filter	no
Default Value	None
Enter Stop	yes
Ignore for Insert Order	no
Is Entity Name	no
Max Length	2
Order	32
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(2) (Allows NULL)
UI Memo Editor	no
UI Width	Medium
User Login	no
Visible	no

Intrastat_Transport_Country_Id

Country of origin of the transport company; used for Intrastat reporting

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	30
Ownership Reference	no
Pasword	no
Picture	no
Primary Key	no
Readonly	no
Referenced Table	Gen_Countries
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

Intrastat_Transport_Country_Id - Supported Filters

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

Intrastat_Transport_Mode_Code

Transport mode; used for Intrastat reporting

Property	Value
Allowed Values	`1`, `2`, `3`, `4`, `5`, `7`, `8`, `9`
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	29
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(1) (Allows NULL)
UI Memo Editor	no
UI Width	Medium
User Login	no
Visible	no

Level1_Discount_Id

Indicates the level 1 discount.

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	45
Ownership Reference	no
Pasword	no
Picture	no
Primary Key	no
Readonly	no
Referenced Table	Crm_Line_Discounts
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

Level1_Discount_Id - Supported Filters

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

Level1_Discount_Percent

The percent of the level 1 discount.

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

Level2_Discount_Id

Indicates the level 2 discount.

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	47
Ownership Reference	no
Pasword	no
Picture	no
Primary Key	no
Readonly	no
Referenced Table	Crm_Line_Discounts
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

Level2_Discount_Id - Supported Filters

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

Level2_Discount_Percent

The percent of the level 2 discount.

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

Level3_Discount_Id

Indicates the level 3 discount.

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	49
Ownership Reference	no
Pasword	no
Picture	no
Primary Key	no
Readonly	no
Referenced Table	Crm_Line_Discounts
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

Level3_Discount_Id - Supported Filters

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

Level3_Discount_Percent

The percent of the level 3 discount.

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

Line_Amount

The total amount for the line. Equals to Quantity * Unit_Price, less the discounts

Property	Value
Auto Complete	no
Data Filter	no
Default Value	0
Enter Stop	no
Format	N2
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	no
RTF	no
Sortable	no
Summary Type	Sum
Supports EQUALS_IN	no
Type	decimal(14, 2)
UI Memo Editor	no
UI Width	80
User Login	no
Visible	yes

Line_Custom_Discount_Percent

User-defined discount for the line

Property	Value
Attributes	IsPercent
Auto Complete	no
Data Filter	no
Default Value	0
Enter Stop	no
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	no
RTF	no
Sortable	no
Summary Type	None
Supports EQUALS_IN	no
Type	decimal(7, 6)
UI Memo Editor	no
UI Width	Medium
User Login	no
Visible	yes

Line_Custom_Discount_Percent - Supported Filters

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

Line_Deal_Type_Id

Deal type to be passed to the invoice line. If deal type in entered then the invoice creates VAT entry for this deal type.

Property	Value
Auto Complete	no
Data Filter	no
Default Value	None
Enter Stop	no
Ignore for Insert Order	no
Is Entity Name	no
Max Length	-1
Order	24
Ownership Reference	no
Pasword	no
Picture	no
Primary Key	no
Readonly	no
Referenced Table	VAT_Deal_Types
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

Line_Deal_Type_Id - Supported Filters

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

Line_Discount_Id

The line discount type used to form the Line_Standard_Discount_Percent

Property	Value
Auto Complete	no
Data Filter	no
Default Value	None
Enter Stop	no
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	yes
Referenced Table	Crm_Line_Discounts
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

Line_Discount_Id - Supported Filters

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

Line_End_Customer_Party_Id

The end customer is the customer of the dealer. It is stored for information purposes only. The end customer may not have customer definition, just party.

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	41
Ownership Reference	no
Pasword	no
Picture	no
Primary Key	no
Readonly	no
Referenced Table	Gen_Parties
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

Line_End_Customer_Party_Id - Supported Filters

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

Line_From_Date

When selling a service valid only for a period, denotes the beginning of the period. NULL means that it is unknown or N/A.

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

Line_From_Date - Supported Filters

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

Line_No

Consecutive number of the line within the sales order

Property	Value
Auto Complete	no
Autoincrement	10
Data Filter	no
Default Value	None
Enter Stop	no
Ignore for Insert Order	no
Is Entity Name	no
Max Length	-1
Order	0
Ownership Reference	no
Pasword	no
Picture	no
Primary Key	no
Readonly	no
RTF	no
Sortable	yes
Summary Type	None
Supports EQUALS_IN	no
Type	int
UI Memo Editor	no
UI Width	25
User Login	no
Visible	yes

Line_No - Supported Filters

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

Line_Standard_Discount_Percent

Standard discount percent for the line. It is calculated by accumulating in cascade the line discounts at all levels.

Property	Value
Attributes	IsPercent
Auto Complete	no
Data Filter	no
Default Value	0
Enter Stop	no
Ignore for Insert Order	no
Is Entity Name	no
Max Length	-1
Order	12
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(7, 6)
UI Memo Editor	no
UI Width	Medium
User Login	no
Visible	no

Line_Store_Id

The store which should be used to issue the goods for the line. NULL means to use the store from the header

Property	Value
Auto Complete	no
Data Filter	no
Default Value	None
Enter Stop	no
Ignore for Insert Order	no
Is Entity Name	no
Max Length	-1
Order	21
Ownership Reference	no
Pasword	no
Picture	no
Primary Key	no
Readonly	no
Referenced Table	Inv_Stores
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

Line_Store_Id - Supported Filters

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

Line_To_Date

When selling a service valid only for a period, denotes the end of the period. NULL means that it is unknown or N/A.

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

Line_To_Date - Supported Filters

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

Lot_Id

Specifies the lot from which the goods should be issued. NULL means that the lot will be specified at a later stage (store order, etc.)

Property	Value
Auto Complete	no
Data Filter	no
Default Value	None
Enter Stop	no
Ignore for Insert Order	no
Is Entity Name	no
Max Length	-1
Order	25
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	no

Lot_Id - Supported Filters

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

Notes

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

Parent_Document_Id

The document, which the current line executes. NULL when the current line does not execute another line.

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	36
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	no

Parent_Document_Id - Supported Filters

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

Parent_Line_No

The number of the line within the parent document, which the current line executes. NULL when the current line does not execute parent line.

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	35
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	no

Parent_Line_No - Supported Filters

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

Persist_Lot

If checked specifies that the lot in the line cannot be changed in the sub-documents created by the current document.

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

Persist_Lot - Supported Filters

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

Product_Code_Id

Used to set the Product_Id thru the coding systems

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	17
Ownership Reference	no
Pasword	no
Picture	no
Primary Key	no
Readonly	no
Referenced Table	Gen_Product_Codes
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	no

Product_Code_Id - Supported Filters

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

Product_Description

The name of the sold product at the time the sale was made

Property	Value
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	7
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) (MultiLanguage)
UI Memo Editor	no
UI Width	Long
User Login	no
Visible	no

Product_Description - Supported Filters

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

Product_Id

The product sold

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

Product_Price_Id

Not NULL when the price has been selected from the list of valid standard prices

Property	Value
Auto Complete	no
Data Filter	no
Default Value	None
Enter Stop	no
Ignore for Insert Order	no
Is Entity Name	no
Max Length	-1
Order	13
Ownership Reference	no
Pasword	no
Picture	no
Primary Key	no
Readonly	no
Referenced Table	Crm_Product_Prices
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

Product_Price_Id - Supported Filters

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

Product_Variant_Id

If specified determines which product variant of the current product in this line is used.

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	34
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	no

Product_Variant_Id - Supported Filters

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

Promotional_Package_Id

The promotional package, based on which the line was added. NULL when the line was not added as part of a promotional package

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	28
Ownership Reference	no
Pasword	no
Picture	no
Primary Key	no
Readonly	yes
Referenced Table	Crm_Promotional_Packages
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

Promotional_Package_Id - Supported Filters

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

Quantity

The quantity sold

Property	Value
Auto Complete	no
Data Filter	no
Default Value	1
Enter Stop	yes
Format	N3
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
RTF	no
Sortable	no
Summary Type	Sum
Supports EQUALS_IN	no
Type	decimal(12, 3)
UI Memo Editor	no
UI Width	80
User Login	no
Visible	yes

Quantity - Supported Filters

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

Quantity_Base

The equivalent of Quantity in the base measurement category 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	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(12, 3)
UI Memo Editor	no
UI Width	Medium
User Login	no
Visible	no

Quantity_Unit_Id

The measurement unit of Quantity

Property	Value
Auto Complete	no
Data Filter	no
Default Value	None
Enter Stop	no
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
Referenced Table	Gen_Measurement_Units
RTF	no
Sortable	no
Summary Type	None
Supports EQUALS_IN	yes
Type	uniqueidentifier
UI Memo Editor	no
UI Width	Short
User Login	no
Visible	yes

Quantity_Unit_Id - Supported Filters

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

Requested_Quantity

Quantity requested by customer

Property	Value
Auto Complete	no
Data Filter	no
Default Value	None
Enter Stop	yes
Format	N3
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	decimal(12, 3) (Allows NULL)
UI Memo Editor	no
UI Width	Medium
User Login	no
Visible	no

Required_Delivery_Date

The required (contracted) delivery date for the line

Property	Value
Auto Complete	no
Data Filter	no
Default Value	None
Enter Stop	no
Ignore for Insert Order	no
Is Entity Name	no
Max Length	-1
Order	14
Ownership Reference	no
Pasword	no
Picture	no
Primary Key	no
Readonly	no
RTF	no
Sortable	no
Summary Type	None
Supports EQUALS_IN	no
Type	date (Allows NULL)
UI Memo Editor	no
UI Width	100
User Login	no
Visible	no

Required_Delivery_Date - Supported Filters

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

Return_For_Invoice_Line_Id

When specified, indicates that the current line is a return for products, invoiced with the specified invoice line.

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	37
Ownership Reference	no
Pasword	no
Picture	no
Primary Key	no
Readonly	no
Referenced Table	Crm_Invoice_Lines
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

Return_For_Invoice_Line_Id - Supported Filters

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

Return_For_Sales_Order_Line_Id

When specified indicates that the goods sold in Return_For_Sales_Order_Line_Id are returned with the current line

Property	Value
Auto Complete	no
Data Filter	no
Default Value	None
Enter Stop	no
Ignore for Insert Order	no
Is Entity Name	no
Max Length	-1
Order	20
Ownership Reference	no
Pasword	no
Picture	no
Primary Key	no
Readonly	no
Referenced Table	Crm_Sales_Order_Lines
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	no

Return_For_Sales_Order_Line_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	38
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

Sales_Order_Id

Property	Value
Auto Complete	no
Data Filter	no
Default Value	None
Enter Stop	no
Ignore for Insert Order	no
Is Entity Name	no
Max Length	-1
Order	23
Ownership Reference	yes
Pasword	no
Picture	no
Primary Key	no
Readonly	no
Referenced Table	Crm_Sales_Orders
RTF	no
Sortable	no
Summary Type	None
Supports EQUALS_IN	yes
Type	uniqueidentifier
UI Memo Editor	no
UI Width	100
User Login	no
Visible	yes

Sales_Order_Id - Supported Filters

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

Sales_Order_Line_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	22
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

Sales_Order_Line_Id - Supported Filters

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

Serial_Number_Id

Which serial number to receive/issue. NULL means that serial number is unknown or not applicable

Property	Value
Auto Complete	no
Data Filter	no
Default Value	None
Enter Stop	no
Ignore for Insert Order	no
Is Entity Name	no
Max Length	-1
Order	26
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	no

Serial_Number_Id - Supported Filters

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

Standard_Quantity_Base

The theoretical quantity in base measurement unit 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	39
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(12, 3)
UI Memo Editor	no
UI Width	Medium
User Login	no
Visible	no

Standard_Unit_Price

Standard unit price of the product during the creation of the sales order line

Property	Value
Auto Complete	no
Data Filter	no
Default Value	None
Enter Stop	yes
Format	N2
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	yes
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

Store_Bin_Id

The bin from which the goods should be withdrawn. NULL means that the bin will be specified at a later stage (store order, etc.)

Property	Value
Auto Complete	no
Data Filter	no
Default Value	None
Enter Stop	no
Ignore for Insert Order	no
Is Entity Name	no
Max Length	-1
Order	27
Ownership Reference	no
Pasword	no
Picture	no
Primary Key	no
Readonly	no
Referenced Table	Inv_Store_Bins
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

Store_Bin_Id - Supported Filters

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

Unit_Price

Unit price of the product in the currency of the sales order and in the unit of measure, as specified by QuantityUnitId

Property	Value
Auto Complete	no
Data Filter	no
Default Value	0
Enter Stop	yes
Format	N2
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, 5)
UI Memo Editor	no
UI Width	80
User Login	no
Visible	yes

Table of Contents