Entity Relation: ItemWareHouse -> WhsCode

Database: "OWHS"."WhsCode"

Database: "OWHS"."WhsName"

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')

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

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

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

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

Database: "OWHS"."U_beas_color"

Database: "OWHS"."U_beas_bitmap"

Database: (select sum("OITW"."OnHand") from "OITW" where "OITW"."WhsCode"="OWHS"."WhsCode")

Database: case when coalesce("OWHS"."Inactive",'N')='Y' then 0 else 1 end

Entity Relation: Branch -> BranchId

Database: "OWHS"."BPLid"

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",'')

Database: Coalesce("BEAS_WHS"."LENGTH_IN_M",0)

Database: Coalesce("BEAS_WHS"."WIDTH_IN_M",0)

Database: "OWHS"."Street"

Database: "OWHS"."StreetNo"

Database: "OWHS"."Block"

Database: "OWHS"."Building"

Database: "OWHS"."ZipCode"

Database: "OWHS"."City"

Database: "OWHS"."County"

Database: "OWHS"."Country"

Database: "OWHS"."State"

Database: "OWHS"."GlblLocNum"