Default Chart of Accounts (SY90100)

azurecurve Products Microsoft Dynamics GP (0)Dexterity SystemDefault 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 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	Default Chart Account Number	Default Chart Account Number	Composite	0
4	DEFCHRAC_1	Default Chart Account Number:Default Chart Account Segment1	String	STR9_Default_Chart_SEG1	9
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'].ACCATNUM
12	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	Posting Account Sequence	INT	Integer	0
28	Posting_Account_Sequence_3	Posting Account Sequence[3]	Integer	INT	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

azurecurve Products Microsoft Dynamics GP (0)Dexterity SystemDefault Chart of Accounts (SY90100)

Click to show/hide

Leave a Reply Cancel reply