With this object you can retrieve the stock information together with Batch/Serial and Bin location information.
It supports SAP, Beas and WMS Bin-managed system - but not all in parallel. This is the reason why you can only display the stock for one warehouse.
The definition on warehouse is mandatory.
/WareHouseStock <- Produce error
/WareHouseStock("BW") <- correct
GET
Stock information for Warehouse
Property
Description
Table
OWHS
Primary key
WhsCode/c,ItemCode/c,Batch/c,BinCode/c Mandatory: WhsCode
$transaction
no
$branch
no
$mask
no
Fields
Name
Type
Description
WhsCode
Edm.String(20)
Entity Relation: WareHouse -> WhsCode
Database: "OWHS"."WhsCode"
ItemCode
Edm.String(50)
Entity Relation: Item -> ItemCode
Integration hub: Importable
Mandatory field
Primary key
Database: "OITM"."ItemCode"
Batch
Edm.String(36)
Database: coalesce("OBTN"."DistNumber","OSRN"."DistNumber",'')
SysNumber
Edm.Int32
Database: coalesce("OBTN"."SysNumber","OSRN"."SysNumber",0)
UoMCode
Edm.String(20)
Entity Relation: UoM -> UoMCode
Database: rtrim("OITM"."InvntryUom")
ForBoMId
Edm.String(20)
This is a field for definition the Filter for field ReservedQuantityForBoM
$select=ReservedQuantityForBoM&$filter=ForBoMId eq 'WoDocEntry/WoLineNumber/WoLineNumber2'
Example
$select=ReservedQuantityForBoM&$filter=ForBoMId eq '3002/10/10'
in $select area it return always empty string
Database:
BinCode
Edm.String(20)
The Bin Location from Beas, SAP or WMS warehouse. See /BinLocation
Entity Relation: BinLocation -> BinCode
Database: ''
RFID
Edm.String(20)
SAP Bin managed warehouse: empty
Beas managed: The RFID number. More see documentation
WMS: The LUID
Database: ''
SSCC
Edm.String(20)
OnHand
Edm.Decimal
Database: coalesce(case when "OITM"."ManSerNum"='Y' then "OSRQ"."Quantity" when "OITM"."ManBtchNum"='Y' then "OBTQ"."Quantity" else "OITW"."OnHand" end,0)
CommitedQty
Edm.Decimal
Commited Quantity (Example Transfer request or SAP Sales order)
Only on Batch/Serial level it is possible to create a hard reservation.
This is not Beas reserved quantity.
If not Batch/Serial number is linked, this information is always 0
Note: This column is not compatible to any Bin managed warehouse
If the Batch item is inside different bin location, you see for every bin location the complete commited quantity
Database: coalesce(case when "OITM"."ManSerNum"='Y' then "OSRQ"."CommitQty" when "OITM"."ManBtchNum"='Y' then "OBTQ"."CommitQty" else 0 end,0)
ReservedQuantityForBoM
Edm.Decimal
Return Quanity for the BoM Position defined in filter ForMomId
$select=ReservedQuantityForBoM&$filter=ForBoMId eq 'WoDocEntry/WoLineNumber/WoLineNumber2'
Example
$select=ReservedQuantityForBoM&$filter=ForBoMId eq '3002/10/10'
If the filter ForBoMId is not defined, then this field return always 0
Database: case when = '' then 0 else (SELECT coalesce(SUM(R1."Quantity"),0) FROM "BEAS_RESERVATION_LINE" R1 WHERE R1."BASE_TYPE"='wo' AND (CAST(R1."BASE_DOCENTRY" AS VARCHAR)+CHAR(47)+cast(R1."BASE_LINENUM" AS VARCHAR)+CHAR(47)+cast(R1."BASE_LINENUM2" AS
BatchAttribute1
Edm.String(36)
Database: coalesce("OSRN"."MnfSerial","OBTN"."MnfSerial",'')
BatchAttribute2
Edm.String(36)
Database: coalesce("OSRN"."LotNumber","OBTN"."LotNumber",'')
IVersionId
Edm.String(36)
Database: coalesce("OSRN"."U_beas_ver","OBTN"."U_beas_ver",'')
Details
Edm.String(8000)
Database: coalesce("OSRN"."Notes","OBTN"."Notes",'')
AdmissionDate
Edm.DateTimeOffset
Database: coalesce("OSRN"."InDate","OBTN"."InDate",NULL)
ExpirationDate
Edm.DateTimeOffset
Database: coalesce("OSRN"."ExpDate","OBTN"."ExpDate",NULL)
WarrantyStart
Edm.DateTimeOffset
Database: "OSRN"."GrntStart"
WarrantyEnd
Edm.DateTimeOffset
Database: "OSRN"."GrntExp"
ManufacturingDate
Edm.DateTimeOffset
Database: coalesce("OSRN"."MnfDate","OBTN"."MnfDate",NULL)
Status
Edm.String(1)
Database: coalesce("OSRN"."Status","OBTN"."Status",'')
SelfProduction
Edm.Boolean
Database: coalesce("OSRN"."U_beas_selfprod","OBTN"."U_beas_selfprod",'')
ReservedQuantity
Edm.Decimal
Reserved Quantity from this Batch/ Serial/ Bin Location (Check only Beas Reservation system, not SAP Commited Quantity)
Database: coalesce(R.reservedQuantity,0)
Relations
Join to Entiy Object
Relation
ItemWareHouse
ItemCode,WhsCode
Item
ItemCode
WareHouseArea
AreaCode
BinLocation
BinCode
ItemVersion
ItemCode,IVersionId
UoM
UoMCode
WareHouse
WhsCode
Batch and Serial number related fields
Note : It is not possible to create a link to Object BatchNumber or to the SerialNumber. These fields can be accessed directly from Batches and Serials in the WareHouseStock Object.