Project Management - Stages - History

Table Name: APM1

Table Description: Project Management - Stages - History

Field	Description	Type	Size	Related	Default Value	Constraints
AbsEntry	Internal Key	Int	11	OPMG
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	-