GL00100 - Account Master | Prospr - Dynamics GP Table Reference

GL00100 - Account Master

Query Builder

Select * from GL00100

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
ACTINDX	Account Index	Long Integer	4	View
ACTNUMBR_1	Account Number:Account_Segment_Pool1	String	10	View
ACTNUMBR_2	Account Number:Account_Segment_Pool2	String	10	View
ACTNUMBR_3	Account Number:Account_Segment_Pool3	String	10	View
ACTNUMBR_4	Account Number:Account_Segment_Pool4	String	10	View
ACTNUMBR_5	Account Number:Account_Segment_Pool5	String	10	View
ACTALIAS	Account Alias	String	22	View
MNACSGMT	Main Account Segment	String	68	View
ACCTTYPE	Account Type Field values: 1 = Posting Account 2 = Unit Account 3 = Posting Allocation Account 4 = Unit Allocation Account	Integer	2	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
ACTIVE	Active 0 = False, for inactive records 1 = True, for active records	Boolean	2	View
TPCLBLNC	Typical Balance 0 = Debit 1 = Credit	Integer	2	View
DECPLACS	Decimal Places	Integer	2	View
FXDORVAR	Fixed Or Variable 1 = Fixed Allocation 2 = Variable Allocation	Integer	2	View
BALFRCLC	Balance For Calculation 0 = Year To Date 1 = TRX Period	Integer	2	View
DSPLKUPS	Display In Lookups 1 = Sales 2 = Inventory 3 = Purchasing 4 = Payroll	Long Integer	4	View
CNVRMTHD	Conversion Method 1 = Current Rate 2 = Average Rate 3 = Historical Rate	Integer	2	View
HSTRCLRT	Historical Rate	Currency (Variable)	10	View
NOTEINDX	Note Index	Currency	10	View
CREATDDT	Created Date	Date	4	View
MODIFDT	Modified Date	Date	4	View
USERDEF1	User Defined 1	String	22	View
USERDEF2	User Defined 2	String	22	View
PostSlsIn	Post Sales In 1 = Detail 2 = Summary	Integer	2	View
PostIvIn	Post Inventory In 1 = Detail 2 = Summary	Integer	2	View
PostPurchIn	Post Purchasing In 1 = Detail 2 = Summary	Integer	2	View
PostPRIn	Post Payroll In 1 = Detail 2 = Summary	Integer	2	View
ADJINFL	Adjust for Inflation	Boolean	2	View
INFLAREV	Inflation Revenue Account Index	Long Integer	4	View
INFLAEQU	Inflation Equity Account Index	Long Integer	4	View
ACCTENTR	Allow Account Entry	Boolean	2	View
USRDEFS1	User Defined String 1	String	32	View
USRDEFS2	User Defined String 2	String	32	View
Clear_Balance	Clear Balance 0 - Roll Balance Forward 1 - Clear Balance at Year End Close	Boolean	2	View

GL00100 - Account Master

Query Builder

Customer Service

Information

My Account

Contact Us