Entity Relation: Workorder -> DocEntry

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"

Internal sort id. beas sort the bom list by this number

Integration hub

-1 = sort by POS_ID, fast solution

-2 = sort by POS_ID, beas sort the complete bill of material list

-3 = sort by Position Text - alphanumeric

-4 = sort by Position Text - Numeric

More information see documentation

object ue_api_wobom

- beas check the sortid and all special rules too, if you save this with wobom.save

stcklistenposition_bearbeiten.htm

Integration hub: Importable

Database: coalesce("BEAS_FTSTL"."SortId","BEAS_FTSTL"."POS_ID")

stcklistenposition_bearbeiten.htm

Integration hub: Importable

Database: "BEAS_FTSTL"."POS_TEXT"

Database: cast("BEAS_FTSTL"."NUMMER" as varchar(20))

stcklistenposition_bearbeiten.htm

Linked table: OITM

Linked column: ItemCode

Integration hub: Importable

Mandatory field

Database: "BEAS_FTSTL"."ART1_ID"

stcklistenposition_bearbeiten.htm

Database: "BEAS_FTSTL"."ItemName"

Database: case when rtrim(coalesce("BEAS_FTSTL"."U_beas_ver",''))='' then '' else "BEAS_FTSTL"."U_beas_ver" end

stcklistenposition_bearbeiten.htm

Database: "BEAS_FTSTL"."MENGE_LAGER"

Database: rtrim("BEAS_FTSTL"."ME_LAGER")

In production BOM the quantity is always provided in consumption units.

stcklistenposition_bearbeiten.htm

Database: "BEAS_FTSTL"."MENGE_VERBRAUCH"

Database: rtrim("BEAS_FTSTL"."ME_VERBRAUCH")

Integration hub: Importable

Mandatory field

Database: coalesce("BEAS_FTSTL"."INPUT_QTY","BEAS_FTSTL"."MENGE_VERBRAUCH")

Database: rtrim(coalesce("BEAS_FTSTL"."INPUT_UNIT","BEAS_FTSTL"."ME_VERBRAUCH"))

Integration hub: Importable

Database: coalesce("BEAS_FTSTL"."INPUT_FACTOR",1)

stcklistenposition_bearbeiten.htm

Integration hub: Importable

Database: "BEAS_FTSTL"."AUSSCHUSS"

stcklistenposition_bearbeiten.htm

Database: "BEAS_FTSTL"."TOTALQUANTITY_WHUNIT"

Booked quantity in Warehouse unit

Database: coalesce("BEAS_FTSTL"."BookedQty",0)

Database: coalesce((select sum(lr."Quantity") from "BEAS_RESERVATION_LINE" as lr where lr."BASE_TYPE"='wo' and lr."BASE_DOCENTRY"="BEAS_FTSTL"."BELNR_ID" and lr."BASE_LINENUM"="BEAS_FTSTL"."BELPOS_ID" and lr."BASE_LINENUM2" = "BEAS_FTSTL"."POS_ID" and lr."RESERVATI

stcklistenposition_bearbeiten.htm

Linked table: OWHS

Linked column: WhsCode

Integration hub: Importable

Database: "BEAS_FTSTL"."WhsCode"

Integration hub: Importable

Database: "BEAS_FTSTL"."BINCODE"

Return internal position to related Routing position

if not defined, it returned the first or last Routing position (related to current settings)

Link to Routing position

Database - NULL: Related to first or last routing position (related to setting)

stcklistenposition_bearbeiten.htm

Integration hub: Importable

Database: case when coalesce("BEAS_FTSTL"."APLANPOS_ID",0)=0 then (select min(fa1."POS_ID") from "BEAS_FTAPL" as fa1 where fa1."BELNR_ID"="BEAS_FTSTL"."BELNR_ID" and fa1."BELPOS_ID"="BEAS_FTSTL"."BELPOS_ID" and fa1."SortId" = (select max(fa2."SortId") from "BEAS_F

stcklistenposition_bearbeiten.htm

Database: "BEAS_FTSTL"."U_znr"

stcklistenposition_bearbeiten.htm

Integration hub: Importable

Database: "BEAS_FTSTL"."DIN"

stcklistenposition_bearbeiten.htm

Linked table: OITM

Linked column: ItemCode

Integration hub: Importable

Mandatory field

Database: "BEAS_FTSTL"."ART1_ID"

stcklistenposition_bearbeiten.htm

Integration hub: Importable

Database: "BEAS_FTSTL"."Match"

stcklistenposition_bearbeiten.htm

Integration hub: Importable

Database: "BEAS_FTSTL"."COLORID"

Constraints:

bmp=bmp

stcklistenposition_bearbeiten.htm

Integration hub: Importable

Database: "BEAS_FTSTL"."BITMAPNAME"

Database: CASE WHEN coalesce("BEAS_FTHAUPT"."ABGKZ",'') = 'J' or coalesce("BEAS_FTPOS"."ABGKZ",'')='J' or coalesce("BEAS_FTSTL"."ABGKZ",'')='J' THEN 1 ELSE 0 END

stcklistenposition_bearbeiten.htm

Integration hub: Importable

Database: "BEAS_FTSTL"."UDF1"

stcklistenposition_bearbeiten.htm

Integration hub: Importable

Database: "BEAS_FTSTL"."UDF2"

stcklistenposition_bearbeiten.htm

Integration hub: Importable

Database: "BEAS_FTSTL"."UDF3"

stcklistenposition_bearbeiten.htm

Integration hub: Importable

Database: "BEAS_FTSTL"."UDF4"

calculate total quantity and save this in current Work order BoM Table, if the entry inside table is wrong

If LineNumber2 not defined, it calculate all Lines from work order position

If LineNumber not defined, it calculate all work order positions

if DocEntry not defined, it calculate all. (Don't use it please. This can take long time)

If LineNumber2 is defined, it return follow informations:

OpenRoundQuantity = open rounded quantity.

OpenQuantity = open quantity without rounding rules

PlannedQuantity = total planned quantity

RoundingRule = rounding rules, dec.: count of decimal places

rounding type

no Rounding=-1

Rounding at .5=0

Rounding up=1

Rounding down=2

Multiple of=3

if LineNumber2 not existing for defined work order position, it return status 400

if LineNumber2 = 0 then it return always status 200