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 TypeSQL DB LengthKeyable Length
1USERID SearchUser IDSTR15_User_IDString1615
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_STORAGEInteger20
3SUBSUDID SearchSubsidiary IDSTR15String1615
4STTACCT_1 SearchStart ACCT:Account_Mask_Pool1Account_Mask_Pool1String86
5STTACCT_2 SearchStart ACCT:Account_Mask_Pool2Account_Mask_Pool2String86
6STTACCT_3 SearchStart ACCT:Account_Mask_Pool3Account_Mask_Pool3String86
7STTACCT_4 SearchStart ACCT:Account_Mask_Pool4Account_Mask_Pool4String86
8STTACCT_5 SearchStart ACCT:Account_Mask_Pool5Account_Mask_Pool5String86
9STTACCT_6 SearchStart ACCT:Account_Mask_Pool6Account_Mask_Pool6String86
10STTACCT_7 SearchStart ACCT:Account_Mask_Pool7Account_Mask_Pool7String86
11STTACCT_8 SearchStart ACCT:Account_Mask_Pool8Account_Mask_Pool8String86
12STTACCT_9 SearchStart ACCT:Account_Mask_Pool9Account_Mask_Pool9String86
13STTACCT_10 SearchStart ACCT:Account_Mask_Pool10Account_Mask_Pool10String86
14ENDACCT_1 SearchEnd ACCT:Account_Mask_Pool1Account_Mask_Pool1String86
15ENDACCT_2 SearchEnd ACCT:Account_Mask_Pool2Account_Mask_Pool2String86
16ENDACCT_3 SearchEnd ACCT:Account_Mask_Pool3Account_Mask_Pool3String86
17ENDACCT_4 SearchEnd ACCT:Account_Mask_Pool4Account_Mask_Pool4String86
18ENDACCT_5 SearchEnd ACCT:Account_Mask_Pool5Account_Mask_Pool5String86
19ENDACCT_6 SearchEnd ACCT:Account_Mask_Pool6Account_Mask_Pool6String86
20ENDACCT_7 SearchEnd ACCT:Account_Mask_Pool7Account_Mask_Pool7String86
21ENDACCT_8 SearchEnd ACCT:Account_Mask_Pool8Account_Mask_Pool8String86
22ENDACCT_9 SearchEnd ACCT:Account_Mask_Pool9Account_Mask_Pool9String86
23ENDACCT_10 SearchEnd ACCT:Account_Mask_Pool10Account_Mask_Pool10String86
24SUBTOTAM_1 SearchSubsidiary Total Amount[1]DLR19_$S2Currency1019
25SUBTOTAM_2 SearchSubsidiary Total Amount[2]DLR19_$S2Currency1019
26SUBTOTAM_3 SearchSubsidiary Total Amount[3]DLR19_$S2Currency1019
27SUBTOTAM_4 SearchSubsidiary Total Amount[4]DLR19_$S2Currency1019
28SUBTOTAM_5 SearchSubsidiary Total Amount[5]DLR19_$S2Currency1019
29SUBTOTAM_6 SearchSubsidiary Total Amount[6]DLR19_$S2Currency1019
30SUBTOTAM_7 SearchSubsidiary Total Amount[7]DLR19_$S2Currency1019
31SUBTOTAM_8 SearchSubsidiary Total Amount[8]DLR19_$S2Currency1019
32SUBTOTAM_9 SearchSubsidiary Total Amount[9]DLR19_$S2Currency1019
33SUBTOTAM_10 SearchSubsidiary Total Amount[10]DLR19_$S2Currency1019
34SUBTOTAM_11 SearchSubsidiary Total Amount[11]DLR19_$S2Currency1019
35SUBTOTAM_12 SearchSubsidiary Total Amount[12]DLR19_$S2Currency1019
36SUBTOTAM_13 SearchSubsidiary Total Amount[13]DLR19_$S2Currency1019
37SUBTOTAM_14 SearchSubsidiary Total Amount[14]DLR19_$S2Currency1019
38SUBTOTAM_15 SearchSubsidiary Total Amount[15]DLR19_$S2Currency1019
39SUBTOTAM_16 SearchSubsidiary Total Amount[16]DLR19_$S2Currency1019
40SUBTOTAM_17 SearchSubsidiary Total Amount[17]DLR19_$S2Currency1019
41SUBTOTAM_18 SearchSubsidiary Total Amount[18]DLR19_$S2Currency1019
42SUBTOTAM_19 SearchSubsidiary Total Amount[19]DLR19_$S2Currency1019
43SUBTOTAM_20 SearchSubsidiary Total Amount[20]DLR19_$S2Currency1019
44SUBTOTAM_21 SearchSubsidiary Total Amount[21]DLR19_$S2Currency1019
45SUBTOTAM_22 SearchSubsidiary Total Amount[22]DLR19_$S2Currency1019
46SUBTOTAM_23 SearchSubsidiary Total Amount[23]DLR19_$S2Currency1019
47SUBTOTAM_24 SearchSubsidiary Total Amount[24]DLR19_$S2Currency1019
48SUBTOTAM_25 SearchSubsidiary Total Amount[25]DLR19_$S2Currency1019
49SUBTOTAM_26 SearchSubsidiary Total Amount[26]DLR19_$S2Currency1019
50SUBTOTAM_27 SearchSubsidiary Total Amount[27]DLR19_$S2Currency1019
51SUBTOTAM_28 SearchSubsidiary Total Amount[28]DLR19_$S2Currency1019
52SUBTOTAM_29 SearchSubsidiary Total Amount[29]DLR19_$S2Currency1019
53SUBTOTAM_30 SearchSubsidiary Total Amount[30]DLR19_$S2Currency1019
54SUBTOTAM_31 SearchSubsidiary Total Amount[31]DLR19_$S2Currency1019
55SUBTOTAM_32 SearchSubsidiary Total Amount[32]DLR19_$S2Currency1019
56SUBTOTAM_33 SearchSubsidiary Total Amount[33]DLR19_$S2Currency1019
57SUBTOTAM_34 SearchSubsidiary Total Amount[34]DLR19_$S2Currency1019
58SUBTOTAM_35 SearchSubsidiary Total Amount[35]DLR19_$S2Currency1019
59SUBTOTAM_36 SearchSubsidiary Total Amount[36]DLR19_$S2Currency1019
60SUBTOTAM_37 SearchSubsidiary Total Amount[37]DLR19_$S2Currency1019
61SUBTOTAM_38 SearchSubsidiary Total Amount[38]DLR19_$S2Currency1019
62SUBTOTAM_39 SearchSubsidiary Total Amount[39]DLR19_$S2Currency1019
63SUBTOTAM_40 SearchSubsidiary Total Amount[40]DLR19_$S2Currency1019
64PRCSSQNC SearchProcess SequenceINTInteger20
65DEX_ROW_ID Searchintint1010

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 *