GET

Workorder

 

Property

Description

Table

BEAS_FTHAUPT

Primary key

DocEntry/i

$transaction

yes

$branch

yes

$mask

For dropdown you can use follow mask definition:
1: DocEntry,DocNum,CardCode,CardName
You can define follow filter:
&$filter=DocEntry eq
 

 

Fields

Name

Type

Description

DocEntry

Edm.Int32

Entity Relation: WorkorderPos -> DocEntry

Document number (numeric)

import: insert "0" as default value

fertigungbeleg_feldbeschreibun.htm

Integration hub: Importable

Mandatory field

Primary key

Database: "BEAS_FTHAUPT"."BELNR_ID"

DocNum

Edm.String(20)

fertigungbeleg_feldbeschreibun.htm

Integration hub: Importable

Database: "BEAS_FTHAUPT"."AUFTRAG"

DocDate

Edm.DateTimeOffset

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

Time format with am/pm not working.

fertigungbeleg_feldbeschreibun.htm

Integration hub: Importable

Database: "BEAS_FTHAUPT"."BELDAT"

DeliveryDate

Edm.DateTimeOffset

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

Time format with am/pm not working.

fertigungbeleg_feldbeschreibun.htm

Integration hub: Importable

Database: "BEAS_FTHAUPT"."LFGDAT"

CardCode

Edm.String(20)

Entity Relation: BusinessPartner -> CardCode

Database: rtrim("BEAS_FTHAUPT"."KND_ID")

CardName

Edm.String(100)

fertigungbeleg_feldbeschreibun.htm

Integration hub: Importable

Database: "BEAS_FTHAUPT"."KNDNAME"

MailAddres

Edm.String(50)

fertigungbeleg_feldbeschreibun.htm

Integration hub: Importable

Database: "BEAS_FTHAUPT"."KNDSTRASSE"

MailZipCod

Edm.String(10)

fertigungbeleg_feldbeschreibun.htm

Integration hub: Importable

Database: "BEAS_FTHAUPT"."KNDPLZ"

MailCitiy

Edm.String(50)

fertigungbeleg_feldbeschreibun.htm

Integration hub: Importable

Database: "BEAS_FTHAUPT"."KNDORT"

MailCountry

Edm.String(30)

fertigungbeleg_feldbeschreibun.htm

Integration hub: Importable

Database: "BEAS_FTHAUPT"."KNDLAND"

Phone1

Edm.String(50)

fertigungbeleg_feldbeschreibun.htm

Integration hub: Importable

Database: "BEAS_FTHAUPT"."KNDTELEFON1"

Lock

Edm.Int32

Constraints:

Yes=J

No=N

fertigungbeleg_feldbeschreibun.htm

Integration hub: Importable

Database: case when coalesce("BEAS_FTHAUPT"."SPERRUNG",'')='J' then 1 else 0 end

Closed

Edm.Int32

Default Value: N

Constraints:

Yes=J

No=N

fertigungbeleg_feldbeschreibun.htm

Integration hub: Importable

Database: case when coalesce("BEAS_FTHAUPT"."ABGKZ",'')='J' then 1 else 0 end

PriorityCode

Edm.String(20)

Database: rtrim("BEAS_FTHAUPT"."PRIOR_ID")

StartDate

Edm.DateTimeOffset

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

Time format with am/pm not working.

fertigungbeleg_feldbeschreibun.htm

Integration hub: Importable

Database: "BEAS_FTHAUPT"."ANFZEIT"

EndDate

Edm.DateTimeOffset

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

Time format with am/pm not working.

fertigungbeleg_feldbeschreibun.htm

Integration hub: Importable

Database: "BEAS_FTHAUPT"."ENDZEIT"

PrintStatus

Edm.Int32

Constraints:

Yes=J

No=N

 

fertigungbeleg_feldbeschreibun.htm

Integration hub: Importable

Database: case when coalesce("BEAS_FTHAUPT"."DRUCKKZ",'')='J' then 1 else 0 end

ItemCode

Edm.String(50)

Entity Relation: Item -> ItemCode

Database: rtrim("BEAS_FTHAUPT"."ItemCode")

OrderBitmap

Edm.String(50)

Database: COALESCE ("BEAS_FTHAUPT"."BITMAPCLOSE", 'bmp/project_yellow.png')

PlannedTime

Edm.Int32

