Name
|
Type
|
Description
|
QCInspectionPlanId
|
Edm.String(50)
|
Integration hub: Importable
Mandatory field
Database: "BEAS_QSARTIKELHAUPT"."ItemCode"
|
|
ValidFrom
|
Edm.DateTimeOffset
|
Database: "BEAS_QSARTIKELHAUPT"."GUELTIG_AB"
|
|
ValidTo
|
Edm.DateTimeOffset
|
Database: "BEAS_QSARTIKELHAUPT"."GUELTIG_BIS"
|
|
SampleAllPcs
|
Edm.Int32
|
create all x warehouse units a new sample
NULL or 0 = create only one sample
Integration hub: Importable
Database: "BEAS_QSARTIKELHAUPT"."MESSUNG_ALLE_STK"
|
|
SampleAllMinute
|
Edm.Int32
|
Integration hub: Importable
Database: "BEAS_QSARTIKELHAUPT"."MESSUNG_ALLE_MIN"
|
|
SamplePerSerial
|
Edm.Boolean
|
if activ then create one sample per serialnumber
Constraints:
yes=1
no=0
Integration hub: Importable
Database: "BEAS_QSARTIKELHAUPT"."PERSERIALNUMBER"
|
|
RecordingType
|
Edm.Int32
|
Recording type
Define, if you record data by Sample, Test or both
Constraints:
per sample=1
per Test=2
All=0
Integration hub: Importable
Database: "BEAS_QSARTIKELHAUPT"."RecordingType"
|
|
Info
|
Edm.String(255)
|
Integration hub: Importable
Database: "BEAS_QSARTIKELHAUPT"."INFO"
|
|
QCGroupId
|
Edm.String(20)
|
Integration hub: Importable
Database: "BEAS_QSARTIKELHAUPT"."GROUPID"
|
|
MeasuringRelease
|
Edm.Int32
|
Constraints:
automatic=0
manual only if ok=2
manual allways=3
Integration hub: Importable
Database: "BEAS_QSARTIKELHAUPT"."MeasuringRelease"
|
|
MeasuringESignature
|
Edm.Int32
|
If active, the user must insert his password if the user release the QC order
NOTE:
The ReleaseQcOrder() function can't ask for the password and can't check, if done.
The Front end must do it self
Integration hub: Importable
Database: "BEAS_QSARTIKELHAUPT"."MeasuringESignature"
|
|
MeasuringEvaluationMandatory
|
Edm.Int32
|
Integration hub: Importable
Database: "BEAS_QSARTIKELHAUPT"."MeasuringEvaluationMandatory"
|
|
ReleaseBatchnumStatus
|
Edm.Int32
|
Constraints:
manual=0
automatic=1
manual after release=2
Integration hub: Importable
Database: "BEAS_QSARTIKELHAUPT"."ReleaseBatchnumStatus"
|
|
OrderRelease
|
Edm.Int32
|
Constraints:
automatic=0
manual if ok=2
manual allways=3
Integration hub: Importable
Database: coalesce("BEAS_QSARTIKELHAUPT"."OrderRelease",0)
|
|
OrderESignature
|
Edm.Int32
|
Integration hub: Importable
Database: coalesce("BEAS_QSARTIKELHAUPT"."OrderESignature",0)
|
|
OrderEvaluationMandatory
|
Edm.Int32
|
Integration hub: Importable
Database: coalesce("BEAS_QSARTIKELHAUPT"."OrderEvaluationMandatory",0)
|
|
CloseOrderAutomatic
|
Edm.Int32
|
Integration hub: Importable
Database: coalesce("BEAS_QSARTIKELHAUPT"."CloseOrderAutomatic",0)
|
|
TransferMandatory
|
Edm.Int32
|
Integration hub: Importable
Database: coalesce("BEAS_QSARTIKELHAUPT"."TransferMandatory",0)
|
|
TransferOnlyReleased
|
Edm.Int32
|
Integration hub: Importable
Database: coalesce("BEAS_QSARTIKELHAUPT"."TransferOnlyReleased",0)
|
|
TransferOnAllWhs
|
Edm.Int32
|
only transfer when ...
0=if item on a qc warehouse
1=allways
Default Value: 0
Constraints:
Only from QC Warehouse=0
From all warehouse=1
Integration hub: Importable
Database: coalesce("BEAS_QSARTIKELHAUPT"."TransferOnAllWhs",0)
|
|
UDF1
|
Edm.String(100)
|
Integration hub: Importable
Database: "BEAS_QSARTIKELHAUPT"."UDF1"
|
|
UDF2
|
Edm.String(100)
|
Integration hub: Importable
Database: "BEAS_QSARTIKELHAUPT"."UDF2"
|
|
UDF3
|
Edm.String(100)
|
Integration hub: Importable
Database: "BEAS_QSARTIKELHAUPT"."UDF3"
|
|
UDF4
|
Edm.String(100)
|
Integration hub: Importable
Database: "BEAS_QSARTIKELHAUPT"."UDF4"
|
|