For detailed information on how to import see Data Integration Hub and Source-Target-Link.
Data import is also possible if no header data is created. The header data is created automatically.
During an update, positions can only be added or changed, but not deleted.
Field
|
Name
|
M
|
Type
|
Description
|
ItemCode
|
QS-Plan-ID
|
X
|
nvarchar(50)
|
|
POS_ID
|
Internal position ID
|
X
|
int(4)
|
|
POS_TEXT
|
QC measurement position
|
X
|
nvarchar(20)
|
|
SORT_ID
|
Sort ID
|
X
|
int(4)
|
|
RELEVANT
|
Check Relevant
|
|
nchar(1)
|
Valid values: Yes=J
No=N
|
DRUCKKZ
|
Print on Certificate
|
|
nchar(1)
|
Valid values: Yes=J
No=N
|
QS_ID
|
QC Order
|
X
|
nvarchar(50)
|
|
BEZ
|
Methodology
|
|
ntext(16000)
|
|
TYP
|
Type of input
|
X
|
nchar(1)
|
Valid values: Measurement=
Attribut=L
Text=T
|
BITMAP
|
Picture
|
|
nvarchar(50)
|
|
COLORID
|
Color
|
|
int(4)
|
|
WKZ_ID
|
Test tool
|
|
nvarchar(20)
|
|
GROUP_ID
|
QC Group
|
|
nvarchar(20)
|
|
SOLLWERT
|
Desired Value
|
|
numeric(4)
|
|
ME_ID
|
Unit of M.
|
|
nvarchar(20)
|
|
MINIMAL
|
Minimum
|
|
numeric(4)
|
|
MAXIMAL
|
Maximum
|
|
numeric(4)
|
|
ManualRelease
|
Manually on ok set allow
|
|
int(4)
|
|
ReleaseAutomatic
|
Aditional release deactivate
|
|
int(4)
|
|
CardCode
|
Business partner
|
|
nvarchar(50)
|
|
RuleId
|
Item rule
|
|
nvarchar(50)
|
|
OnlyAllPoReceipt
|
Only all x documents
|
|
int(4)
|
|
AllwaysAfterError
|
Always by error
|
|
int(4)
|
|
OnlyAllMeasuredPosition
|
Only all x samples
|
|
int(4)
|
|
SCRIPT
|
Script
|
|
nvarchar(0)
|
|
QCPickList
|
Attribute Selection
|
|
nvarchar(255)
|
for measurement type "attribute"
You can insert the attribut list, which the use can choose
one attribut per line
|
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
|
|
|
nvarchar(100)
|
|
UDF6
|
|
|
nvarchar(100)
|
|
UDF7
|
|
|
nvarchar(100)
|
|
UDF8
|
|
|
nvarchar(100)
|
|
UDF9
|
|
|
nvarchar(100)
|
|
UDF10
|
|
|
nvarchar(100)
|
|
UDF11
|
|
|
nvarchar(100)
|
|
UDF12
|
|
|
nvarchar(100)
|
|
UDF13
|
|
|
nvarchar(100)
|
|
UDF14
|
|
|
nvarchar(100)
|
|
UDF15
|
|
|
nvarchar(100)
|
|
Help URL: https://help.beascloud.com/beas202206/index.html?dih-qc-inspection-plan-measure.htm
|