ECM_Budget_SUM_MSTR (ECM00201)

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

Product: Enhanced Commitment Management (2547)
Series: System

Display Name: ECM_Budget_SUM_MSTR
Physical Name: ECM00201
Technical Name: ECM_Budget_SUM_MSTR

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeSQL DB LengthKeyable Length
1CompanyID SearchECM_CompanyIDLI_Sequence_NumberLong Integer410
2SessionID SearchECM_SessionIDLI_14Long Integer414
3BudgetID SearchECM_BudgetIDSTR15_LBAUString1615
Key to the Budget Master (GL00200).

Click to show/hide

SELECT
       ['ECM_Budget_SUM_MSTR'].BudgetID AS 'ECM_Budget_SUM_MSTR-ECM_BudgetID'
       ,['Budget Master'].BUDGETID AS 'Budget Master-Budget ID'
FROM
       ECM00201 AS ['ECM_Budget_SUM_MSTR']
INNER JOIN
       GL00200 AS ['Budget Master']
              ON
                     ['ECM_Budget_SUM_MSTR'].BudgetID = ['Budget Master'].BUDGETID
4PeriodID SearchECM_PeriodIDINT3Integer23
5BudgetAmt SearchECM_BudgetAmtDLR19_$S2Currency1019
6Accatnum SearchECM_AcctCatNumINT2_U0Integer22
Key to the Account Category Master (GL00102).

Click to show/hide

SELECT
       ['ECM_Budget_SUM_MSTR'].Accatnum AS 'ECM_Budget_SUM_MSTR-ECM_AcctCatNum'
       ,['Account Category Master'].ACCATNUM AS 'Account Category Master-Account Category Number'
FROM
       ECM00201 AS ['ECM_Budget_SUM_MSTR']
INNER JOIN
       GL00102 AS ['Account Category Master']
              ON
                     ['ECM_Budget_SUM_MSTR'].Accatnum = ['Account Category Master'].ACCATNUM
7ActIndx SearchECM_AcctIndxLI_Sequence_NumberLong Integer410
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['ECM_Budget_SUM_MSTR'].ActIndx AS 'ECM_Budget_SUM_MSTR-ECM_AcctIndx'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       ECM00201 AS ['ECM_Budget_SUM_MSTR']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['ECM_Budget_SUM_MSTR'].ActIndx = ['Account Index Master'].ACTINDX
8DEX_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.

Leave a Reply

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