WareHouseItemStock

With this object you can retrieve the stock information (together with Batch/Serial and Bin location information) in a warehouse.

It supports SAP, Beas and WMS Bin-managed system - but not all in parallel. This is the reason why you can only display the item stock for one warehouse.

The definition of warehouse and item is mandatory.

The performance of this entity is significantly higher than the WareHouseStock entity filtered by item.

 

/WareHouseItemStock <- produces error

/WareHouseItemStock("BW","item") <- 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)

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

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.