Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/GL11111
Product: Microsoft Dynamics GP (0)
Series: Financial
Display Name: Account Summary History View
Physical Name: GL11111
Technical Name: GL_Account_SUM_HIST_ViewSeq 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 History View'].ACTINDX AS 'Account Summary History View-Account Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
GL11111 AS ['Account Summary History View']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['Account Summary History View'].ACTINDX = ['Account Index Master'].ACTINDX2 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 History View'].ACCATNUM AS 'Account Summary History View-Account Category Number'
,['Account Category Master'].ACCATNUM AS 'Account Category Master-Account Category Number'
FROM
GL11111 AS ['Account Summary History View']
INNER JOIN
GL00102 AS ['Account Category Master']
ON
['Account Summary History View'].ACCATNUM = ['Account Category Master'].ACCATNUM16 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 History View'].NOTEINDX AS 'Account Summary History View-Note Index'
,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
GL11111 AS ['Account Summary History View']
INNER JOIN
SY03900 AS ['Record Notes Master']
ON
['Account Summary History View'].NOTEINDX = ['Record Notes Master'].NOTEINDX33 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