Table Gen_Products

Entity

Products are the different items in the enterprise, which can be purchased, stored, sold and depreciated. Entity: Gen_Products

Summary

Name	Type	Description
ABC_Class	`nvarchar(2)` Allowed: `A` , `B` , `C`	Product importance classification, where A are the most important and C - the least important products. Usually used as user filtering condition when previewing results of the procurement planning process.
Active	`bit`	1 if the product is active, 0 - not to list in combo boxes for choosing in new documents
Allow_Variable_Measurement_Ratios	`bit`	Allow variable (dynamic) measurement ratios for each transaction. If specified, each store transaction could specify different measurement ratio between the used measurement unit and the base measurement unit.
Base_Measurement_Category_Id	`uniqueidentifier`	The base measurement category for quantities of this product.
Cargo_Type_Id	`uniqueidentifier`	Specifies what type of cargo this product is. Required when generating transportation requisitions. NULL means unspecified.
Catalog_Description_Html	`nvarchar(max)`	Full HTML description of the product. Usually used for display on product catalogs, web pages, etc.
Costing_Currency_Id	`uniqueidentifier`	Specifies the currency to use for cost calculations for the product. When NULL, the base currency for the enterprise company should be used
Costing_Method	`nvarchar(4)` Allowed: `AVG`, `EXP`, `BLD`	Specifies the costing method for the product. NULL means to use the Enterprise Company default. Currently supported methods are: EXP - Explicitly specify lot; AVG - Average cost
Creation_Time	`datetime` Readonly
Creation_User	`nvarchar(64)` Readonly
Description	`nvarchar(max)` `ML`	The description of the product
Enterprise_Company_Id	`uniqueidentifier`	When not NULL, specifies that the product is specific to a given enterprise company and may be used only in documents from this enterprise company.
Excise_Product_Type_Id	`uniqueidentifier`	Specifies the basic excise attributes of the product.
Expiry_Period_Days	`int`	Total default expiry period for the product (in days) from the date of production to the date of expiry
Flushing_Method	`nvarchar(1)` Allowed: `B`, `F`, `M`	Consumption method for work orders. M=Manual, using Consuption Journals, F=Forward (on release), B=Backward (on finish)
Guarantee_Period_Days	`int`	Default guarantee period length in days. 0 means no guarantee. Should be non-NULL for serviced products and NULL for the others
Id	`uniqueidentifier` `PK`	Unique id of the item
Intrastat_Commodity_Code_Id	`uniqueidentifier`	Code from The Combined Nomenclature used within the European Union countries. Used when reporting Intrastat and Excise.
Intrastat_Supplementary_Unit_Id	`uniqueidentifier`
Is_Featured	`bit`
Is_Serialized	`bit`	1 if the parts use/require serial numbers
Lots_Issue	`nvarchar(4)` Allowed: `FIFO`, `FEFO`, `LIFO`	Determines the method by which the lots are automatically issued. The method determines the sequence of the lots: in the order of receipt (FIFO), in the order inverse of receipt (LIFO) or in the order of expiration (FEFO).
Manufacturing_Policy	`nvarchar(3)`	Manufacturing policy controls the procurement planing system actions for this product. Allowed values are MTS=Make-To-Stock; MTO=Make-To-Order; ATO=Assemble-To-Order
Measurement_Unit_Id	`uniqueidentifier`	Default measurement unit, when creating new documents with this product.
Minimal_Sales_Price_Per_Lot	`decimal(18, 4)`	Minimal allowed price for sales of this product. The price is for one standard lot and in the costing currency of the product. The minimum is enforced upon planning and/or releasing a document. NULL means that there is no minimal sales price enforcement.
Minimal_Sales_Quantity_Base	`decimal(18, 3)`	Minimal base quantity of this product that has to be specified in any sale.
Origin_Country_Id	`uniqueidentifier`	Country from which the product originates (in which the product is produced/cultivated ...). Primarily used for Intrastat reporting.
Part_Number	`nvarchar(32)`	Unique part number of the product
Planning_Demand_Time_Fence_Days	`int`	Period in the future, in which changes to the MPS are not accepted due to the high cost of changing. Demand for the period is calculated based entirely on the customer orders. Abbr. - DTF (NULL = Default of 30 days)
Planning_Horizon_Days	`int`	Number of days in the future for which to plan the demand and supply (NULL = Default of 180 days)
Planning_Time_Fence_Days	`int`	Period in the future inside of which changes to the MPS are carefully evaluated to prevent costly schedule disruption. Demand for the period between DTF and PTF is calculated as the bigger of customer orders and sales forecast. Abbr. - PTF. (NULL = Default of 90 days)
Product_Group_Id	`uniqueidentifier`	The product group, under which the product is categorized.
Product_Name	`nvarchar(254)` `ML`	Name of the item
Product_Type_Id	`uniqueidentifier`	The type of the product. This also defines whether the product is stocked. NULL=no specific product type and the product is stocked
Purchase_Measurement_Unit_Id	`uniqueidentifier`	Default measurement unit to use, when creating new purchase documents with this product.
Row_Version	`timestamp`
Scrap_Rate	`decimal(7, 6)`	Default scrap rate for the recipe, when this product is used as ingredient
Short_Name	`nvarchar(128)` `ML`	Short name of the product. Used for space-constrained devices, like mobile phones, fiscal printers, etc.
Show_In_Catalog	`bit`	Specifies whether to show the product in catalogs, referring to the product group of the product. 0=Do not show; 1=Show.
Standard_Cost_Per_Lot	`decimal(18, 4)`	Standard cost for one standard lot of the product in the currency, specified by Costing_Currency_Id
Standard_Lot_Size_Base	`decimal(18, 3)`	The size of a standard lot, expressed in the base measurement unit of the product. Used for Standard_Cost and Standard_Price
Standard_Price_Per_Lot	`decimal(18, 4)`	Standard sales price (used if no special price is defined) for one standard lot of the product in the currency, specified by Costing_Currency_Id
Supply_Schema_Id	`uniqueidentifier`	The supply schema to use for the distribution of the product among warehouses
Update_Time	`datetime` Readonly
Update_User	`nvarchar(64)` Readonly
Use_Lots	`nvarchar(1)` Allowed: `A`, `N`, `R`	Specifies whether the use of lots for this product in store documents is required or is unallowed or is allowed while not required.
Valuation_Group_Id	`uniqueidentifier`	Valuation group of the product. Used in reconciliations when compensating pluses and minuses. Equal plus and minus amounts within a valuation group are allowed to be compensated with each other for zero net fiscal effect.

