WorkorderPos

Contents

WorkorderPos

Property	Description
Table	BEAS_FTPOS
Primary key	DocEntry/i,LineNumber/i
$transaction	yes
$branch	yes
$mask	no

Fields

Name

Type

Description

DocEntry

Edm.Int32

Entity Relation: Workorder -> DocEntry

Work order document number (internal counter)

Import: insert value "0" for create new entry.

You can't define the number for new work orders

Default Value: 0

fertigungsposition.htm

Integration hub: Importable

Mandatory field

Database: "BEAS_FTPOS"."BELNR_ID"

LineNumber

Edm.Int32

Work order position

fertigungsposition.htm

Integration hub: Importable

Mandatory field

Database: "BEAS_FTPOS"."BELPOS_ID"

Barcode

Edm.String(16)

fertigungsposition.htm

Integration hub: Importable

Database: "BEAS_FTPOS"."BarCode"

Level

Edm.Int32

Level from position

First Level=0

Sub Level (Sib Assembly) 1 and so on. Max=20

fertigungsposition.htm

Database: "BEAS_FTPOS"."STUFE"

ItemCode

Edm.String(50)

Entity Relation: Item -> ItemCode

fertigungsposition.htm

Linked table: OITM

Linked column: ItemCode

Integration hub: Importable

Mandatory field

Database: "BEAS_FTPOS"."ItemCode"

ItemVersion

Edm.String(20)

fertigungsposition.htm

Integration hub: Importable

Database: "BEAS_FTPOS"."U_beas_ver"

ItemName

Edm.String(100)

Database: rtrim("BEAS_FTPOS"."ItemName")

LineNumber

Edm.Int32

Work order position

fertigungsposition.htm

Integration hub: Importable

Mandatory field

Database: "BEAS_FTPOS"."BELPOS_ID"

Quantity

Edm.Int32

fertigungsposition.htm

Linked table: BEAS_ME

Linked column: ME_ID

Integration hub: Importable

Database: "BEAS_FTPOS"."MENGE"

QuantityConsumptionUoM

Edm.Int32

Quantity in production unit.

creation: Calculate the inventory unit automatically.

fertigungsposition.htm

Integration hub: Importable

Mandatory field

Database: "BEAS_FTPOS"."MENGE_VERBRAUCH"

UoMConsumptionId

Edm.String(20)

fertigungsposition.htm

Linked table: BEAS_ME

Linked column: ME_ID

Integration hub: Importable

Database: "BEAS_FTPOS"."ME_VERBRAUCH"

UoMConsumptionFactor

Edm.Int32

Factor between ConsumptionUnit and StockUnit

1 StockUnit = 1 * ConsumptionFactor ConsuptionUnit

Example

Stock Unit = kg

ConsumptionUnit = g

Factor = 1000

Stock Quantity 1 kg = Consumption Unit 1000 g

fertigungsposition.htm

Database: case when coalesce("BEAS_FTPOS"."ME_UMR",0)=0 then 1 else "BEAS_FTPOS"."ME_UMR" end

QuantityWhsUnit

Edm.Decimal

Return the Quantity in Inventory Unit

creation: Don't use this field.

fertigungsposition.htm

Linked table: BEAS_ME

Linked column: ME_ID

Integration hub: Importable

Database: "BEAS_FTPOS"."MENGE"

QuantityScrap

Edm.Decimal

fertigungsposition.htm

Integration hub: Importable

Database: "BEAS_FTPOS"."MENGE_VERSCHNITT"

QuantityProduced

Edm.Decimal

fertigungsposition.htm

Integration hub: Importable

Database: "BEAS_FTPOS"."GEL_MENGE"

UoMWareHouseId

Edm.String(20)

fertigungsposition.htm

Linked table: BEAS_ME

Linked column: ME_ID

Integration hub: Importable

Database: "BEAS_FTPOS"."ME_LAGER"

WhsCode

Edm.String(20)

Entity Relation: WareHouse -> WhsCode

fertigungsposition.htm

Linked table: OWHS

Linked column: WhsCode

Integration hub: Importable

Database: "BEAS_FTPOS"."WhsCode"

BinCode

Edm.String(20)

fertigungsposition.htm

Integration hub: Importable

Database: "BEAS_FTPOS"."BINCODE"

DrawingNumber

Edm.String(50)

fertigungsposition.htm

Integration hub: Importable

Database: "BEAS_FTPOS"."U_znr"

DIN

Edm.String(20)

fertigungsposition.htm

Integration hub: Importable

Database: "BEAS_FTPOS"."DIN"

RawMaterialId

Edm.String(20)

Entity Relation: RawMaterial -> RawMaterialId

fertigungsposition.htm

Linked table: BEAS_WST

Linked column: WST_ID

Integration hub: Importable

Database: "BEAS_FTPOS"."WST_ID"

MatchCode

Edm.String(20)

fertigungsposition.htm

Integration hub: Importable

