Present the BoM for External Workorder Provision List
For more information see ExternalPurchaseOrder
WorkorderProvisionBom
Property
Description
Table
BEAS_FTSTL
Primary key
ExternalDocEntry/i
$transaction
no
$branch
no
$mask
no
Fields
Name
Type
Description
ExternalDocEntry
Edm.Int32
Database: "BEAS_OWING_SUPPLIES"."DocEntry"
ExternalStatus
Edm.String(1)
Database: case when "POR1"."LineStatus"='O' and "BEAS_OWING_SUPPLIES"."DocStatus" <> 'C' then 'O' else 'C' end
WoDocEntry
Edm.Int32
WoLineNumber
Edm.Int32
WoLineNumber2
Edm.Int32
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"
WoRoutingPosition
Edm.Int32
Database: "BEAS_FTAPL"."POS_ID"
PODocEntry
Edm.Int32
Database: "OPOR"."DocEntry"
PODocNumber
Edm.Int32
Database: "OPOR"."DocNum"
POLineNumber
Edm.Int32
Database: "POR1"."LineNum"
OrderQuantityPrdUnit
Edm.Decimal
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
TransferedQuantity
Edm.Decimal
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
Relations
Join to Entiy Object
Relation
WorkorderBom
WorkorderPos
Workorder
WorkorderRouting
PurchaseOrderLines
ExternalPurchaseOrder