GP Tables

POP10100 - Purchase Order Work

Dynamics GP table POP10100 (Purchase Order Work) contains 149 columns including PONUMBER, POSTATUS, STATGRP....

SQL Query Builder

149 Columns

Column Description Type Length
PONUMBER PO Number String 18
POSTATUS PO Status1 – New2 – Released3 – Change Order4 – Received5 – Closed6 – Canceled Integer 2
STATGRP Status Group Integer 2
POTYPE PO Type1 = Standard2 = Drop Ship3 = Blanket4 = Blanket Drop Ship Integer 2
USER2ENT User To Enter String 16
CONFIRM1 Confirm With String 22
DOCDATE Document Date Date 4
LSTEDTDT Last Edit Date Date 4
LSTPRTDT Last Printed Date Date 4
PRMDATE Promised Date Date 4
PRMSHPDTE Promised Ship Date Date 4
REQDATE Required Date Date 4
REQTNDT Requisition Date Date 4
SHIPMTHD Shipping Method String 16
TXRGNNUM Tax Registration Number String 26
REMSUBTO Remaining Subtotal Currency 10
SUBTOTAL Subtotal Currency 10
TRDISAMT Trade Discount Amount Currency 10
FRTAMNT Freight Amount Currency 10
MSCCHAMT Misc Charges Amount Currency 10
TAXAMNT Tax Amount Currency 10
VENDORID Vendor ID String 16
VENDNAME Vendor Name String 66
MINORDER Minimum Order Currency 10
VADCDPAD Vendor Address Code - Purchase Address String 16
CMPANYID Company ID Integer 2
PRBTADCD Primary Billto Address Code String 16
PRSTADCD Primary Shipto 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
PYMTRMID Payment Terms ID String 22
DSCDLRAM Discount Dollar Amount Currency 10
DSCPCTAM Discount Percent Amount Integer 2
DISAMTAV Discount Amount Available Currency 10
DISCDATE Discount Date Date 4
DUEDATE Due Date Date 4
TRDPCTPR Trade Discount Percent (Precise) Currency (Variable) 12
CUSTNMBR Customer Number String 16
TIMESPRT Times Printed Integer 2
CREATDDT Created Date Date 4
MODIFDT Modified Date Date 4
PONOTIDS_1 PO Note ID Array[1] Currency 10
PONOTIDS_2 PO Note ID Array[2] Currency 10
PONOTIDS_3 PO Note ID Array[3] Currency 10
PONOTIDS_4 PO Note ID Array[4] Currency 10
PONOTIDS_5 PO Note ID Array[5] Currency 10
PONOTIDS_6 PO Note ID Array[6] Currency 10
PONOTIDS_7 PO Note ID Array[7] Currency 10
PONOTIDS_8 PO Note ID Array[8] Currency 10
PONOTIDS_9 PO Note ID Array[9] Currency 10
PONOTIDS_10 PO Note ID Array[10] Currency 10
PONOTIDS_11 PO Note ID Array[11] Currency 10
PONOTIDS_12 PO Note ID Array[12] Currency 10
PONOTIDS_13 PO Note ID Array[13] Currency 10
PONOTIDS_14 PO Note ID Array[14] Currency 10
PONOTIDS_15 PO Note ID Array[15] Currency 10
COMMNTID Comment ID String 16
CANCSUB Canceled Subtotal Currency 10
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
RATETPID Rate Type ID String 16
EXGTBLID Exchange Table ID String 16
XCHGRATE Exchange Rate Currency (Variable) 10
EXCHDATE Exchange Date Date 4
TIME1 Time Time 4
RATECALC Rate Calc Method Integer 2
DENXRATE Denomination Exchange Rate Currency (Variable) 10
MCTRXSTT MC Transaction State0 = Euro currency is not created or no denomination currencies are enabled.1 = Originating is not a denomination; Functional is not a denomination2 = Originating is not a denomination; Functional is the Euro currency.3 = Originating is not a denomination; Functional is a denomination.4 = Originating is a denomination; Functional is not a denomination.5 = Originating is a denomination; Functional is a denomination.6 = Originating is a denomination; Functional is the Euro currency.7 = Originating is the Euro currency; Functional is a denomination.8 = Originating is the Euro currency; Functional is not a denomination. Integer 2
OREMSUBT Originating Remaining Subtotal Currency 10
ORSUBTOT Originating Subtotal Currency 10
Originating_Canceled_Sub Originating Canceled Subtotal Currency 10
ORTDISAM Originating Trade Discount Amount Currency 10
ORFRTAMT Originating Freight Amount Currency 10
OMISCAMT Originating Misc Charges Amount Currency 10
ORTAXAMT Originating Tax Amount Currency 10
ORDDLRAT Originating Discount Dollar Amount Currency 10
ODISAMTAV Originating Discount Amount Available Currency 10
BUYERID Buyer ID String 16
ONORDAMT On Order Amount Currency 10
ORORDAMT Originating On Order Amount Currency 10
HOLD Hold Boolean 2
Hold Status values (2)
0 = Not on hold1 = On hold
ONHOLDDATE On Hold Date Date 4
ONHOLDBY On Hold By String 16
HOLDREMOVEDATE Hold Remove Date Date 4
HOLDREMOVEBY Hold Remove By String 16
ALLOWSOCMTS Allow SO Commitments Boolean 2
DISGRPER Discount Grace Period Integer 2
DUEGRPER Due Date Grace Period Integer 2
Revision_Number Revision Number Integer 2
Change_Order_Flag Change Order Flag Integer 2
PO_Field_Changes PO Field Changes Long Integer 4
PO_Status_Orig PO Status Orig1 – New2 – Released3 – Change Order4 – Received5 – Closed6 – Canceled Integer 2
TAXSCHID Tax Schedule ID String 16
TXSCHSRC Tax Schedule Source Integer 2
TXENGCLD Tax Engine Called Boolean 2
BSIVCTTL Based On Invoice Total Boolean 2
Purchase_Freight_Taxable Purchase Freight Taxable Integer 2
Purchase_Misc_Taxable Purchase Misc Taxable Integer 2
FRTSCHID Freight Schedule ID String 16
MSCSCHID Misc Schedule ID String 16
FRTTXAMT Freight Tax Amount Currency 10
ORFRTTAX Originating Freight Tax Amount Currency 10
MSCTXAMT Misc Tax Amount Currency 10
ORMSCTAX Originating Misc Tax Amount Currency 10
BCKTXAMT Backout Tax Amount Currency 10
OBTAXAMT Originating Backout Tax Amount Currency 10
BackoutFreightTaxAmt Backout Freight Tax Amount Currency 10
OrigBackoutFreightTaxAmt Originating Backout Freight Tax Amount Currency 10
BackoutMiscTaxAmt Backout Misc Tax Amount Currency 10
OrigBackoutMiscTaxAmt Originating Backout Misc Tax Amount Currency 10
Flags Flags Integer 2
BackoutTradeDiscTax Backout Trade Discount Tax Amount Currency 10
OrigBackoutTradeDiscTax Originating Backout Trade Discount Tax Amount Currency 10
POPCONTNUM POP Contract Number String 22
CONTENDDTE Contract End Date Date 4
CNTRLBLKTBY Control Blanket By Integer 2
PURCHCMPNYNAM Purchase Company Name String 66
PURCHCONTACT Purchase Contact String 62
PURCHADDRESS1 Purchase Address 1 String 62
PURCHADDRESS2 Purchase Address 2 String 62
PURCHADDRESS3 Purchase Address 3 String 62
PURCHCITY Purchase City String 36
PURCHSTATE Purchase State String 30
PURCHZIPCODE Purchase Zip Code String 12
PURCHCCode Purchase Country Code String 8
PURCHCOUNTRY Purchase Country String 62
PURCHPHONE1 Purchase Phone 1 String 22
PURCHPHONE2 Purchase Phone 2 String 22
PURCHPHONE3 Purchase Phone 3 String 22
PURCHFAX Purchase Fax String 22
BLNKTLINEEXTQTYSUM Total Blanket Line Ext Qty Currency 10
CBVAT Cash Based VAT Boolean 2
Workflow_Approval_Status Workflow Approval Status1 – Not Submitted2 – Submitted3 – No Approval Needed4 – Pending Approval5 – Pending Changes6 – Approved7 – Rejected8 – Workflow Ended9 – Workflow Not Activated10 – Workflow Deactivated Integer 2
Workflow_Priority Workflow Priority Integer 2
PrepaymentAmount Prepayment Amount Currency 10
OriginatingPrepaymentAmt Originating Prepayment Amount Currency 10

