GP Tables

ASIEXP19 - SmartList Inventory Transaction Amount

Dynamics GP table ASIEXP19 (SmartList Inventory Transaction Amount) contains 107 columns including ASI_Order_By, DOCNUMBR, IVDOCTYP....

SQL Query Builder

107 Columns

Column Description Type Length
ASI_Order_By ASI_Order_By Long Integer 4
DOCNUMBR Document Number String 22
IVDOCTYP IV Document Type Integer 2
ASI_Document_Status ASI_Document_Status Integer 2
ITEMNMBR Item Number String 32
LNSEQNBR Line SEQ Number Currency 10
UOFM U Of M String 10
QTYBSUOM QTY In Base U Of M Currency 10
TRXQTY TRX QTY Currency 10
UNITCOST Unit Cost Currency 10
EXTDCOST Extended Cost Currency 10
TRXLOCTN TRX Location String 12
TRNSTLOC Transfer To Location String 12
TRFQTYTY Transfer From QTY Type1 = On Hand2 = Returned3 = In Use4 = In Service5 = Damaged Integer 2
TRTQTYTY Transfer To QTY Type1 = On Hand2 = Returned3 = In Use4 = In Service5 = Damaged Integer 2
IVIVINDX IV IV Index Long Integer 4
IVIVOFIX IV IV Offset Index Long Integer 4
IVWLNMSG IV WORK LINE Messages Long Integer 4
TRXSORCE TRX Source String 14
DOCDATE Document Date Date 4
HSTMODUL History Module String 4
CUSTNMBR Customer Number String 16
ITEMDESC Item Description String 102
NOTEINDX Note Index Currency 10
ITMSHNAM Item Short Name 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
ITMGEDSC Item Generic Description String 12
STNDCOST Standard Cost Currency 10
CURRCOST Current Cost Currency 10
LISTPRCE List Price Currency 10
ITEMSHWT Item Shipping Weight Long Integer 4
DECPLQTY Decimal Places QTYS Integer 2
DECPLCUR Decimal Places Currency Integer 2
ITMTSHID Item Tax Schedule ID String 16
TAXOPTNS Tax Options1.  Taxable2.  Nontaxable3.  Base on customers Integer 2
Tax Options values (3)
1 = Taxable2 = Nontaxable3 = Base on customer/vendor
COMMCODE Commission Code String 16
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
ITMTRKOP Item Tracking Option1. None2. Serial Numbers3. Lot Numbers Integer 2
Item Tracking Option values (3)
1 = None2 = Serial Numbers3 = Lot Numbers
LOTTYPE Lot Type String 12
KPERHIST Keep Period History Boolean 2
KPTRXHST Keep Trx History Boolean 2
KPCALHST Keep Calendar History Boolean 2
KPDSTHST Keep Distribution History Boolean 2
ALWBKORD Allow Back Orders Boolean 2
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
UOMSCHDL U Of M Schedule String 12
ObjRef1 ObjRef1 Invalid storage type 30 0
ALTITEM1 Alternate Item 1 String 32
ALTITEM2 Alternate Item 2 String 32
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
MSTRCDTY Master Record Type Integer 2
MODIFDT Modified Date Date 4
CREATDDT Created Date Date 4
WRNTYDYS Warranty Days Integer 2
PRCLEVEL PriceLevel String 12
LOCNCODE Location Code String 12
ASI_Main_IV_IV_Index ASI_Main_IV_IV_Index Long Integer 4
ASI_Main_IV_IV_Offset_In ASI_Main_IV_IV_Offset_Index Long Integer 4
BACHNUMB Batch Number String 16
BCHSOURC Batch Source String 16
RCDOCNUM Recurring Document Number String 22
MDFUSRID Modified User ID String 16
POSTEDDT Posted Date Date 4
PTDUSRID Posted User ID String 16
GLPOSTDT GL Posting Date Date 4
PSTGSTUS Posting Status1 = Work2 = Open3 = History4 = Originating Integer 2
Posting Status values (11)
0 = Unposted / New1 = Unposted / Work2 = Posted / Open3 = History / Posted with Error10 = First entry before save20 = Saved and unposted30 = Currently posting40 = Posted50 = Error during posting60 = Edited after save70 = Edited recurring batch
TRXQTYTL TRX QTY Total Currency 10
IVWHRMSG IV WORK HDR Messages Long Integer 4
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
LOCNCODE1 ASI_Location_Code String 12
USAGETYPE Usage Type Integer 2
SRCRFRNCNMBR Source Reference Number String 32
SOURCEINDICATOR Source Indicator1 – (none)2 – Issue3 – Reverse Issue4 – Finished Good Post5 – Reverse Finished Good Post6 – Stock Count7 – Field Service – Service Call8 – Field Service – Return Material Authoization9 – Field Service – Return to Vendor10 – Field Service – Work Order11 – Project Accounting Integer 2
UMSCHDSC U Of M Schedule Description String 32

Related Tables

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

NOTEINDX

AAG00400 AAG00401 AF40100 AF40103 AF40106 ASIEXP01 ASIEXP02 ASIEXP03

CUSTNMBR

ASIEXP02 ASIEXP06 ASIEXP07 ASIEXP08 ASIEXP15 ASIEXP20 ASIEXP21 ASIEXP24

TRXSORCE

ASIEXP06 ASIEXP07 ASIEXP08 ASIEXP09 ASIEXP10 ASIEXP12 ASIEXP18 ASIEXP20

BACHNUMB

ASIEXP06 ASIEXP08 ASIEXP09 ASIEXP10 ASIEXP12 ASIEXP20 ASIEXP25 ASIEXP27

DOCDATE

ASIEXP06 ASIEXP07 ASIEXP08 ASIEXP09 ASIEXP12 ASIEXP20 ASIEXP21 ASIEXP25

MODIFDT

ASIEXP01 ASIEXP02 ASIEXP03 ASIEXP04 ASIEXP06 ASIEXP07 ASIEXP09 ASIEXP11

CREATDDT

ASIEXP01 ASIEXP02 ASIEXP03 ASIEXP04 ASIEXP06 ASIEXP07 ASIEXP11 ASIEXP12

BCHSOURC

ASIEXP06 ASIEXP08 ASIEXP09 ASIEXP12 ASIEXP20 ASIEXP25 ASIEXP27 ASIEXP28

GLPOSTDT

AAG20001 AAG20011 ASIEXP06 ASIEXP08 ASIEXP20 ASIEXP22 ASIEXP25 ASIEXP27

DOCNUMBR

ASIEXP08 ASIEXP09 ASIEXP14 ASIEXP29 CFM20101 CFM20102 CN100201 CN20100