Entity Relation: QCOrder -> DocEntry

Integration hub: Importable

Mandatory field

Primary key

Database: "BEAS_QSFTPOS"."DocEntry"

Mandatory field

Primary key

Database: "BEAS_QSFTPOS"."CHARGE_ID"

Mandatory field

Primary key

Database: "BEAS_QSFTPOS"."BELNR_ID"

Integration hub: Importable

Mandatory field

Primary key

Database: "BEAS_QSFTPOS"."KND_ID"

Integration hub: Importable

Mandatory field

Primary key

Database: "BEAS_QSFTPOS"."POS_ID"

Database: "BEAS_QSFTPOS"."POS_TEXT"

Database: "BEAS_QSFTPOS"."SORT_ID"

Database: "BEAS_QSFTPOS"."BITMAP"

Database: "BEAS_QSFTPOS"."COLORID"

Define the list for all possible valuations. User can choose this by dropdown list

every value is defined in one line (delimiter = CR LF)

Database: "BEAS_QSFTPOS"."QCPickList"

Database: "BEAS_QSFTPOS"."FERT_BELNR_ID"

Database: "BEAS_QSFTPOS"."FERT_BELPOS_ID"

Database: "BEAS_QSFTPOS"."FERT_POS_ID"

Database: "BEAS_QSFTPOS"."GROUP_ID"

Database: rtrim("BEAS_QSFTPOS"."QS_ID")

Database: "BEAS_QSFTPOS"."BEZ"

Define the needed resource (tool)

only for info

Linked table: BEAS_WKZ

Linked column: WKZ_ID

Database: "BEAS_QSFTPOS"."WKZ_ID"

Define the list for all possible valuations. User can choose this by dropdown list

every value is defined in one line (delimiter = CR LF)

Database: "BEAS_QSFTPOS"."QCPickList"

Type of measurement input

Constraints:

Measurement=

Attribut=L

Text=T

Database: "BEAS_QSFTPOS"."TYP"

Database: case when "BEAS_QSFTPOS"."DRUCKKZ" = 'J' then 1 else 0 end

Database: "BEAS_QSFTPOS"."MINIMAL"

Database: coalesce("BEAS_QSFTPOS"."MAXIMAL",999999)

Database: "BEAS_QSFTPOS"."SOLLWERT"

Entity Relation: UoM -> UoMCode

Database: rtrim("BEAS_QSFTPOS"."ME_ID")

Database: case when "BEAS_QSFTPOS"."RELEVANT" = 'J' then 1 else 0 end

System release this autoatically, if

- the user insert the MeasurementString or define this with setValue() and

and the value is between Minimal and Maximal value or it's only a text information

and the BlockReason don't block the Release

It can be changed manually with PUT or setOK(), if

MeasurementOKManual is true and BlockReason don't block the release

Database: case when "BEAS_QSFTPOS"."OK"='J' then 1 else 0 end

Database: "BEAS_QSFTPOS"."ManualRelease"

Return the Measurement value as number

For String values, the system return always 0

This field is changeable with PUT command

Count of decimal: Defined in UoM related to this Measurement Position

The system fill automatically the MeasurementString

Never send MeasurementString AND MeasurementNumber, otherwise the system check the value 2 times.

If possible, use MeasurementString

Integration hub: Importable

Database: "BEAS_QSFTPOS"."MESSWERT"

Return the Measurement value as String

If this is a number, it return the information as the user inserted the value

It's possible to change this entry with

function setValue()

PUT MeasurementString

If the value a number, you can use comma or point as decimal delimiter

Allowed is 5.123 and 5,123

In UoM the count of decimal places defined. If you insert more then defined UoM, the system will ignore this.

If you change this field, the system fill the MeasurementNumber automatically and check, if a release of the position is possible.

Integration hub: Importable

Database: "BEAS_QSFTPOS"."MESSWERTC"

Database: "BEAS_QSFTPOS"."MeasurementPersId"

Database: "BEAS_QSFTPOS"."MeasurementPersName"

Database: "BEAS_QSFTPOS"."MeasurementStationId"

Database: "BEAS_QSFTPOS"."MeasurementDate"

Linked table: BEAS_QSVALUATION

Linked column: ValuationId

Integration hub: Importable

Database: "BEAS_QSFTPOS"."ValuationId"

Integration hub: Importable

Database: "BEAS_QSFTPOS"."ValuationText"

Linked table: BEAS_QSSPERRGRUND

Linked column: SPERRGRUNDID

Integration hub: Importable

Database: "BEAS_QSFTPOS"."SPERRGRUNDID"

Integration hub: Importable

Database: "BEAS_QSFTPOS"."SPERRGRUND"

Database: "BEAS_QSFTPOS"."ReleaseAutomatic"

valid values for

- Yes: Y,J,1

- No: N,0

Constraints:

Yes=1

No=0

Integration hub: Importable

Database: "BEAS_QSFTPOS"."Release"

Database: "BEAS_QSFTPOS"."ReleasePersId"

Database: "BEAS_QSFTPOS"."ReleasePersName"

Database: "BEAS_QSFTPOS"."ReleaseStationId"

Database: "BEAS_QSFTPOS"."ReleaseDate"

Database: "BEAS_QSFTPOS"."BILD1"

Database: "BEAS_QSFTPOS"."BILD2"

Database: "BEAS_QSFTPOS"."BILD3"

Integration hub: Importable

Database: "BEAS_QSFTPOS"."UDF1"

Integration hub: Importable

Database: "BEAS_QSFTPOS"."UDF2"

Integration hub: Importable

Database: "BEAS_QSFTPOS"."UDF3"

Integration hub: Importable

Database: "BEAS_QSFTPOS"."UDF4"

Database: "BEAS_QSFTPOS"."ANDTSTAMP"

Database: "BEAS_QSFTPOS"."ANDUSER"

With this function you can set the Measurement Value (Property MeasurementString) directly

if you want to set a number, you can use point or comma as decimal delimiter

The system use automatically the count of decimal places defined in UoM.

set the OK flag of defined measurement position

Do it only, if

set the Measurement position to released

Only possible, if ok flag is released (correct value inside and / or ok-flag released

See setOK() and setValue()

you need to execute this only, if releaseManual is not activated

if releaseManual is not activated, only another personnel can activate this (4 eyes concept)