GET

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

Quantity

Edm.Int32

fertigungsposition.htm

Linked table: BEAS_ME

Linked column: ME_ID

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

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

Database: "BEAS_FTPOS"."MENGE"

QuantityScrap

Edm.Decimal

fertigungsposition.htm

Integration hub: Importable

Database: "BEAS_FTPOS"."MENGE_VERSCHNITT"

QuantityProduced

Edm.Decimal

fertigungsposition.htm

Database: "BEAS_FTPOS"."GEL_MENGE"

UoMWareHouseId

Edm.String(20)

fertigungsposition.htm

Linked table: BEAS_ME

Linked column: ME_ID

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(203)

fertigungsposition.htm

Integration hub: Importable

Database: "BEAS_FTPOS"."BINCODE"

ProductionLine

Edm.String(50)

Database: "BEAS_FTPOS"."WMS_PRODLINE"

BaseType

Edm.String(1)

Constraints:

Kundenauftrag=K

Vorausrechnung=V

Fertigung=F

nein=

 

fertigungsposition.htm

Database: "BEAS_FTPOS"."BaseType"

BaseDocEntry

Edm.Int32

Base Entry

To Sales Order: RDR1.DocEntry

To PreInvouce: INV1.DocEntry

fertigungsposition.htm

Integration hub: Importable

Database: "BEAS_FTPOS"."AUFTRAGINT"

BaseDocNum

Edm.Int32

fertigungsposition.htm

Integration hub: Importable

Database: "BEAS_FTPOS"."BaseDocNum"

BaseLineNumber

Edm.Int32

fertigungsposition.htm

Integration hub: Importable

Database: "BEAS_FTPOS"."BaseLine"

BaseLineNumber2

Edm.Int32

fertigungsposition.htm

Integration hub: Importable

Database: "BEAS_FTPOS"."BASELINE2"

BaseWhsCode

Edm.String(20)

Database: "BEAS_FTPOS"."BaseWhsCode"

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)

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"

UDF5

Edm.String(50)

fertigungsposition.htm

Integration hub: Importable

Database: "BEAS_FTPOS"."UDF5"

UDF6

Edm.String(50)

fertigungsposition.htm

Integration hub: Importable

Database: "BEAS_FTPOS"."UDF6"

UDF7

Edm.String(50)

fertigungsposition.htm

Integration hub: Importable

Database: "BEAS_FTPOS"."UDF7"

UDF8

Edm.String(50)

fertigungsposition.htm

Integration hub: Importable

Database: "BEAS_FTPOS"."UDF8"

UDF9

Edm.String(50)

fertigungsposition.htm

Integration hub: Importable

Database: "BEAS_FTPOS"."UDF9"

UDF10

Edm.String(50)

fertigungsposition.htm

Integration hub: Importable

Database: "BEAS_FTPOS"."UDF10"

UDF11

Edm.String(50)

fertigungsposition.htm

Integration hub: Importable

Database: "BEAS_FTPOS"."UDF11"

UDF12

Edm.String(50)

fertigungsposition.htm

Integration hub: Importable

Database: "BEAS_FTPOS"."UDF12"

UDF13

Edm.String(50)

fertigungsposition.htm

Integration hub: Importable

Database: "BEAS_FTPOS"."UDF13"

UDF14

Edm.String(50)

fertigungsposition.htm

Integration hub: Importable

Database: "BEAS_FTPOS"."UDF14"

UDF15

Edm.String(50)

fertigungsposition.htm

Integration hub: Importable

Database: "BEAS_FTPOS"."UDF15"

 

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

RefreshQuantity

DocEntry/i,LineNumber/i

CanModify

DocEntry/i,LineNumber/i

SerialNumberReservation

DocEntry/i,LineNumber/i

GetDefaultWareHouse

ItemCode/c,WhsCode/c,FromWhsCode/c,CardCode/c,PrjdCode/c,QCId/c

WipClear

DocEntry/i,LineNumber/i

Close

DocEntry/i,LineNumber/i

Print

DocEntry/i,LineNumber/i,OutputType/c,Printer/c,SetPrintFlag/b

GetSubPositions

DocEntry/i,LineNumber/i

ReCalculateTimes

DocEntry/i,LineNumber/i,SchemaId/c

 

Return Quantity with Count of decimal places

 

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

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