Default Account Master (DEFLTCOA)

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

Product: Microsoft Dynamics GP (0)
Series: Dexterity System

Display Name: Default Account Master
Physical Name: DEFLTCOA
Technical Name: SY_Default_COA_MSTR_Ctree

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeSQL DB LengthKeyable Length
1BUSNESS1 SearchBusiness1CBBoolean20
2BUSNESS2 SearchBusiness2CBBoolean20
3BUSNESS3 SearchBusiness3CBBoolean20
4INDUSTYP SearchIndustry TypeDDL_Industry_TypeInteger20
5DEFCHRAC SearchDefault Chart Account NumberDefault Chart Account NumberComposite 500
6DEFCHRAC_1 SearchDefault Chart Account Number:Default Chart Account Segment1STR9_Default_Chart_SEG1String109
7DEFCHRAC_2 SearchDefault Chart Account Number:Default Chart Account Segment2STR9_Default_Chart_SEG2String109
8DEFCHRAC_3 SearchDefault Chart Account Number:Default Chart Account Segment3STR9_Default_Chart_SEG3String109
9DEFCHRAC_4 SearchDefault Chart Account Number:Default Chart Account Segment4STR9_Default_Chart_SEG4String109
10DEFCHRAC_5 SearchDefault Chart Account Number:Default Chart Account Segment5STR9_Default_Chart_SEG5String109
11ACTDESCR SearchAccount DescriptionSTR50String5250
12PSTNGTYP SearchPosting TypeGBInteger20
13ACCATNUM SearchAccount Category NumberINT2_U0Integer22
Key to the Account Category Master (GL00102).

Click to show/hide

SELECT
       ['Default Account Master'].ACCATNUM AS 'Default Account Master-Account Category Number'
       ,['Account Category Master'].ACCATNUM AS 'Account Category Master-Account Category Number'
FROM
       DEFLTCOA AS ['Default Account Master']
INNER JOIN
       GL00102 AS ['Account Category Master']
              ON
                     ['Default Account Master'].ACCATNUM = ['Account Category Master'].ACCATNUM
14TPCLBLNC SearchTypical BalanceGBInteger20
15SERIES SearchSeriesDDL_SeriesInteger20
16SEQNUMBR SearchSequence NumberLI_Sequence_NumberLong Integer410
17DEX_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 *