RM00401 - RM Key File | Prospr - Dynamics GP Table Reference

RM00401 - RM Key File

Select * from RM00401

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
DCSTATUS	Document Status 1 = Work 2 = Open 3 = History	Integer	2	View
BCHSOURC	Batch Source	String	16	View
TRXSORCE	TRX Source	String	14	View
CUSTNMBR	Customer Number	String	16	View
CHEKNMBR	Check Number	String	22	View
DOCDATE	Document Date	Date	4	View
NEGQTYSOPINV	IsNegQtySOPInvoice	Boolean	2	View