GL_Budget_SUM_MSTR_View (GL01201)

azurecurve Products Microsoft Dynamics GP (0)FinancialGL_Budget_SUM_MSTR_View (GL01201)

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

Product: Microsoft Dynamics GP (0)
Series: Financial

Display Name: GL_Budget_SUM_MSTR_View
Physical Name: GL01201
Technical Name: GL_Budget_SUM_MSTR_View

Seq No	Physical Name	Display Name	Dexterity Data Type	SQL Data Type	Length
1	BUDGETID	Budget ID	String	STR15_LBAU	15
	Key to the Budget Master (GL00200). Click to show/hide SELECT ['GL_Budget_SUM_MSTR_View'].BUDGETID AS 'GL_Budget_SUM_MSTR_View-Budget ID' ,['Budget Master'].BUDGETID AS 'Budget Master-Budget ID' FROM GL01201 AS ['GL_Budget_SUM_MSTR_View'] INNER JOIN GL00200 AS ['Budget Master'] ON ['GL_Budget_SUM_MSTR_View'].BUDGETID = ['Budget Master'].BUDGETID
2	ACTNUMBR_1	Account Number:Account_Segment_Pool1	String	Account_Segment_Pool1	6
3	ACTNUMBR_2	Account Number:Account_Segment_Pool2	String	Account_Segment_Pool2	6
4	ACTNUMBR_3	Account Number:Account_Segment_Pool3	String	Account_Segment_Pool3	6
5	ACTNUMBR_4	Account Number:Account_Segment_Pool4	String	Account_Segment_Pool4	6
6	ACTNUMBR_5	Account Number:Account_Segment_Pool5	String	Account_Segment_Pool5	6
7	ACTNUMBR_6	Account Number:Account_Segment_Pool6	String	Account_Segment_Pool6	6
8	ACTNUMBR_7	Account Number:Account_Segment_Pool7	String	Account_Segment_Pool7	6
9	ACTNUMBR_8	Account Number:Account_Segment_Pool8	String	Account_Segment_Pool8	6
10	ACTNUMBR_9	Account Number:Account_Segment_Pool9	String	Account_Segment_Pool9	6
11	ACTNUMBR_10	Account Number:Account_Segment_Pool10	String	Account_Segment_Pool10	6
12	PERIODID	Period ID	Integer	INT3	3
13	BUDGETAMT	Budget Amount	Currency	DLR19_$S2	19
14	ACCATNUM	Account Category Number	Integer	INT2_U0	2
	Key to the Account Category Master (GL00102). Click to show/hide SELECT ['GL_Budget_SUM_MSTR_View'].ACCATNUM AS 'GL_Budget_SUM_MSTR_View-Account Category Number' ,['Account Category Master'].ACCATNUM AS 'Account Category Master-Account Category Number' FROM GL01201 AS ['GL_Budget_SUM_MSTR_View'] INNER JOIN GL00102 AS ['Account Category Master'] ON ['GL_Budget_SUM_MSTR_View'].ACCATNUM = ['Account Category Master'].ACCATNUM
15	ACTINDX	Account Index	Long Integer	LI_14	14
	Key to the Account Index Master (GL00105). Click to show/hide SELECT ['GL_Budget_SUM_MSTR_View'].ACTINDX AS 'GL_Budget_SUM_MSTR_View-Account Index' ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index' FROM GL01201 AS ['GL_Budget_SUM_MSTR_View'] INNER JOIN GL00105 AS ['Account Index Master'] ON ['GL_Budget_SUM_MSTR_View'].ACTINDX = ['Account Index Master'].ACTINDX
16	ACTALIAS	Account Alias	String	STR20_Account_Alias	20
17	MNACSGMT	Main Account Segment	String	STR66_Seg_ID	66
18	ACCTTYPE	Account Type	Integer	DDL_Account_Type	0
19	ACTDESCR	Account Description	String	STR50	50
20	PSTNGTYP	Posting Type	Integer	GB	0
21	ACTIVE	Active	Boolean	CB_Active	0
22	TPCLBLNC	Typical Balance	Integer	GB	0
23	DECPLACS	Decimal Places	Integer	DDL_Decimal_Places	0
24	FXDORVAR	Fixed Or Variable	Integer	LB_Fixed_Or_Variable	0
25	BALFRCLC	Balance For Calculation	Integer	GB	0
26	DSPLKUPS	Display In Lookups	Long Integer	ML_Display_In_Lookups	0
27	CNVRMTHD	Conversion Method	Integer	DDL_Conversion_Method	0
28	HSTRCLRT	Historical Rate	Currency (Variable)	DLR14_Exchange_Rate	14
29	NOTEINDX	Note Index	Currency	DLR14	14
	Key to the Record Notes Master (SY03900). Click to show/hide SELECT ['GL_Budget_SUM_MSTR_View'].NOTEINDX AS 'GL_Budget_SUM_MSTR_View-Note Index' ,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index' FROM GL01201 AS ['GL_Budget_SUM_MSTR_View'] INNER JOIN SY03900 AS ['Record Notes Master'] ON ['GL_Budget_SUM_MSTR_View'].NOTEINDX = ['Record Notes Master'].NOTEINDX
30	CREATDDT	Created Date	Date	DT	8
31	MODIFDT	Modified Date	Date	DT	8
32	USERDEF1	User Defined 1	String	STR20	20
33	USERDEF2	User Defined 2	String	STR20	20

azurecurve Products Microsoft Dynamics GP (0)FinancialGL_Budget_SUM_MSTR_View (GL01201)

Click to show/hide

Click to show/hide

Click to show/hide

Click to show/hide

Leave a Reply Cancel reply