ASIEXP23 - Item Vendor SmartList | Prospr - Dynamics GP Table Reference

ASIEXP23 - Item Vendor SmartList

Query Builder

Select * from ASIEXP23

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
ITEMNMBR	Item Number	String	32	View
VENDORID	Vendor ID	String	16	View
ITMVNDTY	Item Vendor Type	Integer	2	View
VNDITNUM	Vendor Item Number	String	32	View
QTYRQSTN	QTY Requisitioned	Currency	10	View
QTYONORD	QTY On Order	Currency	10	View
QTY_Drop_Shipped	QTY Drop Shipped	Currency	10	View
LSTORDDT	Last ORD Date	Date	4	View
LSORDQTY	Last ORD QTY	Currency	10	View
LRCPTQTY	Last RCPT QTY	Currency	10	View
LSRCPTDT	Last RCPT Date	Date	4	View
LRCPTCST	Last RCPT Cost	Currency	10	View
AVRGLDTM	Average Lead Time	Long Integer	4	View
NORCTITM	Number Of RCPTS For Item	Integer	2	View
MINORQTY	Minimum ORD QTY	Currency	10	View
MAXORDQTY	Maximum ORD QTY	Currency	10	View
ECORDQTY	Economic ORD QTY	Currency	10	View
VNDITDSC	Vendor Item Description	String	102	View
Last_Originating_Cost	Last Originating Cost	Currency	10	View
Last_Currency_ID	Last Currency ID	String	16	View
FREEONBOARD	Free On Board	Integer	2	View
PRCHSUOM	Purchasing U Of M	String	10	View
CURRNIDX	Currency Index	Integer	2	View
PLANNINGLEADTIME	Planning Lead Time	Integer	2	View
ABCCODE	ABC Code 1 – (None) 2 – A 3 – B 4 – C	Integer	2	View
ALWBKORD	Allow Back Orders	Boolean	2	View
ALTITEM1	Alternate Item 1	String	32	View
ALTITEM2	Alternate Item 2	String	32	View
ASMVRIDX	Assembly Variance Index	Long Integer	4	View
CGSINFLX	COGS Inflation Index	Long Integer	4	View
CGSMCIDX	COGS Monetary Correction Index	Long Integer	4	View
CREATDDT	Created Date	Date	4	View
CURRCOST	Current Cost	Currency	10	View
DECPLCUR	Decimal Places Currency	Integer	2	View
DECPLQTY	Decimal Places QTYS	Integer	2	View
DPSHPIDX	Drop Ship Index	Long Integer	4	View
IVINFIDX	Inventory Inflation Index	Long Integer	4	View
INVMCIDX	Inventory Monetary Correction Index	Long Integer	4	View
IVRETIDX	Inventory Returns Index	Long Integer	4	View
ITMCLSCD	Item Class Code	String	12	View
ITEMCODE	Item Code	String	16	View
ITEMDESC	Item Description	String	102	View
ITMGEDSC	Item Generic Description	String	12	View
ITEMSHWT	Item Shipping Weight	Long Integer	4	View
ITMSHNAM	Item Short Name	String	16	View
ITMTSHID	Item Tax Schedule ID	String	16	View
ITMTRKOP	Item Tracking Option 1. None 2. Serial Numbers 3. Lot Numbers	Integer	2	View
ITEMTYPE	Item Type 1. Sales Inventory (For SBM, this type is Stock Item.) 2. Discontinued 3. Kit 4. Misc Charges 5. Services 6. Flat Fee (For SBM, this type is Labor.)	Integer	2	View
IVCOGSIX	IV COGS Index	Long Integer	4	View
IVDMGIDX	IV Damaged Index	Long Integer	4	View
IVINSVIX	IV In Service Index	Long Integer	4	View
IVINUSIX	IV In Use Index	Long Integer	4	View
IVIVINDX	IV IV Index	Long Integer	4	View
IVIVOFIX	IV IV Offset Index	Long Integer	4	View
IVSLDSIX	IV Sales Discounts Index	Long Integer	4	View
IVSLSIDX	IV Sales Index	Long Integer	4	View
IVSLRNIX	IV Sales Returns Index	Long Integer	4	View
IVVARIDX	IV Variances Index	Long Integer	4	View
KPCALHST	Keep Calendar History	Boolean	2	View
KPDSTHST	Keep Distribution History	Boolean	2	View
KPERHIST	Keep Period History	Boolean	2	View
KPTRXHST	Keep Trx History	Boolean	2	View
KTACCTSR	Kit COGS Account Source 0 – COGS accounts from the components 1 – COGS account from the kit	Integer	2	View
LASTGENSN	Last Generated Serial Number	String	22	View
LOCNCODE	Location Code	String	12	View
LOTTYPE	Lot Type	String	12	View
MSTRCDTY	Master Record Type	Integer	2	View
MODIFDT	Modified Date	Date	4	View
NOTEINDX	Note Index	Currency	10	View
PriceGroup	Price Group	String	12	View
PRCLEVEL	PriceLevel	String	12	View
PRICMTHD	Price Method 1 – Currency Amount 2 – % of List Price 3 – % Markup – Current Cost 4 – % Markup – Standard Cost 5 – % Margin – Current Cost 6 – % Margin – Standard Cost	Integer	2	View
PINFLIDX	Purch Inflation Index	Long Integer	4	View
PURMCIDX	Purch Monetary Correction Index	Long Integer	4	View
PURPVIDX	Purchase Price Variance Index	Long Integer	4	View
SELNGUOM	Selling U Of M	String	10	View
STNDCOST	Standard Cost	Currency	10	View
TCC	Tax Commodity Code	String	32	View
TAXOPTNS	Tax Options 1. Taxable 2. Nontaxable 3. Base on customers	Integer	2	View
UOMSCHDL	U Of M Schedule	String	12	View
UPPVIDX	Unrealized Purchase Price Variance Index	Long Integer	4	View
VCTNMTHD	Valuation Method 1. FIFO Perpetual 2. LIFO Perpetual 3. Average Perpetual 4. FIFO Periodic (This value is not available for SBM.) 5. LIFO Periodic (This value is not available for SBM.)	Integer	2	View
WRNTYDYS	Warranty Days	Integer	2	View
USCATVLS_1	User Category Values[1]	String	12	View
USCATVLS_2	User Category Values[2]	String	12	View
USCATVLS_3	User Category Values[3]	String	12	View
USCATVLS_4	User Category Values[4]	String	12	View
USCATVLS_5	User Category Values[5]	String	12	View
USCATVLS_6	User Category Values[6]	String	12	View
TEN99TYPE	1099 Type 1 – Not a 1099 vendor 2 – Dividend 3 – Interest 4 - Miscellaneous	Integer	2	View
ACNMVNDR	Account Number With Vendor	String	22	View
ACPURIDX	Accrued Purchases Index	Long Integer	4	View
ADDRESS1	Address 1	String	62	View
ADDRESS2	Address 2	String	62	View
ADDRESS3	Address 3	String	62	View
CRTCOMDT	Certificate Commencing Date	Date	4	View
CRTEXPDT	Certificate Expiration Date	Date	4	View
CHEKBKID	Checkbook ID	String	16	View
CITY	City	String	36	View
COMMENT1	Comment1	String	32	View
COMMENT2	Comment2	String	32	View
COUNTRY	Country	String	62	View
CREDTLMT	Credit Limit	Integer	2	View
CRLMTDLR	Credit Limit Dollar	Currency	10	View
CURNCYID	Currency ID	String	16	View
DXVARNUM	Deduction Exemption/Variation Number	String	26	View
DISGRPER	Discount Grace Period	Integer	2	View
DOCFMTID	Document Format ID	String	16	View
DUEGRPER	Due Date Grace Period	Integer	2	View
XPDTOBLG	Expiration Date Obligation	Boolean	2	View
FAXNUMBR	Fax Number	String	22	View
GOVCRPID	Governmental Corporate ID	String	32	View
GOVINDID	Governmental Individual ID	String	32	View
HOLD	Hold	Boolean	2	View
KGLDSTHS	Keep GL Dist History	Boolean	2	View
MXIAFVND	Maximum Invoice Amount For Vendors	Integer	2	View
MAXINDLR	Maximum Invoice Dollar	Currency	10	View
MXWOFAMT	Maximum Write Off Amount	Currency	10	View
MINORDER	Minimum Order	Currency	10	View
MINPYDLR	Minimum Payment Dollar	Currency	10	View
MINPYPCT	Minimum Payment Percent	Integer	2	View
MINPYTYP	Minimum Payment Type	Integer	2	View
PARVENID	Parent Vendor ID	String	16	View
PYMNTPRI	Payment Priority	String	4	View
PYMTRMID	Payment Terms ID	String	22	View
PHONE3	Phone 3	String	22	View
PHNUMBR1	Phone Number 1	String	22	View
PHNUMBR2	Phone Number 2	String	22	View
PMAPINDX	PM AP Index	Long Integer	4	View
PMCSHIDX	PM Cash Index	Long Integer	4	View
PMDAVIDX	PM Discount Available Index	Long Integer	4	View
PMDTKIDX	PM Discount Taken Index	Long Integer	4	View
PMFINIDX	PM Finance Charge Index	Long Integer	4	View
PMFRTIDX	PM Freight Index	Long Integer	4	View
PMMSCHIX	PM Misc Charges Index	Long Integer	4	View
PMPRCHIX	PM Purchases Index	Long Integer	4	View
PMRTNGIX	PM Retainage Index	Long Integer	4	View
PMTAXIDX	PM Tax Index	Long Integer	4	View
PMTDSCIX	PM Trade Discount Index	Long Integer	4	View
PMWRTIDX	PM Write Offs Index	Long Integer	4	View
Post_Results_To	Post Results To	Integer	2	View
PTCSHACF	Post To Cash Account From	Integer	2	View
PPSTAXRT	PPS Tax Rate	Integer	2	View
PRSPAYEE	Prescribed Payee	Boolean	2	View
RATETPID	Rate Type ID	String	16	View
RTOBUTKN	Reporting Obligation Undertaken	Boolean	2	View
Revalue_Vendor	Revalue Vendor	Boolean	2	View
SHIPMTHD	Shipping Method	String	16	View
STATE	State	String	30	View
SBPPSDED	Subject To PPS Deductions	Boolean	2	View
TXIDNMBR	Tax ID Number	String	12	View
TaxInvRecvd	Tax Invoice Received	Boolean	2	View
TXRGNNUM	Tax Registration Number	String	26	View
TAXSCHID	Tax Schedule ID	String	16	View
TRDDISCT	Trade Discount	Integer	2	View
UPSZONE	UPS Zone	String	4	View
USERDEF1	User Defined 1	String	22	View
USERDEF2	User Defined 2	String	22	View
VADDCDPR	Vendor Address Code - Primary	String	16	View
VADCDPAD	Vendor Address Code - Purchase Address	String	16	View
VADCDTRO	Vendor Address Code - Remit To	String	16	View
VADCDSFR	Vendor Address Code - Ship From	String	16	View
VNDCHKNM	Vendor Check Name	String	66	View
VNDCLSID	Vendor Class ID	String	12	View
VNDCNTCT	Vendor Contact	String	62	View
VENDNAME	Vendor Name	String	66	View
VENDSHNM	Vendor Short Name	String	16	View
VENDSTTS	Vendor Status 1. Active 2. Inactive 3. Temporary	Integer	2	View
WRITEOFF	Writeoff	Integer	2	View
ZIPCODE	Zip Code	String	12	View
CREATDDT1	ASI_Created_Date	Date	4	View
KPCALHST1	ASI_Keep_Calendar_History	Boolean	2	View
KPERHIST1	ASI_Keep_Period_History	Boolean	2	View
KPTRXHST1	ASI_Keep_Trx_History	Boolean	2	View
MODIFDT1	ASI_Modified_Date	Date	4	View
NOTEINDX1	ASI_Note_Index	Currency	10	View
PRCHSUOM1	ASI_Purchasing_U_Of_M	String	10	View
FREEONBOARD1	ASI_Free_On_Board	Integer	2	View
PURPVIDX1	ASI_Purchase_Price_Variance_Index	Long Integer	4	View

ASIEXP23 - Item Vendor SmartList

Query Builder

Customer Service

Information

My Account

Contact Us