POP10310 - Purchasing Receipt Line | Prospr - Dynamics GP Table Reference

POP10310 - Purchasing Receipt Line

Query Builder

Select * from POP10310

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
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
RcptLineNoteIDArray_1	ReceiptLine Note ID Array[1]	Currency	10	View
RcptLineNoteIDArray_2	ReceiptLine Note ID Array[2]	Currency	10	View
RcptLineNoteIDArray_3	ReceiptLine Note ID Array[3]	Currency	10	View
RcptLineNoteIDArray_4	ReceiptLine Note ID Array[4]	Currency	10	View
RcptLineNoteIDArray_5	ReceiptLine Note ID Array[5]	Currency	10	View
RcptLineNoteIDArray_6	ReceiptLine Note ID Array[6]	Currency	10	View
RcptLineNoteIDArray_7	ReceiptLine Note ID Array[7]	Currency	10	View
RcptLineNoteIDArray_8	ReceiptLine Note ID Array[8]	Currency	10	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
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
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
RATETPID	Rate Type ID	String	16	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
BCKTXAMT	Backout Tax Amount	Currency	10	View
OBTAXAMT	Originating Backout Tax Amount	Currency	10	View
Revalue_Inventory	Revalue Inventory	Boolean	2	View
Tolerance_Percentage	Tolerance Percentage	Long Integer	4	View
PURPVIDX	Purchase Price Variance Index	Long Integer	4	View
Remaining_AP_Amount	Remaining AP Amount	Currency	10	View
SHIPMTHD	Shipping Method	String	16	View
Landed_Cost_Group_ID	Landed Cost Group ID	String	16	View
Landed_Cost_Warnings	Landed Cost Warnings	Integer	2	View
BackoutTradeDiscTax	Backout Trade Discount Tax Amount	Currency	10	View
OrigBackoutTradeDiscTax	Originating Backout Trade Discount Tax Amount	Currency	10	View
Landed_Cost	Landed Cost	Boolean	2	View
Invoice_Match	Invoice Match	Boolean	2	View
RCPTRETNUM	Receipt Return Number	String	18	View
RCPTRETLNNUM	Receipt Return Line Number	Long Integer	4	View
INVRETNUM	Invoice Return Number	String	18	View
INVRETLNNUM	Invoice Return Line Number	Long Integer	4	View
ISLINEINTRA	IsLineIntrastat	Boolean	2	View
ProjNum	Project Number	String	16	View
CostCatID	Cost Category ID	String	16	View
TrackedDropShipped	TrackedDropShipped	Boolean	2	View
OriginatingPrepaymentAmt	Originating Prepayment Amount	Currency	10	View
ORDISTKN	Originating Discount Taken Amount	Currency	10	View
ORTDISAM	Originating Trade Discount Amount	Currency	10	View

POP10310 - Purchasing Receipt Line

Query Builder

Customer Service

Information

My Account

Contact Us