Related Tables

Tables that share columns with POP10100. 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

TIME1

AAG10001 AAG20001 AAG20011 AAG2001T AAG30001 AAG40001 ASIEXP06 ASIEXP07

RATETPID

AAG10001 AAG20001 AAG20011 AAG2001T AAG30001 AAG40001 ASIEXP02 ASIEXP03

CUSTNMBR

ASIEXP02 ASIEXP06 ASIEXP07 ASIEXP08 ASIEXP15 ASIEXP19 ASIEXP20 ASIEXP21

XCHGRATE

AAG10001 AAG20001 AAG20011 AAG2001T AAG30001 AAG40001 ASIEXP06 ASIEXP07

DENXRATE

AAG10001 AAG20001 AAG20011 AAG2001T AAG30001 AAG40001 ASIEXP06 ASIEXP07

EXGTBLID

AAG10001 AAG20001 AAG20011 AAG2001T AAG30001 AAG40001 ASIEXP06 ASIEXP07

VENDORID

ASIEXP03 ASIEXP07 ASIEXP09 ASIEXP11 ASIEXP16 ASIEXP21 ASIEXP23 ASIEXP27

EXCHDATE

AAG10001 AAG20001 AAG20011 AAG2001T AAG30001 AAG40001 ASIEXP06 ASIEXP07