Microsoft Access AFRUR (Confirmations Already Carried Out)

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

UVORN

CHAR

4

Element

RUECK

NUMC

10

Confirmation

RMZHL

NUMC

8

Counter

AUTYPTXT

CHAR

40

Order type

ERSDA

DATS

10

Created on

ERNAM

CHAR

12

Created by

LAEDA

DATS

10

Last change

AENAM

CHAR

12

Changed by

BUDAT

DATS

10

Posting date

ARBPL

CHAR

8

Work center

ARBTXT

CHAR

40

Work center text

WERKS

CHAR

4

Plant

LTXA1

CHAR

40

Confirmation text

TXTSP

LANG

1

Language

ABARB

NUMC

3

Degree of processing

ISMNW

QUAN

9

Actual work

ISMNE

UNIT

3

Work unit

LEARR

CHAR

6

Activity type

IDAUR

QUAN

7

Actual duration

IDAUE

UNIT

3

Actual duration unit

GRUND

CHAR

4

Reason for deviation

PERNR

NUMC

8

Personnel number

PERTXT

CHAR

 

Text personnel number

ISDD

DATS

10

Actual start date

ISDZ

TIMS

8

Actual start time

IEDD

DATS

10

Actual finish date

IEDZ

TIMS

8

Actual finish time

PEDD

DATS

10

Forecast finish date

PEDZ

TIMS

8

Forecast finish time

AUERU

CHAR

1

Final confirmation

MANUR

CHAR

1

Manual confirmation

OFMNW

QUAN

9

Remaining work

OFMNE

UNIT

3

Work unit

LEKNW

CHAR

1

No remaining activity

ODAUR

QUAN

7

Remaining duration

ODAUE

UNIT

3

Remaining duration unit

STOKZ

CHAR

1

Canceled

STZHL

NUMC

8

Canceled confirmation

KAPNM

CHAR

8

Capacity

KAPTXT

CHAR

40

Short description

KAPAR

CHAR

3

Capacity category

KAPARTXT

CHAR

20

Desc. capacity category

SPLIT

INT1

3

No. of splits

ZAUSW

NUMC

8

Time ID card number