Field
|
Name
|
M
|
Type
|
Description
|
ItemCode
|
QC Inspection Plan Id
|
X
|
nvarchar(50)
|
|
GROUPID
|
QC Group
|
|
nvarchar(20)
|
|
INFO
|
Information
|
|
nvarchar(255)
|
|
MESSUNG_ALLE_STK
|
Sample all x Inventory Uom
|
|
decimal(9)
|
create all x warehouse units a new sample
NULL or 0 = create only one sample
|
MESSUNG_ALLE_MIN
|
Sample per minutes
|
|
decimal(9)
|
|
QcPlanVersion
|
QC Plan Version
|
|
nvarchar(20)
|
|
PERSERIALNUMBER
|
Per serial number
|
|
int(4)
|
if activ then create one sample per serialnumber
Valid values: yes=1
no=0
|
RecordingType
|
Input
|
|
int(4)
|
Recording type
Define, if you record data by Sample, Test or both
Valid values: per sample=1
per Test=2
All=0
|
QcReleased
|
QC Plan Aproved
|
|
int(4)
|
Valid values: yes=1
no=0
|
QcReleasedDate
|
QC aproved date
|
|
datetime(8)
|
best date format: yyyy/mm/dd hh:mm in 24 hour format
Time format with am/pm not working.
|
QcReleasedFromUser
|
QC aproved by User ID
|
|
int(4)
|
|
QcReleasedFromUserName
|
QC aproved by User Name
|
|
nvarchar(50)
|
|
BITMAP
|
Picture
|
|
nvarchar(50)
|
|
COLORID
|
Color
|
|
int(4)
|
|
MeasuringRelease
|
Sample Release
|
|
int(4)
|
Valid values: automatic=0
manual only if ok=2
manual allways=3
|
MeasuringESignature
|
Sample Electronic signature
|
|
int(4)
|
|
ReleaseBatchnumStatus
|
Batch status release
|
|
int(4)
|
Valid values: manual=0
automatic=1
manual after release=2
|
TransferOnAllWhs
|
Transfer
|
|
int(4)
|
only transfer when ...
0=if item on a qc warehouse
1=allways
Valid values: Only from QC Warehouse=0
From all warehouse=1
|
TransferOnlyReleased
|
Transfer release
|
|
int(4)
|
|
OrderRelease
|
QC order Release
|
|
int(4)
|
Valid values: automatic=0
manual if ok=2
manual allways=3
|
OrderESignature
|
QC order electronic signature
|
|
int(4)
|
|
OrderEvaluationMandatory
|
Valuation
|
|
int(4)
|
|
TransferMandatory
|
Transfer / Batch release
|
|
int(4)
|
|
CloseOrderAutomatic
|
QC order automatically close
|
|
int(4)
|
|
MeasuringEvaluationMandatory
|
electronic signatur per Measurement mandatory
|
|
int(4)
|
|
SCRIPT
|
Release Instruction
|
|
ntext(8)
|
|
BILD1
|
Attachment 1
|
|
nvarchar(100)
|
|
BILD2
|
Attachment 2
|
|
nvarchar(100)
|
|
BILD3
|
Attachment 3
|
|
nvarchar(100)
|
|
UDF1
|
Userfield 1
|
|
nvarchar(100)
|
|
UDF2
|
Userfield 2
|
|
nvarchar(100)
|
|
UDF3
|
Userfield 3
|
|
nvarchar(100)
|
|
UDF4
|
Userfield 4
|
|
nvarchar(100)
|
|
UDF5
|
Userfield 5
|
|
nvarchar(100)
|
|
UDF6
|
Userfield 6
|
|
nvarchar(100)
|
|
UDF7
|
Userfield 7
|
|
nvarchar(100)
|
|
UDF8
|
Userfield 8
|
|
nvarchar(100)
|
|
UDF9
|
Userfield 9
|
|
nvarchar(100)
|
|
UDF10
|
Userfield 10
|
|
nvarchar(100)
|
|
UDF11
|
Userfield 11
|
|
nvarchar(100)
|
|
UDF12
|
Userfield 12
|
|
nvarchar(100)
|
|
UDF13
|
Userfield 13
|
|
nvarchar(100)
|
|
UDF14
|
Userfield 14
|
|
nvarchar(100)
|
|
UDF15
|
Userfield 15
|
|
nvarchar(100)
|
|