Field
|
Name
|
M
|
Type
|
Description
|
BELNR_ID
|
Work order number
|
X
|
numeric(4)
|
|
BELPOS_ID
|
Work order position number
|
X
|
numeric(4)
|
|
POS_ID
|
Routing position number
|
X
|
numeric(4)
|
|
DocDate
|
Valuation date
|
|
datetime(8)
|
best date format: yyyy/mm/dd hh:mm in 24 hour format
Time format with am/pm not working.
|
RESOURCENPOS_ID
|
Parallel Position
|
|
int(4)
|
Internal position number of parallel resource
linked to BEAS_FTAPL.WKZPOS_ID !
|
PERS_ID
|
Employee number
|
X
|
nchar(20)
|
|
ANFZEIT
|
Start Date
|
X
|
datetime(8)
|
best date format: yyyy/mm/dd hh:mm in 24 hour format
Time format with am/pm not working.
|
ENDZEIT
|
End Date
|
X
|
datetime(8)
|
best date format: yyyy/mm/dd hh:mm in 24 hour format
Time format with am/pm not working.
|
MENGE_GUT_RM
|
Yield Quantity
|
|
numeric(4)
|
Quantity im time receipt unit
|
MENGE_SCHLECHT_RM
|
Scrap Quantity
|
|
numeric(4)
|
Scrap Quantity im time receipt unit
|
APLATZ_ID
|
Resource
|
|
nchar(20)
|
|
TIMETYPE_ID
|
Time Type
|
|
nvarchar(20)
|
|
KSTST_ID
|
Cost Center
|
|
nchar(20)
|
|
BatchNum
|
Batch Number
|
|
nvarchar(40)
|
|
manualbooking
|
Disable backflushing
|
X
|
char(1)
|
Only Import field:
Disable this field, if you want use the backflush function.
Attention: beas can book only material which defined. If you use manual batchnumbers then beas can't receipt the assembly.
Valid values: Disable backflush=Y
Use default backlfush process=N
|
GRUND
|
Reason for Entry
|
|
nvarchar(255)
|
|
ZEIT
|
Time
|
X
|
numeric(4)
|
|
ABGKZ
|
Closed
|
|
nchar(1)
|
Valid values: Close Routing Position=Y
Don't close Routing Position=N
|
Project
|
Project
|
|
nvarchar(20)
|
|
EXTERNAL_COST
|
External Cost
|
|
numeric(4)
|
Cost (manual entry)
|
TYP
|
message typ
|
|
nchar(1)
|
Valid values: normal time=A
tool time=R
time 2 (H)=H
time 3 (N)=N
|
WKZ_ID
|
Tool Id
|
|
nvarchar(20)
|
Which Tool id (from tool administration BEAS_WKZ) used for this time operation
Only for information. Not mandatory
|
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)
|
|
UDF15
|
Userfield 15
|
|
nvarchar(50)
|
|