Microsoft Access PLAFR (Planned 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

PLNUM

CHAR

10

Planned order

MATNR

CHAR

18

Planning material

MTEXT

CHAR

40

Material short text

PLWRK

CHAR

4

Planning plant

PWWRK

CHAR

4

Production plant

PAART

CHAR

4

Order type

BESKZ

CHAR

1

Procurement type

GSMNG

QUAN

17

Planned order quantity

TLMNG

QUAN

17

Partial lot quantity

AVMNG

QUAN

17

Scrap quantity

BDMNG

QUAN

17

Requirement quantity

PSTTR

DATS

10

Planned start date

PEDTR

DATS

10

Planned finish date

PERTR

DATS

10

Planned creation date

WEBAZ

DEC

3

Goods recpt processing time

DISPO

CHAR

3

MRP controller

UMSKZ

CHAR

1

Conversion indicator

AUFFX

CHAR

1

"Fixed" indicator

STLFX

CHAR

1

Fixed settlement

KNTTP

CHAR

1

Account assignment type

RSNUM

NUMC

10

Reservation

SERNR

CHAR

8

Serial number

PALTR

DATS

10

Planned settlement date

TECHS

CHAR

12

Technical status

VERID

CHAR

4

Production version

AUFNR

CHAR

12

Run schedule header

TERST

DATS

10

Scheduled start

TERED

DATS

10

Scheduled finish

TRMKZ

CHAR

1

Scheduling indicator

TRMER

CHAR

2

Scheduling errors

REDKZ

CHAR

1

Reduction indication

TRMHK

CHAR

1

Scheduling origin

MEINS

UNIT

3

Base unit of measure

REVLV

CHAR

2

Revision level

LGORT

CHAR

4

Storage location

PLSCN

NUMC

3

Planning scenario