ENCSUMTMP - Encumbrance Summary TEMP | Prospr

ENCSUMTMP - Encumbrance Summary TEMP

Select * from ENCSUMTMP

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
INDEX1	Index	Integer	2	View
SMRYTYPE	Summary Type	Integer	2	View
PERIODID	Period ID	Integer	2	View
PERNAME	Period Name	String	22	View
FRMACTIX	From Account Index	Long Integer	4	View
TOACTIDX	To Account Index	Long Integer	4	View
From_Account_Number_1	From Account Number:Account_Segment_Pool1	String	10	View
From_Account_Number_2	From Account Number:Account_Segment_Pool2	String	10	View
From_Account_Number_3	From Account Number:Account_Segment_Pool3	String	10	View
From_Account_Number_4	From Account Number:Account_Segment_Pool4	String	10	View
From_Account_Number_5	From Account Number:Account_Segment_Pool5	String	10	View
To_Account_Number_1	To Account Number:Account_Segment_Pool1	String	10	View
To_Account_Number_2	To Account Number:Account_Segment_Pool2	String	10	View
To_Account_Number_3	To Account Number:Account_Segment_Pool3	String	10	View
To_Account_Number_4	To Account Number:Account_Segment_Pool4	String	10	View
To_Account_Number_5	To Account Number:Account_Segment_Pool5	String	10	View
Actual_Amount	Actual Amount	Currency	10	View
ENCMBAMT	Encumbered Amount	Currency	10	View
CMTEDAMT	Committed Amount	Currency	10	View
BUDGETAMT	Budget Amount	Currency	10	View
Variance_Amount	Variance Amount	Currency	10	View
Variance_Percentage	Variance Percentage	Currency	10	View
YEAR1	Year	Integer	2	View
PreEncumberedAmt	PreEncumbered Amount	Currency	10	View
PreBudgetAmt	PreBudget Amount	Currency	10	View