Microsoft Access AUFKR (Orders)

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

AUART

CHAR

4

Order type

AUARTTXT

CHAR

20

Order type

AUTYPTXT

CHAR

40

Order type

REFNR

CHAR

12

Reference order

KTEXT

CHAR

40

Short text

TXTKZ

CHAR

1

Long text exists

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

KALSM

CHAR

6

Costing profile

ZSCHL

CHAR

6

Overhead key

USER0

CHAR

20

Applicant

USER1

CHAR

20

Telephone

USER2

CHAR

20

Responsible person

USER3

CHAR

20

Telephone

USER4

CURR

14

Estimated costs

USER5

DATS

10

Created on

USER6

CHAR

15

Department

USER7

DATS

10

Work start

USER8

DATS

10

Work finish

USER9

CHAR

1

Work permit

AWSLS

CHAR

6

Variance key

ABGSL

CHAR

6

Results analysis key

TXJCD

CHAR

15

Jurisdiction code

SCOPE

CHAR

5

Object class

AUFEX

CHAR

20

External order number

FLG_MLTPS

CHAR

1

Multi–item

AKSTL

CHAR

10

Required cost center

GLTRP

DATS

10

Basic finish date

GSTRP

DATS

10

Basic start date

FTRMS

DATS

10

Scheduled release date

GLTRS

DATS

10

Scheduled finish

GSTRS

DATS

10

Scheduled start

GSTRI

DATS

10

Actual start date

GETRI

DATS

10

Confirmed finish date

GLTRI

DATS

10

Actual finish date

FTRMI

DATS

10

Actual release date

FTRMP

DATS

10

Planned release date

RSNUM

NUMC

10

Reservation number

GASMG

QUAN

17

Total scrap

GAMNG

QUAN

17

Target quantity

GMEIN

UNIT

3

Base unit of measure

PLNBEZ

CHAR

18

Material plan

PLNTY

CHAR

1

Task list type

PLNNR

CHAR

8

Group

PLNAL

CHAR

2

Group counter

PLSVB

QUAN

17

Lot size to (planned)

PLNME

UNIT

3

Unit of measure (planned)

PLSVN

QUAN

17

Lot size from (planned)

PDATV

DATS

10

Valid from (planned)

PAENR

CHAR

12

Change number (planned)

PLGRP

CHAR

3

Planner group

STLTY

CHAR

1

BOM category

STLBEZ

CHAR

18

Material BOM

STLST

NUMC

2

BOM status

STLNR

CHAR

8

Bill of material (BOM)

SDATV

DATS

10

Valid from (BOM)

SBMNG

QUAN

17

Base quantity

SBMEH

UNIT

3

Base unit of measure

SAENR

CHAR

12

Change number (BOM)

STLAL

CHAR

2

BOM alternative

STLAN

CHAR

1

BOM usage

SLSVN

QUAN

17

Lot size from (BOM)

SLSBS

QUAN

17

Lot size to (BOM)

AUFLD

DATS

10

Explosion date

DISPO

CHAR

3

MRP group

DSNAM

CHAR

18

MRP controller

FEVOR

CHAR

3

Production scheduler

FHORI

CHAR

3

Scheduling margin key

TERKZ

CHAR

1

Scheduling type

REDKZ

CHAR

1

Reduction indicator

APRIO

CHAR

1

Order priority

VORGZ

NUMC

3

Float before production

SICHZ

NUMC

3

Float after production

FREIZ

NUMC

3

Release period

KLVARP

CHAR

4

Costing variant (planned)

KLVARI

CHAR

4

Costing variant (actual)

GLTPP

DATS

10

Forecast finish date

GSTPP

DATS

10

Forecast start date

GLTPS

DATS

10

Scheduled finish (forecast)

GSTPS

DATS

10

Scheduled start (forecast)

FTRPS

DATS

10

Scheduled 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

STUFE

DEC

2

Level

WEGXX

DEC

5

Path

VWEGX

DEC

5

Path

MAUFNR

CHAR

12

Superior order

PRODNET

CHAR

1

Collective order

IASMG

QUAN

17

Confirmed scrap

ABARB

NUMC

3

Degree of processing

AUFNT

CHAR

12

Subnetwork for network

VORNT

CHAR

4

Subnetwork for activity

BREAKS

CHAR

1

Breaks

VORGZ_TRM

DEC

7

Sched. float before production

SICHZ_TRM

DEC

7

Sched. float after production

TRMDT

DATS

10

Scheduled on

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)

CHSCH

CHAR

6

Search procedure

KAPT_VORGZ

NUMC

3

Remaining float before production

KAPT_SICHZ

NUMC

3

Remaining float after production

LEAD_AUFNR

CHAR

12

Leading order

PNETSTARTD

DATS

10

Outline start date

PNETSTARTT

TIMS

8

Outline start time

PNETENDD

DATS

10

Outline finish date

PNETENDT

TIMS

8

Outline finish time

STRMP

DATS

10

Planned start date

ETRMP

DATS

10

Planned creation date

KDEIN

NUMC

4

Schedule line: sales order

WEMNG

QUAN

17

Goods receipt quantity

IAMNG

QUAN

17

Actual scrap quantity

AMEIN

UNIT

3

In–house prod. unit of measure

MEINS

UNIT

3

Base unit of measure

MATNR

CHAR

18

Material number

MTEXT

CHAR

40

Material short text

PAMNG

QUAN

17

Scrap quantity

PGMNG

QUAN

17

Planned order quantity

LTRMI

DATS

10

Actual delivery date

LTRMP

DATS

10

Planned delivery date

KALNR

NUMC

12

Unit costing number

UEBTO

DEC

4

Overdelivery tolerance

UEBTK

CHAR

1

Unlimited overdelivery

UNTTO

DEC

4

Underdelivery tolerance

INSMK

CHAR

1

Quality inspection

WEPOS

CHAR

1

Goods receipt

BWTAR

CHAR

10

Valuation type

PWERK

CHAR

4

Planning plant

LGORT

CHAR

4

Storage location

VERTO

CHAR

4

Distribution key

WEBAZ

DEC

3

Goods receipt processing

ELIKZ

CHAR

1

Final delivery

SERNR

CHAR

8

Serial number

WEUNB

CHAR

1

Non–valuated goods receipt

ABLAD

CHAR

25

Unloading point

WEMPF

CHAR

12

Ship–to party

CHARG

CHAR

10

Batch

STATXT

CHAR

40

Status

FRUEHER

QUAN

7

Earlier

SPAETER

QUAN

7

Later

VERZUG

QUAN

7

Delay

VORBEI

QUAN

7

Past

VEINH

UNIT

3

Unit