| Field |
Description |
Type |
Size |
Related |
Default Value |
Constraints |
| AbsEntry |
Internal Key |
Int |
11 |
OPHA |
|
|
|
| LineID |
Row No. |
Int |
11 |
- |
|
|
|
| StageID |
Stage ID |
Int |
11 |
PMC2 |
|
|
|
| POS |
Position |
Int |
11 |
- |
|
|
|
| START |
Start Date |
Date |
8 |
- |
|
|
|
| CLOSE |
Closing Date |
Date |
8 |
- |
|
|
|
| FINISHDATE |
Finished Date |
Date |
8 |
- |
|
|
|
| Task |
Task Type |
Int |
11 |
- |
|
|
|
| DSCRIPTION |
Description |
Text |
16 |
- |
|
|
|
| EXPCOSTS |
Planned Cost |
Num |
19.6 |
- |
|
|
|
| InvAmtAR |
Invoiced Amount (A/R) |
Num |
19.6 |
- |
|
|
|
| OpenAmtAR |
Open Amount (A/R) |
Num |
19.6 |
- |
|
|
|
| InvAmtAP |
Invoiced Amount (A/P) |
Num |
19.6 |
- |
|
|
|
| OpenAmtAP |
Open Amount (A/P) |
Num |
19.6 |
- |
|
|
|
| PERCENT |
Contribution Rate - Percentage |
Num |
19.6 |
- |
|
|
|
| FINISH |
Finished |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| OWNER |
Owner |
Int |
11 |
OHEM |
|
|
|
| StageDep1 |
Stage Dependence (1) |
Int |
11 |
- |
|
|
|
| StageDep2 |
Stage Dependence (2) |
Int |
11 |
- |
|
|
|
| StageDep3 |
Stage Dependence (3) |
Int |
11 |
- |
|
|
|
| StageDep4 |
Stage Dependence (4) |
Int |
11 |
- |
|
|
|
| StDp1Type |
Stage Dependence (1) project type |
VarChar |
1 |
- |
P |
P |
Project |
| |
|
|
|
|
|
S |
Subproject |
| StDp2Type |
Stage Dependence (2) project type |
VarChar |
1 |
- |
P |
P |
Project |
| |
|
|
|
|
|
S |
Subproject |
| StDp3Type |
Stage Dependence (3) project type |
VarChar |
1 |
- |
P |
P |
Project |
| |
|
|
|
|
|
S |
Subproject |
| StDp4Type |
Stage Dependence (4) project type |
VarChar |
1 |
- |
P |
P |
Project |
| |
|
|
|
|
|
S |
Subproject |
| StDp1Abs |
Stage Dependence (1) project key |
Int |
11 |
- |
|
|
|
| StDp2Abs |
Stage Dependence (2) project key |
Int |
11 |
- |
|
|
|
| StDp3Abs |
Stage Dependence (3) project key |
Int |
11 |
- |
|
|
|
| StDp4Abs |
Stage Dependence (4) project key |
Int |
11 |
- |
|
|
|
| LogInstanc |
Log Instance |
Int |
11 |
- |
0 |
|
|
| AtcEntry |
Attachment Entry |
Int |
11 |
OATC |
|
|
|
| UniqueID |
Unique ID |
nVarChar |
50 |
- |
|
|
|
| EncryptIV |
Encrypt IV |
nVarChar |
100 |
- |
|
|
|