Financials Total Temporary (AF50100)

azurecurveProductsMicrosoft Dynamics GP (0)FinancialFinancials Total Temporary (AF50100)

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_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 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
2REPORTID SearchReport IDINT_STORAGEInteger20
3TOTRWNUM SearchTotal Row NUMINT_STORAGEInteger20
4STACCNDX SearchStart Account IndexLI_14Long Integer414
5EDACCNDX SearchEnd Account IndexLI_14Long Integer414
6TOTLAMNT_1 SearchTotal Amount[1]DLR19_$S2Currency1019
7TOTLAMNT_2 SearchTotal Amount[2]DLR19_$S2Currency1019
8TOTLAMNT_3 SearchTotal Amount[3]DLR19_$S2Currency1019
9TOTLAMNT_4 SearchTotal Amount[4]DLR19_$S2Currency1019
10TOTLAMNT_5 SearchTotal Amount[5]DLR19_$S2Currency1019
11TOTLAMNT_6 SearchTotal Amount[6]DLR19_$S2Currency1019
12TOTLAMNT_7 SearchTotal Amount[7]DLR19_$S2Currency1019
13TOTLAMNT_8 SearchTotal Amount[8]DLR19_$S2Currency1019
14TOTLAMNT_9 SearchTotal Amount[9]DLR19_$S2Currency1019
15TOTLAMNT_10 SearchTotal Amount[10]DLR19_$S2Currency1019
16TOTLAMNT_11 SearchTotal Amount[11]DLR19_$S2Currency1019
17TOTLAMNT_12 SearchTotal Amount[12]DLR19_$S2Currency1019
18TOTLAMNT_13 SearchTotal Amount[13]DLR19_$S2Currency1019
19TOTLAMNT_14 SearchTotal Amount[14]DLR19_$S2Currency1019
20TOTLAMNT_15 SearchTotal Amount[15]DLR19_$S2Currency1019
21TOTLAMNT_16 SearchTotal Amount[16]DLR19_$S2Currency1019
22TOTLAMNT_17 SearchTotal Amount[17]DLR19_$S2Currency1019
23TOTLAMNT_18 SearchTotal Amount[18]DLR19_$S2Currency1019
24TOTLAMNT_19 SearchTotal Amount[19]DLR19_$S2Currency1019
25TOTLAMNT_20 SearchTotal Amount[20]DLR19_$S2Currency1019
26TOTLAMNT_21 SearchTotal Amount[21]DLR19_$S2Currency1019
27TOTLAMNT_22 SearchTotal Amount[22]DLR19_$S2Currency1019
28TOTLAMNT_23 SearchTotal Amount[23]DLR19_$S2Currency1019
29TOTLAMNT_24 SearchTotal Amount[24]DLR19_$S2Currency1019
30TOTLAMNT_25 SearchTotal Amount[25]DLR19_$S2Currency1019
31TOTLAMNT_26 SearchTotal Amount[26]DLR19_$S2Currency1019
32TOTLAMNT_27 SearchTotal Amount[27]DLR19_$S2Currency1019
33TOTLAMNT_28 SearchTotal Amount[28]DLR19_$S2Currency1019
34TOTLAMNT_29 SearchTotal Amount[29]DLR19_$S2Currency1019
35TOTLAMNT_30 SearchTotal Amount[30]DLR19_$S2Currency1019
36TOTLAMNT_31 SearchTotal Amount[31]DLR19_$S2Currency1019
37TOTLAMNT_32 SearchTotal Amount[32]DLR19_$S2Currency1019
38TOTLAMNT_33 SearchTotal Amount[33]DLR19_$S2Currency1019
39TOTLAMNT_34 SearchTotal Amount[34]DLR19_$S2Currency1019
40TOTLAMNT_35 SearchTotal Amount[35]DLR19_$S2Currency1019
41TOTLAMNT_36 SearchTotal Amount[36]DLR19_$S2Currency1019
42TOTLAMNT_37 SearchTotal Amount[37]DLR19_$S2Currency1019
43TOTLAMNT_38 SearchTotal Amount[38]DLR19_$S2Currency1019
44TOTLAMNT_39 SearchTotal Amount[39]DLR19_$S2Currency1019
45TOTLAMNT_40 SearchTotal Amount[40]DLR19_$S2Currency1019
46ACTOTAMT_1 SearchActual Total Amount[1]DLR19_$S2Currency1019
47ACTOTAMT_2 SearchActual Total Amount[2]DLR19_$S2Currency1019
48ACTOTAMT_3 SearchActual Total Amount[3]DLR19_$S2Currency1019
49ACTOTAMT_4 SearchActual Total Amount[4]DLR19_$S2Currency1019
50ACTOTAMT_5 SearchActual Total Amount[5]DLR19_$S2Currency1019
51ACTOTAMT_6 SearchActual Total Amount[6]DLR19_$S2Currency1019
52ACTOTAMT_7 SearchActual Total Amount[7]DLR19_$S2Currency1019
53ACTOTAMT_8 SearchActual Total Amount[8]DLR19_$S2Currency1019
54ACTOTAMT_9 SearchActual Total Amount[9]DLR19_$S2Currency1019
55ACTOTAMT_10 SearchActual Total Amount[10]DLR19_$S2Currency1019
56ACTOTAMT_11 SearchActual Total Amount[11]DLR19_$S2Currency1019
57ACTOTAMT_12 SearchActual Total Amount[12]DLR19_$S2Currency1019
58ACTOTAMT_13 SearchActual Total Amount[13]DLR19_$S2Currency1019
59ACTOTAMT_14 SearchActual Total Amount[14]DLR19_$S2Currency1019
60ACTOTAMT_15 SearchActual Total Amount[15]DLR19_$S2Currency1019
61ACTOTAMT_16 SearchActual Total Amount[16]DLR19_$S2Currency1019
62ACTOTAMT_17 SearchActual Total Amount[17]DLR19_$S2Currency1019
63ACTOTAMT_18 SearchActual Total Amount[18]DLR19_$S2Currency1019
64ACTOTAMT_19 SearchActual Total Amount[19]DLR19_$S2Currency1019
65ACTOTAMT_20 SearchActual Total Amount[20]DLR19_$S2Currency1019
66ACTOTAMT_21 SearchActual Total Amount[21]DLR19_$S2Currency1019
67ACTOTAMT_22 SearchActual Total Amount[22]DLR19_$S2Currency1019
68ACTOTAMT_23 SearchActual Total Amount[23]DLR19_$S2Currency1019
69ACTOTAMT_24 SearchActual Total Amount[24]DLR19_$S2Currency1019
70ACTOTAMT_25 SearchActual Total Amount[25]DLR19_$S2Currency1019
71ACTOTAMT_26 SearchActual Total Amount[26]DLR19_$S2Currency1019
72ACTOTAMT_27 SearchActual Total Amount[27]DLR19_$S2Currency1019
73ACTOTAMT_28 SearchActual Total Amount[28]DLR19_$S2Currency1019
74ACTOTAMT_29 SearchActual Total Amount[29]DLR19_$S2Currency1019
75ACTOTAMT_30 SearchActual Total Amount[30]DLR19_$S2Currency1019
76ACTOTAMT_31 SearchActual Total Amount[31]DLR19_$S2Currency1019
77ACTOTAMT_32 SearchActual Total Amount[32]DLR19_$S2Currency1019
78ACTOTAMT_33 SearchActual Total Amount[33]DLR19_$S2Currency1019
79ACTOTAMT_34 SearchActual Total Amount[34]DLR19_$S2Currency1019
80ACTOTAMT_35 SearchActual Total Amount[35]DLR19_$S2Currency1019
81ACTOTAMT_36 SearchActual Total Amount[36]DLR19_$S2Currency1019
82ACTOTAMT_37 SearchActual Total Amount[37]DLR19_$S2Currency1019
83ACTOTAMT_38 SearchActual Total Amount[38]DLR19_$S2Currency1019
84ACTOTAMT_39 SearchActual Total Amount[39]DLR19_$S2Currency1019
85ACTOTAMT_40 SearchActual Total Amount[40]DLR19_$S2Currency1019
86PRCSSQNC SearchProcess SequenceINTInteger20
87DEX_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 Total Temporary (AF50100)

Leave a Reply

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