GP Tables

POP30300 - Purchasing Receipt History

Dynamics GP table POP30300 (Purchasing Receipt History) contains 103 columns including POPRCTNM, POPTYPE, VNDDOCNM....

SQL Query Builder

103 Columns

Column Description Type Length
POPRCTNM POP Receipt Number String 18
POPTYPE POP Type Integer 2
VNDDOCNM Vendor Document Number String 22
receiptdate Receipt Date Date 4
GLPOSTDT GL Posting Date Date 4
ACTLSHIP Actual Ship Date Date 4
BCHSOURC Batch Source String 16
BACHNUMB Batch Number String 16
VENDORID Vendor ID String 16
VENDNAME Vendor Name String 66
SUBTOTAL Subtotal Currency 10
TRDISAMT Trade Discount Amount Currency 10
TRDPCTPR Trade Discount Percent (Precise) Currency (Variable) 12
FRTAMNT Freight Amount Currency 10
MISCAMNT Misc Amount Currency 10
TAXAMNT Tax Amount Currency 10
TEN99AMNT 1099 Amount Currency 10
PYMTRMID Payment Terms ID String 22
DSCPCTAM Discount Percent Amount Integer 2
DSCDLRAM Discount Dollar Amount Currency 10
DISAVAMT Discount Available Amount Currency 10
DISCDATE Discount Date Date 4
DUEDATE Due Date Date 4
REFRENCE Reference String 32
VOIDSTTS Void Status0 = Document has not been voided.1 = Document has been voided.2 = Document has been marked NSF and voided. Integer 2
Void Status values (2)
0 = Normal1 = Voided
RCPTNOTE_1 Receipt Note ID Array[1] Currency 10
RCPTNOTE_2 Receipt Note ID Array[2] Currency 10
RCPTNOTE_3 Receipt Note ID Array[3] Currency 10
RCPTNOTE_4 Receipt Note ID Array[4] Currency 10
RCPTNOTE_5 Receipt Note ID Array[5] Currency 10
RCPTNOTE_6 Receipt Note ID Array[6] Currency 10
RCPTNOTE_7 Receipt Note ID Array[7] Currency 10
RCPTNOTE_8 Receipt Note ID Array[8] Currency 10
POPHDR1 POP HDR Errors 1 Long Integer 4
POPHDR2 POP HDR Errors 2 Long Integer 4
POPLNERR POP LINE Errors Long Integer 4
POSTEDDT Posted Date Date 4
PTDUSRID Posted User ID String 16
USER2ENT User To Enter String 16
CREATDDT Created Date Date 4
MODIFDT Modified Date Date 4
TRXSORCE TRX Source String 14
VCHRNMBR Voucher Number String 22
Tax_Date Tax Date Date 4
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
ORSUBTOT Originating Subtotal Currency 10
ORTDISAM Originating Trade Discount Amount Currency 10
ORFRTAMT Originating Freight Amount Currency 10
ORMISCAMT Originating Misc Amount Currency 10
ORTAXAMT Originating Tax Amount Currency 10
OR1099AM Originating 1099 Amount Currency 10
ORDDLRAT Originating Discount Dollar Amount Currency 10
ORDAVAMT Originating Discount Available Amount Currency 10
SIMPLIFD Simplified Boolean 2
WITHHAMT Withholding Amount Currency 10
ECTRX EC Transaction Boolean 2
TXRGNNUM Tax Registration Number String 26
TAXSCHID Tax Schedule ID String 16
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
TaxInvReqd Tax Invoice Required Boolean 2
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
TaxInvRecvd Tax Invoice Received Boolean 2
APLYWITH Apply Withholding Boolean 2
PPSTAXRT PPS Tax Rate Integer 2
SHIPMTHD Shipping Method String 16
Total_Landed_Cost_Amount Total Landed Cost Amount Currency 10
CBVAT Cash Based VAT Boolean 2
VADCDTRO Vendor Address Code - Remit To String 16
REVALJRNENTRY Revaluation Journal Entry Long Integer 4
REVALTRXSOURCE Revaluation TRX Source String 14
TEN99TYPE 1099 Type1 – Not a 1099 vendor2 – Dividend3 – Interest4 - Miscellaneous Integer 2
1099 Type values (5)
1 = Not a 1099 Vendor2 = Dividend3 = Interest4 = Miscellaneous5 = Nonemployee Compensation
TEN99BOXNUMBER 1099 Box Number Integer 2
REPLACEGOODS Replace Returned Goods Boolean 2
INVOICEEXPECTED Invoice Expected Returns Boolean 2
PrepaymentAmount Prepayment Amount Currency 10
OriginatingPrepaymentAmt Originating Prepayment Amount Currency 10
POP_HDR_Errors_4 POP HDR Errors 4 Long Integer 4
DISTKNAM Discount Taken Amount Currency 10
ORDISTKN Originating Discount Taken Amount Currency 10
DISAVTKN Discount Available Taken Currency 10
ORDATKN Originating Discount Available Taken Currency 10

Related Tables

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

TRXSORCE

ASIEXP06 ASIEXP07 ASIEXP08 ASIEXP09 ASIEXP10 ASIEXP12 ASIEXP18 ASIEXP19

XCHGRATE

AAG10001 AAG20001 AAG20011 AAG2001T AAG30001 AAG40001 ASIEXP06 ASIEXP07

DENXRATE

AAG10001 AAG20001 AAG20011 AAG2001T AAG30001 AAG40001 ASIEXP06 ASIEXP07

BACHNUMB

ASIEXP06 ASIEXP08 ASIEXP09 ASIEXP10 ASIEXP12 ASIEXP19 ASIEXP20 ASIEXP25

EXGTBLID

AAG10001 AAG20001 AAG20011 AAG2001T AAG30001 AAG40001 ASIEXP06 ASIEXP07

VENDORID

ASIEXP03 ASIEXP07 ASIEXP09 ASIEXP11 ASIEXP16 ASIEXP21 ASIEXP23 ASIEXP27