IVC10200 - Invoicing Payments Work | Prospr - Dynamics GP Table Reference

IVC10200 - Invoicing Payments Work

Select * from IVC10200

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
DOCTYPE	Document Type	Integer	2	View
INVCNMBR	Invoice Number	String	22	View
SEQNUMBR	Sequence Number	Long Integer	4	View
PYMTTYPE	Payment Type	Integer	2	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
CURNCYID	Currency ID	String	16	View
CHEKBKID	Checkbook ID	String	16	View
CARDNAME	Card Name	String	16	View
RCTNCCRD	Receipt Number Credit Card	String	22	View
CHEKNMBR	Check Number	String	22	View
AMNTPAID	Amount Paid	Currency	10	View
DOCDATE	Document Date	Date	4	View
EXPNDATE	Expiration Date	Date	4	View
AUTHCODE	Authorization Code	String	16	View
TRXSORCE	TRX Source	String	14	View
EFTFLAG	EFT Flag	Boolean	2	View