Account Summary Master View (GL11110)

azurecurve Products Microsoft Dynamics GP (0)FinancialAccount Summary Master View (GL11110)

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

Product: Microsoft Dynamics GP (0)
Series: Financial

Display Name: Account Summary Master View
Physical Name: GL11110
Technical Name: GL_Account_SUM_MSTR_View

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

azurecurve Products Microsoft Dynamics GP (0)FinancialAccount Summary Master View (GL11110)

Click to show/hide

Click to show/hide

Click to show/hide

Leave a Reply Cancel reply