Table of Contents

Table Gen_Product_Supply

Entity

Entity: Logistics.Procurement.ProductSupply

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