Default Account Master (DEFLTCOA)

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

Product: Microsoft Dynamics GP (0)
Series:

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

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1BUSNESS1 SearchBusiness1BooleanCB0
2BUSNESS2 SearchBusiness2BooleanCB0
3BUSNESS3 SearchBusiness3BooleanCB0
4INDUSTYP SearchIndustry TypeIntegerDDL_Industry_Type0
5DEFCHRAC SearchDefault Chart Account NumberDefault Chart Account NumberComposite 0
6DEFCHRAC_1 SearchDefault Chart Account Number:Default Chart Account Segment1StringSTR9_Default_Chart_SEG19
7DEFCHRAC_2 SearchDefault Chart Account Number:Default Chart Account Segment2StringSTR9_Default_Chart_SEG29
8DEFCHRAC_3 SearchDefault Chart Account Number:Default Chart Account Segment3StringSTR9_Default_Chart_SEG39
9DEFCHRAC_4 SearchDefault Chart Account Number:Default Chart Account Segment4StringSTR9_Default_Chart_SEG49
10DEFCHRAC_5 SearchDefault Chart Account Number:Default Chart Account Segment5StringSTR9_Default_Chart_SEG59
11ACTDESCR SearchAccount DescriptionStringSTR5050
12PSTNGTYP SearchPosting TypeIntegerGB0
13ACCATNUM SearchAccount Category NumberIntegerINT2_U02
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 BalanceIntegerGB0
15SERIES SearchSeriesIntegerDDL_Series0
16SEQNUMBR SearchSequence NumberLong IntegerLI_Sequence_Number10

Leave a Reply

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