Microsoft Access AFFHR (Production Resources/Tools)

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

PSNFH

NUMC

4

Item

AUTYPTXT

CHAR

40

Order type

STEUF

CHAR

4

Control key

STEUTXT

CHAR

40

Control key text

KZKBL

CHAR

1

Requirements records

BZOFFB

CHAR

2

Reference start

OFFSTB

QUAN

7

Time interval start

EHOFFB

UNIT

3

Unit

BZOFFE

CHAR

2

Reference finish

OFFSTE

QUAN

7

Time interval finish

EHOFFE

UNIT

3

Unit

FSFHD

DATS

10

Earliest start date

FSFHZ

TIMS

8

Earliest start time

FEFHD

DATS

10

Earliest finish date

FEFHZ

TIMS

8

Earliest finish time

SSFHD

DATS

10

Latest start date

SSFHZ

TIMS

8

Latest start time

SEFHD

DATS

10

Latest finish date

SEFHZ

TIMS

8

Latest finish time

ISFHD

DATS

10

Actual start date

ISFHZ

TIMS

8

Actual start time

IEFHD

DATS

10

Actual finish date

IEFHZ

TIMS

8

Actual finish time

DAUSE

QUAN

7

Usage duration

DAUEH

UNIT

3

Duration unit

MGEINH

UNIT

3

Standard value unit: Quantity

MGVGW

QUAN

11

Standard value: Quantity

MGSOLEH

UNIT

3

Total quantity unit

MGSOL

QUAN

11

Total quantity

MGISTEH

UNIT

3

Confirmed quantity unit

MGIST

QUAN

11

Confirmed quantity

MGRSTEH

UNIT

3

Remaining stock qty unit

MGRST

QUAN

11

Remaining requirements qty

MGAUSEH

UNIT

3

PRT quantity

MGAUS

QUAN

11

PRT quantity

MGFORM

CHAR

6

Total quantity formula

EWEINH

UNIT

3

Usage value unit

EWVGW

QUAN

11

Standard value: Usage

EWSOLEH

UNIT

3

Usage value unit

EWSOL

QUAN

11

Total usage value

EWISTEH

UNIT

3

Usage value unit

EWIST

QUAN

11

Actual usage value

EWRSTEH

UNIT

3

Usage value unit

EWRST

QUAN

11

Remaining usage value

EWFORM

CHAR

6

Usage value formula

TXTSP

LANG

1

Language

KTSCH

CHAR

7

Standard text key

TXTZ1

CHAR

40

PRT text

FHMAR

CHAR

1

PRT category

FHMNR

CHAR

33

Production resources/tools

FHWRK

CHAR

4

Plant

MATNR

CHAR

18

Material

MTEXT

CHAR

40

Material short text

SFHNR

CHAR

18

Production resources/tools

DOKAR

CHAR

3

Document type

DOKNR

CHAR

25

Document

DOKVR

CHAR

2

Document version

DOKTL

CHAR

3

Document part

EQUNR

CHAR

18

Equipment

EQPNT

CHAR

12

Measuring point

EQPTX

CHAR

40

Description

MSEHI

UNIT

3

Internal unit of measurement

FHKTX

CHAR

40

Description

FGRU1

CHAR

4

Grouping 1

FGRU2

CHAR

4

Grouping 2

TXTKZ

CHAR

1

Long text exists

STATXT

CHAR

40

Status