Project Management - Summary - History

Table Name: APH8

Table Description: Project Management - Summary - History

Field	Description	Type	Size	Related	Default Value	Constraints
AbsEntry	Internal Key	Int	11	-
LineID	Row No.	Int	11	-
PhBudget	Subproject Budget	Num	19.6	-
OpenAmtAP	Open Amount (A/P)	Num	19.6	-
InvoicedAP	Invoiced (A/P)	Num	19.6	-
TotalAP	Total (A/P)	Num	19.6	-
TotVarAP	Total Variance (A/P)	Num	19.6	-
VarPercAP	Variance Percentage (A/P)	Num	19.6	-
AccPhBudg	Accumulated Subproject Budget	Num	19.6	-
AccOpAmAP	Accumulated Open Amount (A/P)	Num	19.6	-
AccInvAP	Accumulated Invoiced (A/P)	Num	19.6	-
AccTotAP	Accumulated Total (A/P)	Num	19.6	-
AccTVarAP	Accumulated Total Variance (A/P)	Num	19.6	-
AccVPercAP	Accumulated Variance Percentage (A/P)	Num	19.6	-
PoPhAmt	Potential Subproject Amount	Num	19.6	-
OpenAmtAR	Open Amount (A/R)	Num	19.6	-
InvoicedAR	Invoiced (A/R)	Num	19.6	-
TotalAR	Total (A/R)	Num	19.6	-
TotVarAR	Total Variance (A/R)	Num	19.6	-
VarPercAR	Variance Percentage (A/R)	Num	19.6	-
AccPoPhAmt	Accumulated Potential Subproject Amount	Num	19.6	-
AccOpAmAR	Accumulated Open Amount (A/R)	Num	19.6	-
AccInvAR	Accumulated Invoiced (A/R)	Num	19.6	-
AccTotAR	Accumulated Total (A/R)	Num	19.6	-
AccTVarAR	Accumulated Total Variance (A/R)	Num	19.6	-
AccVPercAR	Accumulated Variance Percentage (A/R)	Num	19.6	-
ActICCost	Actual Item Component Cost	Num	19.6	-
ActRCCost	Actual Resource Component Cost	Num	19.6	-
ActAddCost	Actual Additional Cost	Num	19.6	-
ActPrCost	Actual Product Cost	Num	19.6	-
ActBPrCost	Actual By-Product Cost	Num	19.6	-
TotalVar	Total Variance	Num	19.6	-
DueDate	Due Date	Date	8	-
CloseDate	Actual Closing Date	Date	8	-
Overdue	Overdue	Int	11	-	0
Valid	If the calculated data is valid	VarChar	1	-	N	Y	Yes
						N	No
LogInstanc	Log Instance	Int	11	-	0

Key	Unique	Field
PRIMARY	Yes	AbsEntry
		LineID
		LogInstanc