Microsoft Access MLSTR (Milestones)

You should read the table from top to bottom to see the order in which the data fields are stored in the data records in the Access database.

Field name is the name of the field in the table. Type shows the field’s attribute and length gives the length of the data field. Text indicates the type of data.

Field name

Type

Length

Text

ARNUMMER

NUMC

6

Archiving run

VSGRUPPE

CHAR

20

Version group

VSNUMMER

CHAR

12

Version key

PRCTR

CHAR

10

Profit center

PRNAM

CHAR

8

Capital investment program

PRPOS

CHAR

24

Item ID

PSPID

CHAR

24

Project definition

POSID

CHAR

24

WBS element

KDAUF

CHAR

10

Sales document

KDPOS

NUMC

6

Sales item

AUFNR

CHAR

12

Order/network

VORNR

CHAR

4

Activity

MLST_ZAEHL

NUMC

12

Milestone number

AUARTTXT

CHAR

20

Order type

MLSTN

CHAR

5

Milestone usage

TEDAT

DATS

10

Scheduled basic date

TETIM

TIMS

8

Scheduled basic time

TPDAT

DATS

10

Scheduled forecast date

TPTIM

TIMS

8

Scheduled forecast time

EDATU

DATS

10

Fixed basic date

EZEIT

TIMS

8

Fixed basic time

PDATU

DATS

10

Fixed forecast date

PZEIT

TIMS

8

Fixed forecast time

LATED

CHAR

1

Latest dates

DLTAS

CHAR

1

Reference finish

DELTA

QUAN

7

Time interval

DELTE

UNIT

3

Time interval unit

PRCNT

DEC

4

Time interval %

KZ_TREND

CHAR

1

Trend analysis

KZ_LSTWR

CHAR

1

Earned value analysis

KZ_WFLOW

CHAR

1

Milestone functions

KZ_FAKTP

CHAR

1

Sales document date

KZ_FRMST

CHAR

1

Release stop indicator

LST_FERTG

NUMC

3

Completion

LST_ACTDT

DATS

10

Actual date

LST_ACTTM

TIMS

8

Actual time

TASK_ID

CHAR

14

Task

RELSU

CHAR

1

Release following activity

RELMS

CHAR

1

Release to milestone

INCPN

CHAR

1

Include standard network

INCNW

CHAR

1

Create network

INCSN

CHAR

1

Include subnetwork

WKFLW

CHAR

1

Workflow task

RELSU_TSS

CHAR

4

System status: Release following activity

RELMS_TSS

CHAR

4

System status: Release to milestone

INCNW_TSS

CHAR

4

System status: Include standard network

INCPN_TSS

CHAR

4

System status: Create network

INCSN_TSS

CHAR

4

System status: Include subnetwork

WKFLW_TSS

CHAR

4

System status: Workflow task

RELSU_TUS

CHAR

4

User status: Release following activity

RELMS_TUS

CHAR

4

User status: Release to milestone

INCNW_TUS

CHAR

4

User status: Include standard network

INCPN_TUS

CHAR

4

User status: Create network

INCSN_TUS

CHAR

4

User status: Include subnetwork

WKFLW_TUS

CHAR

4

User status: Workflow task

RELSU_CH

CHAR

1

Status change: Release following activity

RELMS_CH

CHAR

1

Status change: Release to milestone

INCPN_CH

CHAR

1

Status change: Include standard network

INCNW_CH

CHAR

1

Status change: Create network

INCSN_CH

CHAR

1

Status change: Include subnetwork

WKFLW_CH

CHAR

1

Status change: Workflow task

RELSU_SG

CHAR

1

Once: Release following activity

RELMS_SG

CHAR

1

Once: Release to milestone

INCPN_SG

CHAR

1

Once: Include standard network

INCNW_SG

CHAR

1

Once: Create network

INCSN_SG

CHAR

1

Once: Include subnetwork

WKFLW_SG

CHAR

1

Once: Workflow task

RELSU_TR

CHAR

1

Function: Release following activity

RELMS_TR

CHAR

1

Function: Release to milestone

INCPN_TR

CHAR

1

Function: Include standard network

INCNW_TR

CHAR

1

Function: Create network

INCSN_TR

CHAR

1

Function: Include subnetwork

WKFLW_TR

CHAR

1

Function: Workflow task

KTEXT

CHAR

40

Description

LTXSP

LANG

1

Long text language

STATXT

CHAR

40

Status

FRUEHER

QUAN

7

Earlier

SPAETER

QUAN

7

Later

VERZUG

QUAN

7

Delay

VORBEI

QUAN

7

Past

VEINH

UNIT

3

Unit