GP Tables

POP10110 - Purchase Order Line

Dynamics GP table POP10110 (Purchase Order Line) contains 102 columns including PONUMBER, ORD, POLNESTA....

SQL Query Builder

102 Columns

Column Description Type Length
PONUMBER PO Number String 18
ORD Ord Long Integer 4
POLNESTA PO Line Status1 – New2 – Released3 – Change Order4 – Received5 – Closed6 – Canceled Integer 2
POTYPE PO Type1 = Standard2 = Drop Ship3 = Blanket4 = Blanket Drop Ship Integer 2
ITEMNMBR Item Number String 32
ITEMDESC Item Description String 102
VENDORID Vendor ID String 16
VNDITNUM Vendor Item Number String 32
VNDITDSC Vendor Item Description String 102
NONINVEN Non IV Integer 2
LOCNCODE Location Code String 12
UOFM U Of M String 10
UMQTYINB U Of M QTY In Base Currency 10
QTYORDER QTY Ordered Currency 10
QTYCANCE QTY Canceled Currency 10
QTYCMTBASE QTY Committed In Base Currency 10
QTYUNCMTBASE QTY Uncommitted In Base Currency 10
UNITCOST Unit Cost Currency 10
EXTDCOST Extended Cost Currency 10
INVINDX Inventory Index Long Integer 4
REQDATE Required Date Date 4
PRMDATE Promised Date Date 4
PRMSHPDTE Promised Ship Date Date 4
REQSTDBY Requested By String 22
COMMNTID Comment ID String 16
DOCTYPE Document Type Integer 2
Document Type (Payables) values (7)
1 = Invoice2 = Finance Charge3 = Miscellaneous Charge4 = Return5 = Credit Memo6 = Payment7 = Scheduled Payment
POLNEARY_1 PO Line Note ID Array[1] Currency 10
POLNEARY_2 PO Line Note ID Array[2] Currency 10
POLNEARY_3 PO Line Note ID Array[3] Currency 10
POLNEARY_4 PO Line Note ID Array[4] Currency 10
POLNEARY_5 PO Line Note ID Array[5] Currency 10
POLNEARY_6 PO Line Note ID Array[6] Currency 10
POLNEARY_7 PO Line Note ID Array[7] Currency 10
POLNEARY_8 PO Line Note ID Array[8] Currency 10
POLNEARY_9 PO Line Note ID Array[9] Currency 10
DECPLCUR Decimal Places Currency Integer 2
DECPLQTY Decimal Places QTYS Integer 2
ITMTRKOP Item Tracking Option1. None2. Serial Numbers3. Lot Numbers Integer 2
Item Tracking Option values (3)
1 = None2 = Serial Numbers3 = Lot Numbers
VCTNMTHD Valuation Method1. FIFO Perpetual2. LIFO Perpetual3. Average Perpetual4. FIFO Periodic (This value is not available for SBM.)5. LIFO Periodic (This value is not available for SBM.) Integer 2
Valuation Method values (5)
1 = FIFO Perpetual2 = LIFO Perpetual3 = Average Perpetual4 = FIFO Periodic5 = LIFO Periodic
BRKFLD1 Break Field 1 Integer 2
PO_Line_Status_Orig PO Line Status Orig Integer 2
QTY_Canceled_Orig QTY Canceled Orig Currency 10
OPOSTSUB Originating Posted Subtotal Currency 10
JOBNUMBR Job Number String 18
COSTCODE Cost Code String 28
COSTTYPE Cost Code Type Integer 2
CURNCYID Currency ID Functional currency code (e.g., USD, CAD, GBP). Use to filter or group multicurrency transactions. String 16
CURRNIDX Currency Index Integer 2
XCHGRATE Exchange Rate Currency (Variable) 10
RATECALC Rate Calc Method Integer 2
DENXRATE Denomination Exchange Rate Currency (Variable) 10
ORUNTCST Originating Unit Cost Currency 10
OREXTCST Originating Extended Cost Currency 10
LINEORIGIN Line Origin Integer 2
FREEONBOARD Free On Board Integer 2
ODECPLCU Originating Decimal Places Currency Integer 2
Capital_Item Capital Item Boolean 2
Product_Indicator Product Indicator Integer 2
Source_Document_Number Source Document Number String 12
Source_Document_Line_Num Source Document Line Number Integer 2
RELEASEBYDATE Release By Date Date 4
Released_Date Released Date Date 4
Change_Order_Flag Change Order Flag Integer 2
Purchase_IV_Item_Taxable Purchase IV Item Taxable1 – Taxable2 – Nontaxable3 – Base on Vendor Integer 2
Purchase_Item_Tax_Schedu Purchase Item Tax Schedule ID String 16
Purchase_Site_Tax_Schedu Purchase Site Tax Schedule ID String 16
PURCHSITETXSCHSRC Purchase Site Tax Schedule Source Integer 2
BSIVCTTL Based On Invoice Total Boolean 2
TAXAMNT Tax Amount Currency 10
ORTAXAMT Originating Tax Amount Currency 10
BCKTXAMT Backout Tax Amount Currency 10
OBTAXAMT Originating Backout Tax Amount Currency 10
Landed_Cost_Group_ID Landed Cost Group ID String 16
PLNNDSPPLID Planned Supply ID Integer 2
SHIPMTHD Shipping Method String 16
BackoutTradeDiscTax Backout Trade Discount Tax Amount Currency 10
OrigBackoutTradeDiscTax Originating Backout Trade Discount Tax Amount Currency 10
LineNumber LineNumber Integer 2
ORIGPRMDATE Original Promised Date Date 4
FSTRCPTDT First Receipt Date Date 4
LSTRCPTDT Last Receipt Date Date 4
RELEASE Release Integer 2
ADRSCODE Address Code String 16
CMPNYNAM Company Name String 66
CONTACT Contact String 62
ADDRESS1 Address 1 String 62
ADDRESS2 Address 2 String 62
ADDRESS3 Address 3 String 62
CITY City String 36
STATE State String 30
ZIPCODE Zip Code String 12
CCode Country Code String 8
COUNTRY Country String 62
PHONE1 Phone 1 String 22
PHONE2 Phone 2 String 22
PHONE3 Phone 3 String 22
FAX Fax String 22
ADDRSOURCE Address Source Integer 2
Flags Flags Integer 2
ProjNum Project Number String 16
CostCatID Cost Category ID String 16

