CN20101 - Collections - Invoice Levels Open | Prospr

CN20101 - Collections - Invoice Levels Open

Select * from CN20101

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
CN_Credit_Level	CN Credit Level	Integer	2	View
CN_Letter_Date	CN Letter Date	Date	4	View
CreditLevelFee	CN Credit Level Fee	Currency	10	View