Database: COALESCE ((select sum((((Coalesce(r."THAPLATZ",0) + Coalesce(r."TNAPLATZ",0) + Coalesce(r."TEAPLATZ",0)) * case when Coalesce(r."MENGE_JE",-1)=0 then 1 else ((p."MENGE_VERBRAUCH" + Coalesce(p."MENGE_VERSCHNITT",0)) / case when Coalesce(r."MENGE_JE",

WorkTime

Edm.Int32

Database: COALESCE ("BEAS_FTHAUPT"."WORKTIME",0)

ReservedTime

Edm.Int32

Database: COALESCE ((select sum("BEAS_RESOURCEN"."ZEIT") from "BEAS_RESOURCEN" where "BEAS_RESOURCEN"."BELNR_ID"="BEAS_FTHAUPT"."BELNR_ID"),0)

ProductionTypeId

Edm.String(20)

fertigungbeleg_feldbeschreibun.htm

Linked table: BEAS_FTTYP

Linked column: FTTYP

Integration hub: Importable

Database: "BEAS_FTHAUPT"."TYP"

PrjCode

Edm.String(20)

fertigungbeleg_feldbeschreibun.htm

Integration hub: Importable

Database: "BEAS_FTHAUPT"."Project"

PrjUID

Edm.Int32

fertigungbeleg_feldbeschreibun.htm

Integration hub: Importable

Database: "BEAS_FTHAUPT"."PRJUID"

WorkorderStatus

Edm.String(20)

fertigungbeleg_feldbeschreibun.htm

Integration hub: Importable

Database: "BEAS_FTHAUPT"."STATUS_ID"

BranchId

Edm.Int32

Entity Relation: Branch -> BranchId

fertigungbeleg_feldbeschreibun.htm

Database: "BEAS_FTHAUPT"."BPLId"

Locked

Edm.Boolean

Database: case when "BEAS_FTHAUPT"."SPERRUNG"='J' then 1 else 0 end

UDF1

Edm.String(50)

fertigungbeleg_feldbeschreibun.htm

Integration hub: Importable

Database: "BEAS_FTHAUPT"."UDF1"

UDF2

Edm.String(50)

fertigungbeleg_feldbeschreibun.htm

Integration hub: Importable

Database: "BEAS_FTHAUPT"."UDF2"

UDF3

Edm.String(50)

fertigungbeleg_feldbeschreibun.htm

Integration hub: Importable

Database: "BEAS_FTHAUPT"."UDF3"

UDF4

Edm.String(50)

fertigungbeleg_feldbeschreibun.htm

Integration hub: Importable

Database: "BEAS_FTHAUPT"."UDF4"

UDF5

Edm.String(50)

fertigungbeleg_feldbeschreibun.htm

Integration hub: Importable

Database: "BEAS_FTHAUPT"."UDF5"

UDF6

Edm.String(50)

fertigungbeleg_feldbeschreibun.htm

Integration hub: Importable

Database: "BEAS_FTHAUPT"."UDF6"

UDF7

Edm.String(50)

fertigungbeleg_feldbeschreibun.htm

Integration hub: Importable

Database: "BEAS_FTHAUPT"."UDF7"

UDF8

Edm.String(50)

fertigungbeleg_feldbeschreibun.htm

Integration hub: Importable

Database: "BEAS_FTHAUPT"."UDF8"

UDF9

Edm.String(50)

fertigungbeleg_feldbeschreibun.htm

Integration hub: Importable

Database: "BEAS_FTHAUPT"."UDF9"

UDF10

Edm.String(50)

fertigungbeleg_feldbeschreibun.htm

Integration hub: Importable

Database: "BEAS_FTHAUPT"."UDF10"

UDF11

Edm.String(50)

fertigungbeleg_feldbeschreibun.htm

Integration hub: Importable

Database: "BEAS_FTHAUPT"."UDF11"

UDF12

Edm.String(50)

fertigungbeleg_feldbeschreibun.htm

Integration hub: Importable

Database: "BEAS_FTHAUPT"."UDF12"

UDF13

Edm.String(50)

fertigungbeleg_feldbeschreibun.htm

Integration hub: Importable

Database: "BEAS_FTHAUPT"."UDF13"

UDF14

Edm.String(50)

fertigungbeleg_feldbeschreibun.htm

Integration hub: Importable

Database: "BEAS_FTHAUPT"."UDF14"

UDF15

Edm.String(50)

fertigungbeleg_feldbeschreibun.htm

Integration hub: Importable

Database: "BEAS_FTHAUPT"."UDF15"

 

Relations

Join to Entiy Object

Relation

Item

ItemCode

BusinessPartner

CardCode

Branch

BranchId

WorkorderPos

DocEntry

ProductionType

ProductionTypeId=ProductionTypeId

 

Functions

Function

Parameter

Description

CheckBarcode

BarCode/c

Search in Routing, Bill of Material and Work order position for the Number

a) Barcode

b) DocEntry Number

c) DocEntry Number/Line Number

e) DocNumber (BEAS_FTHAUPT.AUFTRAG)

 

Support $transaction=receiptwo, issuewo, timereceipt

If you define $transaction, the system return only entries, which allowed for this process

 

Support all $format formats

 

Function call


Workorder/CheckBarcode("String")

Result


{
    "value": [
        {
            "Type": "Workorder_Pos",
            "DocEntry": 1306,
            "LineNumber": 10,
            "LineNumber2": 0,
            "Position": "",
            "DocNumber": "WH000340",
            "ItemCode": "0815",
            "ItemName": "08FF001415-234"
            "BarCode": "08FF001415-234"
        }
    ]
}

BomByBarcode

BarCode/c