QCInspectionPlan

QCInspectionPlan

 

Property

Description

Table

BEAS_QSARTIKELHAUPT

Primary key

QCInspectionPlanId/c

$transaction

no

$branch

no

$mask

no

 

Fields

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"