Introduction

Decision Name

SQL Query

Comment

IsStockCodeValid

SELECT StockCode, Description FROM  SysproCompany0.dbo.InvMaster WITH (NOLOCK) WHERE StockCode = @StockCode

Returns a TRUE if the stock code exists in SYSPRO

 AreMultipleBinsEnabled

SELECT UseMultipleBins FROM SysproCompany0.dbo.InvWhControl WITH (NOLOCK) WHERE Warehouse = @Warehouse 

Returns a TRUE if Multiple Bins are enabled in SYSPRO

 IsLotTraceable

SELECT TraceableType FROM  SysproCompany0.dbo.InvMaster WITH (NOLOCK) WHERE StockCode = @StockCode AND TraceableType = 'T'

Returns a TRUE if the stock code is Lot Traceable in SYSPRO

IsInspection

 SELECT TraceableType FROM  SysproCompany0.dbo.InvMaster WITH (NOLOCK) WHERE StockCode = @StockCode AND TraceableType = 'I'

 Returns a TRUE if the stock code is marked to requred Insepction in SYSPRO

 IsSerialized

SELECT SerialMethod FROM  SysproCompany0.dbo.InvMaster WITH (NOLOCK) WHERE StockCode = "@StockCode" AND SerialMethod <> 'N'")

Returns a TRUE if the stock code is serialised in SYSPRO

IsBatchSerial

SELECT SerialMethod FROM  SysproCompany0.dbo.InvMaster WITH (NOLOCK) WHERE StockCode = @StockCode AND SerialMethod = 'B'

Returns a TRUE if the stock code in marked as Batch Serialised in SYSPRO