Microsoft Access PROJR (Project Definitions)

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

PSPID

CHAR

24

Project definition

POST1

CHAR

40

Description

ERNAM

CHAR

12

Created by

KIMSK

CHAR

24

Mask short ID

VERNR

NUMC

8

Responsible person (number)

VERNA

CHAR

25

Responsible person (name)

ASTNR

NUMC

8

Applicant (number)

ASTNA

CHAR

25

Applicant (name)

VBUKR

CHAR

4

Company code

VGSBR

CHAR

4

Business area

VKOKR

CHAR

4

Controlling area

PWHIE

CUKY

5

Project currency

PLFAZ

DATS

10

Start date

PLSEZ

DATS

10

Finish date

WERKS

CHAR

4

Plant

KALID

CHAR

2

Factory calendar

ZTEHT

UNIT

3

Time unit

TXTSP

LANG

1

Language

AEDTE

DATS

10

Last basic date

AEDTP

DATS

10

Last forecast date

AEDTI

DATS

10

Last actual date

BESTA

CHAR

1

Project stock

SCOPE

CHAR

5

Object class

XSTAT

CHAR

1

Statistic

TXJCD

CHAR

15

Jurisdiction code

ZSCHM

CHAR

7

Interest calculation profile

SCPRF

CHAR

12

WBS scheduling profile

IMPRF

CHAR

6

Investment profile

FMPRF

CHAR

6

Financial budget profile

STATXT

CHAR

40

Status