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
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 |
Name |
Type |
Description |
|
WhsCode |
Edm.String(20) |
|
|
ItemCode |
Edm.String(50) |
|
|
IVersionId |
Edm.String(20) |
|
|
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 |
|
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.