POP10110 - Purchase Order Line | Prospr - Dynamics GP Table Reference

POP10110 - Purchase Order Line

Query Builder

Select * from POP10110

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
PONUMBER	PO Number	String	18	View
ORD	Ord	Long Integer	4	View
POLNESTA	PO Line Status 1 – New 2 – Released 3 – Change Order 4 – Received 5 – Closed 6 – Canceled	Integer	2	View
POTYPE	PO Type 1 = Standard 2 = Drop Ship 3 = Blanket 4 = Blanket Drop Ship	Integer	2	View
ITEMNMBR	Item Number	String	32	View
ITEMDESC	Item Description	String	102	View
VENDORID	Vendor ID	String	16	View
VNDITNUM	Vendor Item Number	String	32	View
VNDITDSC	Vendor Item Description	String	102	View
NONINVEN	Non IV	Integer	2	View
LOCNCODE	Location Code	String	12	View
UOFM	U Of M	String	10	View
UMQTYINB	U Of M QTY In Base	Currency	10	View
QTYORDER	QTY Ordered	Currency	10	View
QTYCANCE	QTY Canceled	Currency	10	View
QTYCMTBASE	QTY Committed In Base	Currency	10	View
QTYUNCMTBASE	QTY Uncommitted In Base	Currency	10	View
UNITCOST	Unit Cost	Currency	10	View
EXTDCOST	Extended Cost	Currency	10	View
INVINDX	Inventory Index	Long Integer	4	View
REQDATE	Required Date	Date	4	View
PRMDATE	Promised Date	Date	4	View
PRMSHPDTE	Promised Ship Date	Date	4	View
REQSTDBY	Requested By	String	22	View
COMMNTID	Comment ID	String	16	View
DOCTYPE	Document Type	Integer	2	View
POLNEARY_1	PO Line Note ID Array[1]	Currency	10	View
POLNEARY_2	PO Line Note ID Array[2]	Currency	10	View
POLNEARY_3	PO Line Note ID Array[3]	Currency	10	View
POLNEARY_4	PO Line Note ID Array[4]	Currency	10	View
POLNEARY_5	PO Line Note ID Array[5]	Currency	10	View
POLNEARY_6	PO Line Note ID Array[6]	Currency	10	View
POLNEARY_7	PO Line Note ID Array[7]	Currency	10	View
POLNEARY_8	PO Line Note ID Array[8]	Currency	10	View
POLNEARY_9	PO Line Note ID Array[9]	Currency	10	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
BRKFLD1	Break Field 1	Integer	2	View
PO_Line_Status_Orig	PO Line Status Orig	Integer	2	View
QTY_Canceled_Orig	QTY Canceled Orig	Currency	10	View
OPOSTSUB	Originating Posted Subtotal	Currency	10	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
LINEORIGIN	Line Origin	Integer	2	View
FREEONBOARD	Free On Board	Integer	2	View
ODECPLCU	Originating Decimal Places Currency	Integer	2	View
Capital_Item	Capital Item	Boolean	2	View
Product_Indicator	Product Indicator	Integer	2	View
Source_Document_Number	Source Document Number	String	12	View
Source_Document_Line_Num	Source Document Line Number	Integer	2	View
RELEASEBYDATE	Release By Date	Date	4	View
Released_Date	Released Date	Date	4	View
Change_Order_Flag	Change Order Flag	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
PURCHSITETXSCHSRC	Purchase Site Tax Schedule Source	Integer	2	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
Landed_Cost_Group_ID	Landed Cost Group ID	String	16	View
PLNNDSPPLID	Planned Supply ID	Integer	2	View
SHIPMTHD	Shipping Method	String	16	View
BackoutTradeDiscTax	Backout Trade Discount Tax Amount	Currency	10	View
OrigBackoutTradeDiscTax	Originating Backout Trade Discount Tax Amount	Currency	10	View
LineNumber	LineNumber	Integer	2	View
ORIGPRMDATE	Original Promised Date	Date	4	View
FSTRCPTDT	First Receipt Date	Date	4	View
LSTRCPTDT	Last Receipt Date	Date	4	View
RELEASE	Release	Integer	2	View
ADRSCODE	Address Code	String	16	View
CMPNYNAM	Company Name	String	66	View
CONTACT	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
CCode	Country Code	String	8	View
COUNTRY	Country	String	62	View
PHONE1	Phone 1	String	22	View
PHONE2	Phone 2	String	22	View
PHONE3	Phone 3	String	22	View
FAX	Fax	String	22	View
ADDRSOURCE	Address Source	Integer	2	View
Flags	Flags	Integer	2	View
ProjNum	Project Number	String	16	View
CostCatID	Cost Category ID	String	16	View
Print_Phone_NumberGB	Print Phone Number GB	Integer	2	View

POP10110 - Purchase Order Line

Query Builder

Customer Service

Information

My Account

Contact Us