With this object you can retrieve the stock information together with Batch/Serial and Bin location information
Support SAP, Beas and WMS Bin managed system
But not all in parallel. This is the reason, that you can display the stock always only 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,BinLocation/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"
IVersionId
Edm.String(20)
Database: coalesce("OBTN"."U_beas_ver","OSRN"."U_beas_ver",'')
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)
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: ''
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
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
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.
