Name
|
Type
|
Description
|
DocEntry
|
Edm.Int32
|
Entity Relation: QCOrder -> DocEntry
Integration hub: Importable
Mandatory field
Primary key
Database: "BEAS_QSFTPOS"."DocEntry"
|
|
DocOrder
|
Edm.String(20)
|
Mandatory field
Primary key
Database: "BEAS_QSFTPOS"."CHARGE_ID"
|
|
DocOrder2
|
Edm.Int32
|
Mandatory field
Primary key
Database: "BEAS_QSFTPOS"."BELNR_ID"
|
|
LineNumber
|
Edm.String(20)
|
Integration hub: Importable
Mandatory field
Primary key
Database: "BEAS_QSFTPOS"."KND_ID"
|
|
LineNumber2
|
Edm.Int32
|
Integration hub: Importable
Mandatory field
Primary key
Database: "BEAS_QSFTPOS"."POS_ID"
|
|
PosText
|
Edm.String(20)
|
Database: "BEAS_QSFTPOS"."POS_TEXT"
|
|
Sort
|
Edm.Int32
|
Database: "BEAS_QSFTPOS"."SORT_ID"
|
|
Bitmap
|
Edm.String(20)
|
Database: "BEAS_QSFTPOS"."BITMAP"
|
|
Color
|
Edm.Int32
|
Database: "BEAS_QSFTPOS"."COLORID"
|
|
QCPickList
|
Edm.String(255)
|
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"
|
|
WoDocEntry
|
Edm.Int32
|
Database: "BEAS_QSFTPOS"."FERT_BELNR_ID"
|
|
WoLineNumber
|
Edm.Int32
|
Database: "BEAS_QSFTPOS"."FERT_BELPOS_ID"
|
|
WoLineNumber2
|
Edm.Int32
|
Database: "BEAS_QSFTPOS"."FERT_POS_ID"
|
|
QCGroupId
|
Edm.String(20)
|
Database: "BEAS_QSFTPOS"."GROUP_ID"
|
|
QCDescription
|
Edm.String(255)
|
Database: rtrim("BEAS_QSFTPOS"."QS_ID")
|
|
QCInfo
|
Edm.String(255)
|
Database: "BEAS_QSFTPOS"."BEZ"
|
|
ResourceId
|
Edm.String(20)
|
Define the needed resource (tool)
only for info
Linked table: BEAS_WKZ
Linked column: WKZ_ID
Database: "BEAS_QSFTPOS"."WKZ_ID"
|
|
AttributeSelection
|
Edm.String(255)
|
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
|
Edm.String(1)
|
Type of measurement input
Constraints:
Measurement=
Attribut=L
Text=T
Database: "BEAS_QSFTPOS"."TYP"
|
|
PrintRelevant
|
Edm.Boolean
|
Database: case when "BEAS_QSFTPOS"."DRUCKKZ" = 'J' then 1 else 0 end
|
|
Minimal
|
Edm.Int32
|
Database: "BEAS_QSFTPOS"."MINIMAL"
|
|
Maximum
|
Edm.Int32
|
Database: coalesce("BEAS_QSFTPOS"."MAXIMAL",999999)
|
|
DesiredValue
|
Edm.Int32
|
Database: "BEAS_QSFTPOS"."SOLLWERT"
|
|
UoMCode
|
Edm.String(20)
|
Entity Relation: UoM -> UoMCode
Database: rtrim("BEAS_QSFTPOS"."ME_ID")
|
|
Relevant
|
Edm.Boolean
|
Database: case when "BEAS_QSFTPOS"."RELEVANT" = 'J' then 1 else 0 end
|
|
MeasurementOK
|
Edm.Boolean
|
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
|
|
MeasurementOKManual
|
Edm.Boolean
|
Database: "BEAS_QSFTPOS"."ManualRelease"
|
|
MeasurementNumber
|
Edm.Int32
|
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"
|
|
MeasurementString
|
Edm.String(255)
|
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"
|
|
MeasurementPersonellId
|
Edm.String(20)
|
Database: "BEAS_QSFTPOS"."MeasurementPersId"
|
|
MeasurementPersonellName
|
Edm.String(50)
|
Database: "BEAS_QSFTPOS"."MeasurementPersName"
|
|
MeasurementStationId
|
Edm.String(20)
|
Database: "BEAS_QSFTPOS"."MeasurementStationId"
|
|
MeasurementDate
|
Edm.DateTimeOffset
|
Database: "BEAS_QSFTPOS"."MeasurementDate"
|
|
ValuationId
|
Edm.String(20)
|
Linked table: BEAS_QSVALUATION
Linked column: ValuationId
Integration hub: Importable
Database: "BEAS_QSFTPOS"."ValuationId"
|
|
ValuationText
|
Edm.String(255)
|
Integration hub: Importable
Database: "BEAS_QSFTPOS"."ValuationText"
|
|
BlockageReasonId
|
Edm.String(20)
|
Linked table: BEAS_QSSPERRGRUND
Linked column: SPERRGRUNDID
Integration hub: Importable
Database: "BEAS_QSFTPOS"."SPERRGRUNDID"
|
|
BlockageReasonText
|
Edm.String(16000)
|
Integration hub: Importable
Database: "BEAS_QSFTPOS"."SPERRGRUND"
|
|
ReleaseAutomatic
|
Edm.Boolean
|
Database: "BEAS_QSFTPOS"."ReleaseAutomatic"
|
|
Release2
|
Edm.Boolean
|
valid values for
- Yes: Y,J,1
- No: N,0
Constraints:
Yes=1
No=0
Integration hub: Importable
Database: "BEAS_QSFTPOS"."Release"
|
|
ReleasePersonnelId
|
Edm.String(20)
|
Database: "BEAS_QSFTPOS"."ReleasePersId"
|
|
ReleasePersName
|
Edm.String(20)
|
Database: "BEAS_QSFTPOS"."ReleasePersName"
|
|
ReleaseStationId
|
Edm.String(20)
|
Database: "BEAS_QSFTPOS"."ReleaseStationId"
|
|
ReleaseDate
|
Edm.DateTimeOffset
|
Database: "BEAS_QSFTPOS"."ReleaseDate"
|
|
Picture1
|
Edm.String(100)
|
Database: "BEAS_QSFTPOS"."BILD1"
|
|
Picture2
|
Edm.String(100)
|
Database: "BEAS_QSFTPOS"."BILD2"
|
|
Picture3
|
Edm.String(100)
|
Database: "BEAS_QSFTPOS"."BILD3"
|
|
UDF1
|
Edm.String(100)
|
Integration hub: Importable
Database: "BEAS_QSFTPOS"."UDF1"
|
|
UDF2
|
Edm.String(100)
|
Integration hub: Importable
Database: "BEAS_QSFTPOS"."UDF2"
|
|
UDF3
|
Edm.String(100)
|
Integration hub: Importable
Database: "BEAS_QSFTPOS"."UDF3"
|
|
UDF4
|
Edm.String(100)
|
Integration hub: Importable
Database: "BEAS_QSFTPOS"."UDF4"
|
|
LastChangeDate
|
Edm.DateTimeOffset
|
Database: "BEAS_QSFTPOS"."ANDTSTAMP"
|
|
LastChangeUserId
|
Edm.String(20)
|
Database: "BEAS_QSFTPOS"."ANDUSER"
|
|