Microsoft Access AFABR (Relationships)

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 I

KDAUF

CHAR

10

Sales document

KDPOS

NUMC

6

Sales item

AUFNR

CHAR

12

Order/network I

VORNR

CHAR

4

Activity I

POSID2

CHAR

24

WBS element II

AUFNR2

CHAR

12

Order/network II

VORNR2

CHAR

4

Activity II

AUTYPTXT

CHAR

40

Order type

AOBAR

CHAR

2

Relationship type

MIMAX

CHAR

1

Maximum time interval

ZEINH

UNIT

3

Relationship unit

DAUER

QUAN

7

Time interval: Relationship

DAUKZ

CHAR

1

Relationship duration ind.

VORNC

CHAR

1

Successor maintained

NCVOR

CHAR

1

Predecessor maintained

KALID

CHAR

2

Factory calendar ID

PRZNT

NUMC

3

Time interval %

PROVG

CHAR

1

Time interval key

ARBPL

CHAR

8

Work center

ARBTXT

CHAR

40

Work center text

WERKS

CHAR

4

Plant

FSABD

DATS

10

Earliest start: Relationship

FSABZ

TIMS

8

Earliest start time: Relationship

SSABD

DATS

10

Latest start: Relationship

SSABZ

TIMS

8

Latest start time: Relationship

FEABD

DATS

10

Earliest finish: Relationship

FEABZ

TIMS

8

Earliest finish time: Relationship

SEABD

DATS

10

Latest finish: Relationship

SEABZ

TIMS

8

Latest finish time: Relationship

DAUTM

INT4

11

Relationship duration (in sec.)

LTXA1

CHAR

40

Activity I text

LTXA12

CHAR

40

Activity II text

NCH

CHAR

1

Successor indicator