Columns

ABC_Class

Product importance classification, where A are the most important and C - the least important products. Usually used as user filtering condition when previewing results of the procurement planning process.

Property	Value
Allowed Values	`A` , `B` , `C`
Auto Complete	no
Data Filter	no
Default Value	B
Enter Stop	no
Ignore for Insert Order	no
Is Entity Name	no
Max Length	2
Order	23
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)
UI Memo Editor	no
UI Width	50
User Login	no
Visible	yes

ABC_Class - Supported Filters

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

Active

1 if the product is active, 0 - not to list in combo boxes for choosing in new documents

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

Active - Supported Filters

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

Allow_Variable_Measurement_Ratios

Allow variable (dynamic) measurement ratios for each transaction. If specified, each store transaction could specify different measurement ratio between the used measurement unit and the base measurement unit.

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

Allow_Variable_Measurement_Ratios - Supported Filters

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

Base_Measurement_Category_Id

The base measurement category for quantities of this 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	6
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
UI Memo Editor	no
UI Width	50
User Login	no
Visible	yes

Base_Measurement_Category_Id - Supported Filters

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

Cargo_Type_Id

Specifies what type of cargo this product is. Required when generating transportation requisitions. NULL means unspecified.

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
Referenced Table	Log_Cargo_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	yes

Cargo_Type_Id - Supported Filters

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

Catalog_Description_Html

Full HTML description of the product. Usually used for display on product catalogs, web pages, etc.

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

Costing_Currency_Id

Specifies the currency to use for cost calculations for the product. When NULL, the base currency for the enterprise company should be 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	27
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	100
User Login	no
Visible	yes

