Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/SY90100
Product: Microsoft Dynamics GP (0)
Series:
Display Name: Default Chart of Accounts
Physical Name: SY90100
Technical Name: syDefaultCOASeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 Business_Type 
Business Type Integer DDL_Business_Type 0 2 INDUSTYP Industry Type Integer DDL_Industry_Type 0 3 DEFCHRAC_1 Default Chart Account Number:Default Chart Account Segment1 String STR9_Default_Chart_SEG1 9 4 DEFCHRAC Default Chart Account Number Default Chart Account Number Composite 0 5 DEFCHRAC_2 Default Chart Account Number:Default Chart Account Segment2 String STR9_Default_Chart_SEG2 9 6 DEFCHRAC_3 Default Chart Account Number:Default Chart Account Segment3 String STR9_Default_Chart_SEG3 9 7 DEFCHRAC_4 Default Chart Account Number:Default Chart Account Segment4 String STR9_Default_Chart_SEG4 9 8 DEFCHRAC_5 Default Chart Account Number:Default Chart Account Segment5 String STR9_Default_Chart_SEG5 9 9 ACTDESCR Account Description String STR50 50 10 PSTNGTYP Posting Type Integer GB 0 11 ACCATNUM Account Category Number Integer INT2_U0 2 Key to the Account Category Master (GL00102).
Click to show/hide
SELECT
['Default Chart of Accounts'].ACCATNUM AS 'Default Chart of Accounts-Account Category Number'
,['Account Category Master'].ACCATNUM AS 'Account Category Master-Account Category Number'
FROM
SY90100 AS ['Default Chart of Accounts']
INNER JOIN
GL00102 AS ['Account Category Master']
ON
['Default Chart of Accounts'].ACCATNUM = ['Account Category Master'].ACCATNUM12 TPCLBLNC Typical Balance Integer GB 0 13 Posting_Account_Series_1 Posting Account Series[1] Integer INT 0 14 Posting_Account_Series_2 Posting Account Series[2] Integer INT 0 15 Posting_Account_Series Posting Account Series INT Integer 0 16 Posting_Account_Series_3 Posting Account Series[3] Integer INT 0 17 Posting_Account_Series_4 Posting Account Series[4] Integer INT 0 18 Posting_Account_Series_5 Posting Account Series[5] Integer INT 0 19 Posting_Account_Series_6 Posting Account Series[6] Integer INT 0 20 Posting_Account_Series_7 Posting Account Series[7] Integer INT 0 21 Posting_Account_Series_8 Posting Account Series[8] Integer INT 0 22 Posting_Account_Series_9 Posting Account Series[9] Integer INT 0 23 Posting_Account_Series_10 Posting Account Series[10] Integer INT 0 24 Posting_Account_Series_11 Posting Account Series[11] Integer INT 0 25 Posting_Account_Sequence_1 Posting Account Sequence[1] Integer INT 0 26 Posting_Account_Sequence_2 Posting Account Sequence[2] Integer INT 0 27 Posting_Account_Sequence_3 Posting Account Sequence[3] Integer INT 0 28 Posting_Account_Sequence Posting Account Sequence INT Integer 0 29 Posting_Account_Sequence_4 Posting Account Sequence[4] Integer INT 0 30 Posting_Account_Sequence_5 Posting Account Sequence[5] Integer INT 0 31 Posting_Account_Sequence_6 Posting Account Sequence[6] Integer INT 0 32 Posting_Account_Sequence_7 Posting Account Sequence[7] Integer INT 0 33 Posting_Account_Sequence_8 Posting Account Sequence[8] Integer INT 0 34 Posting_Account_Sequence_9 Posting Account Sequence[9] Integer INT 0 35 Posting_Account_Sequence_10 Posting Account Sequence[10] Integer INT 0 36 Posting_Account_Sequence_11 Posting Account Sequence[11] Integer INT 0