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 |