Costing_Currency_Id - Supported Filters

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

Costing_Method

Specifies the costing method for the product. NULL means to use the Enterprise Company default. Currently supported methods are: EXP - Explicitly specify lot; AVG - Average cost

Property	Value
Allowed Values	`AVG`, `EXP`, `BLD`
Auto Complete	no
Data Filter	no
Default Value	None
Enter Stop	no
Ignore for Insert Order	no
Is Entity Name	no
Max Length	4
Order	26
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(4) (Allows NULL)
UI Memo Editor	no
UI Width	Medium
User Login	no
Visible	no

Creation_Time

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

Creation_Time - Supported Filters

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

Creation_User

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

Creation_User - Supported Filters

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

Description

The description 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	2147483647
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	nvarchar(max) (MultiLanguage) (Allows NULL)
UI Memo Editor	no
UI Width	100
User Login	no
Visible	yes

Enterprise_Company_Id

When not NULL, specifies that the product is specific to a given enterprise company and may be used only in documents from this enterprise company.

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
Referenced Table	Gen_Enterprise_Companies
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

Enterprise_Company_Id - Supported Filters

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

Excise_Product_Type_Id

Specifies the basic excise attributes 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	48
Ownership Reference	no
Pasword	no
Picture	no
Primary Key	no
Readonly	no
Referenced Table	Exc_Excise_Product_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	yes

Excise_Product_Type_Id - Supported Filters

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

Expiry_Period_Days

Total default expiry period for the product (in days) from the date of production to the date of expiry

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

Flushing_Method

Consumption method for work orders. M=Manual, using Consuption Journals, F=Forward (on release), B=Backward (on finish)

Property	Value
Allowed Values	`B`, `F`, `M`
Auto Complete	no
Data Filter	no
Default Value	M
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
RTF	no
Sortable	no
Summary Type	None
Supports EQUALS_IN	no
Type	nvarchar(1)
UI Memo Editor	no
UI Width	50
User Login	no
Visible	yes

Guarantee_Period_Days

Default guarantee period length in days. 0 means no guarantee. Should be non-NULL for serviced products and NULL for the others

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

Id

Unique id of the item

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

Id - Supported Filters

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

Intrastat_Commodity_Code_Id

Code from The Combined Nomenclature used within the European Union countries. Used when reporting Intrastat and Excise.

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

Intrastat_Commodity_Code_Id - Supported Filters

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

Intrastat_Supplementary_Unit_Id

Property	Value
Auto Complete	no
Base Table.Column	Gen_Measurement_Units.Id
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
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	yes

Intrastat_Supplementary_Unit_Id - Supported Filters

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

Is_Featured

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	10
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_Featured - Supported Filters

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

Is_Serialized

1 if the parts use/require serial numbers

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

Is_Serialized - Supported Filters

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

Lots_Issue

Determines the method by which the lots are automatically issued. The method determines the sequence of the lots: in the order of receipt (FIFO), in the order inverse of receipt (LIFO) or in the order of expiration (FEFO).

Property	Value
Allowed Values	`FIFO`, `FEFO`, `LIFO`
Auto Complete	no
Data Filter	no
Default Value	None
Enter Stop	yes
Ignore for Insert Order	no
Is Entity Name	no
Max Length	4
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(4) (Allows NULL)
UI Memo Editor	no
UI Width	Medium
User Login	no
Visible	yes

Manufacturing_Policy

Manufacturing policy controls the procurement planing system actions for this product. Allowed values are MTS=Make-To-Stock; MTO=Make-To-Order; ATO=Assemble-To-Order

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

Measurement_Unit_Id

Default measurement unit, when creating new documents with this 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	7
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	50
User Login	no
Visible	yes

Measurement_Unit_Id - Supported Filters

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

Minimal_Sales_Price_Per_Lot

Minimal allowed price for sales of this product. The price is for one standard lot and in the costing currency of the product. The minimum is enforced upon planning and/or releasing a document. NULL means that there is no minimal sales price enforcement.

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

Minimal_Sales_Quantity_Base

