Breakdown Account Master (GL00100)

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

Product: Microsoft Dynamics GP (0)
Series: Financial

Display Name: Account Master
Physical Name: GL00100
Technical Name: GL_Distribution_Account_MSTR

Group Display Name: Account Master
Group Technical Name: Account Master

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeSQL DB LengthKeyable Length
1ACTINDX SearchAccount IndexLI_14Long Integer414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['Account Master'].ACTINDX AS 'Account Master-Account Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       GL00100 AS ['Account Master']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['Account Master'].ACTINDX = ['Account Index Master'].ACTINDX
2ACTNUMBR SearchAccount NumberAccount_NumberComposite 8080
3ACTNUMBR_1 SearchAccount Number:Account_Segment_Pool1Account_Segment_Pool1String86
4ACTNUMBR_2 SearchAccount Number:Account_Segment_Pool2Account_Segment_Pool2String86
5ACTNUMBR_3 SearchAccount Number:Account_Segment_Pool3Account_Segment_Pool3String86
6ACTNUMBR_4 SearchAccount Number:Account_Segment_Pool4Account_Segment_Pool4String86
7ACTNUMBR_5 SearchAccount Number:Account_Segment_Pool5Account_Segment_Pool5String86
8ACTNUMBR_6 SearchAccount Number:Account_Segment_Pool6Account_Segment_Pool6String86
9ACTNUMBR_7 SearchAccount Number:Account_Segment_Pool7Account_Segment_Pool7String86
10ACTNUMBR_8 SearchAccount Number:Account_Segment_Pool8Account_Segment_Pool8String86
11ACTNUMBR_9 SearchAccount Number:Account_Segment_Pool9Account_Segment_Pool9String86
12ACTNUMBR_10 SearchAccount Number:Account_Segment_Pool10Account_Segment_Pool10String86
13ACTALIAS SearchAccount AliasSTR20_Account_AliasString2220
14MNACSGMT SearchMain Account SegmentSTR66_Seg_IDString6866
15ACCTTYPE SearchAccount TypeDDL_Account_TypeInteger20
There are four types of account supported by Microsoft Dynamics GP.

Click to show/hide Account Types

1	Posting Account
2	Unit Account
3	Posting Allocation Account
4	Unit Allocation Account
16ACTDESCR SearchAccount DescriptionSTR50String5250
17PSTNGTYP SearchPosting TypeGBInteger20
The Posting Type is the type of Posting Account.

Click to show/hide Posting Types

0	Balance Sheet accounts have their balance brought forward to the next year during a Year-End Close.
1	Profit and Loss accounts have their balance closed to a retained earnings account during the Year-End Close.
18ACCATNUM SearchAccount Category NumberINT2_U0Integer22
Key to the Account Category Master (GL00102).

Click to show/hide

SELECT
       ['Account Master'].ACCATNUM AS 'Account Master-Account Category Number'
       ,['Account Category Master'].ACCATNUM AS 'Account Category Master-Account Category Number'
FROM
       GL00100 AS ['Account Master']
INNER JOIN
       GL00102 AS ['Account Category Master']
              ON
                     ['Account Master'].ACCATNUM = ['Account Category Master'].ACCATNUM
19ACTIVE SearchActiveCB_ActiveBoolean20
20TPCLBLNC SearchTypical BalanceGBInteger20
The Typical Balance shows whether an account typically has a Debit or Credit Balance; used by reporting tools such as Management Reporter to determine how a balance is shown on financial statements.

Click to show/hide Typical Balance

0	Debit
1	Credit
21DECPLACS SearchDecimal PlacesDDL_Decimal_PlacesInteger20
22FXDORVAR SearchFixed Or VariableLB_Fixed_Or_VariableInteger20
23BALFRCLC SearchBalance For CalculationGBInteger20
24DSPLKUPS SearchDisplay In LookupsML_Display_In_LookupsLong Integer40
25CNVRMTHD SearchConversion MethodDDL_Conversion_MethodInteger20
26HSTRCLRT SearchHistorical RateDLR14_Exchange_RateCurrency (Variable)1014
27NOTEINDX SearchNote IndexDLR14Currency1014
Key to the Record Notes Master (SY03900).

Click to show/hide

SELECT
       ['Account Master'].NOTEINDX AS 'Account Master-Note Index'
       ,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
       GL00100 AS ['Account Master']
INNER JOIN
       SY03900 AS ['Record Notes Master']
              ON
                     ['Account Master'].NOTEINDX = ['Record Notes Master'].NOTEINDX
28CREATDDT SearchCreated DateDTDate48
29MODIFDT SearchModified DateDTDate48
30USERDEF1 SearchUser Defined 1STR20String2220
31USERDEF2 SearchUser Defined 2STR20String2220
32PostSlsIn SearchPost Sales InSumOrDetailInteger20
33PostIvIn SearchPost Inventory InSumOrDetailInteger20
34PostPurchIn SearchPost Purchasing InSumOrDetailInteger20
35PostPRIn SearchPost Payroll InSumOrDetailInteger20
36ADJINFL SearchAdjust for InflationCB_Adjust_For_InflationBoolean20
37INFLAREV SearchInflation Revenue Account IndexLI_14Long Integer414
38INFLAEQU SearchInflation Equity Account IndexLI_14Long Integer414
39ACCTENTR SearchAllow Account EntryCB_Allow_Account_EntryBoolean20
When unmarked, this flag allows accounts to be locked down by preventing users from posting to the account, while still allowing it to default onto transactions. Typically this is done on control accounts which should never have manual postings made to them.
40USRDEFS1 SearchUser Defined String 1STR30String3230
41USRDEFS2 SearchUser Defined String 2STR30String3230
42Clear_Balance SearchClear BalanceClear BalanceBoolean20
43Workflow_Status SearchWorkflow StatusWorkflow StatusInteger20
44DEX_ROW_TS Searchdatetimedatetime33
DEX_ROW_TS records the time the record was last changed; often used with integration tools to identify which records have changed and need to be synchronised.
45DEX_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 *