CN100201 - Collections - Build Letter Invoices | Prospr

CN100201 - Collections - Build Letter Invoices

Select * from CN100201

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
USERID	User ID	String	16	View
CUSTNMBR	Customer Number	String	16	View
CPRCSTNM	Corporate Customer Number	String	16	View
CN_Credit_Level	CN Credit Level	Integer	2	View
CreditLevelFee	CN Credit Level Fee	Currency	10	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
UpdateCreditLevel	CN Update Credit Level	Boolean	2	View
NOTEINDX	Note Index	Currency	10	View
ActionType	Action Type	Integer	2	View
ActionAmount	Action Amount	Currency	10	View
ORTRXAMT	Original Trx Amount	Currency	10	View
CURTRXAM	Current Trx Amount	Currency	10	View
ORORGTRX	Originating Original Trx Amount	Currency	10	View
ORCTRXAM	Originating Current Trx Amount	Currency	10	View
DOCDATE	Document Date	Date	4	View
DUEDATE	Due Date	Date	4	View
CN_Letter_Date	CN Letter Date	Date	4	View
AGNGBUKT	Aging Bucket	Integer	2	View
CURNCYID	Currency ID	String	16	View
CURRNIDX	Currency Index	Integer	2	View
CN_New_Credit_Level	CN New Credit Level	Integer	2	View
CN_New_Credit_Level_Fee	CN New Credit Level Fee	Currency	10	View
ADRSCODE	Address Code	String	16	View