Minimal base quantity of this product that has to be specified in any sale.

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

Origin_Country_Id

Country from which the product originates (in which the product is produced/cultivated ...). Primarily 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	36
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	yes

Origin_Country_Id - Supported Filters

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

Part_Number

Unique part number of the product

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	32
Order	1
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(32)
UI Memo Editor	no
UI Width	Medium
User Login	no
Visible	yes

Part_Number - Supported Filters

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

Planning_Demand_Time_Fence_Days

Period in the future, in which changes to the MPS are not accepted due to the high cost of changing. Demand for the period is calculated based entirely on the customer orders. Abbr. - DTF (NULL = Default of 30 days)

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

Planning_Horizon_Days

Number of days in the future for which to plan the demand and supply (NULL = Default of 180 days)

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

Planning_Time_Fence_Days

Period in the future inside of which changes to the MPS are carefully evaluated to prevent costly schedule disruption. Demand for the period between DTF and PTF is calculated as the bigger of customer orders and sales forecast. Abbr. - PTF. (NULL = Default of 90 days)

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

Product_Group_Id

The product group, under which the product is categorized.

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

Product_Group_Id - Supported Filters

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

Product_Name

Name of the item

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

Product_Name - Supported Filters

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

Product_Type_Id

The type of the product. This also defines whether the product is stocked. NULL=no specific product type and the product is stocked

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

Product_Type_Id - Supported Filters

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

Purchase_Measurement_Unit_Id

Default measurement unit to use, when creating new purchase documents with this 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	34
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	100
User Login	no
Visible	yes

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

Scrap_Rate

Default scrap rate for the recipe, when this product is used as ingredient

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	25
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	50
User Login	no
Visible	yes

Short_Name

Short name of the product. Used for space-constrained devices, like mobile phones, fiscal printers, etc.

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

Short_Name - Supported Filters

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

Show_In_Catalog

Specifies whether to show the product in catalogs, referring to the product group of the product. 0=Do not show; 1=Show.

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

Show_In_Catalog - Supported Filters

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

Standard_Cost_Per_Lot

Standard cost for one standard lot of the product in the currency, specified by Costing_Currency_Id

Property	Value
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	no
RTF	no
Sortable	no
Summary Type	None
Supports EQUALS_IN	no
Type	decimal(18, 4)
UI Memo Editor	no
UI Width	50
User Login	no
Visible	yes

Standard_Lot_Size_Base

The size of a standard lot, expressed in the base measurement unit of the product. Used for Standard_Cost and Standard_Price

Property	Value
Auto Complete	no
Data Filter	no
Default Value	1
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
RTF	no
Sortable	no
Summary Type	None
Supports EQUALS_IN	no
Type	decimal(18, 3)
UI Memo Editor	no
UI Width	100
User Login	no
Visible	yes

Standard_Price_Per_Lot

Standard sales price (used if no special price is defined) for one standard lot of the product in the currency, specified by Costing_Currency_Id

Property	Value
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	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	decimal(18, 4)
UI Memo Editor	no
UI Width	50
User Login	no
Visible	yes

Supply_Schema_Id

The supply schema to use for the distribution of the product among warehouses

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

Supply_Schema_Id - Supported Filters

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

Update_Time

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

Update_Time - Supported Filters

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

Update_User

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

Update_User - Supported Filters

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

Use_Lots

Specifies whether the use of lots for this product in store documents is required or is unallowed or is allowed while not required.

Property	Value
Allowed Values	`A`, `N`, `R`
Auto Complete	no
Data Filter	no
Default Value	A
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	no
RTF	no
Sortable	no
Summary Type	None
Supports EQUALS_IN	no
Type	nvarchar(1)
UI Memo Editor	no
UI Width	Medium
User Login	no
Visible	yes

Valuation_Group_Id

Valuation group of the product. Used in reconciliations when compensating pluses and minuses. Equal plus and minus amounts within a valuation group are allowed to be compensated with each other for zero net fiscal effect.

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
Referenced Table	Inv_Product_Valuation_Groups
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

Valuation_Group_Id - Supported Filters

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

Table of Contents