Table Gen_Product_Supply

Entity

Contains supply rules, which are used by the procurement planning system. Entity: Gen_Product_Supply

Summary

Name	Type	Description
Buyer_Name	`nvarchar(64)`	The code or name of the person, who is in charge for purchasing the product from external suppliers. It is used to group different products on purchase demand report. NULL when Procurement_Type is not buy
Default_Store_Bin_Id	`uniqueidentifier`	Default store bin for new deliveries using this supply scheme
Enterprise_Company_Id	`uniqueidentifier`
Fixed_Order_Quantity_Base	`decimal(18, 3)`	Fixed order quantity under the FOQ & EOQ replenishment system
From_Store_Id	`uniqueidentifier`	Used when the Procurement_Type is Transfer
Generate_Document_Type_Id	`uniqueidentifier`	Specifies the type of the document which should be generated by the procurement planning system, when generating supply based on this rule.
Is_Active	`bit`	1 if this product supply is active
Is_Default	`bit`	Specifies whether this is the default supply rule. The planning system works using only the default supply rules. The other rules are for reference and user information.
Manufacturing_Policy	`nvarchar(3)` Allowed: `ATO`, `MTO`, `MTS`, `ETO`	MTS=Make-To-Stock; MTO=Make-To-Order; ATO=Assemble-To-Order;ETO=Engineer-To-Order
Order_Lot_Size_Quantity_Base	`decimal(18, 3)`	The quantity of the product, normally ordered from the plant or supplier. The quantity is expressed in the base measurement unit
Order_Lot_Sizing_Method	`nvarchar(3)` Allowed: `EOQ`, `FOQ`, `LFL`, `LFP`, `ROP`, `ROT`	LFL=Lot for Lot; FOQ=Fixed order quantity; EOQ=Eqonomic Order Quantity; ROP=ReOrder Point; ROT=ReOrder point with Time planning; LFP = Lot For Period;
Order_Maximum	`decimal(18, 3)`	Order maximum when buying or making. NULL means no maximum
Order_Minimum	`decimal(18, 3)`	Minimum order quantity both for buying and making
Order_Multiple	`bit`	1 if the order qty should be multiple of lot size when buying or making
Order_Period_Planning_Days	`int`	For how many days in the future should be planned - for fixed period replenishment system. NULL - not yet specified
Order_Period_Start_Date	`datetime`	Start date of the first period under fixed period replenishment system. NULL - not yet specified
Order_Point_Quantity_Base	`decimal(18, 3)`	Order point quantity under the OP replenishment system
Order_Policy	`nvarchar(3)` Allowed: `MRP`, `OPS`, `OPT`, `PRS`	Order policy/replenishment system. OPS=Order Point System; OPT=Order Point System with Time planning; PRS=Periodic Review System/Periods Of Supply; MRP = Material Requirements Planning
Planning_Annual_Carrying_Cost_Percent	`decimal(5, 4)`	The expected carrying cost as percentage of inventory cost. NULL means unknown
Planning_Annual_Usage_Quantity_Base	`decimal(18, 3)`	Average usage of the product for 1 year. NUL means unknown
Planning_Horizon_Days	`int`	Number of days in the future for which to plan the demand and supply
Planning_Lead_Time_Days	`int`	The number of days required to supply or manufacture the product. The number is exclusive of the lead-time of lower-level components
Planning_Maximum_Inventory_Quantity_Base	`decimal(18, 3)`	Maximum inventory. NULL if N/A
Planning_Order_Cost_Base_Currency	`decimal(18, 3)`	Projected cost to place an order and set-up equipment
Planning_Order_Cycle_Days	`int`	Number of days in one period under fixed period replenishment system. NULL - not yet specified
Planning_Safety_Stock_Quantity_Base	`decimal(18, 3)`	Planned lowest inventory level, protecting against unplanned demands. The quantity is expressed in the base measurement unit of the product
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
Preferred_Supplier_Id	`uniqueidentifier`	Preferred supplier for the product. NULL if there is no preferred supplier
Procurement_Type	`nvarchar(1)` Allowed: `B`, `M`, `T`	M=Make; B=Buy; T=Transfer. Identifies whether the product is produced or externally bought
Product_Group_Id	`uniqueidentifier`	Not null when the method is a default method for a whole product group. In this case new products in the group inherit the settings
Product_Id	`uniqueidentifier`
Product_Supply_Id	`uniqueidentifier` `PK`
Row_Version	`timestamp`
Standard_Cost_Per_Lot	`decimal(18, 4)`	Standard cost for one lot of the product
Store_Id	`uniqueidentifier`	The store for which this rule is defined. When null, the rule is valid for all stores.
Supply_Schema_Id	`uniqueidentifier`	The supply schema to use for the distribution of the product among warehouses

Columns

Buyer_Name

The code or name of the person, who is in charge for purchasing the product from external suppliers. It is used to group different products on purchase demand report. NULL when Procurement_Type is not buy

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

Default_Store_Bin_Id

Default store bin for new deliveries using this supply scheme

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

Default_Store_Bin_Id - Supported Filters

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

Enterprise_Company_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	2147483647
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	100
User Login	no
Visible	no

Enterprise_Company_Id - Supported Filters

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

Fixed_Order_Quantity_Base

Fixed order quantity under the FOQ & EOQ replenishment system

Property	Value
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(18, 3)
UI Memo Editor	no
UI Width	100
User Login	no
Visible	no

From_Store_Id

Used when the Procurement_Type is Transfer

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

From_Store_Id - Supported Filters

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

Generate_Document_Type_Id

Specifies the type of the document which should be generated by the procurement planning system, when generating supply based on this rule.

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

