Microsoft Access ACTR (Activities)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 |
AUTYPTXT |
CHAR |
40 |
Order type |
STEUS |
CHAR |
4 |
Control key |
STEUTXT |
CHAR |
40 |
Control key text |
ARBPL |
CHAR |
8 |
Work center |
ARBTXT |
CHAR |
40 |
Work center text |
WERKS |
CHAR |
4 |
Plant |
KTSCH |
CHAR |
7 |
Standard text key |
LTXA1 |
CHAR |
40 |
Activity description |
TXTSP |
LANG |
1 |
Language |
RSTRA |
CHAR |
2 |
Reduction strategy |
SORTL |
CHAR |
10 |
Sort string |
LIFNR |
CHAR |
10 |
Vendor |
PREIS |
CURR |
14 |
Price |
PEINH |
DEC |
6 |
Price unit |
SAKTO |
CHAR |
10 |
Cost element |
WAERS |
CUKY |
5 |
Currency |
INFNR |
CHAR |
10 |
Purchasing info record |
ESOKZ |
CHAR |
1 |
Purchasing info record category |
EKORG |
CHAR |
4 |
Purchasing organization |
EKGRP |
CHAR |
3 |
Purchasing group |
KZLGF |
CHAR |
1 |
External processing with fixed lot–size |
KZWRTF |
CHAR |
1 |
Fixed value |
MATKL |
CHAR |
9 |
Material group |
DDEHN |
CHAR |
1 |
Extendible duration |
ANZZL |
INT1 |
3 |
Number |
PRZNT |
INT1 |
3 |
Percent |
MLSTN |
CHAR |
5 |
Milestone |
MLSTXT |
CHAR |
40 |
Milestone text |
BUKRS |
CHAR |
4 |
Company code |
ANFKO |
CHAR |
10 |
Required cost center |
ANFKOKRS |
CHAR |
4 |
Controlling area |
INDET |
CHAR |
1 |
Calculation key |
LARNT |
CHAR |
6 |
Activity type |
PRKST |
CURR |
14 |
Amount |
RUECK |
NUMC |
10 |
Confirmation |
RMZHL |
NUMC |
8 |
Counter |
BANFN |
CHAR |
10 |
Purchase requisition |
BNFPO |
NUMC |
5 |
Purchase requisition number |
KALID |
CHAR |
2 |
Factory calendar ID |
KALTX |
CHAR |
20 |
Factory calendar |
VERTL |
CHAR |
8 |
Distribution of capacity requirements: network |
LEKNW |
CHAR |
1 |
No remaining activity |
NPRIO |
CHAR |
1 |
Priority |
TXJCD |
CHAR |
15 |
Jurisdiction code |
SCOPE |
CHAR |
5 |
Object class |
GSBER |
CHAR |
4 |
Business area |
NO_DISP |
CHAR |
1 |
Reservation/purchase req. |
EVGEW |
DEC |
10 |
% completion |
CLASF |
CHAR |
1 |
Classification |
MEINH |
UNIT |
3 |
Activity unit of measure |
PLIFZ |
DEC |
3 |
Planned delivery time |
DAUNO |
QUAN |
7 |
Normal duration |
DAUNE |
UNIT |
3 |
Normal duration unit |
DAUMI |
QUAN |
7 |
Minimum duration |
DAUME |
UNIT |
3 |
Minimum duration unit |
EINSA |
CHAR |
1 |
Constraint start |
EINSE |
CHAR |
1 |
Constraint finish |
ARBEI |
QUAN |
9 |
Work |
ARBEH |
UNIT |
3 |
Work unit |
MGVRG |
QUAN |
17 |
Activity quantity |
ASVRG |
QUAN |
17 |
Scrap quantity |
ISMNW |
QUAN |
9 |
Actual work |
FSAVD |
DATS |
10 |
Earliest start date (basic) |
FSAVZ |
TIMS |
8 |
Earliest start time (basic) |
FSEDD |
DATS |
10 |
Earliest finish date (basic) |
FSEDZ |
TIMS |
8 |
Earliest finish time (basic) |
SSAVD |
DATS |
10 |
Latest start date (basic) |
SSAVZ |
TIMS |
8 |
Latest start time (basic) |
SSEDD |
DATS |
10 |
Latest finish date (basic) |
SSEDZ |
TIMS |
8 |
Latest finish time (basic) |
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 |
PUFFR |
DEC |
4 |
Free buffer |
PUFGS |
DEC |
4 |
Total buffer |
NTANF |
DATS |
10 |
Basic start date |
NTANZ |
TIMS |
8 |
Basic start time |
NTEND |
DATS |
10 |
Basic finish date |
NTENZ |
TIMS |
8 |
Basic finish time |
EWSTD |
DATS |
10 |
Forecast start date |
EWSTZ |
TIMS |
8 |
Forecast start time |
EWEND |
DATS |
10 |
Forecast finish date |
EWENZ |
TIMS |
8 |
Forecast finish time |
EWDAN |
QUAN |
7 |
Normal duration (forecast) |
EWDNE |
UNIT |
3 |
Normal duration unit (forecast) |
EWDAM |
QUAN |
7 |
Minimum duration (forecast) |
EWDME |
UNIT |
3 |
Minimum duration unit (forecast) |
EWSTE |
CHAR |
1 |
Constraint finish (forecast) |
EWSTA |
CHAR |
1 |
Constraint start (forecast) |
DABEA |
QUAN |
9 |
Processing duration |
BEAZE |
UNIT |
3 |
Processing unit |
OFMNW |
QUAN |
9 |
Forecast work |
OFFSTB |
QUAN |
7 |
Time interval start |
EHOFFB |
UNIT |
3 |
Unit |
OFFSTE |
QUAN |
7 |
Time interval finish |
EHOFFE |
UNIT |
3 |
Unit |
FPAVD |
DATS |
10 |
Earliest start date (forecast) |
FPAVZ |
TIMS |
8 |
Earliest start time (forecast) |
FPEDD |
DATS |
10 |
Earliest finish date (forecast) |
FPEDZ |
TIMS |
8 |
Earliest finish time (forecast) |
SPAVD |
DATS |
10 |
Latest start date (forecast) |
SPAVZ |
TIMS |
8 |
Latest start time (forecast) |
SPEDD |
DATS |
10 |
Latest finish date (forecast) |
SPEDZ |
TIMS |
8 |
Latest finish time (forecast) |
BEAZP |
UNIT |
3 |
Processing unit |
PUFGP |
DEC |
4 |
Total buffer |
PUFFP |
DEC |
4 |
Free buffer |
DAPBE |
QUAN |
9 |
Processing duration |
EPANF |
DATS |
10 |
Planned start date |
EPANZ |
TIMS |
8 |
Planned start time |
EPEND |
DATS |
10 |
Planned finish date |
EPENZ |
TIMS |
8 |
Planned finish time |
PDAU |
QUAN |
7 |
Forecast duration from confirmation |
PDAE |
UNIT |
3 |
Forecast duration unit |
SLWID |
CHAR |
7 |
Key word ID |
USR00 |
CHAR |
20 |
User field 1 (20 char.) |
USR01 |
CHAR |
20 |
User field 2 (20 char.) |
USR02 |
CHAR |
10 |
User field 1 (10 char.) |
USR03 |
CHAR |
10 |
User field 2 (10 char.) |
USR04 |
QUAN |
18 |
User field 1: Quantity |
USE04 |
UNIT |
3 |
User field 1: Unit of measure |
USR05 |
QUAN |
18 |
User field 2: Quantity |
USE05 |
UNIT |
3 |
User field 2: Unit of measure |
USR06 |
CURR |
18 |
User field 1: Value |
USE06 |
CUKY |
5 |
User field 1: Value unit |
USR07 |
CURR |
18 |
User field 2: Value |
USE07 |
CUKY |
5 |
User field 2: Value unit |
USR08 |
DATS |
10 |
User field 1: Date |
USR09 |
DATS |
10 |
User field 2: Date |
USR10 |
CHAR |
1 |
User field 1: Evaluation |
USR11 |
CHAR |
1 |
User field 2: Evaluation |
LOSVG |
QUAN |
17 |
Activity quantity |
LOSME |
UNIT |
3 |
Base unit of measurement |
WEMNG_OPR |
QUAN |
17 |
Goods receipt quantity |
WEMEH_OPR |
UNIT |
3 |
Order unit quantity |
FLG_PURS |
CHAR |
1 |
Purchase order exists |
FLG_VAB |
CHAR |
1 |
Subnetwork exists |
PSTXTAR |
CHAR |
2 |
PS text |
PSTXTTI |
CHAR |
20 |
PS text description |
IDAUR |
QUAN |
1 |
Actual duration |
IDAUE |
UNIT |
1 |
Unit of actual duration |
ODAUR |
QUAN |
7 |
Remaining duration |
ODAUE |
UNIT |
3 |
Remaining duration unit |
ABARBD |
NUMC |
3 |
Duration degree of processing |
REMNW |
QUAN |
9 |
Remaining work |
REMNE |
UNIT |
3 |
Work unit |
ABARBA |
NUMC |
3 |
Degree of processing |
STATXT |
CHAR |
40 |
Status |
FRUEHER |
QUAN |
7 |
Earlier |
SPAETER |
QUAN |
7 |
Later |
VERZUG |
QUAN |
7 |
Delay |
VORBEI |
QUAN |
7 |
Past |
VEINH |
UNIT |
3 |
Unit |
VGTYP |
CHAR |
3 |
Type |
FLG_RCKMLD |
CHAR |
1 |
Can be confirmed |