Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/AF50100
Product: Microsoft Dynamics GP (0)
Series: Financial
Display Name: Financials Total Temporary
Physical Name: AF50100
Technical Name: AF_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 Total Temporary'].USERID AS 'Financials Total Temporary-User ID'
,['Users Master'].USERID AS 'Users Master-User ID'
FROM
AF50100 AS ['Financials Total Temporary']
INNER JOIN
DYNAMICS..SY01400 AS ['Users Master']
ON
['Financials Total Temporary'].USERID = ['Users Master'].USERID
2 REPORTID Report ID Integer INT_STORAGE 0 3 TOTRWNUM Total Row NUM Integer INT_STORAGE 0 4 STACCNDX Start Account Index Long Integer LI_14 14 5 EDACCNDX End Account Index Long Integer LI_14 14 6 TOTLAMNT_1 Total Amount[1] Currency DLR19_$S2 19 7 TOTLAMNT_2 Total Amount[2] Currency DLR19_$S2 19 8 TOTLAMNT_3 Total Amount[3] Currency DLR19_$S2 19 9 TOTLAMNT_4 Total Amount[4] Currency DLR19_$S2 19 10 TOTLAMNT_5 Total Amount[5] Currency DLR19_$S2 19 11 TOTLAMNT_6 Total Amount[6] Currency DLR19_$S2 19 12 TOTLAMNT_7 Total Amount[7] Currency DLR19_$S2 19 13 TOTLAMNT_8 Total Amount[8] Currency DLR19_$S2 19 14 TOTLAMNT_9 Total Amount[9] Currency DLR19_$S2 19 15 TOTLAMNT_10 Total Amount[10] Currency DLR19_$S2 19 16 TOTLAMNT_11 Total Amount[11] Currency DLR19_$S2 19 17 TOTLAMNT_12 Total Amount[12] Currency DLR19_$S2 19 18 TOTLAMNT_13 Total Amount[13] Currency DLR19_$S2 19 19 TOTLAMNT_14 Total Amount[14] Currency DLR19_$S2 19 20 TOTLAMNT_15 Total Amount[15] Currency DLR19_$S2 19 21 TOTLAMNT_16 Total Amount[16] Currency DLR19_$S2 19 22 TOTLAMNT_17 Total Amount[17] Currency DLR19_$S2 19 23 TOTLAMNT_18 Total Amount[18] Currency DLR19_$S2 19 24 TOTLAMNT_19 Total Amount[19] Currency DLR19_$S2 19 25 TOTLAMNT_20 Total Amount[20] Currency DLR19_$S2 19 26 TOTLAMNT_21 Total Amount[21] Currency DLR19_$S2 19 27 TOTLAMNT_22 Total Amount[22] Currency DLR19_$S2 19 28 TOTLAMNT_23 Total Amount[23] Currency DLR19_$S2 19 29 TOTLAMNT_24 Total Amount[24] Currency DLR19_$S2 19 30 TOTLAMNT_25 Total Amount[25] Currency DLR19_$S2 19 31 TOTLAMNT_26 Total Amount[26] Currency DLR19_$S2 19 32 TOTLAMNT_27 Total Amount[27] Currency DLR19_$S2 19 33 TOTLAMNT_28 Total Amount[28] Currency DLR19_$S2 19 34 TOTLAMNT_29 Total Amount[29] Currency DLR19_$S2 19 35 TOTLAMNT_30 Total Amount[30] Currency DLR19_$S2 19 36 TOTLAMNT_31 Total Amount[31] Currency DLR19_$S2 19 37 TOTLAMNT_32 Total Amount[32] Currency DLR19_$S2 19 38 TOTLAMNT_33 Total Amount[33] Currency DLR19_$S2 19 39 TOTLAMNT_34 Total Amount[34] Currency DLR19_$S2 19 40 TOTLAMNT_35 Total Amount[35] Currency DLR19_$S2 19 41 TOTLAMNT_36 Total Amount[36] Currency DLR19_$S2 19 42 TOTLAMNT_37 Total Amount[37] Currency DLR19_$S2 19 43 TOTLAMNT_38 Total Amount[38] Currency DLR19_$S2 19 44 TOTLAMNT_39 Total Amount[39] Currency DLR19_$S2 19 45 TOTLAMNT_40 Total Amount[40] Currency DLR19_$S2 19 46 ACTOTAMT_1 Actual Total Amount[1] Currency DLR19_$S2 19 47 ACTOTAMT_2 Actual Total Amount[2] Currency DLR19_$S2 19 48 ACTOTAMT_3 Actual Total Amount[3] Currency DLR19_$S2 19 49 ACTOTAMT_4 Actual Total Amount[4] Currency DLR19_$S2 19 50 ACTOTAMT_5 Actual Total Amount[5] Currency DLR19_$S2 19 51 ACTOTAMT_6 Actual Total Amount[6] Currency DLR19_$S2 19 52 ACTOTAMT_7 Actual Total Amount[7] Currency DLR19_$S2 19 53 ACTOTAMT_8 Actual Total Amount[8] Currency DLR19_$S2 19 54 ACTOTAMT_9 Actual Total Amount[9] Currency DLR19_$S2 19 55 ACTOTAMT_10 Actual Total Amount[10] Currency DLR19_$S2 19 56 ACTOTAMT_11 Actual Total Amount[11] Currency DLR19_$S2 19 57 ACTOTAMT_12 Actual Total Amount[12] Currency DLR19_$S2 19 58 ACTOTAMT_13 Actual Total Amount[13] Currency DLR19_$S2 19 59 ACTOTAMT_14 Actual Total Amount[14] Currency DLR19_$S2 19 60 ACTOTAMT_15 Actual Total Amount[15] Currency DLR19_$S2 19 61 ACTOTAMT_16 Actual Total Amount[16] Currency DLR19_$S2 19 62 ACTOTAMT_17 Actual Total Amount[17] Currency DLR19_$S2 19 63 ACTOTAMT_18 Actual Total Amount[18] Currency DLR19_$S2 19 64 ACTOTAMT_19 Actual Total Amount[19] Currency DLR19_$S2 19 65 ACTOTAMT_20 Actual Total Amount[20] Currency DLR19_$S2 19 66 ACTOTAMT_21 Actual Total Amount[21] Currency DLR19_$S2 19 67 ACTOTAMT_22 Actual Total Amount[22] Currency DLR19_$S2 19 68 ACTOTAMT_23 Actual Total Amount[23] Currency DLR19_$S2 19 69 ACTOTAMT_24 Actual Total Amount[24] Currency DLR19_$S2 19 70 ACTOTAMT_25 Actual Total Amount[25] Currency DLR19_$S2 19 71 ACTOTAMT_26 Actual Total Amount[26] Currency DLR19_$S2 19 72 ACTOTAMT_27 Actual Total Amount[27] Currency DLR19_$S2 19 73 ACTOTAMT_28 Actual Total Amount[28] Currency DLR19_$S2 19 74 ACTOTAMT_29 Actual Total Amount[29] Currency DLR19_$S2 19 75 ACTOTAMT_30 Actual Total Amount[30] Currency DLR19_$S2 19 76 ACTOTAMT_31 Actual Total Amount[31] Currency DLR19_$S2 19 77 ACTOTAMT_32 Actual Total Amount[32] Currency DLR19_$S2 19 78 ACTOTAMT_33 Actual Total Amount[33] Currency DLR19_$S2 19 79 ACTOTAMT_34 Actual Total Amount[34] Currency DLR19_$S2 19 80 ACTOTAMT_35 Actual Total Amount[35] Currency DLR19_$S2 19 81 ACTOTAMT_36 Actual Total Amount[36] Currency DLR19_$S2 19 82 ACTOTAMT_37 Actual Total Amount[37] Currency DLR19_$S2 19 83 ACTOTAMT_38 Actual Total Amount[38] Currency DLR19_$S2 19 84 ACTOTAMT_39 Actual Total Amount[39] Currency DLR19_$S2 19 85 ACTOTAMT_40 Actual Total Amount[40] Currency DLR19_$S2 19 86 PRCSSQNC Process Sequence Integer INT 0