ASIEXP14 - ASI_MDA_SmartList | Prospr - Dynamics GP Table Reference

ASIEXP14 - ASI_MDA_SmartList

Select * from ASIEXP14

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
ASI_Order_By	ASI_Order_By	Long Integer	4	View
ACTINDX	Account Index	Long Integer	4	View
CODEAMT	DTA_Amount	Currency	10	View
CODEID	DTA_Code_ID	String	16	View
GROUPID	DTA_Group_ID	String	16	View
POSTDESC	DTA_Posting_Descr	String	52	View
DTAQNTY	DTA_Quantity	Currency	10	View
DTAREF	DTA_Reference	String	26	View
DTASERIES	DTA_Series	Integer	2	View
DOCNUMBR	Document Number	String	22	View
RMDTYPAL	RM Document Type-All 0 = Reserved for balance carried forward records 1 = Sales / Invoice 2 = Reserved for schedule payments 3 = Debit Memos 4 = Finance Charges 5 = Service Repairs 6= Warranties 7 = Credit Memos 8 = Returns 9 = Payments	Integer	2	View
SEQNUMBR	Sequence Number	Long Integer	4	View
TRXDATE	TRX Date	Date	4	View
DTA_GL_Reference	DTA_GL_Reference	String	26	View
GROUPAMT	DTA_Group_Amount	Currency	10	View
JRNENTRY	Journal Entry	Long Integer	4	View
PSTGSTUS	Posting Status 1 = Work 2 = Open 3 = History 4 = Originating	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
ASI_Favorite_Sequence	ASI_Favorite_Sequence	Long Integer	4	View