General Ledger Period Temporary (GL50011)

azurecurveProductsMicrosoft Dynamics GP (0)FinancialGeneral Ledger Period Temporary (GL50011)

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

Product: Microsoft Dynamics GP (0)
Series: Financial

Display Name: General Ledger Period Temporary
Physical Name: GL50011
Technical Name: GL_Period_Balance_TEMP

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1YEARID SearchYear IDStringSTR15_LBAU15
2PERIODID SearchPeriod IDIntegerINT33
3AMNTFROM SearchAmount FromIntegerINT_STORAGE0
4ACTINDX SearchAccount IndexLong IntegerLI_1414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['General Ledger Period Temporary'].ACTINDX AS 'General Ledger Period Temporary-Account Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       GL50011 AS ['General Ledger Period Temporary']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['General Ledger Period Temporary'].ACTINDX = ['Account Index Master'].ACTINDX
5DOLLAR1 SearchDollar1CurrencyDLR17_RBS0_STR$17
6SQLSESID SearchSQLSessionIDLong IntegerLong Int8
7DEBITAMT SearchDebit AmountCurrencyDLR19_$S219
8CRDTAMNT SearchCredit AmountCurrencyDLR19_$S219
azurecurveProductsMicrosoft Dynamics GP (0)FinancialGeneral Ledger Period Temporary (GL50011)

Leave a Reply

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