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 |