Financials Subsidiary Total Temporary (AF50200)

azurecurveProductsMicrosoft Dynamics GP (0)FinancialFinancials Subsidiary Total Temporary (AF50200)

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_TEMP

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1USERID SearchUser IDSTR15_User_IDString15
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
2REPORTID SearchReport IDINT_STORAGEInteger0
3SUBSUDID SearchSubsidiary IDSTR15String15
4STTACCT_1 SearchStart ACCT:Account_Mask_Pool1Account_Mask_Pool1String6
5STTACCT_2 SearchStart ACCT:Account_Mask_Pool2Account_Mask_Pool2String6
6STTACCT_3 SearchStart ACCT:Account_Mask_Pool3Account_Mask_Pool3String6
7STTACCT_4 SearchStart ACCT:Account_Mask_Pool4Account_Mask_Pool4String6
8STTACCT_5 SearchStart ACCT:Account_Mask_Pool5Account_Mask_Pool5String6
9STTACCT_6 SearchStart ACCT:Account_Mask_Pool6Account_Mask_Pool6String6
10STTACCT_7 SearchStart ACCT:Account_Mask_Pool7Account_Mask_Pool7String6
11STTACCT_8 SearchStart ACCT:Account_Mask_Pool8Account_Mask_Pool8String6
12STTACCT_9 SearchStart ACCT:Account_Mask_Pool9Account_Mask_Pool9String6
13STTACCT_10 SearchStart ACCT:Account_Mask_Pool10Account_Mask_Pool10String6
14ENDACCT_1 SearchEnd ACCT:Account_Mask_Pool1Account_Mask_Pool1String6
15ENDACCT_2 SearchEnd ACCT:Account_Mask_Pool2Account_Mask_Pool2String6
16ENDACCT_3 SearchEnd ACCT:Account_Mask_Pool3Account_Mask_Pool3String6
17ENDACCT_4 SearchEnd ACCT:Account_Mask_Pool4Account_Mask_Pool4String6
18ENDACCT_5 SearchEnd ACCT:Account_Mask_Pool5Account_Mask_Pool5String6
19ENDACCT_6 SearchEnd ACCT:Account_Mask_Pool6Account_Mask_Pool6String6
20ENDACCT_7 SearchEnd ACCT:Account_Mask_Pool7Account_Mask_Pool7String6
21ENDACCT_8 SearchEnd ACCT:Account_Mask_Pool8Account_Mask_Pool8String6
22ENDACCT_9 SearchEnd ACCT:Account_Mask_Pool9Account_Mask_Pool9String6
23ENDACCT_10 SearchEnd ACCT:Account_Mask_Pool10Account_Mask_Pool10String6
24SUBTOTAM_1 SearchSubsidiary Total Amount[1]DLR19_$S2Currency19
25SUBTOTAM_2 SearchSubsidiary Total Amount[2]DLR19_$S2Currency19
26SUBTOTAM_3 SearchSubsidiary Total Amount[3]DLR19_$S2Currency19
27SUBTOTAM_4 SearchSubsidiary Total Amount[4]DLR19_$S2Currency19
28SUBTOTAM_5 SearchSubsidiary Total Amount[5]DLR19_$S2Currency19
29SUBTOTAM_6 SearchSubsidiary Total Amount[6]DLR19_$S2Currency19
30SUBTOTAM_7 SearchSubsidiary Total Amount[7]DLR19_$S2Currency19
31SUBTOTAM_8 SearchSubsidiary Total Amount[8]DLR19_$S2Currency19
32SUBTOTAM_9 SearchSubsidiary Total Amount[9]DLR19_$S2Currency19
33SUBTOTAM_10 SearchSubsidiary Total Amount[10]DLR19_$S2Currency19
34SUBTOTAM_11 SearchSubsidiary Total Amount[11]DLR19_$S2Currency19
35SUBTOTAM_12 SearchSubsidiary Total Amount[12]DLR19_$S2Currency19
36SUBTOTAM_13 SearchSubsidiary Total Amount[13]DLR19_$S2Currency19
37SUBTOTAM_14 SearchSubsidiary Total Amount[14]DLR19_$S2Currency19
38SUBTOTAM_15 SearchSubsidiary Total Amount[15]DLR19_$S2Currency19
39SUBTOTAM_16 SearchSubsidiary Total Amount[16]DLR19_$S2Currency19
40SUBTOTAM_17 SearchSubsidiary Total Amount[17]DLR19_$S2Currency19
41SUBTOTAM_18 SearchSubsidiary Total Amount[18]DLR19_$S2Currency19
42SUBTOTAM_19 SearchSubsidiary Total Amount[19]DLR19_$S2Currency19
43SUBTOTAM_20 SearchSubsidiary Total Amount[20]DLR19_$S2Currency19
44SUBTOTAM_21 SearchSubsidiary Total Amount[21]DLR19_$S2Currency19
45SUBTOTAM_22 SearchSubsidiary Total Amount[22]DLR19_$S2Currency19
46SUBTOTAM_23 SearchSubsidiary Total Amount[23]DLR19_$S2Currency19
47SUBTOTAM_24 SearchSubsidiary Total Amount[24]DLR19_$S2Currency19
48SUBTOTAM_25 SearchSubsidiary Total Amount[25]DLR19_$S2Currency19
49SUBTOTAM_26 SearchSubsidiary Total Amount[26]DLR19_$S2Currency19
50SUBTOTAM_27 SearchSubsidiary Total Amount[27]DLR19_$S2Currency19
51SUBTOTAM_28 SearchSubsidiary Total Amount[28]DLR19_$S2Currency19
52SUBTOTAM_29 SearchSubsidiary Total Amount[29]DLR19_$S2Currency19
53SUBTOTAM_30 SearchSubsidiary Total Amount[30]DLR19_$S2Currency19
54SUBTOTAM_31 SearchSubsidiary Total Amount[31]DLR19_$S2Currency19
55SUBTOTAM_32 SearchSubsidiary Total Amount[32]DLR19_$S2Currency19
56SUBTOTAM_33 SearchSubsidiary Total Amount[33]DLR19_$S2Currency19
57SUBTOTAM_34 SearchSubsidiary Total Amount[34]DLR19_$S2Currency19
58SUBTOTAM_35 SearchSubsidiary Total Amount[35]DLR19_$S2Currency19
59SUBTOTAM_36 SearchSubsidiary Total Amount[36]DLR19_$S2Currency19
60SUBTOTAM_37 SearchSubsidiary Total Amount[37]DLR19_$S2Currency19
61SUBTOTAM_38 SearchSubsidiary Total Amount[38]DLR19_$S2Currency19
62SUBTOTAM_39 SearchSubsidiary Total Amount[39]DLR19_$S2Currency19
63SUBTOTAM_40 SearchSubsidiary Total Amount[40]DLR19_$S2Currency19
64PRCSSQNC SearchProcess SequenceINTInteger0
65DEX_ROW_ID Searchintint10

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.

azurecurveProductsMicrosoft Dynamics GP (0)FinancialFinancials Subsidiary Total Temporary (AF50200)

Leave a Reply

Your email address will not be published. Required fields are marked *