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