Microsoft Access NETZR (Networks)

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

Versions 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

Network

AUFNT

CHAR

12

Subnetwork for network

VORNT

CHAR

4

Subnetwork for activity

AUART

CHAR

4

Network type

KTEXT

CHAR

40

Short text

LTEXT

CHAR

1

Long text exists

BUKRS

CHAR

4

Company code

WERKS

CHAR

4

Plant

GSBER

CHAR

4

Business area

KOKRS

CHAR

4

Controlling area

KOSTV

CHAR

10

Responsible cost center

WAERS

CUKY

5

Currency

TXJCD

CHAR

15

Jurisdiction code

SCOPE

CHAR

5

Object class

GLTRP

DATS

10

Basic finish date

GSTRP

DATS

10

Basic start date

FTRMS

DATS

10

Sched. release date

GLTRS

DATS

10

Sched. finish date

GSTRS

DATS

10

Sched. start date

GSTRI

DATS

10

Actual start date

GETRI

DATS

10

Actual finish date

GLTRI

DATS

10

Actual finish date

FTRMI

DATS

10

Actual release date

FTRMP

DATS

10

Planned release date

DISPO

CHAR

3

MRP group

DSNAM

CHAR

18

MRP controller

FEVOR

CHAR

3

Planner group

TERKZ

CHAR

1

Scheduling type

REDKZ

CHAR

1

Reduction indicator

APRIO

CHAR

1

Priority

GLTPP

DATS

10

Forecast finish date

GSTPP

DATS

10

Forecast start date

GLTPS

DATS

10

Sched. finish (forecast)

GSTPS

DATS

10

Sched. start (forecast)

FTRPS

DATS

10

Sched. release (forecast)

RDKZP

CHAR

1

Reduction indicator (forecast)

TRKZP

CHAR

1

Scheduling type (forecast)

GLUZS

TIMS

8

Sched. finish time (basic)

GSUZS

TIMS

8

Sched. start time (basic)

NAUTERM

CHAR

1

Scheduling not automatic

NAUCOST

CHAR

1

Costing not automatic

NO_DISP

CHAR

1

Reservation/Purchase req.

GLUZP

TIMS

8

Basic finish time

GSUZP

TIMS

8

Basic start time

GSUZI

TIMS

8

Actual start time

GEUZI

TIMS

8

Actual finish time

GLUPP

TIMS

8

Forecast finish time

GSUPP

TIMS

8

Forecast start time

GLUPS

TIMS

8

Sched. finish time (forecast)

GSUPS

TIMS

8

Sched. start time (forecast)

KDEIN

NUMC

4

Schedule lines: sales order

STATXT

CHAR

40

Status

FRUEHER

QUAN

7

Earlier

SPAETER

QUAN

7

Later

VERZUG

QUAN

7

Delay

VORBEI

QUAN

7

Past

VEINH

UNIT

3

Unit