Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/AF50200
Product: Microsoft Dynamics GP (0)
Series: Financial
Display Name: Financials Subsidiary Total Temporary
Physical Name: AF50200
Technical Name: AF_Subsidiary_Total_TEMPSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 USERID 
User ID String STR15_User_ID 15 Key to the Users Master (SY01400).
Click to show/hide
SELECT
['Financials Subsidiary Total Temporary'].USERID AS 'Financials Subsidiary Total Temporary-User ID'
,['Users Master'].USERID AS 'Users Master-User ID'
FROM
AF50200 AS ['Financials Subsidiary Total Temporary']
INNER JOIN
DYNAMICS..SY01400 AS ['Users Master']
ON
['Financials Subsidiary Total Temporary'].USERID = ['Users Master'].USERID2 REPORTID Report ID Integer INT_STORAGE 0 3 SUBSUDID Subsidiary ID String STR15 15 4 STTACCT_1 Start ACCT:Account_Mask_Pool1 String Account_Mask_Pool1 6 5 STTACCT_2 Start ACCT:Account_Mask_Pool2 String Account_Mask_Pool2 6 6 STTACCT_3 Start ACCT:Account_Mask_Pool3 String Account_Mask_Pool3 6 7 STTACCT_4 Start ACCT:Account_Mask_Pool4 String Account_Mask_Pool4 6 8 STTACCT_5 Start ACCT:Account_Mask_Pool5 String Account_Mask_Pool5 6 9 STTACCT_6 Start ACCT:Account_Mask_Pool6 String Account_Mask_Pool6 6 10 STTACCT_7 Start ACCT:Account_Mask_Pool7 String Account_Mask_Pool7 6 11 STTACCT_8 Start ACCT:Account_Mask_Pool8 String Account_Mask_Pool8 6 12 STTACCT_9 Start ACCT:Account_Mask_Pool9 String Account_Mask_Pool9 6 13 STTACCT_10 Start ACCT:Account_Mask_Pool10 String Account_Mask_Pool10 6 14 ENDACCT_1 End ACCT:Account_Mask_Pool1 String Account_Mask_Pool1 6 15 ENDACCT_2 End ACCT:Account_Mask_Pool2 String Account_Mask_Pool2 6 16 ENDACCT_3 End ACCT:Account_Mask_Pool3 String Account_Mask_Pool3 6 17 ENDACCT_4 End ACCT:Account_Mask_Pool4 String Account_Mask_Pool4 6 18 ENDACCT_5 End ACCT:Account_Mask_Pool5 String Account_Mask_Pool5 6 19 ENDACCT_6 End ACCT:Account_Mask_Pool6 String Account_Mask_Pool6 6 20 ENDACCT_7 End ACCT:Account_Mask_Pool7 String Account_Mask_Pool7 6 21 ENDACCT_8 End ACCT:Account_Mask_Pool8 String Account_Mask_Pool8 6 22 ENDACCT_9 End ACCT:Account_Mask_Pool9 String Account_Mask_Pool9 6 23 ENDACCT_10 End ACCT:Account_Mask_Pool10 String Account_Mask_Pool10 6 24 SUBTOTAM_1 Subsidiary Total Amount[1] Currency DLR19_$S2 19 25 SUBTOTAM_2 Subsidiary Total Amount[2] Currency DLR19_$S2 19 26 SUBTOTAM_3 Subsidiary Total Amount[3] Currency DLR19_$S2 19 27 SUBTOTAM_4 Subsidiary Total Amount[4] Currency DLR19_$S2 19 28 SUBTOTAM_5 Subsidiary Total Amount[5] Currency DLR19_$S2 19 29 SUBTOTAM_6 Subsidiary Total Amount[6] Currency DLR19_$S2 19 30 SUBTOTAM_7 Subsidiary Total Amount[7] Currency DLR19_$S2 19 31 SUBTOTAM_8 Subsidiary Total Amount[8] Currency DLR19_$S2 19 32 SUBTOTAM_9 Subsidiary Total Amount[9] Currency DLR19_$S2 19 33 SUBTOTAM_10 Subsidiary Total Amount[10] Currency DLR19_$S2 19 34 SUBTOTAM_11 Subsidiary Total Amount[11] Currency DLR19_$S2 19 35 SUBTOTAM_12 Subsidiary Total Amount[12] Currency DLR19_$S2 19 36 SUBTOTAM_13 Subsidiary Total Amount[13] Currency DLR19_$S2 19 37 SUBTOTAM_14 Subsidiary Total Amount[14] Currency DLR19_$S2 19 38 SUBTOTAM_15 Subsidiary Total Amount[15] Currency DLR19_$S2 19 39 SUBTOTAM_16 Subsidiary Total Amount[16] Currency DLR19_$S2 19 40 SUBTOTAM_17 Subsidiary Total Amount[17] Currency DLR19_$S2 19 41 SUBTOTAM_18 Subsidiary Total Amount[18] Currency DLR19_$S2 19 42 SUBTOTAM_19 Subsidiary Total Amount[19] Currency DLR19_$S2 19 43 SUBTOTAM_20 Subsidiary Total Amount[20] Currency DLR19_$S2 19 44 SUBTOTAM_21 Subsidiary Total Amount[21] Currency DLR19_$S2 19 45 SUBTOTAM_22 Subsidiary Total Amount[22] Currency DLR19_$S2 19 46 SUBTOTAM_23 Subsidiary Total Amount[23] Currency DLR19_$S2 19 47 SUBTOTAM_24 Subsidiary Total Amount[24] Currency DLR19_$S2 19 48 SUBTOTAM_25 Subsidiary Total Amount[25] Currency DLR19_$S2 19 49 SUBTOTAM_26 Subsidiary Total Amount[26] Currency DLR19_$S2 19 50 SUBTOTAM_27 Subsidiary Total Amount[27] Currency DLR19_$S2 19 51 SUBTOTAM_28 Subsidiary Total Amount[28] Currency DLR19_$S2 19 52 SUBTOTAM_29 Subsidiary Total Amount[29] Currency DLR19_$S2 19 53 SUBTOTAM_30 Subsidiary Total Amount[30] Currency DLR19_$S2 19 54 SUBTOTAM_31 Subsidiary Total Amount[31] Currency DLR19_$S2 19 55 SUBTOTAM_32 Subsidiary Total Amount[32] Currency DLR19_$S2 19 56 SUBTOTAM_33 Subsidiary Total Amount[33] Currency DLR19_$S2 19 57 SUBTOTAM_34 Subsidiary Total Amount[34] Currency DLR19_$S2 19 58 SUBTOTAM_35 Subsidiary Total Amount[35] Currency DLR19_$S2 19 59 SUBTOTAM_36 Subsidiary Total Amount[36] Currency DLR19_$S2 19 60 SUBTOTAM_37 Subsidiary Total Amount[37] Currency DLR19_$S2 19 61 SUBTOTAM_38 Subsidiary Total Amount[38] Currency DLR19_$S2 19 62 SUBTOTAM_39 Subsidiary Total Amount[39] Currency DLR19_$S2 19 63 SUBTOTAM_40 Subsidiary Total Amount[40] Currency DLR19_$S2 19 64 PRCSSQNC Process Sequence Integer INT 0