For detailed information on how to import see Data Integration Hub and Source-Target-Link.
Use this to import work order positions with extended position information.
The assembly can be defined, but Beas always uses the BoM and routing information from item master data.
Add position to existing work orders.
Beas explodes the Bill of materials, routing position and all order-related sub-assemblies.
If you do not define a work order number, Beas creates a new work order (BELNR_ID=0).
It is not possible to define additional information for work order header if the system creates a new work order.
It is not possible to update existing positions.
The work order document number, work order position and bill of materials position are mandatory.
When trying to insert an exiting BoM position, Beas updates the position.
Beas does not explode order related assemblies. Multilevel work orders cannot be created.
Defines linked information.
Field
|
Name
|
M
|
Type
|
Description
|
BELNR_ID
|
Document Number
|
X
|
int(4)
|
Work order document number (internal counter)
Import: insert value "0" for create new entry.
You can't define the number for new work orders
|
BELPOS_ID
|
Line Number
|
X
|
int(4)
|
Work order position
|
BarCode
|
Barcode
|
|
nvarchar(10)
|
|
ItemCode
|
Item
|
X
|
nvarchar(50)
|
|
U_beas_ver
|
I-Version
|
|
nvarchar(20)
|
|
ItemName
|
Description
|
|
nchar(100)
|
|
SHORTVARIANT
|
Variant
|
|
nchar(1)
|
Valid values: A=A
B=B
C=C
D=D
E=E
F=F
G=G
H=H
I=I
J=J
K=K
L=L
M=M
N=N
O=O
P=P
Q=Q
R=R
S=S
T=T
U=U
V=V
W=W
X=X
Y=Y
Z=Z
|
VRI
|
Configuration
|
|
int(4)
|
|
MENGE_VERBRAUCH
|
Qty. to produce in Usage inut
|
X
|
numeric(4)
|
|
MENGE_VERSCHNITT
|
Cut-Off Quantity
|
|
numeric(4)
|
|
STARTZEIT_STRUKTUR
|
Start Structure
|
|
datetime(8)
|
best date format: yyyy/mm/dd hh:mm in 24 hour format
Time format with am/pm not working.
|
STARTZEIT
|
Start date
|
|
datetime(8)
|
best date format: yyyy/mm/dd hh:mm in 24 hour format
Time format with am/pm not working.
|
ANFZEIT
|
Start Time
|
|
datetime(8)
|
best date format: yyyy/mm/dd hh:mm in 24 hour format
Time format with am/pm not working.
|
ENDZEIT
|
End
|
|
datetime(8)
|
best date format: yyyy/mm/dd hh:mm in 24 hour format
Time format with am/pm not working.
|
LIEFERDATUM
|
Delivery Date
|
|
datetime(8)
|
best date format: yyyy/mm/dd hh:mm in 24 hour format
Time format with am/pm not working.
|
STATUS_ID
|
Status
|
|
nvarchar(20)
|
Valid values: =
Start Status Position (0%)=Start
|
ZUSATZTEXT
|
Info
|
|
nvarchar(4000)
|
|
RevisionLevel
|
Revision
|
|
nvarchar(30)
|
|
StlItemCode
|
Bill of Materials
|
|
nvarchar(60)
|
|
RoutingId
|
Routing
|
|
nvarchar(60)
|
|
U_znr
|
Drawing no.
|
|
nvarchar(50)
|
|
WST_ID
|
Raw material
|
|
nvarchar(20)
|
|
Match
|
Match code
|
|
nvarchar(50)
|
|
DIN
|
DIN
|
|
nvarchar(50)
|
|
Project
|
Project
|
|
nvarchar(20)
|
|
PRJUID
|
Task
|
|
int(4)
|
|
Confirmed
|
Approved
|
|
int(4)
|
Valid values: Yes=1
No=0
|
STARTCAPACITYPLANUNG
|
Capacity Planning
|
|
int(4)
|
Valid values: Yes=1
No=0
|
STARTDISPOSITION
|
Material planning
|
|
int(4)
|
Valid values: Yes=1
No=0
|
STARTTIMEREQUEST
|
Login to work order
|
|
int(4)
|
Valid values: Yes=1
No=0
|
STARTBOOKING
|
Material posting
|
|
int(4)
|
Valid values: Yes=1
No=0
|
CanModifyWo
|
Allow changes
|
|
int(4)
|
Valid values: Yes=1
No=0
|
DRUCKKZ
|
Printed?
|
|
nchar(1)
|
Valid values: Yes=J
No=N
|
PrintDate
|
Print Date
|
|
datetime(8)
|
best date format: yyyy/mm/dd hh:mm in 24 hour format
Time format with am/pm not working.
|
WhsCode
|
Warehouse
|
|
nvarchar(20)
|
|
FromWhsCode
|
For Warehouse
|
|
nvarchar(20)
|
|
BINCODE
|
Bin Location
|
|
nvarchar(20)
|
|
CHARGE_ID
|
Batch
|
|
nvarchar(30)
|
only for information. No functionality!
|
QS_ID
|
QC Inspection plan
|
|
nvarchar(50)
|
|
SCHEMA_ID
|
Schema
|
|
nvarchar(20)
|
|
VKPREIS
|
Sales Price
|
|
numeric(4)
|
|
ACCOUNT_WIP
|
Account WIA
|
|
nvarchar(15)
|
|
ACCOUNT_VARIANCE
|
Account Variance
|
|
nvarchar(15)
|
|
EXPANDALL
|
Always breakdown subassemblies
|
|
int(4)
|
Valid values: Yes=1
No=0
|
MENGE_BESTELLT
|
Quantity ordered
|
|
numeric(4)
|
|
MENGE_FERTIG_MAUELL
|
Manually Finished Message Quantity
|
|
numeric(4)
|
|
AUFTRAGINT
|
Base Number
|
|
int(4)
|
Base Entry
To Sales Order: RDR1.DocEntry
To PreInvouce: INV1.DocEntry
|
AUFTRAGPOS
|
Base Linenum
|
|
int(4)
|
Line number (linenum) from base document
RDR1.LineNum
INV1.LineNum
|
AUFTRAGHERKUNFT
|
Base type
|
|
nchar(1)
|
Base Type
SalesOrder = K
PreInvoice = R
|
BaseDocNum
|
Base Document number
|
|
int(4)
|
|
DocEntry
|
Base doc entry
|
|
int(4)
|
|
BaseLine
|
Base Line
|
|
int(4)
|
|
BASELINE2
|
Base Line 2
|
|
int(4)
|
|
UDF1
|
User Field 1
|
|
nvarchar(100)
|
|
UDF2
|
User Field 2
|
|
nvarchar(100)
|
|
UDF3
|
User Field 3
|
|
nvarchar(100)
|
|
UDF4
|
User Field 4
|
|
nvarchar(100)
|
|
UDF5
|
User Field 5
|
|
nvarchar(100)
|
|
UDF6
|
User Field 6
|
|
nvarchar(100)
|
|
UDF7
|
User Field 7
|
|
nvarchar(100)
|
|
UDF8
|
User Field 8
|
|
nvarchar(100)
|
|
UDF9
|
User Field 9
|
|
nvarchar(100)
|
|
UDF10
|
User Field 10
|
|
nvarchar(100)
|
|
UDF11
|
User Field 11
|
|
nvarchar(100)
|
|
UDF12
|
User Field 12
|
|
nvarchar(100)
|
|
UDF13
|
User Field 13
|
|
nvarchar(100)
|
|
UDF14
|
User Field 14
|
|
nvarchar(100)
|
|
UDF15
|
User Field 15
|
|
nvarchar(100)
|
|
Help URL: https://help.beascloud.com/beas202402/index.html?dih-production---wo-position.htm
|