GL11110 - Account Summary Master View | Prospr

GL11110 - Account Summary Master View

Query Builder

Select * from GL11110

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
ACTINDX	Account Index	Long Integer	4	View
YEAR1	Year	Integer	2	View
PERIODID	Period ID	Integer	2	View
Ledger_ID	Ledger ID	Integer	2	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
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
PERDBLNC	Period Balance	Currency	10	View
CRDTAMNT	Credit Amount	Currency	10	View
DEBITAMT	Debit Amount	Currency	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
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

GL11110 - Account Summary Master View

Query Builder

Customer Service

Information

My Account

Contact Us