ECM_Budget_SUM_MSTR (ECM00201)

Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/ECM00201

Display Name: ECM_Budget_SUM_MSTR
Physical Name: ECM00201
Technical Name: ECM_Budget_SUM_MSTR

Seq No	Physical Name	Display Name	Dexterity Data Type	SQL Data Type	Length
1	CompanyID	ECM_CompanyID	Long Integer	LI_Sequence_Number	10
2	SessionID	ECM_SessionID	Long Integer	LI_14	14
3	BudgetID	ECM_BudgetID	String	STR15_LBAU	15
	Key to the Budget Master (GL00200). Click to show/hide SELECT ['ECM_Budget_SUM_MSTR'].BudgetID AS 'ECM_Budget_SUM_MSTR-ECM_BudgetID' ,['Budget Master'].BUDGETID AS 'Budget Master-Budget ID' FROM ECM00201 AS ['ECM_Budget_SUM_MSTR'] INNER JOIN GL00200 AS ['Budget Master'] ON ['ECM_Budget_SUM_MSTR'].BudgetID = ['Budget Master'].BUDGETID
4	PeriodID	ECM_PeriodID	Integer	INT3	3
5	BudgetAmt	ECM_BudgetAmt	Currency	DLR19_$S2	19
6	Accatnum	ECM_AcctCatNum	Integer	INT2_U0	2
	Key to the Account Category Master (GL00102). Click to show/hide SELECT ['ECM_Budget_SUM_MSTR'].Accatnum AS 'ECM_Budget_SUM_MSTR-ECM_AcctCatNum' ,['Account Category Master'].ACCATNUM AS 'Account Category Master-Account Category Number' FROM ECM00201 AS ['ECM_Budget_SUM_MSTR'] INNER JOIN GL00102 AS ['Account Category Master'] ON ['ECM_Budget_SUM_MSTR'].Accatnum = ['Account Category Master'].ACCATNUM
7	ActIndx	ECM_AcctIndx	Long Integer	LI_Sequence_Number	10
	Key to the Account Index Master (GL00105). Click to show/hide SELECT ['ECM_Budget_SUM_MSTR'].ActIndx AS 'ECM_Budget_SUM_MSTR-ECM_AcctIndx' ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index' FROM ECM00201 AS ['ECM_Budget_SUM_MSTR'] INNER JOIN GL00105 AS ['Account Index Master'] ON ['ECM_Budget_SUM_MSTR'].ActIndx = ['Account Index Master'].ACTINDX