GP Tables

ASIEXP11 - SmartList Item Quantity Master

Dynamics GP table ASIEXP11 (SmartList Item Quantity Master) contains 250 columns including ASI_Order_By, ITEMNMBR, LOCNCODE....

SQL Query Builder

250 Columns

Column Description Type Length
ASI_Order_By ASI_Order_By Long Integer 4
ITEMNMBR Item Number String 32
LOCNCODE Location Code String 12
BINNMBR Bin Number String 22
RCRDTYPE Record Type Integer 2
Record Type (Quantity Master) values (2)
1 = Overall (all sites)2 = Site-specific
PRIMVNDR Primary Vendor String 16
ITMFRFLG Item Freeze Flag Boolean 2
BGNGQTY Beginning QTY Currency 10
LSORDQTY Last ORD QTY Currency 10
LRCPTQTY Last RCPT QTY Currency 10
LSTORDDT Last ORD Date Date 4
LSORDVND Last ORD Vendor String 16
LSRCPTDT Last RCPT Date Date 4
QTYRQSTN QTY Requisitioned Currency 10
QTYONORD QTY On Order Currency 10
QTYBKORD QTY Back Ordered Currency 10
QTY_Drop_Shipped QTY Drop Shipped Currency 10
ORDRPNTQTY Order Point Qty Currency 10
REORDERVARIANCE Reorder Variance Currency 10
ORDRUPTOLVL Order Up To Level Currency 10
QTYINUSE QTY In Use Currency 10
QTYINSVC QTY In Service Currency 10
QTYRTRND QTY Returned Currency 10
QTYDMGED QTY Damaged Currency 10
QTYONHND QTY On Hand Currency 10
ATYALLOC QTY Allocated Currency 10
QTYCOMTD QTY Committed Currency 10
QTYSOLD QTY Sold Currency 10
DECPLQTY Decimal Places QTYS Integer 2
DECPLCUR Decimal Places Currency Integer 2
QTYAVAIL QTY Available Currency 10
ITEMDESC Item Description String 102
ITMGEDSC Item Generic Description String 12
ITMSHNAM Item Short Name String 16
VENDNAME Vendor Name String 66
VNDITNUM Vendor Item Number String 32
VNDITDSC Vendor Item Description String 102
CURRCOST Current Cost Currency 10
STNDCOST Standard Cost Currency 10
BASEUOFM Base U Of M String 10
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
ALTITEM1 Alternate Item 1 String 32
ALTITEM2 Alternate Item 2 String 32
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
ITMTSHID Item Tax Schedule ID String 16
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
ITMTRKOP Item Tracking Option1. None2. Serial Numbers3. Lot Numbers Integer 2
Item Tracking Option values (3)
1 = None2 = Serial Numbers3 = Lot Numbers
KPERHIST Keep Period History Boolean 2
KPTRXHST Keep Trx History Boolean 2
KPCALHST Keep Calendar History Boolean 2
KPDSTHST Keep Distribution History Boolean 2
ITEMSHWT Item Shipping Weight Long Integer 4
TAXOPTNS Tax Options1.  Taxable2.  Nontaxable3.  Base on customers Integer 2
Tax Options values (3)
1 = Taxable2 = Nontaxable3 = Base on customer/vendor
IVIVINDX IV IV Index Long Integer 4
IVIVOFIX IV IV Offset Index Long Integer 4
IVCOGSIX IV COGS Index Long Integer 4
IVSLSIDX IV Sales Index Long Integer 4
IVSLDSIX IV Sales Discounts Index Long Integer 4
IVSLRNIX IV Sales Returns Index Long Integer 4
IVINUSIX IV In Use Index Long Integer 4
IVINSVIX IV In Service Index Long Integer 4
IVDMGIDX IV Damaged Index Long Integer 4
IVVARIDX IV Variances Index Long Integer 4
DPSHPIDX Drop Ship Index Long Integer 4
PURPVIDX Purchase Price Variance Index Long Integer 4
IVRETIDX Inventory Returns Index Long Integer 4
ASMVRIDX Assembly Variance Index Long Integer 4
ITMCLSCD Item Class Code String 12
LOTTYPE Lot Type String 12
ALWBKORD Allow Back Orders Boolean 2
UOMSCHDL U Of M Schedule String 12
MSTRCDTY Master Record Type Integer 2
WRNTYDYS Warranty Days Integer 2
PRCLEVEL PriceLevel String 12
ASI_Favorite_Sequence ASI_Favorite_Sequence Long Integer 4
ABCCODE ABC Code1 – (None)2 – A3 – B4 – C Integer 2
CGSINFLX COGS Inflation Index Long Integer 4
CGSMCIDX COGS Monetary Correction Index Long Integer 4
IVINFIDX Inventory Inflation Index Long Integer 4
INVMCIDX Inventory Monetary Correction Index Long Integer 4
ITEMCODE Item Code String 16
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
PriceGroup Price Group 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
PRCHSUOM Purchasing U Of M String 10
SELNGUOM Selling U Of M String 10
TCC Tax Commodity Code String 32
UPPVIDX Unrealized Purchase Price Variance Index Long Integer 4
LSTCNTDT Last Count Date Date 4
LSTCNTTM Last Count Time Time 4
NXTCNTDT Next Count Date Date 4
NXTCNTTM Next Count Time Time 4
STCKCNTINTRVL Stock Count Interval Integer 2
LOCNCODE1 ASI_Location_Code String 12
VENDORID Vendor ID String 16
VNDCHKNM Vendor Check Name String 66
VENDSHNM Vendor Short Name String 16
VADDCDPR Vendor Address Code - Primary String 16
VADCDPAD Vendor Address Code - Purchase Address String 16
VADCDSFR Vendor Address Code - Ship From String 16
VADCDTRO Vendor Address Code - Remit To String 16
VNDCLSID Vendor Class ID String 12
VNDCNTCT Vendor Contact String 62
ADDRESS1 Address 1 String 62
ADDRESS2 Address 2 String 62
ADDRESS3 Address 3 String 62
CITY City String 36
STATE State String 30
ZIPCODE Zip Code String 12
COUNTRY Country String 62
PHNUMBR1 Phone Number 1 String 22
PHNUMBR2 Phone Number 2 String 22
FAXNUMBR Fax Number String 22
UPSZONE UPS Zone String 4
SHIPMTHD Shipping Method String 16
TAXSCHID Tax Schedule ID String 16
ACNMVNDR Account Number With Vendor String 22
TXIDNMBR Tax ID Number String 12
VENDSTTS Vendor Status1. Active2. Inactive3. Temporary Integer 2
Vendor Status values (3)
1 = Active2 = Inactive3 = Temporary
CURNCYID Currency ID Functional currency code (e.g., USD, CAD, GBP). Use to filter or group multicurrency transactions. String 16
TXRGNNUM Tax Registration Number String 26
PARVENID Parent Vendor ID String 16
TRDDISCT Trade Discount Integer 2
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
MINORDER Minimum Order Currency 10
PYMTRMID Payment Terms ID String 22
MINPYTYP Minimum Payment Type Integer 2
MINPYPCT Minimum Payment Percent Integer 2
MINPYDLR Minimum Payment Dollar Currency 10
MXIAFVND Maximum Invoice Amount For Vendors Integer 2
MAXINDLR Maximum Invoice Dollar Currency 10
COMMENT1 Comment1 String 32
COMMENT2 Comment2 String 32
USERDEF1 User Defined 1 String 22
USERDEF2 User Defined 2 String 22
CRLMTDLR Credit Limit Dollar Currency 10
PYMNTPRI Payment Priority String 4
KGLDSTHS Keep GL Dist History Boolean 2
HOLD Hold Boolean 2
Hold Status values (2)
0 = Not on hold1 = On hold
PTCSHACF Post To Cash Account From Integer 2
CREDTLMT Credit Limit Integer 2
Credit Limit Type values (3)
0 = No Credit1 = Unlimited2 = Amount (see CRLMTDLR)
WRITEOFF Writeoff Integer 2
MXWOFAMT Maximum Write Off Amount Currency 10
SBPPSDED Subject To PPS Deductions Boolean 2
PPSTAXRT PPS Tax Rate Integer 2
DXVARNUM Deduction Exemption/Variation Number String 26
CRTCOMDT Certificate Commencing Date Date 4
CRTEXPDT Certificate Expiration Date Date 4
RTOBUTKN Reporting Obligation Undertaken Boolean 2
XPDTOBLG Expiration Date Obligation Boolean 2
PRSPAYEE Prescribed Payee Boolean 2
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
PMMSCHIX PM Misc Charges Index Long Integer 4
PMFRTIDX PM Freight Index Long Integer 4
PMTAXIDX PM Tax Index Long Integer 4
PMWRTIDX PM Write Offs Index Long Integer 4
PMPRCHIX PM Purchases Index Long Integer 4
PMRTNGIX PM Retainage Index Long Integer 4
PMTDSCIX PM Trade Discount Index Long Integer 4
ACPURIDX Accrued Purchases Index Long Integer 4
PURPVIDX1 ASI_Purchase_Price_Variance_Index Long Integer 4
NOTEINDX Note Index Currency 10
CHEKBKID Checkbook ID String 16
MODIFDT Modified Date Date 4
CREATDDT Created Date Date 4
RATETPID Rate Type ID String 16
Revalue_Vendor Revalue Vendor Boolean 2
Post_Results_To Post Results To Integer 2
FREEONBOARD Free On Board Integer 2
DISGRPER Discount Grace Period Integer 2
DOCFMTID Document Format ID String 16
DUEGRPER Due Date Grace Period Integer 2
GOVCRPID Governmental Corporate ID String 32
GOVINDID Governmental Individual ID String 32
PHONE3 Phone 3 String 22
TaxInvRecvd Tax Invoice Received Boolean 2
KPCALHST1 ASI_Keep_Calendar_History Boolean 2
KPERHIST1 ASI_Keep_Period_History Boolean 2
KPTRXHST1 ASI_Keep_Trx_History Boolean 2
UMDPQTYS U Of M Decimal Places QTYS Integer 2
UMSCHDSC U Of M Schedule Description String 32
CURRNIDX Currency Index Integer 2
ECORDQTY Economic ORD QTY Currency 10
ITMVNDTY Item Vendor Type Integer 2
Item Vendor Type values (2)
1 = Primary Vendor2 = Non-primary Vendor
Last_Currency_ID Last Currency ID String 16
Last_Originating_Cost Last Originating Cost Currency 10
LRCPTCST Last RCPT Cost Currency 10
MAXORDQTY Maximum ORD QTY Currency 10
MINORQTY Minimum ORD QTY Currency 10
NORCTITM Number Of RCPTS For Item Integer 2
PLANNINGLEADTIME Planning Lead Time Integer 2
AVRGLDTM Average Lead Time Long Integer 4
FREEONBOARD1 ASI_Free_On_Board Integer 2
LSTORDDT1 ASI_Last_ORD_Date Date 4
LSORDQTY1 ASI_Last_ORD_QTY Currency 10
LSRCPTDT1 ASI_Last_RCPT_Date Date 4
LRCPTQTY1 ASI_Last_RCPT_QTY Currency 10
QTY_Drop_Shipped1 ASI_QTY_Drop_Shipped Currency 10
QTYONORD1 ASI_QTY_On_Order Currency 10
QTYRQSTN1 ASI_QTY_Requisitioned Currency 10
PRCHSUOM1 ASI_Purchasing_U_Of_M String 10
Landed_Cost_Group_ID Landed Cost Group ID String 16
PORETRNBIN Purchase Returns Bin String 16
SOFULFILLMENTBIN SO Fulfillment Bin String 16
SORETURNBIN SO Return Bin String 16
BOMRCPTBIN BOM Receipt Bin String 16
MATERIALISSUEBIN Material Issues Bin String 16
MORECEIPTBIN MO Receipt Bin String 16
REPAIRISSUESBIN Repair Issues Bin String 16
BUYERID Buyer ID String 16
PLANNERID Planner ID String 16
ORDERPOLICY Order Policy1 – Not planned2 – Lot for Lot3 – Fixed Order Quantity4 – Period Order Quantity5 – Order Point6 – Manually Planned (Removed for version 10.0) Integer 2
Order Policy values (6)
1 = Not planned2 = Lot for Lot3 = Fixed Order Quantity4 = Period Order Quantity5 = Order Point6 = Manually Planned
FXDORDRQTY Fixed Order Qty Currency 10
NMBROFDYS Number of Days Integer 2
MNMMORDRQTY Minimum Order Qty Currency 10
MXMMORDRQTY Maximum Order Qty Currency 10
ORDERMULTIPLE Order Multiple Currency 10
REPLENISHMENTMETHOD Replenishment Method1 – Make2 – Buy3- Make or Buy Integer 2
SHRINKAGEFACTOR Shrinkage Factor Currency 10
PRCHSNGLDTM Purchasing Lead Time Currency 10
MNFCTRNGFXDLDTM Manufacturing Fixed Lead Time Currency 10
MNFCTRNGVRBLLDTM Manufacturing Variable Lead Time Currency 10
STAGINGLDTME Staging Lead Time Currency 10
PLNNNGTMFNCDYS Planning Time Fence Days Integer 2
DMNDTMFNCPRDS Demand Time Fence Periods Integer 2
INCLDDINPLNNNG Included in Planning Boolean 2
FRCSTCNSMPTNPRD Forecast Consumption Period1 – Days2 – Weeks3 – Months Integer 2
SFTYSTCKQTY Safety Stock Qty Currency 10
PORECEIPTBIN Purchase Receipt Bin String 16
ReplenishmentLevel Replenishment Level Integer 2
POPOrderMethod POP Order Method Integer 2
MasterLocationCode Master Location Code String 12
POPVendorSelection POP Vendor Selection Integer 2
POPPricingSelection POP Pricing Selection Integer 2
PurchasePrice Purchase Price Currency 10
IncludeAllocations Include Allocations Boolean 2
IncludeBackorders Include Backorders Boolean 2
IncludeRequisitions Include Requisitions Boolean 2

Related Tables

Tables that share columns with ASIEXP11. 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 ASIEXP16 ASIEXP21 ASIEXP23 ASIEXP27 ASIEXP28

MODIFDT

ASIEXP01 ASIEXP02 ASIEXP03 ASIEXP04 ASIEXP06 ASIEXP07 ASIEXP09 ASIEXP12

CREATDDT

ASIEXP01 ASIEXP02 ASIEXP03 ASIEXP04 ASIEXP06 ASIEXP07 ASIEXP12 ASIEXP13

SHIPMTHD

ASIEXP02 ASIEXP03 ASIEXP06 ASIEXP07 ASIEXP08 ASIEXP09 ASIEXP15 ASIEXP16

TAXSCHID

ASIEXP02 ASIEXP03 ASIEXP06 ASIEXP07 ASIEXP08 ASIEXP09 ASIEXP15 ASIEXP16

PYMTRMID

ASIEXP02 ASIEXP03 ASIEXP06 ASIEXP07 ASIEXP08 ASIEXP09 ASIEXP15 ASIEXP16