Database: "BEAS_FTPOS"."Match"

Configuration

Edm.Int32

fertigungsposition.htm

Integration hub: Importable

Database: "BEAS_FTPOS"."VRI"

ShortVariant

Edm.String(20)

Constraints:

A=A

B=B

C=C

D=D

E=E

F=F

G=G

H=H

I=I

J=J

K=K

L=L

M=M

N=N

O=O

P=P

Q=Q

R=R

S=S

T=T

U=U

V=V

W=W

X=X

Y=Y

Z=Z

fertigungsposition.htm

Integration hub: Importable

Database: "BEAS_FTPOS"."SHORTVARIANT"

DeliveryDate

Edm.DateTimeOffset

best date format: yyyy/mm/dd hh:mm in 24 hour format

Time format with am/pm not working.

fertigungsposition.htm

Integration hub: Importable

Database: "BEAS_FTPOS"."LIEFERDATUM"

AssignedToLineNumber

Edm.Int32

Linked to father item

Example:

A1 (Level = 1, BEAS_FTPOS.BELPOS_ID=10)

|- Material A2 (BEAS_FTSTL.BELPOS_ID=10, BEAS_FTSTL.POS_ID=50)

|- Assembly A2 (Level = 2, BEAS_FTPOS.BELPOS_ID=20, ZU_BELPOS_ID=10, ZU_POS_ID=50)

fertigungsposition.htm

Database: "BEAS_FTPOS"."ZU_BELPOS_ID"

SchemaId

Edm.String(20)

fertigungsposition.htm

Integration hub: Importable

Database: "BEAS_FTPOS"."SCHEMA_ID"

Closed

Edm.Boolean

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

Confirmed

Edm.Boolean

Constraints:

Yes=1

No=0

fertigungsposition.htm

Integration hub: Importable

Database: coalesce("BEAS_FTPOS"."Confirmed",1)

ChangeAllow

Edm.Boolean

Constraints:

Yes=1

No=0

fertigungsposition.htm

Integration hub: Importable

Database: coalesce("BEAS_FTPOS"."CanModifyWo",1)

MaterialPlanning

Edm.Boolean

Constraints:

Yes=1

No=0

fertigungsposition.htm

Integration hub: Importable

Database: coalesce("BEAS_FTPOS"."STARTDISPOSITION",1)

MaterialBooking

Edm.Boolean

Constraints:

Yes=1

No=0

fertigungsposition.htm

Integration hub: Importable

Database: coalesce("BEAS_FTPOS"."STARTBOOKING",1)

CapacityPlanning

Edm.Boolean

Constraints:

Yes=1

No=0

fertigungsposition.htm

Integration hub: Importable

Database: coalesce("BEAS_FTPOS"."STARTCAPACITYPLANUNG",1)

MaterialPlanning

Edm.Boolean

Constraints:

Yes=1

No=0

fertigungsposition.htm

Integration hub: Importable

Database: coalesce("BEAS_FTPOS"."STARTDISPOSITION",1)

LoginToWorkOrder

Edm.Boolean

Constraints:

Yes=1

No=0

fertigungsposition.htm

Integration hub: Importable

Database: coalesce("BEAS_FTPOS"."STARTTIMEREQUEST",1)

UDF1

Edm.String(50)

fertigungsposition.htm

Integration hub: Importable

Database: "BEAS_FTPOS"."UDF1"

UDF2

Edm.String(50)

fertigungsposition.htm

Integration hub: Importable

Database: "BEAS_FTPOS"."UDF2"

UDF3

Edm.String(50)

fertigungsposition.htm

Integration hub: Importable

Database: "BEAS_FTPOS"."UDF3"

UDF4

Edm.String(50)

fertigungsposition.htm

Integration hub: Importable

Database: "BEAS_FTPOS"."UDF4"

Relations

Join to Entiy Object	Relation
RawMaterial	RawMaterialId
Item	ItemCode
UoM	UoMCode=UoMWareHouseId
UoMConsumption	UoMCode=UoMConsumptionId
WareHouse	WhsCode
Workorder	DocEntry
WorkorderBom	DocEntry,LineNum
WorkorderRouting	DocEntry,LineNumber
WorkorderSerialNumberReservation	DocEntry,LineNumber

Functions

Function

Parameter

Description

GetNextBatchNumber

DocEntry/i,LineNumber/i

CutOffQuantity

ItemCode/s,Quantity/i

Barcode

DocEntry/i,LineNumber/i

RefreshQuantiy

DocEntry/i,LineNumber/i

CanModify

DocEntry/i,LineNumber/i

Return Quantity with Count of decimal places

WorkorderPos(1038,10)?$select=QuantityConsumptionUoM,UoMConsumptionId,UoMConsumption/ConsumptionRoundDec

{
    
    "value": 
         {
        "QuantityConsumptionUoM": 55,
        "UoMConsumptionId": "Pcs",
        "ConsumptionRoundDec": 3
        }
    
}