POP30300 - Purchasing Receipt History | Prospr

POP30300 - Purchasing Receipt History

Query Builder

Select * from POP30300

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
POPRCTNM	POP Receipt Number	String	18	View
POPTYPE	POP Type	Integer	2	View
VNDDOCNM	Vendor Document Number	String	22	View
receiptdate	Receipt Date	Date	4	View
GLPOSTDT	GL Posting Date	Date	4	View
ACTLSHIP	Actual Ship Date	Date	4	View
BCHSOURC	Batch Source	String	16	View
BACHNUMB	Batch Number	String	16	View
VENDORID	Vendor ID	String	16	View
VENDNAME	Vendor Name	String	66	View
SUBTOTAL	Subtotal	Currency	10	View
TRDISAMT	Trade Discount Amount	Currency	10	View
TRDPCTPR	Trade Discount Percent (Precise)	Currency (Variable)	12	View
FRTAMNT	Freight Amount	Currency	10	View
MISCAMNT	Misc Amount	Currency	10	View
TAXAMNT	Tax Amount	Currency	10	View
TEN99AMNT	1099 Amount	Currency	10	View
PYMTRMID	Payment Terms ID	String	22	View
DSCPCTAM	Discount Percent Amount	Integer	2	View
DSCDLRAM	Discount Dollar Amount	Currency	10	View
DISAVAMT	Discount Available Amount	Currency	10	View
DISCDATE	Discount Date	Date	4	View
DUEDATE	Due Date	Date	4	View
REFRENCE	Reference	String	32	View
VOIDSTTS	Void Status 0 = Document has not been voided. 1 = Document has been voided. 2 = Document has been marked NSF and voided.	Integer	2	View
RCPTNOTE_1	Receipt Note ID Array[1]	Currency	10	View
RCPTNOTE_2	Receipt Note ID Array[2]	Currency	10	View
RCPTNOTE_3	Receipt Note ID Array[3]	Currency	10	View
RCPTNOTE_4	Receipt Note ID Array[4]	Currency	10	View
RCPTNOTE_5	Receipt Note ID Array[5]	Currency	10	View
RCPTNOTE_6	Receipt Note ID Array[6]	Currency	10	View
RCPTNOTE_7	Receipt Note ID Array[7]	Currency	10	View
RCPTNOTE_8	Receipt Note ID Array[8]	Currency	10	View
POPHDR1	POP HDR Errors 1	Long Integer	4	View
POPHDR2	POP HDR Errors 2	Long Integer	4	View
POPLNERR	POP LINE Errors	Long Integer	4	View
POSTEDDT	Posted Date	Date	4	View
PTDUSRID	Posted User ID	String	16	View
USER2ENT	User To Enter	String	16	View
CREATDDT	Created Date	Date	4	View
MODIFDT	Modified Date	Date	4	View
TRXSORCE	TRX Source	String	14	View
VCHRNMBR	Voucher Number	String	22	View
Tax_Date	Tax Date	Date	4	View
CURNCYID	Currency ID	String	16	View
CURRNIDX	Currency Index	Integer	2	View
RATETPID	Rate Type ID	String	16	View
EXGTBLID	Exchange Table ID	String	16	View
XCHGRATE	Exchange Rate	Currency (Variable)	10	View
EXCHDATE	Exchange Date	Date	4	View
TIME1	Time	Time	4	View
RATECALC	Rate Calc Method	Integer	2	View
DENXRATE	Denomination Exchange Rate	Currency (Variable)	10	View
MCTRXSTT	MC Transaction State 0 = Euro currency is not created or no denomination currencies are enabled. 1 = Originating is not a denomination; Functional is not a denomination 2 = 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	View
ORSUBTOT	Originating Subtotal	Currency	10	View
ORTDISAM	Originating Trade Discount Amount	Currency	10	View
ORFRTAMT	Originating Freight Amount	Currency	10	View
ORMISCAMT	Originating Misc Amount	Currency	10	View
ORTAXAMT	Originating Tax Amount	Currency	10	View
OR1099AM	Originating 1099 Amount	Currency	10	View
ORDDLRAT	Originating Discount Dollar Amount	Currency	10	View
ORDAVAMT	Originating Discount Available Amount	Currency	10	View
SIMPLIFD	Simplified	Boolean	2	View
WITHHAMT	Withholding Amount	Currency	10	View
ECTRX	EC Transaction	Boolean	2	View
TXRGNNUM	Tax Registration Number	String	26	View
TAXSCHID	Tax Schedule ID	String	16	View
BSIVCTTL	Based On Invoice Total	Boolean	2	View
Purchase_Freight_Taxable	Purchase Freight Taxable	Integer	2	View
Purchase_Misc_Taxable	Purchase Misc Taxable	Integer	2	View
FRTSCHID	Freight Schedule ID	String	16	View
MSCSCHID	Misc Schedule ID	String	16	View
FRTTXAMT	Freight Tax Amount	Currency	10	View
ORFRTTAX	Originating Freight Tax Amount	Currency	10	View
MSCTXAMT	Misc Tax Amount	Currency	10	View
ORMSCTAX	Originating Misc Tax Amount	Currency	10	View
BCKTXAMT	Backout Tax Amount	Currency	10	View
OBTAXAMT	Originating Backout Tax Amount	Currency	10	View
TaxInvReqd	Tax Invoice Required	Boolean	2	View
BackoutFreightTaxAmt	Backout Freight Tax Amount	Currency	10	View
OrigBackoutFreightTaxAmt	Originating Backout Freight Tax Amount	Currency	10	View
BackoutMiscTaxAmt	Backout Misc Tax Amount	Currency	10	View
OrigBackoutMiscTaxAmt	Originating Backout Misc Tax Amount	Currency	10	View
TaxInvRecvd	Tax Invoice Received	Boolean	2	View
APLYWITH	Apply Withholding	Boolean	2	View
PPSTAXRT	PPS Tax Rate	Integer	2	View
SHIPMTHD	Shipping Method	String	16	View
Total_Landed_Cost_Amount	Total Landed Cost Amount	Currency	10	View
CBVAT	Cash Based VAT	Boolean	2	View
VADCDTRO	Vendor Address Code - Remit To	String	16	View
REVALJRNENTRY	Revaluation Journal Entry	Long Integer	4	View
REVALTRXSOURCE	Revaluation TRX Source	String	14	View
TEN99TYPE	1099 Type 1 – Not a 1099 vendor 2 – Dividend 3 – Interest 4 - Miscellaneous	Integer	2	View
TEN99BOXNUMBER	1099 Box Number	Integer	2	View
REPLACEGOODS	Replace Returned Goods	Boolean	2	View
INVOICEEXPECTED	Invoice Expected Returns	Boolean	2	View
PrepaymentAmount	Prepayment Amount	Currency	10	View
OriginatingPrepaymentAmt	Originating Prepayment Amount	Currency	10	View
POP_HDR_Errors_4	POP HDR Errors 4	Long Integer	4	View
DISTKNAM	Discount Taken Amount	Currency	10	View
ORDISTKN	Originating Discount Taken Amount	Currency	10	View
DISAVTKN	Discount Available Taken	Currency	10	View
ORDATKN	Originating Discount Available Taken	Currency	10	View

POP30300 - Purchasing Receipt History

Query Builder

Customer Service

Information

My Account

Contact Us