PA23000 - PA Applied OPEN | Prospr - Dynamics GP Table Reference

PA23000 - PA Applied OPEN

Select * from PA23000

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
DOCNUMBR	Document Number	String	22	View
RMDTYPAL	RM Document Type-All 0 = Reserved for balance carried forward records 1 = Sales / Invoice 2 = Reserved for schedule payments 3 = Debit Memos 4 = Finance Charges 5 = Service Repairs 6= Warranties 7 = Credit Memos 8 = Returns 9 = Payments	Integer	2	View
PADocnumber20	PA Document No.	String	18	View
CUSTNMBR	Customer Number	String	16	View
PABILLTRXT	PA Biller Trx Type	Integer	2	View
PAPROJNUMBER	PA Project Number	String	16	View
PACCAA	PA CostCat Applied Amount	Currency	10	View
PAFAA	PA Fee Applied Amount	Currency	10	View
PATTA	PA Terms Taken Amount	Currency	10	View
PAWA	PA Writeoff Amount	Currency	10	View
PA_Tax_Applied_Amount	PA Tax Applied Amount	Currency	10	View
DOCDATE	Document Date	Date	4	View
TRXDSCRN	Transaction Description	String	32	View