ASIEXP11 - SmartList Item Quantity Master | Prospr

ASIEXP11 - SmartList Item Quantity Master

Query Builder

Select * from ASIEXP11

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
ASI_Order_By	ASI_Order_By	Long Integer	4	View
ITEMNMBR	Item Number	String	32	View
LOCNCODE	Location Code	String	12	View
BINNMBR	Bin Number	String	22	View
RCRDTYPE	Record Type	Integer	2	View
PRIMVNDR	Primary Vendor	String	16	View
ITMFRFLG	Item Freeze Flag	Boolean	2	View
BGNGQTY	Beginning QTY	Currency	10	View
LSORDQTY	Last ORD QTY	Currency	10	View
LRCPTQTY	Last RCPT QTY	Currency	10	View
LSTORDDT	Last ORD Date	Date	4	View
LSORDVND	Last ORD Vendor	String	16	View
LSRCPTDT	Last RCPT Date	Date	4	View
QTYRQSTN	QTY Requisitioned	Currency	10	View
QTYONORD	QTY On Order	Currency	10	View
QTYBKORD	QTY Back Ordered	Currency	10	View
QTY_Drop_Shipped	QTY Drop Shipped	Currency	10	View
ORDRPNTQTY	Order Point Qty	Currency	10	View
REORDERVARIANCE	Reorder Variance	Currency	10	View
ORDRUPTOLVL	Order Up To Level	Currency	10	View
QTYINUSE	QTY In Use	Currency	10	View
QTYINSVC	QTY In Service	Currency	10	View
QTYRTRND	QTY Returned	Currency	10	View
QTYDMGED	QTY Damaged	Currency	10	View
QTYONHND	QTY On Hand	Currency	10	View
ATYALLOC	QTY Allocated	Currency	10	View
QTYCOMTD	QTY Committed	Currency	10	View
QTYSOLD	QTY Sold	Currency	10	View
DECPLQTY	Decimal Places QTYS	Integer	2	View
DECPLCUR	Decimal Places Currency	Integer	2	View
QTYAVAIL	QTY Available	Currency	10	View
ITEMDESC	Item Description	String	102	View
ITMGEDSC	Item Generic Description	String	12	View
ITMSHNAM	Item Short Name	String	16	View
VENDNAME	Vendor Name	String	66	View
VNDITNUM	Vendor Item Number	String	32	View
VNDITDSC	Vendor Item Description	String	102	View
CURRCOST	Current Cost	Currency	10	View
STNDCOST	Standard Cost	Currency	10	View
BASEUOFM	Base U Of M	String	10	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
ALTITEM1	Alternate Item 1	String	32	View
ALTITEM2	Alternate Item 2	String	32	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
ITMTSHID	Item Tax Schedule ID	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
ITMTRKOP	Item Tracking Option 1. None 2. Serial Numbers 3. Lot Numbers	Integer	2	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
ITEMSHWT	Item Shipping Weight	Long Integer	4	View
TAXOPTNS	Tax Options 1. Taxable 2. Nontaxable 3. Base on customers	Integer	2	View
IVIVINDX	IV IV Index	Long Integer	4	View
IVIVOFIX	IV IV Offset Index	Long Integer	4	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
LOTTYPE	Lot Type	String	12	View
ALWBKORD	Allow Back Orders	Boolean	2	View
UOMSCHDL	U Of M Schedule	String	12	View
MSTRCDTY	Master Record Type	Integer	2	View
WRNTYDYS	Warranty Days	Integer	2	View
PRCLEVEL	PriceLevel	String	12	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
LSTCNTDT	Last Count Date	Date	4	View
LSTCNTTM	Last Count Time	Time	4	View
NXTCNTDT	Next Count Date	Date	4	View
NXTCNTTM	Next Count Time	Time	4	View
STCKCNTINTRVL	Stock Count Interval	Integer	2	View
LOCNCODE1	ASI_Location_Code	String	12	View
VENDORID	Vendor ID	String	16	View
VNDCHKNM	Vendor Check Name	String	66	View
VENDSHNM	Vendor Short Name	String	16	View
VADDCDPR	Vendor Address Code - Primary	String	16	View
VADCDPAD	Vendor Address Code - Purchase Address	String	16	View
VADCDSFR	Vendor Address Code - Ship From	String	16	View
VADCDTRO	Vendor Address Code - Remit To	String	16	View
VNDCLSID	Vendor Class ID	String	12	View
VNDCNTCT	Vendor Contact	String	62	View
ADDRESS1	Address 1	String	62	View
ADDRESS2	Address 2	String	62	View
ADDRESS3	Address 3	String	62	View
CITY	City	String	36	View
STATE	State	String	30	View
ZIPCODE	Zip Code	String	12	View
COUNTRY	Country	String	62	View
PHNUMBR1	Phone Number 1	String	22	View
PHNUMBR2	Phone Number 2	String	22	View
FAXNUMBR	Fax Number	String	22	View
UPSZONE	UPS Zone	String	4	View
SHIPMTHD	Shipping Method	String	16	View
TAXSCHID	Tax Schedule ID	String	16	View
ACNMVNDR	Account Number With Vendor	String	22	View
TXIDNMBR	Tax ID Number	String	12	View
VENDSTTS	Vendor Status 1. Active 2. Inactive 3. Temporary	Integer	2	View
CURNCYID	Currency ID	String	16	View
TXRGNNUM	Tax Registration Number	String	26	View
PARVENID	Parent Vendor ID	String	16	View
TRDDISCT	Trade Discount	Integer	2	View
TEN99TYPE	1099 Type 1 – Not a 1099 vendor 2 – Dividend 3 – Interest 4 - Miscellaneous	Integer	2	View
MINORDER	Minimum Order	Currency	10	View
PYMTRMID	Payment Terms ID	String	22	View
MINPYTYP	Minimum Payment Type	Integer	2	View
MINPYPCT	Minimum Payment Percent	Integer	2	View
MINPYDLR	Minimum Payment Dollar	Currency	10	View
MXIAFVND	Maximum Invoice Amount For Vendors	Integer	2	View
MAXINDLR	Maximum Invoice Dollar	Currency	10	View
COMMENT1	Comment1	String	32	View
COMMENT2	Comment2	String	32	View
USERDEF1	User Defined 1	String	22	View
USERDEF2	User Defined 2	String	22	View
CRLMTDLR	Credit Limit Dollar	Currency	10	View
PYMNTPRI	Payment Priority	String	4	View
KGLDSTHS	Keep GL Dist History	Boolean	2	View
HOLD	Hold	Boolean	2	View
PTCSHACF	Post To Cash Account From	Integer	2	View
CREDTLMT	Credit Limit	Integer	2	View
WRITEOFF	Writeoff	Integer	2	View
MXWOFAMT	Maximum Write Off Amount	Currency	10	View
SBPPSDED	Subject To PPS Deductions	Boolean	2	View
PPSTAXRT	PPS Tax Rate	Integer	2	View
DXVARNUM	Deduction Exemption/Variation Number	String	26	View
CRTCOMDT	Certificate Commencing Date	Date	4	View
CRTEXPDT	Certificate Expiration Date	Date	4	View
RTOBUTKN	Reporting Obligation Undertaken	Boolean	2	View
XPDTOBLG	Expiration Date Obligation	Boolean	2	View
PRSPAYEE	Prescribed Payee	Boolean	2	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
PMMSCHIX	PM Misc Charges Index	Long Integer	4	View
PMFRTIDX	PM Freight Index	Long Integer	4	View
PMTAXIDX	PM Tax Index	Long Integer	4	View
PMWRTIDX	PM Write Offs Index	Long Integer	4	View
PMPRCHIX	PM Purchases Index	Long Integer	4	View
PMRTNGIX	PM Retainage Index	Long Integer	4	View
PMTDSCIX	PM Trade Discount Index	Long Integer	4	View
ACPURIDX	Accrued Purchases Index	Long Integer	4	View
PURPVIDX1	ASI_Purchase_Price_Variance_Index	Long Integer	4	View
NOTEINDX	Note Index	Currency	10	View
CHEKBKID	Checkbook ID	String	16	View
MODIFDT	Modified Date	Date	4	View
CREATDDT	Created Date	Date	4	View
RATETPID	Rate Type ID	String	16	View
Revalue_Vendor	Revalue Vendor	Boolean	2	View
Post_Results_To	Post Results To	Integer	2	View
FREEONBOARD	Free On Board	Integer	2	View
DISGRPER	Discount Grace Period	Integer	2	View
DOCFMTID	Document Format ID	String	16	View
DUEGRPER	Due Date Grace Period	Integer	2	View
GOVCRPID	Governmental Corporate ID	String	32	View
GOVINDID	Governmental Individual ID	String	32	View
PHONE3	Phone 3	String	22	View
TaxInvRecvd	Tax Invoice Received	Boolean	2	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
UMDPQTYS	U Of M Decimal Places QTYS	Integer	2	View
UMSCHDSC	U Of M Schedule Description	String	32	View
CURRNIDX	Currency Index	Integer	2	View
ECORDQTY	Economic ORD QTY	Currency	10	View
ITMVNDTY	Item Vendor Type	Integer	2	View
Last_Currency_ID	Last Currency ID	String	16	View
Last_Originating_Cost	Last Originating Cost	Currency	10	View
LRCPTCST	Last RCPT Cost	Currency	10	View
MAXORDQTY	Maximum ORD QTY	Currency	10	View
MINORQTY	Minimum ORD QTY	Currency	10	View
NORCTITM	Number Of RCPTS For Item	Integer	2	View
PLANNINGLEADTIME	Planning Lead Time	Integer	2	View
AVRGLDTM	Average Lead Time	Long Integer	4	View
FREEONBOARD1	ASI_Free_On_Board	Integer	2	View
LSTORDDT1	ASI_Last_ORD_Date	Date	4	View
LSORDQTY1	ASI_Last_ORD_QTY	Currency	10	View
LSRCPTDT1	ASI_Last_RCPT_Date	Date	4	View
LRCPTQTY1	ASI_Last_RCPT_QTY	Currency	10	View
QTY_Drop_Shipped1	ASI_QTY_Drop_Shipped	Currency	10	View
QTYONORD1	ASI_QTY_On_Order	Currency	10	View
QTYRQSTN1	ASI_QTY_Requisitioned	Currency	10	View
PRCHSUOM1	ASI_Purchasing_U_Of_M	String	10	View
Landed_Cost_Group_ID	Landed Cost Group ID	String	16	View
PORETRNBIN	Purchase Returns Bin	String	16	View
SOFULFILLMENTBIN	SO Fulfillment Bin	String	16	View
SORETURNBIN	SO Return Bin	String	16	View
BOMRCPTBIN	BOM Receipt Bin	String	16	View
MATERIALISSUEBIN	Material Issues Bin	String	16	View
MORECEIPTBIN	MO Receipt Bin	String	16	View
REPAIRISSUESBIN	Repair Issues Bin	String	16	View
BUYERID	Buyer ID	String	16	View
PLANNERID	Planner ID	String	16	View
ORDERPOLICY	Order Policy 1 – Not planned 2 – Lot for Lot 3 – Fixed Order Quantity 4 – Period Order Quantity 5 – Order Point 6 – Manually Planned (Removed for version 10.0)	Integer	2	View
FXDORDRQTY	Fixed Order Qty	Currency	10	View
NMBROFDYS	Number of Days	Integer	2	View
MNMMORDRQTY	Minimum Order Qty	Currency	10	View
MXMMORDRQTY	Maximum Order Qty	Currency	10	View
ORDERMULTIPLE	Order Multiple	Currency	10	View
REPLENISHMENTMETHOD	Replenishment Method 1 – Make 2 – Buy 3- Make or Buy	Integer	2	View
SHRINKAGEFACTOR	Shrinkage Factor	Currency	10	View
PRCHSNGLDTM	Purchasing Lead Time	Currency	10	View
MNFCTRNGFXDLDTM	Manufacturing Fixed Lead Time	Currency	10	View
MNFCTRNGVRBLLDTM	Manufacturing Variable Lead Time	Currency	10	View
STAGINGLDTME	Staging Lead Time	Currency	10	View
PLNNNGTMFNCDYS	Planning Time Fence Days	Integer	2	View
DMNDTMFNCPRDS	Demand Time Fence Periods	Integer	2	View
INCLDDINPLNNNG	Included in Planning	Boolean	2	View
FRCSTCNSMPTNPRD	Forecast Consumption Period 1 – Days 2 – Weeks 3 – Months	Integer	2	View
SFTYSTCKQTY	Safety Stock Qty	Currency	10	View
PORECEIPTBIN	Purchase Receipt Bin	String	16	View
ReplenishmentLevel	Replenishment Level	Integer	2	View
POPOrderMethod	POP Order Method	Integer	2	View
MasterLocationCode	Master Location Code	String	12	View
POPVendorSelection	POP Vendor Selection	Integer	2	View
POPPricingSelection	POP Pricing Selection	Integer	2	View
PurchasePrice	Purchase Price	Currency	10	View
IncludeAllocations	Include Allocations	Boolean	2	View
IncludeBackorders	Include Backorders	Boolean	2	View
IncludeRequisitions	Include Requisitions	Boolean	2	View

ASIEXP11 - SmartList Item Quantity Master

Query Builder

Customer Service

Information

My Account

Contact Us