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_CtreeSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 BUSNESS1 
Business1 Boolean CB 0 2 BUSNESS2 Business2 Boolean CB 0 3 BUSNESS3 Business3 Boolean CB 0 4 INDUSTYP Industry Type Integer DDL_Industry_Type 0 5 DEFCHRAC Default Chart Account Number Default Chart Account Number Composite 0 6 DEFCHRAC_1 Default Chart Account Number:Default Chart Account Segment1 String STR9_Default_Chart_SEG1 9 7 DEFCHRAC_2 Default Chart Account Number:Default Chart Account Segment2 String STR9_Default_Chart_SEG2 9 8 DEFCHRAC_3 Default Chart Account Number:Default Chart Account Segment3 String STR9_Default_Chart_SEG3 9 9 DEFCHRAC_4 Default Chart Account Number:Default Chart Account Segment4 String STR9_Default_Chart_SEG4 9 10 DEFCHRAC_5 Default Chart Account Number:Default Chart Account Segment5 String STR9_Default_Chart_SEG5 9 11 ACTDESCR Account Description String STR50 50 12 PSTNGTYP Posting Type Integer GB 0 13 ACCATNUM Account Category Number Integer INT2_U0 2 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'].ACCATNUM14 TPCLBLNC Typical Balance Integer GB 0 15 SERIES Series Integer DDL_Series 0 16 SEQNUMBR Sequence Number Long Integer LI_Sequence_Number 10