Microsoft Access RESBR (Components)

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

AUFNR

CHAR

12

Order/network

VORNR

CHAR

4

Activity

UVORN

CHAR

4

Element

RSNUM

NUMC

10

Reservation

RSPOS

NUMC

4

Item no.: Stock transfer reservation

AUTYPTXT

CHAR

40

Order type

RSART

CHAR

1

Record type

BDART

CHAR

2

Requirements type

RSSTA

CHAR

1

Reservation status

XFEHL

CHAR

1

Missing part indicator

MATNR

CHAR

18

Material

MTEXT

CHAR

40

Material short text

WERKS

CHAR

4

Plant

LGORT

CHAR

4

Storage area

CHARG

CHAR

10

Batch

PLPLA

CHAR

10

Production storage bin

SOBKZ

CHAR

1

Special stock

BDTER

DATS

10

Requirements date

BDMNG

QUAN

17

Requirements quantity

MEINS

UNIT

3

Base unit of measure

ENMNG

QUAN

17

Quantity withdrawn

WAERS

CUKY

5

Currency

ERFMG

QUAN

17

Quantity in unit of entry

ERFME

UNIT

3

Unit of entry

BAUGR

CHAR

18

Origin

SERNR

CHAR

8

Serial number

BWART

CHAR

3

Movement type

SAKNR

CHAR

10

G/L account

POSTP

CHAR

1

Item category

APOSN

CHAR

4

BOM item

ROMS1

QUAN

17

Size 1

ROMS2

QUAN

17

Size 2

ROMS3

QUAN

17

Size 3

ROMEI

UNIT

3

Size unit

ROMEN

QUAN

17

Variable–size item quantity

SGTXT

CHAR

50

Text

RFORM

CHAR

2

Formula key

ROANZ

QUAN

17

No. of variable–size items

FLMNG

QUAN

17

Missing parts

POTX1

CHAR

40

Item text

SANKA

CHAR

1

Relevancy to costing

SCHGT

CHAR

1

Bulk material

GPREIS

CURR

21

Price/currency

PEINH

DEC

6

Price unit

RGEKZ

CHAR

1

Backflush

EKGRP

CHAR

3

Purchasing group

ROKME

UNIT

3

Component unit of measure

VMENG

QUAN

19

Quantity for auditing procedure

LIFZT

DEC

3

Delivery time in days

KFPOS

CHAR

1

Configurable item

NO_DISP

CHAR

1

Reservation/purchase req.

VORAB

CHAR

1

Preliminary order indicator

LTEXT

CHAR

1

Long text exists

LIFNR

CHAR

10

Vendor

MATKL

CHAR

9

Material group

WEBAZ

DEC

3

Goods receipt processing time

BANFNR

CHAR

10

Purchase requisitions

BANFPO

NUMC

5

Item

EINHEIT

UNIT

3

Base unit of measure

FLG_PURS

CHAR

1

Purchase order exists

WEMNG_CMP

QUAN

17

Goods receipt quantity

WEMEH_CMP

UNIT

3

Order unit

KNTTP

CHAR

1

Account assignment category

PSTXTAR

CHAR

2

PS text

PSTXTTI

CHAR

20

Description

STATXT

CHAR

40

Status