coAccoun - Account Cache | Prospr - Dynamics GP Table Reference

coAccoun - Account Cache

Select * from coAccoun

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
ACTALIAS	Account Alias	String	22	View
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
ACTDESCR	Account Description	String	52	View
DECPLACS	Decimal Places	Integer	2	View
ACCTTYPE	Account Type Field values: 1 = Posting Account 2 = Unit Account 3 = Posting Allocation Account 4 = Unit Allocation Account	Integer	2	View
PostIvIn	Post Inventory In 1 = Detail 2 = Summary	Integer	2	View
PostPRIn	Post Payroll In 1 = Detail 2 = Summary	Integer	2	View
PostPurchIn	Post Purchasing In 1 = Detail 2 = Summary	Integer	2	View
PostSlsIn	Post Sales In 1 = Detail 2 = Summary	Integer	2	View