Related Tables

Tables that share columns with POP10110. Click "Join" to add to your query.

CURNCYID

AAG10001 AAG20001 AAG20011 AAG2001T AAG30001 AAG40001 AAG50001 AAG60001

CURRNIDX

AAG10001 AAG20001 AAG20011 AAG2001T AAG30001 AAG40001 AAG50001 AAG60001

XCHGRATE

AAG10001 AAG20001 AAG20011 AAG2001T AAG30001 AAG40001 ASIEXP06 ASIEXP07

DENXRATE

AAG10001 AAG20001 AAG20011 AAG2001T AAG30001 AAG40001 ASIEXP06 ASIEXP07

VENDORID

ASIEXP03 ASIEXP07 ASIEXP09 ASIEXP11 ASIEXP16 ASIEXP21 ASIEXP23 ASIEXP27

DOCTYPE

ASIEXP09 ASIEXP10 ASIEXP18 ASIEXP21 ASIEXP25 ASIEXP26 ASIEXP29 EDCEI016

TAXAMNT

ASIEXP06 ASIEXP07 ASIEXP08 ASIEXP09 ASIEXP20 ASIEXP21 ASIEXP25 ASIEXP26

SHIPMTHD

ASIEXP02 ASIEXP03 ASIEXP06 ASIEXP07 ASIEXP08 ASIEXP09 ASIEXP11 ASIEXP15

ITEMNMBR

AAG20001 AAG20011 ASIEXP04 ASIEXP11 ASIEXP19 ASIEXP20 ASIEXP21 ASIEXP23

LOCNCODE

ASIEXP04 ASIEXP06 ASIEXP11 ASIEXP15 ASIEXP19 ASIEXP20 ASIEXP21 ASIEXP23