PA11902 - PA Project Closing Distribution WORK | Prospr

PA11902 - PA Project Closing Distribution WORK

Select * from PA11902

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
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
PAPROJNUMBER	PA Project Number	String	16	View
PACONTNUMBER	PA Contract Number	String	12	View
PA_Proj_Closing_Sequence	PA Proj Closing Sequence No.	Long Integer	4	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