ItemWareHouse

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:
1: WareHouse/WhsCode,WareHouse/WhsName,OnHand,UoMCode,WareHouse/WhsType,WareHouse/WhsColor,WareHouse/WhsBitmap
You can define follow filter:
&$filter=ItemCode eq
 

 

Fields

Name

Type

Description

ItemCode

Edm.String(50)

Entity Relation: Item -> ItemCode

Database: "OITW"."ItemCode"

WhsCode

Edm.String(20)

Entity Relation: WareHouse -> WhsCode

Database: "OITW"."WhsCode"

OnHand

Edm.Decimal

stcklistenposition_bearbeiten.htm

Database: "OITW"."OnHand"

UoMCode

Edm.String(20)

Entity Relation: UoM -> UoMCode

Integration hub: Importable

Database: "OITM"."InvntryUom"

Locked

Edm.Boolean

Database: "OWHS"."Locked"

Active

Edm.Boolean

Database: case when "OWHS"."Inactive"='Y' or "OITW"."Locked" = 'Y' then 0 else 1 end

 

Relations

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"
        }
    ]
}