QCOrderSamples

QCOrderSamples

 

Property

Description

Table

BEAS_QSFTMESSUNG

Primary key

DocEntry/i,LineNumber/i

$transaction

no

$branch

no

$mask

no

 

Fields

Name

Type

Description

DocEntry

Edm.Int32

Entity Relation: QCOrder -> DocEntry

Linked table: BEAS_QSFTHAUPT

Linked column: DocEntry

Integration hub: Importable

Database: "BEAS_QSFTMESSUNG"."DocEntry"

DocOrder

Edm.String(20)

Linked table: BEAS_QSFTHAUPT

Linked column: CHARGE_ID

Integration hub: Importable

Mandatory field

Primary key

Database: "BEAS_QSFTMESSUNG"."CHARGE_ID"

DocOrder2

Edm.Int32

Linked table: BEAS_QSFTHAUPT

Linked column: BELNR_ID

Integration hub: Importable

Mandatory field

Primary key

Database: "BEAS_QSFTMESSUNG"."BELNR_ID"

LineNumber

Edm.String(20)

Integration hub: Importable

Mandatory field

Primary key

Database: "BEAS_QSFTMESSUNG"."KND_ID"

WoDocEntry

Edm.Int32

Linked table: BEAS_FTPOS

Linked column: BELNR_ID

Integration hub: Importable

Database: "BEAS_QSFTMESSUNG"."FERT_BELNR_ID"

WoLineNumber

Edm.Int32

Integration hub: Importable

Database: "BEAS_QSFTMESSUNG"."FERT_BELPOS_ID"

WoLineNumber2

Edm.Int32

Integration hub: Importable

Database: "BEAS_QSFTMESSUNG"."FERT_POS_ID"

Release1

Edm.String(1)

Default Value: O

Constraints:

Open=O

Locked=E

Released=F

Manually Locked=I

Integration hub: Importable

Database: "BEAS_QSFTMESSUNG"."PRUEFKZ"

Release2

Edm.Boolean

For 4 eyes check

Need a second release from second person

Default Value: 0

Constraints:

Yes=1

No=0

Integration hub: Importable

Database: "BEAS_QSFTMESSUNG"."Release"

ReleasePersonnelId

Edm.String(20)

Database: "BEAS_QSFTMESSUNG"."ReleasePersId"

ReleasePersName

Edm.String(20)

Database: "BEAS_QSFTMESSUNG"."ReleasePersName"

ReleaseStationId

Edm.String(20)

Database: "BEAS_QSFTMESSUNG"."ReleaseStationId"

ReleaseDate

Edm.DateTimeOffset

Database: "BEAS_QSFTMESSUNG"."ReleaseDate"

ReleaseAutomatic

Edm.Boolean

Database: "BEAS_QSFTMESSUNG"."ReleaseAutomatic"

ValuationId

Edm.String(20)

Linked table: BEAS_QSVALUATION

Linked column: ValuationId

Integration hub: Importable

Database: "BEAS_QSFTMESSUNG"."ValuationId"

ValuationText

Edm.String(255)

Integration hub: Importable

Database: "BEAS_QSFTMESSUNG"."ValuationText"

BlockageReasonId

Edm.String(20)

Linked table: BEAS_QSSPERRGRUND

Linked column: SPERRGRUNDID

Integration hub: Importable

Database: "BEAS_QSFTMESSUNG"."SPERRGRUNDID"

BlockageReasonText

Edm.String(16000)

Linked table: BEAS_QSSPERRGRUND

Linked column: SPERRGRUNDID

Integration hub: Importable

Database: "BEAS_QSFTMESSUNG"."SPERRGRUND"

DistNumber

Edm.String(40)

Database: rtrim("BEAS_QSFTMESSUNG"."DistNumber")

SystemNumber

Edm.Int32

Database: "BEAS_QSFTMESSUNG"."SysNumber"

MeasurementUntested

Edm.Int32

