Database: "BEAS_OWING_SUPPLIES"."DocEntry"

Database: case when "POR1"."LineStatus"='O' and "BEAS_OWING_SUPPLIES"."DocStatus" <> 'C' then 'O' else 'C' end

stcklistenposition_bearbeiten.htm

Integration hub: Importable

Mandatory field

Primary key

Database: "BEAS_FTSTL"."BELNR_ID"

stcklistenposition_bearbeiten.htm

Integration hub: Importable

Mandatory field

Primary key

Database: "BEAS_FTSTL"."BELPOS_ID"

Internal Position number. You can't change it.

This is not the sort number. Sorting is defined by SortId

Integration hub

- use POS_ID=0 - beas create the next number

- if you define a POS_ID, beas update the existing position number or create a new line, if not existing

ue_api_wobom

- the object don't check, if the pos-id is existing. if you insert a existing pos_id a second time, you create a primary key error.

stcklistenposition_bearbeiten.htm

Integration hub: Importable

Primary key

Database: "BEAS_FTSTL"."POS_ID"

Database: "BEAS_FTAPL"."POS_ID"

Database: "OPOR"."DocEntry"

Database: "OPOR"."DocNum"

Database: "POR1"."LineNum"

Database: "POR1"."Quantity" * case when COALESCE("POR1"."U_anz_pack","BEAS_FTAPL"."RM_FAKTOR",0)=0 then 1 else COALESCE("POR1"."U_anz_pack","BEAS_FTAPL"."RM_FAKTOR") end

Database: Coalesce((select sum("Quantity") from "WTR1" where "WTR1"."U_belnrid"="POR1"."U_belnrid" and "WTR1"."U_belposid"="POR1"."U_belposid" and "WTR1"."U_posid"="BEAS_FTSTL"."POS_ID" and "WTR1"."WhsCode"="BEAS_OWING_SUPPLIES"."WhsCode" and ((-1) * "BEAS_OWING_SU