SY90100 - Default Chart of Accounts | Prospr - Dynamics GP Table Reference

SY90100 - Default Chart of Accounts

Query Builder

Select * from SY90100

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
Business_Type	Business Type	Integer	2	View
INDUSTYP	Industry Type	Integer	2	View
DEFCHRAC_1	Default Chart Account Number:Default Chart Account Segment1	String	10	View
DEFCHRAC_2	Default Chart Account Number:Default Chart Account Segment2	String	10	View
DEFCHRAC_3	Default Chart Account Number:Default Chart Account Segment3	String	10	View
DEFCHRAC_4	Default Chart Account Number:Default Chart Account Segment4	String	10	View
DEFCHRAC_5	Default Chart Account Number:Default Chart Account Segment5	String	10	View
ACTDESCR	Account Description	String	52	View
PSTNGTYP	Posting Type 0 = Balance Sheet 1 = Profit and Loss	Integer	2	View
ACCATNUM	Account Category Number 1 = Cash 2 = Short Term Investments 3 = Accounts Receivable 4 = Notes Receivable 5 = Inventory 6 = Work In Process 7 = Prepaid Expenses 8 = Long-Term Investments 9 = Property, Plant and Equipment 10 = Accumulated Depreciation 11 = Intangible Assets 12 = Other Assets 13 = Accounts Payable 14 = Notes Payable 15 = Current Maturities Of Long-Term Debt 16 = Taxes Payable 17 = Interest Payable 18 = Dividends Payable 19 = Leases Payable (Current) 20 = Sinking Fund Payable (Current) 21 = Other Current Liabilities 22 = Long-Term Debt 23 = Common Stock 24 = Preferred Stock 25 = Additional Paid-In Capital - Common 26 = Additional Paid-In Capital - Preferred 27 = Retained Earnings 28 = Treasury Stock 29 = Common Dividends 30 = Preferred Dividends 31 = Sales 32 = Sales Returns And Discounts 33 = Cost Of Goods Sold 34 = Selling Expense 35 = Administrative Expense 36 = Salaries Expense 37 = Other Employee Expenses 38 = Interest Expense 39 = Tax Expense 40 = Depreciation Expense 41 = Income Tax Expense 42 = Other Expenses 43 = Other Income 44 = Charges Not Using Working Capital 45 = Revenues Not Producing Working Capital 46 = Gain/Loss On Asset Disposal 47 = Amortization Of Intangible Assets 48 = Non-Financial Accounts	Integer	2	View
TPCLBLNC	Typical Balance 0 = Debit 1 = Credit	Integer	2	View
Posting_Account_Series_1	Posting Account Series[1]	Integer	2	View
Posting_Account_Series_2	Posting Account Series[2]	Integer	2	View
Posting_Account_Series_3	Posting Account Series[3]	Integer	2	View
Posting_Account_Series_4	Posting Account Series[4]	Integer	2	View
Posting_Account_Series_5	Posting Account Series[5]	Integer	2	View
Posting_Account_Series_6	Posting Account Series[6]	Integer	2	View
Posting_Account_Series_7	Posting Account Series[7]	Integer	2	View
Posting_Account_Series_8	Posting Account Series[8]	Integer	2	View
Posting_Account_Series_9	Posting Account Series[9]	Integer	2	View
Posting_Account_Series_10	Posting Account Series[10]	Integer	2	View
Posting_Account_Series_11	Posting Account Series[11]	Integer	2	View
Posting_Account_Sequence_1	Posting Account Sequence[1]	Integer	2	View
Posting_Account_Sequence_2	Posting Account Sequence[2]	Integer	2	View
Posting_Account_Sequence_3	Posting Account Sequence[3]	Integer	2	View
Posting_Account_Sequence_4	Posting Account Sequence[4]	Integer	2	View
Posting_Account_Sequence_5	Posting Account Sequence[5]	Integer	2	View
Posting_Account_Sequence_6	Posting Account Sequence[6]	Integer	2	View
Posting_Account_Sequence_7	Posting Account Sequence[7]	Integer	2	View
Posting_Account_Sequence_8	Posting Account Sequence[8]	Integer	2	View
Posting_Account_Sequence_9	Posting Account Sequence[9]	Integer	2	View
Posting_Account_Sequence_10	Posting Account Sequence[10]	Integer	2	View
Posting_Account_Sequence_11	Posting Account Sequence[11]	Integer	2	View

SY90100 - Default Chart of Accounts

Query Builder

Customer Service

Information

My Account

Contact Us