Field
|
Name
|
M
|
Type
|
Description
|
ItemCode
|
Routing ID
|
X
|
nvarchar(60)
|
|
ForItemCode
|
Linked with Item
|
|
nvarchar(50)
|
Linked to Items. It's only for information
|
DESCRIPTION
|
Description
|
X
|
nvarchar(255)
|
|
MatchCode
|
Match code
|
|
nvarchar(50)
|
|
TYP
|
Routing Type
|
|
nvarchar(20)
|
Type of routing. Current only "bom" allowed
Valid values: bill of material=bom
|
CanModify
|
Allow changes
|
|
int(4)
|
|
Release
|
Release
|
|
int(4)
|
|
Block
|
Blocked
|
|
int(4)
|
|
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)
|
|
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
|
Blockage reason
|
|
nvarchar(50)
|
|
BITMAPNAME
|
Picture
|
|
nvarchar(50)
|
|
COLORID
|
Color
|
|
int(4)
|
|
Remarks
|
Information
|
|
nvarchar(255)
|
Long description for this routing plan
|
RevisionLevel
|
Revision Nummmer
|
|
nvarchar(30)
|
|
UDF1
|
Userfield 1
|
|
nvarchar(50)
|
|
UDF2
|
Userfield 2
|
|
nvarchar(50)
|
|
UDF3
|
Userfield 3
|
|
nvarchar(50)
|
|
UDF4
|
Userfield 4
|
|
nvarchar(50)
|
|
UDF5
|
Userfield 5
|
|
nvarchar(50)
|
|
UDF6
|
Userfield 6
|
|
nvarchar(50)
|
|
UDF7
|
Userfield 7
|
|
nvarchar(50)
|
|
UDF8
|
Userfield 8
|
|
nvarchar(50)
|
|
UDF9
|
Userfield 9
|
|
nvarchar(50)
|
|
UDF10
|
Userfield 10
|
|
nvarchar(50)
|
|
UDF11
|
Userfield 11
|
|
nvarchar(50)
|
|
UDF12
|
Userfield 12
|
|
nvarchar(50)
|
|
UDF13
|
Userfield 13
|
|
nvarchar(50)
|
|
UDF14
|
Userfield 14
|
|
nvarchar(50)
|
|