NOTE:
In this table documents for different sources are saved.
For detailed information on how to import see Data Integration Hub and Source-Target-Link.
Settings for import Item Version documents:
Column
|
Type
|
Link
|
Link Type
|
Default
|
itemversion
|
Reference 1
|
From table
|
item code
|
Reference 2
|
From table
|
item version
|
Reference 3
|
No
|
|
LineId
|
No / FromTable
|
Line Number.
Defined only if you want to update a line.
If 0, the system creates a new line.
Note:
If the user deletes a document in the program, the system does not delete the entry, but marks it as invisible. If you update the line, you must disable the invisible flag (invisible=0)
|
Note:
You must save the link of the original file name.
The file must be in a shared folder.
The system does not create a copy of the file if you import the data - it only provides a link to the file.
For more information see Detailed documentation.
Field
|
Name
|
M
|
Type
|
Description
|
TYP
|
Link Type
|
X
|
nvarchar(20)
|
define the linked object
Valid values: link to item Version=itemversion
|
ValueId
|
Reference 1
|
X
|
nvarchar(50)
|
Define the object
Itemversion: the ItemCode number, linked to BEAS_ITEM_VERSION
|
Value2Id
|
Reference 2
|
X
|
nvarchar(20)
|
Define the object
Itemversion: the A-Version number, linked to BEAS_ITEM_VERSION
|
Value3Id
|
Reference 3
|
X
|
nvarchar(20)
|
|
LINEID
|
Line ID
|
X
|
int(4)
|
Line Id.
Import: If 0 then next row
|
DESCRIPTION
|
Description
|
X
|
nvarchar(200)
|
|
SortId
|
Sorting
|
|
int(4)
|
|
BITMAPNAME
|
Icon
|
|
nvarchar(50)
|
|
COLORID
|
Color
|
|
int(4)
|
|
ViewVariant
|
View Type
|
|
int(4)
|
Describe the type of view
Valid values: Shell=0
Text=1
Bitmap Viewer=2
Script=3
|
DocumentTyp
|
Document Type
|
|
nvarchar(1)
|
Describe the type of document
Link to a file = A
Show text, which you can save in this document table: text
Valid values: Datei=A
Text=Text
|
FileNameInternal
|
File Name (real)
|
|
nvarchar(200)
|
beas create a copy of the file name
In this field you see the name of the copied file.
Import: Save the name in this field. The document must be in the attachment folder
|
FileName
|
File Name (orginal)
|
X
|
nvarchar(200)
|
This is the original file name, not real file name
The file name self saved in FileNameInternal
|
QcReleased
|
Plan Release
|
|
int(4)
|
Valid values: yes=1
no=0
|
QcReleasedFromUser
|
Release by User ID
|
|
int(4)
|
|
QcReleasedFromUserName
|
Release by User Name
|
|
nvarchar(50)
|
|
QcReleasedDate
|
Release Date
|
|
datetime(8)
|
best date format: yyyy/mm/dd hh:mm in 24 hour format
Time format with am/pm not working.
|
FilePath
|
File Directory
|
|
nvarchar(200)
|
|
UDF1
|
Userfield 1
|
|
nvarchar(50)
|
|
UDF2
|
Userfield 2
|
|
nvarchar(50)
|
|
UDF3
|
Userfield 3
|
|
nvarchar(50)
|
|
UDF4
|
Userfield 4
|
|
nvarchar(50)
|
|
Category
|
Category
|
|
nvarchar(20)
|
|
QcVersion
|
Version
|
|
nvarchar(20)
|
|
Help URL: https://help.beascloud.com/beas202402/index.html?dih-item-version-documentation.htm
|