Default Chart of Accounts (SY90100)

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: syDefaultCOA

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1Business_Type SearchBusiness TypeIntegerDDL_Business_Type0
2INDUSTYP SearchIndustry TypeIntegerDDL_Industry_Type0
3DEFCHRAC_1 SearchDefault Chart Account Number:Default Chart Account Segment1StringSTR9_Default_Chart_SEG19
4DEFCHRAC SearchDefault Chart Account NumberDefault Chart Account NumberComposite 0
5DEFCHRAC_2 SearchDefault Chart Account Number:Default Chart Account Segment2StringSTR9_Default_Chart_SEG29
6DEFCHRAC_3 SearchDefault Chart Account Number:Default Chart Account Segment3StringSTR9_Default_Chart_SEG39
7DEFCHRAC_4 SearchDefault Chart Account Number:Default Chart Account Segment4StringSTR9_Default_Chart_SEG49
8DEFCHRAC_5 SearchDefault Chart Account Number:Default Chart Account Segment5StringSTR9_Default_Chart_SEG59
9ACTDESCR SearchAccount DescriptionStringSTR5050
10PSTNGTYP SearchPosting TypeIntegerGB0
11ACCATNUM SearchAccount Category NumberIntegerINT2_U02
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'].ACCATNUM
12TPCLBLNC SearchTypical BalanceIntegerGB0
13Posting_Account_Series_1 SearchPosting Account Series[1]IntegerINT0
14Posting_Account_Series_2 SearchPosting Account Series[2]IntegerINT0
15Posting_Account_Series SearchPosting Account SeriesINTInteger0
16Posting_Account_Series_3 SearchPosting Account Series[3]IntegerINT0
17Posting_Account_Series_4 SearchPosting Account Series[4]IntegerINT0
18Posting_Account_Series_5 SearchPosting Account Series[5]IntegerINT0
19Posting_Account_Series_6 SearchPosting Account Series[6]IntegerINT0
20Posting_Account_Series_7 SearchPosting Account Series[7]IntegerINT0
21Posting_Account_Series_8 SearchPosting Account Series[8]IntegerINT0
22Posting_Account_Series_9 SearchPosting Account Series[9]IntegerINT0
23Posting_Account_Series_10 SearchPosting Account Series[10]IntegerINT0
24Posting_Account_Series_11 SearchPosting Account Series[11]IntegerINT0
25Posting_Account_Sequence_1 SearchPosting Account Sequence[1]IntegerINT0
26Posting_Account_Sequence_2 SearchPosting Account Sequence[2]IntegerINT0
27Posting_Account_Sequence SearchPosting Account SequenceINTInteger0
28Posting_Account_Sequence_3 SearchPosting Account Sequence[3]IntegerINT0
29Posting_Account_Sequence_4 SearchPosting Account Sequence[4]IntegerINT0
30Posting_Account_Sequence_5 SearchPosting Account Sequence[5]IntegerINT0
31Posting_Account_Sequence_6 SearchPosting Account Sequence[6]IntegerINT0
32Posting_Account_Sequence_7 SearchPosting Account Sequence[7]IntegerINT0
33Posting_Account_Sequence_8 SearchPosting Account Sequence[8]IntegerINT0
34Posting_Account_Sequence_9 SearchPosting Account Sequence[9]IntegerINT0
35Posting_Account_Sequence_10 SearchPosting Account Sequence[10]IntegerINT0
36Posting_Account_Sequence_11 SearchPosting Account Sequence[11]IntegerINT0

Leave a Reply

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