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 DEX_ROW_ID is an auto-numbered IDENTITY column used internally by Dexterity for lock management; it should not be used by developers to identify any particular piece of information. Microsoft MVP Mariano Gomez has a good write up on the DEX_ROW_ID column.
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 STR15_User_ID String 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'].USERID
2 REPORTID Report ID INT_STORAGE Integer 0 3 SUBSUDID Subsidiary ID STR15 String 15 4 STTACCT_1 Start ACCT:Account_Mask_Pool1 Account_Mask_Pool1 String 6 5 STTACCT_2 Start ACCT:Account_Mask_Pool2 Account_Mask_Pool2 String 6 6 STTACCT_3 Start ACCT:Account_Mask_Pool3 Account_Mask_Pool3 String 6 7 STTACCT_4 Start ACCT:Account_Mask_Pool4 Account_Mask_Pool4 String 6 8 STTACCT_5 Start ACCT:Account_Mask_Pool5 Account_Mask_Pool5 String 6 9 STTACCT_6 Start ACCT:Account_Mask_Pool6 Account_Mask_Pool6 String 6 10 STTACCT_7 Start ACCT:Account_Mask_Pool7 Account_Mask_Pool7 String 6 11 STTACCT_8 Start ACCT:Account_Mask_Pool8 Account_Mask_Pool8 String 6 12 STTACCT_9 Start ACCT:Account_Mask_Pool9 Account_Mask_Pool9 String 6 13 STTACCT_10 Start ACCT:Account_Mask_Pool10 Account_Mask_Pool10 String 6 14 ENDACCT_1 End ACCT:Account_Mask_Pool1 Account_Mask_Pool1 String 6 15 ENDACCT_2 End ACCT:Account_Mask_Pool2 Account_Mask_Pool2 String 6 16 ENDACCT_3 End ACCT:Account_Mask_Pool3 Account_Mask_Pool3 String 6 17 ENDACCT_4 End ACCT:Account_Mask_Pool4 Account_Mask_Pool4 String 6 18 ENDACCT_5 End ACCT:Account_Mask_Pool5 Account_Mask_Pool5 String 6 19 ENDACCT_6 End ACCT:Account_Mask_Pool6 Account_Mask_Pool6 String 6 20 ENDACCT_7 End ACCT:Account_Mask_Pool7 Account_Mask_Pool7 String 6 21 ENDACCT_8 End ACCT:Account_Mask_Pool8 Account_Mask_Pool8 String 6 22 ENDACCT_9 End ACCT:Account_Mask_Pool9 Account_Mask_Pool9 String 6 23 ENDACCT_10 End ACCT:Account_Mask_Pool10 Account_Mask_Pool10 String 6 24 SUBTOTAM_1 Subsidiary Total Amount[1] DLR19_$S2 Currency 19 25 SUBTOTAM_2 Subsidiary Total Amount[2] DLR19_$S2 Currency 19 26 SUBTOTAM_3 Subsidiary Total Amount[3] DLR19_$S2 Currency 19 27 SUBTOTAM_4 Subsidiary Total Amount[4] DLR19_$S2 Currency 19 28 SUBTOTAM_5 Subsidiary Total Amount[5] DLR19_$S2 Currency 19 29 SUBTOTAM_6 Subsidiary Total Amount[6] DLR19_$S2 Currency 19 30 SUBTOTAM_7 Subsidiary Total Amount[7] DLR19_$S2 Currency 19 31 SUBTOTAM_8 Subsidiary Total Amount[8] DLR19_$S2 Currency 19 32 SUBTOTAM_9 Subsidiary Total Amount[9] DLR19_$S2 Currency 19 33 SUBTOTAM_10 Subsidiary Total Amount[10] DLR19_$S2 Currency 19 34 SUBTOTAM_11 Subsidiary Total Amount[11] DLR19_$S2 Currency 19 35 SUBTOTAM_12 Subsidiary Total Amount[12] DLR19_$S2 Currency 19 36 SUBTOTAM_13 Subsidiary Total Amount[13] DLR19_$S2 Currency 19 37 SUBTOTAM_14 Subsidiary Total Amount[14] DLR19_$S2 Currency 19 38 SUBTOTAM_15 Subsidiary Total Amount[15] DLR19_$S2 Currency 19 39 SUBTOTAM_16 Subsidiary Total Amount[16] DLR19_$S2 Currency 19 40 SUBTOTAM_17 Subsidiary Total Amount[17] DLR19_$S2 Currency 19 41 SUBTOTAM_18 Subsidiary Total Amount[18] DLR19_$S2 Currency 19 42 SUBTOTAM_19 Subsidiary Total Amount[19] DLR19_$S2 Currency 19 43 SUBTOTAM_20 Subsidiary Total Amount[20] DLR19_$S2 Currency 19 44 SUBTOTAM_21 Subsidiary Total Amount[21] DLR19_$S2 Currency 19 45 SUBTOTAM_22 Subsidiary Total Amount[22] DLR19_$S2 Currency 19 46 SUBTOTAM_23 Subsidiary Total Amount[23] DLR19_$S2 Currency 19 47 SUBTOTAM_24 Subsidiary Total Amount[24] DLR19_$S2 Currency 19 48 SUBTOTAM_25 Subsidiary Total Amount[25] DLR19_$S2 Currency 19 49 SUBTOTAM_26 Subsidiary Total Amount[26] DLR19_$S2 Currency 19 50 SUBTOTAM_27 Subsidiary Total Amount[27] DLR19_$S2 Currency 19 51 SUBTOTAM_28 Subsidiary Total Amount[28] DLR19_$S2 Currency 19 52 SUBTOTAM_29 Subsidiary Total Amount[29] DLR19_$S2 Currency 19 53 SUBTOTAM_30 Subsidiary Total Amount[30] DLR19_$S2 Currency 19 54 SUBTOTAM_31 Subsidiary Total Amount[31] DLR19_$S2 Currency 19 55 SUBTOTAM_32 Subsidiary Total Amount[32] DLR19_$S2 Currency 19 56 SUBTOTAM_33 Subsidiary Total Amount[33] DLR19_$S2 Currency 19 57 SUBTOTAM_34 Subsidiary Total Amount[34] DLR19_$S2 Currency 19 58 SUBTOTAM_35 Subsidiary Total Amount[35] DLR19_$S2 Currency 19 59 SUBTOTAM_36 Subsidiary Total Amount[36] DLR19_$S2 Currency 19 60 SUBTOTAM_37 Subsidiary Total Amount[37] DLR19_$S2 Currency 19 61 SUBTOTAM_38 Subsidiary Total Amount[38] DLR19_$S2 Currency 19 62 SUBTOTAM_39 Subsidiary Total Amount[39] DLR19_$S2 Currency 19 63 SUBTOTAM_40 Subsidiary Total Amount[40] DLR19_$S2 Currency 19 64 PRCSSQNC Process Sequence INT Integer 0 65 DEX_ROW_ID int int 10