PA10802 - PA Billing Distribution WORK | Prospr

PA10802 - PA Billing Distribution WORK

Select * from PA10802

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
PADocnumber20	PA 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
CUSTNMBR	Customer Number	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
POSTED	Posted	Boolean	2	View
POSTEDDT	Posted Date	Date	4	View