ASIEXP28 - SmartList Purchasing Receipt Lines | Prospr

ASIEXP28 - SmartList Purchasing Receipt Lines

Query Builder

Select * from ASIEXP28

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
ASI_Favorite_Sequence	ASI_Favorite_Sequence	Long Integer	4	View
ASI_Order_By	ASI_Order_By	Long Integer	4	View
ASI_Document_Status	ASI_Document_Status	Integer	2	View
POPRCTNM	POP Receipt Number	String	18	View
RCPTLNNM	Receipt Line Number	Long Integer	4	View
PONUMBER	PO Number	String	18	View
ITEMNMBR	Item Number	String	32	View
ITEMDESC	Item Description	String	102	View
VNDITNUM	Vendor Item Number	String	32	View
VNDITDSC	Vendor Item Description	String	102	View
UMQTYINB	U Of M QTY In Base	Currency	10	View
ACTLSHIP	Actual Ship Date	Date	4	View
COMMNTID	Comment ID	String	16	View
INVINDX	Inventory Index	Long Integer	4	View
UOFM	U Of M	String	10	View
UNITCOST	Unit Cost	Currency	10	View
EXTDCOST	Extended Cost	Currency	10	View
LOCNCODE	Location Code	String	12	View
NONINVEN	Non IV	Integer	2	View
DECPLCUR	Decimal Places Currency	Integer	2	View
DECPLQTY	Decimal Places QTYS	Integer	2	View
ITMTRKOP	Item Tracking Option 1. None 2. Serial Numbers 3. Lot Numbers	Integer	2	View
TRXSORCE	TRX Source	String	14	View
JOBNUMBR	Job Number	String	18	View
COSTCODE	Cost Code	String	28	View
COSTTYPE	Cost Code Type	Integer	2	View
CURNCYID	Currency ID	String	16	View
CURRNIDX	Currency Index	Integer	2	View
XCHGRATE	Exchange Rate	Currency (Variable)	10	View
RATECALC	Rate Calc Method	Integer	2	View
DENXRATE	Denomination Exchange Rate	Currency (Variable)	10	View
ORUNTCST	Originating Unit Cost	Currency	10	View
OREXTCST	Originating Extended Cost	Currency	10	View
ODECPLCU	Originating Decimal Places Currency	Integer	2	View
BOLPRONUMBER	BOL_PRO Number	String	32	View
Capital_Item	Capital Item	Boolean	2	View
Product_Indicator	Product Indicator	Integer	2	View
Purchase_IV_Item_Taxable	Purchase IV Item Taxable 1 – Taxable 2 – Nontaxable 3 – Base on Vendor	Integer	2	View
Purchase_Item_Tax_Schedu	Purchase Item Tax Schedule ID	String	16	View
Purchase_Site_Tax_Schedu	Purchase Site Tax Schedule ID	String	16	View
BSIVCTTL	Based On Invoice Total	Boolean	2	View
TAXAMNT	Tax Amount	Currency	10	View
ORTAXAMT	Originating Tax Amount	Currency	10	View
BKTPURAM	Backout Purchases Amount	Currency	10	View
OBKPURAMT	Originating Backout Purchases Amount	Currency	10	View
Revalue_Inventory	Revalue Inventory	Boolean	2	View
PURPVIDX	Purchase Price Variance Index	Long Integer	4	View
PSTGSTUS	Posting Status 1 = Work 2 = Open 3 = History 4 = Originating	Integer	2	View
POPTYPE	POP Type	Integer	2	View
VENDORID	Vendor ID	String	16	View
VENDNAME	Vendor Name	String	66	View
VNDDOCNM	Vendor Document Number	String	22	View
GLPOSTDT	GL Posting Date	Date	4	View
receiptdate	Receipt Date	Date	4	View
BCHSOURC	Batch Source	String	16	View
BACHNUMB	Batch Number	String	16	View
POSTEDDT	Posted Date	Date	4	View
PTDUSRID	Posted User ID	String	16	View
USER2ENT	User To Enter	String	16	View
CREATDDT	Created Date	Date	4	View
MODIFDT	Modified Date	Date	4	View
Tax_Date	Tax Date	Date	4	View
QTYSHPPD	QTY Shipped	Currency	10	View
QTYINVCD	QTY Invoiced	Currency	10	View
QTYREJ	QTY Rejected	Currency	10	View
Landed_Cost_Group_ID	Landed Cost Group ID	String	16	View
Landed_Cost	Landed Cost	Boolean	2	View
RCPTRETNUM	Receipt Return Number	String	18	View
INVRETNUM	Invoice Return Number	String	18	View
BIN	Bin	String	16	View
Total_Landed_Cost_Amount	Total Landed Cost Amount	Currency	10	View
QTYRESERVED	QTY Reserved	Currency	10	View
QTYINVRESERVE	QTY Invoice Reserve	Currency	10	View
UMSCHDSC	U Of M Schedule Description	String	32	View
QTYMATCH	QTY Matched	Currency	10	View
ProjNum	Project Number	String	16	View
CostCatID	Cost Category ID	String	16	View

ASIEXP28 - SmartList Purchasing Receipt Lines

Query Builder

Customer Service

Information

My Account

Contact Us