ASIEXP29 - SmartList Tax History | Prospr - Dynamics GP Table Reference

ASIEXP29 - SmartList Tax History

Query Builder

Select * from ASIEXP29

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
ASI_Favorite_Sequence	ASI_Favorite_Sequence	Long Integer	4	View
ASI_Order_By	ASI_Order_By	Long Integer	4	View
ASI_Document_Status	ASI_Document_Status	Integer	2	View
DOCNUMBR	Document Number	String	22	View
DOCTYPE	Document Type	Integer	2	View
SERIES	Series 1 = All 2 = Financial 3 = Sales 4 = Purchasing 5 = Inventory 6 = Payroll - USA 7 = Project	Integer	2	View
RCTRXSEQ	Recurring TRX Sequence	Currency	10	View
SEQNUMBR	Sequence Number	Long Integer	4	View
TAXDTLID	Tax Detail ID	String	16	View
TXDTLPCT	Tax Detail Percent	Currency	10	View
TXDTLAMT	Tax Detail Amount	Currency	10	View
ACTINDX	Account Index	Long Integer	4	View
DOCDATE	Document Date	Date	4	View
Tax_Date	Tax Date	Date	4	View
PSTGDATE	Posting Date	Date	4	View
TAXAMNT	Tax Amount	Currency	10	View
ORTAXAMT	Originating Tax Amount	Currency	10	View
Taxable_Amount	Taxable Amount	Currency	10	View
Originating_Taxable_Amt	Originating Taxable Amount	Currency	10	View
DOCAMNT	Document Amount	Currency	10	View
ORDOCAMT	Originating Document Amount	Currency	10	View
ECTRX	EC Transaction	Boolean	2	View
VOIDSTTS	Void Status 0 = Document has not been voided. 1 = Document has been voided. 2 = Document has been marked NSF and voided.	Integer	2	View
CustomerVendor_ID	Customer/Vendor ID	String	16	View
CURRNIDX	Currency Index	Integer	2	View
Included_On_Return	Included On Return	Boolean	2	View
Tax_Return_ID	Tax Return ID	String	22	View
TXORGN	Tax Origin	Integer	2	View
TXDTLTYP	Tax Detail Type	Integer	2	View
TXDTLDSC	Tax Detail Description	String	32	View
TXDTLBSE	Tax Detail Base	Integer	2	View
TXDETPCTAMT	Tax Detail Percent/Amount	String	16	View
CustomerVendor_Name	Customer/Vendor Name	String	66	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

ASIEXP29 - SmartList Tax History

Query Builder

Customer Service

Information

My Account

Contact Us