ASIEXP19 - SmartList Inventory Transaction Amount | Prospr

ASIEXP19 - SmartList Inventory Transaction Amount

Query Builder

Select * from ASIEXP19

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
ASI_Order_By	ASI_Order_By	Long Integer	4	View
DOCNUMBR	Document Number	String	22	View
IVDOCTYP	IV Document Type	Integer	2	View
ASI_Document_Status	ASI_Document_Status	Integer	2	View
ITEMNMBR	Item Number	String	32	View
LNSEQNBR	Line SEQ Number	Currency	10	View
UOFM	U Of M	String	10	View
QTYBSUOM	QTY In Base U Of M	Currency	10	View
TRXQTY	TRX QTY	Currency	10	View
UNITCOST	Unit Cost	Currency	10	View
EXTDCOST	Extended Cost	Currency	10	View
TRXLOCTN	TRX Location	String	12	View
TRNSTLOC	Transfer To Location	String	12	View
TRFQTYTY	Transfer From QTY Type 1 = On Hand 2 = Returned 3 = In Use 4 = In Service 5 = Damaged	Integer	2	View
TRTQTYTY	Transfer To QTY Type 1 = On Hand 2 = Returned 3 = In Use 4 = In Service 5 = Damaged	Integer	2	View
IVIVINDX	IV IV Index	Long Integer	4	View
IVIVOFIX	IV IV Offset Index	Long Integer	4	View
IVWLNMSG	IV WORK LINE Messages	Long Integer	4	View
TRXSORCE	TRX Source	String	14	View
DOCDATE	Document Date	Date	4	View
HSTMODUL	History Module	String	4	View
CUSTNMBR	Customer Number	String	16	View
ITEMDESC	Item Description	String	102	View
NOTEINDX	Note Index	Currency	10	View
ITMSHNAM	Item Short Name	String	16	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
ITMGEDSC	Item Generic Description	String	12	View
STNDCOST	Standard Cost	Currency	10	View
CURRCOST	Current Cost	Currency	10	View
LISTPRCE	List Price	Currency	10	View
ITEMSHWT	Item Shipping Weight	Long Integer	4	View
DECPLQTY	Decimal Places QTYS	Integer	2	View
DECPLCUR	Decimal Places Currency	Integer	2	View
ITMTSHID	Item Tax Schedule ID	String	16	View
TAXOPTNS	Tax Options 1. Taxable 2. Nontaxable 3. Base on customers	Integer	2	View
COMMCODE	Commission Code	String	16	View
IVCOGSIX	IV COGS Index	Long Integer	4	View
IVSLSIDX	IV Sales Index	Long Integer	4	View
IVSLDSIX	IV Sales Discounts Index	Long Integer	4	View
IVSLRNIX	IV Sales Returns Index	Long Integer	4	View
IVINUSIX	IV In Use Index	Long Integer	4	View
IVINSVIX	IV In Service Index	Long Integer	4	View
IVDMGIDX	IV Damaged Index	Long Integer	4	View
IVVARIDX	IV Variances Index	Long Integer	4	View
DPSHPIDX	Drop Ship Index	Long Integer	4	View
PURPVIDX	Purchase Price Variance Index	Long Integer	4	View
IVRETIDX	Inventory Returns Index	Long Integer	4	View
ASMVRIDX	Assembly Variance Index	Long Integer	4	View
ITMCLSCD	Item Class Code	String	12	View
ITMTRKOP	Item Tracking Option 1. None 2. Serial Numbers 3. Lot Numbers	Integer	2	View
LOTTYPE	Lot Type	String	12	View
KPERHIST	Keep Period History	Boolean	2	View
KPTRXHST	Keep Trx History	Boolean	2	View
KPCALHST	Keep Calendar History	Boolean	2	View
KPDSTHST	Keep Distribution History	Boolean	2	View
ALWBKORD	Allow Back Orders	Boolean	2	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
UOMSCHDL	U Of M Schedule	String	12	View
ObjRef1	ObjRef1	Invalid storage type 30	0	View
ALTITEM1	Alternate Item 1	String	32	View
ALTITEM2	Alternate Item 2	String	32	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
MSTRCDTY	Master Record Type	Integer	2	View
MODIFDT	Modified Date	Date	4	View
CREATDDT	Created Date	Date	4	View
WRNTYDYS	Warranty Days	Integer	2	View
PRCLEVEL	PriceLevel	String	12	View
LOCNCODE	Location Code	String	12	View
ASI_Main_IV_IV_Index	ASI_Main_IV_IV_Index	Long Integer	4	View
ASI_Main_IV_IV_Offset_In	ASI_Main_IV_IV_Offset_Index	Long Integer	4	View
BACHNUMB	Batch Number	String	16	View
BCHSOURC	Batch Source	String	16	View
RCDOCNUM	Recurring Document Number	String	22	View
MDFUSRID	Modified User ID	String	16	View
POSTEDDT	Posted Date	Date	4	View
PTDUSRID	Posted User ID	String	16	View
GLPOSTDT	GL Posting Date	Date	4	View
PSTGSTUS	Posting Status 1 = Work 2 = Open 3 = History 4 = Originating	Integer	2	View
TRXQTYTL	TRX QTY Total	Currency	10	View
IVWHRMSG	IV WORK HDR Messages	Long Integer	4	View
ASI_Favorite_Sequence	ASI_Favorite_Sequence	Long Integer	4	View
ABCCODE	ABC Code 1 – (None) 2 – A 3 – B 4 – C	Integer	2	View
CGSINFLX	COGS Inflation Index	Long Integer	4	View
CGSMCIDX	COGS Monetary Correction Index	Long Integer	4	View
IVINFIDX	Inventory Inflation Index	Long Integer	4	View
INVMCIDX	Inventory Monetary Correction Index	Long Integer	4	View
ITEMCODE	Item Code	String	16	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
PriceGroup	Price Group	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
PRCHSUOM	Purchasing U Of M	String	10	View
SELNGUOM	Selling U Of M	String	10	View
TCC	Tax Commodity Code	String	32	View
UPPVIDX	Unrealized Purchase Price Variance Index	Long Integer	4	View
LOCNCODE1	ASI_Location_Code	String	12	View
USAGETYPE	Usage Type	Integer	2	View
SRCRFRNCNMBR	Source Reference Number	String	32	View
SOURCEINDICATOR	Source Indicator 1 – (none) 2 – Issue 3 – Reverse Issue 4 – Finished Good Post 5 – Reverse Finished Good Post 6 – Stock Count 7 – Field Service – Service Call 8 – Field Service – Return Material Authoization 9 – Field Service – Return to Vendor 10 – Field Service – Work Order 11 – Project Accounting	Integer	2	View
UMSCHDSC	U Of M Schedule Description	String	32	View

ASIEXP19 - SmartList Inventory Transaction Amount

Query Builder

Customer Service

Information

My Account

Contact Us