PM30600 - PM Distribution History File | Prospr

PM30600 - PM Distribution History File

Select * from PM30600

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
DOCTYPE	Document Type	Integer	2	View
VCHRNMBR	Voucher Number	String	22	View
DSTSQNUM	Distribution Sequence Number	Long Integer	4	View
CNTRLTYP	Control Type	Integer	2	View
CRDTAMNT	Credit Amount	Currency	10	View
DEBITAMT	Debit Amount	Currency	10	View
DSTINDX	Distribution Account Index	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
CHANGED	Changed	Boolean	2	View
USERID	User ID	String	16	View
PSTGSTUS	Posting Status 1 = Work 2 = Open 3 = History 4 = Originating	Integer	2	View
VENDORID	Vendor ID	String	16	View
TRXSORCE	TRX Source	String	14	View
PSTGDATE	Posting Date	Date	4	View
CURNCYID	Currency ID	String	16	View
CURRNIDX	Currency Index	Integer	2	View
ORCRDAMT	Originating Credit Amount	Currency	10	View
ORDBTAMT	Originating Debit Amount	Currency	10	View
APTVCHNM	Apply To Voucher Number	String	22	View
APTODCTY	Apply To Document Type	Integer	2	View
SPCLDIST	Specialized Distribution	Integer	2	View
DistRef	Distribution Reference	String	32	View