Field
|
Name
|
M
|
Type
|
Description
|
ItemCode
|
Bill of materials Id
|
X
|
nvarchar(60)
|
The id of bill of material list
It can be the same as the item but can have a own number
|
DESCRIPTION
|
Description
|
X
|
nvarchar(255)
|
Description for the bill of material definition
|
TYP
|
Type
|
|
nvarchar(20)
|
Valid values: standard=bom
|
RoutingId
|
Routing
|
|
nvarchar(50)
|
|
AccessGroup
|
Authorization group
|
|
nvarchar(20)
|
|
MatchCode
|
Match code
|
|
nvarchar(50)
|
|
ZNR
|
Drawing number
|
|
nvarchar(50)
|
|
ForItemCode
|
Linked to Item
|
|
nvarchar(50)
|
Describe, for which item you use this bill of material (linked to OITM)
|
Release
|
Release
|
|
int(4)
|
Valid values: yes=1
no=0
|
ReleaseDate
|
Release Date
|
|
datetime(8)
|
best date format: yyyy/mm/dd hh:mm in 24 hour format
Time format with am/pm not working.
|
ReleasePersName
|
Release From
|
|
nvarchar(50)
|
|
Block
|
Blocked
|
|
int(4)
|
Valid values: yes=1
no=0
|
BlockDate
|
Blocked Date
|
|
datetime(8)
|
best date format: yyyy/mm/dd hh:mm in 24 hour format
Time format with am/pm not working.
|
BlockName
|
Blocked Name
|
|
nvarchar(50)
|
|
BlockReason
|
Blocked Reason
|
|
nvarchar(50)
|
|
BITMAPNAME
|
Bitmap
|
|
nvarchar(50)
|
|
COLORID
|
Color
|
|
int(4)
|
|
Remarks
|
Remark
|
|
nvarchar(255)
|
|
ReleaseStationId
|
Release on Work station
|
|
nvarchar(20)
|
|
RevisionLevel
|
Revision Nummmer
|
|
nvarchar(30)
|
|
Version
|
Version
|
|
nvarchar(20)
|
Version field is not visible in the program
|
Status
|
Status
|
|
nvarchar(20)
|
Status field is not visible in the program
|
CanModify
|
|
|
int(4)
|
|
UDF1
|
Userfield 1
|
|
nvarchar(50)
|
|
UDF2
|
Userfield 2
|
|
nvarchar(50)
|
|
UDF3
|
Userfield 3
|
|
nvarchar(50)
|
|
UDF4
|
Userfield 4
|
|
nvarchar(50)
|
|
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)
|
|