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