Table Structure

Production > Capacity Planning, APS > Graphic View > Data Structure > Table Structure

Top  Previous  Next

The graphical view has an internal table with the following structure:

All information can be accessed in the menu definition using '<parent.xgantt.datafield.[id]>' .

 

 

0

ID

ID of the work sequence (string).

1

Start

Start of the work sequence (start of transit time).

2

End

End of work sequence (end of idle time).

3

Fixstart

1/0 work sequence specified at start of routing.

4

routingstart

Start of processing time (green range).

5

routingend

End of processing time.

6

routingcut

1/0 deadline exceeded (red shading).

7

deliverycut

1/0 delivery deadline exceeded?

8

time

Duration.

9

linenumber

Consecutive number – sorted by structural layout of the production order.

10

strutcrcode

Structural layout (as string information).

11

sortnumber

Sorting by structural layout (number).

12

Doc. no. id

Document No.

13

Doc pos

Doc. Position.

14

pos_id

Operation internal position number.

15

pos2_id

Position of parallel resources.

16

resourcetyp

Resource type

E

Parallel resource

W

Tool

F

External operation

R

Position (green range)

L

Delivery date (red dot)

17

resource_id

ID of the resource (can also be a tool).

18

resourcename

Name of the resource.

19

resourcegroup

Resource group.

20

orderinfo

User-definable order labeling.

21

posinfo

User-definable assembly labeling.

22

routinginfo

User-definable position labeling.

23

priority

Priority of the work order.

24

prjcode

Project number.

25

marker

Position marked Y/N.

26

Status

Work order status

new

Newly created

print

Printed

inwork

Currently logged in

work

Partially logged

Info: Closed or blocked production orders or work sequences are not displayed, as these are not scheduled and do not require any resources.

27

APS

1/0: Marked as planned.

28

free

Transit Start.

29

free

Transit End.

30

free

Idle Start.

31

free

Idle End.

32



33



34



35

udf1

Material Date.

36

udf2

Material failed.

37

udf3

User-definable field.

38

udf4

User-definable field.

39

lieferdatum

Delivery date.

40

stufe

Wok order position level.

41

sortid

Operation – sorting.

42

pos_text

Operation alphanumeric position number.


Help URL: https://help.beascloud.com/beas202402/index.html?tabellenaufbau.htm