PA30903 - PA Inventory Distribution History | Prospr

PA30903 - PA Inventory Distribution History

Select * from PA30903

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
PAIV_Document_No	PA IV Document No	String	18	View
TRXSORCE	TRX Source	String	14	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
DistRef	Distribution Reference	String	32	View
USERID	User ID	String	16	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