Warehouse from an item
Property |
Description |
Table |
OITW |
Primary key |
ItemCode/c,WhsCode/c |
$transaction |
yes |
$branch |
yes |
$mask |
For dropdown you can use follow mask definition: |
Name |
Type |
Description |
|
ItemCode |
Edm.String(50) |
|
|
WhsCode |
Edm.String(20) |
|
|
OnHand |
Edm.Decimal |
|
|
UoMCode |
Edm.String(20) |
|
|
Locked |
Edm.Boolean |
|
|
Active |
Edm.Boolean |
|
Join to Entiy Object |
Relation |
Item |
ItemCode |
WareHouse |
WhsCode |
UoM |
UoMCode |
Branch |
BranchId |
ItemWareHouse example GET query, that requests the ItemCode and WhsCode of the ItemWareHouse filtered by a specific the WhsCode:
/ItemWareHouse?$select=ItemCode,WhsCode&$filter=WhsCode eq "B-2"
Response in JSON format:
{
"value": [
{
"ItemCode": "Sofa",
"WhsCode": "B-2"
},
{
"ItemCode": "Sofa0003_000",
"WhsCode": "B-2"
},
{
"ItemCode": "Sofa0004_000",
"WhsCode": "B-2"
}
]
}