📚 SAP Business One SDK Help

Table Name: OMSN

Table Description: MRP Scenarios

Field Description Type Size Related Default Value Constraints
AbsEntry Internal Number Int 11 -      
MsnCode MRP Scenario Code nVarChar 30 -      
Descr Description nVarChar 100 -      
GrpPeriods Group Data into Periods of VarChar 1 - D D Days
            W Weeks
            M Months
PeriodsLen Group Data into Periods of Int 11 - 1    
StartDate Report Start Date Date 8 -      
EndDate Report End Date Date 8 -      
MaxLdTime Maximum Cumulative Lead Time Int 11 -      
HldaysProd Holidays for Production VarChar 1 - Y Y Yes
            N No
HldaysPurc Holidays for Purchase VarChar 1 - Y Y Yes
            N No
ItmFrom Items Codes From nVarChar 50 OITM      
ItmTo Items Codes To nVarChar 50 OITM      
ItmGrp Items Groups Int 11 OITB      
ItmQryGrp Item Summary Report Group nVarChar 250 -      
ExistStock Consider Existing Inventory VarChar 1 - Y Y Yes
            N No
PurchOrder Consider Purchase Orders VarChar 1 - Y Y Yes
            N No
SalesOrder Consider Sales Orders VarChar 1 - Y Y Yes
            N No
WorkOrder Consider Work Orders VarChar 1 - Y Y Yes
            N No
MinStckLvl Minimum Inventory Level VarChar 1 - N Y Yes
            N No
FCTAbs Forecast Absolute Entry Int 11 OFCT      
SortBy Sort By VarChar 1 - L L Assembly Sequence
            C Item Number
            N Item Description
            G Item Group
ItmReq Items Without Requirement VarChar 1 - N Y Yes
            N No
Simulation Is Scenario a Simulation VarChar 1 - N Y Yes
            N No
UpdateDate Update Date Date 8 -      
UpdateBy Update By nVarChar 20 -      
LastExecDa Last Execute Date Date 8 -      
AllItems All Items VarChar 1 - Y    
ByCompany By Company VarChar 1 - Y    
IncHisData Include Historical Data VarChar 1 - N Y Yes
            N No
ResInv Reserve Invoice VarChar 1 - N Y Yes
            N No
Wtrq Inventory Transfer Request VarChar 1 - N Y Yes
            N No
InvtLevel Inventory Level VarChar 1 - D D  
            R Required
            I Minimum
            A Maximum
            M Minimum - Maximum
RcmPO Recommend Purchase Order VarChar 1 - N Y Yes
            N No
RcmWO Recommend Production Order VarChar 1 - Y Y Yes
            N No
RcmWTRQ Recommend ITRQ VarChar 1 - N Y Yes
            N No
RCMDefWhs Recommend to Default Warehouse VarChar 1 - Y Y Yes
            N No
OnlyNettbl Only Nettable VarChar 1 - Y Y Yes
            N No
ExpandedPO Expanded Purchase Order VarChar 1 - N    
ExpandedSO Expanded Sales Order VarChar 1 - N Y Yes
            N No
RcmCalDate Recommendation Calculated Date Date 8 -      
RcmCalTime Recommendation Calculated Time Int 11 -      
PurchOAT Blanket Purchase Agreement VarChar 1 - Y Y Yes
            N No
SalesOAT Blanket Sales Agreement VarChar 1 - Y    
Rots Recurring Order Transactions VarChar 1 - N Y Yes
            N No
ExpdResINV Expanded Reserve Invoice VarChar 1 - N    
ExpdWOR Expanded Production Order VarChar 1 - N Y Yes
            N No
IgnoreCLT Ignore Cumulative Lead Time VarChar 1 - N Y Yes
            N No
PurchReq Consider Purchase Request VarChar 1 - N Y Yes
            N No
PurchQuota Consider Purchase Quotations VarChar 1 - N Y Yes
            N No
SalesQuota Consider Sales Quotations VarChar 1 - N Y Yes
            N No
ExpdPurReq Expanded Purchase Request VarChar 1 - N Y Yes
            N No
ExpdPQuota Expanded Purchase Quotations VarChar 1 - N Y Yes
            N No
ExpdSQuota Expanded Sales Quotations VarChar 1 - N Y Yes
            N No
ExpdPAgree Expanded Purchase Agreements VarChar 1 - N Y Yes
            N No
ExpdSAgree Expanded Sales Agreements VarChar 1 - N Y Yes
            N No
ExpdTraReq Expanded Transfer Request VarChar 1 - N Y Yes
            N No
DisSelItem Display Selected Item Only VarChar 1 - N Y Yes
            N No
Key Unique Field
PRIMARY Yes AbsEntry
MSN_CODE Yes MsnCode