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: Dexterity System

Display Name: Default Chart of Accounts
Physical Name: SY90100
Technical Name: syDefaultCOA

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeSQL DB LengthKeyable Length
1Business_Type SearchBusiness TypeDDL_Business_TypeInteger20
2INDUSTYP SearchIndustry TypeDDL_Industry_TypeInteger20
3DEFCHRAC SearchDefault Chart Account NumberDefault Chart Account NumberComposite 500
4DEFCHRAC_1 SearchDefault Chart Account Number:Default Chart Account Segment1STR9_Default_Chart_SEG1String109
5DEFCHRAC_2 SearchDefault Chart Account Number:Default Chart Account Segment2STR9_Default_Chart_SEG2String109
6DEFCHRAC_3 SearchDefault Chart Account Number:Default Chart Account Segment3STR9_Default_Chart_SEG3String109
7DEFCHRAC_4 SearchDefault Chart Account Number:Default Chart Account Segment4STR9_Default_Chart_SEG4String109
8DEFCHRAC_5 SearchDefault Chart Account Number:Default Chart Account Segment5STR9_Default_Chart_SEG5String109
9ACTDESCR SearchAccount DescriptionSTR50String5250
10PSTNGTYP SearchPosting TypeGBInteger20
11ACCATNUM SearchAccount Category NumberINT2_U0Integer22
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 BalanceGBInteger20
13Posting_Account_Series SearchPosting Account SeriesINTInteger20
14Posting_Account_Series_1 SearchPosting Account Series[1]INTInteger20
15Posting_Account_Series_2 SearchPosting Account Series[2]INTInteger20
16Posting_Account_Series_3 SearchPosting Account Series[3]INTInteger20
17Posting_Account_Series_4 SearchPosting Account Series[4]INTInteger20
18Posting_Account_Series_5 SearchPosting Account Series[5]INTInteger20
19Posting_Account_Series_6 SearchPosting Account Series[6]INTInteger20
20Posting_Account_Series_7 SearchPosting Account Series[7]INTInteger20
21Posting_Account_Series_8 SearchPosting Account Series[8]INTInteger20
22Posting_Account_Series_9 SearchPosting Account Series[9]INTInteger20
23Posting_Account_Series_10 SearchPosting Account Series[10]INTInteger20
24Posting_Account_Series_11 SearchPosting Account Series[11]INTInteger20
25Posting_Account_Sequence SearchPosting Account SequenceINTInteger20
26Posting_Account_Sequence_1 SearchPosting Account Sequence[1]INTInteger20
27Posting_Account_Sequence_2 SearchPosting Account Sequence[2]INTInteger20
28Posting_Account_Sequence_3 SearchPosting Account Sequence[3]INTInteger20
29Posting_Account_Sequence_4 SearchPosting Account Sequence[4]INTInteger20
30Posting_Account_Sequence_5 SearchPosting Account Sequence[5]INTInteger20
31Posting_Account_Sequence_6 SearchPosting Account Sequence[6]INTInteger20
32Posting_Account_Sequence_7 SearchPosting Account Sequence[7]INTInteger20
33Posting_Account_Sequence_8 SearchPosting Account Sequence[8]INTInteger20
34Posting_Account_Sequence_9 SearchPosting Account Sequence[9]INTInteger20
35Posting_Account_Sequence_10 SearchPosting Account Sequence[10]INTInteger20
36Posting_Account_Sequence_11 SearchPosting Account Sequence[11]INTInteger20
37DEX_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 *