Generate_Document_Type_Id - Supported Filters

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

Is_Active

1 if this product supply is active

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	no

Is_Active - Supported Filters

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

Is_Default

Specifies whether this is the default supply rule. The planning system works using only the default supply rules. The other rules are for reference and user information.

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	no

Is_Default - Supported Filters

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

Manufacturing_Policy

MTS=Make-To-Stock; MTO=Make-To-Order; ATO=Assemble-To-Order;ETO=Engineer-To-Order

Property	Value
Allowed Values	`ATO`, `MTO`, `MTS`, `ETO`
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	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(3)
UI Memo Editor	no
UI Width	100
User Login	no
Visible	no

Manufacturing_Policy - Supported Filters

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

Order_Lot_Size_Quantity_Base

The quantity of the product, normally ordered from the plant or supplier. The quantity is expressed in the base measurement unit

Property	Value
Auto Complete	no
Data Filter	no
Default Value	1
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
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

Order_Lot_Sizing_Method

LFL=Lot for Lot; FOQ=Fixed order quantity; EOQ=Eqonomic Order Quantity; ROP=ReOrder Point; ROT=ReOrder point with Time planning; LFP = Lot For Period;

Property	Value
Allowed Values	`EOQ`, `FOQ`, `LFL`, `LFP`, `ROP`, `ROT`
Auto Complete	no
Data Filter	no
Default Value	ROP
Enter Stop	yes
Ignore for Insert Order	no
Is Entity Name	no
Max Length	3
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(3)
UI Memo Editor	no
UI Width	100
User Login	no
Visible	no

Order_Lot_Sizing_Method - Supported Filters

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

Order_Maximum

Order maximum when buying or making. NULL means no maximum

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

Order_Minimum

Minimum order quantity both for buying and making

Property	Value
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(18, 3)
UI Memo Editor	no
UI Width	100
User Login	no
Visible	no

Order_Minimum - Supported Filters

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

Order_Multiple

1 if the order qty should be multiple of lot size when buying or making

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

Order_Period_Planning_Days

For how many days in the future should be planned - for fixed period replenishment system. NULL - not yet 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	no
Type	int (Allows NULL)
UI Memo Editor	no
UI Width	100
User Login	no
Visible	no

Order_Period_Start_Date

Start date of the first period under fixed period replenishment system. NULL - not yet 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	no
Type	datetime (Allows NULL)
UI Memo Editor	no
UI Width	100
User Login	no
Visible	no

Order_Period_Start_Date - Supported Filters

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

Order_Point_Quantity_Base

Order point quantity under the OP replenishment system

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

Order_Point_Quantity_Base - Supported Filters

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

Order_Policy

Order policy/replenishment system. OPS=Order Point System; OPT=Order Point System with Time planning; PRS=Periodic Review System/Periods Of Supply; MRP = Material Requirements Planning

Property	Value
Allowed Values	`MRP`, `OPS`, `OPT`, `PRS`
Auto Complete	no
Data Filter	no
Default Value	OPS
Enter Stop	yes
Ignore for Insert Order	no
Is Entity Name	no
Max Length	3
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(3)
UI Memo Editor	no
UI Width	100
User Login	no
Visible	no

Order_Policy - Supported Filters

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

Planning_Annual_Carrying_Cost_Percent

The expected carrying cost as percentage of inventory cost. NULL means unknown

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

Planning_Annual_Usage_Quantity_Base

Average usage of the product for 1 year. NUL means 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	no
Type	decimal(18, 3) (Allows NULL)
UI Memo Editor	no
UI Width	100
User Login	no
Visible	no

Planning_Horizon_Days

Number of days in the future for which to plan the demand and supply

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

Planning_Lead_Time_Days

The number of days required to supply or manufacture the product. The number is exclusive of the lead-time of lower-level components

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

Planning_Maximum_Inventory_Quantity_Base

Maximum inventory. NULL if 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	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(18, 3) (Allows NULL)
UI Memo Editor	no
UI Width	100
User Login	no
Visible	yes

Planning_Order_Cost_Base_Currency

Projected cost to place an order and set-up equipment

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

Planning_Order_Cycle_Days

Number of days in one period under fixed period replenishment system. NULL - not yet 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	no
Type	int (Allows NULL)
UI Memo Editor	no
UI Width	100
User Login	no
Visible	no

Planning_Safety_Stock_Quantity_Base

Planned lowest inventory level, protecting against unplanned demands. The quantity is expressed in the base measurement unit of the product

Property	Value
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(18, 3)
UI Memo Editor	no
UI Width	100
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

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

Preferred_Supplier_Id

Preferred supplier for the product. NULL if there is no preferred supplier

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

Preferred_Supplier_Id - Supported Filters

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

Procurement_Type

M=Make; B=Buy; T=Transfer. Identifies whether the product is produced or externally bought

Property	Value
Allowed Values	`B`, `M`, `T`
Auto Complete	no
Data Filter	no
Default Value	B
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	nvarchar(1)
UI Memo Editor	no
UI Width	100
User Login	no
Visible	no

Procurement_Type - Supported Filters

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

Product_Group_Id

Not null when the method is a default method for a whole product group. In this case new products in the group inherit the settings

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

Product_Group_Id - Supported Filters

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

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

Product_Id - Supported Filters

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

Product_Supply_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

Product_Supply_Id - Supported Filters

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

Standard_Cost_Per_Lot

Standard cost for one lot of the product

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

Store_Id

The store for which this rule is defined. When null, the rule is valid for all stores.

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

Store_Id - Supported Filters

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

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

Table of Contents