Database: (select count(*) from "BEAS_QSFTPOS" where "BEAS_QSFTPOS"."CHARGE_ID"="BEAS_QSFTMESSUNG"."CHARGE_ID" AND "BEAS_QSFTPOS"."BELNR_ID"="BEAS_QSFTMESSUNG"."BELNR_ID" and "BEAS_QSFTPOS"."KND_ID"="BEAS_QSFTMESSUNG"."KND_ID" and Coalesce("BEAS_QSFTPOS"."Release",

MeasurementFaulty

Edm.Int32

Database: (select count(*) from "BEAS_QSFTPOS" where "BEAS_QSFTPOS"."CHARGE_ID"="BEAS_QSFTMESSUNG"."CHARGE_ID" AND "BEAS_QSFTPOS"."BELNR_ID"="BEAS_QSFTMESSUNG"."BELNR_ID" and "BEAS_QSFTPOS"."KND_ID"="BEAS_QSFTMESSUNG"."KND_ID" and Coalesce("BEAS_QSFTPOS"."Release",

MeasurementToRelease

Edm.Int32

Database: (select count(*) from "BEAS_QSFTPOS" where "BEAS_QSFTPOS"."CHARGE_ID"="BEAS_QSFTMESSUNG"."CHARGE_ID" AND "BEAS_QSFTPOS"."BELNR_ID"="BEAS_QSFTMESSUNG"."BELNR_ID" and "BEAS_QSFTPOS"."KND_ID"="BEAS_QSFTMESSUNG"."KND_ID" and Coalesce("BEAS_QSFTPOS"."OK",'N')=

MeasurementLastChange

Edm.DateTimeOffset

Database: (select max ("ANDTSTAMP") from "BEAS_QSFTPOS" where "BEAS_QSFTPOS"."CHARGE_ID"="BEAS_QSFTMESSUNG"."CHARGE_ID" and "BEAS_QSFTPOS"."BELNR_ID"="BEAS_QSFTMESSUNG"."BELNR_ID" and "BEAS_QSFTPOS"."KND_ID"="BEAS_QSFTMESSUNG"."KND_ID")

UDF1

Edm.String(50)

Integration hub: Importable

Database: "BEAS_QSFTMESSUNG"."UDF1"

UDF2

Edm.String(50)

Integration hub: Importable

Database: "BEAS_QSFTMESSUNG"."UDF2"

UDF3

Edm.String(50)

Integration hub: Importable

Database: "BEAS_QSFTMESSUNG"."UDF3"

UDF4

Edm.String(50)

Integration hub: Importable

Database: "BEAS_QSFTMESSUNG"."UDF4"

LastChangeDate

Edm.DateTimeOffset

Database: "BEAS_QSFTMESSUNG"."ANDTSTAMP"

LastChangeUserId

Edm.String(20)

Database: "BEAS_QSFTMESSUNG"."ANDUSER"

 

Relations

Join to Entiy Object

Relation

QCOrder

DocEntry

QCOrderMeasurement

DocEntry,LineNumber

 

Functions

Function

Parameter

Description

Release1

DocEntry/i,SampleId/c

Release "Release 1".

Not possible to release

- if not all measurement postiions are released

- block reasion is used, which don't allow the release

 

return 200 (OK) or 404 (not possible or error)

 


odata/Release1(1024,"2",10)

Release2

DocEntry/i,SampleId/c

Release "Release 2".

Not possible to release

- if not "Release 1" is released

- block reasion is used, which don't allow the release

 

return 200 (OK) or 404 (not possible or error)

 


odata/Release2(1024,"2",10)

 

With this object you can change all fields in QC Samples

4 eyes concept supported. For this we've 2 release functions.
With Release1() you can set the first Release Flag, If you want to change the Release1 to another values example "Manuel locked", "Open manually", then use the put command.

 

qcsamples

 

PUT Command

Follow fields changeable

UDF1...UDF4, BlockageReasonId,BloackageReasonText,ValuationId,ValuationText,Release1 and Release2

Example:

put QCOrderSamples(1407,"1")

{"BlockageReasonId":"WrongColor"}

 

Notes:

 
- Send parameter in correct order. First the Id and then the Text.

If you send an ID, the system insert the default Text information and with next property you can overwrite it

Example: Overwrite standard BlockageReason Text:

put QCOrderSamples(1407,"1")

{"BlockageReasonId":"WrongColor","BlockageReasonText":"This is my own Text"}