WareHouseStock

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)

ItemCode

Edm.String(50)

Batch

Edm.String(36)

SysNumber

Edm.Int32

UoMCode

Edm.String(20)

ForBoMId

Edm.String(20)

BinCode

Edm.String(20)

RFID

Edm.String(20)

SSCC

Edm.String(20)

OnHand

Edm.Decimal

CommitedQty

Edm.Decimal

ReservedQuantityForBoM

Edm.Decimal

BatchAttribute1

Edm.String(36)

BatchAttribute2

Edm.String(36)

IVersionId

Edm.String(36)

Details

Edm.String(8000)

AdmissionDate

Edm.DateTimeOffset

ExpirationDate

Edm.DateTimeOffset

WarrantyStart

Edm.DateTimeOffset

WarrantyEnd

Edm.DateTimeOffset

ManufacturingDate

Edm.DateTimeOffset

Status

Edm.String(1)

SelfProduction

Edm.Boolean

ReservedQuantity

Edm.Decimal

 

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.