For detailed information on how to import see Data Integration Hub and Source-Target-Link.
Use this if you want to update the header information or if you want to create new work orders and you need only the item code and quantity for the work order position.
Inserts first work order position with item code and quantity.
Beas explodes the bill of materials, routing position and all order-related sub-assemblies.
Note:
Creating reference to other documents or changing any properties in the work order line is not possible.
You can change the work order type, but it is not possible to change the work order type related flags; Beas ignores these changes.
You cannot define the document number (BEAS_FTHAUPT.BELNR_ID), only the order number (BEAS_FTHAUPT.AUFTRAG).
Most properties are changeable, but you cannot change the created work order positions.
Beas ignores the item code and quantity property.
Field
|
Name
|
M
|
Type
|
Description
|
BELNR_ID
|
Document no
|
X
|
int(4)
|
Document number (numeric)
import: insert "0" as default value
|
AUFTRAG
|
Order Number
|
|
nvarchar(50)
|
|
TYP
|
Work order type
|
|
nvarchar(30)
|
|
BELDAT
|
Order date
|
|
datetime(8)
|
best date format: yyyy/mm/dd hh:mm in 24 hour format
Time format with am/pm not working.
|
KND_ID
|
Customer Id
|
|
nchar(20)
|
The Customer, Lead or Vendor
|
KNDNAME
|
Customer Name
|
|
nvarchar(100)
|
|
KND_SHIPTOCODE
|
Customer Delivery
|
|
nvarchar(100)
|
|
KNDSTRASSE
|
Customer Street
|
|
nvarchar(50)
|
|
KNDPLZ
|
Customer ZIP / City
|
|
nvarchar(10)
|
|
KNDORT
|
Customer Location
|
|
nvarchar(50)
|
|
KNDLAND
|
Customer Country
|
|
nvarchar(30)
|
|
KNDTELEFON1
|
Customer Telephone
|
|
nvarchar(50)
|
|
PRIOR_ID
|
Priority
|
|
char(0)
|
|
Project
|
Project
|
|
nvarchar(20)
|
|
PRJUID
|
Task
|
|
int(4)
|
|
BPLName
|
Branch
|
|
nvarchar(100)
|
|
ZUSATZTEXT
|
Information
|
|
nvarchar(255)
|
|
STATUS_ID
|
Status
|
|
nvarchar(20)
|
|
LFGDAT
|
Delivery 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.
|
GEMEINKOSTEN
|
Overhead order
|
|
int(4)
|
Valid values: Yes=1
No=0
|
PLANNINGORDER
|
Planned order
|
|
int(4)
|
Valid values: Yes=1
No=0
|
TIMECALCULATE
|
Schedule automatically
|
|
int(4)
|
Valid values: Yes=1
No=0
|
SPERRUNG
|
Block
|
|
nchar(1)
|
Valid values: Yes=J
No=N
|
UNVISIBLE
|
Invisible
|
|
int(4)
|
Valid values: Yes=1
No=0
|
APSSTATUS
|
APS: Planned
|
|
int(4)
|
Valid values: Yes=1
No=0
|
DRUCKKZ
|
Printed
|
|
nchar(1)
|
Valid values: Yes=J
No=N
|
ABGKZ
|
Closed
|
|
char(0)
|
Valid values: Yes=J
No=N
|
PROJECTUSER1
|
Project manager 1
|
|
nvarchar(25)
|
|
PROJECTUSER2
|
Project manager 2
|
|
nvarchar(25)
|
|
PROJECTSTATE
|
Project Status
|
|
nvarchar(20)
|
|
PRJINFO1
|
Info 1
|
|
nvarchar(50)
|
|
PRJINFO2
|
Info 2
|
|
nvarchar(50)
|
|
PLANNEDHOURS
|
Time
|
|
int(4)
|
|
PLANNEDCOSTS
|
Cost
|
|
decimal(9)
|
|
INFORMATION2
|
information 2
|
|
nvarchar(0)
|
|
PRJUDF1
|
Project UDF 1
|
|
nvarchar(50)
|
|
PRJUDF2
|
Project UDF 2
|
|
nvarchar(50)
|
|
PRJUDF3
|
Project UDF 3
|
|
nvarchar(50)
|
|
PRJUDF4
|
Project UDF 4
|
|
nvarchar(50)
|
|
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)
|
|
ItemCode
|
Item Number
|
|
nvarchar(50)
|
|
PROJECT_MANUAL
|
Quantity (import)
|
|
int(4)
|
only for import:
You can define in this field the quantity to produce
|
Enter topic text here.
Help URL: https://help.beascloud.com/beas202206/index.html?dih-production---wo-header.htm
|