DIH Production - WO Position

Administration > Data Integration Hub > Data integration hub > Import Definition > Definition Data Target > DIH Production > DIH Work Order > DIH Production - WO Position

Top  Previous  Next

Description

See

Table

Work order position

Edit Work order position master data

BEAS_FTPOS

 
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