Breakdown Account Master (GL00100)

Easily find this page again using the shortlink:

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 TypeLength
1ACTINDX SearchAccount IndexLI_14Long Integer14
Key to the Account Index Master (GL00105).

Click to show/hide

       ['Account Master'].ACTINDX AS 'Account Master-Account Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
       GL00100 AS ['Account Master']
       GL00105 AS ['Account Index Master']
                     ['Account Master'].ACTINDX = ['Account Index Master'].ACTINDX
2ACTNUMBR SearchAccount NumberAccount_NumberComposite 80
3ACTNUMBR_1 SearchAccount Number:Account_Segment_Pool1Account_Segment_Pool1String6
4ACTNUMBR_2 SearchAccount Number:Account_Segment_Pool2Account_Segment_Pool2String6
5ACTNUMBR_3 SearchAccount Number:Account_Segment_Pool3Account_Segment_Pool3String6
6ACTNUMBR_4 SearchAccount Number:Account_Segment_Pool4Account_Segment_Pool4String6
7ACTNUMBR_5 SearchAccount Number:Account_Segment_Pool5Account_Segment_Pool5String6
8ACTNUMBR_6 SearchAccount Number:Account_Segment_Pool6Account_Segment_Pool6String6
9ACTNUMBR_7 SearchAccount Number:Account_Segment_Pool7Account_Segment_Pool7String6
10ACTNUMBR_8 SearchAccount Number:Account_Segment_Pool8Account_Segment_Pool8String6
11ACTNUMBR_9 SearchAccount Number:Account_Segment_Pool9Account_Segment_Pool9String6
12ACTNUMBR_10 SearchAccount Number:Account_Segment_Pool10Account_Segment_Pool10String6
13ACTALIAS SearchAccount AliasSTR20_Account_AliasString20
14MNACSGMT SearchMain Account SegmentSTR66_Seg_IDString66
15ACCTTYPE SearchAccount TypeDDL_Account_TypeInteger0
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 DescriptionSTR50String50
17PSTNGTYP SearchPosting TypeGBInteger0
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_U0Integer2
Key to the Account Category Master (GL00102).

Click to show/hide

       ['Account Master'].ACCATNUM AS 'Account Master-Account Category Number'
       ,['Account Category Master'].ACCATNUM AS 'Account Category Master-Account Category Number'
       GL00100 AS ['Account Master']
       GL00102 AS ['Account Category Master']
                     ['Account Master'].ACCATNUM = ['Account Category Master'].ACCATNUM
19ACTIVE SearchActiveCB_ActiveBoolean0
20TPCLBLNC SearchTypical BalanceGBInteger0
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_PlacesInteger0
22FXDORVAR SearchFixed Or VariableLB_Fixed_Or_VariableInteger0
23BALFRCLC SearchBalance For CalculationGBInteger0
24DSPLKUPS SearchDisplay In LookupsML_Display_In_LookupsLong Integer0
25CNVRMTHD SearchConversion MethodDDL_Conversion_MethodInteger0
26HSTRCLRT SearchHistorical RateDLR14_Exchange_RateCurrency (Variable)14
27NOTEINDX SearchNote IndexDLR14Currency14
Key to the Record Notes Master (SY03900).

Click to show/hide

       ['Account Master'].NOTEINDX AS 'Account Master-Note Index'
       ,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
       GL00100 AS ['Account Master']
       SY03900 AS ['Record Notes Master']
                     ['Account Master'].NOTEINDX = ['Record Notes Master'].NOTEINDX
28CREATDDT SearchCreated DateDTDate8
29MODIFDT SearchModified DateDTDate8
30USERDEF1 SearchUser Defined 1STR20String20
31USERDEF2 SearchUser Defined 2STR20String20
32PostSlsIn SearchPost Sales InSumOrDetailInteger0
33PostIvIn SearchPost Inventory InSumOrDetailInteger0
34PostPurchIn SearchPost Purchasing InSumOrDetailInteger0
35PostPRIn SearchPost Payroll InSumOrDetailInteger0
36ADJINFL SearchAdjust for InflationCB_Adjust_For_InflationBoolean0
37INFLAREV SearchInflation Revenue Account IndexLI_14Long Integer14
38INFLAEQU SearchInflation Equity Account IndexLI_14Long Integer14
39ACCTENTR SearchAllow Account EntryCB_Allow_Account_EntryBoolean0
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 1STR30String30
41USRDEFS2 SearchUser Defined String 2STR30String30
42Clear_Balance SearchClear BalanceClear BalanceBoolean0
43Workflow_Status SearchWorkflow StatusWorkflow StatusInteger0
44DEX_ROW_TS Searchdatetimedatetime3
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 Searchintint10

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 *