POP10170 - Purchase Order Prepayments | Prospr

POP10170 - Purchase Order Prepayments

Query Builder

Select * from POP10170

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
PONUMBER	PO Number	String	18	View
PMNTNMBR	Payment Number	String	22	View
PrepaymentSource	Prepayment Source	Integer	2	View
PYENTTYP	Payment Entry Type	Integer	2	View
PrepaymentAmount	Prepayment Amount	Currency	10	View
OriginatingPrepaymentAmt	Originating Prepayment Amount	Currency	10	View
APPLDAMT	Applied Amount	Currency	10	View
ORAPPAMT	Originating Applied Amount	Currency	10	View
CURTRXAM	Current Trx Amount	Currency	10	View
ORCTRXAM	Originating Current Trx Amount	Currency	10	View
DISTKNAM	Discount Taken Amount	Currency	10	View
ORDISTKN	Originating Discount Taken Amount	Currency	10	View
CHEKBKID	Checkbook ID	String	16	View
CARDNAME	Card Name	String	16	View
CHEKNMBR	Check Number	String	22	View
DOCNUMBR	Document Number	String	22	View
CNTRLTYP	Control Type	Integer	2	View
PrepaymentAccountIndex	Prepayment Account Index	Long Integer	4	View
Cash_Account_Index	Cash Account Index	Long Integer	4	View
PAY_ACCT_IDX	Account Payable Account Index	Long Integer	4	View
GLPOSTDT	GL Posting Date	Date	4	View
BACHNUMB	Batch Number	String	16	View
BCHSOURC	Batch Source	String	16	View
TRXSORCE	TRX Source	String	14	View
PSTGSTUS	Posting Status 1 = Work 2 = Open 3 = History 4 = Originating	Integer	2	View
VOIDED	Voided	Boolean	2	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

POP10170 - Purchase Order Prepayments

Query Builder

Customer Service

Information

My Account

Contact Us