GP Tables

ASIEXP23 - Item Vendor SmartList

Dynamics GP table ASIEXP23 (Item Vendor SmartList) contains 181 columns including ASI_Favorite_Sequence, ASI_Order_By, ITEMNMBR....

SQL Query Builder

181 Columns

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

Related Tables

Tables that share columns with ASIEXP23. Click "Join" to add to your query.

NOTEINDX

AAG00400 AAG00401 AF40100 AF40103 AF40106 ASIEXP01 ASIEXP02 ASIEXP03

CURNCYID

AAG10001 AAG20001 AAG20011 AAG2001T AAG30001 AAG40001 AAG50001 AAG60001

CURRNIDX

AAG10001 AAG20001 AAG20011 AAG2001T AAG30001 AAG40001 AAG50001 AAG60001

RATETPID

AAG10001 AAG20001 AAG20011 AAG2001T AAG30001 AAG40001 ASIEXP02 ASIEXP03

VENDORID

ASIEXP03 ASIEXP07 ASIEXP09 ASIEXP11 ASIEXP16 ASIEXP21 ASIEXP27 ASIEXP28

MODIFDT

ASIEXP01 ASIEXP02 ASIEXP03 ASIEXP04 ASIEXP06 ASIEXP07 ASIEXP09 ASIEXP11

CREATDDT

ASIEXP01 ASIEXP02 ASIEXP03 ASIEXP04 ASIEXP06 ASIEXP07 ASIEXP11 ASIEXP12

SHIPMTHD

ASIEXP02 ASIEXP03 ASIEXP06 ASIEXP07 ASIEXP08 ASIEXP09 ASIEXP11 ASIEXP15

TAXSCHID

ASIEXP02 ASIEXP03 ASIEXP06 ASIEXP07 ASIEXP08 ASIEXP09 ASIEXP11 ASIEXP15

PYMTRMID

ASIEXP02 ASIEXP03 ASIEXP06 ASIEXP07 ASIEXP08 ASIEXP09 ASIEXP11 ASIEXP15