Field
|
Name
|
M
|
Type
|
Description
|
WKZ_ID
|
Tool Key
|
X
|
nchar(20)
|
|
WKZTYP_ID
|
Type
|
|
nchar(1)
|
Valid values: Tool=W
Help Tool=H
|
BEZ
|
Description
|
X
|
nvarchar(255)
|
|
AKTIV
|
Active
|
|
int(4)
|
Valid values: Yes=1
No=0
|
GESPERRT
|
Block availability
|
|
int(4)
|
Valid values: Yes=1
No=0
|
GESPERRT_BIS
|
Block availability to
|
|
datetime(8)
|
best date format: yyyy/mm/dd hh:mm in 24 hour format
Time format with am/pm not working.
|
ZNR
|
Drawing number
|
|
nvarchar(50)
|
|
ART
|
Type
|
|
nvarchar(100)
|
|
CardCode
|
Customer
|
|
nvarchar(20)
|
|
LAGO_ID
|
Store location (Warehouse)
|
|
nvarchar(20)
|
|
Project
|
Project
|
|
nvarchar(20)
|
|
LPLATZ_ID
|
Bin location
|
|
nvarchar(20)
|
|
MENGE
|
Quantity tools
|
|
int(4)
|
|
NUTZEN
|
Use factor by (shot/pass)
|
|
decimal(9)
|
|
KAPAPLANUNG
|
Capacity planning
|
|
int(4)
|
Valid values: Yes=1
No=0
|
BESTIMMT_ZEIT
|
Defines lead time
|
|
int(4)
|
if active, the tool define the duration time of work order position
Valid values: yes=1
no=0
|
CHOOSEABLE
|
Selectable at time receipt
|
|
int(4)
|
Valid values: yes=1
no=0
|
BEMERKUNG
|
Remark
|
|
ntext(8)
|
|
ItemCode
|
Item number
|
|
nvarchar(50)
|
|
APSVIEW
|
View in APS
|
|
int(4)
|
Valid values: No=0
Yes=1
|
DATUM
|
Date of purchase
|
|
datetime(8)
|
best date format: yyyy/mm/dd hh:mm in 24 hour format
Time format with am/pm not working.
|
BETRIEBSDAUER
|
Product life in units
|
|
numeric(4)
|
|
LIEF_ID
|
Supplier
|
|
nchar(20)
|
|
FERTIGER
|
Manufacturer (Name)
|
|
nvarchar(50)
|
|
INSTKST
|
Maintenance costs
|
|
numeric(4)
|
|
INSTKSTJE
|
Maintenance costs per units ot measure
|
|
int(4)
|
|
KST
|
Purchased price
|
|
numeric(4)
|
|
KTIMETYPE_ID
|
Cost element for buy
|
|
nvarchar(20)
|
|
KOSTENJE
|
Cost input in
|
|
int(4)
|
Valid values: Quantity=0
Time=1
|
WTIMETYPE_ID
|
Cost element for maintenance
|
|
nvarchar(20)
|
|
KAUFBEMERKUNG
|
Remark
|
|
nvarchar(0)
|
|
KAPACHECKLIMIT
|
Consider resource limits
|
|
nchar(1)
|
Valid values: No=0
Yes=1
|
BETRIEBSZEIT
|
Operation Time:
|
|
numeric(4)
|
|
WARTUNG_MAX
|
Maintenance all per unit
|
|
int(4)
|
|
WARTUNG_LETZTE
|
Last maintenance
|
|
datetime(8)
|
best date format: yyyy/mm/dd hh:mm in 24 hour format
Time format with am/pm not working.
|
WARTUNG_ZAEHLER
|
Maintenance counter
|
|
int(4)
|
|
BILD1
|
Attachment 1
|
|
nvarchar(255)
|
|
BILD2
|
Attachment 2
|
|
nvarchar(255)
|
|
BILD3
|
Attachment 3
|
|
datetime(8)
|
|
ZUSTAND
|
Status
|
|
nvarchar(20)
|
|
LIEGEZEIT
|
Idle time
|
|
int(4)
|
|
LIEGEZEIT_TYP
|
--
|
|
int(4)
|
|
ZEITKSTGK
|
Cost per time unit / Marginal Cost
|
|
numeric(4)
|
|
ZEITKSTVK
|
Cost per time unit / Full Cost
|
|
numeric(4)
|
|
ZEITKSTZEITJE
|
Cost unit
|
|
int(4)
|
|
WARTUNG_INFO
|
Maintenance info
|
|
nvarchar(100)
|
|
ZAEHLERSTAND
|
Counter status
|
|
datetime(8)
|
best date format: yyyy/mm/dd hh:mm in 24 hour format
Time format with am/pm not working.
|
ZAEHLER_VOM
|
Counter status from
|
|
datetime(8)
|
best date format: yyyy/mm/dd hh:mm in 24 hour format
Time format with am/pm not working.
|
GESPERRT_GRUND
|
Locked reason
|
|
nvarchar(255)
|
|
UDF1
|
Userfield 1
|
|
nvarchar(100)
|
|
UDF2
|
Userfield 2
|
|
nvarchar(100)
|
|
UDF3
|
Userfield 3
|
|
nvarchar(100)
|
|
UDF4
|
Userfield 4
|
|
nvarchar(100)
|
|
DOCUMENTS
|
Edit documents
|
|
nvarchar(0)
|
|