POP10500 - Purchasing Receipt Line Quantities | Prospr

POP10500 - Purchasing Receipt Line Quantities

Query Builder

Select * from POP10500

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
PONUMBER	PO Number	String	18	View
POLNENUM	PO Line Number	Long Integer	4	View
POPRCTNM	POP Receipt Number	String	18	View
RCPTLNNM	Receipt Line Number	Long Integer	4	View
QTYSHPPD	QTY Shipped	Currency	10	View
QTYINVCD	QTY Invoiced	Currency	10	View
QTYREJ	QTY Rejected	Currency	10	View
QTYMATCH	QTY Matched	Currency	10	View
QTYRESERVED	QTY Reserved	Currency	10	View
QTYINVRESERVE	QTY Invoice Reserve	Currency	10	View
Status	Status	Integer	2	View
UMQTYINB	U Of M QTY In Base	Currency	10	View
OLDCUCST	Old Current Cost	Currency	10	View
JOBNUMBR	Job Number	String	18	View
COSTCODE	Cost Code	String	28	View
COSTTYPE	Cost Code Type	Integer	2	View
ORCPTCOST	Originating Receipt Cost	Currency	10	View
OSTDCOST	Originating Standard Cost	Currency	10	View
APPYTYPE	Apply Type	Integer	2	View
POPTYPE	POP Type	Integer	2	View
VENDORID	Vendor ID	String	16	View
ITEMNMBR	Item Number	String	32	View
UOFM	U Of M	String	10	View
TRXLOCTN	TRX Location	String	12	View
DATERECD	Date Received	Date	4	View
RCTSEQNM	Receipt SEQ Number	Long Integer	4	View
SPRCTSEQ	Split Receipt SEQ Number	Long Integer	4	View
PCHRPTCT	Purchase Receipt Cost	Currency	10	View
SPRCPTCT	Split Receipt Cost	Currency	10	View
OREXTCST	Originating Extended Cost	Currency	10	View
RUPPVAMT	Remaining UPPV Amount	Currency	10	View
ACPURIDX	Accrued Purchases Index	Long Integer	4	View
INVINDX	Inventory Index	Long Integer	4	View
UPPVIDX	Unrealized Purchase Price Variance Index	Long Integer	4	View
NOTEINDX	Note Index	Currency	10	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
RATETPID	Rate Type ID	String	16	View
EXGTBLID	Exchange Table ID	String	16	View
Capital_Item	Capital Item	Boolean	2	View
Product_Indicator	Product Indicator	Integer	2	View
Total_Landed_Cost_Amount	Total Landed Cost Amount	Currency	10	View
QTYTYPE	QTY Type 1 = On Hand 2 = Returned 3 = In Use 4 = In Service 5 = Damaged	Integer	2	View
Posted_LC_PPV_Amount	Posted LC PPV Amount	Currency	10	View
QTYREPLACED	QTY Replaced	Currency	10	View
QTYINVADJ	QTY Invoice Adjustment	Currency	10	View

POP10500 - Purchasing Receipt Line Quantities

Query Builder

Customer Service

Information

My Account

Contact Us