RVLPD014 - Sales Payment Document Remittance Distributions | Prospr

RVLPD014 - Sales Payment Document Remittance Distributions

Select * from RVLPD014

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
REMTYPE	RemitType	Integer	2	View
REMITID	RemitID	String	16	View
SEQNUMBR	Sequence Number	Long Integer	4	View
DISTTYPE	Distribution Type 1 = Cash 2 = Payable 3 = Discount Available 4 = Discount Taken 5 = Finance Charge 6 = Purchase 8 = Misc. Charge 9 = Freight 10 = Taxes 11 = Writeoffs 12 = Other 13 = GST Disc	Integer	2	View
DSTINDX	Distribution Account Index	Long Integer	4	View
POSTED	Posted	Boolean	2	View
POSTEDDT	Posted Date	Date	4	View
DEBITAMT	Debit Amount	Currency	10	View
CRDTAMNT	Credit Amount	Currency	10	View
CURNCYID	Currency ID	String	16	View
CURRNIDX	Currency Index	Integer	2	View
ORDBTAMT	Originating Debit Amount	Currency	10	View
ORCRDAMT	Originating Credit Amount	Currency	10	View
DistRef	Distribution Reference	String	32	View
TRXSORCE	TRX Source	String	14	View
DCSTATUS	Document Status 1 = Work 2 = Open 3 = History	Integer	2	View