CN30200 - Collections - Invoice Notes History | Prospr

CN30200 - Collections - Invoice Notes History

Select * from CN30200

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
CUSTNMBR	Customer Number	String	16	View
CPRCSTNM	Corporate Customer Number	String	16	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
DOCNUMBR	Document Number	String	22	View
NOTEINDX	Note Index	Currency	10	View
RevisionNumber	CN Revision Number	Integer	2	View
RevisionDate	CN Revision Date	Date	4	View
RevisionTime	CN Revision Time	Time	4	View
USERID	User ID	String	16	View
ActionType	Action Type	Integer	2	View
ActionAmount	Action Amount	Currency	10	View
CURTRXAM	Current Trx Amount	Currency	10	View
CURNCYID	Currency ID	String	16	View
CURRNIDX	Currency Index	Integer	2	View