ASIEXP36 - ASI_IV_Purchase_Receipts_Explorer | Prospr

ASIEXP36 - ASI_IV_Purchase_Receipts_Explorer

Select * from ASIEXP36

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
ITEMNMBR	Item Number	String	32	View
TRXLOCTN	TRX Location	String	12	View
DATERECD	Date Received	Date	4	View
RCTSEQNM	Receipt SEQ Number	Long Integer	4	View
RCPTSOLD	Receipt Sold	Boolean	2	View
QTYRECVD	QTY Received	Currency	10	View
QTYSOLD	QTY Sold	Currency	10	View
QTYCOMTD	QTY Committed	Currency	10	View
QTYRESERVED	QTY Reserved	Currency	10	View
FLRPLNDT	Floor Plan Date	Date	4	View
PCHSRCTY	Purchase Receipt Type	Integer	2	View
RCPTNMBR	Receipt Number	String	22	View
VENDORID	Vendor ID	String	16	View
PORDNMBR	Purchase Order Number	String	22	View
UNITCOST	Unit Cost	Currency	10	View
QTYTYPE	QTY Type 1 = On Hand 2 = Returned 3 = In Use 4 = In Service 5 = Damaged	Integer	2	View
Landed_Cost	Landed Cost	Boolean	2	View
NEGQTYSOPINV	IsNegQtySOPInvoice	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
ADJUNITCOST	Adjusted Unit Cost	Currency	10	View
QTYONHND	QTY On Hand	Currency	10	View