Microsoft Access PRPSR (WBS Elements)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 |
POST1 |
CHAR |
40 |
Description |
POSKI |
CHAR |
16 |
Short ID (WBS element) |
ERNAM |
CHAR |
12 |
Created by |
VERNR |
NUMC |
8 |
Responsible person (number) |
VERNA |
CHAR |
25 |
Responsible person (name) |
ASTNR |
NUMC |
8 |
Applicant (number) |
ASTNA |
CHAR |
25 |
Applicant (name) |
PBUKR |
CHAR |
4 |
Company code |
PGSBR |
CHAR |
4 |
Business area |
PKOKR |
CHAR |
4 |
Controlling area |
PRART |
CHAR |
2 |
Project type |
PLAKZ |
CHAR |
1 |
Planning element ind. |
BELKZ |
CHAR |
1 |
Account assign. element ind. |
FAKKZ |
CHAR |
1 |
Billing element ind. |
STUFE |
NUMC |
3 |
Level |
AKOKR |
CHAR |
4 |
Required controlling area |
AKSTL |
CHAR |
10 |
Required cost center |
AKTXT |
CHAR |
40 |
Reqd cost center description |
FKOKR |
CHAR |
4 |
Controlling area resp. cost ctr |
FKSTL |
CHAR |
10 |
Responsible cost center |
FKTXT |
CHAR |
40 |
Resp. cost center description |
FABKL |
CHAR |
2 |
Calendar |
PSPRI |
CHAR |
1 |
Priority |
EQUNR |
CHAR |
18 |
Equipment number |
TPLNR |
CHAR |
30 |
Technical location |
PWPOS |
CUKY |
5 |
Currency |
WERKS |
CHAR |
4 |
Plant |
TXTSP |
LANG |
1 |
Language |
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: Selection |
USR11 |
CHAR |
1 |
User field 2: Selection |
CLASF |
CHAR |
1 |
Classified |
SCOPE |
CHAR |
5 |
Object class |
XSTAT |
CHAR |
1 |
Statistic |
TXJCD |
CHAR |
15 |
Jurisdiction code |
ZSCHM |
CHAR |
7 |
Interest calculation profile |
IMPRF |
CHAR |
6 |
Investment profile |
EVGEW |
DEC |
10 |
% completion |
SUBPR |
CHAR |
12 |
Subproject |
PSPCODE |
CHAR |
50 |
WBS code |
PSTRT |
DATS |
10 |
Basic start date |
ESTRT |
DATS |
10 |
Forecast start date |
ISTRT |
DATS |
10 |
Actual start date |
PENDE |
DATS |
10 |
Basic finish date |
EENDE |
DATS |
10 |
Forecast finish date |
IENDE |
DATS |
10 |
Actual finish date |
PDAUR |
QUAN |
7 |
Basic duration |
EDAUR |
QUAN |
7 |
Forecast duration |
IDAUR |
QUAN |
7 |
Actual duration |
IEINH |
UNIT |
3 |
Unit |
EEINH |
UNIT |
3 |
Unit |
PEINH |
UNIT |
3 |
Unit |
PSTRM |
DATS |
10 |
Sched. start date (basic) |
PETRM |
DATS |
10 |
Sched. finish date (basic) |
ESTRM |
DATS |
10 |
Sched. start date (forecast) |
EETRM |
DATS |
10 |
Sched. finish date (forecast) |
VISTR |
DATS |
10 |
Tentative start date |
VIEND |
DATS |
10 |
Tentative finish date |
STATXT |
CHAR |
40 |
Status |
FRUEHER |
QUAN |
7 |
Earlier |
SPAETER |
QUAN |
7 |
Later |
VERZUG |
QUAN |
7 |
Delay |
VORBEI |
QUAN |
7 |
Past |
VEINH |
UNIT |
3 |
Unit |