Name
|
Type
|
Description
|
WhsCode
|
Edm.String(20)
|
Entity Relation: ItemWareHouse -> WhsCode
Database: "OWHS"."WhsCode"
|
|
WhsName
|
Edm.String(100)
|
Database: "OWHS"."WhsName"
|
|
WhsTypeId
|
Edm.String(100)
|
Return the Warehouse Type
Y = Blocked Warehouse (but transactions in SAP possible)
B = Allocation Warehouse
E = External Warehouse
K = PO Comission Warehouse
A = Absorption Cost Warehouse
S = Standard Warehouse
Database: coalesce("OWHS"."U_beas_lck",'S')
|
|
WhsType
|
Edm.String(50)
|
Return the Description of Warehouse Type
In language of current Session
Blocked Warehouse
Allocation Warehouse
External Warehouse
PO Comission Warehouse
Absorption Cost Warehouse
Standard Warehouse
Database: case coalesce("OWHS"."U_beas_lck",'') when 'Y' then 'Sperrlager' when 'W' then 'Wareneingang und QC' when 'B' then 'Bereitstellungslager' when 'E' then 'Externes Lager' when 'K' then 'Einkauf Kommissionslager' when 'A' then 'Absorption Cost' el
|
|
WhsBinType
|
Edm.Int32
|
Warehouse Bin Administration Type
0=None
1=beas
2=SAP
3=Produmex (current not supported)
Database: case when coalesce("BEAS_WHS"."BINTYP",'') = '1' then 1 when "OWHS"."BinActivat" = 'Y' then 2 else 0 end
|
|
WhsBinRFID
|
Edm.Boolean
|
Define, if RFID is supported.
This is possible only in beas bin management, if you activate the RFID support in configuration wizzard
Database: case when coalesce("BEAS_WHS"."BINTYP",'') = '1' then 1 else 0 end
|
|
Visualization
|
Edm.Boolean
|
Define, if the visualisation is avtive
You can define this in beas bin management - warehouse area
This flag is active, if in minimal one warehouse area the visualisation is activated
Database: case when (select count(*) from "BEAS_WHSAREA" a WITH (NOLOCK) where a."WhsCode"="OWHS"."WhsCode" and a."VISUALISATION" = '1' ) >0 then 1 else 0 end
|
|
WhsColor
|
Edm.Int32
|
Database: "OWHS"."U_beas_color"
|
|
WhsBitmap
|
Edm.String(50)
|
Database: "OWHS"."U_beas_bitmap"
|
|
OnHand
|
Edm.Decimal
|
Database: (select sum("OITW"."OnHand") from "OITW" where "OITW"."WhsCode"="OWHS"."WhsCode")
|
|
Active
|
Edm.Boolean
|
Database: case when coalesce("OWHS"."Inactive",'N')='Y' then 0 else 1 end
|
|
BranchId
|
Edm.Int32
|
Entity Relation: Branch -> BranchId
Database: "OWHS"."BPLid"
|
|
DefaultVariant
|
Edm.String(1)
|
If in batch-pre-calculation "Price per warehouse" - "Variants per warehouse" is set up,
referring to the warehouse to be calculated, the stored variant is used.
The option is only displayed, if in Basis-Initialization "Price per warehouse" was set up.
Additionally, a default variant can be stored, which is used at the creation of a work order or
in case of changing the receipt warehouse.
Database: Coalesce("OWHS"."U_beas_variant",'')
|
|
Length
|
Edm.Decimal
|
Database: Coalesce("BEAS_WHS"."LENGTH_IN_M",0)
|
|
Width
|
Edm.Decimal
|
Database: Coalesce("BEAS_WHS"."WIDTH_IN_M",0)
|
|
Street
|
Edm.String(100)
|
Database: "OWHS"."Street"
|
|
StreetNo
|
Edm.String(100)
|
Database: "OWHS"."StreetNo"
|
|
Block
|
Edm.String(100)
|
|
Building
|
Edm.String(1024)
|
Database: "OWHS"."Building"
|
|
Postcode
|
Edm.String(20)
|
Database: "OWHS"."ZipCode"
|
|
City
|
Edm.String(100)
|
|
County
|
Edm.String(100)
|
Database: "OWHS"."County"
|
|
Country
|
Edm.String(20)
|
Database: "OWHS"."Country"
|
|
State
|
Edm.String(20)
|
|
GLN
|
Edm.String(50)
|
Database: "OWHS"."GlblLocNum"
|
|