Account Rollups Account Segment Summary (SE000100)

azurecurveProductsMicrosoft Dynamics GP (0)FinancialAccount Rollups Account Segment Summary (SE000100)

Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/SE000100

Product: Microsoft Dynamics GP (0)
Series: Financial

Display Name: Account Rollups Account Segment Summary
Physical Name: SE000100
Technical Name: SE_Account_Segment_SUM

Group Display Name: Account Rollup Inquiries
Group Technical Name: Account Rollup Inquiries

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1USERID SearchUser IDStringSTR15_User_ID15
Key to the Users Master (SY01400).

Click to show/hide

SELECT
       ['Account Rollups Account Segment Summary'].USERID AS 'Account Rollups Account Segment Summary-User ID'
       ,['Users Master'].USERID AS 'Users Master-User ID'
FROM
       SE000100 AS ['Account Rollups Account Segment Summary']
INNER JOIN
       DYNAMICS..SY01400 AS ['Users Master']
              ON
                     ['Account Rollups Account Segment Summary'].USERID = ['Users Master'].USERID
2PERIODID SearchPeriod IDIntegerINT33
3PERNAME SearchPeriod NameStringSTR2020
4SE_Net_Amount_1 SearchSE Net Amount[1]CurrencyDLR11_$S214
5SE_Net_Amount SearchSE Net AmountDLR11_$S2Currency14
6SE_Net_Amount_2 SearchSE Net Amount[2]CurrencyDLR11_$S214
7SE_Net_Amount_3 SearchSE Net Amount[3]CurrencyDLR11_$S214
8SE_Net_Amount_4 SearchSE Net Amount[4]CurrencyDLR11_$S214
9SE_Period_Balance_1 SearchSE Period Balance[1]CurrencyDLR11_$S214
10SE_Period_Balance_2 SearchSE Period Balance[2]CurrencyDLR11_$S214
11SE_Period_Balance SearchSE Period BalanceDLR11_$S2Currency14
12SE_Period_Balance_3 SearchSE Period Balance[3]CurrencyDLR11_$S214
13SE_Period_Balance_4 SearchSE Period Balance[4]CurrencyDLR11_$S214
14SECURIDX_1 SearchSE Currency Index[1]IntegerINT33
15SECURIDX_2 SearchSE Currency Index[2]IntegerINT33
16SECURIDX SearchSE Currency IndexINT3Integer3
17SECURIDX_3 SearchSE Currency Index[3]IntegerINT33
18SECURIDX_4 SearchSE Currency Index[4]IntegerINT33
azurecurveProductsMicrosoft Dynamics GP (0)FinancialAccount Rollups Account Segment Summary (SE000100)

Leave a Reply

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